Rocklin, CA *****
DATA ARCHITECT, DATA WAREHOUSE and DATA INTEGRATION SPECIALIST
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, team building, and guidance to my team whether on-site or off-shore. My experience includes designing all ETL processes and setting all standards for a 2.5 Petabyte Data Warehouse with many billion row tables, a custom EDI system that processed 2 billion dollars per month, a billion fact rows per month data mart, a Clinical Data Warehouse with 11 facts, 37 dimensions, and 15 aggregate facts, and a 14 subject area Enterprise Data Warehouse. Industries include biotech, health care, manufacturing, marketing, insurance and financial.
AREAS OF EXPERTISE
Data Warehouse Design, Data Warehouse Methodologies, ETL Architecture, ETL Development, Enterprise-Level Data Architecture, Data Modeling, Data Quality, Data Governance, Technical Specification Development, Performance Tuning, Source System Analysis, Test Cases and Test Plans, Report Development, 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.
* 10 years of Designing Data Warehouses, Data Modeling, and Architectural experience including Conceptual, Physical & Logical data modeling using Erwin and ER/Studio.
* 16 years of Data Integration experience, including EDI, ETL/ELT, BI, Data Warehouse, and Data Integration.
* 16 years in Application Development using SQL, 4gls, PL/SQL, T-SQL, Shell scripts, and Perl.
* 14 years of ETL experience designing, developing, and supporting Informatica Intelligent Cloud Service, Informatica PowerCenter 7, 8, 9, 10, and Informatica Big Data Edition solutions, including Integration Hub, Application Hub, Designer, Workflow Manager, Workflow Monitor, Data Explorer, Data Quality, MDM, Repository Manager, Metadata Manager, and Source Analyzer, SSIS, Business Objects Data Services and Oracle Data Integrator.
* 7 years of Report/Visualization development using Cognos, MicroStrategy, Business Objects, and Tableau.
* 7 years of Management experience. Teams ranged in size from 5-25, including on-site and off-shore resources.
California Department of State Hospitals
Informatica Architect (Sacramento, CA)
Design Enterprise Service Bus Architecture using Publish and Subscribe model using Informatica Intelligent Cloud Services.
Install, Configure, & Deploy PowerCenter 10.2 on Windows Server 2016.
Install, Configure, & Deploy PowerExchange for Mainframe on Windows.
Present High-Level Technical Architecture Plan to DSH Technical Team
Understand Current State and Design Future State Technical Architecture
Train and mentor TSD developers on the use, development, release-planning and deployment of advanced Enterprise Service Bus solution.
Develop an ADABAS Mainframe source to a Microsoft SQL Server destination using a publish and subscribe model.
Develop a multi-point REST Web Service source to single REST Web Service destination using a publish and subscribe model.
Agile/Scrum Framework for managing product development.
Environment: SQL Server 2016, Informatica Intelligent Cloud Services, PowerCenter 10.2, PowerExchange, Windows Server 2016
Kaiser Permanente (Pleasanton, CA)
Data/ETL Architect (Shared Services)
January 2018-June 2018
Data Architect designing a new Financial Data Mart to integrate POST Allocation data from Apptio into the ITBDM data warehouse.
Develop Informatica ETL processes to load data from source to staging to presentation.
Create re-usable components for all the data validation and data quality processes.
Environment: Oracle 11g, Informatica 10.1, Red Hat Enterprise Linux, MDM, ERWin, BOX
Miami Children's Hospital (Miami, FL)
September 2017-January 2018
Data Architect designing new Clinical and Financial Enterprise Data Warehouse using TOGAF framework
BI Architect designing new presentation layer for BI Analytics
Data Governance Program Lead
Agile development with daily scrums and 2 week sprints.
Create ETL to load PeopleSoft HR data to the Data Warehouse using Impala
Environment: Oracle, Informatica 9.6, Cerner and Power Insight, ERWin, Impala, Cloudera Hadoop
BBA Aviation (Orlando, FL)
July 2017-September 2017
Data Architect designing new HR Data Warehouse using TOGAF framework
Data Modeling of new Staging, Integration, and Presentation layers.
Started Data Governance Program
Create ETL for Cloud Sources
Environment: SQL Server 2012, SAP Business Objects, ER/Studio, Taleo, Fusion
Office Depot (Boca Raton, FL)
Data Warehouse Lead/Solution Architect (Marketing and Ecommerce)
July 2016-July 2017
Leads the Data Warehouse development team in overall application technology design activities, ETL jobs, Reporting Data Marts, and Teradata ETL BTEQ script creation.
Designed and created new Fraud Data Mart.
Designed and created new Loyalty Program Data Mart.
Created Cognos and MicroStrategy reports for Loyalty Program
Data Governance Team Lead
Agile development with daily scrums, 2 week sprints, sprint planning and review sessions.
Environment: Red Hat Enterprise Linux, Teradata 15, Informatica 9.6, MicroStrategy, Cognos, GITHUB
Pfizer Analytics Lab (San Diego, CA)
October 2015 – June 2016
Customer Insight Explorer - Pfizer Analytics Lab. Pfizer Analytics Lab is an integrated data management and analytics platform that enables "BIG Data” analytics. Load iMed/PRIMA unstructured data into Pfizer Analytics Lab Aster database using analytical algorithms and analytic functions for performing Sentiment Analysis, Tokenization, Similarity Analysis, Stop Word Identification, Co-Term Frequency Analysis, Named Entity Recognition, Controlled Vocabulary Identification, and Product Identification.
Create Visualizations of the data using Tableau
Environment: Red Hat Enterprise Linux, Teradata 15, Aster 6.1, Informatica 9.6, Tableau
San Diego Gas & Electric (San Diego, CA)
May 2015 – October 2015
Lead Architect for a re-design of the Customer Data Warehouse, including Database, ETL and Stored Procedures. Changes included Fact tables, Dimension tables, Anchor tables, and Relationship tables. Re-designed the data model, modified the tables, and re-wrote the ETL. The Data Warehouse has 16 fact tables, 21 aggregate fact tables, 47 dimension tables, 34 detail tables, 21 anchor tables, and 31 relationship tables.
POC for Customer Data Lake in HDFS (Hortonworks) using HiveQL and Pig.
Environment: SQL Server 2012, SSIS, Informatica Powercenter 9.5, Hadoop, Hive, Pig, SalesForce.com.
Teksystems Global Services (San Diego, CA)
December 2014 – May 2015
Practice Architect for all West Coast projects.
Architect for all ETL and Data Warehouse systems and databases. Provide design, review, validation, approval, and developer leadership for all client requests ensuring compliance with corporate standards.
Lead Architect for Qlikview Dashboard, Informatica upgrade, and Hadoop ODS projects.
Environment: Oracle 11g, OBIEE, Teradata, Informatica Powercenter 9.6, Informatica Big Data Edition, SAP, PowerExchange for SAP, SalesForce.com, Hadoop, Hive, Pig.
Opera Solutions (Del Mar, CA)
July 2014 – December 2014
Lead Data Architect implementing Operational Analytics & Fraud Surveillance for the Health Insurance Marketplaces being implemented as a result of the Affordable Care Act.
Design and deliver the data infrastructure required to support predictive modeling and analytics
Data Architect for all ETL and Data Warehouse systems and databases. Provide design, review, validation, approval, and developer leadership for all fulfillment requests ensuring compliance with corporate standards.
Application performance and user quality of experience analysis, network and customer usage behavioral analysis, and data warehouse, analytics, and report development with Cognos.
Agile development with daily scrums and 2 week sprints.
Environment: Oracle 11g, SQL Server 2012/2008, Linux, Erwin, PL/SQL, Cognos, Hadoop, Hive, Pig.
SynteractHCR (Carlsbad, CA)
Nov 2013 – July 2014
EIM Architect for all projects relating to the Clinical Data Warehouse and the Business Data Warehouse.
Re-designed the Clinical Data Warehouse, including ETL, Stored Procedures, Universe Design, Report Design, and Database Design. System was created by an outside company and it never worked. Re-designed and fixed all the problems. The Data Warehouse has 11 fact tables, 15 aggregate fact tables, and 37 dimension tables.
Created Client/Project specific reports using Business Objects
Environment: SAP BusinessObjects 4.1 Data Services, Web Intelligence, Explorer, Dashboard Design, Information Design Tool, Information Platform Services, SalesForce.com, Cerner, Rave, Argus, SSIS, SSRS, T-SQL, MDM, SQL Server 2012/2008, Oracle 11g, ERStudio.
Catalina (St. Petersburg, FL)
Mar 2013 – Nov 2013
Lead Informatica Architect responsible for SOA Architecture and the Integration Competency Center.
Started Data Governance Program from scratch
Member of Architecture Review Board
Designed Informatica Architecture for 4 new Informatica instances.
Created all best practices and standards documents, including Development Standards, Administration Standards, Operational Standards, Architecture Standards, and Design and Review processes and documents.
Lead Architect for SalesForce.com, Multi Domain MDM Hub, and Real-Time Web Services projects.
Created Informatica developer training material and ran classes for all new developers.
Environment: Informatica PowerCenter and Informatica Big Data Edition, IDQ, MDM, Metadata Manager, PowerExchange for Netezza, SalesForce.com, PowerExchange for SalesForce.com, SSIS, Hadoop, Hive, Pig, Netezza, Oracle 11g, OBIEE, MySQL, ERStudio, and MicroStrategy.
JM Family (Deerfield Beach, FL)
Sr. ETL Consultant
Jan 2013 – Mar 2013
Lead a Data Integration project to create a new purchasing and supplier system to transfer data from an existing Lawson system to a new Ariba system. Created Technical Specification Documentation, performed Source System Analysis, lead Data Mapping meetings, and performed Data Integration Development.
Environment: Informatica PowerCenter 9.1, Oracle 11g, SQL Server, Cognos, DB Visualizer, UNIX.
BankUnited (Miami Lakes, FL)
Sr. ETL Consultant
Sept 2012 – Jan 2013
Lead a Data Integration project to convert an underwriting and analytics software platform that includes risk assessment, risk based pricing, and regulatory compliance for all commercial loan classes from Experian to Moody's software platform. Created Technical Specification Documentation, performed Source System Analysis, lead Data Mapping meetings, and performed Data Integration Development.
Environment: Informatica PowerCenter 9.1, Oracle 11g, SAP, PowerExchange for SAP, SQL Server, PL/SQL, Toad, UNIX, Cognos, OBIEE.
Kaiser Permanente (Pleasanton, CA)
Sr. ETL Developer/Consultant Specialist
Oct 2011 – Sept 2012
Lead consultant for the 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.
Lead consultant for the Consumer Directed Health Care (CDHC) replacement program. This is an HRA system for Claims Eligibility and Claims Extracts. The new solution will support a broader scope of products which includes many flavors of HRA, HSA and FSA products.
Environment: Informatica PowerCenter 8.6, MDM, ERwin 7.2, Oracle 11g, PL/SQL, OBIEE, SQL Developer, UNIX, Cognos, Toad.
Sony Playstation (San Diego, CA)
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.
Performed all Data Modeling for any changes or additions to the Data Warehouse.
Started Data Quality program and created charter for new Data Governance program.
Agile development with daily scrums and 4 week sprints.
Environment: Informatica PowerCenter 8.6/9.1, Data Explorer, Metadata Manager, MDM, ERwin 7.2, Oracle 11g, MySQL, SQL Server 2008, Toad, PL/SQL, UNIX, Cognos.
Life Technologies (Carlsbad, CA)
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, SAP, PowerExchange for SAP, Oracle 11g, Toad, UNIX, Cognos, Business Objects, Cerner.
Sony Electronics (San Diego, CA)
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.
Data Governance Committee Member
Environment: Informatica PowerCenter 8.6, MDM, Metadata Manager, SAP, PowerExchange for SAP, ERwin 4.1, Oracle 10g, SQL Server 2008, Toad, PL/SQL, UNIX, Cognos, Business Objects, and Crystal Reports.
Coventry Health Care (Sunrise, FL)
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, SSIS, SQL Server 2005, AIX, Cognos.
Lynn Insurance (Boca Raton, FL)
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, SSIS, SSRS, SQL Server 2005, Cognos.
Fresenius Medical Care (Nashville, TN)
Data Integration Manager
June 2007 – May 2008
Managed all development and support efforts for the Data Integration/Data Warehouse team.
Hiring, firing, team building, and management of Architects, Developers and Administrators, including contracted Developers for all Data Integration/Data Warehouse projects. Team size consisted of up to 20 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.
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.
Environment: Informatica PowerCenter 7 and 8, Informatica PowerExchange for SalesForce.com, Informatica PowerExchange for SAP, MDM, eGate, HL7, Oracle Data Integrator, ERwin 4.1, Oracle 10g, PL/SQL, MySQL. SQL Server, SSIS, SSRS, Cognos, PeopleSoft, SAP, Toad, and Unix.
Capgemini (Consultant at Royal Caribbean (twice) - Miramar, FL, JM Family - Deerfield Beach, FL, and Compass Bank - Birmingham, Alabama)
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 9g and 10g, PL/SQL, SQL Server 2005, SSIS, Siebel, Crystal Reports, Essbase, Brio, Peoplesoft, SAP, Toad, and Unix.
Tyco Safety Products (Boca Raton, FL)
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 custom Enterprise MDM solution.
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, MDM, ERwin 4.1, MicroStrategy 7, SQL Server, Oracle 9i, PL/SQL, Baan IV, Baan V, JD Edwards, PeopleSoft, Pronto, Toad, SQL Developer, and Unix.
Hartford University - Bachelor of Science in Computer Science with a 3.5 GPA - Courses included Applications Programming, Database Management, Advanced Database Management, Advanced Database Research, Object-Oriented Systems, Systems Analysis and Design, and Network Security.
The Data Warehouse Institute Training – 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.
AWS Cloud Training - AWS Certified Solutions Architect – Courses included Identity Access Management (IAM), Databases on AWS, VPC, Route53, Application Services, and Kinesis.