SUMMARY:

• Experienced professional with excellent communication skills, both with stakeholders and with developers.
• Effective at translating business needs into technical solutions.
• Experienced in coordinating, motivating, teams of developers.
• Have worked effectively in a range of business sizes and teams to provide a high standard of data integration and data warehousing solutions.
• Acquired a range of data warehouse and data integration experience over the full systems development lifecycle.
• Strong conceptual, leadership, and technical skills.

TECHNICAL SKILLS:

Data Integration: Informatica PowerCenter, PowerMart, PowerCenter Real Time, PowerExchange, Siebel Data Warehouse

Databases: Oracle, SQL Server, DB2 for AS400/iSeries/System I, Netezza

Development Tools: Oracle Developer, Oracle Designer, IBM Visual Age for Java, TOAD, SmartFTP, Rational ClearCase, ClearQuest, Erwin, iSeries Navigator

Languages: Java, JSP, PL/SQL, SQL, HTML, XML

Operating Systems: IBM AS400/iSeries/System i, Windows NT/2000, UNIX (Solaris, AIX, HP - UX), Windows XP

EXPERIENCE:

Confidential - Los Angeles, CA

ETL Architect / Developer

Responsibilities:

• Architected solution using Informatica to load consumer products data from source system to new consumer products data warehouse in Teradata. Worked 80% remote.
• Source data consisted mostly of relational tables, but also some flat files.
• Designed and developed Informatica objects including workflows, sessions, mappings, etc.
• Met documentation and configuration requirements and handed off to Production support team.

Technology Used: Informatica PowerCenter 9.6.1 HF3, Teradata 15.00.04.02, Teradata SQL Assistant, SQL Server 2016 CTP2.

Confidential - Los Angeles, CA

ETL Architect / Developer

Responsibilities:

• Analyzed existing Informatica data warehouse load processes and environments and recommended and successfully implemented changes to improve performance.
• Based on dependencies, reordered/rescheduled daily, weekly, monthly, and quarterly data warehouse loads to minimize wait times and to complete in the least time possible.
• Analyzed individual sessions and successfully implemented performance improvements such as index strategies, hints, parallel processing and merges.
• Implemented failure email notifications to improve production support.
• Recommended Informatica, database and hardware upgrades to improve performance.
• Developed new workflows to process data from multiple streams into HR mart and project summary mart.
• Advised Informatica administrator settings and changes.

Technology Used: Informatica PowerCenter 9.6.1 HF1, Informatica PowerCenter 9.0.1, Oracle 11g, Oracle 10g, T.O.A.D.

Confidential - Long Beach, CA

Lead ODI Developer

Responsibilities:

• Generated out-of- the-box load plans, fixed errors, executed successfully.
• Troubleshooting data issues and bugs, working with Oracle to successful resolution.
• Developed custom mappings to add new columns to existing tables.
• Developed custom mappings to load new custom tables to warehouse.
• Developed custom mappings to send email notifications on error, as well as "success" emails.
• Developed custom mapping to call ODI procedure running SQL statements.
• Customized out-of-the-box load plans to include custom mappings.
• Explored data masking options for testing purposes.
• Assisted OBIEE Administrator in configuration tasks.
• Mentored staff on ODS configuration and development.

Technology Used: Oracle Data Integrator (ODI) 11.1.1.7.1 for OBIEE 11g, Oracle 11g, Oracle SQL Developer

Confidential - Carlsbad, CA

ETL Architect/Developer

Responsibilities:

• Designed and developed extension of highly customized data warehouse following requirements using Siebel CRM (SONIC) as a source.
• Modified existing Informatica mappings to support enhancements.
• Development included table structures, as well as mappings, sessions, workflows based on Oracle BI Apps Informatica objects.
• Provided QA support with rapid turnaround.

Technology Used: Oracle BI Applications for Informatica Powercenter 7.9.6, Informatica PowerCenter 9.0.1 HF2, Oracle BI Data Warehouse Administration Console 10.1.3.4.1, Oracle 11g, T.O.A.D.

Confidential - Torrance, CA

ETL Architect/Developer

Responsibilities:

• Modified existing Informatica mappings to support file structure changes in new version of Oracle Enterprise Performance Management Architect (EPMA) to load metadata to Operational Data Store (ODS). Supported testing by Essbase developers.
• Extended existing dimension mappings to include slowly-changing dimension logic (SCD).
• Designed and developed new tables (Oracle star schema) and mappings to contain dimensional metadata hierarchies to support new Oracle BI POC sourcing fact data from Essbase cubes. Modified existing fact loads (Oracle) to include the surrogate keys.

Technology Used: Informatica PowerCenter 9.1.2 HF 4, Oracle 11g

Confidential - Midland, TX

