Software Engineer Data

Thomas Jacobsen

**** ***** ***

Braselton, GA ***17

770-***-**** (Cell)

404-***-**** (Home)

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

SUMMARY

Senior software engineer with fifteen plus years experience in database

software development and design for the energy, wholesale credit,

foodservice, and manufacturing industries. Creative and Analytical thinker

with exceptional organizational, interpersonal and communications skills as

well as demonstrated ability to manage multiple priorities in fast-paced

environments. Ability to convey complex solutions to end user in a

simplified manner. Dedicated team player. Expertise includes:

PL/SQL JAVA

JSP/J2EE ERWIN

Oracle SQL Tuning

PROFESSIONAL EXPERIENCE

Foodbuy, Atlanta, GA Nov 2007 -

Present

Procurement Subsidiary of Compass Group, a $9B global contract foodservice

company.

Senior Database Developer:

. Perform data model enhancements that require adding or modifying various

table structures, indexes, triggers, and constraints. One specific

example involved the Managed Order Guide subsystem due to changing user

requirements. This enhancement also involved a non-trivial data

migration process that I performed as part of deployment.

. I work in a team that supports and enhances a system that receives 20

million food purchase transactions monthly, scrubs and calculates rebates

daily, and bills food manufacturers for contracted rebates. My function

is designing and coding Oracle 11g PL/SQL batch processes and various

PL/SQL support functions and triggers to support the front-end Graphical

User Interface.

. Support the Reporting team by researching data differences between

reports.

. Create and optimize (SQL Tune) various complex report queries using both

SQL (Oracle OLTP) and MDX.(SQL Server OLAP cube).

. Perform modifications to reports in Microsoft Reporting Services.

. Write Ad-hoc queries and updates to support user special requests.

. Perform ad-hoc bulk data loads from Excel spreadsheets using Oracle

SQLLoader

. Troubleshooting issues with nightly batch processing.

CoxNet, Atlanta, GA (Now called Cox Media Group) Sep 2006 -

Nov 2007

Online subsidiary of Cox Enterprises, a media company with 12B in annual

revenues.

Software Engineer:

. Designed the data model for the new movies database application using

ERWin. This application is used across all Cox newspaper properties,

including the Atlanta Journal-Constitution, Palm Beach Post, and Austin

Statesman.

. Redesigned the data access layer for sports statistics application

written in Java to improve performance. This application has both a

public-facing web component and a XML output component to create text for

use in the printed newspaper. It utilizes Oracle Object-Relational Views.

. Designed, and coded a data loading system for a new movies database that

utilizes Oracle External Tables to load movie data from a data vendor

provided in CSV format. This movie data dynamically updates the website

with showtime data and added theaters, movies, and actors daily.

. Added RSS functionality to the AJC Shopping and Austin Shopping

platforms.

. Utilized XSLT to transform XML output from various systems to Adobe

InDesign format for use in the printed newspaper.

. Wrote various datafeeds in Java to create XML to send AJC Jobs data to

Yahoo Hotjobs. This also required writing Unix shell scripts.

. Wrote a datafeed to receive data from Yahoo Hotjobs via their RSS

interface and update an Oracle database with job data.

. Assisted and mentored other developers in database, JDBC, and SQL related

issues, Often served as a resource to the DBAs for PL/SQL related

questions.

MODIS, Atlanta, GA Jan 2006 -

Sep 2006

Consulting Company

Software Engineer:

Assigned to CoxNet

Mirant Corporation, Atlanta, GA Oct 1999 -

Sep 2005

Energy company that produces electricity worldwide with 3.94B in annual

revenues.

Senior Developer:

. Performed data model design using ERWIN for 5 long-term projects. Three

of these projects involved 30+ tables.

. Designed, coded and maintained PL/SQL stored procedures, functions, and

packages. Many of these involved data validation, scrubbing,

transformation, and loading (ETL) of various data feeds, both external

