Experience :

Confidential
Pasadena, CA

March 2000 to May 4, 2012
Senior Programmer/Analyst

• Maintain the Infor/Infinium Human Resources and Payroll Software. This includes installation, testing and implementation of new upgrades. Also support all users by troubleshooting and resolving processing issues and create custom query reports to meet user requirements.
• Developed custom programs needed for the interface between ADP Time and Attendance and Infinium Payroll Process. This includes Integration and Testing where I tested the programs in a development environment to check for errors, bugs and interoperability. Final step is the new interface is put into production and becomes a daily job run to complete the Time and Attendance Module of the ADP Software. Programming done in RPG/ILE, Free Form RPG with Embedded SQL.
• Involved in the Data Conversion of the Infinium HR/Benefit/Payroll System to ADP HR/Benefit/Payroll System (outsource). This includes programming to create the conversion files/data and testing. Programming done in RPG/ILE and Free Form RPG with embedded SQL.
• Responsible for the conversion of Payroll and Accounts Payable checks, Invoices, W2 forms, Benefit Letter into Laser form. This includes custom programming to create the spool file. Then creating and designing the forms using ACOM Software to which the spool is merged. Programming done in RPG400, RPG/ILE and Free Form RPG with Embedded SQL. This conversion reduced the usage of 7 checks forms into one laser check form. No need to order pre-printed invoice/voucher forms, instead these print on plain paper.
• Maintain existing custom applications for Payroll, Human Resources, Check Reconcilement, General Ledger and 401K Systems. This includes formulating system analysis and design techniques to solve problems and/or meet project goals. Then I create new applications and/or make enhancements on existing applications applying the techniques ultimately meeting user requirements and attaining project objectives. Also provide needed documentation for the users. Programming done in RPG400, RPG/ILE and Free Form RPG with Embedded SQL. Also used Subfile Processing.
• Responsible for creation of custom programs for Star Bucks Electronic Invoice Monthly Process. This is basically an addition to the already existing EDI process. Programming done in Free Form RPG with Embedded SQL.
• Involved in the programming aspect of the Billing System website application. Created Java Codes, Servlets, JSPs, Javascript, HTML, XML, Java Beans, stored procedures using IBM Websphere Development Studio Client 5.1.

Confidential
La Crescenta, CA

July 1999 to January 2000
Programmer/Analyst

• Responsible for enhancements on existing claims applications for a healthcare provider client in Riverside, CA.
• Programming done in RPG400.

Confidential
Camarillo, CA

June 1995 to March 1999
Supervisor/Programmer/Analyst

• Planned, developed a new system for Price Survey to meet client requirements. Responsible for design, analysis and creating new applications. Responsible also for Testing and Implementation. Programming done in RPG III, RPG400.
• Maintained and enhanced all existing in-house systems (Price Survey, Wholesale, DTW, Billing, Share of Market). Responsible for modifying existing programs to improve the system and to constantly meet user requirements. Programming done in RPG III, RPG400.
• Responsible for managing the AS/400 System. Update PTFs, review computer system capabilities, improve system and job performance and make necessary decisions on all MIS matters to improve production, operation, and communications.
• Project Leader for the Year 2000 Conversion. Responsible for the upgrade of the AS400 operating system to V3R2 to make it Y2K compliant. Also responsible for all decision-making for the Y2K project; analysis of available Y2K tools; planning and scheduling; testing and implementation. Worked with RavenSoft Inc. on the Y2K Project and have successfully implemented the Y2K conversion.

Confidential.
Los Angeles, CA 90010

Nov 1994 to June 1995
Advance Programmer

• Responsible for enhancement of software package developed for the company’s agents. Created new programs and made major revisions on existing programs to meet user requirements in areas where software failed to provide. Programming done in RPG400.
• Responsible for solving 90% of problems reported by agents.

Confidential.
Los Angeles, CA

Oct 1990 to Nov 1994

Programmer

• Responsible for programming of Tax Reports, Human Resources Reports, Bank Reconcilement System and other Payroll Subsystems using JDEdwards CASETOOL, DREAMWRITER, WORLDWRITER. Also responsible for Data Migration from the existing Payroll/Billing Software Package to JD Edwards.
• Responsible for the development, enhancement and maintenance of in-house computerized systems for the corporate office and its 40 branches. Performed analysis, design, coding, testing and implementation of 401K and Pension System, Bank Reconcilement System and other Payroll Subsystems. Programming done in RPG in S/36 Mode and RPG400.

SKILLS: RPG400, RPGIV, RPGILE, Free Form RPG, embedded SQL, Sub-file Processing, Stored Procedure, CL Programming, DBMS
JAVA, BASIC, COBOL, HTML, XML, JSP, Javascript

SYSTEMS: IBM I-Series or AS400, S/36, S/34, IBM mainframe, Windows XP, Windows 7 

SOFTWARE: INFOR/INFINIUM PAYROLL/HUMAN RESOURCES SOFTWARE JD EDWARDS ACOM

TOOLS: DBU 9.0, Hawkeye, Extermin8, Aldon CMS, DFU, RLU, SDA, DB2/400, Query/400, FTP, IP Switch (FTU), Client Access, Websphere Studio 5.1, RAD 6.0

EDUCATION: 
Bachelor of Science in Business Administration, Major in Marketing