Oracle Developer

[pic][pic] [pic]

Bradford M. Allen, MCSA, OCA

*** *** *****

Santa Fe, New Mexico 87501

505-***-**** (C)

Email ****.*****@*****.***

Education:

Master of Science - Finance, May 1991

Louisiana State University - Baton Rouge, Louisiana

Bachelor of Arts - Economics, December 1987

Southwestern University - Georgetown, Texas

Professional Certifications:

Microsoft Certified Systems Administrator - Windows - 2000

Microsoft Certified Professional - Installing, Configuring, and

Administering Microsoft Windows 2000 Server

Microsoft Certified Professional - Windows 2000 Network Environment

Microsoft Certified Professional - Windows 2000 Network Infrastructure

Administration

Microsoft Certified Professional - Microsoft Windows XP Professional

Oracle9i Database Administrator Certified Associate

Software, Language and Systems Experience:

Oracle 9i ( Oracle 10g ( Oracle 11g ( TOAD ( Oracle AS 9i ( Oracle AS 10g (

Oracle APEX (formerly HTMLDB) ( ActiveWidgets ( Ext.JS ( Oracle BI

Publisher ( Oracle Internet Developer Suite ( Oracle Forms ( Oracle Reports

( JavaScript ( AJAX ( Oracle J Developer ( Oracle Data Miner ( Oracle

Enterprise Manager ( Oracle Data Loader ( Redhat Linux ( Crystal Reports

( Business Objects ( Visual Basic ( SQL ( PL/SQL ( VBScript ( HTML ( DHTML

( XML ( Web Services ( SOAP ( TCL ( Expect ( Microsoft Server 2000

(Microsoft Server 2003 ( Microsoft Active Directory ( Microsoft Windows

2000 ( Microsoft Windows XP ( Microsoft Vista ( Microsoft Excel (

Microsoft Access ( Cincom ID Workstation ( Attachmate Extra ( Putty (

SFTP ( Extra Basic ( Hummingbird Host ( Xceed ( Adobe CS4

Employment History:

03-01-10 - Present

Logic

Minneapolis, MN

BI Publisher Developer

Contract Assignment for US Veteran's Administration, VHA Veteran's Canteen

Service in St. Louis, MO.

Developing custom BI Publisher reports for Oracle Financials R12 and Oracle

Retail R12 implementation.

180 custom financial reports with direct queries to Oracle Financials

Database.

Custom PL/SQL and Model queries.

11/15/09 - 2-01-10

OUREA

Colorado Springs, CO

Sr. Oracle Application Express Developer

Contract Assignment for US Department of Justice, Kansas City, Missouri

APEX Team Lead.

Utilized APEX 4.0 Early Adopter Version,

Developed flight reservation and tracking system application for Justice

Prisoner and Alien Transportation Service (JPATS) in APEX with tie ins to

Oracle OTM R12 and Oracle Financials R12. Heavy use of Ext.JS,

ActiveWidgets, AJAX, JavaScript.

10/09 - 11/15/09

Acclaim Systems

Philadelphia, PA

Oracle Application Express Trainer/Developer

Contract Assignment for Cobb EMC, Marietta, Georgia.

Train IT Developers in Oracle Application Express (formerly HTML_DB).

Provide both formal classroom and hands on training for Oracle Application

Express to the IT Development Staff of a large electric and gas utility.

Training shall include Oracle BI Publisher. Assess staff and make

recommendations for environment and setup. Aided in the conversion of 100

Lotus Domino applications to Oracle Application Express.

1/08 - 10/09

Applications Developer/Senior Database Administrator

New Mexico Secretary of State

State of New Mexico

Santa Fe, NM

DBA for state voter registration database. Oversaw all aspects of

administration and recovery for this critical system. Developed various

web based applications for the New Mexico Secretary of State. Oversaw

hardware setup and IT purchasing.

Developed Campaign Finance reporting System using Oracle Apex, Oracle BI

Publisher and PL/SQL to track campaign contributions, loans, and

expenditures with robust search and data entry features.

Performed ad hoc queries and developed PL/SQL packages on all Oracle

databases.

Developed and maintained MS Access databases. Developed MS Excel

spreadsheet with links to Oracle databases.

Served as the backup web administrator for all web applications ad sites,

9/07 - 11/07

Web Applications Developer

Verispan LLC

Waltham, MA

Develop Ajax XHTML/DHTML Web Applications using Oracle APEX and Adobe

Creative Suite 3 for Drug Data company based on an Oracle Data Warehouse.

Use Ajax and DHTML techniques to develop customer facing applications for a

156 terabyte Data Warehouse. Build interfaces to the Data Warehouse for

custom web based Applications.

10/06 - 9/07

Database Administrator/Applications Developer

Product Support and Technology/Information Services

University of Massachusetts Medical School

Worcester, Massachusetts

Responsible for design, development, and writing of PL/SQL Packages,

Procedures, and functions for use in applications for Oracle 9i, and Oracle

10g environments. Works closely with Business Analysts and Java Developers

to plan and produce final applications.

Major Accomplishments.:

. Designed Package to verify Public School Medicare Claim calculation

using advanced PL/SQL concepts such as table functions, Oracle

Analytical functions and modularized code. New features may now be

added to the program by selecting appropriate modularized code

resulting in faster change/upgrade timeframes. The package was also

significantly faster and more efficient than the code was designed to

verify.

. Redesigned storage tables for historical point in time data for

reports resulting in more efficient data storage and much faster data

retrieval.

. Designed a database approach for calling report and file names

replacing a hard coded list allowing changes to be more easily made

and storage for historical reports.

. Managed all database aspects of a project to migrate an application

and database from MS SQL Server to Oracle. Including all table and

PL/SQL package design. Supervised another DBA resource during this

project.

1/05-9/06

Database Administrator II

Local Government Division

Department of Finance and Administration,

State of New Mexico

Santa Fe, New Mexico

Responsible for all aspects of database administration for the agency.

Administer Oracle 10g Database running on Red Hat AS4 Enterprise Linux.

Administer Oracle Application Server 10g with Forms and Reports.

Responsible for all aspects of Oracle Application and Oracle Web

Application Development. Develop applications in Oracle Forms and in Oracle

APEX (formerly HTML_DB). Responsible for all reports Development in Oracle

reports. Responsible for all aspects of development for a Statewide Grant

project management and accounting system running on Oracle. Responsible for

all IT purchasing and budgets for the Division. Responsible for all IT

licensing and contractual agreements for the Division. Responsible for all

hardware software administration, maintenance, inventory, security and

upgrades for the Division. Responsible for all IT planning for the

Division. Participated in all Agency IT planning and initiatives.

Participated in Statewide IT Planning and initiatives, Responsible for

Server and Network Security.

Major Accomplishments:

. Development of Statewide web based Grant Project Management and

Accounting System Using Oracle APEX (formerly HTML_DB) along with

JavaScript and Ajax concepts.

. Designed and developed over 20 Oracle Apex (formerly HTML_DB)

applications integrated with Oracle Reports.

. Migrated applications from Oracle Forms to Oracle Apex (formerly

HTML_DB) allowed for faster design and development giving a greater

number of staff members immediate access to information.

. Migration from Oracle Forms 6i Client/Server to Oracle Forms 10g 3

tier architecture.

. Designed a project to put self service information and forms on the

internet for self service public access using Oracle Apex (formerly

HTML_DB).

. Implemented and Installed Oracle Application Sever including selection

and purchase of all hardware and software components.

. Migration from Oracle Database 9i to 10g including migration to Oracle

ASM.

. Installation of a new 64 bit server for Oracle database including

selection and purchase of all hardware and software.

. Migration of Oracle Servers from Windows 2000 Server to Red Hat Linux

AS4 (64 bit).

. Integration of Oracle database and COBOL based Central Accounting

System.

. Integration of Oracle database and Peoplesoft Central Accounting

System.

. Revamped and Reorganized approximately 70 Oracle reports.

. Participated in Agency conversion to Windows Active Directory.

. Participated in Statewide Email conversion to Microsoft Outlook and

Microsoft Outlook Web Access

. Upgrade of all workstations from Windows 2000 to Windows XP.

. Upgrade of all workstations from Office 2000 to Office 2003.

9/02-1/05

Database Administrator/Quality Control Analyst-Network Applications Support

AIG Annuity

Amarillo, Texas

Preformed Database Administration for the Automated Policy Assembly test

database.

Preformed ETL from COBOL to Oracle database. Tested data transferred from

COBOL Mainframe into Oracle 8i for accuracy and completeness. Worked with

COBOL programmers to correct code errors. Created new and test policy

Documents using Cincom ID Workstation and Microsoft word. Worked with

Business Objects and Quest Software's Tool for Oracle Application

Development (TOAD). Wrote test plans for output testing. Developed

Mainframe Macro in Attachmate's Extra program programs to make Data

Processing and Customer service representative more efficient. Work on

Imaging and Production Processing systems.

Major Accomplishments:

. Developed Mainframe Macro's that resulted in a 20% increase in

efficiency

. Introduced the use of matrices in policy production which resulted in

a shorter job run.

. Worked on over 40 new Policies Packets.

11/00-2/02

Network & Phone Administrator/Senior Registered Sales Assistant

Morgan Stanley

Santa Fe, New Mexico

Administrator for Windows NT network with three servers, twenty-seven

workstations two Lexmark Optra T620 monochrome printers, one Lexmark Optra

1200 color printer, and various other peripheral equipment. Set up and

administered user accounts including email accounts. Upgraded and

maintained all hardware and software. Responsible for all inventory. Backed

up servers. Troubleshot and maintained equipment. Liaison between Dallas,

Texas and New York, New York IT departments and branch. Provided support

and training for branch office personnel. Set up phones and voicemail

accounts. Managed phone system. Provided sales and operational support to

brokers.

8/00-6/01*

Researcher-Executive Search Database

Spencer Stuart

Santa Fe, New Mexico

Researched candidates for executive placement using the Internet and other

information sources. Populated database with candidate information.

Performed database queries and generated candidate lists for placement

consultants based on those queries.

*From 11/00-6/01 worked 30 hours a week while working for Morgan Stanley

4/99-4/00

Securities Analyst

Regulation & Licensing Department

Securities Division

Santa Fe, New Mexico

Reviewed securities registration document submitted by firms seeking to

register and sell securities in the State of New Mexico. Approved or

disapproved registration applications in accordance with State securities

statutes. Supervised Junior Analysts. Interpreted State securities statutes

regarding securities registration for constituents. Managed a project to

migrate the registration database from an AS/400 Cobol based system to a

Windows based client/server system. Worked with programmers, end users and

IT staff to build new database.

7/97-12/98

Fund Accountant

Davis Selected Advisers

Santa Fe, New Mexico

Fund Accountant for a large Mutual Fund company. Produced Director's

briefing booklets for Board of Directors meetings. Responsible for all

aspects of production including gathering data, calculating ratios and fund

performance, data layout and presentation, and delivering press ready

documents to the printer. Downloaded Accounting and Pricing data in to fund

database from custodial banks on a daily basis.

Served as Bloomberg information systems trainer. Responsible for securities

settlement, fund pricing, foreign exchange trading, and other accounting

duties.

7/97-12/98

Chief Equity Trader

Employee's Retirement System of Texas

State Employee's Pension Fund

Austin, Texas

Oversaw equity trading for a 5.5 billion dollar equity portfolio.

Supervised all domestic equity, foreign equity, and foreign exchange

trading. Supervised Junior Equity Traders and support staff. Responsible

for all trading desk technology including Bloomberg, Reuters, and Portia,

accounting systems, and all trading desk computers, printers and servers.

Lead a project to update and improve all trading desk systems and

technologies.

3/94-2/96

Senior Options Trading Specialist

Charles Schwab & Co., Inc.

Brokerage Firm

Indianapolis, Indiana

Account Executive for the firm's most active option clients. Placed complex

option trades and provided strategy and information for the firm's clients

and other brokers.

Managed the desk when desk manager was away. Monitored and managed client

and firm risk. Used advanced computer systems to calculate, manage and

monitor risk. Lead Bloomberg trainer for the options and high value trading

desks.

3/93-3/94

Registered Representative

Charles Schwab & Co., Inc.

Brokerage Firm

Midland, Texas

Provided investment advice and service to firm's clients. Branch Options

Trading Specialist. Reconciled deposits and disbursements for the branch

office. Branch equity trading specialist.

Contact this candidate