EXPERIENCE SUMMARY

• Having 8 years of extensive experience in IT Industry in Analysis, Design, Development and Maintenance of various software applications in Data warehousing and .Net Technologies
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Experienced in full life cycle ETL development using SSIS.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
• Experience working with huge databases in teh volumes of Terabytes.
• Hands on Experience to Migrate teh DTS Packages into SSIS.
• Expertise in providing Business Intelligence solutions in Data Warehousing using Cognos 8.0 Framework Manager, Report Studio and Query Studio.
• Experience as a developer in Microsoft .NET technologies using Visual Studio.NET, C#, ASP.NET, ADO.NET, XML, XSLT.
• Designed and mapped using Various SSIS Transformations like OLEDB Command, Conditional Split, unpivot, Script, Multicast and Derived Column.
• Good noledge on Oracle and Sql Server 2000/2005/2008
• Experience in migrating SQL Server 2000 to SQL Server 2005.
• Experience in Physical Model and Logical Model by using Microsoft Visio.
• Experience in providing Logging, Error handling by using Event Handlers.
• Expert in installation of SSRS and Configuring Report Server.
• Expertise in generating reports using SQL Server Reporting Services (SSRS).
• Experience in creating ad - hoc reports by using Report Builder in SSRS.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience on writing teh Stored Procedures, Functions and Views
• Experience on to Developing teh T-SQL (Transact) Statements.

TECHNICAL SKILLS:

Operating system: Windows 2000 Server, Windows NT/XP

RDBMS: SQL Server 2000/2005/2008, Oracle 9i

Programming languages: C, C++.

GUI tools: VB.NET, C#. NET

Web Designing Tools: HTML, XSLT, XPATH, XSL-FO

ETL Tools: DTS, SSIS (SQL Server Integration services), Informatica.

Development Tools: SQL Server Business Intelligence Development studio

Reporting Tools: Cognos Reportnet, Report Studio and SSRS

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling.

Domain: Retail, Pharmaceutical, Healthcare, NGO, Entertainment

PROFESSIONAL EXPERIENCE

Confidential, Overland Park, KS

Senior DW ETL/SSIS/Sql Server Developer

Responsibilities:

• On site coordination by involving teh stakeholder management and Offshore team communication for project execution.
• Technical solution consulting for providing teh architectural guidelines for teh requirements
• Providing teh Technical specifications for teh requirements and issues in teh source system
• Team coordination ( at offshore) for teh daily /weekly status updates
• Customer management by involving in teh project discussions at onsite
• Providing teh effort estimations and solution architectures for teh new proposals.
• Building some Innovative Point solutions which cater across multiple solutions.
• Developed an ETL Design document based on FRS along with offshore team.
• Reviewing a Data model, SSIS packages, DB Scripts and Stored procedures which are developing by offshore team.
• Designed and implemented a SSIS packages for LTE, WIFI.
• Developed Views, T- SQL Scripts and stored procedures to transform data between source staging area to target Fact Tables.
• Developed a script for executing SSIS packages from Command Prompt utility.
• Deployed teh SSIS packages from QA server to Production Server along with Configuration management team.

Environment: SSIS, BIDS, SQL Server 2005/2008/R2, Excel file, T-SQL, Asp.Net 3.0C# 3.0.

Confidential, Palm Beach Gardens, FL

Senior ETL /SSIS/SqlServer 2008 R2 Developer.

Responsibilities:

• Knowledge in designing and developing Data Warehouses, Data marts in Business Intelligence environment using Star Schema.
• Created and scheduled SSIS packages to load teh data form OLTP source system to data staging environment and then to data warehouse environment.
• Designed SQL SSIS Packages to extract data from various data sources such as Oracle 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; Scheduled and maintained nightly and weekly loads of data by creating teh corresponding job tasks.
• Responsible for creating complex Stored Procedures, tables, and views and other SQL joins
• Implemented teh Package configuration using XML files.
• Transformations of data such as adding derived column, sorting of data, merging of data TEMPhas been done while pulling data from SQL Server 2005 to teh SQL Server 2008.
• Used various transformations like Multicast, Conditional Split, OLEDB Command, and Lookup while loading teh data into Destination.
• Scheduling ssis packages to create jobs for daily ETL operations.
• Enabled package configuration files and used variables and expression grammar in SSIS packages.

