Sanju Sharma

201-***-****

Highly motivated IT Professional with 6+ Experience in Microsoft technologies, Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2008/2005, SSIS and SSRS.

Experience in various domain such as Financial, Healthcare, Insurance and Retail.

Experience in migration of data and reports using SQL server 2012/2008R2/2008/2005/2000 and Visual studio 2012/2008/2005.

Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2000/2005/2008/2008R2/2012 with expertise on data normalization and understanding of software/application/system development lifecycle.

Experience in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

Expertise in using Business Intelligence Development Studio (BIDS) Graphical User Interface (GUI) to design SSIS packages for Data Management applications. Experience in Normalization/De-normalization, data design methodology and building Referential Integrity. Good knowledge of security, memory management, and exception handling.

Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transform Services (DTS) and SQL Server Analysis Services (SSAS).Extensive experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MS SQL Server 2005/2008/2008R2/2012 SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.

Experienced in designing and developing large number of reports in SSRS/Tableau using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources. Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio. Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.

Experience in data Import/Export, Bulk insert and BCP. Experienced in creating Jobs, alerts, SQL Mail Agent, scheduling packages using SSRS.

Extensive experience in database activities like Data Modeling, Database Design & Development, Coding, Implementation, Maintenance and Performance Monitoring & Tuning using tools such as Index Tuning Wizard, SQL Profiler and Replication.

Highly proficient with Microsoft Office tools such as Word, PowerPoint, Excel and Outlook.

Organized, self-motivated and punctual with excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time and little training.

Skill set:

Languages

T-SQL, PL/SQL Programming, Dynamic SQL, XML, HTML, Visual Basic 6.0, Unix/Perl Shell Scripting

Databases

MS SQL Server,2012,2008R2,2008,2005,MS Access,Oracle 10g/11g

DWH / BI Tools

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio,

Packages

MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools and Utilities

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Business Intelligence Development Studio (BIDS), Power Pivot, Microsoft Office, Excel Power Pivot, Excel Data Explorer, Tableau.

Operating Systems

Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

Professional Summary:

Commerce Insurance Group, MA net 05, 2015-11, 2016

Role: BI/SQL developer

Project Scope: Commerce insurance group is a leading company which provides personal insurance, commercial property insurance and casualty insurance. The aim of the project was to create, maintain and administer ETL and reporting jobs and to support the data and reporting needs of the organization.

Responsibilities:

Worked with Project Manager and IT Analyst to understand business rules and to discuss gap analysis between old system and new system.

Developed dashboards for the summary of analysis using various high level charts, parameters and filters.

Proactively designed, used and managed mapping overview documents to identify relationship between source and destination and to document the business process logic in the SSIS packages.

Written T-SQL queries, stored procedures, user defined functions to implement mapping fields and remaining fields.

Designed staging tables, temp tables to perform multiple joins, merge statements, views and aggregate functions.

Created T-SQL stored procedures to improve the performance of aggregate queries dynamically.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse/data marts.

Developed SSIS packages for data migration using OLEDB connection and transformation like Lookup, Merge, Data Conversion, Copy Column, and Derived Column.

Test and Debug ETL packages and configured the packages for migration, worked with QA teams to qualify and migrate packages from Dev to test to PROD environments.

Environment: MS SQL Server 2008/2012, T-SQL, SQL Server Integration Services, Management Studio, SQL server Profiler, Erwin, Tableau9.

Hanover Insurance, MA 12, 2013- 04, 2015 Role: BI/SQL Developer

Project Scope: Hanover Insurance group based in Massachusetts; provides world class auto, home, and business insurance companies. The aim of the project was to develop and implement database by restoring it from old source to new source; and providing various reports which will adequately supports BI needs of the organization.

Responsibilities:

Worked closely with clients as part of a development team to evaluate requirements and developed BI / DW solutions.

Worked with DBA to design/implement/maintain the Data Warehouse and Business Intelligence solutions.

Analyzed data for data quality and improved data architecture.

Performed tasks like -execute SQL task, data flow task, file system task for ETL process.

Developed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, Oracle, flat file, Text Format Data).

Used multiple transformations provided by SSIS such as Slowly Changing Dimension, Data Conversion, Derived Column, Lookup, Conditional Split, Bulk Insert, Merge and union all, etc.

