SUMMARY:

• Well experienced Database management involving Oracle Applications(ERP)+DB and fusion technology using different methodologies Oracle Unified Method(OUM), AIM and agile
• Project Management professional - PMP Certified
• Expert in setting up and managing onsite/offshore 24x7 managed services(support)
• Involved in Sales initiatives, played the role of solution architect, resource allocation planning, PMO office, created proposals and presented in Orals.
• Managed massive 11i, R12 implementation projects, and multiple upgradation projects to R12.2 and databases to 12c
• Upgrade and implementation specialist.
• Expertise in configuring and maintaining Oracle Apps Modules like financial GL, AP,AR, FA, CE, manufacturing, distribution, ASCP and maintaining a Advanced Planning and Scheduling (APS) instance separate from OLTP instance.
• Senior in the Emerging Technology group in Confidential Americas.
• Well versed in Oracle APPS DBA, Unix shell scripting, JSP, Java and OC4J,
• All Fusion middleware SOA-BPEL, Jdeveloper, Demantra, OBIEE, Hyperion, Oracle Access manager, OID, Oracle Transportaion Management(GTM), weblogic.
• Excellent communication skills, strong analytical and logical abilities in business analysis and technical documentation
• Well versed with Sarbanes-oxley and HIPPA
• Proficient in Microsoft MS PROJECT, EXCEL, WORD, powerpoint, VISIO, ACCESS
• Global cross culture work experience in GE-ITALY, SONY- Japan and various cities in USA and India.

PROFESSIONAL EXPERIENCE:

Confidential

Database Architect, Tampa, FL

Responsibilities:

• Maintained and supported Oracle ERP R12.2, Exadata, RAC 12c, fusion applications ( SOA, OBIEE, Hyperion, SQL server, .NET )
• Involved in installation and mainteance of Oracle OEM(cloud control 12c) on all the targets, DB, cloud DB, ASM, Goldengate, OBIEE, Hyperion on windows system using psexec, masking of downstream using OEM.
• Initiated conferences with Oracle and primary in installing Oracle Advanced Support Gateway as part of Platinum services. Negotiated best cost value proposition with Oracle.
• Designed the complete new architecture of ETL processes using Informatica Mappings and Oracle data integrator ODI + Goldengate 12c for both OBIEE and Hyperion EPM.
• Redesigned the external pricing module data loading with PL/SQL triggers, packages and automated them with Unix shell scripting and concurrent manager reports
• Improved the performance of huge amount of data operations in PL-SQL by using bulk binding collect, FORALL, PL/SQL Function Result Cache, Subprogram Inlining, NOCOPY hint, DBMS PARALLEL EXECUTE
• Re-designed triggers based on business logic using trigger follows and compound triggers
• Involved in the following projects.
• Executed the oracle 12c upgrade project for all the 20 Oracle instances their standby(s) and downstream.
• Upgrade the EBS instances from R12.0.4 to R12.2
• Install and maintain HCM and WFM
• Consolidate all the 3 rd party Financial applictions and migrate GL to a single oracle EBS
• Migrate and maintain edition based database and file system and applied patches using adop.
• Move custom dev objects from dev to prod patch edition and then to run edition.
• Migrate all tablespaces to TDE encryption enabled
• Manage projects like consolidate all the 3 rd party Financial applictions and migrate GL to a single oracle EBS
• Built a robust DR strategy with Dataguard.
• Install BMC software for enterprise wide scheduling and workflow.
• Install and maintain Goldengate (using Integrated capture and Integrated replication on ACFS) and data transfer from OLTP to BI instances
• Install and maintain data vault
• Backup/recovery and cloning of downstream environments using RMAN, Commvault. Found an Oracle bug that does not recover 11g TDE encrypted file and raised SR with Oracle deliver the fix for both exadata and downstream RHEL.
• Financial Modules supported - R12.2 GL, AP, AR, CE, FA, INV, OTM/GTM, Hyperion, OBIEE

Confidential

Senior Oracle Apps DBA, cleaveland, OH

Responsibilities:

