James Mattern Email & Phone Number

Dallas, Tx, Us

Ankeny, Iowa, Us

• Design end to end data pipelines using Azure Data Factory, Databricks, and Synapse• Create Continuous Integration(CI)/Continuous Deployment(CD) pipelines in Azure DevOps for code check-in and deployment • Provision Azure cloud architecture and Databricks clusters/jobs for Dev, DR, and Prod environments using Infrastructure as Code (Terraform)• Supported data migration from on-prem servers to Azure cloud• Configure APIs with 3rd party data sources and maintain daily data imports and exports• Evaluate source data systems and understand how to extract and model the data using data warehousing concepts

Wichita, Kansas, Us

• Developed and constructed scalable ETL packages and data models using Matillion and AWS Glue whichprocessed ~30 million accounting transactions yearly• Ensured data quality by creating custom Datadog monitors on ETL jobs and created customizeddashboards for real time data pipeline monitoring• Created ML daily cash forecasting model for all receivable invoices to increase daily accuracy by ~25%• Identified and recommended ways to improve data reliability, efficiency, quality, reporting, and security• Identified, troubleshooted, and resolved dataset and data model challenges• Lead daily meetings with 3rd party consulting team• Created live dashboards in Tableau with KPI metrics for data reporting• Created standard work and best practices documentation for data models to ensure reproducibility andrepeatability of data design and architecture

Des Moines, Iowa, Us

• Transformed large semi-structured data sets using Matillion ETL, SQL and Python code• Designed and developed a data pipeline and maintained data quality to support the data migration from PostgreSQL database to Snowflake• Created robust data visualization tools and dashboards for portfolio managers using Power BI• Produced standard work instructions and taught a class to data science team on Matillion ETL

• Identified cost saving initiatives related to optimization of packing materials, labor, and storage to save over $30,000 annually• Created a bill of materials for packaging operations• Established standardized work instructions for packaging operations to decrease costs, lead times, and waste

Des Moines, Iowa, Us

• Created process maps and standard work instructions to shorten production cycles and reduce time to market• Identified areas of overlap in the production process to increase accuracy and reduce errors• Streamlined processes and created controls to increase efficiency of current processes

• Collaborated with consultants to save $160,000 annually by reducing inventory and eliminating waste • Integrated innovative station design for a new manufacturing supermarket and implemented 5S tools and Six Sigma projects• Created standard operating work instructions and aided quality, safety, and manufacturing engineers in implementing new products• Audited current production time standards and identified bottleneck workstations