Chris Pando

1815 Widdicomb Court

Houston, TX 77008

713-864-8881

chris.pando@gmail.com 

Summary 

Self-starting analyst with over 20 years experience in IBM midrange (S/34-S/38-AS/400-iSeries). Extensive experience in Payroll/Human Resources, Accounting (G/L, A/R, A/P) and Distribution and Manufacturing. Equally comfortable with both the technical and human side of the job, most recent areas of concentration have been implementation methodologies and standards. As a multi-tasker, an ideal job would be a combination of self-lead projects combined with team responsibilities. While a long-time RPG programmer, opportunities to learn new technologies would be considered a real plus. 
 

Professional Experience 

A Major Oil Services Company 2004-2006

Consultant

A Major Oil Services Company, whose core business comprises cementing, stimulation, downhole tools and coiled tubing services worldwide.  

• Aldon – Aldon had recently been installed, but the installation was piecemeal and flawed. A suite of integrity reports were written, reconciling JDEdwards source management with Aldon’s. Bugs in the Aldon supplied exit programs were discovered and, after extensive consultation with Aldon support, resolved. 
• Accounting Interfaces –  Many distributed Oracle databases generate information (G/L, A/P) that must be imported into the JDEdwards accounting systems. This was done using DRDA (Distributed Relational Database Architecture) and the Oracle product Oracle Access Manager.
• Accounting Interfaces – Expense processing had been outsourced to a third-party service provider (GELCO). An interface for both G/L and A/P was constructed, to populate the JDEdwards Open Architecture Batch  Interface files with information provided through WebMethods middleware.
• System Tools – System integrity reports were written enabling the management of all command defaults (both system and custom). Integrity reports were written verifying synchronization of table-files on multiple machines.
• Application Security (Sarbanes-Oxley Compliance) – Participated in implementation of an Security Maintenance system for JDEdwards World and OneWorld.  All file maintenance was automated, driven by client defined ‘Policies’, and a full suite of integrity/audit reports demonstrate compliance.
• Accounting – Changes in state requirements regarding tax exemption for non-road diesel fuel required significant modification to fuel-use entry screens and allocation programs. In addition, reallocation from the beginning of the fiscal year so as to utilize newly created accounts was required.

 

 

David Weekley Homes 2003 - 2004

Consultant

David Weekley Homes is a major home-builder based in Houston, Tx, and located in fourteen cities.  

• Purchasing - David Weekley Homes is running heavily modified JDEdwards WorldSoftware. Growth to over a dozen cities required major restructuring of custom master files, with information moving from header to detail records. These changes were high-risk, involving conversions to both program logic and data
• General Accounting - Changes in accounting practices caused a need to reassign JDEdwards Address Book Numbers for a group of vendors. This re-sequencing involved data conversions to a majority the files, including over nine years of purchasing history.
• Accounts Payable - Redesigned process for entry and payment of utilities. A redesigned front-end cut data-entry time in half, and the check print program was modified to create an ACH/EDI file for direct transmission to the bank, eliminating the need to print over 600 checks a month.
• AS/400 Security – A complete security implementation was designed. Exit programs were installed to log all uploads/downloads, and production libraries modified so that access was only possible through adopted authority (JDEdwards recommended solution for securing World Software).
• Training – In-house training for David Weekley programming staff included condensed JDEdwards (Tech. Foundations, A.P.C.S) and custom RPG/III and  ILE/RPG.

 
 

PentaSafe Security Technologies, Houston, TX 2000 – 2002

Senior Software Developer

• VigilEnt Security Agent for J.D. Edwards WorldSoftware™  - Designed, implemented, and supported a point product providing audit capabilities thoroughly documenting application security, both as intended (policy) and as actually implemented; automating and simplifying creation of application security implementation; automatic creation of custom menus based upon defined application access policy. Written in RPG/III.
• VigilEnt Security Agent for iSeries – Secure – Remote Request Manager implemented native (green-screen) user interface for Remote Request Manager, a product providing exit point management for the iSeries. The user interface was implemented using proprietary Pentasafe Deployment Architecture, and was written entirely in ILE/RPG.
• Pentasafe Deployment Architecture – Pentasafe Deployment Architecture is a proprietary PentaSafe standard allowing for rapid and repeatable implementation of interactive data-base applications (on the AS/400). Functions related purely to the user interface are separated from those related to application logic (business rules). This separation of functionality allows for common logic to be shared by graphic and text user interfaces. Pentasafe Deployment Architecture was a solo project, implemented entirely in ILE/RPG, utilizing embedded SQL for all database I/Os.

 

Source Code / Product Build / Product Install Owner

Source code management was accomplished through Aldon. All product builds were constructed using IBM’s Licensed Program / Program Temporary Fix process. Was (as part of a team) responsible for automation of both the Build and Install processes. 

