SUMMARY

• Over 15 years of IT industry experience
• 10+ Years of hands on experience in developing ETL process using Informatica -
• Strong working experience in building and managing various data warehousing/data marts using Informatica products such as PowerCenter, PowerAnalyzer,
• Strong working experience in Large Data warehouse environments
• Strong technical hands on experience in Oracle 10g/11g databases
• Providing ETL solutions for various business units as per the requirements
• Excellent working knowledge with BI reporting tools using Business Objects, Cognos
• Excellent analytical, problem solving, communication and interpersonal skills, with an ability to interact with individuals at all levels.
• Participated in full Software Development Life Cycle (SDLC) of the data warehousing project; project planning, business requirement analysis, data analysis, logical and physical database design, setting up the warehouse physical schema and architecture, developing reports, security and deploying to end users.
• Strong logic and analytical skills and Solid business acumen.
• Extensive work exposure in Unix Korn Shell scripting
• Effective troubleshooting skills.
• Ability to manage time spent on multiple projects to meet deadlines.
• Proficient in Oracle PL/SQL programming, writing Stored Procedures, Functions, Database Triggers etc

TECHNICAL SKILLS

Informatica: PowerCenter 9.5/8.6 PowerConnect tools for SAP, Mainframes, PowerAnalyzer, Metadata Exchange for Data models.

RDBMS: ORACLE 10g/11g, DB2, SQL SERVER 2000/7.0/6.5 , Sybase

Business Intelligence: Business Objects, Cognos

Other Tools/Methodologies: Data modeling, Star Schema, Snowflake Schema

O/S: UNIX (HPUX, IBM AIX, Sun Solaris), Windows 2003/XP/2000/NT, Scripting

Scheduling Tool: TWS, Autosys, Cron

Project Management Experience: Involved in working with teams at onsite/offshore model

PROFESSIONAL EXPERIENCE

Confidential, Irvine CA

ETL Architect

Responsibilities:

• Re-design an existing DWH environment
• Design reusable ETL components to be used by the development team
• Optimize/ Performance Tune the ETL processes developed in Informatica /SQL
• Design Autosys Job for nightly batch
• Sprint planning (work with the product owner in creating stories for each sprint)
• Develop ETL process for external integrations.
• Design the CRM Integrations for loading the Customer Information into the CRM system from various vendors.
• Support the OBIEE environment and design the physical and logical models for Siebel Analytics.
• Design/Develop Data Marts and ETL process for the Hyundai Motors Group
• Work with Business Analysts to understand business requirements and convert tan to technical specs and work on developing the ETL process
• Design ETL processes for the MDM implementation at Hyundai Capital
• Infrastructure redesign for ETL related environments
• Develop integration between legacy systems and Siebel CRM system

Environment: Informatica 9.5.1/8.6, Oracle 9i/10g, Linux Red Hat,Solaris, Windows batch script, Unix Shell Scripts, OBIEE, DAC

Confidential, Irvine CA

DWH ETL Consultant

Responsibilities:

• Work with Business Analysts to understand business requirements and convert tan to technical specs and work on developing the ETL process
• Part of Data modeling team, which design the new models based on the new requirements. (Exposure to Snowflake and star schema models)
• Used Autosys for scheduling jobs
• Design an Proceses for data Integration/Migration. dis is being done as one of the projects is moving from Siebel to SalesForce.Com
• Work in SCRUM/AGILE environment for the salesforce.com project
• Work with existing Siebel CRM team and understand the functionality, design and develop ETL process (for one time migrations and ongoing integrations) from/into SalesForce.com from various applications.
• Work with salesforce data loader utility
• Design the ETL processes for loading the Siebel base tables from 2 legacy source systems
• Configure the OBIEE environment and design the physical and logical models for Siebel Analytics.
• Trouble shoot the analytics reports
• Work with Business Analysts to understand business requirements and convert tan to technical specs and work on developing the ETL process

Confidential, Costa Mesa, California

