Post Job Free

Resume

Sign in

Manager Oracle

Location:
Naperville, IL
Posted:
December 14, 2016

Contact this candidate

Resume:

Imran Khan

SUMMARY

Over ** years of IT full life-cycle implementation, support, and development experience working as Oracle 11i, Rel 12 ERP Architect on FINANCIALS, SUPPLY CHAIN, MFG, HRMS, Payroll, Order Management, CRM, iStore, iPayment modules. Over 9 years of experience as 10g/11g Oracle Application Server Architect working on Fusion Middleware and SOA suite of products. Professional skilled in project management and people management and experienced in all aspects of the system development life cycle (SDLC). Delivered quality, flexible, maintainable, solutions meeting stakeholder expectations, within cost and time budgets and can concurrently manage many projects.

Extensive experience in Cloud Life Cycle Management technology( HyperGrid ) and Migration Strategy. Extensive working knowledge of Oracle Pre-engineered system such as Exadata, ExaLogic, ZDLRA, Private Cloud Appliance and Oracle Cloud Technology.

Proven record of design, implementation, installation, migration, upgrade and support of database designs, Oracle server Installations and migrations (12c/11g/10G/9.x/8.1.x/8.0.x/7.x), Oracle Applications Rel 12 and (11.5.10.2/11.5.x/11.0.3) Installations, Migration & Upgrade, Oracle 9iAS/10G/11g Application Server setup & installation, Oracle Portal 9i/10G/11g, Discoverer 4.x/3.x setup & installation, Oracle Enterprise Manager 12c/10G/9.x/2.x. Experience and expertise in Oracle Applications System Administration, Oracle Workflow, Oracle Self Service Web Applications including iSupport, Parallel Concurrent Processing, Multi Node/Single Node Cloning of Oracle Applications, Application Tuning, Patching, Security Administration, Data Architecting, Integration of Oracle Internet Directory and Oracle Single Sign On using OAM,OID, OIF, Webgate and Accessgate with Oracle E-Business Suite 11i and Rel 12, Integration of OTM (Oracle Transportation Management) 5.5 with Oracle E-business Suite Rel 11i and Rel 12 and Oracle BPEL Process Manager on Fusion Middleware.

Proficient in Space Management, Capacity Planning, Change Management, Backups and Recovery, RMAN, Disaster Recovery, Database and Applications Performance Tuning, Oracle Standby Server, Oracle 9i/10G Data Guard, Oracle 9i/10G/11g/12c RAC with Automatic Storage Management, Oracle Replication using Golden Gate 11g Multithreaded servers, Index and Cluster Partitioning. Expertise in using packages like Smart DB, Schema Manager, EMC DM, Veritas Clusters, RAID, BCV, SRDF, ZDLRA.

CLOUD SKILLS:

Project Management

Cloud Assessment

Cloud Environment Deployment

Big Data /Hadoop

Process Automation (Chef)

IAAS/PAAS/SAAS/DAAS

Amazon Web Services (AWS)

Oracle Cloud

Cloud Life Cycle Management Tool (DCHQ)

Cloud Architecture Design

Cloud Security Design

Pre-Sales Activities / Sales

IP Routing / Configuration

MySQL

Cloud Orchestration

TECHNICAL SKILLS:

Operating Systems

Sun Solaris 6,7,8,9. HP-UX 11.x/10.2, Red Hat Linux Advanced Server 3.0/4.0, SUSE Linux SLES9, IBM AIX 5L, Windows 2000/NT 4.0, Oracle Linux

Databases:

ORACLE 12c/11g/10G/9.2.0.x/8.1.x/7.x

Hardware:

Sun Sparc E4500, HP 9000, IBM RS6000, IBM eServer (P5 590/595/575), Compaq Proliant 3000, Dell Power Edge 4200/6200, EMC, IBM Tivoli Storage Management, Storage Area Networks, Veritas Cluster, VMware, Exadata, ExaLogic, ZDLRA, PCA.

Client Server Tools:

Developer 6i, Developer 2000, Forms (6i/4.5), Reports (6i/2.5), Discoverer 4i

SOA Fusion

Technologies

