SUMMARY

• Data Warehouse Data and ETL Architect/Analyst/Developer with over 25years 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 Confidential /UNIX and SQL Server environments
• Experience includes star schema and ETL architecture in addition to ETL development primarily using a combination of Informatica, Confidential 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, Confidential Sales Analyzer, and Metaphor

TECHNICAL SKILLS

• RDBMS
• ETL Tools
• Analysis & Design
• BI Tools
• Other Tools
• Confidential
• Informatica
• TOAD
• OBIEE
• PUTTY
• SQL Server
• SQL
• PL/SQL Developer
• Essbase
• SQL*PLUS
• Teradata
• PL/SQL & T/SQL
• SQL Analyzer
• Brio
• WinSCP
• DB/2
• UNIX & Window scripts
• ERWin
• Business Objects
• Sybase
• ODI
• ERStudio
• Cognos
• TD SQL Assistant
• Crystal Reports
• Sales Analyzer/Express

PROFESSIONAL EXPERIENCE

Confidential - Golden, CO

Data Warehouse Architect, Informatica ETL Architect, BI Technical Team Lead

Responsibilities:

• Leading the Business Intelligence technical team that includes OBIEE and Hyperion developers drawing on past experiences to provide direction, suggestions, support, mentoring and backup
• 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 Confidential ’s EBS burden logic
• Architected ETL system for new data warehouse and developed majority of mappings that integrated data from Confidential ’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 Confidential database architecture and design
• Wrote Confidential complex SQL scripts for data conversion from current data warehouse design to new design

Confidential - Littleton, CO

Informatica ETL Architect & Development Consultant

Responsibilities:

• 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 - Denver, CO

Informatica ETL Architect & Development Consultant

Responsibilities:

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

Confidential - Denver, CO

Informatica ETL Architect & Development Consultant

Responsibilities:

• 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: Confidential SQL and lookup enhancements Incorporating temporary tables Usage of Informatica transformations Database performance(e.g. Confidential parameters & table partitioning) Informatica Object reusability Data analysis using TOAD
• Performed troubleshooting on existing Informatica code to correct and/or improve ETL logic

Confidential - Denver, CO

Informatica ETL Architect & Development Consultant

Responsibilities:

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

Confidential - Denver, CO

Informatica & Confidential Database Consultant

Responsibilities:

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

Confidential - Denver, CO

Sr. Data Warehouse Analyst

Responsibilities:

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

Confidential - Denver, CO

Data Warehouse Architect & Business Intelligence Consultant

Responsibilities:

• 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 Confidential database bug fixes and enhancements
• Worked with DBA’s, Business Objects and Informatica developers and mentored junior level developers to ensure project success

Confidential - Denver, CO

Data Warehouse & Business Intelligence Consultant

Responsibilities:

• Worked with an object-oriented Confidential 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 - Denver, CO

Data Warehouse & Business Intelligence Consultant

Responsibilities:

• 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

Confidential - Erlanger, KY

Data Warehouse & Business Intelligence Consultant

Responsibilities:

• Developed 70+ ETL mappings to complement delivered EPM mappings to integrate data from Financials, Projects, Asset Management, and Human Resource systems into the ODS and data warehouse databases

Confidential - Atlanta, GA

Data Warehouse & Business Intelligence Consultant

Responsibilities:

• Architected/modeled the initial phase of the enterprise data warehouse, which integrated data from disparate sources and including GL (JD Edwards), work order (ICOMS), customer service (ICOMS), and other operational data files from field offices
• Led the ETL development team using Informatica in a multi-phase, bottom-up development effort of an Enterprise Data Warehouse within a Sun Solaris and Confidential environment

Confidential - Atlanta, GA

Data Warehouse Architect & ETL Technical Team Lead

Responsibilities:

• Led the analysis, design and development of a revenue reporting data warehouse/data mart conversion from Informix to Confidential 8i in a Sun Solaris UNIX environment
• Developed the star schema physical data model using ERWin for the Confidential 8i and Brio system
• Wrote specifications and led the ETL development using PL/SQL

Confidential - Atlanta, GA

Data Warehouse & Business Intelligence Consultant

Responsibilities:

• Led the development of a relational and OLAP data mart using and the Confidential 8i and Confidential Express/ Confidential Sales Analyzer Performed the analysis, design, and implementation of the system, which included developing a prototype for executive level sign-off
• Developed pre-sales prototype data warehouse using Oracle8, Confidential Designer, Confidential RAA/RAM, Confidential Express, and Confidential Sales Analyzer, which involved business analysis, and logical and physical data modeling After several C-Level presentations and discussions the prototype won a $500,000 consulting deal

Confidential - Atlanta, GA

Business Intelligence Consultant and Initiative Manager

Responsibilities:

• Developed a variety of business intelligence applications using Metaphor, DB/2, Star schema database, and Nielsen syndicated data for USA Operations
• Managed system life cycles, including requirements gathering, design, development, implementation, maintenance, and help desk support
• Recognized for re-establishing client confidence by emphasizing quality control and technical standards
• Managed and coordinated the system upgrade to Logility’s Logility Value Chain Solution (LVCS) client/server forecasting system for the Non-Carbonated Beverage sales forecasting group. This also involved the migration from a HP UNIX/MicroFocus COBOL file system server to an Confidential AIX/ Confidential server
• Managed and participated in the migration of the Gallon Sales forecasting system Metaphor’s client/server environment to a SAS/CLIST/MVS mainframe environment

Confidential - Atlanta, GA

Data Warehouse\Business Intelligence Consultant

Responsibilities:

• Developed a prototype application using Excel/VBA and Sagent’s Data Mart Solution software to create market analysis information from a customer-integrated database for Confidential Corporate Marketing Group
• Performed ad-hoc reporting for Small Business Marketing using UNIX, Red Brick’s DBMS, and Metaphor

Confidential - Atlanta, GA

Data Warehouse\Business Intelligence Consultant

Responsibilities:

• Led the development of an income and expense reporting system for a financial information warehouse project using Metaphor

Confidential - Cincinnati, OH

Programmer-Analyst (Co-Op)

Responsibilities:

• Developed a variety of applications for the marketing research department using Metaphor