John Paolo C. Email & Phone Number

Canada

Responsible for ensuring inventory integrity between general ledger and the valuation of the company's inventory on other integrated applications. Uses SQL queries to capture transaction data and uses data analysis to identify inventory issues and recommend solution thru database change or programming changes to Inventory Controllers/Loss Prevention. Maintain the general ledger as the source of truth by showing accuracy, reliability, prevent bad customer experience. Lead enterprise related IT inventory count and move activities as part of SOX controls in terms of planning, coordination with other teams, playbook creation and execution.

Ncr - National Capital Region, Philippines

Managed the conversion and training of existing applications to an Oracle Utility Suite Framework.Liaised between Delivery Manager, offshore application experts and onshore counterparts with respect to daily batch completion and ensured issues were addressed to minimize customer/user impact.Implemented code changes on Mobile Workforce Management application and Oracle reports.Created baseline standard procedures for the start-up team comprised of 3 resources.

Application maintenance for retailer's warehousing system and remote inventory products● Assumed Level 3 on-call support responsibility (24 x 7).● Performed offshore support lead role for 4 resources doing code, design peer reviews, continuous team improvements and ensured SLA/SLEs are met,● Managed tasks/tickets of resources to meet deliverables based on communicated business priorities.● Coordinated work with other teams, other functional areas within the unit, and other operationaldomains.●Liaised and coordinated stake holders needs with application support and development team

Philippines

Application Support Analyst- Assumed Level 2 and 3 on-call support responsibility (24x7) while ensuring service level agreements and operational deliverables are met based on communicated business priorities.- Developed and enhanced code from defect descriptions using PL/SQL, Oracle Forms and Packages.- Sub lead a team of 4 resources, managed resource capacity and training and assumed the role as escalation point of issues.