Summary

• More than 12 years of experience in Integration Architecturing, ETL Development, Data warehousing, Database Administration and Application Development.
• Have very good experience in Managing offshore and onsite teams with 100 customer satisfaction delivery in Data integration and ETL Projects for MNCs.
• Extensive experience in handing Multivendor projects delivery and technical solutions.
• Worked extensively in ETL Development using Informatica PowerExchange, Informatica Power Center 6.x, 7.x, 8.x and Informatica Data Explorer.
• Very strong expertise in large Market Data feeds and Heterogeneous Source systems like Teradata, Oracle, MS SQL server, IBM DB2, XML, COBOL files and Flat Files.
• Experience on Master Data Consolidation, Master Data Harmonization, Enterprise Application Integration EAI , Enterprise Information Integration EII , Customer Data integration CDI and Global Data Synchronization GDS , Change Data Capture CDC ,
• Experience in Data modeling, Star and snowflake schemas, Dimensions and Fact Tables.
• Strong performance tuning skills in tuning ETL Session, SQL Queries and stored procedures.
• Experience in writing Stored Procedures in PL/SQL, T-SQL, SQL Server and queries.
• Expertise in BI Development Studio including Analysis, Integration and Reporting Services.
• Gathered business requirements, established functional specifications/ ETL mapping documents, translated them to design specifications. Generating test plans and cases for unit and system testing based on requirements.
• Excellent knowledge on Web and Windows application development technologies like VB, ASP, VB.net, ASP.net, C , ADO.net,
• Excellent Analytical and problem solving skills, systematic approach to programming tasks and good interpersonal skills.
• Involved in Installation upgrade of Informatica Power center from version 7.x to 8.x.

PROFESSIONAL SKILLS:

• Operating Systems : MS-DOS, WIN-95 and so on, UNIX and Linux
• RDBMS : Dbase, MS-Access, Sybase, Oracle, MS-SQL Server. Teradata,DB2
• ETL Tools : Informatica Power Center Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor 8.x/7.x/6.x Informatica Power Mart Informatica Power Exchange, Informatica Power Connect , Data Stage 8.x.
• Development Languages : T-SQL, SQL, PL/SQL, VB, ASP, VB.net, ASP.net, C .
• Web Technologies : HTML, DHTML, ASP, J Scripting, Java Script, VBScript.
• Knowledge : COM, DCOM, XML, ActiveX, ADO, Crystal Reports, BO Reports, Windows Services, Web Services, BO reports, SSIS, SSRS, SSAS.
• OLAP Tools : Business Objects, Crystal Reports.

PROFESSIONAL EXPERIENCE

Confidential

Environment: Linux, Unix, Informatica 9.1, TERADATA 13.0, Control M scheduling tool.

Responsibilities:

• Requirement Analysis and Estimations
• Project Planning and Deliverables Milestone commitment to business.
• Adhere to Organizational best practices and bring new best practices to minimize the cost to Program.
• Monitoring Onsite and Offshore deliverables and making sure align to the project plan and Mile stones.
• Risks and Impact analysis and mitigation plans.
• Architectural and design solutions and bringing best practices. Making sure the technical solutions meeting to the organizations' best practices.
• Every day business reviews and project progress tracking.
• Technical Design documents review and delivery.
• Offshore and onsite development and testing deliverables progress tracking.
• User Acceptance testing co-ordination with business and technical explanation to business.
• Production delivery and business sign-off

Confidential

Environment: Linux, Windows, Data Stage 8.1, Windows XP, SQL Server 2005, TERADATA V2R5, DB2. SFTP, Uni-center Scheduling utility.

Responsibilities:

• Estimation, Requirement Analysis, Integration Design and Technical Design of mapping document.
• Designed and created logical physical data models to support strategic business decisions.
• Setting up Metadata driven utility design for Data Extraction, Derive, Transformation, Loading and Validation processes.
• Implemented Industry best practices in Integration Architecture.
• Set up batches and sessions to schedule the loads at required frequency.
• Performance tuning to ensure optimal session performance.

Confidential

Environment: Linux, UNIX, INFORMATICA Power Center 7.3.1, Data Stage, Windows XP, SQL Server 2005, Oracle 9i, TERADATA V2R5, DB2.

Responsibilities:

• Estimation, Requirement Analysis and Design of mapping document and Planning for Informatica ETL and DataStage.
• Setting up Metadata driven utility design for Data Extraction, Derive, Transformation, Loading and Validation processes using Informatica 7.1.
• Designed and created logical physical data models to support strategic business decisions.
• Used transformations like Aggregators, lookups, Filters Sequence and many more as per business requirement.
• Developed complex Pl/Sql procedures and packages as part of Transformation and data cleansing.
• Developed UNIX shell scripts to control the process flow for Informatica workflows to handle high volume data.
• Set up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Extensively used Informatica debugger to validate Mappings and to gain troubleshooting information about data and error conditions.
• Performance tuning to ensure optimal session performance.

Confidential

