Business Intelligence Sql Server

VLADIMIR ISAEV

Golden Beach, OR

303-***-****; ad5yf4@r.postjobfree.com

SKILLS: DBA, SQL DEVELOPMENT, DATA ARCHITECTURE/BI;

Production OLTP/OLAP DBA, SQL Developer, SQL Server and Query Performance Analyst, T-SQL Developer and Architect, Solutions and DevOps Analyst, Business Intelligence Analyst/Developer (incl. ETL (SSIS, Talend)), Data Analyst, IT problem solver with hands-on programming, deployment, QA, technical support, offshore teams collaboration, good writing and communication skills, and more than 10 years overall Data Engineering/DBA/IT.

•PPREFERRED IT ROLES: DBA, Business Intelligence (BI) Developer; SQL Performance Analyst, Systems Analyst, Data Architect, Project Integration Specialist;

•OS: Windows Server 2003/2008/2012 /2016 UNIX, Linux (multiple flavors);

•DATABASES: Microsoft SQL Server 2000/2005/2008/R2/2012/2014/2016/2017/2019/2022; Oracle, MS Access, MySQL, Postgre SQL, DB2, Teradata, and Sybase (ASE);

•LANGUAGES: SQL, TRANSACT-SQL (T-SQL), PL/SQL, VISUAL BASIC 5.0/6.0/.NET, JavaScript, XML, .NET/C#, Python;

•SOFTWARE/TOOLS: Windows Server Management tools, AppDynamics, ERWin, TFS, SVN, RedGate Tools (all), Toad (Oracle), SQL Server Reporting Services (SSRS), SSAS, SSIS, Crystal Reports (Business Objects), SOLAR WINDS, Oracle (Toad, SQL Developer), Solar Winds, AQUA Data Studio, and a number of custom tools developed by myself (SQL Agent Jobs Management Utility; BLT – Block and Lock Tracing), LAG system (Latency At A Glance) analysis and proactive alerts tool.

•WEB DEVELOPMENT: IIS/ASP, VBScript, JavaScript, HTML, XML, .NET.

•BUSINESS INTELLIGENCE (BI)/REPORTING: SSRS (SQL Server Reporting Services), Business Objects, Cognos, Data Warehousing (DW) Architecture and Implementation, Dashboards, ETL (Talend, SSIS), Power BI.

EXPERIENCE

SR. DBA/SQL PERFORMANCE ANALYST

WNS - HealthHelp, LLC. · Full-time (Houston, TX)

October 10, 2020 – December 31, 2024

•Healthcare environment: Day to day T-SQL Code reviews; DBA, DevOps, Server and Query Performance Analysis, and Query Optimization (including code refactoring).

•Monitoring operational and Business Intelligence data loads, Replication, AAG, BI processes, and performance/behavior of Production SQL Servers, including Operational Analytics and development of proactive alerting both programmed in T-SQL as proprietary solutions and using third party tools such as App Dynamics.

•Designed and developed enterprise-wide proactive alerting system named LAG (Load-At-A-Glance) allowing to promptly evaluate rapidly escalating workload and server bottlenecks at the early stages of their escalation (before any latencies are reported by global end-users).

•Developed hands-on (~25%+ time) and re-factored Stored Procedures (targeting performance improvement to meet clients’ SLAs). Disaster Recovery (DR) testing; Database Servers High Availability/ALWAYS-ON: testing and troubleshooting.

SQL SERVER DBA/DEVELOPER

GUARDIAN LIFE INSURANCE COMPANY · (via PRI TECHNOLOGIES) (OWINGS MILLS, MD)

October 2019 - October 2020

•As a part of 3 teams (DevOps, DBA, and SQL Development teams), performed a number of duties primarily related to troubleshooting production issues, creating SQL CPR (Custom Performance Repository) as a Base-lining and Monitoring solution targeted at Healthcare/Claim Adjudication business transactions and ETL loads (Brigdegate, SSIS). Power BI (introduced via POCs the PowerBI suite to the company first time).

•Involved into Solutions Architecture and re-design of existing projects as well as brainstorming and inception of the new initiatives. Data Modelling and Object Dependencies Analysis. Load and Process Troubleshooting.

