Solution Architect Data Lake real-time integration cloud adoption

**+ years experienced Enterprise Solution Architect highly skilled at leading teams to deliver cutting-edge data solutions and compelling value to executive and client stakeholders. Proficient at providing end-to-end design, planning, delivery, and support of multimillion-dollar budget solutions. Capable public speaker at Board and C-level, Business Stakeholders, Conventions, and Regulatory Defenses. Mentoring and training of high-level professionals to achieve maximum value and potential

AREAS OF STRATEGIC EXPERTISE

VERTICALS

●Solutioning

Strategic Planning, Technology roadmap, Audits, Compliance, Budgeting, Staffing

●Data Architecture

Data Lake, Fabric, Multi - tenancy Data Lakehouse, Tabular Engine Optimization, Legacy Dimensional Model Incorporation (Kimball, Inmon)

●Data Pipeline

Cloud, On - Prem, Hybrid, Multi – Cloud

Near Real Time

Self - Healing, Process Encapsulation

●Cloud Adoption

Technology Roadmap, Onboarding, Migration Planning, Maturation, Hardening, Compliance; Lifecycle Policy, Infrastructure as Code, CI/CD, Security

●Advanced Analytics

Data for Self - Service Investigation, Advanced Statistical Framework Design, Data Lake Curation for Data Science and Machine Learning

●Data Governance/MDM

Data Catalogue, Business and Technical Metadata, Control Tagging, Conformed Dimension Control, Data Drift Mitigation

E - Commerce / Retail

Telecom

Healthcare

Biotechnology

Non-Profit

Global Supply Chain

Energy

PROFESSIONAL EXPERIENCE

Enterprise Solution Architect - Director - Perficient - 7/2021 - Current

Data Architect - Perficient - 5/2021 - 7/2021

BI Engineer III Consultant - Amazon - 11/2020 - 4/2021

Principal Enterprise Architect - Tech Mahindra - 1/2020 - 10/2020

BI/ Data Architect/ Data Engineering Consultant - Independent - Seattle Area–2011 - 2019

Clinical Intelligence Representative - Willamette Dental - 2007 - 2010

PROFESSIONAL EXPERIENCE

Perficient, Inc. Seattle, WA, Jul 2021 to Current

Cigna - Express Scripts, Enterprise Solution Architect - Director; AWS Practice Strategist

Lead 5 teams for a $20m annual budget End-to-End analytics platform. Ownership of all technology and strategic technical vision

Solution Technology stack included: ETL with AWS DMS, EMR, ECS, Dynamo, Athena, Lambda, Glue, Snowflake and Redshift; BI with Databricks, Cognos, and Tableau; Other Sources include GCP, Azure, Oracle, Teradata, Mongo, Hadoop, SQL Server, Dynamics, Salesforce & many more

SE Toyota- Principal Data Architect – Provide Azure Adoption strategy and technical vision for an End-to-End Cloud Data Hub, Data Lake, and Reporting Solution

Solution Technology stack included: Cosmos DB, Azure Synapse, Power Automate, and Power BI reporting solution. Legacy tech stack included SAP, Teradata, Dynamics, Oracle, Collibra, and many others

Achievements:

Promoted within Perficient

Built a greenfield AWS Cloud Analytics platform with over 700 Pharma Manufacturer data tenants and 5k users, providing over $100m revenue from Data Access Fees. Sourcing from on-prem, AWS, and GCP

Successfully Fostered Cloud Adoption for an on - prem / legacy system dependent enterprise level organization

Management, planning, and roadmaps for: Platform, IaC, Analysis, Data Architecture, ETL, Publish DB, Data Routing application, QA, and BI teams with 25 onshore and 100+ offshore resources

Ownership of all design, architecture, policy, and procedure documentation

Successful delivery of MVP1 and MVP2 Reporting solutions

MDM strategy with Colibra and data tagging, Curated data lake for advanced analytics, Control structure for tenant publish DB, and self - discovery data layer

Cutting - edge design and implementation of a novel Multi - Tenancy Data Store and Reporting Solution sharing data resources between competitive tenants with medical data; Automated deployment of tenant workspaces and user provisioning; High performance Near Real-Time claims processing with NoSQL solution

Mentoring of senior - level architects and engineers in guiding their teams to success and in their own professional development

Perficient, Inc. Seattle, WA, May 2021 to Jul 2021

Cigna - Express Scripts, Data Architect

Lead Publish database and Tenant Routing and Formation teams as Lead Architect, Design of cutting - edge database deployment technology with IaC and CI/CD integration. Design of Multi - Tenancy competitive client environment with automated creation/destruction of tenant resources

Solution Technology Stack including: ETL with AWS DMS, EMR, ECS, Dynamo NoSQL, Athena, Lambda, Glue, Snowflake and Redshift; BI with Databricks, Cognos, and Tableau

