Jacqueline Senesac Email & Phone Number

Tampa, Florida, United States

● Analyzed payroll accounts including Salaries, Stipends, Bonus’ and On-Call expenses.● Revamped current processes for faster, more accurate data and created presentations utilizing Hyperion Essbase.● Streamlined the physician payroll accrual by consolidated 8 Excel reconciliations into 1 Excel modal. This increased productivity by cutting down 3 analysts to 1, 24 hours to 2, and 20+ tabs to 11 that provided a standardized format for management needs.● Performed ad-hoc analysis utilizing Hyperion Essbase and EmTime for senior management for management needs.

Temple Terrace, Fl

● Planned, built, and maintained rent payments by building a property rent schedule in Excel summarizing rent contracts to be used as a benchmark to reconcile actual rent payments to what the newly implemented Lease Controller Software will pay. Coordinated and worked with the Accounting Department to identify and resolve significant payment variances and helped to resolve.● Put together a master physician file in Excel including all physician detail to keep track of their movements and hours worked.● Prepared, supported, and assisted in the creation of the annual budget in excess of $6.2M utilizing newly implemented Axiom software. ● Accountable for month end financial statement analysis, building presentations and financial reports to summarize operating results in a clear and comprehensive format to support physician practice operations for management.● Continuously strived for improvement by constantly asking the who, what, when, where and why by analyzing actual operating results to budget to understand the underlying cause of substantial variances and aware management of these trends, issues, and opportunities.● Ability to identify strategic areas of opportunity, collected and manipulated large data sets, established facts, assessed results, drew valid conclusions, provided alternative solutions and translated analysis into useful management executive summaries by understanding relational databases, statistical techniques and spreadsheet modeling principals.● Audited submitted invoices to physician contracts including Medical Directorship fees, Call Pay and Bonus agreements.● Performed ad-hoc analysis utilizing PeopleSoft (GL) and Axiom (Reporting/Budgeting) for senior management.management.

Tampa, Florida

● Assisted management in developing and managing the annual budget in excess of $30M.● Developed the weekly cash forecast to oversee that the insurance company payments were being paid correctly and timely according to their contracts. Used actual billing dates, historical trends, and aging schedules to predict future payments. Presented and called attention to any large variances I will follow up on in the daily video conference calls with all the executives countrywide.● Used exceptional research and qualitative abilities in scrutinizing operational key performance indicators to identify the root cause of poor performing metrics and made recommendations for improvement.● Prepared variance analysis reports (Actual vs Historic vs Budget) in Excel to monitor RCM spending. Researched significant fluctuations, documented, and recommended corrective action to management. ● Extracted, collected, analyzed, interpreted, and questioned complex healthcare data of various types from many sources to identify cost savings opportunities to support strategic and tactical needs to back business decisions.● Created PowerPoint presentations to support executive leadership in their review of operating performance● Built staffing models to project the profitability of underwriting new clients by assessing their earnings/profit potential.● Increased productivity by 30% by researching and automating system and process inefficiencies in a claim operations process.● Assisted the Cash team by automating a 2-hour morning daily claim process down to instant results by using Excel VBA macros.● Reviewed RCM vendor invoices to ensure that they were performing to contract and were being utilized in a cost-efficient manner and created an Excel spreadsheet to keep track of any overdue vendor invoices to follow up on.● Utilized JD Edwards (GL) and Adaptive Insights (Budget) to successfully investigate statistics.● Utilized JD Edwards

Tampa Florida

