Jan Lloyd Pagaduan Pagaduan, Process Improvement Specialist

Jan Lloyd Pagaduan Pagaduan

Process Improvement Specialist

Power International Holding

Location
Qatar - Doha
Education
Bachelor's degree, Accountancy
Experience
6 years, 1 Months

Share My Profile

Block User


Work Experience

Total years of experience :6 years, 1 Months

Process Improvement Specialist at Power International Holding
  • Qatar - Doha
  • My current job since November 2021

• Design and implement workflows for Finance and Supply Chain Department which are integrated in SAP.
• Created and maintained master DOA for Finance for the group of companies in our holding.
• Created and maintained master DOA for Supply Chain for the group of companies in our holding.
• Provided solution achieving 57% efficiency from the current number of workflows in SAP MM from almost
4, 000+ workflows to our current 1700+ workflows. It contributed to a simpler way of maintaining workflows and
streamlined excess processes which takes up extra processing time in the system. This project includes modules
as follows: Purchase Requisition, Purchase Contract, Purchase Orders and Service entry sheets.
• Led the initial study and analysis of business partner accounts via Excel Fuzzy match, Power Pivot and Power
Query. Analysing 20, 000+ suppliers with their past 4 years of transaction and identifying around 42% of
suppliers which are stagnant and marked them for deletion or deactivation.
• Led the initial study and analysis of all the active payment terms via Excel Fuzzy match, Power Pivot & Power
Query. Identified 154 recorded payment terms of which only 75 are active and used.
• Design organizations structure via Microsoft Visio and mirror data to SAP SuccessFactors.
• Collaborated with key stakeholders to define organizational structures, roles, and responsibilities.
• Assisted in developing workforce plans, including analysing staffing needs and skill requirements for FIFA 2022
readiness.
• Coordinated and streamlined movement of a 60, 000+ employee workforce by utilizing Excel techniques such as
XLOOKUP, VLOOKUP, and pivot data to assign employees to their correct business unit, division, department,
and cost centre based on recently approved organizational charts. Entered the processed data into SAP Success
Factors to initiate and effect the changes.
• Conducted data analysis and utilized HR metrics to assess organizational performance.
• Facilitated and developed the cost analysis for the 2023 Cost Optimization Exercise for all PIH support
functions.
• Core team member that developed and integrated cost to company (CTC) calculator in SAP SuccessFactors
which ensured standard calculation methodology across business verticals.
• Developed the 2022 & 2023 manpower budget, by determining the allocation of resources across
departments and functions. Factors considered are staffing ratios, workload distribution, and productivity
levels to ensure efficient and effective resource allocation.
• Collaborated with department heads to assess the organization's current and future workforce needs. This
includes analysing workload projections, identifying skill gaps, and determining the optimal employee
headcount required to meet business objectives.
• Provided input on the costs associated with various aspects of the workforce, such as salaries, benefits, training,
recruitment, and employee development programs.
• Conducted in-depth analysis of HR metrics and workforce data to identify trends, patterns, and insights, such as
turnover ratio, retention rate, engagement, and performance.
• Created and maintained HR dashboards, reports, and visualizations to communicate key HR metrics and
findings to stakeholders via Power BI and Microsoft Excel.
• Conducted ad-hoc analyses such as vacancy and position ageing reports, data analysis and generated reports
that track compensation trends, budget utilization,

Internal Auditor at Al Jaber Group
  • Qatar - Doha
  • June 2020 to October 2021

• Conducts financial audit & operational audit across group of companies which consists of 15+ different business units immersed to different industries such as manufacturing, contracting, logistics, sales, merchandising, etc.
• Proficient in comprehensive audit planning, precise audit testing, adept utilization of sampling techniques, meticulous analysis of audit findings, and meticulous maintenance of thorough audit documentation with continuous monitoring of each finding.
• Conducted thorough risk assessments and played a key role in identifying and addressing control weaknesses within various business areas, including procurement processes, accounts receivable recording, accounts payable/operating and administrative expenses treatment, inventory methodologies, sub-contractor agreements, revenue management, and overall general accounting entries. Utilized a meticulous approach to ensure the correction and enhancement of internal controls, fostering an environment of operational efficiency and compliance.
• Expertly prepared comparative financial statements, employing a wide array of essential ratios, including liquidity ratios, solvency ratios, profitability ratios, efficiency ratios, and market prospect ratios. Through this comprehensive analytical approach, I delved deeper into the financial data, identifying, and scrutinizing any discrepancies or areas of concern. This in-depth analysis provided invaluable insights for decision-makers, enabling them to make informed strategic choices and fostering financial stability and growth for the organization.
• Produced an impactful audit report that played a crucial role in assisting one of the group's manufacturing lines in accurately determining the appropriate number of bonuses to be declared. Utilizing advanced management accounting techniques, including a meticulous comparison between variable costing and standard costing, I provided valuable insights and clarity. This analysis not only ensured fair and accurate bonus allocation but also contributed to optimizing the manufacturing line's operational efficiency and overall financial performance. My dedication to delivering actionable recommendations through the audit process positively impacted the organization's decision-making and financial management strategies.
• Actively contributes to the year-end financial audits, engaging in a thorough range of audit procedures. This involves conducting diligent sampling alongside physical inventory counting to ensure accurate stock valuation. Additionally, I conduct rigorous petty cash vouching and bank reconciliations, guaranteeing the integrity of financial records. Furthermore, I take charge of facilitating intercompany balance verifications, accounts receivable, and accounts payable verification processes, conscientiously confirming the accuracy of transactions. As part of the audit process, I also undertake the critical task of re-calculating the company's asset depreciation schedules, ensuring adherence to accounting standards and precise asset valuation. My assiduous approach and attention to detail during these audits contribute significantly to the company's financial transparency, regulatory compliance, and overall confidence in financial reporting.

