We provide IT Staff Augmentation Services!

Sr. Programmer Analyst Resume

3.00/5 (Submit Your Rating)

Pasadena, CA

Summary of Qualifications,1976 Present

  • Over 33 years of Data Processing Experience, including 30 years of analysis, design and Development
  • Over 22 years as an independent consultant
  • Industry Experience including; Gaming and Hospitality, Banking, Pipeline Transportation, Medical Instruments, Amusement parks, Hospitals, and Auto Painting
  • Most work performed includes Conversions, Data Collection for Litigation cases, Interfaces to and from the AS/400 I Series Platform, New Implementations, Production Support, Development and Documentation.
  • Extensive Experience in Infinium Applications including; Payroll, Human Resources, Flexible Benefits, General Ledger, Payables Ledger, Income Reporting, Accounts Receivable, Fixed Assets and Application Manager. Approximate years of experience within application;
  • Payroll / Human Resources 8 Years
  • Financial Management 10 Years
  • Considered by Clients to be a Specialist in Infinium upgrades with excellent planning skills
  • Hardware Experience on IBM AS/400, I-Series, System 38, Unisys Midrange and PC’s.
  • Language Experience in RPG Free, RPGIV, RPGLE, RPGIII, CLP, FTP Scripting, COBOL and SQL.
  • Tool Experience in Word, Excel, Visio, MS Project, View, DBU and Turnover.

Professional Experience

Consulting,01/05 Present

Client: Confidential,

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM I Series Languages Used: RPGIV, RPGLE (Free), CL, SQL

Developed a Race and Sports Book and check request data base system. This system will allow all maintenance functionally and lookup capabilities and will perform interfaces into the Infinium Payables Ledger system to create vendors and invoice vouchers. Served as Project Lead and technical lead to convert Timeworks time and attendance system over to Kronos. Provided technical support for Infinium year end upgrades and reporting (1099, W2) for HR/PY and financial applications 2004 2007. Served as a Project Lead and Sr. Analyst/Programmer in an Infinium Environment to develop a Vacation and Flex Time recalculation process to recalculate all Vacation/Flex Balances since the initial cutover from Caesar’s Entertainment to Colony Resorts. Developed a Benefit Cutover process to convert employee current enrollments into new plans based on calculated annualized income. Performed development of an Hours Exception reporting process which identified exceptions to FT and PT status based on actual payroll productive hours. Performed development of a Before and After Audit reporting process which identifies all changes to the Infinium Main Files HR/PY files (Basic Master, Payroll Master and Personnel Master). Developed and implemented Check Reconciliation interfaces for Payables ledger and Payroll to a web based Banking Portal. Available to Client on an as needed basis.

11/07 Present

Client: Confidential,

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM I Series Languages Used: RPGIV, CL, SQL

Performed Infinium Year End Upgrades for Financial Management (FM) and Human Capital Management (HCM) Applications. Performed Infinium Major Upgrades for FM to release level 14.0 and HCM to release level 11.0. No major issues were encountered. Provided technical support for Infinium year end upgrades and reporting (1099, W2) for HR/PY and financial applications for 2007. Developed interfaces for Time and Attendance (Unitime) to HR/PY and Food Tracking System to Payables Ledger for Invoice generation. Available to Client on an as needed basis.

02/06 Present

Client: Confidential,

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM I Series Languages Used: RPGIV, RPGLE, CL,

Developed a Benefit Extract process which extracts information for all Resorts properties from the Infinium Data bases into EDI 834 formats for submission to a 3rd party Vendor for producing Benefit Statements. Served as technical lead to perform Infinium HR/PY 10.4 Upgrades for six Properties. Also served as Sr. Analyst/Programmer in an Infinium Environment to develop an interface from Benefit Enrollments into a Cigna Client Eligibility Database. Process included the flexibility of selecting multiple property databases and creating extraction files conforming to Cigna Ace formats and an archive of files sent. Reporting included detailed auditing of qualified enrollments and their beneficiaries, comprehensive exceptions detected, control file auditing and summary reporting. Continuing to provide Support and development. Available to Client on a as need basis.

07/07 01/08

Client: Confidential, Valencia

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM I Series Languages Used: RPGLE, CL,

Serving as the Technical Lead to perform Infinium Financial (GL and PL) Upgrades from 3 releases back to the current release level of 13.1.

06/07 11/07

Client: Palms Casino, Las Vegas

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM I Series Languages Used: RPGLE, CL,

Corrected Infinium Payroll Accrual Calculations to meet Vacation and Flex time Property Needs. Available to Client on a as need basis.

04/07 12/07

Client: Daughters of Charity Health Systems

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM I Series Languages Used: RPGLE, CL,