Performed error handling in SSIS using Event Handling and logging.

Developed standard reporting structures, dashboards, drilldowns, and multilevel drill down, cascading, parameterized and sub reports etc. with different types of format.

Contributed to develop ETL/reporting standards for the organization.

Worked with visualization team to develop various dashboards.

Environment: MS SQL Server 2008/2012, T-SQL, SQL Server Reporting services, SQL Server Integration Services, Management Studio, SQL server Profiler

Fresenius Medical Care, MA 05, 2012- 11, 2013 Role: SQL/BI Developer

Project Scope: Fresenius medical care is German based company which specializes in the production of medical supplies, primarily to facilitate or aid renal dialysis. The project mainly involved designing data source and data flows, developing, and monitoring the SSIS packages and generating reports using SSRS regarding the health plans and pharmacy services for public and private employer.

Responsibilities:

Developed and deployed SSIS packages also upgrading DTS packages to SSIS. Involved in extracting the data from OLTP to OLAP using SSIS.

Used various transformations while mapping the data from source to destination using SSIS.

Designed and Built ETL packages to migrate data from different source systems using Data vault modeling concept.

Used SQL server agent to automate the SSIS package execution.

Transferred data from various sources like MS Excel, MS Access, SQL Server using SSIS and then created reports using this data using SSRS.

Tested the SSIS packages using debugging process.

Created drill-down, parameterized, sub- reports for health plan policies using SSRS.

Generated reports using Global Variables, Expressions and Functions for the reports.

Responsible for writing complex stored procedures, triggers, views and queries.

Environment: MS SQL Server 2008, MS SQL Server Reporting Services, MS SQL Integration Services-SQL, MS Visio Drawing, MS Excel, MS Word, Visual Studio.

Capital One, VA 01/2011- 04/2012 Role: SQL Developer/Data Analyst

Project Scope: The project deals with data analysis of application of the Wealth Management Group at Capital One. The main scope of the project is performing software development, maintenance, and enhancements for Client Review Centre (CRC) web application of the Wealth Management group of Capital One. CRC web application is used by Financial Advisors at Capital One to generate and review various reports which help to analyze the performance of his client’s portfolio. The data is then converted into a PDF document which is the final report.

Responsibilities:

Created reports to meet user requirements using Microsoft SQL Reporting Services.

Wrote and maintained SQL database stored procedures.

Documented all data mapping and transformation processes in the Functional Design documents based on the business requirements.

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Prepared the complete data mapping for all the migrated jobs using SSIS.

Extensively used SSIS transformations such as derived column, data conversion, Aggregate, Conditional split, SQL task and Send Mail task.

Participated in project scope discussions and business requirements meetings.

Updated requirements documentation and assist with any updates discovered during the report implementation and UAT.

Developed different kind of reports such a sub reports, charts, matrix reports, linked reports and drill-down reports.

Generated multi-parameterized reports allowing users the ability to make selections before executing reports.

Developed Reports for business end users using report builder with updating statistics.

Developed an automated report subscription process using SSRS.

Responsible to support the issues with reports on the enterprise environments (development, UAT, test and production).

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, Visual Studio 2012, MS Visio 2008, Windows 2007, PL SQL Program,, Oracle 11g.

Axis BANK, INDIA 12/2009- 11/2010

Role : SQL Devloper/DBA

Project Scope: The project involved in creating tables,views, indexes, stored procedures, functions, trigger, SSIS, ETL Packages, and various formats of reports in SSRS.

Responsibilities:

Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.

Worked with DDL, DML, and DQL in T-SQL using CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, FROM, WHERE, ORDER BY, and GROUP BY.

Responsible for quick response of SQL statement and connectivity from front application to the database servers.

Created SSIS packages/ extracts for clients like Microsoft using various components.

Involved in the performance and database optimization of T-SQL queries.

Implemented many stored procedures using DDL commands (Create, Alter, Drop).

Implemented dynamic SQL queries in stored procedures using temporary tables.

Configured the data flow and the individual data flow elements. Monitored the performance the SSIS packages.

Environment: MS SQL Server 2008R2/2008, MS SQL Server Management Studio (SSMS), MS SQL Server Integration Services (SSIS), MS Excel, T-SQL.

Education:

Master’s in Computer Science.

Contact this candidate