NICK VALTCHEV

Rochester Hills MI

adczis@r.postjobfree.com

248-***-****

Summary of Qualifications

Planning, installing, and configuring instances, data warehouse design, implementation and normalization/de-normalization in the ETL process given schema requirements, working with metadata, creating SSIS projects to automate various database requirements, auditing data to meet data-integrity levels, implementing and optimizing indexes appropriately to increase data-retrieval efficiencies given database environments, debugging code to locate culprits in various processes, designing end-user friendly data-retrieval solutions with graphical capabilities, and high proficiency with general database administrative tasks.

Technical Skills

Databases: Microsoft SQL Server 2012-2016, MySQL, Azure SQL Server

Operating Systems: Windows 7, 8, 10, Windows Server 2012 R2, Windows Server 2016, Ubuntu, ESXi 6.0.

Languages: C#, T-SQL, XML, Windows PowerShell, CSS, HTML, JavaScript

Business Intelligence:

Microsoft Office Suite (Excel, Access, Word, PowerPoint, Outlook, Visio, SharePoint), SAS, Tableau, SSRS, SSAS, SSIS, SSMS, Visual Studio, Oracle Hyperion, SAP Crystal Reports, Microsoft Power BI, JIRA, SVN

Professional Experience

US Medical Management, Troy, Michigan 10/2018– Current

Database Developer

•Creates ETL solutions using SSIS from multiple data sources (internal and external/ODBC) to numerous systems.

•Manages service desk tickets pertaining to database and web development issues.

•Creates SharePoint reports given user requirements in an agile environment.

•Participates in small and large sprint projects where collaboration with other developers and meeting deadlines are crucial factors for the success of the project.

•Debugs complex SSIS job failures containing many tasks/data flows and both SQL and C# scripts.

•Handles some data integration to transfer health data in HL7 format both internally and externally using Rhapsody integration engine and converting it to relational data.

•Debugs T-SQL and C# code to resolve database and programming logic issues.

•Handles database design issues, performance issues, and data integrity issues.

•Creates custom internal applications using Windows forms to aid help desk in automation.

Nextep Systems, Troy, Michigan 04/2018– 10/2018

Database Administrator

•Handles and configures database security through Microsoft Azure.

•Data migration of databases from an on-premise server to Azure.

•Solves bugs in the software caused by T-SQL.

•Configures a report server off of Azure VM to point to live data.

•Handles internal and external user complaints relating to any aspect of databases.

•Tunes procedures and indexes, examines statistics, database locks, blocks, and deadlocks.

•Looks at high DTU (Database Transaction Unit) utilizing queries and tunes them to reduce resource utilization.

•Handles database backups, restores, and copies for all environments.

•Creates database geo-replications for possible future failovers.

•Maintains SSRS server and handles all tasks related to database reporting.

•Complete data encryption and encryption key management for healthcare databases to ensure HIPAA compliancy.

ChannelVantage Inc., Detroit, Michigan 04/2017– 04/2018

Data Consultant (contract)

•Provides data analytics, and business intelligence solutions to GM clients.

•Creates and maintains daily, weekly, monthly, and quarterly deliverables.

•Debugs procedures to find solutions and timely accommodate these solutions to meet client expectations.

•Performs testing of new products in different environments to ensure data integrity.

•Adjusts various database administrative tasks to further protect database integrity.

•Completes client ad-hoc requests on or before the requested timeframe.

•Works on front-end solutions to create a competitive product and incentivize further client business.

•Manages indexes and statistics for more efficient execution plans.

•Creates stored procedures, views, and user-defined functions to aid in database administration.

•Handles locks, blocks, and deadlocks to resources in databases when user complaints or alerts arise.

•Manages transaction logs and comes up with back-up strategies.

•Captures database activity with SQL Server Profiler and configures traces.

•Identifies bottlenecks by looking at disk usage, memory usage, and CPU usage.

•Creates jobs and alerts using SSIS and/or SQL Server Agent for front-end and administrative tasks.

United Shore, Troy, Michigan 01/2016– 03/2017

Data Analyst-Secondary Market

•Provides database support, maintenance, and data analytics to senior staff.

•Creates executive-level reports, examined directly by senior staff and CEO, using various methods (SSRS, Excel, Hyperion, SSMS).

•Intermediates ETL (SSIS) processes to data warehouse and examines data for anomalies.

•Performs database administration tasks such as query tuning, index management, solving concurrency issues, database backups/restores, and user complaints.

•Builds interactive reporting solutions for end-users using SSRS/Visual Studio.

•Creates business applications using stored procedures to aid in customer automation processes.

Ciber Inc., Southfield, Michigan 05/2015– 12/2015

Junior Business Systems Analyst (7 month contract)

•Provides quantitative and qualitative consultation on how best to attain maximum productivity by presenting economic and statistical concepts and ideas such as market structures, consumer theory, and central tendency.

•Employs statistical methods using SAS and SPSS and serves as a consultant on topics such as data analytics, descriptive statistics, inferential statistics, hypothesis testing, regression analyses, and analyses of variances.

•Develops SQL queries to organize and analyzes large datasets from relational databases and converts them into forms of reports, charts, and tables using Tableau, SAS, or Excel for easy comprehension.

•Communicates technical economic, statistical, and financial subjects clearly and concisely to individuals from different professional backgrounds. Provides actionable information to support various business functions. Consults with managers to determine the role of computer systems in the organization.

Digital Terrain, Livonia, Michigan 01/2013– 05/2015

Junior Business Analyst

•Worked as an intermediary between IT and stakeholders to facilitate efficient business operations.

•Designed and develops new systems by choosing and configuring hardware and software. Conducts testing to ensure the newly implemented systems work to their potential.

•Trained system’s end-users and writes simple instruction manuals for support.

•Completed marginal utility analyses to better understand and model consumer behavior, and formulates pricing and output recommendations.

•Increased productivity by analyzing statistical variances, recognizing patterns, trend analyses on data, and comparing the results to forecasted plans.

Education

Bachelor of Science, Economics – University of Michigan 2014

Certifications

MCSA (Microsoft Certified Solutions Associate) Certification in 70-461.

Contact this candidate