Vijayendra G
Bangalore
Summary
Seasoned Oracle Apps Techno-Functional Consultant with over 17 years of experience in ERP implementations and support, specializing in Oracle E-Business Suite across diverse industries. Demonstrated expertise in database management and project leadership, significantly enhancing operational efficiencies at LTIMindtree Ltd. Skilled in fostering innovative solutions and managing large teams to deliver projects successfully, showcasing exceptional technical acumen and collaborative prowess.
Overview
18
18
years of professional experience
1
1
Certification
Work History
LTIMindtree Ltd
Bangalore
10.2022 - Current
- Environment : Oracle Applications R12.2.6, OM, INV, PO, AR, AP, PL/SQL, Oracle 10g, TOAD, Discoverer, Forms, Reports, UNIX, XML Publisher, J Developer, JAVA, and workflow builder, ACMP, Service Now, Dell Boomi, Oracle Apex, Jagger etc
- Team Size : 35, Terex is a global manufacturer of materials processing machinery and aerial work platforms
- Terex design, build and support products used in construction, maintenance, manufacturing, energy, recycling, minerals, and materials management applications
- Roles:
- Extensively worked for ‘Terex simplicity’ roll out project
- Part of ‘simplicity’ Project extensively worked on Supplier conversions
- Part of ‘simplicity’ Project extensively worked on Customer conversions
- Extensively worked for reports enhancements for Simplicity project
- Extensively worked Order Managements, account payable, account receivable conversions for simplicity project
- Worked on ‘item master’ and ‘item on hand’ conversion for Simplicity project
- Worked for ‘OM’ workflow enhancements for simplicity project
- Worked for OSM-TMS integration project and extensively supported OSM integration related issues
- Developed new integration ‘OSM-TMSAR’ integrations to create a ‘Account Receivable’ invoice in TMS from OSM via OIC
- Worked on OAF Development, personalization, and extensions
- Prepared all required Detailed design documents, technical design documents and deployments documents for the project
- Worked
- Worked on account receivable interface from OSM system
- Worked and support account payable workflow process and issues
- Supported finance support issues
Oracle apps Techno functional Consultant
LTIMindtree Ltd
Bangalore
03.2022 - Current
- Having 17+ years of total IT experience in Oracle Apps implementation and support engaged in technical development and functional support areas of Oracle Applications 11i and R12 E-Business Suite.
Team lead
LTIMindtree Ltd
Bangalore
03.2022 - 09.2022
- Environment : Oracle Applications R12.1.3, OM, INV, PO, AR, PL/SQL, Oracle 10g, TOAD, Discoverer, Forms, Reports, UNIX, XML Publisher, J Developer, JAVA, and workflow builder, ACMP, Service Now, Dell Boomi, Oracle Apex, and Jagger etc
- Team Size : 35
- Role :, Digitalize the Mechanical and Electrical Buyout Sourcing process
- The solution will take care Business needs to take of the current Process
- Roles:
- Extensively involved in designing the process
- Extensively worked on oracle APEX to Build Dashboard application
- A tailored APEX dashboard builds for Supplier quotation analysis
- Automated the RFQ to Quote and Quote to Requisition creation process
- Build RFQ Analysis Dashboard to display end to end details for the Mechanical buy out process
- Prepared all required Detailed design documents, technical design documents and deployments documents for the project
- Extensively worked on Electrical buy out process to Automate
Oracle apps Techno functional Consultant
Infosys Ltd
Bangalore
11.2021 - 03.2022
Team lead
Global Foundries, GLOBALFOUNDRIES
Bangalore
07.2015 - 03.2022
- Environment : Oracle Applications R12.1.3, OM, INV, PO, AR, PL/SQL, Oracle 10g, TOAD, Discoverer, Forms, Reports, UNIX, XML Publisher, J Developer, JAVA, and workflow builder, ACMP, Service Now, Dell Boomi, Oracle Apex, and Jagger etc
- Team Size : 35
- Role :, , the world's first full-service semiconductor foundry with a truly global manufacturing and technology footprint, is executing its vision to reshape the semiconductor industry through collaboration and innovation
- Roles:
- Extensively working oracle mobile application (MSCA) to enhance existing mobile logistic process
- Extensively Worked on OAF Development and supports Activities
- Worked on PO approval workflow enhancements.
- Supporting many interfaces as GF EBS system is communicating many other third-party systems
- Customized ‘invoice print’ report based on the user requirement
- Worked on Dell Boomi integration projects
- Worked on Custom misc
- Form changes as this form are extensively used in GLOBALFOUNDRIES for logistic process
- Extensively working on form personalization to implement business rules by using CUSTOM.pll and application-level personalization
- Supporting various SCM Production (INV, OM, and PO) support issues
- Closely interacting with end users and providing solutions for various live issues
- Extensively working oracle workflow customization, enhancement and supports
- Working on enhancement and development of customized objects
- Developed many OAF pages for EHS logistic process
- Developed and supported ‘on hand’ and ‘item master’ conversion programs as part SDA project
- Developed and Enhanced BI publishers reports as per the business requirements
- Extensively worked ASN OAF Page Enhancements
- Involved in SCR project to build end to end P2P process for GF With Apex user interface
- Worked on Chemix project to users to select Chemical combination using Apex user interface
- Worked on ‘Sample PO type’ end to end enhancement process for GF
- Worked on AWSS roll out project for Dresden operation
- Worked on ‘On semi’ projects to Automate the materials stock detail to accessible servers
- Proactively worked on incidents and prod issues and helped functional people if they needed any information about issues
- Worked on Jagar P2P system integration with Oracle EBS for Supplier creation and p2p process
- Extensively worked on P2P logistic enhancements and incidents for various existing applications
Oracle apps Techno functional Consultant
Worked Global Foundries
Bangalore
07.2015 - 10.2015
Oracle apps Technical Consultant
SIIX Corporation
10.2014 - 05.2015
Technical consultant
SIIX Corporation, SIIX Singapore
10.2014 - 04.2015
- 3, OM, INV, PO, AR, PL/SQL, Oracle 10g, TOAD, Discoverer, Forms, Reports, UNIX, XML Publisher, workflow builder Developer
- Team Size : 10
- Role :, SIIX is a unique global company that responds to various outsourcing needs in manufacturing from the “global procurement” which is the biggest challenge for global manufacturing to “logistics” and “Electronics Manufacturing Services (EMS)”
- SIIX is a company that cannot be pinned down to a particular line of business
- Roles:
- Working on the development of Interfaces, Data Conversions, developing new Forms, Reports, Customizing Oracle Reports in Order to Cash, Procure to Pay Cycles touching various modules such
- Customized ‘PO Auto Create’ form to select multiple requisition lines automatically for PO creation
- Worked OAF Pages personalization’s and extensions based on user requirement
- Worked on CO extension for adding dynamic lov based on List of Stores in I Procurement page
- Worked on VO extension in Employee Self Service page based on responsibility level
- Customized ‘invoice print’ report based on the user requirement
- Developed new forms and reports for WMS Application
- Extensively working on form personalization for current assignment
- Extensively working on CUSTOM.pll to implement various business validations in the application
- Supported interfaces related to production issues
- Supported Minor enhancement for SCM setup related changes
- Extensively working on RICE Components enhancement and support
- Documented and maintained all technical design documents as per AIMS methodology
Team lead
PACE plc
06.2012 - 09.2014
- Organization : NTTDATA Global delivery services
- Environment : Oracle Applications R12.1.3, OM, INV, PO, AR, PL/SQL, Oracle 10g, TOAD, Discoverer, Workflow, Forms, Reports, UNIX, XMLPublisher, Discoverer
- Team Size : 15
- Role :, Pace is a leading technology solutions provider to the Pay TV and broadband service industries
- Pace solutions empower customers to innovate at the speed simply and cost-effectively they want and in the way they want, enabling them to build their success
- Pace’s thirty years of leadership, experience and expertise is recognized by a customer base that spans the globe
- Roles
- Worked on the development of Interfaces, Data Conversions, developing new Forms, Reports, Customizing Oracle Reports in Order to Cash, Procure to Pay Cycles touching various modules such as INV, OM, SHIPPING, PO, AR and AP
- Developed new forms and customized existing forms according to the client’s requirements
- Validated Custom Scripts in 11i and made the changes in R12 standard script
- Register generated reports, forms, Flex fields
- Defined Descriptive Flex fields, value sets and also registered PL/SQL stored procedures, SQL
- Plus scripts etc
- Design and development of several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development
- Simulating and analysing the CEMELI objects issues
- This usually involves a code walkthrough of Interfaces, Reports, Host Programs and SQL Scripts
- Worked with CUSTOM.pll to implement business validations on Application forms
- Developed supplier spend form
- Developed purchase order quantity outstanding form
- Developed and modified customized reports based on the customer request
- Customized Bom inventory components report which will give out put in CSV format
- Worked on customizations of ‘invoice print’ report as per customer request
- Customized BPA Extract report to get the output in CSV format
- Supported workflow related issue and changes as per the customer request
- Developed Inventory stock ageing report
- Supporting interfaces related to various customization and business flow as part of support Activities
- Supporting discoverer related issues
- Developed ‘price list interface’ program which will upload new price list information into oracle system
- Creating and handling Oracle Meta link Service Request and Appling the fixes to the instance as per the Solution provided in SR
- Registration of concurrent programs, creating values and value sets and look ups in AOL and moving to live instance using FND LOAD
- Defining or Modifying Responsibilities, Menus, Functions, Request Groups, Reports, Concurrent Requests, Request Sets and Procedures
- Design and development of several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development
- Developed various complex SCM SQL extracts which helped business uses to audit daily transaction flows
Oracle apps Technical Consultant
NTTDATA
Bangalore
01.2011 - 09.2014
Team member
Oracle India, Agilent Technologies
01.2011 - 03.2012
- Ltd
- Environment : Oracle Applications 11.5.10, R12, OM, INV, PO, AR, PL/SQL, TOAD, OVSD tool TOAD, Discoverer, Forms, Reports, UNIX, XML Publisher, Discoverer, Workflow Developer
- Team Size : 25
- Role :, Manufacturer of a wide range of analytical instrumentation
- Agilent has a complex structure and live data flow between SAP, Seibel and Oracle
- Agilent Technology is a support and re implementation from 11i to R12with SCM, Finance, Planning, OICP and System Admin modules
- The support includes developing new objects, consultancy, query resolution, customization, setup configuration and testing and issue resolution
- Roles
- As a senior Oracle Apps Technical consultant my primary job function was to responsible for SCM module extensions (RICE/CEMLI) objects and conversions from 11i to R12 part of R12 re-implementation (Financial, Procure to Pay(P2P), Order to Cash (O2C), Supply Chain modules
- As part of R12 re-implementation, Developed various conversion processes (Supplier, Customers, Item) from 11i systems to R12 system
- Validated Custom Scripts in 11i and made the changes in R12 standard script
- Developed various complex SCM SQL extracts which helped business uses to audit daily transaction flows
- Worked with CUSTOM.pll to implement business validation on Oracle forms
- Extensively worked with forms personalization to implement business validation
- Worked as a support analyst with in-depth knowledge of oracle E-biz suite modules (INV, OM, and PO)
- Involved in migration of Purchase order, Sales Order interfaces and Item interfaces objects from 11i to R12
- Supported interfaces related to various customization and business flow
- Supported Minor enhancement for SCM setup related changes
- Development of new objects related to business requirement
- Documented and Maintained MD50, MD70 technical documents as per AIMS methodology
- Well efficient to use Oracle API for updating or inserting Data into Oracle apps base tables
- Closely interacting with onsite coordinator in deriving the delivery dates of the components
- Simulating and analyzing the reported output display issues
- This usually involves code walkthroughs of Interfaces, Reports, Host Programs and SQL Scripts
- Resolved various Order process issues like shipping transaction is not completed, shipped but not invoiced struck in AR auto invoice
- Working closely with Oracle, Sysadmin & DBA teams for regular Patch Applications
- Action plans given by Oracle
- Generated the Debug file, trace file etc
- Coordinating with 3rd party teams to assist in troubleshooting/issue identification
- Arranged virtual meetings with the users and guided them to solve their issues
- Involved in monitoring and supporting scheduled jobs in the production environment
Team member
MindTree Ltd
08.2008 - 12.2010
- Oracle Applications 11.5.10, 9i, AR, OM, INV, BOM, PO, Advance pricing I Store, PL/SQL, TOAD, Forms, Reports, UNIX, XMLPublisher
- Team Size : 10
- Role :, Developed order summary report to extract order details
- Developed PO Interfaces to create purchase order in oracle based on the flat file
- Implemented Order inbound interface to create orders from external system
- Worked on item interface to import items to oracle application form legacy system
- Developed many custom reports using XML Publisher
- Worked upon the technical issues coming up time-to-time in the different modules of the Customizations in Inventory, Order Management and BOM modules, providing solutions to resolve them
- Developed and converted various rdf reports to BI Publisher
- Implemented forms personalization based on the customer requirement
- Extensively worked on CUSTOM
- Pll to implement business validation on application
- Developed Pace Sales Order History Extract Report to get order history details
- Developed ‘New Customers Report’ to extract new customer details
- Developed Stock Inventory Detail Report
- Developed ‘Deliveries Details Report’ to extract delivery details
- Preparation of User Manual Document, Concurrent setups document, Field mapping documents
- Worked with APIs related to create, update quote header and line information based on the configuration
- Worked with APIs related to available quantity (ATP), price list, order API’s
- Worked with the process order API for placing the order based on the quotation
- Role –, engineer responsible for analyzing requirements, data-structure, architecture of system, preparing interface mapping and technical specification documents, coding, testing and implementation in Apps environment
- Achievements: Certificate of Appreciation for EMSUPPORT Team
Oracle apps Technical Consultant
Mind Tree Ltd
Bangalore
11.2006 - 12.2010
- Oracle Applications module configuration and process use for modules including OM, PO , INV, BOM, AP , AR, AOL, HRMS System Administration
- Worked Extensively on RICEW objects
- Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC)
- Extensive experience in implementation, Migration, Customization, Production support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), Purchase Order (PO), Accounts Receivable (AR), BOM
- Has expertise on designing and implementing Oracle Alerts and Lookups
- Expertise in creation of migration scripts (LDT’s) and install instructions/migration documents (MD120) for all RICE/CEMLI objects
- Designed and developed various interfaces to import Orders, Bill of Material, Items to Oracle ERP
- Developed various BI/XML publisher reports as part modernizing the Payment process in R12
- Re-designed and developed all (CEMLI/RICE) objects in R12 from 11i
- Expertise in converting RDF reports to BI Publishers reports in R12 using XML Publishers converter utility
- Expertise in mobile supply chain application (MSCA/mwa) Development and enhancement for logistic process
- Well versed with Oracle OAF Development, Personalization/Extensions, and customizations
- Good working knowledge on Track production support issues
Team member
MindTree Ltd
11.2007 - 07.2008
- Requirement gathering
- Developing procedures, functions, packages
- Creation of Test Plans and testing
- Developed Test Cases, Test Procedures and Test Scripts
- Performed Functional and Integration Testing
- Participated in Audit
- Developed reports based on customer requirements
- User acceptance testing
- Deployment in production environment
- Modules Developed BOM Exploded View Component Where Used Base Key Search Extended, Achievements: - Certificate of Appreciation for EMR Customer Access to Oracle BOM
Team member
MindTree Ltd
11.2006 - 10.2007
- Oracle Applications 11I (, Requirement gathering
- Developing procedures, functions, packages
- Worked with APIs related to creation of Customer, Location, Account, Account Site, Account Site Use codes
- Worked on the Auto Invoicing process for importing Sales Order information from Legacy system into Oracle Apps system using the Auto Invoice API
- Worked with DBMS Change Notification feature of Oracle 10g to get notifications upon Payments received on Invoices related to the AR_PAYMENT_SCHEDULES_ALL table
- Invoice interface- Load the invoice transactions into account receivables Base Tables Through the invoice Import Program from the Legacy Data
- Involved in developing Customer interface –for adding the new customer information to Oracle AR
- Preparation of SQL Loader scripts
- Involved in customizing and Developing the Reports and Conversions
- Developed Test Cases, Test Procedures and Test Scripts
- Performed Functional and Integration Testing
- Involved in Client meetings.
Terex Corporation
Education
Master of Science - Electrical Engineering
V T U
Belgaum11-2006
Skills
- ERP
- Databases
- Languages
- Tools
- GUI
- Operating Systems
- Project management
Certification
- Oracle Certified Professional, E-business suite –R12 Essential for Implementers
- GATE, 2004, 93
Timeline
LTIMindtree Ltd
10.2022 - Current
Oracle apps Techno functional Consultant
LTIMindtree Ltd
03.2022 - Current
Team lead
LTIMindtree Ltd
03.2022 - 09.2022
Oracle apps Techno functional Consultant
Infosys Ltd
11.2021 - 03.2022
Team lead
Global Foundries, GLOBALFOUNDRIES
07.2015 - 03.2022
Oracle apps Techno functional Consultant
Worked Global Foundries
07.2015 - 10.2015
Oracle apps Technical Consultant
SIIX Corporation
10.2014 - 05.2015
Technical consultant
SIIX Corporation, SIIX Singapore
10.2014 - 04.2015
Team lead
PACE plc
06.2012 - 09.2014
Oracle apps Technical Consultant
NTTDATA
01.2011 - 09.2014
Team member
Oracle India, Agilent Technologies
01.2011 - 03.2012
Team member
MindTree Ltd
08.2008 - 12.2010
Team member
MindTree Ltd
11.2007 - 07.2008
Oracle apps Technical Consultant
Mind Tree Ltd
11.2006 - 12.2010
Team member
MindTree Ltd
11.2006 - 10.2007
Terex Corporation
Master of Science - Electrical Engineering
V T U
Similar Profiles
Saranya SelvarajSaranya Selvaraj
Specialist- Workforce Management at LTIMindtree LtdSpecialist- Workforce Management at LTIMindtree Ltd
Jagadishchandrabose Jagadishchandrabose null
Module Lead at LTIMindtree LtdModule Lead at LTIMindtree Ltd
Aruna Arumugam VanniarAruna Arumugam Vanniar
Senior Specialist - Leadership Hiring at LTIMindtree LtdSenior Specialist - Leadership Hiring at LTIMindtree Ltd