Level III Technical Support

Was called upon to provide Level III technical support (bug-fix and PTF creation) across the entire product line. This included extensive client contact. 
 

J.D.Edwards, Houston, TX 1994 – 1999

Senior Technical Consultant

My duties at J.D.Edwards were quite varied, depending upon the specific client’s needs.

A partial list of clients and responsibilities:

• Sunbeam (Hattiesburg, Mississippi) – Sunbeam is one of the largest Manufacturers/Distributors of small appliances in the world. Acquisition of another company required resequencing of all system generated keys within all master files. This was a high-risk conversion, affecting all files within J.D.Edwards. This was accomplished through the creation of a generic conversion tool (written in RPG/III), which lent itself to other applications.
• Gateway (North Sioux City, South Dakota) – Gateway is one of the largest Manufacturers/Distributors of Personal Computers in the world. Manual optimization of CASE generated batch programs was required because nightly posts were not finishing in a timely manner. This required extensive modifications to the code base (all work was RPG/III). Also conducted custom training in J.D.Edwards Programming Standards.
• AmeriServe (Dallas, Texas) – AmeriServe is one of the nation's leading food and restaurant supply distribution companies. My accomplishments included working with IBM engineers to optimize performance of a four-processor AS/400 (both performance-tuning and hand-optimizing generated RPG/III) and extensive modification (in RPG/III) of the Accounts Receivable reporting used to identify receivables eligible to secure Ameriserve’s line of credit.
• Shell South Africa – Shell South Africa is a JDEdwards “preferred client”, and as such participated in the design of enhancements. I was responsible for the design and implementation of extensive modifications to the Distribution system. The requirement was that Receipt Routing (Receipt Routing tracks the progress of purchased goods prior to their being entered into inventory) handle bulk (as opposed to packaged) goods.  All of the modifications were implemented using RPG/III.
• Grupo Cementos de Chihuahua (Chihuahua, Chihuahua) - Grupo Cementos de Chihuahua produces mainly cement and concrete in Mexico and in the United States of America. Poor training and circumvention of controls had resulted in compromised integrity of both financial and distribution files. I was responsible for verifying the integrity of all inventory data. This was accomplished with a three-count inventory, a functionality not provided for by JDEdwards. I was responsible for creating input documents (count tags), data-entry screens, edit/reconciliation programs and the master file update. All of this was written in ILE/RPG.
• Oceaneering (Houston, Texas) - Oceaneering is an advanced applied technology company that provides engineered services and hardware to Customers who operate in marine, space, and other harsh environments. Working closely with the Functional Consultant, I implemented inventory controls which complemented the aspects of job-costing which were peculiar to the industry. All development was in RPG/III, and implementation of the new controls delivered quantifiable savings.
• J.D.Edwards Corporate Headquarters (Denver, Colorado) – Six months Payroll Development (7.3), including design work for major K-12 (school system) enhancements. Six months ECS (Energy and Chemical Systems) support, working with clients (e.g. Total)  to enhance base system.

 

J.D.Edwards Trainer

Various Field Offices

• Certified Instructor – Advanced Programming Concepts and Skills (APCS)
• Taught both technical and function courses: Technical Foundations, RPG, APCS, CASE, Payroll, Human Resources / Benefits

 

Brillig enterprises, Houston, TX 1992 – 1994

Independent Consultant

A partial list of clients and responsibilities:

• Pilgrim’s Pride  (Mount Pleasant, Texas) – Pilgrim’s Pride is a leader in the production of prepared and fresh chicken in North America. The lack of an audit report for the pricing functions within Pilgrim’s Pride’s Lawson software created accountability issues, with deep concern about employee fraud. I utilized the AS/400’s native journalling ability to quickly create audit reporting (in RPG/III) which provided the necessary controls.
• Vinson & Elkins – Changes in legislation resulted in a need to update the Benefit Administration System that I had written as an employee of Vinson & Elkins. While most of the system was table-driven, some changes to the code-base (RPG/III) were required.

 
 

Vinson & Elkins, Houston, TX 1985 – 1992

Analyst / Programmer

• Designed, implemented and supported Benefit Administration System
• Supported all interfaces to ADP Payroll
• Security Officer (performance tuning, disaster recover, configuration)
• Team member, Data Warehousing project

 
 

M. L. Kerns, Houston, TX 1984 – 1985

Programmer/Analyst

• Team member participating in the development of a Pension Management System
• MAPICS Payroll
• Security Officer (performance tuning, disaster recover, configuration)

 
 

Gerald D. Hines Interests, LTD., Houston, TX 1982 – 1984

Programmer

• CMAS Payroll
• Team member, McCormack & Dodge General Ledger implementation

 
 

Education 

B.A. in Computational and Applied Mathematics, Rice University, Houston, TX