Chen Li Email & Phone Number

Toronto, ON, CA

Ontario, Canada

• Using SQL to create data staging, transformation, and validation scripts, cleanse and transform client data to align with our models and client-specific details
• Assess new data sources and data-gathering techniques for effectiveness and accuracy
• Analyze asset-specific data to identify risks, improve data quality, and collaborate directly with clients and business users
• Perform risk analysis for specific pipeline assets, including detailed engineering calculations, and address pipeline integrity issues within risk modelling approaches
• Execute engineering aspects of Integrity Management software implementations, data transformation and the enhancement of risk models for pipeline assets while also addressing software engineering elements
• Utilizing Power BI to create reports and provide peer reviews as needed, including both well-organized and unstructured datasets. Identify, analyze, and interpret trends in complex data sets

Toronto, Ontario, Canada

• Proficient in Extracting, Transforming, and Loading (ETL) data from diverse sources, including Excel, Flat files, and other data repositories, into MS SQL Server using SSIS packages
• Leveraged a wide range of SSIS transformations, including Lookup, Derived Column, Data Conversion, Aggregate, Conditional Split, SQL Task, Script Task, and Send Mail Task, among others, to ensure data accuracy and.
• Designed and configured OLAP Cubes (utilizing Star and Snow Flex Schema) using SSAS, providing valuable insights for decision-makers
• Utilized Power BI to craft diverse analytical dashboards tailored to the specific needs of various departments and upper-level management, enabling quick and informed decision-making
• Developed dashboards and ad-hoc reports using Power BI and SSRS to support the management team in their data analysis efforts
• Conducted ongoing maintenance and troubleshooting, addressing bug fixes in both existing and new Power BI Reports

Toronto, Ontario, Canada

• Extracted, cleansed, and processed marketing and contacted data using MS Excel, MS Access, and SQL
• Analyzed data using advanced SQL queries including table joins, subquery, single row function, group function, and set operation, views, dynamic SQL, index, etc.
• Developed projects using SSAS, created data source, data source view, OLAP cubes with measures and dimensions, configured attributes of dimension table with hierarchy relationships
• Modified cube and dimensions, deployed KPIs on SSRS and create different metrics, deployed measure groups and dimensions to SSAS instance
• Performed marketing research, updated, and improved database on a regular basis
• Effectively communicated with the project manager to identify issues and potential solutions when required

Montreal, Quebec, Canada

• Documented issues, resolutions/programming steps pertaining to the implementation process and client data
• Performed analyses and quantitative modeling to support strategic, tactical, and operational decisions in the following areas
• Performed 3-month look-ahead Sales forecasting with the consideration of the seasonality in fashion/retail business through the implementation of linear regression, winter-holts, and ARIMA models
• Implemented Digital marketing strategy across multiple channels of Email, Web, Mobile, and social media by WeChat and Sina Weibo to promote quarterly sales events
• Presented business insights/discovery with reporting tools Power BI
• Worked with team members on managing the data implementation process from start to finish for clients

Montreal, Quebec, Canada

• Worked independently to perform data analysis and data extraction of system-wide data
• Determined strategic goals for group/department and developed action plans to achieve strategic goals plus objectives set by upper management
• Developed diagnostics to identify and optimize business performance against objectives
• Supported data collection, validation, cleansing and analytics activities and provide recommendations for data quality improvements

Chenzhou, Hunan, China

• Updated and assisted in providing content to all station’s digital news platforms
• Worked with editorial leadership to develop social media strategies
• Worked closely with VJs, photographers, writers and producers in advertising
• Coordinated and assisted advertising team member
• Worked closely with Executive Producers on advertising planning and coordination

Bachelor Of Science - Bs, Recording Engineering

Diploma Of Education, Residential And Commercial Drafting