John Harralson
Austin,Texas
Summary
Contributes several years of professional experience in multiple roles including Consultant, Technical Support, Department Head, Data Migration Consultant, and Systems Analyst. Extensive experience in design, implementation, and documentation of large integrated systems. Experience in managing a large group of software engineers and technicians. Effective speaker and instructor. Enjoy interacting with people. Held multiple senior level technical positions as well as managerial positions.
Overview
58
58
years of professional experience
Work History
Trust Administrator
C.E. Harralson Family Trust /AGA Insurance Broker
10.2013 - Current
- Managing family investments
- Developed and maintained a MySQL database of stocks, bonds and real estate utilizing Java GUI interface
- Produced financial reports for periodic review of performance, preparation of taxes
- Medicare sales representing 10 Medicare Advantage companies
Project Leader
University of Texas at Dallas
01.2012 - 09.2013
- Conducted meetings and kept track of progress and issues related to timely completion
- Facilitated interfaces between the IR personnel required to extract data files from PeopleSoft and the MS Access programmers
- Facilitated interfaces between the Budget personnel who were the recipients of the tool and the MS Access programmers
- Submitted periodic reports on the schedule of progress to all team members in IR, Budget, and the MS Access developers
- Built a Detailed Transaction table for PeopleSoft Accounting Actuals Working closely with a PeopleSoft consultant from CIBER, developed a proposal for a table to be built from 8 Accounting Lines tables in PeopleSoft
- Meeting periodically with personnel from Finance, fine-tuned the design of the table to meet specific requirements for Finance
- Developed a set of 8 individual SQL scripts to extract data from the respective Accounting Lines tables, and constructed a single table for this extract
- Proved the results were correct by writing a Java program to compare the Detail Transaction values to PeopleSoft General Ledger table
- Found some discrepancies between the Detail Transaction table and the General Ledger
- Wrote a java program to drill down the differences to the account and the journal entries associated with these differences
- Apparently, this nature of reporting does not exist anywhere in the PeopleSoft standard reporting or in the customization
- Spent two weeks with the MS Access Developers reviewing and documenting every aspect of the Budget Tool, including forms, tables, procedures, SQL scripts, and reports
- Captured all of my notes in a word document that was distributed to IR and Budget personnel for review
- Wrote a java program to combine all the Merit spreadsheets into a single spreadsheet
- Wrote a SQL script to prepare a report to the VP of Budget and Finance on the cost of administrative support personnel to the University
- This report was part of a presentation made to the president as a proposal for job enrichment for this staff.
Consultant
Integral Process Improvement, LLC
02.2011 - 01.2012
- Worked independently developing a Salesforce CRM application.
Consultant
Onshore Technology Macon
08.2010 - 12.2010
- Hired as a senior resource to mentor new trainees in application development
- Company is dedicated to compete with off-shoring of software development by training individuals located in depressed labor markets in the United States, thus providing opportunities for U.S
- Citizens, and offering rates that are competitive with foreign competitors
- My role has also been to do software development in JAVA and JavaScript within the Spring framework for a client developing medical record keeping
- Also responsible for testing, and creating automated scripts for testing, and mentoring of new trainees.
Consultant
Dairy Farmers of America
09.2008 - 11.2009
- Implemented and maintained batch and interactive processes in PL/1, MVS, DB2, and CICS to support the payroll function for the Dairy Farmers cooperative
- Dairy Farmers of America is the largest cooperative representing farmers from across the United States
- My assignments included conversion of several VSAM files to DB2 tables, and the corresponding rewrite of the associated batch and CICS PL/1 programs
- Also developed several new CICS screens and batch programs
- Original contract was for 6 months, but was extended several times for a total of 14 months.
Consultant
Wal-Mart
08.2007 - 09.2008
- Implementing batch processes in COBOL, MVS, DB2 and Teradata to support tax exempt customer verification for Sam's club and Wal-Mart
- Several states have agreed to verify a quarterly electronic transmission of customer data to ensure those customers have a valid tax-exempt status – this in turn relieves Wal-Mart of any liability for uncollected taxes for customers who may not in fact be tax exempt
- Responsibilities include building batch data streams of customer data, and making those files available for remote FTP access by participating states
- Also responsible for taking the return data from each of the states and preparing customer profiles for reporting for those customers with issues with their tax-exempt status
- I have the overall responsibility for determining user requirements, turning those requirements into specifications, and implementing the requirements.
Consultant
EDS - SABRE Inc.
09.2006 - 06.2007
- To evaluate feasibility of migration of existing mainframe system to UNIX based data mediation tool
- Mainframe systems are based in the MVS operating system, and are written in PL/1
- The proposed UNIX based system has been used to successfully replace simple mainframe systems at SABRE
- The task is to determine if a more complex system could be replaced as well
- MVS assignments to change OS JCL and PL/1 programs in order to support phased Unix implementations
- UNIX assignments to develop shell scripts in ksh and bash to support the conversion effort
- Contract is for 10 months – September 2006, through June 2007.
Technical Analyst/Consultant
Conversant, Inc.
06.2003 - 06.2006
- Conversant is a subsidiary of Empire District Electric, Joplin, Missouri and is engaged in the development of Customer Information Systems for the Utilities industry
- The primary product, CustomerWatch, is based upon open-source technology utilizing Java as the implementation language
- CustomerWatch is designed to access open-source relational databases, including Oracle, SQL Server, and DB2
- My responsibilities include providing programming development support for new releases of the product, as well as custom changes for new customers
- Primary responsibility is developing conversions for new customers into CustomerWatch
- Most recent assignment requires interfacing to customer data stored in MS Access databases for 45,000 customers
- My conversion proceeds by reading the MS Access tables via an open-source SQL processor and populating the proper CustomerWatch tables and columns, for this customer in Oracle
- The conversion deals with approximately 60 tables with 700 plus columns
- Also, generally responsible for designing/implementing the integration of external data sources into CustomerWatch
- I use Eclipse as an IDE and CVS for source code version control
- Wrote several PL//SQL scripts to support the conversion.
Perl Implementation Consultant
Financial Times Interactive Data
07.2002 - 03.2003
- Migrating routines from a VM mainframe environment to a UNIX/Perl environment
- Interpret and understand current financial data routines in a mainframe environment and re-engineer the same routines in a UNIX/Perl environment
- Access is to a common database of financial data, and the output to the customer is to look the same in UNIX as it appears from the mainframe.
Systems analyst
Southwest Missouri State University
11.2001 - 07.2002
- Responsible for supporting systems related to Human Resources, Security, Telecommunications, and Procurement
- Systems are written in COBOL utilizing DB2 and CICS in a DOS/VSE environment.
Data Solutions Integrator/Migration Specialist
LOGAN/BRITTON, Inc.
08.1997 - 10.2001
- Retained for the L/B practices for Data Solutions Integration for Data Transformation, Data Conversion, Data Warehousing, Data Migrations and Data Mining
- Served the following clients: Allstate Insurance, Compaq Computer/KPMG, Pratt & Whitney, Acxiom Corporation, SITA Corporation, GTE.
Senior Analyst
HOECHST CELANESE CORP.
01.1996 - 04.1997
- Primary duties included analysis, design, and implementation of a PL/1 IMS DB/DC system which supports the routine duties of customer service representatives and the strategic corporate goals in setting prices for products.
Consultant
SABRE DECISION TECHNOLOGIES, AMR CORP
01.1995 - 08.1996
- Worked with existing MVS Ticketing systems that are written in PL/1, utilizing TSO/ISPF Clists
- Learned file systems associated with different ticket stock, including electronic tickets
- Made improvements to existing programs, made Y2K changes, and provided extracts of purchase data to Marketing for future promotions
- Analysis, design, and implementation of an ORACLE-based demand forecasting system in a Sun UNIX environment
- Experience included C and Pro
- C programming as well as relational table design and SQL programming
- Also had extensive knowledge of existing MVS forecasting system which is written in PL/1 and SAS, and some experience with TSO/ISPF C lists and REXX.
Senior Consultant
Superconducting Super-COLLIDER LABORATORY (SSCL)
01.1990 - 01.1995
- Primary duties included analysis, design, and written specifications for financial users of the ORACLE Financial System
- Utilized knowledge of the various functional areas of Finance, as well as an in-depth knowledge of the ORACLE Financials product and Data Base Management system
- Often had to model desired program results using high level tools such as Data Prism and Data Pivot, as well as low level tools such as C programming
- Last project was to prepare for further downsizing by establishing a micro-based networked accounting system (MAS90) to replace the current ORACLE Financial System
- Wrote several personnel and financial applications in FOCUS for satellite offices.
Director of Information Resource Management
PRINCETON UNIVERSITY PLASMA PHYSICS LABORATORY
01.1976 - 01.1989
- Developed an on-line data processing and Management Information System (PUBSYS)
- System is fully integrated and performs accounting, budget, payroll, purchasing, receiving, government reporting, and University reporting
- Worked closely with interdepartmental administrators to determine system requirements
- Managed the production and maintenance of PL/1 and COBOL code for data entry, database management, and reporting
- Personally produced much of the code in PL/1 for interactive reporting
- Wrote several routines for migrating VSAM data files to FOCUS tables, and wrote subsequent inquiries using FOCUS HLI to query the tables.
Programmer/Analyst
PRINCETON UNIVERSITY
01.1970 - 01.1976
- Developed a student records system, which maintained current and historical academic and personal data for students
- Worked with the registrar and other academic officers of the university analyzing needs and requirements, designed system, and performed all programming
- System was written entirely in PL/1 and maintained student and course relations in IMS databases (logically related)
- Completed design and implementation of a budget system for the Controller.
Programmer/Analyst
IBM Corporation
01.1968 - 01.1970
- Was responsible for the implementation of an Order Entry system
- I was responsible for managing a group of six programmers, along with my own development responsibilities, for a PL/1 based Order Entry system
Programmer/Analyst
New York Life Insurance Co
01.1966 - 01.1968
- Trained in PL/1 programming
- Wrote several routines implementing Record I/O functionality for PL/1 in Basic Assembly Language.
Education
MBA - Finance
Rider University
Lawrenceville, NJBA - Economics
University of Missouri
Columbia, MOSkills
1 Senior programmer/analyst in a variety of programming languages with experience in multiple settings
Skillset
- PL/1
- COBOL
- MVS
- JCL
- SQL
- IMS DB/DC
- DB2
- REXX
- C
- ORACLE
- PL/SQL
- PERL
- UNIX
- Java
- Python
- Eclipse
- MS Access
- Endevor source code management
Training
- SAP ABAP/4 certification in September '98
- ETI
- Extract Certification for Masters Users July '97
- Object Oriented Programming in C++, AT&T Corp.
- C Language for Programmers, AT&T Corp.
- UNIX System V, Release 4, AT&T Corp.
- Shell Command Language for Programmers, AT&T Corp.
- X Window System Applications, AT&T Corp.
- Fast Track to Sybase, Sybase SQL, Sybase Corp.
- Oracle SQL, Oracle Programmatic Interfaces, Database Consultants.
- Object Oriented Requirements Analysis, Tapestry Inc
- Visual Basic, TCJC
- C Programming, TCJC
- Advanced C Programming, TCJC
- C++ Programming, TCJC
- Java, Intermediate Java, Advanced Java, Austin Community College
- Python, Austin Community College
Timeline
Trust Administrator
C.E. Harralson Family Trust /AGA Insurance Broker
10.2013 - Current
Project Leader
University of Texas at Dallas
01.2012 - 09.2013
Consultant
Integral Process Improvement, LLC
02.2011 - 01.2012
Consultant
Onshore Technology Macon
08.2010 - 12.2010
Consultant
Dairy Farmers of America
09.2008 - 11.2009
Consultant
Wal-Mart
08.2007 - 09.2008
Consultant
EDS - SABRE Inc.
09.2006 - 06.2007
Technical Analyst/Consultant
Conversant, Inc.
06.2003 - 06.2006
Perl Implementation Consultant
Financial Times Interactive Data
07.2002 - 03.2003
Systems analyst
Southwest Missouri State University
11.2001 - 07.2002
Data Solutions Integrator/Migration Specialist
LOGAN/BRITTON, Inc.
08.1997 - 10.2001
Senior Analyst
HOECHST CELANESE CORP.
01.1996 - 04.1997
Consultant
SABRE DECISION TECHNOLOGIES, AMR CORP
01.1995 - 08.1996
Senior Consultant
Superconducting Super-COLLIDER LABORATORY (SSCL)
01.1990 - 01.1995
Director of Information Resource Management
PRINCETON UNIVERSITY PLASMA PHYSICS LABORATORY
01.1976 - 01.1989
MBA - Finance
Rider University
BA - Economics
University of Missouri
Programmer/Analyst
PRINCETON UNIVERSITY
01.1970 - 01.1976
Programmer/Analyst
IBM Corporation
01.1968 - 01.1970
Programmer/Analyst
New York Life Insurance Co
01.1966 - 01.1968