profile-pic
Vetted Talent

Anirudha Dustakar

Vetted Talent

As an Oracle EBS Techno-Functional Consultant with 3.5 years of experience, I specialize in PL/SQL and Oracle Development across domains such as Healthcare and Appliances. I have expertise in the SDLC for client implementations, covering requirements gathering, design, development, testing, technical documentation, delivery/migration, and support.

  • Role

    Oracle Techno-Functional Consultant

  • Years of Experience

    3.6 years

Skillsets

  • Implementation - 3.5 Years
  • Global trade management suite
  • Oracle apps r12
  • Oracle E-Business Suite
  • Oracle SQL
  • Windows 10
  • Windows 11

Vetted For

8Skills
  • Roles & Skills
  • Results
  • Details
  • icon-skill_image
    Oracle ERP Functional Analyst - Finance(Remote)AI Screening
  • 64%
    icon-arrow-down
  • Skills assessed :asian client, Business Analysis, Customization, Data Migration, Finance Module, Oracle ERP E-Business Suit 12.2, Problem Solving Attitude, SQL
  • Score: 32/50

Professional Summary

3.6Years
  • Dec, 2023 - Present2 yr 6 months

    Oracle Techno-Functional Consultant

    Tata Consultancy Services LTD.
  • May, 2023 - Dec, 2023 7 months

    Oracle Techno-Functional Consultant

    Tata Consultancy Services LTD.
  • Dec, 2021 - May, 20231 yr 5 months

    Oracle Techno-Functional Consultant

    Tata Consultancy Services LTD.
  • Aug, 2021 - Dec, 2021 4 months

    Oracle Analyst

    Tata Consultancy Services LTD.

Applications & Tools Known

  • icon-tool

    Oracle SQL Developer

  • icon-tool

    PuTTY

  • icon-tool

    WinSCP

  • icon-tool

    HP-ALM

  • icon-tool

    Smartsheet

  • icon-tool

    GitHub

Work History

3.6Years

Oracle Techno-Functional Consultant

Tata Consultancy Services LTD.
Dec, 2023 - Present2 yr 6 months
    Conducted end-to-end testing for various types of international and domestic orders. Prepared Standard Operating Procedures (SOPs) for all types of scenarios. Utilized standard, KIT, PTO, ATO, partial, and complete items configurations for testing purposes. Regularly checked if orders had reached the Global Trade Management (GTM) system. Developed a concurrent program using SQL Queries for the automatic booking of sales orders. Performed sanity testing of the Procure-to-Pay (P2P) and Order-to-Cash (O2C) cycles in the Oracle EBS frontend on OM, INV, PO & AR Modules. Created test scripts for various user stories for Conference Room Pilot (CRP), System Integration Testing (SIT), and User Acceptance Testing (UAT). Successfully executed various user stories in the Oracle EBS applications frontend during CRP sessions. Managed the migration of setups across various environments using GitHub. Performed data conversion for modules such as Open Accounts Receivable (AR), Item Cost, and Sub-inventory using Web ADI. Successfully deployed all test scripts in HP Application Lifecycle Management (ALM) for informal as well as General Ledger (GL) production testing. Developed a concurrent program for automatic booking of sales orders. Managing Service Now incidents involve performing both functional and technical analyses to identify the root cause and provide solutions to users.

Oracle Techno-Functional Consultant

Tata Consultancy Services LTD.
May, 2023 - Dec, 2023 7 months
    Conducted sanity testing of the Procure-to-Pay (P2P) and Order-to-Cash (O2C) cycles in the Oracle EBS frontend. Developed test scripts for various Supply Chain Management (SCM) user stories for Conference Room Pilot (CRP), System Integration Testing (SIT), and User Acceptance Testing (UAT). Successfully executed multiple user stories in Oracle EBS applications during CRP, SIT, and UAT sessions. Created BR100 documents for the Order Management (OM), Inventory (INV), and Accounts Receivable (AR) modules. Generated Daily Aged Orders and Weekly Order reports. Regularly performed SCALE query checks.

Oracle Techno-Functional Consultant

