Professional Summary:

• 8 years of experience in MS SQL Server suite of products like SSIS, SSRS and SSAS of MS SQL Server 2005/2008/2008R2/2010/2012.
• Excellent in High Level Design of ETL DTS Package for integrating data from heterogeneous sources Excel, CSV, Oracle, flat file, Informix, OLE DB, Text Format Data .
• Strong in developing, deploying packages and extracting data using SSIS from OLTP to OLAP.
• Good in Data Analysis Services OLAP Cubes, MOLAP and Mining.
• Expert in designing reports using SQL Server Reporting Services SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix reports and other features of reporting service.
• Extensively worked in Migration for MS SQL 2005 to 2008 and MS SQL 2008 R2 to MS SQL 2012.
• Good in calculating measures and dimension members using multi-dimensional expression MDX , mathematical formulas and user-defined functions.
• Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity, SQL joins and query writing.
• Tuned and optimized queries by altering database design, analyzing different query options and indexing strategies.
• Having good ability to interact with the Project Manager, Business Manager, Marketing Specialists, Business Analysts, Software Developers and Systems Engineers both on and off-shore to understand and clearly define requirements.
• Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL MS SQL Server 2005/2008/2008R2/2012 and MS Access databases.
• Experienced in generating on-demand and scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008/2010 SSRS .
• Highly proficient in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process BCP and SSIS with MS SQL 2005/2008/2010.
• Experienced in working as a team leader and guide junior developer to understand requirement and complete task before due time.
• Expert in Coding and testing according to requirements and did implementation to meet the business need.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts and SQL Mail Agent.
• Strong in database backups, restore, recovery, security, user logins, database role and database permission and hands on experience with Business Intelligence tools.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

Skillset:

MS SQL Server 2000/2005/2008/2008 R2/2012, MS SQL Server Integration Service 2005/2008/2010, SQL Server Reporting Service 2005/2008/2010, SQL Server Analysis Services 2005/2008, Aginity workbench for Netezza, Data Mart, MS Access, ERWIN 4.0/4.1/4.2, Windows 9x/NT/2000/XP/Server2003, PL-SQL, Visual Studio 2008/2010, Microsoft Visual SourceSafe, HTML, ProClarity, ASP.Net, C , VB.Net, MS Office, Crystal Reports 8.5/9/10, IBM Cognos 8, XML, MS office Visio 2007, HP Quality Center 10.0, VisualCron 6, YouTrack and Jira.

Projects Summary:

Confidential

Technical Architecture/Lead MS SQL Server,

Responsibilities:

• Created Packages using ETL tool for the users to check the codes and responsible for extracting data from huge database to manipulate and analyze the data for the end users.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Responsible for Technical analysis and design for functional requirements and Performed updating to the technical documents.
• Have worked on Data Mart design and implementation.
• Used linked server to access the objects from the Oracle data source for the mapping of source tables to destination tables.
• Designed and analyzed the document business processes, systems processes and data flow and impacts.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed system test plans, assisting in execution, recording results and ensuring that the solution meets the functional requirements.
• Implemented Facts and Dimensions tables for providing summarized and aggregate views of large sets of data.
• Worked on deployment of SSIS packages on SQL management studio and created SQL Agent Jobs to schedule run of SSIS projects.

Environment: MS SQL Server Management Studio 2008 R2, Aginity Workbench for Netezza, MS SQL Server Integration Service 2008, MS Access , MS office Visio, VB.Net, SQL Server Agent job

Confidential

MS SQL Server Developer, SSIS, SSRS

Responsibilities:

• Created parameterized reports and ad-hoc reports using Report builder for company's Stakeholders.
• Involved in transferring old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2012 database using SSIS Packages.
• Designed and created views for security purposes, implemented rules and user defined data types.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Created SSIS packages for company's website application that would transfer data among servers and perform other data transformations scheduled the same SSIS packages by creating the corresponding job tasks using SQL Server Agent and VisualCron.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Installed configured database software, associated database tools and performance monitoring software.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata.
• Created complex Stored Procedures, Triggers, Functions, Tables, SQL joins and other T-SQL code to implement business rules.
• Formatted the report layout for the requirement of the users and deploy the developed reports on to the server.
• Worked on Agile method and experience to work on tickets assigning through YouTrack and Jira.