Senior Accountant at Urban Operations and Maintenance
  • Qatar - Doha
  • October 2018 to February 2020

• As a dynamic financial professional, I took charge of steering the month-end and year-end closing processes, orchestrating the prompt and precise generation of comprehensive financial statements and internal reports for the entire group. My commitment to maintaining the integrity of the general ledger contributed to the establishment of a dependable financial foundation. Among my regular tasks, I expertly prepared vital reports encompassing financial analysis, variance analysis, and cash flow management, which served as pivotal indicators for the management team. By providing keen insights and accurate assessments, I empowered strategic decision-making and facilitated the achievement of key business objectives.
• Exemplified strong leadership in spearheading the annual budgeting and forecasting process for the segment, collaborating seamlessly with operations managers to achieve collective success. By fostering a collaborative and supportive environment, I ensured that all stakeholders contributed their expertise and insights, resulting in a well-informed and comprehensive budgeting and forecasting strategy. The successful execution of this process played a pivotal role in driving the segment's growth and financial prosperity.
• Championed and executed the meticulous clean-up of the company's landscaping division's multiple assets registers, encompassing diverse inventories and assets. Through this initiative, I established controlled asset ID registers and a streamlined filing structure, facilitating the workshop manager in efficiently tracking assets across the entire group. This endeavours significantly improved asset management, ensuring enhanced organization, accountability, and optimal utilization of resources company wide.
• Demonstrated exceptional proficiency in account reconciliation of receivables and payables, leveraging customized Excel templates to streamline the process. With a keen eye for detail, I conducted monthly ledger closing, ensuring the accuracy and integrity of financial records. Handling a substantial volume of transactions—averaging a hundred per week across multiple clients and vendors—I maintained a high level of precision and efficiency. This meticulous approach to financial management contributed to the company's smooth operations and strengthened financial controls.
• Conducted rigorous audits of more than 30 suppliers' contracts per project, collaborating closely with the project manager to proactively mitigate potential cost risks. By taking a proactive approach, we successfully prevented end-of-project accounting discrepancies, ensuring accurate financial outcomes, and maintaining strong financial health. This meticulous oversight and attention to detail significantly contributed to the overall success of the projects, fostering a reputation for reliability and excellence in financial management.
• Proficiently managed a diverse range of transactions involving letter of credit (LC), skilfully handling at least 8 active simultaneous contracts with a combined value exceeding QAR 100M+. Additionally, I effectively managed all intercompany transactions within the group, extending to the holding and sister companies operating predominantly in the food sector, logistics, real estate, and construction domains. My comprehensive oversight and expertise in financial management ensured seamless and accurate intercompany financial dealings, contributing significantly to the success and cohesion of the entire business conglomerate.
• Well versed in financial system and software (e.g. SAP FI, SAP MM, Sage50 & Tally)

Junior Accountant at Triplo Design and Build
  • Qatar - Doha
  • February 2018 to October 2018

• Proficiently updated and maintained monthly records for loans, prepaid expenses, advances, visa renewals, and ensured the validity of the company's legal documents. Skilfully handled leave applications, end of service computations, ticket provisions, bank loan amortization, and monthly asset depreciation, adhering to set schedules.
• Diligently prepared monthly bank reconciliations and conducted intercompany ledger reconciliations across 5 group companies, managing an average of over a hundred transactions per month with great accuracy.
• Took full responsibility for the daily disbursement, liquidation, and replenishment of the revolving petty cash fund, maintaining meticulous records throughout.
• Closely monitored income and expenses per truck and trailers, overseeing repair and insurance expenses with utmost attention to detail.
• Efficiently generated daily sales reports and sales comparison reports, providing valuable insights into financial profitability standings from day-to-day transactions, including meticulous checking and comparison of delivery receipts.
• Provided valuable assistance in payroll preparation and effectively allocated overtime, ensuring accurate and timely compensation for employees.

Education

Bachelor's degree, Accountancy
  • at Tarlac State University
  • June 2017
High school or equivalent, Accountancy
  • at Gerona Junior College
  • June 2012

Specialties & Skills

Internal Audit
Budgeting
US GAAP
Financial Statement Analysis
WRITING
FINANCIAL STATEMENTS
MICROSOFT EXCEL
MICROSOFT POWERPOINT
MICROSOFT WORD
SAP FICO
POWER BI

Languages

English
Expert

Memberships

Institute of Management Accountant
  • Associate / Member
  • June 2023