ETL Architect/Developer

Responsibilities:

• Assisted on project to convert data from two historical HR systems, plus current Production HR system, to load into Oracle HR Analytics
• Analyzed two historial HR systems to determine business rules and data mapping to SDE Universal Adaptor source files, including modifications to SDE and SIL mappings.
• Developed mappings, sessions, workflows, task groups, subject area and execution plans in the Data Administration Console (DAC), including configuration and testing.

Technology Used: Oracle BI Apps, DAC version 10.1.3.4.1, Informatica PowerCenter 8.6.1 HF 10, Oracle 11g, IBM DB2 9.1, SQL Server 2008

Confidential - Irvine, CA

ETL Architect/Developer

Responsibilities:

• Participated in team’s Agile development process, including gathering requirements, working with business, designing solutions, developing Informatica workflows, data modeling, unit-testing, QA and UAT support, production support, etc.
• Made best-practice recommendations including naming conventions, repository management, hardware recommendations, development standards, performance improvement.
• Mentored former SSIS developers in Informatica PowerCenter in all aspects and routinely answered questions and solved development problems faced by the developers.

Technology Used: Informatica PowerCenter 9.1.2, IBM Netezza 6.0, SQL Server 2008

Confidential - Carlsbad, CA

ETL Architect

Responsibilities:

• Analyzed client’s current installation and configuration of Oracle BI Apps for Siebel to address critical performance problems.
• Assessed Informatica server hardware and software, configurations, SQL analysis, analysis of the Informatica ETLs for OBI Apps, analysis of the DAC configuration and execution plans, index strategy.
• Made a detailed list of recommendations including immediate fixes to help in the short-term and long-range steps to maximize performance and utilization of existing hardware.

Technology Used: Oracle BI Applications for Informatica Powercenter 7.8, Informatica PowerCenter 7.1.4, Oracle BI Data Warehouse Administration Console 10.1.3.4.1, Oracle 10g, Oracle 11g, SQL Plus, T.O.A.D.

Confidential . - Irvine, CA

Oracle BI Apps Informatica Lead Analyst/Designer

Responsibilities:

• Resolves defects in recently implemented Oracle Service Analytics project.
• Utilized a wide range of skills, including data analysis, SQL analysis, analysis of the Informatica ETLs for OBI Apps, analysis of the DAC configuration and execution plans.
• Analyzed defects, identified root causes, suggested possible solutions, designed solutions, developed solutions, unit-tested solutions, supported Integration Testing and UAT of solutions.
• Development included SQL and Informatica objects (mapping, sessions, workflows), DAC configuration and execution plans.
• Developed PL/SQL stored procedures and functions to load data for OBIEE project. Data modeling to create star schema and staging tables for OBIEE data load. Directed and assisted with RPD and report development for OBIEE.

Technology Used: Oracle BI Applications for Informatica Powercenter 7.8, Informatica PowerCenter 8.1, Oracle BI Data Warehouse Administration Console 10.1.3.4.1, OBIEE, Oracle 10g, Oracle 11g, SQL Plus, T.O.A.D.

Confidential - Irvine, CA

Informatica Team manager/Sr. Lead Developer

Responsibilities:

• Position started as contract-to-hire to get the Informatica team staffed and functioning.
• Interviewed and hired three core members of Informatica team.
• Reported to Director with weekly team status.
• Responsible for setting project timelines and project priorities.
• Oversaw upgrade of hardware to new 64-bit machines.
• Oversaw upgrade of data warehouse database to three environments (Dev, UAT, and Prod)
• Established best practices for the team.
• Sarbanes-Oxley (SOX) recommendations.
• Responsible for hardware and software upgrades.
• Acted as technical lead for solving key design questions, issues.
• Provided and mentoring for the developers (team of five).
• Development included SQL and Informatica objects (mapping, sessions, workflows), data modeling, including tables and indexes.
• Served as Informatica administrator.
• Shared production support duties.

Technology Used: Informatica PowerCenter 8.6 for Windows 64-bit, DB2 for AS400/iSeries/System I, IBM iSeries Navigator, Oracle 10g, SQL Plus, SQL Server 2005, Windows XP.

Confidential - Anaheim, CA

Senior ETL Architect and Lead Developer/Manager

Responsibilities:

• Lead on project to integrate data from new loan origination system (LOS) to existing operational data store (ODS). Supervised team of four developers.
• Lead on project to integrate HR and cost center data with new loan origination system.
• Lead on project to integration new LOS data to existing commission system (BUC$).
• Lead on project to loan new normalized operational data store (CDCN) with loan origination system data, including real-time feeds gathered from message queues.
• Lead on project to provide loan lookup across all businesses.

