Nguyễn Thị Quế Trân

NGUYEN THI QUE TRAN PROCESS IMPROVEMENT AND DATA MANAGEMENT OFFICER 📧 District 7, Ho Chi Minh City |-| linkedin.com/in/tran-nguyen-085aaa282 🔗 📞- PROFESSIONAL PROFILE Analytical and results-driven Data Analyst with a strong foundation in business statistics and econometrics. Experienced in transforming raw data into actionable insights through data visualization, automation, and predictive modeling. Adept at handling large datasets using SQL, Power BI, and Python, with a proven ability to streamline reporting processes and communicate effectively with both technical and non-technical stakeholders. TECHNICAL SKILLS • Tools & Languages: SQL Server, Power BI, Excel (Pivot Tables, VLOOKUP), Python (Pandas, Matplotlib), Power Query • Analytics: Data Cleaning, KPI Monitoring, Forecasting, A/B Testing, Dashboard Design • Statistical Modeling: Regression Analysis, Correlation, Multicollinearity, OLS, FEM, REM • Automation & Workflow: Python Scripting, API Integration, Lark Workflow, Coze AI PROFESSIONAL EXPERIENCE Orient Commercial Joint Stock Bank (OCB) Process improvement and data management officer Apr 2024 – Apr 2025 Designed dynamic Power BI dashboards to track banking KPIs across 10+ departments Developed optimized SQL queries for extracting and transforming data from DWH systems Automated Board and KRI reports using Power Query, reducing manual work by 40% Built early warning systems to monitor underperformance in key business areas Collaborated on cross-functional BI projects to enhance enterprise reporting Transform Group Data & Workflow Automation Specialist (Freelancer) Jan 2024 – Mar 2024 Created chatbot and data automation solutions for HR and recruitment workflows Integrated Google Sheets, APIs, and Lark Workflow to automate revenue tracking Reduced manual reporting by 50% through script-based automation Conducted internal training on data tools for 30+ employees Fujifilm Business Innovation Vietnam Sales Operations Assistant (Data Support) Ensured CRM data quality in Salesforce for accurate sales analytics Collected and processed data for opportunity and performance analysis Supported digital solution mapping and generated customer journey reports Coordinated reporting for regional partners in Korea and Japan PROJECTS & RESEARCH Power BI Dashboard – Banking KPIs Automation Power BI Dashboard: Banking KPIs Automation Built a Power BI dashboard connected to SQL Server, automating Board KPIs & monthly targets. Integrated conditional formatting and DAX measures for real-time performance tracking. Econometric Research – Healthcare Earnings Management Collected panel data for 53 companies over 7 years. Applied Pooled OLS, FEM, REM, GLS using STATA to identify earnings manipulation behavior. Won Consolation Prize at National Econometrics Olympiad 2022. EDUCATION University of Economics Ho Chi Minh City (UEH) Bachelor’s in Valuation Industry | 2019 – 2022 Focus Areas: Econometrics, Business Statistics, Financial Valuation CERTIFICATIONS : Microsoft Azure , Microsoft Power Bi , Microsoft SQL LANGUAGES Vietnamese – Native English – Professional Proficiency Dec 2022 – Jan 2024