Uploaded File
Yuriy
levenyu@yahoo.com
904-657-8869
213 Beech Brook St
Fruit Cove, FL 32259
Software, SQL Developer, Database Administrator
32 years experience W2
07/25/2021
2
Recommendations
Average rating
227
Profile views
Summary

Software, SQL Developer, Database Administrator.

30+ years of experience in application and data development, testing, troubleshooting, support, and implementation. Substantial analytical and research skills, strong knowledge of technical specifications, documentation and work flow development according to all SDLC phases. High quality work under minimal provided supervision. Goal driven quick learner, who can promptly adapt to a new and diverse business environment.

DBA Skills:

RDBMS MS SQL Server 2014

Tools Visual Studio 2012/2013, IDERA SQL DM tool, Red Gate SQL Tool Belt, SQL Sentry Plan Explorer, Pragmatic Workbench with BI xPress.

OS/Servers Windows 2012 R2 on VMware

.NET Technical Skills:

Web Tools .NET 3.5/4.5 (Web & Windows Forms), .NET AJAX, Classic ASP, VBScript, JavaScript, HTML, XHTML, DHTML, CSS, XML, XSLT, jQuery

Languages C#, ASP.NET, Classic ASP, TSQL, SSIS, Visual Basic, CA Clipper, MS Access

Databases SQL Server 2014

App Tools Visual Studio 2012/2013

OS/Servers Windows7, IIS 6/7

Soft. Tools MS Office 2007/2010, MS Visio, Crystal Reports, VSS, PVCS, Visual SVN, Subversion, Tortoise SVN, Perforce, VPN, VNC, NUnit 2.5.x, TestDriven.NET, SnagIt, Version One

Experience
MS Database Administrator
Information Technology
Jan 2014 - present
  • Hybrid Database Administration with SSIS, SSRS, SSAS, Data Mirroring, Merge Replication, AlwaysOn AG for DR and CDC for DWH data processing.
  • SQL development – database design, creation and deployment of tables, views, triggers, stored procedures, functions, DB maintenance plans, SQL jobs, SSIS packages, extended events. Query tuning and performance troubleshooting.

Tools: Visual Studio 2012/2013, IDERA SQL DM tool, Red Gate SQL Tool Belt, SQL Sentry Plan Explorer, Pragmatic Workbench with BI xPress.

DBA SSIS SQL Visual Studio Workbench Triggers Stored Procedure Database Design Data Replication MS TFS Performance Tuning HADR SSRS SSAS
Remove Skill
.NET Developer
Information Technology
Aug 2011 - Jan 2014
  • Development and support of Web based business applications. Agile SDLC. MS .NET frameworks.
  • SQL development - creation and deployment of tables, views, triggers, stored procedures, functions.

