Alan Plummer Associates, Inc.
Fort Worth, Texas

Instrumental in the conversion from Deltek Sema 4 to SQL Server-based Deltek Vision 4.0 enterprise software; researched extensive Vision data structure, developed complex SQL Server queries, researched data anomalies, fashioned global data solutions, and designed new reporting. Orchestrated the migration from Groupwise to Outlook. Researched and implemented Riverbed Steelhead WAN acceleration technology. Researched, established email policy, and implemented Oasys Mail Manager. Facilitated activities to insure that the work production was being accomplished efficiently. Defined, developed and implemented work processes and provided ongoing comprehensive oversight of internal operations and project management profitability.

Chief Operating Officer

January 2005 - September 2006

Paramount Mortgage
Fort Worth, Texas

Managed the internal operations of a mortgage broker firm, including human resources, payroll, quarterly tax returns, accounts payable, business procedures, software implementations, communications management, and IT support.  These was little office automation in place,  Great advanacements were made with simple spreadsheets and the introduction of new technology.

Special Projects

·  Implemented the Maximum Marketing campaign which included 9 pages of letters and surveys (co-branded with the Paramount logo and the realtor’s logo) that delivered information and gifts to our clients over the course of one year.  Documents were merged out of the loan origination software and filed in monthly folders for future mailings.  Gifts were ordered in bulk and stored until mailed.

·  Researched the major industry-standard loan origination software packages and interviewed their technology representatives and selected clients.

·  Implemented the installation of SQL Server based Calxy Point loan origination software and configured the system with Paramount customization including migrating all custom forms, marketing letters, and client loans since 1997 from Genesis.  Included standardizing the fields of 4,000 records required for future marketing mailings.

Technology Improvements

·  Upgraded all PCs and servers.

·  Implemented offsite server backup for catastrophic recovery.

·  Implemented scanning for all loan files and eliminated physical file storage offsite.

·  Implemented fax-to-email telephone numbers for all employees.

Business Process Improvements

·  Created loan officer prequalification with their embedded signatures that allowed them to email these to borrowers for rapid response and better client retention.

·  Created summary spreadsheets to replace manually calculated forms for loan officer commissions.

·  Created spreadsheet to reconcile lender loan purchases with warehouse banks.

·  Revised closing instructions to include bank wires, instead of checks, which improved cash flow.

·  Established direct deposit for employee payroll.

·  Built custom Peachtree reports to support quarterly tax returns.

·  Setup to pay all state and federal taxes online.

·  Developed documentation to set up coordinated employee accounts for network access, email, remote email server, loan origination software, Paramount secured website, and vendor websites.

·  Established lender documentation published centrally on the secure website.

Program Manager

April 2003 - January 2005

Ron Walker & Associates
Fort Worth, Texas

Provided client program management and managed five contract employees assigned to the General Services Administration, Public Buildings Service.

General Services Administration, Public Buildings Service
April 2003 - Present

Oracle Portal was implemented to provide a single point of contact for access to 8 national databases.  Through both Oracle Portal reports and Oracle Reports, a geographical drill down system was designed to navigate to any level of the organization for financial and other data.  Where live database links were not available to national databases, a data warehouse was built and populated at night from legacy databases.  These national databases, built autonomously, had many redundancies.  Linking the data from many systems uncovered the inconsistencies within the redundancies.  The region (1 of 11 nationally) moved from last place nationally in data accuracy to first place as a result of cross-database reporting.

Oracle Senior Consultant

July 1998 - March 2003

ThinkSpark
Fort Worth, Texas

Provided Oracle database consultation for such clients as Ernst & Young, LLP,  Central and South West (a utility holding company), Burlington Resources, Galderma Laboratories, and the General Services Administration Public Buildings Service.  All environments were multiple Oracle 7.x and/or 8.x databases, serving wide area networked users.  Consulting services included:

·  Applications DBA

·  Applications development in Oracle Forms (both client-server and web-enabled)

·  Applications development in Oracle Reports (both client-server and web-enabled)

·  PL/SQL procedures

·  Security review of access methodologies

·  Application and background process documentation

·  System architecture review

