Nikolay Shanin

SQL Developer

Sandy, UT *****

adalmb@r.postjobfree.com

801-***-****

Experience in SQL Server migration, ETL, web development, and database administration. Strong full project life cycle knowledge. Effective problem solving skills and proven ability to work in both independent and team-based environments.

Authorized to work in the US for any employer

Work Experience

Operations Engineer - Database

Galileo Financial Technologies - Salt Lake City, UT November 2017 to Present

Led the on-call and change window rotations, monitored application performance and failures with Splunk. Handled outages and issues related to card processing operations in a PCI environment. Led a project to automate product setup tasks and audit the database. Mentored junior colleagues and met deadlines on over 50 client requests and issues per week. Identified issues with data and applications, designed reporting tools and scripts. Organized the team's workload, led quality initiatives, advised client-facing teams. MySQL Application Developer

SMW Refrigeration & Heating - Tempe, AZ

December 2015 to September 2017

Built PHP apps for ETL, payroll, maps, segmentation, estimates, invoicing, data cleanup, etc. Streamlined and enhanced the corporate accounting and operations system. Built custom CRM integrations which fed data from MySQL to SQL Server and vice versa. The new systems dramatically improved the efficiency of telemarketers, technicians, and office workers at SMW and other HVAC shops.

SQL Server Database Manager

Pearson - Chandler, AZ

December 2015 to November 2016

Worked with a DBA on a critical Windows Server and SQL Server migration. Installed and upgraded SSRS/SSIS, optimized stored procedures, responsible for daily reporting and DBA tasks.

Worked alone to optimize T-SQL transformations for datasets with >100MM records. Built the customer engagement SSAS cube and migrated this customer data to SalesForce. Solely responsible for daily tasks, server problems, and successfully automating all existing SSIS jobs and producing their documentation.

Senior SQL Server Consultant

CVS Health - Scottsdale, AZ

April 2012 to February 2015

Wrote ETL and reporting solutions for audits, end-to-end reporting, data processing, and executive metrics.

Submitted over 20 issue logs for systems integration testing and led the implementation of break-fixes and workarounds for my team's data extract from the Facets system. Deployed jobs, corrected production failures, and was accountable for the full life-cycle of four business-critical projects, including the first end-to-end monitoring solution for the client “NEJE”. The end-to-end visibility yielded major results: keeping the client's business during the CMS Sanction, pinpointing several process failures, stopping executive-level escalations, reduced manual effort, etc. Wrote over 100 business requirements documents and participated in database modeling and design discussions. Wrote concise documentation and work instructions. Education

B.S. in Biochemistry

Arizona State University

2017

A.S. in General Studies

Utah State University

Skills

SQL, T-SQL, Oracle, Crystal Reports, SSIS, SSRS, SSAS, Visual Studio, TFS, C#, VB.NET, ASP.NET, MVC, Sharepoint, JavaScript, PHP, jQuery, Linux, SalesForce, Python, RabbitMQ, NoSQL, Docker, JIRA, Process Improvement, Linux

Additional Information

SQL Expert Certification from Oracle Corporation, January 2011

Contact this candidate