Mel Cruzado

Key Skills

Functional Industries

Financial Services, Utilities, Manufacturing, Education, Government, Local Council, Multinational Organisation.

Oracle Capabilities

• Financials (Oracle Cloud ERP)
• Financials (Oracle EBS)
• Supply Chain
• General Ledger
• Procurement
• Accounts Payable
• Accounts Receivable
• Inventory
• Projects
• Order Management
• Data Migration
• Integration
• Security and Roles
• BI Publisher
• OTBI

Technical Skills

• Oracle Identity Cloud Service (IDCS)User Management
• Oracle Import and Load Data–Employee, User and Rol Management
• Oracle Role Data Access Security and Oracle Procurement Agents Configuration
• Oracle Transactional Business Intelligence (OTBI)Reports
• Master data extract, analysis, cleansing, mapping, load preparation and post load reconciliation
• Data migration through Templates by Import and load of datafiles
• Data Migration via Interfaces and API using Stage–Transform-Load Framework
• Oracle Application Development-Reports, Interfaces, Conversions, Extensions and Workflows (RICEW)
• Prepare Solution Design, Technical Specifications and Installation Instructions
• Prepare Integration and Data Conversion Mapping Documents
• ATO Business Activity Statement (BAS)Detail and Summary Tax Reports
• ATO Taxable Payments Annual Report (TPAR)
• Subledger Accounting (SLA)Drill Down for GL Transactions Analysis Reports
• Purchase Requisition/Purchase Order Create and Approval Workflow Customisations
• Payment Process Customisations including Cheque Printing, EFT Payment File Generation & Separate
• Remittance Advice Bursting
• AR Statements, Dunning Letters and External Debt Collectors Customisations with Burst to Email & Print

Experience

Department of Justice and Community Safety - Melbourne, Lead Oracle Techno-Functional Consultant

2024 –2025

• Support the design, build and implementation of the Oracle Financials integration to enable payment of claims by DJCS under the FAS CMS Program.
• Lead the Oracle Integration end-to-end solution design and development to load suppliers and invoices to Oracle Financial System
• Develop Oracle data templates, reports and programs and work with business users and project stakeholders ensuring the requirements were captured and aligned with what will be developed, tested and implemented.
• Prepare Go-Live Runsheet, identify the pre-requisite activities and coordinate its completion including GL accounts definition, financial delegations for approval hierarchy, sftp directories set up and production clone timings ensuring they are ready for SIT and UAT.
• Prepare all the required Technical Design and Unit Test documents, create deployment scripts to migrate customisation and handover to the Oracle Finance BAU Support Team.
• Provide post-production support and establishment of standard operating procedures on the end-to-end process from Salesforce CMS extract, file transfer to Azure and GoFex to Oracle job scheduling and process timings.

Department of Health, Melbourne - Technical Business Analyst

2023 –2024

• Identify data requirements to load Oracle Cloud ERP employees, work structures and user data.
• Prepare User Role Mapping for the current Oracle EBS responsibility to future state roles in Oracle Cloud ERP.
• Prepare User Stories and Acceptance Criteria for the Employee, Work Structure, User Roles and Data Access.
• Manage the documentations and artefacts to support the establishment of the design requirements.
• Extract Data from Oracle EBS to help analyse the current state customisations and report requirements.
• Manage stakeholder communications for SMEs and vendor for all employee data related activities and timings.
• Support the team with techno-functional related tasks to help identify design gaps.
• Assist the current Oracle Finance Support Team for BAU tickets and project related activities.

KPMG, Melbourne - Manager, Powered Data

2022 - 2023

• Engagement Lead for Data Migration and Integration Projects for KPMG Powered Data Practice
• Organise Data Quality, Data Mapping and Reconciliation workshops with SMEs, Client Data/Platform Owner, Users and Data Migration team to establish the process leading towards the cutover and go-live data migration activities.
• Monitor progress and oversee completion of each object build and provide guidance on design challenges.
• Migration Lead for KPMG’s first Co-Existence Powered Data Migration Project for one of the Big 4 banks with daily migration and reconciliation of customer and accounts with Term Deposits and Self-Manage Super Funds over a period of 6 months. Successfully migrating over 200 cutovers/tranches.

Department of Transport, Melbourne - Lead Business Data Analyst

2020 - 2022

• Payroll Business Analyst unifying the different payroll systems being used at DOT (Empower, Chris21 and Connect) to SAP Success Factors - Employee Central Payroll (SAP ECP)
• Worked on DOT Localisation and collaborate with the Whole of Victorian Government (WoVG) Project Team for design and template alignment.
• Define Business Requirements Document for Integration between SAP Success Factors and Oracle ERP Finance
• Data Gathering, Analysis and Design and Mapping of Current and Future State Process
• Requirements gathering, test scenario creation and collaborate with the SMEs regarding proof of concepts and Payroll Simulation
• Prepare mapping documents for SAP Foundation Data on Cost Centre where DOT Chart of Accounts (Legal Entity & Cost Centre) is mapped to Team Level of the DOT Organisation Structure.
• Collaborated with Oracle Finance and DOT SAP Data Migration Team and Stakeholders for its finalisation.
• Use Oracle Visual Builder PaaS integrated with GitHub and Atlassian Source Tree to maintain application version control, track all issues and activities and report all development tasks and data cleansing requirements.

Rimini Street, Melbourne - Oracle Services Solution Consultant

2019-2020

Technical Support for Oracle e-Business Suite (EBS), Oracle Transport Management (OTM) Cloud Application and various integrations with 3rd Party application via WSO2 Integration platform

DXC Red Rock - Oracle EBS Technical Consultant

2012-2018

• Assigned to clients to provide onsite / remote consulting services on Oracle EBS project implementations, including technical design, development and support.
• Develop customisations & extensions on Financials, Procure to Pay and Supply Chain modules using Workflow, PL/SQL, Reports6i, XML Publisher, Discoverer, JDeveloper & OAF
• Clients included, Bunnings, Mazda, Melbourne University, Department of Transport, Red Cross, Department of Health, and various others across multiple industries

Boutique Systems Pty Ltd - Senior Oracle ERP Business Analyst

2009-2012

• Multiple Oracle EBS project implementations, including technical design, development and support.
• Focus on Oracle Financials
• Provided Support to existing clients
• Built integrations, migrations and reports

Various Oracle Technical and Business Analyst Roles

2002 – 2009

Location: Philippines, Melbourne and Adelaide.