Andrew Koltyakov, Developer in Saint Petersburg, Russia
Andrew is available for hire
Hire Andrew

Andrew Koltyakov

Verified Expert  in Engineering

SharePoint Developer

Location
Saint Petersburg, Russia
Toptal Member Since
February 19, 2015

Since 2005, Andrew has gained extensive experience in enterprise information systems implementation, software development, and project management. His field of experience includes enterprise content management, business intelligence, and business process automation. Most recently, he has focused on projects involving SharePoint and the Microsoft technology stack.

Portfolio

CIB Point
Caml, REST, CSOM, JavaScript Object Model (JSOM)...
Cross Decisions
Windows Communication Framework (WCF), T-SQL (Transact-SQL), REST...
Skb Kontur JSC
Software as a Service (SaaS), HIPAA Electronic Data Interchange (EDI)

Experience

Availability

Part-time

Preferred Environment

Sublime Text, SharePoint, Visual Studio, Windows

The most amazing...

...thing that I can do is unique custom projects with SharePoint for automating customer business processes and facilitating competitive advantages.

Work Experience

SharePoint Developer and Consultant, CEO & Co-Founder

2012 - PRESENT
CIB Point
  • Led the company’s organization management center (maintaining company processes, contracts and risk management, financial planning, etc.).
  • Collaborated on sales and partnership processes and activities.
  • Ran the projects management office.
  • Conducted analysis on customer needs accumulation.
  • Created custom SharePoint development tasks (rather as other team members).
  • Architected and planned solutions for SharePoint projects.
  • Consulted and communicated with customers.
Technologies: Caml, REST, CSOM, JavaScript Object Model (JSOM), Server-side Object Model (SSOM), Windows Communication Framework (WCF), WWF, JavaScript, C#, SharePoint

ECM Consultant, Co-Founder

2008 - 2014
Cross Decisions
  • Automated the platform for selection consulting.
  • Optimized business processes.
  • Managed pre-sales and partnership relation processes.
  • Consulted on development issues.
  • Implemented audits.
  • Trained and coached ECM.
Technologies: Windows Communication Framework (WCF), T-SQL (Transact-SQL), REST, Server-side Object Model (SSOM), CSOM, JavaScript Object Model (JSOM), JavaScript, C#, SharePoint

Project Manager

2012 - 2012
Skb Kontur JSC
  • Managed SaaS EDI projects.
  • Conducted public activities and workshops events.
Technologies: Software as a Service (SaaS), HIPAA Electronic Data Interchange (EDI)

Project manager and Head of division

2010 - 2012
SoftInStyle, LLC
  • Managed ECM/DMS solutions implementation projects.
  • Managed scaling and integration of multiple ECM instances (SOA/ESB) of an analysis and architecture project.
  • Managed government implementation projects.
  • Communicated with government customers and managed professional relationships.
  • Planned projects, including budgeting and approval of tasks and activities.
  • Oversaw government auction project activities.
  • Supported contract management activities.
Technologies: Alfresco, ECM, Enterprise Service Bus (ESB), BIRT, SQL, DQL

Senior Software Engineer and Consultant and Team Lead

2008 - 2010
MES Engineering Limited
  • Managed projects for MES Factelligence/Wonderware solutions development and implementation.
  • Created a solution for product owners for a food processing industry MES solution.
  • Conducted pre-sale activities and solution choice consulting.
  • Communicated on technical issues with the platform vendor (Wonderware, USA).
  • Implemented and maintained a project management and interactions portal (SharePoint Services).
Technologies: C#, PL/SQL, T-SQL (Transact-SQL), Wonderware ArchestrA, AVEVA (formerly Wonderware)

Senior Software Implementation Engineer and Consultant

2006 - 2008
Status Technology (ST), LLC
  • Developed and implemented ECM software solutions.
  • Developed lists, forms, business logic, workflows, and reports for DMS, CRM, and contract management.
  • Developed portal (SharePoint Services) integration mechanisms.
  • Conducted support and maintenance activities.
  • Built software solutions and planned service pre-sale activities.
  • Trained and consulted for customers' employees.
Technologies: Web Services, Contract Management, CRM Systems, Document Management Systems (DMS), T-SQL (Transact-SQL), C#, SQL Server Reporting Services (SSRS), SharePoint Service Applications

Software Developer and Engineer

2005 - 2006
Arsenal Machine-Building Plant Open JSC
  • Maintained PDM-system SmarTeam (ENOVIA) and developed audit tools.
  • Developed integration mechanisms for PDM and CAD SolidWorks.
  • Implemented ERP Galaxy modules (pilot stages) (modules: PP, PM, HR).
Technologies: T-SQL (Transact-SQL), Active Server Pages (ASP), C#

Software Developer and Engineer

2004 - 2005
Techpribor
  • Conducted CAD/CAM/CAE system administration and maintenance.
  • Developed and maintained CAD/CAM/CAE with PDM PartY Plus (Lotsia Soft).
  • Developed third-party components for data-driven integration of internal enterprise systems.
Technologies: SQL, VB, C#

Summary of Projects

• 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

Budgeting in SharePoint

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

SharePoint Lists Quick ETL

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

SharePoint User Actions Advanced Audit

• 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

Online Examination System in SharePoint

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)

Rival Analysis System in SharePoint

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

Languages

JavaScript, C#, T-SQL (Transact-SQL), SQL, VB, Active Server Pages (ASP), Caml, ECMAScript (ES6)

Libraries/APIs

jQuery

Tools

SOLIDWORKS, Microsoft Visual Studio, Alfresco, Visual Studio, Sublime Text

Platforms

SharePoint 2013, SharePoint 2010, SharePoint, Wonderware ArchestrA, BIRT, Windows, Oracle, AVEVA (formerly Wonderware)

Frameworks

Knockout (Knockout.js), WWF, ASP.NET Web API, ASP.NET MVC 5, Windows Communication Framework (WCF), Windows Workflow Foundation

Paradigms

ETL, REST, JavaScript Object Model (JSOM), Server-side Object Model (SSOM), Agile Software Development, Business Intelligence (BI), Scrum, Kanban

Storage

Microsoft SQL Server, SQL Server Reporting Services (SSRS), PL/SQL, MySQL, MongoDB

Other

SharePoint Online, SharePoint Service Applications, Document Management Systems (DMS), CRM Systems, Contract Management, DQL, Enterprise Service Bus (ESB), ECM, HIPAA Electronic Data Interchange (EDI), Software as a Service (SaaS), CSOM, Customer Relationship Management (CRM), Web Services, Architecture

2000 - 2006

Engineering Degree in Computer-aided Design and Engineering

Saint-Petersburg State University Information Technologies, Mechanic and Optics - Saint Petersburg

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