Summary

• 7 years of experience in working with Data Warehousing Business Intelligence solution Design, in the area of specifically related to MS SQL server 2005/2008 R2/2012.
• Experience in Data Extraction, Transforming and Loading ETL between Homogenous and Heterogeneous Systems using SQL Server tools, including SQL Server Integration Services SSIS , Data Transformation Services DTS .
• Expertise in SQL server database tools SQL Server Management Studio, Enterprise Manager and SQL Server Business Intelligence Studio.
• Working experience in domains Auto, Medical, Banking and Insurance sectors.
• Excellent knowledge of Data Modeling Methodologies i.e. Normalization/De-Normalization.
• Extensive experience in designing complex Relational Database models and implementations as per business requirements.
• Expert in creating Stored Procedures, User Defined Functions and T-SQL batch scripts to accommodate complex business specifications.
• Created SSIS packages with error handling using various data transformations like conditional split, for each loop, multi cast, column conversion, script components for elimination of duplicate Data, Null values, and converting data into required formats.
• Experience in migrating data from external system including flat files, excel, MS Access and Oracle into SQL Server using SSIS/DTS packages.
• Worked with OLTP, Data warehouse applications, dimensional models which include star and snowflakes schemas to implement SSAS, SSRS for supporting large Reporting needs.
• Experience in front end development tools like VB.net, c .net, and HTML.
• Excellent task oriented team player with good written and verbal communication skills.

Technical Skills:

• Databases: MS SQL Server 2008/2005, Oracle 10g/9i
• Database Tools: Enterprise Manager, Query Analyzer, SSMS, SQL Profiler, Data Transformation Services DTS , Business Intelligence Development Studio BIDS .
• Data Modeling: Dimensional Data Modeling, UML, Logical and Physical data modeling.
• ETL Tools: SQL Server Integration Services SSIS , SQL scripts, Data Junction.
• Languages: T-SQL, PL/SQL, MDX, HTML, DHTML, XML, VBA, C .net, Asp.net
• Operating System: Windows XP/2000, Vista, UNIX, Windows Server 2003/2008.
• Reporting Tools: SQL Server Reporting Services SSRS ,Crystal Reports 9/8.5, MS Excel.

PROJECTS SUMMARY:

Confidential

ETL Developer

Responsibilities:

• Design and develop ETL solutions using approved WPS tools for interfacing between source data and Data Warehouse.
• Execute unit tests and validate expected results: iterating until test conditions have passed.
• Perform problem assessment, resolution and documentation in existing ETL packages, mapping and workflow in production.
• Develop Data Marts.
• Develop SQL and stored procedures for reporting.

Environment: SQL Server 2012, 2008R2, 2000, SSIS, SSRS, DTS, DB2, SQL Profiler, Management Studio.

Confidential

SQL Server SSIS Developer

Responsibilities:

• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data into ODS.
• Extract, Transform and Load ETL process framework.
• ETL development using T-SQL programming, scripts, stored procedures, views.
• Developed SSIS packages using different types of Error Handling for various events.
• Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database DB2, Text files and Excel files to SQL Server.
• Developed complex queries using joins and sub-queries.
• Experience with ER and Dimensional modeling.
• Performance tuning and Query Optimization.
• Created multiple views and queries for complex SSRS reports.
• Developed SQL Scripts for creation of various Database Objects Stored Procedures, Indexes, Triggers, and User Defined Functions .
• Created Clustered index and Non-clustered for increasing performance.
• User interface design and developed scripts to support client business needs.
• Perform data load into star schema and cube refresh dimensions and measures .
• Worked with business analyst to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

Environment: SQL Server 2008R2, SQL BI Suite SSIS, SSAS, SSRS , MS Visual Studio 2005/2008,T-SQL,i360,SQL Profiler, Management Studio.

Confidential

SSIS Developer/MSSQL Developer

Responsibilities:

• Developed various queries, stored procedures, functions, triggers, cursors and views on existing database schema of SQL Server 2008.
• Developed SSIS/ETL packages to integrate data between various databases and also to load data from disparate data sources to an integrated data warehouse.
• Developed SSIS packages using different types of Error Handling for various events.
• Developed complex queries using joins and sub-queries.
• Experience with ER and Dimensional modeling.
• Involved in Performance tuning and Query Optimization.
• Created multiple views and queries for complex SSRS reports.
• Created Clustered index and Non-clustered for increasing performance.
• User interface design and developed scripts to support client business needs.
• Worked with business analyst to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

