Vladimir Yedynak

Experience

• 

  Europart RUS

  Feb 2008 - Feb 2009

  Programmer

  Responsibilities: development of database objects for company's trading system (logic - T-SQL, interface - VBA), server administration tasks.Completed projects:1. Configured import of supplier data from xml files to the server.2. Developed a mechanism for combining several invoices for one shipment to a client.3. Developed a support for storage history in warehouse spaces.

• 

  Niks, OOO

  Feb 2009 - Feb 2010

  Programmer

  Responsibilities: development of client server applications for process automation in various departments (logic - T-SQL, interface - VBA).Completed projects:1. Developed the program for storing and displaying the topology of the local network.2. Developed the application for reading data from a GPS receiver.3. Developed the program for scanning hard drives.

• 

  M.Video

  Feb 2010 - Jun 2011

  Database Developer

  Responsibilities: T-SQL programming for the development and maintenance of the corporate information system, query tuning.Completed projects:1. Developed the procedures for data migration from corporate information system to the data marts and data convertation in xml for the subsequent migration to the SAP PI system.2. Developed client server application for reconciliation of payment data between corporate system and external payment systems (logic - T-SQL, interface - VB6).

• 

  Uralsib

  Jul 2011 - Feb 2014

  Lead Software Developer

  Responsibilities: development of the analytical data warehouse (logical and physical structure). Query tuning, server administration, development and maintenance of client server applications, customer interaction.Completed projects:1. Developed the data wareouse for Treasury Reporting Department. The architecture of economical storage of heterogeneous entities on the same principals enabled to use the storage as a shell for the corporate dwh. Different reports were introduced. The task of finding the financial result of the bank was made based on the data loaded into the data warehouse.2. Automated administration tasks on 5 servers.3. Developed client server application for setting and sending the orders for currency rates for the regional netword of the bank (logic - T-SQL, interface - VB6). Show less

• 

  Alfa-Bank

  Feb 2014 - Feb 2015

  Lead Software Developer

  Responsibilities: Database Development and query optimization in high load OLTP system. Development of the Alfa Direct - brokerage system for operations in stock markets.Completed projects: developed the replication between several database servers for load scaling using the service broker and replication components of MS SQL.

• 

  Gazprombank

  Feb 2015 - now

  Director

  Responsibilities: development and maintenance of the analytical data warehouse, query optimization, server administration, creation of the Analysis Services databases. Development of algorithms for customer deduplication. Solving Data Mining problems.Completed projects:1. Transferred data marts and Excel files of the Internal Treasury Department to the new data storage that acts as a shell and visualizer of any external data sources of the financial data. Designed the archtecture at the logical and physical level.2. Developed two Analysis Services databases. Created partitioned OLAP cubes and Tabular models. Eleborated processing prcedures and MDX/DAX queries that speed up the performance of reports.3. Designed the engine of the rules constructor. Eleborated metadata structures and procedures that allowed end users to create their own criteria of searching, including or excluding financial entities (deals and accounts) and for changing their attribute composition without the aid of the database programmer. For example, the solution allows you to create criteria for searching accounts and deals, create their clones, set algorithms for changing the attribute composition in data quality problems.4. Created the metadata and procedures that allow end users to configure the load process of different bank entities and their attributes from various external sources into the target data warehouse. The solution allowed end users to map the attributes of external data marts to a unified extensible storage model for to perform subsequent automatic downloads without the aid of the programmer. Show less