Oracle Apps Dba/bi Dba/admin Resume
Oakbrook, IL
SUMMARY
- A highly motivated and vastly experienced Information Technology Professional with over 9+ years of experience as a highly regarded technology professional with a deep understanding of Oracle ERP, Oracle Database Administration OBEE,OBIA & ODI
- Worked for many high profile companies contributing in the success of several business critical projects, has the energy, passion and a relentless ambition needed to ensure that positive project outcomes are achieved within the parameters of time, cost, scope, risk and benefits.
- Defining IT solutions and then presenting those solutions in written or oral reports.
- Managing project dependencies, preparing project briefs, compiling reports and maintaining records.
- Ensuring that all stakeholders are up - to-date and up to speed with developments.
- Helping project teams to move through the various stages and decision points of a program.
- Participated for pre sales, proposals, effort estimations, project plan activities.
- Proven experience in OBIA Implementation/upgrade and in Oracle Business Intelligence and OBIEE Administration along with Knowledge of installing, upgrading and configuring OBIEE tools
- Proficient in the use of repository variables and Administer ETL and data warehousing applications and tools and Understand the standard of best practices in BI administration environment
- An effective communicator with relationship management skills and ability to relate to people at any level of business and management.
- Hands on experience on Oracle BI Implementation, upgradation and on Oracle Apps and Database administration.
- Experience of various applications on UNIX (Solaris/Red hat) and Win environment
- End to End Implementation of Oracle Apps R11i and R12 on different platforms.
- Upgradation of Oracle Application from 11i to R12 on Linux and windows environments.
- Upgradation of 9i and 10g databases on various platforms
- End to End Implementation of Oracle Application Server 10g, FMW11g (OID,SSO, Portal)
- Implementation of Oracle Enterprise Content Server.
- Implementation of Oracle database Vault, Label Security and Audit Vault.
- Good knowledge in using Apps Utilities (patch, adadmin. Cloning etc)
- Outstanding organizational, communication & presentation skills
TECHNICAL SKILLS
Databases: Oracle 10g
Datawarehouse: Informatica, DAC, OBIEE, ODI, OBIA
ERP Administration: Oracle Release 11i, R12
Application Servers: 10g Application server, SSO, weblogic
O/S: Windows, Linux (RHEL,OEL)
RDBMS: Oracle 10g
FMW: SOA,ODI, OBIEE,weblogic
Tools: Oracle Enterprise manager, Informatica, DAC
Content Management: Oracle Enterprise content management
Security: Oracle Database Vault, Label Security and Audit vault, EUS
PROFESSIONAL EXPERIENCE
Confidential, OakBrook, IL
Oracle Apps DBA/BI DBA/ADMIN
Environment: OBIA, ODI, WebLogic, Oracle Apps R12, oracle Database 11g RHEL 5
Responsibilities:
- Responsible for support for OBIA and Oracle Database 11g as BI DBA/ADMIN
- Interaction with Oracle Support Services to resolve mission critical issues
- Providing process driven support to end users and application developers.
- This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.
- OBIA upgrade/Implementation, migrating INFM to ODI
- Responsible to provide Production Support after Go Live as well.
- OID Administration, EUS support
Confidential, Augusta, GA
Oracle Apps DBA
Environment: Oracle Application Server10g, FMW11g, LINUX
Responsibilities:
- Responsible for Migrating portal and OID to new setup and upgrade it to FMW11g
- End to End implementation of Application server10g OID,SSO,&PORTAL.
- Virtual Name and SSLing.
- Upgradation of 10g Application server to FMW11g.
- This implementation also includes database upgradation from 10g to 11gR2.
- Interaction with Oracle Support Services to resolve mission critical issues
- Providing process driven support to end users and application developers.
- This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.
- Interacting client to understand business requirements and mapping the same to Oracle Applications.
- Responsible to design the project & provide solutions
Confidential
Oracle Apps DBA
Environment: Oracle 10g, Oracle R12.1.1, Oracle Apps 11.5.8 on Windows serverProject: Oracle Apps 11i to R12 upgradation
Responsibilities:
- End to End upgradation of Oracle Apps 11.5.8 to R12.1.1
- Basic database & APPS environment troubleshooting
- Acknowledging the support requests as per SLA.
- Resolving the issues reported on Development and Production environments.
- Troubleshooting problems reported with technology stack components.
- Troubleshooting and fixing problems with concurrent managers.
- Cloning and Refresh of the non-production instances from production instance.
- Merging the patches.
- Patching the instances.
- Planning the technical activities lined up for the regular maintenance and provide steps for execution
- Interaction with Oracle Support Services to resolve mission critical issues
- Providing process driven support to end users and application developers.
- This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.
Confidential
Associate Consultant
Environment: Oracle 10g, Oracle R12.0.4, Linux, SOA
Responsibilities:
- End to End Implementation of Oracle R12.0.4 installation in HDNL Servers
- Performing Weekly Database and Application Backups
- Basic database & APPS environment troubleshooting
- Monitoring Oracle Applications Instance and Oracle Databases
- Trouble shooting Oracle Applications Issues
- Backup and recovery via RMAN & Snapshot backup
- Patching databases and applications on various platforms
- Interaction with Oracle Support Services to resolve mission critical issues
- SOA Administration and Troubleshooting
- Providing process driven support to end users and application developers.
- This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.
- Daily Health Check of SOA Environment and Non SOA Environment.
- Oracle R12.1.1 installation in TDIC server
- Installation Oracle database 10g and Stellent (UCM)
- Installing Database Vault and Audit Vault and Configuring both
- Integrating Database Vault with Oracle R12.1.1
- Creating Realm of Restricting unauthorized user to access other tables
- Configuring Audit Vault of R12.1.1
- Integrating content Management with Microsoft Dynamics.
- Configuring UCM
- Applying Extra modules as per requirement.
- Workflow configuration for Content management.
- Administration of Stellent product
- Creating users, user grants and application appropriate privileges, maintaining Database & application security
- Monitoring tablespace and extent growth
- Monitoring Oracle Applications Instance and Oracle Databases
- Trouble shooting Oracle Applications Issues
- Cloning R12 application from Multi node to Single Node
- Backup and recovery via RMAN & Snapshot backup
- Applying Patches on Database and Application level.
- Interaction with Oracle Support Services to resolve mission critical issues
- Providing process driven support to end users and application developers.
- This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.
- Performing Weekly Database and Application Backups
- Installation Oracle Applications from 11.5.10.2
- Installation of Logon Manager Administrative Console and Agent
- Configured the Oracle Logon Manager to contribute with Various Applications
- Patching and upgrading databases and applications on various platforms
- Cloning using Rapid clone, manually clone, Autoconfig and adclone utility
- Administration of Oracle Apps using ad admin utilities
- Creation of Concurrent Mangers, Programs, and Request sets
- Creating users, user grants and application appropriate privileges, maintaining Database & application security
- Monitoring tablespace and extent growth
- Hot and Cold Backup and Recovery of the database
- Configured ESSO Setup in the Application Server
Confidential
Responsibilities:
- Oracle R12 installation in Harvest server
- Performing Weekly Database and Application Backups
- Installed Arabic patch and Translated patch in Harvest server
- Worked on Oracle R12 Cloning
- Basic database & APPS environment troubleshooting
- Monitoring Oracle Applications Instance and Oracle Databases
- Trouble shooting Oracle Applications Issues
- Cloning R12 application from Multi node to Single Node
- Backup and recovery via RMAN & Snapshot backup
- Patching databases and applications on various platforms
- Interaction with Oracle Support Services to resolve mission critical issues
- Providing process driven support to end users and application developers.
- This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.