Dmitriy Pavlov Email & Phone Number

Baltimore, Md, Us

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.Was responsible for the 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 the 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)Designed and developed several web-based applications for the business needs using VB.NET, JavaScript, jQuery. Supported existed desktop/web based applications for troubleshooting and new application 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.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.Developed and supported several web based applications using Visual Studio 2010, 2013 and SQL Server 2008.

Was responsible for SQL development background using SSIS/SSRS. 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 clients requests and error log messages. Developed several programs for the business needs using VB.NET.Was instrumental in implementation of Advantica Insurance EDI eligibility process using BizTalk and SSIS packages used for submitting EDI 834 eligibility data to Advantica. Led efforts for overseeing, creating and maintaining scheduled jobs and complicated SSIS packages for the data operation. Processed old 4010 and new 5010 files due to the HIPAATalk regulation. Provided customer support for the processes running under SQL server SSIS scheduled packages.

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.

Us