Evgeny Veselov Email & Phone Number

St Petersburg, St Petersburg City, Russia

Project: Support of the company's production environmentParticipation: Maintain and ensuring high availability of production MS SQL Servers

St Petersburg, St Petersburg City, Russia

• Project: iLevel for S&P Global (www.spglobal.com). Development of a web service for private capital market.Participation:
• Maintain production MS SQL Servers
• Controlled 26 Production SQL Server 2016 machines (AWS EC2 not just RDS) in Amazon AWS cloud.
• Maintained 2 Production Always On Availability Groups for 6 years.
• The biggest AG was 5 TB of data in 666 db's per each of 3 replicas, processing 3500 avg / 7500 peak TPS, having the biggest db of 380 GB.
• Proposed and implemented a PowerShell script for automation of SQL Server installation/configuration.

St Petersburg, St Petersburg City, Russia

• Project: SharePoint Support for Zoetis (www.zoetis.com)Participation:
• Provided administration of 7 MS SQL 2008 R2 / 2012 instances related to SharePoint farms.
• Assisted SharePoint support team in troubleshooting and solving of database-related problems.
• 3 TB of data in 250 databases in three environments (DEV / QA / PROD). The biggest database was 150 GB.
• Was responsible for creation/deletion/moving of databases, accounts, database permissions.

* IHS Markit merged with S&P Global in December 2021

* Ipreo was acquired by IHS Markit in August 2018

St Petersburg, St Petersburg City, Russia

• GGA was acquired by EPAM in June 2014Project: SharePoint Support for Novartis International AG (www.novartis.com)Participation:
• Administrated 15 MS SQL Server 2005/2008 R2 machines which were servicing 12 MS SharePoint farms.
• Maintained 3 Failover Cluster Instances (FCI) of 3 nodes each, with NetApp Storage connected via FC SAN.
• Overall size of production data was 2 TB in 200 databases, the biggest db was about 400 GB.
• Reacted on errors and bottlenecks.
• Assisted to SharePoint support team in problem solving.

St Petersburg, St Petersburg City, Russia

• Project: Support of the production system of the companyParticipation:
• Administrated the company's high-loaded production system: 14 machines with MS SQL Server 2005 plus 6 machines with IIS 6.0/7.0. Database sizes were hundreds of GB.
• Provided 24x7 3-d line support for the production environment, reacted on issues and incidents.
• Monitored SQL server performance.
• Ensured High Availability using Mirroring and Replication for production databases.
• Troubleshooted database bottlenecks using Profiler.

St Petersburg, St Petersburg City, Russia

• Project: Development of trading platform Web Trader / Client Station for Saxo Bank (www.home.saxo)Participation:
• Administrated databases of the development environment of the St. Petersburg Affiliate.
• Reviewed the project's T-SQL code: ensured standards compliance, improved query performance.
• Synchronized local databases with their remote versions via RedGate Toolbelt (SQL Compare, Data Compare)
• Mentored development and QA teams on database development questions.
• Took part in other database projects of the affiliate, where necessary.

St Petersburg, St Petersburg City, Russia

• Project: LSE-CRE2 for London Stock Exchange. Development of a web portal for assisting companies in populating of rating agencies questionnaires.Participation:
• Controlled developement database of the project
• Reorganized a database development process from parallel work on a single development database, to a more stable approach where each developer worked with its own copy of the development database.
• Developed a set of batch files for instant restoration of any database version from an archive.
• Arranged regular releases of database versions.
• Maintained ER-diagrams, consulted developers, performed query optimizations.

St Petersburg, St Petersburg City, Russia

• Project: MedEquip. Development of a system for storing of technical descriptions of medical equipment with a rich search by the user defined criterias. Team: 12 members.Participation:
• Shared several roles: Business Analyst, Database Designer, Database Developer, Developer of UI (pilot version).
• Performed initial requirements analysis, communicated directly with a customer.
• Designed and maintained ER-model of the database in Sybase PowerDesigner.
• Implemented the database (40 tables) on MS SQL Server 2000.
• Proposed conception of user-defined properties and property templates.

St Petersburg, St Petersburg City, Russia

• Project: Developement of Medical Information System of Region. The system provided a centralized storage of polyclinic and hospital service cases.Participation:
• Maintained the OLTP database structure and the ER model in Sybase PowerDesigner.
• Self studied all aspects of OLAP, warehouse, DTS and MDX technologies via Microsoft Official Courseware.
• Designed from scratch and implemented: the Warehouse database, the multidimensional OLAP database (8 cubes, 37 shared dimensions), 3 DTS packages for ETL automation.
• Provided a concept of parameterized queries for the OLAP database.
• Implemented all MDX queries for data extraction from cubes.

St Petersburg, St Petersburg City, Russia

Took part in development of the company's databases on MS SQL Server 2000. Designed and implemented a set of tables and stored procedures for automatic trade requests (StopLoss). Developed stored procedures for calculation of user defined economic indicators. Developed scripts for extraction of data for complex reports.

St Petersburg, St Petersburg City, Russia

Project: Development and support of myspace.com (at the time it was a highly popular file exchange resource). Paricipation: Optimized queries, monitored the database activity, documented the database, preparied database release scripts, supported ER-diagrams. My first experience with MS SQL Server 6.5 / 7.0

St Petersburg, St Petersburg City, Russia

Project: "Blue:solution Handwerk" (an automation system for building and repairing business). Paricipation: Developed wizards, visual components, forms, modules, reports in Borland Delphi Enterprise 5.0 using Apollo VCL, Apollo SQL, Report Builder.

St Petersburg, St Petersburg City, Russia

Designed and developed the agency’s automation system using Borland Delphi C/S Suite 3.0 and Interbase 4.0 database. Implemented and administrated the local network on base of MS Windows NT 4.0 domain.

St Petersburg, St Petersburg City, Russia

Supported and developed internal databases in MS Access, administrated the MICROS-Fidelio software complex (an integrated enterprise solution for the hospitality industry).