·  Performance tuning for procedures and reports with some gains from hours to minutes

ThinkSpark assignments included the following clients:

General Services Administration, Public Buildings Service
March 2002 - March 2003

This government agency needed custom applications to support an electronic document management system (EDMS) to provide access to essential documents from its field offices connected on the wide area network.  The repository included a project drawing library of over 50,000 drawings, as well as contract and lease scanning.  Using an Oracle 8i database, Oracle forms and Oracle reports were created for use in a web-enabled environment.  Viewing software was incorporated to handle both scanned and AutoCAD drawings.  Java was incorporated to support automated operating system level reads of file names to be imported into the database.  Automatic indexing was established based on file naming conventions to speed user input.  Traveled to each field office to provide on-site training on accessing and using the EDMS.
 

Galderma Laboratories
October 1999 – October 2001

This dermatological company had need for an applications dba to design and manage a customized schema to support the sales force data from the field that was administered by a vendor.  This included interface with Sales Management to determine their data and reporting needs.  The data was replicated from the vendor nightly and transformed via stored procedures to a data warehouse for reporting.  Galderma also needed an applications developer to build custom Oracle V6 reports, using this summarized data, with extensive parameter forms to simulate as close to ad hoc querying as was possible for the field.  Delivering these reports to the field via the Intranet eliminated the need to print 5 reams of reports each night and mail them to the field, as well as providing the field with timely information about their sales performance.  The impact on monthly reporting was even more dramatic.

Approximately (15) existing Oracle Forms 4.5 and (30) Oracle Reports 2.5 applications for home office use were converted to  version 6 for use on the Intranet by home office and field personnel.  This project led to extensive retrofitting of the form applications, since some were originally built with Oracle Forms 3.0 technology.  In addition many reports were consolidated into one application using advanced parameter forms and logic to allow one report to meet the needs of several reports.

Many nightly data transfer processes were rewritten to eliminate the need for temporary tables, convert client-side procedures to stored procedures,  and improve performance from several hours to a few minutes.  Ultimately this reduced the overall nightly process from 9 or 10 hours to 2 hours freeing up valuable time for maintenance on databases and servers.
 

Burlington Resources
March 1999 – May 1999

This oil and gas environment had a need for stored procedures to migrate data from one data repository to another to support data warehousing reporting to the web (Intranet).  The stored procedures translated transactional data into summary data in non-normalized tables to minimize report generation time.  These procedures translated tens of thousands of records per day in support of Oil Safety Net (daily oil allocation), Well Profitability (volumes, revenue and expenses), and a Master Well table which summarized well information from four databases and 20 tables to a unique record per well.

These PL/SQL stored procedures were created in packages of multiple procedures and utilized PL/SQL tables, records, cursors, loops, and screen reporting of results.  They were first created in the "development environment", promoted to the "test environment", and finally to the "production environment."  This project also included capturing historical information from the retired main frame.
 

Central and South West
November 1998 – December 1998

Central and South West is a holding company for several electric utility companies.  The database received transmission data from many generation and transmission points within the multi-state distribution system. The database security analysis encompassed reviewing form, report, batch report, and background process applications © and Fortran generated executables) for imbedded user names and passwords.  Since the imbedded user names found were all DBA-level database accounts, the rights granted to roles, the roles granted to users, and system privileges granted to both had to be reviewed to ensure that the appropriate users would be able to operate the applications once they were no longer connecting with a DBA-level account.

Furthermore, application access from DEC terminal station menus was reviewed to determine the extent of changes to the menu items and called *.com files to remove imbedded user names.  The logicals were reviewed for the existence of required Oracle parameters.

An implementation plan was prepared outlining the imbedded user names found, the system privileges review, the role grants, the role grant and system privilege conflicts, the structure of the DEC terminal menus and *.com files, and the order of processing changes to all of the above to ensure minimum impact on the system.  The security changes were implemented on three databases: two for development and one for production.
 

Ernst & Young LLP
July 1998 - October 1998

