Senior Oracle Technical Consultant

• Jun 2021 - Present

Corporate Account Executive

• 2009 - Present

I handle corporate accounts for HMO requirements of companies nationwide. For details, visit www.hmi.com.ph I handle corporate accounts for HMO requirements of companies nationwide. For details, visit www.hmi.com.ph

Senior Oracle Applications & PL/SQL Developer

• Jul 2018 - May 2021

Oracle Technical Consultant

• Jul 2016 - Jun 2018

Technical Trainer

• May 2015 - Jun 2016

I am an Instructor for corporate clients handling Introduction to Oracle 12C and PL/SQL, both Basic and Advanced courses. www.techedge-solutions.com I am an Instructor for corporate clients handling Introduction to Oracle 12C and PL/SQL, both Basic and Advanced courses. www.techedge-solutions.com

Senior Systems Analyst

• Nov 2014 - Mar 2015

Supports the day-to-day issues encountered in Oracle R12 Financials system with modules in AR, AP, PO and GL.Monitors daily interfaces from the company's Legacy System to Oracle Financials.Creation of PL/SQL scripts as requested by the users to be used for data analysis and gathering. Supports the day-to-day issues encountered in Oracle R12 Financials system with modules in AR, AP, PO and GL.Monitors daily interfaces from the company's Legacy System to Oracle Financials.Creation of PL/SQL scripts as requested by the users to be used for data analysis and gathering.

Oracle e-Business Suite Financials

• Aug 2013 - Oct 2014

• Oracle EBS R12 Upgrade Project using Oracle PL/SQL and Data Loader• Overall offshore lead in the Conversion for Financials modules such as GL Balances, Suppliers, Items, Requisitions, Purchase Orders, Invoices, Fixed Assets, On-Hand Balances and Receipts and HR Module for Employees• Monitor deliverables in a daily basis and coordinate with onshore team to ensure that requirements were met• Assigning tasks to designers and developers and assist team members in troubleshooting and defects fixing• Responsible for enabling the team to deliver based on the project’s deliverables and track status of team deliverables• Managing the team work plan and workload and track status of team deliverables• Follow-up on and ensure closure of issues raised by team members• Make sure that team members follow project standards and procedures• Identify and implement process improvements, suggest solutions to possible project risks• Communicate team goals, organizational philosophies, and policies and procedures to the application team• Coordinates work with other teams, other functional areas within the unit, and other operational domains.• Responsible for Deployment activities on development and test environments using Jenkins Configuration Management Tool• Responsible for Metrics reporting (Delivery Analysis & Reporting for Technology Growth Platform)• Prepare and conduct performance evaluations of the team

Oracle Consultant

• Jul 2012 - Jul 2013

• Monthly Financial Reports Automation Project using Oracle Discoverer and PL/SQL from ACBS System• Work closely with business users to define the reporting requirements including data model• Propose detailed design for CTL reporting requirements and obtain OIST sign-off on detailed design• Implement detailed design and ensure that relevant OIST standards for IT Projects are followed• Provide accurate documentation for data mapping/coding. within the format required by OIST• Assist the business users in the conduct of user acceptance testing in accordance with OIST Quality Management Standards, and provide the required artifacts to document• Develop training material, and train users on reports developed • Prepare the necessary material for Change Advisory Board and submit for deployment of solution to production• Provide system documentation to OIST and conduct knowledge transfer to the designated group within OIST

Oracle PL/SQL/E-business Suite(R12) Developer

• Jan 2012 - Jun 2012

• Development and support for Oracle EBS R12.1.3 Upgrade• Creation of templates and test data for R12.1.3 Upgrade for HRMS Module• Datafix and change requests using Oracle service requests (SRs) and JIRA• Reports creation using Oracle BI Discoverer Administration and Oracle Discoverer Desktop

Oracle PL/SQL/Reports/E-business Suite(R12) Developer

• Nov 2009 - Jan 2012