● Coordinated with management and team in building the annual budget with revenue in excess of $173M.● Instrumental in transitioning the existing budgeting software (TM1) to the new BI360 software by working directly with external consultants in creating reports and building dashboards. Built last minute emergency budget files in Excel for the entire company from a late decision made by upper management to retire the BI360 software a week before the budget season. Recognized with a “wish we can clone you” by the VP and Manager.● Provided management insight into trends, issues, and opportunities by constantly monitoring, analyzing, and questioning expenses (Actual vs Historic vs Budget) by utilizing Excel modals to pinpoint significant fluctuations.● Utilized financial systems to their maximum potential and made reporting effective, efficient, accurate, timely and insightful to allow management to understand variances to make effective decisions around resource allocation.● Applied analytical thinking to multifaceted problems, evaluated and drew conclusions from large amounts of data.● Developed a deeper understanding of complex situations and was always eager and able to uncover critical details that others may miss.● Constructed detailed financial models for an audience with limited financial background to assist in their decision-making process.● Very proactive in Identifying process inefficiencies to revamp and boost productivity including reducing a process from 2 days to 2 hours by incorporating Pivot Tables and VBA Macro’s. Was rewarded with an “Excellent job for the quick turnaround” from the VP.● Provided Excel training classes to help the Claims department’s productivity.

Tampa, Fl

● Participated in analyzing financials to generate the budget in excess of $729M.● Analyzed operational expense trends to gage operating performance and promptly called attention to any concerns and resolved.● Built dashboards to supply concise and summarized data for analysts and management.● Streamlined inefficient, disorganized, and manual processes in Excel by building models.● Performed ad-hoc analysis utilizing Sage (GL) and TM1 (Reporting/Budgeting) for senior management.● Performed ad-hoc analysis utilizing Sage (GL) and TM1 (Reporting/Budgeting) for senior management.

Tampa, Florida

● Prepared quarterly forecasts projections and budget using Hyperion in excess of $3.7B by partnering with multiple departments including Accounting, Revenue, Accounts Receivable, Accounts Payable and IT.● Utilized advanced Excel and Access skills to manage large amounts of data to automate the budget and forecast process which resulted in the elimination of keying errors, generating faster and 100% accurate real time statistics, and created reporting capabilities.● Provided process improvements and efficiency initiatives to ensure the month and year end closing schedule were met with accuracy.● Subject Matter Expert in calculating the productivity index for every departments headcount to see that they are correctly staffed.● Created variance analysis financial models in Excel utilizing Hyperion Essbase and VBA macros for department utilization.● Transitioned all VBA internal and external reports from the old Essbase Ad-in code to the new Hyperion Smart View software language.● Participated in testing a new Forecast/Budget tool (Oracle/Essbase) and assisted in fixing errors by working with external consultants.● Executed ad-hoc analysis utilizing Oracle Hyperion, Essbase, Smart View, TSI and Crystal reports for senior management and CFO.

Brandon, Florida

● Created a myriad of Access databases and Excel spreadsheets to better organize, standardize and manage month end close. ● Prepared, analyzed, standardized, and recommended improvements to general ledger account reconciliations including inventory, liabilities, rent, marketing fees, coupons, and recycling fees in accordance with GAAP.● Performed analysis of accounts receivables and payables, cash accruals, and foreign exchange.● Ensured the accuracy of 150+ manual journal entries including but not limited to pallets & shells, rebates, and freight.● Produced financial statements including usage, production volume, inventory, and shrinkage.● Reconciled capital deposits involving millions of dollars in receivables.● Promoted to lead analyst to standardize the corporate pricing structure by maintaining an Access database and working closely with 5 business units worldwide. ● Consolidated reports, account reconciliations and journal entries during the creation of the new Shared Services Center.● Instrumental in on-boarding staff through the multi-year implementation of the SAP ERP system through 1 on 1 training support.● Performed ad-hoc analysis utilizing Lawson, SAP, AS400, Basis and Monarch for senior management.

Tampa, Florida, United States

● Audited 100+ expense reports and resolved any discrepancies by interacting with managers and partners.● Reconciled general ledger accounts, researched variances, and made manual journal entries in Excel.● Designed and presented a training manual in PowerPoint for new employees resulting in shorter training periods.● Promoted during the merger with Coopers & Lybrand to train new analysts on corporate policies and procedures. Gained experience and confidence in delegating tasks, developing trust, and creating a positive team atmosphere.