SUMMARY

• 8 years of experience in design, development, testing, performance optimization and documentation using SQL Server.
• Experience in working with SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008.
• Extensive experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Extensive experiences in developing Stored Procedures, Views, Triggers and Complex Queries, generating cubes on SQL Server 2000/2005/2008 .
• Excellent experience and understanding of database design, migrating data using SSIS, relational integrity, Constraints, OLAP, OLTP, Cubes and normalizations.
• Expert in development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SSIS with MS SQL 2008.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Knowledge regarding cubes and developed measures and dimension members using Multi Dimensional Expression (MDX) to meet additional needs that were calculated from existing measures.
• Excellent experience as a Crystal Reports Developer working on large-scale enterprise projects involving complex business case functions, web integration, and data management.
• Proficient in using Crystal Management Console, Crystal Configuration Manager, Crystal Repository, Crystal Migration Wizard and Crystal Publishing Wizard for publishing reports on the Intranet.
• Experienced with converting Crystal reports to SSRS reports and migrate crystal reports to higher versions.
• Experienced in capturing data changes made to the tables.
• Maintained Data quality, experienced in loading and transforming complex data using Talend open studio.
• Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008
• SSIS 2008/2005
• SSRS 2008/2005
• SSAS 2008/2005
• OLTP
• OLAP
• SQL Query Analyzer
• SQL Server Management Studio
• MS SQL Profiler
• Erwin Data Modeler
• Crystal Reports 8.5/9.0/10/X1
• C
• C++
• C#
• Oracle 9i
• Oracle 10g
• TOAD 6.0
• Microsoft Products MS Word
• MS Excel
• MS Power point
• VSS
• HTML
• XML
• Unix
• MS VISIO
• Erwin
• Talend
• CDC.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

MS SQL Developer/ETL/SSIS/SSRS Developer

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Involved in writing stored procedures, Triggers, User-defined Functions, sub-queries, views and Cursors for both Online and Batch requests handling business logic and functionality of various modules. Experience in creating joins for complex queries involving multiple tables.
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Involved in query optimization and tuning stored procedures for better performance.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked on different kinds ofTransformations (Data Conversion, Lookup, Derived Column, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Slowly Changing Dimension, Union All etc)inSSISas per the clients Requirement.
• Experience in providing Error handling by using Event Handler for SSIS Packages.
• Worked with different methods of logging in SSIS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2012.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2012.
• Created stylish Report Layouts and Deployed the Reports using SSRS 2005.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.

Environment: MS SQL Server 2008 Enterprise Edition, SQL Server 2012,sql server reporting services, sql server integrating services, T-SQL, Erwin 7.1

Confidential, Sunnyvale, CA

MS SQL Developer/BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks 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.
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created Views to reduce database complexities for the end users.
• Created Sub-Reports, Drilldown-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.
• Used SQL Profiler for creating traces by which a suggestion for the query is analyzed by SQL query analyzer.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Migrated data from one database to other database using SSIS.
• Developed test reports for the test cases and updated the changes of the test cases in the data ware house.
• Generated reports based on the test cases.
• Performed Documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Involved in database performance and maintenance duties such as Tuning.
• Documented the project work and process.

Environment: MS SQL Server 2008, T-SQL, MS SQL Server Integration Services 2008, MS SQL Server Reporting Services 2008, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2008, Erwin Data Modeler, Windows XP, MS Office 2003/2007/2010 , MS Access.

Confidential, Grapevine, TX

MS SQL Developer/ETL/SSIS/SSRS Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Created complex Stored Procedures, triggers, tables, views and SQL joins and statements for applications.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2008.
• Developed measures and dimension members using Multi Dimensional Expression (MDX) to meet additional needs that were calculated from existing measures.
• Implemented the calculations to aggregate physical measures using management studio.
• Defined Referenced relationships with the measure groups and fact tables.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Communicated with the business users for gathering of requirements.
• Involved in Quality Assurance checks on data retrievals on a daily basis.
• Documented the project work and process.

Environment: MS SQL Server 2005, 2008 Enterprise Edition, sql server reporting services, sql server integrating services,T-SQL, Erwin 7.1

Confidential, Naperville, IL

Data Base Developer/ Data Modeler

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Upgraded MS SQL Server 2000 databases to 2005.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created SQL server Analysis Projects and created multi-dimensional databases.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2008.
• Developed measures and dimension members using Multi Dimensional Expression (MDX) to meet additional needs that were calculated from existing measures.
• 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.
• Applied performance tuning techniques for a poorly performing query.
• Used SQL Profiler for creating traces by which a suggestion for the query is analyzed by SQL query analyzer.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: MS SQL Server 2000/2005, T-SQL, MS SQL Server Integration Services 2005, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Erwin Data Modeler, Windows XP, MS Office 2003/2007, MS Access

Confidential, Chicago, IL

MS SQL Developer/SSIS Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents.
• Created complex Stored Procedures, triggers, tables, views and SQL joins and statements for applications.
• Developed T-SQL (DDL-Data Definition Language, DML-Data Manipulation Language) statements using dynamically generated SQL.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Implemented triggers for automating tasks. Created Linked Servers for OLEDB Data Source and Native Sources.
• Responsible for creating, maintaining and monitoring mirrored servers, configured using synchronous and asynchronous updates with witness server.
• Used SQL Profiler, Windows Performance Monitor and DB Artisan for troubleshooting, monitoring,
• Setup log shipping and troubleshooting log shipping errors when arises.

Environment: MS SQL Server 2000/2005 Enterprise Edition, T-SQL, VB Script, Windows Server 2000, Erwin 4.0, Integration Services