Project Visual Basic

Title:Senior Consultant

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

Document

Source below

NAME: Konstantina Ferrer

ADDRESS: *** ***** ***. *. *-29

CITY: North York

STATE/PROVINCE: CO

ZIP/POSTAL CODE: 80210

COUNTRY: USA

EMAIL: *******@*******.***

PHONE: 416-***-****

CANDIDATE ID: 173554

CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 6

WILL RELOCATE: Yes

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED: Open

HOMEPAGE:

EDUCATION

Advanced to HTML Course - 03/2000

Intro to HTML Course

- 02/2000

Oracle DBA Certification in process (attended several courses)

Intro to PL/SQL - 1998

Database Administration

- 1999

Certified Database Administrator, University of Denver - 1998

Dale Carnegie Course

- 1998

Masters of Science

in Computer Science, University of Denver - 1994

BS

in Computer Science and BS in Mathematics, Truman State University (former Northeast

Missouri State University

) - 1993

PROFESSIONAL WORK EXPERIENCE

Senior Consultant

- Keane, Inc., Lakewood, CO, USA - 12/1996 - 03/2000

Senior Developer

(Contract through Keane) - Fireman's Fund Insurance, Novato, CA, USA

10/1999

-12/1999

For a major insurance company, enhance an internal application using IBM VisualAge C on a

DB2 (UDB) database. It included interfacing C with MS Word through Dynamic Data Exchange

(DDE) protocols and Visual Basic for Applications as well as DBA related activities like

creating new tables, populating the tables and managing the data. Other tasks include:

Project Management, including setting up deadlines, writing proposals and others.

Gathering requirements from the end-users.

Database Architecture/Design.

Environment: DB2 (UDB), IBM VisualAge C, Windows Programming, MS Word, Visual Basic for

Applications, Windows 95, Windows NT

DBA / Y2K Tester

(Contract through Keane) - Gambro Healthcare, Lakewood, CO, USA -

07/1999

- 10/1999

For a major Healthcare company, maintain a database in MS Access to set security levels,

keep out unauthorized access, and ensure users can have their required access without

changing critical database objects. Other tasks included creating Y2K scripts for testing

the local software as well as Spanish-written software for the Argentina and Mexico

offices.

Environment: Windows 95, MS Access 97

Database Coordinator Manager

(Contract through Keane) - Janus Mutual Funds, Denver, CO,

USA - 06/1998 - 07/1999

For a major mutual fund company, assigned to phase III of a Y2K project. Re-

design/Maintain a database in MS Access to set security levels and ensure users can have

their required access without changing critical database objects. Other tasks included:

Ensure that requests and approved changes made by the Y2K Project Office are made in a

timely manner.

Meet with clients/project office team to develop and recommend detailed database

redesign specifications and structures

Coordinate with users to ensure their work can continue with proper safeguards to

protect date-critical data.

Produce database input screens and reports for clients as required

Maintain data integrity by daily monitoring all data to ensure it meets specified

standards.

Provide weekly updates to the Y2K Project Office.

Created a Visual Basic Application to export data from MS Access to different MS

Projects Automatically with specific formats

Created a variety of SQL queries to automatically export data from MS Access into

different MS Excel Spreadsheets and run calculations within Excel for the MS Project

Office Weekly Status Report

Environment: Windows 95, MS Access 97, MS Excel, MS Project

Senior Programmer/Analyst

(Contract through Keane) - IBM, Boulder, CO, USA - 01/1998 -

05/98

For a major computer/software manufacturer, worked on a data warehouse project for the

Worldwide Distribution Department. Tasks included:

Converting data from an OS/2 warehouse to a Windows NT environment using IBM Visual

Warehouse and DB2.

Managing databases and business views within the warehouse.

Enhancing the OS/2 data warehouse to meet the client requirements.

Using IBM OLAP tools, and the backup and recovery package (ADSM) for IBM RISC6000 and

IBM PS/2.

Environment: Windows NT, IBM 0S/2, IBM DB2 (UDB), IBM Visual Warehouse, IBM ADSM, IBM

