Manager, Portfolio Reporting And Management
Current- Pioneer of Data Science Unit, primary point of contact with external vendors specifically in the context of Google Cloud Platform (GCP)- Developed an efficient ETL pipeline with R Studio, Cloud Storage, Cloud Functions, Dataflow and BigQuery, with PII anonymization- Transform old VBA automations to near instantaneous interactive reporting tools in GCP with GSheet, Apps Script and Looker Studio- Perform analytical tasks with SAS EG, VertexAI, Jupyter Notebook and BigQuery- Expert in portfolio management reports like Portfolio Quality Review (PQR), Credit Asset Quality (CAQ), Month On Book (MOB) Analysis, Loan Compression monitoring and BNM STATSmart Reporting- Data extraction with SQL, supporting data needs for >10 departments for all retail credit products: Mortgage, Project End Financing, Overdraft, Hire Purchase, Personal Loan, Credit Card, Share Margin Financing, ASB Financing- Developed and provide maintainence service for VBA automation on MIS and BNM Reportings- Approver for BNM STATSmart submissions- SQL script conversion among 4 different database systems: TSQL, Teradata, PostgreSQL, BigQuery- Operational risk assessor- OSHA Representative, First-Aider