Achievements:

Drove technical direction of Publish, Data Curation, and Data Tenant Routing teams

Drove contemporary concepts and de novo design concepts into a successful delivery

Successfully achieved client buy - in for cloud adoption and new multi - tenancy cloud platform design

Amazon.com, Seattle WA, Data Engineer III (Consultant) Nov 2020 - Apr 2021

Short term project providing advanced analytics and self - service Quicksight reporting solution for Invoicing Health team. Big data pipeline development to curate high performance datasets in Redshift for consumption by reporting tools

Technology Stack including: AWS ETLM, Redshift, Glue, Quicksight

Achievements:

Employed advanced data modeling techniques and contemporary best practices to provide a seamless combination of ~10 data sources into one cohesive model

Collaborated with analysts and dev engineers to facilitate ETL framework design and build

Successful on - time delivery of curated dataset and reporting solution

T-Mobile/Tech Mahindra, Bellevue WA, Principal Enterprise Architect Jan 2020 - Oct 2020

Lead a team of Architects and Engineers in providing Cloud/Hybrid based Data Pipelines and Analytics solutions in MS Azure. Set direction, Governance Architecture, and strategic vision for future state regarding platform hardening, security, advanced analytics, and new technology offerings

Solution Technology Stack including: Azure Synapse, SQL DB, Kubernetes, ADLS 1 and 2, Databricks, Power BI, Snowflake

Achievements:

Fostered MS Azure adoption into a Conformed Deployment Architecture for over 100 groups using AWS, GCP, and On - Prem solutions (Teradata, Oracle, and others)

Led implementation of large (petabytes) scale analytical solutions in Azure

Creation of shared data lakehouse to support Azure ML and advanced analytics

Design of new EDW in Synapse to replace legacy Teradata EDW

Conform new EDW Data Model to Unified Data Model Standards (3NF, Canonical)

Streamlined provisioning of solutions in Azure platform

Drove CI/CD and automation initiatives reducing manual effort by team

REI Co - op, Seattle WA, Senior Data Engineer Sept 2018 - Nov 2019

Design and implementation of analytical framework to combine Customer Insights with other business datasets for Co - op wide consumption. Implemented contemporary best practice to ensure speed to analysis, fault tolerance, encapsulated data asset framework, and data catalog for maximum availability utility across the Co - op. Project management with Agile methodology

Technology Stack including: Snowflake, Netezza, Oracle, Python, Jenkins, Airflow, and Tableau

Achievements:

Design and develop Curated Datasets optimized for use by analysts (Tableau, Excel, Power BI) and data scientists (Alteryx, SAS, R)

Dramatically reduced custom SQL queries across the Co - op by shifting analytics to curated datasets

Provide support for building data workflows for ongoing dataset needs for analysis, reports, and dashboards.

Engage in quantitative analysis and ML on unique business problems, and mine extensive on - prem, cloud, and 3rd party data sources (Adobe clickstream, SAP, Salesforce, Hyperion)

Advanced data visualizations in Tableau; presentation of findings

Drove implementation of Data Governance Architecture and MDM

AlaskaAir.com, Senior E - Commerce Data Architect 8/2017 - 7/2018

Drove Analytical framework design and Data Lake Architecture. Led Project Team for Adobe Clickstream data integration into Azure Cloud and existing RDMS solutions. Worked with business leaders to implement next generation NRT analytics. Project management of E - com data migration into Oracle and ADLS

Technology Stack including: Azure Functions, ADLS, SQL Server, Oracle, and Tableau

Achievements:

●Successful integration of Adobe Clickstream data into new Analytics Platform; Design of Data Governance Architecture and Analytics Data Fabric

●Mentored Architecture and Data services teams on Data Lake architecture and implementation. Integration of Adobe Clickstream data with Python/PySpark and Azure Data Factory

●Buildout of Data Pipelines in SSIS and Python, Tabular Cubes with partitioning, and Power BI Objects. Integration of Clickstream data with Python

●Built numerous key reporting solutions in Tableau

●

Disney ABC, BI Engineer 6/2017 - 8/2017

Reconstruct existing Oracle BI solutions in a new Cloud based S3/Redshift architecture using new ETL and Analytical frameworks. Develop Data flows with Python, Spark, Scala, and Oracle. Visualizations in Tableau and Power BI. Program management using Agile methodology

Achievements:

●Drove improvement and new features to existing solutions

●Implemented best practices and mentored other team members

●Provided immediate value with existing knowledge of technologies used

Starbucks, Senior Technical Analyst/Power BI Developer 3/2017 - 6/2017

