Ron H. Email and Phone Number

Analyzed and communicated financial information to clients, driving financial analysis and control functions. Managed rollover and change management for MCAPS Core Finance key revenue reports using Excel and Power BI. Maintained key dimensions and hierarchies, communicated updates daily. Generated monthly pipeline snapshot reports, monthly revenue close packages, assisted revenue outlook reports, and quarterly revenue forecast packages.Partnered with technical and solution teams to create agile financial reports/models for robust analysis in a dynamic business environment. Supported ad-hoc finance analysis of key business metrics and models in insights gathering efforts.

Performed business operational duties, including interfacing with multiple data systems, ensuring data quality across multiple reporting layers. Ensured integrity of system and data quality via User Acceptance Testing (UAT), reconciliations and audits. Collaborated with IT program management and Engineering teams in analysis, development, test, and production support to facilitate required bug fixes and/or enhancements. Maintained, updated and ran quarterly SOX user audits to ensure compliance of MS Finance governance policies.

Develop and maintain worldwide-level reports for the WCB ECIF and GSMO PnL divisions using Microsoft Excel including advanced functions, pivot tables, Power Pivot, Power Query and VBA macros.Validated metrics and insights leveraging budgeting and forecast models.Collaborated with Finance Management & Controller teams for report requirements gathering, analysis and user acceptance tests (UAT) through User Stories on Azure DevOps.Leverage DAX within Power BI to develop reports that enable financial controllers across entire divisions to make sound decisions.

Process engineering and execution of creation & maintenance of new and ongoing reporting processesDevelopment of standardized analysis models with relevant step by step instructive documentsCreation of best practice documentation for all finance processes and process improvement initiativesExtensive data analysis, template creation, and supported multiple Controllers and Partners across business segmentsReporting examples include Budget, Forecast and Revenue recognition Rhythm of Business cycles.

Executed development of procurement processes and primary procurement systems to improve service, efficiency, quality, and cost reductionsAnalyzed data to determine root cause, improvement opportunities, and potential for riskInterfaced with suppliers, developing strong relationships to assist business requirements; evaluated supply and supplier issues and recommended appropriate resolutionCompiled, tracked and summarized measurement data; developed actionable reports from results

Led development of diversified marketing strategy for mobile heating, ventilation, and air conditioning manufacturerCreated an integrated lifecycle workflow for new product production, across initial procurement, to production, to product completion▪ Evaluated sales history and slow-moving inventory items; developed forecasting metrics to prevent excess inventory▪ Oversaw maintenance and data input of three product catalog databases, including new product initiatives▪ Created and updated social media accounts, utilizing Google Analytics for website and mobile application projects

Responsible for purchase and sales order process, coordinating with vendor and supplier warehousesInterfaced with internal and external customers, building strong inter-professional relationshipsDirected product line, complying with department and company requirements and objectivesConfigured purchasing requirements to automate data entry in SAP Master Data MaintenanceExtensively utilized technical research skills across bills of material, product service manuals, and operating instructions to determine value-add to customer interactions

▪ Promoted from initial role as Material Expediter to serve in dual position of Account Manager and Contract Administrator▪ Led multiple departments in the coordination of data input process for contract negotiations▪ Responsible for the management and support of international accounts with multi-million-dollar value▪ Improved organization’s customer scorecard ratings through review of Key Performance Indicators (KPIs)▪ Managed all aspects of planning, supply chain, Agile Product Lifecycle Management, and client relationship methodology▪ Spearheaded effort to transition paper-based filing system to electronic database, successfully increasing productivity and information retrieval by 50%▪ Transitioned into supporting regulatory compliance functions, managing export and International Traffic in Arms Regulations accounts

▪ Specialized logistics duties as an enlisted officer, training, supervising and mentoring 10-member supply clerk team and 12 work centers▪ Performed forensic data analysis to identify stock discrepancies within monthly purchase accounts

PowerBI, PowerPivot, PowerQuery, Excel, DAX, MDX, SQL, OBIEE, SharePoint, Lotus Same Time, Adobe Acrobat, WEBEX, MS LiveMeeting, MS Lync, Agile Product Lifecycle Management, MFG/PRO-QAD Enterprise Applications, SAP, Oracle, Discoverer Reporting, HTML