OTM Technical Consultant with 3+ years in Oracle Fusion Cloud, specializing in SQL development and d
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
I bring over 3.7 years of experience as a Technical Consultant specializing in Oracle Fusion Cloud. I am a results-driven SQL professional with strong experience in SQL database development, query optimization, data analysis, and data management. My expertise spans the development of custom BI and OTBI reports focused primarily on Procure-to-Pay, Order-to-Cash, and Financial modules including General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), and Fixed Assets. I also have experience in procurement modules, implementation, and configuration of Oracle Financial Modules including GL, AP, AR. I have worked on various roles like implementation, post-implementation support, data migration, and QA testing in the Financial module.
Nexxoft Infotel Ltd.
Oracle Fusion Technical Consultant
November 1, 2022 – Present
India
Agios Pharmaceuticals
March 1, 2024 – October 1, 2024
Customer, Customer Contacts and Customer Accounts imported using FBDI templates. Supported data migration activities including data extraction, transformation, validation reconciliation and post migration Support. Managed database security through user access control, roles, permissions, authentication and audit compliance. AGIOS AP unpaid invoices based on supplier and the date parameters. AGIOS Supplier Open Balance report. AGIOS Supplier Balance Summary Report. AGION GL Trail Balance Report. Developed AP Integration to AP invoices from third party system using OIC SOAP/Rest services. Design and Development of Customer Invoice statement with bursting options enabled in BI reports. Developed Data Extracts in BI Publisher and set up FTP connections with the third-party system. Worked on Query Optimization and Performance Tuning of BIP Reports. Worked on FBDI Template load for suppliers and Invoice data. Trained end users and internal on fusion GL,AP,AR,CM and FA Reports. Worked on BI Publisher Reports and Custom ESS Job creation. Raising SR to Oracle to get support on specific issues.
Salvation Army Fin Implementation and Support
May 1, 2023 – February 1, 2024
Implemented outbound master data (Supplier, Customer, Exchange rates) to Source systems. Supported ETL processes, reporting requirements, and large scale data processing activities. Worked on database patching, Upgrades, environment refreshes and release deployment support. Implemented Custom BI/OTBI reports as per client requirement. Understanding the Functional Specifications (MD050). Preparation of Technical Design Documents (MD070). BI Publisher template development in Invoice and Credit Memo Print. Displaying Customer and Address Detail in OTBI Reports. Created Multiple Custom Jobs and duty roles as per business requirements in financial modules. Performed Data load (conversion) for suppliers, supplier address, sites, contact sites, business attachments by using the FBDI Templates. Worked on Creation of Data Access sets, custom jobs and duty roles in the security console. Conducted Workshops and Knowledge Transfer Session with Client Team.
KNS ACQUISITIONS
November 1, 2022 – June 1, 2026
Developed AP Invoice on hold report. Worked on Query Optimization and Performance Tuning of BIP Reports. Worked on PLSQL Packages for data validation. Worked on General Ledger journals load FBDI. Migrated master Data Supplier/Supplier Address, Supplier Sites, Supplier Site Assignments, Supplier Contacts and Supplier Bank Accounts using FBDI templets. Created ESS jobs for custom reports as per the client requirements. Involved in Migration from DEV environment to Test and UAT environments. Developed AP, AR and GL OTBI reports for Audit purpose. Involved in Developing KNS Awards Report. Worked on AP Invoice Validation Reports. Worked on Asset Activity Report. Developed bulk data import via FTP, enabling secure and efficient file-based integrations between on-premise and cloud systems. Generated bank payment files in EFT Format. Developed KNS General ledger Journal detail Listing report. Developed KNS Supplier Open Balance report. Worked on Customization of standard report (Customer Statement Report). Worked on Purchase Order Fbdi from Ebs to Fusion. Involved in end-to-end General Ledger (GL) data import using FBDI templates through OIC. Developed Dashboard to view the AP invoice interface process and exception data.
Aviva Insurance Fin Implementation
November 1, 2022 – April 1, 2023
Build the customer, supplier, AR and AP payment BI reports and FTP the output. Developed PL/SQL Package, procedures, functions and scripts for automation and reporting. Developed Custom reports using BI and customized the standard reports as per the requirement with Bursting. Developed using Payable payment hold report by supplier Developed prepayment invoice by suppliers. Developed Custom AP Invoice details Report with PDF and excel output. Developed Custom AP Payment details Report with PDF and excel output. Developed Custom PO Purchase order Report with PDF and excel output. Developed Custom PO Requisition Report. Developed queries on PO, AP, AR, XLA and GL base tables. Created required lookups, created connections to FTP, Fusion application and Fusion BI to run ESS jobs and Error BI reports. Developed analysis OTBI reports in GL and AP. Trained users on OTBI analysis. Involved in Data Conversion using FBDI templates. Custom ESS job Creation. Raising SR to Oracle to get support on specific issues. Resolved Support issues in BI reports in AP, AR, GL and FA modules. Created a few custom roles in payables and receivables users.
Cultural Fit Analysis
The candidate's experience across multiple clients (KNS, Agios Pharmaceuticals, Salvation Army, Aviva Insurance) and locations (US, Singapore) demonstrates adaptability to diverse work environments and client cultures. The breadth of their technical skills and involvement in various aspects of Oracle Fusion implementations (reporting, data migration, security, integrations) indicates a versatile and collaborative mindset. Their experience in training end-users and participating in business requirements gathering further suggests a proactive and team-oriented approach, which aligns well with a consulting role requiring strong client interaction.
Soft Skills & Operational Fit
The candidate demonstrates strong client-facing skills, including conducting workshops and end-user training, which are crucial for a consulting role. Their experience in handling business-critical issues and supporting ETL processes indicates good problem-solving and operational support capabilities. The resume also highlights excellent communication and team management skills, essential for collaborative project environments. The candidate's involvement in various project phases (implementation, support, data migration, QA testing) suggests adaptability and a comprehensive understanding of project delivery.