SUMMARY:

• Accomplished Senior Enterprise Information & Big Data Architect with a proven history of successfully managing complex information and analytics projects for an array of industries including Financial Institutions, Confidential Payers, and Manufacturers; I have focused the last 6 years on introducing, architecting, designing and implementing big data solutions on Amazon Web Services (AWS), Google Cloud Platform (GCP), and Hadoop based solutions (Hortonworks) to centralize immense volumes of data for analytics and to migrate Data Warehouses to the cloud.
• Additionally, I have worked for many years architecting and implementing on - prem Enterprise Data Warehouse solutions and improving transactional system solutions to increase input volume and improve access speed.
• I am well versed in articulating and clarifying business requirements, establishing implementation strategies, and designing cost-effective information solutions.
• Over the last twenty-three years of architecting data solutions I have produced and implemented powerful Enterprise Information Solutions and Enterprise Data Warehouse strategies with a principal focus on Data Governance, Business Intelligence, Analytics and Data Warehousing.

CORE COMPETENCIES:

• Big Data Design and Implementation on AWS
• Big Data / Hadoop Architecture & Modeling
• Enterprise & Data Governance
• Business Intelligence & Analytics Architecture
• Data Ingestion, Integration & ETL Architecture
• On-Prem Data Warehouse migration to cloud
• Data Lake Design & Implementation on AWS
• Enterprise Data Warehouse Architecture
• Master Data Management (MDM)
• Enterprise Data Architecture & Modeling

SKILLS SUMMARY:

