Sample of Resume

Name:                              Sample Candidate

Age:                                    36

Date of Birth:                     1 August 1962

Availability:                         Immediate

Address:                             2, bld. 3/1, Lomonosova str., Novosibirsk (630111)

Telephone:                         home:    +7 (3832) 628519 (19-00 √ 24-00)
                                            work:    +7 (3832) 567812
                                            fax:        +7 (3832) 567813
                                            E-mail:   perep@usa.net

Citizenship:                        Russia

Referral Date:                   15 January 1999

Objectives:
Senior Analyst Programmer with Banking experience,
PowerBuilder or SqlWindows & Oracle programmer, RDBMS developer or DBA.

Education

1979-1984 Novosibirsk State University. Applied Mathematics, Information Technology.
MS in Computer Sciense.

Training courses:

1995, Microinform, Moscow
Microsoft 505 "Supporting MS Windows NT 3.51",
Microsoft 487 "Supporting MS Windows Server 3.51".
1997, Microinform, Moscow
Novell 801 "NetWare Service & Support".

TECHNICAL SUMMARY:
1 =  Theory Only: 2 = Limited Use; 3 = Competent; 4 = In-depth Use.

SKILL	RATING 1 - 4	YEARS EXP	LAST USED
ROLES:  Oracle DBA, DB2 DBA, DB2 Lecturer, Senior Analyst / Programmer		3 5 2 18
HARDWARE Sun Mac RS/6000 IBM-3090 IBM-4381 IBM-3081 IBM System 38, IBM 360/370 IBM PC Clones	3 2 3 3 3 3 3 2 4	2 1 2 4 2 4 5 2 10	1999 1999 1999 1994 1991 1986 1988 1982 1999
OPERATING SYSTEMS: Solaris Mac/OS MVS VM JCL Windows NT 4 Windows NT 3.51 Windows 95 Windows 3.1 AIX MS-DOS	3 2 3 3 1 3 1 3 4 4 4	2 1 4 2 2 2 6 months 2 3 5 10	1999 1999 1994 1991 1999 1999 1997 1997 1997 1999 1999
DEVELOPMENT TOOLS: Oracle Designer/2000, Oracle Developer/2000, IEW / ADW	3 3 3	4 4 3	1999 1999 1994
OTHER TOOLS: Oracle Symmetric Replication, DB2 Data Propagator, DB2PM, Omegamon, DBRAD, CULPRIT, FILE-AID, SAS, CICS DBUG, QMF, XPEDITER, ABEND-AID, EASYTRIEVE, SQL*Net, TCP/IP, NT WINS Names Resolution, Oracle Names, Pro*C, SQL*Forms, NetMaster, RACF	4 3 3 3 2 1 1 3 4 4 1 1 3 2 4 1 2 3 3 1 3	4 4 4 2 2 1 2 4 4 5 2 2 4 2 2 2 2 2 2 2 5	1999 1997 1997 1994 1994 1994 1994 1986 1997 1994 1986 1986 1986 1999 1999 1997 1999 1999 1999 1990 1990
DATABASE:  DB2, IDMS, VSAM, Oracle, SQL Windows, CICS	4 3 3 2 1 4	6 4 6 2 4 months 7	1997 1997 1997 1999 1998 1997
LANGUAGES: SQL, COBOL, COBOL II, CSP, PL/1, C, REXX, Pascal, SQL Windows, PL/SQL, C++, SQL/DS, RPG-III	4 4 4 1 1 3 2 3 1 3 2 1 3	8 10 5 2 1 2 1 3 4 months 2 2 3 month 2	1999 1997 1997 1994 1982 1999 1994 1999 1998 1999 1999 1991 1988

EMPLOYMENT HISTORY

Period: September 1997 - present

Organization: LiptoBank, Novosibirsk

Role: Database Administrator

Environment: Sun Solaris, Windows NT 4, Mac/os

Development of an external web site using Oracle Web Server and PL/SQL packages. Design and development of data integrity procedures in PL/SQL, to reconcile internal LiptoBank da-tabases with a public version of the same data. Installation of a multi-master replication sys-tem between seven databases sites spread across Siberia. Installation of Oracle databases and Developer/2000 tools on NT and Unix. Oracle NamesServer installation and support. Data-base reorganizations using Import/Export. Provision of assistance to analyst programmers with query development and tuning. Upgrade and reconciliation of the Designer/2000 case repository.  Other DBA tasks as required.Period: March 1997 - May 1997

