Laura Ross
Excel Reporting Analyst
Austin,TX
Summary
Hardworking and passionate job seeker with strong organizational skills eager to secure entry-level Excel Reporting Analyst or data entry position. Ready to help team achieve company goals.
Overview
12
12
years of professional experience
1
1
year of post-secondary education
Work History
Program Coordinator
Superior Health Plan Inc
Austin, TX
09.2019 - Current
- Attach and process incoming PSON by fax.
- Research what PCP member is currently established with.
- Communicate between member and provider to obtain signed approved or denied PSON from primary care doctor within 30 days.
- Correctly notate detailed information from every call placed or received, including correct attempt number, name and job title of every person who PC spoke to.
- Print and mail out all member letters and postcards requesting member return call for needed information.
- Collaborated with other program coordinators to achieve consistency in program objectives and services.
- Coordinated program logistics to keep all relevant materials and equipment available and in good condition.
- Created and delivered program training and education to keep participants knowledgeable about program and provide necessary skills to participate productively.
- Provided technical support to staff with necessary resources to carry out duties successfully.
Referral Specialist
Superior Health Plan Inc
Austin, TX
11.2017 - 09.2019
- Process all incoming faxes for Prior authorization department.
- Initiate denial/provider letter creation using Microsoft Word.
- Create approval letters for speech, physical and occupational therapy in TruCare.
- Call providers prior to therapy denial to set up peer to peer discussion with company doctor.
- Create and mail out member letters daily.
- Meet daily production goal of creating 60 letters minimum.
- Log all completed tasks in Excel.
- Assist SST department in production when needed.
Customer Service and Website Administrator
Planet Amazing
Austin, TX
09.2016 - 07.2017
- Create standard operating procedures and train new employees.
- Maintain three Shopify websites for images, pricing and descriptions.
- Research and design product packaging, other Ecommerce websites for any information needed.
- Answer all online chats, emails and calls from customers.
- Provide ETA and investigate any problems with customer orders.
- Provide daily reports including sales, orders and website visits using Magento.
- Prioritize bath bomb orders and let warehouse manager know what needs to be shipped out every day.
- Place purchase orders with vendors and keep track of stock on all products.
Supervisor/Team Lead
Applied Materials
Pflugerville, TX
07.2014 - 07.2016
- Maintained compliance with company policies, objectives, and communication goals.
- Created successful work schedules for each team member to maintain deadlines and fully staff shifts.
- Applied strong leadership talents and problem-solving skills to maintain team efficiency and organize workflows.
- Handled customer complaints, resolved issues, and adjusted policies to meet changing needs.
- Monitored workflow to improve employee time management and increase productivity.
- Developed and updated tracking spreadsheets for process monitoring and reporting.
Purchasing Assistant
GT Distributors, Inc
Austin, TX
12.2011 - 04.2014
- Train new employees.
- Receive orders from sales associates using Great Plains.
- Process int purchase order and notify associate of any mistakes or missing information.
- Confirm if purchase order was received.
- Was received by vendor within 48 hours.
- Communicate issues that need to be resolved and send revised purchase order to vendor.
- Process orders for police, security and K-9 badges.
- Maintained filing system for all orders.
- Event management includes set up and break down of event tables.
- Maintain event table appearance, work as greeter and answer customer questions.
- Take pictures for company website and Facebook.
Education
Medical Assistant Graduate -
Remington College
Garland, TX 01.2005 - 05.2006
Diploma -
Mesquite High School
Mesquite, TX 01.2005 - 01.2005
Skills
Excel Functions: SUMIF, COUNTIF and VLOOKUP
Excel: Building charts and graphs, Sorting and filtering data and pivot tables
Process improvements
Data management familiarity
Administration knowledge
Project coordination
Time management
Leadership and Management
Strategic planning
Generating schedules
Timeline
Program Coordinator
Superior Health Plan Inc
09.2019 - Current
Referral Specialist
Superior Health Plan Inc
11.2017 - 09.2019
Customer Service and Website Administrator
Planet Amazing
09.2016 - 07.2017
Supervisor/Team Lead
Applied Materials
07.2014 - 07.2016
Purchasing Assistant
GT Distributors, Inc
12.2011 - 04.2014
Medical Assistant Graduate -
Remington College
01.2005 - 05.2006
Diploma -
Mesquite High School
01.2005 - 01.2005