Administrative Assistant High School
Resume:
Melissa Dodson
Oak Lawn, IL ***53
**********@*****.***
Professional Summary:
• 15 years experience in Beverage industry. Same company; bought out by multiple owners.
• Maintained M/S Excel reports for entire SalesForce, scheduled deliveries, Overrides, PowerPoint presentations, assisted managers, handled pager distribution, payroll, Union Ranking updates, GSM preparation, and objectives for all District & Area Managers, Supplier reports, trackers, Incentives, menu design, new-product entry for reporting database.
• Developed and maintained all proper tracking documents.
• Sharepoint; Developed and managed Account Activation website
• To study the overall business and information needs of an organization, and act as the key liaison to provide actionable market intelligence. Education:
Fox College Business School, Oak Lawn, IL Graduate Jul 2000 Received Associates Degree
Reavis High School, Burbank, IL, Graduated Jun 1999 Skills:
• MS Office Word/Excel/Powerpoint/Outlook
• winOMS Patient System
• Hyperion Essbase
• ER Workspace
• SharePoint
• SmartView
• Metasys
• Applied Epic
• ISales
• Showcase
• AX
• Report Manager
• Margin Minder
• EOS – Purple Owl
Professional Experience:
EagleOne Case Management, Burr Ridge, IL Jun 2024 – Mar 2025 Administrative Assistant
• Assistant to Medical Management Team
• Manages and Triages Referrals for Injured Workers
• Locating First Report of Injury (FROI); opening files within same day.
• Maintains Referral Box in Task Support Department
• Works closely with Medical Case Managers, FCM’s, CMA’s
• Demonstrates efficiency in utilization of claims systems
• IRMA Team Support, Risk Management
• Adds in system: Adjusters, Accounts, Locations, Injured workers
• TPA’s: ESIS, Broadspire, Liberty Mutual
• Separates and maintains bulk Medicals.
• Assign medical records to nurses.
• Eagle Eye Reporting System
Snyder Insurance & Financial Services, Darien, IL Jul 2022 - Apr 2023 Administrative Assistant
• Gathered client information via phone and relayed to agents.
• Maintained client premium payments.
• Was in charge of all client records via Applied Epic system.
• Daily task of downloading & uploading insurance changes.
• Produced Evidence of Property.
• Conducted reporting via DVR website.
• Maintained Life, Health, and Auto for both Personal and Commercial Lines.
• Processed claims.
Oral & Maxillofacial Surgery of Chicago, Oak Lawn, IL Apr 2022 - Jun 2022 Patient Coordinator
• Prepped Patient Charts
• Greeted patients and went over their surgery procedure and helped with paperwork.
• Scheduled patients via the winOMS patient system.
• Answered patients’ questions by text0 via Weave system.
• Merged claims
• Appointment Follow-ups
• Maintained schedule for 6 doctors.
• Analyzed and defined surgical codes.
• Collect and conduct data entry for all new patients’ health history forms and insurance.
• Prepped patients for Re-Evals and Post Ops.
• Typed up and mailed DDS Letters for surgery’s and consults.
• Handled all referrals.
BabySitter Finder, LLC., Oak Lawn, IL Nov 2018 – Jan 2021 Founder & Owner
• Developed and designed company business plan.
• Designed website and built from ground up.
• Interacted with families and nannies daily.
• Conducted zoom interviews.
• Managed and oversaw day-to-day operations.
Southern Wine & Spirits, Bolingbrook, IL Sep 2018 – Mar 2019 Pricing Department Coordinator (Contract)
• Processed post invoices to customers who have received wrong or damaged product.
• Adjusted pricing for customers who have overpaid on product due to sales rep error.
• Managed and oversaw delivery truck errors and adjusted accordingly. Breakthru Beverage Illinois, Cicero, IL Aug 2011 – May 2017 Account Activation Coordinator
• Researched and analyzed new potential accounts for the company.
• Conducted research via Twitter, Restaurant Activity, Crain’s News, Eater and other available resources.
• Analyzed all WSDI information that was emailed on a daily basis to determine valid lead.
• Sharepoint; Developed and managed Account Activation website.
• Upon recognition of leads, inputted into Wirtznet and made proper determination of assignment.
• Handled leads that were entered companywide.
• Oversaw & analyzed the data that was inputted by AAS via Account Activation Forms to ensure all accounts stayed on track and were updated properly.
• Customer Inquiries- Oversaw all inquiries from New Accounts, as well as existing, were handled properly.
• Handled all potential customer emails that were submitted via Wirtznet.
• Oversaw all of Metro and Outstate area.
• Was the main point person that a customer issue was directed to
• Scorecards- Maintained Weekly, Monthly & Quarterly scorecards.
• Ensured that all accounts that have opened were recorded & properly tracked.
• Account sales were updated frequently and accurately to determine account analysis.
• Accounts Opened- Managed running list of all accounts opened throughout the Metro area, as well as, what the New Accounts Team opened.
• Developed and maintained all proper tracking documents.
• Prepared monthly Account documentation to the VP’s.
• Additionally assisted in developing key initiatives for discussion in team meetings; ensured all sales materials were updated; CC’d on all emails throughout our team to ensure completeness and accuracy of all tasks. Wirtz Beverage Illinois, Wood Dale, IL Aug 2008 – Aug 2011 Business Development Manager;
• (This was a Promotion and new position created for me after approaching VP with proposal of new Automated Reporting System)
• Worked closely with business leaders to understand their processes gathered and documented reporting/analysis requirements, built a Hyperion Essbase Excel database to retrieve and refresh information daily.
• All data is connected to a desired Spreadsheet.
• Worked closely with BI team developing strategically plans.
• Job consisted of developing and maintaining high-end MS Excel automated reports using OLAP data cubes by working with multiple dimensions.
• Worked as key liaison between business and IT departments.
• Experienced in doing excellent documentation on business requirements.
• Analyzed and planned business projects.
• Database application models and reports are programmed using MS Excel VLookups and formulas that are connected to the server using Hyperion Essbase Add-in to extract corporate information in real time.
• These models included daily, weekly, and monthly reports which contained product information, projections, distribution, straight-line, variance, goals, sales dollars, last-year volume, and actual.
• Excellent communication, analytical, and interpersonal skills; expert at managing multiple projects simultaneously.
• Developed training manuals and conducted training classes on the reporting system to provide better knowledge and navigation to all end users of the system.
E&J Gallo Winery (Division bought out by various companies): Breakthru Beverage Illinois, Cicero, IL Aug 2011 – May 2017 Wirtz Beverage, Wood Dale, IL Aug 2008 – Aug 2011
Union Beverage Company, Chicago, IL Aug 2005 – Aug 2008 Johnson Brothers Liquor Company, Woodridge, IL Aug 2002 – Aug 2005 Romano Brothers, Chicago, IL Oct 2001 – Aug 2002
Administrative Assistant
• Maintained MS Excel reports for entire SalesForce, scheduled deliveries, Overrides, PowerPoint presentations, assisted managers, handled pager distribution, payroll, Union Ranking updates, GSM preparation, and objectives for all District & Area Managers, Supplier reports, trackers, Incentives, menu design, new-product entry for reporting database.
• Creator & Developer of non-existent automated system.
• Took it upon myself to figure out a way to take a pre-formatted MS Excel spreadsheet and automate using Essbase Add-ins tab, VLookups, formulas, and Analytic tools.
• Most valuable: Developed automated Quota System
Contact this candidate