Oracle ADF, ADF Faces, ADF-BC, Task flows, Portlets, MDS, Web-Services, WSDL, JAX-WS,

JAX-RPC, BPEL, BPMN, XSD, XSLT, Human task, Business Rules, Mediator, Adaptors, MVC,

Servlets, UCM, SES

Products/Languages:

Oracle Applications (11.5.1-11.5.10.2, 11.0.3), Oracle 10G/9i Application Server, Oracle Workflow 2.6, PeopleSoft 7.5, Apache 1.3.x/Jserv, PL/SQL, SQL*Plus, Designer 2000, Unix Shell Scripting, PeopleCode, Java/JSP, HP Outerbay, Appworx, OWB with B2B, WebLogic Cluster, Oracle RTD, Fusion Middleware 11g R1/R2

DBA Tools:

Oracle Enterprise Manager, Oracle Applications Manager, RMAN, Toad, Clear Case Version control Software, PVCS Serena Version Manager, Smart DB, DBARTISAN, SQL Backtrack

Application Modules:

Oracle General Ledger (GL), Oracle Receivable (AR), Oracle Order Entry (OE), Oracle Purchasing (PO), Oracle Payable (AP), Oracle Assets (FA), Oracle Project accounting (PA), Oracle Bill of Materials (BOM), Order Management (ONT), Oracle Advanced Pricing (QP), Oracle Shipping (WSH), Oracle Work In Progress (WIP), Supply Chain Management (SCM), Oracle Manufacturing (MFG), Oracle Inventory (INV), Oracle Human Resources (PER), Oracle Payroll (PAY), Oracle Service (CS), Self-Service Web Applications (ICX), iProcurement, iSupplier, iExpense, iStore, iPayment, Oracle Time and Labor(OTL), Advanced Benefits(BNE), Fast Formula(FF)

Education

Master of Science in Computer Engineering, Wayne State University, Detroit, MI – May 1994

Bachelor of Science in Electrical Engineering, N.E.D. University of Engineering and Technology, Karachi, Pakistan, August 1989

MAJOR RECENT ASSIGNMENTS:

GE Aviation, Cincinnati, OH July 2014 – Oct 2016

Title: Senior ERP Application Architect

Applications/Database/Tools: Oracle E-business Suite Release 12.1 and 12.2, Oracle 11g/12c, Data Guard, Endeca, SOA Suite, Webcenter, Demantra, Exadata RAC Database, ExaLogic, ZDLRA, PCA, GE Resiliency initiative for High Available and Disaster Recovery

Responsibilities as Lead Architect:

Oracle/SAP ERP Architecture/Tech Refresh/Upgrade/Implementation

Provided leadership, direction, support and consultation for Oracle ERP system across Aviation landscape.

Function as resident expert in architecture, design, implementation and deployment of technical and functional solutions for enterprise leaders within Aviation.

Designed and Developed Technology ERP Roadmap for upcoming Tech Refresh planning and operations and support vision with engineered system such as Exa Stack and SAP HANA Appliances.

Developed over all financial business case and estimated ROI of the application and infrastructure optimization solutions based on new platform.

Managed Platform and Product Services Budgeting process across all Aviation ERP and echo system.

Served as subject matter expert across technology/function within Aviation business and drove the implementation of technology strategy and road map direction.

Developed road map of the evolution of the enterprise application portfolio from current to future state (as defined by the Security, Technology and Architecture Governance Teams)

Developed roadmap of the evolution of the Data and Security application portfolio and capability from current to future state

Facilitate the evaluation and selection of software product standards, as well as the design of standard software configurations

Participated in various governance forums to advocate and educate sound data and security governance policies

Established Security Architecture, standards and governance models related to internal, B2B and external data/application access and integration.

Demonstrated and Presented product / program strategies, technical roadmaps, risks, and recommendations to senior leaders (EB and SEB) within technical space and to senior leaders across GE.

Contributed to highly complex projects that require in-depth domain knowledge.

Influenced engagement and decision making with external parties.

Reviewed emerging technologies and software trends as well as infrastructure tool sets across and provided recommendations and new selections influencing purchase decisions.

