PROFESSIONAL SUMMARY:

• Over 17 years in IT experience including 8 years of experience in BI/DW ETL OBIEE Architecture/Developer
• Experience on all phases of Data Warehouse/ETL/OBIEE development, Testing, Implementation lifecycle from gathering requirements to testing, implementation, and support.
• Data Load from EBS to EDW and Data Integration from Salesforce.com to EDW.
• Exceptional background in analysis, design, development, test, and implementation of Data Warehouse, Business Intelligence Environment with Slowly Changing Dimension SCD Type 1, 2, and 3 as well as Changed Data Capture CDC
• Demonstrated expertise utilizing various ETL tools Informatica, ODI, DataStage, PL/SQL and Cast Iron .
• Designed ODS, Staging, Multi Dimensional, Fact, Data Mart tables with Star, Snowflake schema.
• Advised and consulted for technical groups on ETL best practices.
• Built RPD, Dashboard/Analysis, and OBI Publisher reports in OBIEE 10/11g
• Excellent technical and analytical skills with clear understanding of business requirement
• Team player with good communication and problem solving skills
• Leads the implementation of effective solutions in data integration
• Oracle Data Integrator ODI v10 Training Certification: Administration and Development

TECHNICAL SKILLS:

• ETL Tools Informatica v9, Oracle Data Integrator ODI v10, DataStage v7/8, Cast Iron
• Development tools Toad, SQL Developer, SQL Loader, Apex Data Loader, PL/SQL, PeopleTools 8.45, XML, HTML, T-SQL, Erwin, SharePoint, MS Project, Visio
• BI Reporting Tool OBIEE 10/11g, OBI Publisher, Crystal Report, Micro Strategy
• DB Oracle 10/11g, DB2, and MS SQL Server
• O/S UNIX/Linux, Windows NT, Mainframe IBM
• ERP/EPM PeopleSoft 8/9 EPM, Financial, Supply Chain, HR, CRM

PROFESSIONAL EXPERIENCE:

Confidential

Senior BI/DW OBIEE Consultant

• Analysis Business user's requirements and build Logical and Physical Data Models with Star/Snowflake Schema.
• Design and development OBIEE Analysis, Dashboard BI Publisher Reports using OBIEE 11g.
• Build Repository and Hierarchy in OBIEE Admin Tool RPD .
• Development and Enhancement to load/extract data from ODS to DW schema using PL/SQL and SQL scripts as well as assisting other team members.
• Support business operations via OBIEE: investing defects or issues, assisting with usage tracking metrics, and updating existing BI Publisher report, analyses, dashboards.
• Ensure that all incidents and requests are resolved and handled promptly and in order of priority.

Confidential

BI/Data Warehouse ETL Lead/Architect

• Worked closely with Business users to understand their data needs and translate requirements into ETL design and integration workflows.
• Identifies requirements, defines scope, performs cost benefit analysis, and develops conceptual specifications to address complex business issues and problems.
• Analysis and Design Data Modeling Physical / Logical Data Model for Revenue Forecast, Booking, and Sales Models.
• Design Functional/Technical Specifications based on the Business Requirements.
• Build Metadata Repository in OBIEE Admin Tool
• Create Answers and Dashboards for Revenue Forecast Model in OBIEE.
• Create Dimensional and Fact tables in Star/Snowflake Schema.
• Create Staging, DW and Aggregated, Data Mart tables with SCD Type 1, 2 and 3.
• Create Oracle PL/SQL, Materialized views and functions for ETL and OBIEE.
• Configured ODI ELT Designer, Topology, Operator and Security Manager.
• Create Physical, Logical Architecture and Repository in Topology Manager.
• Create Data Model, Data Store and Project in Designer.
• Develop Procedure, Interface, and Packages using ODI Knowledge Modules for data load from EBS to EDW.
• Setup ODI Agent to execute the ODI scenario jobs automatically in Batch schedule.
• Develop/manage ETL Informatica Repository, Mapping, Workflow in Batch Schedules/Ad-hoc Processing.
• Performance Tuning on ETL - Informatica mapping/workflows, PL/SQL, SQL scripts.
• Provide Strong Technical Leadership on projects with working independently.
• Possesses strong Data Warehouse/ETL Architecture concepts and knowledge.
• Build strong relationships with other project members and 3rd party consultants.
• Utilize 3rd party development tools for System/Data Integration.
• Demonstrates strong commitment to Continuous Improvement in the areas of process and technology.
• Troubleshooting and resolve end user issues and problems.

Technologies: ODI v10, Informatica Power Center v9, DAC, Oracle 11g, OBIEE, PL/SQL, SQL Plus, Toad, SQL Developer, SQL Loader, Linux, Erwin, MS SQL Server, T-SQL

Confidential

DW/ETL Specialist

• Analysis and configure the ETL system to convert from Informatica to Datastage.
• Design and develop ETL Datastage, Informatica , PL/SQL, Store procedures, configuration files, tables, views, and functions implement best practices to maintain optimal performance.
• Advising other groups in organization on ETL development, data warehouse development, and ETL development best practices.
• Conduct code walkthroughs and review peer code and documentation.
• Build efficient ETLs and Test scripts for processing data load from financial system/Payroll/HR to EPM as well as 3rd Party system.
• Establish shell scripts/runsheets of ETL jobs for Batch Process via Control-M.
• Work with other developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Provide on-call support to production system to resolve any issues.
• Improved the performance on weekly data load process from 6 hours to 1 hour.

