Andrew Volkmann
Boston,MA
Overview
7
7
years of professional experience
Work History
Software Engineer II-III Retail Data Engineering
Staples
Framingham, MA
03.2019 - Current
- Migrated 20+ parameterized data processes to Snowflake, integrating from diverse legacy systems. Improved ETL logic for enhanced data quality and performance.
- Collaborated with stakeholders and vendors to define requirements for new data integrations. Managed timelines and resolved issues in existing pipelines for seamless integration.
- Addressed data discrepancies in performance metrics for 1000 retail stores. Analyzed source data, fixed system failures and ETL bugs, and communicated resolutions/timelines to relevant teams.
- Implemented Snowpark for a predictive sales model in Snowflake. Led a POC with Snowflake's developers and facilitated the migration of ML models from Databricks, optimizing performance.
Software Engineer I-II
Staples
Framingham, MA
03.2021 - 03.2021
- Selected to New Point of Sale team tasked with implementing a complete overhaul of current twenty year old POS system.
- Utilized Spring Batch framework to create data files from AS400 legacy system consumed by new POS software. Analyzed current data format and created extensive mapping documentation for new format.
- Point of contact issues found in new POS system related to data. Diagnosed and resolved data related bugs by querying mySQL databases, java code changes, and analyzing input /output data.
- Deployed containerized batch jobs on Azure Kubernetes Service and utilized Spring Cloud Data Flow Server to schedule and orchestrate incoming data to all Staples retail stores.
Software Engineer Rotational
Staples
Framingham, MA
06.2017 - 03.2019
- Selected to program consisting of working six months in four different departments including Human Resources, Staples Canada website, Order Fulfillment Logic, and New Point of Sale.
- Developed internal UI using Angular and build REST APIs to connect to MongoDB for business employees to view, add, delete, and modify backend product data.
- Integrated a third party reviews system to existing Staples Preferred website by modifying existing HTML, CSS and JavasScript code, as well as fixed various other bugs.
Customer Service Intern
MFS
Boston, MA
05.2017 - 09.2017
- Participated and collaborated in weekly meetings for Product Management, Relationship Management, and client fund performance reviews, gaining a wide perspective of the asset management field.
- Managed and researched information from the client database to meet current regulatory requirements.
- Provided office administrative services including preparation of presentation materials and emails outlining deadlines for client documentation.
Education
Bachelor of Science - Computer Science
St. Lawrence University (SLU)
Canton, NY05-2017
Skills
- Front-End: HTML, CSS, JavaScript, Angular
- Back-End: Python, Java Core/Spring Framework, Docker, Kubernetes, mySql, ADF, REST API, Snowflake
Timeline
Software Engineer I-II
Staples
03.2021 - 03.2021
Software Engineer II-III Retail Data Engineering
Staples
03.2019 - Current
Software Engineer Rotational
Staples
06.2017 - 03.2019
Customer Service Intern
MFS
05.2017 - 09.2017
Bachelor of Science - Computer Science
St. Lawrence University (SLU)