● Oversaw primary finance system for Hotel Accounting, Revenue Strategies, and Operations planning for about 130 properties● Implemented automation in month end reporting, including P&Ls, to reduce errors and turn time to 2 days from about 1 week● Provided guidance on the use and interpretation of financial results and their translation to financial planning models● Conducted period comparison analysis for about $1.5B/Yr Forecast and Budget datasets to remove flaws and ensure feasibility● Lead team on supporting Financial Reporting requirements, Data ETLs, and establishing controls for user admin audits● Kept and updated owners' financial reports to ensure compliance with regulations and alignment with industry standards● Validated daily and monthly data loads between primary system to Financial System of record for completeness and timeliness● Maintained driver templates for all properties projection models reducing errors through standardization● Triaged and communicated system deficiencies to product owners and return resolutions or timelines to Business users● Served as the primary liaison between technology and finance teams enhancing operational efficiency● Organized and approve the setup of new, or changes to existing, Chart of Accounts codes to systems● Administered training for Accounting system use to new users and provided ongoing support● Evaluated and implemented enhancements to existing reports, tailoring to end-users' needs and improving report accuracy

● Develop strategic action plans for short term architecture and long term growth of the data organization● Produce Looker Dashboards and Looks to visualize key data points for internal and external stakeholders● Construct SQL based models to organize data for reporting from structured and semi-structured sources● Analyze large data sets for key indicators or trends and propose opportunities for enhancements to executive management● Establish stop-gap solutions for immediate reporting and analysis needs of the Finance, Insurance, and Product departments● Evaluate and implement improvements to existing reports to better suit needs of end business users● Outline cross-functional standards for technical structure and business reporting layouts● Identify key areas for development within data governance process and structure

● Modernize and automate over 30 monthly reports saving an average of 1,800 hours annually● Manage SQL server data governance, organization, and structure for more than 25 databases across multiple servers● Develop SQL queries to improve system performance and reporting accuracy, reducing errors by up to 100%● Lead data cleanup effort of around 100K records across accounting and human capital management systems● Create PowerBI Visualization Dashboard of about $500M worth of each billings and collections management by Clients/Matters● Import and Execute custom script Visuals into report dashboards● Maintain ad-hoc and scheduled Elite 3E metrics for creating and auditing continuous reporting● Train colleagues in various systems and languages such as SQL, Elite 3E, VBA, and Excel● Provide guidance and advice on system utilization and functions to end users● Modify and deploy report design changes with SQL Server Reporting Service (SSRS) Report Writer● Analyze user needs and functions to create and implement process improvements● Act as a liaison between technology groups and accounting or law firm management● Control versioning and security of over 50 monthly reports in NetDocuments document repository● Write Visual Basic macros and executables to automate regular reports and tasks, contributing at least 50 original procedures● Create new reporting standard formats for management requests● Title change, promoted to Senior Financial Systems Analyst after less than 1 year

● Assigned and audit system roles for about 1,000 daily users according to SOX regulatory requirements● Adjusted financial report mapping to meet reporting model requirements● Redesigned report layouts with BIRT (Business Intelligence and Reporting Tools) report writer● Identified potential upgrades for system design to improve business processes● Rebuilt system audit report with original VBA macro automation saving around 4 work hours per week● Advised Finance and Accounting teams on Workday Financial System functionality

● Developed and manage various SharePoint Key Performance Indicator (KPI) tracking task lists● Wrote SQL queries to convert raw data from multiple sources for single data model● Projected payment totals for about $10M portion of monthly treasury budget across multiple processing methods● Used gateway pipelines to connect source data and dashboards for instant real-time metric updates● Manipulated SharePoint data with Power BI to deliver metrics dashboard for upper management● Produced Excel reports and compare accuracy against account batched transactions in Great Plains Accounting software● Created ODBC connection to reduce manual reporting process to near instant automatic process● Verified and approve over 15,000 monthly rent transactions transferred between systems by ledger account● Compiled and analyze outstanding payable items to identify problems among over 50,000 monthly transactions● Created trend analysis report of total monthly payments by ledger account made to all vendors● Constructed Macro driven Excel dashboard for monthly reporting data manipulation● Cross-Trained team members on Analysis Processes and Excel Functions

● Developed Excel formulas to eliminate manual updating of multiple financial documents● Updated and developed Cash Flow workbook for reduce reworking of reports for company Comptroller● Consulted with Finance and Accounting on Excel functions and formatting improvements● Automated the credit card process to decrease project time from several days to instantaneous● Utilized Access query functions to locate flagged accounts that required reconciliation● Produced an aggregate report to ensure utility cost savings were correctly quoted by servicer