KONSTANTIN LOPATIN

Email: adm38b@r.postjobfree.com

Phone: 623-***-****

Address: **** * ********* **, *****, AZ 85048

LinkedIn: linkedin.com/in/konstantin-lopatin-86154812/

TECHNICAL SKILLS

SQL database development – 15+ years

SQL Server Reporting Services – 3 years

SQL Server Integration Services – 3 years

MS SQL Server (2000 - 2019) Administration – 15+ years

MS Office (Excel, Access) – 15+ years

MS Windows Server 2003. 2008. 2012, Network Administration, Active Directory – 15+ years

C#, VB, T-SQL, ASP.Net, ADO.Net, HTML, CSS, JavaScript, jQuery, MS Visual Studio, Visual Studio Code, Crystal Report, JSON, XML, MATLAB

EXPERIENCE

Arizona Department of Corrections

Software Developer October 2020 – December2020

Recreate the Database structure according to new Federal requirements

Develop new application according to new Federal requirements

Freelance

SQL Developer April 2020 – September 2020

Database integration

Convert text file data into SQL format

Create Excel and MS Access applications

US Department of State / US Agency for International Development (USAID)

Software Developer/SQL Developer June 2010 – December 2019

●Supported USAID Mission IT network (SQL database, SQL servers’ administration).

●Designed and developed desktop and Web application using C# (Visual Studio, WPF) and SQL Server 2014. SSRS and Crystal Report was used for generating standardized reports. E.g. designed and implemented new Budget system with flexible structure and multiple cloning budget versions allowing to decrease time of budget development from 5-6 days to 1 day.

●Designed and developed application in sending Emails of Weekly Reports using SQL Mail configuration to send Mails via SMTP Mail server.

●Transferring inbound data from various sources like csv files, Oracle, MS Access, and Excel into database using SSIS Packages.

●Developed complex T-SQL code such as Stored Procedures, functions, triggers, indexes, and views for the application.

●Develops technical system documentation, SOPs and manuals.

●Provided training for users, including advanced software functionality.

●Tech support Electronic Document System - Documentum

System Manager September 2007 – June 2010

●Provided leadership to the Central Asia Regional IT team (5 countries, 7 USAID offices, CDC/Kazakhstan Office and US General Consulate in Almaty, 250 users), Strategic and Operational Planning, Security (ranked #1 as the most secure USAID Mission in the world in 2009), IT Budgeting.

Computer Management Specialist June 2003 – September 2007

●MS SQL Server database development / administration.

●MS Windows Server administration

●Provided IT support for USAID Mission:

managed computer networks for USAID/Central Asia Mission (7 country offices, up to 40 servers), monitored performance and maintained systems according to the requirements, ensured security, timely backups and firewalls.

●Developed WinForm, Web-based, and hybrid applications for General Services and Financial Department purposes, such as Expendable Property warehouse, Voucher Tracking System, IT HelpDesk (which allowed timely monitoring of IT-related requests and improved the average time of service provision by 10%).

●Tech support for Electronic Document System – Documentum

●Tech support for Mission-wide geo project – ArcGIS

Computer Systems Analyst March 1997 – June 2003

●Provided IT support for USAID Central Asia Mission (5 country offices, over 200 users), including: Setting up accounts and workstations, installation and configuration of software and hardware; troubleshooting issues, supporting software.

●Designed database, tables, and views structure for the application.

EDUCATION

Master’s in Computer Sciences, Kazakh National Technical University

graduated with honors.

ADDITIONAL SKILLS

●Good listener, attentive to customer’s need

●Adaptable, flexible, logical thinking, creative

●Able to negotiate with others, and to recognize and appreciate diversity in a team

●Results-oriented

●Extensive experience in multicultural environment

SPECIAL ACHIEVEMENTS

More than 20 awards from the US Government (Meritorious Honor Award, Eagle Award, Spot Award, Mission Honor Awards, and Certificate of Appreciation, etc.)

AUTHORIZATION TO WORK

United States Permanent Resident Card (Green Card)

Contact this candidate