Oracle Project

Title:IVAN VALIENTE

abpw6u@r.postjobfree.com

Document

Source below

NAME: Jennifer Brickner

ADDRESS: **** ********* ***

CITY: Tallahassee

STATE/PROVINCE: FL

ZIP/POSTAL CODE: 32308

COUNTRY: USA

EMAIL: abpw6u@r.postjobfree.com

PHONE: 850-***-****

CANDIDATE ID: 112502

CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 5

WILL RELOCATE: No

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED: Open

HOMEPAGE:

HOTSKILLS: Oracle Developer =5+ yrs, Oracle Forms =5+ yrs, Oracle Reports =5+ yrs,

Oracle Designer =5+ yrs, Oracle PL/SQL =5+ yrs, Oracle Web Toolkit =3+ yrs, Visual

Basic =3+ yrs

ESUME

SOFTWARE

ORACLE Designer/2000 (since 1.0)/ORACLE CASEDICT 5.0,ORACLE SQL*Loader, ORACLE SQL*Forms

(since 2.x), ORACLE SQL +, PL/SQL, ORACLE SQL*Reportwriter (since 1.0), ORACLE

Developer/2000 (since 1.0), Oracle RDBMS (8x,7x,6x,5x) WAS/OAS/IAS Web Toolkit, ADW

Knowledgeware CASE, Cold Fusion, Visual Basic, Crystal Reports, WINBATCH, CSS (Cascading

Style Sheets), Netscape, Internet Explorer, Unix, Windows NT/98, Novel Netware, IBM MVS,

DEC VAX/VMS, OS/2, DOS

WORK EXPERIENCE

5/17/2000

PRESENTPhoenix Consulting, Inc. Tallahassee, FL

Program Manager

Corporate-wide Duties: Prepare and review estimates for new work. Attend implementation

and strategy meetings for follow-ups and to draw up suggested work plans and estimates.

Conduct code walk-throughs to provide guidance in form and syntax.

Client:

Department of Education

Bright Futures (BSFA) 01/16/2001- 6/29/2001

Description: Maintain hundreds of Oracle Developer Forms and Reports 6i and PL/SQL

program units to be used in a two-way Client/Server and Internet Application for State-

wide Student Scholarship Applications system written by KPMG, Inc. and originally

implemented in California. Coordinate enhancement requests between all functional areas.

Meet code standards, library requirements and project deadlines. Provide training and SQL

mentoring to other developers and testers. Originate database requests for new tables,

sequences, indexes and other database objects.

Skills: Programming and Project Management

Tools: Microsoft Project, Oracle 8i SQL, Oracle Developer 6i (Forms and Reports)

Client:

Dept. of Labor and Employment Securities Public Employee Relations Commission

(PERC

) 09/17/2000- 01/15/2001

Description: Conducted user walk-through for implementation approval for Court Business

logic validation. Verify mediation panel steps, case event processing for each order type

and provide business process diagrams where appropriate. Led Visual Basic Development Team

and provided mentoring to other developers. Tested, debugged and re-coded dozens of Visual

Basic screens, including complex data selection statements creation for compiling

statistics and Access storage and retrieval. Tested, debugged and implemented several

ACCESS Database objects for application use. Authored and tracked project plan. Estimated

and delivered code on schedule and allocated resources in an efficient manner.

Skills: Programming and Project Management

Tools: Microsoft Project, Visual Basic, Crystal Reports, Access SQL

Client:

Department of Health (DOH), State of Florida 6/7/2000-9/17/2000

Description: Installed, configured, documented and implemented Oracle 8i database and

NET8.

Installed, configured, documented and implement Oracle Internet Application Server (IAS

1.0 formerly WAS and OAS). Implemented and successfully tested existing procedures

(developed by DMS) using Oracle IAS 1.x Web Toolkit. Designed, created and implemented one

new Oracle Report. Designed created and implemented several new Oracle objects including

database links, tables indexes, sequences, etc to provide new functionality. Designed,

created and implemented history table cleanup (which included appropriate backup scripts,

PL/SQL, updates and verification scripts) for unusable data. Designed, created and

implemented DOH specific new data load packages with custom database objects. Designed and

created several batch entry screens using Oracle OAS 4.x Web Toolkit for the Training

Direct Application. Facilitated local implementation (at DOH) of DMSs PROJEX application.

Provided implementation expertise for Oracle Reports on the Internet to DMS. Created and

maintained project status and deliverables and successfully completed implementation with

positive feedback from Internet users and both DOH and DMS.

Skills: Programming, System Administration, Project Management, Database Administration

Tools: Oracle 8.X SQL, Oracle Application Server (OAS), PL/SQL Web Toolkit,and Developer

6.0 (Reports).

Client:

