Hoai Le N.

POWER BI SOLUTION PORTAL Insights, + Implemented asynchronous processing with Kafka to eliminate query delays caused by slow rendering of Power BI reports on client portals. + Developed ETL and data integration pipelines to extract and transform data from external databases (SQL Server) and load pre-processed data into SFTP for subsequent processing in Power BI. + Optimized Azure cloud resource costs, reducing expenses to approximately $900/month through Azure automation runbooks for scaling, pausing, and starting Power BI Embedded. CRM + Transformed a large Microsoft Access application into a PowerApps solution with Azure SQL. + Built automation to send 500+ templated emails/day using Power Automate and Exchange Online. + Refactored and optimized Azure SQL queries, reducing query time from 7s to 1.08s across a 5M+ row Leads table. + Migrated user mailboxes from on-premise hMailServer to Microsoft 365 (Exchange online). REPORTING + Developed a PowerApps tool enabling 50 employees across 5 sites to modify and submit their monthly reports. + Implemented role-based access control (employee/manager login), reporting, and data visualization (Power BI)..

• - Notable project: Étude des conflits dans l'édition collaborative + Analyzed conflicts in asynchronous contexts (merging on Git-based open-source projects) and synchronous contexts (collaborative editing on a on-premise ShareLatex server) Back-End

My-reward-2 + Migrated a website from PHP to Java using the Struts MVC framework and Hibernate. + Key responsibilities included refactoring back-end logic and optimizing database interactions.