Vasiliy Klimenko
ERP, BI, and ETL Developer
Canada NOC 2173
Moscow
********@*****.***
https://www.linkedin.com/in/vasiliy-klimenko-07a849b4/
Skilled software professional who has worked with standard and custom configurations for business needs in fields such as construction, real estate, catering, pharmacy, and retail. Worked on tasks from deploying databases, administration, creating objects, writing stored procedures and queries, optimization, and making user interfaces. Also worked on external APIs, reports, integrating with retail equipment and other systems, which all were solved with 1 experienced specialist, using standard set of tools and 1C libraries. Being sure that this technology is competitive, with an ease in developing enterprise-level cloud-based software, wish to share personal experience with employers.
Experience
MARCH 2018 – PRESENT
DevOps Unifarma (Unifarma.ru), Moscow
Moved to the company (an In-Tech client) from previous job. Continue to maintain the same configuration developed for pharmacy chains independently.
Rewrote the configuration based on the wishes of the current pharmacy chain to the functionality of pricing, auto-ordering, inventory, commodity movement, operational accounting, highly customizable motivation system for pharmacists, and flexible settings for the exchange of Distributed DB, external API (for pharmacy aggregators, online orders).
Upload primary documentation to the Accounting and Salary modules. This automation slashed payroll/benefits administration costs by 40% while ensuring the continuation and enhancements of services.
Added functionality for optimizing illiquid transfers between pharmacies according to the need.
Implemented several card marketing projects, including the calculation of the discount through a remote web service.
Integrated in fully automatic mode this software with the national drug marking program MDLP. Updated hardware modules, hardware drivers for new firmware (20% VAT, MDLP)
Developed a live queue functionality for pharmacies with high traffic.
Made this custom IPOS + BackOffice solution fully cloudy (SaaS model as well as client-side server mode). This configuration has become a competitive solution in the pharm market.
JUNE 2017 – MARCH 2018
BI/ETL Developer/InTech (Intech.one), Moscow
Worked in the development team on custom configurations for pharmacies and pharmacy chains. Made new functionality in pricing blocks, retail sales, orders to suppliers, technical support, reporting, printing forms, data exchanges.
Improved exchanges of regulatory and reference information and operational data between the Central database and pharmacies (files + web services).
Debugged cash register equipment and its drivers in conjunction with the configuration. Updated pharmacy databases. Bugs rectification.
APRIL 2016 – MAY 2017
Programmer/Mercury (Mercury.ru), Moscow
Participated in development of non-standard configurations for selling premium cars (Bentley, Ferrari, Maserati) and motorcycles (Harley Davidson), as well as and luxury accessories.
Added new and optimized existing reports.
Improved existing subsystems, developed data exchange mechanisms with standard regulatory reporting configurations.
Moved from COM-based exchanges to web-based services, which reduced the exchange time.
Implemented email and SMS distribution mechanisms, which helped to promptly inform clients about promotions. Configured IIS server. Provided consulting and operational support for users.
MAY 2012 – MARCH 2016
Lead Programmer/Absolute Realty (absrealty.ru), Moscow
Development and implementation of new functionality in non-standard CRM configuration.
New objects (directories, documents, processing)
Complex reports (2000-5000 lines of query code in the report) using the 1c reporting composition engine. This became a powerful management mechanism for tracking real estate transaction activity.
Combined the functionality of several big configurations into one, working with data conversion.
Created and implemented new printing forms (using COM objects). Created and modified XML rules for uploading and uploading data between typical and non-typical configurations.
Integrated the 1C database with the Avaya telephony component (for incoming and outgoing calls. Rewrote part of the existing functionality to a thin client mode.
Prompt solution of user issues (distribution of rights: roles, RLS; error correction).
AUGUST 2011 – MAY 2012
Main Program Developer/Sphere of Business Solutions (Bssp.ru), Moscow
Supported projects such as "construction cost Management", "construction Customer" for the Federal state unitary enterprise under the Ministry of defense of the Russian Federation (mainly accounting unit).
DECEMBER 2010 – AUGUST 2011
Engineer Programmer/Muvicom (Muvicom.ru), Moscow
Updated and improved configurations Trade Management on 8.1, Accounting and ZIK on 7.7 for the needs of users (managers, accountants, management).
Wrote new functionality (reports, processing, routine procedures).
JUNE 2008 – JUNE 2010
Head of Information and Computing Center/Trading House, Moscow
Updated and revised trading solutions on the platform 1C 8 in conjunction with the SQL server base and fiscal registrar.
Did the installation and commissioning of cash register equipment, bar code scanners, fiscal printers, label printers. Did periodic updates the accounting database.
Configured an email program, Microsoft Exchange Server, installation of client-Bank software, administration, ISA Server.
Set up periodic backups, setting user rights in the domain network, writing SQL scripts, and serviced office equipment.
FEBRUARY 2008 – APRIL 2008
Programmer/Implementer/Astrosoft (astrosoft.ru), Moscow
FEBRUARY 2006 – DECEMBER 2007
1C Programmer/Chronobus (Chronobus.ru), Moscow
Worked on COTS for educational process
Developed a subsystem for automated scheduling of classes
Data exchange between the configuration and application packages written in other programming languages
Updating software logic at the request of methodologists
MAY 2005 – JULY 2005
Delphi Programmer/Research Institute "Voskhod" (voskhod.ru), Moscow
Skills
Accounting (10 + years)
Trading (1 year)
Regulatory Reporting (7 years)
API (6 years)
Scripting (10+ years)
SQL (10+ years)
Microsoft SQL Server (10+ years)
XML (7 years)
JSON (5 years)
Web Services REST & SOAP (7 years)
ERP Systems (10+ years)
Retail Sales (7 years)
Real Estate (4 years)
CRM Software (4 years)
Microsoft Office (10 + years)
Integration (10+ years)
Pharmacy Software (4 years)
Retail Software (7 years)
Education
Bachelor in Applied Informatics, Moscow State University of Economics, 2008
Asessments
Logic & Critical Thinking — Proficient
May 2020
Using logical approaches to problems.
Full results: Proficient
Business Analyst — Familiar
June 2020
Analyzing information to solve business problems
Full results: Familiar
Data Entry: Accuracy — Proficient
July 2020
Entering data quickly and accurately
Full results: Proficient
Work Motivation — Expert
June 2021
Level of motivation and discipline applied toward work
Full results: Expert
Data analysis — Highly Proficient
June 2021
Interpreting and producing graphs, identifying trends, and drawing justifiable conclusions from data.
Full results: Highly Proficient
Publications
Excample 1 of what i do with comments
https://vimeo.com/427838256
Excample 2 of what i do without comments
https://disk.yandex.ru/d/PIbUrdwF_T4l8w
These are videos of business processes in pharmacy retail. You can find how pickup and sales are taking place. How QR code is scanned, how live queue goes, how regulatory reporting works, how the need for pharmacies is counted...