DATA WAREHOUSE and DATA INTEGRATION SPECIALIST
I have been in the software development field for more than 25 years. I have provided numerous Fortune 500 companies with full life cycle software development including requirements definition, design, architecture, development, testing, implementation and support. I have experience as a manager, architect and team leader, providing motivation and guidance to my team whether on-site or off-shore. My experience includes a multi-terabyte database with a billion row table, a custom EDI system that processed 2 billion dollars per month, a billion fact rows per month data mart, and a 14 subject area Enterprise Data Warehouse. Industries include health care, manufacturing, insurance and financial.

AREAS OF EXPERTISE
Data Warehouse Design, Data Warehouse Methodologies, ETL Architecture, ETL Development, Enterprise-Level Data Architecture, Data Modeling, Technical Specification Development, Performance Tuning, Source System Analysis, Test Cases and Test Plans, Requirements Definition, Quality Assurance, High Data Volume Processing, Troubleshooting, Error Handling Strategies, Integration Management, Resource Selection and Management, Training and Mentoring, Team and Project Leadership, Vendor Selection and Management

TECHNICAL PROFICIENCIES

• 25 years of experience in the software development industry, with an emphasis on full life cycle software development using best practices.
• 15 years of Data Integration experience, including EDI, ETL, Data Warehouse, and Data Conversion.
• 15 years in custom application development using 4gls, PL/SQL, SQL, Unix Shell scripts, Perl, and COBOL.
• 12 years of experience designing and developing custom, integrated, enterprise wide EDI solutions.
• 10 years of management experience. Teams ranged in size from 5-15, including off-site and off-shore resources.
• 10 years of Data Modeling and Architectural experience including Physical & Logical data modeling using Erwin 3.5 and 4.1.
• 10 years of developing Business Intelligence and Data Warehousing solutions.
• 10 years of source and target analysis, data profiling, data cleanliness, ETL mappings, ETL workflows, and performance tuning.
• 8 years of designing, developing, and supporting Informatica PowerCenter 7 and 8 solutions, including Designer, Workflow Manager, Workflow Monitor, Repository Manager, PowerExchange and PowerConnect.

Professional Experience

Confidential
Sr. ETL Developer/Consultant Specialist
Oct 2011 - Present

• Senior Data Warehouse Engineer to create OPPR Program, a claims processing system to enable the synchronization of member and eligibility data to adjudicate all of the “commercial” pharmacy claims with a Pharmacy Benefit Management system at MedImpact.

Environment: Informatica PowerCenter 8.6, ERwin 7.2, Oracle 11i, PL/SQL, SQL Developer, UNIX, Cognos, Microsoft Office, Windows XP.

Confidential
ETL Architect/Analyst
Oct 2010 – Oct 2011

• Senior Data Warehouse Engineer for all ETL and Data Warehouse systems and databases for VIP. Provide analysis, design, development, review, validation and code review for all Informatica and Oracle project and fulfillment requests for all new game platforms.
• Performed all Informatica Administration for versions 8.6 and 9.1 and upgraded Informatica from 8.6.1 to 9.1
• Performed all source analysis of new game platforms using Informatica Data Explorer.

Environment: Informatica PowerCenter 8.6/9.1, ERwin 7.2, Oracle 11i, Toad, PL/SQL, UNIX, Cognos, Microsoft Office, Windows XP.

Confidential
Data Architect/Data Modeler 
July 2010 – Oct 2010

• Data Warehouse Architect, Data Modeler and Lead Developer for all ETL and Data Warehouse systems and databases.
• Provide analysis, design, review, validation and approval for all Oracle database requests ensuring compliance with Corporate Data Warehouse standards.

Environment: Informatica PowerCenter 8.6, ERwin 7.2, Oracle 11i, Toad, PL/SQL, UNIX, Cognos, Business Objects, Microsoft Office, Windows XP.

Confidential
Solution Architect/Lead Analyst
Aug 2009 – July 2010

• Data Warehouse Architect/Lead Analyst/Lead Developer for all ETL and Data Warehouse systems and databases. Provide design, review, validation, approval and offshore developer leadership for all Informatica and Oracle project and fulfillment requests ensuring compliance with Corporate Data Warehouse standards.
• Data Warehouse Architect/Lead Analyst/Lead Developer for the Sales reporting (B2B, B2C and supply chain), Call Center reporting (sales, customer service and repair) and Inventory reporting Data Marts.

Environment: Informatica PowerCenter 8.6, ERwin 4.1, Oracle 10g, Toad, PL/SQL, UNIX, Cognos, Business Objects, Microsoft Office, Windows XP.

Confidential
ETL Architect/Lead Analyst
Dec 2008 – August 2009

