Andrew Koltyakov

• SharePoint projects (business process automation, document management, portal solutions, data integration (ETL), and reporting centres)
• Over 20 projects of ECM DIRECTUM (www.directum.com) implementation (analyses, development, consulting roles)
• Data and business logic distributed integration projects
• Business applications integration (ECM/CRM/ERP/Portal) projects
• Manufacturing Execution System implementation projects (Metallurgy, Meat Processing)
• Documentum and Alfresco implementation projects in government

Company's budget planning and accounting based on SharePoint Foundation 2010 platform, ETL and SSRS.

Main features:
• Planning multiple analytics structured budgets
• Role based approving and events
• Payment approval and finance blocking
• Plan-fact analyses and reporting
• Accounting systems integration

System user roles:
• Finance managers
• Approval initiators and supervisors
• Budget state owners
• Ratifying managers
• Accountants

Technological solution for rapid extraction, transformation and loading data of any sized SharePoint lists.

• Over-throttling experience, multi-threading, and custom batches
• Works with SharePoint Online, SharePoint Foundation, and Server
• Extracting lookups and multiple lookups information
• No need for administrator permissions

• Advanced user actions audit for any kind of actions and custom events
• Preparing statistics information for analysis - SQL Server tables structure
• Reports for audit, cross browser web-part for SSRS stand-alone reports
• Custom rules for conditional event triggering
• SharePoint Foundation supported

An online examination system for SharePoint that can be used across different organization types (educational, business, etc.).

The system allows administrators, examiners, and question setters to add/edit/delete questions and schedule tests, exams and generate results.

Main features:
• Creating examination (test's) models (test types, groups, questions sets)
• Rich questions editor (different answers types, full HTML support)
• Questions randomizer and rules matrix
• Security layers (questions answers never get direct access to questions and answers lists)
• SPA UI client with questions map and state saving
• Results reports and possibility for different reports building

System's users roles:

• Administrators
• Examiners
• Question setters
• Question answerers (employees, students, applicants)

A rivals analysis system for a large cinema network, which accumulates price policy data from most rivals’ cinemas and builds analysis reports for the cinema and its territorial rivers in a matrix.

Main features:
• Collects cinema ticket prices from different online data sources
• Collects information from cities level with deep dive to specific movies
• Data store layer and SharePoint services (actual data includes over a million of records to be analysed)
• Matrix report system and rules for identifying exceptions
• Settings layer in SharePoint

System user roles:
• Administrators
• Functional moderators
• Marketing managers in cinemas