Environment: INFORMATICA 7.1.3, 8.1.1 8.5, Oracle Database 10g, SYBASE, SQL Server 2005, BO reports, TOAD, Windows-XP.

Responsibilities

• Requirement Analysis and Functional and Technical documents design for all integrations.
• Designed and developed ETL Technical Design Specification documents.
• Logical and physical database Design Data Modeling
• Designed database with best performance consideration
• Created shortcuts to reuse objects across folders without creating multiple objects in the repository and automatically inherit changes made to the source.
• Developed and scheduled various pre- and post-sessions commands and workflows for all mappings to load data from source files to target tables.
• Created mappings to dynamically generate parameter files.
• Setting up Metadata driven utility design for Data Extraction, Derive, Transformation, Loading and Validation processes using Informatica 7.1 and 8.2.
• Used transformations like Aggregators, lookups, Filters Sequence and many more as per business requirement.
• Developed complex Pl/SQL procedures and packages as part of Transformation and data cleansing.
• Developed UNIX shell scripts to control the process flow for Informatica workflows to handle high volume data.
• Set up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.

Confidential

Environment: INFORMATICA 7.3.1, SQL Server 2005, BO reports, Oracle 9i, Windows-XP, Business Objects.

Contribution

• Based on the requirements created Functional design documents and Technical design specification documents for ETL Process.
• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Created complex mappings using Aggregator, Expression, Joiner transformations.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load intervals.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Designed and implemented mappings using SCD and CDC methodologies.
• Designed and developed process to handle high volumes of data and large volumes of data loading in a given load window.
• Extensively involved in migration of ETL environment, Informatica, Database objects.
• Involved in splitting of Enterprise data warehouse environment and Informatica environment in to 3 of each company.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment

Confidential

Environments: UNIX, ORACLE 9i, INFORMATICA 6.1, Windows-XP, SQL Server 2005.

Contribution:

• Extraction, Transformation and Load was performed using Informatica Powermart to build the Oracle Data ware house using flat files.
• Accomplished automated data extraction from various RDBMS via scripts, ETL processing using Informatica and loading into Oracle Data warehouse.
• Created complex joiners, transformations of all types as needed to smoothly pass data through ETL maps.
• Design and development of PL/SQL Stored Procedures using dynamic SQL for checking existence of partitions and creating them with appropriate values in the case of their absence.
• Setting of Error Logic for streamlining and automating the data loads for cleansing and trapping incorrect data on staging servers and then loading it to the Oracle 8 data warehouse.
• Testing for the Data integrity and Consistency.
• Documenting the issues related to cleaning of the Data.

Confidential

• Changepoint Changepoint is a third party application that can capture the Microsoft Consulting Services Activities. The Changepoint is developed by the Chagepoint Corporation, which can easily integrate with the Microsoft Applications like Siebel, MS-Expanses, MS-Sap, MS-Sales and EPV.
• Changepoint is application which MSC user can create Engagement, can create Project for the created Engagement, and can create Tasks for the created Project. MCS user can map the Resource to the Task. According to the Role of the Resource the billing can be made, The same billing can be called as Invoice.
• MS-Expanses is a Integrated application can use only to submit the expenses, which are made by the MSC users while, progress the Engagements and Projects. The Revenue will be posted to the MS-SAP.
• MS-SAP is a integrated application can process the invoice and kept into the SAP system for accounting.
• MS-Sales is a Integrated application can calculate the Revenue of the each resource in terms of the Engagements and Projects. The Revenue will be posted to the MS-SAP.

Environment : Windows XP, Siebel 7.5, SQL Server 2000, SQL Server 2005, SSIS, SSRS.

Contribution :

• Functional Analysis and Database design using normalization Techniques.
• Logical and physical database Design Data Modeling
• Designed database with best performance consideration
• Database design changes for functional enhancements.
• Created reusable DTS and SSIS packages for all integrations for up and down stream applications.
• Performance and Tuning of the system by doing the Query/Stored procedures optimization.
• Extensively used T-SQL for creating stored procedures, tables, views, triggers and user defined function for Data integration
• Creating triggers, indexes, constraints for maintaining the Referential Integrity.
• Have worked on SSIS and SSRS for reporting and Data integration.
• Analyzing the Production issues and fixing the data using SQL scripts.
• Functional Analysis and Database Design
• Managing Test servers for running the jobs.

Confidential

Environment : Windows 2000, ASP, VB, SQL Server 2000, Crystal reports.

e-Health line system is a Web based application for a group of hospitals that manages the entire services and transactions of the hospitals. It tracks the 3 different users like Patients, Doctors, and Hospital Staff. The patient can view the entire doctor's Schedule, Each doctor profile and his case rate. The hospital staff can view all the patients who are online they can give proper guidance according to the Doctor's instructions. Doctor's can view all the patients' profile and case study prescription history. It is integrating with the payment module where the patient can pay the fee to doctor tip to the hospital staff online. Doctors can view their income in different criteria.

Environment: Windows 2000, HTML, DHTML, JavaScript, ASP, Oracle 8i, and Crystal Reports.