SUMMARY:

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, 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:

• 15 years of Data Integration experience, including EDI, ETL/ELT, BI, Data Warehouse, and Data Integration.
• 15 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 PowerCenter 7, 8, 9, and Informatica Big Data Edition solutions, including 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.
• 10 years of Data Modeling and Architectural experience including Conceptual, Physical & Logical data modeling using Erwin and ER/Studio.
• 7 years of Management experience. Teams ranged in size from 5-25, including on-site and off-shore resources.

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

Data/BI Architect

Responsibilities:

• Data Architect designing new Clinical and Financial Enterprise Data Warehouse
• BI Architect designing new presentation layer for BI Analytics
• Created 5 year One Florida hospital submission files on Hadoop/Impala/HiveQL
• Agile development with daily scrums

Environment: Oracle, ERWin, Informatica, Oracle, SQL Server, SQL, Cerner and Power Insight, Hadoop (Cloudera), HiveQL, Impala, MDM, PeopleSoft

Confidential, Orlando, FL

Data/BI Architect

Responsibilities:

• Data Architect designing new HR Data Warehouse
• Data Modeling of new Staging, Integration, and Presentation layers.
• ETL creation of templates for cloud access
• Started Data Governance Program

Environment: Oracle, ERStudio, Business Objects Data Services, SQL, PeopleSoft HR, Taleo Cloud, Fusion Cloud, Oracle, SQL Server, MDM

Confidential, Boca Raton, FL

Solution Architect/Data Warehouse Lead

Responsibilities:

• 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.
• 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, PeopleSoft, SQL, Cognos

Confidential, San Diego, CA

BI Architect

Responsibilities:

• Confidential Analytics Lab is an integrated data management and analytics platform that enables "BIG Data” analytics. Load iMed/PRIMA unstructured data into Confidential 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.

Environment: Red Hat Enterprise Linux, Teradata 15, Aster 6.1, Informatica 9.6, SQL, Tableau

Confidential, San Diego, CA

ETL Architect

Responsibilities:

• 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.

Environment: SQL Server 2012, SSIS, Informatica Powercenter 9.5.1, Hadoop, Hive, Pig, SQL, SalesForce.com.

Confidential, San Diego, CA

Practice Architect

Responsibilities:

• 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.

Confidential, Del Mar, CA

Data Architect

Responsibilities:

• 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.
• Agile development with daily scrums and 2 week sprints.

Environment: Oracle 11g, SQL Server 2012/2008, Linux, Erwin, PL/SQL, Hadoop, Hive, Pig.

Confidential, Carlsbad, CA

BI Architect

Responsibilities:

• 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.

Environment: SAP BusinessObjects 4.1 Data Services, Web Intelligence, Explorer, Dashboard Design, Information Design Tool, Information Platform Services, SQL, SalesForce.com, PeopleSoft HR, Cerner, Rave, Argus, SSIS, SSRS, T-SQL, MDM, SQL Server 2012/2008, Oracle 11g, ERStudio.

Confidential, St. Petersburg, FL

Informatica Architect

Responsibilities:

• 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, SQL, SalesForce.com, PowerExchange for SalesForce.com, SSIS, Hadoop (HortonWorks), Hive, Pig, Netezza, Oracle 11g, OBIEE, MySQL, ERStudio, and MicroStrategy.

Confidential, Deerfield Beach, FL

Sr. ETL Consultant

Responsibilities:

• 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, SQL, Cognos, DB Visualizer, UNIX.

Confidential, Miami Lakes, FL

Sr. ETL Consultant

Responsibilities:

• 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 Confidential to Confidential '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, SQL, SAP, PowerExchange for SAP, SQL Server, PL/SQL, Toad, UNIX, Cognos, OBIEE.

Confidential, Pleasanton, CA

Sr. ETL Developer/Consultant Specialist

Responsibilities:

• Lead consultant for the Confidential 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 Confidential .
• 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.

Confidential, San Diego, CA

ETL Architect/Analyst

Responsibilities:

• 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.

Confidential, Carlsbad, CA

Data Architect/Data Modeler

Responsibilities:

• 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.

Confidential, San Diego, CA

Solution Architect/Lead Analyst

Responsibilities:

• 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 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.

Confidential, Sunrise, FL

ETL Architect/Lead Analyst

Responsibilities:

• 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.