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.60 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.60Years
  • Dec, 2023 - Present1 yr 9 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.60Years

Oracle Techno-Functional Consultant

Tata Consultancy Services LTD.
Dec, 2023 - Present1 yr 9 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 - Present1 yr 9 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 from past 3.5 years. I have in my tenure, I have worked on total 4 projects, 2 implementations and 2 supports. Uh, that for the 2 implementation, my my clients were g Global Trade Management and g higher appliances. And for the support, g billing motor and g ServiceNow. Uh, I have done, uh, it's I I'm expertise in order to cash flow and procure to procure to pay in my end to end, uh, testing CRP site and UAD phase. Also, I have designed and developed, uh, some concurrent program for the auto in, uh, for automatic sales order booking. Also, I have prepared the user stories and test scripts and done the testing of it. My expertise models are order management, inventories, uh, account payables, account receivables, WSH, and general. Also, in, uh, service for the ServiceNow, I have, uh, worked on the ticketing tools like, ServiceNow and the Jira, uh, as l two support. I have done the incident management of the l two things, all the stuff. Also, I have done some good cause analysis of the major issues, high priority issues, and, uh, provided solution to the users.

Uh, no. Uh, I have, uh, some of the experience in account payables, account receivables, and general ledgers. Also, I have, uh, done some mandatory configurations and setups for the o two c p two p as well, all the invoices types, all that receivables and end to end stuff. Also, for the DFF and custom reports, I'm well aware aware of it.

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

Uh, yes. Uh, in, uh, experience with Oracle, uh, ABC artwork, uh, yes. I have I will walk you through the order to cash flow, prepare to pay flow. In the order to cash, first of all, order booking is done. So order creation, then order booking, then order scheduling. In the order scheduling, the we have to check the item online quantities as well, item, uh, categories, and item inventory. Uh, after that, we come to the shipping model. In that, we have to done the pick release, then we have to do the unpacking of the item, and after that, the shipping. Okay. Then we used to source the item from, uh, the WSS up to the air air no. Uh, AR model, uh, through the interface program that is the RA interface line. So also, we used to run, uh, 2 programs for the sourcing the data. Uh, first of all, we used to work for background process, and then we used to run auto invoice import program. Uh, once the data comes to the AR model, then the invoice generation is there. Once the invoice generation is there, after that, um, we send the invoice to the customer, then invoice then the customer does the payment. And once the once we receive the payment from the customer, uh, then we, uh, provide the receipt to the customer. And once the receipt is provided, we, uh, we and we do the entries of that in our general agents account accountings. And, also, the mandatory setups, uh, sorry, mandatory setups for the order to cash flow, transaction types, customer sales persons. Okay. Defining items, define price list, uh, shipping grants. Okay. Uh, add pricing and advanced pricing. Okay. Types of cost inside then setup. All that stuff. Yeah.

Yeah. First of all, uh, what techniques would you apply to identify and mitigate risks during a major? Yeah. Uh, first of all, I will check that no orders are pending. Uh, there during the, uh, flow means this all all orders are closed. Okay. If some orders are pending, then I will work on that, and I will close that. Uh, and during the system update, uh, majorly, I will check that, uh, from the back end that all the properly code has been migrated to the front end or not. Means has been deployed to it in it. So if if if it is not deployed, then it will be take more time to update. So I will majorly check on that.