Environment: MS SQL Server 2008 R2/2012, MS SQL Server Reporting service 2008/2010, MS SSIS 2008/2010, VisualCron 6, NetSuite, YouTrack and Jira.

Confidential

Sr. MS SQL Server, SSIS, SSRS Developer

Responsibilities:

• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, Testing of application.
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Have used SQL Server 2010 Integration Services SSIS transformations in the data flow of a package to aggregate, merge, distribute, and modify data.
• Did the whole documentation of packages and applied Naming Standards.
• Explained the whole design of ETL Process using Visio tool.
• Design and develop store procedures, configuration files, tables, views, and functions, also implement best practices to maintain optimal performance.
• Used SQL Execution plan of Queries and to index the Tables.
• Created Jobs and scheduled Packages using SQL Server Management Studio for the weekly load.
• Designed and developed a reporting solution for client environment using MS SQL Server 2012 and SQL Server Data Tool 2010.
• Generated multi parameterized reports in MS SSRS 2010 allowing users the ability to make selections before executing reports thus making them user friendly.

Environment: MS SQL Server 2012, MS SQL Server Integration Services 2010, Microsoft Office Visio 2010, Visual Studio 2012, Erwin and SQL Server Data Tools 2010.

Confidential

Sr. MS SQL Server, SSIS Developer

Responsibilities:

• Designed and built Microsoft SQL Server Integrated services Packages.
• Designed the complete Data warehouse Schema using Erwin with proper relationships defined.
• Worked with the IT staff, Actuarial Support staff and Database Administrator to assist in designing and developing appropriate relational database structures.
• Responsible for the administration and maintenance of the SSIS packages as well as taking part in setting ETL best practices and standards.
• Worked closely with the Cognos 8 BI Report Author to ensure we were meeting the increased demand for improved analysis and reporting.
• Maintained a user-focused approach to application development and reporting solutions.
• Designed and developed customized Cognos reports for the client.
• Communicated with all levels of internal and external technical and non-technical staff.
• Prepared project life cycle deliverables within expected time frame as specified by the project plan.
• Worked on SQL Server 2008 architecture and demonstrated experience reading and interpreting SQL query plans and designed high-performance, parallelized database code.
• Developed Complex stored procedures in enterprise environments and Experienced in data modeling and designing.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata.

Environment: MS SQL Server 2008/2008 R2, MS SQL Server Integration Services 2008, T-SQL, Microsoft Office Visio 2007, IBM Cognos 8, HP Quality Center 10.0

Confidential

Sr. MS SQL Server, SSIS, SSRS Developer

Responsibilities:

• Worked on designing and developing Data Warehouses, Data marts and Business Intelligence.
• Worked on migration of MS Access to SQL Server 2005 Databases and to SQL Server 2008 and moved associated logins.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count Transformations.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
• Analyzed the existing tool and participated in meetings with the business users to gather
• Requirements and design goals of data warehouse.
• Created Parameterized reports, Cross-Tab reports, Drill down reports Summary reports by using SSRS.
• Created complex Stored Procedures for commonly used complex queries involving join and union of multiple tables.

Environment: MS SQL Server 2008 R2, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005/2008, Microsoft Visual SourceSafe 6.0, Microsoft Office Visio 2007

Confidential

MS SQL Server Developer/ SSRS, SSIS, SSAS

Responsibilities:

• Created reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple T-SQL queries.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
• Responsible for Monitoring and Tuning Report performance by analyzing the execution plan of the report.
• 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 2005.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Performed extract, transform, and load data into the repository and Created Complex Stored procedure, Functions, Views, and Indexes for the Logic package.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.
• Involved in project planning, scheduling for database module with project managers.

Environment: MS SQL Server 2005/2008, MS SQL Server Analysis Service 2005/2008, MS SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services 2005/2008, T-SQL.