Debabrata B.

Debabrata B.

Sr. Technical Specialist

Pune , India

Experience: 12 Years

Debabrata

Pune , India

Sr. Technical Specialist

USD / Year

  • Start Date / Notice Period end date:

12 Years

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...

Show More

Portfolio Projects

Description

Working as individual contributor gather the requirement from onsite cordinator and Worked on objects

Show More Show Less

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

Show More Show Less

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

Show More Show Less

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

Show More Show Less

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 Less

Description

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 Less

Description

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 Less

Description

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 Less

Description

Employer : TrinitiRole :Oracle Technical ConsultantProduct Version :11.5.10Module :PO,InventoryResponsibilities:· Purchase Order Conversion· PO Release conversion· Material Receipt Conversion

Show More Show Less

Description

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 Less

Description

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 Less

Description

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 Less

Description

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 Less

Description

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 Less

Description

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 Less

Description

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

Description

Role : Oracle Technical ConsultantProduct Version : 11.5.10Module : Inventory, BOM and SourcingResponsibilities:· Created Data Conversion program to Import Item/BOM/Sourcing· Resolving Functional Issues in Inventory and Bom whenever Occurred.

Show More Show Less