Informatica Consultant

Responsibilities:

• Set up the Informatica Environment in a new data center
• Install Informatica 8.6 AE (PowerCenter, Data Analyzer and Metadata Manager)
• Setup a 3 tier environment
• Working with Linux Shell Scripts, needed to automate the weekly maintenance schedule
• Document the data flow within the Organization.
• Design a generic ETL framework for a data migration/integration.
• Develop ETL mappings to create extracts required by external client to Confidential
• Work with Business Analysts to understand business requirements and convert tan to technical specs and work on developing the ETL process
• Convert existing Sagent ETL process to Informatica ETL Processes.

Environment: Informatica 8.11/8.6, Oracle 9i/10g, Linux Red Hat, MKS version control, Shell Scripts

Confidential, California

Sr. Informatica Administrator

Responsibilities:

• Analyzed the different source system data to be use in building the datamart and gathering functional requirements from the Business Analysts and designing the ETL framework and getting it approved
• Designing/developing ETL processes for various DM on the EDW
• Assign the ETL designs to the offshore team and track the process and report to the management,
• Extensive usage of powercenter tools/transformation in the development process of ETL(both 7.14 on AIX and 8.6 on Linux Red Hat) for various Data Marts
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per customer requirement to make new enhancements or resolve problems
• Working on upgrading powercenter from version 7.14 to 8.6.
• Design ETL framework for Data migration projects
• Provide solutions for data migration projects
• Analyze existing oracle procedures, functions, packages and design informatica mappings.
• Capacity planning on these environments
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies
• Maintain all necessary updates and/or patches for the ETL environment.
• Code/folder migration from one environment to another as part of release management
• Develop utilities using Informatica command line utilities

Environment: Informatica 7.1.4, Oracle 9i, Sybase, HP-UX, Autosys (Scheduler), SQL Server 2000

Confidential, California

Senior Informatica ETL Architect/Administrator

Responsibilities:

• Worked as Sr. Informatica 7.1.4 Administrator for ODS/EDW, CDW and ICRS (Integrated credit Information system)
• 24*7 Production Primary support for ODS/EDW and CDW/ICRS and Production Parallel Environment
• Capacity planning on these environments
• Setting up standard for the developers to follow the Procedures, naming conventions, standards and Regulations.
• Informatica migration on Development, Test and Production environment.
• Involved in the Informatica7.1.4 installation on AIX environment and applied patches.
• Created meta- data repository queries to know the Workflow status, Error finding and to know the statistics.
• Wrote UNIX shell scripts and Awk programs for file manipulation
• Shell Scripting to Automate OS Backup (through Cron) in AIX / Configuring production job scheduling, maintenance and alert system.
• Automate and manage repository administration tasks using shell scripts.
• Training and pair programming to get the teams up to the speed.
• Provided various suggestions for best practices for the development, and improving the performance and tuning of current slowly running jobs.

Environment: Informatica 7.1.4, Oracle 9i, IBM AIX,IBM Mainframe, MKS version control, TWS(Scheduler),SQL Server 2000, TWS Scheduler, Shell Scripts

Confidential

Informatica Architect/Technical Lead

Responsibilities:

• Gather Functional requirement from the various source system owners
• Manage projects for onsite/offshore models
• Responsible for developing development standards, common re-useable Informatica mapping templates, migration procedures, error handling process design and implementation.
• Responsible for developing best practices for Informatica server installations, administration and maintenance, high availability (HA) and disaster recovery (DR).
• Also involved with checking the server resource utilization and providing recommendations for faster performance.
• Work with IT teams of the respective source systems to get the legacy data/interfaces extracts created.
• Design a generic Informatica process to read various source systems data and load to SAP clients
• The data resides in various platforms like oracle, Sybase, DB2, and VSAM etc.
• The current scope of the project is to load the SAP R/3 tables and SAP BW.

