SUMMARY

• About 11 years of IT experience in the field of Data Warehousing providing BI solutions using Informatica Power Center, Data Quality, MDM, OBIA wif SDLC processes.
• 10.5 years of experience as Informatica Admin, Development and providing ETL Solutions using Informatica Power Center 9.x/8.x/7.x. etc.
• Expertise in Informatica version upgrades like from 8x to 9x and latest from 9.5.1 to 9.6.1.
• Informatica Admin experience like setting up environments in Linux, Windows, User & Groups creations, LDAP configuration, Repository creations using Admin URL, Repository Migrations etc.
• Monitor and tune environments such as CPU, RAM, IO and Network and make recommendations on general architecture of environment.
• Experience in installation and configuration of Informatica Metadata Manager (IMM), Informatica Data Quality (IDQ), MDM, ILM, Power Exchange (PWX) CDC etc.
• Involve in Level - 3 production support issues specific to Informatica product.
• Experience in Informatica code migration using Deployment Groups.
• Experience in Informatica Power Center ETL Tool wif Banking, Financial, Healthcare, Insurance and Sales & Marketing domains.
• Identify and manage necessary upgrades to environment including Fix Packs, EBF’s and new versions.
• Experience in working wif Informatica product support in case of any Issues, bug reporting etc.
• Experience in working wif Release Management team on change control and releases, and proceed wif code migrations accordingly.
• Experience in working wif ITSM team in case of Application related alerts management, and debugging infrastructure related issues etc.
• FTP setups follow up wif ‘System Admin Team’ and verify the incoming source (OLTP) related files
• Extensive experience in Install and configuration using OBIEE 11.1.1.7, OBI apps 7.9.6/11g.
• Team Player, Able to Work wif a new and fresh perspective on work assignments, good in debugging, creative and able to learn new things.
• Highly motivated, energetic individual and a very good team player willing to work hard to meet intensive schedules and having excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6x/ 9.5/9.1/8.6/8.1.1/7.9. x/6.1.1, ODI 12c/11g

BI Tools: OBIEE 11g/10g, Cognos 10x, Business Objects

Dimensional Data Modeling: Conceptual, Logical and Physical Data Modeling using Sybase Power Designer, ERwin tools. Data Mart Designing.

Tools: Toad, SQL Developer, SQL Plus, Control-M

Language: SQL, PL/SQL, Unix Shell Scripting, C, and C++

Operating Systems: Linux, Windows 2007,2003/2000/XP/98, MS-Dos

System Design & Development: Requirements Gathering and Analysis, Data Analysis, ETL Design, Reporting Environment Design, Development and Testing UAT Implementation

Scheduling Tools: Datawarehouse Administration Console (DAC), Ctrl M, Chronicle, AutoSys

RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server, Teradata, DB2, Netezza, MS Access

Applications: MicroSoft Visual Source Safe, Smart FTP, MS Office, Outlook, Win SCP, Putty.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr Informatica Administrator

Responsibilities:

• Involved in the initial setup of BIApps environment wif Informatica and DAC for ETL.
• Installation and Configuration of Informatica PowerCenter including Repository and User creation.
• Informatica Powercenter upgrade from 9.5.1 to 9.6.1.
• Clustering Informatica environments, Grid implementation.
• Monitor and tune environments such as CPU, RAM, IO and Network etc.
• Code deployment/migration, monitoring the jobs, support and maintain the environment.
• Make sure High Availability is maintained across the environments.
• Make sure their are no connectivity/networking issues between the envrionments.
• Installation and configuration of Power Exchange (PWX) CDC.
• Informatica code migrations using Deployment Groups.
• Developed Unix script for Code backups, archiving logs etc.
• Configured Informtica Data Quality (IDQ).
• Worked wif different source systems like CRM, ERP, BRM, EDI etc to bring in the data.
• Configured DAC (ETL jobs scheduling tool) wif different workflows, parameters and .
• Created Execution plans and scheduled them in DAC.
• Work wif Informatica support in case of any product related issues or Bugs.
• Work wif Release Management team on change control and releases and do code migrations accordingly.
• Work wif ITSM team in case of Application related alerts.
• New FTP: Directories creation and permissions across environments
• FTP setups followup wif SysOps and verify the incoming source files etc.

Environment: Informatica Power Center 9.6.1, OBIEE 11.1.1.7, Oracle 11g, Oracle DAC, WINDOWS Server 2003.

Confidential, Dallas, TX

Informatica Administrator/Lead

Responsibilities:

