SUMMARY:

• Around 8+ years of experience as a MS SQL Server Developer in various domains like Healthcare, Banking, Insurance, retail and Pharmaceutical with expertise in MS SQL Server 2012/2008r2/2008/2005 and SSIS, SSRS, SSAS.
• Experienced in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL
• Involved in different phases of Software Development Life Cycle (SDLC) involving gathering requirements, Design, Development and Implementation.
• Proficient in Data Extraction, Transforming and Loading (ETL) using SQL SSIS, DTS, Bulk Insert and BCP.
• Experience in SQL Server DTS and SSIS (Integration Services) package design, development, and modifying using SQL server advanced features in Control flow, data flow, Error Handling and event handling.
• Produced operational reports in SSRS 2012/2008R2 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports
• Strong experience in designing and developing enterprise reports(SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources. Normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.
• Worked on Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
• Proficient in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Highly experienced in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, and SQL joins.
• Expertise in Data modeling tool Erwin, Backup and restore tool such as Red Gate and Idera, and insurance tool Guide Wire (for claim and billing purpose).
• Involved in Migration of data from other database to SQL Server using SSMA.
• Strong leadership, communication, problem-solving and multi-tasking abilities, demonstrated experience seamlessly learning new technologies in a short span of time, and working well under pressure.
• Involved in creating and deploying SSRS Reports on report manager.

TECHNICAL SKILLS:

MS SQL Server 2012/ 2008r2/2008/2005, SQL Server Integration Services (SSIS), SQL Server DTS, Data Stage, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, Data Modeler, Erwin 8.0/7.3/7.2, Cognos report, Oracle 11g/10g/9i, Microsoft Excel, Outlook, MS SQL, VB6, Microsoft Products MS Word, MS Excel, PowerPoint, MS Access 2010/2007/2003, XML, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Cockeysville, MD

MS SQL Server/SSIS Developer/SSRS Developer

Responsibilities:

• Involved in redesigning and redefining data warehouse and provided necessary documentation.
• Use SSIS packages to extract data from old Data Warehouse and push into new Data Warehouse.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, tables, Views, Functions.
• Used DDL, DML, and TCL to write query, recursive CTE, Join and views.
• Successfully implemented indexes on tables for optimum performance.
• Created SSIS 2012/2008 Packages to integrate data coming from Text files and Excel files.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS 2012/2008.
• Configured and Deployed SSIS Packages.
• Used SQL Agent to setup schedule for SSIS Packages.
• Responsible for implementation of data viewers, SSIS 2012/2008 Logging, error configurations for error handling the packages.
• Created several drill down and drill through reports using SSRS
• Developed dashboard reports using reporting Services, report Model and reporting using Report Builder.
• Experienced in creating linked reports and parameterized reports with knowledge of report serving architecture. (Table, chart and matrix report)
• Use various SSIS transformations such as Conditional Split, Lookup etc which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Fixed File) and loaded the data into target tables by performing different kinds of transformations using SSIS 2008.
• Updated and made necessary changes to existing Tubule, matrix and parameterize SSRS reports.

Tools: MS SQL Server 2012/2008, T-SQL, SSIS 2008, Microsoft visual studio 2008, Windows server 2008, SSRS 2012/2008.

Confidential, Westport, CT

MS SQL Server/SSIS Developer/SSRS Developer

Responsibilities:

• Involved in redesigning and redefining data warehouse and provided necessary documentation.
• Use SSIS packages to extract data from old Data Warehouse and push into new Data Warehouse.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, tables, Views, Functions.
• Successfully implemented indexes on tables for optimum performance.
• Created SSIS 2012/2008r2 Packages to integrate data coming from Text files and Excel files.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS 2012/2008r2.
• Worked on various database maintenance tasks using Drill-Down, Drill-through.
• Responsible for implementation of data viewers, SSIS 2012/2008r2 Logging, error configurations for error handling the packages.
• Use various SSIS transformations such as Conditional Split, Lookup etc which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Fixed File) and loaded the data into target tables by performing different kinds of transformations using SSIS 2008r2.
• Updated and made necessary changes to existing Tubule, matrix and parameterize SSRS reports.