Period:  March 1997 - May 1997

Organization: OOO ⌠Temp■, Omsk

Role: Installer

Environment: Windows NT 3.51

Design and development of automated installation and database creation procedures for Ora-cle7 and Personal Oracle7 for use by non-technical staff in Austrade overseas sites. Proce-dures created using WYSE, targeting servers and notebook clients running Windows NT 3.51.

Period: May 1995 - March 1997

Organization: NTK ⌠Poliet■, Omsk

Role: Database Administrator, Senior Analyst

Environment: RS/6000, AIX 4.1, Windows 3.1, Windows NT 3.51

Design and installation of a 3-tiered data replication environment, using Oracle7.2/7.3 on UNIX and Windows NT 3.51 platforms. Based on Oracle Symmetric Replication tools, util-izing multiple master and updateable/read-only snapshot constructs. Design and coding of a program suite to generate SQL statements to assist with creation, alteration and administration of a replicated environment.

Logical and physical database design of a Customer Information system, using Oracle De-signer/2000 case tool. Implementation of physical design standards, naming conventions and Oracle installation standards.

Administration (backup, recovery, import/export, SQL tuning) of Oracle databases on Win-dows NT, Windows 95 and UNIX platforms.

Installation and tuning of Oracle 7.2 / 7.3 on Windows NT and Windows 95 for a distributed database environment.  Experience with TCP/IP,  SQL*Net, NT WINS Names Resolution, Oracle Names.

Design and coding of numerous data load and data integrity checking routines using PL/SQL. Development of Pro*C programs to initiate replication activities from a C++ client applica-tion.

Author of Systems Administration Guide, Operations Manual and Global Design documenta-tion.

Evaluation of DB2 DataPropagator.
 

Period: February 1995 - May 1995

Organization: Bank of Russia, Omsk

Role: DBA, Analyst Programmer

Environment: IBM 3090, MVS/ESA, CICS 2.1, DB2 V2.3, Cobol II

Analysis, design, coding and implementation of a DB2/CICS/Cobol II system to process cus-tomer requests for foreign currency and travelers checks.

Design of DB2 housekeeping suite for system tables. Performance analysis and tuning of SQL calls made by system programs. Provision of DB2 technical assistance to other team mem-bers.

Period: July 1991 - November 1994

Organization: AOOT NZHK,  Novosibirsk

Role: Database Administrator / Senior Analyst Programmer

Environment: IBM 3090, MVS/XA, CICS 2.1, DB2 V2.2, Cobol II, QMF 2.4, IEW, REXX, Oracle V6, OMEGAMON

Analysis and design of DB2 online and batch components of a Custody Administration Sys-tem.  Implementation of design units using CICS Cobol II and DB2. Data transfer and conver-sion between an H/P Oracle-based system to DB2 systems.

Develop standards for DB2 Naming Conventions, DB2 Programming Standards, Physical Database Design, DB2 Security Administration and Backup/Recovery Procedures.  System and design unit performance monitoring using OMEGAMON .   Physical DB2 implementa-tion of project data models.   Monitoring, backup, recovery and housekeeping tasks for project databases.   User training for DP staff not familiar with DB2 and CICS concepts.   Set up and maintenance of a Data Dictionary facility using IEW, ISPF, DB2 and Cobol II.

Evaluation of software development platforms including Oracle SQL*Forms and Gupta SQLWindows.

Development of on-line and batch QMF standards. QMF training and site customization tasks. Implementation and maintenance of a query database for end-users using data extracted from operational systems.

Period: May 1991 - July 1991

Organization: NSTU, Novosibirsk

Role: Senior Analyst Programmer

Environment IBM 4381, VM, SQL/DS, CSP V3.2

Design and coding of an on-line CSP and SQL/DS education and training grants system.
 

Period: July 1990 - January 1991

Organization: Private gimnasium ⌠Veritas■, Novosibirsk

Role: DB2 Lecturer

Presentation of a number of courses to in-house developers -
 . IBM DB2 Application Programming course (4 days), presented for the Australian Taxation Office
 . Introduction to DB2 (2 days), presented for the Superannuation Fund Investment trust
 . CSP Application Development for DB2 (3 days), presented for the Superannua-tion Fund Investment Trust
 