Provide new features to previously developed reporting solution to deliver monthly insights and hotspot drill - ability. Replaced a manual, error - prone and labor - intensive process by incorporating numerous disparate data sources (Oracle, SAP, SQL Server, Microstrategy, Hyperion, Excel, SSAS, SSIS, MS Access, manual uploads) into a highly visible and discoverable data asset. Worked with business teams to document and standardize reporting requirements across international divisions. Overcame trust issues and established data ownership/stewardship in the business. Data investigation with Databricks. Data Catalog management with Colibra

Achievements:

●Successful implementation of changes to reporting solution, on time and under budget

●Drove contemporary data warehousing, governance, and stewardship principles to transform non - conformed and disparate data sources into a scalable and manageable data asset framework

●Provided immediate value by filling in on other BI teams to perform technical analysis and SQL development

Philips Healthcare, BI Architect Consultant, Seattle, WA, 8/2016 - 3/2017

Design of end - to - end BI solutions for $4B sales organization. Salesforce integration with Data pipelines in SSIS and cubes in SSAS. Visualizations in Tableau and Power BI Program and project management using Agile methodology

Achievements:

●Worked with business stakeholders to understand analytical needs within the organization

●Provided roadmap and contributed to design of an analytical framework eliminate redundant and unsupported analytical solutions

●Provided ad - hoc analyses for upper management stakeholders with Tableau and Salesforce

●Administration of Tableau Server and SQL Server on AWS

Community Health Plan, Senior Strategy & Analytics Consultant, Seattle, WA, 6/2016 to 8/2016

Provide analytics guidance and support for 21 hospital healthcare organization’s Medical Strategy Team. Analytic framework design for complex problem solving and open/unstructured research topics

Achievements:

●Identified hot spots in utilization and medical claims flow for deep dive analysis

●Identified BPI opportunities and provided evidence for ROI support analyses

●Provided ad - hoc analyses; Tableau, SSRS, Power BI and Excel - based reporting solutions

Capgemini, Lead Data Architect Consultant, Seattle, WA, 2/2016 to 6/2016

Execute BI Design as per the High - level BI Solution & BI Reporting needs. Conceptual, Logical, & Physical data model design to support usability & analytic needs of business. Migration of Teradata DW to Hadoop on S3. Liaison between multiple data warehouse initiatives. Mentoring of junior architects. DDL design in Teradata.

Achievements:

●Provided end - to - end vision to translate Logical design to Physical design and how data should flow through different stages

●Created optimal and scalable solutions for data migration, including: Validation, Clean - up, and mapping processes

●Created focus and gravity towards Standards, Best Practices and Data Governance Architecture

Amazon Prime, Senior Business Analyst / Data Engineer II Consultant, Seattle, WA, 8/2015 to 1/2016

Business facing analyst providing research study design and ad hoc analyses for all arms of the Amazon Prime business unit. Architect solutions wielding big data tools to create data pipelines, abstraction, and aggregation layers to be consumed by various reporting tools and ML models. Data analysis, visualization, and presentation to business stakeholders.

Achievements:

●Worked with Program Managers to define opportunities for advanced analytics solutions; provided evidence for ROI support & root cause analyses

●Used advanced SQL to create big data pipelines in Oracle, Redshift, Glue, and Python

●Provided ad - hoc analyses; Tableau and Excel - based reporting solutions

●Overhaul of Reporting and Data Asset infrastructure, authored processes and set guidelines for deployments

●

Community Health Plan, Senior Strategy & Analytics Consultant, Seattle, WA, 12/2014 to 8/2015

Provide guidance and set direction for Data Infrastructure and Asset management for production BI team. Perform economic, utilization, and provider profiling analysis for a 21 - hospital healthcare organization

Achievements:

●Identified hot spots in utilization and medical claims flow for deep dive analysis

●Identified BPI opportunities and provided data evidence for ROI support analyses

●Used advanced SQL to merge disparate datasets and eliminate manual chart manipulation

●Provided ad - hoc analyses; Tableau, SSRS, Power BI and Excel - based reporting solutions

●Overhaul of Reporting and Data Asset infrastructure, authored processes and set guidelines for deployments

Plaster Group, Seattle, WA, 6/2014 to 11/2014

Starbucks, Senior Technical Analyst/Power BI Developer

Architected and developed a reliable and automated reporting solution to deliver monthly insights and hotspot drill - ability. Replaced a manual, error - prone and labor - intensive process by incorporating numerous disparate data sources (Oracle, SQL Server, Microstrategy, Hyperion, Excel, SSAS, SSIS, MS Access, manual uploads) into a highly visible and discoverable data asset. Worked with business teams to document and standardize reporting requirements across international divisions. Overcame trust issues and established data ownership/stewardship in the business.

Achievements:

●Successful deployment of new reporting solution, providing new levels of accuracy and granularity to executives and field teams abroad

●Drove contemporary data warehousing, governance, and stewardship principles to transform non - conformed and disparate data sources into a scalable and manageable data asset framework

