ABHIJEET JADHAV

I have good experience in MS SQL server, SSIS,SSRS technologies.

good team player . 

able to deliver tasks assigned in timely manner

Professional Experience

Project Name: Munich Re

Munich Re is a leading global provider of reinsurance, primary insurance and insurance-related risk solutions.

Detail Description:

• Creating new database objects like Procedures, Functions, Tables and Views, Adhoc SQL scripting for business reporting in SQL Server
• Developed SSIS Package’s reports and SQL Store Procedures.
• created several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services as per user’s requirement.
• Importing data through various data sources like excel, SQL server, Oracle using SSIS. Designing reports in SSRS as per tickets generated.
• Regular client interaction through emails, chat and conference calls.
• Defining Schedules, Timelines, list of suggestions, concerns for the migration of project and release related activities.
• Communicating with Client to understand the project requirement.

Project Name: Ingram Micro

Ingram Micro is an American distributor of information technology products and services

Detail Description:

• Creating new database objects like Procedures, Functions, Tables Views, Adhoc SQL scripting for business in AWS Redshift
• Developed SSIS Package’s reports and SQL Store Procedures.
• Importing data through various data sources like excel, SQL server using Copy commands. Regular client interaction through emails, chat and conference calls.
• Defining Schedules, Timelines, list of suggestions, concerns for the migration of project and release related activities.
• Communicating with Client to understand the project requirement. 

Project Name: EHR Application.

EHR is one of the smart healthcare application, it is mainly used for maintaining Patient Unique entry data. Which caters all the needs of Patients from admission to discharge from hospital. Application will help provider to better decision at the point of care. It provides multiple options for providing reports depend on Requirements. It contains different types of reports like Patient Orders, Documentand Flow sheets and Structure Note and Project Dash Board.

Detail Description:

• Involved in coordinating with different departments to gather the requirements.
• Understanding the business requirements and Report Specification Document to meet the client requirements.
• Involved in develop, implement and optimize stored procedures and functions using T-SQL
• Involved in creating and designing packages using SSIS by using the Existing tasks and transformations.
• Writing stored procedures and building reports based on Report Specification.
• Deploying the generated reports on production server and prepared documentation for the generated report.
• Creating new database objects like Procedures, Functions, Tables and Views, Adhoc SQL scripting for business reporting in SQL Server
• Developed SSIS Package’s reports and SQL Store Procedures.
• Collaborate with business analysts to understand the requirements to develop SSRS reports.
• Developing SSRS reports including required functionalities like Parameterized, Cascaded, and Tabular reports.

Project Name:Digital river

Digital River provides Global E-Commerce, paymentsand marketing services to their clients

Detail Description:

• Creating new database objects like Procedures, Functions, Tables and Views, Adhoc SQL scripting for business reporting in SQL Server
• Developed SSIS Package’s reports and SQL Store Procedures.
• created several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services as per user’s requirement.
• Importing data through various data sources like excel, SQL server, Oracle using SSIS. Designing reports in SSRS as per tickets generated.
• Regular client interaction through emails, chat and conference calls.
• Defining Schedules, Timelines, list of suggestions, concerns for the migration of project and release related activities.
• Communicating with Client to understand the project requirement.
• Involved in develop, implement and optimize stored procedures and functions using T-SQL
  • Creating Technical documents for Project.

Title: Sufficiency Plan Reports for CE, CEEMEA, ASIA and Philippines Business Plan Reports for CE, CEEMEA,ASIA and Philippines

Roles and Responsibility:

Sufficiency Report is basically for CE, CEEMEA, ASIA and Philippines (Total 12 reports). These reports are one of the best reports provided by Infosys to P&G. The raw data is taken from the client side and processed. In this project, my responsibility was to create SQL procedures, SSIS packages to upload the all extracts in SQL tables to manipulate the data & present the data in terms of the report structure with the help of mapping files. Client suggested to representthe report in excel,so we have constructed a Pivot Table & with the help of Macro we have generatedthe report template.

Other Roles-

• Effort Estimating for Project.
• Communicating with Clientto understand the project requirement.
• Developed SSIS Packageand SQL Store Procedures.
• Handling client queries via email and calls.
• Managing the alignments for report with clients

 Academic Credentials

MCA from Siddhant Institute of Comp. Application, Pune University.

 BCA from Modern Collage, Ganeshkhind, Pune University.

H.S.C. from Shri. Fattechand Jain College, Chinchwad, Pune.

S.S.C. from Modern High-school, Pune.