Business Intelligence Specialist

• Feb 2022 - Present

Senior Business Intelligence Analyst and Developer

• Apr 2020 - May 2022

● Collaborate with business stakeholders to identify and define project deliverables, create business requirements documents, and develop solutions within enterprise business intelligence platforms● Organize complex sets of business data and translate it into cohesive, professional reports, models, and dashboards and ability to understand and respond to business related inquiries within the scope of the material● Identify and document business requirements for multiple reports and datasets across several Business groups within the organization to create a centralized BI platform for internal users to access RSI’s rich data repository ● Collaborate with IT to isolate and troubleshoot data integrity problems across RSI’s business intelligence environment, including but not limited to, Enterprise Data Warehouse (EDW), Internal Analytics generated by the enterprise BI platform, and external analytics presented to Burger King franchisees and supply chain partners● Coordinate with IT to identify opportunities to improve processes and strategies within our systems and assist with deploying software upgrades, minimizing downtime, and ensuring Data Quality standards are met● Develop policies and procedures for the collection and analysis of data● Provide training and coaching of business intelligence tools to all internal users● Monitor data integrity checks to ensure accuracy and completeness of the DC data● Analyze and Develop any ad hoc dashboard requests and analysis from the CEO and other Executives

Senior Business Performance Analyst

• Apr 2019 - May 2022

• Provide optimal business solutions to achieve operational and financial goals• Develop business presentations for the executive team and approximately 7,100 Burger King stores as needed• Create performance measurement frameworks to analyze the performance of Burger King Promotions.• Utilize company resources to curate and validate data. • Generate monthly reports utilizing market and financial trends.• Prepare P&L analysis for RSI Management, BA Committee Calls, and Board Meetings• Build custom models to facilitate the loading of disparate franchisee P&L data into the RSI P&L database• Onboard new members to the RSI P&L data sharing and reporting platform. • Build and monitor P&L data integrity reports to identify and correct any data exceptions• Oversee the monthly food & commodity forecasting process ensuring that all forecasts are completed in an accurate and timely manner• Responsible for compiling the Food Cost and Price Index and measuring purchasing performance vs the Producer Price Index (PPI) • Responsible for pulling PPI data from BLS website only a monthly basis • Prepare slides for quarterly Food Cost and Price Index presentation for RSI and BKC management• Responsible for updating the Food Cost Forecast Tool on RSI Web monthly• Prepare ad hoc Food Cost and Price Index analysis for RSI management and BKC

Senior Financial and Business Intelligence Analyst

• Jul 2015 - Feb 2019

• Developed complex and occasionally highly complex financial analysis models to guide and influence CEO, CFO and business leaders in strategic decision-making. • Oversaw and led the annual budgeting, forecasting and analysis process for all divisions and hospitals in the company which amounts to approximately $1B in Revenue. • Assisted in preparing monthly, quarterly, annual financial reporting packages, as well as identify alternative methods to introduce / enhance automation. • Partnered with IT, Operations and Business intelligence to help organize / enhance financial data creation and identify potential opportunities / issues with information systems data output. (SQL) • Worked with senior management and executives in effort to help in understanding the reported results of operations, explained variances, developed trends and made recommendations where applicable for improvement in earnings. • Organized complex amounts of business information and developed it into cohesive, professional reports and presentations, with little guidance and ability to recognize and respond to business related issues within the scope of the material. • Actively participated in the strategic planning, target setting, and annual planning processes, and performed risk and opportunities analysis versus business outlook. • Ensured adherence and compliance to financial laws and guidelines. • Prepared ad hoc analysis and reporting as required. • Provided training and coaching of all systems to Division VPs, AVPs and Accounting Team.

Senior Reporting and Budget Analyst

• Sep 2014 - Jul 2015

• Reported and analyzed capitation, membership, shared risk arrangements, claims, provider incentive programs, and stop-loss provisions. • Handled all Budgeting and Forecasting for the CFO and continually improve detailed forecasting/budgeting processes and models to support the short/long term needs of all medical centers.• Evaluated profit and cost efficiencies in various areas of the organization as needed.• Utilized financial management systems to consolidate and analyze large amounts of data.• Was responsible for a variety of monthly financial management reports, analyzed variations in forecasts and actual performance; determined reasons for variance; completed written summaries of findings. • Performed financial statement analysis to support the consideration and execution of M&A opportunities, including detailed financial modeling.• Interacted with executive managers, medical administrators regarding weekly and monthly reports.• Identified, implemented and developed analytical tools for various areas of the business. • Identified opportunities for process improvement and policy development and engaged in the design.• Provided ad hoc training of all systems used in both the Accounting and Finance departments.• Effectively communicated and presented the critical financial matters to the Board of Directors.• Provided solid leadership and development for the Finance staff. (5 Junior Analysts)

Senior Corporate Accountant

• Nov 2011 - Sep 2014

• Prepared and analyzed financial statements and supporting schedules for monthly, quarterly and yearly close, as well as, reported on variances.• Confirmed financial status by monitoring revenue and expenses; coordinating the collection, consolidation, and evaluation of financial data; preparing special reports.• Prepared monthly account and cash reconciliations.• Monitored and reported capital expenditures.• Yearly tangible property tax reporting on 80 locations.• Assisted Treasury Manager with cash reconciliations and cash management, as well as, oversee the cash flow.• Was responsible for debt covenants and quarterly debt compliance. • Prepared annual financial budget and rolling forecast.• Payroll reporting and analysis.• Supervised accounts receivables operations on medical claims transactions. • Supervised, directed and reviewed the work of accounting staff. (12 staff member)• Reviewed general ledger on a monthly basis for accuracy of posting. • Documented and monitored all internal controls.• Created ad hoc financial reports and performed other duties as assigned or required.• Implemented recommendations to improve account processes and procedures.• Assisted with request from internal and external audits.