CONTACT
*****.*.*******@*****.***
** ***** *** *******, ******* Hills
Quezon City
Philippines
https://www.linkedin.com/ in/romeo-labalan-89299570
ROMEO APUYA LABALAN (MIONG)
ORACLE APPLICATION DEVELOPER
PROFILE
10+ years of experience in Oracle Development and Support. Creating programs based from Functional Design. Communicate technical design and Migration plan to the user or business. Supporting GO-LIVE projects and trouble shoot any application error related to Oracle Applications or Projects.
Create/Enhance existing PL-SQL codes such as Packages, Anonymous PL-SQL block, Procedures and Functions. This includes creating view table and extraction of data from SQL*Plus using Oracle utility such as UTL_FILE, Cusors, Spool etc.
Experienced out of the country onsite support. I was one in our team to travelled and visit Italy last November 2016. This is related to RTC Project support which includes most of my EIS reports created.
Ability to learn new technologies and practices with minimal/zero supervision. Extremely well organized, with proven ability to multi-task and prioritize workload.
Knowledgeable in Oracle Forms and Reports, UNIX command and basic UNIX shell scripting, Oracle Fusion Middleware such as ODI and SOA. Basic PYTHON Programming.
Experience in SDLC and AGILE/SCRUM Methodologies. Ability to learn new technologies and practices with minimal/zero supervision.
TECHNICAL SKILLS
Oracle SQL and PL/SQL 6+ years exp.
Oracle EBS(R11/R12)
Oracle Forms and Reports
UNIX and Basic Shell Scripting
Basic PYTHON Programming
Oracle Data Integrator
(Oracle Fusion Middleware)
Database Languages/Tools
SQL*Plus
TOAD
PVCS, KINTANA, SBM
PUTTY
SQL*Loader
Crimson/Notepad++ Editor
WinSCP/FileZilla
IDLE (Python 3.7)
TRAINING
Basic PYTHON Programming Magno Software Development and Training Services
November 10, 2018 – Dec 01, 2018
EIS for EBS reporting tool
Vertiv Co. Inc.
April 2016
Basic Shell Scripting and Informix Programming
IBM Philippines
January 2014
Oracle Data Integrator/SOA
Accenture Philippines
March 2012
Oracle Forms and Reports 6i Integrator/SOAComputer Professionals INC.
January 2008
Oracle SQL and PL-SQL
Computer Professionals INC.
January 2008
WORK EXPERIENCE continued
May 2019 – PRESENT
Willis Towers Watson Philippines
Oracle Application Reports Developer
Creating/Enhancing PL-SQL scripts/objects such as Procedure, Function, Packages including JavaScript inside PL-SQL package for iPA and IPW pension system.
Deploying codes using GIT.
Creating and updating technical Documents in the CONFLUENCE site.
Bugs fixing via JIRA ticketing tool.
Creating Work Unit via SOFTWARE MOVER application for data migration.
MARCH 2016 – May 10, 2019
Vertiv Co. INC. formerly Emerson Network Power
Oracle Application Reports Developer
Creating/Enhancing PL-SQL scripts/objects such as Procedure, Function, Packages and view table for EIS Application tool.
Production Support and Program Deployment for EBS using SBM Migration Application and PVCS (SERENA).
Creating/Enhancing existing EBS and concurrent programs in different Modules such as Inventory, Purchase Order etc.
Creating/Enhancing existing EIS Reports.
Travelled to Italy once in 2016 even though I was just seven (7) months in the company. This is for a specific project which is related to EIS reporting and support activities with our colleagues in Europe.
s exp.
Oracle EBS(R11/R12)
Oracle Forms and Reports
UNIX and Basic Shell Scripting
Basic PYTHON Programming
Oracle Data Integrator
(Oracle Fusion Middleware)
Database Languages/Tools
SQL*Plus
TOAD
PVCS, KINTANA, SBM
PUTTY
SQL*Loader
Crimson/Notepad++ Editor
WinSCP/FileZilla
IDLE (Python 3.7)
GIT
SOFTWARE MOVER
CONFLUENCE
TRAINING
iPA Pension system. Creating iPA page using PL-SQL with JavaScript.
Basic PYTHON Programming Magno Software Development and Training Services
November 10, 2018 – Dec 01, 2018
EIS for EBS reporting tool
Vertiv Co. Inc.
April 2016
Basic Shell Scripting and Informix Programming
IBM Philippines
January 2014
Oracle Data Integrator/SOA
Accenture Philippines
March 2012
Oracle Forms and Reports 6i Integrator/SOA
Computer Professionals INC.
January 2008
Oracle SQL and PL-SQL
Computer Professionals INC.
January 2008
WORK EXPERIENCE continued
AUGUST 2012 - FEBRUARY 2016
IBM Solutions Delivery INC. Philippines
APPLICATION PROGRAMMER
Client: LOBLAW Retail Co. Canada
Creating/Enhancing PL-SQL scripts/objects such as Procedure, Function, Packages and view table for Labour Management Application.
Migration and Updating Informix application version via UNIX Polling Manager and PVCS.
Creating and discussing Migration Plan to the business and support.
Assigned specific project with very limited time and not familiar application tool such as SWEDAMART. But the project was successful and creates more sales to Loblaw particularly in Joe Fresh Apparel.
JULY 2011 - AUGUST 2013
ACCENTURE Philippines
Senior Software Engineer
Client: EDCON Retail Co. South Africa
Chevron – 4Gen Marine Lubricants
Creating/Enhancing PL-SQL scripts/objects such as Procedure, Function, Packages and extraction of data from central database to specific schema for our team.
Team Lead for EDCON Project specific for Oracle Fusion Middleware such as Oracle Data Integrator (ODI) and Service Oriented Architecture (SOA).
AUGUST 2010 - JULY 2011
Primover Consultancy Services INC.
Production Support Analyst
Client: Bureau of Internal Revenue
Maintaining existing program for ITS.
Creating/Enhancing existing Shell Scripts program.
Create PL-SQL scripts for extraction of data based from user/s request.
HOBBIES & INTERESTS
Mobile Games
Basketball and Billiards
Travelling
PERSONAL REFERENCE
Jesus Agsolid Jr.
Data Analytics Analyst I –
JP Morgan Chase
Richard Rubante
PL/SQL Developer – Willis Towers Watson
WORK EXPERIENCE continued
JANUARY 2008 - AUGUST 2010
Computer Professionals INC.
Oracle Reports and Forms Developer/SQL and PL-SQL
Client: Pioneer Non-Life Insurance, MAFRE Insurance and Bureau of Internal Revenue.
Creating/Enhancing Oracle Forms and Reports 6i and 9i.
Creating/Enhancing existing reports in NIIS and GENISYS application.
Creating PL-SQL scripts for extraction of data based from user/s request.
Creating/Enhancing existing PL-SQL program such as Packages, Procedure and Functions.