Michael Liang

Senior Program Analyst (Power Bi, Sql, Ms Access, Python, Vba, Etl) @City of Los Angeles

Los Angeles, CA, US

Supporting MS ACCESS Application (VBA) • Building Monthly reports, Management reports, Sanitation report using power BI (Dax)/Excel Macros• Design and optimize DAX expressions for calculated columns, measures, and calculated tables to ensure efficient and accurate data model• Optimize Power BI performance by fine-tuning DAX queries, data models, and report designs.• Developed and maintained enterprise applications using C#(WPF, ASP.NET MVC) and SQL Server. • Designed and optimized stored procedures, views, functions, and triggers for SQL Server and Oracle db. • Migrate MS Excel to SSRS/Power Bi reports. • Developed Power BI /paginated reports with DAX functions and Python integration for data visualization. • Use Python (Matplotlib, Panda) import source data and create visuals reports. • Buit ETL package to migrate MS ACCESS data to SQL server • Setup connection from data factory to snowflake and create data flow. • Built data pipeline using data factory to migrate SQL/ external data to snowflake and save the code to GitHub. • Analysis the data from snowflake • use CI/CD for testing Data Factory pipeline code. • Migrated MS Access applications to SQL Server to Azure data bricks, converting VBA scripts into C# applications. • Automated workflows and data synchronization using Power Automate. • Led the redesign of the Fuel Maintenance and Petroleum Products applications• Automated Contract expiration notification system using MS power Automate • Automated Invoice Approval notification system using MS Power App. • Working with MS Dataverse data to create power Apps• Loading data using ETL (SSIS) to SQL server • Create stored procedure for Data cleansing, data corrections, Data remediation for external data before importing to SQL Server. • Using Project Online Desktop Client to manage and track all the projects plans, including scheduling, and reporting (power bi reports, power apps, power automate)

Baruch College

BS, Computer Science

Baruch College

Bachelor's degree, Computer Science