Analyst proficient in ORACLE, SQL, PL/SQL, C, PRO C
Resume:
Christopher Ballard
**************@*****.***
SUMMARY
An innovative IT Consultant with expertise in relational database design, development and
implementation. Expertise in analyzing the organization’s needs to develop databases that
maximize efficiency of business processes. Recognized for proficiently troubleshooting data
integrity issues and communicating the resolution to end users and support personnel.
Demonstrated ability to collaborate with individuals at all levels.
TECHNICAL SKILLS
Databases: Oracle10g, Oracle11g, Microsoft SQL Server
Languages: SQL, PL/SQL, SQL*Forms, SQL*Loader, T-SQL, MS/DOS, VBA,
VBScript, C, PRO*C, PRO*COBOL
Tools & Technologies: HTML, XML, TOAD
Software Tools: Microsoft Office Suite, SharePoint
Applications: Maximo, Web Methods Server Administration,
Microsoft Application Compatibility Toolkit, Quorum Land System
PROFESSIONAL EXPERIENCE
OXY USA, Houston, TX 1996 – 2015
IT Consultant Maximo Application Support (2012 – 2015)
Led technical and functional support of the integration between Oracle Financials and an Asset
Management Application (Maximo). On-call domestic and international production support 24/7.
• Analyzed stored PL/SQL procedures, functions, packages and XML files to resolve data
discrepancies which caused production downtime.
• Assisted end users with mass data loads creating PL/SQL scripts which significantly
reduced data entry time.
• Monitored server health to ensure data integration processes were running between
systems.
IT Consultant Web Methods Server Administrator (2009 – 2012)
Web Methods server health, on-call domestic and international production support 24/7.
• Project lead server upgrade. Completed upgrade of 16 servers without issues before
scheduled 8 month deadline.
• Assisted desktop support team over 6 months with a routine Windows upgrade. Created
all necessary reports from the Microsoft Application Compatibility Toolkit (ACT) SQL
Server database.
Christopher Ballard 832-***-**** Page 2
IT Consultant Land Management and Revenue Systems (1996 – 2009)
Oversaw Oracle integration modules between Land and Revenue Systems. Daily interaction with
end users troubleshooting data discrepancies.
• Improved performance of the forms and queries. Reduced data retrieval from minutes to
seconds by optimizing SQL queries and triggers.
• Led ETL for land acquisitions. Designed multiple PRO*C programs and PL/SQL
procedures to load data from various formats into Quorum Land System.
• Implemented a PRO*C program to load acquisition data received in EDI format, which
omitted the need to purchase an EDI translator.
• Worked with vendor to analyze PL/SQL code and created ADHOC reports to help debug
issues. Identifying the issues for the vendor escalated time to modify code.
Texas Eastern Products Pipeline Co. Houston, TX 1991 –1996
Troubleshooting data integrity issues and on-call rotation support 24/7.
SQL*Forms application utilizing user exit functionality with PRO*C and PRO*COBOL.
• Developed mission critical applications in PRO*C which dramatically improved
performance. Daily and monthly closing PRO*C programs reduced daily closing to
seconds as opposed to 15 minutes per truck terminal and monthly closing from 8 hours to
30 minutes.
• Automated a shipping EDI application in PRO*C. Created formatted document and sent it
to shippers via EDI software.
• Developed a ticketing system generated from SQL*FORMS which eliminated the need to
manually write ticket orders and purchase pre-printed tickets.
Systems Analyst Revenue System
Troubleshooting data integrity issues and participated in monthly closing routines with the end
users.
• PRO*COBOL programs had numerous rounding errors. Created a routine in PRO*C to
manipulate numerical data and return data with greater precision. Oracle database was
on a VAX/VMS operating system. Mixed languages allowed data to be passed between
PRO*C and existing PRO*COBOL programs which eliminated the need to re-write existing
code to interact with new developments.
• Developed a Product Transfer Order application with SQL*Forms using PRO*C user exits
calling VAX/VMS system service routines that allowed the user to fax or e-mail production
orders directly to the shippers or print locally.
EDUCATION
Bachelor of Arts (Design) – California State University, Los Angeles, California
Contact this candidate