Yuri Zelepukin

** ********* *** ********* ********, NJ 08550 adlz3l@r.postjobfree.com 732-***-****

Summary of qualifications

Extensive Experience in the data processing and analysis. Specializing in

design, development, testing, implementation and maintenance of database applications

for Oracle, Sql Server, MySql, Postgres, Aurora, MongoDB. Experienced in performance tuning of

SQL applications for large databases. High interest in the area of object-oriented

development, cloud applications and Innovations. Very creative and responsible worker.

Would enjoy being part of a development team. Experienced in completing individual

projects as well.

Technical experience

Database Systems: Oracle, MySql, Aurora Db, PostgreSql, MongoDB, CouchBase,

Redis, MS Sql Server.

Programming Languages: SQL, N1QL, PL/SQL, Java, JavaScript, Perl, Python, Shells,

Pro*C, C/C++, HTML, JSON, LDAP

Tools: Toad, AWS, Sql Developer, MySql Workbench, Sql*Plus, PGadmin, Robomongo,

MongoChef, SVN, Github, Content Management System, Jira, Eclipse, VmWare,

Jenkins, Cucumber,SSRS,Vault, OpenDJ, Docker, CentOS, Ubuntu, Track,VirtualBox.Jira, Bitbucket, Horizon.

Professional experience

VP-Software Engineer II at Bank of America Pennington, NJ 12/2017-Now

Participated in Team CICD Pipeline design for changing the deployment process from SVN/DMA to Bitbucket and Ansible Tower with Radical

Worked on Multiple data feeds for Internal and External Vendors from Global HR Referential Data Repository Database Oracle 12c.

Involved in Data Base migration from Oracle 11 to Oracle 12c

Involved in full lifecycle of Design, Development Testing, Implementing and support for Database Changes on Monthly Releases

Developer on Employee Survey Data Feed to Qualtrics Vendor from Global HR Oracle 12c Database

Onboarding Team member. Helped Applications to onboarding process to HR Referential Repository Database

Designed Oracle Materialized View for performance improvement of Mulesoft Worker API

Designed data feeds for new Vendors.

Wrote HLD and LLD Design Documents for new projects.

Changed PL/SQL package code to improve rights revocation for terminated

users.

Assisted users with access requests

Designed Autosys jobs to process data feeds and access revocation requests

Designed data feed for India employee transportation vendor change.

Assisted production support with fixing Production issues.

Contractor - AAA Mid Atlantic Wilmington, DE (remote) 8-12/2017 (4mo)

MS SQL Server 14, SSRS, SSIS, SSMS, MS Visual Studio 14, Windows NT Server

Mapped the data values based on Requirements from AAA Mid-Atlantic Data Warehouse for 12 different charts.

Designed Multiple SQL queries, views, tables and T-Sql Procedures

Designed Master reports in SSRS and VS14 combining 12 metric sub-reports with option of AAA station change as a parameter for Mid-Atlantic Region

Worked on performance of the Queries, Presented the final master report to the Business.

· Scheduled night procedure to recalculate the daily stages.

· Involved in converting Master report from SSRS/MS VS14 to Python.

NoSql Developer Adara Networks San Jose, CA (remote) 7-8/2017 (2mo)

Oracle 12c Installed and Configured replication to Kafka with Golden Gate 12.2.

Configured CouchBase with OpenDJ over LDAP.

Configured Vault backend with Consul.

Installed Oracle 11g and 12c on CentOS 7, configured for replication.

· Worked remotely under hard deadline and multitasking

Database Developer III at Vonage Holmdel, NJ 6/2006-6/2017 (11 Years)

Tuned up query performance with Materialized View Logs.

Investigated and fixed variety of production issues for Oracle and MySql Dbs.

Designed scripts, procedures, packages, triggers for Oracle and Mysql.

Created highly available Aurora DB instances in Amazon Web Services(AWS).

Configured Security Groups and VPC Peering for Aurora DBs and EC2 cluster.

Created new Rate plans and promotions using Content Management System.

Developed scripts for MongoDB collection changes.

Agile and Devops development team member

Used SVN and GitHub to commit all code changes.

Used Jira and Trac for release tickets and Wiki, Confluence for documentation.

Worked with Redis and Memcached hashes.

Used Eclipse to build Java projects using Maven on Ubuntu.

Improved performance of queries in PostgreSql and Ms Sql Server.

Participated in test automation project using Jenkins and Cucumber on VmWare.

Provided Night support for production deployments.

Synced up all Oracle and Mysql db environments to maintain data quality.

Involved in performance tune up project based on AWR RAC report.

Team member on MySql 4 to Oracle 11.2 and Oracle 9i to 11.2 upgrade

projects.

Worked on Vonage World, Mobile, Extensions, No StartUp Cost, Refer a Friend.

Worked on Database remediation project to improve data quality and security.

Participated in Company Innovations Creative KickBox project.

Tested Python Application on Tornado Web Server for Nexmo voice API.

Participated in Device Inventory Automation and address validation projects.

Created new Users, tables, tracing sessions, submitting Oracle Jobs.

Peer Recognition Awards for 2012 and 2013, Employee of the month award.

Awards for participating in Vonage World, Extensions, Vonage Mobile projects.

Worked as a Volunteer at NJ Shore to help Sandy affected families.

Consultant at AT&T Bedminster, NJ 09/2005-06/2006 (9 mo.)

Supported production process for Networking Exchange project.

Wrote PL/Sql for new members activations, merged data from different sources.

Generated mailing and calling lists with PL/SQL and Shell scripts

Wrote and tuned Ad hoc queries from Marketing Data Warehouse for business.

Specialized in addresses and name parsing, address correction software.

Consultant at Merck & Co. Whitehouse Station, NJ 10/2003-09/2005 (12 mo.)

Changed, and unit tested the views of financial reporting system.

Added changes in ETL process for Capital and Fixed assets Data Warehouse.

Changed and Unit tested Load packages of the ETL process.

Changed PL/SQL, Pro*C for worldwide product cost - sales analysis system

Changed Pro*C for Third party transactions into Global Repository database.

Changed PL/SQL for Local Repository Sales and Inventory processing system.

Was part of the team for moving applications from Oracle 8i to Oracle 9i.

Programmer at Civic Development Group. Edison, NJ 08/1998 -09/2003 (5 Years)

Designed Pro*C and PL/SQL code to improve data quality.

Utilized USPS address correction tool PostalSoft to improve address quality.

Created Pro*C applications for processing phones area code changes updates

Wrote PL/SQL counts collection grid for many different counts from Oracle 8i

Wrote Pro*C program using MS Visual C++ environment to prepare addresses.

Designed changes for lists generator on Developer 2000 / Oracle Forms 4.5.

Education

Bauman State Technical University. (Moscow, Russia)

M.S. Degree in Mechanical Engineering.

Certifications: PL/SQL - Brainbench, 2013

Contact this candidate