• Created and enhanced Accounts Receivables reports using Oracle BI Publisher• Coding data conversions, extensions and interfaces in Oracle E-Business Suite• Created Treasury Receipt Interface System• Create shell scripts for downloading/uploading data (using Sqlloader)• Create / optimize complex packages/procedures• Involved in testing, maintenance, and implementation • Resolves day-to-day systems issues, data fix and user requests including creation/follow-up of Oracle service requests (SRs).• Ad hoc development of small application changes and enhancements.

Oracle Developer

• Oct 2008 - Feb 2009

• Provide data analysis, reports layout and resources used for Hong Kong and Indonesia clients.• Developed, enhanced and debugged form modules and user interface layout using Forms 6.0 • Developed, enhanced and debugged report modules using Reports 6.0.• Develop database scripts using Oracle PL/SQL.• Developed Data entry screens for Hong Kong client. • Provide data analysis, reports layout and resources used for Hong Kong and Indonesia clients.• Developed, enhanced and debugged form modules and user interface layout using Forms 6.0 • Developed, enhanced and debugged report modules using Reports 6.0.• Develop database scripts using Oracle PL/SQL.• Developed Data entry screens for Hong Kong client.

Senior Software Engineer for Database Administration

• Nov 2004 - Feb 2007

XM Satellite Radio Canada Junior DBA for Infranet 6.7 • Perform data analysis and database management activities. • Monitoring database performance and space requirements. • Build, test, and implement changes to the databases, and operations documentation required for continual releases to the system. • Involved in rotation of 24x7 support for the CSR Production In-Scope environments. Marriott International, Inc. Junior DBA: • Database Maintenance: Maintains the continuous operation of the databases. • Space Management: prepares space planning and database growth trends that include monitoring the size of the tablespaces, adding datafiles and rebuilding of indexes. • User Management: creates and/or drops users with appropriate roles to access the database. • Security Management: performs monthly password change in the databases and develops password encryptions and restricts users with limited privileges when accessing the databases. • Performance Management: makes sure the performance of the database is at its best to accommodate batch processes and batch jobs. It also includes running of statistics, statspack, SQL and database tuning. • Configuration Management: assists in Oracle installations, patching and relinking of Oracle homes as well as database cloning and decommissioning.Johnson & Johnson - Health Care Products & Pharmaceuticals DBA Support: Data Warehouse Production Management Team • Application Maintenance and technical Support of Regional Datawarehouse • Perform daily operational checks, maintenance of datafiles, extents/tablespaces • Monitoring and support of scheduled extraction jobs in Oracle using Actaworks Admin Page • Cube building and delivery to various country servers using Cognos Transformer and Powerplay

Senior Oracle Developer

• Jul 2000 - Nov 2004

Programmer AnalystProvided systems development services to the following projects: Programmer AnalystProvided systems development services to the following projects:

Programmer

• Mar 2001 - Oct 2004

Programmer AnalystInvolved in three(3) system teams:General Ledger System(GLS)Deposit Management System(DMS)Commercial Loans System(CLS) Programmer AnalystInvolved in three(3) system teams:General Ledger System(GLS)Deposit Management System(DMS)Commercial Loans System(CLS)

Programmer

• Jul 2000 - Jan 2001

• System analysis and design.• Developed, enhanced and debugged Form modules using Forms 3.0, Forms 4.5 and Forms 6.0 • Developed, enhanced and debugged Reports modules using Reports 1.0,Reports 2.5 and Reports 6.0.• Develop database packages, procedures, functions and scripts for different reports and form modules using ORACLE PL/SQL. • System analysis and design.• Developed, enhanced and debugged Form modules using Forms 3.0, Forms 4.5 and Forms 6.0 • Developed, enhanced and debugged Reports modules using Reports 1.0,Reports 2.5 and Reports 6.0.• Develop database packages, procedures, functions and scripts for different reports and form modules using ORACLE PL/SQL.