Senior Consultant
Hitachi Consulting
Total years of experience :9 years, 8 Months
Project Name: Hitachi Consulting GDC
Location: Off-Shore - Hyderabad
Duration: From March 2012 to Till Date.
Version: 11.5.10.2, R12.0.6 and R12.1.3, Weblogic 11g
Project Profile: Hitachi Consulting’s client base spans a wide range of industries and includes 35 percent of the Fortune 100, 25 percent of the Global 100, and many mid-market leaders.
Role: Team Lead
Job Profile:
• Provide pro-active support to Hitachi’s GDC global customers.
• Meet SLA effectively and efficiently using tools like Assure Service Desk.
• Currently supporting around 20 clients with a varied range of technologies including Oracle Core Databases (10g, 11g), Oracle E-Business Suite (11i, R12), Oracle Middleware - Weblogic 11g
• Completed the automation of disk storage monitoring at both Oracle database and O.S. Level.
• Expertise in all areas of Oracle Core Database :
o Installation, upgrades and patching of Oracle core databases including OEM.
o High Availability and Storage - RAC, Standby and ASM
o Backups - Both RMAN and traditional O.S. Level.
o Responsible for Oracle Core database and Apps capacity planning, backup strategies, near zero downtime by leveraging methodologies of Oracle MAA (Maximum Availability architecture), housekeeping and smooth functioning.
o Can diagnose, analyze and tune databases for maximum performance.
• Expertise in all areas of Oracle E-Business Suite :
o Upgraded EBS environment from version 12.0.6 to 12.1.3
o Reported on all client instances vulnerable to Oracle sustenance and P1 Bug fix support policies.
o E-Business suite’s System Administration including Workflow configuration.
o Oracle Applications Manager.
o Shared Applications File System, PCP
o All ad utilities - adadmin, adpatch, admrgpch, adident, adsplice, autoconfig, etc..
o Clone - Multi-node to single node.
o Installation - R12 Multi-node, single-node, Platform Migration
• Expertise in following areas of Oracle Middle-Ware:
o Installation, integration and patching of Oracle Weblogic, SOA Suite, UCM, Discoverer, WebCenter, OIM, OAM
o Configured almost all Fusion Middleware products in standalone mode with Weblogic.
Project Name: Oracle GSD
Location: Off-Shore Hyderabad
Duration: From Feb 2010 to March 2012 ( 2 Years )
Version: 11.5.10.2, R12.0.6 and R12.1.3
Role: Senior Consultant.
Job Profile:
• Provide pro-active support to Oracle’s GSD global customers.
• Responsible for all Core Database activities for all clients.
• Upgraded R12.0.6 to R12.1.3 including database upgrade from 11.1.0.7 to 11.2.0.2
• Supported E-Business Suite version 11.5.10, R12 and GRC (Logical Apps)
• Successfully configured / integrated 12.1.3 MWA services in a multi-node environment (3 DB nodes + 11 Apps nodes)
• Completed the creation of two node DMZ (external) tier in an existing E-Business Suite environment.
• As part of BCP (Business Continuity Plan) created physical standby databases prior to go-live of many customers.
• Designed, Configured and Deployed Oracle MAA (Maximum Availability Architecture) in an R12.1.3 roll-out.
• This was achieved using best of Oracle technologies both at database and application tiers. The technologies used were Oracle RAC, Shared Application File System, PCP and Dataguard.
• Migrated complete E-Business suite environment 11.5.10.2 running on SPARC Solaris to RHEL 5
• Logical Apps, Oracle GRC (Governance, Risk and Compliance) Suite 6.1 integration with R12.1.3.
• Integrated Vertex and Oracle IPM with Oracle E-Business Suite 12.1.3
• Implementation and migration support for new ERP instances from 11.5.9 to 11.5.10.2.
• Responsible for current production and development instances support (11.5.9).
• Working in a rigid SOX controls and compliance environment.
• Performing all the oracle apps SYSADMIN tasks to support the technical and functional teams.
• Experience in giving support to the project RICE development teams.
• Logical Apps, Oracle GRC (Governance, Risk and Compliance) Suite integration
• Code and object migration using FNDLOAD, WFLOAD and third party clomming tools.
• Trouble shooting users’ instance access and login issues.
• Multi-node (5+1) and single-node cloning.
• Patching Oracle database and applications.
• Proficient in all ad utilities like apatch, adadmin, adctrl, adident, admrgpch, adautocfg, adrelink, etc…
• Registering and trouble shooting printer issues.
• Good understanding of shared application files system architecture and NetApp filers (7.3).
• Advanced topologies installation and configuration. SSL and F5 load balancer configuration.
• Resolve customer issues within the SLA.
• R12 installation and maintenance.
• Workflow administration.
• Database alert log, table space and system resource monitoring.
• Generate user session trace on request and proactive monitoring for DB blocking sessions.
• Provide support during quarter-end close of business.
Third Party Tools:
• Logical Apps, Oracle GRC Suite
Successfully lead the project - Logical Apps integration
o Installation, configuration and integration of Logical Apps, GRC suite 7.2.2.2 with Oracle E-Business Suite 11.5.10.2
o Implemented as per Oracle’s best practices architecture and design.
o Worked with Oracle support through SR and OWC to resolve issues.
o Day-to-day end user support.
o Documentation and knowledge transfer.
• Object Migration Manager (OMM), UNITASK
• Optio Printing
• VSS and PVCS.
o Extensive use of VSS in supporting implementation teams. Proficient in both VSS and PVCS
• Maintaining different environments like 11.5.5 & 11.5.10
• Looking into day-to-day activities of Production database, Monitoring its growth and performance.
• Clone 11i instances for developing and testing purposes.
• Applying patches for enhancement and fixing bugs using adpatch, Opatch.
• Monitor the growth of Table spaces to see the fragmentation and available space for growth. Check for log and trace files.
• Registering the new Forms, Reports, sqlloader, pl/sql scripts as concurrent programs as part of technical support.
• Cases support from Offshore
• Creating Technical Notes and Documentation.
• Trouble shooting the database related issues.
• Off shore support for R12 Early Adaptors Program
Installation, configuration, kernel and operating system package upgrade of Redhat Linux Advanced Server as and when required.
Used kick-start to install Linux desktop clients and configuration of TCP wrappers.
Expertise in troubleshooting boot time issues.
Performance tuning and job scheduling.
Configuration of Samba server as PDC and stand alone.
Installation and configuration of FTP, NFS, NIS and VNC Servers.
Installation and configuration of DNS, DHCP, Web and Mail servers.
Managing disks and users, knowledge of LVM
Installation of Oracle 9i enterprise server on Linux.
Bachelor of Computer Applications with 65%