SUMMARY

• Over 8+ years of IT experience as a MS SQL Server 2012/2008R 2/2008/2005/2000 Developer in various industries like Finance, Insurance, and Health Care.
• Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools and surrogate key generation.
• Expert in Logical and Physical Database design & development and Data modeling using the Erwin Data Modeler tool. Also performed consistency checks using DBCC utilities to ensure the physical consistency of the database and objects.
• Experienced in SharePoint 2010 Development, .NET Development, SharePoint 2010, web configuration and deployment
• Provided support to SharePoint users and site level administrators
• In - depth knowledge of Transact-SQL (DDL and DML). Proficient in creating Tables, Indexes, Joins, Triggers, Views, Stored Procedures, User Defined Data Types and Functions.
• Expertise in performing ETL using SSIS, DTS, Bulk Insert and BCP.
• Developed SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Expertise in upgrading/migrating from DTS to SSIS packages. Experienced in resolving complex issues and error handling in SSIS 2012/2008R 2/2008/2005.
• Experienced in report generation using Crystal Reports, XML, MS Access and Excel.
• Proficient in creating Chart reports, Drill down and Drill through reports by passing parameters using SSRS 2012/2008R 2/2008/2005.
• Conversant with all phases of the Software Development Life Cycle (SDLC) involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.
• Developed and Deployed OLAP cubes, Facts and Dimension tables.
• Used MDX (Multi-dimensional Expressions) queries for calculated members of a cube and KPIs (Key Performance Indicators) in SSAS 2012/2008R 2/2008/2005.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export and Troubleshooting.
• Expertise in using tools like the Index Tuning Wizard of the Database Engine and SQL Profiler for performance monitoring and tuning.
• Expertise in VBA macros and MS-Excel (VLOOKUP and Pivot)
• A motivated, highly organized individual and enthusiastic team player with excellent communication, analytical and problem solving skills.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R 2/2008/2005/2000
• MS SQL Server 2008/2005 Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Reporting Services (SSRS)
• Microsoft Access 2000
• ERWIN 9/8/7.2
• Microsoft Visio 2010/2007
• T-SQL
• C#
• VB.Net
• HTML
• XML
• XSL
• Oracle 11g/10g
• Crystal Reports 8.5/9/10/11
• TFS
• Visual source safe 2005
• MS office 2010/2007/2003
• Windows 2008/2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation
• Facets
• QlikView
• VBScript
• SharePoint 2007.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

MS SQL/SSIS/SSRS/SSAS Developer/BI Developer

Responsibilities:

• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, PSD (Staging Database) to data warehouse (PDW).
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Created jobs on daily basis and schedule job to update recent data by using SQL Server Agent jobs.
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.
• Developed Package Configuration by using SQL Server type for making Package dynamic.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment using Sql Server Reporting Services(SSRS).
• Scheduled execution and delivery of end of the day report using SSRS.
• Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.
• Optimized schema, performance and capacity planning of various data transformation processes related to the reports.

Confidential, Charlotte, NC

SQL/SSIS/SSRS /BI Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources (Teradata) for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to CDW with the help of SSIS.
• Used QlikView Business Intelligence platform for turning data into knowledge.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2012.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2012.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2012 with the use of the Query Analyzer and Database Engine Tuning Wizard.

Confidential, Worcester, MA

MS SQL Server/SSIS/SSRS/ BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• 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.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.

Confidential, NYC,NY

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed SSIS packages to transfer data between servers, load data into database, archive data file from different DBMS’s using SSMS on SQL Server 2005 environment, and deploy the data; Scheduled the jobs to do these tasks periodically;
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Made sure that standards and best practices in database development were followed and maintained.
• Scheduled and monitored all maintenance activities of SQL Server 2008 including database consistency checks and index defragmentation.
• Set up database backup and recovery strategies.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Maintained all records of project status and followed changes as per control procedures.
• Provided technical support to internal developers and external clients.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Confidential, Westlake, OH

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed a Database and a Data Warehouse for the system using Star Schema.
• Implemented SSIS package to perform ETL on data from OLTP systems such as Oracle, Flat Files, CSV, SQL 2008 and loading into the Staging Database using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures and Triggers.
• Developed Stored Procedures and Triggers to handle complex business rules, data conversion, historical data, and audit analysis.
• Scheduled Stored Procedures and SSIS packages every mid-night and every week by creating SQL Server Agent jobs in SQL Server Management Studio (SSMS).
• Designed and Deployed Cubes in SSAS 2008. Created Fact and Dimension tables.
• Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI (Key Performance Indicators).
• Created Sub-reports, Drill-down reports, Matrix reports and Summary reports in SSRS 2008.
• Utilized VB.net in Script Task to check existing file in SSIS package
• Created various Parameterized Reports, Drill through Reports using SSRS 2008.
• Generated ad-hoc reports using MS Reporting services.
• Utilized Package Configurations and Event Handlers in SSIS to make a package more portable and to handle errors in the packages.

Confidential

Data Analyst/SSRS Developer

Responsibilities:

• Upgraded MS SQL Server 2000 databases to 2005 using detach/attach, backup and recovery and by replication.
• Incorporated the DTS packages into SSIS 2005 by using package migration wizard and executed DTS 2000 Package task.
• Involved in SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.
• Performed transformations using various SSIS tasks such as conditional split, derived column, that performed data scrubbing, including data validation checks during staging, before loading the data into the data warehouse.
• Used ETL to implement the slowly changing transformation to maintain historical data in data warehouse.
• Created Views to reduce database complexities for the end users.
• Designed and implemented stored procedures and triggers for automating tasks.
• Created Sub-reports, Drill-down reports, Summary reports, and Parameterized reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
• Created alerts for successful or unsuccessful completion of scheduled jobs