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 EXPERTISE: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
• Managing teams at onsite and offshore
• Resource, Schedule and budgetary planning
• Coordinating with the Functional/Business owners and IT Managers for defining the project lifecycle deadlines and ensuring the consistency in delivery
• Building an effective team by working with the marketing/recruitment teams and getting the best resources available in the market
• Supporting the organization in the presales department, by working with new clients for business improvement in the BI sector.

WORK HISTORY:

Anaheim, CA

Informatica Architect / Administrator

Responsibilities:

• Migrate SSIS packages to Informatica
• Create IDQ Score Cards for Different Source systems.
• Implement MDM solution using Informatica MDM tool
• Implement Metadata Manager for getting data lineage and creating Business Glossary
• Design Data Quality Rules for data validation prior to loading and create error reports
• Load and maintain a repository for all the Fund and Investment Strategies, and Client Accounts which are received from applications including outside Vendor applications and Provide data to other downstream applications for Publishing through the digital Media and Print media.

 Environment: Informatica PowerCenter 9.5.1, Informatica DQ, Informatica MDM, Informatica Metadata Manager, SQL Server 2012, Windows, QuickBase, Microsoft VSS

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
• Develop ETL process for external integrations.
• Define strategies for Data Governance to ensure data quality and integrity
• Load and maintain a repository for all the Fund and Investment Strategies, and Client Accounts which are received from applications including outside Vendor applications and Provide data to other downstream applications for Publishing through the digital Media and Print media.

 Environment: Informatica 9.5.1/8.6, Oracle 11g, Linux Red Hat, JIRA, Confluence, HP

Irvine, CA

OBIEE ETL Lead/Architect

Responsibilities:

• 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 then to technical specs and work on developing the ETL process
• Design ETL processes for the MDM implementation at Hyundai Capital
• Developed MDM strategies and solutions utilizing DataFlux

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

Irvine, CA

DWH ETL Consultant

Responsibilities:

• Work with Business Analysts to understand business requirements and convert then 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)
• Develop Report using Microstrategy and Actuate
• Used Autosys for scheduling jobs
• Design an Proceses for data Integration/Migration. This 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

Irvine, California

Informatica/OBIEE Architect

Responsibilities:

• 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 then to technical specs and work on developing the ETL process

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 Tickets.com
• Work with Business Analysts to understand business requirements and convert then 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

Monterey Park, 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.

Environment: Informatica 7.1.4/8.6 ,Oracle 9i/10 g , IBM AIX, Linux Red Hat, IBM Mainframe, MKS version control, TWS(Scheduler)/Autosys,SQL Server 2000, TWS Scheduler, Shell Scripts

Irvine, California

Technical Architect

Responsibilities:

• 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

Monterey Park, 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

Kansas, USA

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

Kansas, USA

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

Environment: Informatica PowerCenter 7.1.2/7.1.1/6.2.1 , Oracle applications, PowerAnalyzer, Erwin, Oracle 10g/9.x/8.x, PL/SQL, , UNIX Shell Scripting, MS SQL Server 2000, SUN Solaris, Unix/Solaris, Citrix ICA client, DB2 Connect, Sybase

Kansas, USA

Life Data Mart Development Support

Informatica/ETL Developer

Responsibilities:

• 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
• Develop various kind of Reports in Cognos and troubleshoot performance of the same
• Cognos Framework Manager, Report studio, Query studio, Analysis studio, PowerPlay Transformer,   Impromptu Web Reports (IWR).
• 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,

Kansas, USA

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.

Environment: Informatica PowerCenter 4.7/5.1, Oracle 8i, Teradata, , Oracle Financials, Shell Scripting, PL/SQL Programming, Sybase 11.2.9, Business Objects, Cognos, ER Win 4.5, Windows NT, IBM AIX

CMDWH (Commercial Data Ware Housing)

Responsibilities:

• Trace the jobs to final tables used in the data warehouse. This includes the datasets used on the mainframe, which were used as a source for the data extracts feeding the data warehouse. This 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. This was done in a flowchart as well as pseudo code.
• Create a document describing the process flows of the jobs. This would be in a flowchart. It would differ from the job trace in that it would contain the processing logic carried out (if any) by the job on each data set before it reaches the final ORACLE tables. This would also contain the logic used to enrich the columns of the tables.

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

Claims Automated System for Payment and Reporting (CASPAR).

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.

Environment: COBOL, CICS, EASYTRIEVE, CP01 (Infront), MVS(JCL,VSAM) , ORACLE 7.3, Developer 2000 (Forms 4.5,Reports 2.5), PLATINUM Erwin 3.5.2 and Win’95

SMT System (Secondary Marketing System)

Responsibilities:

• 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