We provide IT Staff Augmentation Services!

Data Warehouse Lead/solution Architect Resume

4.00/5 (Submit Your Rating)

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, BI, Data Warehouse Design, and Data Integration.
  • 15 years in custom application development using SQL, 4gls, PL/SQL, Unix Shell scripts, Perl, Hadoop, Hive and PIG.
  • 15 years of Data Modeling and Architectural experience including Physical & Logical data modeling using Erwin and ERStudio.
  • 13 years of management experience. Teams ranged in size from up to 15, including on-site and off-shore resources.
  • 12 years of ETL. Designing, developing, and supporting Informatica PowerCenter 7, 8, 9, and Informtica 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.

PROFESSIONAL EXPERIENCE:

Confidential

Data Warehouse Lead/Solution Architect 

Responsibilities:

  • Guides and leads the Data Warehouse development team in overall application technology design activities, ETL jobs, and Teradata ETL BTEQ script creation.
  • Leads the identification and definition of key architectures, components and interfaces, design of data model and data/information flows.
  • Assesses the business and organizational implications of key application technology alternatives for wide-impact initiatives and recommends appropriate action.

Environment: Red Hat Enterprise Linux, Teradata 15, DataStage, MicroStrategy

Confidential

BI Architect

Responsibilities:

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

Confidential

ETL Architect

Responsibilities:

  • Re-designed 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.
  • Informatica Upgrade from 8.6 to 9.1, 9.5 and 9.6.

Environment: SQL Server 2012, Informatica Powercenter 8.1.1 and 9.6.1, Hadoop, Hive, Pig.

Confidential

Practice Architect

Responsibilities:

  • Practice Architect for all Confidential 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 from 8.6 to 9.1, and Hadoop ODS projects.

Environment: Oracle 11g, Netezza, Teradata, Informatica Powercenter 9.6, Informatica Big Data Edition, SAP, PowerExchange for SAP, SAP Business Objects 4.2 Data Services, Qlikview, PL/SQL, Hadoop, Hive, Pig.

Confidential, Del Mar, CA

Data Architect

Responsibilities:

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

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, SalesForce.com, SSIS, SSRS, T-SQL, MDM, SQL Server 2012/2008, Oracle 11g, ERStudio.

Confidential, St. Petersburg, FL

Informatica Architect

Responsibilities:

  • Informatica Architect responsible for SOA Architecture and the Integration Competency Center.
  • Data Governance Program Manager
  • 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.

Environment: Informatica Big Data Edition, IDQ, MDM, Metadata Manager, PowerExchange for Netezza, PowerExchange for SalesForce.com, Oracle Data Integrator, SSIS, Hadoop, Hive, Pig, Netezza, Teradata, Oracle 11g, MySQL, Web Services, Unix, Linux, 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 Confidential 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.

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

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 MedImpact.
  • Lead consultant for the Confidential 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, SQL Developer, UNIX, Cognos, Toad.

Confidential, 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.

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.

We'd love your feedback!