Software Engineer Data

YEFIM SLAVIN

Brooklyn, NY ***** 917-***-**** mailto:*******@*****.***

*******@*****.***

linkedin.com/in/yefimSlavin

MS SQL BACKEND IT PROFESSIONAL

Dynamic and accomplished IT professional with extensive experience throughout the production process, including backend design, development, testing, deployment. Learns quickly and adapts to diverse technical requirements. Skilled in analyzing production issues, identifying root cause and remedying. Team player that collaborates with business users throughout development life cycle to deliver on objectives.

TECHNICAL SKILLS

• SME backend and data domain knowledge • MySQL

• BMC Control-M • SSIS, SSRS

• MS Windows Server 2014 • Atlassian Bitbucket

• Microsoft SQL Server Management Studio • FileZilla

• Reflection Desktop Pro • Jenkins

• Tortoise SVN, GIT • JIRA

EXPERIENCE

JP Morgan Chase, New York, NY May 1994 – May 2019

Software Engineer, May 2007 – May 2019

Designed, built, tested, and deployed database changes and logic to support the backend for proprietary applications.

Developed error free database objects such as tables, indexes, stored procedures, views, triggers to support existing and new applications.

Used MS SQL to support both web backend and batch process.

Researched data to identified opportunities to improve database response time.

Tuned SQL statements based on query plans, designed and implemented the correct indexes to achieve optimal SQL performance.

Created and supported daily data integrity scripts for Operation Team to streamline maintenance.

Created numerous reports for business users’ ad-hoc requests.

Used the different Control-M products to create, schedule and maintain batch jobs running on SQL server.

To speed up the ETL process…used MS batch objects in conjunction with Control-M such as batch (.BAT), format (.FMT) and SQL (.SQL) files

To speed up the ETL process … created numerous BCP statements to transfer data from database objects to generate flat files on the MS server folders as well as upload them back from files to database.

Used the database knowledge to most efficient QA application changes.

Promoted database changes to DEV/UAT/Prod environments using latest Autopilot application, JENKINS.

Used SVN and GIT/Bitbacket systems to store all database and batch changes.

Leveraged JIRA technology to identify application problems and resolve them.

Worked closely with business users to design, build and deploy theirs requests to improve data flow.

EDUCATION

Master’s Degree (MS), Railroad Automation

Moscow Railroad University, Moscow, Russia

Contact this candidate