Tata Consultancy Services LTD.
Dec, 2021 - May, 20231 yr 5 months
    Created functional setups such as Descriptive Flex fields (DFF), Value Sets, Lookups, User-Defined Attributes (UDA), Pricelists, and Items. Performed sanity testing of the Procure-to-Pay (P2P) and Order-to-Cash (O2C) cycles in the Oracle EBS frontend. Created test scripts for various finance and Supply Chain Management (SCM) user stories for Conference Room Pilot (CRP) and System Integration Testing (SIT). Successfully executed various user stories in the Oracle EBS applications frontend during CRP sessions. Designed Inventory (INV) components for the INV interface (both Inbound and Outbound) and Min-Max Planning, and documented them as MD60. Developed pseudocode for various project components and documented them as MD60. Created an APEX form for error handling by business users. Developed ISG packages for loading custom staging tables. Developed custom packages, PL/SQL stored procedures, and functions for validation, necessary operations, and loading interface tables. Created Oracle Forms for error handling using Oracle APEX builder. Experienced in using various Oracle standard APIs for loading Inventory (INV) and Order Management (OM) base tables from interface tables. Performed data conversion for modules such as Open Accounts Receivable (AR), Item Cost, and Sub-inventory using Web ADI. Created BR100 documents for the Order Management (OM), Inventory (INV), and Accounts Receivable (AR) modules. Experienced in raising and closing GE-IT ServiceNow change requests and incidents for project requirements.

Oracle Analyst

Tata Consultancy Services LTD.
Aug, 2021 - Dec, 2021 4 months
    Conducted end-to-end testing for user creation in Payroll and HR modules. Analysed and tested user profile options and configured elements for time and labour data entry. Implemented names and sets utilizing the OTL Cycle.

Achievements

  • Received appreciation and on-the-spot awards for timely delivery and successful Go-Live activities.
  • Secured 1st prize in the College Level Basketball Competition at D.Y. Patil Polytechnic, Pune (2016-17).

Major Projects

4Projects

GE Healthcare (Global Trade Management)

Dec, 2023 - Present2 yr 6 months
    Conducted end-to-end testing for various types of international and domestic orders. Prepared Standard Operating Procedures (SOPs) for all types of scenarios. Utilized standard, KIT, PTO, ATO, partial, and complete items configurations for testing purposes. Regularly checked if orders had reached the Global Trade Management (GTM) system. Developed a concurrent program using SQL Queries for the automatic booking of sales orders. Performed sanity testing of the Procure-to-Pay (P2P) and Order-to-Cash (O2C) cycles in the Oracle EBS frontend on OM, INV, PO & AR Modules. Created test scripts for various user stories for Conference Room Pilot (CRP), System Integration Testing (SIT), and User Acceptance Testing (UAT). Successfully executed various user stories in the Oracle EBS applications frontend during CRP sessions. Managed the migration of setups across various environments using GitHub. Performed data conversion for modules such as Open Accounts Receivable (AR), Item Cost, and Sub-inventory using Web ADI. Successfully deployed all test scripts in HP Application Lifecycle Management (ALM) for informal as well as General Ledger (GL) production testing. Developed a concurrent program for automatic booking of sales orders. Managing Service Now incidents involves performing both functional and technical analyses to identify the root cause and provide solutions to users.

GE Appliances (Bailing Water Project)

May, 2023 - Dec, 2023 7 months
    Conducted sanity testing of the Procure-to-Pay (P2P) and Order-to-Cash (O2C) cycles in the Oracle EBS frontend. Developed test scripts for various Supply Chain Management (SCM) user stories for Conference Room Pilot (CRP), System Integration Testing (SIT), and User Acceptance Testing (UAT). Successfully executed multiple user stories in Oracle EBS applications during CRP, SIT, and UAT sessions. Created BR100 documents for the Order Management (OM), Inventory (INV), and Accounts Receivable (AR) modules. Generated Daily Aged Orders and Weekly Order reports. Regularly performed SCALE query checks.

GE Appliances (Haier Company)

