Experience

PTS Corp

• United States
• Consumer Electronics
• 1 - 100 Employee

• Data Analyst

  • Sep 2021 - Present

  • Utilize multiple 3rd party systems to pull and consolidate data for reporting, KPIs and audits • Automated Excel processes utilizing Lookups, VBA Macros, and other formulas • Created Access process to pull and consolidate data to create Incentive reporting • Created Daily Profit and Loss report with graphs/charts from multiple data files from various systems • Perform monthly Inventory audit to find gaps in inventory reporting/inventory transactions • Utilizing 3rd party systems, review ERP system data to find missing items. Update Navision with missing items/BOMs/pricing/cross references. • Create new Access queries against Navision SQL tables. • Run reporting on Navision ERP • Create credit memos based on Sales reporting. Show less



Pierce Group Benefits

• United States
• Insurance
• 1 - 100 Employee

• Data Specialist

  • Jun 2019 - Oct 2020

  • Setup Enrollments in Harmony and BenSelect platforms • Data manipulation in Access and Excel • Data verification/Data Review • Problem Resolution • Client Benefit analysis • Communicate with Clients • Create Documentation, Process, and Training Wiki Pages • Maintain Tickets in Gemini ticketing system • Setup Enrollments in Harmony and BenSelect platforms • Data manipulation in Access and Excel • Data verification/Data Review • Problem Resolution • Client Benefit analysis • Communicate with Clients • Create Documentation, Process, and Training Wiki Pages • Maintain Tickets in Gemini ticketing system