Environment: SQL Server 2008R2, SQL BI Suite SSIS, SSAS, SSRS ,MS Visual Studio 2005/2008, DTS, T-SQL, i360, SQL Profiler, Management Studio, TOAD.

Confidential

Project Description:

Responsibilities:

• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data into Data Warehouse and Data Mart.
• Extract, Transform and Load ETL process framework.
• Developed SSIS packages using different types of Error Handling for various events.
• ETL development using T-SQL programming, scripts, stored procedures, views.
• Experience with ER and Dimensional modeling.
• Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database DB2, Text files and Excel files to SQL Server.
• Performance tuning and Query Optimization.
• Developed complex queries using joins and sub-queries.
• Created multiple views and queries for complex SSRS reports.
• Developed SQL Scripts for creation of various Database Objects Stored Procedures, Indexes, Triggers, and User Defined Functions.
• Created Clustered index and Non-clustered for increasing performance.
• Experience in Designing and Building the Dimensions and Facts with star schema and snowflake schema using SQL Server Analysis Services SSAS .
• User interface design and developed scripts to support client business needs.
• Perform data load into star schema and cube refresh dimensions and measures .
• Worked with business analyst to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

Environment: SQL Server 2008R2, SQL BI Suite SSIS, SSAS, SSRS , MS Visio2005/2008, XML, VB. NET, MS office 2007, MS Project , Windows Server 2003, Internet Information Server IIS 6.0/7.0, My SQL, MS-Access, ASP.NET,MS Visual Studio 2005/2008, DTS, T-SQL, SQL Profiler, Power Builder, Management Studio,HL7 Iguana,Pragmatic works, TOAD.

Confidential

SQL Server SSIS Developer

Responsibilities:

• Developed T-SQL scripts to merge data into central repository.
• Created configuration files for Deployment of SSIS packages onto Different server.
• Worked with different data sources like DB2, Oracle and Access.
• Good experience in working with Data Transformation tasks such as Conditional Split, row count, Copy Column, DerivedColumn, look up, Merge and Merge Join tasks.
• Created DTS and SSIS packages for the Data Flow.
• Developed Complex Stored Procedures and Functions for supporting efficient data storage and manipulation.
• Create User Defined Functions depending upon the requirements.
• Data loading into Tables using Stored Procedures and SSIS Packages.
• Created Views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Wrote SQL scripts to Insert, Update and Delete data in MS SQL database.
• Experience in Designing and Building the Dimensions and Facts with star schema and snowflake schema using SQL Server Analysis Services SSAS .
• Developing user controls and aspx pages.

Environment: SQL Server 2005, SQL Server 2000, VB 6, Transact-SQL, VBScript, Erwin, Crystal Reports, Microsoft Visio 2000, ASP.NET, MS Excel Windows 2003/2000/NT/XP.

Confidential

SQL Developer/ETL Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Indexes, Views using T-SQL.
• Testing the stored procedures performance and its path of execution by using SQL Profiler.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Data Transfers between various servers using BCP.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
• Designing, creation of tables, stored procedures with E-R diagrams with extensive use of Erwin 4.0.
• Experience in Error and Event Handling, Precedence Constraints, Break Points, Check Points, Logging.
• various data sources.
• Designing and Developing the Data Transformation Services DTS packages to populate data from
• Creation of user Databases and installation of MS SQL Server 2005.
• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams, phasing from development to QA and to Production environment.

Environment: SQL Server 2005/2000, T-SQL, Data Transformation Services DTS , SSIS, SSRS, SSAS, Windows2003, Query Analyzer, SQL Profiler.

Confidential

SQL Server Developer

Responsibilities:

• Designed DTS Data Transformation Service packages to transfer data between servers, load data into database, archive data file from different DBMS's using SQL Enterprise Manager/SSMS on SQL Server 2000 environment and deploy the data.
• Worked on DTS Packages, DTS Import/Export Wizard for transferring data from different types of Databases to SQL Server.
• Designed ER diagrams and mapped the data into database objects.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
• Used DDL and DML commands for writing triggers, stored procedures, and data manipulation.
• Created joins and sub-queries for complex queries involving multiple tables.
• Performance tuning of TSQL queries and Stored Procedures.
• Created Indexes for fast retrieval of the data.
• Worked on Exception Handling with error and Try/Catch blocks.
• Involved in developing user controls and aspx pages.

Environment: MS SQL Server 2000/2005, Windows NT, SQL Profiler, Access, Excel, Windows 2000,Query Analyzer, Enterprise Manager, Data Transformation Services DTS .