Project Development

*** ***** **** . ********, **, *****

Phone 847-***-**** . E-mail abjnsy@r.postjobfree.com

Vadim Sakhray

Professional Skills

Solid experience in all phases of software development life cycle (SDLC)

Skilled systems analyst focused on development, testing, maintenance,

implementation, application support and version control

Strong technical knowledge writing and supporting applications in a multi-platform

environment

Deep technical knowledge of client-server/N-tier and ETL environments

Working knowledge of a variety of relational DBMS products, with 15 years experience

in designing and programming relational databases including Oracle, Sybase and MS

SQL Server.

Solid experience in Unit testing, Integration testing, Functional testing,

Regression testing, User Acceptance testing

Experience in leading teams of developers (on site and off-shore), mentoring and

providing technical expertise to programmers

Participated well within a team and worked diligently to share skills and

information with other team members.

Experience in project management, project issue resolution, facilitating project

needs.

Demonstrated success in both consulting and corporate environments to improve

business capability to achieve increased profit, reduced cost, and increased

service level

Able to learn very quickly and apply new skills to existing problems.

DATABASE/Hardware/Operating Systems

Oracle(9/10/11), MS SQL Server(2000/2005/2008), DB2, Sybase, Access

IBM PC: MS DOS/Windows/95/2000/NT/XP/Vista/7

IBM Mainframe

UNIX (AIX)

SOFTware/LANGUAGES

DataStage, PowerBuilder, Visual Basic, SQL, PL/SQL, SQL*Plus, Toad, Shell scripting,

IBM MQ Series, GTM, ObjectStar, Cognos, IBM RAD 7, WebSphere, Java, JavaScript,

J2EE, ERWin, HTML, XML, Visio, Lotus Notes, MS Office(Excel, Word, Project), PVCS,

MKS, Citrix, Atlassian tools

Testing Tool

Mercury Test Director, Mercury Quality Center

Professional experience

05/06 - 09/10 Walgreens Deerfield, IL

Sr. Programmer Analyst

Analysis, design, development, testing and implementation of Pharmacy Benefits

Management (PBM) Application (PDE).

PDE Application generates reports for its Part D clients and transmits them to the

Center for Medicare and Medicaid Services (CMS) for payment calculation and

reconciliation. The system utilized a multi-platform environment (Oracle 11g, UNIX,

Shell scripting, PL/SQL, DataStage 8.01, Java, J2EE, PowerBuilder 9.0, IBM

Mainframe, MVS, Windows XP). PDE application is allowing representatives from the

MedOps department to perform activities (inquiry and update information) related to

PDE record contains prescription drug cost and payment data that will enable CMS to

make payments to Plans. The PDE record include covered drug costs above and below

the out-of-pocket threshold, distinguish enhanced alternative costs from the cost of

drugs provided under the standard benefit and will record payments made by Part D

sponsors (Plans), other payers, and by or on behalf of the beneficiaries.

Identify and implement opportunities to reduce problems and optimize support.

Responsible for production support (24/7), providing effective and preventive

solutions to production problems and immediate remedies during on call hours.

Analysis, design, development, testing and implementation of Claim Solution

Archiving Application.

Archiving Application utilizes a multi-platform environment (Oracle, UNIX, Shell

scripting, Datastage8.01, Java, J2EE, Database Xtender provided by EMC/OuterBay).

05/01 - 05/06 HSBC- North America Wood Dale, IL

Sr. Business Analyst

Participated in the full software development life cycle

Gathered user requirements, performed analysis, design, development, testing and

implementation of Collection Automated Front End Application (CAF ). The system

utilized a client-server (n-tier) in a multi-platform environment (PowerBuilder,

PFC, IBM MQ Series, IBM Mainframe, Cobol, MVS, Oracle, DB2, Windows XP, Lotus Notes,

Citrix, and Concerto Dialers). CAFE application is allowing representatives from the

Collections departments to perform collections activities (inquiry and update

information) related to Credit cards, Retail services, Auto loans and Consumer

lending products.

Customization and implementation of CAFE application throughout the world (US,

Canada, England, Australia).

Developed project timelines, insured project issue resolution, and facilitated

project needs.

Accountable for application quarterly releases. Responsible for application and code

