Cesar Wilen
Ponte Vedra,FL
Summary
With over 15 years of cross-functional experience in accounting and business intelligence, I excel in leveraging advanced analytics tools like Power BI, Excel, SQL, VBA, and Power Automate to drive strategic business decisions and enhance operational efficiency. My career is marked by a proven track record of automating processes to reduce time and errors, integrating comprehensive financial insights with robust data analysis to optimize business operations. Known for adaptability and a proactive approach, I thrive in dynamic environments and am committed to using my analytical expertise to deliver value and innovation across various business sectors. Notable achievements include leading several full payroll system migrations, cutting out weeks of manual work and developing Power BI dashboards that transitioned KPI monitoring from weekly to real-time updates, significantly enhancing decision-making processes.
Overview
16
16
years of professional experience
3
3
Certifications
Work History
Senior Accountant
Nemours Children's Hospital
11.2023 - Current
- High-Volume Cash Reconciliation and Financial Analysis: Efficiently reconciling multiple highvolume cash accounts daily
- Successfully implementing enhanced automations and accuracy in financial reporting
- Collaborative Problem-Solving and Creating Improvements: Documenting procedures and supporting internal and external shareholders.
Controller
Big Country Dermatology Pharmacy
11.2022 - 10.2023
- Led financial operations, including managing a $10 million annual revenue P&L
- Successfully performed full migration of the company's payroll
- Implemented automation solutions, reducing manual work by 50 hours per month
- Created Power BI dashboards for real-time KPI monitoring, increasing scorecard updates from once a week to real time.
Senior Accountant
InLight Real Estate Partners
10.2021 - 10.2022
- Implemented advanced pivot tables to showcase project costs by property
- Developed Excel-based financial models from ERP data
- Managed treasury, accounts payable, property financials, and systems migration.
Controller
Credit Management Company
02.2011 - 09.2021
- Managed end-to-end accounting processes, including financial statements, cash flow management, budgeting, forecasting, month-end closing, bank reconciliations, payroll, and 401k, ensuring financial compliance and efficiency
- Automated commission, vacation accrual, new business, month end, invoicing, and ad-hoc reports for team leaders
- Took over an operations performance report manually updated daily to a fully automated real-time report 4x daily, saving 22 labor hours per month
- Built a monthly reporting system from scratch for a company we acquired in 2015 using ODBC, Access, Power Query, & VBA Macros all in unison
- Debugged prior VBA code to restore a broken process! Created an advanced pivot revenue report giving President multiple metrics of last 10 years of income
- Developed a shadow accounting suite of reports in one Excel workbook, mirroring all ERP data from Microsoft Dynamics
- Performed to query data 50% faster to achieve month end objectives.
Senior Staff Accountant
Marriott Vacation Club
12.2007 - 09.2010
- Managed domestic and international cash receipts and disbursements
- Eliminated 45 hrs/month manual work automating reconciliations and journals
- Nominated to the Process Improvement Team by Senior Director of Accounting.
Education
Bachelor of Science Financial Management -
Skills
Power BI: Data Wrangling & Modeling, DAX, Reports & Dashboards, Power BI Service
MS Excel: PowerPivot, Power Query, Pivot Tables, VBA
Database Management: SQL, Microsoft Access, Data Integration across Multiple Platforms
Software: QuickBooks, Oracle Cloud, MS Dynamics, Great Plains, Sage Intacct, MS 365, Google Suite
Accounting: Financial Statement Preparation, Account Analysis, Reconciliations, Report Automation
Payroll Administration: ADP, Paylocity, QuickBooks Payroll
Continuous Learning: DataCamp, Audible, YouTube
Payroll Management
Bank Reconciliation
Report Preparation
Certification
Microsoft Certified: Power BI Data Analyst
Favorite Reads
- The Four Agreements by Don Miguel Ruiz
- Be Useful by Arnold Schwarzenegger
- Verbal Judo by George Thompson
Timeline
Senior Accountant - Nemours Children's Hospital
11.2023 - Current
Controller - Big Country Dermatology Pharmacy
11.2022 - 10.2023
Senior Accountant - InLight Real Estate Partners
10.2021 - 10.2022
Controller - Credit Management Company
02.2011 - 09.2021
Senior Staff Accountant - Marriott Vacation Club
12.2007 - 09.2010
Florida Southern College - Bachelor of Science Financial Management,