tahoman

Reviewed, interpreted, and deconstructed current version of large and intricate financial spreadsheet used for tracking division resources and improved upon current process working across different platforms. • Developed new and upgraded all necessary macros and formulas using advance Excel (Vlookup, Index/Match, SUMIFS, Pivot Tables, Power Pivot) to perform the same functions for optimal and uninterrupted use. • Collected, interpreted and analyzed results using Excel (advanced formulas, initialized automatic checks) and provided ongoing results in a comprehensive manner. • Located and defined new process improvements and automation opportunities within Excel and corporate reporting systems. • Facilitate meetings with SMEs to implement and manage new processes, to improve methods and procedures. • Created User’s Guide of updated and newly developed formulas, macros, pivot tables and other solutions.

In partnership with Product Manager, oversaw and owned the day-to-day operation, as well as any needed improvements, of the initial delivery, ongoing operation, and necessary maintenance of Disciplined Agile certification products. Tracked all aspects using Excel. • Managed the operational daily activities related to the Disciplined Agile (DA) certification processes. • Management of exam candidate rosters. Received from Authorized Training Partners (ATP) and Self Study and validated candidate’s compliance with exam requirements and regulations for submission to testing facility. • Point of Contact. Solely managed all escalations and appeals from Authorized Training Partners (ATP) and exam candidates via email and supported to resolution. • Communications. Orchestrated all communications with Authorized Training Partners (ATP), and exam candidates on current and new exam processes and requirements via email and PowerPoint. • Reported/resolved any issues within internal testing system with the JIRA team and Pearson testing center. • Analyzed and made recommendations to improve communications to ATPs and candidates of submission and exam guidelines. Reduced mailbox receipt of duplicate queries by 50%. • Input/register students PM Ready Demo/Courseware in Certiport and tracked. Reduced Demo registration from 30min to 5min by automating procedure using Excel macros and formulas. • Verified all military applications for PMP and maintained mailboxes.

Documented and verified each End-of-Life Milestone were completed according to Global Standard Operating Procedures to remove 3,500 discontinued items, involved in multiple plant closures in US and Mexico, from corporate system for each Product Family that were to be obsoleted and inactivated from system. • Contacted and worked closely with each department manager for required data (Sales, Contract (Domestic and International), Quality and Regulatory, Inventory Status, Plant Impact (Scrap (RAW/WIP)), Financial Analysis and Accounting for each item being obsoleted for each milestone of GSOP and document. • Updated and simplified PowerPoint presentation for weekly meetings.