Dmitri Vybornov

Took part in a number of projects for higher education institutions, including

- Data Warehouse development, enhancements and support at University of Western Cape

- Data Warehouse development, enhancements and support at University of Pretoria

- Learner Analytics Warehouse development, enhancements and support

- A variety of comprehensive MIS/Reporting solutions at SA higher education institutions

Duties and responsibilities:

• Extensive data and business requirements analysis

• Data warehouse design, development and support

• Management information systems design, development and support

• Taking part in product development

Consulted on a number of projects, including

- management information system audit at Competition Commission and FirstRand,

- DWH maintenance and development at Investec and Verpakt,

- front end and back end development using QlikView at Standard Bank,

- delivery of HR information system at Inegr8,

- data warehousing and reporting at Verpakt,

- new DWH design and development at Adcorp,

- SAP to Microsoft data migration at Deloitte

- reporting enhancements and information system maintenance at OPSI Systems,

- data analysis and modelling, data mapping, ETL and reports development at FNB

Duties and responsibilities:

• Systems analysis and audit

• Business analysis

• Information systems audit

• Systems maintenance and support (MSSQL Server 2008-2016)

• ETL design and development (T-SQL, PL/SQL, SSIS, QlikView)

• Report and dashboard development (SSRS, QlikView, Power BI, ASP.NET)

• OLAP design and development (SSAS)

• Was responsible for all BA work on a data / reporting project for Massdiscounters (Game / Dion Wired)

• The work involved analysis of current reports and reporting requirements, gathering information on available data sources, identifying missing data to be ETLed into Data Warehouse

• Gathered and analyzed reporting requirements for the business

• Analyzed current and To-Be data sources

• Drew up business requirements documentation

• Liaised with reporting and DWH teams to ensure the optimal solution

• Liaised with project managers to ensure timely delivery

Reason for Leaving : Preferred a more senior all-round BI role

• Worked on clarification of business requirements, defining reporting outlines and building a data warehouse for SBV Services

• Helped formalize business requirements for the warehouse

• Analyzed production data using OLAP

• Re-designed the Data Warehouse structure

• Designed and developed ETL packages to populate DWH

• Liaised with project managers to ensure timely delivery

• Designed and developed reports

Reason for Leaving : End of contract

• Worked on various BI projects, including one at Liberty Life, 3rd biggest long term insurance company in South Africa

• The work involved analysis of various sources of data to consolidate the information into the Generic Business Model

• Substantial part of the analysis was done on investment data

• It involved Business Analysis, data modeling, ETL design and development, defining reporting outlines

• Gathered and analyzed end user reporting requirements, design sample reports

• Provided As-Is and To-Be Analysis of the systems

• Data modeling, System Architecture and Design

• Analyzed and classified source data from legacy ( asset and liability) systems

• Participated in enhancement of data models

• Liaised with project managers to ensure timely delivery

• Designed and developed ETL packages to populate Generic Business Model

Reason for Leaving : Next opportunity was a good match for my skills and experience

• Was contracted for over 2 years to Green Model Business Unit of First National Bank, second leading banking institution in South Africa

• Green Model was the largest data warehouse within FNB

• He was responsible for design, development and maintenance of MSSQL OLAP and relational environments. He worked closely with the business to make sure that information delivery met all the end user requirements

• The cubes he developed were used on a daily basis by the senior management and EXCO of FNB

• He was also involved in a program to enhance bank’s management and financial reporting via a SharePoint based portal

• Ran Microsoft-based BI environment (designed, development and maintenance)

• MSSQL Server OLAP and reporting technical lead

• Took part in BI strategy development

• Took part in architectural decision making

• Analyzed business requirements

• Worked with the business to enhance reporting

• Liaised with project managers to ensure timely delivery

• Was involved in data quality analysis

• Took part in design and implementation of data integrity processes between MSSQL and Sybase IQ platforms

• Trained and guided junior developers

Reason for Leaving : End of contract 

• An important role in implementation of Business Bank MIS at ABSA, South Africa.

• International experience through working on a range of projects with companies abroad (USA, UK, Yugoslavia)

• One of the key developers of Naxian OLAP and reporting toolset successfully used in South Africa and abroad. Naxian was one of the main BI systems used in ABSA bank, South Africa

• Management information systems architecture and design

• Management information systems development

• Management information systems maintenance and support

• Data Mart design, development and maintenance (SQL Server 2000 and 2005, Oracle 8i and 9i)

• SQL Server and Oracle database performance tuning

• ETL design and development (DTS, SQL Server Integration Services, SAS)

• Data integrity validation

• Multidimensional database design, development and maintenance (Analysis Services 2000 and 2005)

• Analysis of business requirements and reports design

• Report development (Reporting Services 2000 and 2005)

• Front end application development (ASP.NET, C#, VB.NET, Delphi)

• User training and support

Reason for Leaving : New position was more sound financially and provided new challenges

• Business requirements analysis

• Information systems design, maintenance and support

• Database development and administration (SQL Server 6.5, 7)

• Maintenance of IT infrastructure

Reason for Leaving : A challenging role with DWH experts

• Stock Market analysis

• Back office data mart maintenance and updates

• Participation in Information Systems design

Reason for Leaving : Moving overseas

• Software development to support economic modeling

• Database design and maintenance

• Management reporting

Reason for Leaving : A permanent position with one of the leading  Russian banks