Microsoft Office, Power Bi, underlying Stata
PHAN THUY TRANG
Consultant Expert
Overview
13
13
years of professional experience
9
9
years of post-secondary education
Work History
Consultant Expert for Large Corporate Customers
Techcombank, 191 Ba Trieu Street, Vincom Tower, Hanoi
Hanoi
12.2020 - Current
- Refine Vinhomes's in/out cashflow into categories: Finance (principal /interest payment, interest income) / Operations (payroll, electricity & water, tax...)/ Commercial flows (constructors, individual customers, real-estate agency) /Internal flows (cash sweeping between internal accounts, cash transferred within group) based on daily transaction data retrieved from T24 system to analyze cashflow proportion at Techcombank vs other banks
- Apply & multiply rules of transactions of the Vinhomes use case for other clients to understand client's behaviors so enhance transactions to increase CASA balance at Techcombank
- Join TWS1 - Treasury Management System (TMS) project, working with frontline to analyze on clients' treasury assessment score, building & updating daily client engagement tracking dashboard, mapping & proposing use cases for each clients in the watching list, participating into TMS demo meetings for clients
- Join SCF - Supply chain financing project, analysis package on Vinhomes use cases by building qualitative & quantitative benefit SCF third-party model (Vinhomes - Contractors - Techcombank), sizing market for Supply chain financing & distributor financing in FMCG & Recom
- Collect public & classified info to build competitive tracking file between banks (offerings, credit policy, loan structure by segment & by bizline)
Economics & Business Expert
Global Transaction Banking, Techcombank 191 Ba Trieu Street Vincom Tower
Hanoi
12.2019 - 12.2020
- In charges of sub-segment Reports (Pharma, Retail, Agriculture & Fisheries)
- Analyzing the difference in term of finance between Vinamilk’s & Masan’s Distributors (Short term funding policy affects on financial status)
- Business Analysis for USME & SME Sales Department (which BBC can enhance TOI results directing to industry perspectives)
- Building opportunity pool model for Recom & FMCG (estimate financial statement at the industry scale related to flows from downstream to upstream incorporated with available banking products offerings)
- Join Techcombank's 5-year strategy (Market Sizing TOI for FMCG, Recom, Utility, Financial Services, Travel & Leisure, Auto & Parts) to identify where to play
Macro Economics Senior Officer
Treasury Research Department, Techcombank 191 Ba Trieu Street, Vincom Tower
Hanoi
04.2018 - 12.2019
- In charge of bilingual Macro weekly reports for Techcombank’s institutional clients & Wholesales Banking
- Collaborated with team members to prepare ALCO reports related to analysis on macro variables such as GDP, CPI, IIP, BOP, Trade Balance, FDI, FII and also sticked to banking system, real-estate sector, FX & interest rates trending, global economic movements…
- Carried out weekly presentation on macroeconomic perspective for Treasury team
- Build Trade Balance, Oil, Banking dashboard, ETF Fund tracking
- Supported other departments such as Investor Relation (IR) department for Techcombank analyst meetings
Consulting Senior Analyst
Bao Viet Securities JSC (BVS), 2&3 Floor, 72 Tran Hung Dao Street
Hanoi
04.2015 - 04.2018
- Big advisory deals: Sate divestment at Gemadept, M&A Traphaco, project valuation model for Vinpearl, loans consultancy for Hon Tam Nha Trang projects, IPO advisory reports including equity valuation model for PV Power & Genco II
- Industry & Company reports: Sugar/Rubber/Oil/Electricity & analysis on corporates at above industries
- Incorporated with frontline to stock buying advisory
Senior Analyst
Military Bank Securities JSC (MBS), 3&7 Floor, 3 Lieu Giai
Hanoi
12.2014 - 04.2015
- Carried out the proposal of investment opportunities for institutional investors by synthesizing daily news & continuously updating valuation model as well as visualizing investment catalysts through detail-oriented reports, quick reports, business visit notes & daily reports)
- Covered reports related to industry in couple with some enterprises in the industry: Banking (Military Bank), Electricity (Nhon Trach II), Real-Estate (Hoa Phat, Bim Son, Ha Tien I), Shipping (Vietnam Ocean Shipping), Wood (Truong Thanh Furniture), Oil (Petrovietnam Technical Services)
Senior Analyst
Sai Gon – Ha Noi Securities JSC (SHS), 1A Yet Kieu
Hanoi
11.2010 - 11.2014
- In charge of reports related to industry in couple with analysis on some enterprises: Real-Estate (Hoa Phat Group & other construction companies), Textile (Thanh Thanh Cong Textile), Consumer Industry (Thanh Thanh Cong Bien Hoa Sugar, Vinamilk, Vinh Hoan corp, Hung Vuong panga), Oil Indsutry
- Managed OTC portfolio & incorporate with treasury department to support for repo operations
Project Finance Specialist
Project Finance Specialist
Hanoi
12.2009 - 10.2010
- Business planning and project financial planning (forecasting cash flows & analyzing project investment efficiency through IRR, NPV, years of payback ratios)
- Supported for mobilizing capital for the project (mobilized successfully from Techcombank & BIDV for projects named NewLife Cancer Clinic & Vietnam NewLife Hospital with the total funding raising of 36 millions USD)
Education
Master of Finance - Finance Banking Insurance
Université D’Orléans
France 09.2007 - 12.2009
Bachelor of Economics & Management - Economics And Management
Université De La Méditerranée D’Aix- Marseille II
France 06.2004 - 09.2007
High School Diploma -
Ha Noi – Amsterdam School
Hanoi 06.2001 - 06.2004
Skills
Responsible
undefinedSoftware
Timeline
Consultant Expert for Large Corporate Customers
Techcombank, 191 Ba Trieu Street, Vincom Tower, Hanoi
12.2020 - Current
Economics & Business Expert
Global Transaction Banking, Techcombank 191 Ba Trieu Street Vincom Tower
12.2019 - 12.2020
Macro Economics Senior Officer
Treasury Research Department, Techcombank 191 Ba Trieu Street, Vincom Tower
04.2018 - 12.2019
Consulting Senior Analyst
Bao Viet Securities JSC (BVS), 2&3 Floor, 72 Tran Hung Dao Street
04.2015 - 04.2018
Senior Analyst
Military Bank Securities JSC (MBS), 3&7 Floor, 3 Lieu Giai
12.2014 - 04.2015
Senior Analyst
Sai Gon – Ha Noi Securities JSC (SHS), 1A Yet Kieu
11.2010 - 11.2014
Project Finance Specialist
Project Finance Specialist
12.2009 - 10.2010
Master of Finance - Finance Banking Insurance
Université D’Orléans
09.2007 - 12.2009
Bachelor of Economics & Management - Economics And Management
Université De La Méditerranée D’Aix- Marseille II
06.2004 - 09.2007
High School Diploma -
Ha Noi – Amsterdam School
06.2001 - 06.2004
Similar Profiles
Brandon BoardmanBrandon Boardman
Control Operations at Allied Universal Security/ BA Plaza TowerControl Operations at Allied Universal Security/ BA Plaza Tower
Phu Manh NguyenPhu Manh Nguyen
All Rounder at Ba Mi Vietnamese Street FoodAll Rounder at Ba Mi Vietnamese Street Food
Emilia Esperanza R. RiveraEmilia Esperanza R. Rivera
Financial Analyst at State Street HCL Services Philippines, Science Hub TowerFinancial Analyst at State Street HCL Services Philippines, Science Hub Tower
Mykyta ShymkoMykyta Shymko
Account Executive - Large Customers at Akamai TechnologyAccount Executive - Large Customers at Akamai Technology
ANNA GAVRILINAANNA GAVRILINA
Sales Manager Large Enterprise and Global customers at Lenovo East (Russia and CIS)Sales Manager Large Enterprise and Global customers at Lenovo East (Russia and CIS)