Dept. of Labor

and Employment Securities Public Employee Relations Commission

(PERC

) 5/17/2000-6/7/2000

Description: Designed, created and implemented dozens of Crystal Reports, including

complex data selection statement creation for compiling statistics on Court Cases and

Results. Designed, created and implement several ACCESS Database objects for application

use.

Skills: Programming and Project Management, Database Administration, System Architecture

Tools: Microsoft Project, Visual Basic Crystal Reports, ACCESS SQL

02/2000

-5/2000BenovaSenior Business Systems Analyst

Description: Responsible for defect management, design, analysis and requirements

gathering for a Customer Management system using Oracle 7.x PL/SQL, Vantive and Actuate

Reports. Project Manager for new projects developing test plans, detailed design

specifications, performing code reviews, and coordinating implementation.

Skills: Business Analysis, Test Plan Creation, and Detail Design Requirements Creation

Tools: Oracle 7.X SQL, Oracle PL/SQL, Vantive Screen Builder, Actuate Report Builder.

11/98

02/2000ORACLE Corporation, Florida State and Local ConsultingPrincipal Consultant

Client: Department of Highway Safety & Motor Vehicles (HSMV), State of Florida

Description: Updated PL/SQL data conversion packages on Unix called from COBOL CICS.

Corrected dozens of batch jobs and OLTP PL/SQL programs with data performance issues.

Provided developer mentoring and SQL troubleshooting. Conducted code walk-throughs with

developers. Wrote queries to obtain test data and output to EXCEL for layout matching.

Skills: Application tuning, Programming, Database Administration

Tools: Oracle Enterprise Manager, Oracle 7.x SQL, Oracle PL/SQL, Oracle Programmer 2000

(

PRO COBOL

)

Client: Administration of Child Services (ACS), City of New York

- New York, New York

Description: Generated webserver modules from Designer 2.1.1 and 2.1.2. Facilitated

upgrade of clients and repository to 2.1.2 from 2.1.1. Adding functionality to Module Data

Diagrams, tables/views, APIs, etc. based on enhancement request and bug reports. Created

new modules, tables, constraints, etc. based on enhancement requests. Conducting test

script review sessions with client. Tested all modules with approved test scripts.

Facilitated changes required as a result of testing with other developers. Created base

document template (style sheet) for this application. Answered dozens of ORACLE postings

on Forms 5.0, Forms 4.5 and Forms 3.0 technical issues. Assisted other consultants on

using Developer/2000 2.x new products including Project Builder. Conducted various DBA

activities: ran AUTOTRACE utility, created trace roles and other activities to replace

manual EXPLAIN PLAN being conducted at the SQL prompt by developers; sized tables,

indexes, and constraints as well as provided indexing plans for additional performance and

wrote repository update plan from 2.1.1 to 2.1.2 and provided expertise in making

appropriate space and configuration parameter changes. Provided DBA expertise for various

additions to Oracle Database initialization parameter files for improved performance.

Provided DBA expertise for capacity planning and application sizing. Coordinated creation

of DBLINKS to communicate between machines instead of creating redundant tables.

Skills: Project Management, Joint Application Development (JAD) Facilitation, System

Architecture, Database Administration

Tools: Oracle Designer 2.X, Web Application Generator, Oracle 7.X SQL, Oracle Web

Application Server (WAS), PL/SQL Toolkit

Client:

Injured Workers Insurance Fund

(IWIF) - Baltimore, MD

Title: Project Manager

for insurance application for a Maryland Workers Compensation Fund

with a Governor-appointed board.

Description: Completed Agent subsystem models and generated database and application

objects for acceptance by client utilizing JAD sessions. Completed over 3 dozen screens

and reports (Forms 4.5 and Reports 2.5). Provided technical expertise to the Legal

Tracking Developers on Forms 5.0 and Reports 3.0. Made dozens of screen and report

enhancements. Conducted training for more than one dozen developers on using Designer/2000

for maintenance of forms, reports, and database objects. Included various examples and

scenarios for impending upgrade to Forms 5.0/Reports 3.0. Performed DBA activities

including running EXCEPTION utility to enable enabling constraints with exception

gathering, sized database for three years, added and removed indexes as required,

performed export/import after conversion activities and other performance enhancing tasks.

Skills: Project Management, Joint Application Development (JAD) Facilitation, System

Architecture, Database Administration, Preparing and Delivering Technical Training,

Programming

Tools: Oracle 7.X SQL, Oracle Designer 2.X, Oracle Developer 2.X (Forms and Reports),

Oracle Developer 3.X, IBM DB2 SQL

03/98

-10/98Florida Executive Office of the GovernorSystems Project Administrator

Description: Responsible for the Design, development and maintenance of application

