Resume

Sign in

Ssrs Ssis

Location:
Pune, Maharashtra, India
Salary:
13 lakhs
Posted:
April 27, 2021

Contact this candidate

Resume:

Abhijeet Acharekar

Cell:+91-771*******

Email: adlzmm@r.postjobfree.com

Address: E-201,Sai Paradise,Sector 8A,Airoli,Navi Mumbai-400708.

DATABase and MSBI Developer

Career Objective:-

A skilled, Talented and dedicated IT professional with diverse experience in database, Data warehousing and business intelligence. Looking for a challenging position to utilize my knowledge of implementing and designing low cost solution for enterprise data integration.

Personal Details:

Nationality

Indian

Religion

Hindu

Date & Place of Birth

March 01, 1990

Marital Status

Single

Phone

771-***-****

Email Address

adlzmm@r.postjobfree.com, adlzmm@r.postjobfree.com

Languages Known

English Hindi Marathi.

IT Summary:-

Having 8 years of experience in IT

Having domain knowing of General Insurance and Banking.

Having 8 year of experience in Designing ETL and Report through SSIS/SSRS.

8 years of experience in T-SQL coding, Procedures, functions, triggers, cursors using SQL Server 2005/2008/2012.

Basic knowledge of Oracle, ODI tool, Teradata, C#.net.

Good technical, logical skills

A dynamic team player with ability to learn quickly.

Database Developer And MSBI skills include:

Experience on Business Intelligence Developer in Production, Development and Staging Environments.

Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.

Experience in BI Development and Deployment of SSIS packages .

Experience in development and deployment of SSRS Reports.

Experience in solving Real Time issues

Experienced in programming tasks-Stored Procedures, Triggers, CTE, Cursors using SQL Server 2005/2008/2012 with T-SQL.

Experience in developing Parameterized reports, Sub reports, Linked reports, drilldown reports in SSRS.

Experience in Email subscriptions for SSRS reports.

Expertise T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Complex Transactions.

Creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Defaults, user defined data types and functions

Experience in Implemented CDC(Change data capture)

Experience in development of complex queries for TAT reports, Summary reports in SQL.

Work Experience

IDBI Intech Pvt. Ltd.

Sr. Executive Technology Delivery MIS

FEB’17-Present

Projects-

1.Automated Data Flow(ADF)

ADF application is developed to prepare RBI reports.

Key Responsibilities:.

Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS),Developed, deployed and monitored SSIS Packages.

Collecting of data from different source .

Created SSRS report for reporting purpose.

2.Combined Dashboard

It is C#.net application which includes number of SSRS reports.

Key Responsibilities:

Development of SQL scripts as per the requirement.

Coordination with application development team.

Development of SSIS packages and SSRS reports.

3.EIR tool

This tool is used to calculate effective interest rate on given loan.

Key Responsibilities:

Design and development of SQL store procedure as per requirement.

Coordination with application development team.

Development of SSIS package and SSRS reports.

Ahead Infosoft Pvt. Ltd.

Client – Reliance General Insurance

Senior Software Engineer

JAN’15-JAN’17

Projects-

4.Insurance Information Bureau (IIB) Reports

Preparing the IIB report in Specified format for commercial & retails products like Fire, Engineering, Marine & Motor.

Key Responsibilities:

Performed Physical and Logical Data Modeling for databases of varied sizes.

Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS),Developed, deployed and monitored SSIS Packages.

Collecting of data from different source .

Created SSRS Sub report for reporting purpose.

5.Renewal Target Generation

Collecting data from all transactional system and pushing into a one common table.

Key Responsibilities:

Creating ETL specifications for data roll up from DWH base table and find out the Policy end date and claims against policy.

Performing Vendor, branch, agent, Sales managers against policy for renewal.

Update make and Model against Policy Numbers.

6.RI Reports

Collecting data from different RI tables and generating the different RI reports.

Key Responsibilities:

Collecting of data from different RI register like RI Inward register & RI register dummy.

Designing the report like GNPI, Treaty,SOA Etc

Deployment of report on report server.

7.CN Outstanding Reports

Insurance company provides cover note book to motor insurance agent. Each book contains 5 cover note numbers. CN outstanding reports shows the details of pending cover notes at agent to responsible persons like SM, BM, CM etc. It helps to reduce frauds.

Key Responsibilities:

Worked as a database and MSBI developer .

Create Database Objects like Tables with proper indexes, Stored Procedures and queries that used in SSRS reports.

Created SSIS package that send mails with attachment of SSRS reports as per schedule.

8.Migration of past data

Migration of previous four years data from excel to sql tables.

Key Responsibilities:

Worked as a database and MSBI developer .

Created Sql Tables,SSIS package that sequentially import excel file to sql using for each loop container.

Created SSRS report that shows summary of migrated data for reconciliation purpose .

9.CUB Report

It’s a City Union Bank report to examine how much business they have given to RGI from each branch.

Key Responsibilities:

Worked as a database and MSBI developer .

Created SSRS report and its email subscription to send this report to concern persons.

Health India TPA services Pvt. Ltd.

Software Engineer

Jul’14– Jan’15

Projects-

1PIMS (Pre-Insurance Management System)

PIMS is a web based application. PIMS System is used to store the details of Test that taken before providing health insurance policy to customer. Its helps insurance company to identify customers habits, diseases etc. and also helps to decide premium of policy. It also has DC(Diagnostic Center) module.

.

Key Responsibilities:

Worked as a database developer .

Create Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.

Worked with C#.net developers.

Create SSRS reports & SSIS package as per requirement.

2Claim Management System (CMS)

This windows based application is developed to provided end to end solution for claim processing. It helps in maintaining claim registers both in creation and maintenance, generate MIS report, TAT reports and overall business. It enables faster settlement of claims, better customer retention ratio, more accurate assessment of liability & assessing the employee performance

Key Responsibilities:

Worked as a database developer .

Create Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.

Paramount TPA Services Pvt. Ltd.

Jr.Programmer

Mar’12– May’14

Projects-

1.RSBY (Rashtriya Swasthya Bima Yojana)

RSBY is a government scheme where government providing health insurance to the people that came under below poverty line. This system is developed to take care overall RSBY process at TPA level basically to settled the claims. It’s also used for reporting purpose where we creates SSRS reports and show them in web application. Also need to manage enrollment data provided by vendor, restoring backup files, cleaning of data and taking backup.

Key Responsibilities:

Designing and coding sql queries, store procedures, triggers, cursors, etc.

Created SSRS Reports.

Worked little on C#. net web application.

2.BKKY (Biju Kishu Kalyan Yojana)

BKKY is a Orissa government scheme where government providing health insurance to the people. This system is developed to take care overall BKKY process at TPA level basically to settled the claims. It’s also used for reporting purpose where we creates SSRS reports and show them in web application. Also need to manage enrollment data provided by vendor, restoring backup files, cleaning of data and taking backup.

Key Responsibilities:

Designing and coding sql queries, store procedures, triggers, cursors, etc.

Creating SSRS Reports.

Worked little on C#. net web application.

Technical Skill

Software

MS SQL Server 2000/2005/2008/2012, SSIS,SSRS, Oracle 9i

Education& Training

SSC from Maharashtra board

HSC from Mumbai University

B.com from Mumbai University

GNIIT from NIIT



Contact this candidate