Summary:

• 4.5 years of IT experience in Data Design and Development on Microsoft SQL Server 2008R2/2008/2005, T-SQL, Performance Tuning,SSIS, SSRS, Cognos and Data-warehousing for projects in Healthcare domain.
• Employed with Infosys Limited as Technology Analyst. Currently working at client location in Long Beach ,California USA on H1B work permit as ETL development lead.
• Experience with all phases of software development life cycle SDLC and project methodologies
• Primary skill in developing complex packages through Microsoft Business Intelligence tool SSIS in MS SQL Server 2008 and Secondary skill in reporting through SSRS and Cognos
• Knowledge of Informatica sessions and workflows.
• Experience with T-SQL in constructing and developing Triggers, Tables, implementing stored Procedures, Functions, Views
• Experience in Performance Tuning and Query Optimization
• Knowledge of Normalization and Relational Database Management Systems.
• Experienced in using ETL tools in SSIS MS SQL 2008,MS SQL 2005
• Created SSIS Packages using Various Transformation like Lookup, dynamic lookup,Script task in VB Script,Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports
• Package logging, data auditing and error handling in SSIS.
• Experience in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Carts and Graphs using Cognos or SSRS in Business intelligence development studio BIDS
• Experience in fine tuning the reports.
• Experience with logical and physical data modeling and database design using Erwin
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments
• At client location, having extensive experience in gathering Client requirement, understanding business and leading offshore team.

Skillset:

MS SQL Server 2008/2005, T-SQL,SQL Server 2005 Management Studio,Business Intelligence SSIS,SSRS, Cognos 8.3 Report studio, Analysis studio, Query studio, Event Studio,Framework Manager , Erwin

Projects Summary:

Confidential

Onsite ETL Development Lead

Responsibilities:

• Understanding the client requirement both functional and non-functional, and providing best approach for its implementation as per their business rules.
• Providing technical design for the client requirements.
• Leading offshore team, providing them technical solutions and understanding of business.
• Involved in all phases of System Development Life Cycle SDLC
• Developed and scheduled the SSIS packages to perform the daily ETL tasks
• Performed Full load Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS
• Creating reusable packages for package logging ,data auditing and error handling.
• Performed data cleaning using SSIS, and also deleted/updated bad data in the existing data according to the business requirement
• Configured Connection Manager files for SSIS packages to dynamically execute on Production server
• Created reusable tasks through SQL Script task in VB Script.
• Configured SQL mail agent for sending automatic mails
• Design, development and deployment of new mappings, workflows in SSIS.
• Development and documentation of new packages in SSIS.
• Prepare, execute and document unit test cases.
• Complete management of projects and analysis of the underlying phenomenon.

Confidential

Onsite ETL Developer and Business Analyst

Responsibilities:

The role requires

• Process consulting and application development in data warehousing technologies SSIS and SSMS.
• Understanding of Informatica sessions and work flows and implementing same functionality in SSIS .
• Involved in all phases of System Development Life Cycle SDLC
• Developed and scheduled the SSIS packages to perform the daily ETL tasks
• Performed Full load Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS
• Performed data cleaning using SSIS, and also deleted/updated bad data in the existing data according to the business requirement
• Configured Connection Manager files for SSIS packages to dynamically execute on Production server
• Created reusable tasks through SQL Script task in VB Script.
• Configured SQL mail agent for sending automatic mails
• Design, development and deployment of new mappings, workflows in SSIS.
• Development and documentation of new packages in SSIS.
• Prepare, execute and document unit test cases.

Confidential

Offshore ETL Developer Chandigarh

Responsibilities:

The role requires-

• Analysis of requirements gathered from the client.
• Design and develop ETL solutions through SSIS including customized SQL queries around the client's specifications and also suggest better solutions.
• Performed data cleaning using SSIS, and also deleted/updated bad data in the existing data according to the business requirement
• Configured Connection Manager files for SSIS packages to dynamically execute on Production server
• Configured SQL mail agent for sending automatic mails
• Preparing and executing unit test cases.
• Complete documentation of the process, ETL deliverables and test cases.

Confidential

Offshore Report Developer Chandigarh

Responsibilities:

• Involved in requirement gathering and analysis.
• Performed metadata modeling, creating reports and event scheduling.
• Creating reports in Cognos which included Drill through, User prompts and other complex functionalities in Cognos.
• Creating metadata model for reporting purposes in Universe designer.
• Provided adhoc customer support.
• Optimization of queries. Performed unit testing , Data integrity testing on the reports so developed
• Involved in preparing Functional design documents, Technical design documents, test cases and validation documents.

Confidential

Trainee Engineer

• Trained in Business Intelligence BI , majorly comprising of the following technologies -
• Microsoft Business Intelligence SSIS,SSRS,SSAS
• Data Modeling Concepts
• Software Development Life cycle and Data Warehousing
• Concepts of ETL Extract , Transform ,Load
• Oracle and PL/SQL
• SQL server