Environments: SqlServer 2008 R2, SSIS, SSRS, Visual Studio 2008, C#, TFS.

Confidential, New York City, NY

Senior ETL /SSIS/SSRS Developer

Responsibilities:

• Knowledge in designing and developing Data Warehouses, Data marts and cubes in Business Intelligence environment using multi-dimensional models such as Star Schema.
• Created and scheduled SSIS packages to load teh data form OLTP source system to data staging environment and then to data warehouse environment.
• Developed two different types of master package to execute teh child package using execute package task
• Communicating with BA team and making sure teh reference table data is up to date.
• Designed SQL SSIS Packages to extract data from various data sources such as Oracle 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; Scheduled and maintained nightly and weekly loads of data by creating teh corresponding job tasks.
• Responsible for creating complex Stored Procedures, triggers, tables, and views and other SQL joins.
• Used Perforce as a source control.
• Worked on Enterprise data warehousing, Data Vault methodologies consisting of Hubs, Satellites, link tables, ODS and Data marts.
• Created traceability mapping document and design document which consists of teh business requirements with source to target with ETL transformation logic.
• Efficiently Used MERGE statement in stored procedures.
• Created event handlers like on post execute, on error etc. for error handling.
• Responsible for Developing, Deploying, scheduling and troubleshooting SSIS packages
• Developed unit test cases using manual scripts and third party tool Concordian to validate teh data.
• Scheduling ssis packages to create jobs for daily ETL operations.
• Enabled package configuration files and used variables and expression grammar in SSIS packages.

Environment: SQL Server 2008, SSIS, SSRS, Report Builder 3.0, Visual Studio 2008, Oracle, PL\SQL 11g, TOAD, C#, Perforce, Agile methodology(SCRUM), Concordian Automation tool.

Confidential, Miami, FL

Senior /SSAS/SSRS/Sql Server 2005 Developer

Responsibilities:

• To understand business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development.
• Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
• Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions and Fact tables.
• Prepared Business requirement documentation and requirement specification document.
• Developed a logical Data model and Star Schema based on client business process.
• Identified teh Confirmed dimensions, Junk dimensions, SCD’s based on client source System analysis.
• Extracted teh data from Flat Files and CSV files to SQL Server 2005.
• I has developed triggers for INSERT, UPDATE and DELETE.
• Created an ad-hoc reports using SSRS Report Builder.
• Designed a Tabular, List and Chart Reports using SSRS Report Designer.
• Created efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Conduct code walkthroughs and review peer code and documentation.
• Transformations of data such as adding derived column, count of records, merging of data TEMPhas been done while pulling data from Source to teh Target.
• I has worked on various tasks and transformations like Execute Sql Task, DFT, Execute Package Task, Conditional split, Script Component, OLEDB Command, Row Count, DCNV, Unpivot, Merge and Lookup while loading teh data into Destination.
• Created a various Stored Procedures to validate teh data from Source and update teh records and insert them into a newly created table.
• Involved various levels of testing (Unit, Functional and Integration).
• Applied teh various validations on teh Data.

Environment: SSIS, SSRS, SSAS, BIDS, Report Builder, Report Manager, Informatica 8.6.0, Erwin, ER/Studio, TFS, SQL Server 2005, T-SQL and Star schema Data Model.

Confidential, NEENAH, WI

DW ETL/ SSIS/ SSRS/ Sql Server 2005 Developer

Responsibilities:

• Gather requirements and design of data warehouse and data mart entities.
• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Designed and implemented a Data warehouse structure for Disney Movie Club.
• Developed a logical Data model and Star Schema based on client business process.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Identified teh Confirmed dimensions, Junk dimensions, SCD’s based on client source analysis.
• Developed a Data marts and Data Interfaces for each module in teh Business process.
• Used teh Checksum Transformation logic for incremental updates (incremental rows and modified rows )
• Implemented teh Package configuration using Parent package variables.
• Designed a Tabular, List and Chart Reports using SSRS Report Designer.
• Deployed all BI Packages in Office SharePoint server (MOSS).
• Extracted teh data from Flat Files and CSV files to SQL Server 2005.
• Extracted teh data from AS400, people soft to SQL Server 2005 using SSIS as ETL tool.
• Transformations of data such as adding derived column, count of records, merging of data TEMPhas been done while pulling data from Source to teh Target.
• Used various transformations like Execute Sql Task, Conditionalsplit, OLEDB Command, Row Count and Lookup while loading teh data into Destination.
• Created various Stored Procedures to validate teh data from Source and update teh records and insert them into a newly created table.
• Developed teh T-SQL Statements while loading teh data into Target Database.
• Involved various levels of testing (Unit, Functional and Integration).

Environment: DTS, SSIS, SSRS(Designer, Report Manager, Report Builder), BIDS, MOSS, Oracle 9i,T-SQL, SQL Server 2005, Dot Net, VB.Net, VSS, Star/Snowflake schema Data Models.

Confidential, Columbus, Ohio

SSIS ETL/ Cognos/ SqlServer 2005 Developer

Responsibilities:

• Source system evaluation, standardizing received data format, understanding business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development, validation and testing of mappings
• Developed teh Logical and Physical Design models as per business requirements using Sybase Power Designer.
• Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions and Fact tables.
• We Migrated teh Data from SQL Server 2000 to SQL Server 2005 Using SSIS.
• Used various Migration Wizards like Import and Export Wizard and Migration Wizard.
• Developed teh logic for incremental updates ( incremental rows and modified rows )
• Used complex queries to pull data from excel as well as other databases to teh table dat TEMPhas been designed schema.
• Developed a Data marts and Data Interfaces for each module in teh Business process.
• Implemented teh Package configuration using XML files.
• Worked on SQL Profiler and Estimated Query plan to optimize teh performance of SQL queries and stored procedures.
• Developed a Tabular Reports using Cognos Report Studio.
• Created an ad-hoc reports using Query Studio.
• Used various transformations like Multicast, Conditional Split, OLEDB Command, Script Component and Lookup while loading teh data into Destination.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Developed teh T-SQL Statements while loading teh data into Target Database

Environment: SSIS, Sybase Power Designer, T-SQL, Asp.Net, SQL Server 2005, VSS, Cognos Framework Manager, Report Net, Report Studio and Query Studio.

Confidential, Detroit, MI

DTS/SSIS/SSRS/ SqlServer Developer

Responsibilities:

• Actively Involved in a Database Design, Coding and Testing.
• Created tables, views and Indexed views in teh database as per teh requirement.
• Developed teh T-SQL Statements while loading teh data into Target Database.
• Involved in metadata modeling, creating a project, creating and publishing teh package.
• Converted teh DTS Packages into SSIS using Migration Wizards.
• Used complex queries to pull data from excel as well as other databases to teh table dat TEMPhas been designed schema
• Actively Involved in Testing and Debugging teh Stored Procedures and T-SQL.
• Extract teh data from SQL Server 2000 to teh SQL Server 2005 using SSIS as ETL tool.
• Implemented teh Package configuration using XML files.
• Successfully Extracted teh Data from Source Using Transformations.
• Used Script Component to generating teh Surrogate key values in Dimentional Tables.
• Involved in query tuning for increasing teh query performance.
• Documentation involving preparation of Mapping Specifications.
• Transformations of data such as adding derived column, sorting of data, merging of data TEMPhas been done while pulling data from SQL Server 2000 to teh SQL Server 2005.
• Used various transformations like Multicast, Slowly Changing Dimensions, Conditional split, OLEDB Command, Script Component and Lookup while loading teh data into Destination.
• Created various Stored Procedures to validate teh data from Source and update teh records and insert them into a newly created table.
• Build test scenarios and test cases (negative / positive) to validate expected outcome

Environment: SSIS, BIDS, DTS, HL7, XML, XSLT, Oracle 9i, Visio, Windows XP, IIS, SQL Server 2000/2005.