Dec, 2021 - May, 20231 yr 5 months
    Created functional setups such as Descriptive Flex fields (DFF), Value Sets, Lookups, User-Defined Attributes (UDA), Pricelists, and Items. Performed sanity testing of the Procure-to-Pay (P2P) and Order-to-Cash (O2C) cycles in the Oracle EBS frontend. Created test scripts for various finance and Supply Chain Management (SCM) user stories for Conference Room Pilot (CRP) and System Integration Testing (SIT). Successfully executed various user stories in the Oracle EBS applications frontend during CRP sessions. Designed Inventory (INV) components for the INV interface (both Inbound and Outbound) and Min-Max Planning, and documented them as MD60. Developed pseudocode for various project components and documented them as MD60. Created an APEX form for error handling by business users. Developed ISG packages for loading custom staging tables. Developed custom packages, PL/SQL stored procedures, and functions for validation, necessary operations, and loading interface tables. Created Oracle Forms for error handling using Oracle APEX builder. Experienced in using various Oracle standard APIs for loading Inventory (INV) and Order Management (OM) base tables from interface tables. Performed data conversion for modules such as Open Accounts Receivable (AR), Item Cost, and Sub-inventory using Web ADI. Created BR100 documents for the Order Management (OM), Inventory (INV), and Accounts Receivable (AR) modules. Experienced in raising and closing GE-IT ServiceNow change requests and incidents for project requirements.

GE Healthcare

Aug, 2021 - Dec, 2021 4 months
    Conducted end-to-end testing for user creation in Payroll and HR modules. Analyzed and tested user profile options and configured elements for time and labor data entry. Implemented names and sets utilizing the OTL Cycle.

Education

  • Bachelors of Engineering

    PCETS Nutan Maharashtra Institute of Engineering & Technology, Pune (2021)
  • Diploma

    D.Y. Patil Polytechnic, Pune (2018)
  • H.S.C

    Chate Junior College, Pune (2016)
  • Bachelors of Engineering

    PCET’S Nutan Maharashtra Institute of Engineering & Technology, Pune (2021)
  • S.S.C

    Raghavdas Vidyalaya, Pune (2014)

AI-interview Questions & Answers

Hello. My name is. Currently, I'm working in Tata Consultancy Services for the past 3.5 years. I have worked on a total of 4 projects, 2 implementations and 2 supports. That for the 2 implementations, my clients were Global Trade Management and higher appliances. And for the support, it was billing motor and ServiceNow. I have expertise in order to cash flow and procure to pay, in end-to-end testing, CRP site, and UAD phase. Also, I have designed and developed some concurrent programs for automatic sales order booking. Also, I have prepared user stories and test scripts and done the testing of them. My expertise models are order management, inventories, account payables, account receivables, WSH, and general. Also, in service for ServiceNow, I have worked on the ticketing tools like ServiceNow and Jira, as two separate tools. I have done incident management of both things. Also, I have done root cause analysis of major issues, high-priority issues, and provided solutions to the users.

No, I have experience in account payables, account receivables, and general ledgers. I have also done some mandatory configurations and setups for the Oracle two-party and two-party as well, all the invoice types, all the receivables and end-to-end stuff. Also, for the DFF and custom reports, I am well aware of it.

Yeah, I have done the development in order management model. I have done the development for the automatic sales order booking. However, in terms of account payables, account disables in general, I am good from the functional end. I have done the testing from pay to pay. In that, all the steps we have for the model, account payables and account receivable, I've done it. Also, I've set up the DFF, KFF as well.

Yes, in my experience with Oracle, ABC artwork, yes. I have, I will walk you through the order to cash flow, prepare to pay flow. In the order to cash flow, first of all, order booking is done. So order creation, then order booking, then order scheduling. In order scheduling, we have to check the item online quantities as well, item categories, and item inventory. After that, we come to the shipping model. In that, we have to do the pick release, then we have to do the unpacking of the item, and after that, shipping. Okay. Then we source the item from the WMS up to the air transport. The AR model, through the interface program that is the RA interface line. So also, we used to run two programs for sourcing the data. First, we used to work on a background process, and then we used to run the auto invoice import program. Once the data comes to the AR model, then the invoice generation is there. Once the invoice generation is there, after that, we send the invoice to the customer, and then the customer does the payment. And once we receive the payment from the customer, then we provide the receipt to the customer. And once the receipt is provided, we do the entries of that in our general ledger accountings. And also, the mandatory setups for the order to cash flow, transaction types, customer sales persons. Okay. Defining items, defining price lists, shipping rates. Okay. Adding pricing and advanced pricing. Okay. Types of costs inside, then setup. All that stuff. Yeah.

Yeah. First of all, what techniques would you apply to identify and mitigate risks during a major? First of all, I would check that no orders are pending. During the flow, all orders are closed. Okay. If some orders are pending, then I would work on that, and I would close them. During the system update, I would majorly check that all properly coded changes have been migrated to the front end from the back end. If it has not been deployed, then it will take more time to update. So I would majorly check on that.