Period: August 1988 - December 1990

Organization: Fund Investment Trust,  Novosibirsk

Role: Database Administrator / Senior Analyst Programmer

Environment: IBM 4381, MVS/XA, CICS 1.7, DB2 V1.3 to V2.2, CSP, Cobol II, IBM Mainframe C, QMF 2.2 to 2.4, DB2PM, DBrad, RACF, Netmaster

Installation and maintenance of DB2 software and associated products QMF, DBRAD, DB2PM and CSP. Design of application and data  migration plans where required. Definition and documentation of standards for DB2 subsystem and allied address space setup, including CICS/RCT entry conventions.  Development of  DB2 object naming conventions.  Develop-ment of a strategy for DB2 physical database design (including referential integrity con-straints), using IEW (case tool)  physical models as input   Physical design and implementa-tion of all of SFIT's corporate DB2 databases.  Development of a Security and Authorization plan for control of DB2 objects and DB2 connections.

Design and implementation (in CSP) of a Menu/Security system designed to build tailored menus for users based on menu structure and security information held in DB2.   Assistance with the design and coding of an Assets Tax Depreciation system.  Assistance with the devel-opment of standards for use of SQL in Cobol and C programs, and programmer guidelines for CSP and QMF. Preparation and presentation of DB2 and CSP courses to SFIT application de-velopers.

Development and implementation of a Performance Monitoring strategy for DB2, using DB2PM.   Development and implementation of a Backup and Recovery strategy for DB2, in-cluding coding of a utility and JCL generator program to automate backup procedures.   Re-sponsibility for all recovery operations on DB2 databases.

Design and implementation of a housekeeping system to generate and run DB2 utility state-ments, and collect and store RUNSTATS statistics in a database, for future analysis.   Design of a DB2 Tablespace Re-organization strategy, which included an ISPF interface, Cobol and C programs to determine candidate tablespaces for reorganization, and generation of appro-priate JCL and utility statements.   Setup of a suite of QMF queries to report on the DB2 catalogue, i.e. database structure, table and plan authorization, RI structures, tablespace and index space DASD utilization.
 

Period: June 86 - August 88

Organization: Department of Communications, Novosibirsk.

Role: Senior Analyst Programmer / Database Administrator

Environment: IBM System/38, System/38 relational database and application development tools, Cobol, RPG III

Setup and maintenance of an Australia-wide network, using System/38 communications soft-ware and Telecom DDL and Austpac services. Responsibility for recovery operations.   Maintenance of systems and database security, using the security package on the System/38.   Responsibility for system software upgrades. Assistance with system performance monitoring and tuning.

Application design and coding online transaction and batch programs, using System/38 rela-tional database tools, Cobol and Screen Writer. Setup of a User Help Desk system. Develop-ment  and documentation of Host to PC data downloading procedures. Supervision of Opera-tions staff.
 

Period: November 82 - June 86

Organization: Department of Housing and Construction, Novosibirsk

Role: Analyst/Programmer

Environment: IBM 3081, MVS/SP, CICS 1,7, IDMS/DB and DC, ADS/Online, Cobol, SAS, RACF, EASYTREIVE

Application design and coding of a large on-line Housing Grants scheme, using IDMS as a database manager, and ADS/Online as a development tool.  Design and coding of numerous batch Cobol programs with IDMS and VSAM calls, submitted via an ISPF interface.  Design of numerous ad-hoc reports using SAS, EASYTREIVE and Culprit.  User liaison and help desk tasks.  Maintenance of smaller systems using FILETAB, Cobol and SAS.

Period: September 81 - November 82

Organization: Department of Communications, Novosibirsk

Role: Programmer

Environment: IBM 370/60, MVS, TSO, VS Cobol, Easytreive

Submission and checking of scheduled batch update and reporting jobs.  Preparation of simple reports using Cobol and EASYTREIVE.   File housekeeping duties, performed using IBM utilities.

REFEREES:

1. Vladimir S. Kirienko, Head of IT Department, LiptoBank.
Home phone: +7 (3832) 11-0619

2. Oleg Sysuev, Vice-president of LiptoBank.
 Home phone: +7 (3832) 77-3524