Andrei Zverev, M.SC.

ANDREI ZVEREV IS A SENIOR ORACLE DEVELOPER, ANALYST AND DATA ARCHITECT WITH

** ***** ** *********** ********** INDUSTRY EXPERIENCE. DURING HIS CAREER,

HE HAS PARTICIPATED IN THE SUCCESSFUL DELIVERY OF A VARIETY OF APPLICATIONS

ON MANY DIFFERENT PLATFORMS. ANDREI IS AN ORACLE CERTIFIED PROFESSIONAL

DEVELOPER WITH OVER SEVEN YEARS OF EXPERIENCE USING ORACLE TOOLS AND

TECHNOLOGY. ANDREI HAS SIGNIFICANT EXPERIENCE WITH ORACLE TOOLS SUCH AS

DESIGNER, FORMS AND REPORTS, AS WELL AS A VARIETY OF THIRD-PARTY TOOLS.

Andrei has recently delivered several web deployed and client server Oracle

projects that have included both application migrations and new application

development. Andrei has also been instrumental in the successful delivery

of a number n-tier architecture applications using JSP technology for the

mid-tier and presentation layer.

Relevant Consulting EXPERIENCE

2005- TO PRESENT SENIOR ORACLE DBA AT CGI, PARTICIPATING IN VARIOUS

PROJECTS AS SENIOR DBA, DATA ARCHITECT, DEVELOPER.

1. BC Ministry of Technology Trade and Economic Development - Forms

Application Upgrade of the Business Investment System 2009 to Present -

Senior Oracle Developer, DBA

. Andrei is a Senior Oracle Developer for the 10g Upgrade project.

Application includes Oracle Forms and Report 6i running in client-

server mode. Those were migrated to version 10g release 2 and several

enhancements were applied. Responsibilities included: Forms, Reports

migration, re-development and enhancement; Oracle application server

setup and patching..

. Technologies used: Oracle Application Server 10gR2, Oracle Webutil,

Oracle Developer Suite 10gR2

2. BC Ministry of Citizens' Services - Application Fixes for the Project -

August 2008 to Present - Senior Oracle Developer, DBA

. Andrei is part of a technical team to support the Provincial system

for registering and maintaining Green House Gas Emissions. Andrei

provides programming, systems analysis, business analysis and database

administration services. The Application architecture involves a .NET

application server on an Oracle 10g database.

. Technologies used: Oracle 10g database, asp .NET framework.

3. BC Ministry of Technology Trade and Economic Development - Application

Support of the Business Investment System- December 2007 to 2009 - Senior

Oracle Developer, DBA

. The scope of this project included updates to the Ministry's

Application to support the addition of a new web module for electronic

submission and reporting of Tax Credit Applications. The Application

is developed using Oracle forms on an Oracle 9i database.

. Technologies used: Oracle 9i database.

4. BC Ministry of Health Services -July 2008 to 2010 - Senior Oracle

Developer, DBA

. Andrei was performing database deployments, support, configuration,

and maintenance.

. Technologies used: Oracle 11g database, Oracle Times Ten.

5. BC Ministry of Environment - Application Enhancements and Support

February 2005 to Present - Senior Developer

. Andrei was a Senior Oracle Developer for numerous Enhancement and

Support engagements with the Ministry of Environment. He was involved

in the Oracle Application Server 10g and development environment

setup, forms and reports development and conversion from 6i client-

server to 10g, as well as from 9i to 10g release 2, and subsequently

to the conversion of forms and reports to secure socket layer (SSL).

. Andrei is doing application support related to database stored

procedures, forms, and report enhancements, and maintenance.

. Technologies used: Oracle 10g database, Oracle 10g forms and reports.

6. BC Ministry of Children and Family Development - Child Care Programs and

Services Division - February 2005 to February 2007 - Senior Developer

. Andrei was a senior oracle developer for the Project (Ministry of

Children and Family Development, Child Care Programs and Services

Division). He was involved in reports and stored procedures

development.