Environment: Informatica PowerCenter 7.1.4/6.2.1/6.1/5.1 , Business Objects, Informatica, PowerAnalyzer, ER Win, Oracle 9.x/8.x, DB2,, PL/SQL, UNIX Shell Scripting, PVCS, MS SQL Server 2000, IBM AIX

Confidential, Kansas

Informatica Power Center 6.1 Administration

Responsibilities:

• Worked on Informatica PowerCenter upgrade, implement server grid manually and performance & tuning of the server as well as various maps and sessions.
• Extensively worked on planning and upgrading all their Informatica servers from 6.x to Informatica 7.1.4.
• Worked on performance & tuning of various slowly running jobs.
• Worked on designing the server architecture and implementation of PowerAnalyzer installations and configurations.
• Configuration of Informatica Server
• Automate application install, uninstall and application enhancements through shell scripts
• Programs created using Unix shell scripts for system management and monitoring.
• Implemented and Managed Secure file transfer and secure shell based server access
• Writing Shell scripts (Ksh) for generating reports and automating tasks
• Develop and automate a number of ETL processes which involves developing Unix shell script, NT batch scripting
• Responsible for analyzing the existing system to re-engineer their reporting applications.
• Responsible for complete design of the architecture for re-engineering and developing whole new application with a separate stage, ODS and a Datamarts.
• Business Objects is the business intelligence tool used for reporting.
• Shell scripts for automated installations and extracting logs
• Development of Informatica mappings/sessions to load the data in Life Data Mart.
• Providing support to the “Life Data Mart” design team.
• Developing Unix Shell scripts for automating the loads, by scheduling the sessions using Unix shell scripts and tuning the mappings/sessions to get the maximum output from them.

Environment: Informatica PowerCenter 7.1.1/6.2.1/6.1/5.1 , Business Objects, Cognos, Informatica Metadata Reporter & PowerAnalyzer, Erwin, Oracle 9.x/8.x, PL/SQL, UNIX Shell Scripting, PVCS, Cron, Auotsys, MS SQL Server 2000, HP UX, Sun Solaris

Confidential, Kansas

BO Universe Design for MX views

Responsibilities:

• Worked extensively on databases such as Oracle Metadata during the ETL processes development
• Extensive involvement in the design aspects and involved in developing various prototypes and testing them thoroughly.
• Cleanse the source data, Extract and Transform data with business rules, and built re-usable mappings, known as ‘Mapplets’ using Informatica PowerCenter Designer.
• Databases include Oracle 8i, SQL Server, Access, Excel, flat files etc.
• To analyze the Informatica Meta Data exchange views (MX views) in Oracle 8.0.
• To develop/design the universe on MX views to develop reports on Meta Data created by Informatica in the Repository.
• Trace the jobs to final tables used in the data warehouse. dis includes the datasets used on the mainframe, which were used as a source for the data extracts feeding the data warehouse. dis was to be done in a graphical format (using flowcharts).
• Describe the calculations done on various columns to arrive at the final values used in the data warehouse. dis was done in a flowchart as well as pseudo code.
• Create a document describing the process flows of the jobs. dis would be in a flowchart. It would differ from the job trace in dat it would contain the processing logic carried out (if any) by the job on each data set before it reaches the final ORACLE tables. dis would also contain the logic used to enrich the columns of the tables.

Environment: ORACLE 7.3, UNIX, COBOL, PL/SQL and EASYTRIEVE

Confidential

Claims Automated System

Responsibilities:

• Design of the target database in Oracle, based on the existing COBOL file layouts
• Analyzing the existing system
• Generating program specification and flowcharts
• Prototyping and developing various forms and report modules for the system.
• Tabulate the software, language wise & complexity wise.
• Complexity factors are - Total LOC, Impacted LOC, Number of Subroutines & COPY MODULES.
• If more than one person is working on the estimation, cross verify the estimates
• Time estimation to obtain the time required to convert programs of a complexity type.
• Document analysis & results.

Environment: COBOL, CICS, EASYTRIEVE, MVS (JCL, VSAM), SEEC TOOL