• ETL Architect/Lead Analyst for the extraction, transformation and loading of data from the Vista Health Plans Enterprise Data Warehouse to the Coventry Health Plans Enterprise Data Warehouse.
• Data included all encounters for Private, Group and Medicaid plans for Pharmacy, Vision, Dental and Mental Health claims plus all providers, labs, premiums and capitations.
• ETL Architect/Lead Analyst for the extraction, transformation and loading of data from the Mutual of Omaha Health Plans Enterprise Data Warehouse to the Coventry Health Plans Enterprise Data Warehouse. Data included all claims and premiums for Government, Private and Group plans.
• Responsible for resource estimation and allocation for all projects in the Vista Data Warehouse Group.
• Lead and provide direction to Informatica developers.
• Provide weekly project reports on status and issues to management.
• Train and mentor other staff members on all aspects of Informatica PowerCenter, including maps, maplets, transformations, sessions, workflows, worklets and deployment groups.

Environment: Informatica PowerCenter 8.1, ERwin 4.1, Oracle 10g, PL/SQL, SQL Server 2005, AIX, Cognos, Microsoft Office, Windows XP.

Confidential
Sr. ETL Consultant
May 2008 – Nov 2008

• Team lead for the design and creation of a Claims Data Mart as part of the Enterprise Data Warehouse. The Data Marts used the Ralph Kimball methodology, 5 star schemas with conformed dimensions and fact tables.
• Created all training materials and held a bi-weekly class in designing, creating and testing Informatica PowerCenter 8 including maps, maplets, transformations, sessions, workflows and worklets using Designer, Workflow Manager, Workflow Monitor and Repository Manager.

Environment: Informatica PowerCenter 8.1, ERwin 4.1, SQL Server 2005, Cognos, MS Office, Windows XP.

Confidential
Data Integration Manager
June 2007 – May 2008

• Managed all development and support efforts for the Data Integration/Data Warehouse team.
• Hired, fired and managed Architects, Developers and Administrators, including contracted Developers for all Data Integration/Data Warehouse projects. Team size consisted of up to 15 members.
• Developed vision and strategy for building the Data Integration/Data Warehouse team. Selected and developed staff to meet plans and objectives. Conducted regular team meetings to facilitate team goals.
• Facilitated and conducted business team meetings with other team leaders to identify and meet company goals and strategies and to increase communication between groups.
• Provide weekly reports on status and issues to upper management.
• ETL Architect for the design of a Data Mart to hold Salesforce.com data and the Informatica processes to extract the Salesforce.com data into the Data Mart and the Enterprise Data Warehouse.
• ETL Architect/Developer for the design and creation of a 5 Star Financial Data Mart as part of the Enterprise Data Warehouse. Analyzed source systems and source data, created technical design specs, created complex map designs, created error handling and update strategies, created test plans and test cases and lead the deployment of all objects. The Data Marts used the Ralph Kimball methodology, 5 star schemas with conformed dimensions and fact tables. Project used Informatica\'s Velocity Methodology.
• ETL Architect for the upgrade of Informatica from Version 7.1.5 to version 8.1.5.
• ETL Architect/Developer for the design and creation of an ETL interface from PeopleSoft to 2 different SAP systems in 2 different divisions.

Environment: Informatica PowerCenter 7 and 8, Informatica PowerExchange for SalesForce.com, Informatica PowerExchange for SAP, eGate, HL7, Business Objects Data Integrator, ERwin 4.1, Oracle 10g, PL/SQL, Cognos, PeopleSoft, SAP, TOAD, Microsoft Office, Windows XP, and Unix.

Confidential
Sr. Lead Consultant
Jan 2006 – June 2007

• Technical Architect for 2 assessment and recommendation projects at a major cruise line. Accessed the current system and recommended upgrades and modifications to ETL processes and Data Mart structures. Recommendations were accepted and our company was signed up for the 2 projects.
• Lead ETL Architect/Developer for the design and creation of 2 new Data Marts with bi-directional links to Siebel Analytics and Siebel CRM as part of the Enterprise Data Warehouse for a major cruise company. Analyzed Siebel source systems and source data, created functional and technical designs, created complex map designs, created error handling and update strategies and created test plans and test cases. The Data Marts used the Bill Inmon methodology. The Enterprise Data Warehouse included staging, data store and presentation areas.
• Lead Developer for the design and creation of a Data Warehouse for a major automotive leasing company. Created a Loan Originations Data Mart with 5 subject areas using the Velocity Methodology. The system consisted of 3 layers, the staging area, the integration area and the reporting area. Modified physical data models using Erwin, performed ETL design, ETL Development, Error handling, creation of ETL standards and best practices, creation of ETL test plans and mentoring junior team members.

