Sales Software

TOM HERNANDEZ

Huntington Beach, Calif. ***** *******@***.*** 714-***-****

QUALIFICATIONS

A Programmer Analyst with experience performing business analysis, systems analysis, software design,

development and testing, and providing customer support. Have strong skills in requirements gathering,

analysis, verbal and written communication, and use of SQL for database reporting.

PROFESSIONAL EXPERIENCE

Computer Sciences Corporation 06/2010-04/2014

Systems Programmer: Provided technical support for IBM Mainframe relational database products

used within Boeing

Installed software upgrades for DB2 z/OS using MVS-based tools such as JCL, TSO/ISPF, VSAM

and SPUFI. Responded to trouble tickets by providing technical support to users of DB2.

Supported nightly execution of production batch jobs.

Used Microsoft Word and Excel to document system upgrades and track organization readiness for

change implementation. Coordinated system changes involving many organizations.

Boeing 12/2004-06/2010

Programmer Analyst: Modified and maintained a software application that interfaced with multiple

Materials Requirements Planning systems and the Corporate Accounting System.

Worked with accountants to document requirements for enhancements to existing reports, so that

they could more easily reconcile discrepancies between inventory and parts-cost reports.

Designed, coded and unit-tested software using COBOL, JCL, TSO/ISPF, FileAid and other IBM

mainframe tools. Debugged existing software to identify defects causing incorrect results.

Provided on-call support for nightly, weekly, and monthly batch job execution by troubleshooting

abends and resolving other production issues.

Documented system interfaces and work flow using Microsoft Word and Visio flowchart tool.

Created SQL queries to merge DB2 data from multiple software systems in order to identify and

resolve variances between accounting reports.

Mitsubishi Motor Sales of America 09/1997-12/2004

Systems Specialist: Designed, developed, and tested software for an Automotive Parts application.

Supported business analysts in the Parts and Service department.

Developed COBOL DB2-based software and performed varied levels of testing for Mitsubishi’s

Parts application. Made significant quality improvements, and enhanced the ability of parts

analysts to track inventory and sales.

Analyzed business requirements of Pricing Analysts. Developed design documents such as Word

documents and spreadsheets to describe system designs. Worked with business analysts and

managers to ensure that requirements were correctly communicated and implemented.

Recommended system improvements to users, explaining how existing programs were not meeting

business requirements, and how design changes could correct existing system deficiencies.

Facilitated the decision making by business analysts and managers by developing ad-hoc SQL

queries and creating on-demand reports in response to their questions about various aspects of parts

sales and inventory.

Significantly improved accuracy of financial reports that track profitability and volume of parts

sales by developing reporting programs. Demonstrated an excellent attention to detail by

developing SQL queries that demonstrated quality improvements to management reports.

Delta Computer Consulting 11/1995-09/1997

Quality Assurance: Tested data conversion performed for the implementation of a new automotive

parts management system.

Designed and developed test plans to verify the accurate conversion of Mitsubishi Motors sales,

purchasing, inventory, pricing data from a sequential-file system into a DB2-based system.

Executed test scripts, documented expected and actual testing results, and tracked defect resolution.

Created innovative SQL queries to automate verification, in order to demonstrate successful

conversion to end users.

Improved the quality of data conversion by analyzing existing business data and identifying

conversion issues that were not addressed in original functional specifications.

Farmers Insurance Group 05/1993-11/1995

Advanced Software Engineer: Designed, developed, and tested portions of an automobile-insurance

software application.

Interviewed insurance underwriters to determine business requirements. Developed use-case

scenarios to identify business triggers that the proposed system needed to address. Participated in

design meetings in order to gain client acceptance of the system design.

Performed business process re-engineering of the company’s existing insurance system,

decomposing software programs into programming specifications, then into business rules, in order

to document the business requirements of a new system being developed.

Supervised the analysis performed by other team members.

Wrote Design Specifications for software programs used to support the work of underwriters.

Provided technical direction to other programmers implementing those specifications.

Developed and tested software written for the IBM-mainframe and Windows environments.

EDUCATION AND TRAINING

B.S., Computer Science, California State University Northridge

Completion of college-level courses in software testing and in the programming languages, Java, C, and

HTML

Company-sponsored technical courses: DB2 application design, DB2 database administration, DB2

system programming, SQL concepts, and Software Development Methodologies, Microsoft Word, Excel,

Visio.

Contact this candidate