Ross Brubaker Email & Phone Number

Columbus, OH, US

• Consult for diverse group of external clients spanning across Retail, Medical, and Manufacturing industries
• Create custom reporting dashboards to help clients more quickly and better understand their business results
• Built multiple new websites in collaboration with Marketing team, focusing on SEO and Organic/Paid Media, increasing traffic to medical client by 41% [Website examples available upon request]
• Financial modeling and sales forecasting for clients focused on margin improvement, resulting in one client doubling their revenue within a year in preparations to sell their business
• Manage the internal Rapid Consulting business for 5 partners including website, financial projections, accounting, and payroll to drive savings and tax efficiencies

Venice, California, US

• Managed reporting for $30M revenue across 7 locations including integration of sales data and POS technology from different systems for three newly acquired business and two new corporate-owned stores
• Built and launched new e-commerce platform integrating a new POS system with vendor/inventory management system while complying with strict state-level regulations across the US
• Created a custom integrated CRM loyalty program to drive sales and grew the member base to 80k in 4 months

Columbus, Ohio, US

• Created and distributed a daily sales report including visualization and analysis/commentary integrating information from multiple data sources as the business scaled from 1 to 196 locations
• Finance liaison for leadership and cross-functional teams needing new reports and data
• Created and automated hourly, daily, and weekly reporting using Python and analyzed reports to make recommendations to leadership for improving margin and profitability
• Ran weekly cash sales posting for 196 locations across the country
• Developed algorithm for the Real Estate team to analyze locations and local regulations in order to choose the most profitable locations for new stores
• Audited expenses to improve margin resulting in $350k in phone system and $150k in POS equipment savings

Woodbridge, Ontario, CA

• Lead analyst supporting 50-person sales team to prepare ad-hoc data summaries and customer facing presentations
• Launched new project management software, Asana, to help with monthly and quarterly reporting
• Implemented VBA to automate recurring legacy reports to improve efficiency and accuracy
• Managed commission program for sales team and regional directors
• Implemented new visual reports using Power BI and data warehouse to increase and simplify data access

Worthington, Ohio, US

• Coordinated daily projects for commercial construction builds, specializing in automation and security
• Managed charity website project, Power Giving, and collaborated with developers
• Worked to find cost saving solutions for security, automation, branding, and equipment

Columbus, Ohio, US

• Worked part-time on projects for the development department to help build clients
• Built an internal intranet site to help the employees communicate and access information across multiple offices

Columbus, Ohio, US

• Grew an understanding of how a Non-Profit operates and assisted in opening new offices in Ohio
• Worked with the COO at the 4th largest Small Business Administration microlender in the United States
• Increased Excel skills with Visual Basics to create macros automating the Lending department’s processes
• Built a new automated timesheet procedure to correspond with the allocations of the institution’s funds
• Worked with different teams and departments to learn more about creating and running small businesses

Boston, Massachusetts, US

• Responsible for preparing and analyzing interim and annual financial statements in accordance with relevant GAAP requirements for alternative investments (hedge, private equity, exchange, and real estate) funds
• Collaborated with a small team to meet deadlines on projects for various tasks required to produce statements
• Increased efficiency and accuracy by utilizing Excel VLookup and SumIfs formulas to extract and analyze relevant information from large trading and investment holdings data exports
• Verified that statements and notes were free of errors, and formatting was in line with client templates
• Assisted with interviewing and selecting new students for upcoming Co-op positions

Columbus, Ohio, US

• Full-time member of the Strategy and Business Development division at a multi-hospital organization
• Helped conduct research and analysis of new partnerships for the growth of Joint Ventures
• Demonstrated skills and enhanced knowledge in Microsoft Office products such as Excel to research physicians for growth opportunities and learned how to use and communicate using Lotus Notes
• Worked within a team to write and prepare request for proposals and complete due diligence while communicating within the office in a professional manner