• Upgraded Oracle applications from 11i, R12 to R12.1.3
• Configured the p2p and o2c life cycle.
• Upgraded Oracle databases to 11.2.0.5, 12c
• Experience in Oracle versions from Oracle 12c\11G\10g\9i\8i.
• Installed HCM for multiple clients
• Developed automation scripts for multiple support operations.
• Manage the sucessful transition operation of Keybank leasing, SUNGL, Supertrump, procurement and financials, ariba systems from previous vendor (Wipro)
• Prepared SLAs, Lead iTAR- access security initiative
• Design and implement application aware Oracle RAC Active/Active Service based infrastructure on exadata.
• External pricing module data loading with PL/SQL triggers, packages and automated them with Unix shell scripting
• Configure and troubleshoot SCAN listener.
• Backup/recovery and cloning of downstream environments using RMAN, Commvault.
• T roubleshooting various RAC issues include node eviction, HAIP Configuration, OCR Voting disk recoveries using crsctl and srvctl utilities
• Apply exadata, crs, asm, rdbms, erp patching using rolling patch patchmgr, opatch and adpatch
• Architected the multi-standby (local and remote standby) configurations allowing the oracle client to transparently failover to local standby using Fast connection failover(FCF) and Transparent Application Failover(TAF)
• Configured and used the local standby database to offload read-only reporting purpose workload from the primary database using Active Data Guard, to offload fast incremental backups using Active Data Guard, to function as a test system using Data Guard Snapshot Standby, or to perform database rolling upgrades
• Perform Database cutovers using Oracle Data guard switchover
• Configure Oracle Golden Gate replication - Troubleshoot Golden Gate replication issues using log dump, Golden gate logs
• Designed the complete new architecture of ETL processes using Informatica Mappings and Oracle data integrator ODI + Goldengate 12c for both OBIEE and Hyperion EPM.
• Cloning apps tier and database tier for all ERP, OBIEE and hyperion downstream enviroments using rapidclone.
• Configure and maintain Oracle Streams AQ
• Develop and implement PLSQL interfaces that will perform AML risk score calculations and process more than million records using bulk collections.
• Also developed PLSQL and java interfaces to identify and alert AML activity for unsual large transactions, excessive bank dragt activity,
• Automated the process of generating Suspicious activitiy report (SAR) and Currency transaction report (CTR) and send to the Managers BI dashboard.
• Participated in CAB to propagate CRs from Dev to QA and then PROD.
• Was single point of escalation of all the support issues for the PROD and multiple nonprod instances in Confidential, Swiss Re, Wellcare, Cigna, Keybank for Xcelys, Oracle Financials accounting, OBIEE, Hyperion and been the point of escalation and contact
• Implemented Servicenow ticketing system for change management and incident management for production database system
• Vendor management(contractors) and mentored the onsite/offshore reportees.

Confidential

Senior Oracle APPS DBA, seattle, WA

Responsibilities:

• Managed the upgrade of Oracle applications from 11i, R12 to R12.0.6 US english and Canadian French using Agile methodology.
• Upgraded the database RAC on Exadata with dataguard/ASM
• Designed the production instance with BIG IP and separate web, forms, concurrent manager, database tier per requirements of the client. Also designed the development instances as they moved the whole instance from SUN OS to RHELinux using Agile methodology..
• Configure workflow for both out-bound and in-bound processing
• Moved single apps tier to shared appl top and load balance with Parallel concurrent processing(PCP)
• Configured DMZ external for isupplier module.
• Configured MWA dispatcher to load balance between 2 sets of 6 MWSA telnet ports
• Migrated the database and ERP from SUN OS to RHELinux.
• Architected the SSH option for Mobile web applications instead of Telnet.
• Innovative solutions like a custom jsp that can start/stop MWA in version 11.5.8
• Migrated the PROD system from non-RAID disks to RAID 10 disks
• Worked closely with Functional team to solve issues on Enterprise Budget and planning, payroll extract
• Managed cross functional team involving SQL server, Unix admin, Demantra, SOA-BPEL, Hyperion and lot of other Fusion applications.
• Prepared solution design, estimation and Configured Dataguard setups and Parallel concurrent processing
• Audited the installation of R12 PROD system running currently with HR and Payroll system
• Performed the monthly updates of Vertex.
• Vendor management(contractors) and mentored the onsite/offshore reportees.
• Upgrade from Oracle Internet Time (OIT) to Oracle Time & Labor
• Install Restricted HR to use it with OTL
• Upgrade the Oracle Internet Expenses (OIE) to patchset K
• Run datainstaller for loading data to HR tables that are related to OTL.
• Applied latest Daily Business Intelligence 7.3
• Install SOA 10.1.3.3 BPEL server in HA configuration and load balancing. Ensure that it is able to connect to the EBS and deploy custom Bpel applications using ANT
• Understand the usage of Jdeveloper and deploy it on development BPEL servers.
• Performance tuning using Gather schema statistics, partitioning data using Histograms (buckets)
• Involved in migrating from Jinitiator to SUN-JVM for Microsoft Vista desktops
• Solved the issue with French email approval by upgrading the xml parser
• Configure printers using CUPS
• Migrate custom objects
• Worked with network and functional team on the connectivity of Application Desktop integrator with the EBS.
• Solved the REP-3000 problem and the Confidential report publish problem by installing a x-server and propertly defining the Display parameters