Nitin Chavan, Principal Consultant

Nitin Chavan

Principal Consultant

ennVee Solutions Pvt Ltd

Lieu
Inde - Pune
Éducation
Master, MBA- Professional
Expérience
16 years, 3 Mois

Partager Mon CV

Empêcher usager


Expériences professionnelles

Total des années d'expérience :16 years, 3 Mois

Principal Consultant à ennVee Solutions Pvt Ltd
  • Inde - Bengaluru
  • Je travaille ici depuis août 2018

Project Details
I) Project 1 (US Client)
• Currently working on install and integrate oracle SSO (OAM & OID) with EBS 12.1.3.
• APEX installation, SSL enable for APEX(ORDS) and creating windows service to AutoStart
ORDS service.

II) Project 2 (US Client)
Responsibility-
• Supported to EBS 12.1.3 with Database 12.1.0.2
• Provided support when users sending requests to migrate code for their testing. Multiple requests
handling and replying to users with details.
• If users facing issues to access instances, troubleshooting issues, and making sure that keep
instances available to users.

III) Project 3 (US Client)
Responsibility-
• Provided production support for EBS 12.2.4 instance on OCI with EXADATA DB machines.
• Troubleshooting user’s issues as per Cherwell tickets, patching, cloning, change request activities
for EBS 12.2.4 instance.

IV) Project 4 (US Client)
Responsibility-
• EXCEL4APPS Installation, upgradation and perform required pre and post steps.

V) Project 5 (Internal)
Responsibility-
• Working on Trendz Monitoring tool (ennVee tool) as like OEM to monitor Database, EBS and
other applications like SOA, OBIEE, WebLogic etc

VI) Project 6 (US Client)
Responsibility-
• Worked on Database 19c and EBS 12.2.9 Upgrade Project.

Sr. Oracle Apps DBA à Infosenseglobal Pvt Ltd
  • Inde - Ahmedabad
  • avril 2016 à août 2018

Project Details
I) Project 1
Responsibility-
• Provided production support for EBS 12.2.5 instance 24/7.
• Performed patching, cloning, task migration activities for EBS 12.2.5
instance.
• Administration of EBS-R12.2.5 instances.
• Worked on ETL and reporting tools like OBIEE.
• Supported SSO (OAM and OID) for integrated with EBS 12.2.5

II) Project 2
Responsibility-
• Worked on application upgrade (EBS-R12.1.2 to EBS-R12.2.5)
• Worked on custom top creation, multinode configurations using shared file system.
• Applied WebLogic patches on EBS 12.2.5 instance.
• Integrated SSO with upgraded EBS12.2.5
• Workflow configuration and administration.
• Configured Mobile Application and enabled required applications.
• Implemented Brazil Localization and EMEA Localization. Applied latest
country specific Add-on Localization patches

III) Project 3
Responsibility-
• Worked on Application upgrade (from EBS-R12.1.3 to EBS-R12.2.5)
• Applied Advanced supply chain planning (ASAP) patches.
• Worked on custom top creation, multinode configurations using shared file system.
• Applied WebLogic patches on EBS 12.2.5 instance.

IV) Project 4
Responsibility-
• Providing production support to EBS 12.1.2 with Exadata databases with RAC node.
• Applied Opatches on Exadata for both RAC nodes.

Senior Oracle Apps DBA à Cyret Technologies (India) Pvt.Ltd
  • Inde - Pune
  • avril 2015 à février 2016

I) Project 1
Client Sunrise foods Pvt. Ltd. Kolkata.
Role Senior Oracle Apps DBA
Responsibility:
I) Worked on Database and Application upgrade (DB-10.2.0.2 APP-12.0.6 to DB-11.2.0.3 APP-12.1.3) and migrated from RHEL-4.4(32-bit) to OEL-6.5(64-bit)
II) Applied RPC patches and product specific patches after upgrade and migration.

II) Project 2
Client Synpack Zipper Bags Pvt. Ltd. Bangalore
Role Senior Oracle Apps DBA
Responsibility:
II) Worked on implementation project to install EBS 12.1.1 and upgrade DB from 11.1.0.7 to 11.2.0.3 and application to 12.1.3 . Also Applied RPC patches over 12.1.3

Oracle Apps DBA à IBM India Pvt.Ltd.Pune
  • Inde - Pune
  • juillet 2011 à février 2015

I) Project 1
Client IDEA Cellular Pvt. Ltd. Pune
Role Oracle AppsDBA
Responsibility:
• Providing support to multi node environment production instance for Oracle
application R12 (12.1.3) and RDBMS (11.2.0.3) with RAC and ASM .
• Upgraded RDBMS (10.2.0.5) to (11.2.0.3) and application (11.5.10.2) to (12.1.3)
• Patching Analysis and patch application.
• Rapid Cloning from production instance to test instances.
• Implementing RFC's on UAT and production instance.
• Diagnose and resolve users issue and close the ticket in BMC tool.
• SSL (HTTPS) Implementation on DEV and UAT instance.
• Created DR server (replica of production server) and doing DR drill quarterly.
• Quarterly applying CPU patches.
• Daily backup of production for application and database using RMAN.
• Implemented PCP (Parallel concurrent processing) in oracle apps.
• Monitoring Tivoli alerts
• Configured shell scripts for monitoring and atomization for smoothly working
of application.

Oracle Apps Consultant à Iware Logic Technologies Pvt.Ltd.
  • Inde - Pune
  • octobre 2010 à juillet 2011