and internal, for plant telemetry recording systems and various systems

to bid electrical energy into the marketplace.

. Created database triggers, including many involving insertion/update to

views to hide higher complexity DML involving >10 tables from the middle

tier.

. Created Java stored procedures on the database for applications where

PL/SQL did not have equivalent functionality, such as Daylight savings

and time zone support prior to Oracle 9i. Other Java procedures included

a facility to normalize time series data based on plant location to feed

via a TIBCO interface, the calculation of real time Profit and Loss.

. Coded business logic and web pages in Java in a Weblogic environment

using EJB, and JSP

. Created a deployment and promotion process for database objects and

stored procedures. This process produced logs and other audit trail

information of data model changes necessary for Sarbanes Oxley

compliance.

. Performed technical evaluations of various shrink-wrapped software

products and reported my findings to management. Two of the products

resulted in a >50 seat license purchase.

. Performed SQL tuning involving the use of Explain Plan and the

appropriate combination of creating indexes, using hints, SQL statement

reorganization, and partitioning of tables and indexes. This included

mentoring other developers in writing efficient SQL queries.

. Maintained a sandbox development Oracle instance on my laptop computer.

This was used to test migration scripts where the database would need to

be refreshed frequently, as well as PL/SQL debugging where debugger

sessions would need to be force terminated without involving the DBA. To

maintain this database, I performed administrative tasks such as

import/export and table space creation.

. Assisted in the deployment of the TIBCO publish/subscribe system to allow

inbound and outbound data feeds from the database to process in real-

time.

. Performed technical screening interviews of new hire candidates and

reported findings to management.

Datascan Technologies, Alpharetta, GA May 1997 -

Oct 1999

Provider of wholesale floorplan accounting and risk management systems and

services to the wholesale finance industry.

Software Engineer:

. Wrote back end procedures and functions in PL/SQL to support a Oracle

Forms based wholesale floorplan credit application.

. Created a subsystem that would dynamically load and parse data files via

UTL_FILE, based on mappings in user configurable meta data stored in the

database.

. Tuned SQL to improve application performance and mentored other

developers in tuning SQL.

. Assisted the DBA in designing the data model using Oracle Designer

AGCO Corporation Feb 1993 - May

1997

Manufacturer of agricultural equipment and related accessories with $5.58B

in annual revenues.

Programmer/Analyst:

. Rewrote batch processes in PL/SQL that were previously written in Micro

Focus COBOL which resulted in a 30% performance increase and made the

system considerably more maintainable. I was instrumental in convincing

management to choose PL/SQL.

. I was instrumental in saving a project that was in danger of being

canceled due to inability to upgrade the database on schedule. I devised

a way that the code could run in the new Oracle version where the data

can be stored in the old database version. This saved >$10000 in

development costs already accrued.

. Rewrote existing reports to the SQR report writer to enable portability

to the Dynix/PTX (UNIX) platform, thus reducing the month-end report

processing time by apoximately 50%.

. Rewrote Orders, Invoices, and other dealer statements in SQR to be

printed graphically on laser printers that provided a modernized

appearance and saved the cost of preprinted forms.

. Created a dealer-direct web interface to the Factory Ordering system

utilizing Microsoft IIS, ASP, and VBScript. In this project, I was also

the key designer and developer in creating the subsystem that would serve

orders and invoices on demand via the web application by converting the

output of the SQR report writer to PDF format to be served to the web

browser.

. Maintained and enhanced an Accounts Receivable and Factory Ordering

system utilizing Gupta SQLWindows.

. Tuned SQL to improve performance in a Oracle 7.3 environment.

EDUCATION

Oakland Community College, Farmington Hills MI.

Associates Degree - Computer Information Systems

Associates Degree - Liberal Arts

University of Michigan, Ann Arbor MI

Pursued a Bachelor degree in Computer Science.

Attained junior level standing.

Contact this candidate