Now you can Instantly Chat with Debabrata!
About Me
Masters degree in Computer Application, NIT, Jamshedpur, CGPA-7.95/1013 years of IT experience in Oracle e-Business Suite(Release -12/ 11.5.10)12 years experience oracle EBS Technical consultant in (FIN and SCM)INV,BOM,PO,OM,AR,AP,GL,WIP and FATechni...s experience oracle EBS Technical consultant in (FIN and SCM)INV,BOM,PO,OM,AR,AP,GL,WIP and FATechnical Expertise includes PL/SQL, forms, reports, Interfaces, conversions, APIs, Workflow,Oracle Alerts, Form Personalization, Oracle Extensions, XML/BI PublisherExtensive experience in Oracle Applications Development, implementation, Rollouts ,R12Upgrade and Production Infant CareGood understanding of modules like in Oracle Distribution (O2C & P2P),AP, AR, GL,FA,PO,INV,BOM,OM,WIP ,OSFM and iprocurement.Exposure to onsite assignments Malaysia.
Show MorePortfolio Projects
Description
- Developed Bank ,Bank Branch, Bank Account and Bank account uses conversion
- Developed Customer Conversion.
- EDI Outbound Payment processing
- Customized Account Itemization program and printing general ledger report
- Developed of XML Publisher Reports
- Customized of Payment format
- Involved in preparation of MD-70 technical design document
- Review the code and MD70 Document
- Responsible to handle the daily update status call with onsite co-coordinator
- Developed Sales order Acknowledgement Report for Russian Language
Description
- Involved in the requirement gathering and preparation of SDD(Solution Design Document).
- Co-ordinated with middleware ,onshore and source team for the data mapping and gap analysis
- Developed interface program to validate and load the data into oracle R12(ERP) side
- Developed Acknowledgement procedure to send the acknowledgement to middleware and source team for successful and rejected records.
- Developed of XML Publisher Reports
- Involved in CRP and assisted user in UAT testing
Description
- Design Custom program for Create Routing
- Design custom program for update the operation in Work in Process
- Design Custom program for WIP Back Flush
- Design Custom program for Apply Hold and Release hold in sales order
- Carried UAT and CRPs for the integration project along with NGMES and Middleware team.
- Prepared technical specifications like MD070
- Involved in preparation of MD-70 technical design document
- Responsible to handle the development status call with business super user and Business Analyst(BA).
- Infant Care support
Description
Client : In House (TCIL , Calcutta) (Nov2003 to April2004)Software: Oracle 8i,Oracle PL/SQL,developer/2000 (Forms 5/6i,Report 3/6i) CASE tool –Designer, SQL LoaderResponsibilitiesRequirement analysis and information collection to visualize the needs of the User,setting up questionnaires, understanding the procedures and processInteraction with Users to get feedback about the different aspects of design andimplementationDesigning the system using CASE tools ( System Designer ) - process modeling, ER modeling,functional hierarchy architecture, data and module data diagrammer, module structurediagrammer etc.generation of screens and reports using generation tools of Designer 2000 and customizing theuser interfaces using Forms 6i and Reports 6iResponsibilities :Development ,Enhancement and maintenance
Show More Show LessDescription
Client : TATA STEEL (TATA CENTRE , Calcutta) (June1999 to July 2000)Software : Oracle 7.3.2,PL/SQL,developer/2000 (Forms 4.5,Report 2.5),CASEtool –Designer, SQL LoaderProject : Integrated Finance SystemThis is basically an integration of three systems that is Finance and Cash system, TravelAdministration,T. A. Bill system and Budget Control system. All the system has beenimplemented in July2000 and post-implementation supportResponsibilitiesImpact Analysis, Requirement Collection, Low Level Design, Coding, Testing, UserInteraction, Documentation.
Show More Show LessDescription
Employer : Zensar TechnologiesRole : Functional/Technical ConsultantProduct Version : R12Module : Finance (AR,AP,GL and FA ) and OM R12 UpgradeResponsibilities:As a Techno-Functional Consultant responsible for the following:Modification the packages and Reports based on R12Developed Bank ,Bank Branch, Bank Account and Bank account uses conversionDeveloped Customer Conversion.EDI Outbound Payment processingCustomized Account Itemization program and printing general ledger reportDeveloped of XML Publisher ReportsCustomized of Payment formatInvolved in preparation of MD-70 technical design documentReview the code and MD70 DocumentResponsible to handle the daily update status call with onsite co-coordinatorDeveloped Sales order Acknowledgement Report for Russian LanguageResponsible to handle team
Show More Show LessDescription
SUNPOWER, USAEmployer : TrinitiRole :Oracle Techno Functional ConsultantProduct Version :R12Module :PO,AR,AP and InventoryResponsibilities:· Played a Key Role in the development of Automated Commercial Flow(ACF)which is used to create AR,AP,Inventory.· Designed Custom programs for AR Creation ,AP Creation and Material Receipt andMaterial Issue.· Designed and Developed Manual Release Form· Designed and Developed the custom Program to Import Price List for Item· Designed and Developed pattern creation form· Prepared technical specifications like MD070Responsible to handle the daily development status call with business super user
Show More Show LessDescription
Role :Oracle Technical ConsultantProduct Version :12iModule :PO,OMResponsibilities:· Designed And Developed the custom Program to Import the Purchase Order· Designed and Developed the Custom program to import the Sales Order.· Preparing the Technical Document Reference Custom Programs· Developed of XML Publisher Reports.· Developed of BI Publisher Reports
Show More Show LessDescription
Employer : TrinitiRole : Oracle Technical ConsultantProduct Version : 11.5.10Module : Inventory, Shop Floor and PurchasingResponsibilities:· Designed and Developed the Custom form TLS(Triniti Lots Start)· Designed and Developed the Custom program to import the Blanket Purchase Orders,Consumed and Unconsumed the Lots· Preparing the Technical Document Reference Custom Programs· Developed of XML Publisher Reports.
Show More Show LessDescription
Employer : TrinitiRole : Oracle Technical ConsultantProduct Version : 11.5.10Module : Order Management, I-storeResponsibilities:· Helped the client to successfully implement Oracle Apps version 11.5.10· Developed the custom program item , Categories and Cross Referencesimport· Designed and Developed the custom program for bulk image upload for anitem in i-store· Designed and Developed Custom Program to Import Item Price List· Customization of PO Report and Pack Slip Report· Created Alerts for sending mail to users whenever the status of the sales orderchanges, like Entered, Booked etc.
Show More Show LessDescription
Employer : TrinitiRole : Oracle Technical ConsultantProduct Version : 11.5.10Module : Inventory, BOM and Shop FloorResponsibilities:· Played a Key Role in the development of Triniti Product Modeler (TPM) aTriniti tool which is used to create Items, BOM, Souring, Co-Products etc.· Triniti Routing Edapter· Designed Custom programs for flushing Item and BOM data into OracleApps.· Worked closely with clients in helping them migrating to Apps Version11.5.10.· Supporting the client in go live issues.
Show More Show LessDescription
Role : Oracle Technical ConsultantProduct Version : 11.5.10Module : Inventory, Purchasing, Order ManagementResponsibilities:· Creation of Concurrent programs and Responsibility assignment.· Creating Business Alerts on Day to day activity.· Developed Discover Reports and Trained users on using Discoverer Reports· Form customization using custom.pll· Preparing the Technical Document Reference Custom Programs.
Show More Show LessDescription
Role : Oracle Technical ConsultantProduct Version : 11.5.10Module : Inventory and Sourcing.Responsibilities:· Designed and developed custom program to create an Item Revisions andItem Catalog.· Designed and developed custom program to create a Sourcing at Item-Category Level.· Designed and developed custom program to Insert, Update and Delete theItem Cost information.
Show More Show LessDescription
Role : Oracle Technical ConsultantProduct Version : 11.5.10Module : Order ManagementResponsibilities:· Developing Reports in Discoverer like Field Sales Open Order, Open PO Report, PreBook Monthly Report,Pre Book Summary Report .· Developing Reports in Report Builder like Invoice Report, Purchase order Report· Creating extensions to meet user requirements.· Preparing the Technical Document Reference Custom Programs.
Show More Show Less