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 Alteryx, along with various integrations such as HubSpot CRM, Samsara (Fleet management), and TMW ERP system• 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 Project work tracking• Developed comprehensive document specifications, created detailed user guides that enhanced user experience by providing step-by-step instructions and designed work guides to streamline internal processes

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 existing game data staging tables to allow for complex future game analytics- Developed enhancements to Apache Airflow ETL processes used in extracting production data into Vertica DB for analytics, with source code stored in a Git-based source control system- Created new Tableau reports (including Proof-of-Concepts), and improved existing reports on new and existing Data warehouse objects- Maintained documentation within Jira and the company internal Wiki pages

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 Salesforce. Ensured the data accuracy of each report, and presentedthe Tableau dashboards to the appropriate business stakeholders- Maintained and enhanced existing ETL flows in Alteryx and created new flows based on business needs- Managed data warehouse data modeling, including maintaining, creating, and optimizing tables, views, andmaterialized views in order to ensure good data refresh performance with PostgreSQL and Tableau Bridge- Responsible for all Tableau Online and Tableau Desktop related matters including security configuration,upgrading/maintenance, performance, and user/group management

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, Product Return, Return to Vendor, Site to Site Transfer, Price Elasticity Concept - Designed, developed, and tested complex dashboards with functionality based on business requirements with Oracle OBIEE and Tableau - Assisted in the day-to-day operations of the team, coordinated tasks between internal team members, and collaborated with other departments in the company - Diagnosed and solved clients’ dashboards issues, redirecting problems to the appropriate resource when necessary, and enhancing clients’ reports based on advanced business requirements - Participated in ETL development using PL/SQL, including analysis, testing, and bug fixing - Involved in the migration from Oracle technology to Tableau and Snowflake for the BI stack - Designed and built a new BI Cube for the Order Management System module in the Jesta ERP system

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 assistance to students during their projects related to SQL, SSAS, SSIS, SSRS

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 Manager in preparing monthly and annual tasks and budgets - Maintained close communication and coordination with other departments

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, monthly, and yearly to all sales departments using PowerPoint presentations - Maintained strong communication and coordination between departments in English

Advance Bi Diploma, Business Intelligence And Reporting Analyst

D.E.P, Computer Graphics

Bachelor'S Degree, Computer Science