7. The Genetic Corporation - 2005 to Present - Senior Developer

. Andrei is a Senior Oracle Developer for The Genetic Corporation,

located in Guelph, Ontario. is Canada's largest herd genetics and

artificial insemination technology co-operative. Andrei helped deliver

a significant re-modeling of the mission critical applications that

run the business. In addition to this project, Andrei provided on-

going managed services to maintain these mission critical applications

and their associated databases and servers. He provided the proof of

concept research and demo related to possible migration of the current

Field application (html db) to Oracle Application Express.

. Andrei was working on the Application Support (GEN Application

Support) project, fixing reports and forms issues in post migration

phase. As well as, on Data Modeling (GEN Data Modeling) project

implementing solutions discovered during the data model review.

. Andrei was a Senior Oracle Developer for the migration project,

The Genetic Corporation, located in Guelph, Ontario. Andrei was

involved in Oracle forms and reports migration from 6i to version 10g.

He was a senior developer for application upgrade.

is an Oracle html DB application, generated from Oracle Designer

repository as a large set of PL/SQL modules and it is currently

running under Oracle Application server 10g.

. The application upgrade has been done as a part of Oracle

repository upgrade (10g rel.2) and included regeneration of all html

db modules, upgrade of the system packages and resolving issues

specific to Oracle Application Server 10g release. He was also

responsible for html db setup and configuration.

8. Ballard Power System's Transportation Division (BPS) - 2005 to Present -

Senior Developer/DBA

. Andrei is currently a Senior Oracle Developer for Ballard Power

System's Transportation Division in Phase 5 of its Fuel Cell Passenger

Bus Development Project. It is in the stage of implementing

enhancements to the application used to collect data on bus

conditions, actions taken on the bus, and to manage the engineering

change management process. The application is built on Oracle 6i web

forms, Oracle 8.1.7 database, Oracle portal and makes extensive use of

Oracle workflow to model business processes and workflow.

. Andrei was a Senior Oracle Developer (Team Lead) for Ballard Power

System's Transportation Division in Phase 5 of its Fuel Cell Passenger

Bus Development Project where he delivered a comprehensive Oracle 9i

AS and Oracle Portal based data collection and reporting application

for its 3-year field trials in North America and Europe. The

application is used to collect data on bus conditions, actions taken

on the bus, and to manage the engineering change management process.

The application is built on Oracle 6i web forms, Oracle 8.1.7

database, Oracle portal and makes extensive use of Oracle workflow to

model business processes and workflow.

. Andrei was a Senior Oracle Developer for the DCS migration project

