Ankita Samal
Oracle Cloud Techno Functional Consultant
Summary
A highly experienced and extremely accomplished individual with an outstanding knowledge in the field of Oracle Fusion Cloud and Oracle EBusiness Suite 11i/R12 is currently seeking opportunities where I can apply my experience, skills and knowledge which will enable me to make a continued significant contribution as a distinguished Technical as well as functional consultant.
Overview
15
15
years of professional experience
4
4
Certifications
Work History
Oracle Fusion Functional Consultant
SAB Oracle Finance Implementation Project
01.2024 - Current
- Led end-to-end Oracle Fusion Cloud Financials implementation for Payables and Fixed Assets, driving solution design, configuration strategy, and business process transformation initiatives.
- Conducted executive-level requirement workshops, performed gap analysis, and delivered comprehensive BRD, FDD, and Solution Design Documents aligned with enterprise objectives.
- Architected enterprise structure setup including Ledgers, Legal Entities, and Business Units, ensuring compliance with statutory and corporate reporting standards.
- Designed and implemented complete Procure-to-Pay (P2P) lifecycle covering invoice processing (Standard, Credit Memo, Prepayment), payment processing (EFT/Cheque), and accounting integration with General Ledger.
- Designed and optimized BPM approval workflows for invoice and payment processes, strengthening internal controls and governance.
- Led data migration strategy for suppliers, open invoices, and asset data using FBDI and ADFDI; ensured reconciliation accuracy and zero critical post-go-live discrepancies.
- Directed cross-functional integrations between Payables, Purchasing, Cash Management, and General Ledger, ensuring seamless financial accounting flow.
- Played key role in Oracle Integration Cloud (OIC) design and data mapping for ARIBA–Oracle Fusion integrations (inbound/outbound), collaborating with technical teams and external vendors.
- Developed executive dashboards and financial reports using OTBI and BI Publisher, enabling real-time visibility into liabilities, aging, and cash flow positions.
- Managed Security Console configurations including custom role creation, data access policies, and segregation of duties alignment.
- Supported Risk Management initiatives and internal audit controls to enhance compliance framework.
- Led SIT, UAT, regression testing, ensured smooth Go-Live and hypercare stabilization.
- Provided strategic support during month-end and year-end close cycles, ensuring accurate subledger accounting and reconciliation.
- Mentored junior consultants, conducted user training sessions, and prepared comprehensive SOPs and knowledge transfer documentation.
Oracle Technical Consultant
Royal London Group, UK
06.2019 - 09.2023
- Worked on implementation and support for RLG in UK Location.
- Incident Management – Led end-to-end Incident Management for high-severity production issues, driving rapid service restoration by prioritizing incidents based on business impact and mobilizing cross-functional teams.
- Owned the complete incident lifecycle including triage, root cause analysis (RCA), resolution, escalation management, and stakeholder communication to ensure SLA compliance and minimal business disruption.
- Performed advanced troubleshooting in complex production environments, identified application defects, and collaborated with development teams for permanent fixes.
- Established and maintained Incident, Problem, Risk, and Change Management procedures, ensuring governance, audit readiness, and process standardization.
- Drove automation and continuous improvement initiatives to eliminate recurring incidents, enhance system stability, and improve operational efficiency.
- Batch Monitoring - Led enterprise batch operations for Pension Support systems, monitoring PL/SQL and SQC jobs using Dollar Universe (SU) across Production and UAT environments to ensure uninterrupted processing.
- Managed end-to-end job scheduling lifecycle including job creation, session management, dependency configuration, calendar-based scheduling, resource allocation, and business view monitoring.
- Performed advanced job failure analysis in Unix environments, implemented corrective fixes, and coordinated with on-call and cross-functional teams to resolve late/long-running jobs within SLA timelines.
- Developed and maintained automation scripts using Unix, DOS, and PowerShell to optimize batch performance and reduce manual intervention.
- Conducted proactive log monitoring, performance tuning, and continuous improvement initiatives to enhance batch stability, reliability, and operational efficiency.
- In Dollar Universe involved - Job creation, Management units, Launches, Business view and Sessions, Schedule tasks and sessions for specific events, Data models, Using calendars, Assign scheduling rules to specific tasks, Managing conditions, dependencies and resources.
- Insurance Domain- Strong domain expertise in Life Insurance and Pension lifecycle management, including Auto-Enrolment, policy administration (Oryx Framework), scheme build, contributions, renewals, payroll assessments, investment processing, and quotes management.
Oracle EBS Technical Consultant
Ingersoll Rand -IR
12.2013 - 03.2019
- Worked on the development of RICEW components on various modules such as MFG, INV, PO and WSH- Shipping.
- Developed and Supported many manufacturing interfaces like Item Sync Interface, Revision Sync Interface, Windchill Item Interface, Windchill BOM Interface, Discrete Routing conversion.
- Worked on WEBADI Flow schedule Import.
- Created Applications by using Oracle APEX.
- Worked on BOM Explosion API.
- Developed outbound interface for PO outbound Interface, PO Requisition outbound, Inventory material transactions outbound, Inventory Locators and Subinventories Outbound interface, Inventory Sync Outbound Interface, Truck unload interface.
- Developed an inbound interface for Inventory material transactions inbound interface, Oracle Internal Requisitions interface, Truck load interface.
- Customization of MSCA Pages.
- End to End testing of the interface: Requisition creation-Receipt for the Purchase Order. Created test data for material transactions like miscellaneous receipt, miscellaneous issue and Sub inventory transfer.
- Customized the custom form using Forms 10g tool.
- Extensively worked with developing reports using Oracle Report (XML Reports, reports using data template and translations) 6i & 10g.
- Experience in Workflow customizations.
- Worked on Agile process like creating of Jira, Story points, Update scrum board.
- Functional knowledge on Purchasing and Inventory.
- Prepared Technical Specifications Document MD70, MD120 and Unit Test Plan document.
- Responsible for meeting deadlines for the change request or enhancement.
- Worked on SQL Loader.
- Proactively performance tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
- Worked on Erwin and data ware housing to extract transform and load from legacy system to new SAViS system.
- Document and communicate changes to OLTP, OLAP systems.
- Responsible for data analysis, transforming and loading data from different vendors and other flat data files sources.
- Project Name: Ingersoll Rand -IR
Developer
JP Morgan Chase -JPMC
02.2013 - 12.2013
- Oracle Apps Technical Consultant for upgrade and support project.
- Upgrade Assessment of current business process in R12 (AP,GL and FA)
- Retro fitment of Packages, Procedures, Views, Triggers and Workflows as per Release 12 standard.
- Develop various Oracle Applications using PL/SQL, SQL
- Plus, Reports, Workflow Builder, and Application Object Library.
- Use Oracle E-Business Suite applications for accounts payable (AP), iExpense, general ledger and fixed assets.
- Designed and developed reports using combination of RDF Report, Data template and XML publisher for modules like AP and GL.
- Extensively worked in Workflow customization for hierarchy approval level in iExpense.
- Worked on Interfaces and APIs.
- Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
- Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.
- Project Name: JP Morgan Chase -JPMC
Developer
Ingersoll Rand - IR
04.2012 - 02.2013
- Hands-on experience in Oracle Applications (R12,11i) as a Technical Consultant and functional areas i.e Oracle Purchasing, AP and Inventory.
- Extensively worked with developing reports using Oracle Report 6i & 10g.
- Expertise in development and customization of XML Reports and reports using data template.
- Experience in Workflow customizations for POAPPRV & CREATEPO Workflows.
- Worked on lifting shifting of interface & conversion programs.
- Worked on few Form Personalizations.
- Worked on Oracle Financial Application module such as Oracle Purchasing, AP and INV.
- Worked on customization of Part Supplier interface.
- Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, forms and reports.
- Also engaged in support activities like creation of data Fix scripts, Custom Solution issue Fix, Workflow issue Fix and Pre-Lease changes (Forms/Reports/Workflow).
- Project Name: Ingersoll Rand - IR
Developer
MAXAM
04.2011 - 11.2011
- Assess business and application requirements. Work with the client to analyze their requirements; prepare and participate in workshops, requirement documentation.
- Role includes implementation of new functionalities, deep involvement in a business process and knowledge transfer provision creation of solution design.
- Extensively worked with developing reports using Oracle Report 6i.
- Expertise in deploying reports on Reports Server and troubleshooting Oracle Reports.
- Worked on Oracle Financial Application module such as AP, AR, GL, PO and FA.
- Proficient in programming like Procedures, Functions, Database Triggers, Packages using PL/SQL and SQL.
- Defined value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures, and Packages.
- Do useful coding such as SQL queries and PLSQL code.
- Migrate the report in Oracle application environment for review.
- Prepare Technical Specifications Document, Unit Test Plan document and Code promotion sheet.
- Responsible for meeting deadlines for the change request or enhancement
- Project Name: MAXAM
Developer
Johnson & Johnson
01.2011 - 03.2011
- Hands on Oracle Reports, Forms, Packages
- Gather knowledge on Oracle Application EBS
- Project Name: Johnson & Johnson
Education
B Tech - Computer Science
SOA University
+2 - Science
10th - All subjects
Skills
Technologies :-
SQL
PL/SQL
Unix,DOS,Power Shell Script
Performance Tuning & Optimization
Oracle Forms
Oracle Reports and XML Publisher Report
BPM Worklist
Oracle Workflow
Interfaces
Conversion
WebAdi
Oracle APEX
SQL Loader
Form personalization
MSCA Page Customization
Data Modeling & Database Design
Data Warehousing Concepts & Design
Tools :-
BPM Worklist
File-Based Data Import (FBDI) & ADF Desktop Integration (ADFDI)
BI Publisher, OTBI, Smart View,Oracle Reports 6i/ 10g (Reports), XML Publisher
Form Builder, Workflow Builder
Putty & WINSCP
Control M, Dollar Universe
JDeveloper
Serena Dimex - Version control tool
Kintana PPM –Migration Tool
HPQC & HPALM – Defect Control tool
Remedy Tool – Remedy tool, Service Now
Methods :-
Agile Methodologies
Business Areas :-
Banking
Insurance
Retail
Finance
Manufacturing
Company
TATA CONSULTANCY SERVICES
Aug 2010 - Present
Certification
1Z0-520 Oracle EBS R12.1 Purchasing Essentials
Profile Snapshot
- Over 15+ years of diversified IT experience in Analysis, Design, Development, Testing and Implementation of business application systems for Banking, Insurance, Retail, Finance, Manufacturing sectors.
- Strong hands on experience with Oracle Applications mainly Oracle Fusion Financial/ P2P Cloud and EBS R11/11i/R12.2.3 implementation, upgrade, Rollout and Production support in Procure to Pay (i - Procurement, PO/AP/INV/ EB-tax), Order to Cash (OM/INV/AR), Financials (AP/AR/GL /FA), i-Expense.
- Led end-to-end functional implementation and configuration of Oracle Fusion Cloud Payables and Fixed Assets modules.
- Configured user roles and data access controls using Oracle Fusion Security Console.
- Designed, implemented and supported BPM Worklist approval rules for Invoice Approval, Payment Approval and Intercompany transaction workflows in Oracle Fusion.
- Worked on integration of Oracle Fusion Cloud modules using File-Based Data Import (FBDI) and ADFDI templates; supported integrations through Oracle Integration Cloud (OIC).
- Experience in developing and customizing reports using BI Publisher, OTBI, and Smart View.
- Technically proficient in RICEW components (Reports, Interfaces, Conversions, Forms, Workflows) and PLSQL.
- Experience in ETL, data transformation, conversion & interface.
- Involved in performance tuning, database monitoring and SQL tuning (Analyze, Explain plan, TKPROF), Hints, table partitioning and Indexes.
- Extensively involved in creating, scripting, scheduling, monitoring, and troubleshooting batch jobs using Control-M and Dollar Universe.
- Hands on experience in Unix Shell Scripting, DOS Scripting and Power Shell Scripting.
- Executed end-to-end Oracle Fusion implementations including requirement gathering, gap analysis, solution design, configuration, UAT, data migration, training, and production support, with hands-on experience in AIM documentation (BR010, MD50, TE20, CV40, etc.).
- Leveraged strong analytical and communication skills to manage daily production support, resolve complex issues, and coordinate with business owners, users and service teams for effective problem resolution.
- Raised and managed Oracle Service Requests (SRs), coordinated with Oracle Support, and conducted Oracle Web Conference (OWC) sessions for issue resolution and system improvements.
Timeline
Oracle Fusion Functional Consultant
SAB Oracle Finance Implementation Project
01.2024 - Current
Oracle Technical Consultant
Royal London Group, UK
06.2019 - 09.2023
Oracle EBS Technical Consultant
Ingersoll Rand -IR
12.2013 - 03.2019
Developer
JP Morgan Chase -JPMC
02.2013 - 12.2013
Developer
Ingersoll Rand - IR
04.2012 - 02.2013
Developer
MAXAM
04.2011 - 11.2011
Developer
Johnson & Johnson
01.2011 - 03.2011
+2 - Science
10th - All subjects
B Tech - Computer Science
SOA University