Fostered strong relationships within GE teams and industry experts, participated in roundtable conferences, work out sessions, presentations, coached and mentored staff.

Defined complex technical platforms utilizing modeling principles for best practices and ensuring coherence across all aspects of the IT architecture framework an underlying taxonomies.

Presented Enterprise Mobile Platform for ERP at GE Tech Time

Driving UX and mobile application design solutions for ERP based Applications.

Architect/Lead and Initiated Aviation First successful Oracle ERP Centerpiece ( ASCP, OLTP ) upgrade from Rel 12.1.3 to 12.2.4 with 12c database on Solaris and rolled out to Production in 3 months. Designed and proposed the complete new Architecture for Rel 12.2.4. Drove all activities related to execution. This was the fastest upgrade in the history of Oracle and was presented at the Open world 2015.

Designed, Architected and Lead the overall ERP cloning process for entire Aviation ERP system and improved the cloning process significantly by improving the time from 48 hours to 2 hours. This is a unique design and worked with Oracle Pre-engineered systems such as Exadata, Exalogic, ZDLRA and PCA.

Lead and Initiated Exadata/ExaLogic POC on GE P&W hardware. Migrated Centerpiece ASCP and OLTP ERP system on Exadata/Exalogic on a 3 months period. Ran ASCP Planner and MRP Planner with huge performance gain from 2.5 hours to less than 30 mins. Over all performance of both OLTP and ASCP system increased by 96%. Drove all activities related to execution.

Lead Architect for Aviation FASTTRACK Exadata/ExaLogic migration for Centerpiece ASCP and OLTP in 8 days. This was a special project sponsored jointly by Oracle and GE Aviation to showcase in Open World and to showcase how fast you can migrate to Exa stack platform from Sun Solaris. This was a unique project of its kind and went very smooth. 12c In Memory Database option was turned on for both ASCP and OLTP. Oracle In Memory Advisor was installed and used for reporting on the objects to be put in memory.

Lead Design and Architecture for Migrating Aviation Solaris SAP System to Exadata and Vmware. Initiated SAP HANA appliance vendor selection based on Core-tech mandate and generated RFQ for vendor selection based on hardware specs, support model and services. Directing initiative to re-platform from Solaris to Linux x-86 on Exadata and Application on Vmware. The new proposed architecture saved nearly $600K yearly from $1M yearly current cost.

Lead GE CAS initiative for Resiliency to test Disaster Recovery for all ERP system. Planned, designed, documented and initiated Disaster Recovery Plan for over all Aviation system and implemented with complete user testing. New record RTO and RPO was reported ever in the Aviation industry. The Architecture was based on Oracle Dataguard design and replicated the data between Governers Hill data center and Alpharetta Data center.

OBIEE/ENDECA/Hyperion Lead Architect

Architected and Lead Technical Architecture for Endeca integration with E-Business Suite Rel 12.2.4

Installed, Configured and deployed Endeca with Oracle E-Business Suite Rel 12.2.4.

Designed a High Availability Architecture for Multi Tier install for Endeca and OBIEE.

Work with Onsite and Offshore Technical Apps Tech team for migrating Endeca extentions from one instance to another.

Implemented Clone process for Endeca/OBIEE based system with E-Business Suite.

Implemented backup strategy for Endeca/OBIEE applications and Database system.

Implemented/Installed/configured Hyperion 11.1.2.4 on Widows VM and integrated with E-Business Suite Rel 12.2.5 using Oracle Data Integrator.

Installed/Configured ODI on Windows VM and used ODI Studio to manage and maintain the connectivity between Hyperion/E-Business Suite.

Installed and Configured SSO using OAM with Hyperion 11.1.2.4 and tested the user experience with Kerberos based authentication.

AWS Cloud Lead Architect:

•Leading AWS based cloud architecture for Enterprise Batch Processing (EBP) of ERP and upgrading the application from 12.1.3 to 12.2.4.

Architected Oracle E-Business Suite ERP applications with the use of AWS services like EC2, RDS, S3, EBS, ELB, IAM, SNS, Route53, CloudWatch and CloudFormation. ERP architecture also features enhanced services as SOA, OTM and SWF.

