Developer Administrative Assistant

Larysa Shepetchuk

Tel.: 289-***-****. Email: *******@*******.***

OBJECTIVE: Database Analyst, Developer

SUMMARY

Extensive experience with MS Access and MS Excel customized applications.

Expertise in preparing report specifications in order to support client

requirements.

Load data from MS Excel to MS Access and MS Access to MS Excel.

Used partitioning and sub partitioning of tables to improve performance.

Excellent organization, analytical, time management and problem-solving

skills.

Reliable team worker and able to work independently, under the pressure in

a fast-paced environment.

TECHNICAL SKILL SUMMARY

Operating Systems: Windows 95/98/2000/Vista/7, MS DOS, UNIX

Database: Oracle 8i, MS Access (97-2010)

Languages: SQL, PL/SQL, FORTRAN, C, HTML

Other Tools: SQL Plus, Oracle Developer 2000, SQL Server 2005, MS-Word, MS-

Excel, MS Outlook, Power Point, Visio, Crystal Reports, Photoshop, Forms

5.0, Forms 6i

PROFESSIONAL EXPERIENCE

April 2002 - Present

Asian Television Network, Markham, Ontario

Database Developer, Administrator

Designing, developing and upgrading multiple MS Access database

applications.

Transferring data from several Excel spreadsheets into MS Access database

for library and commercial traffic departments.

Implement effective database security practices and procedures (creating

database users, roles and managing security).

Creating forms, queries, reports; and deploying the applications to clients

and internal users.

Preparing presentations for management and customers (PowerPoint)

Generating SQL queries and creating new reports based on customer and

management requirements.

Preparing and providing training for users of MS Access and MS Excel

applications.

Supervising co-op program students.

February 2001 - October 2001

Nanowave Technology Inc., Etobicoke, Ontario

Administrative Assistant

Provided support for existing MS Access databases and MS Excel spreadsheet

documents.

Analyzed data to identify duplicates, data errors, and other changes that

needed to be addressed in order to successfully import the data into

Access.

Participated in creating requested custom reports.

November 2000 - February 2001

Heart and Stroke Foundation of Ontario, Toronto, Ontario

MS Access Database Developer

Designed (logical and physical models) and tested MS Access 2003 database

for the Heart and Stroke Foundation website based on client requested

functionality.

Developed customized database forms and reports to support customers'

requests.

Automated several manual data processes of collection of data to several MS

Access databases by use of VBA MS Access forms and SQL inserts, updates and

queries to make the databases more efficient and protected by data

integrity.

Provided website and back-end database testing for Ontario's Heart and

Stroke website.

April 1995 - January 1998

National Institute of Health (IT department), Kiev, Ukraine

Application Developer

Provided database development and support for Health Resources and Service

Administration (HRSA) database application (Visual Basic, VBA).

Provided administration and distribution of front-end Access databases to

clients.

Created training documentation and manuals for R&D and accounting

department's databases users (MS Office).

Participated in the collecting and analyzing of statistical data of the

ratio of family physicians in urban and rural areas.

Created many advanced reports and presentations that were distributed to

upper management.

May 1990 - March 1995

Production Association "Plant Arsenal", Kiev, Ukraine

Programmer Analyst

Developed complex reports - multi-functioned, leveled and grouped, summary

functionality in main reports and sub-reports, error handling/messaging,

clean and attractive, user friendly designs.

Developed, tested and supported various applications for engineering

departments (FORTRAN, UNIX)

Designed, maintained and tested database applications for accounting and

bookkeeping departments (PL/SQL).

Performed unit testing, integration testing, and performance testing

(Basic, C).

COURSES

Advanced database concepts and design

1999

Seneca College, Toronto

Accounting I

2011

Seneca College, Toronto

Small Business Accounting

2012

Seneca College, Toronto

Records Management

2012

Seneca College, Toronto

EDUCATION

Bachelor Degree in Computer Science

1984 - 1990

Kiev Technical University, Ukraine

Contact this candidate