Systems Analyst Customer Support

DMITRIY PAVLOV

********@*******.*** 410-***-**** Ellicott City, Maryland 21043

Personal Summary

Dynamic Senior Systems Analyst with extensive experience at Leidos, specializing in SQL Server and SharePoint administration. Demonstrates expertise in transforming complex reports and improving user access while providing outstanding customer support.

Technology

SharePoint 2010, 2013, 2016, and Online

ASP.NET and VB.NET

MS Visual Basic 6.0

MS Access and Crystal Reports

MS Visio and VBScript

JavaScript and jQuery

MPower and NetSuite

PowerBuilder 4.0 and 5.0

MS SQL Server and T-SQL

Oracle SQL and PL/SQL

Visual SourceSafe 6.0

Team Foundation Server

SSRS and SSIS

Professional Profile

Senior Systems Analyst Leidos 04/2021 - Current

Company Overview: Leidos is a global science and technology company that provides solutions in defense, aviation, information technology, and biomedical research.

Work as Leidos contractor supporting the Civil Rights Division of DOJ. Responsible for conversion of Crystal Reports from Oracle database to SQL Server. Writing SQL queries, stored procedures.

Performed SharePoint 2016 website administration and maintenance including monthly patching for development, testing and production environments, creation of document libraries, surveys, SharePoint sites.

Identify and resolve issues that users experience with SharePoint, creating new user accounts, adjusting account privileges, Training new employees to use SharePoint.

Configure SharePoint sites and manage user access. Use HTML to structure content and CSS to style pages.

Provide customer support giving instruction by demonstrating, troubleshooting and configuring Microsoft SharePoint 2016 to all users.

Worked on Master pages for adding logos, edited CSS files and files for making design changes based on requirements.

Designed and developed new and maintained existed PowerApps applications.

Provided customer support through the helpdesk web application.

Leidos is a global science and technology company that provides solutions in defense, aviation, information technology, and biomedical research.

Systems Analyst The Midtown Group 09/2020 - 04/2021

Work as subcontractor for Leidos supporting the Civil Rights Division of DOJ. Responsible for conversion of Crystal Reports from Oracle database to SQL Server. Writing SQL queries, stored procedures.

Performed Share Point 2012 website administration and maintenance including monthly patching for development, testing and production environments.

SSRS Report Writer Synagro 06/2020 - 09/2020

Develop reports that are under old RMS Reporting Services (R&R reporting tool) or Crystal Reports and convert them into SSRS using SQL Server 2016 and SQL Report Builder.

Database Developer / VB.NET Developer Synagro 08/2013 - 02/2020

Was responsible for maintenance and support of several databases including the design and development of stored procedures, views, triggers and tables for the application running on MS SQL Server 2005/2008 platform.

Supervises data cleaning to correct inconsistent, unused, or duplicate data.

Helps developers tune queries, assign proper indexes, create triggers and stored procedures.

Performing routine database administration activities including setup login credentials for users & administer general security measures on database, to resolve and troubleshoot database access/other database issues, handle the backing up process of the database & its inspection.

Successfully implemented the data movement capability and reporting using MS SQL Server Suite of Business Intelligence products (SSIS for ETL module and SSRS for reports).

Adding or modifying system/user permissions to databases or database servers.

Troubleshoot query slowness and find optimal indexes.

Designed and developed several web-based applications for the business needs using ASP.NET, JavaScript, jQuery. Supported existed desktop/web based applications for troubleshooting and new applications futures.

Designed and developed several web based applications using mPower tool with MS SQL Server 2008 database on a backend. Wrote custom utilities for the futures not provided and supported by mPower tool.

As member of large team, implemented NetSuite ERP system with primary focus on reports and dashboards design for the user's needs.

Performed Share Point 2010 website administration and maintenance including troubleshooting of user permissions, new sites, pages, workflows, web parts. Have used Share Point Designer to create and edit workflows.

Performed administration of access controls and user's permissions for Customer Relationship Management application.

