Naum Bidzovski

Created reporting and data visualization standards that have become Telekom Austria Group's reference for financial and marketing reporting.

Developed from scratch and managing reporting portfolio and online reporting portal of a large telco operator in the EU region. In a 4-year period, delivered and managed more than a hundred complex on-line reports and dashboards that are being used by almost 80 users in marketing, sales, and finance departments on various positions: executives, directors, and line managers. Responsible for documentation and alignment of all business-relevant KPI-s, collection of new report requirements from business users, and MDM/data governance processes implementation.

Technologies used: Teradata DWH, MS SharePoint, MS SSAS/SSRS/SSIS, and MS Power BI.

Designed and responsible for delivery of onSpot Socializer - social media competitive intelligence tool that collects data from major social media platforms and delivers unique customized qualitative and quantitative insights on competition to social media managers like no other tool on market. The tool performs custom categorization of competitors’ social media content based on the client’s requirements and industry specifics allowing them to receive focused and relevant updates and to conduct an in-depth analysis of social media content Tableau platform. The tool is used by a dozen clients in the EU region. The system is based on MariaDB, Apache Spark, Pentaho ETL tool, Python data collection scripts, and Tableau for reporting.

Developed online dashboards and email reports for social media monitoring tools in Tableau. More than 300 KPIs and 50 dashboards have been created, split into several groups. One set of dashboards enabled clients' executives to get very aggregated and focused top-level updates only on relevant competitor's activities on social media. The second set of dashboards enabled media and product managers to conduct an in-depth analysis of competitor's activities, observe user's reactions, and benchmark their promotion activities against the competition. The third set of reports is being sent by email to relevant departments enabling them to get almost real-time updates on competitor's promotions on social media.

The reports are being used by a dozen companies in EU region in telco, energetics, and tourism industries.

End-to-end responsible for design, development, and delivery of onSpot Competitive Intelligence Tracker system - a tool for tracking activities of competitors on national markets from various data sources, used by many telco companies in the EU region. CIT scans web sites of local companies competitors collects tenths of thousands of prices, offers, and promotions and delivers fast notifications on market changes, online analytics, pricing, and competitive bench-marking capabilities, It provides very reliable, up-to-date, standardized and detailed data from unstructured market data to a number of departments, such as customer value management, terminal management, products and services, pricing, controlling and sales. A tool is developed in the MariaDB database, uses several customized and commercial data scrapping tools including Python, Pentaho Data Integration for data transformation, and Tableau Server for OLAP reporting and analytics.

Developed online dashboards and email reports for visualizing data from competitive intelligence data monitoring tools in Tableau. The tool collects large amounts of unstructured data from telco, energetics, and FMCG company's web sites and delivers almost 800 structured consolidated KPIs on a daily level. More than a hundred custom dashboards and 40 email reports have been created in a period of four years for clients in Tableau. They have been split into several groups and areas based on industry, specific client's needs, and executive levels.

One set of dashboards enabled clients' executives to get very aggregated and focused top-level updates only on relevant competitor's activities on Web sites. The second set of dashboards enabled product, pricing, and sales managers to conduct an in-depth analysis of competitor's activities, conduct competitive price, product, and service benchmarking, build and update pricing models. The third set of reports is being sent by email to relevant departments enabling them to get almost real-time updates on competitor's new products and services and price changes.

The reports are being used by a dozen companies in the EU region in telco, energetics, and FMCG industries.

Leading company's #1 priority project that positioned Telenor Serbia as a leader in Telenor group data analytics. Besides project and team management, responsible for documentation and alignment of all relevant KPIs, reports, and data-related processes in marketing, finance, and technology departments, implementation of MDM and data quality management procedures used to maintain data quality company-wide. This one-year lasting project has delivered state-of-the-art Oracle Exadata DWH hardware system, eight analytical business areas on top of customized Teradata telco data model, four customer data-marts, and hundreds of OBIEE online reports.

Technologies used: Oracle DB, Oracle OBIEE, MS SharePoint.

Designed and implemented DMC-Squid - an MS SQL server and SPSS Clementine (now SPSS modeler) based system for collecting, standardizing, enriching, and validating demographic contact data from publicly available data sources. Data from this system is used for user segmentation during DM campaign preparation.

Responsible for building customer experience monitoring and reaction system that has helped Telenor Denmark to locate all events that have been decreasing customer experience levels by low-latency monitoring of interactions with the mobile network, points of sales an contact center. Technologies used: Teradata Aster, Oracle Exadata, and Pentaho ETL.