Santhosh Devassy
Oracle Cloud Finance Consultant
Craigieburn
Summary
More than one year of Oracle ERP Cloud experience as Senior SME – Accounts Receivables in Department of Education, Victoria. Responsible for gathering requirements, preparing data field mappings, creating data migration specifications, developing complex SQL and PL/SQL scripts for extracting and converting data into Oracle ERP FBDI format, generating reports, assisting with data cleansing, resolving data issues during migration mock runs, verifying uploaded data in ERP Cloud, preparing reconciliation reports for business sign-off, and reducing error rates to ensure 100% success in UAT data migration. Over 18 years of specialized techno-functional prowess within Oracle E-Business Suite Applications, particularly in the capacity of Accounts Receivable, Fixes Assets, General Ledger, Accounts Payables, Procurement, HCM etc. Holder of an ITIL Foundation Certification in IT Service Management, reflecting a commitment to best practices in IT service delivery. Achieved certifications in Oracle Cloud Infrastructure (OCI) Associate, Oracle Cloud Data Management Associate, and Oracle Financials Business Process Foundation Associate. Vast techno-functional expertise in contributing to multifaceted projects encompassing the implementation, upgrade, and production support of Oracle Finance, and other Oracle ERP modules. Strong acumen in Requirement Gathering, Gap Analysis, and Business Process Modeling. Proven track record of successfully planning, overseeing, and managing intricate, large-scale techno-functional solutions within a complex service industry organization, demonstrating extensive expertise and accomplishments. Orchestrated the seamless migration of Finance data from legacy systems to Oracle E-Business Suite, leveraging adept use of Oracle Interfaces and APIs, etc. Adept in Oracle e-Business Suite development tools and languages, including SQL, PL/SQL, Oracle Forms/Reports, OAF, Oracle Discoverer, XML Publisher, XML Bursting, and more. Demonstrated mastery in Implementation, Upgrade, and CEMLI (Configurations/Customization, Extension, Modification, Localization, and Integration). Substantial techno-functional expertise and organizational proficiency gained in a fast-paced and challenging professional setting, showcasing a demonstrated ability to prioritize, handle multiple tasks, accomplish business objectives, excel in performance, and consistently maintain a customer-centric approach. Significant experience in SOA Gateway and custom Web services integration. Accomplished track record in delivering large-scale ERP implementations and intricate system integrations. Collaborative approach with cross-functional teams to define integration requirements effectively. Provides techno-functional subject matter expertise, ensuring alignment of development with project objectives. Recognized for outstanding problem analysis, root cause diagnosis, and resolution skills. Expert in Interfaces and Data conversions from Legacy systems to Oracle applications. In-depth experience in ITIL and information systems support practices. Exceptional documentation skills using AIM methodology. Robust understanding of software development strategies, SDLC, and release management practices. Ensures successful completion of Root Cause Analysis for critical incidents, facilitating resolution and related communication. Extensive experience in Performance tuning through TKPROF and Explain Plan analysis. Effective communicator across all organizational levels, adaptable to change, and proactive in meeting service expectations and deadlines. In-depth domain knowledge spanning Education, Health, Banking, Utilities, Manufacturing, Telecom, and Insurance sectors. Key strengths encompass leadership, stakeholder management, a customer-centric approach, and quick learning abilities honed through ERP implementation and support projects.
Overview
19
19
years of professional experience
3
3
years of post-secondary education
6
6
Certifications
Work History
Senior Subject Matter Expert – Accounts Receivables
Department of Education
Melbourne, Victoria
12.2023 - Current
- Delivered end-to-end solutions for the Accounts Receivables module, migrating from Oracle EBS to Oracle ERP Cloud.
- Identified business and end users for functional requirements collection.
- Supported the implementation partner in documenting existing business processes.
- Collected pain points from the business and proposed optimized solutions in the destination system.
- Documented current business processes in the source system and their equivalents in the destination system for business approval.
- Addressed process gaps and proposed suitable solutions to align with the destination system.
- Recommended maximum automation to minimize manual intervention.
- Gathered business-critical reports for financial reporting and suggested Oracle ERP OTBI reports or scoped them for custom solutions.
- Assisted the integration team in identifying integrations between Oracle EBS and third-party systems, collecting functional and technical documentation for conversion.
- Prepared UAT test scripts assigned tasks based on roles, and uploaded test scripts into Jira.
- Trained end users to execute test scripts, record results, and manage defects in Jira during UAT.
- Configured More4Apps for Oracle ERP and trained end users on the tool’s templates.
- Prepared sample data and test scripts for UAT with More4Apps templates.
- Identified appropriate stakeholders from Business, BAU, inter-departments, and third parties for requirement-gathering sessions.
- Coordinated with the project manager to create a calendar for data migration discussions on various objects.
- Assisted the change management team in preparing and sending stakeholder communications and scheduling sessions based on availability.
- Prepared an initial kickoff pack with an overview of data migration activities for each phase.
- Developed data migration mapping sheets for field-to-field mapping between Oracle EBS (source) and Oracle ERP Cloud (destination).
- Gathered requirements from stakeholders and translated them into data mapping sheets.
- Created lean specifications for master and transactional data migration objects.
- Designed complex SQL and PL/SQL scripts to extract data from Oracle EBS and convert it into Oracle ERP FBDI format.
- Generated FBDI files and supported the implementation partner in resolving data-related issues during mock migration runs.
- Verified uploaded data in the ERP Cloud and prepared reconciliation reports between Oracle ERP Cloud and Oracle EBS for business sign-off.
- Created custom reports and supported data cleansing activities to reduce error rates and achieve 100% success during UAT and production migrations.
- Collaborated with implementation partners, business users, and third-party system owners to prepare the data migration cutover plan.
Oracle E-Business Techno-Functional Consultant
Tata Consultancy Services (TCS)
Melbourne, Victoria
11.2018 - 10.2023
- Lead efforts to ensure seamless system availability and support for critical applications for Oracle Finance modules like Accounts Receivable, General Ledger, Accounts Payables, etc.
- Regularly integrate and apply software patches and updates to ensure that the system is not only up-to-date with the latest features but also fortified against potential security vulnerabilities.
- Created various Oracle Financial Interactive Reports, and Interactive Grid reports using the Oracle APEX tool.
- Extend Oracle applications using Oracle APEX builder for Financial modules.
- Take complete ownership of ERP integration project Oracle Finance integration with Coupa application, overseeing them from initiation to completion.
- Craft precise techno-functional specifications and artifacts, encompassing configuration and integrations, by interpreting high-level business requirements, solution design, and user-defined criteria.
- Manage and mentor the Oracle Finance Development team, optimizing deployed solutions, ensuring data consistency, and safeguarding existing Oracle & Coupa process integrations.
- Provide comprehensive service, delivery, and support across all aspects of projects.
- Ensure accuracy and execution of business-focused solutions, fostering effective integration between business functions through collaboration with support teams, internal IT, outsourced vendors, Oracle Business Solution Architect, and the Project Management office.
- Strategically plan, execute, monitor, and manage individual work packages to ensure adherence to defined scope and timelines.
- Actively manage and supervise workstream activities related to the projects.
- Offer advanced functional and analytical solutions, contributing across all project phases to achieve objectives and deliverables.
- Regularly monitor and report project progress through weekly reports.
- Collaborate closely with Santos Business Analysts and Coupa Consultants to gather interface and conversion requirements.
- Create design documentation for Boomi development and support in designing data mapping documents.
- Develop integration solutions within the Oracle ERP environment.
- Work closely with Boomi consultants to create end-to-end solutions.
- Conduct unit and system integration testing of the developed solutions.
- Assist Business Analysts in performing User Acceptance Tests.
- Aid the team in understanding Santos standards and the required framework for ERP integrations.
- Conduct peer reviews and provide feedback on project components.
- Validate integration mapping, design, and development.
- Troubleshoot major issues identified during Development, System Integration Testing, User Acceptance Testing, and Post Go-Live phases.
- Address integration bug fixes between Coupa and Oracle ERP.
Oracle E-Business Techno-Functional Consultant
Wipro Limited
Adelaide, South Australia
03.2012 - 10.2018
- Served as a Techno-Functional Consultant for Oracle Finance modules like Accounts Receivables, General Ledger, Accounts Payable, Cash Management, and Fixed Assets.
- Responsible for the oversight, development, and execution of processes related to the Oracle Finance modules.
- Manage the implementation of system configuration changes due to new releases, enhancements, fixes, and overall enterprise structure changes.
- Ensure successful completion of Root Cause Analysis for all critical and high severity incidents; enable resolution and related communication as appropriate.
- Conducts or participates in user requirements gathering, blueprinting, and documentation designs.
- Ensure the integrity of the configuration of the Oracle Finance system across multiple landscapes.
- Support production configuration and assist in functional change requests.
- Support business implementations by sharing best practice configuration skills.
- Assist with responding to user requirements, problem resolution, developing designs, and process Modelling.
- Conduct configuration changes to accommodate change requests and prototype activities.
- Demonstrate proof of concept & assist in training activities.
- Perform initial testing of problem fixes, change request, enhancements, and new functionality.
- Managed various types of work items, including Incidents, Service Requests, Problem Tickets, and Continuous Service Improvements.
- Designed and implemented custom extensions in OAF pages using Java to facilitate the printing of work order attachments from Open Text to Oracle EAMs.
- Participated in release management meetings to coordinate enhancements and system changes.
- Provided support for major enhancements and projects related to Oracle services.
- Collaborated with IT teams and vendors to address Oracle support service-related issues.
- Conducted and organized reviews of technical documents and deployed solutions to various environments (SIT/UAT/PROD).
- Communicated with business customers to gather requirements and define solutions.
- Ensured compliance with Origin's ITIL-based IT policies, including design standards, change control, security standards, and release management.
- Responsible for designing, developing, testing, and deploying new configurations and custom extensions in Oracle, such as reports, forms, alerts, workflows, and interfaces, maintaining technical integrity.
- Developed and maintained technical design documents, System Maintenance Technical Documents (SMTD), test scripts, and user training manuals.
- Created inbound and outbound interfaces between Oracle and third-party applications using Oracle SOA Gateway.
- Acted as the EBS Technical representative for the Dell Boomi product rollout in June 2017, participating in workshops and training sessions.
- Implemented the SparesFinder project, the first Dell Boomi integration in Origin Energy, exposing a custom API to external systems via Oracle Integrated SOA Gateway.
- Successfully integrated Vinidex with Oracle EBS, receiving material transaction inputs from Vinidex via email attachments and processing them using Dell Boomi.
- Executed an integration project with ServiceNow, involving the extraction of CLD, DOA, and Project data from Oracle EBS, which was then transferred to ServiceNow.
- Collaborated with Origin's Business Analysts to gather functional requirements and design software components.
- Reported progress and issues to Origin/Wipro management in a timely manner.
- Coordinated with team members to explore solution options, conduct peer reviews, and improve code quality.
- Played a key role in various patching projects as a technical consultant, identifying affected components, fixing issues, and performing testing.
- Worked closely with business end users, DBAs, Origin's functional team, Operations, and Infrastructure teams to resolve problems and implement enhancements, including root cause analysis.
- Established and maintained a Known Error Database (KEDB) and process documents for addressing repetitive issues and tasks.
- Successfully completed the upgrade activities for Noetix, Excel4Apps, and More4Apps wizards for Oracle E-Business plugins.
Oracle E-Business Techno-Functional Lead
Wipro Ltd
Bangalore, Tasmania
04.2010 - 02.2012
- Spearheaded expertise in Oracle Applications Finance modules especially on Accounts Receivables and General Ledger.
- Proficiently led the charge in gathering requirements and shaping solutions for Oracle projects.
- Diligently managed incidents and problem tickets in strict adherence to SLA and KPI benchmarks, delivering unwavering application support to end-users while promptly resolving functional and technical issues.
- Played a pivotal role in application design, offering insightful input during code reviews, and proactively recommended enhancements.
- Orchestrated the initiation of change requests, meticulously prepared functional and technical documentation, and rigorously tested components across Unit Test, Performance Test, Regression Test, and System Integration Test (SIT) stages.
- Authored comprehensive documents such as BR100, MD050, MD70, and MD120 for smaller projects and customizations.
- Leveraged Kintana packages to seamlessly migrate developed components from the development environment to production.
- Collaborated effectively with the Oracle support team, persistently troubleshooting and debugging issues until their satisfactory resolution.
- Fostered productive collaborations with DBAs and third-party vendors, ensuring the delivery of high-quality solutions.
- Strategically addressed problem tickets, consistently updating relevant teams, conducting Root Cause Analysis (RCA), and implementing permanent fixes.
- Maintained ongoing communication with clients and end-users, providing weekly status updates on issue resolution progress.
- Demonstrated unwavering commitment with 24/7 support during critical month-end, quarter-end, and year-end closures.
- Regularly updated and disseminated month-end closure (MEC), quarter-end closure (QEC), and year-end closure (YEC) statuses to senior management within both Wipro and Avago.
- Contributed to end-user empowerment through training initiatives and the creation of comprehensive end-user training materials.
- Produced and reviewed technical articles related to Oracle applications, enriching the Known Error Data Base (KEDB).
- Developed and meticulously maintained up-to-date process documents, ensuring operational excellence.
Oracle E-Business Techno-Functional Consultant
EDB Business Partner
09.2008 - 03.2010
- Conduct comprehensive requirement gathering and perform gap analysis to identify areas for enhancement.
- Address functional and technical challenges within the Oracle application, ensuring seamless operations.
- Engage in meaningful user interactions to gain insights into system issues and challenges faced by users.
- Provide expert advice and implement enhancements to streamline processes and reduce manual workloads.
- Develop essential documentation, including BR100 setup documents, MD50 functional documents, MD70 and MD120 technical documents.
- Oversee the creation and management of both Inbound and Outbound Interfaces for efficient data exchange.
- Analyze all customizations and extensions to optimize system performance.
- Formulate action plans and execute solutions to resolve identified issues and improve application functionality.
Oracle EBS Technical Lead
KPMG
Mumbai, India
11.2006 - 08.2008
- Expertise in handling diverse data conversions and interfaces, including Open Purchase Orders, Sales Orders, Supplier Migration, Supplier Additional Information, Item Migration, AP Invoice Migration, AR Invoice Migration, Bill of Material and Routing, Job Migration, Move Transactions, Resource Transactions, and Material Completion Transactions.
- Demonstrate leadership by guiding and mentoring fellow technical resources in the development of reports, conversions, and customizations, fostering skill growth within the team.
- Facilitate seamless collaboration with end-users, ensuring their requirements are met by actively participating in report development and legacy data migration efforts.
- Conduct rigorous testing procedures encompassing reports, Inbound and Outbound interfaces, and various client extensions to guarantee flawless functionality.
- Craft comprehensive end-user training manuals, empowering users to effortlessly navigate and leverage the full spectrum of Oracle Application functionalities.
- Skillfully execute Form and Workflow Customizations, tailoring the system to align with specific business needs and workflows.
Education
Master of Computer Applications (MCA) -
Madurai Kamaraj University
Madurai, India 06.2002 - 11.2004
Post Graduate Diploma in Computer Applications (PGDCA) -
Madurai Kamaraj University
Madurai, India 06.2001 - 05.2002
Skills
Oracle Fusion Cloud
Oracle EBS
SQL
PL/SQL
OTBI
BI Publisher
Oracle Forms
Oracle Reports
Oracle Workflow
Oracle Discoverer
XML
XML Bursting
XML Gateway Message Designer
Dell Boomi
SOAP UI
SQL
Certification
Oracle Financials Business Process Foundations Associate Rel2, 09/26/23
Resident Status
Australian Citizen
Timeline
Senior Subject Matter Expert – Accounts Receivables
Department of Education
12.2023 - Current
Oracle E-Business Techno-Functional Consultant
Tata Consultancy Services (TCS)
11.2018 - 10.2023
Oracle E-Business Techno-Functional Consultant
Wipro Limited
03.2012 - 10.2018
Oracle E-Business Techno-Functional Lead
Wipro Ltd
04.2010 - 02.2012
Oracle E-Business Techno-Functional Consultant
EDB Business Partner
09.2008 - 03.2010
Oracle EBS Technical Lead
KPMG
11.2006 - 08.2008
Master of Computer Applications (MCA) -
Madurai Kamaraj University
06.2002 - 11.2004
Post Graduate Diploma in Computer Applications (PGDCA) -
Madurai Kamaraj University
06.2001 - 05.2002
Similar Profiles
ABIGAIL CORTESABIGAIL CORTES
Paraprofessional at Department Of EducationParaprofessional at Department Of Education
Romela ZalsosRomela Zalsos
Special Education Teacher/High School Social Studies Teacher at Department Of EducationSpecial Education Teacher/High School Social Studies Teacher at Department Of Education
Tahlia MatthewsTahlia Matthews
Relief Special Needs Education Assistant at Department Of EducationRelief Special Needs Education Assistant at Department Of Education
Olivia GrahamOlivia Graham
Secondary Science Teacher at Department Of EducationSecondary Science Teacher at Department Of Education
Joynal AbedinJoynal Abedin
Kitchen Hand at Sultan's DineKitchen Hand at Sultan's Dine