Ming Li Email & Phone Number

Lasalle, Quebec, CA

• Lead BI initiatives covering all aspects of the business, in close collaboration with key stakeholders such as Executives and Senior Management, Operations, and other departments, including providing presentations
• Developed and maintained key BI Dashboards (Sales Performance, Daily Gain vs. Budgets and Pace, AR Report, Churn Report, Trucking Performance, Executive Dashboard, etc.) using Tableau, PostgreSQL, IBM DB2, Python, and.
• Developed and maintained key Operations reports, notably Commissions calculations and reporting, working closely with Operations and Payroll using Tableau, DB2 SQL, and API integration with the BambooHR ERP system
• Created complex SQL queries for backend views and calculations used in various reports, such as in TMW DAWG reports for Operations teams, using Git for Version Control
• Ensured streamlined BI operations by assigning and managing team workloads, providing mentorship and coaching as needed, and upheld SLAs for support tickets and issues (using FreshService)
• Worked closely with the Digital Transformation team to migrate the legacy TMW ERP system to a new NetSuite and Turvo ERP-based platform, including all downstream impacts to BI and reporting, using Monday.com for.

Herzliya, IL

Apache Airflow, Vertica DB, Tableau Desktop, Kafka, Jira- Collaborated with BA, R&D to identify and define BI requirements and telemetry data points of significance for existing game features. Transferred and flattened relevant data from Kafka with JSON format to Vertica DB- Defined data warehouse structures and built Dimension and Fact tables, based on.

Lasalle, Quebec, CA

- Collaborated with various teams including Executive (CEO, President), Sales, Finance, Marketing, HR, and EDI to takeprecise business needs and translate them into functional and technical BI requirements- Designed, developed, and tested complex dashboards with functionality based on transportation businessrequirements using Tableau, PostgreSQL, and.

Montreal, Quebec, CA

Tools Used: Tableau, Snowflake, OBIEE, ODI, PL/SQL, Microsoft Excel, JIRA- Facilitating Retail Client Operations with Data insights, interactive dashboards and Ad-hoc Reporting- Lead several projects designing and developing modules pertaining to Customer Relationship Management (CRM), OMNI channel Sales and Orders, Retail Inventory Management strategy.

Montreal, Quebec, CA

Tools Used: T-SQL, SSIS, SSRS, SSAS- Worked on projects for the Montreal Transport Society (Société de Transport de Montréal, STM) using Microsoft SQL Server 2012, SSIS, SSRS, and SSAS - Analyzed and cleaned source data, and extracted data from flat files and loaded it into SQL Server - Built operational reports (daily bus schedules) using SSRS - Provided.

Tools Used: Microsoft Excel, Microsoft Access, Microsoft PowerPoint- Analyzed business data for all regions of the province, and generated sales reports and PowerPoint presentations using Excel generated data (Pivot tables, VLOOKUP, charts) - Responsible for key customers, negotiations, and assisted in regional treatment issues - Assisted the General Sales.

Shanghai, Shanghai, CN

Tools Used: Microsoft Excel, Microsoft Access, Microsoft PowerPoint- Analyzed business data for all stores of the province with a complete ETL process (data extraction from cashier servers, data transformation to SQL, and data loaded to Excel) to provide for analysis in Excel by using formulas, pivot tables, and VLOOKUP - Reported sales results daily.

Advance Bi Diploma, Business Intelligence And Reporting Analyst

D.E.P, Computer Graphics

Bachelor'S Degree, Computer Science