Supply Chain Operations Analyst
Resume:
Aracile Alcoriza
***.********@*****.***
Bethpage, TN 37022
Authorized to work in the US for any employer
Education
Bachelor of Science in Information and Computer Science
University of Cebu
June 1986 to October 1998 (Graduated)
Skills
More than 25 years of IT Experience with more than 22 years of extensive experience working in developing client/server applications.
Worked extensively on Oracle Applications versions 11.5.8/11.5.9/11.5.10/11.5.12 and Databases version 7i/8i/9i,10g,11g and 12g
Well experienced in database development such as packages, procedures, functions, triggers, views/materialize views, tables, indexes and sequences.
Knowledge on Business Intelligence (BI), Oracle Warehouse Builder (OWB), Data Warehousing using ETL Tools, Self Service Web Applications (SSWA) and basic knowledge of JAVA, HTML, UML and XML, Oracle Cloud Control 12C, PHP, Fortna (Conveyor), PTL (Pick To Light), SnowFlakes, Tableau.
Experience working with large Oracle Application in both Financial and Manufacturing Institution.
Experience in conversion, implementation, maintenance, interfaces, troubleshooting and support on large Oracle applications.
Solid experience on Oracle RICE development using tools such as Forms6i/9i/10g, Reports 6i/9i/10g, Discoverer 4, Workflow, ADI, API, EDI, RAC and Oracle PL/SQL.
Expertise using third party software for Oracle Database such TOAD, SQL Tools, SQL Navigator, Rational Rose, FTP, SSH (Secure Shell) and CONTROL-M, MAESTRO, OPCON, DBA_JOBS,CRON-TAB.
Expertise in Unix Scripting using SunOS 5.9, Linux 2.6.9-55.0.9.EL and HP-UNIX.
Experience in using Oracle utilities and analysis tools for diagnostic and for monitor performance issues such as Explain Plan and TKPROF.
Expertise in performance tuning and multi-threading jobs.
Expertise on creating new application inside Oracle Application, setting up some flex field values/lookup values, registering forms, reports, PL/SQL, host programs and etc.
Expertise on MS ACCESS programming, Visual Basic V6.0 and using Crystal Reports, Tableau
Experience of about almost 3 years plus on extensive development in MIDRANGE PLATFORM using IBM AS400, COBOL400, CL400, SQL400, SEU, DFU, SDA, RLU, PDM of AS400, and OS400 in DB2 Database.
Intensive experience on development in MAINFRAME PLATFORM using IBM Mainframe MVS2/OS390, JCL, Proc’s, Params, EasyTrieve Plus, VSCobol II, CICS, VSAM, DMLO, OLQ, IDD in IDMS database.
Experience of intensive development in MAINFRAME PLATFORM using TANDEM, Tandem Nonstop Kernel OS, TACL, JCL, COBOL85, TEDIT, ENDSDBA, RUND, ENFORM, PERUSE, FUP, Non-Stop SQL in ENSCRIBE Database.
Work experience
Business Analyst/Developer
Cracker Barrel - Lebanon, TN
January 2022 to June 2025
Maintenance and Support of the following systems:
1.WMS
2.TMS
3.Fortna (Conveyor)
4.PTL (Pick To Light)
5.ECOM (E-Commerce)
Responsibilities:
Interact with the business users to gain understanding of the changes requested.
Design, develop and maintain enhancements / customizations to the systems mentioned above.
Developed and maintained multiple areas of the systems mentioned above to synchronization between Cracker Barrel and their vendors.
Involved in the design, development, testing, and implementation of many modifications.
Provided solutions to complex issues during design and status meetings.
Worked closely with the user community to ensure that the software delivered the results they were expecting and increased their productivity.
Key person in supporting in the systems mentioned above.
Tuning for performance improvement initiatives through code modifications, adding cost base hints and/or the creation of an index, specialized views or even materialize views or even making the job into a multi-threaded. Performance tuning was based on what we see in our OEM Cloud Control 12C.
Handling user queries and production support.
Sr. Software Engineer
Dollar General Corporation - Goodlettsville, TN
August 2012 to July 2021
Maintenance and Support of the following Symphony EYC Retail and Distribution Modules:
1.Symphony EYC Retail and Distribution
2.GOLD Central
3.Product Management Information (PIM)
4.Assortments
5.Replenishment
6.Forecasting
7.Purchase Orders
8.Event Management
Responsibilities:
Interact with the team and functional users to gain understanding of the changes requested by the business users.
Design, develop and maintain enhancements / customizations to the modules mentioned above.
Developed and maintained multiple areas of the Merchandising System specializing in Purchase Order Management, Promotional Pricing, and Cost Synchronization between Dollar General and their vendors.
Involved in the design, development, testing, and implementation of many modifications.
Provided solutions to complex issues during design and status meetings.
Worked closely with the user community to ensure that the software delivered the results they were expecting and increased their productivity.
Key person in supporting the PIM Application where the items are configured through workflows.
Worked closely with 3rd party vendors for the project assigned.
Tuning for performance improvement initiatives through code modifications, adding cost base hints and/or the creation of an index, specialized views or even materialize views or even making the job into a multi-threaded using a generic script that runs in our job scheduler called OPCON 5.1. Performance tuning was based on what we see in our OEM Cloud Control 12C.
Handling user queries and production support.
Sr. System Analyst Programmer / Oracle Applications
Bucher + Christian Consulting - Terre Haute, IN
January 2009 to March 2012
Client: Sony DADC, Terre Haute, IN
Maintenance and Support of the following Oracle ERP or Oracle
E-Business Suite Modules:
Oracle Manufacturing
1.Inventory
2.Work In Progress (WIP)
Discrete Jobs
1.Configurator
2.Bill of Materials (BOM)
Media Management System (MMS)
Warehouse Management System (WMS)
Logistics Information System (LIS)
Quality System
Oracle Purchasing (PO)
Shop Floor System (SFC)
1.APB
2.FROGS
Responsibilities:
Interact with the team and functional users to gain understanding of the changes requested by the business users.
Design, develop and maintain enhancements / customizations to the modules mentioned above.
Uses Oracle's latest development tools to develop reports, forms, discoverer and procedures for an advanced reporting.
Creates objects from design specifications provided.
Performs necessary unit and system testing and document the changes.
Tuning for performance improvement initiatives through code modifications, adding cost base hints and/or the creation of an index, specialized views or even materialize views. Tuning efforts are based on the reports that the DBA generated every week that called Top 20 Low Performance Scripts.
Upgrade of the existing Shop Floor Applications that uses oracle forms/reports 6i to 10g forms/reports that consists of 115 forms, and 92 reports.
Create additional reports for users using Discoverer 4i or BI.
Work closely with DBA in upgrading the database from 8i to 10g and to 11g.
Create additional interfaces from other systems to Oracle such JD Edwards, COM, SOFTEON, CLAIMS, B2B and etc. in a crossed platform.
Create additional process for ETL using the PLSQL to EXTRACT data from JD Edwards, SOFTEON, B2B and CLAIMS and TRANSFORM by validating the extracted data into a series of look-up tables and LOAD into Oracle Database using the SQL Loader.
Create additional reports using Discoverer, BI or Oracle reports.
Creating UNIX script to scheduled jobs using CRON-TAB and maintained/creates scheduled jobs using MAESTRO or DBA_JOBS.
Handling user queries and production support.
Sr. Oracle Developer
Coterie Solutions LLC
March 2008 to December 2008
Client: Sony DADC, Terre Haute, IN
Maintenance and Support of the following Oracle ERP or Oracle E-Business Suite Modules:
Oracle Manufacturing
1.Inventory
2.Work In Progress (WIP)
Discrete Jobs
1.Configurator
2.Bill of Materials (BOM)
Media Management System (MMS)
Warehouse Management System (WMS)
Logistics Information System (LIS)
Quality System
Oracle Purchasing (PO)
Shop Floor System (SFC)
1.APB
2.FROGS
Responsibilities:
Interact with the team and functional users to gain understanding of the changes requested by the business users.
Design, develop and maintain enhancements / customizations to the modules mentioned above.
Uses Oracle's latest development tools to develop reports, forms, discoverer and procedures for an advanced reporting.
Creates objects from design specifications provided.
Performs necessary unit and system testing and document the changes.
Tuning for performance improvement initiatives through code modifications, adding cost base hints and/or the creation of an index, specialized views or even materialize views. Tuning efforts are based on the reports that the DBA generated every week that called Top 20 Low Performance Scripts.
Create additional reports for users using Discoverer 4i or BI.
Create additional interfaces from other systems to Oracle such JD Edwards, COM, SOFTEON, CLAIMS and etc. in a crossed platform.
Create additional process for ETL using the PLSQL to EXTRACT data from JD Edwards, SOFTEON, B2B and CLAIMS and TRANSFORM by validating the extracted data into a series of look-up tables and LOAD into Oracle Database using the SQL Loader.
Create additional reports using Discoverer, BI or Oracle reports.
Creating UNIX script to scheduled jobs using CRON-TAB and maintained/creates scheduled jobs using MAESTRO or DBA_JOBS.
Handling user queries and production support.
Sr. Oracle Developer
A Media Bank Company - Chicago, IL
July 2007 to December 2007
Supporting the following Clients:
Kinesis Marketing
Butler Till
Bennett Kuhn Varner
Frengo
Account Now
Tribal
Wyndham
Responsibilities: Sr. Oracle Developer
Develop an understanding of business processes.
Interact with the team and functional users to gain understanding of the changes requested by the business users.
Design, develop and maintain enhancements / customizations to the clients mentioned above.
Uses Oracle's latest development tools (Oracle Reports, Oracle Forms and PL/SQL) to develop reports, forms and procedures for an advanced reporting and analytics portal.
Creates objects from design specifications provided.
Performs necessary unit and system testing and document the changes.
Assists with performance improvement initiatives through code modifications and/or the creation of specialized views of the data.
Work with OWB to load and validate data from the client.
Provided end-user support in setting up maintenance files.
Handling post-live user queries and production support.
Sr. Analyst Programmer
Axiom Systems, Inc - Bolingbrook, IL
May 2006 to July 2007
Client: Sony Entertainment Distribution, Bolingbrook, IL
Quality Assurance (QA) System
This project is a conversion from Access Database to Oracle Forms and Reports 10g in Oracle 10g Database.
Responsibilities: (Project Lead)
Gathered requirements from users and preparing the system specifications and its data flow diagram.
Preparing program specs for each program to be developed that includes reports, maintenance screen, data entry screen, and batch programs and AD HOC reports.
Develop customize forms for Data Entry and some maintenance screen.
Develop customize Oracle forms 6i, reports 6i and discoverer 4i, UNIX scripting to cater user's requirements.
Develop triggers, procedures, functions and packages for the audit trail reports and month end processing.
Successfully tested and converted over 35,000 records from legacy system into Oracle customize table in both test and production environments using SQL Loader.
Customize audit trail and AD HOC reports.
Provided end-user support in setting up maintenance files.
Handling post-live user queries and production support.
Sr. Analyst Programmer
Oversea-Chinese Banking Corporation Limited – Singapore
February 2001 to April 2006
Staff Credit Facility
This project is a conversion from Visual Basic to Oracle Application.
Responsibilities: (Project Lead)
Gathered requirements from user and preparing the system specifications and its data flow diagram.
Preparing program specs of its program to be developed that includes reports, maintenance screen, data entry screen, and batch programs and ADHOC reports.
Develop customize forms for Data Entry and some maintenance screen.
Successfully tested and converted over 65,000 records from legacy system into Oracle customize table in both test and production environments using SQL Loader.
Developed batched program and ADHOC reports for month end processing.
Customize reports to cater the user requirements including audit trail reports.
Provided end-user support in setting up user responsibilities, menus, request groups and some flex values.
Handling post-live user queries and production support.
Phase 2 of Invoice Payment System
The main purpose of this system is to facilitate the prompt payment of all invoices that includes Equipment (Leasing or Metering) and Maintenance Contract (Supply/Install).
Responsibilities: (Project Lead)
Develop additional data entry screens and some maintenance screen.
Change all the programs done in phase 1 to cater the new set of books being implemented by the Oracle ERP such as GL, AP and FA.
Update the program specs of each program to reflect the changes done.
Developed additional triggers, SQL/PL-SQL stored procedure and function and some batched program.
Customize additional reports for a certain group of users including some reports for intellistor.
Oracle Purchase Order (PO)
Responsibilities:
Develop a host program to import items from legacy system to Oracle user defined temporary table then validate each record before it will be inserted into the Oracle Purchase Order Items table (MTL_SYSTEM_ITEMS_INTERFACE).
Enhance the host program to import requisitions from legacy system to Oracle table (PO_REQUISITIONS_INTERFACE) base on the user requirements.
Customize the PO approval workflow and the Requisition approval workflow base on the user request to meet business requirements.
Develop a host program to import orders from legacy system to Oracle user defined temporary table then validate each record before it will be inserted into Oracle Purchase Order tables such as PO_HEADERS_INTERFACE and PO_LINES_INTERFACE.
Develop a hose program to export orders from Oracle Purchase Order to legacy system.
Enhance the host program to import receipt from legacy system to Oracle user defined temporary table then validate each record before it will be inserted into Oracle Purchase Order tables such as RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE.
Develop a host program to export supplier from Oracle Purchase Order to legacy system.
Gathered requirements including report layouts for the customized reports from the user.
Develop reports using SQL or Oracle Reports 6i or Discoverer to cater the user requirements mention above.
Develop triggers; SQL-/PL-SQL scripts for the audit trail reports.
Provided end-user support in setting up user responsibilities, menus, request groups and some flex values.
Handling user queries and Production support.
Phase 2 of Oracle Fixed Asset (FA)
Responsibilities:
Developed additional PLSQL stored procedure and function and some batched program.
Customize additional reports for the users including audit trail reports and reformat some reports for intellistor.
I'm responsible for the development of the reconciliation program between Oracle Fixed Assets and the Oracle General Ledger.
Customize reports for a certain group of users for intellistor.
Invoice Payment System
The main purpose of this system is to facilitate the prompt payment of all invoices that includes Equipment (Leasing or Metering) and Maintenance Contract (Supply/Install).
Responsibilities: (Project Lead)
Gathered requirements from user and preparing the system specifications and its data flow diagram.
Preparing program specs of its program to be developed that includes reports, maintenance screen, data entry screen, and batch programs and ADHOC reports.
Develop data entry screen for EAV Data Entry (ELECTRONIC ANALYSIS VOUCHER) and some maintenance screen.
Successfully tested and converted over 90,000 records from Excel into Oracle customize table in both test and production environments using SQL Loader.
Developed batched programs and ADHOC reports for month end processing.
Customize reports to cater the user requirements including audit trail reports.
Provided end-user support in setting up user responsibilities, menus, request groups and some flex values.
Handling post-live user queries and Production support.
Bungalow System
This project is a conversion from Visual Basic to Oracle Application.
Responsibilities: (Project Lead)
Gathered requirements from user and preparing the system specifications and its data flow diagram.
Preparing program specs of its program to be developed that includes reports, maintenance screen, data entry screen, and batch programs and ADHOC reports.
Develop data entry screen for Booking Application, Withdrawal, Cancel and Reapply and some maintenance screen.
Developed batched program for Balloting and Slots Generation process.
Customize reports to cater the user requirements including audit trail reports.
Customize reports for a certain group of users for intellistor.
Provided end-user support in setting up user responsibilities, menus, request groups and some flex values.
Handling post-live user queries and Production support.
Oracle Fixed Assets (FA)
This project is a conversion from Clipper to Oracle Application.
Responsibilities:
Gathered requirements from user on what are the additional information of an asset they want to capture and preparing the program specs of the data entry screen and some maintenance screen.
Develop data entry screens to capture the additional information of an asset and some maintenance screen.
Successfully tested and converted over 120,000 records from legacy system into Oracle customize table in both test and production environments using SQL Loader.
Customize the workflow of the Oracle Fixed Asset for the cost center from asset cost center to asset assignment cost center to meet business requirements.
Developed batched program and ADHOC reports for month end processing.
Developed batched program for data synchronization between Oracle Fixed Assets and customized tables.
Customize reports for the user requirements including audit trail reports.
Provided end-user support in setting up user responsibilities, menus, request groups and some flex values during training session.
Handling post-live user queries and Production support.
Caveat/Mortgage Register System
This project is a conversion from Clipper to Oracle Application.
Responsibilities: (Project Lead)
Gathered requirements from user and preparing the system specifications and its data flow diagram.
Preparing program specs of its program to be developed that includes reports, maintenance screen, data entry screen, and batch programs and ADHOC reports.
Develop transaction data entry screen, some maintenance screen and reports including the audit trail reports.
Successfully tested and converted over 30,000 records from legacy system into Oracle customize table in both test and production environments using SQL Loader.
Developed batched program and ADHOC reports for month end processing.
Developed utility program to export data into a text file and ftp to a specified location for another system to pick up.
Provided end-user support in setting up user responsibilities, menus, request groups and some flex values.
Handling post-live user queries and Production support.
Oracle Accounts Receivables (AR)
Responsibilities:
Research on data conversion methodologies between legacy account receivables system and Oracle Account Receivables requirements.
Developed loader scripts and validation programs for data conversion of AR legacy system to Oracle AR.
Successfully tested and converted over 100,000 legacy accounts receivable data into both test and production environments.
Gathered requirements including report layouts for the customized reports from the user.
Developed and tested Oracle reports, SQL/PL-SQL scripts, and Oracle forms.
Developed batched program, triggers for audit trail reports and ADHOC reports for month end processing.
Customize reports to cater the user requirements and provide audit trail reports.
Customize the AR Credit Management Application Process Workflow to implement customize credit decision in order to meet business requirements.
Develop some customize reports for intellistor.
Assisted in the initial Oracle AR setup of the Development and SIT environment.
Investigated and fixed functional problems reported by users.
Conducted various functional tests either to prove concepts or to verify fixes.
Responsible for the migration of all customized program such as SQL/PL-SQL scripts, forms and reports and etc. to production environment.
Provided end-user support in setting up user responsibilities, menus, request groups and some flex values.
Handling post-live user queries and production support.
Oracle Accounts Payable (AP)
This project is a conversion from Tandem Accounts Payable System to Oracle ERP Accounts Payable Module.
Responsibilities:
Customize the CUSTOM.pll based on user request such us make some fields mandatory and validate base on certain criteria.
Gathered requirements including report layouts for the customized reports from the user.
Developed batched program, triggers for audit trail reports and ADHOC reports for month end processing.
Customize reports to cater the user requirements and provide audit trail reports.
Develop some customize reports for intellistor.
Successfully tested and converted the records from TANDEM ACCOUNTS PAYBLES System into Oracle AP Interface tables in both test and production environments using SQL Loader.
Investigated and fixed functional problems reported by users.
Conducted various functional tests either to prove concepts or to verify fixes.
Responsible for the migration of develop reports and SQL/PL-SQL scripts and register to Production environment.
Develop MS Access programs to populate invoice lines from different department to Oracle Interface tables.
Provided end-user support in setting up some flex values during training session.
Handling post-live user queries and Production support.
Oracle General Ledger (GL)
This project is a conversion from Tandem General Ledger to Oracle ERP General Ledger Module.
Responsibilities:
Successfully tested and converted the records of over 50 subsystems from TANDEM PBLGL System into Oracle GL Interface tables in both test and production environments using SQL Loader.
Gathered requirements including report layouts for the customized reports from the user.
Developed batched program, triggers for audit trail reports and ADHOC reports for month end processing.
Customize reports to cater the user requirements including audit trail reports and for intellistor.
Investigated and fixed functional problems reported by users.
Conducted various functional tests either to prove concepts or to verify fixes.
Responsible for the migration of develop reports and SQL/PL-SQL scripts and register to Production environment.
Provided end-user support in setting up some flex values during training session.
Analyst Programmer
Singapore Telecommunications Limited – Singapore
July 2000 to January 2001
SingTel is the Asia's leading communications group with operations and investments in more than 20 countries and territories around the world. SingTel has had more than 120 years of operating experience and has played an integral part in the development of the city as a major communications hub in the region.
Maintenance of Marketing and Billing Systems
Responsibilities:
Gathered requirements including report layouts for the new customized reports from the user.
Develop or change those existing reports based on user requirements.
Develop ADHOC reports for month end processing.
Prepare paper works for the migration of those develops or change reports to production after receiving the UAT signed off from the user.
Contact this candidate