Helping team with the automation of Cloning of ERP architecture utilizing Chef automation engine and using its attributes, cookbooks and recipes.

Helping leadership in cost control with effective measure and matrices on the usage of various AWS services and ensuring proper Cloud Guardian policies are enforced for best practices.

Mentoring and teaching team on ERP AWS architecture and bringing them up to the speed.

Bringing the best practices of ITIL Services framework with Cloud architecture to ensure that we developed a service-centric cloud ERP solution with effective monitoring, SLAs, release and configuration management aspects.

SouthWestern Energy, Houston, TX Sep 2013 – Jan 2014

Title: Lead Oracle Apps/Project DBA

Applications/Database/Tools: Oracle E-business Suite Release 12.1.2, Oracle 11g GRID OEM, Data Guard, OAM, SOA Suite, OID, OIF, Webgate, Accessgate on Fusion Middleware on Oracle Linux 5, Exadata RAC Database, High Available and Disaster Recovery

Responsibilities as Lead Oracle Fusion Apps DBA:

Involved in Building the infrastructure for hosting Corporate E-Business site running on Application Stack with with Multi Tier architecture on Oracle Linux and Exadata RAC Database.

Installed, implemented and integrated with Oracle Access Manager( OAM ) with OID, SOA Suite, OIF 11gR2 Patchset 1, using Oracle Access Manager WebGate and Oracle E-Business Suite AccessGate.

Fusion Middleware 11.1.3 with OAM, SOA Suite, OID, OIF Webgate and Accessgate

Installed and Configured High Availability 4 Node WebLogic Clutser for OAM, SOA Suite, OID, OIF Webgate and Accesgate with RAC database and integrated E-Business Suite Rel 12.1.3 Single Sign on Solution for the DEV, TEST and PROD instances.

Setup High Availability Multi tier Oracle Fusion Middleware server for OPMN managed components with Active-Active Topology with Load Balancing and Failover features.

Installed Configured High Availability RAC database failover plan using 11g R2 physical standby database and maintaining through Dataguard.

Implemented and configured OID Replication using Golden Gate 11g R1.

ACCO Brands, Lincolnshire, IL Mar 2012 – Aug 2013

Title: Lead Oracle Apps/Project DBA

Applications/Database/Tools: Oracle E-business Suite Release 11.5.10.2, Oracle 10g GRID OEM, Data Guard, BCV, Oracle BPEL Process Manager on Fusion Middleware, Oracle Transportation Management 5.5 CU3 RUP4 with Oracle 10g R2 on Linux, Oracle Application Server as OTM App Tier, Oracle Application Server 10g R2 for Reports, PC*Miler, Rand McNally, SOA Suite,OWB and B2B, Oracle Access Manager 11g R2 ( OAM ).

Responsibilities as Lead Oracle Fusion Apps DBA:

Involved in Building the infrastructure for hosting Corporate e-Business site running on Oracle Application Server 10.1.3.3 Multi Tier architecture on Red Hat Linux Cluster for US and Canada System

Involved in designing the architecture for hardware and Software for their corporate and other Business sites.

Involved in defining the Code migration methodology and governing patching strategy as per SOX compliance.

Implemented shared (appl top, common top and Oracle 806, iAS Home) across 6 application tiers to minimize patching downtime.

Installed, implemented and integrated with Oracle Access Manager( OAM )11gR2 Patchset 1 using Oracle Access Manager WebGate and Oracle E-Business Suite AccessGate.

Have been responsible for conducting RAC certification test to simulate all possible disaster scenarios and have provided detailed documentation on the certification and the recommendations.

AWS Cloud Architect:

•Leading AWS based cloud architecture for ERP and migrating the application from 11.5.10.2 as Proof of Concept

•Worked on Scrum style agile boards which helped us to create and track our delivery and production support stories for designing new ETK architecture on AWS Cloud using Amazon VPC, EC2, Route 53 and S3 and EFS Storage.

•Created Amazon IAM roles and group and performing policy attachments to the DOT groups as well as to the EC2 instances to access the S3 buckets using Amazon APIs.

•Designed VPC with private and public subnets and attributing appropriate Security Gateways to the instances on various nodes in the subnet for additional layer of Security. Started to use Amazon Lambda for a server-less configuration on Amazon Cloud.

