Andrew is available for hire
Hire AndrewAndrew 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 Foundation (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 Foundation (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 Foundation (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#
Experience
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
• 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
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
• 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
• 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)
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
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
Skills
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 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, Windows Communication Foundation (WCF)
Education
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