Pann Pwint Phyu Portrait

Hi , I am

Pann Pwint Phyu

A passionate Data Analyst / BI Analyst with expertise in Excel,Power BI ,SQL ,ETL&Data Warehouse. Business Data Analyst (Team Leader) with 3+ years’ experience in the Microfinance sector, specializing in Sales performance analytics,Portfolio insights, Early-closure analysis, and Fraud detection. Strong background in Monthly HQ reporting, Reward program design, ETL development, Customer segmentation, and Leading cross-functional follow-up teams to drive sales productivity and portfolio quality.

About Me

Hello! I'm Pann Pwint Phyu .

A Business Data Analyst Team Leader with 3+ years of experience in Shinhan Microfinance Myanmar.

🔹 Sales Analytics & HQ Reporting
Delivered monthly sales, risk, and portfolio reports to Korea HQ, covering disbursement trends, PAR, customer behavior, officer performance, and early-closure patterns. Analyzed DPD buckets, roll rates, delinquency trends, and early-warning signals to support credit risk decisions.

🔹 Reward Program Development
Designed and automated the Monthly Excel-based incentive program, improving transparency and boosting sales team motivation and productivity.

🔹 Early Closure & Interest Loss Analysis
Identified early-closure behavior affecting interest income and portfolio cycling; recommended strategies to reduce losses and improve loan retention.

🔹 High-Risk Customer Follow-Up Leadership
Led the follow-up team for abnormal repayment customers and developed Monthly Sales-priority plans using data-driven scoring models, improving recovery efficiency and sales performance.

🔹 ETL & Data Warehouse (Bronze → Silver → Gold)
Built daily and monthly ETL pipelines for closed, disbursed, LP, overdue, and customer info datasets using SQL, staging, and BULK INSERT. Maintained high data accuracy for Power BI and HQ reporting.

🔹 Fraud & Credit Analytics
Designed early warning indicators, identified fraud patterns, and strengthened credit monitoring with repayment and behavior analysis.

🔹 Operational Tools & Automation
Developed an AppSheet negotiation tool enabling sales officers to access real-time repayment history. Automated approval processes using AI to reduce manual workload.

🔹 Regulatory & FRD Reporting
Prepared monthly reports required by FRD. Managed 6-month FRD audit submissions, ensuring compliance, accuracy, and timely delivery. Maintained audit-ready datasets and collaborated with internal teams to support regulatory inspections.
----------------------------------------------------------------------------------------------------------------------------------------------------
🔹WORKFLOW SUMMARY
Daily
Portfolio Monitoring ,ETL processing, Data Validation, Dashboards, Cross-team support
Weekly
Performance Monitoring, Action Planning & Team Support.Prepared and delivered weekly briefing reports for management, highlighting priority areas, branch-level performance , officer productivity issues, and actionable recommendations.
Monthly
EOM snapshots, Korea HQ reporting, reward calculation, closure trend review, follow-up planning, management insights
----------------------------------------------------------------------------------------------------------------------------------------------------

CORE SKILLS

  • Business
    • Portfolio Reporting, Incentive Modeling, Early-Closure Analysis, Recovery Prioritization, Fraud Detection, Team Leadership
  • Technical
    • SQL , Power BI , Excel , AppSheet, ETL & Data Warehouse (Bronze–Silver–Gold)
----------------------------------------------------------------------------------------------------------------------------------------------------

Experience

  • (2023-October) - (2025-September)
  • Business Data Analyst Team Leader @ Shinhan Microfinance Myanmar

  • (2022-August) - (2023-September)
  • Senior Business Data Analyst@ Shinhan Microfinance Myanmar

  • (January-2020) - (April-2021)
  • Sales Consultant @ MMIT
    ----------------------------------------------------------------------------------------------------------------------------------------------------
  • Date of birth
  • 10-May-1995

  • Marital Status
  • Single

  • Education
  • BA.(English)

    🔹Certificate
    Data Analyst in Power BI by Datacamp

    My Projects

    Superstore Analytics Dashboard



    View on GitHub

    Insurance Business Insights Report



    View on GitHub

    End to End SQL,Power BI,Analytics



    View on GitHub

    My Achievements


    🔹Best Team Leader Award 2024
    For developing an impactful digital solution (AppSheet) that improved negotiation efficiency and ensured timely, accurate data during field operations.

    🔹Best Team Leader Award 2023 (Back Office)
    For using analytics to detect fraud, strengthen sales performance, and consistently deliver high-value insights to management.

    🔹 Credit Monitoring & Overdue Risk Analysis (Cross-Functional Impact)
    Developed a monthly Credit Monitoring Report using overdue history and repayment behavior analysis. This replaced manual account-by-account checking and enabled faster, more accurate decision-making. The report significantly supported both the Recovery and Credit Teams, improving risk evaluation, borrower assessment, and cross-functional coordination.

    🔹 Operational App Development (AppSheet_No code Development)
    Designed an AppSheet negotiation support tool that provides real-time repayment history and accurate customer information to field sales officers. This digital solution improved negotiation efficiency, reduced data access time, and enhanced overall sales operations.

    🔹 Data Quality Transformation
    Led a data quality improvement initiative that transformed inconsistent, fragmented datasets into accurate, reliable reporting sources. Before this initiative, many required data points were unavailable or incorrect; afterward, me and my team could deliver any data the management needed, consistently and accurately.

    🔹 Historical Data Mining & Behavioral Insights
    Performed deep data mining from 2016 to the present, uncovering trends in repayment behavior, product performance, and customer lifecycle patterns. These insights enabled more accurate customer segmentation, stronger credit analysis, and improved operational planning. Lead the development and successful launch of [Project Name], resulting in [quantifiable impact, e.g., 20% increase in sales].

    🔹 Fraud Detection & Prevention Support
    Enhanced fraud detection capabilities by identifying unusual repayment deviations, loan cycling patterns, and abnormal borrower behavior. Provided analytical support to prevent fraud and protect portfolio quality.

    🔹 Incentive & Reward Program Design
    Created a performance-based reward program that aligned officer and manager behavior with organizational goals. Monthly Excel-based calculations ensured transparency, fairness, and improved sales performance.

    Contact Me

    Feel free to reach out through any of the following channels:

  • Address

  • N0.20,Lanmadaw (16) St,Lanmadaw Tsp,Yangon.

    Email

    pannpwintphyu465@gmail.com

    Phone Number

    09959715275

    Social Media