Tools: MS SQL Server 2012/2008r2, T-SQL, SSSIS 2008r2, Microsoft visual studio 2008, Windows server 2008, SSRS 2012/2008r2.

Confidential, Wilmington, DE.

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in using Guide Wire suite and Gosu.
• Loaded data from staging table to operational tables and finally, to the Guide Wire policy center.
• Wrote complex T-SQL queries, store procedure and created database objects such as tables, and views.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SSRS.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Created SSIS packages for transaction reconciliation, which is being used by the accounting department as a daily basis from SAP.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis using SQL Server Agent.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SAP, SQL Server and Flat File sources and load into various Business Entities.
• Created various database objects such as Stored Procedures, Functions, Tables, and Views and wrote T-SQL queries to retrieve data from various tables.
• Configured the report viewing security for various users at various levels using Report Manager.
• Wrote queries used in Guide Wire tool based on Insurance and Assurance requirements.
• Worked on Guide Wire tool for property and causality claims.
• Work on Performance Tuning of complex queries using SQL Profiler, Index Tuning Wizard and Execution Plan.

Tools: MS SQL Server 2008/2005, SSIS, SSRS, T-SQL, MSCRM, Guide wire, Windows 2008 Server, DTS, and Erwin, Guide Wire.

Confidential, Minneapolis, MN

MS SQL Server/SSIS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Used Erwin Model to design database.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.
• Successfully implemented indexes on tables for optimum performance.
• Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Fixed File) and loaded the data into target tables by performing different kinds of transformations using SSIS 2008.
• Wrote MS SQL Server Store Procedures using existing Oracle logic.
• Worked on creating and maintaining Oracle objects such as Tables, views, and PL/SQL queries.
• Used SSMA for migrating data from Oracle to SQL Server.
• Transform all objects from Oracle database to SQL Server.
• Involved in testing to compare and verify the result set in Oracle database and SQL Server.

Tools: MS SQL Server 2008, PL/SQL, Oracle 11g, T-SQL, SSSIS 2008, Microsoft visual studio 2008, Windows server 2008, Erwin, and SSMA.

Confidential, New Brunswick, NJ

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Wrote complex dynamic SQL queries for changing column and table names using SQL variables.
• Created Complex Stored Procedures, Triggers, Function, Indexes, Tables, Views, T-SQL code and SQL Joins for applications.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Designed databases from scratch using conceptual, logical and physical modeling using Erwin.
• Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Created SSIS packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
• Analyzed and designed the business rules for Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column that are required by the staging OLAP and OLTP databases.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Worked with application developers and production teams across functional units to identify business needs and discussed solution options.
• Defined the browsing perspectives and browsing translations since most transactions were online.
• Involved in creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services and Created ad-hoc reports Using Report Builder.
• Created SSRS reports from Different Databases like Oracle and SQL Server. Configured and deployed SSRS reports.

Tools: MS SQL Server 2008, Oracle, SSIS, SSRS, T-SQL, PL/SQL, Erwin, MS Office.

Confidential, Cleveland, OH

Jr. MS SQL Server/BI Developer

Responsibilities:

• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2005.
• Upgraded to SQL Server 2005 and Management tools using SQL Server Setup Program.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using SSIS on different Data Sources.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target DW using SSIS and BCP
• Designed SSIS Packages to transfer data from various sources like XML Files, SQL Server, Excel, and Access to SQL Server.
• Handled slowly changing dimensions to maintain the history of the data.
• Identified Key Performance Indicators (KPI) and Metrics for Business needs.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed, reviewed and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.

Tools: MS SQL Server 2005, SQL Server Integration Services, MSVisual Studio, Windows Server 2003, MS Excel, MS Access, SQL Server Profiler, Erwin, T-SQL