Pankaj Dutta

Pankaj Dutta

Trainee (software development)

Followers of Pankaj Dutta509 followers
location of Pankaj DuttaMidnapore Sadar, India

Connect with Pankaj Dutta to Send Message

Connect

Connect with Pankaj Dutta to Send Message

Connect
  • Timeline

  • Skills

    Sql
    Oracle forms
    Oracle reports
    Big data
    Hadoop
    Xml publisher
    Sqoop
    Oracle workflow
    Oracle pl/sql development
    Order management module
    Eam module
    Procure to pay module
    Forms personalization
    Oracle application object library
    Oracle erp implementations
  • About me

    Looking for a change as PL/SQL Developer or into Oracle Apps Technical. Having expertise in SQL, PL/SQL, Forms, Reports, XML Publisher Reports, Oracle Workflow, E-Business Suite R12 Order Management, Enterprise Asset Management and Purchasing Module. Ready to relocate anywhere. Having total experience of 8 years. Relevant experience 6 years. Any openings please.

  • Education

    • National institute of management and technology (nimt)

      2010 - 2016
      Master of computer applications (mca) computer science b
    • National institute of management and technology (nimt)

      2005 - 2008
      Bachelor of computer application (bca) computer science a
    • Douglas memorial higher secondary school (dmhss)

      2005 - 2005
      Isc (xii) arts b

      activities and societies: selected as the best athlete in annual sports meet, 2005 when in school. participated in the inter school 5-a side football tournament, 2004 when in school.

    • Douglas memorial higher secondary school (dmhss)

      2003 - 2003
      Icse (x) general b
  • Experience

    • Management and computer consultants (mcc)

      Feb 2010 - Jun 2010
      Trainee (software development)

      development of oracle d2k and xml publisher reports.

    • Web development company ltd. (wdc)

      Jun 2010 - Dec 2010
      Software developer trainee

      database image backup in hard disk drive and migration and error rectification if there are any backup errors. giving support to central prepaid activation and audit team to retrieve their large volume of data by writing sql query using sql developer as a tool.

    • Kaizen it services pvt. ltd.

      Feb 2011 - Jul 2012
      Software developer

      interaction with users and giving them support related to their various system issues. also, writing sql queries and pl/sql blocks for data retrieval and user management in oracle production database. disk space and table space monitoring and also dropping of table partitions if required. sim uploading in bscs through ra module. bill files downloading through file zilla application. bill cycle creation. service provisioning in in and hlr.

    • Ivl dhunseri petrochem industries private limited

      Jul 2012 - Jan 2018
      Senior officer (information technology)

      1. development and modification of oracle d2k and xml publisher reports and registering those reports in e-business suite r12.also, development and modification of d2k forms and registering the same in e-business suite r12. 2. mis reporting by writing sql query using toad as a tool, as per business requirements.3. giving support and training to users in e-business suite r12. 4. order creation to shipping in e-business suite r12 through om module and also resolving technical and functional issues. also, supplier and customer creation, item creation, defining item class, purchase requisition and purchase order creation, creation of gate pass.5. asset management in e-business suite r12 through eam module. creation of asset and parent asset in r12, scheduling of preventive maintenance against an asset, insertion of activity against an asset, creation of set names. show less

    • Eveready Industries India Ltd

      Feb 2018 - Jun 2018
      Executive -business application

      • sql query using toad as a tool. also, writing pl/sql blocks.• giving support to users and solving their problems in e-business suite r12. • development and modification of oracle d2k and xml publisher reports. also, development and modification of d2k forms.• forms personalization in r12.• development of business intelligence reports using oracle discoverer.• ebs r12 order management module: customer creation, gst number incorporation against customers, sales order creation, shipment against sales order and invoice generation, mapping of sales order in ar, product code and lot uploading, increasing the expiry date of an item, pricing upload of a lot against an item, hsn code creation against an item, account code change of an item.• ebs r12 inventory module : inventory category code and category set creation, po category creation. show less

    • Ivl dhunseri petrochem industries private limited

      Jun 2018 - Dec 2021
      Senior officer (information technology)

      • sql query using toad and sql developer as a tool. also, writing pl/sql blocks.• giving support to users and solving their problems in e-business suite r12 and oracle cloud erp. • ebs r12 order management module: sales order creation, shipment of the sales order, oc generation, invoice generation, invoice cancellation in case of sales order return and also resolving technical and functional issues. also, supplier and customer creation. gst number incorporation against customers and suppliers.• ebs r12 enterprise asset management (eam) module : asset management in e-business suite r12 through eam module. creation of asset and parent asset numbers in r12, scheduling of preventive maintenance against an asset, insertion of activity against an asset, creation of set names.• development and modification of oracle d2k and xml publisher reports and registering those reports in e-business suite r12.also, development and modification of d2k forms and registering the same in e-business suite r12. • development of oracle cloud forms using apex tool. also, developing oracle cloud bi reports and registering the same in oracle cloud erp and development of jasper soft reports.• purchase requisition and purchase order creation, creation of gate pass in oracle r12 and oracle cloud erp.• forms personalization in r12 and development of business intelligence reports using oracle discoverer.• oracle cloud erp order management module : customer creation, hsn code incorporation against items, supplier creation, sales order creation, shipment of the sales order, oc generation, invoice generation, invoice cancellation in case of sales order return and also resolving technical and functional issues. show less

    • IVL Dhunseri Petrochem Industries Pvt Ltd.

      Jun 2018 - now
      Chief officer
  • Licenses & Certifications

    • Oracle Certified Professional (OCP)

      Oracle
      Jul 2010
    • Big Data Analytics

      InsAnalytics
      Jan 2018
    • Oracle Certified Associate (OCA)

      Oracle
      Jan 2009
    • Oracle Application Software Developer (OASD)

      SQL Star International
      Jan 2009