Summary




Over 12 12 years work experience in the area of planning, business analysis, software design and development, programming, maintenance, testing, training, implementation and documentation of Human Capital Management HCM applications using complete Software Development Life Cycle SDLC.
Industry experience in Airline Transportation, Government or Public Sector and Private School.
Extensive knowledge in design, setup, configuration, customization, implementation and integration of Oracle ERP Applications, Oracle Human Resources Management System HRMS, Oracle Self Service Human Resources SSHR, Oracle Learning Management OLM, Oracle Training Administration OTA, Oracle Advanced Benefits OAB, Oracle Payroll OP and Self Service Payslip, Oracle Time and Labor OTL, Oracle HRMS Leaves and Self Service Leaves.
Expert level skills in review of business process, fit-gap analysis, preparation of well-documented business requirements, project scope, project plans, deliverables, functional specifications, test matrix, test cases, test scripts, sign-off and turnover documents and presentation materials.
Expert level skills in developing Inbound and Outbound Interfaces, conversion and migration of legacy applications to Oracle ERP Applications.
Involved in upgrade from Oracle 10.7 to 11 and 11 to 11i. Good experience in DB2.
Highly self-motivated, team player, fast learner, hardworking, excellent analytical, interpersonal, organization, verbal and written communication skills with an ability to interact with individuals at all levels.
Managed all implementations with high degree of client satisfaction.


Employment

August, 2008 -  Present
Consultant

PROJECT : Oracle Human Resources Management System HRMS, Oracle Self Service Human Resources SSHR, Oracle Human Resources Daily Business Intelligence DBI, Oracle iRecruiment, Oracle Payroll
January 2009 September 2009 Project involves system enhancements of this integrated family of Oracle Human Capital Management HCM modules.

Responsibilities : Involved in the application design process by performing business process review and defining business requirements.

Implemented applications enhancements and customizations, custom Reports, Menus, Functions, Security Profiles, Responsibilities, etc.

Automated several HR processes, Certificates and Licenses, Personnel Actions, Supervisor Changes, Salary Changes, Termination, Absences, etc.
Implemented restricted access to application based on user role.
Implemented Oracle Workflow approvals.
Debugged Fast Formulas.
Performed System Administrator functions.
Provided application technical support, researched, performed troubleshooting, fixed bugs, analyzed data discrepancies and logged application issues as Oracle Service Requests SRs in Oracle Metalink.
Prepared functional specifications, test cases, test data, performed thorough Unit and Acceptance Testing UAT of enhancements and customizations.

Prepared application setup and other system documents, training and user guides and conducted trainings.
Prepared Powerpoint presentation material used to gain approval from the Steering Committee.

Leveraged testing techniques to other functional and technical analysts and developers.
Performed knowledge transfer to client.

Environment : Oracle Apps 11i 11.5.10.2, Oracle HRMS, Oracle SSHR, Oracle iRec, Oracle HR DBI, Oracle 10g, Oracle 11g, Sun Solaris SPARC 32 - bit Soralis 10, Oracle Workflow, Oracle Reports, SQL, PL/SQL, Toad, SQL*PLus

PROJECT :
Oracle Learning Management OLM, Oracle Human Resources Management System HRMS, Oracle Training Administration OTA

August 2008 September 2009 Oracle Learning Management is an e-business suite solution designed to support all education models by providing a single unified learning delivery system. It was implemented in City of North Las Vegas Human Resources Training and Development to replace the Oracle Training Administration OTA application.

Responsibilities : Extensive involvement in business process review, user group interviews, fit-gap analysis, business requirements and project scope preparation.
Configured, customized, setup, tested and implemented OLM application.
Designed, developed and setup OLM Catalog Administration Objects, Roles, etc.

Integrated OLM with other Oracle Applications.
Led the team in performing enhancements and customizations of the application.
Implemented OLM Automatic Waitlisting feature.
Performed application Personalizations.
Implemented Oracle Workflow custom processes.

