Developer Sales
Resume:
Gerald W. (Jerry) Krenek
Spring, Texas 77379-8764
********@*******.***
Primary Software Skills: WebFOCUS (10 yrs), FOCUS (24 yrs)
Other Software Skills: MVS, JCL, ISPF/TSO, VM/CMS, SAS, SQL
12/2010 - 02/2011 MASTERCARD TECHNOLOGIES O'Fallon, MO
Consultant. Developed Customer Analytics reports for use by bank clients
of Mastercard, with WebFOCUS Developer Studio version 7.7.02 using Oracle
and Netezza data.
07/2010 - 10/2010 WENDY'S INTERNATIONAL Dublin, OH
Consultant. Worked as a WebFOCUS developer on a team deploying and
supporting an enterprise management reporting dashboard for company
executives and management at the well known restaurant chain. The
dashboard application was developed and enhanced in WebFOCUS Developer
Studio version 7.6.8 using Oracle data.
04/2010 - 07/2010 INSURANCE COMPANY OF THE WEST San Diego, CA
Consultant. Returned at the client's request for a specific short term
project. Implemented the FOCUS portion of the company's short term and
long term solutions for outsourcing auto insurance debts that had been
written off in house to an outside collection agency. The work consisted
of FOCUS programming and related changes, included creating files to send
to the outside vendor collection agency as well as the in house policy
management system, along with several accompanying reports. The environment
was VM/CMS Mainframe FOCUS 7.1.1 database updating and reporting.
06/2009 - 03/2010 APACHE CORPORATION Houston, TX
Consultant. Developed and maintained WebFOCUS reports and HTML launch
pages with Javascript validation in WebFOCUS MRE version 7.6.8 for the
Houston based oil and gas company. The reports were primarily for revenue
accounting and financial accounting end users, with some for marketing and
sales users as well.
02/2009 - 02/2009 NORTHERN NATURAL GAS Omaha, NE
Consultant. Short term contract. Researched and extracted pipeline and
other property data from an old standalone PC FOCUS 5.5 property tax report
system for the Nebraska based gas pipeline company. Worked with the DBA
group to properly format and prepare the data for loading into SQL Server
tables.
08/2008 - 11/2008 SOCIAL SECURITY ADMINISTRATION Baltimore, MD
Consultant. Developed WebFOCUS reports from DB2 data using Developer
Studio 7.6.6 for the Social Security Administration. Converted reports
from Hyperion to WebFOCUS.
03/2008 - 06/2008 NAIC/NIPR Kansas City, MO
Consultant. Supported and developed WebFOCUS reports from Oracle data
using WebFOCUS 7.6.4, including Developer Studio and Managed Reporting
Environment, from producer, risk bearer and appointment data for the
National Association of Insurance Commissioners and the National Insurance
Producer Registry.
12/2006 - 02/2008 INSURANCE COMPANY OF THE WEST San Diego, CA
Consultant. Supported a VM/CMS Mainframe FOCUS 7.1.1 database and
reporting environment. Maintained and enhanced the company's FOCUS based
insurance reporting systems for personal and business auto, commercial
property, commercial differences in conditions (earthquake and flood),
surety bonds and workers compensation.
01/2005 - 12/2006 MAYO CLINIC Rochester, MN
Consultant. Supported a WebFOCUS 5.3.6 MRE/DB2/MVS Mainframe FOCUS 7.2.8
reporting environment. Developed and maintained WebFOCUS reports,
Reporting Objects, Report Caster schedules, and FOCUS mainframe reports.
Tuned WebFOCUS and FOCUS reports for better performance. Helped WebFOCUS
and FOCUS users with report requests and problems. Assisted with planning
and testing for a proof of concept trial for moving WebFOCUS reporting from
z/OS to z/Linux, and then assisted with the move to z/Linux. Assisted with
planning, testing and implementation of upgrading WebFOCUS version 4.3.5 to
version 5.3.3, to version 5.3.4 and to version 5.3.6. Converted mainframe
FOCUS reports using FOCUS and VSAM databases to WebFOCUS reports using DB2
databases. Converted a COBOL program report to a set of WebFOCUS reports.
08/2003 - 01/2005 HALLIBURTON Houston, TX
IT Applications Analyst/Developer III. Developed and supported WebFOCUS
version 5.x self service applications, including both reports and graphs,
for the Houston energy services company. Reported against SQL Server
databases, Oracle databases, FOCUS databases and various extract files.
Supported an Executive Central system that provided financial reports and
graphs for company executives. Supported a Wellsight system that provided
information by well and by well interval. Developed a reporting system for
the Midland Business Development group for their Occidental customer that
showed customer job information, including completed jobs, billable and
nonbillable job time, dead time, and various other job related statistics
in both summary and detail reports, with several levels of drilldowns. Used
both WebFOCUS MRE and Developer Studio.
06/2003 - 07/2003 TARGET Minneapolis, MN
Consultant. Developed marketing campaign performance WebFOCUS reports for
the Minneapolis, Minnesota retail company. Reported against Tandem
database tables using WebFOCUS version 5.2, including Developer Studio.
05/2003 - 06/2003 HARVARD PILGRIM HEALTH CARE Quincy, MA
Consultant. Developed health care and health insurance related WebFOCUS
reports for the Boston, Massachusetts area health insurance provider.
Reported against Teradata database tables using WebFOCUS version 5.2,
including Developer Studio.
03/2003 - 05/2003 STRATEGIC MARKETING CORPORATION Philadelphia, PA
Consultant. Returned at the client's request for another short term
contract. Developed more WebFOCUS reports and graphs from physician survey
data on prescription drugs for a pharmaceutical client of the Philadelphia,
Pennsylvania market research company. Reported against SQL Server data
stored in a star database schema.
01/2003 - 02/2003 STRATEGIC MARKETING CORPORATION Philadelphia, PA
Consultant. Short term contract. Developed a number of WebFOCUS reports
and graphs from physician survey data on prescription drugs for a
pharmaceutical client of the Philadelphia, Pennsylvania market research
company. Reported against SQL Server data stored in a star database
schema.
10/2002 - 11/2002 GALLO WINERY Modesto, CA
Consultant. Short term contract. Developed several WebFOCUS reports for an
events management system for marketing at the Modesto, California wine
company using Developer Studio. The reports were part of a replacement for
a set of Microsoft Access reports.
09/1998 - 09/2002 INFORMATION BUILDERS Houston, TX
Senior Consultant on six client assignments for the WebFOCUS and FOCUS
software vendor.
Developed WebFOCUS reports on a Unix system for banking and investment
applications at JP Morgan Chase Bank in Dallas. Emphasized incorporating
the latest WebFOCUS features, especially for report formatting.
Developed WebFOCUS reports for medical and dental insurance applications,
using both WebFOCUS MRE on Windows NT and self service applications, from
DB2 tables on IBM MVS at Blue Cross Blue Shield of Mississippi in Jackson.
Created and edited HTML launch pages in WebFOCUS MRE and used native SQL
for DB2 as needed within WebFOCUS reports. Scheduled WebFOCUS reports
using Report Caster. Developed a number of batch FOCUS and SAS reports on
IBM MVS for testing, comparison and debugging. Developed WebFOCUS and
FOCUS master file descriptions from IBM MVS COBOL record layouts. Also
worked as an analyst preparing report specifications for other programmers.
Converted programs written in SAS and FORTRAN to WebFOCUS in the conversion
of an automated pricing and estimating system on IBM MVS to WebFOCUS on
Windows NT at Lockheed Martin in Dallas. Conducted testing using both
WebFOCUS and native SQL for reporting.
Developed WebFOCUS reports for human resource and payroll applications
using WebFOCUS MRE on Windows NT at Administaff in Houston.
Developed reports using FOCUS on IBM MVS and WebFOCUS MRE on Windows NT at
Textron Marine & Land Systems in New Orleans. Created reports using FOCUS,
WebFOCUS and native SQL from SQL Server tables and IBM MVS sequential data.
Developed and modified client applications on IBM MVS FOCUS in batch and
online modes for both data update and reporting at Hibernia Bank in New
Orleans. Included statistical analysis and data collection from several
banking systems for use in cost allocation.
07/1994 - 09/1998 VASTAR RESOURCES Houston, TX
Senior Systems Analyst. IBM MVS FOCUS database updating and reporting from
DB2 tables, FOCUS files and sequential files in batch and online modes for
revenue accounting, financial accounting, land and lease systems and other
applications. Installation and support of PC software packages and
internally developed applications in IBM MVS FOCUS, COBOL, SAS and other
languages for Production, Engineering, Exploration, Treasury, Tax and other
groups. Used IBM MVS SAS and COBOL for financial reporting.
10/1993 - 07/1994 AMOCO Houston, TX
Consultant. Converted salary planning system, random drug and alcohol
testing system and employee emergency notification system from IBM MVS
FOCUS to POWERBUILDER with SYBASE tables. Converted human resource systems
reporting from IBM VM FOCUS to BUSINESS OBJECTS with SYBASE tables.
Provided IBM MVS FOCUS and VM FOCUS reporting for human resource systems.
08/1993 - 10/1993 ENRON Houston, TX
Consultant. Provided IBM VM FOCUS database updating and reporting for
development and support of a newly developed natural gas sales contracts
system.
03/1993 - 08/1993 MBNA INFORMATION SERVICES Dallas, TX
Consultant. Provided IBM MVS FOCUS database updating and reporting in
batch and online modes for credit card applications. Also provided heavy
user phone support as part of a group of analysts serving as a help desk
for end users for FOCUS and related online and batch JCL issues and
questions.
07/1990 - 02/1993 BP EXPLORATION Houston, TX
Consultant. Returned at the client's request. Developed and maintained an
online IBM MVS FOCUS training management system. Supported IBM MVS FOCUS
and COBOL human resource systems with database updating and reporting in
batch and online modes, analysis, special projects and consulting for
users.
12/1989 - 06/1990 TENNECO Houston, TX
Consultant. Returned at the client's request. Developed a DB2 application
with CSP updating and IBM MVS FOCUS reporting which estimated the level of
undiscovered petroleum reserves in the south Louisiana basin. Supported
IBM MVS FOCUS systems for company take-or-pay liability, oil and gas
nominations and legislative activity.
05/1988 - 12/1989 BP EXPLORATION Houston, TX
Consultant. Supported IBM MVS FOCUS human resource systems, including an
online training management system and a batch personnel information
reporting system. Supported IBM MVS FOCUS and COBOL financial systems in
batch and online modes, including accounts payable, accounts receivable,
general ledger and leases and properties.
10/1987 - 04/1988 TENNECO Houston, TX
Consultant. Supported IBM MVS FOCUS systems for pipeline transportation,
allocation of oil and gas to markets and spot sales of oil and gas.
Provided both database updating and reporting for development and support
in batch and online modes.
03/1987 - 10/1987 MOBIL Houston, TX
Senior Programmer. Developed an IBM VM FOCUS system for natural gas volume
and revenue tracking. Supported an IBM VM FOCUS system for natural gas
sales contracts.
11/1985 - 02/1987 MITRE Houston, TX
Member of the Technical Staff. Analyst in computer capacity planning
group. Analyzed and reported on system accounting and performance data
using IBM MVS and VM SAS.
01/1983 - 08/1985 EXXON Houston, TX
Senior Systems Analyst. Developed IBM VM FOCUS systems for natural gas
sales contracts and prospects and an IBM MVS FOCUS system for oil
production reporting in batch and online modes. Supported general ledger,
sub ledger, expense reporting, income reporting, depreciation and depletion
applications using IBM MVS COBOL, FORTRAN, PL/I, MARK IV, FILEAID, SYNCSORT
and IBM utilities.
07/1981 - 12/1982 GRADUATE SCHOOL College Station, TX
07/1977 - 07/1981 U.S. AIR FORCE Eglin AFB, FL
Early Warning Systems Analyst. Supported IBM FORTRAN and ASSEMBLER
programs for real-time sea-launched ballistic missile radar detection and
warning and for maintenance of the NORAD Spacetrack satellite and orbiting
object catalog.
MBA Texas A&M University 12/1982 Mgmt Info Systems
BS Texas A&M University 05/1977 Applied Mathematics
Contact this candidate