Environment: Informatica PowerCenter 7 and 8, ERwin 4.1, Oracle 9i and 10g, PL/SQL, Siebel, Essbase, Brio, Peoplesoft, SAP, TOAD, Microsoft Office, Windows XP, and Unix.

Confidential
Lead Data Integration Analyst/Data Modeler
Oct 2002 to Jan 2006

• Lead all Onshore and Offshore Informatica Development. Lead a team of 2 onshore and 6 offshore developers for multiple Data Warehouse projects. Designed all process models for software development, including onshore and offshore development.
• Gathered user requirements, analyzed source systems and source data, designed logical and physical data models using ERwin, created functional and technical designs, performed complex map development using Informatica PowerCenter 7 Designer, created sessions, worklets and workflows using Workflow Manager, performed unit, integration and system testing, performed component migration using Repository Manager and supported ETL processes using Workflow Monitor
• Designed and developed Global Revenue data warehouse that extracts, transforms and loads source data from ERP source systems around the world to provide visibility to revenue data at 9 source locations.
• Used the Ralph Kimball methodology, star schemas with conformed dimensions and fact tables.
• Performed administration of Informatica PowerCenter 7 including managing and scheduling workflows, managing components, migrations, deployments, security, users and repositories.
• Performed logical and physical data modeling as well as database creation and modification for Global Inventory, Global Revenue and Global Demand Planning data warehouses using Erwin.
• Performed bulk extracts as well as change data capture (CDC) from remote systems using POWER CONNECT (DETAIL NAVIGATOR).

Environment: Informatica PowerCenter 7, Informatica PowerExchange, Detail Navigator, ERwin 4.1, MicroStrategy 7, SQL Server, Oracle 9i, PL/SQL, Baan IV, Baan V, JD Edwards, PeopleSoft, Pronto, TOAD, SQL Developer, Microsoft Office, Windows XP/NT/2000, and Unix.

Confidential
Data Warehouse Specialist 
Feb 2002 to Oct 2002

• Designed and developed custom ETL processes to populate the data warehouse and downstream data marts
• Performed a complete re-design of all the Oracle Triggers and Packages using Toad.
• Created database packages, procedures, functions, cursors and triggers using PL/SQL.

Environment: HP UNIX, Korn Shell Scripts, PL/SQL, SQL, Perl, ERwin 3.5, Oracle 8i and 9i, TOAD, Microsoft Office, and Windows NT/2000.

Confidential
EDI Manager/Supply Chain and E-Business
Apr 1993 to Feb 2002

• Lead all development efforts for the E-Business team. Hired, fired and managed all the developers including all contracted developers for all EDI and E-Business projects.
• Performed presentations of all new projects to upper management.
• Single point of contact for all software, user and database development and support for all Enterprise Network Logistics and Distribution EDI Systems world wide that processed as much as 2 billion dollars of orders a month.
• Analyzed, designed, coded and tested 5 different Enterprise Networks Logistics and Distribution EDI Interface systems including a multi-company version, a Canadian version, a European version and a Latin American version.
• Performed logical and physical data modeling as well as database creation and modification using ERwin.

Environment: HP (MPE and UNIX), Microfocus COBOL, UNIX Shell Scripts, Maestro, Powerhouse, Oracle, PL/SQL, SQL, ERwin, Gentran, Mercator, X12, Microsoft Office, and Windows.

Confidential, Taylor, Wells
Systems Analyst and Project Lead
Dec 1989 to Apr 1993

• Contract Systems Analyst for a consulting company. Clients included Revlon, 3M, Northern Telecom, and Collier Jackson performing upgrades and enhancements to ERP, manufacturing, and financial systems.

Confidential, CBL, Tylan 
Programmer and Systems Analyst
Mar 1986 to Nov 1989

• Started as a programmer analyst for a grocery distribution company and ended as a Systems Analyst for a hi-tech manufacturing company supporting and upgrading ERP, Finance, and Warehouse Management Systems.

Education History Bachelor of Science in Computer Science - Courses included Applications Programming, Database Management, Advanced Database Management, Advanced Database Research, Object-Oriented Systems, Systems Analysis and Design, and Network Security.Courses included Data Warehousing Concepts and Principles, Data Warehousing Architectures, Data Modeling I, Data Modeling II, Intermediate Dimensional Modeling, Advanced Dimensional Modeling, and Emerging Technologies.Informatica Training – Introduction to PowerCenter 7, Advanced PowerCenter 7, PowerCenter 7 Metadata Management, and PowerCenter 7 Performance Tuning.Computer Associates Training - Computer Associates Model Manager, ERwin Data Modeler, and BPwin Business Process Modeler.The Project Management Excellence Center – PMP Review - Framework, Integration Management, 
Scope Management, Time Management, Cost Management, Quality Management, Human Resource Management, Communications Management, and Risk Management.