(Ballard Power System's Transportation Division). The project

includes: application server, portal, and developer suite migration to

version 10g.

9. BC Ministry of Transportation - Progress Estimating System -

February 2005 to April 2008 - Senior Oracle Developer

. Andrei was a Senior Oracle Developer on the project. Andrei

developed stored procedures/scripts for data migration and oracle

reports. Andrei has continued to support the application in

production primarily focusing on oracle reports.

. Andrei was doing application support related to Oracle reports.

10. BC Ministry of Water, Land and Air Protection - Comprehensive Record

and Information System for (CRISP) - 2005 to 2007 - Senior Oracle

Developer

. Andrei was a senior oracle developer for the CRISP Project. He was

involved in reports and form development and conversion from 6i to

10g.

11. BC Ministry of Public Safety and Solicitor General - On-Line Program

Records Administration - 2002 to present - Senior Developer

. Andrei was a senior oracle developer for the Project. He was

involved in reports and stored procedures development as well as in

the development of Oracle designer workbooks. The architecture for

this project includes Oracle Web Forms 10g, Oracle database 9i, 10g.

. Currently Andrei is doing application support related to Oracle

reports and Forms

12. BC Ministry of Small Business and Economic Development - Business

Investment System - 2002 to 2004 - Senior Developer

. Andrei was the senior Oracle developer for the Project. He developed

reports and stored procedures development as well as designing and

building the complex tax algorithms. He has been the DBA for the

Project for 6 successive releases over the past 5 years.

13. BC Ministry Of Public Safety and Solicitor General - Crime Victim

Assistance Program - Electronic Victim Information System (ELVIS) - 2002

to present - Senior Developer/DBA

. Andrei was the senior developer/DBA for the Electronic Victim

Information System (ELVIS) Project for the Ministry of Public Safety

and the Solicitor General's Crime Victim Assistance Program. ELVIS is

a case management system developed to support the Crime Victim

Assistance Program (CVAP). CVAP provides financial benefits and

assistance to victims of crime and other eligible claimants. Andrei

was involved in the design of the application, data model design,

forms and stored procedure development as well as in the data

migration from previous IBM Mainframe application. This project

involved the design and development of an Oracle Web forms application

to manage the tracking and financial components of this new program

area. The architecture for this project initially includes Oracle Web

Forms, Designer 6, and Oracle 8.17.

. Currently Andrei is doing application support related to Oracle

reports and Forms

.

14. Tantalus Communications Inc. - 1999 to 2002 - Senior Developer

. Andrei was a Senior Developer for Horsepower Network.com working on

the second phase of work for a web based application.

. Andrei was a Senior Developer for SNV International, where his duties

included:

. Design and Server Model Diagrams.

. Developed PL/SQL code and interfaces to java middle tier.

. Andrei was a Senior Developer for WebDispatchers.com, where his duties

included:

. Business analysis and development of Entity Relationship Diagrams.

. Design and Server Model Diagrams.

. Developed PL/SQL code and interfaces to java middle tier.

. Andrei was a Senior Developer for Horsepower Network.com, where his

duties included:

. Business analysis and development of Entity Relationship Diagrams.

. Design and Server Model Diagrams.

. Developed PL/SQL code and interfaces to java middle tier.

. Andrei was a Senior Developer for the Brick Warehouse. His

responsibilities included: business analysis and development of Entity

Relationship Diagrams.

15. LGS Group - 1997 to 1999 - Senior Oracle Technical Specialist

. Andrei was a Senior Oracle Technical Specialist for LGS, his duties

included:

. Oracle forms design, database design, and preparation of documents for

SPARC and POS projects.

. Design and development of the Shopper Profile and Contract

modules/P.O.S. forms, database design using Oracle Form Designer,

Developer / Designer 2000, Oracle Forms 4.5 (20 person team)

. Designed and built the majority of the Contract module which is the

largest and most complex part of the SPARC POS application. Contract

is the core of the POS application. It includes 6 main windows

(implemented as one large module) and several secondary windows called

by the main one.

. Integrated related functions and windows into the Contract module

. Provided support to other developers and client testing team.

16. Corporate Insights - Maintenance - 1997 - Database Manager

. Andrei's responsibilities included adjustment and enhancements to CI's

proprietary software and other database programming requirements.

17. Promstal Company - Moscow Russia - 1995 to 1997 - Programmer/Database

Analyst

. Andrei's responsibilities included: database design and development

for the world's largest metallurgical companies: Magnitogorsk Iron and

Steel Company, Nigny Tagil Iron and Steel Company and members of

Russian Steel Exporter Guild using MS Access, ORACLE, VB, C++, MFC,

MAPI on W95, and NT. He also focused on Internet applications and web

pages development and design.

18. Interquality (Russian - German Joint Venture) - 1994 to 1995 -

Programmer/Database Analyst

. Andrei was responsible for database design and development related to

ultrasonic examination of welded joints for BABCOCK Company (in

Oberhausen German)

. Technologies used: MS Access, VB, and C++.

19. NIKIMT - Institute of Assembly Technology, Moscow, Russia - 1985 to

1994 - Chief of Programming Laboratory

. Andrei's duties included:

. Software design for acoustic emission control systems for atomic

industry using / C++, Borland C, Pascal, Assembler on Windows and

MS DOS.

. Installed systems on Zaporozskaja, Smolenskaja, and Bilibinskaja

Atomic Power Plants.

20. Institute of Experimental Meteorology, Moscow Russia - 1983 to 1985 -

Software Engineer

. Duties included:

. Software for satellite ozone monitoring systems using Assembler,

PL/I, Pascal, IBM Mainframe, microVax.)

