Andrew Koltyakov

Andrew Koltyakov

Saint Petersburg, Russia
Hire Andrew
Scroll To View More
Andrew Koltyakov

Andrew Koltyakov

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
  • JavaScript, 5 years
  • jQuery, 3 years
  • SharePoint, 4 years
  • SharePoint 2010, 4 years
  • SharePoint 2013, 2 years
  • SQL, 8 years
  • C#, 6 years
  • Business Intelligence, 3 years
Saint Petersburg, Russia
Preferred Environment
Windows, Visual Studio, SharePoint, Sublime Text
The most amazing...
...thing that I can do is unique custom projects with SharePoint for automating customer business processes and facilitating competitive advantages.
  • SharePoint Developer and Consultant, CEO & Co-Founder
    CIB Point
    2012 - PRESENT
    • 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: SharePoint, C#, JavaScript, WWF, WCF, SSOM, JSOM, CSOM, REST, CAML
  • ECM Consultant, Co-Founder
    Cross Decisions
    2008 - 2014
    • 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: SharePoint, C#, JavaScript, JSOM, CSOM, SSOM, REST, T-SQL, WCF
  • Project Manager
    Skb Kontur JSC
    2012 - 2012
    • Managed SaaS EDI projects.
    • Conducted public activities and workshops events.
    Technologies: EDI, Diadoc
  • Project manager and Head of division
    SoftInStyle, LLC
    2010 - 2012
    • 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: DQL, SQL, BIRT, Documentum, ESB, ECM, Documentum, Alfresco
  • Senior Software Engineer and Consultant and Team Lead
    MES Engineering Limited
    2008 - 2010
    • 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: MES, Factelligence, T-SQL, PL/SQL, C#
  • Senior Software Implementation Engineer and Consultant
    Status Technology (ST), LLC
    2006 - 2008
    • 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: DIRECTUM, SSRS, C#, T-SQL, ISBL, Web Services
  • Software Developer and Engineer
    Arsenal Machine-Building Plant Open JSC
    2005 - 2006
    • 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: C#, ASP, T-SQL
  • Software Developer and Engineer
    2004 - 2005
    • 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: C#, VB, SQL
  • Summary of Projects (Development)

    • SharePoint projects (business process automation, document management, portal solutions, data integration (ETL), and reporting centres)
    • Over 20 projects of ECM DIRECTUM ( 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 (Development)

    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 (Development)

    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 (Development)

    • 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 (Development)

    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 (Development)

    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

  • Starter MasterPage for SharePoint 2010 (Design)

    SharePoint masterpage with Bootstrap integrated.

  • Starter MarterPage for SharePoint 2013/Online (Design)

    SharePoint masterpage with Bootstrap integrated.

  • Languages
    JavaScript, SQL, T-SQL, C#, ECMAScript
  • Libraries/APIs
    jQuery, Web API
  • Platforms
    SharePoint 2013, SharePoint 2010, SharePoint
  • Frameworks
    Knockout.js, WCF, Windows Workflow Foundation, MVC 5
  • Tools
    SSRS, Visual Studio, ETL
  • Paradigms
    REST, Agile Software Development, Scrum, Kanban
  • Storage
    SQL Server, Oracle, MySQL, MongoDB
  • Misc
    SharePoint Online, CRM, Business Intelligence, Architecture, Web Services
  • Engineering degree in Computer-aided Design and Engineering
    Saint-Petersburg State University Information Technologies, Mechanic and Optics - Saint Petersburg
    2000 - 2006
I really like this profile
Share it with others