Now you can Instantly Chat with Indrajeet!
About Me
About 14+ years of progressive experience in implementing and maintaining (Technical and Functional) Oracle eBS (Oracle E-Business Suite 11i/R12) and Oracle Cloud (R12) technology as Techno Functional consultant. Involved in full life cycle implement...
Show MoreSkills
Portfolio Projects
Description
Implementations and support in Oracle Cloud (R12) procurement and cloud inventory and Finance. Responsibilities: Analysed the business processes, designed functional specifications, and mapped these specifications to the Oracle Cloud Application. Interacting with Oracle Middleware team for resolving interface related issues. Opening SR and bringing them to closure by following up with Oracle SR team. Prepared Design Documents and unit test scripts. Coordinate with business user for requirement gathering and prepare functional document and technical document. Developed Custom OBIEE Dashboard and subject area.
Show More Show LessDescription
Enhancement and support in modules OM, PO, AR, AP, GL and 3rd party tools. Responsibilities: Functional / Technical design in the modules of OM, PO and AP. Responsible for supporting all standard and customized OM flows Responsible for support enhancement activities Opening SR and bringing them to closure by following up with Oracle SR team. Analyzed the business processes, designed functional specifications, and mapped these specifications to the Oracle Applications. Prepared Design Documents and unit test scripts (TE020) for the custom components. Coordinate with business user for requirement gathering and prepare functional document and technical document. Developed interface scripts in i-Expense module. Migration of objects from UAT to Production. Coordinated with Technical team and DBAs during Quarter releases for Production issues. Raising SR and provide a close observation for those SR
Show More Show LessDescription
R12 Upgrade and enhancements includes the modules INV, PO, OM, AR, BOM, WIP Advance Pricing and Shipping Execution. Responsibilities: Leading two teams on Onsite-offshore Global Business model. Functional and Technical design in the modules of AR, INV, OM and Shipping Execution. Analyzed the business processes, designed functional specifications, and mapped these specifications to the Oracle Applications. Understanding the current Business Process and preparation of As-Is documentation. Designing of To-Be process and Identification of Gaps. Prepared Functional Design (MD050), Technical Design (MD070) Documents and unit test scripts (TE020) for the custom components. Functional/Technical Support to critical interfaces in Production for Order-to Cash, Procure to Pay processes. Coordinate with business user for requirement gathering and prepare functional document and technical document. Post GO LIVE support in the area of INV, BOM, AR and OM. Developed interface scripts in AR, OM and CRM Field Services. Migration of objects from UAT to Production. Responsible for Configuration/Setup, testing and support of all the above mentioned modules. Managed functional/technical design, development, unit and system testing for key custom components. Closely monitor the unit testing and resolved the complex issue raised by client during this enhancement Understanding to use HP Quality Center.
Show More Show LessDescription
Implementation and phase wise rollout of Oracle Apps 12.0.1. Implementation includes the Oracle Apps modules INV, OM, BOM, WMS, WIP, AR and GL. Responsibilities: Functional design in the modules of INV ,OM , Advance Pricing and Shipping execution. Gathered business requirements, analyzed the business processes, designed functional specifications, and mapped these specifications to the Oracle Applications. Prepared Functional Design Documents (MD050), Mapping documents (CV040) and unit test scripts (TE020) for the custom components. Coordinate with business user for requirement gathering and prepare functional document. Post GO LIVE support in the area of INV, BOM, WIP and OM. Maintaining the issue tracker for CR and defects and support technical and functional issues. Migration of objects from UAT to Production. Developed interface and conversion scripts. Developing training documents for developers and Business users Testing the new developed components and custom objects as per the business need. (TE- 50). Creation of Modifiers, qualifiers etc. Lead the technical consultants for coding and developing the reports to meet the requirements Played major role in managing and resolving tickets raised in ticketing tool. Resolved short term and long term issues in Oracle SCM Modules. Raised SR in metalink and provided a close observation for them Actively involved in training to client on Oracle SCM Modules SETUP Inventory – Define Organization Structure(Business Groups, Operating Units, Inventory Organization, Subinventory, Locations), Key Flex fields, Descriptive Flex fields, Shipping Networks, Transaction Types( Miscellaneous, Subinventory transfer, Inter-Org, Direct Transfer, Move Orders), Item Category Setup(Item Category Sets, Default Category sets, Item category flex field), Defining Items (Master level & Org level), Status attributes, Attribute Controls, Receiving options etc. Order Management – Customers, Order Types setup, Price List setup, Defaulting Rules, System Parameters, O2C cycles(Drop ship, Back –to – Back, IR –ISO, Standard Order cycle, RMA), Interface Third Party Orders(SFDC) to OM, orders Pick Release, ship confirm Advance Pricing – Profile option setup for enabling in Purchasing and OM, Modifier-Qualifier setup, Price Lists
Show More Show LessDescription
Gilead Sciences, Inc. is a research-based biopharmaceutical company that discovers, develops and commercializes innovative medicines in areas of unmet need. With each new discovery and experimental drug candidate, we seek to improve the care of patients suffering from life- threatening diseases. Responsibilities: Requirement gathering, Client clarifications, Technical & Functional design review with onsite team. Write MD70 documents of various objects assigned to me. Developed conversions scripts. Developing training documents for developers and Business users. Migration of objects from UAT to Production and Go-Live.
Show More Show LessDescription
Vaisala is a global leader in environmental and industrial measurement. Building on more than 70 years of experience, Vaisala contributes to a better quality of life by providing a comprehensive range of innovative observation and measurement products and services for meteorology, weather critical operations and controlled environments. Headquartered in Finland, the company employs over 1200 professionals worldwide and is listed on the NASDAQ OMX Helsinki. The Project involves implementation in Oracle R12. Have done conversion and interface as per client requirement. Responsibilities: Registration Custom object in oracle applications. Worked on RICE components across various modules of Oracle Apps eBS. Creation of PL/SQL functions, Procedures and Packages. Development of conversions. Developed Customer Conversion. Developed Installed Base Conversion. Developed Supplier Conversion. Developed on Item conversion. Developed Item Category conversion. Preparation of technical documents. Creation of migration documents. Creating Business Group Locations. Create a Business Group and assign the location and KFFs created above to it. Add organization classifications.
Show More Show LessDescription
The client is an independent government agency that manages the beverage alcohol industry in Pennsylvania. It is responsible for licensing the possession, sale, storage, transportation, importation and manufacture of wine, spirits and malt or brewed beverages in the Commonwealth, as well as operating a system of liquor distribution (retailing) and providing education about the harmful effects of alcohol consumption. Project involves development of various conversions, interfaces and form development. The Project involves implementation in Oracle R12. I have done development of conversion and interface as per client requirement. Responsibilities: Preparation of technical documents. Worked on Interface include: HRMS Inbound Interface Creation of PL/SQL functions, Procedures and Packages. Creation of migration documents. Development of eBS conversions.
Show More Show LessDescription
The Project involves enhancement of Oracle Financials modules of Oracle Applications 11i (AP, AR, GL).In these modules I have done enhancement of the report and developed some report as per client requirement .Most of the report done in XML Publisher. Responsibilities: Registration Custom object in oracle applications. Creation of PL/SQL functions, Procedures and Packages. Customized 4Bucket & 7 Bucket report. Customized customer details report. Developed Direct Debit Reports. Worked on Lockbox Interface. Developed Supplier interface. Developed AP invoice Interface. Developed Customer Open Balance Letter for multiple countries. Developed Supplier details report in XML Publisher report. Developed Project Task loader conversion through API. Developed Project Class loading interface through API.
Show More Show LessDescription
Client : Boars Head, Sarasota, FL
Role : Techno functional Consultant
Duration : April-16 – Oct-19
Implementation (R12.2.4) and enhancement in SCM (OM, INV, WMS), BOM, WIP and OBIEE 12c.
Responsibilities:
- Functional and Technical design in the modules of BOM, WIP and Shipping Execution and Picking execution.
- Imported Bills and Routings through BOM Interfaces.
- Understanding the current Business Process and preparation of As-Is documentation.
- Designing of To-Be process and Identification of Gaps.
- Prepared Functional Design (MD050), Technical Design (MD070) Documents for the custom components.
- Technical development and support to critical interfaces in Production in Order Management and Warehouse Management system.
- Coordinate with business user for requirement gathering and prepare functional document and technical document.
- Post GO LIVE support in the area of INV, OM, WMS.
- Developed new custom processes OM and WMS.
- Design custom form in MSCA.
- Prepared Design Documents and unit test scripts (TE020) for the custom components.
- Design and developed the integration process between third party tools with Oracle application using SOA 12c.
Designed and developed multiple complex subject area and dashboards
Show More Show LessDescription
Client : Adecco NA, NY
Role : Techno functional Consultant
Duration : May-15 – Apr-16
Implementations and support in Oracle Cloud (R12) procurement and cloud inventory and Finance
Responsibilities:
- Analysed the business processes, designed functional specifications, and mapped these specifications to the Oracle Cloud Application.
- Interacting with Oracle Middleware team for resolving interface related issues.
- Opening SR and bringing them to closure by following up with Oracle SR team.
- Prepared Design Documents and unit test scripts.
- Coordinate with business user for requirement gathering and prepare functional document and technical document.
- Developed Custom OBIEE Dashboard and subject area.
Description
Client : BMC, Houston, TX
Role : Techno functional Consultant
Duration : Nov-13 – Dec-14
Enhancement and support in modules OM, PO, AR, AP, GL and 3rd party tools.
Responsibilities:
- Functional / Technical design in the modules of OM, PO and AP.
- Responsible for supporting all standard and customized OM flows
- Responsible for support enhancement activities
- Opening SR and bringing them to closure by following up with Oracle SR team.
- Analyzed the business processes, designed functional specifications, and mapped these specifications to the Oracle Applications.
- Prepared Design Documents and unit test scripts (TE020) for the custom components.
- Coordinate with business user for requirement gathering and prepare functional document and technical document.
- Developed interface scripts in i-Expense module.
- Migration of objects from UAT to Production.
- Coordinated with Technical team and DBA's during Quarter releases for Production issues.
- Raising SR and provide a close observation for those SR
Description
Client : Worldline
Role : Techno functional Consultant
Duration : July-11 – Nov-13
R12 Upgrade and enhancements includes the modules INV, PO, OM, AR, BOM, WIP Advance Pricing and Shipping Execution.
Responsibilities:
- Leading two teams on Onsite-offshore Global Business model.
- Functional and Technical design in the modules of AR, INV, OM and Shipping Execution.
- Analyzed the business processes, designed functional specifications, and mapped these specifications to the Oracle Applications.
- Understanding the current Business Process and preparation of As-Is documentation.
- Designing of To-Be process and Identification of Gaps.
- Prepared Functional Design (MD050), Technical Design (MD070) Documents and unit test scripts (TE020) for the custom components.
- Functional/Technical Support to critical interfaces in Production for Order-to Cash, Procure to Pay processes.
- Coordinate with business user for requirement gathering and prepare functional document and technical document.
- Post GO LIVE support in the area of INV, BOM, AR and OM.
- Developed interface scripts in AR, OM and CRM Field Services.
- Migration of objects from UAT to Production.
- Responsible for Configuration/Setup, testing and support of all the above mentioned modules.
- Managed functional/technical design, development, unit and system testing for key custom components.
- Closely monitor the unit testing and resolved the complex issue raised by client during this enhancement
- Understanding to use HP Quality Center.
Description
Client : Panasonic
Role : Techno functional Consultant
Duration : March-10 - July-11
Description:
Implementation and phase wise rollout of Oracle Apps 12.0.1. Implementation includes the Oracle Apps modules INV, OM, BOM, WMS, WIP, AR and GL.
Responsibilities:
- Functional design in the modules of INV ,OM , Advance Pricing and Shipping execution.
- Gathered business requirements, analyzed the business processes, designed functional specifications, and mapped these specifications to the Oracle Applications.
- Prepared Functional Design Documents (MD050), Mapping documents (CV040) and unit test scripts (TE020) for the custom components.
- Coordinate with business user for requirement gathering and prepare functional document.
- Post GO LIVE support in the area of INV, BOM, WIP and OM. Maintaining the issue tracker for CR and defects and support technical and functional issues.
- Migration of objects from UAT to Production.
- Developed interface and conversion scripts.
- Developing training documents for developers and Business users
- Testing the new developed components and custom objects as per the business need. (TE-50).
- Creation of Modifiers, qualifiers etc.
- Lead the technical consultants for coding and developing the reports to meet the requirements
- Played major role in managing and resolving tickets raised in ticketing tool. Resolved short term and long term issues in Oracle SCM Modules. Raised SR in metalink and provided a close observation for them
- Actively involved in training to client on Oracle SCM Modules
SETUP
- Inventory – Define Organization Structure(Business Groups, Operating Units, Inventory Organization, Subinventory, Locations), Key Flex fields, Descriptive Flex fields, Shipping Networks, Transaction Types( Miscellaneous, Subinventory transfer, Inter-Org, Direct Transfer, Move Orders), Item Category Setup(Item Category Sets, Default Category sets, Item category flex field), Defining Items (Master level & Org level), Status attributes, Attribute Controls, Receiving options etc.
- Order Management – Customers, Order Types setup, Price List setup, Defaulting Rules, System Parameters, O2C cycles(Drop ship, Back –to- Back, IR –ISO, Standard Order cycle, RMA), Interface Third Party Orders(SFDC) to OM, orders Pick Release, ship confirm
- Advance Pricing – Profile option setup for enabling in Purchasing and OM, Modifier-Qualifier setup, Price Lists
Description
Client : Gilead Science, US
Role : Senior Analyst
Duration : Aug-09 - Dec-09
Description:
Gilead Sciences, Inc. is a research-based biopharmaceutical company that discovers, develops and commercializes innovative medicines in areas of unmet need. With each new discovery and experimental drug candidate, we seek to improve the care of patients suffering from life-threatening diseases.
Responsibilities:
- Requirement gathering, Client clarifications, Technical & Functional design review with onsite team.
- Write MD70 documents of various objects assigned to me.
- Developed conversions scripts.
- Developing training documents for developers and Business users.
- Migration of objects from UAT to Production and Go-Live.
Description
Client : Vaisala, Finland
Role : Senior Analyst
Duration : March-09 - Aug-09
Description:
Vaisala is a global leader in environmental and industrial measurement. Building on more than 70 years of experience, Vaisala contributes to a better quality of life by providing a comprehensive range of innovative observation and measurement products and services for meteorology, weather critical operations and controlled environments. Headquartered in Finland, the company employs over 1200 professionals worldwide and is listed on the NASDAQ OMX Helsinki.
The Project involves implementation in Oracle R12. Have done conversion and interface as per client requirement.
Responsibilities:
- Registration Custom object in oracle applications.
- Worked on RICE components across various modules of Oracle Apps eBS.
- Creation of PL/SQL functions, Procedures and Packages.
- Development of conversions.
- Developed Customer Conversion.
- Developed Installed Base Conversion.
- Developed Supplier Conversion.
- Developed on Item conversion.
- Developed Item Category conversion.
- Preparation of technical documents.
- Creation of migration documents.
- Creating Business Group Locations.
- Create a Business Group and assign the location and KFFs created above to it. Add organization classifications.
Description
Client:PLCB, Pennsylvania
Role:Senior Analyst
Duration: Nov-08 - March-09
Description:
The client is an independent government agency that manages the beverage alcohol industry in Pennsylvania. It is responsible for licensing the possession, sale, storage, transportation, importation and manufacture of wine, spirits and malt or brewed beverages in the Commonwealth, as well as operating a system of liquor distribution (retailing) and providing education about the harmful effects of alcohol consumption.
Project involves development of various conversions, interfaces and form development.
The Project involves implementation in Oracle R12. I have done development of conversion and interface as per client requirement.
Responsibilities:
- Preparation of technical documents.
- Worked on Interface include:
HRMS Inbound Interface
- Creation of PL/SQL functions, Procedures and Packages.
- Creation of migration documents.
- Development of eBS conversions.
Description
Client : Bestseller, Denmark
Role : Associate Technical Consultan
Duration : March-07 - Oct-08
Description:
The Project involves enhancement of Oracle Financials modules of Oracle Applications 11i (AP, AR, GL).In these modules I have done enhancement of the report and developed some report as per client requirement .Most of the report done in XML Publisher.
Responsibilities:
Registration Custom object in oracle applications.
Creation of PL/SQL functions, Procedures and Packages.
Customized 4Bucket & 7 Bucket report.
Customized customer details report.
Developed Direct Debit Reports.
Worked on Lockbox Interface.
Developed Supplier interface.
Developed AP invoice Interface.
Developed Customer Open Balance Letter for multiple countries.
Developed Supplier details report in XML Publisher report.
Developed Project Task loader conversion through API.
Developed Project Class loading interface through API.