Technology Used: Informatica PowerCenter 7.1.1, Informatica Real Time for JMS, TOAD, ERwin, Oracle 9.2, SQL Plus, Windows 2000, Empower.

Confidential - Chicago, IL

Senior ETL Architect

Responsibilities:

• ETL hands-on Developer on Global Balancing Tool project to daily balance clients’ trading activity on futures and options exchanges.
• Developed ETLs to load flat-file sources to database, including mappings and workflows, and defined source and target objects. Designed staging and target tables for ETLs.
• Liaising with London office, gathered business requirements for calculations and identified improvements through data analysis.

Technology Used: Informatica PowerMart 6.2.2, TOAD, Oracle 9.2, SQL Plus, Windows 2000

Confidential

Senior Consultant

Responsibilities:

• Managed the design, development and deployment of ETLs (data sources include GTX CRM database, customized Siebel CRM, flat files from external sources), including mappings, sessions, batches, scheduling, and administration.
• Supervised work of four internal developers.
• Provided and mentoring for the developers.
• Gathered and analyzed business requirements.
• Produced ETL documentation, including mapping spreadsheets.
• Assisted with data modeling for source and target systems to improve ETL effort.
• Assisted with data conversion of legacy data.
• Administrated Informatica server in UNIX environment.
• CMM level 4.

Technology Used: Siebel Analytics 7.5.2, Siebel Data Warehouse 7.5.2, Cognos, Informatica PowerCenter 5.1.2, TOAD, ERwin, Oracle 9.2, SQL Plus, Sun Solaris 2.8 (UNIX), Windows NT 2000 Server, SmartFTP.

ETL Architect and Lead

Confidential - Arlington, VA

Responsibilities:

• Managed the design, development and deployment ETLs using customized Siebel CRM database as a source and Siebel data warehouse as target, including mappings, session, batches, scheduling and administration.
• Gathered and analyzed business requirements.
• Produced ETL documentation, including mapping spreadsheets.
• Assisted with data modeling for source and target systems to improve ETL effort.
• Administrated Informatica server in UNIX environment.

Technology Used: Siebel Analytics 7.0.4, Siebel Data Warehouse 7.0.4, Informatica PowerCenter 5.1.2, Oracle 8.1.7, TOAD, SQL Plus, Sun Solaris 2.8 (UNIX), Windows NT 2000 Server.

ETL Architect

Confidential - Chicago, IL

Responsibilities:

• Designed, developed and deployed data warehouse architecture and ETLs, including mapping, session, batches, scheduling, and administration.
• Gathered and analyzed business requirements.
• Produced ETL documentation, including mapping spreadsheets.
• Assisted with data modeling for source and target systems to improve ETL effort.
• Administrated Informatica server in UNIX environment.

Technology Used: Informatica PowerMart 4.7.3, Oracle 8i, TOAD, SQL Plus, PL/SQL, Sun Solaris 2.7 (UNIX), Windows NT.

Confidential - Tulsa, OK

Java developer and Lead

Responsibilities:

• Mentored and trained client’s internal IT staff in design and development of Java web application using a custom navigation control frameworks solution, including gathering business requirements and analysis, as well as detailed documentation. Worked with four internal developers. Responsible for keeping developers on schedule.
• Designed and developed customer web application for new customer account registration.

Technology Used: Java, JSP, HTML, BEA WebLogic, Oracle 8i, TOAD, SQL Plus, PL/SQL.

Confidential - Secaucus, NJ

Responsibilities:

• Designed and developed stored procedures for web application that create customer account, modify account information, and retrieve account information. Acted as DBA for local development team.

Technology Used: Java, Oracle 8i, TOAD, PL/SQL, SQL Plus, Oracle DBA Studio

Confidential - Chicago, IL

Responsibilities:

• Designed and developed custom loan application. Involved meeting with users, business requirements, data modeling, developing prototype, testing, user testing, etc. Forms modules, stored procedures, triggers, and some DBA responsibilities.

Technology Used: Oracle Designer, Developer (Forms and Reports), Oracle 8i, TOAD, PL/SQL, SQL Plus

Confidential - Chicago, IL

Responsibilities:

• Designed, developed and deployed database application. Analyzed business processes, developed prototype, tested, implemented and maintained production application, as well as business consultation based on process/data analysis. Involved forms application, data migration, custom reports, database, triggers, stored procs, inventories, mailing labels, packing lists, etc. Direct impact: caused savings in excess of $2 million annually.

Technology Used: MS Access, Oracle 7, SQL Plus.

Confidential - Evanston, IL

Responsibilities:

• Designed, developed and deployed database application for two-hospital trauma center for patient satisfaction/employee performance. Analyzed business processes, developed prototype, tested, implemented and maintained production application. Forms, database, data migration, triggers, custom reports.

Technology Used: MS Access