Technologies: Informatica Power Center v7, DataStage v7/8, Oracle 10g, PL/SQL, SQL Plus, Toad, SQL Developer, SQL Loader, Unix, Erwin

Confidential

Senior ETL Consultant

• Designed Data Model, ODS layers, Data Warehousing, and Data Mart Tables for Dashboard Scorecards.
• Developed Informatica ETLs to interface data from FIN/HR/Hyperion/CRM to EPM.
• Customized/Developed Application Engines, SQRs, PS Query, and SQL Scripts.
• Setup Record Metadata and defined Dimension/Fact Tables for DWH and Data Mart.
• Provided technical and functional support with production support for PeopleSoft EPM with HR, Financial, and CRM system.
• Identifying, defining, and implementing new processes as required to business needs.
• Reconciled the data b/w PeopleSoft Financial/HR/CRM and EPM.
• Troubleshooting system issues for PeopleSoft EPM and Financial 8.4 GL, AR, AP, BI, Project applications.
• Created Test scripts and results.
• Report Query writing /development, and maintenances

Technologies: Informatica Power Center v7, Oracle 10g, PL/SQL, SQL Plus, Toad, SQL Developer, SQL Loader, UNIX, Erwin v7

Confidential

PeopleSoft Consultant

• Implemented PeopleSoft v8.3/8.8 HR, Global Payroll Interface System, Benefits .
• Production support for interface processes via FTP, XCOM, and XML on Global Payroll System.
• Analyzed, designed Tech spec, and developed batch process SQR , on line process.
• PeopleCode, App Engine for MPC Compensation, Job code change, Mass change, and Terminated EE list, etc.
• Enhanced Work Location, Expatriate EE Payroll, Personal data change, Cash awards, Cost Center with PeopleCode, PeopleTools, App Engines.
• Created new PS queries and updated existing queries for user's needs.
• Resolved HR problem tickets, Troubleshooting, Performance Monitoring.
• On call production support.

Confidential

PeopleSoft/ETL Consultant

• Implemented on PeopleSoft EPM V8.8/CRMv8.4 fixed and enhanced on issues and defects in CDM, Sales, Marketing, and Support modules.
• Developed/Modified Interface Job Processes from Existing Custom Data CRM into EPM ODS Layer via ETL Ascential Datastage tool for consolidated data Incremental/Destructive.
• Maintenance interface process from 3rd party XML file to PeopleSoft EPM.
• Created Dimension, Fact, Error, Temporary tables for EPM Data Warehousing.
• Created Metadata, Table map, Data map, Data Loader Process with EPM App Engine Engine.
• Designed Technical specs and built Data loader processes from ODS layers into Data Warehouse Tables Dimension/Fact Tables, etc on Product, Issue, Advisor modules, etc.
• Developed/Customized Application Engines, SQR and Crystal Reports for marketing/sales.
• Created many Lookup Views and SQL objects for Daily/Weekly/Monthly Reports.
• Created run control pages/menu for the new custom reports and set up in process scheduler.
• Wrote unit test plan and support to functional analysts to create the PS Queries.
• Fixing critical defects and performance monitoring on data loading processes.
• Developed Black Berry Mobile Sales interface system between SQL server and PeopleSoft CRM.
• Successfully implemented for EPM v8.8.
• Created several complex reports for Marketing and Sales modules timely in PS CRM/EPM
• Participated development of Black Berry RIM interface modules for Peoplesoft.

Confidential

PeopleSoft Consultant

• Fixing critical defects and performance monitoring on data loading processes.
• Implemented the PeopleSoft HRMS v7.5/8.3 modules HR, Payroll, Time Labor, Benefits, Recruit Workforce and Financial GL/AM .
• Upgraded SQR programs, PeopleCodes, PS Tables for HRMSv7.5 to 8.3.
• Designed technical specifications, modified objects Components, Pages, Table Structures, etc. .
• Developed/Customized of App. Engine programs for complex calculations or to change in business rules.
• Production Support for HR defect corrections/Data change requests.
• On call production support for PeopleSoft HRMS applications HR, Payroll, Benefits Administration and Base Benefits, time and labor .
• Customized pages, components, menus for HR, Payroll, Base Benefits, and GL/AM, etc.
• Created multiple SQR reports, Crystal reports HR, Payroll, Benefits, Financial reports GL, AM .

Confidential

Programmer/Analyst

• Developed all application programs, mainly interface programs for Bank client to control and manage information of financial transactions transmitted between Bank and Finance company.
• Converted the Banking System Customer Information Management from Mainframe to UNIX.
• Upgraded and enhanced applications for GIC, Mutual Funds and Checking/Savings Accounts in general system of financial business.
• Modified applications for Management Information System and Personnel Management System.
• Processes involved analysis, design, specification, programming, menu displays and testing. Focused on analysis, coding and testing application programs as a main staff of the team.
• Programs were written in Oracle Forms/Report, Pro C/C, PL/SQL, Pro COBOL, Unix, and SQL Plus using Oracle database on HP/UNIX.