Migrated OTA training data to OLM and disabled OTA application objects.
Customized affected Oracle HRMS application objects.
Performed System Administrator functions.
Provided application technical support, researched, performed troubleshooting, fixed bugs, analyzed data discrepancies, applied patches, logged application issues as Oracle Service Requests SRs in Oracle Metalink.
Prepared functional specifications, test cases, test data, performed thorough Unit and User Acceptance Testing UAT and conducted Conference Room Pilot CRP testing.

Prepared User Guides and Training Manuals and conducted Train-the-Trainer sessions and administrators trainings.
Prepared, maintained and managed issues log, action items and minutes of meetings.

Prepared and maintained application setup and other system documents.
Performed knowledge transfer to client.

Environment : Oracle Apps 11i 11.5.10.2, OLM, OTA, Oracle HRMS, Oracle 10g, Oracle 11g, Sun Solaris SPARC 32 - bit Soralis 10, Oracle Workflow, Oracle Reports, SQL, PL/SQL, Toad, SQL*PLus

August, 2008 -  February, 2009

Oracle Advanced Benefits is an e-business suite solution designed to administer the user s own benefits or requirements include offering flexible benefit plans. This provides the full solution for benefits management, life event triggered enrollments and communications, online life event processing, processing of flexible spending account claims and what-if eligibility analysis. Project focused on implementation of this module.

Responsibilities : Extensive involvement in business process review, fit-gap analysis, business requirements and project scope preparation.
Designed, configured, customized, setup and tested OAB application.
Customized and cleaned-up affected Oracle HRMS application objects and data.
Prepared custom Oracle Workflow notification specifications.
Prepared Outbound Interface specifications and coordinated with insurance vendors.

Prepared test scenarios and test data, conducted and performed Unit, Conference Room Pilot CRP, User Acceptance Testing UAT and conducted trainings.
Prepared application setup document, issues log, action items and minutes of meetings.
Performed knowledge transfer to client.

Environment : Oracle Apps 11i 11.5.10.2, OAB, Oracle HRMS, Oracle 10g, Oracle 11g, Sun Solaris SPARC 32 - bit Solaris 10, Oracle Workflow

May, 1997 -  March, 2008
Philipines Senior Functional Analyst

Education

Training

SQL ,
PL/SQL , Oracle Reports Project Management SQL*Wizard Forms 6i Presentation Skills Oracle9i : Build Internet Applications II Forms II Basic Management Oracle 11i Time and Labor Management Fundamentals and Implementation J2EE and Oracle JDeveloper
JAVA J2SE Oracle 11i Payroll Management Fundamentals and Implementation JAVA J2EE
Web Page Development Fundamentals Using JavaScript in Domino R5 Applications Java Script
Perl/CGI Fundamentals of IBM Computer Systems 9370 : Introduction to VSE/SP MVS Concepts and Facilities Programming in PL/1 MVS JCL Coding Lotus Notes Overview Lotus Notes Development Domino R5
Lotus Notes Development Training
Unix Shell Scripting Fundamentals of JavaScript on Domino R5 applications
Resume of Gerlie G. Salazar Page 1 of 8


Skills


Oracle E-Business Suite : Oracle Apps 11i 11.5.10.2 and Oracle Apps 10.7 Oracle HRMS, Oracle SSHR, OLM, OTA, OAB, OTA, OP, Oracle SS Payslip, Oracle HRMS Leaves, Oracle SS Leaves, Oracle HR DBI, Oracle iRec Development Tools : Oracle PL/SQL, SQL, Oracle 9i Developer Suite, Oracle Forms 6/6i/9i Oracle Reports 6/6i/9i Oracle Software Configuration Manager Release 2 9.0.2.5, Oracle Discoverer for End Users and Administration Edition 3.0, 3i, 4i, Oracle Workflow, Oracle Designer 2000/9i, Oracle SQL PLUS 8, TOAD, SQL Loader, WS FTP, APIs, Fast Formulas, Lotus Notes 6.5, DataLoad Classic 4.3.9.0, Natural Adabas 2.2.5 Natural N314 7.1.2 Adabas, PL/1 2.2.1 CICS, JCL, Clipper, Foxbase, Foxpro 2.6., and Visual Foxpro RDMS : ORACLE 11g, ORACLE 10g 10.2.0.2, 10.2.0.3 for Oracle E-Business Suite, Oracle9i Enterprise Edition Release 9.2.0.5.0, ORACLE 7 7.3.4 for Oracle In-House Developed Application Operating System : Windows 95/98/2000/XP/NT 4.00.1381, OS/390 2.9, UNIX, LINUX, Sun Solaris SPARC 32 - bit Soralis 10


