SUMMARY

• 8+ years of professional IT experience in ETL Data warehousing, Design, Modeling, Development, Analysis, Implementation, Maintenance and Testing.
• Experience in the areas of Airlines, Insurance and Logistics domains.
• Master in designing and implementing DW&BI and Performance Management solutions through the creation of Enterprise data warehouses (EDW), Data marts, and BI Projects while ensuring high levels of data availability.
• Proven Experience in assessing existing DW Architecture, issues, pain areas and proposing short term and long term architectural solutions and best practices.
• Highly skilled and experienced in working with business users, leadership team, SME, organizational stakeholders to identify and build data warehouse architectures that meet business requirements.
• Extensive hands - on expertise using Informatica 9.x/8.x/7.x/6.x/5.x (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Experience in Informatica Power Exchange. Worked with PWX navigator to create data maps, Register files and used PWX to capture the CDC data from different types of source.
• Strong knowledge in Data Analysis, Data Cleansing, Data Profiling with various tools especially Informatica IDE/ IDQ.
• Managed multiple projects and experienced in different types of projects involving data migration, integration, conversion, data warehouse, Production support and Testing.
• Sound experience in Oracle, MS SQL Server, DB2, flat files, PL/SQL.
• Extensive experience in error handling, debugging and troubleshooting
• Expertise in performance tuning of the mappings and sessions in Informatica and determining the bottlenecks.
• Involved in documentation related to detailed work plans, mapping documents and high-level data models. Worked with Production support team for maintaining the mappings, sessions and workflows.
• Experience in Project estimation, Resource planning, Proposals, SOW preparation, Project Planning
• Knowledge on Data Modeling at both OLTP and OLAP with Relational, Star Schema, Snowflake Schema and Multi Dimensional Modeling.
• Experience in Optimizing Database querying, data manipulation and population using SQL and PL/SQL in Oracle, flat files, DB2 and SQL Server databases.
• Experience in implementing Change Data Capture (CDC), Restart ability, Recovery mechanism at Informatica level.
• Experience with UNIX environment and writing UNIX shell scripts.
• Knowledge of Erwin, EASparx and MS Visio for the Data modeling and designing various other technical specifications.
• Excellent communicator with emphasis on clearly presenting information and developing strong interpersonal relationships.
• Self-motivated individual with strong Technical, Managerial & Analytical skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x, Informatica Power Exchange 9.x, 8.x, Informatica Data Explorer (IDE)

Data Base: Oracle 9i/10g, SQL server 2000, UDB DB2, Netezza

Versioning Tools: Microsoft TFS, Clear case, SubVersion (SVN), Microsoft Virtual Source Safe

Tools: SQL*plus, TOAD, Toad Optimizer, AS400 iSeries, Quest central, WINsql, winSCP, HP Quality Center, Share Point portal, EASparx, MS Visio, Erwin, Autosys, Microsoft Project Planning.

Languages and Others: PL/SQL, Unix Shell scripts

PROFESSIONAL EXPERIENCE

Confidential - Tempe, AZ

Technology Lead

Responsibilities:

• Analyse and Profile the existing PNR version 1 data mart and design the new PNR v2 data mart.
• Work with business to understand the requirements and build the new PNR v2 Data mart functionalities.
• Convert the existing PL/SQL programs into Informatica based ETL codes.
• Tune the codes and Improve the performance of all the existing jobs
• Work on Informatica 9.1 - Power Center, Admin Console, Power Exchange
• Work on Oracle 11i to develop functions and procedures
• Responsible for monitoring the user queries and help them to tune the jobs
• Responsible for interacting with business user for providing information on Data warehouse
• Involve in the Enhancements as part of warehouse improvement.
• Involve in design strategy and documentation
• Work on Oracle optimizer to tune user queries
• Understand the business process, prepare & Reviews of Technical Specifications
• Will be involved in the development of code versioning, release document using TFS
• Support for deployment in different environments like SIT, E2E, UAT and Performance
• Provide weekly status report to the management

Confidential - Phoenix, AZ

Sr ETL Developer and Lead

Responsibilities:

• Understanding the business requirements of the various down steams and converting them into technical design documents for PAS integration.
• Reverse engineered the Exigen system and deigned the architecture of the conversion ODS.
• Analyse and Profile the existing Legacy systems and design the conversion strategy.
• Providing solution & approaches from database as well as application point of view to optimize various processes to improve productivity.
• Lead the team and Coordinate day-to-day activities for the project
• Responsible for interacting with SME’s for obtaining clarifications
• Managing expectations of stakeholders, risks, contingencies and dependencies
• Used Informatica Powercenter/Power Exchange to extract/transform and load into different systems involving like Oracle, Sql Server, AS400, MQ, XML, Flat files.
• Used Informatica IDE to profile the source system data for conversion process.
• Worked in Informatica Power Exchange to read data and write data into different source systems like AS400, Mainframes.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin
• Designed the Informatica Restart ability, Job control, batch logging mechanisms to cover the rainy day scenarios.
• Managing the development of the ETL and reviewing the results till the production load.
• Reviewing codes and documents prepared by team members.
• Prepare the release notes and deployment document for code migration.
• Support the smoke testing and code verification after deployment and Coordinate with the testing team for System testing.
• Preparing status reports and collecting metrics. And drive the weekly Project Status Review meeting.
• Training the team with process and timelines, PMO Activities, Timesheet. Project management is done through Cognizant’s proprietary tool Cognizant 2.0.
• Face the Audit and submitting the metrics on time.
• Imparting domain and technical knowledge to the new entrants and also fellow team members.

Environment: Informatica PowerCenter 8.6.1, Informatica IDE, Oracle 10g, UNIX, SVN, Clear case

Confidential - Phoenix, AZ

Sr ETL Developer

Responsibilities:

• Shouldering overall responsibilities to understand Client Processes and to work efficiently to meet targets and deliver solutions in accordance with quality control standards and business practices and procedures.
• Involved in the development of High Level Design and design document
• Responsible for the resolving all Analysis issues raised by the team
• Primary contact person during the System Integration Testing, UAT and Migration phases
• Worked on Informatica 8.6 - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.
• Design and Development of Unix shell Scripts for Autosys scheduling
• Used command line mode to embed pmcmd commands in to shell scripts and used pmcmd, pmrep commands in Interactive mode to access repository and workflows.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Analyzed business expert undocumented knowledge and documented into business logic and table structures by designing and drawing Business Process Models, Conceptual Data Models, Logical Data Models and Physical Data Models.
• Analyzed and identified several data quality issues from the source systems and designed scalable exception handling process and Data Quality Confirmation methods that meets the business requirements and DW standards.
• Understand the business process, prepare & Reviews of Technical Specifications
• Worked with Offshore for enhancing application needs and responsible for reviewing the offshore deliverables
• Involved in the development of code versioning, release document management.
• Face the Audit and submitting the metrics on time.
• Support for deployment in different environments like SIT, E2E, UAT and Performance

Environment: Informatica PowerCenter 8.6.1/8.1.1 , Power Exchange, Oracle 10g, AS400, UNIX Shell Scripts, Clear case

Confidential - Phoenix, AZ

Senior ETL Developer

Responsibilities:

• Coordinate of day-to-day activities for the project and Interact with offshore team for project status and issues.
• Assessed the ETL performance issues and presented the long term solutions using Informatica (Cache, Session Partitioning, Pushdown optimization, best practices and coding standards) and DB2 (Parallel Degree, Indexing Strategy (EVI and BRI) and Reorganization) features and concepts.
• Provide level 1 support for the production jobs and monitor them. Ensure that the ETL jobs get completed as per the SLA.
• Giving Knowledge transition to team on issues, bug fix and enhancements.
• Involved in Change Request requirement analysis, impact analysis and solution documentation.
• Prepared the Knowledge Transition Documents and ETL reference documents, artifacts.
• Change Request requirement analysis and impact analysis.
• Developed mappings to extract data from Mainframes, Oracle, SQL Server and load into DataMart using the PowerCenter as part of CR’s and Enhancements.
• Implemented various Performance Tuning techniques at Informatica, Design and Data base level.
• Enhanced and stabilized many applications. Generated automatic dashboard using Infa repo DB which is used by offshore team for monitoring the jobs.
• Performed Informatica admin activities using Informatica Admin console
• Prepare status reports and collect metrics. Training the team with process and timelines.
• Standardized the ETL codes across applications and implemented various processes eg: Restart mechanisms, Audit logging, Error logging.

Environment: Informatica PowerCenter 8.1.1, Informatica power exchange, Informatica IDQ, SQL Server 2000, Oracle 10g, Clear case

Confidential, Minneapolis, MN

Senior ETL Developer

Responsibilities:

• Involved in Requirements Gathering
• High Level Design document, Source to Target mapping document and Project Planning document development
• Review the low level design documents and ETL Maps.
• Development of the Informatica Mappings as per the requirements. Used SaleForce API’s.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Collaborated with Informatica Admin in process of Informatica Upgradation from PowerCenter 7.1 to PowerCenter 8.1.
• Designed effective solutions for data cleansing, exceptions handling and normalizing the data.
• Identified sources, targets, mappings and sessions and tuned them to improve performance
• Performed System Testing and development integration testing.
• Tracked the defects in Mercury quality centre and triaged them to closure.

Environment: Informatica PowerCenter 8.1/7.1, UDB DB2,Qwest Central

Confidential, Madison, WI

ETL Developer

Responsibilities:

• Worked with the business users to get the business rule modifications in development and testing phases and analyzed claims data through rigorous evaluation methodology.
• Analyzing the Business requirements and work in Data Modeling.
• Preparation of the following various technical and functional documents Requirement Specification document, High Level Analysis and Approach document, High Level Design Document, System test plan and test procedure document.
• Validated the data cleansing rules.
• Review the low level design documents and ETL Maps.
• Development of the Informatica Mappings as per the requirements and built the snapshots and warehouse.
• Leaded and coordinated the offshore team and managed the team to meet the deliverables on time.
• Interaction with Client to get the specifications and analyze and involve in design.
• Developed and implemented Error Handling Strategies.

Environment: Informatica PowerCenter 7.1, SQL Server 2005, WINsql

Confidential, Hartford, CT

ETL Developer and Analyst

Responsibilities:

• Work on analysis of the Business requirements from the client, and putting them down in technical specifications.
• Creation of several Gap Analysis/ benchmarking /migration/ Design documents.
• Development of the Informatica Mappings as per the requirements.
• Performance tuning of the Enterprise Data Mart loading process.
• Involved in writing stored procedures and shell scripts for automating the execution of jobs in pre and post sessions to modify parameter files, prepare data sources
• Created and used reusable mapplets and worklets to reduce the redundancy.
• Leaded the migration testing of data from SQL server 2000 to SQL Server 2003.
• Creating and maintaining project plans Microsoft project Plan .
• Development of Test Planning and Test Strategy.
• Building new attributes and entities.
• Performed data consistency testing.

Environment: Informatica 7.1, SQL Server 2000, 2003, UNIX

Confidential

ETL Developer

Responsibilities:

• Work on analysis of the Business requirements from the client, and putting them down in technical specifications.
• Creation of several Gap Analysis/ benchmarking /migration/ Design documents.
• Development of the Informatica Mappings as per the requirements.
• Performance tuning of the Enterprise Data Mart loading process.
• Involved in writing stored procedures and shell scripts for automating the execution of jobs in pre and post sessions to modify parameter files, prepare data sources
• Created and used reusable mapplets and worklets to reduce the redundancy.
• Leaded the migration testing of data from SQL server 2000 to SQL Server 2003.
• Creating and maintaining project plans Microsoft project Plan .
• Development of Test Planning and Test Strategy.
• Building new attributes and entities.
• Performed data consistency testing.

Environment: Informatica 7.1, SQL Server 2000, 2003, UNIX

Confidential

Database Developer

Responsibilities:

• Developed and maintained the database using sql server 2000.
• Involved in creating database objects and migration of ddl’s across various environments.
• Has extensively involved in writing SQL’s and stored procedures.
• Analysis of the Business requirements from the client, and putting them down in technical specifications.
• Creation of Design documents.
• Developed new features and enhanced the portal.
• Analysis and Resolving open issues.

Environment: SQL Server 2000