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 • Develop engineering solutions using data analysis techniques, such as Reliability modelling, Fault Tree Analysis, Weibull Analysis, Root-Cause, and Root-Cause Failure Analysis (RCA, RCFA)• Focusing on data assessment, governance, and recommendations for subsequent improvements

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 reliability• 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• Utilized SQL queries to create interactive Dashboards in Salesforce for streamlined Customer Issue Resolution and effectively managed CRM processes

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• Participated, cooperated and contributed to cross-functional project teams to assist in the development and improvements of business processes to meet ongoing business needs

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