PROFILE

• Overall 17+ years solid experience in Information Technology
• Professional AS/400 & Mainframe Developer with experience in System Analysis, Design, Development and Implementation of Application Software Development in AS/400 System I, Mainframes, Client Server environment
• Expertise in AS400 System I, COBOL, COBOL/400, RPG/400, RPGILE, CL/400 and is well versed with RDBMS concepts such as DB2/400 and Hierarchical database concepts such as DB2
• 7+ years solid experience in the finance industry
• 7+ years experience in the manufacturing industry
• Exposure to systems development, application systems customization (including ERPs), business intelligence information systems using CorVu, document management systems, application servers, and application systems integration
• Good interpersonal and organizational skills
• Excellent communication skills working with technical and functional groups

LANGUAGES: SQL/400 (interactive or embedded), RPG/400, CL/400, RPGII, OCL, RPG IV, RPG ILE (procedures, binding, service program, modules, API, Infoprint/ Overlay), RPG Free, SQLRPG, COBOL/400, Java, UML, VBA (Excel Macro), XML, MVS JCL, PL/SQL, FoxPro, HTML, C#, .NET
CASE TOOLS: Designer/2000, Synon, Rational Rose
BUSINESS INTELLIGENCE: CorVu
TOOLS: Implementer, Aldon Change Management System; TCP/IP, WebSphere Development Studio Client, Turnover, Hawkeye, PKZIP in AS400, Robot, MIMIX, MS Project, ROSCOE
APPLICATION PACKAGES: BPCS, Genelco's Life Support Plus, Genelco's Health Benefit and Maintenance System, JD Edwards World, DPI/ICMS, TELXON
DATABASE SYSTEM: DB2/400(triggers/ stored procedures, DDM), SQL Server (Transact SQL, stored procedures), MS Access, Remote SQL, ORACLE 8i and 9i, Informix
HARDWARE: AS/400 System I, Novell/NT, RS/6000, MVS, PC, Sun Solaris, HP
OPERATING SYSTEM: OS/400 System I, Windows/NT, AIX, MVS, DOS
INTERNATIONAL EXPOSURE: United States, Hong Kong, Singapore, Philippines

WORK EXPERIENCE

Confidential
Programmer/Analyst

A software services company.

Client: Confidential, Suffolk County, NY Mar 08 - Jan09, Sept - Dec 09

Confidential is a leading global vertically integrated manufacturer, marketer and distributor of a broad line of high-quality, value-priced nutritional supplements in the United States and throughout the world.
RESPONSIBILITIES:

• Modified programs for Purchase Orders, Zoning, Pack Slips, Raw Material Maintenance, and Work Order Reports.
• Modified programs for Order/ Invoice Inquiry, and Telxon Order Maintenance. Research cause of errors in programs.
• Developed CAPTIVA Reports, Finished Good Inventory History Inquiry (with optimize embedded sql to handle files with big records), converted pack slip program from regular PRTF to one using overlay (this includes revisiing the report layout), and develop new programs for International Order Transfers and Monthly usage automated update parameters.
• Worked with Quality Assurance Department to implement newly developed programs.
• Administration and menu set-up for users in Warehouse, Manufacturing, Logistics/Distribution, and Domestic Wholesale. This includes new menu set-up for roll-up of Leiner products and Solgar Conversion.
• Resolved help desk issues assigned to Warehouse, Manufacturing, Logistics/Distribution, and Domestic Wholesale.
• Implemented revised and newly developed programs using Implementer.

Environment: RPG/400 (including subfiles), RPGLE/400, RPGIV, RPG Free, CLLE, CL, Overlay, Procedures, SQL/400, Remote SQL, API, Implementer, AS/400 System i

Client: Confidential, Monroe County, NY Nov 07 - Mar 08

Frontier Communications Company is one of USA\'s largest independent providers of telecommunications services
RESPONSIBILITIES:

• Assigned to work on DPI, revising programs for Order Management System, Directory, and AT&T Separate CARE Files and Global Crossing for LD Provisioning.
• Revised Technical Requirement Document when necessary.
• Provided technical/ data information needed by Requirement Analyst.

Environment: RPG/400 (including subfiles), RPGIII, RPGLE/400, RPG Free, RPG IV, CLLE, CL, API, FTP, Turnover, SQL/400, AS/400 System I, OS/400

Client: Confidential, Westchester County, NY Aug 07- Oct 07

Confidential is a software development company in USA, whose single focus is logistics
RESPONSIBILITIES:

• Revised program on wave (warehouse) management set-up for Barnes and Noble.
• Revised program on inventory management for Vitamin Shoppe.
• Revised program on item cross reference management for Arett Sales.

Environment: RPG/400 (including subfiles, FTP, PKZIP), RPGIII, RPGLE/400, RPG IV, CLLE, CL, SQL/400, AS/400 System i, OS/400

