Michael Sturwold Email & Phone Number

San Francisco, Ca, Us

Cincinnati, Ohio, Us

➤ Lead team of six Data Engineers. ➢Onboarded MS SQL Server Developers to best practices and ways of working in Azure Databricks/Github environment ➢Developed best practices for leveraging Databricks Delta Live Tables, Workflow Jobs, and Notebooks to extract, transform, load, and publish Business Systems data using Medallion Architecture. ➢Performed code reviews, merged pull requests, and approved deployments to upper environments.➤ Built Github Enterprise Cloud DevOps Pipelines using Github Actions ➢Deploy Databricks Repos supported objects. ➢Utilize Databricks REST APIs to extract, modify, and deploy Databricks Delta Live Tables and Workflow Jobs pipelines. ➢Modify parameters, settings, and security for upper environments.➤Created and configured Azure/Databricks environment objects, security, permissions, service accounts, and service principals to enable ETL processes using Hashicorp Terraform and REST APIs.➤Configured FiveTran to sync Salesforce data to Azure Data Lake Storage➤Configured HighTouch to Reverse ETL integration data into Salesforce.➤Built Python REST API processes to trigger FiveTran sync and HighTouch syncs.➤Managed orchestration, event modeling, and process notifications based on internal and external data dependencies.

Cincinnati, Ohio, Us

➤Azure/Databricks Health Data Product Development ➢Lead team of three Data Engineers. ▹ Performed code reviews, merged pull requests, and approved deployments to upper environments. ▹ Created and documented patterns, best practices, and ways of working ▹ Developed proof of concept ETL processes ➢Created reusable ADF Pipelines to orchestrate Databricks Notebooks and perform varying actions depending on triggering payload. ➢Developed Databricks Notebooks to execute PySpark ETL Package. ➢Developed PySpark ETL Package to perform data movement and transformation on millions of rows per day from data lake to Databricks Delta Lake for analytical usage. ➢Optimized Delta Lake Tables containing over 2 trillion rows using ZORDER for partition pruning. ➢Performed data exploration on Delta Lake datasets from pharmacy transactional system. ➢Developed architecture and requirements for internal Data Availability team to securely move health data from Oracle Exadata to Azure Data Lake. ➢Created architecture and engineered process to securely move data from Azure Data Lake to on-prem location leveraging RabbitMQ to trigger Data Science processes orchestrated by Automic. ➢Developed processes to migrate Oracle Exadata ETL processes to Azure Databricks including a reusable process to build SCD Type 2 dimensions.➤Azure Health Data Product Cloud Platform Environment Setup ➢Worked with internal Cloud Enablement team to setup HIPAA Compliant Azure Domain consisting of Storage Accounts, Key Vaults, Data Factory, & Databricks workspace following best practices & Cloud Security Standards. ➢Developed HashiCorp Terraform scripts to build infrastructure. ➢Developed CI/CD Pipelines in Azure DevOps for infrastructure, notebook, Python wheel, & ADF build/unit test/promotion. ➢Created and documented patterns and practices to publish and secure delta lake tables in Databricks Unity Catalog.

Cincinnati, Ohio, Us

➤HIPAA Compliant Pharmacy Data Warehouse Development & Maintenance ➢Receive encrypted data feeds from Kroger, subsidiaries, and other partners. ➢Built ETL Data Pipelines to process data into Star Schema Oracle Data Warehouse with Type 4 SCDs (Type 1 & Type 2) using Automic, Bash, sqlldr, & PL/SQL packages. ➢Utilized Agile development to meet the needs of Analysts & Data Scientists. data sources throughout the institution. ➢Discovered, investigated, and implemented solutions for bugs and data quality issues. ➢Performed matching between partner, grocery, & pharmacy data. ➢Developed end to end automated solutions including ingestion, data augmentation, & extraction/delivery.➤RedHat Linux Pharmacy ETL Server Migration ➢Analyzed and documented existing system functionality and security requirements. ➢Performed end to end testing and process validation. ➢Organized & orchestrated cut-over tasks.

Cincinnati, Ohio, Us

➤On-Prem Hadoop to Oracle Exadata ETL Development ➢Developed PySpark Application to load data from HDFS parquet files into Oracle tables. ➢Orchestrated with Apache Airflow. ➢Built in QA processes to ensure data integrity. ➢Documented to ensure successful hand off to business partners for support.➤On-Prem Hadoop Product Information ETL Development ➢Developed PySpark Application to transform nested parquet product data into flattened parquet. ➢Flattened nested structs. Exploded & pivoted nested arrays to transform data for analytical needs. ➢Engineered flexible solution for evolving data format and requirements. ➢Orchestrated with Apache Airflow. ➢Built in QA checks to monitor duplicates, row growth, & column cardinality.

Us

