Cesar Gatica Email & Phone Number

Seattle, Wa, Us

US Reporting for Amazon Transportation Services

New Brunswick, Nj, Us

Medical

New Brunswick, Nj, Us

➢ Managed $1.2B of global IT products/services’ spend, budget, and forecasting for more than 200 legal entities➢ Led global analysis of vendor spend across regions, projects, and operating companies➢ Partnered with cross-functional (IT, Procurement, Engineering, Operations) teams and with 3rd party vendors➢ Provided finance leadership & decision support for business plan process with quarterly updates➢ Developed automated pricing & billing models utilizing Excel, PowerQuery and PowerPivot➢ Collaborated with business partners in the management of service portfolio, strategy, and delivery➢ Identified innovative solutions to improve costs and related analytics to drive business decisions➢ Found opportunities for improvement in execution, design, and implementation process changes➢ Won multiple Recognition Awards for going above and beyond as well as educating others on various topics

La Chaux-De-Fonds, Neuchâtel, Ch

➢ Implemented the creation of over 10 monthly and quarterly P&Ls for all North America business➢ Owned multiple reporting requirements for CFO, CEO, and international business partners➢ Performed analysis of actual v. budget for P&L accounts and cost centers➢ Presented monthly analysis of Key Performance Indicators using dashboards in Excel and Syrus➢ Reconciled P&L and Balance Sheet with Accounting Manager on Quarterly Closings➢ Assisted Accounting Manager with monthly Balance Sheet review➢ Participated in inventory analysis on a quarterly basis➢ Composed and entered recurring and non-recurring Journal Entries, Accrual Entries and Reversal Entries in SAP➢ Successfully business partnered with Commercial, Sales, Marketing, and Upper Management teams

Totowa, New Jersey, Us

➢ Maintained Sales data in Microsoft Access, analyzed data in Excel, and loaded data into PowerBi for Sales Teams➢ Processed and reported contractual chargebacks for clients and coordinated with A/P to send out checks➢ Teamed up with accounting to have chargeback transactions posted into correct GLs➢ Provided different departments with pricing and costing depending on various parameters and contractual standards➢ Improved Access database by learning, mastering, and applying SQL expressions as per our reporting needs➢ Mentored coworkers as Excel/Access/Costing/Pricing

New Brunswick, Nj, Us

➢ Managed $160M of budgets for Admin functional areas across three Medical Devices companies➢ Controlled Quarter/Year-End close, reconciliation, and interco accounting while remaining SOX & GAAP compliant➢ Formulated annual operating budgets and updated monthly forecasts➢ Utilized SAP, Lynx, and HFM software to post Journal Entries, create reports, and review ledger data➢ Leveraged Microsoft Excel to create Budget v. Actual reports to provide support and drive better decision making➢ Analyzed P&L budget variances and report to upper management and business partners➢ Won multiple Awards for outstanding work and positive results

St. Louis, Mo, Us

➢ Provided analytical, quantitative, and financial cost modeling➢ Executed financial analyses and consultation for clients based on individual needs➢ Offered clients financial recommendations through creative modeling and analyses➢ Conducted in-depth analyses to identify client performance and recommend opportunities and savings➢ Managed development of pricing for client renewals and proposals from P&L modeling to execution of client contract➢ Maintained on-going management of a client's contracts to ensure compliance with financial terms

Indianapolis, Indiana, Us

➢ Oversaw monthly & quarterly telecom spend for three clients (including two global banks)➢ Accumulated operational and financial data from vendors to create reports for clients➢ Modeled out complex Excel analysis to manage and maintain useful client/vendor data➢ Participated in quarterly telecom spend reviews with clients➢ Intermediated between clients and vendors to resolve inconsistencies and disagreements➢ Implemented ASPAC taxation process which was shared across the company to use as a standard➢ Won “I Make it Happen” Award for outstanding work and dedication to the improvement of our processes

Indianapolis, Indiana, Us

New York, Ny, Us

➢ Managed costs and expenses associated with revenue generating projects➢ Posted adjusting entries to modify general ledger accounts➢ Assisted upper management with posting journal entries into our Front End Financial System➢ Created statements of open accounts and aging reports for clients➢ Maintained monthly balance sheet analysis for asset and accrual accounts

Paris, Ile-De-France, Fr

➢ Entered daily invoices into SAP journal system➢ Balanced G/L accounts pertaining to account payable department➢ Processed utility bills for all store locations in the United States➢ Updated monthly utility Excel Spreadsheets in order to maintain accurate records➢ Journalized sales tax expenses for every state in which the company operates➢ Stored all paper invoices into a organized storage system for easy access➢ Verified all utility payments in order to avoid any late penalties➢ Confirmed and fed corporate expense reports into SAP system ➢ Attended meetings regularly in order to learn and understand other department operations➢ Met company CEO, Steven Birkhold, in a meeting and discussed company tactics and future planning➢ Assisted in month closing operations

Charlotte, Nc, Us

➢ Handled substantial cash amounts on a daily basis➢ Sold financial products to qualifying customers➢ Provided world-class service to all customers➢ Processed various monetary and debt transactions➢ Administered private customer information

New York, Ny, Us

➢ Managed assets, depreciation, accruals entries, asset decommission, financial analysis, and cost attachment ➢ Prepared monthly cash receipt reports and updated them daily➢ Posted journal entries using J.D. Edwards➢ Updated monthly financial analysis ➢ Created formulated spreadsheets and pivot tables using Microsoft Excel➢ Updated cost schedules and forecasting reports➢ Created expense reports for executive employees