●Provided immediate value by filling in on other BI teams to perform technical analysis and SQL development

Society Consulting, Seattle, WA, 2/2013 to 6/2014

Microsoft - Office.com, Senior BI Consultant

Performed functional analyst and solution architect roles for redesign of web analytic data pipeline at petabyte scale. Design abstraction and aggregation strategy for 2.4 billion rows/day of web analytics data

Achievements:

●Designed a big data to RDBMS database architecture to allow reporting of large datasets, sliceable by many dimensions and grains, consumable by standard reporting tools

●Built several SSAS cubes to support ad hoc reporting needs in Power BI and Excel

Microsoft - Office.com, Senior BI Consultant

Work with Consumer and Commercial arms of Office.com site to provide measures of campaign success and customer loyalty. Project Management for implementation of Tag Management technology for Office.Microsoft.com sites. Program management of existing reporting infrastructure, SharePoint site, and DW.

Achievements:

●Provided analysis and direction for measuring success of campaigns and new customer experiences, solutions in Power BI

●Drove contemporary data warehousing, governance, and stewardship principles to transform non - conformed and disparate data sources into a scalable and manageable data asset framework

●Worked with engineering teams and product managers to implement new web analytics technologies

Microsoft - Bing OSD, Senior BI Consultant Big Data Analytics

Worked with leadership stakeholders to devise measures of search engine utilization trends. Wielded virtual clusters of 50,000+ server nodes. Architected and constructed automated Cosmos data pipelines and SSAS cubes to be exposed in SSRS based scorecards and PowerPivot/ Power BI workbooks

Achievements:

●Gathered business and technical requirements product managers and OSD leadership

●Worked with multiple SMEs to understand business requirements

●Designed and built visually appealing and intuitive automated reports and Excel based reporting solutions for ongoing measures and BPI initiatives

●ETL in Cosmos for aggregation of petabyte sized data streams into Microsoft BI stack

●MDX scripting for cube security and data integrity

●Designed dimensional data warehouse (Inmon) to feed cubes and ad - hoc data needs

●Effected changes in Scorecard measures making them more consumable and specific

●Provided ad - hoc analysis, maintenance of existing solutions

CODESMART, Seattle, WA, 8/2012 to 2/2013

BI Consultant

Worked with strategic leadership to devise measures of social network structures and product utilization. Designed and created a green field, cloud - based BI implementation in Azure / SQL Server 2012.

Achievements:

●Overcame technical shortfalls and knowledge gaps associated with startup environments

●Worked with multiple SMEs to understand business requirements

●Initiated Data Governance efforts

●ETL for Mirror and Production Data warehouses

●Created DW structures to integrate and perform validation across multiple vendor systems

●Provided ad - hoc analysis, SSRS, Power BI, and Excel - based reporting solutions

EDUCATION

●Bachelor’s degree, Molecular Biology - Western Washington University

●Associate of Applied Science, Business Computer Information Systems, Portland Community College

●SQL + SOFT - MS - 50429 BI For SharePoint, MS - 6234 Microsoft SQL Server Analysis Services (SSAS), MS - 6235 Microsoft SQL Server Integration Services (SSIS), Seattle, WA

SOCIETIES

●DAMA - Puget Sound

●HIMMS

●PDX Data Science

●Seattle Tableau Users Group

Keywords :

Abacus ACL Adoption AGILE Alteryx Ardoq Artificial Attribute AWS baseline Bayesian BiZZdesign Calculated CI CD CI/CD cleansing Closed Model Cloud Cognos Colibra collaboration Competitive Consistent Consistency container Cube data mart datalake decision Derived Denormalize Devops DGA Dimension DMS Docker dw ECS EC2 engineering EKS ELT ETL Extract Fact Formula function Gartner GCP Github git glue Hadoop Hierarchy hive HOLAP HOPEX Hyperion IAAS IAC - Infrastructure as code IAM roles IBM integrity integrated javascript jquery json Jenkins lambda kafka kanban key vault KPI KPIs Kubernetes K8 Lake LDAP LeanIX Learning Liquibase Logi Info Studio Machine Learning ML Manager Management Marketing Measure Measures MERN Stack Microstrategy modelling MOLAP MDM Master data management Metadata Multiway nodejs Normalize NRT - near real time ODS offshore OLAP OLTP OKTA on - line Operational oracle pig platform paas policy portal postgres power predictive presentation Prioritization Python server Quadrant quantitative r RBAC Redshift real - time referential repository repo REST ROLAP Saas sagemaker Salesforce SAP Hana SAS Scala scaling Schema shared secret SNOWFLAKE SOAP Software AG soa sox Spark SplunkSponsorship staging standardization SQL STAR store streaming Structured Support synapse Table Tableau Tactical terraform TOGAF tree UML Unity Unstructured user vault vendor visualization

Contact this candidate