David C.
Truncale
9734 Bayou Woods Dr.
Baytown, Tx. 77521
phone: (281) 383-3753
e-mail:
web site: www.Truncale.com
Software Development /
Application Support / SQL DBA
SUMMARY
Click Here to Download
Full Resume in Word Format
As an experienced Software Developer, DBA, and
Applications Support Analyst, I know how to evaluate, install, create and
support automated solutions and serve and assist their users in a variety of
environments. My portfolio includes excellent problem solving abilities,
outstanding interpersonal skills, and a disciplined and mature work ethic. With
20 years of experience developing, installing and supporting systems; including
server administration, analysis, and integration work; preceded by 7 years of
financial accounting, planning, and auditing experience, I am well qualified to
provide software systems and support for business users.
EXPERIENCE
Programmer /
Analyst / SQL Server DBA
3/1995 - Present,
Truncale Consulting Services,
Houston /
Baytown, Texas - or contract employee
Since
1995, I have enjoyed a variety of experiences working as a contract or
hourly employee (direct, indirect, 1099 and/or W-2) for the following
companies: • Automotive Software Designers, Inc., Houston. November 2007 to
Present. • ExxonMobil Global Services Company (Information Technology Dept.
/ Upstream Applications Support) at the Greenspoint, Houston location. March
2007 to November 2007. • Bayer, A.G. at the Baytown Industrial Park.
February 2002 to March 2007. • CTI Texas Construction, remote development
project. Several months in 2004 and 2005. • ExperTox Laboratories, remote
development project. Several months in 2003. • Chevron Products Company,
remote development project. January 2002 to February 2002. • Enron Energy
Services at the downtown Houston office. November 2000 to November 2001. •
IBM (during the Enron engagement). November 2000 to July 2001. • Computer
Learning Centers at their West Houston campus. August 2000 to November 2000.
• Computer Techniques, remote development Project. July 2000 to October
2000. • Concentra Healthcare Management, remote development project. October
1999 to February 2000. • Lyondell Petrochemical Co. at their downtown
Houston office. February 1998 to May 2000. • Berwanger Engineering Co. at
their Greensway Houston office. January 1997 to February 1998. • Lyondell
Petrochemical Co. at their downtown Houston office. March 1995 to January
1997.
Applications Development
Manager - Information Services
5/1989 - 3/1995, Lyondell
Petrochemical Company,
Houston,
Texas
Beginning as a Sr. Systems Support Consultant supporting computing systems
in the Accounting Department, promoted through successive positions as LAN
Administrator/Legal Staff Administrator in the Legal Department, Information
Services Help Desk Manager, Computer Operations Manager, and Applications
Development Manager. Experienced not only in supervision and management
(have managed a department as large as 35 persons), but also with hands-on
user support and training.
Assistant Vice President - Financial
Planning and Systems Development
5/1988 - 5/1989, First
Interstate Bank of Texas Houston, Texas
Designed and developed planning and budgeting system for First
Interstate Bank of Texas and its 60+ branch banks. Led a team of 5
professionals, reported to the Sr. Vice President of Financial Planning.
Assistant Vice President – Branch
Banking Controller / Internal Control
5/1983 - 5/1988,
FirstRepublic Bank of Houston, Houston, Texas
Performed duties typical of an internal auditor / internal controls
officer - and later, served as branch-bank controller. During this period,
I transitioned my career from Accounting to Systems Development. Supervised
professional and clerical staff.
Sr. Staff Auditor
5/1981 - 5/1983, Deloitte,
Haskins, and Sells, Houston, Texas
In my first job after graduating from Lamar University, performed, and
later supervised, financial audits of a variety of businesses. Obtained
Texas CPA license in 1983.
EDUCATION
Bachelor’s Degree
5/1981, Lamar University,
Beaumont, Texas
Bachelors of Business
Administration - Accounting Major. GPA of 3.97, graduated with honors.
Associate's Degree
5/1990, Lee College, Baytown, Texas
Associate of Applied Science -
Computer Science. GPA of 4.00
Other undergraduate work
8/1973 – 5/1974, Rice University,
Houston, Texas
Chemistry
/ Engineering major. 33 hours completed.
Post-graduate work
1986,
University of Houston, Houston, Texas
MBA /
Information Systems Program. 6 hours post-graduate credits.
SKILLS
Skill Name, Skill Level, Last Used, Experience
•
Visual Basic (VB6, Visual Studio 2003, 2005) , Advanced, Currently used,
10 years
•
SQL Language, Advanced, Currently used, 11 years
•
Microsoft SQL Server, Advanced, Currently
used, 10 years
•
Oracle, Proficient, Used with past 2 years, 4 years
experience
•
Microsoft Access, Expert, Currently used, 12
years
•
Microsoft Excel, Expert, Currently used, 12
years
•
VBA / COM Automation, Advanced, Currently used,
9 years
•
DAO / ADO / ODBC / MS Office Integration,
Advanced, Currently used, 8 years
•
Crystal Reports, Proficient, Currently used, 5
years
•
Active Server Pages .NET / VB Script /
Javascript, Proficient,
Currently used, 3 years
•
HTML - Web Development, Proficient, Currently
used, 7 years
•
Windows NT/2000/XP Operating Systems, Advanced,
Currently used, 10 years
•
Documentation, Flowcharting, Diagramming,
Advanced, Currently used, 10 years
•
Training and Teaching, Intermediate, 2000, 12
years
•
Many others...
PERSONAL ATTRIBUTES
•
20 years systems development, support, and integration
experience in Automotive, Petrochemical, Engineering, Accounting, Plant Maintenance, Sales, Human Resource,
Corporate Legal, and Energy Risk Management businesses
•
7 years prior financial / accounting experience in Public
Accounting (Big-8) and Banking
•
Ability to work intimately with business users to
draw out and understand their business needs and requirements and to then
translate them into automated solutions - which I can design and build
•
Problem solver
•
Excellent interpersonal skills and a disciplined
and mature work ethic
•
High personal ethical standards
•
Enjoy working with people of diverse cultures, ethnicity,
and backgrounds
•
Very flexible and adaptable to various supervisor styles
and working environments
•
Self starter
ARTICLES PUBLISHED
The Lyondell NT Project - Case
in Point, Windows
NT Magazine, June 1996
CompuServe Brings NT Online, Windows NT Magazine, November
1996
Why Poet? (an Objected Oriented Database), Windows NT Magazine, November
1996
AFFILIATIONS
4/2008 - Present, Pregnancy
Resource Center East, Volunteer / Teacher
1/2002 – Present, Alliance Bible Church, Deacon, Elder, Administrative
Committee
7/2003 - 1/2007, Pregnancy
Resource Center East, Board Member / Treasurer
1/2000 – 7/2006, Baytown Christian Academy,
School Board,
President
5/1983 - 12/1997, Certified Public Accountant,
Texas
1/1991 - 12/1993, Lee Community College, Data Processing Advisory Committee
PROFESSIONAL AND PERSONAL REFERENCES
Provided upon request
Automotive Software Designers,
Inc., Houston - SQL Server DBA, Application Support and Development
November 2007 to Present
Primary duties
are those of the SQL Server DBA for this small software company producing an
extensive CRM system for automobile dealerships. DBA duties include performance
tuning, administration, backups and data recovery, db design, and programming
interfaces between SQL Server and host-based legacy systems (Reynolds &
Reynolds, ADP, and UCS). Development duties have included creating custom query
screens for the front-end application (compiled MS Access) utilizing stored
procedures and other objects in the SQL back-end. Also programmed and deployed
several VB-Script and VB.Net (Visual Studio 2005) solutions for synchronizing
files, error reporting, remote printing, and for monitoring and restarting
critical applications and services running on the application’s host server.
ExxonMobil, Houston -
Application Support Analyst, Upstream Business Applications
March 2007 to November 2007
Provided coordination of services, technical support, and programming
services for a variety of applications supported by the Upstream Business
Applications Group. Applications included
Kildrummy CostManager®,
Engineering Practices System, Safety Points Database, Financial Planning and
Budgeting Database, Access 97 to Access 2003 conversion project.
Bayer, Baytown - Database
Developer, TRACK System DBA
February 2002 to March 2007
Design, Develop, and Support various database
applications. Duties include DBA support for the TRACK time
management system used at the Baytown site. This includes writing inbound and
outbound interfaces between TRACK and Bayer’s SAP system. Also
responsible for testing and installing upgrades and fixes to the TRACK System.
Other systems developed include: Plateau custom reports web site, SLA (Service Level Agreement)
Reporting System, the Bayer Approved Vendor database, reports for the KPI
(Key Performance Indicators) system, enhancements to the existing OEE
(Operational Equipment Effectiveness) system, support and administration of the
Baytown I.S. Development group’s development server and other applications.
Tools used include SQL Server, Oracle, MS Access, Excel (VBA and ADO), MS Visual
Studio .NET 2003, and Crystal Reports among others.
Chevron Products Company
– various database projects
January 2002 to February 2002
Modified an existing, 8-year old Microsoft Access database, replacing
cumbersome screen by screen interface with more streamlined, tab-based
navigational design. Enhancements to this application also included integrating
a third-party CAD / document viewer (AutoVue) to permit users to access
and then view AutoCAD and other engineering drawings and documents from within
the application. This was accomplished through the use of OLE Automation.
Also created a new Access application to track Chevron's reimbursement claims
submitted to the TNRCC in connection with their management of underground
petrochemical storage tanks. This application involved importing existing data
from Microsoft Excel spreadsheets using OLE Automation and
ADO.
Enron Energy Services -
Data Viewer
November 2001
Enron’s geographically
remote project engineers needed to view current data from a large and
sophisticated SQL Server database located in Houston, Texas. These users were
connected to the Enron through low-bandwidth connections via the Internet.
Because of bandwidth limitations, they had been provided access to their data
through a web interface, but they were unsatisfied with the limitations and
sluggishness of the web browser’s thin client and limited filtering / sorting
/ and data manipulation characteristics. I solved this problem by using
Microsoft Access 2000 and ADO / OLE DB technology through
the new connectionless Access Data Project feature. By creating
stored procedures and views on the SQL server to retrieve
data, and Access forms with VBA code on the client, produced an
efficient, attractive, and highly flexible application to solve these user’s
business problem. The resulting client application was less than 300 KB in
size, yet capable of returning thousands of rows of filtered and sorted data
in just seconds over 128 KB connections located several states away. Total
development time was 2 weeks.
IBM (on Enron engagement) -
Energy Savings Projects Valuation Tool
June 2001 to July 2001
Working contract for IBM on the Enron engagement, created a sophisticated
Excel spreadsheet, using extensive VBA programming to
automate the valuation of Energy Savings Projects using various inputs and
energy project curve data. This push-button, automated spreadsheet reduced
the time spent by Enron’s Risk Managers to value projects by a factor of 10,
while greatly increasing the reliability and consistency of the results.
IBM (on Enron engagement) -
Actuarial Database
February 2001 to March 2001
Working contract for IBM on the Enron engagement, developed a database to
import a variety of data from Excel spreadsheets. The application
utilizes Microsoft Access for the front-end and SQL Server 7.0
for the back-end. Communication to the back-end is accomplished through
ODBC linked tables, DAO, and SQL pass-through queries. Data
is imported and input from a variety of sources – other SQL Server databases,
various Excel spreadsheets, and user input. This database captures
engineering-related data from energy savings projects and is used as an
“actuarial” database for determining probabilities of outcomes for similar
projects. It utilizes over 60 tables and 1,200 fields.
IBM (on Enron engagement) -
Portfolio Management Tool (3-tiered)
November 2000 to February 2001
Developed an Excel/SQL-Server/Web-based analysis and reporting tool while
working on a contract basis for IBM at Enron Energy Services. The Portfolio
Management Tool is an Excel Add-in that is programmed in Visual
Basic for Applications. It utilizes Microsoft Automation,
including DAO / ODBC-Direct to retrieve data from SQL Server
7.0 and Microsoft Access databases. Enron’s Asset Investment
Managers use this tool to evaluate the viability of high-dollar energy savings
projects, based upon performance ratios and graphs built into the tool.
Updating to the databases, through multi-level security is accomplished by
communicating information from Excel to the SQL Server database, through an
existing Intranet / ASP-based web site, using dynamic queries
built from the VBA code in the Excel spreadsheet. Middle-tier
database access COM components were written in Visual Basic.
Computer Techniques, Inc. -
Commercial Web Site Development
July 2000 to October 2000
Developed initial phases of a commercial Internet web site for an
independent attorney / CPA. The web site will provide continuing education
courses to attorneys, accountants, financial planners, and others via the
Internet. The site was developed in Microsoft FrontPage and Microsoft
InterDev, utilizing HTML 4.0, VBScript, Active Server
Pages, and a SQL / Access database backend. The site utilizes a
proprietary shopping cart, which I modified to implement the special
requirements of this site’s products (i.e. – the site delivers online pages
for a fee, rather than shipping physical goods).
Computer Learning Centers -
Teaching Assignment in
Relational Database Design
and the SQL Language
August 2000 to October 2000
For Computer Learning Centers in Houston, taught Relational Database
Design and the SQL Language to students enrolled in a technical,
programming curriculum. The course encompassed 100 hours of instruction – 50
hours of lecture and 50 hours of hands-on laboratory instruction. Subjects
taught included SQL language, Database Design, Entity-Relationship
Diagramming, Database Normalization, MS-Access development,
Stored Procedures, Triggers, and more.
Backstage Dancewear -
Small Business Network and Point of Sale Installation
October 2000
Recommended hardware, upgraded systems, and installed a small
network for Backstage Dancewear, a retail business based in Webster,
Texas. Installed and configured a file server to provide common access
to data files, reliable data backups, and printer sharing to all workstations
in the business. Also installed and configured the MicroBiz point of
sale system.
Lyondell Petrochemical
Company - NOx Reduction (EPA Emissions)
Automated
Spreadsheets and Database Reporting System
January 2000 to June 2000
In meeting new Federal EPA regulations, the NOx Reduction system was
created to collect data about NOx emitting devices throughout the company. On
this project, I served as the primary developer in creating a VBA /
Excel Macro-driven system of spreadsheets used by various engineers
throughout Equistar Chemicals and Lyondell. The spreadsheets are designed
with form-driven input screens which create data spreadsheets from
pre-designed templates and stores them in a central repository with an
automated document index. To collect the data from the data spreadsheets
and to facilitate reporting and consolidated analysis of the data, I also
developed a Microsoft Access database that imports the spreadsheets
using OLE Automation. Menu driven, with flexible import routines,
pre-programmed queries and reporting, this database captures over 200 data
points for each NOx emitting device.
Lyondell Petrochemical
Company - Capital Projects Database
December 1999 to June 2000
Using Microsoft Access, I designed and developed a
multi-user database with multi-level security used by Equistar
Chemicals and Lyondell to record monthly forecast and budget updates from
field engineers and project controllers. The Capital Projects Management
Database was built with a flexible data import function that allows the
database user to import data pertaining to projects, plans, forecast
updates, and actual monthly results from Microsoft Excel spreadsheets
(since not all users in the field have Microsoft Access installed). Monthly
results are exported from SAP into Excel and then brought into
the Capital Projects database for comparison to forecasts. Fully menu driven
with pre-programmed, filter-driven reports and export to MS Excel and
MS Word. Includes graphing functions.
Royal Coin and Jewelry -
Network and High-Speed Internet Installation
December 1999 to April 2000
Recommended purchase of hardware and software for Royal Coin
and Jewelry, a small business in Houston, Texas. Installed new
computers, upgraded other hardware and software (Quickbooks Pro),
and connected computers on local area network. Worked with
outside vendor to integrate high-speed DSL internet connection into
Royal Coin’s network so that all users have Internet access on demand.
Concentra Health Management
- Employee Absence Tracking
October 1999 to February 2000
System Designed and developed a Microsoft Access database for
Concentra Health Management, a supplier of health-care management services to
Equistar Chemicals. The Employee Absence Tracking database tracks employee
absences, return to work dates, doctor’s diagnoses, and various communications
to and from the employee. The system calculates various “tickler” dates to
help the company maintain compliance with the Family Management Leave Act and
other, internal company leave policies. Installed system and
trained client personnel on use as well as further development of
pre-programmed reports.
Lyondell Petrochemical
Company - Various Database Development Projects
April 1999 to January 2000
Concurrent with the Y2K Project (below), designed and developed
Microsoft Access database applications in support of the Y2K Remediation
Project, the Contingency Planning Project, Equistar Supplier Compliance
Project, and various Human Resources databases. Developed six databases for
multi-user, LAN/WAN access, utilizing the security services
within Microsoft Windows NT and Microsoft Access.
Lyondell Petrochemical
Company - Y2K Project
March 1999 to January 2000
As member of the Year 2000 Remediation team for Equistar Chemicals
Company, conducted reviews of microcomputer software and
hardware for Y2K compliance, developed and coordinated testing
programs, provided technical consultation to management
regarding technical issues with specific applications. Provided general
database technical and development support for the team
of engineers assigned to review the Y2K compliance of Equistar’s physical
plants and manufacturing facilities.
Lyondell Petrochemical
Company - Sales Force Automation System
March 1998 to February 1999
This system was developed and implemented for Equistar Chemicals Company.
The SFA system provides Equistar’s mobile sales force with daily sales
and business contact information. It was developed in Microsoft
Outlook utilizing customized forms and Visual Basic Scripting
language. The distribution system was written primarily in Microsoft
Visual Basic 6.0 and Visual Basic for Applications utilizing
Automation / OLE to package and deliver daily, customized reports
extracted from Equistar’s SAP system through Cognos /
Impromptu in HTML format for viewing by the sales force.
Baytown Christian Academy -
Network and Classroom Computer
Lab Installation
and part-time Teaching Assignment
August 1998 to May 2000
As the primary (and often the only) computer consultant for Baytown
Christian Academy, installed, configured, and supported
the computer systems in use at the school. This environment encompasses
about 50 computers, 2 LANS, and 2 Windows NT file servers. Reviewed
and recommended software upgrades for the school’s administrative and student
records and then implemented it. Created a teaching laboratory for 16
students, building some of the computers from the ground-up and
upgrading many of the others. Also provide ongoing support. As
Computer Teacher (part time) – taught High School students microcomputer
hardware, operating systems, Microsoft Office applications,
Visual Basic programming, Web site development.
Berwanger, Inc. -
Pressure Protection Manager 98
February 1997 to February 1998
Pressure Protection Manager (PPM98) is an engineering
application, written for Berwanger, Inc., a Houston-based Engineering
Consulting Company. PPM98 is used by the company’s engineering consultants in
performing pressure relief valve sizing computations and documentation
in accordance with OSHA regulations. The product was also developed to
be marketed, as shrink-wrap software, to the Petrochemical and Refining
industry by Berwanger. PPM98 is an object-oriented application and was
developed in Microsoft Visual Basic 5.0 and 6.0, utilizing a
Microsoft Access Database and Crystal Reports as the reporting
tool.
Lyondell Petrochemical
Company - Enterprise Systems
Management Review
March 1996 to February 1997
This general project involved reviewing the performance and
tuning of Lyondell Petrochemical’s Windows NT Server / Workstation
environment of 30+ servers and 1,500+ workstations and making improvements
and recommendations. Products utilized in this review included
Microsoft Premier Watch, HP OpenView, and BMC’s PATROL.
Customized development included Visual C++ applications to supplement
Windows NT Security in enhancing the manageability of Lyondell’s user
account database.
Lyondell Petrochemical
Company - Windows NT Installation
and Conversion from Novell
March 1995 to March 1996
Member of 4-person core team that directed the installation and set the
technical standards for upgrading Lyondell Petrochemical’s enterprise-wide
computing environment from Windows 3.1 & Novell to Windows NT
Workstation & NT Server. Developed installation standards,
documentation, and testing procedures. Developed
installation and conversion utilities in MS Visual Basic,
REXX, and NT Batch Command language.