- SharePoint Developer and Consultant, CEO & Co-Founder2012 - PRESENTCIB 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: SharePoint, C#, JavaScript, WWF, WCF, SSOM, JSOM, CSOM, REST, CAML - ECM Consultant, Co-Founder2008 - 2014Cross 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: SharePoint, C#, JavaScript, JSOM, CSOM, SSOM, REST, T-SQL, WCF - Project Manager2012 - 2012Skb Kontur JSC
- Managed SaaS EDI projects.
- Conducted public activities and workshops events.
Technologies: EDI, Diadoc - Project manager and Head of division2010 - 2012SoftInStyle, 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: DQL, SQL, BIRT, Documentum, ESB, ECM, Documentum, Alfresco - Senior Software Engineer and Consultant and Team Lead2008 - 2010MES 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: MES, Factelligence, T-SQL, PL/SQL, C# - Senior Software Implementation Engineer and Consultant2006 - 2008Status 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: DIRECTUM, SSRS, C#, T-SQL, ISBL, Web Services - Software Developer and Engineer2005 - 2006Arsenal 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: C#, ASP, T-SQL - Software Developer and Engineer2004 - 2005Techpribor
- 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
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
Portfolio
- CIB PointSharePoint, C#, JavaScript, WWF, WCF, SSOM, JSOM, CSOM, REST, CAML
- Cross DecisionsSharePoint, C#, JavaScript, JSOM, CSOM, SSOM, REST, T-SQL, WCF
- Skb Kontur JSCEDI, Diadoc
Experience
- SQL, 8 years
- C#, 6 years
- JavaScript, 5 years
- SharePoint, 4 years
- SharePoint 2010, 4 years
- jQuery, 3 years
- Business Intelligence (BI), 3 years
- SharePoint 2013, 2 years
Availability
Part-time
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.
Employment
Experience
- 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 (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 (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
Skills
- LanguagesJavaScript, SQL, T-SQL, C#, ECMAScript (ES6)
- Libraries/APIsjQuery
- PlatformsSharePoint 2010, SharePoint 2013, SharePoint, Oracle
- FrameworksKnockout.js, ASP.NET MVC 5, Windows Communication Framework (WCF), ASP.NET Web API, Windows Workflow Foundation
- ToolsVisual Studio, SSRS
- ParadigmsREST, ETL, Agile Software Development, Kanban, Scrum
- StorageMicrosoft SQL Server, MongoDB, MySQL
- OtherSharePoint Online, Customer Relationship Management (CRM), Business Intelligence (BI), Architecture, Web Services
Education
- Engineering degree in Computer-aided Design and Engineering2000 - 2006Saint-Petersburg State University Information Technologies, Mechanic and Optics - Saint Petersburg