•Setup performance and code deployment tools and alarms like Cloudwatch, CloudFront and OpsWorks to automate code deployment using Puppet and Chef.

Interacted with Business and Product owners, in facilitating business requirement and engaging business analysts in approving these requirements and building a Product Backlog with the Product Owner.

Designed and Architected integrations with the ERP and connectivity to AWS Cloud.

Helping leadership in cost control with effective measure and matrices on the usage of various AWS services.

Mentoring and teaching team on ERP AWS architecture and bringing them up to the speed.

Fusion Middle Ware 11.1.3 with B2B

Installed and Configured Oracle B2B Rel 11g SOA Suite Fusion Middleware for their PROD, DEV and TEST instances.

Installed, configured and setup Oracle RTD on Weblogic server. Administer Domains, manage users, and create datasources for RTD.

Architecting and designing Oracle SOASuite, OSB and/or J2EE solutions.

Have implemented complete backup strategy for all controlled and non-controlled instances, this includes BCV setup for OTM and FUSION Production instance.

Setup High Availability Multi tier Oracle Application server Cluster for OPMN managed OC4J components with Active-Active Topology with Load Balancing and Failover features.

Maintained and Administer Web services, XML and MQ.

Performance tuning for all Fusion Middleware Product including Hyperion, SOA Suite, OAM, OID, Accessgate and Webgate application.

Responsible for creating all required Solution Delivery Methodology (SDM) documentation including: requirements documentation; unit test cases; code and construction documents; code walkthrough documentation; load and performance testing; and user acceptance testing.

Responsible for resolution of application defects.

Maintaining and expanding current functionality. Application Release Planning. Requirements gathering/discovery. Participate in Testing Teams for unit testing, system testing, and load and performance testing.

Administrate and maintain cluster based Weblogic server environments.

Deploy code to development, testing and production environment.

NEC, Downers Grove, IL April 2011 – Mar 2012

Title: Project Apps DBA

Applications/Database/Tools: Oracle E-business Suite Release 12, Oracle 10g (2 Node RAC ) on IBM AIX version 5.3 Server, HRMS, FF, OAB and PAY Module, OBIEE

Responsibilities as Project Apps DBA:

Involved in Building the infrastructure for hosting Corporate e-Business site running on Oracle Application Server 10.1.3.3 Multi Tier architecture on AIX Cluster for US and Canada System.

Involved in designing the architecture for hardware and Software for their corporate and other Business sites for moving the infrastructure from AIX to Linux based platform and how to minimize the downtime.

Implemented shared (appl top, common top and Oracle 10.1.2, 10.1.3, iAS Home) across 6 application tiers to minimize patching downtime.

Installed, Configured Oracle Business Intelligence ( OBIEE ) Rel 11g for reporting for end users integrated with E-Business Suite and other data warehouse system

Migrated AIX servers from Canada Colo to Atlanta and re-platform them on Linux Redhat servers for E-Business Suite Application and Database Rel 12.1

Involved in the Database upgrade from 10.2.4 to 11g Rel 2 using ASM, automatic storage management.

Configured their production & non production databases for adequate performance and high availability using Disaster Recovery Planning with Active/Passive setup.

Datavail Corporation, CO Oct 2009 – Jan 2011

Title: Performance Tuning Apps DBA

Applications/Database/Tools: Oracle E-business Suite Release 12, Oracle 9, 10g, 11g ) on IBM AIX version 5.3 Server, Sun Solaris 10

Responsibilities as Performance Tuning Apps DBA:

Client Arrow Electronics Oct 2009 – Jan 2010

Involved in heavy performance tuning of the whole E-Business Suite Environment, including hardware, Concurrent jobs, SQL Tuning, packages and procedures. Different tools and methods used for this project, including nmon analyzer, Grid Control, DBMS_PROFILER, AWR Reports.

Resolve database performance issues, database capacity issues and other distributed data issues.

Designed, developed, plan and implemented the technical database design of detailed system components; such as Oracle ERP applications Rel 12, other enterprise business applications, interfaces, customized process.

