SUMMARY

• Data Warehouse Data and ETL Architect/Analyst/Developer with over 24years experience in IT/DW/BI
• Strong analytical, problem solving, and data analysis skills
• Led efforts in the technical design and construction of business intelligence systems primarily in Oracle/UNIX and SQL Server environments
• Experience includes star schema and ETL architecture in addition to ETL development primarily using a combination of Informatica, Oracle PL/SQL, SQL, and UNIX/Windows scripting
• Been responsible for working with business users to define their decision support needs and the development of business intelligence applications using tools such as Crystal Reports, Oracle Sales Analyzer, and Metaphor

TECHNICAL SKILLS Primary

WORK EXPERIENCE

Confidential

Data Warehouse Architect, Informatica ETL Architect, Technical Team Lead

• Designing new dimensional and integration tier database models for existing data warehouse and new future version of data warehouse environment
• Designing new ETL/Informatica architecture and mappings after researching solutions to existing complex problems such as NREL's FTE calculations and burdening of plan data using Oracle's EBS burden logic
• Architected ETL system for new data warehouse and developed majority of mappings that integrated data from Oracle's EBS Project accounting, General Ledger, Human resources , Hyperion Planning and Funding, IP Manager SQL Server and a variety of user-maintained spreadsheets/flat files
• Created ETL process control that includes parameter files, command line processing, trigger files, and a PL/SQL package with data warehouse-related procedures and functions e.g. truncating partitions
• Created non-data warehouse ETL system for outbound files going to cloud provider using Informatica's SFTP
• Created all ETL development standards and performed code reviews and migrations
• Mentored junior and midlevel developers on Informatica development and standards
• Worked closely with users' business analyst on dashboard requirements followed by performing the data modeling and creating source-to-target specifications for Informatica team member
• Provided assistance on Oracle database architecture and design
• Wrote Oracle complex SQL scripts for data conversion from current data warehouse design to new design

Confidential

Informatica ETL Architect Development Consultant

• Architected and developed ETL process using Informatica for new Product Activity BI system
• Performed data and business analysis in support of design and development
• Created Product Activity ETL support document due to the complexity of transformation rules

Confidential

Informatica ETL Architect Development Consultant

Confidential

• Partnered in the ETL architecture and standards development
• Converted existing Oracle ODI ETL programs for an Oracle data warehouse to Informatica for a Teradata data warehouse using SQL Server, Oracle and DB/2 data sources
• Used Teradata's export/load utilities and Informatica's push-down optimization

Confidential

Informatica ETL Architect Development Consultant

Confidential

• Analyzed, redesigned and reprogrammed different aspects of Informatica mappings, sessions, and workflows, as well as, ETL and database architecture to improve performance and maintainability and included:

• Performed troubleshooting on existing Informatica code to correct and/or improve ETL logic

Confidential

Informatica ETL Architect Development Consultant

Confidential

• Led ETL Development using Informatica in an Oracle and SQL Server environment
• Made improvement decisions on data warehouse architecture, data model, and Informatica code
• Responsible for the design and development of special projects using Informatica

Confidential

Informatica Oracle Database Consultant

Confidential

• Led development of building interfaces using Informatica and writing extensions as Oracle PL/SQL packages UNIX scripts, between TriZeto's Facets Oracle database and DB/2 mainframe accounting database, SAP, and various other systems

Confidential

Sr. Data Warehouse Analyst

Confidential

• Modified Informatica mappings and Sybase data structures in support of reporting system

Confidential

Data Warehouse Architect Business Intelligence Consultant

Confidential

• Architected and modeled data warehouse third normal and data marts star schema tables using ERWin that integrated data from the work order and asset management system PassPort and GL JD Edwards
• Led effort to provide business metrics for upper management by integrating data from disparate systems, such as JD Edwards financials and billing and customer service systems and generating information from that data into presentation form Excel graphs and reports
• Performed troubleshooting and created technical specifications for Informatica, Business Objects, and Oracle database bug fixes and enhancements
• Worked with DBA's, Business Objects and Informatica developers and mentored junior level developers to ensure project success

Confidential

Data Warehouse Business Intelligence Consultant

Confidential

• Worked with an object-oriented Oracle database design for the ChannelWave sales lead management system to develop high-performing views and used those views to create Crystal Reports for Sales and Marketing analyst and managers

Confidential

Data Warehouse Business Intelligence Consultant

Confidential

• Performed data extractions from SAP for data analysis using TOAD and loaded SAP data into the data warehouse using Informatica and Informatica's SAP PowerConnect application
• Developed standard reports using Crystal Reports that include trending analysis and other extended features of Crystal Reports 9.0 and managed report publication via Crystal Enterprise