Ferdinand Yu

Skilled Business System Analyst with record of success breaking down and improving business systems. Collaborates well to test, implement, refine and enhance systems and meet current and expected business needs. Excellent research, reporting and communication strengths developed over 18 year career.

• Apr 2022, Oracle Cloud
• Jan 2018, SAP B1 Training
• Jul 2017, Oracle BI Training
• Sep 2012, Oracle Hyperion
• Sep 2012, Oracle Hyperion Financial Management
• Sep 2012, Oracle Data Integrator
• Sep 2012, Oracle Essbase
• Sep 2012, Oracle Business Intelligence
• Sep 2012, Introduction to Unix
• Sep 2012, Introduction to Oracle SQL
• Sep 2012, Introduction to Oracle PLSQL
• Sep 2012, OBIEE Answers and Dashboards
• Sep 2012, Oracle BI Publisher and ITIL Training
• Aug 2010, SQL Programming: Data Handling Techniques (CBT)
• Aug 2010, SQL Programming: Database Queries (CBT)
• Jul 2010, Oracle 10g Administration Boot Camp
• Jul 2010, Microsoft Windows Server 2003
• Jul 2010, Oracle Scripting and On-the-Job Simulation
• Jul 2010, Solaris System Administration
• Aug 2006, Basic Accounting
• Jul 2006, Oracle Accelerator
• Jun 2006, Oracle Reports
• May 2006, PL/SQL
• Nov 2005, E-Business Suite Essentials for Implementers
• Nov 2005, Navigate Oracle Applications
• Oct 2005, Oracle Business Guidelines and Processes for Partners
• Sep 2005, Oracle Support Customer Orientation
• Nov 1998, Assembly Language
• Nov 1998, HTML/JAVASCRIPT
• Nov 1998, Internet Technology
• Jul 1998, Local Area Network