Developed TSA (403b) Matching process to calculate employer match percentages on a bi-weekly basis external from the Infinium System. Development also included processing for an YTD True-Up Adjustment process to account for annual salary adjustments such as bonuses, rate increases and retro-pay. Updates were made to the employer match fields within the Infinium Deduction Ledger files for Audit Trail and online inquiry purposes.

10/06 11/06

Client: MGM Mirage

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM I Series Languages Used: RPG Free, RPGLE, CL,

Served as a team member to perform an ERP Assessment to determine if this solution would be cost justified for the MGM Mirage 23 Properties. This included evaluating SAP and ORACLE against Infinium with presentations of each solutions capabilities, projected cost and current cost of ownership. This project was undertaken to justify additional budget for a more in depth assessment. Additionally, I modified an interface to provide Smith Barney stock investment executive information to comply with latest format requirements.

10/02 01/05

Client: Catholic Healthcare West (CHW) All Divisions

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM AS/400 RISC Languages Used: RPGIV, RPGLE, CL, SQL, FTP Scripting

Served as a Technical Lead and Analyst/Programmer to develop solutions to bring all Infinium Payroll Calculations in Compliance with the Federal Labor Standards Act (FLSA). This included Payroll Procedural changes, Custom Calculations and Audit Reporting. This approach is currently being rolled out to all CHW Divisions. Once a solution was developed for remediation, this approach was used to develop a Historical Recalculation of Payroll for determining Liability which included recalculating Payroll on the employee/facility level for three plus years. Also performed Year End Infinium Upgrades for HR/PY, GL/AP and Technical Development of Open Enrollment Interfaces from Watson-Wyatt Benefit Applications.


12/99 02/06

Client: Earl Scheib, Inc. Sherman Oaks, CA

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM AS/400 RISC Languages Used: RPGIV, CL, SQL, View

Performed Infinium Upgrades for Earl Scheib, Inc. in Beverly Hills California. Upgrades included Infinium Financials; General Ledger, Payables Ledger, Fixed Assets and Payroll. No major issues were encountered. Performed Electronic Filing for 1099 and W2 Information. Developed a Check History printing process to support a litigation case. I’m continuing to provide support, maintenance and development on an as needed basis.

01/01 02/02

Client: Catholic Healthcare West (CHW) Coast Division

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM AS/400 RISC Languages Used: RPGIV, CL, SQL, FTP Scripting

Performed Infinium Payroll and Human Resources Implementation for CHW Coast Division in Oxnard, CA. Served as Project Co-Lead with responsibilities of coordinating conversion resources, defining requirements, conducting weekly status meetings with Users and Senior Management and developing Documentation. Also responsible for Developing Interfaces to and from the AS/400 and LAN using FTP processing. This included Time and Attendance entry using Matrix, Direct Deposits, Check Reconciliation, 401K Processing, Financial Interfaces and Flex Benefits Import and Export. I was also responsible for performing all AM2000 Platform administration.

10/99 06/02

Client: Catholic Healthcare West (CHW) Central Division

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM AS/400 RISC Languages Used: RPGIV, CL, SQL, FTP Scripting

Performed Infinium Upgrades for Mercy Hospital and Memorial Hospital, Bakersfield California. Upgrades included Infinium Financials; PL 3.2 to PL 11.0, GL 10.0 to GL 11.0 and Applied Application Program Changes (APC’s) to Infinium Human Resources; PY 9.2 A-G. Project required retrofitting of customized programs to newly released programs, testing and production installation. No major issues were encountered. I coordinated offsite payroll processing when AS/400 crashed with no major issues.

12/98 - 10/99

Client: Catholic Healthcare West (CHW) Central, Northern & SoCal Divisions

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM AS/400 RISC Languages Used: RPGIV, CL, SQL, FTP Scripting

Served as a Key member of a Project Team to certify Y2K Compliance for Infinium Financials and Human Resources/Payroll Applications for Catholic Healthcare West, Inc., a Major Health Care Corporation consisting of over 50 Hospitals. Responsibilities included; Y2K Impact Analysis, Developing Testing Strategies and scripts detailing functional testing and writing documentation conforming to Internal Audit Requirements.

2/98 - 12/98

Client: Confidential, Culver City, CA

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM AS/400 CISC & RISC Languages Used: RPGIII, RPGIV, CL

Served as a Project Leader to Karl Storz Endiscopy, Inc., where I performed Major Infinium Upgrades for Two Operating Companies which Included Accounts Receivable 4.0 to 4.1 to 5.0 to 6.0 & General Ledger 8.0 to 9.0 to 10.0. Both Companies were Upgraded two weeks apart and considered extremely successful with No Major Issues. I also worked as a key member on an AS/400 CISC to RISC Migration Team and a PRMS/Y2K Upgrade Project. Both Projects went very well with no down time to the User Community. My other responsibilities included Administrating Infinium AM2000 for all Application Menus, Users and Groups. I also provided Production Support to Interfaces to and from the Infinium Applications.

