Tarkeshwar

Mobile: +91-6389021613

Email: singh.tarkeshwar6237@gmail.com

Experience Summary:

• Having 4 years of experience in Microsoft Business Intelligence (SQL, T-SQL, SSIS and SSRS) Development using SQL Server 2016/2017.
• Having good knowledge in Sublanguage, CTE, Joins, Views, Stored Procedures and Triggers.
• Understanding Business Specification Documents /Source map documents for creating Packages and Reports.
• Experience in Design and Development of SSIS Packages.
• Working with various transformations such as Lookup, Conditional Split, Multicast, Derived column, Merge, Merge Join and Tasks such as Dataflow Task, Execute SQL Task, Execute Package, Bulk Insert, File system, For Loop, For Each Loop etc. in Integration Services Development.
• Implemented Event Error Handling, Package Configuration and Logging.
• Created various types of Reports like Table, Chart, Sub Reports and Drill through, Drill down reports based on client requirement.
• Created Parameterized Reports using Cascaded Parameters.
• Created and working with Standard and Complex Report by using Report Server Project and Report Builder.
• Having good knowledge on Data Warehousing concepts.
• Created Deployment of all Reports.

Technical Skills:

RDBMS : SQL SERVER 2016/2017

Operating Systems : WINDOWS XP/07/10

ETL Tools : SSIS 2015/2017

Reporting Tools : SSRS 2015/2017

Work Experience:

• Working as MSBI Developer from June - 2018 to

July -2022.

Educational Qualification:

• Bachelor of Technology from Kalasalingam University.
• Project Experience:

Project # 1:

Project

Saubhagya

Client

Bajaj Electricals Limited

Technology

SQL Server 2017, SSIS, SSRS

Team Size

5

Duration

June- 2018 to March-2021

Role

Asst. Software Engg.

 

Description:

The objective of this project was for electrification in Uttar Pradesh by providing electrical service connection to the APL and BPL households in rural areas. To achieve this, Pradhan Mantri Sahaj Bijli Har Ghar Yojana has been launched in the state. Total 1.2 crore household surveyed, and electrification has to be done. For this android based Mobile application has been developed namely “SAUBHAGYA YOJNA”. Application has been installed in surveyor phone, PMA phone, TKC employees’ phone and on client’s employee’s phone.

Surveyors collect data of consumer by using mobile apps. The collected data by surveyor had been verified by PMAs and client employees. After data verification meter has been installed by TKC employee. PMA and client employee again verify the installed meter using mobile app. Many reports like total application, rejected application, approve application, pending application for approval, installed meter, rejected installed meter, pending installed meter for approval and bill of customers were created and available for proper business and use.

Roles & Responsibilities:

• Design packages using control flow tasks like execute SQL task and data flow task, bulk insert task and using containers like for loop container, for each loop container and sequence container.
• Extracted data from various sources and transformed the data using different transformations like data conversion, derived columns, look up, sort, aggregate, union all, merge and multi cast etc.
• Created stored procedures, triggers, constraints, CTE, temp table etc.
• Used ranking function, Rank function, scalar function, string function, table valued function and other function etc.
• Write query in SSMS as per requirement, creating index, views, joins etc.
• Write query to find duplicate data.
• Developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.

Project # 2:

Project

DDUGJY

Client

Bajaj Electricals Limited

Technology

SQL Server 2017, SSIS, SSRS

Team Size

6

Duration

March-2021 to July- 2022