•Database Development, Query Optimization, Administration of SQL Servers; Monitoring tools (App Dynamics, Footlight, Zenoss, Analysis of Production failures and Deployments (DevOps team). Post-migration testing; SSIS/SSRS/ETL daily support.

SQL, MS Access, and Oracle Architect

IRON MOUNTAIN (COLLEGEVILLE, PA) (SQL Experts, LLC. and Beacon Hill Technologies)

11/2017-10/2019

•Created a powerful Proof of Concept (POC) and implementation for migrating 2 databases to Azure/Cloud environment.

•Co-designed a Commissioning System for UK sales representatives of the company based on the US System for commissions issuance to sales representatives as a part of a larger solutions coalesced with Sales Force system.

•Analysis and re-design of VB 6 and MS ACCESS based applications to .NET and SQL Server environment.

DBA/DATABASE PROGRAMMER

COTIVITI HEALTHCARE, (CONSHOHOCKEN, PA) (via Randstad Technologies)

3/2017-10/2017

•As a part of the CMS Government Engineering group within Cotiviti Healthcare(formerly Connolly) Health care and as a Business Intelligence and Performance Analyst with strong knowledge of T-SQL and Data Analysis -- investigated, troubleshooted, and proposed solutions to production issues that cause slowdown of major overnight ETL processes. Via fine-tuning SQL Server configuration options, indexing, and re-writing essential blocks of T-SQL, I have achieved performance gain that can be quantified not only by seeing reduced I/O on the server but also via run-time (reduced from 15 to 8 hours overall duration of the overnight report building process.)

•Setup, Tuned, and tested the first SSRS environment in the company, and supervised and developed and the first suite of SSRS reports in the company (using certain prototypes of reports formerly developed in MS Access and Excel yet scalability requirements called for a different, more robust environment like SSRS and/or Business Objects.

SQL SERVER BI DEVELOPER/DW DBA

STATE OF DELAWARE, (DOVER, DE), Department of Education

07/2014- 01/2017

•As a Business Intelligence Developer, Analyst, Database Problem Solver, and Data Warehouse DBA provided day to day input into maintaining Production and Development servers, as well as actively participate in SSRS and SSAS solutions in MS SQL Server 2008 R2 and 2012 Enterprise. Troubleshooting and improving ETL processes that refresh DE DEPARTMENT OF EDUCATION Databases (and subsequent DW) with the latest data from school districts across the State of Delaware.

•T-SQL code refactoring and testing as a part of daily support for the Student Education System servers. DR Documentation, DR/Failover within the Early Learning Education system Portal framework.

DATABASE CONSULTANT

CLIENT CSC (COMPANY SERVICES CORPORATION) via DIAMOND TECHNOLOGIES, INC. (WILMINGTON, DE)

11/2013 – 06/2014

•As Data Analyst, DBA, Performance Investigator, and SQL Developer/BI Developer closely collaborate with both Infrastructure and Development groups to identify and remediate major Database Server performance issues, particularly focusing on optimization and tuning of T-SQL within Stored Procedures and Functions that house the main business logic for the company’s most essential software products, primarily high-concurrency and high-volume web-based .NET and .Java applications.

EDUCATION

Dnipro State University and Kiev Technical University (Ukraine);

B.S. Degree in Information Science and Linguistics.

Special Talents and Abilities

Master Level Chess player and coach, Data Science and BI Concepts instructor;

Knowledge of 5 human (foreign) languages and ability to work with 6 programming languages;

Current/ON-GOING learninG

Python and Machine Learning; Artificial Intelligence/LLM theory and practice;

Python + SQL Server use cases;

New features of SQL Server 2019 and their further evolution in version 2022;

MS Visual Studio 2022 DATA TOOLS;

Azure managed databases; Azure Kubernetes Service (AKS).

EXAMPLE of my recent POC presentation:

to both non-technical and technical business analysts:

TEMPORAL TABLES: NEW FEATURE IN SQL SERVER 2016 (youtube.com)

(https://www.youtube.com/watch?v=6LUN543vnJI)

EXAMPLE of my recent WRITING AND CODING:

https://www.codeproject.com/Tips/5311874/Monitoring-SQL-Agent-with-Alerts-for-Long-Running

Contact this candidate