Credit Reporting & Visualization Specialist – First Level Officer
HAO KIM NEPOMUCENO
COMERICA BANK
Chino,CA
26
years of professional experience
Experienced Banking and Financial Reporting Professional with 25 years in financial reporting, credit analysis, and process improvement. Developed automated reports and dashboards to enhance reporting efficiency and streamline workflows. Background includes commercial lending and credit risk management.
Work History
Credit Reporting & Visualization Specialist – First Level Officer
8 Years 7 Months
COMERICA BANK | 02.2018 - 09.2026
Developed automated reports and dashboards for commercial real estate, technology life science, mortgage, and national dealer services, enhancing data accessibility.
Created reporting solutions using Power BI, PowerApps, SAS Enterprise Guide, Hyperion, and Excel.
Reduced reporting turnaround time by 71% through automation and process improvements.
Created reporting solutions with Power BI, PowerApps, SAS Enterprise Guide, Hyperion, and Excel to facilitate data-driven decision-making.
Integrated and reconciled financial data from multiple banking systems to improve reporting accuracy.
Collaborated with business teams to produce accurate reports that informed management decisions.
Administrative Assistant III – Technology Life Science Department
4 Years 4 Months
Comerica Bank | 10.2013 - 02.2018
Supported senior credit officers with administrative and operational tasks, enhancing departmental workflow.
Developed and monitored departmental budgets, ensuring accurate monthly and quarterly financial reporting.
Prepared departmental budgets and maintained monthly and quarterly reports.
Verified daily loan bookings and maintained accurate banking records.
Updated credit risk ratings in AFS and VC Premier systems.
Coordinated employee onboarding, training sessions, meetings, and departmental projects to streamline processes.
Credit Specialist III – Commercial Real Estate Department
7 Years 1 Month
Comerica Bank | 09.2006 - 10.2013
Analyzed financial statements, tax returns, cash flow, and collateral to evaluate borrower creditworthiness.
Processed commercial loan requests, renewals, extensions, modifications, and credit reviews.
Created financial spreads, cash flow projections, and borrowing-base analyses to support credit decision-making.
Developed portfolio reports to monitor past-due loans, ensure covenant compliance, and evaluate credit risk ratings and exceptions.
Compiled specialized reports to assess credit concentrations and evaluate portfolio risk exposure.
Updated credit risk ratings in AFS and Hogan systems to ensure accuracy. in AFS and Hogan systems.
Maintained credit risk ratings in AFS and Hogan systems.
Trained new employees on banking systems and procedures.
Credit Specialist III – Special Assets Group, Collections Department
4 Years 2 Months
Comerica Bank | 07.2002 - 09.2006
Assisted banking officers in credit administration and loan documentation to ensure accurate processing and compliance.
Prepared charge-off requests, non-accrual documentation, and credit quality reviews.
Developed loan covenant tracking systems to monitor borrower compliance.
Created loan covenant tracking systems to enhance monitoring of borrower compliance and mitigate risk.
Supported banking officers with credit administration and loan documentation.
Tracked borrowing bases, collateral schedules, and borrower financial performance to identify potential issues and support credit decisions.
ATM Deposit Processing
1 Year 5 Months
Comerica Bank | 02.2001 - 07.2002
Processed and verified ATM deposits, withdrawals, and transfers to ensure transaction accuracy and compliance.
Reconciled daily transaction reports and resolved discrepancies to maintain operational integrity.
Monitored ATM transactions and escalated unusual or potentially fraudulent activity to safeguard assets.
Maintained accurate records and followed banking security and confidentiality procedures.
Education
Associate of Applied Science - Accounting
Heald College School of Business | 06-2001
Skills
Financial Reporting
Data Analytics
Reporting Automation
Power BI
Dashboard Development
SAS Enterprise Guide
Hyperion
Microsoft Excel
Power Apps
PowerPoint
Outlook
Microsoft Word
Data Reconciliation
Credit Risk Analysis
Financial Statement Analysis
Business reporting
Compliance monitoring
Risk management
Banking Systems: Hogan
DCORR
Risk Origins
DEALS
AFS
Credit Operations
Process Improvement
Analytical thinking
Technical communication
Team collaboration
Written communication
Reporting tools
Data analysis
Documentation management
Timeline
Credit Reporting & Visualization Specialist – First Level Officer
COMERICA BANK
02.2018 - 09.2026Read More
Administrative Assistant III – Technology Life Science Department
Comerica Bank
10.2013 - 02.2018Read More
Credit Specialist III – Commercial Real Estate Department
Comerica Bank
09.2006 - 10.2013Read More
Credit Specialist III – Special Assets Group, Collections Department
<ul><li>Company Overview: Group Company of PUIG, Spain</li><li>Team Leadership & Process Excellence: Organised the transformation of the Finance & Accounts function, establishing performance-driven goals, and embedding a culture of accountability and continuous improvement. Drove operational efficiency through process redesigns, SOP implementation and optimal resource deployment, leading to measurable improvements in turnaround time and accuracy.</li><li>Strategic Partnering with CXOs: Acted as a key advisor to the CEO, CFO, and other CXOs on business planning, pricing strategies, and business model pivots to support scale-up and profitability. Contributed to investor communications with data-backed insights to enhance stakeholder confidence and secure strategic funding.</li><li>Cross-Functional & Global Stakeholder Management: Functioned as the strategic finance business partner to cross-functional heads and the PUIG global finance team, aligning local execution with global financial strategies and compliance requirements.</li><li>ERP Transformation & System Automation: Led end-to-end ERP reimplementation to address system gaps, enforce role-based controls, and automate core finance processes—resulting in enhanced data accuracy, faster reporting and improved internal controls.</li><li>Costing, Inventory & Profitability Optimization: Designed and implemented plant-level costing models to ensure accurate COGS determination. Improved inventory management across pricing, consumption tracking, and aging analysis—enabling better working capital control and cost efficiency.</li><li>Manufacturing Finance & Statutory Compliance: Supervised end-to-end accounting for manufacturing operations and ensured full statutory compliance.</li><li>Financial Reporting, MIS & Profitability Analytics: Delivered accurate and timely monthly MIS reports, including P&L, Balance Sheet and KPI dashboards with deep-dive variance analysis across stores, business verticals, and geographies. Supported board-level decision-making through insightful presentations on financial health and business performance.</li><li>Budgeting, Forecasting & Business Planning: Led the Annual Operating Plan (AOP) and rolling forecasts, ensuring alignment with strategic objectives and market dynamics. Monitored key financial metrics to enable business decisions and proactive cost management.</li><li>Statutory, Internal & Tax Audit Management: Finalized standalone and consolidated financials under Ind AS and IFRS, ensured timely group reporting and compliance with international standards. Delivered clean and timely closures of statutory, tax, and internal audits in coordination with Big 4 auditors. Strengthened audit readiness through pre-audit diagnostics and rectification of recurring control gaps.</li><li>Regulatory Compliance & Risk Management: Ensured end-to-end compliance which includes ROC, RBI, FEMA, Income Tax, GST, Transfer Pricing, DTAA, and Customs. Reviewed cross-border contracts and transactions to ensure arm’s length pricing, accurate TDS application, and proper documentation under Transfer Pricing regulations.</li><li>Commercial Negotiation & Contract Governance: Led commercial negotiations and structured deals with vendors and franchisees. Reviewed key business contracts to ensure financial viability, risk protection, and compliance with regulatory standards.</li><li>Treasury & External Commercial Borrowing (ECB): Managed fund planning and liquidity management including ECB drawdowns, bank negotiations, and interest optimization. Improved working capital cycles through proactive cash flow forecasting and receivables control.</li><li>Internal Controls & Governance Framework: Led organization-wide reviews of internal control systems, identified process gaps, and redesigned or implemented over 40 SOPs and IFCs. Established a governance structure for financial discipline, risk mitigation, and policy compliance across departments.</li></ul> at Kama Ayurveda Pvt. Ltd. & PUIG India Pvt. Ltd.<ul><li>Company Overview: Group Company of PUIG, Spain</li><li>Team Leadership & Process Excellence: Organised the transformation of the Finance & Accounts function, establishing performance-driven goals, and embedding a culture of accountability and continuous improvement. Drove operational efficiency through process redesigns, SOP implementation and optimal resource deployment, leading to measurable improvements in turnaround time and accuracy.</li><li>Strategic Partnering with CXOs: Acted as a key advisor to the CEO, CFO, and other CXOs on business planning, pricing strategies, and business model pivots to support scale-up and profitability. Contributed to investor communications with data-backed insights to enhance stakeholder confidence and secure strategic funding.</li><li>Cross-Functional & Global Stakeholder Management: Functioned as the strategic finance business partner to cross-functional heads and the PUIG global finance team, aligning local execution with global financial strategies and compliance requirements.</li><li>ERP Transformation & System Automation: Led end-to-end ERP reimplementation to address system gaps, enforce role-based controls, and automate core finance processes—resulting in enhanced data accuracy, faster reporting and improved internal controls.</li><li>Costing, Inventory & Profitability Optimization: Designed and implemented plant-level costing models to ensure accurate COGS determination. Improved inventory management across pricing, consumption tracking, and aging analysis—enabling better working capital control and cost efficiency.</li><li>Manufacturing Finance & Statutory Compliance: Supervised end-to-end accounting for manufacturing operations and ensured full statutory compliance.</li><li>Financial Reporting, MIS & Profitability Analytics: Delivered accurate and timely monthly MIS reports, including P&L, Balance Sheet and KPI dashboards with deep-dive variance analysis across stores, business verticals, and geographies. Supported board-level decision-making through insightful presentations on financial health and business performance.</li><li>Budgeting, Forecasting & Business Planning: Led the Annual Operating Plan (AOP) and rolling forecasts, ensuring alignment with strategic objectives and market dynamics. Monitored key financial metrics to enable business decisions and proactive cost management.</li><li>Statutory, Internal & Tax Audit Management: Finalized standalone and consolidated financials under Ind AS and IFRS, ensured timely group reporting and compliance with international standards. Delivered clean and timely closures of statutory, tax, and internal audits in coordination with Big 4 auditors. Strengthened audit readiness through pre-audit diagnostics and rectification of recurring control gaps.</li><li>Regulatory Compliance & Risk Management: Ensured end-to-end compliance which includes ROC, RBI, FEMA, Income Tax, GST, Transfer Pricing, DTAA, and Customs. Reviewed cross-border contracts and transactions to ensure arm’s length pricing, accurate TDS application, and proper documentation under Transfer Pricing regulations.</li><li>Commercial Negotiation & Contract Governance: Led commercial negotiations and structured deals with vendors and franchisees. Reviewed key business contracts to ensure financial viability, risk protection, and compliance with regulatory standards.</li><li>Treasury & External Commercial Borrowing (ECB): Managed fund planning and liquidity management including ECB drawdowns, bank negotiations, and interest optimization. Improved working capital cycles through proactive cash flow forecasting and receivables control.</li><li>Internal Controls & Governance Framework: Led organization-wide reviews of internal control systems, identified process gaps, and redesigned or implemented over 40 SOPs and IFCs. Established a governance structure for financial discipline, risk mitigation, and policy compliance across departments.</li></ul> at Kama Ayurveda Pvt. Ltd. & PUIG India Pvt. Ltd.