version control (PVCS, MKS).

Lead small team of developers (offshore), mentoring and providing technical advice

to programmers.

Participated in production support (24/7), providing effective and preventive

solutions to production problems and immediate remedies during on call hours.

Participated in disaster recovery and yearly compliance tests.

Wrote SQL stored procedures for Caf application.

03/00 - 05/01 General Service Administration Chicago, IL

Consultant

Member of development team to rewrite PICS (Product Information and Communication

System). PICS is used by the General Service Administration, part of US Government's

Federal Supply Service, to maintain product catalog data in various federal offices

around the US and Europe. The system utilized a PowerBuilder (PFC) front-end and

Sybase Adaptive Server Enterprise 11.9 back-end. Analysis, design, development,

testing and implementation. Wrote SQL stored procedures, triggers and views.

Added user interface to create and load a product information summary into a web

page. The program extracts data from the database and dynamically created a HTML

file around the extracted data.

System analysis to re-engineer, development, testing and implementation of CD-ROM

based product catalog database, catalog browser, and product order entry system.

This application was to be distributed on a CD-ROM to various customers throughout

the world (Continental US, Hawaii, Alaska, and Europe) including US navy ships at

the sea. The application could also assimilate product update data (such as price,

stock availability, etc.) via an update file download from the Internet. Orders can

be printed and faxed or attached to emails and submitted electronically.

01/00 - 02/00 BlueCross BlueShield Association Chicago, IL

Consultant

Design, development, testing and implementation of the "Blue Card System" utilizing

Client/Server technology (MS Server 2000, PowerBuilder). Performed extensive

debugging and troubleshooting. Identified and resolved production support issues.

06/99 - 11/99 Discovery International Deerfield, IL

Consultant

Development, testing and implementation of the "Discovery International Management

System" utilizing Client/Server technology (Sybase, PowerBuilder). Gathering of

users requirements. Wrote SQL stored procedures.

Performed extensive debugging and troubleshooting. Developed application that

allowed customers to create ad hoc reports. Participated in production support.

Identified and resolved production support issues.

06/98 - 05/99 BP AMOCO Chicago, IL

Sr. Programmer/Analyst

Design, development and implementation of the "Information Technology Enterprise

Asset Management System" utilizing Client/Server technology (Oracle, PowerBuilder,

PFC). The project was to create a data repository for all assets within Amoco's

enterprise-wide computing environment. Responsible for gathering user requirements.

Data modeling. Extensive debugging and troubleshooting. Created reports (Access)

that allows customers to create ad hoc reports. Responsible for system security.

04/97 - 06/98 KEMPER Long Grove, IL

Programmer/Analyst

Design, development and implementation of the Kemper Billing System, utilizing

Client/Server Multi-tier technology (ObjectStar, PowerBuilder, Cognos). KBS offered

flexible payment plans, supports multi-policy accounts and different line of

business, provides GUI screens for users (agents, financials and collections

offices).

Data modeling. Extensive debugging and troubleshooting. Involved in creation of KBS

and customer reports that allow customers to create ad hoc reports. Wrote utilities

to manipulate data for system testing. Responsible for system security.

09/95 - 04/97 ENESCO Corporation Itasca, IL

Programmer/Analyst

Design, development, maintenance and implementation of on-line multimillion-dollar

catalog order processing system (PowerBuilder, Sybase). The system had remote

communication capabilities for 500 sales representatives. The system consisted of a

browsing part and actual order processing, including customer invoice generation and

acknowledgement of orders and generating account payable transactions and

manufacturing work orders.

Data modeling and design of the relational databases. Programmed SQL queries.

EDUCATION

DataStage Training, IBM Corporation, Deerfield, IL

Managing IT Project Training,The George Washington University, Schaumburg, IL

Java Training, Learning Tree Corporation, Schaumburg, IL

Oracle Training, Oracle Corporation, Chicago, IL

PL/SQL Training, Oracle Corporation, Chicago, IL

PowerBuilder Training, Sybase Corporation, Chicago, IL

CAD certificate, Oakton Community College, Des Plaines, IL

MS Electrical Engineering, Belarusian National Technical University, Minsk, Belarus

References

US Citizen. Reference available upon request.

Contact this candidate