Technology used: ASP.NET 3.5/4.0/4.5 (C#, Web/Win Forms), MS T-SQL (2014), .NET AJAX, LINQ, VB script, Java script, jQuery, HTML, CSS, XML, Visual Studio 2012/2013, Infragistics, TFS, Red Gate SQL Tool Belt, SQL Sentry Plan Explorer.

.NET Agile Methodology SDLC SQL Triggers Stored Procedure ASP.NET C# T-SQL AJAX LINQ VBScript JavaScript jQuery HTML CSS XML Visual Studio MS TFS Visual Basic Java
Remove Skill
References
Average Rating

1 recommendation
Software Developer
Information Technology
Feb 2011 - Aug 2011
  • Development and support of Web based business applications. Full SDLC. MS .NET frameworks.
  • ïSQL development - creation and deployment of tables, views, triggers, stored procedures, functions, jobs, DB maintenance plans, SSIS packages and ad-hoc scripts to be used in conjunction with Crystal Reports reporting engine.

Technology used: ASP.NET 2.0/3.5/4.0 (C#, Web Forms, SOAP Web Services), Transact SQL (SSMS 2000/2005/2008), .NET AJAX, VB script, Java script, jQuery, HTML, CSS, XML, XSLT, Classic ASP, Infragistics, Telerik controls, Crystal Reports.

.NET AJAX ASP.NET Crystal Reports CSS HTML JavaScript jQuery SQL Stored Procedure Triggers VBScript XML SOAP WebServices XSLT Visual Basic Java SSIS Web Forms
Remove Skill
Software Developer
Information Technology
Jul 2009 - Jan 2011
  • Development and support of Windows and Web based business applications, based on SQL Server and Oracle back end. Design, development, deployment and support of MCALMS Enterprise suite. SQL development - ad-hoc queries, tables, views, triggers, stored procedures, functions, SQL jobs, SSIS packages, DB maintenance plans.

Technology used: ASP.NET 3.5/4.0 (C#, Web Forms, SOAP Web Services), Transact SQL + SSIS (SSMS 2005/2008), .NET AJAX Extensions, .NET AJAX Toolkit, VB script, Java scripts, HTML, CSS, XML, Classic ASP, FTP, MS DOS and Windows scripts and command files.

.NET AJAX ASP.NET CSS FTP HTML MS DOS Oracle SQL SQL Server Stored Procedure Triggers VBScript Windows XML SOAP SSIS Visual Basic Java Web Forms
Remove Skill
Sr. Software Developer for B2B Mortgage Information Services (MIS)
Information Technology
Aug 2006 - Jul 2009
  • Skillfully designed, developed and supported multiple Web and Windows business applications and services of Retail Financial Services division of JPMorgan Chase such as Customer Management System, Business Planning Center, Electronic Referral Process, Account Executive Management Tool, Time Tracking and Compensation System, Contact Database, MI Billing etc.
  • Developed and implemented SQL Server jobs and DTS packages in order to provide various data feeds to business applications, used parameterization in order to optimize object’s performance and flexibility
  • Improved performance of supported applications by utilizing effective analysis of Execution Plans of SQL objects on SQL Server side
  • Analyzed, researched and enhanced legacy programs (Classic ASP, VB and MS Access) to increase their maximum operating efficiency. Converted them (e.g. HUD Case Query, Client Roster etc.) to .NET and SQL Server business solutions
  • Designed, analyzed and developed various business reporting solutions for different corporate units via Chase MIS Report Management System
  • Provided assistance and training to end users and technical support staff for newly developed and deployed applications
  • Delivered fast and successful resolution to multiple production issues that could otherwise lead to a financial impact

Technology used: .NET (C#, Web Forms, SOAP Web Services), TSQL (SSMS 2000/2005), Classic ASP, VB script & Java script, HTML, CSS, XML, FTP, Crystal Reports, Windows and MS DOS batch scripts

.NET Analysis Crystal Reports CSS HTML JavaScript MS Access MS DOS SOAP SQL SQL Server Technical Support Training VBScript Windows XML Visual Basic Java Web Forms
Remove Skill
Sr. Technology Analyst for Chase Home Finance
Information Technology
Oct 1997 - Aug 2006
  • Maintained Chase Wholesale Mortgage Loan Origination System (LINCS) used by multiple branches nationwide
  • Performed effective UI design/re-design, business logic/formula adjustments, Welcome and Closing document updates (VMP and Chase Compliance), funding check update, performance enhancement and debugging to keep LINCS running at the peak of its performance
  • Successfully developed and implemented front and back end of an import/export process of data exchange data between LINCS and Web/SQL based application
  • Analyzed, added and updated mortgage products such as Interest Only, ARM’s and Fixed, major/market types, loan purposes, document types, fees, discount points, FNMA/FHLMC limits, buy-downs and PMI
  • Managed and designed utilities to feed and report loan data to Servicing and Enterprise Data Warehouse (EDW)
  • Analyzed BRD and participated in the process of creating programming SPEC
  • Efficiently used VSS and PVCS tools for version control of source code, libraries, link scripts, make files, build batch files, documents and data tables
  • Programmed test scripts and cases, performed unit testing
  • Created extensive technical documentation, developed and supervised test procedures during UAT
  • Delivered system support to users and end-point support to help desk personnel

Technology used: CA Clipper (v. 5.2), DBASE III, MS DOS batch scripts, FTP scripts, Classic ASP, VB script & Java script, HTML, CSS, XML, TSQL, .NET (C#)

UI SQL Data Warehousing VSS Test Case Preparation Unit Testing Documentation UAT Clipper MS DOS FTP VBScript JavaScript HTML CSS .NET C# T-SQL BRD Compliance
Remove Skill
IT Team Lead
Information Technology
Sep 1989 - Apr 1997
  • Maintained legacy applications, managed new projects and was promoted to Team lead
  • Increased efficiency of SDLC phases by implementing standardized SPEC
  • Improved effectiveness of inter-department application’s connectivity by using network compliant programming approach
  • Architected several accounting, statistical and field specific applications
  • Improved speed of General Ledger processing by utilizing new RDBMS and programming languages
  • Converted front and back end of legacy systems to the up-to-date network configuration
  • Designed and implemented 2D graphical image based application interface to analyze distribution of electrical energy within a region, which improved the quality of control over energy distribution and its effective troubleshooting

Technology used: Pascal, Visual FoxPro, CA Clipper (v. 5.2), DBASE III, MS DOS batch scripts, FTP scripts

Clipper DB2 SDLC RDBMS Pascal FoxPro MS DOS FTP
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Computer Science and Automation of Technological Processes
South-Kazakhstan University of Technology
Attended in Java Programmer and OOP Diploma
Penn Foster College
Related Courses
HADR Availability Groups, 2016 A
Skills
MS DOS
2011
20
SQL
2021
19
FTP
2011
17
.NET
2014
16
Clipper
2006
16
CSS
2014
16
HTML
2014
16
VBScript
2014
16
JavaScript
2014
14
C#
2014
11
T-SQL
2014
11
SDLC
2014
10
BRD
2006
9
Compliance
2006
9
Data Warehousing
2006
8
Documentation
2006
8
Java
2014
8
Test Case Preparation
2006
8
UAT
2006
8
UI
2006
8
Unit Testing
2006
8
VSS
2006
8
DB2
1997
7
FoxPro
1997
7
Pascal
1997
7
RDBMS
1997
7
Stored Procedure
2021
7
Triggers
2021
7
Visual Basic
2014
7
XML
2014
7
T-SQL Developer
2017
1
MS TFS
2021
5
Visual Studio
2021
5
Web Forms
2011
5
AJAX
2014
4
ASP.NET
2014
4
SOAP
2011
4
SQL Server
2011
4
SSIS
2021
4
Windows
2011
4
Business Requirements
2015
1
System Analysis
2015
1
WinForms
2013
1
Crystal Reports
2011
3
Data Replication
2021
3
Database Design
2021
3
DBA
2021
3
HADR
2021
3
Performance Tuning
2021
3
SSAS
2021
3
SSRS
2021
3
Workbench
2021
3
Agile Methodology
2014
2
Analysis
2009
2
jQuery
2014
2
LINQ
2014
2
MS Access
2009
2
Technical Support
2009
2
Training
2009
2
Oracle
2011
1
DHTML
0
1
IIS
2011
1
MS Visio
2011
1
Solutions Architecture
1997
1
SQL Developer
0
1
SVN
2011
1
Technical Specifications
0
1
VB.NET
0
1
VMWare
0
1
VPN
0
1
WebServices
2011
1
XSLT
2011
1
Languages
English, Fluent/Bilingual
Russian, Fluent/Bilingual