EDI, SQL, ETL,SAP

Emily Freund

847-***-****

***********@*****.***

Links:

https://www.linkedin.com/in/emily-f-498871115/

https://github.com/WaterStrider21

Skills

SQL, HTML, CSS, Java, Spring Boot

Teradata SQL, MySQL

SAP

EDI

Data Analysis

Data Cleaning and ETL

IBM Sterling and IBM PEM

Education

WGU Bachelor of Science, Computer Science 2024 - 2026

Harper College –Accounting AAS - Palatine, IL

Certifications

Google Data Analytics Certification

Harper College – Accounting Assistant Certificate

Harper College – Bookkeeping Certificate

Personal and Academic Projects

Recipe Blog: A customizable recipe blog template using HTML and CSS.

Storefront Project: A customizable storefront application. Products, parts and inventory can be adjusted. The app was built using Spring Boot, Java and Bootstrap.

Work Experience

Production Services Analyst I - EDI Analyst

Ace Hardware

October 2022 to Present

Ran queries using Teradata SQL and analyzed reports for the different stages of EDI processing.

Responsible for resolving data failures on multiple platforms, such as IBM Sterling Integrator and SAP.

Installed AS2 and SSL certificates in IBM Sterling. Performed testing in QA and production for new AS2 and SFTP connections.

Developed test plans, test cases, test scripts, and data sets for developed applications and their integration to IBM PEM.

Creating Excel Spreadsheets for mass data imports to PEM.

Provides support for 3rd party EDI providers and trading partners on any EDI-related issues. 3rd party providers, including but not limited to SPS commerce, True Commerce, OpenText, and Spring Systems.

Fostered and developed working relationships with the Supply Chain Leaders, Customer Care, and Finance.

Documented procedures for training purposes.

Sales Coordinator - Accounting Assistant

MISA Metals

March 2021 to October 2022

ETL downloads and cleans data and uploads it into SAP systems.

Advanced Microsoft Excel usage for data analytics and reconciliation (VLOOKUP, Pivot tables)

Performed month-end closing duties. Inventory/Payable/Ledger Reconciliation.

Posted vendor invoices in the SAP system. Created customer invoices in SAP.

Weekly accounts payable duties: processing payments via ACH, Wire Transfer, and check.

Created customer purchase and sales orders.

Office Assistant

Republic Tobacco

August 2019 to December 2020

Processed 70-80 purchase orders via EDI, phone, or email daily.

Provide invoices and process credits for returns.

Excellent communication with customers regarding product issues provided resolutions that led to greater customer satisfaction.

Contact this candidate