Nhu Phạm

Results-driven Business Intelligence Developer and Data Analyst with over 9 years of progressive experience across BI development, data engineering, and data analytics. Proven track record leading full-cycle BI development - from data warehouse design and SSIS pipelines to high-volume Power BI reporting - and now advancing into data engineering, driving ERP system migration (Dynamics AX to Odoo) and enabling BI teams through clean, well-structured data pipelines. Skilled in Advanced SQL/T-SQL/PostgreSQL (Window Functions, CTEs), Python, Power Query, and DAX, with strong data governance practices through Row-Level Security (RLS).

Experienced with legacy platforms (SQL Server/SSIS) and modern cloud tools such as Microsoft Fabric and Power Automate, recognized with a company award for workflow automation.

Senior Data Engineer at ILA Vietnam (2026-01 – Present)

• ERP Migration: Leading the data migration from Dynamics AX to Odoo, including validating data integrity and consistency across systems.
• Reporting Development: Building and maintaining custom reports within the Odoo system to support business reporting needs.
• Cross-functional Consulting: Partnering with the BI team to guide data extraction and cleansing, structuring transformed data within the data warehouse, and advising on Power BI report design and Power Query data transformations.

Business Intelligence Developer at AS White Global (2019-04 – 2025-12)

Engaged on the EML Group account, one of Australia's leading workers' compensation and insurance providers, delivering BI and data engineering solutions across Claims Management, Compensation Management, Finance, and Actuarial Analytics functions.

• Stakeholder Engagement: Worked with stakeholders and cross-functional teams to define and develop BI solutions aligned with business needs.
• Data Warehouse Management: Led the design of SQL Server data warehouses and constructed SSIS packages for complex, multi-source data integration processes.
• ETL Development: Developed and monitored ETL processes using SQL and SSIS to cleanse, transform, and load complex datasets into the SQL database.
• Performance Optimization: Optimized complex stored procedures, functions, and SQL queries to improve performance across large datasets.
• Data Modeling: Maintained and built data models and schemas to provide statistical and analytical visualizations in BI reports.
• Cloud Migration: Migrated on-premises databases and CSV files to Microsoft Fabric Lakehouse to optimize BI report performance for large-scale datasets.
• Cloud Security & Optimization: Successfully deployed Power BI reports to the cloud with Row-Level Security (RLS) and provided advanced DAX and Power Query support to internal teams.
• Dashboard & Reporting: Developed and maintained dashboards and BI reports tracking performance metrics for Claims Management, Compensation Management, Finance, Insight, and Actuarial Analytics teams; published and maintained reports on Fabric service, managing user permissions and ensuring timely updates.
• Ad-hoc Analysis: Used SQL queries to extract ad-hoc data for stakeholders.
• Innovation & Automation: Implemented a Power Automate solution to automatically save survey forms to SharePoint, reducing manual data handling and resulting in a quarterly company award for workflow automation.
• Key Reporting Solutions: Developed high-volume analytical reports supporting compliance and operational insights, including Incapacity Delay Reporting and Physical Injuries with Psych Spend Analysis.
• Mentorship: Provided technical mentorship by peer-reviewing Power BI reports and assisting team members with DAX expressions and Power Query transformations.

Senior Data Analyst at ILA Vietnam (2017-10 – 2019-04)

• BI Migration Leadership: Led the project to migrate legacy SSRS ERP Dynamics reports to Power BI systems, leveraging advanced DAX and Power Query for complex calculations, data transformation, and enhanced analytics.
• Data Optimization: Optimized SQL scripts for financial, cost, and sales datasets, improving query performance and supporting data warehouse design efforts.
• Report Development: Developed interactive Power BI Desktop reports, using Power Query for data transformation, based on gathered user requirements to support business decision-making.

Technical Consultant at Delta 5 Group (2015-08 – 2016-12)

• ERP Customization: Customized key modules of Epicor ERP using C# to align the system with client-specific business requirements.
• Reporting: Developed standard and custom reports using SSRS and Crystal Reports based on SQL.

Bachelor's Degree in Management Information Systems – University of Economics and Law (2011 – 2015)