Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Denis Romanenko

Mississauga,ON

Summary

Personable business professional bringing successful 20+ year career in Data Architect and Busyness Analysis roles within telecommunication industry Consumer Marketing, Finance, and wholesale groups. Creative solutions architect with real-time problem-solving flexibility.

Overview

25
25
years of professional experience
1
1
Certification

Work History

Business Systems Analyst II

TELUS, Finance
09.2020 - 02.2024
  • Collaborated with stakeholders to gather essential requirements, ensuring successful project outcomes
  • Developed custom reports utilizing advanced analytics techniques, giving decision-makers valuable insights
  • Provided critical support for multi-layer Mobile at Home (M&H) data processing system
  • Developed DOMO dashboards for M&N offer redemptions in National sales channels reporting
  • Developed data process on customer with single product (so-called "naked" customers)
  • Developed comprehensive Tableau dashboard on Customer Product Intensity
  • Acted as a team leader in group projects
  • Tableau admin for the department
  • Ad-hoc reporting. Competitive outage impact. M&H customers movement

Market Intelligence Manager

TELUS, Consumer Marketing
03.2016 - 09.2020
  • Implemented comprehensive automated reporting system for customer activations, renewals and migrations
  • Created dashboards to monitor key performance indicators for mobility MRC and ARPU.
  • Created dashboards to monitor customers allotted data usage, CHURN
  • Implemented automated processes for low level data analysis on customers offers for multicultural sub-market to specific to customer porting
  • Generated ad-hoc reports to evaluate specific business requirements.

Business Systems Analyst

TELUS, Global Carrier Solutions
09.2008 - 03.2016
  • Comprehensive automated Tableau dashboard reporting with multiples data sources
  • Support for financial settlement and network operations with reliable reporting and analysis in all aspect of roaming business
  • Dashboard for customer profile analysis
  • Dashboard for weekly roaming steering optimization
  • Full Monte presentation support for roaming financials
  • Wholesale service invoice validation

Sr. Analyst, Roaming Settlement

Rogers Communications
11.2002 - 07.2008
  • Rates modeling and optimization for complex roaming agreements,
  • Data analysis and reporting (including mandated by SOX legislation.
  • Rates validation. Developed system for detection of incorrect charges in roaming usage on individual record level and Data Clearing House reports
  • Billing system provisioning for voice and data· Credit/Debit Notes investigation and disputes resolution


Roaming Specialist

Kyivstar GSM
08.1999 - 05.2021

· Application development for roaming analytics (Oracle, Excel)

· Data analysis and reporting regular/ad-hoc

· Monthly roaming service invoicing for finance and reconciliation

· Roaming data exchange control, evaluation and errors correction

Education

Professional Certificate - Big Data Tools And Techniques

University of Toronto School of Continuing Studies
Toronto, ON
12.2014

Master of Science - Telecommunications Systems

Telecommunications University
Kyiv, Ukraine
05.1999

Graduate Certificate - Advanced Computer Training

National Polytechnic University
Kyiv, Ukraine
05.1999

Bachelor of Science - Telecommunications

Telecommunications College
Kyiv, Ukraine
05.1996

Skills

  • SQL Proficiency in Oracle, Pl/Sql, Sql Server, My Sql
  • Business intelligence tools: SAS, Tableau, DOMO, GCP, Power BI, SAS Data Flux
  • MS Office, VBA Proficiency
  • Code debugging
  • Data Migration
  • Attention to Detail
  • Documentation abilities
  • Database Design
  • Requirements Gathering

Certification

  • SAS Data Management and Macro language, SAS Institute, July 2018
  • SAS Programming: Data Manipulation Techniques, SAS Institute, July 2019
  • Big Data Management Systems & Tools, University of Toronto School of Continuing Studies, 2013 - 2014

Languages

English
Ukrainian

Timeline

Business Systems Analyst II

TELUS, Finance
09.2020 - 02.2024

Market Intelligence Manager

TELUS, Consumer Marketing
03.2016 - 09.2020

Business Systems Analyst

TELUS, Global Carrier Solutions
09.2008 - 03.2016

Sr. Analyst, Roaming Settlement

Rogers Communications
11.2002 - 07.2008

Roaming Specialist

Kyivstar GSM
08.1999 - 05.2021

Professional Certificate - Big Data Tools And Techniques

University of Toronto School of Continuing Studies

Master of Science - Telecommunications Systems

Telecommunications University

Graduate Certificate - Advanced Computer Training

National Polytechnic University

Bachelor of Science - Telecommunications

Telecommunications College
Denis Romanenko