modules using NT, Designer/2000, Developer/2000, PL/SQL, SQL Loader and Visual Basic.

Normalize table relationships based on requirements gathered. Provide application

optimization implementation; table, sequence and index creation; and production data

fixes. Upgrade dozens of forms and reports to Forms 5.0/Reports 3.0 from Forms 4.5/Reports

2.5. Provided regression testing methodology advice and documentation as well as executing

various cycles. Provide developers with PC and ORACLE expertise and assistance on request.

Provided methodology for index review, as well as conducting a review and implementing

indexes. Upgrade and maintain Designer/2000 Repositories. Provide design guidance,

leadership and methodology documentation using Designer/2000. Answered hundreds of emails

from the Developer 2000 mail group on enhancements in Forms 5.0 and how to use them,

including tree lists, wizards, etc.

Skills: Project Management, Joint Application Development (JAD) Facilitation, System

Architecture, Database Administration, Preparing and Delivering Technical Training,

Programming

Tools: Oracle Designer 2.X, Oracle Developer 2.X, Oracle Developer 3.X (Forms and

Reports), Microsoft Project

01/96

-03/98The Printing House, IncorporatedProgrammer III

Description: Responsible for maintaining and enhancing three large databases (ORACLE 7.2)

(including hundreds of stored procedures, database triggers, tables, snapshots, sequences,

indexes, and constraints). Responsible for composing and maintaining (utilizing re-

engineering for the majority) Entity Relationship Diagrams (ERDs), Functional Design

Hierarchies, and Data Flow Diagrams for all applications in the enterprise. Converted over

400 objects (reports, graphics and forms) to Developer/2000. Programming and designing

several large billing, telemarketing, web marketing, and publishing systems utilizing

ORACLE Forms 4.0 and 4.5, ORACLE Reportwriter 2.0 and 2.5, Developer/2000 (1.4W), Windows

3.1, Windows '95, UNIX, Shell, CRON, PERL, Visual Basic 4.0, ODBC, and Designer/2000. Work

