profile-pic

Anirudha Dustakar

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

  • Process Improvement - 3 Years
  • Implementation - 3.5 Years
  • Data Integration - 3 Years
  • System Analyst - 3.5 Years
  • Optimization - 3.5 Years
  • Oracle ERP - 3.5 Years
  • Oracle EBS R12 - 3.5 Years
  • Finance Module - 3.5 Years
  • Global trade management suite
  • Oracle apps r12
  • Oracle e-business suite
  • Oracle SQL
  • PL/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 4 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 4 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 4 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)