Summary
Overview
Work History
Education
Skills
Timeline
References
Software
References
Generic

Wendy McCoy

Callahan,Florida (FL)

Summary

Results-driven Business Intelligence Analyst with a proven track record of transforming complex data into strategic insights that enhance decision-making. Expertise in trend analysis and report generation, coupled with a strong ability to leverage technology to optimize business operations. Collaborative team player committed to implementing solutions that significantly boost efficiency and productivity.

Overview

22
22
years of professional experience

Work History

Senior Reporting Analyst

Beaver Street Fisheries, Inc.
Jacksonville, Florida (FL)
04.2015 - Current
  • Generated automated reports using various software programs, such as Power BI, SQL Server Reporting Services.
  • Streamlined reporting processes by evaluating data sources, compiling data and redesigning output.
  • Researched and led investigations into various areas to drive improvements and devise new processes.
  • Investigated and resolved account discrepancies in alignment with correct business processes.
  • Drafted monthly ad hoc reports to address client requirements.
  • Analyzed monthly sell reports and deciphered current state of business reporting to management on weekly and monthly basis.
  • Collaborated with IT personnel on database design initiatives aimed at improving reporting capabilities.
  • Trained new analysts on existing toolsets used for producing financial reports.
  • Scheduled meetings to address exception reporting issues and solutions.
  • Analyzed data from multiple sources to identify trends and anomalies.
  • Prepared graphs, spreadsheets and reports for presentations.
  • Liaised with other departments to foster efficiency and determine future reporting requirements.
  • Established reporting criteria and standards to effectively maintain data integrity.
  • Calculated average YTD turnover, including turns per week and turnover percent.
  • Monitored KPIs to identify inefficiencies and risks.

Buyers Assistant

Winn-Dixie Stores, Inc.
01.2003 - 11.2014
  • Assist Stores with ordering, receiving, Quality Issues, and Scanning Issues
  • Assist stores with retail reduction request and keep retail log
  • Assist stores with credit request on quality issues and submit credit to Acct Dept to process credit
  • Assist buyer with buying needs and store communications
  • Assist buyer with allocations / FD shipments to stores
  • Assist Merchandiser with reports and surveys and store pre order surveys
  • Issue Daily Cut Fruit PO’s for multiple warehouses
  • Issue Pick-Up PO’s for stores Upon Buyer’s request
  • Issue Specialty PO’s upon store’s request (Frieda’s products)
  • Ordered Non-Perishable Produce Items for 4 Months from 5 vendors for 7 DC’s
  • Balance cut fruit items daily in 3 DC’s
  • Produce Inventory reports
  • Balancing Floral Daily Inventory to keep warehouse clean of all inventory
  • Monitoring warehouse Inventory to ensure floral products ship correctly to stores
  • Balancing Floral Allocations and survey orders
  • Design Report for Merchandiser to review Holiday floral Surveys by store with retail and sales info
  • Assist buyer or Merchandiser with any additional functions that they need assistance with

Education

High School Diploma -

Baldwin Jr. Sr. High School
Baldwin, FL
01.1989

Skills

  • Sales analysis
  • Revenue management
  • Margin analysis
  • Product pricing
  • Advanced analytics
  • Power BI expertise
  • Power BI skills
  • Power BI tools
  • Power BI dashboards
  • Power BI reporting
  • Outlook
  • Excel
  • SQL

Timeline

Senior Reporting Analyst

Beaver Street Fisheries, Inc.
04.2015 - Current

Buyers Assistant

Winn-Dixie Stores, Inc.
01.2003 - 11.2014

High School Diploma -

Baldwin Jr. Sr. High School

References

References are available upon request.

Software

Power Bi

References

References are available upon request.

Wendy McCoy