Business Analysis, Managerial Capability, Financial Reporting
Resume:
JOHN MICHAEL Q. CLEMENTE
Unit *** Tower * AVIDA CENTERA Corner EDSA, Reliance Street,
Mandaluyong City, Metro Manila
***.********@*****.***
KEY COMPETENCIES AND SKILLS
• 8 years of solid Financial Reporting experience with global investment banks
• 5 years of solid Business Analysis experience - involved in various projects and business implementation
• Manager experience - people management skills
• Familiarity with various financial instruments and different product processors
• Strong Business Analysis skills and work experience. Having been involved in different business implementation and system migration
• Good understanding and experience of Software Development Life Cycle (SDLC)
• Significant knowledge on Business Analysis approach - including AGILE, Waterfall and process decomposition
• Experience in SQL for working with big data, requirement analysis and issues investigation
• Significant exposure and use of Tableau
• Familiarity with Data Warehousing process and activities
• Familiarity with Python language - can read and understand code and syntax
• Experience in Lean Six Sigma and process automation
• Good exposure and experience in writing Functional specification and project requirement documents. Ability to create user materials and provide trainings
• Skilled in performing Intercompany Derivative reconciliation. Providing accurate report and timely feedback to immediate superior and stakeholders
• Efficient task management capabilities allowing participation in major system rollouts or change initiatives on top of BAU
• Strength in the use of MS Excel, MS Visio and MS Office Suite
• Solid work experience in process migration and transition and involvement in working on migration requirement documents
• Ability to manage all level of Stakeholders. Working efficiently with both onshore and offshore counterparts
• Mentors, coaches and trains the team and directs. Can foster teamwork, maintain good communication and collaboration while managing competing priorities EMPLOYMENT EXPERIENCE
Deutsche Bank, (Deutsche Knowledge Services, Manila) Lead Business Functional Analyst - AVP
September 2016 to September 2019
RESPONSIBILITIES:
• Drives data discovery, sourcing, modelling and analytics to support the creation data flows and models.
• Leads discovery, source system analysis, data profiling and quality analysis for upcoming initiatives.
• Formulates and creates complex functional / non-functional specification documentations in close working with engineering teams.
• Completes and elaborates complex functional designs in accordance with the defined principles, blueprints, standards, patterns, etc.
• Designs and conceptualizes new complex business solution options and articulates identified impacts and risks. Leads the identification and analysis of business drivers to develop risk and controls requirements.
• Review testing requirements including test plans, test cases, test-data and interface testing between different applications. Works with engineers to resolve complex functional issues arising from user acceptance testing.
• Reviews business facing documentation (e.g. user manuals, solutions briefs, functional summaries).
• Develops hypotheses to explain why usability, process, functional and data issues have occurred or are likely to occur.
• Communicates usability and business process improvement, though application of detailed analytics, pattern and root cause analysis. Leverages visualization techniques.
• Assists onshore and offshore teams (Dev, QA) on understanding the business requirements and support in test cases and design.
• Foster teamwork, communication, collaboration while managing competing priorities.
• Communicates awareness and understanding of data information needs, objectives, and direction to appropriate stakeholders and users.
• Performs Ad-hoc tasks that may be assigned.
Citibank N.A ROHQ, (Citi Shared Services - Asia)
Business Process Analyst - AVP
January 2009 to September 2016
RESPONSIBILITIES:
• Responsible in reviewing and supervising EMEA/NAM Derivative Team intercompany processes.
• Responsible in providing Intercompany reconciliation support (Balance Sheet and Profit and Loss) to the Business units being handled during each reporting cycle and ensures delivery of timely and accurate reports and other requirements.
• Responsible in ensuring that all significant breakages identified are either tagged/IKL’d or communicated to the necessary counterparties for tagging before the corporate deadline. Monitor recurring issues and breakages and provide necessary resolution and apply permanent fix at source.
• Responsible in addressing queries and concerns raised by clients and ensure timely resolution based on the service level agreements.
• Responsible in conducting monthly and weekly calls with offshore counterparts.
• Responsible in formulating process improvements such as streamlining of processes, developing/ improving process documentation, introducing new model/approach and strengthening Intercompany Reconciliation control process.
• Responsible in providing support in any process migration initiatives to Manila Shared Services on the Intercompany processes which are still in country.
• Responsible in supporting project implementation tasks for any finance-related system migration affecting the current Intercompany process.
• Mentors, coaches, trains and oversees progress of Intercompany Reporting Specialists
• Ad hoc tasks that may be assigned by the Team Lead
• Responsible in maintaining awareness of compliance related policies and guidelines with the group.
• Responsible in developing a strong working relationship with the internal Citigroup customers serviced by the unit, ensuring that high quality service standards are maintained. RenditionDigital Inc, Manila Office
Business Analyst
March 2008 to Dec 2008
Project Assigned:
• Slainte Claimsure Billing System
• Enterprise Revenue Forecasting Tool (internal project)
• Aviation Services Ireland (ASI) Onsite project (process documentation)
• Philippine Airline (PAL) Booking Engine
RESPONSIBILITIES:
• Responsible for documentation of functional and process specifications of the project.
• Responsible for conducting sessions and meetings with Client to gather data and requirements for the project.
• Responsible in providing screens layout or prototype for writing of code and for development.
• Responsible for helping the Project Manager in setting up project plans and work estimates
• Responsible to close tracking and coordination of all test efforts from development to integration testing.
• Responsible for reviewing test specifications and cases ensuring that all functional requirements are met.
• Responsible for issuing follow up questions and feedback to client on project requirements.
• Responsible for documentation of system end user readiness materials.
• Responsible for coordinating project issues from client to a team of developers and propose solutions to the problems.
• Responsible for close tracking of bugs and issues encountered. Also ensuring that fixes patched to the system being developed will not impact negatively with other functionalities of the system. Software Laboratories Inc, Manila Office
Assigned to SMART Telecommunication
Business Analyst (Consultant) – July 2007 to February 2008 Project Assigned: Customer Service Platform for Corporate Business Group of SMART Telecommunication.
Functions:
• Prepared Functional Specifications of the system, to ensure that all business rules and policies were met.
• Performed Unit Testing and Internal quality checking to ensure that the web design is functioning well with regards to the business process.
• Monitored the work of the developers and work with them to align the development of the program with the current plans of SMART Corporate Group.
• Prepared Test Data samples/scripts to be used in debugging and eliminating of program errors.
• Discussed with SMART Corporate Business Group and System and Procedure Group regarding new plans and future development in the business.
• Performed actual System set-up to ensure that the escalation processes of the business were met.
• Maintained the Transaction Flow Chart of the Team. Navitaire International LLC, Manila Office
Business Process Outsourcing Employee - Team Captain Revenue Associate (United Airline) September 2004 – June 2007 RESPONSIBILITIES:
• Served as knowledge and skills expert to primarily lead a team of Revenue Associates in achieving operational goals related to output, quality and efficiency.
• Provided policy advice and make recommendations to seniors on identified out-of date contract provisions and system errors, which may indicate problems with the system fare loads used in the audit process.
• Assisting in implementation and monitoring of United Airlines Policies and Procedures.
• Monitors daily output of Revenue Associates to ensure that assigned sales transactions for processing are completed.
• Regularly reviews transaction batch set-up to ensure that transactions are properly grouped, leading to more effective workload management.
• Conducted regular team meetings/consultations with Revenue Associates to provide feedback on team and individual performances; to solicit suggestions on possible process improvements.
• Multi-tasked as Quality Control Analyst for published and unpublished transaction processing to minimize manual errors.
• Performed quality review on processed tickets by auditors.
• Analyzed client audit review to determine causes of client rejects/reversals.
• Implementing constant debriefing sessions with airline teams to identify areas for improvements.
• Reviews of unloaded file to ensure profit maximization and for system improvements. EDUCATIONAL BACKGROUND
• 1999-2003 University of Rizal System, Tanay, Rizal Bachelor of Science in Business Administration
Major in Management
Magna Cum Laude
Consistent University Scholar
President, Student Grantees and Scholars Association SY 2001-2003
Contact this candidate