SUMMARY

• 15 plus years of Business Intelligence and Data warehouse experience in working with Data extraction, transformation and loading using Informatica PowerCenter. Expertise in Extraction, Transformation and Loading (ETL) processes using Informatica Power Center 10.2/9.5.1/9.0.1 /8.6.1/7. x/6.x
• More than Nine years of development experience in the Data Analysis, Requirement study, Data cleansing and Data quality, Data Profiling and Master Data Management, mapping business requirements to high level design and detailed design, development, testing and implementation, maintenance of Database/Data Warehousing applications, System Integration and Software Configuration Management.
• Implementation experience in multiple industries like Auto Finance, Public sector, Life science and Healthcare, Banking and Insurance domain
• Experience in data integration, aggregation and delivery of Clinical data using Clinical Data Repository.
• Experience in Administration and S/W Installation Informatica PowerCenter 10.2 9.6.1/9.5.1 in RHEL(Linux) with Oracle 12c/11g/10g/9i, SQL Server 2012/2008/2005 databases.
• Exposure in Informatica Cloud data extraction, Transformation and Loading process. Extracted and loaded data in SFDC system using Informatica Intelligent Cloud Services (IICS).
• 6 years of Business Intelligence experience using Oracle BI Applications 7.9.6.x, Informatica 10.x,9.x/8.x/7.x/6.x and Oracle Business Intelligence EE 10.x (OBIEE).
• 5 years of experience in data integrations with Salesforce application using Informatica PoerCenter and IICS.
• Nine Plus years of database experience in Oracle 11g/10g/9i/8i, IBM UDB, SQL*Plus, PL/SQL and oracle DBMS Packages, oracle supplied utilities, TOAD, Rapid SQL.
• Strong Knowledge of Data Warehousing concepts and Dimensional modeling using Star schema and Snowflake schema. Extensive experience in defining the overall data warehouse architecture (e.g., ETL process, ODS, Data Marts).
• Well versed in Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using Informatica PowerCenter tool.
• Expertise in debugging, optimizing the performance tuning of Informatica Mappings/Workflows.
• Extensive exposure various tools like Informatica PowerExchange, Informatica Cloud, Informatica Data Quality (IDQ)
• 4 years of experience as BI developer in Oracle Business Intelligence (OBIEE) 10.x including server installations & upgrades on Windows/Unix, repository configuration using administration tool, creation of dashboards and reports source from relational databases, cache management and metadata migration to different environments.
• Strong Knowledge of Data Warehousing concepts and Dimensional modeling using Star schema and Snowflake schema.
• Extensive experience in defining the overall data warehouse architecture (e.g., ETL process, ODS, Data Marts).
• Experience in database design and knowledge in Data Modeling.
• Extensive work in ETL process consisting of data extraction, transformation, data sourcing, mapping, and loading.
• Exposure in working with various OLTP and OLAP database system.
• Expertise in debugging, optimizing the performance tuning of Oracle BI Applications and Informatica Mappings / Workflows.
• Well versed in Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using Informatica PowerCenter tool.
• Multi - platform experience on SOLARIS/UNIX/Linux and Windows Server family of products.
• Excellent Team Management Skills with good business acumen, effective communicator, experience in working with Business Users and Senior Managers and Executives.
• A Team Player with excellent communication, analytical, verbal and writing skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.2./9.6.1/9.5.1/ 9.0.1/8.6.1 /7.2 ((Source Analyzer, Data warehousing designer, Mapping Designer, Workflow Manager,Workflow Monitor)Business Objects Data Integrator(BO DI), TIBCO DataExchange Designer 5.x

Business Intelligence Tools: Oracle BI Applications 7.9.6.X, Oracle BI EE 11.1.1.x/10.1.3.x, Bi Publisher 10.1.3.4.1 , DAC 10.1.3.x

Database: Oracle 8i/9i/10g/11g, LDAP, DB2, MS SQL Server, Oracle Applications 11i

Other Tools: ClearCase, VISIO, ERWIN R7,ER Studio, MPP, TIDAL, TOAD, SQL*Loader, SQL Developer, JDEVELOPER, Mercury Test Director(Quality Center), ClearQuest, Microsoft Office 2003/2007

Operating Systems: UNIX, SOLARIS, Windows 2000/2003/XP

Programming Languages: Java, SQL, PL/SQL, JSP, Servlets, JDBC, EJB, JNDI, Java Script, Shell Script

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Developer / OBIA Developer

Responsibilities:

• Responsible for analyzing, designing and developing ETL processes using Informatica PowerCenter 10.2/9.6.1/9.5.1 for loading the data into CRM system.
• Developed ETL mappings and workflows to source data from multiple source systems (Leasepak, Daybreak, Blaze, IVR, MEND) and loaded into Siebel EIM tables with custom transformations.
• Develop Mappings & Workflows in Informatica PowerCenter 9.5.1 for data load and integration of Oracle Siebel CRM Application, MDM and Near Real time batch.
• Support Data Integration for multiple custom interfaces related to ILM Data Shaing, Dialer Integration, WFM system, FICO Load processes, Selligent system and DEEP.
• Created various Data Replication, Synchronization, Masking and PowerCenter tasks in Informatica Intelligent Cloud Services (IICS).
• Developed data load processes in Informatica Cloud to extract data from SFDC environment to DataMart system.
• Exposure in the Salesforce Lookup, Salesforce Merge, SalesForce PickList transformations.
• Develop custom SDE and SIL Informatica mappings in Oracle Business Intelligence Applications.
• Develop Datawarehouse Admin Console (DAC) load processes for Siebel CRM to OBAW data load.
• Design and Develop Tasks and Execution plans and exposure in performance tuning of existing DAC load processes.
• Developed Informatica mappings to read data from XML source with extensive use of XML Sources and XSDs.
• Develop complex ETL processes for data extractions, data transformations, data staging and data migration to centralized data warehouse and datamart systems.
• Strong exposure in UNIX shell scripts for execution of the Informatica workflows, flat file handling, developing archival process.
• Analyze Functional & technical design documents. Participated in all phases of project development, testing, deployment and support.
• Coordinate with other programmers, data analyst and HCA architecture team during the ETL development process.
• Develop the tables and the required database objects in Oracle 11g database management system.
• Develop data load processes using SQL, Oracle database and Microsoft SQL Server software.
• Help in data migration, project deployment and implementation activities.
• Provide production support of Informatica production environment and implementation of smooth system performance.
• Support Informatica Administration activities.
• Support performance tuning and optimization of data load Mappings & Workflows in production environment.
• Strong exposure in SQL, ETL/ELT processes. Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL to move the changed data across multiple environments using DB links.

Confidential, Irvine, CA

Senior Informatica ETL Developer

Responsibilities:

• Involved in defining the Clinical data repository and data mart architecture, technical requirements
• Responsible for analyzing, designing and developing ETL processes using Informatica PowerCenter 9.0.1
• Designed and developed various Clinical study data load process, workflows and Sessions to suit the requirements.
• Implemented various ETL Mappings in Informatica PowerCenter 9.0.1 for data extractions, data transformations, data staging and aggregation.
• Developed the complex Mappings, mapplets, Transformations, UDFs for loading Study Protocol Deviation Repository.
• Developed ETL processes for building, deploying, and managing the data migration to Datamart.
• Architected and implemented change data capture process in Informatica mappings.
• Experience in developing Informatica mappings to read data from XML source with extensive use of XML Source and XSD.
• Extensive experience in Informatica Workflow manager and developed workflows using worklets, decision task, Control, Event, command task.
• Experience in code migration using Informatica Repository manger deployment groups
• Developed UNIX shell scripts for execution of the Informatica workflows, flat file handling, developing archival process
• Expertise in debugging, optimizing, resolving defects and programming fixes
• Experience in scheduling of workflow using Informatica Scheduler.
• Involved in Database design and data analysis.
• Involved in Migration, Project deployment and implementation activities.
• Coordination with different work stream leads along with teams across multiple locations
• Support in system and User acceptance testing and Exposure in migration activities and Job scheduling
• Involved in the deployment and implementation of ETL modules

Environment: Informatica Power Center 9.0.1, oracle 11 g, SQL, PL/SQL, TOAD, Clearcase, UNIX.

Confidential, Santa Ana, CA

Senior Informatica ETL Developer/OBIA Developer

Responsibilities:

• Involved in defining the data mart architecture and technical requirements, and in coordinating the design of the consolidated data model.
• Prepared Gap Analysis documents between requirements in necessary customizations and out-of the- box Oracle BIA functionality.
• Responsible for analyzing, designing and developing ETL processes using Informatica PowerCenter 9.0.1/8.6.1 (data load to Oracle Business Analytics Warehouse - OBAW from the source database)
• Designed and customized various SDE and SIL mappings, workflows and Sessions to suit the requirements.
• Implemented various ETL Mappings in Informatica PowerCenter 9.0.1 for data extractions, data transformations, data staging, movement and aggregation.
• Developed the complex mappings, mapplets, Transformations in Informatica PowerCenter.
• Implemented change data capture process in Informatica mappings.
• Expertise in managing the ETL mappings and executed the workflows using DAC.
• Customized DataWarehouse Administration Console (DAC) ‘Complete ETL’ execution plan to created/customize Task definitions.
• Customized warehouse schema by creating custom tables and loaded data with custom ETL routines.
• Support in system and User acceptance testing and Exposure in migration activities and Job scheduling
• Involved in the deployment and implementation of ETL modules
• Design and developed the repository (.rpd) by defining Physical Layer/Business Model and Mapping Layer/ Presentation Layer.
• Created the Logical complex join relationships in Business Model and Mapping Layer.
• Developed Logical columns in Business Model and Mapping layer and defined different Aggregation rules.
• Customized the RPD metadata and BI reports for Finance subject areas.
• Worked on Pre-built RPD to customize for EBS FINANCIAL's.
• Experience performing Administrative tasks of migrating repositories of OBIEE, Informatica and DAC between various environments like DEV, SIT, UAT and PROD.
• Responsible for preparing and delivering the Proposal Document, Detailed Low Level Design (LLD) Documents, Release Documents, traceability matrix etc.

Environment: OBIEE 11.1.1.x/10.1.3.x, Oracle BI Applications 7.9.6.x, Informatica Power Center 9.0.1/8.6.1 , oracle 10g, SQL, PL/SQL, TOAD, Clearcase, UNIX.