Evan Bu

Take charge of the logic and data research responsibilities of the Asset/Liability Management Information System (ALMIS) database and the flow of ALMIS data into its associated analytic and reporting applications.
Develop DQ control framework and maintain query for various data checks.
Monitor daily BAU reporting progress and ensure data readiness for all downstream processes.
Root cause analysis for identified/reported data issues, and construct remediation plan and communicate with associate parties for execution.

Take charge of the logic and data research responsibilities of the Asset/Liability Management Information System (ALMIS) database and the flow of ALMIS data into its associated analytic and reporting applications. Develop DQ control framework and maintain query for various data checks. Monitor daily BAU reporting progress and ensure data readiness for all downstream processes. Root cause analysis for identified/reported data issues, and construct remediation plan and communicate with associate parties for execution.

Managed quantitative models to forecast revenue for various businesses under different macroeconomic scenarios to maintain a clear documentation trail of approach and process.
Conducted revenue projection models’ execution, analysis, and report, and ensure consistency across models employed for forecasting and stress testing.
Built, published customized interactive reports & dashboards, reported scheduling using Tableau server.
Cleansed and blended multiple data sources to allow for different views on application data in a single dashboard.
Performed Data Analysis and data profiling using complex SQL on sources systems including SQL Server.
Worked with Business, Controller, and IT to remediate model-related issues identified.

Managed quantitative models to forecast revenue for various businesses under different macroeconomic scenarios to maintain a clear documentation trail of approach and process. Conducted revenue projection models’ execution, analysis, and report, and ensure consistency across models employed for forecasting and stress testing. Built, published customized interactive reports & dashboards, reported scheduling using Tableau server. Cleansed and blended multiple data sources to allow for different views on application data in a single dashboard. Performed Data Analysis and data profiling using complex SQL on sources systems including SQL Server. Worked with Business, Controller, and IT to remediate model-related issues identified.

Participated in the Earning at Risk project, working as a liaison between business units and IT department to translate business objects to system requirements, tasks including code validation, data mapping, model vetting and implementation.
Developed SQL procedures to streamline ongoing consolidation of data from multiple sources.
Maintained and utilized database stored procedures, user-defined functions, views, triggers and other common database objects in MS SQL Server to fulfil data requests from different business units.
Conducted quantitative analysis, including the construction of regression models in SAS & Python to forecast rates’ change & book growth of business.
Visualized analysis & generated reports in Power BI & presented deliverables to different audiences.
Facilitated the transition of model development and maintenance work from SAS to Python environment.

Participated in the Earning at Risk project, working as a liaison between business units and IT department to translate business objects to system requirements, tasks including code validation, data mapping, model vetting and implementation. Developed SQL procedures to streamline ongoing consolidation of data from multiple sources. Maintained and utilized database stored procedures, user-defined functions, views, triggers and other common database objects in MS SQL Server to fulfil data requests from different business units. Conducted quantitative analysis, including the construction of regression models in SAS & Python to forecast rates’ change & book growth of business. Visualized analysis & generated reports in Power BI & presented deliverables to different audiences. Facilitated the transition of model development and maintenance work from SAS to Python environment.

Performed financial data compilation and analysis including cash flow projection, budgeting, analytical procedures e.g., ratio, trend, variance, reasonableness, etc., and identified metrics and areas that provide more insights to the financial performance.
Worked directly with CFO and EDs on predictive modelling methodology to better forecast revenue and operating results and refining process to better monitor and management actuals against budget.
Designed queries for reporting efficiency, built templates in Tableau to automate reports generation & published reports to the designated audience and made Tableau dashboards available to web clients and in mobile apps.
Served as the Admin for all database modules including Payroll, P&L/General Leger, and BI data warehouse.
Trained junior staffs to use BI tool and ERP system.
Interacted and corresponded professionally with team members, department delegates, and other stakeholders on a daily basis.

Performed financial data compilation and analysis including cash flow projection, budgeting, analytical procedures e.g., ratio, trend, variance, reasonableness, etc., and identified metrics and areas that provide more insights to the financial performance. Worked directly with CFO and EDs on predictive modelling methodology to better forecast revenue and operating results and refining process to better monitor and management actuals against budget. Designed queries for reporting efficiency, built templates in Tableau to automate reports generation & published reports to the designated audience and made Tableau dashboards available to web clients and in mobile apps. Served as the Admin for all database modules including Payroll, P&L/General Leger, and BI data warehouse. Trained junior staffs to use BI tool and ERP system. Interacted and corresponded professionally with team members, department delegates, and other stakeholders on a daily basis.

Imported the claims data into Python using Panda’s libraries and performed various data analyses, and generated various capacity planning reports used Python packages like NumPy, Pandas, Matplotlib, SciPy, Spark and Flask.
Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart, and prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
Involved in creating database objects like tables, views, procedures, triggers, functions using SQL to provide definition, structure and to maintain data efficiently, and performed Data Analysis and data profiling used complex SQL on various sources systems included MySQL and MS SQL Server.
Prepared the data rules spreadsheet using MS Excel that will be used to updated allowed values, findings, and profiling result.

Imported the claims data into Python using Panda’s libraries and performed various data analyses, and generated various capacity planning reports used Python packages like NumPy, Pandas, Matplotlib, SciPy, Spark and Flask. Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart, and prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau. Involved in creating database objects like tables, views, procedures, triggers, functions using SQL to provide definition, structure and to maintain data efficiently, and performed Data Analysis and Data profiling used complex SQL on various sources systems included MySQL and MS SQL Server. Prepared the data rules spreadsheet using MS Excel that will be used to updated allowed values, findings, and profiling result.