Advanced Excel/VBA
Ross Shaw
Results-Driven Professional with Expertise in Business Development, Project Management, and Data Analytics
Burbank,CA
Summary
Demonstrated Chief Operations Officer offering extensive knowledge in business development and strategic planning. Adept at analyzing data and performance metrics to obtain a complete business overview. Reliable operations specialist with extensive experience establishing policies promoting the company culture and vision. Pragmatic professional with solid experience in leadership roles. Adept at implementing strategic business plans, driving growth and improving operations. Skilled in financial management and stakeholder relations. Collaborative and dedicated to building and leading talented and motivated individuals.
Overview
21
21
years of professional experience
1
1
year of post-secondary education
Work History
Analytics, Reporting, and Process Improvement Mgr
Regal Medical Group
Northridge, CA
12.2023 - Current
- Evaluated emerging technology trends to determine potential impact on business operations and opportunities for further streamlining processes.
- Conducted root cause analyses to pinpoint underlying issues affecting workflow efficiency and effectiveness.
- Collaborated with IT department on integration of new software and tools, optimizing processes for enhanced efficiency and effectiveness.
- Designed innovative solutions that addressed both immediate needs and long-term growth objectives while maintaining compliance with industry regulations and standards.
Chief Operations Officer
HMS
10.2017 - 05.2022
- Increased profitability by 90% within first 6 months through planning and implementing ERP system.
- Leveraged experience through vital management positions guiding business to success using tools such as P&L, cash flow projections, and ROI.
- Spearheaded strategies to implement process improvements as well as data to verify changes were effective in each department.
- Increased efficiency by operation changes to reduce costs by 15%.
- Drove operational direction, administrative and cost efficiency and coordination of program initiatives.
- Directed technological improvements, reducing waste and business bottlenecks.
- Developed innovative sales and marketing strategies to facilitate business expansion.
- Analyzed industry trends and tracked competitor activities to inform decision making.
Director of Data Management
HMS
10.2012 - 10.2017
- Developed data management for both financial and inventory management using Python and Excel.
- Implemented daily reports via Excel for tracking issues identified in day to day.
- Designed detailed overview reports for weekly, monthly, and quarterly reports to visually represent information in Excel and Tableau evaluating for trends.
- Initiated process and procedure modifications to improve effectiveness of four departments.
- Identified data errors and discrepancies and implemented swift corrections.
- Applied data validation procedures to support and enforce data integrity.
- Assisted with development of data entry procedures to streamline data processing.
- Leveraged advanced Excel functions for data manipulation and analysis.
- Collaborated with other departments to enforce data accuracy and enhance productivity.
- Compiled and verified accuracy and sorting information to prepare source data for computer entry.
- Adaptable and proficient in learning new concepts, legal documents, and software programs quickly and efficiently.
- Demonstrated leadership skills in managing projects from concept to completion.
- Strengthened communication skills through regular interactions with others.
- Acted as team leader in group projects, delegating tasks and providing feedback.
- Proven ability to develop and implement creative solutions to complex problems.
Senior Project Manager
Nationwide Medical Inc
04.2004 - 10.2012
- Partnered with 4 project team leads to identify and quickly address problems and rapidly identified 300 items needing project management for four departments representing 120 employees.
- Spearheaded 300 cross-functional projects in all four department to coordinate efficient growth.
- Oversaw large portfolio of projects to support teams, report progress, and influence positive outcomes for key stakeholders.
- Created statistical and forecasting data reports using SQL queried, ETL evaluated, and trend forecasted within Excel providing guidance on trends to predict where NMI was heading, by department.
- Designed real time data reports to simplify & summarize data to communicate effectively company-wide with fewer reports.
- Ensured quality control of process changes matched data requirements using closing metrics. Worked directly under CCO to handle compliance with regulatory issues.
- Assisted with GAAP reporting procedures, federal government compliance standards, JACHO accreditation requirements, and multiple Federal Government financial, documentation, and compliance audits.
- Maintained schedules to meet key milestones at every project phase.
- Directed changes to project scope and cost and implemented appropriate change management processes to keep project on track.
- Coordinated cross-functional teams to determine timely delivery and compliance of project requirements that handled multiple department objectives.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
Education
Master of Science - Project Management
University of Southern California
Los Angeles 12.2024 - Current
Bachelor of Arts - Economics
California State University - Los Angeles
Los Angeles, CA 05.2008 - 2010.10
Skills
Performance Optimization
undefinedSoftware
Fast Learner on Any Program
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
How many ideas have there been in the history of the human race that were unthinkable ten years before they appeared?
Fyodor Dostoevsky
Timeline
Master of Science - Project Management
University of Southern California
12.2024 - Current
Analytics, Reporting, and Process Improvement Mgr
Regal Medical Group
12.2023 - Current
Chief Operations Officer
HMS
10.2017 - 05.2022
Director of Data Management
HMS
10.2012 - 10.2017
Bachelor of Arts - Economics
California State University - Los Angeles
05.2008 - 2010.10
Senior Project Manager
Nationwide Medical Inc
04.2004 - 10.2012
Accomplishments
- Achieved 90% increase in sales by introducing OpenERP (a SQL based open source system) for CRM tasks, inventory management and communication for HMS.
- Led a team of 120 in the development of M&A Project for Nationwide Medical.
- Documented and resolved 300 objectives using the above M&A project which led to efficiency gains in every department at Nationwide Medical.
- Achieved a reduction of 60% on days pending using Excel formatted, SQL Query, and graphical dashboard ready report. The report contained multi-directional variables able to assist department management and with the ability to report KPIs with pinpoint accuracy to stakeholders at HMS.
Similar Profiles
Jael GaldamezJael Galdamez
Mail Clerk at Regal Medical GroupMail Clerk at Regal Medical Group
Maythe CastanedaMaythe Castaneda
Medical Social Worker at Regal Medical GroupMedical Social Worker at Regal Medical Group
Paul EliasPaul Elias
Project Manager Inpatient Coordinator at Regal Medical GroupProject Manager Inpatient Coordinator at Regal Medical Group
Alisa ParonyanAlisa Paronyan
HEDIS Outreach Coordinator at Regal Medical GroupHEDIS Outreach Coordinator at Regal Medical Group
Manuel PernillaManuel Pernilla
Assistant at Housekeeping ServicesAssistant at Housekeeping Services