Summary
Overview
Work History
Education
Skills
Qualifications And Certifications
Projects And Assignments
Industry Experience
Timeline
Generic
Ferdinand Yu

Ferdinand Yu

Business Analysts

Summary

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.

Overview

18
18
years of professional experience
26
26
years of post-secondary education

Work History

Business Systems Analyst

Infotech Solutions PH
05.2023 - Current
  • Organized system operating procedures to strengthen controls.
  • Identified needed business improvements and determined appropriate systems required to implement solutions.
  • Created and maintained standard operating procedures governing system functions and features.
  • Assessed business requirements to create focused solutions.
  • Coordinated data migration and consolidation efforts.
  • Improved systems with addition of new features and infrastructure.
  • Trained business personnel in use of systems.
  • Collected, defined and analyzed business requirements.
  • Enhanced interfaces to promote better functionality for users.
  • Tracked feedback at all levels and researched resolutions for common concerns.
  • Gathered, reviewed and reported on findings.
  • Researched and adopted new technologies to add value to existing offerings.
  • Monitored employee tasks to gauge business functions and inefficiencies.

Technical and Functional Consultant

NRI (Formerly ASG Group)
07.2020 - 04.2023
  • 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.
  • Troubleshot incidents reported by end-users to schedule system changes and identify permanent solutions.
  • Determined proper methodologies and procedures to use based upon project specifications.
  • Liaised between IT infrastructure team and other personnel to assist with resolution of system issues.
  • Professionally interacted with clients to assess business requirements and determine software needs.
  • Developed and implemented reports and presentations for key stakeholders and senior management.
  • Wrote effective documentation for each client system to deliver comprehensive sets of requirements and alignment with business objectives.
  • Developed, configured and tested applications for accurate alignment with project standards.
  • Analyzed existing systems and databases and recommended enhancements to solve business needs
  • Performed internal system acceptance to deliver well-tested enhancements and meet business requirements.
  • Enhanced project management skills by defining and presenting system solutions and timelines for business needs or technical problems.
  • Developed diagrams to describe and lay out logical operational steps.

Programmer Analyst

Vertere Global Solutions Inc.
07.2019 - 12.2020
  • Participated in design sessions with clients to ascertain project specifications.
  • Worked closely with clients to establish specifications and system designs.
  • Designed and developed loading scripts using control files and external tables to load data to main tables.
  • Worked with multiple sources such as relational database, flat files for extraction, transforming and loading data.
  • Directed software design and development to meet client needs for functionality and performance.
  • Identified causes of issues within applications and determined which modifications needed to be made.
  • 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, technical and requirements specifications.
  • Provided technical support using knowledge of complex technology to solve problems and support new projects.
  • Monitored the system once they are up and running in production and performed fixes or enhancements as needed
  • Performed regression and system-level testing to verify software quality prior to release.
  • Created projects, packages, mapping, procedures, variables, models, load plans, scenarios, and interfaces to load metadata and 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.
  • Planned computer systems using information engineering, data modeling, and structured analysis.

ERP Developer / MIS Engineer

VSTECS (Formerly MSI-ECS)
07.2016 - 06.2019
  • 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.

J1F Analyst / Software Engineer

Accenture
07.2010 - 01.2013
  • 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.

Oracle Developer / Analyst Programmer

American Technologies Inc.
08.2005 - 06.2010
  • Customized or developed Oracle workflows to meet company business processes.
  • Followed standard methodologies on coding to write clean and self-documenting code.
  • Developed or customized Oracle reports and forms to meet functional business requirements.
  • Drafted documentation to detail development, logic and testing processes.
  • Worked with end-users and functional analysts to capture and document business requirements.
  • Collaborated with technical contributors during application development to resolve application defects.
  • Liaised with end users and functional analysts to perform unit, system and regression testing.
  • Consulted with users on priorities, complexities and other impacts to provide time and cost estimates for proposed changes.
  • Gathered and documented business requirements to determine capabilities to be delivered.
  • Provided technical expertise to support daily operations in Oracle applications.
  • Designed and implemented scalable applications for data extraction and analysis.
  • Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
  • Coordinated deployments of new software, feature updates and fixes.
  • Conducted data modeling, performance and integration testing.
  • Estimated work hours and tracked progress using Scrum methodology.
  • Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.
  • Designed and developed analytical data structures.
  • Tuned systems to boost performance.
  • Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
  • Resolved or escalated problem tickets to resolve user issues.

Education

Diploma - Digital Media Technologies

GCA, Sydney Australia
01.2014 - 12.2014

Certificate II-IV in Information - Digital Media And Technology (Multimedia)

NTIS CODE: ICA20111, GCA, Sydney Australia
01.2014 - 12.2014

Supplemental Study - MS Visual FoxPro

Informatics
01.2000 - 01.2000

Bachelor of Science - Computer Science

AMA Computer University Project 8, Quezon City
05.1997 - 05.2021

Skills

Oracle E-Business Suite (Accounts Receivable, Accounts Payable, Order Management, Purchasing, iProcurement, Inventory, General Ledger, Cash Management, Fixed Assets)Oracle Cloud FusionOracle PL/SQLSQLOracle SQL DeveloperOracle DatabaseOracle Forms and ReportsOracle DiscovererOracle WorkflowsOracle Data IntegratorOracle Application FrameworkOracle Integration CloudGupta Team Developer (OpenText)JAVAWEB ADIETL (Extract Transform Load)OA FrameworkXML/BI PublisherSQL LoaderData LoaderAME (Approval Management Engine)PowerbuilderOracle APEXOTBIMulesoftBizTalkOracle APEXUnix ScriptingRed Hat LinuxSun SolarisPuttyWinSCPOffice 365ToadTortoise SVNBeyond CompareCisco WebexMS TeamsWorkchatVPN (Virtual Private Network)CollibraWindows ServerMS SQL ServerSybaseSharepointRemote Desktop Protocol (Jumphost)CitrixTeam ViewerPostmanREST Web ServicesJIRABMC Remedy Ticketing SystemServiceNowRedmineConfluenceGitHubCI/CD

Agile expertise

Personnel training

Research and analysis

Solution testing and implementation

Production support

Data migration

Report preparation

Requirements gathering

Documentation abilities

Technologically-savvy

Technical Analysis

Problem-Solving

Planning and Coordination

Scrum Master

Qualifications And Certifications

  • 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

Projects And Assignments

  • 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)

Industry Experience

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

Timeline

Business Systems Analyst

Infotech Solutions PH
05.2023 - Current

Technical and Functional Consultant

NRI (Formerly ASG Group)
07.2020 - 04.2023

Programmer Analyst

Vertere Global Solutions Inc.
07.2019 - 12.2020

ERP Developer / MIS Engineer

VSTECS (Formerly MSI-ECS)
07.2016 - 06.2019

Diploma - Digital Media Technologies

GCA, Sydney Australia
01.2014 - 12.2014

Certificate II-IV in Information - Digital Media And Technology (Multimedia)

NTIS CODE: ICA20111, GCA, Sydney Australia
01.2014 - 12.2014

J1F Analyst / Software Engineer

Accenture
07.2010 - 01.2013

Oracle Developer / Analyst Programmer

American Technologies Inc.
08.2005 - 06.2010

Supplemental Study - MS Visual FoxPro

Informatics
01.2000 - 01.2000

Bachelor of Science - Computer Science

AMA Computer University Project 8, Quezon City
05.1997 - 05.2021
Ferdinand YuBusiness Analysts