10/96 - 2/98

Client: Confidential, Studio City, CA

Consultant, Confidential, Santa Clarita, CA

Hardware: IBM AS/400 CISC & RISC Languages Used: RPGIII, RPGIV, CL

Providing consulting to Universal Studios Hollywood with the Tours Recreation Group where I developed a Voucher Interface between JDA and Accounts Payable 2000, Developed a Non Payment Reporting Module within Accounts Payable and Purchase Management, Supported Year End Income Reporting and worked on a project team to perform Infinium Release Upgrades for Accounts Payable 6.9 to 7.1, Purchase Management 2.0 to 4.0 and General Ledger 8.0 to 10.0. Provided Production Support and development as business needs dictated.

10/91 - 10/96

Client: Confidential, Los Angeles, CA

Consultant, Confidential, Santa Clarita, CA

Hardware: Unisys V380, IBM AS/400 E45 Languages Used: Cobol, RPG, CL, SQL

As an independent Consultant, I was contracted to the same LA based Company as my previous employer. My responsibilities included production support, maintenance and development, as Business needs dictated on both a Unisys V380 and AS/400 E45 platform. My role on the Unisys was to serve as a consultant assisting in the application migration of the Revenue Billing System to the AS/400 and Operational Systems to a VAX platform. Within the AS/400 Environment, I assisted in development of their Revenue Billing System, served as a Project Leader in the production installation of Software 2000’s Purchase Management System and development of a Tiered Delivery Discount System as a sub Module to the Revenue Billing System.

2/86 - 10/91

Client: Confidential, Los Angeles, CA

Confidential, Saugus, CA

Hardware: Unisys V380, IBM AS/400 E45 Languages Used: Cobol, RPG, CL, SQL

Employed as a Sr. Programmer Analyst for a consulting company, I was assigned to a client in L.A. whose business is to ship petroleum products through a refined product pipeline within the western United States. Projects worked on include development of an accounting system to track and forecast contaminated fuels generated on the pipeline, providing production support and maintenance of the their Billing, Reporting and Product Terminal Systems, performing history extracts for transfer to other platforms such as PC’s, IBM Sys/38 and VAX.

Professional Experience

4/82 - 2/86

Sr. Programmer Analyst, Confidential, CA

Hardware: Unisys V380, Languages Used: Cobol, Work-Flow Language

Employed as a Sr. Programmer Analyst, I was placed in charge of coordinating all Financial Year-End Close Out processing, which included modification, testing and documentation of all 1099 programs to conform to Federal reporting requirements. Other projects and responsibilities include performing a major software upgrade affecting all financial applications, supervising five other programmers, development of a DDA statement process, Savings interest forecast process, Microfiche reporting system and Proxy reporting.

6/81 - 4/82

Sr. Programmer Analyst, Confidential, Pasadena, CA

Hardware: Unisys V380, Languages Used: Cobol

Employed as a Sr. Programmer Analyst for a consulting company, I was assigned to an account with American National Bank in Bakersfield, CA. where I worked on a six month project to install a Burroughs ‘Bulk Filing’ system and support the ‘Check Processing’ system (I.P.S. & A.I.C). Letter of reference available.

5/76 - 4/81

Programmer Analyst, Confidential,Valencia, CA

Hardware: Burroughs B2900, B4700, Languages Used: Cobol

Employed as a Computer Operator and Proof Reconciler on a Burroughs Medium system, learned the concepts of operations quickly and within six months was given a shift of responsibility. Within a year and a half I was promoted to Lead Operator where my duties included training and writing documentation. After a period of two and a half year years, I was promoted to Jr. Programmer Analyst where I was able to build a solid foundation of structured programming skills and soon was promoted to Programmer Analyst. As a Programmer Analyst, I worked on projects such as coordinating Microfiche Specifications for all reports used by the Bank, Performing conversions of application files (DDA, TCD, SAV) for acquired branches and supporting the Check Processing system (I.P.S & A.I.C.).

Career Summary:
I have over 33 years of Analysis and Programming experience including 12 years COBOL and 20 years using RPG & CL on an IBM SYS/38, AS/400 I-Series. Experience working with Infinium applications such AM, AR, FA, PM, AP, PL, IR, GL, PY, FB and PE. I have a lot of experience within Production Support, trouble-shooting problems requiring a quick turn around. I’m very proficient at SQL, Query 400, Excel, Word, Visio and other PC based Applications.

Education: COBOL Programming and Supervision and Management

We'd love your feedback!