Learn Data Skills
Beta

Mihaela Ceausu

Senior Data Analyst

Dynamite

Technologies

My Portfolio Highlights

My New Track

Data Scientist

My New Course

Introduction to Python

My New Track

Data Scientist

Passionate problem-solver, leveraging data to drive impactful solutions.

My Work

Take a look at my latest work.

course

Introduction to R

course

Introduction to Python

course

Intermediate Python

course

Introduction to R

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to Power BI
Introduction to R
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

Groupe Dynamite | Nov 2021 - Sep 2022

Senior Data Analyst

• Created a PowerBI report to explore customer survey responses using the AWS Comprehend model (language detection and targeted sentiment analysis via the API using Python) • Brought data from BigQuery into SQL to tie media source to revenue for improved marketing reporting: ROAS, paid media performance, customer purchase and browsing behaviour • Completed AB test analyses for the marketing team and improved the analytical process • Completed regular data analysis requests (SQL, Excel) and presentations (Google Slides) for business stakeholders regarding customer sales metrics and purchase behaviour - LTV, carrier shipment performance, and affiliate marketing impact on sales
Show More

Just Energy | Dec 2020 - Nov 2021

Business Analyst

• Built the FY22 Budget • Auditing accruals to reconcile budget vs actuals facilitating quicker analysis • Building queries and automating reports in PowerBI for trend analysis and drill downs on key metrics, offering insight on performance and opportunities for improvement on bad debt, campaigns, and operational work load • Teaching SQL to the department to help drive greater efficiency and effectiveness

Just Energy | Oct 2019 - Dec 2020

Operations Analyst

• Created, updated and queried tables using DDL, DML, and DQL to consolidate data from different servers into one database to determine the effectiveness of an incentive program on customer behaviour • Discovered gaps between new business and outdated system logic by querying relevant tables (T-SQL), scoped out range and size of impact, clearly outlined specifications and suggested potential solutions to management and IT • Lead analyst in working with IT to implement major and minor system changes – validated data for migration, checked for data integrity, proper functioning of system procedures and transaction error handling • Built and improved processes and reports to keep track of program trends, budgeting, KPIs and financial risk

Just Energy | Apr 2018 - Sep 2019

Workforce Analyst

Lean Six Sigma Green Belt • Achieved results of 3% in FTE reduction ($150,000/year) by optimizing skill profiling during the completion of a Lean Six Sigma Greenbelt project – used Microsoft Visio and statistics for qualitative and quantitative analysis of all internal factors contributing to agent occupancy Reporting Analysis and Accuracy • Improved payroll accuracy– edited the Excel macro for accurate hours calculation and to incorporate a new company code; worked with Business Intelligence to query accurate data; tracked issues to identify further opportunities for improvement • Produced commission reports (Excel) making necessary functional adjustments; developed process for validating invoices and stopped overbilling by $20,000/month • Led the automation of commissions reporting – defined parameters, completed variance analysis, performed UAT and trained others while working with IT and a consulting firm Workforce Analysis • Validated a new headcount file and developed process for its maintenance • Performed intraday functions such as closing tickets, queue management, uploading dialer lists, running reports and meetings

My Education

Take a look at my formal education

Master of Arts - MA, Public Policy and AdministrationRyerson University | 2014
Hobours Bachelor of Science - HBS , Environmental ChemistryUniversity of Toronto | 2011

About Me

Mihaela hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free