• Involved in Business Requirement gathering wif multiple business users and decided on environment specific Infrastructure.
• Did initial setup for the project wif Oracle DB, Informatica infrastructure etc and lead ETL Team of 5 members including offshore.
• Has setup the Informatica PowerCenter Environment and Administration.
• Installation and Configuration of Informatica PowerCenter including Repository and User creation.
• Configured Informatica Metadata Manager.
• Designing Informatica ETL mappings using Transformation logic etc. for an TEMPeffective loading of Data from source systems.
• Informatica code migrations using Deployment Groups.
• Developed UNIX script for Code backups, archiving logs etc.
• Worked closely wif the database team for designing the Data Model as Star Schema using ERWin.
• Designed Informatica Mappings wif various transformations like Source qualifier, Aggregators, Dynamic Lookup, Router, Sequence generator for mappings based upon the requirement.
• Teradata Bteq scripts been used extensively in DWH implementation.
• Most of the columns which require calculations are determined first and are calculated in ETL using Informatica in order to increase the query performance.
• Work wif Informatica support in case of any product related queries.
• Work wif Release Management team on change control and releases

Environment: Informatica Power Center 9.6.1, Cognos 10x, Oracle 11g, Teradata 13x (TD 13.10), WINDOWS Server 2003, Linux

Confidential, Atlanta, GA

OBIApps Administrator (Informatica/OBIEE)

Responsibilities:

• Implemented OBIA Environment setup (Informatica, DAC, and OBIEE) to give complete Datawarehousing/BI solutions including ETL and Reporting.
• Performed the Admin related Activities like Configured and Installing OBIA Out of Box Applications and OBIEE 11g and Applying OBI 11g applying interim and bundle patches, and Ins refreshing the servers, services, Shutting and Starting up the servers
• Informatica code migrations by exporting into XML files and import into higher environments.
• Developed UNIX script for Code backups, archiving logs etc.
• Leading and mentoring the team to understand the data model and development and enhancement of ETL and DAC objects.
• Involved in migration of code objects (ETL, DAC, RPD and Catalog) form development to the higher environments.
• Trouble shooting the issues related to repository models and report development.

Environment: Informatica 9.1.0, OBI Applications 7.9.6.3, OBIEE 11g, Oracle11g, Oracle DAC, ODI 11g, EBS R12 (12.1.3), BI Publisher, SQL Developer, WINDOWS Server 2008, Linux.

Confidential, Wilmington, DE

ETL Administrator/Developer

Responsibilities:

• Informatica version upgrade and configuration from 8.6.1 to 9.0.1.
• Created the Technical Specification Document and Functional Specification Document based on business specs.
• Implemented and installed Informatica Power Center 9.0.1 and OBIEE 11g.
• Involved in designing and development of ETL (Informatica) mappings to from OLTP to Staging and from staging to DWH by using various Informatica Transformations.
• Informatica code migrations using Deployment Groups.
• Developed Unix script for Code backups, archiving logs etc.
• Integrated all Informatica workflows into Oracle DAC, Created Execution plans, and schedules ETLs.

Environment: Informatica 8.6/9.0.1, OBIEE 11g, Oracle11g/10g, Oracle DAC, Siebel CRM, Toad, WINDOWS Server 2003, Linux.

Confidential, Santa Clara, CA

ETL Developer

Responsibilities:

• Worked closely wif Business Analysts in understanding the Analytics Requirements and designed ETL structures as per the requirements.
• Analyzing existing Informatica mappings and do the customizations according to new requirements. DAC Configuration and Informatica-ETL Configuration.
• Designed and Developed Informatica mappings from OLTP to Staging and from Staging to DWH by using Transformations.
• Involved in the installation and configuration of Informatica and OBIEE 10g in the windows as well as the Linux environment.
• Implemented SCD Type II in Informatica mappings to implement Full Historical DWH.

Environment: Informatica 8.6, OBIEE 10g, Oracle 10g, SQL Developer, WINDOWS XP, Linux.

Confidential, Chicago, IL

Sr. Software Engineer

Responsibilities:

• Involved in complete life cycle of the project from project initiation to development and maintenance.
• Developed Informatica mappings and created document indicating the source tables, columns, data types, transformation required, business rules, target tables, columns and data types.
• Implemented Daily Data reconciliation using Informatica Mappings after daily incremental load.
• Worked wif multiple sources such as Relational Databases, Flat files for extraction using Source Qualifier and Joiner Transformations.
• Developed various Mappings & Mapplets to load data from various sources using different
• Created materialized views and aggregates to improve performance.

Environment: Informatica 7.1.4, Siebel Analytics, Oracle 9i, Toad, PL/SQL, Windows XP