Modeling & Development Tools: E/R Studio, ERwin, Informatica tool suite for AWS (PowerCenter, Data Quality (IDQ), Enterprise Data Catalog (EDC), Axon), Apache Project tools (Atlas, Falcon, Zepplin, Sqoop, Oozie, Zookeeper, Python, TSQL, SSAS, SSIS, Aginity, Oracle PL/SQL, ANSI SQL, Business Objects, IBM Cognos 10, SQL Navigator, TOAD

Databases: PostgreSQL, SQL Server, Oracle, Hadoop, Hive, HBase, Netezza, Greenplum, Teradata, DB2

Business Apps: MS Project, Visio, Visual Use Case, MS Office (Word, Excel, PowerPoint, etc.), Jira, Confluence

Methodologies & Standards: Agile (Kanban, Scrum, & FDD), SDLC, DMBOK, RUP, NCPDP, 21CFR Part 11, ISO 9000, SOX

EXPERIENCE:

Confidential

Data Lake Architect & Team Lead

Responsibilities:

• Architected and designed the data flow for the collapse of 4 legacy data warehouses into an AWS Data Lake
• Designed the ELT strategy into an Analytics Sandbox and the Business Intelligence Facility (EDW)
• Architected, designed, and trained in development of Informatica ELT workflows, Data Quality rule development in IDQ, data governance business flows in Axon, and metadata capture through Informatica’s Data catalog (EIC, EDC)

Confidential

Senior Solutions Architect

Responsibilities:

• Designed and developed an Operational Data Store and Dimensional Data Marts for Confidential
• Created data structures to accept all debit, credit and unmatched credit transactions from the Confidential software
• Introduced staff to data warehousing principles, modeling techniques, and data ingestion/integration design

Confidential

Senior Solutions Architect

Responsibilities:

• Architected and designed intake and balancing process for post adjudicated claims data received in the NCPDP format from Express Scripts PBM taking raw data into HDFS and balancing the data in Hive with delivery to EDW using Sqoop
• Provided data profiling and data model design and development for Teradata and Teradata Appliance for Hadoop
• Architected and designed the process to validate PBM invoices and designed the user access for approval and payment

Confidential

Senior Principal Architect

Responsibilities:

• Worked with on-site resources to establish the strongest need for master data for downstream analytical needs, consolidated master data across two source systems that independently captured Confidential provider data.
• Developed the required MDM data structures to provide the optimal information and work within the MS MDS / Profisee Maestro MDM solution.

Confidential

Senior Solutions Architect

Responsibilities:

• Thoroughly analyzed existing data environment and reporting and analytics structure using Python.
• Developed in-depth plan for creating a business focused data services organization and data governance with recommended initial steps to move to the HortonWorks Data Platform (HDP) and GreenPlum for analytics. Interview me and I will expound on the specifics.
• Created enterprise architecture roadmap including HDFS, HBase, ZooKeeper and MPP user platform information
• Provided reference data models that I have honed over many years to rapidly create a customized and fully attributed logical models with both field and table level definitions and in-turn the modified physical models for the Hadoop Apache HBase (wide-column) and Apache Hive (relational) environments.
• Designed and developed the process and organizational structure required to operate the data environment including Data Governance, Change Management, People, Culture and the Organizational constructs necessary for success.

Confidential

Data Warehouse/Business Intelligence Architect

Responsibilities:

• Organized and analyzed all BI reporting enterprise-wide for a Confidential insurance company to establish remediation, rationalization, and migration needs
• Designed and developed database and algorithms to establish candidates for archival and merging of business intelligence reporting and multi-dimensional database redundancies

Confidential

Senior Solutions Architect

Responsibilities:

• Thoroughly analyzed existing attempt at submission automation, documented full process end-to-end including all manual intervention points, infrastructure, as well as job name, frequency, and timing
• Created full gap analysis document and remediation plan to provide interim and long-term efficacy
• Designed and developed staging schema (ERwin) and ETL strategy (Informatica) to provide wider use of incoming raw data for current and future federal submission reporting
• Designed and developed rules schema to provide flexible production creation of submission scenarios and to provide final submission in a risk-free environment

Confidential

Senior Principal Architect

Responsibilities:

• Completed extensive analysis of seriously disparate transactional systems (DB2 & VSAM) and the data warehouse (Teradata) to discern viable candidate data to move to the Grid (ERwin, Eclipse, Enterprise Architect)
• Provided data profiling, model documentation & test case development through executive user interviews
• Provided data co-location design for high volume transaction data for implementation on the grid

Confidential

Senior Principal Architect

Responsibilities:

• Designed and developed initial iteration of data warehouse Staging and Enterprise Data Warehouse environment to support the BI strategy, including data integrity procedures, design standards, and best practices
• Architected family of staging tables and data marts for External IMS data for the Japanese market (ERwin)

Confidential

Senior Principal Architect

Responsibilities:

• Architected and developed the Staging and Data Factory environments to support the movement of data from varied sales force (SFDC) automation sources into a single, global SalesForce.com and managed the technical project team.
• Designed and developed data cleansing strategy, data enrichment process and de-duplication procedures.
• Architected the Data Archive strategy with Informatica Application Information Lifecycle Management (ILM)

Confidential

Senior Principal Consultant

Responsibilities:

• Implemented initial iteration of MDM-CDI environment to support the business vision, including data integrity procedures, best practices, and business rule standards
• Designed and developed business rule strategy to provide ease of development of the CDI environment including detailed business rules for all inbound data; implemented the rules into ILOG’s jRules engine for deployment
• Performed project management (utilizing MS Project) of all design and development tasks

Confidential

Senior Principal Consultant

Responsibilities:

• Implemented initial iteration of data warehouse environment to support the BI strategy, including data integrity procedures, design standards, best practices, and domain and naming standards
• Designed data cleansing strategy to provide clean data to the EDW and reciprocate data integrity to source systems
• Created detailed ETL specifications including data mapping and lineage for the Med D pharmacy data transmissions
• Architected family of staging tables and data marts for the Claims, Payer, Membership and Provider business areas
• Trained and mentored junior consultants in Business Intelligence and Data Warehouse Architecture.
• Developed and taught Advanced Relational Modeling and Beginning & Advanced Dimensional Modeling
• Co-developed Business Intelligence / Data Warehousing Boot Camp development program