with users extensively in requirements gathering, analysis (including Joint Application

Design (JAD), testing, implementation and change control. Served as backup DBA and

provided mentoring to inexperienced DBA. There was no referential integrity of any of the

databases when I arrived. I spent two weeks identifying, sizing, exceptioning, and

implementing over 2000 primary, foreign key and check constraints. Wrote scripts, plans

and indexes for snapshots to improve performance across the network. Wrote plan to justify

purchase of Adhawk Enterprise Management tools, which accomplished the following:

published data dictionaries for the first time, provided real-time security and

performance diagnostics. Provided a plan,implementation and technical assistance for

capacity planning which had never been done before at this location. Provided DBA

technical expertise for an INTRANET index and constraint reporting system used by

developers. Provided DBA expertise for various additions to Oracle Database initialization

parameter files for improved performance. Provided DBA expertise for capacity planning and

application sizing. Wrote storage plans, including map for separating tables and indexes.

Installed Oracle on SUN/OS Sparc hardware. Installed several patch upgrades to Solaris

ORACLE 7.X databases when sent by Oracle Support.

Skills: Project Management, Joint Application Development (JAD) Facilitation, System

Architecture, Database Administration, Preparing and Delivering Technical Training,

Programming

Tools: Oracle 6.X-7.3 SQL, PL/SQL, Oracle Designer 2.X, Oracle Developer 1.X- 3.X (Forms

and Reports), Microsoft Project, UNIX Cron, UNIX Shell, Programmer 2000 (PRO C)

09/94

-12/95Keane Federal Systems, Inc.

Senior Consultant

Title:

Senior Developer and client service representative

for two large ORACLE database

applications (i.e. Cash and Receiving (CRA) and Storage Tank and Contamination Monitoring

(STCM)) contracting for the Department of Environmental Protection (DEP).

Description: Designed, developed and maintained application modules using VAX VMS, ORACLE

Forms 3.0, SQL, SQL Reportwriter 1.0, SQL Loader and SQL Menu. Normalize table

relationships based on requirements gathered. Provided application optimization

implementation; table, sequence and index creation; production data fixes; and batch

processing scripts to DBA. Provide expertise on financial systems. Worked with DEP's

Management and Auditors to assure calculation and crosscheck modules meeting with Florida

legislation requirements and user requests. Provided developers with PC and ORACLE

expertise and assistance on request. Provided DBA expertise for various additions to

Oracle Database initialization parameter files for improved performance. Provided DBA

expertise for capacity planning and application sizing. Provided database as well as

application tuning expertise.

Skills: Project Management, Joint Application Development (JAD) Facilitation, System

Architecture, Database Administration, Preparing and Delivering Technical Training,

Programming

Tools: Oracle 6.X-7.X SQL, Oracle PL/SQL, Oracle Developer 1.X, Reports 1.0, Forms 3.0,

Microsoft Project

10/90

-08/94Cincinnati Bell Information Systems (CBIS)

Senior Systems Analyst

Title:

Senior Systems Analyst and On

-Site project leader for a $5 million switch network

management system for the State of Florida's SUNCOM network.

Description: Design, develop and maintain application modules using ORACLE CASE, "C",

UNIX, Shell, ORACLE Forms 3.0, SQL, Reports 1.0, and SQL Loader.

Skills: Project Management, Programming, System Architecture, UNIX System Administration

Tools: Oracle Casedict 5.0, Oracle 6.X SQL, Oracle PL/SQL, Reports 1.0, Forms 3.0,

Microsoft Project, Pro C, UNIX Shell, UNIX Awk

Title: Served as technical liaison and sole implementation responsible party for NOVELL

LAN interfaces and minicomputers, including hardware repair, equipment procurement,

maintenance agreement negotiation and coordination of software fix

development/implementation with other vendors (i.e. ORACLE, MOTOROLA, etc.).

Skills: System Architecture, LAN Administration, PC Hardware Repair, Programming

Tools: Lotus Notes Screen Builder, Lotus Notes Mail Administration, Novell LAN

Administration

Title: Senior Systems Engineer for COREWARE, a project to design common, reusable objects

for telephony software reuse.

Description: Facilitated months of Joint Application Design (JAD) sessions to model

existing telephony systems. Prepared and maintained common objects for corporate-wise

reuse. Design databases, indices, sequences, etc. using ORACLE CASE and good normalization

techniques. Provided DBA expertise for various additions to Oracle Database initialization

parameter files for improved performance. Provided DBA expertise for capacity planning and

application sizing.

Skills: Project Management, Programming, System Architecture, Systems Engineering, Object

Oriented Design (OOD), Oracle Database Administration

Tools: ADW Knowledgeware, Oracle Casedict 5.0, ORACLE 6.X SQL

Title: Systems Analyst for Cellware, a cellular billing system for three cellular

telephone companies in Mexico

Description: Wrote and maintained COBOL programs for financial side. Wrote design

specifications for debit and credit card programs. Met with Spanish-speaking technical

professionals in Banks in Mexico to review requirements and test data exchange tapes.

Wrote bill print programs and traveled to data center in Monterrey, Mexico to supervise

bill prints and mail-outs. Provided data center support in Spanish for all developers

program or JCL abends because I was the only Spanish-speaking developer on the team.

Skills: Programming, Requirements Writing, Test Plan Writing, Technical Documentation

Translation

Tools: COBOL, JCL,

IMS DB/DC

02/90

-09/90Midland Corporation

PC Programmer

Description: Primary responsibilities were to design and program relation database

applications (ADVANCED REVELATION) and serve as part of a three member PC/LAN Support

team.

Skills: System Architecture, LAN Administration, PC Hardware Repair, and Programming

Tools: ADVANCED REVELATION SQL, Screen and Report Tools

06/89

-01/90Access CorporationTest Team Manager

Description: Primary responsibilities were as Test Team Leader for a $700,000 ORACLE and

"C"/UNIX hardware software project. Wrote business cycles and test schedules, implemented

test data, and administered change control including code release acceptance. Authored

three manuals delivered to the customer and used in technical training. Performed and

coordinated on-site and off-site implementation and acceptance testing.

Skills: System Test Plan Creation, Technical Documentation Creation, Project Management,

Programming, data conversion and data validation

Tools: Oracle 6.X SQL, Oracle Forms 2.0, Oracle Reports 1.0, Microsoft Project

03/83

-06/89U.S. Government Civil ServiceEngineering Technician

Description: Held over fifteen different positions in Fort Bragg, North Carolina; and

Howard AFB, the Republic of Panama. Majority of responsibilities were of a classified

nature (SECRET clearance) for full life cycle development (including technical

specifications, requirements and documentation) of weapons, missile, and inventory systems

utilizing PC and mini hardware, programming in BASIC, DBASE Procedural Language, PASCAL

and others. Performed clerical, documentation and other tasks as well. Received numerous

cash and outstanding achievement awards for superior performance.

Skills: Programming, Hardware Procurement and repair, System Architecture

Tools: DBASE I SQL, DBASE Procedural Language, EXCEL macro programming, BASIC

Education

1990

University of Cincinnati

BS

in Information Processing Systems (most recent only)

Other (current year only)

July 2000 FSU CPD, Cold Fusion Development

August 2000 Oracle Education/DCC, Oracle 8i DBA I Architecture

October 2000 CPD, Oracle 8i DBA II Backup and Recovery

Contact this candidate