Key Responsibilities:

• Developing various migration automation tools for multiple internal and customer projects.
• Writing code in C#, Java, and various SQL dialects (T-SQL, PL-SQL, etc.).
• Working with different frameworks and parsers (.NET, Spring, ANTLR) required to automate code conversion.
• Writing unit, functional, integration, and load tests.
• Creating design documents and specifications, such as BRD and TDD.
• Participating in team SCRUM ceremonies, proposing estimates, defining project scope.
• Participating in code reviews and knowledge transfer sessions.

Key Achievements:

• Designed and created full specification for SSRS to QuickSight reports converter, and later acted as a SME for the development team. The tool was used by one key customer to transform DAL for compatibility.
• Created test data samples generator for SQL Server databases with considering objects relations and query parameters using parsing when database metadata is not available. Used as a part of test environment setup.
• Developed parser of complex Oracle AWR HTML reports, which translates it to the fully customizable JSON. The utility became part of a solution, which meats security limitations.
• Taken part in embedded SQL queries migration. Created parsers, analyzers, and converters for new source languages, PHP and VB.NET. As a results thousands of hours of manual labor are saved.

Tools & Technologies:

SQL Server · SSRS · C# · XML/XSLT/JSON

Key Responsibilities:

• Database development, administration, monitoring, and optimization.
• Providing SDE expertise to the database engineering organization.Integrating various data management systems into a single solution.
• Participating in database migration projects.Developing in-house advanced database monitoring solution.Implementing database best practices for external clients.

Key Achievements:

• Using native SQL Server tools such as Query Store, I created a solution to load test repeatsactual user’s activity without access to production databases. This solution reduced 80% ofindex storage and improved 20% of performance.
• Created an extension for Microsoft SSMA which emulates Oracle spatial types using SQLServer Geo data types.
• Analyzed the performance of newly created CRM product, found multiple issues in databasedesign and programming objects. After my optimization the database passed performancetests and was successfully deployed to production.
• Added to monitoring system a component which aggregates various performance countersmetrics and shows them in a highly configurable SSRS graphic report. It allowed support teamto predict issues and proactively make changes to the database infrastructure.
• Designed and implemented a solution which consolided data from various sources (Mixpanel,MongoDB, MariaDB, etc.) in a single cloud target. The solution supports comprehensiveconfiguration and runs in parallel to ensure less than two minutes latency.

Tools & Technologies:

SQL Server, ~Oracle, ~MongoDB, ~MariaDB, C#

Microsoft Commerce Server 2007 e-commerce solution development and support

Designed and singlehandedly implemented a internal workflow management, a web-site with visual workflow designer, tasks planning, reporting, and time management.

Integrated the internal system with Salesforce CRM, which also saved on licensing cost, using single account instead of individual subscriptions.

The solution was used by ~200 people daily and replaced hundreds of shared Excel spreadsheets.

Tools & Technologies:

SQL Server · ASP.NET (WebForms) · JavaScript · jQuery ·

As part of a team of six people, built a comprehensive in-house ERP system, which covered Sales, Logistics, Manufacturing, Technology, HRM, Accounting, and Finance.

The system was used by the ~500 corporate employees for four years, before it was replaced by the third-party product.

Tools & Technologies:

ASPNET 1.0 – 2.0 (C#) · MS Access (VBA) · MS Exchange (VBS) · SQL Server

• A utility to calculate the optimal rectangular cutting process. More than ten manufacturers of cabinet furniture purchased the software to save on cost and time.
• A custom CRM for the small law-firm.
• An accounting system for an agricultural enterprise with plots visualization on the map.
• A dental practice management system, sold to four local clinics.

System and database administration, software development.

Created a comprehensive solution for automated goods, monetary and bills accounting, which is being used to this day.

Tools & Technologies:

Delphi · Firebird

Participated in the development of two ERP systems and their adoption by the staff

Tools & Technologies:

Borland Pascal · Delphi · Interbase · Btrieve

Developed software for electronic display boards