Miscellaneous

PROJECT : Oracle Payroll OP, Oracle Self Service Payslip, Oracle Human Resources Management System HRMS
ROLE : Team Lead or Senior Functional Analyst
Oracle Payroll is an e-business suite application customized for Philippine Airlines business requirements. It has a key role in processing various inputs from timekeeping, earnings and deductions, payroll computation, update of balances, generation of remittance reports and transfer to GL. It was implemented in Philippine Airlines to replace the following legacy and developed applications : PAL Payroll System Oracle environment
Cabin Crew Productivity Allowance System PL/1, Adabas Natural, CICS, JCL mainframe environment
Pilot Productivity Allowance System PL/1, Adabas Natural, CICS, JCL mainframe environment
Cabin Crew Allowances System Foxpro2.6 for Windows environment
Pilot Transportation Allowance System Foxpro2.6 for Windows environment
Other payroll related applications
Responsibilities : Extensive involvement in project planning, business process review, user group interviews, fit-gap analysis, evaluation, preparation of business requirements and project scope.
Prepared project plans, process and data flows, migration items and functional specifications.
Led the project team in Flight Crew Payroll sub-modules implementation.
Designed, customized, setup, tested and implemented OP application, Retropay process.
Developed, setup and implemented BEEs, Fast Formulas, Skip Rules, Forms, Reports, Oracle Discoverer Reports, PL/SQL, Functions, Procedures, Packages, APIs, SQL scripts, SQL Loaders, conversion, migration and interface programs.
Customized affected Oracle HRMS application objects.
Implemented restricted access to applications based on user role.
Managed open issues by coordinating with Oracle vendor, users, other analysts and developers.
Involved in the system maintenance and further enhancements of the application.
Automated manually processed jobs in the system.
Performed System Administrator functions.
Provided application technical support, researched, performed troubleshooting, fixed bugs, analyzed data discrepancies, applied patches, logged application issues as Oracle Service Requests SRs in Oracle Metalink.
Prepared functional specifications, text matrix, test cases, test data, performed and conducted thorough Unit and User Acceptance Testing UAT testing.
Prepared application setup, sign-off and other system documentations, conducted turnover presentations.
Prepared User Guides and Training Manuals and conducted trainings.
Prepared Powerpoint materials for Steering Committee presentations.
Rolled-out Oracle Self Service Payslip to all PAL Demostic Stations.
Major Projects/Enhancements : Cabin Crew Transportation Allowance Payroll Module
Pilot Transportation Allowance Payroll Module
Cabin Crew Productivity Allowance Payroll Module
Pilot Productivity Allowance Payroll Module
Environment : Oracle E-Business Suite version 11.5.9, OP and Oracle SS Payslip, Oracle HRMS, PL/SQL, SQL, SQL*Plus, Toad, Oracle Discoverer, Oracle Forms6i, Oracle Reports6i, SQL Loader, Fast Formulas, APIs, Oracle 9i Developer Suite IDSHome Software Configuration Manager, Oracle9i Enterprise Edition Release 9.2.0.5.0., Oracle10g, Natural Adabas 2.2.5 Natural N314 7.1.2 Adabas, PL/1 2.2.1 CICS, JCL, Clipper, Foxbase, Foxpro 2.6., and Visual Foxpro
PROJECT : Oracle Time and Labor OTL, Oracle Human Resources Management System HRMS, Biometrics and other Time Recorders Implementation
ROLE : Team Lead or Senior Functional Analyst
Oracle Time and Labor is an e-business suite solution for time capture, validation, time management and approval. However, since not all application s features suit Philippine Airline s requirements, major customizations were made. It was implemented in Philippine Airlines to replace the developed legacy application, the Electronic Timekeeping System.
Responsibilities : Led the project team in OTL application implementation.
Extensive involvement in project planning, business process review, user group interviews, fit-gap analysis, evaluation, preparation of business requirements and project scope.
Prepared project plans, process and data flows, migration items and functional specifications.
Designed, customized, setup, tested and implemented OTL application.
Developed, setup and implemented BEEs, Fast Formulas, Skip Rules, Forms, Reports, Oracle Discoverer Reports, PL/SQL, Functions, Procedures, Packages, APIs, SQL scripts, SQL Loaders, conversion, migration and interface programs.
Migrated timekeeping data from legacy system to OTL.
Customized affected Oracle HRMS application objects.
Implemented restricted access to applications based on user role.
Managed open issues by coordinating with Oracle vendor, users, other analysts and developers.
Involved in the system maintenance and further enhancements of the application.
Automated manually processed jobs in the system.
Performed System Administrator functions.
Provided application technical support, researched, performed troubleshooting, fixed bugs, analyzed data discrepancies, applied patches, logged application issues as Oracle Service Requests SRs in Oracle Metalink.
Prepared functional specifications, text matrix, test cases, test data, performed and conducted thorough Unit and User Acceptance Testing UAT testing.
Prepared application setup, sign-off and other system documentations, conducted turnover presentations.
Prepared User Guides and Training Manuals and conducted trainings.
Prepared Powerpoint materials for Steering Committee presentations.
Implemented and rolled-out Biometrics Technology solution for time and attendance data capture to large-sized PAL Domestic Stations.
Implemented and rolled-out Electronic Time Recorder for time and attendance data capture to Manila ticket offices and all small to medium-sized PAL Domestic Stations.
Designed, developed, tested, implemented and rolled-out Overtime Authorization Excel Template for overtime authorization electronic submission using Document Library to all PAL Philippine Stations.
Major Projects/Enhancements : Overtime Authorization Excel Template and Lotus Notes Document Library
Electronic Time Recorder PC-based Application
Biometrics Time Recorder Device, FUSION Online Query Application and Fingerlan 4.6 Application
Environment : Oracle E-Business Suite version 11.5.9, OTL, Oracle HRMS, OP, PL/SQL, SQL, SQL*Plus, Toad, Oracle Discoverer, Oracle Reports6i, SQL Loader, APIs, Oracle 9i Developer Suite IDSHome Software Configuration Manager, Oracle9i Enterprise Edition Release 9.2.0.5.0., Oracle10g, Lotus Notes 6.5, Clipper, Foxbase, Foxpro 2.6., and Visual Foxpro
PROJECT : Oracle HRMS Leaves, Oracle Self Service Leaves, Oracle Human Resources Management System HRMS
ROLE : Team Lead or Techno-Functional Analyst or Senior Developer
Oracle HRMS Leaves is an e-business suite solution for absences, leaves management and approval. It was implemented in Philippine Airlines to replace the in-house mainframe developed legacy application, the Benefits Administration System.
Responsibilities : Led the project team in implementing HRMS Leaves and Self Service Leaves.
Gathered business requirements, prepared process and data flows, project plans, deliverables, technical architecture diagrams, migration items and status reports.
Designed, configured, customized, setup, tested and implemented Oracle HRMS Leaves and Oracle Self Services Leaves applications.
Developed, setup and implemented BEEs, Fast Formulas, Skip Rules, Forms, Reports, Oracle Discoverer Reports, PL/SQL, Functions, Procedures, Packages, APIs, SQL scripts, SQL Loaders, conversion, migration and interface programs.
Migrated leaves data from legacy system to Oracle HRMS Leaves.
Implemented Oracle Workflow approvals.
Optimized and fine-tuned source codes.
Performed application Personalizations.
Customized affected Oracle HRMS application objects.
Managed open issues by coordinating with Oracle vendor, users, other analysts and developers.
Performed System Administrator functions.
Provided technical support, researched, performed troubleshooting, fixed bugs, analyzed data discrepancies, applied patches, logged application issues as Oracle Service Requests SRs in Oracle Metalink.
Prepared functional and technical specifications, test cases, test data, performed and conducted thorough Unit and User Acceptance Testing UAT testing.
Prepared application setup, sign-off and other system documentations, conducted turnover presentations.
Prepared User Guides and Training Manuals and conducted trainings.
Rolled-out Oracle Self Service Leaves to all PAL Domestic Stations.
Environment : Oracle E-Business Suite version 11.5.9, Oracle HRMS Leaves, Oracle SS Leaves, Oracle HRMS, Oracle Workflow, Oracle Discoverer, PL/SQL, SQL, SQL*Plus, Oracle Forms6i, Oracle Reports6i, SQL Loader, Fast Formulas, APIs, Oracle 9i Developer Suite IDSHome Software Configuration Manager, Oracle9i Enterprise Edition Release 9.2.0.5.0., Oracle10g, Oracle Workflow
PROJECT : Oracle Human Resources Management System HRMS, Oracle Self Service Human Resources SSHR, Oracle Training Administration OTA, Oracle Basic Benefits
ROLE : Senior Techno-Functional Analyst or Developer
Oracle Human Resources Management System and Oracle Training Administration are integrated e-business suite solution customized for Philippine Airlines, Inc s Human Resources and Training and Development needs.
Responsibilities : Led the project team in enhancements and customizations of the applications.
Customized, setup, tested and implemented enhancements to Oracle HRMS and OTA applications.
Developed, setup and implemented BEEs, Fast Formulas, Skip Rules, Forms, Reports, Oracle Discoverer Reports, PL/SQL, Functions, Procedures, Packages, APIs, SQL scripts, SQL Loaders, conversion, migration and interface programs.
Migrated training data from legacy system to OTA.
Implemented Oracle Workflow customizations.
Optimized and fine-tuned source codes.
Revised custom. pll.
Managed open issues by coordinating with Oracle vendor, users, other analysts and developers.
Performed System Administrator functions.
Prepared technical specifications, test cases, test data and performed and conducted thorough Unit and User Acceptance Testing UAT testing.
Provided technical support, researched, performed troubleshooting, fixed bugs, analyzed data discrepancies, applied patches, logged application issues as Oracle Service Requests SRs in Oracle Metalink.
Environment : Oracle E-Business Suite version 11.5.9, Oracle HRMS, Oracle SSHR, OTA, Oracle Discoverer, PL/SQL, SQL, SQL*Plus, Oracle Forms6i, Oracle Reports6i, SQL Loader, Fast Formulas, APIs, Oracle 9i Developer Suite IDSHome Software Configuration Manager, Oracle9i Enterprise Edition Release 9.2.0.5.0., Oracle10g, Oracle Workflow
PROJECT : Philippine Airlines Payroll System PPS, Oracle Human Resources Management System HRMS ROLE : Technical Analyst or Developer
PAL Payroll System PPS was an in-house client-server application developed using Oracle tools to process payroll of PAL general employees, generate reports and provide interface data to other applications. It was replaced with Oracle Payroll for a more efficient operation.
Responsibilities : Involved in the system maintenance, development and testing and in the extensive analysis of the system and its data functionality.
Setup application security control and restricted access by creating Roles, Synonyms, Privileges, etc.
Developed Oracle Menus, Forms, Reports, PL/SQL, Functions, Procedures, Packages, SQL scripts, SQL Loaders, extraction, conversion, migration and interface programs.
Optimized and fine-tuned source codes.
Converted payroll data for migration to OP.
Prepared technical specifications, test cases, test data and performed and conducted thorough Unit and User Acceptance Testing UAT testing.
Provided technical support, researched, performed troubleshooting, fixed bugs and analyzed data discrepancies.
Prepared system documentations, User Guides and conducted user trainings.
Environment : Oracle HRMS, Oracle 7, PL/SQL, SQL, SQL*Plus, Oracle Forms6, Oracle Reports6, SQL Loader