EDUCATION and PROFESSIONAL CERTIFICATION

1983 MOSCOW ENGINEERING PHYSICS INSTITUTE (MEPHI-STATE

UNIVERSITY), RUSSIA

M.Sc. in Engineering Mathematics

Major: Applied Mathematics and Programming

2000 Oracle Certified Professional Developer

HARDWARE AND SOFTWARE EXPERTISE

SUBJECT AREA TECHNOLOGY

INTERNET DHTML

Java

MS FrontPage 2000

MS IIS 4.0

Web Services (Jrun4, Tomcat)

XML

Data Base Management Systems MS Access

MS SQL Server 7, 2000

Oracle 10g, 10g rel.2

Oracle 7.3

Oracle 8

Oracle 9i

Application Development Basic

Environments/Languages MS Visual Basic

Oracle Forms 4.5, 6(i) and 10g rel. 2

Oracle Reports 2.5, 6 and 10g rel. 2

PL/SQL Developer

PL/SQL

SQL

SQL Navigator

TOAD

Hardware Platforms IBM PC and PS/2 (and compatible)

Operating Systems DOS 6.22

UNIX

Windows 2000 Professional and Server

Windows 2003 Server - Terminal Services

Windows 95, 98

Windows NT 4.0 Workstation and Server

Windows XP

PROFESSIONAL SKILLS SUMMARY

SKILL YEARS EXPERIENCE LAST USED

PROGRAMMING LANGUAGES:

HTML 1 2004

JAVA 4 CURRENT

PL/SQL 14 CURRENT

VISUAL BASIC 6 2002, CURRENT

SOFTWARE AND APPLICATION EXPERIENCE:

ACCESS 2000 1 2005

MS VISUAL STUDIO 6.0 3 2003,2011

ORACLE 11G DATABASE 3 CURRENT

ORACLE 10G DATABASE 5 CURRENT

ORACLE 7.3 DATABASE 5 2003

ORACLE 8I DATABASE 4 2005

ORACLE 9I DATABASE 3 2007

ORACLE WEBLOGIC SERVER 11G 2 CURRENT

ORACLE APPLICATION SERVER 9I AND 10G 9 CURRENT

ORACLE FUSION MIDDLEWARE 10G AND 11G 5 CURRENT

ORACLE BUSINESS INTELLIGENCE 9I, 10G AND 5 CURRENT

11G

ORACLE FORMS 4.5, 6(I),10G AND 11G 10 CURRENT

ORACLE REPORTS 2.5, 10G AND 11G 10 CURRENT

PL/SQL DEVELOPER 12 CURRENT

TOAD 9 CURRENT

OPERATING SYSTEMS:

UNIX, LINUX 5 CURRENT

WINDOWS 2000 PROFESSIONAL AND SERVER 3 2008

WINDOWS 2003, 2008 SERVER 2 CURRENT

WINDOWS 95, 98 2 2004

WINDOWS NT 4.0 WORKSTATION AND SERVER 6 2002

WINDOWS XP PROFESSIONAL, WINDOWS 7 5 CURRENT

EXPERIENCE SNAPSHOT

INDUSTRIES

. Ministry of Children and Family Development

. Ministry of Transportation

. Ministry of Environment

. Ministry of Public Safety and Solicitor General

. Ministry of Small Business and Economic Development

. Ministry of Citizens' Services

. Technology

. Agriculture

. Education

Solutions

. Green House Gas Measurement Calculator

. - The Genetic Corporation

. Ballard Power Systems

. Child Care Programs and Services Division

. Progress Estimating System

. On-Line Program Records Administration

. Business Investment System

. Electronic Victim Information System

Methodologies and Techniques

. Java

. Web Services

. Oracle

. PL/SQL

.

Contact this candidate