toptal.com
Contact us: +1.888.867.7001
Andrew Koltyakov, SharePoint Developer in Saint Petersburg, Russia
Andrew Koltyakov

SharePoint Developer in Saint Petersburg, Russia

Member since January 12, 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.
Andrew is now available for hire
Hire Andrew

Portfolio

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

Experience

Location

Saint Petersburg, Russia

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.

Employment

  • 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, 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, Wonderware ArchestrA

  • 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, C#, 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, 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

  • 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

Skills

  • Languages

    JavaScript, C#, T-SQL, SQL, VB, Caml, ECMAScript (ES6)

  • Libraries/APIs

    jQuery

  • Tools

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

  • Platforms

    SharePoint 2013, SharePoint 2010, SharePoint, Wonderware ArchestrA, BIRT, Windows, Oracle

  • Frameworks

    Knockout.js, ASP, 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, 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

Education

  • Engineering Degree in Computer-aided Design and Engineering
    2000 - 2006
    Saint-Petersburg State University Information Technologies, Mechanic and Optics - Saint Petersburg

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM