Jonathan Ross Email & Phone Number

Phoenix, AZ, US

Phoenix, Arizona, United States

Phoenix, Arizona, United States

Phoenix, Arizona

• In this role, I:
• Used Excel, SQL Server Management Studio, Oracle SQL Developer, and Microsoft Power BI to provide actionable reporting and insights to teams across the organization
• Used Python, PowerShell, and additional tools to automate and integrate data from multiple internal and external APIs, FTPs, and web platforms
• Administered and troubleshot issues with our Dynamics Great Plains database, Adaptive Insights financial planning software, and related third-party extensions
• Helped develop security best practices with regards to file and system access

Scottsdale, Arizona

• In this role, I have:
• Used SQL, MicroStrategy, Excel, and other data access/organization platforms to analyze financial and operational data as well as develop actionable reports and insights for senior leaders
• Overseen end-to-end business solution creation and design from initial planning with stakeholders to final deliverables such as dashboards, KPI metric reports, models, etc.
• Implemented and currently maintain a company-wide budgeting/forecasting/reporting software platform (Adaptive Insights) for over 250 cost centers for revenues and expenses
• Significantly improved speed, accuracy, and detail of numerous financial and operational metric reports whilst consolidating responsibilities across teams
• Worked with a wide range of team members (from store-level operators to the CEO) to best address financial and operational opportunities, and developed action plans and insights to further progress the business

Phoenix, AZ

• In this role I have created new financial and staffing reports for senior leadership to see incredible levels of detail. I have also developed and maintained a complex financial forecast model which has been used in.
• Prepared monthly G&A expense item budget variance analyses for departments across multiple lines of business
• Processed General Ledger data to create financial reports for company leadership
• Created a monthly forecast for current fiscal year by expense item and line of business
• Refined and rebuilt financial analysis processes and files to save significant amounts of time
• Analyzed staffing to determine headcount and salary budget variances across departments

West Chester, PA

• In this role, I:
• Designed and developed a relational marketing database system using FileMaker Pro database software, containing 21,000 contacts
• Planned and executed marketing campaigns, in collaboration with the company’s Vice President and President
• Managed a marketing team of five employees and assign daily marketing tasks
• Analyzeed past business orders and define geographic areas to launch targeted marketing campaigns
• Developed new products in collaboration with the company’s President to expand offerings to consumers

West Chester, Pennsylvania

Assisted Economics faculty in research and data analysis during summer 2012Collected and analyzed economic data for 21 OECD nations across multiple data setsReviewed relevant foreign direct investment literature

Responsible for receiving product deliveries via truck, as well as stocking point-of-sale shelves in the storeDirected stock team activities to maximize working efficiency

I started at Acme Markets as a low-level service clerk, and exited the company as a cashier who was about to be trained as a manager. I helped assist customers and provided cashier services, as well as some stocking and organization duties.