Upgraded legacy VB 6 desktop application to ASP.NET web based application.

Developed and supported several web based applications using Visual Studio 2010, 2013 and SQL Server 2008.

Developed and supported call in application using Angel Click web provider.

Provided customer support through the helpdesk web application.

Database Engineer / Software Engineer Advantica 03/2012 - 08/2013

Was responsible for SQL backend development using Oracle and MS SQL Server BI Suite of products.

Schedule and perform regular SQL DB maintenance operations according to workload pattern and usage of the SQL DB.

Implementing solutions for Microsoft SQL database backup and recovery infrastructure.

Improved failover procedures and processes by participating in yearly Disaster Recovery testing. Prepared Disaster Recovery database recovery plan, verified server infrastructure and application configuration for DR Disaster Recovery testing; completed analysis and configuration of the areas that were critical to ensure database recovery (when required) and implemented Backup System Design enhancement to address critical failures.

Maintained and supported several databases, designed database schema, implemented stored procedures, views, triggers and tables for SQL 2005/2008.

Was responsible for the database support and troubleshooting based on client's requests and error log messages. Developed several programs for the business needs using VB.NET.

Was instrumental of Advantica Insurance EDI eligibility process using BizTalk and SSIS packages used for submitting EDI 834 eligibility data to Advantica.

Led effort for overseeing, creating and maintaining scheduled jobs and complicated SSIS packages for the data operation.

Processed legacy 4010and new 5010 files due to the HIPAATalk regulation.

Provided customer support for the processes running under SQL server SSIS scheduled packages.

Application Developer Pante' Technology 03/2009 - 03/2012

Company Overview: Pante' Technology provides IT services and solutions to various government agencies.

Responsible for upgrade from SQL 2000 to SQL 2008 (Facts1 and IFCS databases). Duties for the upgrade included design and implementation of the stored procedures, functions, views, tables compatible to SQL 2008, rewriting the DTS packages not supported in SQL 2008 to SSIS, redesigning hardcoded SQL statements in web applications asp pages to be compatible with the SQL 2008 version of SQL. Used SSRS for the reports generation.

Maintained and supported several SQL 2000/2005/2008 databases, created database schema design, implemented stored procedures, views, triggers and tables.

Participated in the yearly Disaster Recovery Exercise of BPD Intel Platform Applications. Performed security vulnerabilities scans (cross-site scripting, sql injection) of the www.fms.treas.gov web application, analyzed and corrected issues found by the scan report.

Responsible for analyzing, troubleshooting and resolving issues related to the various web applications. Worked with business owners to provide technical guidance and operational support for resolving issues related to the web and desktop applications.

Pante' Technology provides IT services and solutions to various government agencies.

Sr. Programmer Analyst Constellation Energy - Pasadena, USA 11/2007 - 03/2009

Designed and developed reports using Crystal Reports and Oracle database. Implemented stored procedures and triggers for the reports.

Programmer Analyst / Application Developer 11/1995 - 11/2007

Multiple organizations – details available upon request

Education

Business Economy Institute St.Petersburg, Russia 07/1994

Bachelor's Degree: Computer Science

State University St.Petersburg, Russia 07/1990

Bachelor's Degree: Accounting/Financial Law

Current Clearance

Public Trust

Technology

SharePoint 2010, SharePoint 2013, SharePoint 2016, SharePoint online, ASP.NET, VB.NET, MS Visual Basic 6.0, MS Access, Crystal Reports, MS Visio, VBscript, JavaScript, jQuery, mPower, NetSuite, PowerBuilder 4.0, PowerBuilder 5.0, MS SQL Server (T-SQL) 2005, MS SQL Server (T-SQL) 2008, MS SQL Server (T-SQL) 2012, MS SQL Server (T-SQL) 2019, MS Access, ORACLE (SQL, PL/SQL), Visual Source Save 6.0, Team Foundation Server (TFS), SSRS, SSIS

Contact this candidate