Summary

• 10 years of IT experience in the Data Warehouse, Requirement gathering, Gap Analysis, Architecture, Development, Implementation of various applications in client/server environment.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Strong experience in Data Warehousing and ETL using Informatica Power Center 9.1.
• Had experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Had knowledge on Kimball/Inmon methodologies.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center v 5.x/6.x/7.x/8.x.
• Experience in testing the Business Intelligence applications developed in Qlikview.
• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
• Experience in database programming in PL/SQL Stored Procedures, Triggers and Packages .
• Well versed in UNIX shell scripting.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data used pager for notifying the alerts after successful completion.
• Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.
• Involved validation for technical requirements and architecture quality attributes
• Involved in Performance Tuning, Backup and Recovery Process, Production Support on various platforms
• Designed data model, analyzed data for online transactional processing OLTP and Online Analytical Processing OLAP systems.
• Worked on production support to handle project issues P1, P2 and P3.
• Experienced in User Acceptance Testing UAT , Unit testing, System testing, Integration testing, Development and Production
• Solutions architecture experience with complex enterprise applications including Data warehousing /BI, ERP implementations

Technical Skills

Data Warehousing:

OLAP Tools OBI 11G

ETL Tools Informatica Power Center 8.x / 7.x

Data Modeling Erwin

Others TOAD, SQL Developer, Quality Center, Banking, Retail and Financial Domain

Group approved Package True Comp 5.1.4

Database Skills:

Relational Databases Oracle 7.x/8.0/10, SQL Server

Procedural language PL/SQL

Languages:

Programming Languages C, C , JAVA

Systems:

Operating Systems Windows XP/NT, Windows 2000, UNIX, Windows 2000 Professional

Professional Experience

Confidential

Informatica Technical Lead/Architect

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 8.6 for extraction, transformation and load ETL of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices

Environment: Informatica9.1, Oracle APPS R12 12.1.3 , Oracle9i/10Gdatabase, SQL Developer, PL/SQL, Forms 6i, Reports 6i

Confidential

Informatica Technical Lead

Responsibilities:

• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy.
• Stored reformatted data from relational, flat file, XML files using Informatica ETL .
• Worked on Dimensional modeling to design and develop STAR schemas using ER-win 4.0, Identifying Fact and Dimension Tables.
• Created various batch Scripts for scheduling various data cleansing scripts and loading process.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Created post-session and pre-session shell scripts and mail-notifications
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Created Several Stored Procedures to update several tables and insert audit tables as part of the process.
• Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with backend database using PL/SQL.
• Written Unix Shell Scripts for getting data from various source systems to Data Warehouse.
• Performance tuning by optimizing the sources targets mappings and sessions.
• Tested mappings and sessions using various test cases in the test plans

Environment: Informatica 9.1, Oracle Applications R12 12.1.3 , Oracle 9i/10G database, SQL Developer

Confidential

Senior Informatica Lead/Consultant

Responsibilities:

• Accountable for completion of assigned Informatica mappings including transformations ,sessions, Workflows and functional designs as per the allocated budget
• Ensure the sign off process is followed, ensuring appropriate project, business conversion input has been incorporated, and identifying and escalating issues that may impact the sign off schedule
• Keep Project Lead informed of status and progress of work and raise any issues and risks impacting ability to complete tasks and deliverables by the required time
• Develop a deep functional knowledge of assigned tasks and understanding of PFS, PCS processes.
• Doing Optimization in Extensively at Informatica, Database side. for improving the Performance
• Adhere to templates and best practices relevant to the development work stream
• Data loading for both PFS and PCS and sending the reports.
• Creating, running Workflows and capturing results.

Environment: Informatica 8.6, Siebel CRM, Windows XP, SQL

Confidential

Consultant

Responsibilities:

• Member of warehouse design team assisted in creating fact and dimension tables based on specifications provided by managers.
• Load operational data from Oracle, SQL Server, flat files, Excel Worksheets into various data marts like PMS and DEA.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Implemented effective date range mapping Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.
• Design complex mappings involving constraint based loading, target load order.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets that provides reusability in mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.

Environment: Informatica Power Center 8.6, Oracle, ,OBI, Windows 2000, SQL Server 2000, Microsoft Excel, SQL Plus

Confidential

Responsibilities:

• Working on the Data Analyzer, Data Quality and data profiler tool for handling the business logic and exception logic from the inbound feeds and also the outbound feeds.
• Architected data flow for efficiency.
• Created / revised data models
• Created and maintained mappings as needed.
• Tested application and implemented into production.
• Data Warehouse and Data Mart design and data modeling.
• Business analysis and data model design for new tables related to ETL.
• I have involved in Design phase.
• Prepared the Informatica functional design and mapping Design.
• Developed the mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Joiner , Sequence Generator, stored procedure ,Update Strategy and Normalized
• Prepare the test cases and implement the test cases.
• Involved in doing review, testing and preparing the Amended documents

Environment: Informatica 6.2, Oracle 8i, TOAD, Windows NT and UNIX

Confidential

Responsibilities:

• Creating Technical specification document for full and incremental mappings
• Creating incremental mappings for Global Payroll and House hold tables
• Creating full and incremental mappings for audit tables
• Creating workflows, sessions for Global payroll and audit tables
• Creating the test results document
• Migrating mappings and sessions from Development to System and Functional environs
• Interacting with Hong Kong IT users to resolve the data issues
• Debugging and fixing the failed mappings and sessions

Environment: Informatica 6.1, Oracle 9i, Windows 2000, SQL