Summary
Overview
Work History
Education
Skills
Timeline
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

Comerica Bank
07.2002 - 09.2006Read More

ATM Deposit Processing

Comerica Bank
02.2001 - 07.2002Read More

Heald College School of Business

Associate of Applied Science from Accounting
Read More
HAO KIM NEPOMUCENO