Gilbert Villa Email & Phone Number

Los Angeles, Ca, Us

Redmond, Washington, United States

▪ Analyze Office Commercial and OnPrem business, and present key findings during monthly LT meeting. Key findings include overall seat/license performance, revenue growth and VTF outliers, and collaboration with partners to drive actions around key areas of improvement including M-Suites, CSP, and Upsell Motions from basic to premium skus.▪ Developed an all-up model to track the performance of our Hosting (primarily Cloud Solution Provider Program) sales channel and provide analytics at a granular level. Model is currently used as a baseline for EG and partners as a baseline for CSP performance and KPIs.▪ Assess revenue and EOP seat impact of debundling our Teams product from premium suites across the EU and ROW. KPIs are presented and distributed to SLT on a monthly rhythm to assess customer behaviors and performance. Modeled and quantified the financial impact of the new unbundled sku for LTs which helped be an additional component for deciding to launch WW later in the fiscal year (FY24) (WCF Impact Award Winner).▪ Implemented the new AGR ARPU Bridge framework to look at quarterly growth drivers, which are critical moving forward as many of our new products do not count for additional seats from an external perspective. This method lays out the impacts of Price/Mix/Non-seat generating AGR and helps explain drivers in a much clearer way.

Burbank, California, United States

▪ Oversaw the monthly close process and prepare journal entries and monthly financial reportsensuring their accuracy and timeliness▪ Modeled annual budget and 5-Year Plan to give executives and investors insight into the company’scurrent and future performance goals▪ Distributed monthly P&L presentation dashboards to exec team to highlight KPIs and measureperformance on an MTD and YTD basis▪ Collaborated with accounting and cross-functional teams to identify inefficiencies and gaps in ourOrder-to-Cash process, and work towards implementing solutions to achieve desired outcomes▪ Partnered with senior business leaders to define and analyze critical business and financial goals todrive accountability and influence critical decision making▪ Leveraged tools and technologies (Power BI, Excel, VBA, Python, Data Queries) to provide keyinsights, and optimize operational workflows and increase overall efficiency▪ Streamlined finance processes to mitigate risk and find value within the business by automatingfunctions and reducing manual updates▪ Developed and lead a team of two analyst to ensure all ad hoc and monthly reporting goals are met

Burbank

▪ Migrated and train users and company (worldwide) to use QuickBase and other database systems to centralize production data and metrics▪ Developed user-friendly financial models for management and production staff to use daily to track project progress, associated fees and costs, and forecasting functionalities▪ Developed new forecasting method and process to improve accuracy and timeliness▪ Developed reporting and billing processes using cloud-based program (QuickBase) to give management real-time data insights▪ Used VBA and macros to increase efficiency by reducing the amount of time reports take to complete and errors made by manual data entry

Greater Los Angeles Area

▪ Consolidated data from multiple databases and locations (including international) to determine monthly revenue totals▪ Compiled weekly revenue forecast for the current and future 3 months and highlight changes for all global locations and business segments▪ Led company-wide initiative to increase efficiency, accuracy, and timeliness of revenue and forecasting reporting by holding training sessions and creating user-friendly reporting tools

Greater Los Angeles Area

▪ Built and maintained complex billing system process unique to digital media advertising company for five locations▪ Developed multiple Excel spreadsheets to track client revenue▪ Performed gap analysis to identify weaknesses in previous revenue recognition process and launched a new revenue tracking and billing process to improve timeliness, accuracy, and reliability▪ Assisted in set-up and implementation of Concur employee expense reimbursement process▪ Entered monthly over $500k in revenue and supporting balance sheet adjusting journal entries▪ Supervised and oversee work of AR specialist and two team members in Dallas to ensure accuracy and timeliness▪ Tracked and reconciled over $2.5 million in monthly pass through costs▪ Initiated revenue and balance sheet variance analysis reports for month end closing▪ Designed waterfall reports for executive management team to track monthly revenue attrition and increases

El Segundo, Ca

▪ Transitioned clients to proper revenue recognition principles under GAAP▪ Instituted collections process that resulted in a 67% decrease in AR aging▪ Launched automation processes in QuickBooks Enterprise which reduced the time needed to complete tasks by two weeks▪ Assisted in month-end closing process by completing monthly credit card and departmental revenue reconciliations with team▪ Created credit memos and journal entries for bad debt expenses and allowance for doubtful accounts▪ Responsible for the invoicing and maintaining historical billing information of over 300 clients▪ Created journal entries for monthly revenue accruals and deferrals▪ Collaborated with collections agency to successfully obtain over $100k in payments from delinquent accounts

Greater Los Angeles Area

▪ Assisted KPMG consultants and internal auditors by excavating requested invoices and documents▪ Indexed invoices of over 100 companies into online Oracle R12 database▪ Conducted purchase order compliance to ensure accurate cash flow and integrity▪ Demonstrated critical thinking and ability to accomplish tasks efficiently and with minimal supervision

Greater Los Angeles Area

▪Provided clients with excellent services based on their specific needs and areas in need of improvement ▪ Self-started tutoring company aimed to service students in need of academic guidance and aide

▪ Support staff and the Student Technical Support Lead▪ Perform system testing and minor troubleshooting and repair of multimedia presentation systems▪ Maintained department’s incident report below five percent

Greater Los Angeles Area

• Produced inventory reports on Microsoft Excel and noted any discrepancies for upper management• Created and prepared presentations on Microsoft PowerPoint for team meetings detailing weekly needs and results

Greater Los Angeles Area

▪ Coordinated and facilitated event planning for Los Angeles Mayor Villaraigosa▪ Supervised and trained new junior employees and/or volunteers▪ Assisted technologically challenged employees by providing basic computer and Office tutorials

Greater Los Angeles Area

▪ Recorded and reported current inventory to ensure accuracy ▪ Recorded sales on Excel sheets after closing hours