SUMMARY:

• Extensive experience in administration, planning and support of numerous oracle technologies likeracle ERP/CRM (11i/R12/R12.2), oracle RAC database(9i to 12c), Oracle VM 2.2/3.0, racle Fusion Middleware, Weblogic, OBIEE, BI Publisher, discoverer, OAM/SSO, support oracle database for Demantra, Agile. experience in erp and database upgradation, erp server migration, database recovery, ERP R12.2 and 11gR2 sso/WNA integration,, OBIEE setup/installation,
• OBIEE end to end development (db view to dashboard), development using sql/pl - sql, EBS API, data mining
• Leadership and supervisory abilities with effective liaison between technical teams, business representatives, and technical consultant, oracle support.

TECHNICAL SKILLS:

ERP: Management and maintenance of Oracle ERP/CRM (11i/R12/R12.2) with oracle RAC database; Extensive experience with EBS SSO integration with OAM, SSO, OID and windows AD,wna; Adclone (clone) for multinode to multimode/single node, adding new node; adautocfg (autoconfig), adpatch and ADOP (Quarterly cpu patch, Delta etc), admerge, adctrl; Monitoring / troubleshooting of concurrent manager/request, enable tracing/debug, work flow mailer, sql tracing, DMZ setup; Disaster recovery setup, Annual DR testing, up gradation, rman and code tree backup; Java/JRE upgradation, SSL/Java code certificate setup/renew; Data mining and Knowledge of sales, Budget, order, customer, gl balance, Trading Community Architecture, hz parties, hz party site, hz customer etc.

Database: Extensive experience in oracle database administration (9i to 12c) for ERP database, standalone OLTP and data warehouse (OLAP) in RAC environment. maintained vary large dataase 3 tb to 5tb. Rman backup/restore, hot backup, cold backup, export/import, database recovery. Database tuning, sql tuning, sql loader, AWR, OEM. Expertise in using Oracle backend (PL/SQL) development Database Triggers, Packages, Procedures, Functions, Packages and constraints and data modeling and star schema for data warehouse/development.

Fusion Middleware: Setup and maintenance of 10g,11g, weblogic, Apache. SSO/OAM setup with WNA for EBS, OBIEE

Business Intelligence: setting up OBIEE with analytic and oracle DAC, informatica. OBIEE custom view for EBS module like gl balance, AP, AR, Trading Community Architecture, sales, Budget. OBIEE Dashboard development, BI Publisher, portal, discoverer, APEX, Noetix Reporting

Operating system: Linux, AIX,HP UX, Sun Solaris, Windows. shell scripting for monitor env, mount point, cleanup log/trace, email alert.

PROFESSIONAL EXPERIENCE:

Confidential, CA

PDL and Senior Oracle Apps DBA

Responsibilities:

• Responsible for maintaining oracle ebusiness suit ERP/CRM (R11/r12) including oracle database 10g,11g with RAC, for production and development.
• Maintaining large database 2.7 TB to 4TB size.. managing ebs 12,1,3 with SSO/OAM, Weblogic, OBIEE, portal
• ERP Cloning using Rman, quarterly patching, day to day troubleshooting with application and database. day to day dba activities. Using adconfig, adpatch, admerge, adautocfg which include up gradation, performance tuning, sql tuning, export/import, data loading, patching, cloning, setup and manage Data guard for EBS database using rman full / increment backup. Annual DR test.
• Managing sso with weblogic for EBS environment.
• Unix shell scripting for various database testing and monitoring..
• SSL certificate setup/renew for ebs web, Java code certificate .

Confidential, CA

Supporting as oracle consultant

Responsibilities:

• OBIEE installation setup and development of data modeling for obiee dashboard. Xml development.
• Develop custom finance view for sales, Budget, order, customer, gl balance and other finance module for obiee data mining.
• PL/SQL development for various automation process for bi reporting.
• XML publisher and APEX integration.

Confidential, CA

Senior Oracle Apps DBA

Responsibilities:

• Project lead with Detail planning and carry out Up gradation for oracle 10g/11g and oracle EBS R12 under hard deadlines.
• Setup and administration of SSO for oracle E Business suit with 10g database, portal and oracle OCS environment integrated with Microsoft AD and wna (zero authentication)
• EBS SSO with multimaster replication and oracle 10g RAC solution provided to ITC customer. installation and setup of oracle OBIEE with oracle analytics including setting up obiee, oracle DAC, inforamatica, data warehouse, oracle finance analytics, oracle HR analytics.
• Day to day maintenance of oracle database, ERP application, portal, discovere, OBIEE and ocs which include up gradation, performance tuning, sql tuning, export/import, data loading, Delta patching for EBS, cloning, backup, performance tuning, cloning, Troubleshooting for oracle ERP.
• Migration of oracle erp, portal, obiee env to oracle VM including details design of infrastructure. star schema data modeling, dimension and OBIEE dashboard development for sales by customer, sales lead, budget vs. actual, profitability, inventory, shipping, gross margin and many more.
• OBIEE administration and configure for user base security and data access and SSO with oracle EBS.
• Configuring oracle DAC and informatica for oracle OBIEE and dataware house
• Cloning of Oracle database, ERP/CRM application server and Portal with different technology like transport set, database export, import, RMAN etc
• Closely working with developer team and coordinate for implementing custom database objects and configuration EBS technology like concurrent programs development and setup, support custom workflow development and forms development, noetix reports etc..
• Oracle Infrastructure planning for future requirement, testing, evaluating new oracle technologies..

Confidential, CA

AS A SENIOR ORACLE CONSULTANT

Responsibilities:

• Leading the Project for migration of ERP from Unix to Linux
• Maintenance and cloning of Oracle ERP/CRM environment using various oracle technology like adconfig, adpatch, admerge, adautocfg
• Oracle ERP/CRM administration and its components like Concurrent Manager, workflow, oracle Alerts, XML gateway, Flex Field
• Leading the project for BIS(Business Intelligence Finance/marketing etc )
• Worked with Trading Community Architecture and its EBS data model.
• Backend development using oracle 11i API,PL/SQL e.g Used Receipt API for applying return cash receipt and applying debit.
• Data mining for sales online, marketing online, isupport etc.. involved in development of custom workflow and setup in database.
• Develop process for ecommerce using XML and PL/SQL setup / configuration web ADI
• Administration and Maintenance of 24x7 oracle OLTP and WAREHOUSE databases.
• Recovered Database at lest 3-4 times in different scenario like Disk failure, Block corruption, Hardware failure.
• Real time Performance monitoring and Tuning of Oracle systems/SQL using different monitoring tools like DB General, OEM, UTLESTAT/UTLBSTAT, Unix utilities and disk manager
• Oracle Installation, setup database on Raw partition and disk array using different type of RAID configuration for maximum throughput. Extensively work for adhoc query/sql tuning.
• Administration of RMAN environment with Legato networker for database backup, Used Export/import, sql loader, Replication, Materialize view, XML etc..
• Closely working with developer team for sizing database objects, developing Database Triggers, sequences, constraint, function, procedure, and for efficient sql ETL development using pl/sql, PHP and unix shell scripting for WAREHOUSE
• Monitoring and managing resource requirements for data warehouse system.
• Installation, setup, configuration upgrade, applying patches to Oracle 9i web application server.
• Configuration and setup of Discoverer, PORTAL,SSO
• Disk array management and Raid configuration using VERITAS volume manager, SUN SOLASTIC including Raw partition, disk format, replacement and adding new disk, Creating file system, mount point, NFS FS