Boris is currently unavailable
Boris Mihajlovic
Verified Expert in Engineering
Data Engineer and Software Developer
Belgrade, Serbia
Toptal member since July 19, 2022
Bio
Boris is a goal-driven, innovative IT professional delivering successful projects on time and budget and transforming company operations in key areas of retail, customer relations, finance, and analytics in the oil and gas, telco, and banking industries. He has extensive experience delivering highly challenging projects and complex IT integrations, ensuring thousands of business users benefit from IT systems, and driving efficient and controllable business practices.
Portfolio
Pemex - Main
Microsoft Power BI, SQL, Oracle Primavera, SAP, ETL, Microsoft SQL Server...
NIS Gazprom Neft
Oracle BI, SQL, Oracle RDBMS, Oracle Hyperion Planning...
NIS Gazprom Neft
Oracle BI, Oracle Analytics Cloud (OAC), Oracle RDBMS...
Experience
- Data Analytics - 19 years
- SQL - 15 years
- Oracle RDBMS - 15 years
- BI Reporting - 15 years
- Data Visualization - 15 years
- Microsoft SQL Server - 15 years
- Oracle BI - 13 years
- Microsoft Power BI - 3 years
Preferred Environment
Oracle BI, Oracle Analytics Cloud (OAC), Microsoft Power BI, SQL, D3.js, Oracle RDBMS, Microsoft SQL Server, Oracle SQL Developer, MySQL, PostgreSQL
The most amazing...
...project I've led is a BI solution for an O&G company with 30+ subject areas and thousands of dashboards, enabling an unprecedented rise in the use of data.
Work Experience
Power Bi Expert
2022 - PRESENT
Pemex - Main
- Implemented a comprehensive suite of reporting dashboards for refinery maintenance analytics from data extraction and validation, ETL, and model building to reporting, dashboards, and KPIs.
- Created a complete reporting toolset for project cost forecasting, business planning, risk assessment, variance reporting, and project portfolio management, from data extraction, ETL, and model building to reporting, dashboards, and KPIs.
- Implemented reporting flows for contractor analytics, headcount analysis, and cost planning https://www.pemex.com/en/paginas/default.aspxnd control.
- Enforced equipment rental reporting, driving significant cost reduction, clarity, and understanding of the workflow and process.
Technologies: Microsoft Power BI, SQL, Oracle Primavera, SAP, ETL, Microsoft SQL Server, Azure, Azure SQL, JSON, DAX, Power Query M, Data Warehousing, SQL Server Analysis Services (SSAS), Oracle, Oracle BI, Oracle Database, PL/SQL, Oracle PL/SQL, Azure Synapse Analytics, Synapse, Azure Synapse, Primavera P6 Professional Project Management, Power BI REST APIs, ODBC, Master Data Management (MDM), Data Governance
Next-gen Analytics and Reporting Manager
2021 - PRESENT
NIS Gazprom Neft
- Facilitated the move to next-gen analytics, including self-service analytics, automated infographics, and KPI performance management for 400+ users.
- Created custom fit-for-purpose visualizations and infographics for company top management and key board meetings.
- Improved data quality considerably across subject areas, introducing business firewalls, data enrichment, quality control checkpoints, and data management applications.
- Collaborated with security professionals on data consumption tracking within the company and mobile devices, significantly improving transparency.
- Implemented the accounts receivable and payable subject area, combining data sets from SAP ERP across companies within the group, external benchmarking data, and macro-financial data into single data and dashboard source.
- Implemented material balance subject area, integrating data from Hyperion Planning and custom data enrichment for a unified source of all movement and stock of the NIS Group.
- Implemented SLA subject area for a newly formed shared services business unit, providing all services with a balanced scorecard for all services offered to all clients within NIS Group with custom dynamic rebalancing KPIs.
- Implemented refinery maintenance subject area, integrating data from IBM Maximo service module and providing data enrichment and KPIs for service requests and refinery assets.
Technologies: Oracle BI, SQL, Oracle RDBMS, Oracle Hyperion Planning, Key Performance Indicators (KPIs), D3.js, Microsoft SQL Server, Oracle SQL Developer, Data Science, Oracle Application Express (APEX), Oracle Database, Financial Data Analytics, Data Analytics, Data Visualization, OLAP, Database Design, Star Schema, Oracle Analytics Cloud (OAC), Oracle REST Data Services (ORDS), JavaScript, Jira, Oracle, Data Architecture, Python, Analytics, Data Integration, Data Lakes, Data Engineering, Large Data Sets, Smartsheet, Data Loading, Data Analysis, NoSQL, Hadoop, Oracle WebLogic Application Server, WebLogic, DAX, SQL Server Analysis Services (SSAS), Back-end Development, Architecture, Reporting, Dashboards, Batch Apex, Oracle PL/SQL, Apex, Data Modeling, Interactive Dashboards, Reports, Microsoft Excel, Data-level Security, APIs, BI Reporting, Databases, Data Transformation, Data Cleansing, Data Queries, Transact-SQL (T-SQL), SAP, PL/SQL, JSON, Business Intelligence (BI) Platforms, Marketing Reports, Marketing Analytics, Real-time Data, ODBC, Master Data Management (MDM), Data Governance
BI Manager
2016 - 2021
NIS Gazprom Neft
- Identified and consolidated KPI hierarchies with major stakeholders like upstream, refinery, oil field services, sales, distribution, energy, petrochemicals, health safety, environment, and finance for 6,000+ KPIs and hundreds of business processes.
- Transformed an as-is reporting and designed visual solution and interactions with KPI reporting for BoD from Excel spreadsheets and PowerPoint presentations to easy-to-use and instantly understandable infographics.
- Implemented a data flow from back-end systems and data entry to BI and EPM reporting systems. Ensured consistent and reliable data, checks, and verification processes as well as data enrichment and verification points.
- Implemented several financial subject areas, including current balance, 10-year financial reports, macro-economic reports, and taxes.
- Implemented a service desk for a newly formed shared services center and service desk subject area and dashboards for reporting.
- Implemented timesheet management and a responsible subject area for reporting for the newly formed shared services center.
- Led a company-wide implementation of Jira for business tasks and all development and PM within finance.
- Implemented a retail (petrol station) subject area, integrating data from several data sources such as POS systems, SAP ERP, and Hyperion Planning.
- Implemented a KPI subject area and custom board of directors set of dashboards with a unique custom KPI visualization custom plug-in, fit for the company's methodology and management needs.
- Delivered key insights rapidly during the COVID-19 crisis with key insight into receivables and payables, customer and supplier oversight, and credit scoring.
Technologies: Oracle BI, Oracle Analytics Cloud (OAC), Oracle RDBMS, Oracle Data Integrator (ODI), D3.js, Data Analytics, JavaScript, Jira, Key Performance Indicators (KPIs), SQL, Microsoft SQL Server, Oracle SQL Developer, MySQL, PostgreSQL, Data Science, Oracle Application Express (APEX), Oracle Database, Financial Data Analytics, Oracle Hyperion Planning, Data Visualization, OLAP, Database Design, Star Schema, Oracle REST Data Services (ORDS), Oracle, Data Architecture, Oracle BI EE 11g, Microsoft Data Transformation Services (now SSIS), Analytics, Data Integration, Data Engineering, Large Data Sets, Business Requirements, Data Loading, Data Analysis, NoSQL, Hadoop, Oracle WebLogic Application Server, WebLogic, DAX, SQL Server Analysis Services (SSAS), Architecture, Reporting, Dashboards, Batch Apex, Oracle PL/SQL, Apex, Data Modeling, SSAS, SQL Server Reporting Services (SSRS), Interactive Dashboards, Reports, Microsoft Excel, Data-level Security, APIs, BI Reporting, Databases, Data Transformation, Data Cleansing, Data Queries, Transact-SQL (T-SQL), SAP, PL/SQL, Warehouses, Data Pipelines, JSON, Business Intelligence (BI) Platforms, Marketing Reports, Marketing Analytics, Real-time Data, ODBC, Master Data Management (MDM), Data Governance
Project Manager, Business Intelligence
2012 - 2016
NIS Gazprom Neft
- Led and implemented the company's project portfolio for implementing a BI solution integrating tens of data sources, 30+ subject areas, and thousands of dashboards.
- Delivered business requirements with each business stream owner before implementing it in concert with other streams, working with five business consulting companies and coordinating over 50 consultants.
- Coordinated and led three IT service providers for the technical implementation of each subject area stream with 50+ technical consultants at the peak of implementation.
- Found the best solution for ETL and CDC from the company's SAP ERP, testing and validating 21 different approaches ensuring the best speed, accuracy, and impact.
- Enrolled 400+ business users in BI practices, covering education and improving the corporate culture for consuming data and analytics, evolving to self-service analytics across subject areas.
Technologies: Oracle BI, Oracle RDBMS, Oracle Data Integrator (ODI), Jira, D3.js, SQL, Microsoft SQL Server, Oracle SQL Developer, Data Science, Oracle Application Express (APEX), Oracle Database, Financial Data Analytics, Data Analytics, Data Visualization, OLAP, Database Design, Star Schema, OLTP, Oracle REST Data Services (ORDS), JavaScript, Oracle, Data Architecture, Oracle BI EE 11g, Analytics, Tableau, MySQL Workbench, Data Integration, Data Engineering, Business Requirements, Data Loading, Data Analysis, Oracle WebLogic Application Server, WebLogic, Architecture, Reporting, Dashboards, Batch Apex, Oracle PL/SQL, Apex, Data Modeling, Interactive Dashboards, Reports, Microsoft Excel, Data-level Security, APIs, BI Reporting, Databases, Data Transformation, Data Cleansing, Data Queries, Transact-SQL (T-SQL), SAP, PL/SQL, Warehouses, Data Pipelines, JSON, Business Intelligence (BI) Platforms, Marketing Reports, Marketing Analytics, ODBC, Master Data Management (MDM), Data Governance
Project Manager, Document Management
2010 - 2012
NIS Gazprom Neft
- Created and implemented an IT strategy for ECM and DM,.
- Implemented a DM project for the company's thousands of users and hundreds of document flows and approval processes.
- Established the company's document archive, initiating and managing large-scale scanning, OCR, and cataloging of 43 kilometers of archival documents from the 1960s till today.
Technologies: Document Management Systems (DMS), SharePoint, Microsoft SQL Server, SQL, Data Visualization, Oracle REST Data Services (ORDS), Analytics, Data Integration, Data Engineering, Business Requirements, Data Loading, Data Analysis, Oracle WebLogic Application Server, WebLogic, Architecture, Reporting, Dashboards, Interactive Dashboards, Reports, Microsoft Excel, Data-level Security, APIs, Databases, Data Transformation, Data Cleansing, Data Queries, PL/SQL, JSON, Data Governance
CRM/BI Consultant
2008 - 2010
Comtrade
- Implemented Siebel CRM solution in Telenor MNE, including sales, service, and marketing modules.
- Implemented custom Siebel CRM integrations with telco back-end systems such as prepaid and postpaid billing systems and HLR service.
- Implemented a document archiving solution and integration of Siebel CRM and Microsoft SharePoint for all generated customer documentation.
Technologies: Siebel, Siebel CRM, Siebel EAI, Siebel EIM, Siebel Administration, Oracle BI, Oracle RDBMS, REST, Microsoft SQL Server, SharePoint, D3.js, SQL, Oracle SQL Developer, CRM Design, Document Management Systems (DMS), Data Visualization, Oracle REST Data Services (ORDS), Microsoft Data Transformation Services (now SSIS), Analytics, Data Integration, Data Engineering, Business Requirements, Data Loading, Data Analysis, Oracle WebLogic Application Server, WebLogic, Analysis, SQL Server Integration Services (SSIS), Back-end Development, Architecture, Reporting, Dashboards, Data Modeling, SSAS, Reports, Microsoft Excel, APIs, Databases, Data Transformation, Data Cleansing, Data Queries, Transact-SQL (T-SQL), PL/SQL, Warehouses, Data Pipelines, JSON, Business Intelligence (BI) Platforms, Marketing Reports, Marketing Analytics, ODBC, Data Governance
Consultant
2006 - 2008
S&T Serbia d.o.o
- Implemented the Infor Epiphany CRM system in Banca Intesa Beograd. The solution introduced customer 360 data, Salesforce automation, service and call center integration, inbound and outbound marketing, campaigns, and analytics.
- Developed a highly optimized ETL process, integrating local and customized core banking suite, government, and national bank IT services.
- Provided customer support on-site, driving solution adoption and providing agile changes, ensuring value for customers, educating customer staff, and transparent system operation for management and regulatory audits.
Technologies: Document Management, Document Management Systems (DMS), Customer Relationship Management (CRM), Business Intelligence (BI), SharePoint, Microsoft SQL Server, Oracle RDBMS, Analytics, Data Integration, Business Requirements, Data Loading, Data Analysis, Oracle WebLogic Application Server, WebLogic, Analysis, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Back-end Development, SQL Server Reporting Services (SSRS), Reports, Microsoft Excel, APIs, Databases, Data Transformation, Data Cleansing, Data Queries, Transact-SQL (T-SQL), PL/SQL, Infor, Business Intelligence (BI) Platforms, Marketing Reports, Marketing Analytics, ODBC, Data Governance
IT Analyst
2005 - 2006
S&T Russia
- Developed framework and methodology for Rosbank's intranet portal, connecting hundreds of cities in a single network using IBM WebSphere line of tools.
- Implemented Oracle BI reporting subject areas in one of the leading Russian banking companies.
- Implemented IBM MicroStrategy BI solution in a Russian manufacturing company.
Technologies: Document Management Systems (DMS), Customer Relationship Management (CRM), Business Intelligence (BI), Business Requirements, Data Loading, Data Analysis, Analysis, SQL Server Analysis Services (SSAS), Microsoft Excel, APIs, Databases, Data Transformation, Data Cleansing, Data Queries, Transact-SQL (T-SQL), Marketing Reports
Researcher | Developer
2003 - 2005
Samsung Advanced Institute of Technologies and Moscow State University Joint Lab
- Developed part of MPEG standard regarding computer vision, 3D reconstruction data, and point-cloud visualization.
- Developed methods and models for 3D reconstruction and coloring data.
- Developed processes and apps for 3D data storage, retrieval, classification, and object tracking.
Technologies: C++, SQL, Applied Mathematics, Computer Vision, Computer Science, MPEG, Business Intelligence (BI), Data Science, Data Loading, Analysis, Databases, Data Queries
Experience
Oracle BI Implementation
Acted as a project manager and tech lead for a BI implementation project using Oracle BI, Oracle RDBMS as a data warehouse, and Oracle Data Integrator for ETL with 10+ data sources, 30+ subject areas, and 1,000+ dashboards. The BI system encompassed all business areas and launched with 400+ users.
BI Solution for Car Rental and Franchise Company
I automated ETL, data consolidation, and data enrichment and integration with car renting services. I built complex PowerBI dashboards, forecasts, and analytics for a car rental franchise, including time series analysis, fleet utilization, revenue management, and forecasting.
NIS KPI Reporting
Implemented the company's KPI reporting subject area, encompassing 6,000+ KPIs for the top management board meetings and cascading drill-down.
The project consisted of a detailed KPI methodology, scoring and aggregating processes, a custom KPI visualization plugin for Oracle Analytics (D3.js and OAS framework), a set of dashboards and custom interactions, and a data management application.
The project consisted of a detailed KPI methodology, scoring and aggregating processes, a custom KPI visualization plugin for Oracle Analytics (D3.js and OAS framework), a set of dashboards and custom interactions, and a data management application.
Account Receivable and Payable Subject Area Reporting
AR/AP subject area for company's reporting, integrating SAP ERP account data, sales and volumes, external data, indicators, and scoring. Dashboards include a single place for all company's data about customers, a 360-degree view of all interactions and history, benchmarking, and a credit board dashboard. Alongside data and dashboards, a data entry and control app was also developed as well as several custom plugins for dashboard visualization.
Material Balance Subject Area Reporting
Created a set of material balance dashboards and ETL procedures, integrating data from Hyperion Planning and custom data control procedures and apps.
Dashboards show all movements of material and processes in the company, starting from oil and gas extraction, raw oil, procurement, refining, production of distillates, and sales by channel, country, and products, as well as stock movements and levels.
Dashboards show all movements of material and processes in the company, starting from oil and gas extraction, raw oil, procurement, refining, production of distillates, and sales by channel, country, and products, as well as stock movements and levels.
SLA Reporting
Implemented a subject area for service level agreement reporting, KPIs of business departments per client, and balanced scorecards per client's agreements. The data model and management app support rebalancing KPIs per provided services and contracted and uncontracted services on six levels of aggregations as well as several grouping paths. The app implements everything needed for reporting, from 200+ data quality checks to defining multiple hierarchies of KPIs per BU and client.
Refinery Maintenance Subject Area
Implemented a subject area for reporting on refinery maintenance, integrating data from IBM Maximo, custom data hierarchies and external benchmarking data, KPIs of 100,000+ assets (MTBM, MTBR), and millions of service requests with extremely complicated maintenance workflows.
Timesheet Management App and BI Subject Area
Led the implementation of a timesheet management app and developed BI subject area for it, integrating timesheet data, financials, and other benchmarking data into a singular set of dashboards for managing the newly formed shared services BU.
Service Desk and Reporting
Implemented a service desk for a newly formed shared services center and a service desk subject area and dashboards for reporting. This included details about service requests for all business areas, including IT, finance, legal, and HR, as well as mechanism and reporting on satisfaction and benchmarking.
Siebel CRM Implementation
Conducted CRM implementation for Telenor MNE, including sales, services, and marketing areas, integration with prepaid, postpaid billing systems (REST and bulk database integrations), HLR service system, and SharePoint portal for document management, and business process design and post-live support.
Education
2000 - 2005
Master's Degree in Informatics and Applied Mathematics
Lomonosov Moscow State University - Moscow, Russia
Skills
Libraries/APIs
D3.js, REST APIs, Power BI REST APIs, ODBC
Tools
Microsoft Power BI, Oracle Application Express (APEX), Tableau, Apache Tomcat, Batch Apex, Microsoft Excel, Redash, Siebel CRM, Jira, MySQL Workbench, Apache, SSAS, Synapse, IBM Maximo, Smartsheet, Microsoft Power Apps, Power Query
Languages
SQL, Apex, Transact-SQL (T-SQL), Power Query M, JavaScript, Python, C++
Paradigms
OLAP, Database Design, Business Intelligence (BI), ETL, REST
Platforms
Oracle Database, Oracle BI EE 11g, Oracle, Azure Synapse Analytics, SharePoint, Oracle Data Integrator (ODI), Oracle Analytics Cloud (OAC), Microsoft Power Automate, Azure, Azure Synapse
Storage
Microsoft SQL Server, Oracle SQL Developer, OLTP, Data Integration, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Oracle PL/SQL, SQL Server Reporting Services (SSRS), Databases, PL/SQL, Data Pipelines, JSON, Master Data Management (MDM), Oracle RDBMS, MySQL, PostgreSQL, Siebel EIM, Essbase, Data Lakes, NoSQL, Azure SQL, HBase
Frameworks
Hadoop
Other
Oracle BI, Applied Mathematics, Computer Science, Computer Vision, Data Science, Key Performance Indicators (KPIs), CRM Design, Financial Data Analytics, Data Analytics, Data Visualization, Star Schema, Oracle REST Data Services (ORDS), Data Warehousing, IT Project Management, Data Architecture, Analytics, Data Engineering, Business Requirements, Data Loading, Data Analysis, Oracle WebLogic Application Server, WebLogic, DAX, Analysis, Reporting, Dashboards, Data Modeling, Interactive Dashboards, Reports, Data-level Security, APIs, BI Reporting, Dashboard Development, Data Transformation, Data Cleansing, Data Queries, Warehouses, Business Intelligence (BI) Platforms, Marketing Reports, Marketing Analytics, Real-time Data, Data Governance, Siebel EAI, Siebel Administration, Siebel, Microsoft Data Transformation Services (now SSIS), Document Management Systems (DMS), Oracle Hyperion Planning, Document Management, Customer Relationship Management (CRM), Large Data Sets, Back-end Development, Architecture, Apache Superset, Metabase, Oracle Primavera, MPEG, SAP, Infor, Primavera P6 Professional Project Management
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring