Pavel Safonov Email & Phone Number

Moscow, Russia

China

United States

Projects: Insights (MVP), Evaluate My Practice (7,000 customers)Technologies: C#, .NET Core, ASP.NET Core, REST, Linq2Db, React, SASS, TypeScript, Azure SQL Server, T-SQL, Azure Synapse Analytics, Azure App Service, Application Insights, Azure CLI, PowerShellDescription:- Took part in the development of the Insights solution based on Azure Synapse Analytics.- Integrated Google Places API into Evaluate My Practice service.

United States

Projects: Forms (2,000 customers), Online Scheduling (500 customers), Payments (3,000 customers)Technologies: C#, .NET Core, ASP.NET Core, REST, OAuth, Identity Server, Linq2Db, React, SASS, TypeScript, Azure SQL Server, T-SQL, Application Insights, Azure App Service, Azure Cache for RedisDescription:- Led a team of 6 engineers including QA and SDET helping them grow. - Designed and implemented a paperless forms solution. It included websites for patients and practice staff, API for the mobile application.- Designed and implemented an online scheduling solution. It included websites for patients and practice staff.- Upgraded the payment integration with WePay.

United States

Projects: Single sign-on (7,000 customers)Technologies: C#, .NET, ASP.NET MVC, Entity Framework, HTML, CSS, JavaScript, Microsoft SQL Server 2016, T-SQL, IISDescription:- Developed a single sign-on solution for multiple user types with customizable permissions.- Integrated the single sign-on into main company products.

Australia

Project: MS SQL Server migration to PostgreSQL (Firstmac)Technologies: C#, .NET, MS SQL Server 2008, T-SQL, PostgreSQL, Entity FrameworkDescription:- As a part of the international team I rewrote the database layer of entiresolution. Queries, stored procedures and data structures were moved from MSSQL Server to PostgreSQL and Entity Framework.

Russian Federation

Project: ETL/DWH system (PJSC VimpelCom, Telecom Armenia CJSC, Kar-Tel LLC, Mobitel LLC, Sky Mobile LLC, Unitel LLC)Technologies: C#, .NET, MS SQL Server 2012, T-SQL, IISDescription:- Directly managed a team of 6 engineers helping them grow.- Led customization and further development of ETL/DWH system.- Ensured adoption of the system for new customers from Armenia, Georgia, Kazakhstan, Kyrgyzstan, Tajikistan and Uzbekistan.

Russian Federation

Projects: ETL/DWH, FM, BI systems (PJSC VimpelCom)Technologies: C#, .NET, MS SQL Server 2008, T-SQL, Informatica ETLDescription:- Ran the engineering department of 16 software engineers including solution architects and leads.- People management, motivation, coaching, hiring and firing duties.- Developed internal processes.- Ensured the technical execution of more than 90 projects.

Russian Federation

Projects: ETL/DWH, FM systems (PJSC VimpelCom)Technologies: C#, .NET, MS SQL Server 2008, T-SQL, StreamInsight, DevExpress, IISDescription:- Interfaced with customers and delivered updates during all aspects of the project process from initial sales opportunity through to project completion.- Directly managed a team of 10 people including a system analyst, a solution architect, software and QA engineers.- Completed more than 60 projects.- ETL/DWH system was enhanced to process 100 new data types, it handled 3 billion records per day.- FM (Fraud Management) system was successfully launched.

Russian Federation

Project: ETL/DWH system (PJSC VimpelCom)Technologies: C#, .NET, MS SQL Server 2008, T-SQL, IISDescription:- Directly managed a team of 4 engineers.- Led development, testing and deployment of ETL/DWH system including 60 transformation modules.

Russian Federation

Project: Mediation system (250,000 subscribers)Technologies: C#, .NET, Oracle 10g, PL/SQLDescription:- Designed and developed a mediation system for automatic collecting, clearing, aggregating and loading fixed telephony data into a billing system.- Eliminated any delays in data processing before closing billing periods.

Russian Federation

Project: Data collection from voice switches (10 types including Alcatel 1000 S12)Technologies: C#, .NET, XMLDescription:- Redesigned binary and text file parsers for all voice switches in use.- Eliminated data loss in the amount of 5% of all traffic.- Increased speed of file processing up to 10 times.

Russian Federation

Project: Billing systemTechnologies: C#, .NET, Oracle 9i-11g, PL/SQL, OCIDescription:- Worked on multiple projects for internal company customers.- Worked on reverse engineering of Oracle-based billing system.