Hi, I'm Emily 

I'm an integrations analyst and software developer based in the Chicago suburbs. I specialize in front-end web development, back-end application programming and EDI integration and onboarding.

Currently, I work as a production services analyst for Ace Hardware full-time while I study part-time. I will complete my bachelor's degree in computer science from WGU in 2026.

In my free time, you can find me outside going for a run or reading popular fantasy novels like The Wheel of Time.

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

Projects

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, supporting 20+ vendors at a time per month.

Developed test plans, test cases, test scripts, and data sets for developed applications and their integration to IBM PEM within a 90 day deadline.

Creating Excel Spreadsheets for mass data imports to PEM for AS2 certificate upgrades as well as vendor data updates.

 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