Mykola H. Solution Architect/.NET Software Engineer

Experience

Team Lead, Solution Architect, Cognizant Softvision

2 years 2 months (2020 - 2022)

Responsibilities:

• Develop a tool for ingesting tax data (pdf, IRS-XML, JSON) into centralized storage, parsing it
  accordingly to the model, and reporting on the data. Uses Azure Functions and Web Jobs for data transformations and report generation, easily scales out. Communication between services and apps is done via Azure Storage Queue. Database scalability is implemented based on partitioning.
• Develop Corporate Assets Recovery System. Allows users to upload data from various state sources (XML, CSV, excel, pdf) into a central location for searching. Used Azure Search for searching through a high volume of data.
• Distributed windows services for the ETL process. Processing different kinds of tax files and storing them in unfiled format.
• Develop Audit Reserve Management - a system that allows users to manage audits and reserves,
  import audit transactional data, upload Pdf files for OCR, and get predictions on interest\penalties\tax based on transaction data using 3rd party systems. Bulk inserts\updates on large data volumes.

Solution Architect, Senior Developer, Under NDA

3 years 11 months (2016 - 2020)

Responsibilities: 

• Consulting existing and new customers.
• Define the architectural approach for new projects and related integrations.
• Taking part in pre-sales meetings.
• Assist solution architects during the solution design phase.
• Research new technologies and recommend where/when to use them.
• Business needs analysis, requirements gathering, translating requirements into functional
  specifications, and creating project documentation.
• Communication with stakeholders
• Interviewing
• Validate and maintain the technical service designs

Technologies: Visual Studio 2015-19, .NET Core, TFS, VSTS, WebApi, Angular 6, TypeScript, Mailgun,
Document Core Pack, SSIS, SSRS, PowerBI

Senior Information Technology Consultant, Arrow Digital, US.

2 years (2016 - 2017)

Responsibilities: 

• Working on a distributed system for Reporting and Analytics. Built WPF client applications, RESTful APIs, and services to implement calculation algorithms. Provided internal technical seminars for developers.

Major Accomplishments:

• Re-engineered the serialization subsystem of transferring data using protobuf serializer and improved the efficiency of the serialization by 50%.
• Implemented a logging service that is used across the entire client application to identify the problem areas and improved our bottleneck identification process.
• Made continuous performance improvements implementing fast complex validation subsystem.
• Solved production bugs.
• Implemented wrappers to call Qt dll from .NET code, modified C++ code according to new
  requirements.

Technologies: C#, SQL, WPF, protobuf, JSON, Qt, XML, Web API, Entity Framework, TFS

Lead engineer in designing and implementing information systems, Metinvest Holding

2 years (2013-2015)

Responsibilities: 

• Performed tasks of developing and implementing production management software. This MES system consists of 8 servers and works with more than 90000 online parameters.
• Assigned tasks of implementing manufacturing and automation strategies, optimizing process control, and investigating assets reliability issues by coordinating with process experts and reliability engineers
• Developed information system of melding process (MS SQL, C#, LINQ, WPF)
• Teaching developers of Enakievo Steel (C#, XAML, WPF, LINQ)
• Creating reports in MS SSRS
• Created information web screens in Matrikon Operation Insight
• Created and improve MS SQL data structure and stored procedures for the best performance
• Created models of Asset in Honeywell Asset Manager
• Assisted an engineering team from Honeywell to solve the problem
• Configured and administrated MES servers:
  
  • Matrikon Production Manager and Reconciler based on MS SharePoint 2010;
  • Matrikon Operation Insight hosts on MS IIS;
  • Honeywell PHD based on two Windows 2012 failover clusters (MSSQL 2012 and process history database servers clusters), data collection applications servers;
  • Honeywell Asset Manager hosts on MS IIS
• Take part in developing integration between MES and ERP SAP systems
• Provide training sessions for engineers of Enakievo Steel, Zaporizhstal for working with
  Honeywell PHD, Operation Insight
• Develop server extension for document turnover system based on DocsVision

Process control analyst, Ukrtatnafta

Duration: 10 years (2003-2013)

Responsibilities: 

• Developing structure of process control system, SCADA projects, PLC programs, reporting
  and accounting systems; commissioning and supporting
• Developing servers for data transformation between different systems
• Hands-on development services in a multi-tier application
• Hands-on development experience in developing C# .Net-based Application
• Programming experience and knowledge with creating SQL Server database, scripts for the database objects, normalization
• Design and Development of Windows Applications
• Experience with different PLC types from Siemens, Honeywell, ABB, etc
• Managed and executed training sessions for control engineers regarding programming control systems (WinCC, Step7, InTouch)
• Set up radar meters, Coriolis meters, variable-frequency drives

Education

Ivan Franko National University, M. Sc. Degree in Applied Mathematics and Informatics