Position: MIS Reporting Manager
Category: Business Analyst
English level: fluent
Years of experience: 6

CASHWAGON.

- Launch discount process - technical side, generate offers, load to crm by ETL with PowerShell
- Launch repeat loan offers process for clients via json, technical side - scoring by parameters from
RiskTeam, generate offers, load into crm with using ETL\PowerShell
- Launch additional disbursement process, technical side - generate offers, load into crm with using
ETL\PowerShell
- Launch reporting for financial regulators - Philippines, Malaysia, Indonesia
- Launch reporting for P2P platforms - such as Mintos
- Launch repeat offers via API. Python/MSSQL/SSIS


------------------------------


Finstar 

- Power BI implemented
- Power BI reports update tool implemented
- Movied and rebuild main valuable reports to Power BI.
- Error notifications system implemented
- MSSQL Indexes optimisations
Reporting Manager

CASHWAGON (Microfinance APAC). 
Countries: Vietnam, Sri-Lanka, Philippines, Indonesia, Malaysia
Directions: ALL: Sales, Digital Sales, Operation, Collection, Risk
Products: PDL, IL

- Power BI implemented
- Collection Call Lists automatisaition implemented
- Writing and optimizing complex tsql scripts and stored procedures on mssql.
- Creating reports in Microsoft Power BI. Reporting to financial regulators, launch loyalty programs.
- Full technical control of repeat loans by MIS side
- Creating ETL processes with SSIS.
- Create Python scripts to post data via API, libraries :Pyodbc / Logging / Requests / Slacker
The most valuable reports :
- Roll Rates
- LGD
- Reserve Rates / Provisioning
- Surplus
- Clients Vintages (Risk\Sales Curves)
- Incentives
------------------------------

Senior RH Risks Analyst
Finstar (Microfinance APAC). 

Countries: Vietnam, Sri-Lanka, Philippines, Indonesia, India
Directions: ALL: Sales, Digital Sales, Operation, Collection, Risk
Products: PDL, IL, POS
- Power BI implemented.
- Indexes optimisations. Removed unused, created useful.
- Optimizing SSIS packages. For example: rebuild facebook and google statistics packages
(using api). They have never broken after my updates and have only correct values.
- Movied and rebuild main valuable reports to Power BI. Such as Surplus, Inflow (inflow
1+/5/15/30/60/90 by duedate and products and number of period), Collection Costs,
Collection Dialer and etc.
- Power BI reports update tool implemented (adal + pypowerbi.client) 
- Create LTV report about all countries. Gross and Net verdions.
- Error notifications system implemented (with using python). 
- Monitoring system implemented (with using python). 
- Deep dive into India reports.
Moved all reports to APAC reporting, added new data to existing reports with many
unique attributes.
The main expectations are:
• Interesting projects, im kind of person who always needs to do something. Im in love on what i do.
• Professional skills improvement 
• Long term cooperation