Alexey G. Email and Phone Number

Working on various projects:VBA and Google App scripts that automate processes, prepare PDF documents, send emails, exchange data with external sources (SQL server, MySQL, BigQuery etc), organize data in Drive folders.Creating MS Excel + SQL Server dashboards.Optimizing stored procedures, queries, functions in SQL Server.Generating and processing of XML and JSON data in SQL Server.Creating service based on Broker Service for exchanging data between servers.Creating MS Access application for editing data in SQL Server.Creating Google Sheets + MySql application for processing csv files and generating automated reports.

The main role in this position was to develop automated analytical reports based on data stored in a SQL Server database for clients using the company's services. The responsibilities also included maintenance existing reports: adding functionality, optimizing performance (make reports run faster and take less resources), fixing bugs, checking the code of colleagues by team.Skills and technologies used in this position:Developing reports in SQL Server Reporting Services (SSRS).Writing SQL code for creating stored procedures, functions, views, tables and indexes in SQL Server.SQL Managment Studio, Visual Studio, SQL Profiler, Git (TFS)

The responsibilities in this role was maintenance and developing analytical banking system. That included developing reports and developing database architecture for storage and processing incoming client data. In this position, among other things, I developed a solution that allows you to automatically process the chain of sending data to external services for verification. Each subsequent sending and selecting an external service was based on the business logic of processing the response from an external service in the previous steps.Skills and technologies used in this position:Writing SQL code for creating schemes, tables, views, indexes, constraints.Writing and optimization of stored procedures, functions, triggers.Converting data to XML and processing XML data in SQL Server.SQL Managment Studio, SQL Server Service Broker, SQL Profiler, SVC.

In this position I developed a set of automated analytical reports and dashboards for analyzing secondary sales and evaluating KPI of employee. I have developed databases and corresponding Windows applications for data correction in the database by the operator: Database on the sale of the company’s products to pharmacies and medical institutions; Database of stocks of the company’s products in the warehouses of distributors.I completed various projects at the request of the company’s managers, including was developed an application for tracking the sales promotions and parsing web sites to compare the workload of pharmacies with the company’s products with those of competitors.Skills and technologies used in this position:Database design, development and administration in SQL Server 2008, MS Access 2010.Creating stored procedures, functions, triggers, views, indexes in SQL Server.VBA MS Access and MS Excel (application, reports, dashboards).Windows applications in C# (WinForms) for work with the database and generate reports to employees of company.

Math and computer science lessons (mathematical analysis, theoryprobability, mathematical statistics), methodical work.

Math lessons for students of economy (mathematical analysis,linear algebra), methodical work.