Amy Jones of Elberta, AL, has been named to the Chancellor's List at Troy University for the spring semester/Term 4 of the 2016/2017 academic year. The Chancellor's List honors full-time undergrad...
May, 22 2017 - Verified by Troy UniversityRecruited to use expertise in providing financial analysis for a wide range of constituents; liaised and communicated with Segment/SBU Controller, Finance Leadership, Data Operations team, Computer Competency Center and IT.
Key Contributions:
♣ Developed new methodology, standard work and trained other global entities on Excess & Obsolete Inventory (E&O), Work in Process (WIP) and Quarterly Statement (Q19) financial models.
♣ Supported requirements for month-end and quarter-end financial reporting for Corporate and Americas.
♣ Provided expertise during internal/external audits, monthly account closing, forecasting, pricing and budgeting processes.
♣ Reviewed company’s consolidated financial position on a monthly basis and prepared reports and analyses.
♣ Successfully contributed as technical and business subject matter expert in all reporting projects launched.
♣ Team member and supported SAP ‘Go Live’ by designing universes (tables) and data dictionary needed for Aerostructures future reporting needs.
♣ Voice of the Customer collection, analysis and reporting (Scorecard)
♣ Designed, validated and implemented the following:
o SAP business object reports and detailed specifications that met business partner requirements
o Automated VBA/Excel job scheduling tool based on management and user specifications
o MS Access front/back end Work in Process visual including dashboard which proactively measured sales, cost, profit, and turn-around-time
♣ Led slow moving inventory incentive for teams by creating tool to manage inventory
♣ Migrated current applicable reports from MS Access to Business Objects (specifically Web Intelligence (WEBI)).
♣ Effectively drove customer satisfaction through direct, energetic, high-value communication of individual reports/analyses.
♣ Remotely delivered desktop MS Access support using Bomgar (Secure Remote Support & Privileged Access Management Solution).
♣ Worked cross-functionally with Corporate IT and Business units, identifying reporting solutions to drive value through reduction of repetitive and costly manual reporting methods.
♣ Managed metadata across operations and finance for Alabama Service Center
♣ Anticipated and identified issues that inhibited the attainment of project goals and implemented corrective actions.
♣ Owner of prior ERP system data located on SQL server for warranty purposes.
♣ Trained users on Microsoft Excel by conducting formal training and constructing training guide.
Promoted as strategy analyst to handle ad-hoc database analysis requests including managing on-going projects supporting all areas of UPS business.
Key Contributions:
♣ Successfully wrote SQL against OLAP cube containing ongoing input of records by month for packages shipped, resulting in perspective on reliability for UPS vs. competitors by service by lane; discussed and presented all findings to staff managers.
♣ Created front-end (MS Access) for management team accessibility (SQL).
♣ Managed research project (Voice of Customer) to determine UPS differentials.