Developer Oracle

Vitaly Mezheritsky

*** ****** ** **

Renton, WA, 98059

425-***-**** (home)

206-***-**** (cell, 24x7)

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

QUALIFICATIONS:

. Strong experience in Oracle 10g, SQL, PL/SQL, SQL Plus, SQL Navigator,

SQL Developer, TOAD, Unix, Korn Shell

. Experience in Queries Performance Tuning, Very Large Tables and

Datasets, Data Dictionary maintenance, Partitioning, Data Pump,

Dynamic SQL, Stored Procedures, Packages, Functions, System Events and

Schema Triggers, SQL*Loader

. Strong problem solving and analytical skills

. Driven by hard work ethic and service excellence

. Customer oriented attitude and exemplary client relationship skills

. Proficient in focusing on details and meeting deadlines

. Enthusiasm to learn and driving desire to succeed

. Fast learner, Team player

EDUCATION AND TRAINING:

. University of Washington, Seattle, WA - Oracle 10g Applications

Development Certificate

. Cognos Training Services - Cognos 8 BI - Reports Authoring, SDK

. University of City of Lviv, Ukraine - BS in Mathematics

EXPERIENCE:

ORACLE DATABASE DEVELOPER,

Cortech LLC (Contract, VerizonWireless), Bellevue, WA (November, 2008 -

December, 2009)

ORACLE 10g, PL/SQL, SQL Navigator, Oracle SQL Developer, Unix, Korn Shell

. Developed Health Checks and Cleanup processes to synchronize and repair

data in three independent Oracle databases that support a MyBusiness

application - Siebel online account management . Participated in production

support, defect tickets resolution, and data errors fixes . Proposed

changes to one of the monthly data load processes and developed working

prototype using partition utilization to increase performance . Developed

changes to the daily incremental ETL process to include selected elements

on demand

ORACLE DATABASE DEVELOPER,

KForce Professional Staffing (Contract, AT&T Mobility, Data Mediation

Group),

Bothell, WA (January, 2008 - November, 2008)

ORACLE 10g, PL/SQL, TOAD, Oracle SQL Developer, Unix, Korn Shell

. Supported test environment for conversion projects by creating and

administering schemas,

objects, privileges . Worked on resolution of production software defect

tickets, issues, and support of existing code and errors fixes according to

specifications . Developed process to compress archived tables which

resulted in reduction of disk space consumption . Re-engineered Data

Mediation archive

process using DBMS_DATAPUMP . Streamlined and re-factored package for

automated handling of adding/removing daily partitions by following best

practices guidelines . Wrote shell scripts and PL/SQL procedures to query

and modify data in tables containing tens of millions of records per daily

partition .

Developed data upgrade scripts . During development of new code adhered to

coding standards suggested by Oracle best practices

ORACLE PL/SQL DEVELOPER,

iTechSolutions (Contract, Washington Mutual Bank), Seattle, WA (March, 2007

- January, 2008)

ORACLE 10g, PL/SQL, TOAD, Unix

. Supported existing implementation of Capital Market Research Group Data

Mart by handling multiple requests for ad hoc queries and analysis .

Developed PL/SQL procedures, functions, and triggers to query and modify

data in Oracle 10g database . Created and maintained packages, views,

partitioned tables and indexes, and performed other tasks as assigned .

Completed performance tuning of queries and procedures. . Created Unix

shell scripts . Performed basic database administration and maintenance

tasks . Participated in evaluation of Oracle Reports

Cognos REPORTS DEVELOPER,

CNSI, Rockville, MD (April, 2006 - March, 2007)

ORACLE 10g, PL/SQL, TOAD, Cognos ReportNet, Cognos Framework Manager

. Provided programming and business analysis support for the design,

development, testing, and implementation of Operational Reports for a

Washington State MMIS (Medicaid Management Information System) using Oracle

10g PL/SQL, TOAD, and Cognos tools . Created packages, stored procedures,

triggers, and functions, collaborated with customers and team members to

resolve technical and functional problems . Developed and implemented

simulation process to mimic future production environment to be used for

reports design . Proposed solution for reports delivery requirements using

Cognos SDK . Prepared functional and technical report requirement packages

to be used by team leads during reports design sessions with their state

counterparts

TECHNICAL CONSULTANT,

PTC, Needham, MA (May, 2005 - April, 2006)

JSP, Java Script, XML, Info*Engine

. Customized and integrated the Windchill Project Data Management

application for the Future Combat Systems program at Boeing . Developed and

altered several functionalities per client's requests for

application enhancements using JSP, Java Script, and InfoEngine

(proprietary tool for data retrieval from application database) . Installed

and configured PTC software. . Installed and configured requisite third

party software (ORACLE, LDAP, Retrieval Ware, etc.) as applicable to the

client's solutions

SENIOR CONSULTANT,

CGI, Montreal (formerly AMS, CGI-AMS, Fairfax, VA) (July, 2000 - May, 2005)

Oracle, PL/SQL, Cognos ReportNet, Cognos Framework Manager, VB, VB Script,

Java Script, ASP, HTML, XML

. Proposed, designed and developed enhancements to Cognos data model,

created stored procedures, functions, views; developed technical

requirements, solutions, and reports during implementation of AMS Advantage

ERP for Los Angeles County . Contributed to overall continued

standardization and consistency of approval processes and procedures by

proposing, gathering business requirements, and developing automated

Expense Report Approval Workflow . Proposed solution, completed business

analysis, and developed tool to provide disconnected option of recording

and uploading expenses to traveling users who may not have regular access

to the web in a cost effective, maintainable, and serviceable way (Xpense

Remote) . Identified functional requirements and developed Per Diem

functionality in full compliance with GSA code . Proposed solution,

validated the design with key stakeholders through design reviews and

developed Expense Adjustment Tool to initiate cost adjustments and balance

CFS data with data held in XMS database . Provided subject matter expertise

for engineering solutions during implementation process . Provided

production support through problem analysis and resolution to correct

deficiencies

CONSULTING ENGINEER,

Concur Technologies, Inc. Redmond, WA (December, 1997 - July, 2000)

ORACLE, PL/SQL, MS SQL, SYBASE, VB, VB Script, Java Script, ASP, HTML

. Analyzed client's requests, developed custom solutions, wrote technical

specifications and participated in implementation of custom solutions .

Completed on site functional specification refinement for custom

integration, and installation of custom code . Developed fully configurable

receipts dunning process.

. Developed solution for complex government and private sector business

requirements for several Fortune 500 companies . Developed unique solution

for large financial institution to comply with clients' internal report

routing and approval model . Proposed and developed solution for critical

implementation problem at largest XMS/Windows client . Developed

engineering patches for several critical base product issues . Provided

phone support for product and custom solution issues . Provided training

and technical assistance to partners and field consultants

PROGRAMMER ANALYST,

City University, Bellevue, WA (May, 1997 - November, 1997)

PROGRAMMER ANALYST, TAX DEVELOPER,

SCS/Compute - RIA Group, Bellevue, WA (March, 1995 - May, 1997)

PROGRAMMER ANALYST, TAX DEVELOPER,

ORRTAX Software, Bellevue, WA (September, 1994 - February, 1995)

Contact this candidate