Developed system management procedures, measure and performance indicators and customer performance measures and lead DBA's in the installation of patches, upgrades and installation of application databases and other projects, ensuring that designs fall within the technical framework.

Troubleshoot Problems with concurrent managers, Apache, Jserv processes, forms, reports and Database performance.

NEC, Downers Grove, IL July 2008 – Oct 2009

Title: Lead Apps Implementation DBA

Applications/Database/Tools: Oracle E-business Suite Release 12, Oracle 10g (2 Node RAC ) on IBM AIX version 5.3 Server, OAM, HRMS, FF, OAB and PAY Module

Responsibilities as Lead Apps Implementation DBA:

Involved in implementation the infrastructure for hosting Corporate e-Business site running on Oracle Application Rel 12 Multi Tier architecture on IBM AIX 5.3 Platform for US and Canada System.

Implemented data models and database designs, data access and table maintenance codes; resolve database performance issues, database capacity issues and other distributed data issues.

Designed, developed, plan and implemented the technical database design of detailed system components; such as Oracle ERP applications Rel 12, other enterprise business applications, interfaces, customized process.

Worked with various application groups to gather requirements, coordinate timelines, and plan overall database management and support.

Developed system management procedures, measure and performance indicators and customer performance measures and lead DBA's in the installation of patches, upgrades and installation of application databases and other projects, ensuring that designs fall within the technical framework.

Support Functional and RICE (Reports, Interfaces, Conversions, and Extensions) teams for trouble-shooting and identifying the bugs and patches required.

Troubleshoot Problems with concurrent managers, Apache, Jserv processes, forms, reports and Database performance.

Involved in designing the architecture for hardware and Software for their corporate and other Business sites.

Involved in defining the Code migration methodology and governing patching strategy as per SOX compliance.

ACCO Brands, Lincolnshire, IL Apr 2007 – July 2008

Title: Sr. Oracle Applications Lead DBA

Applications/Database/Tools: Oracle E-business Suite Release 11.5.10.2, Oracle 10g GRID OEM, Data Guard, BCV, OAM, Oracle BPEL Process Manager on Fusion Middleware, Oracle Transportation Management 5.5 CU3 RUP4 with Oracle 10g R2 on Sun Solaris Cluster, Oracle Application Server as OTM App Tier, Oracle Application Server 10g R2 for Reports, PC*Miler, Rand McNally,OWB and B2B

Responsibilities as Sr. Oracle Applications Lead DBA:

Involved in Building the infrastructure for hosting Corporate e-Business site running on Oracle Application Server 10.1.3.3 Multi Tier architecture on Sun Solaris 9 Cluster for US and Canada System

Involved in designing the architecture for hardware and Software for their corporate and other Business sites.

Involved in defining the Code migration methodology and governing patching strategy as per SOX compliance.

Implemented shared (appl top, common top and Oracle 806, iAS Home) across 6 application tiers to minimize patching downtime.

Have been responsible for conducting RAC certification test to simulate all possible disaster scenarios and have provided detailed documentation on the certification and the recommendations.

Involved in the Database upgrade from 9.2.0.7 to 10.2..0.4 using ASM, automatic storage management.

Configured their production & non production databases for adequate performance and availability

Have installed and configured Oracle 10g OEM for monitoring various components of the e-business suite and 10g database.

Work with Oracle Worldwide Support on Tars to resolve customer issues.

Prepared the Document and Engagement Summary as per their Architecture.

Involved in setup DNS Servers for their various e-Business sites.

Involved in design and setup/configuration of DMZ zones and core network architecture.

Involved in Support and Maintenance of Oracle Financials 11.5.10.2 on Multi tier Sun Solaris 9 Cluster architecture.

Upgrade their 11i Tablespace structure as per new OATM (Oracle Applications Tablespace Model).

Setup and defined the Oracle Application Java Workflow notification mailer and monitored the activities through OAM.

Migrate and promote the data between instances using WFLOAD, FNDLOAD utilities.

Support Functional and RICE (Reports, Interfaces, Conversions, and Extensions) teams for trouble-shooting and identifying the bugs and patches required.

Troubleshoot Problems with concurrent managers, Apache, Jserv processes, forms, reports, Discoverer and Database performance.