MQF, AIX, Lotus Notes R4.5

Senior Programmer/Analyst

(Contract through Keane) - IBM, Boulder, CO, USA - 08/1997 -

12/1997

For a major printing systems company, created programs in C to read barcodes for the

British Royal mailing systems. Made enhancements to existing applications using C, C++ in

AIX and Windows NT environments. Created front-end programs in Windows NT for DB2

databases residing on AIX machines.

Environment: C, C++, Windows NT, IBM DB2, AIX, Lotus Notes R4.5

Programmer/Business Analyst

(Contract through Keane) - Janus Mutual Funds, Denver, CO,

USA - 06/1997 - 08/1997

For a major mutual fund company, provided Y2K analysis. Redesigned a tool written in MS

Access to match client and project needs. Analyzed various databases and programs for Y2K

compliance. Wrote a FoxPro program that automatically retrieved the structure of all

databases and dumped the results into an ASCII file to be later imported into Excel, which

allowed more than 5,000 tables to be analyzed for Y2K readiness.

Environment: Windows 95, FoxPro, Ms Access, MS Excel, COBOL, RPG

Software Tester

(Contract through Keane) - Encore, Greenwood Village, CO, USA - 05/1997-

06/1997

For a cable company, tested applications written in Powerbuilder and Sybase to ensure

they interacted correctly with the graphical user interface, connectivity, and database

retrieval. Ensured that project specifications were met and that all functions of the

application performed correctly.

Environment: Windows 95, Sybase, Powerbuilder

Access/VB Programmer

(Contract through Keane) - America Drug Store, Chicago, IL, USA -

02/1997

- 05/1997

For a national pharmacy, analyzed, designed, maintained, enhanced and programmed

prescription the benefits administration system.

Maintained and developed client/server applications in Access and Visual Basic. Created

user-friendly reports.

Redesigned application to accommodate new client requirements.

Investigated databases and applications to determine specific areas for performance and

maintenance improvements.

Implemented documentation and trained users on system.

Environment: Windows, Access, Visual Basic

Software System Programmer Analyst II

- DP Associates, Commerce City, CO, USA - 04/1995 -

11/1996

For a vendor providing services to the Federal government, worked as a DBA, developer,

and UNIX administrator.

Developed applications for Federal clients involved in environmental remediation,

information and analysis work.

Created a Windows 32-bit application to allow connectivity and SQL data manipulation

and retrieval from databases on multiple platforms.

Controlled Internet access to prevent unauthorized access to restricted information.

Monitored and developed reports on snooping and access from unfamiliar domains or sub-

domains.

Wrote applications that loaded and updated dates from map files into Access databases.

Designed, developed and populated a relational database that contained GIS information

from map files.

Created programs in C/UNIX to automatically print system log file on hard copy upon

detection of any unusual Internet activities.

Edited and updated programs written to manipulate environmental database.

Maintained and troubleshot UNIX systems for Silicon Graphics Machines.

Monitored Internet usage for business/personal use.

Installed Silicon Graphics workstations including hardware, network connectivity,

operating system (IRIX 6.2), Internet firewall, AutoCAD, GIS packages, Netscape.

Designed strategies for daily system backups for GIS department.

Environment: Visual C++, C, Visual Basic, ODBC, Access, Ingress, Q+E, Windows 3.11/NT/95,

UNIX (Ultrix, Irix), SQL, Wrappers, GIS, Netscape

Programmer Analyst I/ System Administrator

- Harding Lawson Associates, Denver, CO, USA -

9/94

- 4/95

For a geological firm, developed and validated environmental databases. Worked with

scientists to analyze and report on environmental data. Responsible for UNIX systems

administration.

Environment: dBase IV, Excel, Access, Solaris, Lotus123, SUN, OS, GIS

Activities/Interests

Toronto/Mississauga WebGrrls Member

2000

- present

Women in Technology (

WIT

) Social Coordinator1998 - 2000

Rocky Mountain Internet Users Group

(RMIUG) Member 1995 - 2000

Languages

Fluent in Spanish and Greek

Reference

Available Upon Request

Contact this candidate