The Professional Resume of Page * of *
Lloyd Gauthier
advczk@r.postjobfree.com
EDUCATION
B.S., Computer Science
Southern University, Baton Rouge, LA
PROFESSIONAL EXPERIENCE
IT Solutions Provider
• Contractor (3/2020 – Present)
o Provided development of Perl software to process Oracle data utilizing only text format with PCL embedded code to produce invoices. Invoice system serves over 30,000 clients.
o Worked as part of team providing Perl development to assist a Fortune 100 telecommunications company’s phone conversion from analog to VoIP, to date the largest phone conversion in history.
o Provides customized software development and database services.
§ Specifically in Perl with MySQL or Oracle backend databases.
§ Provide automated data processing report generation viewable by web page or directly through email.
o Provides application support for variety of industries. o Creates small/medium size business website packages.
• IT Solutions Provider (3/2018 – 3/2020)
ExxonMobil
o Wrote PowerShell scripts to assist with managing Active Directory (AD) group memberships as well for custom software installations o Provided 1st and 2nd tier support for all Drilling and Subsurface applications for global upstream customers
o Proactively researched and presented statistics and proposal to upper management that led to global change in employee/contractor application access management that resulted in ~ +$100K / year saving as well as better ability to better satisfy IRS software cost sharing regulations
o Tested new software releases and worked with IT Services team for production and virtual server deployment
11/2013 – 12/2016
Insight Global / ConocoPhillips
Houston, Texas
GGRE Application Support Analyst – ConocoPhillips:
• Designated Paradigm EPOS & Geolog global focal point The Professional Resume of Page 2 of 5
Lloyd Gauthier
advczk@r.postjobfree.com
o Wrote Perl script to copy Geolog 7.0 well data from ‘source’ to ‘target’, creating a unique well name for each well that already existed in the target location. This would aid analysts in quickly identifying duplicate data at the well-level, instead at set-level
o Wrote Perl script to aid in new project launch that modifies an LAS (Log ASCII Standard) file to ensure that it has a unique common well name in a newly created field (CWN) by storing the value of the Unique Well Identifier (UWI) in it. The script converts LAS files from OpenWorks [Log Export Utility & Web OpenWorks
(WOW)], IP (Interactive Petrophysics), Techlog, Geolog, and Petrel. Script can be used against a single LAS file or in batch mode (every LAS file in directory) o Coordinated global (Canada, Alaska, Australia, Norway) rollout of Paradigm 15
(and 15.5) and Geolog 7.4
• Designated CGG Hampson Russell global focal point o Wrote startup script to dynamically restrict license usage by North American geoscientists
o Provided application error reports to vendor that reduced pay-per-usage (PPU) license costs
10/2012 – 11/2013
Accenture / Pyramid Consulting
Houston, Texas
Application Support Analyst - Chevron:
• Supported Petrotechnical Application Support Bellaire Office Complex (PASBOC) group by providing user access and data management services. o Wrote Perl scripts that utilize Paradigm Command Line Interface (CLI) commands as well as Linux commands to produce user / group management reporting o Served as group communication lead
o Mentored interns
3/2011 – 9/2012
EXPERIS (MANPOWER)/COMSYS CONSULTING
Houston, Texas
Lead Programmer/Analyst, Outsourcing Division - Mercer: Lead developer in the conversion, development, and testing of Perl scripts that govern the moving of data into and out of Pension administration system (BeneCalc). Project includes migration from Sybase database on an HP-UX Unix server to a RedHat Linux server communicating with a Microsoft SQL Server database. Reviewed all existing system functions to prepare for data integration.
The Professional Resume of Page 3 of 5
Lloyd Gauthier
advczk@r.postjobfree.com
• Installed and configured Perl software (5.12.3) and related modules
• Modified Perl code, as necessary, to ensure the SQL Stored Procedures (SPs) worked as expected
• Setup development server infrastructure to allow conversion of Perl scripts from UNIX- based Sybase database to RedHat Linux-based server communicating with Microsoft SQL Server, as well as overall functionality
• Converted C# code that retrieved and processed SQL Server data into Perl on Windows server
• Installed and configured FreeTDS open-source software to enable script communication with SQL Server
• Installed and configured sqsh [http://www.sqsh.org/ (version 2.1.7)] for command-line querying
• Modified code for ActiveState Perl version 5.12.4 for Windows production code to extract Microsoft SQL Server 2008 data using ODBC connectivity 5/2008 – 1/2009
JP MORGAN CHASE
Houston, Texas
Associate / Applications Support Analyst, Investment Bank Technology:
• Wrote UNIX shell scripts that utilized Smalltalk code (Topaz) to extract data from Gemstone database
• Performed roles of Systems Analyst (SA) and Database Administrator (DBA) for GemStone, a state-of-the-art platform for developing, deploying, and managing scalable, high-performance, multi-tier applications based on business objects. Infrastructure included over 2,200 blades
• Resolved more than 470 compliance issues in a single week 6/2002 – 5/2008
TEXAS INSTRUMENTS
Houston, Texas
Project Manager & IT Analyst, Test Floor and Wafer Fabrication (6/2006 – 5/2008):
• Wrote and deployed Perl script that monitored critical production services and notified appropriate personnel as needed
• Wrote Perl script to manipulate raw data for analysis by management and engineers
• Updated Oracle data via various tools to correct erroneous data for production fabrication engineers
Unix Customer Support Manager, Houston IT Services (6/2002 – 6/2006): The Professional Resume of Page 4 of 5
Lloyd Gauthier
advczk@r.postjobfree.com
• Developed automated Perl script that extracted data from Remedy database (via Oracle RDBMS connectivity) to produce web-based customer ticket metrics for daily management meetings by utilizing object oriented (OO) CPAN Perl modules. Script saved approximately $20K/year via automated tasks (replaced manual system of extracting from SAP Business Objects and manipulating data)
• Developed Perl script to extract LDAP data for UNIX user validation for various projects 11/2000 – 6/2002
AJILON CONSULTING
Houston, Texas
Staff Manager & Senior Operations Specialist, Texas Instruments, Inc:
• Wrote Perl scripts to transform flow-automation scripts, used by DSP design engineers, to a more efficient format for their Simulation Program with Integrated Circuit Emphasis
(SPICE) programs
• Created Perl/CGI and shell scripts to automate UNIX system administration tasks as monitoring of Network Information Systems (NIS) servers
• Promoted to Staff Manager after 3 months on client site 5/1999 – 11/2000
BANK UNITED/WASHINGTON MUTUAL
Houston, Texas
Senior Information Systems Auditor:
• Conducted audit examinations of the internal controls provided by the Information Systems Audit and Control Association (ISACA). Duties entailed conducting internal audits, writing internal audit reports and preparation of work papers.
• Contributed to development of Bank project management methodology. Analyzed Windows NT systems for proper security procedures and developed an audit program for the auditing thereof. Coordinated and administered department’s Windows NT test lab.
• Had extensive involvement with the Bank’s disaster recovery/business resumption program and help desk services audits.
10/1997 – 4/1999
LANDMARK GRAPHICS / HALLIBURTON
Houston, Texas
Consultant:
The Professional Resume of Page 5 of 5
Lloyd Gauthier
advczk@r.postjobfree.com
• Managed user accounts, tested the integration of data between OpenExplorer and OpenWorks products, and the accuracy thereof.
• Performed quality assurance testing (including regression and aged) of Landmark
(particularly GIS ArcView-based) products (OpenExplorer GIS) on several UNIX platforms
(some through Citrix interface) as well as Windows NT 4.0.
• Performed defect/enhancement tracking from development to certification phase of software development and reported them to development staff through Scopus.
• Provided informal training for personnel unfamiliar with GIS software. 10/1996 – 10/1997
EXXON EXPLORATION COMPANY
Houston, Texas
Consultant:
• Proposed and developed automated system consisting of Arc Macro Language (AML) and UNIX shell scripts to archive/update data into several INFO databases, as well as ORACLE database. Participated in weekly development planning meetings with management personnel of client that oversaw the scope/direction of the automated system.
• Presented development proposals and demos to management. Supervised project schedule of co-workers. "Georeferenced" geospatial coverages and defined coverages with correct projection. Documented the development/implementation of a UNIX icon to execute the automated utility on a Solaris platform.
• Conducted technical interviews for potential employees. 10/1993 – 10/1996
CDSI / ACS GOVERNMENT SOLUTIONS GROUP
New Orleans, Louisiana
Systems Development Specialist, Department of the Interior:
• Designed menus, modified ProC programs, performed some UNIX system administration tasks, set up C-shell script files for users, temporarily performed duties of supervisor in his absence, documented procedures for software maintenance.
• Developed GIS applications using Arc/Info, maintained spatial databases, developed standards for maps created with Arc/Info, performed ORACLE data queries using SQL*PLUS while developing standards for integrating data with Arc/Info database.
• Assisted in maintaining applications that involved the mapping of 2D and 3D seismic data. Performed development testing of ArcView-based application.