Qualifications Summary:

• 10 years of comprehensive in-depth experience in the Information Technology IT industry with specialization and expertise in Data Warehousing and Business Intelligence area. Accomplished B.I. Architect, ETL Lead, Data Modeler and Designer.
• Perform overall project management, analysis, architecture, design, development and implementation of data warehousing / business intelligence initiatives.
• Work on data warehousing projects from inception to implementation and deliver high quality solutions in a timely manner meeting and exceeding the business requirements. This involves working with the top management and executives, business sponsors and IT department.
• Leading a team of ETL developers in implementing new projects and optimizing existing ETL processes for EDW, Data marts and Business Intelligence projects.
• Analyze new data source, perform requirement gathering, ETL design, and code review to ensure quality development with timely delivery.
• Manage and administer systems performance including on-going optimization and tuning of production environment. Identify performance bottle-neck processes and modify them to get best performance by implementing database and ETL best practices.
• Manage Development of complex ETL processes using best practice and standards, and implement various process controls.
• Lead data warehouse initiative projects in On-shore/off-shore model.
• 8 years of Data Modeling experience using Dimensional Data modeling, Star Join Schema/Snowflake modeling, FACT Dimensions tables, Physical logical data modeling, All Fusion Erwin Data Modeler8.x/7.x/4.1.2/ 3.x.
• 10 years of Expertise in Extraction, Transformation, Loading ETL data from various sources into Data Warehouses and Data Marts using Informatica Power Center 9.0.1/8.x/7.x Repository Manager, Designer, Server Manager, Workflow Manager, Workflow Monitor and Business Object Data Services 14.x.
• 8 years of experience using PL/SQL, Shell Scripting, SQL Plus, MS SQL Server 2000/2005/2008, Sun Solaris 2.6/2.5.1, AIX 5.2, HP-UX, Windows 2000/2003/Vista/win 7.

Technical Skill set:

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Business Object Data Services 14.x,

eFusion.

Reporting Tools: SQL Server Analysis Services 2005/2008, Business Objects 6.5/XI R2 Designer, Supervisor, BO , WebI

Database: Oracle 11g/10g/9i, SQL Server 2000/2005/2008, MS Access

Languages: Java, C, C , C , SQL, PL/SQL

GUI/Tools: TOAD, SQL Navigator, SQL Developer, Aqua Studio

Operating Systems: Windows 95/98/2000/2003/2005 Server/XP/NT4.0, UNIX Sun and HP

Work Experience Most current First

Confidential

Role: ETL Lead/Supervisor

Responsibilities:

• Leading a team of ETL developers in implementing new projects and optimizing existing ETL processes for EDW, Data marts and Business Intelligence projects.
• Analyze new data source and gather requirement, perform ETL design and code review to ensure quality development with timely delivery.
• Manage and administer systems performance including on-going optimization and tuning of production environment. Identify performance bottle-neck processes and modify them to get best performance by implementing database and ETL best practices.
• Manage Development of complex ETL processes using best practice and standards, and implementing needed process controls.
• Lead data warehouse initiative projects in On-shore/off-shore model.
• Provide on-call production support

Confidential

Role: Lead ETL Developer

Responsibilities:

• Led the Conversion of Wells Fargo Auto Finance loans into Wells Fargo Dealer Services Data Warehouse Data analysis, source to target mapping, identified data gaps, validated transformation logic, developed re-usable objects, performed unit and integration testing, reviewed all the mappings to ensure best practices, provided weekly updates to the PMO office on the project.
• Gathered requirements, performed data analysis of various source data, designed and developed Informatica mappings, sessions, and workflows.
• Modified mappings to improve data quality and workflow performance.
• Developed and maintained shell scripts, Informatica mappings, sessions and workflows to process historical data from Jan 2000 through Dec. 2009 from data warehouse joining with other sources for economy performance related data and prepared all data into one flat file and loaded them into SAS data set using Informatica.
• Validated SAS dataset using SAS Enterprise Guide and reported any data discrepancies to team and worked with business users to implement the optimal solution using Informatica and SAS.
• Mentored Jr. Developers and performed code review.

Confidential

Role: Sr. Programmer Analyst

Responsibilities:

• Provided on call Production Support for all Informatica jobs.
• Performed data analysis of various sources, designed and developed ETL, Star Schema dimensional modeling, slowly changing dimensions, fact tables, to load large volume of data into data warehousing on oracle 10g to support Business Intelligence using Informatica 8.1.1.
• Developed and maintained Shell/Pearl script to perform pre-load audit, file watcher and post load audit processes.
• Performed data analysis, created source to target mapping documents, testing scripts, PL/SQL store procedures to support unit testing and integration testing and reported any data anomalies to business analyst.
• Improved workflow performance using various data warehouse techniques: SQL tuning, mapping performance tuning, PL/SQL, parallel data load into fact tables using Informatica session partitioning, table partitioning, and index disabling/enabling.
• Provided guidance to team members and reviewed Informatica mappings and pl/sql stored procedures with team members.
• Designed, developed, implemented and maintained PL/SQL, mappings, mapplets, worklets, Sessions and workflows to support Loan Performance project integration of origination and servicing data.
• Designed, developed and maintained complex mappings to implement Net Credit Loss project to extract data from transactional sources and apply different transformation such as Router, Aggregate, Join, Look up, reusable mapplets, and transformations to calculate static pool measures like estimated loss, current loss, MTD Recoveries.
• Designed and developed complex Informatica mapping, mapplets, transformations, sessions, workflows and PL/SQL store procedures to implement Collector Scorecard and Call Measure project to deliver collectors' performance measures for different delinquent buckets: 1- 45, 46 90, 91 119, 120 .
• Scheduled Informatica Workflows and other processes using AutoSys scheduler
• Responsible to setup the QA environment and migration procedure for production push.

Confidential

Role: Sr. Informatica Developer

Responsibilities:

• Provided on call Production Support for all Loan Servicing Workflows.
• Designed project ETL logic, developed and implemented mappings, mapplets, worklets, Sessions and workflows.
• Architected the ETL staging area and the integration of all the mappings in a workflow.
• Modified mappings to improved workflow performance.
• Performed data analysis of the source data coming from different transactional systems, and flat files and identified the common business rules and developed the Mapplets and Transformations, which can be reused in the project.
• Designed and developed complex mappings to extract the data using Router, Aggregate, Join, Look up, Update Strategy and reusable mapplets transformations.
• Designed and developed full scale reporting solutions using SQL Analysis services 2005 and SSRS 2005: OLAP/Dimensional modeling, complete ETL process to load data into data mart, scheduled OLAP cubes to re-build daily and provided production support.
• Involved in automation of processes using Control M scheduler.
• Designed and developed Re-load workflow for EPRO system to re-load data for a particular transaction date from an Auto dialer system for all the summary tables.
• Participated in the planning and execution of integration test, system test, and user acceptance test activities, including developing and documenting test plans.
• Responsible to setup the QA environment and migration procedure for production push.
• Participated in planning and setting of Business Objects environments: DEV, CERT, and PROD and Configured Security and Scheduler.
• Developed macros to re-name, archive, and publish reports to different categories.
• Provided Business Object Application support for Security configuration, Broadcast Agent, Scheduler and Repository.
• Provided support to report writers, implemented Active directory security configuration, created and maintained Universe and categories.
• Design and implemented Business Object health check procedure.