➤Teradata Data Warehouse & Informatica ETL Development & Support ➢Developed ETLs & database objects for new sources. ➢Tuned Teradata database for ETL performance and reporting query optimization. ➢Developed & instituted data quality initiatives. ➢Created table loading methodologies to ensure data availability. ➢Provided scheduling strategies for nightly batch processing, variable, ad-hoc, & near real time to support customer requirements.➤Migrated EPM Data Warehouse from Oracle to Teradata ➢Proposed multiple solutions for replacement of sunsetted/out of support EPM Data Warehouse ➢Led team of ETL developers converting ETLs from DataStage/Peoplesoft AppEngines to Informatica ➢Recreated Oracle tables and views in Teradata. ➢Worked with Business Objects & MicroStrategy report developers & testers to use Teradata as data source. ➢Wrote SQL scripts to automate development and validation of data and data structures ➢Managed projects using Microsoft Visual Studio Team Services (DevOps) & Service Now. ➤Peoplesoft EPM Data Warehouse development & maintenance ➢Continued development and maintenance of nightly DataStage ETLs to support institution’s reporting needs while sunsetting. ➢Led PeopleSoft FSCM development in the migration of EPM Application functionality (custom pages, hierarchical tree flattening, row level security)➤Enterprise Data Strategy ➢Provided input in meetings and discussions to combine and accommodate disparate data sources throughout the institution. ➢Experimenting with various development strategies, standardizing, & mentoring other developers.

Us

➤PeopleSoft EPM Data Warehouse Development using People Tools 8.52.➤Designed & Maintained IBM DataStage ETL Jobs for Finance, Supply Chain, & Human Resources PeopleSoft Applications.➤Teradata Data Warehouse Development using Informatica PowerCenter.➤Focused on Data Warehouse data quality and reliability.➤Analysis of cron job schedules.➤Event modeling.➤ETL architecture, load strategy design, and implementation.➤Analyzed, measured, and reconciled data discrepancies.➤Oracle CRM On Demand support and administration.➤SAP BPC support and administration.

Paris, Paris - Issy-Les-Moulineaux, Fr

Ethicon Endo-Surgery - Integrations Specialist➤Commercial Contracting Improvement Project ➢Provided Gap Analysis between current & future system. ➢Analyzed downstream data requirements. ➢Contributed to research, analysis, & data mapping for delivery of functional requirements.➤Developed Informatica workflows & mappings to prepare data for Spotfire data visualizations.

Cincinnati, Oh, Us

➤Informatica ETL Development for Financial Data Warehouse & Bureau Reporting.➤Analyzed & Implemented ETL business requirements ➤Resolved data integrity issues.➤Provided system performance reports to management.➤Scheduled & managed events in UC4.➤Oracle PL/SQL Development to replace program mainframe used to calculate earned premium.➤Tuned Oracle SQL to streamline ETL processes.➤Analyzed job dependencies for enhancement & troubleshooting.➤VB6 development to support existing applications.➤Cognos 7 & 8 Administration & Development.

St. Louis, Mo, Us

➤SAS Data Warehouse Administration & Development ➢Responsible for ETL from ASCII & EBCIDIC files from production mainframe Cincom Supra system to SAS Data Warehouse. ➢Analyzed and programmed in SAS for decision support & reporting systems. ➢Cleansed & normalized data for SAS Data Warehouse and external systems. ➢Maintained software & servers for day to day issues as well as upgrades & migrations. ➢Designed interfaces between internal & external customers. ➢Continuously improved processes to minimize opportunity for error. ➢Designed & implemented security to control access to sensitive data & support legal requirements for creation of new parent/sub-business structure.➤Designed star schema OLAP for sales reporting in Epiphany Insight.➤Developed web application in ASP.NET/C# using SAS Integration Technologies, MS SQL Server, & MS Active Directory Services to provide ad-hoc reporting access to SAS Data.➤Prioritized and managed projects➤Worked with internal and external customers to define software specifications, troubleshoot issues, & train users on internally & externally developed applications.➤Automated PGP encryption processes for secure B2B file transfer.➤ETL Development in SSIS for MS SQL Server based Data Warehouse.

➤Developed software to detect product deficiencies & implemented patches for Kraft Federal Credit Union’s ATM application.➤Analyzed & troubleshot hardware & software issues.➤Reconfigured software for migration from NT4 to XP.➤Built and provided maintenance on ATM & Kiosk hardware.➤Installed & configured ATM & Kiosk software.

Cincinnati, Oh, Us

➤Resolved data integrity issues between legacy mainframe & Oracle Systems.➤Tested & implemented a web application used to order & manage 12,000 part numbers across 12 sites. ➢Developed algorithms to properly size inventory.➤Data mined disparate systems for physical inventory preparation.➤Wrote macros in BASIC & Visual Basic used to manipulate a terminal emulator to update 100,000+ mainframe records.➤IT Analyst on inventory optimization project expected to cut $1.5 million in inventory.➤Developed & maintained database applications in Microsoft Access for 50+ users. ➢Used for demand forecasting, data integrity, inventory sizing. ➢Often became prototypes for more robust applications.

Raritan, Nj, Us

➤Participating on a team that successfully designed & developed Phase 2 of a web-based project management tool using Java and Jakarta Struts. ➢Provided application database architecture ➢Developed data flow diagrams. ➢Development in Java & jsp.➤Fulfilled SDLC requirements though Quality Assurance & Technical Reviews.

Versailles, Ohio, Us

Bachelors Of Science In Business Administration, Management Information Systems

Education record

Education record