• Infotech Solutions PH, May 2023, Present, Manages the AWS infrastructure and strategic vendor relationships including development firms., Works with internal teams to create the migration process of legacy systems to the AWS cloud., Collaborates with business unit managers to understand project scope, suggest possible alternative and document each step of the design., Works with security division to design and manage IAM roles for users, vendors and other third-party vendors., Works with several third party vendors in big data and other areas to support our overall cloud initiative., Collaborates with the sales team, formulate and execute a sales strategy to exceed revenue objectives through the adoption of AWS.
• NRI (Formerly ASG Group), Jul 2020, Apr 2023, Gathering business requirements, providing technical solution to defects in the application and supporting day to day operations., Liaising with business users, business analysts to ensure business needs are met., Maintaining the production and non-production application environments., Nurturing continuous process improvements according to the client’s policies., Contributing to the functional and technical design., Involving in the full development cycle of planning, analysis, design, development, testing and implementation., Designing, developing, and implementing database structures including tables, indexes, views, stored procedures, packages, triggers and functions., Writing PL/SQL programs required to retrieve data using cursors and exception handling., Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and eliminating the complexity of the large queries., Created and modified several Unix shell scripts according to the changing needs of the project and client requirements., Performed SQL and PL/SQL tuning and application tuning using various tools like tkprof, autotrace and dbms_sql tuning., Integrating using REST Web Service, Configuring and migrating setup, creating custom OTBI and BIP Report using complex SQL queries and Subject areas. Configuring FRS reports using smart view, importing and converting data using web service and file-based data import., Used DevOps agile principles GitLab, Docker and GitKraken., Reduced code conflicts after utilizing GitLab for version control., Leveraged docker for containerization which reduced deployment time, Learned and worked with different platforms and technologies, API Management platform, ESB and AWS tools.
• Vertere Global Solutions Inc., Jul 2019, Dec 2020, Designed and developed table structures, stored procedures, and functions to implement business rules., Developed shell scripts that execute PL/SQL for scheduling periodic load processes., Designed and developed loading scripts using control files and external tables to load data to main tables from flat files., Developed reconciliation reports that joins the loaded data from the main table that generates CSV files., Used extensively Integration Knowledge Module (IKM) to efficiently transformed data from staging area to the target tables by using optimized PL/SQL., Designed and documented the process and data flow, ER-Diagrams, Solution Decks, High Level architecture diagrams, Functional Specifications, Technical Specifications and Requirements Specifications., Delivered high level assessment for application system modification and technical requirements., Collaborated with Business Analyst to provide design inputs and estimates in the preparation of Requirement Specifications., Conducted Unit Testing to ensure program executes without any issues., Coordinated with Oracle vendor while doing my own investigation and possible resolution of errors reported during User Acceptance Testing and System Integration Testing., Monitored the system once they are up and running in production and performed fixes or enhancements as needed., Designed and developed complex Interfaces using Oracle Data Integrator (ODI) that involved slowly error handling and business logic implementation., Created Projects, Packages, Mapping, Procedures, Variables, Models, Load Plans, Scenarios, and interfaces to load metadata and data., Acquired extensive knowledge on Oracle General Ledger Module and Financial Accounting Hub., Involved in the banking process and integration of different applications through developing Application Programming Interface (API)., Interacted with Business Units / Stakeholders for requirements gathering., Experienced with performance tuning and query optimization for Oracle RDBMS using Explain Plan., Modelled the data structure of the target data warehouse to store the required information., Worked with multiple sources such as Relational database, Flat Files for Extraction, Transforming and loading data., Involved in debugging existing scripts, reviewing codes, developing and maintaining Work Plans to manage the scope and team and make sure delivery schedules is right on track.
• VSTECS (Formerly MSI-ECS), Jul 2016, Jun 2019, Involved in the upgrade of Oracle EBS from 11i to R12.2.0 and R12.2.7 accordingly., Worked closely in retrofitting CEMLI’s to R12., Involved in cross functional discussion with business users to address critical upgrade issues., Performed end to end integration testing for business flow processes touching integration points and customizations, Worked with Procure to Pay teams to test cross module customizations/interfaces., Reviewed Order Management customizations and performed gap analysis., Worked with business users to test customization during UAT and SIT. Drafted integration test scripts and unit test scripts for CEMLI., Migrated customizations including personalization, workflow, lookups and concurrent programs using Oracle’s object deployment process using FNDLOAD., Created the control files to migrate the data into staging tables, Experienced in loading data from spreadsheets., Worked on building PL/SQL programs for validating and converting the data into Oracle EBS base tables, Trained business users with the new functionality in R12 and provided user’s manual., Created documents like functional (MD050), technical (MD070) for newly gathered requirements., Developed new customized objects and extensions based business requirements provided by the Client following the Agile Methodology;, Contribute towards impact analysis of Oracle released patches on modifications and/or customizations to the Oracle EBS environment., Scoped customizations and proposed work plan detailing the following information:, Product Description and Deliverables;, External Dependencies;, Risks and Assumptions;, Task Level Cost and Effort Breakdown., Documented TE040 test case documents for QA Team., Supported production post Go-live on closing issues. Examined and corrected production issues as they occur in the system. Supported the clients by providing long-term solutions to the tickets by replicating issues to dig deeper into the root cause of the issue., Prepared technical design documents for the on-going enhancements and application patches, Validated and customized reports using different tools like XML Publisher, Oracle Reports Builder and BI Publisher, Developed API integrations for Oracle E-Business Suite., Created personalization for Oracle E-Business Suite R12., Performed data fixes in the database., Administered Oracle E-Business Suite., Designed and built components for Oracle eBS Financial modules which include Interfaces( AR, GL, and AP), Conversion (Supplier and Customer Conversion) and Extension (AR Customer Validation and Import), Used PL/SQL and SQL
• Loader to create packages for flat file loading and error capturing into log tables, Seeked deep and complete understanding of business objectives, requirements and designs for process improvements and attended trainings and walkthroughs., Provided technical support of custom extensions to Oracle Applications - configurations, extensions, modifications, localizations and integration (CEMLI) across EBS.
• Accenture, Jul 2010, Jan 2013, Provided Remote Assistance and Online Client Support., Supported clients for airline applications and infrastructure., Monitored proactively and supported applications on its components and its health status., Involved in checking the database performance and application's availability on the start of business day., Responded immediately to all alert notifications from applications and performed appropriate resolution based on SLA., Executed SOP’s for preventive measures using SQL Scripts., Involved in creation of users in Microsoft Server active directory and group policy., Managed active directory and user administration., Provided Remote Support and Administration on network for Internal and external clients using tools like Microsoft Remote desktop Connection, VNC, Putty, Citrix, and Team Viewer., Performed troubleshooting software issues.
• American Technologies Inc., Aug 2005, Jun 2010, Involved in implementation of Oracle E-Business Suite 11i Financial Modules, Responsible for collecting business requirements, analysing gap between oracle functionality and business requirements and designing a solution., Worked on Financial modules setups and configurations., Supported in configuring multi-organization environment for business groups, legal entities, operating units, set of books, chart of accounts. Setting up customer details, currencies, flexfields, profile options, quick codes, bank accounts, payment methods and other setups.), Responsible for issue resolution, escalations, TAR or Metalink support, Created functional specifications and BR100 documents, Resolved implementation and post implementation problems in the production environment., Documented user manuals for business users., Suggested functional design and process flow and provided training to stakeholders., Supported business for month end closing.
• Orient Integrated Development Consultants Inc., Jan 2004, Dec 2004, Designed, developed, and implemented Accounting System for 5 different conglomerate companies: CHI, COOP, CTTC, OIDCI, and ENR., Tracked transaction entries of the company namely: Voucher Payable Entry, Check Voucher Entry, Journal Voucher Entry, Official Receipt Entry, Billing Journal and Voucher's Request Entry.
• Kanzen Solutions Inc., May 2001, Dec 2003, Designed, developed, and implemented application systems for KSI clients., Developed a network management system., Created the different objects which acquire data and storing the data in SQL Server., Involved in projects for AR, AP, INVENTORY, PURCHASING System., Involved in the development of Sales and Distribution System and Simple Business Solution, Involved in the tracking of the Sales Process and Inventory Control of the company., Integrated system using remote access service which links to multiple sites (storefronts and warehouses)

• Financial Services
• Distributor
• Government
• Airline
• IT Outsourcing
• Retail