beBee background
Professionals
>
Technology / Internet
>
Pimpri
ABHIJEET JADHAV

ABHIJEET JADHAV

MSBI DEVLOPER -SQL SERVER, T-SQL,SSIS,SSRS
Pimpri, Maharashtra

Social


About ABHIJEET JADHAV:

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

good team player . 

able to deliver tasks assigned in timely manner

Experience

Professional Experience

  
 


 

L&T Software Pvt. Lmt, PuneJune 2019 – Present

 

 

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. 

 

 

Allscripts India Pvt. Lmt,PuneOct 2017 – June2019

 

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.

 

Cybage Software Pvt. Lmt, PuneJul 2015 – Oct 2017

 

 

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.

 

Infosys PuneMar2014 - Jul2015

 

 

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

 

Education

 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.

 

Professionals in the same Technology / Internet sector as ABHIJEET JADHAV

Professionals from different sectors near Pimpri, Maharashtra

Other users who are called ABHIJEET

Jobs near Pimpri, Maharashtra

  • K R Public School, Nandurbar

    Tgt English

    2 weeks ago

    Direct apply

    K R Public School, Nandurbar Nandurbar, India

    K R Public School is a CBSE Day cum Residential school in Nandurbar. KRPS is the only school in Nandurbar with Sr. Secondary affiliation. School is spread in 15 acres with all all modern facilities like swimming pool, smart classes, Math lab, English language lab, Phy, Ch, Bio la ...

  • K R Public School, Nandurbar

    Prt English Teacher

    2 weeks ago

    Direct apply

    K R Public School, Nandurbar Nandurbar, India

    K R Public School is a CBSE Day and Residential school in Nandurbar. KRPS is the only school in Nandurbar with Sr. Secondary affiliation. School is spread in 16 acres with all all modern facilities like swimming pool, smart classes, Math lab, English language lab, Phy, Chem, Bio ...

  • Rawalwaisa Group

    Site Supervisor

    4 days ago

    Direct apply

    Rawalwaisa Group Dediapada, India

    **Industry: Solar** · **Job Title: Site Supervisor (Civil)** · **Hours: Full-time** · **Location: Surat, Gujarat (Head Office); On-Site work** · **Compensation: As per industry norms** · **Job Purpose** · As a Site Supervisor (Civil), your primary role is to work under the guidan ...