I) Project 1
Client Kirloskar Pneumatic Co. Ltd. Pune
Role Oracle Apps DBA
Responsibility:
• Worked on Oracle application 11i (11.5.10.2) and RDBMS (10.2.0.5) multinode
environment.
• Patch analysis and patch application
• Cloning database and application to test instances.
• Post steps after upgrade of ATG7
• Upgraded Roll UP INV4 to INV23
• Revised user accesses (Created Menus, responsibilities for 17 org, assigned
profiles, assigned security rules)
• Define new programs, request groups.
• All sysadmin task
• Daily Activities and Monitoring

II) Project 2
Client SIOM (Sinhgad Institute of Management) Pune
Role Oracle AppsDBA
Responsibility:
• Worked on R12 installation for giving training SIOM and provided support
for multiple instances.
• Worked on client machine configurations for accessing the front end for users
and resolved the issues of users.

Oracle Apps DBA à Bramhatech (IT Support & Solution Provider Company)
  • Inde - Pune
  • mars 2010 à octobre 2010

I) Project 1
Client Honeywell Automation India Ltd. Pune
Role Oracle AppsDBA
Responsibility:
• Worked on Oracle application 11i (11.5.10.2) database (9.2.0.7).
• Applied adpatches, localization patches, opatches and used ad utilities when
required.
• Rapid cloning for oracle application.
• Database 9i, 10g installation on windows 2003 server.
• Upgrade Database from 9.2.0.5 to 9.2.0.8 and from 9.2.0.8 to 10.2.0.4
• Database cloning on windows server 2003.
• Applied Critical Opatch for database on windows server 2003 environment.
• Deployed tested queries\scripts on production database when requested.
• Oracle application Sysadmin activities.
• Run the diagnostic scripts and provide the output.
• Resolve the database and application performance issues.
• Oracle client installation(i.e. Report builder, form builder, SQL developer,
Workflow, Discoverer)
• Worked on Exp/Imp utility on schema level, tablespace and tables.
• Resolved the issues related windows database services
• Database backup using RMAN utility.
• Create and alter the database objects as per requirement.
• Database auditing.
• Created duplicate database using RMAN backup.
• Daily DBA/Apps DBA task.

II) Project 2
Client Honeywell Turbo Technology Pune
Role Oracle AppsDBA
Responsibility:
• Created standby database for Production.
• Implemented RMAN backup policy for production database.

Software Engineer à Infogain Systems Pvt. Ltd.
  • Inde - Pune
  • janvier 2008 à mars 2010

I) Project 1
Client PTC Pvt. Ltd. Pune
Role Oracle DBA/Apps DBA
Responsibility:
• Worked on seven different database instances on the different Platforms.
• Daily performance monitoring and taking reports.
• Worked on database security.
• Database backup, restore and recovery.
• Database space management.
• Execute and analyze ADDM, AWR report
• Rebuild indexes and analyze tables.
• Deploy the queries on production after confirmation from development team.
• Provide the required information to management regarding database.

II) Project 2
Client - Rucha Engineers Pvt. Ltd. Aurangabad
Role - Oracle DBA/Apps DBA
Responsibility:
• Upgraded oracle application from 11.5.9 to 11.5.10.2 and oracle database
from 9.2.0.3 to 9.2.0.8
• Rapid cloning for oracle application 11i
• Applied adpatches, localization patches, opatches.
• Worked on adadmin, adpatch, adrelink, adctrl, admrgpch, adident, adconfig utilities.
• Create SR, update SR, OWC session, and download patches from metalink.
• Start and stop oracle database and application services.
• Manually backup of archive log, cold backup in the tape and backup of control file.
• Remove old archives to make space available on mount point.
• Compile Invalid objects.
• Rebuild indexes, analyze tables, and execute packages.
• Add or resize data files for the particular tablespace.
• Database and application tuning.
• Create application users assign required responsibilities.
• Printer installation and configuration in the application.
• Set the profile as per requirement.
• Schedule any program in application when required.
• All the tasks related system administrator and DBA/Apps DBA.

III) Project 3
Client - Novelis (India) InfoTech Ltd, Pune
Role - Oracle DBA/Apps DBA
Responsibility:
• Worked on RAC and Multinode environment for 12.0.6 oracle application and 10.2.0.4
database.
• Worked on several databases (10.2.0.4) which are on windows server 2000, 2003 and
2008.
• Cloning of production instance to development and test instance.
• Patching application.
• Database administration of production, development and test instances.
• System administration functions like creating users, creating responsibilities,
menus and functions.
• Database and server Space management
• Database backup and recovery procedures,
• Deleting old archives on the server.
• Security implementation including routine maintenance activities.
• Providing required information regarding database and application to
management and users.
• Closely monitoring the each database and application to prevent the issues.

Éducation

Master, MBA- Professional
  • à M.S University
  • mai 2012

MBA- Professional

Baccalauréat, Graduation- B.sc (Computer Science)
  • à Dr. Babasaheb Ambedkar Marathwada University. Aurangabad.
  • juin 2002

B.sc (Computer Science)

Etudes secondaires ou équivalent, HSC
  • à Vasantrao Naik College, Aurangabad.
  • mars 1998

HSC

Specialties & Skills

Oracle ERP
Team Leadership
Oracle RAC
Performance Tuning
Operating System-Linux, UNIX, Sun Solaris, IBM Aix and Windows
Applications-Oracle E-Business Suite 11i ,R12,12.2.x and Weblogic 12c
Shell Scripting for automation
Databases - Oracle Database 12c, 11g, Oracle 10g, Oracle9i
Oracle SSO integration with EBS, configure IDCS in cloud, EBS 12.2.x upgrade and database upgrade
Handling Team

Langues

Anglais
Expert
Hindi
Expert
Marathi
Expert

Formation et Diplômes

oracle cloud associate architect (Formation)
Institut de formation:
oracle online
Date de la formation:
May 2019
Durée:
50 heures

Loisirs

  • Watching News on TV
    Watching new on TV and Reading online news