Confidential, Philippines Jan 05 - Nov 06
Sr. Programmer

One of the leading life insurance company in the Philippines, AXA provides traditional life insurance, variable life insurance, and group life insurance.
RESPONSIBILITIES:

• Created SE-CMM functional design and technical design, programming (to traditional and variable life insurance application system). The two core system were developed using RPG/400, RPG/ILE, CLLE, Excel VBA, and Foxpro.
• Prepared unit/ system test plans.
• Coordinated User Acceptance Testing.
• Implemented programs using ACMS.
• Administration (defines user access; ensures timely setting/upload of system data references and rates - Cash Values, Dividends, Reserves, Fund's Buy/Sell Rates, Exchange Rates; troubleshooting application issues.s)
• Worked on New Business, Underwriting, Policy Changes, General Ledger Systems, Fund Management System (Bonds, Capital Investment, Equity, Fund Switching), Claims, and IVRS.
• Administered the SQL server and developed reports for end users. The SQL server is the back end of the SMS system, which was developed using VB, SQL Server, MS Access, and Globe Telecoms textconnect (third party software).

Environment: RPG/400 (including subfiles, FTP), RPGIII, RPGLE/400, RPG IV, CLLE, CL, Excel Macro/ VBA, Foxpro, SQL Server, Remote SQL, FTP, Aldon Change Management System, SQL/400, AS/400 System i, MS Access, OS/400

Confidential, Alabang, Philippines Jul 04 - Nov 04
Consultant

Philippine software services company

Client: Confidential- Application Support Center,
A software services company supporting application systems for Michelin. Employees and consultants assigned at Michelin Asia Pacific - Application Center worked remotely or relocated to actual client site.
RESPONSIBILITIES:

• Revised and developed programs for in-house application system for Societes Materiales Premieres Tropicales (SMPT). SMPT buys natural rubber for all the Michelin Group operations around the world. The SMPT application system (including buying, finance, and logistics) was developed using RPG/400, RPGII, RPG/ILE, FTP, and Excel VBA.
• Worked with business users in implementing revised and newly developed programs.
• Supported in-house application system for Michelin Japan. The application system was developed using COBOL/400.

Environment: RPG/400 (including subfiles), RPGIII, RPGLE/400, RPG IV, RPGII, CLLE, CL, FTP, COBOL/400, VBA, SQL/400, Remote SQL, AS/400 System I, OCL, Excel Macro/ VBA, OS/400, DDM

Confidential, Santa Rosa, Philippines Nov 03 - Feb 04
Consultant

Philippine software services company.

Client: Confidential
TMP is the manufacturing company for Toyota cars in the Philippines.
RESPONSIBILITIES:

• Assigned as System Analyst and Programmer for in- house developed Accounts Payable and Procurement System.
• Worked with Business Users to implement revised and newly developed programs.
• Main tasks included systems analysis, modification, and reprogramming.

Environment: RPG/400 (including subfiles), RPGIII, RPGLE/400, RPG IV, SYNON/400, CLLE, CL, SQL/400, AS/400 System i, LANSA, OS/400

Confidential, Makati City, Philippines May 02 - Sept 03
IT Consultant

IT Consulting arm of one of the lead financial auditing firm in the Philippines. The main task of this organization is to support/ lead/ manage IT projects (particulary projects for Central Bank of the Philippines) and business development for KPMG Philippines.

Clients: Confidential

• Confidential, was established on 3 January 1949, as the country's central monetary authority. It enjoys fiscal and administrative autonomy from the National Government in the pursuit of its mandated responsibilities.
• Confidential, Philippines. Quezon City is the number one city in the Philippines in terms of revenue for 2002.
• Confidential is one of Asia's most modern polyvinyl chloride (PVC) manufacturing plants. Its world-scale capacity can supply almost all the domestic PVC requirements, making the country self-sufficient in PVC resins supply. The plant utilizes state-of-the-art technology provided by Tosoh Corporation (Japan), PRII's major shareholder, in the production of high quality PVC resins.

RESPONSIBILITIES:

• Designed and facilitated pre-implementation and implementation of cFAS (Core Financial Accounting System) - application system developed for Central Bank of the Philippines;
• Facilitated resolution of issues during the warranty period;
• Corrected or designed procedures for correcting data inconsistencies in DB2/400 production environment;
• Maintained and provided troubleshooting for Actuate and Application servers.
• Gathered requirements for Integrated Property Supplies and Materials Management System (IPSMMS). IPSMMS is a system for the Administration Services Department of the Central Bank of the Philippines. IPSMMS functions include Procurement, Logistics, and Materials Management System;
• Proposed JDEdwards for IPSMMS and PRII project.
• Reviewed existing application systems and business requirements of Quezon City Government. Developed document proposing new application system for this local government.
• Acted as requirements gathering leader for Order Management for PRII project.
• Business development.

Environment: RPG/400 (including subfiles, DB2/400 triggers), RPGIII, RPGLE/400, RPG IV, FTP, CLLE. CL, Java, Websphere, MIMIX, ORACLE Order Management, ORACLE DBs, MS Project, UNIX, JDEdwards, SQL/400, AS/400 System i, OS/400

Confidential, Makati City, Philippines May 00 - May 02
Life Insurance Business Analyst

A consulting firm focusing on the life insurance industry.

Clients: Confidential was among the top 10 life insurance companies in the Philippines.

• Confidential (First Life) is a dynamic provider of financial security products and services designed for the protection of the family. From its corporate office in Makati and with a network of highly professional career underwriters, First Life maintains a coveted position among life insurers in the country today specializing in both group and individual coverage. First Life\'s suite of life insurance products allows clients to fulfill the complex financial needs of the family while improving cash flow and managing future obligations.
• Confidential is the life insurance company of United Coconut Planters Bank, one of the respected local banks in the Philippines.
  FGL project started first. Subsequently, COCOLIFE project was executed simultaneous with FGL project.

RESPONSIBILITIES:

• Acted as the Project Team Leader for the Requirements Analysis Phase in a full-scale development of a life insurance (individual,group, and reinsurance) application package. Monitored implementation of other subprojects for Document Management and Great Plains System.
• Assisted the main Project Technical Leader in the development and testing of the LIFe system, a web-enabled application developed on ORACLE 8i using Designer/2000.
• Designed highlevel database structure.
• Created program specifications.
• Supervised development.
• Developed, migrated developed application system to live environment, and module-tested Plan Maintenance, Reinsurance, and Billing System.
• Coached and mentored Systems Analysts on business and logical design of other modules - like Policy Benefits, Policy Changes (value and non-value changes), Internal processing (auto NFO, dividends, reserves, cash values, etc.), and Group Insurance.
• Worked on the implementation of CorVu, a business intelligence tool. Its features include: Ad Hoc Query OLAP and Reporting; Production Report Writing; and, KPI Monitoring and Alerting.

Environment: ORACLE DBs, DESIGNER/2000, PL/SQL, CORVU, MS Project, RS6000 UNIX. Informix, UNIX FTP

Confidential, Makati City, Philippines
(Among the top 15 life insurance companies in the Philippines)
Admin Consultant Feb 00 - Aug 01
Systems Analyst Apr 99 - Feb 00
Jr. Systems Analyst Apr 97 - Apr 99

Life Insurance company, which is among the top fifteen Philippine Life Insurance Companies.
RESPONSIBILITIES:

• As an Admin Consultant, I designed and developed Cashiering System. Integrated it on LSP using MAP. Corrected errors made by EDP on the system.
• Key technical person responsible for the conversion of data from existing system to Life Support Plus LSP. Enhanced or designed enhancements to several modules in LSP, particularly on: New Business, Billing System, Policy Payment, Basic Agent Compensation System and Set-up Module, Plan Definition Set-up, and Reserves Processing.
• Worked heavily with Navisys Missouri USA and Navisys Asia Pacific Hong Kong for LSP and HBMS projects.
• Supported existing in-house developed application system until LSP was implemented.

Environment: RPG/400 (including subfiles), RPGIII, CL, LSP, HBMS, SQL/400, AS/400 System i

Confidential,Manila, Philippines May 95 - Nov 96
Analyst Programmer

Philippine Software services company.

Clients: Confidential
RESPONSIBILITIES:

• Customized BPCS Financials and Sales Monitoring, and JDEdwards. Occassionally, assigned to coach and mentor programmer trainees.

Environment: RPG/400 (including subfiles), RPGIII, CL. BPCS, JDEdwards, SQL/400, SYNON, AS/400 System i, OS/400

Confidential, Makati City, Philippines.
Programmer II Feb 93 - Sept 94
Programmer I Aug 91 - Jan 93
Programmer Trainee May 91 - Aug 91

Philippine Software Consulting Company owned by Confidential

Clients: Confidential
RESPONSIBILITIES:

• Customized TOPAS (Inventory/Logistics/Distribution), BPCS, and/ or in-house developed programs of different clients. Programming languages used are RPG/400, COBOL/400, SYNON/400, and FoxPro.
• Acted as the Lead programmer for developing and implementing Sales Monitoring System integrated to BPCS. Converted data from existing in-house developed system in UNIX to newly developed application in AS400. Supervised 7 junior programmers.

Environment: RPG/400 (including subfiles), RPGIII, COBOL/400, SYNON/400, FoxPro. BPCS, UNIX, SQL/400, CL, AS/400 System i, OS/400

EDUCATION

M.S. in Information Technology Major in Information Systems Planning
B.S. in Computer Engineering