|
Jeff Fogarty |
|||
|
400 South 4th Street, Apt 1409, St. Louis, MO 63102 |
|||
|
314.753.2279 |
|||
|
jeff@fogarty.org |
|||
Summary |
Seasoned data warehouse/ETL architect and manager with 13 years of IT experience. Designed, developed and implemented enterprise data warehouse solutions with customer and financial data. Expert in dimensional modeling on various database platforms. Ability to communicate well at all levels of the organization.
|
||
Areas of Expertise |
· Data Warehouse Architect · ETL Architect · Informatica PowerCenter · Mentor · Team Lead and Manager · Informatica PowerExchange |
||
Experience |
US Bank. |
2006-Present |
|
|
|
ETL Manager / Data Warehouse Architect Lead the development team for the data extraction part of US Bank’s data warehouse. Lead a team of 5 ETL Developers in the following area; · Influenced the database design to follow the dimensional conformed method. · PowerCenter Proof of Concept. · Selected the PowerCenter Server platform. · Installed PowerCenter in the Development, Integrated Testing, User Acceptance Testing and Production environments. · Created Unit testing policies and procedures. · Created Migration plan to adhere to US Bank’s Separation of Duty policy. · Applied US Bank’s SOX policy to PowerCenter UAT and Production environments · Designed and Developed PowerCenter jobs (mappings, workflows, etc…) to load the data warehouse. · Conducted performance evaluations on team members. · Mentored team members with PowerCenter development, troubleshooting and documentation. · Developed Production Support policy and procedures. · Conducted Interviews for new employees and consultants.
|
||
|
|
JT Fogarty, INC |
2003-2006 |
|
|
|
ETL Consultant |
||
|
|
|
US Bank |
2006 |
|
|
Conducted Proof of Concept for PowerCenter Informatica. Influenced the database design to follow the dimensional conformed method. Designed and Developed PowerCenter jobs (mappings, workflows, etc…) to load the data warehouse. Mentored PowerCenter developer. |
||
|
|
|
John Deere |
2005 |
|
|
Designed and developed new ETL process using PowerCenter 7.x Produced ETL documentation. |
||
|
|
|
W.W. Grainger Inc |
2005 |
|
|
Upgraded PowerCenter from 6.x to 7.1.3. Provided production support. |
||
|
|
|
Missouri Department of Transportation |
2004-2005 |
|
|
Installed and tested new version of PowerCenter. Analyzed performance issues and recommended changes. Informatica Administrator Translated business requirements into Informatica mappings/workflows. Supplied mentoring on mapping design, workflow logic and scheduling |
||
|
|
|
Knowledge Based Marketing |
2004 |
|
|
Assisted in the development of ETL process for new client |
||
|
|
|
Public Company Accounting Oversight Board |
2003 |
|
|
Worked with a team to developers a billing system for PCAOB using market capitalization data. |
||
|
|
Reinsurance Group Of America, INC |
2000-2003 |
|
|
|
Data Warehouse Developer Initiated a data warehouse to aid actuaries in their analysis process. Designed, implemented and tested data marts using Oracle PL/SQL to populate dimensions and fact tables. Installed and administered MicroStrategy as the BI reporting tool for data marts. |
||
|
|
Daugherty Systems |
1998-2000 |
|
|
|
Application Developer Visual Basic Development. |
||
|
|
TALX, INC |
1997-1998 |
|
|
|
Application Developer Visual Basic Development. |
||
Education |
|
|
|
|
|
Webster University |
1999-2001 |
|
|
|
M.A. Computer Resource Management |
||
|
|
Embry-Riddle Aeronautical University |
1983-1990 |
|
|
|
B.S. Aviation Technology Studied Aviation Maintenance and Electronics Holds FCC First Class Radiotelephone License Holds FAA Maintenance Licenses |
||