Lisa Gelber
Tujunga, CA. 91042
Phone & Fax 818-***-****, Cell 818-***-****
abnnee@r.postjobfree.com
Overview
Assignments vary depending on Clients' needs. Past assignments include or combine project
management, project documentation, design, analysis, programming, testing, implementation,
user documentation and user training. A common assignment is to analyze process issues (a
data integrity issue, a process issue or a procedural issue). Often an assignment is to fill a
resource position, this resource demand is often due changes to project scope or timeline, or to
fill in when regular resources are temporarily unavailable.
Qualifications
Experience on IBM Midrange Systems, iSeries (AS/400), RPG III, RPG IV, RPGILE,
RPG-free, SQL, CL, DDS, Implementer, etc.
Project analysis and design, management and application development experience in a
wide variety of industries. Home Delivery, Call Center, Order Entry, A/P, A/R, Billing,
G/L, Manufacturing, Delivery Schedules, Tool & Die Warehousing/Purchasing, Pest
Control, Textile Manufacturing, Laundry Systems, Electronics Manufacturing, CRM.
Bachelor of Science in Information Technology (BSIT)
Masters Business Administration (MBA)
WORK HISTORY
Contract History
Consultant / Project Lead / Analyst / Programmer 1989- Present
Sony Pictures (sub-contract) 9/2008– 1/2009
AS/400, RPGILE, SQL, CL, DDS
Modify and/or develop applications as required. Staff programmer/analyst.
Created extract programs for the initial population of data to Sony’s i2 demand planning
application. These extracts select data from existing JDE files via RPGILE programs with
embedded SQL statements. The data selections are based on user options entered into
JDE dream writer processing options. Created an (RPGILE / JDE dream writer) interface
to feed daily shipments to Sony’s i2 demand planning application. The demand planning
interface performs data selections via JDE dream writer functionality then executes
further validation with in an RPGILE program. The resulting data files are placed in an
IFS directory. Modified an existing EDI application to include an alternate method for
reconciling data transmissions.
US Health Works (contract) 9/2007– 6/2008
AS/400, RPG IV, RPGILE, SQL, CL, DDS, QUERY
Modify and/or develop applications as required. Staff programmer/analyst.
Created or modified user reports which select data through RPGILE with embedded SQL
to create extract files which are placed in an IFS directory for user retrieval. Created a
process to flag duplicate or incomplete images for removal. Created a process to look for
missing images and build a list/request for images and documentation (with regard to
patient appointment tracking) for the document imaging application.
HACSB (contract) 2006– Present (ongoing
occasional support)
Housing Authority of the County of San Bernardino
AS/400, RPG III, RPG IV, RPGILE, SQL, CL, DDS, QUERY
Support all day to day AS/400 functional issues. On-call as required. Modify and/or
develop applications as required. Extract data for a conversion to new windows based
Page 1 of 5
Lisa Gelber
7214 Flora Morgan Trail
Tujunga, CA. 91042
Phone & Fax 818-***-****, Cell 818-***-****
abnnee@r.postjobfree.com
applications. Modify IRS 1099 reporting as required. Maintain and enhance legacy
programs. Most HACSB legacy programs are coded in RPGIV, some legacy processes
run in SYS/36 mode, newer development in ILE.
Sparkletts - (contract) 1993- 2006
DS Waters of North America
AS/400, RPG III, RPG IV, RPGILE, SQL, CL, DDS, QUERY, Implementer
(Sparkletts Water formerly McKesson Water Products Company)
Part of a team that developed a system to put wireless PC’s in a fleet of home delivery
trucks (over 900 units) running a custom CRM package. Each PC contains Customers,
Products, & Billing History for a specific route. Transactions are entered throughout the
day and uploaded when the unit is docked. Several types of wireless transactions are
also processed. Designed interfaces / programs to populate & retrieve data from various
Oracle and DB2 servers.
Responsible for promoting AS/400 applications (programs, files, etc.) from development
system to production environments.
Responsible for redesigning an existing CRM application to make it cosmetically
consistent with other existing programs and incorporated functional enhancements.
Created a centralized date calculator (commitment engine) incorporating Company
Delivery Calendars and Customer Information to force consistent scheduling rules.
Crated processes to incorporate acquired Company’s Customers into existing systems.
The final project involved extracting data for conversion to an Oracle database, then to a
DB2 database
Pacific Homes (contract) 1989- 1993
AS/400, RPG III, CL, DDS, QUERY, COBOL
Created several systems for a skilled nursing environment, including daily census,
pharmacy charges, Medical/Medicare billing, A/R, A/P, G/L.
Converted a payroll system (COBOL) from a SYS/36 to an AS/400.
Other Miscellaneous Contracts
KCET (3 month sub-contract)
AS/400, RPG III, RPG IV, CL, DDS, QUERY
Filled in as needed for absent existing staff. Created programs as directed. Created
extracts for phone campaigns. Developed a process to produce shipping documentation
to improve processing of phone orders (from the AS/400 to the shipping department)
Technicolor (3 month sub-contract)
AS/400, RPG III, RPG IV, CL, DDS, QUERY
Populated G/L files for a conversion to an AS/400.
Lendco (2 month sub-contract)
AS/400, RPG III, CL, DDS, QUERY
Modified existing files and programs to comply with the requirements of a new funding
agency and created new programs as required.
Additional Legacy Contracts
SYS/36, AS/400, RPG III, RPG IV, CL, DDS, QUERY, SQL. OCL
Designed and implemented a purchasing system for a tool & die company based on
recent inventory turnover and customer purchase history to suggest projected customer
demand.
Created an estimating system for a carpet manufacturer and distributor. An estimate
could be populated to an existing Order Entry application.
Page 2 of 5
Lisa Gelber
7214 Flora Morgan Trail
Tujunga, CA. 91042
Phone & Fax 818-***-****, Cell 818-***-****
abnnee@r.postjobfree.com
Created a route scheduling system for a pest control company.
Employment History – Full Time Employment
Reliable Company 5/1987- 6/1989
SYS/36, RPG, DDS, OCL, JDE
(Reliable Co, Reliable Sales, Pride Laundry Systems)
Data Processing Manager, report to CFO
Responsible for Application Design, Programming, Implementation, Enhancing existing
systems, and all day to day operations.
Created a comprehensive Customer Inquiry System to manage sales and customer
support.
Created a Service Department Dispatch System to dispatch service calls, track parts
used, and track types of repairs.
Automated a manual process to interface and upload receipts/data from a coin counter -
coin bags were identified by attaching tags with unique barcodes, which were scanned by
the coin counter – receipts were then transferred to the accounting module.
Imperial Oil & Grease 5/1985- 5/1987
SYS/36. RPG, OCL, DFU, Menus, Etc.
Programmer, report to MIS Manager
Created a bill of material system to mix lubricants.
Maintained A/P, A/R and G/L applications.
Responsible for all communication devices, and for support of remote and local users.
Audiotronics Corporation 1/1980- 4/1985
SYS/34, SYS/36, RPG, OCL, MAPICS
Programmer/Operator, report to MIS Manager
Responsible for all day to day operations, software modifications & upgrades (MAPICS).
Responsible for all aspects of user training.
EDUCATION
Bachelor of Science in Information Technology (BSIT)
University of Phoenix,
299 North Euclid Avenue Suite 100, Pasadena, CA 91101
Masters Business Administration (MBA)
University of Phoenix,
299 North Euclid Avenue Suite 100, Pasadena, CA 91101
Page 3 of 5
Lisa Gelber
7214 Flora Morgan Trail 41424 N. Whistling Strait Drive
Tujunga, CA. 91042 Anthem, AZ. 85086
Phone & Fax 818-***-****, Cell 818-***-****
abnnee@r.postjobfree.com
Reference List
W ayne Hyatt, MBA
Managing Partner
The Phoenix 5
40004 N Lytham Way
Anthem, AZ 85086-2923
abnnee@r.postjobfree.com
Relationship: Professional at Sparkletts / DWNA / DS Waters from 1993.
Steve Essayan
VP of Information Technology
US Health Works
28035 Avenue Stanford
Valencia, CA 91355-1104
abnnee@r.postjobfree.com
Relationship: Professional at Sparkletts / DWNA / DS Waters / USHealthWorks from 1993.
Catalino Felipe
IT Manager
Housing Authority of the County of San Bernardino
715 E. Brier Dr.
San Bernardino, CA 92408-2841
909-***-**** x 2154
abnnee@r.postjobfree.com
Relationship: Professional at HACSB.
Mike Mackey
Senior Systems Engineer
Pharmavite LLC
8510 Balboa Blvd.
Northridge, Ca. 91325-3583
abnnee@r.postjobfree.com
Relationship: Professional at Sparkletts / DWNA / DS Waters.
Page 4 of 5
Lisa Gelber
7214 Flora Morgan Trail 41424 N. Whistling Strait Drive
Tujunga, CA. 91042 Anthem, AZ. 85086
Phone & Fax 818-***-****, Cell 818-***-****
abnnee@r.postjobfree.com
Aditya Tahilramani
SPHE - Director Information Technology
Sony Pictures Home Entertainment)
SPP 3228
10202 W Washington Blvd.
Culver City, CA 90232
abnnee@r.postjobfree.com
Relationship: Professional at Sony (SPHE) from 2008.
Lisa Suddith
IT Manager
Entertainment Partners
2835 N. Naomi St.
Burbank, CA 91504-2024
abnnee@r.postjobfree.com
Relationship: Personal - Life long friend, met in kindergarten.
Page 5 of 5