Support Sql

ALEX BECHUTSKY

ORACLE PROGRAMMER ANALYST

C: 301-***-****

ac1v8q@r.postjobfree.com

U.S.

Qualifications Summary

Mr. Bechutsky has 18 years of expertise in Oracle 11g, PL/SQL, Oracle Forms, Oracle Reports, SQL* Plus, TOAD, HTML DB, and Java Server Pages (JSP). He has expertise in PL/SQL Optimization and has worked in both Windows and UNIX environments. Mr. Bechutsky participates in the full system development life-cycle including design, analysis, coding, testing, implementation, and support in client/server and web environment architectures. Mr. Bechutsky is an expert PL/SQL programmer, coding packages, procedures, and functions using latest PL/SQL features and optimization. He is exceptionally skilled at designing Oracle Forms and Oracle Reports.

Designed process of development the documents in MS Word format using ASP.NET, C#, and Aspose third party tool.

As part of these efforts, he prepares test scripts, adheres to recent guidelines, and provides related documentation. He has excellent communication skills and knowledge of SEI CMMI Level 2.

Work Experience

CACI International Inc. 11/07 - Present

Programmer Analyst

Participates in the full system development life-cycle including designing, analysis, coding, testing, implementation, and support in the client/server environment architectures for the number of projects. Writes PL/SQL packages, procedures, and functions using latest PL/SQL features. Optimizes PL/SQL packages and SQL statements. Designs number of Oracle forms and reports. Revised code according to client’s development guidelines. Prepared the test scripts and documentation. Used Oracle 11g, PL/SQL, SQL* Plus, TOAD, Oracle Forms 11 and Reports 11.

Participates in development and support of Resource Management Decision (RMD) applications for the client from 11/2007 to Present.

Lead the conversion of RMD applications into .NET client including conversion of Oracle Forms PL/SQL into packages to support .NET.

Participates in development and support of Financial Summary Tables Reporting System for the client from 11/2007 to Present.

Participates in development and support of Corporate Information Systems (CIS) modules for client from 11/2007 to Present.

SI International 05/06 – 11/07

System Programmer

Participated in the full system development life-cycle including designing, analysis, coding, testing, implementation, and support in the client/server environment architectures for the number of projects for the Census Bureau such as Time and Attendance, Education and Training Informational System, Employee Interface, Cost Activity Reporting System, Jeffersonville Activity Reporting System. Wrote dozens of PL/SQL packages and SQL reports using latest PL/SQL features. Optimized PL/SQL packages and SQL statements. Designed number of Oracle forms and reports. Revised code according to client’s development guidelines. Created various DB objects and prepared deliverable scripts. Prepared the test scripts and documentation. Used Oracle 9i, PL/SQL, SQL* Plus, TOAD, Oracle Forms and Reports 6.0. System Programmer.

SYSTALEX Corporation 08/99 – 05/06

CAMS Support Center, U.S. Department of Commerce

System Engineer

Participated in the full system development life-cycle including designing, analysis, coding, testing, implementation, and support in the client/server environment architectures for the number of projects for the Department of Commerce, such as Accounts Receivables, Quarter Closing, General Ledger Reporting, and Summary Level Transfer, Technical Migration project.

Gathered functional requirements and created prototypes. Designed number of Oracle forms and reports. Optimized the code, applied database security, and table partitioning using Oracle 9i new features. Developed the CRS (CFS Reporting System) Extract File Generation applications. This wizard-like GUI application provided the capability to extract financial data to be submitted on a monthly basis to the SAS/CRS to display it in the DOC CRS Secretary's View in the SAS Portal.

Created the Budget and Expenditures (B&E) reporting application, which allowed user to query budget data on any (or multiple) portions of the accounting code, and then drill down from the query results all the way to the document and item levels. Migrated CFS applications from Oracle 8i to Oracle 9i. Wrote technical documentation, including Detail Designs, User Manuals, Data Dictionary, and Testing Plans. Participated in preparing application Demo and User Training documentation for clients. Provided the customer support for Census, EDA, NOAA, and NIST users. Used PL/SQL, SQL* Plus for Oracle 9i and 10g, TOAD, SQL optimization, database security, and table partitioning, Oracle Forms and Reports 6.0 and 10g. Provided recommendations for various technical issues and application testing of CFS applications for Web Migration prototype conversion from Oracle Forms 6i to 10g.

R.O.W. Sciences, Inc 10/98 to 08/99

Software Engineer

Worked on the system full-life cycle development including designing, analysis, coding, testing, implementation, and support in the client/server and thin client in WEB environment architectures of Research Grants Award System. Designed and developed Assignment Tracking System (ATS) and Public Affairs Reporting Information System (PAIRS) - support management reporting applications. Participated in the design of the database and prepared the scripts to create various DB objects. Developed end-user transactional and reporting screens and reports. Used Oracle 7/8, SQL*Plus, Developer 2000 (Forms 6i, Reports 2.5), PL/SQL, SQL, TOAD.

Education

Bachelor's Degree – Mechanical Engineering

Kiev Inst. of Auto-Road Machineries, 1986

Clearance

SECRET

Awards and Honors

OUSD Controller numerous letters of recognition for development and continues support of Resource Management Decision System applications, Financial Summary Tables Reporting, and

Corporate Information Systems modules.

United States Department of Commerce Certificate of Appreciation for contribution to the successful implementation of the Core Financial System of the Commerce Administrative Management System (CAMS) for NIST, NTIA, and TA.

United States Department of Commerce recognition letters for various projects.

Contact this candidate