Oracle Customer Service
Resume:
Beverly J. Turner
***** ********* ***** ** Humble, TX 77396
Email: ******.******@*****.***
EDUCATION:
Bachelor of Science in Business Administration with honors - University of
Arkansas. Major: Computer Information Systems and Quantitative Analysis.
GPA=3.6. Selected Outstanding Student for Major.
Certified Oracle Professional Application Developer: Passed all five tests
required for certification: SQL and PL/SQL, Develop PL/SQL Program Units,
Dev/2000 Build Forms I, Dev/2000 Build Forms II, Dev/2000 Build Reports.
TECHNICAL SKILLS:
Operating Systems: MS-DOS, Windows 3.1 thru Windows 2000 and XP, Unix,
Windows NT, Novell.
Databases: Oracle, Visual FoxPro, FoxPro 2.6 for Windows, Clipper, dBase
III & IV.
Languages: EASE, FoxPro, dBase, Clipper, HTML, QBasic, Perl, Unix Shell
Scripting (Bourne, Korn) SQL, PL/SQL.
Misc: OOP, Oracle Forms, Oracle Reports, Dev/2000, RDBMS, Oracle
Designer/Repository, Multi-User, PC Anywhere, VFEdit, OLE,
DDE, TOAD, SQL Tools, SQL*Loader, Triggers, Stored Procedures, Packages,
Data Modeling, Quickbooks.
EXPERIENCE:
The Woodlands Moving Company - Houston, TX (Nov 2009 - Present)
*Industry: Transportation.
*Owner/Manager.
*Manage moving crew; perform all human resources, administrative,
bookkeeping, customer service, purchasing, marketing, and clerical
functions.
*Quote and schedule jobs; develop, modify, and complete all contracts and
forms; purchase pkg. materials and boxes, insurance, office supplies
and equipment, and schedule vehicle maintenance; develop
advertising, and distribute flyers; handle customer complaints and
problems.
*Quickbooks, MS Word, Excel, maintain web page.
PSI (Contractor for Professional Support, Inc.) working for Department of
Defense (DOD/DFAS) - Cleveland, OH (Nov 2007 - Mar 2009)
*Industry: Federal Government - Department of Defense Financial and
Accounting Services.
*Oracle Programmer/Developer responsible for two systems WYPC (Work Year
Personnel Costs) and ARS (Adoption Reimbursement System).
*Converted client server ARS system using Oracle DB 8i, and Oracle forms
and reports 6i to Oracle 10g.
*Custom Oracle web-based forms and reports, SQL, PL/SQL in triggers,
procedures, functions, and packages.
*Utilized TOAD: to view tables, views, user roles and privileges,
sequences, and schemas,
to develop, test, and run database stored
procedures, functions, packages, and triggers;
to write scripts to pull data and run and
test programs, and to write scripts to develop tables, views, synonyms,
data links,
and to create users, and create or modify
user roles, etc.
* Oracle 10g maintenance, enhancements, and new development.
ACT (Appraisal and Collection Technologies) - Houston, TX (Aug. 2006 - Oct
2007)
*Industry: County Government - Property Taxes.
*Oracle Programmer using custom Oracle web-based forms and reports, SQL,
PL/SQL in triggers, procedures, functions, and pkgs. using TOAD.
*Oracle 10g maintenance (break-fix), enhancements, and new development.
*Oracle Business Analyst/Account Mgr. and helpdesk (balancing, fiscal
rollover, etc.) for ACT's custom tax system for Jefferson County
Texas.
Central Florida Investments (Contractor with Veredus for 5 months) -
Orlando, FL (Nov. 2005 - Aug. 2006)
* Industry: Resort, Vacation, Financial, and Real Estate.
* Oracle Developer/Programmer using Oracle database 9i, Oracle
Applications Server 10g, and Oracle forms (10g) and reports.
* Maintained current systems, enhancements, and new screens and reports
using SQL and PL/SQL in triggers, procedures, functions, and packages, and
stored packages, procedures and functions using TOAD.
* Used explain plan in TOAD to help tune applications.
Dudley Land Company, Inc. - Houston, TX (May 2003 - Oct. 2005)
* Industry: Oil/Gas Services Company.
* Oracle Applications Developer utilizing Oracle database developer 2000
8i and Oracle forms and reports version 6i for new custom development,
enhancements, and maintenance.
* Designed, developed, tested and implemented the following complex Oracle
forms and reports using PL/SQL and SQL in triggers, procedures, functions
and packages, and created stored procedures and functions using TOAD.
* Developed new custom Fixed Asset Package based on old Access programs.
Developed Oracle tables and indexes, and exported data in Access tables to
Excel, and used SQL*Loader to port data to Oracle tables. Created 17
forms (12 similar forms to track various software installed in the
computers). The main form contains five tabs with a jpg or tif image
display of the fixed asset. This module also integrates with the general
ledger database (vendors and accounts payable). The package also includes
forms to maintain the multiple offices, locations, and categories in the
fixed asset module. Four custom Oracle reports were developed to complete
this module.
Beverly J. Turner
Page Two
* Designed and developed new Work Ticket package which included six
intricate forms and six complicated reports. The reports made use of both
the header and main pages as legal-sized multi-pages. The reports
contained about 11 groups or queries with data links, and expandable
groups within groups. This package was integrated with the Client/Prospect
package and the custom Oracle email program. Also designed and developed
tables and indexes for the work tickets.
* Developed custom Oracle email module by downloading, modifying and
incorporating Java server-side package to allow uploading of binary data
into BLOB columns. Created client-side interface for the attachment email
program that used WIN API to manipulate attachment files. Later, used FTP
to manipulate the BLOB data. Incorporated the email program to run within
several other Oracle forms.
* Developed resume access program utilizing OLE that allows multi-page
resume access to documents stored as tif files. The resumes are viewed in
Kodak Imaging software.
* Produced overdue invoices form: User can query invoices with the number
of days overdue, and then select the invoices to automatically email all
of the selected clients with overdue invoices.
* Created new workers' comp package to calculate the workers' compensation
amount due for selected time periods and various states. Report by state
and employee type with totals on each individual, and summary totals for
each category with beginning and ending balances. Incorporated this with
the paperwork and insurance form. Created tables and indexes necessary
for the module. Created script to populate table so that Users would only
need to input data for new contractors.
* Utilized OLE2, developed small program to print MS Word new hire packets
or individual documents of the packet thru Oracle. Also, created a few
simple custom employee forms and reports,
* Enhancements: "Landman Module" - stacked canvas (total revision),
employee, client/prospect (stacked canvas) and sections (total revision),
and various other forms and reports.
ESG Consulting for Harte-Hanks - Austin, TX (Jan. 1999 - April 1999)
* Industry: Marketing.
* Contract Programmer/Analyst developing and maintaining FoxPro
applications.
* Converted 2.6 FoxPro applications to Visual FoxPro.
EOTT Energy Corporation - Houston, TX (Sept. 1997 - Dec. 31, 1998)
* Industry: Oil Trading Company.
* Programmer/Analyst developed and maintained Visual FoxPro and FoxPro 2.6
applications.
* Tracked the profitability and quantity of crude oil trades.
* Total responsibility for managing three systems: Trade Capture,
Position Reporting and Inventory.
* Responsible for approximately 6GBs code.
* Responsibility for 200+ tables and 60+ users including Long Beach and
Calgary offices.
Data Management Solutions - Houston, TX (April 1997 - Sept. 1997)
* Industry: Natural Gas Pipeline Industry.
* Programmer/Analyst developed and maintained FoxPro 2.6 applications.
* Tracked the flow of gas from the well or purchase through the pipeline
points.
* Programming code for accounts payable, accounts receivable, commissions,
and general ledger.
* Heavy development of complicated screens, forms, menus, and reports.
Equal Net - Houston, TX (October 1996 - April 1997)
* Industry: Telecommunications.
* Programmer/Analyst developed and maintained Visual FoxPro and Clipper
applications.
* Converted Clipper to Visual FoxPro environment.
* Programming code for accounting, billing, provisioning, commissions, and
export and import programs.
* Developed databases, reports, objects, and menus.
Cytel - Houston, TX (July 1994 - October 1996)
* Industry: Telecommunications.
* Developed and maintained EASE and FoxPro 2.6 programs.
* Implemented Programs: Credit card calls, collect calls, Int'l call-
back, debit card calls, operator calls.
* Created validation program, and number identification program.
* Hardware: Dialogic board, SS96, EA24, Stromberg Carlson switch, PC,
Ultra Graphics 800.
Contact this candidate