Dora Stefanova

Lead full cycle BI projects from business requirements definition, raw data ingestion, and data model creation to actionable insights delivery. Initiate digital transformation of commercial processes, identify technical solutions and lead the design and implementation.

Responsible for the design, implementation and automation of Orsay’s E-Commerce analytics & reporting platform, including integration of disperse data from multiple sources in Google Cloud. • Building multidimensional data and analytical models for Marketing, Sales, UX, Assortment, Customer Service and E-Commerce teams. • Business and technical support for Orsay’s mobile app including partner integration enabling generation of over €1MM daily revenue. • Designing and implementing Tableau dashboards.

Leading role in data integration, analysis and validation. Driving conceptualizing and implementation of new corporate analytical initiatives. * Led customer data migration project and exceeded conversion and penetration targets by more than 10% and 35%. Designed and implemented reporting data mart for customer migration tracking. * Designed a data model for cross-functional and cross-enterprise conversion from contract- to customer-based performance evaluation enabling company-wide CRM overhaul.

Led the data transition to CIS virtual server and implementation of new reporting platform. * Designed and developed enterprise data models from over 50 disperse data bases. Optimized performance via push-down, partitioning and query optimization with a CIS virtual server. * Analyzed cost, training, technical and functional capabilities of various BI solutions such as Tableau, Qlik Sense and Qlik View. Selected and led the implementation of the most suitable tool for reporting and data visualization.

Designed the BI architecture and developed the data mart for the Product Management and CRM departments. Introduced quality assurance practices to ensure data integrity and quality. * Improved the performance for major daily ETL procedures used for the reporting by the Analytics team by more than 10 times. * Replaced a company-wide used data structure for tracking the mobile and DSL contracts (over 20MM customers) resulting in 15% improved data quality.

Performed predictive modeling, market segmentation, campaign definition, post-campaign, and various statistical analyses in support of strategic loyalty and marketing initiatives. Enhanced and automated ongoing reporting and executive dashboards. * Automated the procedure for the bi-annual executive program revision: enabled the Analytics team to prepare the required analyses and presentations for more than 30 partners. * Implemented a methodology for precise geotargeting

Performed analysis, implemented and controlled improvements to the cost management levers for air redemption expense. Developed business requirements for a new IT infrastructure implementation and fare provider replacement for Aeroplan’s air booking platform. * Managed end-to-end testing activities and business requirements for the implementation of a new booking platform. * Built optimization models supporting Aeroplan in accumulation rate negotiations with Star Alliance partners.

Managed Six Sigma projects and facilitated workout sessions. Provided expertise in various corporate initiatives with process mapping, data analysis, report creation, automation and roll-out. * Led a project of automating the performance reporting for the Aeroplan’s contact center. Designed and built a reporting database consolidating disperse data sources and standardized automated report with all KPIs. * Led a project for improving the e-mail processing by a team of call center agents resulting.