Pankaj Dutta

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