The Dallas ADC developed and maintained the Account Life Cycle (ALC) Version 1.5 suite of applications developed for E&Y's consultants.  These utilized background Oracle processes for report generation, as well as for transfer, upload and download of engagement and competency data between the consultants' local Access databases and the enterprise Oracle databases for human resources, financials, and ALC.  The ALC applications utilized Maestro schedules run at night to batch process jobs written as shell scripts, SQR scripts, and SQL scripts.  The Maestro schedules were researched to determine the frequency of execution, and the order and name of jobs executed, as well as their dependencies on other jobs.  The jobs were researched to determine the type and script name executed.  The scripts were reviewed to determine their functionality, and then documented in layman's terms for use by the ALC applications maintenance team.  These scripts for data manipulation and report generation were comprised of Oracle stored procedures and SQR scripts.

The Seattle ADC, in the development of a web-based income tax application for the consumer public, had developed the business rules and data entry screens, but the initial planning phase for the data model had resulted in 90 Oracle tables.  To ensure quality control, the development team requested an unbiased outside opinion from someone who had not been immersed in the developmental process. The two-week review, concentrated mostly on normalization, resulted in a data model utilizing only 30 tables – much to the relief of the developers.
 

Director of Information Systems

1992 - June 1998

Carter & Burgess, Inc.
Fort Worth, Texas

Responsible for the architecture, data modelling, object design, GUI applications development, data conversions and training for the corporate database which utilizes a centralized Oracle RDBMS V7 with Windows workstations connected in a wide area network across 18 offices nation-wide. This custom database supports data repositories for Human Resources, Project History, Project Management, Reference Libraries, Inventories and Mailing List information.

Migrated the database from RDBMS V6 to V7 and upgraded from V7.1 NetWare to V7.3 NT. The 90 percent of bulk loaded data was obtained from WordPerfect, Lotus and DBase files which all required extensive manipulation and normalization prior to loading. The extensive menu system drives forms, reports and graphics applications. User requirements to electronically own data output is accomplished using SQL Plus/WordPerfect 5.1 and Oracle Reports/WordPerfect 5.1. Images are accessed with database pointers and read by forms applications with the option to download.

Assist the users with complex queries, develop new applications, convert available data for new applications and manage the data for inconsistency trends. Responsible for the administration of parallel directory structures in each office across the WAN that contain local Oracle client-side software, database applications, and master documents utilized by support and production staff. Developed Windows help files to support the corporate database, internal operations procedures, and individual database applications.

Responsible for orchestrating the internal operations procedures, maintaining the documentation, and training new employees and newly acquired offices in Carter & Burgess' internal operations including database applications. Encompassed within internal operations are all word processing standards and office automation.

Group Manager Mechanical/Electrical/Plumbing

February 1989 - 1992

Carter & Burgess, Inc.
Dallas, Texas

Previously responsible for the management of the MEP production staff, as well as business development and contract negotiations. Technically directed the electrical design within the department.

Experience includes the design and evaluation of a wide variety of engineering projects in the industrial, commercial, municipal and institutional industries. Projects included food service facilities, retail shopping malls, country clubs, educational facilities, hospitals and medical offices.

Special projects have included preparing the procedures for all computer and hard copy document filing and archiving for all departments and their interface with accounting. I have also developed the procedures for saving and managing word processing documents and CADD generated drawing files.

Vice President

August 1985 - February 1989

Walter Cash & Partners Consulting Engineers
Dallas, Texas

Responsible for design and management of the electrical production staff, as well as business development, proposals, contract negotiations, and corporate financial review.

Special projects included designing cash flow projection and job cost spread sheets, preparing the procedures for all computer and hard copy document management and archiving, and preparing the company Personnel and Procedure Manuals.

Project Manager

January 1980 - August 1985

Fisk Electric Company
Houston, Texas

Projects included new construction and renovation of hospitals, industrial and commercial buildings. Utilizing a consultative approach with clients, I determined the scope of the desired project, prepared the bid documents, managed the purchase of materials, and coordinated the installation of projects. In doing so, I achieved an annual sales volume for the company in excess of $2 million over a four year period.

---

National Council of Examiners for Engineering

1992, United States of America, 10949

Registered Professional Engineer

1987, State of Texas, 63076