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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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