Numerous companies and businesses related to databases and analytics – Russia
1999 – 2018
After the scientific center school, I showed outstanding results in physics and mathematics and was promoted by the radio-technical faculty dean to a scientific company, where my database journey began and later naturally transitioned to analytics and AI. Some details are available on my site: http://sergeyavdovin.com/ContentPage/Resume
Details of the 1999–2018 projects (from the earlier version of this page)
Independent Consultant
Duration 06.2015 - Current (9 months)
Position Microsoft Business Intelligence/ Project Server/ SharePoint consultant
Summary and Achievements As a revision of previous professional activities several Microsoft Business Intelligence and Project Server articles were accomplished including TechNet Guru award winning: Project Server: Refresh calculated fields for all projects via PowerShell PSI calls Windows PowerShell Technical Guru January 2016 Gold SSAS, SSIS: Extending Project Server OLAP Cubes via push-mode processing SSAS: Slicing and dicing over data differences between SSAS databases via C# UDF and shell dimension SQL BI and Power BI Technical Guru October 2015 Gold SSRS: Merge data from different data sources into one data set inside SSRS report using XML Connection SSRS: Merge data from different data sources into one dataset inside SSRS report SSRS: End-user defined parameters set and cascading hierarchy SQL BI and Power BI Technical Guru June 2015 Bronze SSRS: Deduplicating unrelated details data SSRS: Join data from different SSRS data sources into data set Special recognition from the TechNet community resulted in TechNet Wiki Interview: Interview with a SQL Server Business Intelligence Expert and Wiki Ninja The interview reflects my history, ideas and plans. During this period some small projects were accomplished as well:
Project 1 ”Project Center” IIS site migration SharePoint/ ProjectServer 2010 to SharePoint/ ProjectServer 2013
Duration 1 months
Role all in one: from negotiations to implementation
Description from customer: "external customer has a site from another System Integrator, would be good to recompile it from 2010 platform to 2013 platform".
Results: - Several development/testing cycles completed - all the functional migrated and Visual Studio 2015 solution with deployment guide is delivered to customer. - Unsupported and undocumented by vendor (Microsoft) calls to Published Project Server database (for authorization purposes) replaced by CSOM OData Project Server calls. - SSRS native calls migrated to SSRS SharePoint 2013 integrated calls. - Legacy application architecture yielded in restriction on Project Server Custom Fields values (current immediate resolution of malfunction) - explained to customer. Solution with SSRS reports modifications proposed (using UIDs instead of text values for SSRS parameters keys). - Project Server 2013 Development Environment deployed from scratch in Amazon AWS: -- EC2 -- Directory Service (Simple AD) -- Windows Server 2012 AMI -- SharePoint 2013 -- SQL Server 2014 -- Project Server 2013 -- AutoSPInstaller
Results were delivered in 2 stages, analysis and full communication and delivery cycle was proved during first stage (with a lack of information and high communication and technical risks). During first stage the following was discovered about the site: A custom ASP. NET Internet Information Services (IIS) Site "Project Center" uses information from RDB (Project Server Reporting Database), Published DB (Unsupported and undocumented by vendor - Microsoft), aggregates information to display it to users and contains links to projects workspaces, Project Detail Pages(PDP). SSRS URL access with JavaScript used to render reports in EXCEL and PDF formats. At the second stage the proved communication scheme used to deliver the final result with recommendations for further development
Project 2 Project Online reporting consultations
Duration 1 months Teaching OData PowerPivot Excel Project reporting tables structure Reporting troubleshooting (restriction on custom field names for OData reporting)
incoma.ru (System Integrator)
Duration 12.2008 – 03.2015 (6 years 5 months)
Position Analyst, Head of Business Intelligence Line
Summary and Achievements The first task was to integrate internal Navision and Project Server systems – several previous attempts were unsuccessful – Project Server 2007 server side integration requires strong analytical capabilities and very accurate execution as MSDN product documentation states :” …Developers working with the Project Server Interface (PSI) can be confused by this behavior” . As a result, the integration allowed to get accountant data in Project Server self-service business intelligence OLAP (Online Analytical Processing) cubes. After that in the position of Head of Business Intelligence line I participated in various internal and external projects with solutions parts based on Microsoft Project Server platform and Microsoft Business Intelligence Stack. The work included actions from solutions proposals started from phrases “can you offer anything to manage it?” and planning to ALM (Application Lifecycle Management) processes development and implementation and complex troubleshooting and support for even greater area over Microsoft platforms where colleagues could not find causes of the problems and solutions. Work on ALM processes improvements yielded in some efficient techniques like complex report documentation: here business and power users, analysts, methodologists describe reports using test source data snapshots and display data flows and calculations graphically what from one hand injects testing algorithms directly into the documentation and from the other hand gives some relief to critical brain side – it altogether dramatically reduces the number of report development cycles and mistakes. First years I provided most of the technical results alone, last 3 years i was teaching and working with a dedicated colleague in the department – as a result lately we were able to transfer information flows which required explicit presence to the colleague and I concentrated then on ALM and more deep technical aspects. Stability of established processes allowed to deliver results partially remotely for 1 year and then fully remotely for 1,5 years (Bali).
Project 1 Call Center
Duration 6 months
Client Bank of Russia
Role Business Intelligence Subsystem architect
Technologies DWH (Data Warehouse) – from scratch, sources: Microsoft CRM (SQL), Microsoft Office Communication Server (SQL) SQL Server Database Engine, SSRS, SSAS - OLAP, live monitoring Dashboard with Windows Forms - .Net
Summary Project included direct work with Call Center department head as well as with other department staff in requirements gathering. Source data extraction was built in collaboration with CRM and OCS colleagues.
Achievements and Results Letter of acknowledgment from client for advanced reporting and analytic capabilities
Project 2 Integration and Business Intelligence System
Duration 6 years 5 months
Client internal
Role Business Intelligence and Integration architect
Technologies DWH – extension of existing (Microsoft Project Server) + separate from scratch, sources: Microsoft CRM (SQL CLR), SharePoint (SSIS SharePoint List Source ), Security System, Exchange (extension of SQL CLR EWS - .Net), Microsoft Navision SQL Server Database Engine, SSIS, SSAS – OLAP (MDX,,Net UDF ), SSRS, SharePoint (+Excel Services - .Net, JScript) ALM – Visual Studio Team Services (Online, promoted and implemented processes: source control, requirements management, work management)
Summary Project included various internal integration and Business Intelligence tasks resolutions.
Achievements and Results Previously timely failed project of internal Navision and Project Server systems was successfully implemented. As a part of self-service business intelligence implementation Excel Services functions of SharePoint were promoted and used in parts of financial control system. Stable ALM processes were established.
Project 3 Business Intelligence and Integration Server concept
Duration 1 year
Client internal
Role Business Intelligence and Integration architect
Technologies SQL Server 2012 – SSIS, SSAS (+MDX), SSRS, SharePoint 2013 ALM – Visual Studio Team Services (source control, requirements management, work management)
Summary Internal promotion of the idea and implementation of [Business Intelligence and Integration Server] concept from scratch (inspired from Business Decision Appliance ) BI and Integration functions were migrated to the server. Concept relies on AutoSPInstaller in Repeatable Implementation.
Achievements and Results Uptime and stability of integration and Business Intelligence processes were dramatically improved.
Project 4 Project and Portfolio Management System
Duration 3 years, sequence of projects
Client IT department of Bank of Russia
Role Business Intelligence and Integration architect, Contracts Management subsystem architect
Technologies DWH – extension of existing (Microsoft Project Server) SSRS, SharePoint 2010 (+Extension of Microsoft JSGrid, JQuery for projects template management), Elements of Contracts Management Subsystem (LightSwitch HTML - .Net, JQuery) ALM – Visual Studio Team Services (source control, requirements management, work management)
Summary Key responsibilities included planning support, controlling, teaching and troubleshooting the work of IT department and colleagues from my department during whole Project and Portfolio Management System implementation cycles. Promoted and established processes: Visual Studio Team Services (Online, Source control, demand management, work management with code reviews), SharePoint ALM – processes with 3 environments and 4th in plans .
Achievements and Results Stability of established ALM processes allowed to work partially remotely for 1 year and then fully remotely for 1,5 years (Bali).
presshouse.ru (Retail)
Duration 11.2007 - 11.2008 (1 year)
Position System Analyst on Analytical Systems Internal Business Intelligence Project
Technologies SQL Server Database Engine, SSAS (MDX), SSRS, Microsoft Office Performance Point Server 2007, cross-selling data mining, ProClarity Professional
Summary Project included implementation of planning and Business Intelligence (SSAS, SSRS) system based on Microsoft Office Performance Point Server 2007 (planning and monitoring modules), MS SQL Server 2005, ProClarity Professional. The team consisted of 2 people – the second one was responsible for the DWH implementation.
Achievements and Results Planning system – in a test cycle, Business Intelligence system: up to implementation of several Shell Dimensions, cross-selling data mining, Monitoring: several dashboards in PPS 2007 were implemented.
merlion.ru (Retail)
Duration 05.2007 - 11.2007 (6 months)
Position Analyst Internal Business Intelligence Project
Technologies SQL Server Database Engine, SSAS (MDX), SSRS
Summary Implementation of business Intelligence system based on Microsoft SQL Server 2005. Performance optimization of MDX reports. Structure optimization of the cubes. ETL processes optimization.
Achievements and Results The system has been implemented successfully and now is in work use. Deep MDX experience was obtained as well as experience of working with complex big SSRS MDX reports.
International Institute for Applied systems Analysis (Scientific institution)
Duration 06.2006 - 08.2006 (3 months)
Position Young Scientists Summer Program Participant Scientific Collaboration Project
Technologies SQL Server Database Engine, SSIS, SSAS (Data Mining)
Summary Research with title: Using Data Mining for Explanation and Prediction of Systems Behavior Abstract in English can be found here: IIASA YSSP 2006 Abstracts, p. 5 (archived copy, web.archive.org) Full Article (in Russian, with partial google translation)
Achievements and Results After successful final presentation corresponding article have been made. The work will be included in the dissertation.
Position MS SQL Server 2000/2005 specialist Internal Business Intelligence and Integration Project
Technologies SQL Server Database Engine, SSIS+DTS, SSAS (+Data Mining), SSRS
Summary The first task was to find causes of prepaid cards state errors – the problem could not be solved for years. If a card has an invalid state it is unusable and clients are calling to support, support then changes the state manually. I was invited as a SQL Server Database Engine Expert as far as the billing system was based on SQL Server. It has occurred that really the error state comes from numerous errors but none of them are on the SQL Server side like: call end IP packet can come to SQL Server before call start IP packet when the call length is near zero – the packets may follow different routes or there was an error in big and complex regular Perl expression which yielded in an incorrect number filtering. After successful competition of the first task I concentrated on the evolution of the billing system and implementation of Business Intelligence systems based on MS SQL 2000/2005. Some of the tasks included integration of the payment and telecommunication systems.
Achievements and Results - in dozens of times the performance of reports was improved - availability of the system was increased to 24x7 (new index defragment feature) - some hard-to-detect errors in system were found and corrected (this was the main task at the beginning of the work) - additional services were implemented - OLAP system elements were implemented (SSAS 2000, SQL Server 2000) - during investigation of the error causes some Data Mining experience was obtained – log tables, connected with the error states are good candidates for case learning tables in order to detect what changes in the system when it comes to an error state
Self-Employed Position Entrepreneur
Duration 03.2005 - 03.2009 (4 years) Project Car incidents registration and drivers support system
Technologies SQL Server Database Engine
Summary Creation from scratch of car incidents registration and drivers support system – from all negotiations to fixed price long term support contract
Achievements and Results - A client-server system was implemented (SQL Server 2000, Delphi 7) - Excel regular reporting via VBA and analysis via excel pivot tables implemented - Support with fixed price contract
Trading firm Tom UPI (Retail)
Duration 04.2004 - 04.2005 (1 year)
Position Analyst, Architect Internal Business Intelligence Project
Technologies SQL Server Database Engine, SSAS
Summary T echnical support, development of OLAP system based on the SQL Server 2000, SSAS 2000, other different BPAs
Achievements and Results - A client-server budget system was implemented (SQL Server 2000, SSAS 2000, Delphi 7) - 2 versions of a client-server system for the trading group salary management were released. As a result, an additional premium was obtained due to the request of the trading group director - The performance of reports in OLAP system was significantly improved
Ural Bank of the Saving Bank of Russia, Headquarter (Banks)
Duration 04.2003 - 01.2004 (8 months)
Position Architect
Internal Project
Technologies SQL Server Database Engine
Summary Creation from scratch of analysis and control system for credits and other banking products
Achievements and Results - high-performance system based on SQL Server 2000 and Delphi 7 was implemented - data mining capabilities of SSAS 2000 were studied and tested
International Festival Spring UPI 2002 (Educational Institution)
Duration 04.2002 - 05.2002 (1 month)
Position Architect
Internal Project
Technologies SQL Server Database Engine
Summary Creation from scratch of client-server system for participant registration and management
Achievements and Results System (SQL Server 2000, Office 2000, Delphi 7) was rated highly by organizers and participants, a corresponding term paper was defended, next festival used the system as the base for further development
Administration of the customer service of the Kirovskii district (Public Institution)
Duration 07.2001 - 02.2002 (5 months)
Position Architect
Internal Project
Technologies SQL Server Database Engine
Summary Creation from scratch of client-server system for housing resources accounting
Achievements and Results Complex solution for the housing resources accounting (SQL Server 2000, Delphi 6, ADO, COM Servers Word, Excel) was implemented
Program Systems Institute (Systems Integration)
Duration 02.2001 - 10.2002 (1 year 8 months)
Position MS SQL 2000, VB6 developer
External Project
Client Urlmashplant
Technologies SQL Server Database Engine
Summary Development of different BPAs with MS SQL Server 2000 and VB6
Achievements and Results as a part of the project following modules were released: -SQL Server references manager (manager of user references in SQL Server tables) -SQL Server file manager (manager of the files stored in tables of SQL Server 2000) -System update module
Scientific production association “Komatek” (Scientific/Production Institution)
Summary After the scientific centre school I showed outstanding results in physics and mathematics and was promoted by our radio-technical faculty dean to the company. Here I tried myself in different fields (designer, programmer, engineer)