Installed and configured Oracle Diagnostics utility for Proactive Maintenance of Production system.

Performed all Applications System Administration tasks like registering new forms, reports, Setting Profile Options, Creating/Assigning Responsibilities, and Creating APPS Users etc.

Define new Printers and fixing other Printer issues.

Set up the Access control with Oracle User Management which includes Function Security, Data Security, Role based access control, delegated administration etc.

Setup and defines the role categories, defined data security policies.

Defined the Oracle Application object library security which includes defining a request security group, user session limits, case sensitivity in Oracle Applications user passwords.

Involved in defining the Function and Menu security.

Setup the User and Data Auditing which includes setting up Sign on Audit, Reporting on Audit trail data and defined the various Sign -On Audit concurrent requests.

Implemented Multi Node DR setup with 10g Data Guard for their Oracle E-Business suite project.

Implemented PCP (Parallel concurrent processing) for their production instance to load balance concurrent requests across 2 nodes.

Heavily involved in defining the Code migration methodology and governing patching strategy as per Quality compliance.

Work with Oracle Worldwide Support on Tars to resolve customer issues.

Prepared the Document and Engagement Summary as per their Architecture.

Managed and supported offshore team for all daily, weekly and monthly activity for patching, cloning, monitoring.

OTM(Oracle Transportation Manager ) CU3 RUP4

Designed the Architecture on Intel Red Hat Linux for their Production, Development and Test instances.

Installed and configured OTM 5.5 CU2 on DB, Application and Web server (Single Node) for their TEST and Development Instances.

Installation and Integration of Oracle Application 10gR2 Forms and Reports Services with OTM 5.5

Installed and Configured Multi Node Production instance of OTM on 3 Node.

Involved in Integration and Setup of OTM 5.5 with Oracle E-Business Suite and Oracle BPEL Manager as integration layer for TEST and DEV instances..

Upgraded OTM 5.5 CU2 to CU3 RUP4. Responsible for moving OTM 5.5 CU3 RUP4 to a 64 Bit architecture.

Tuned OTM tomcat JVM and OAS memory, other glog.properties and OTM threads parameters for performance issues.

Building the infrastructure for hosting Oracle Transportation Management Logistics Solutions for ACCO Brands.

Involved in designing the architecture for hardware and Software Licensing Issues.

Involved in Sizing and Capacity Planning for their Inbound and Outbound shipments for Ogdensburg and Boonville Organization Units.

Fusion Middle Ware 10.1.2 and 10.1.3 with BPEL Process Manager

Installed and Configured Oracle BPEL Process Manager Rel 10.1.2 and 10.1.3 on Fusion Middleware for their PROD, DEVP and TEST instances.

Have implemented complete backup strategy for all controlled and non-controlled instances, this includes BCV setup for OTM and FUSION Production instance.

Setup High Availability Multi tier Oracle Application server for OPMN managed OC4J components with Active-Active Topology with Load Balancing and Failover features.

Setup High Availability Multi tier Oracle HTTP server with Active-Active Topology with Load Balancing and Failover features.

Configured BPEL Process Manager with SOA Management Pack for monitoring using Grid Control 10g.

Installed and Configured AD4J for monitoring Java Heap and Fusion Middle Ware performance.

Tuned BPEL Process Manager configuration for different domains configured in the system.

Wrote monitoring scripts for process going into BPEL Recovery and alert the user to take action.

Integrated with E-Business Suite 11.5.10.2

Data warehouse with OWB

Installed and Configured Oracle Workflow Builder and integrated with Fusion Middle Ware and B2B

Maintenance of Data warehouse database, creating materialized views and refresh snapshot.

Created table partition and index partition for monthly and yearly dimension tables.

Configured Control Center for Oracle Workflow Builder.

Troubleshooted all performance related issued to datawarehouse.

Solo Cup, Highland Park, IL July 2006- April 2007

Title: Oracle Applications Lead DBA

Applications/Database/Tools: Oracle E-business Suite Release 11.5.10.2, Oracle 10g GRID OEM, BCV, Oracle Application Server 10g R2, Discoverer.



Contact this candidate