SUMMARY

• Over 10 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, Oracle9iAS/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 11gMultithreaded servers, Index and Cluster Partitioning. Expertise in using packages like Smart DB, Schema Manager, EMC DM, Veritas Clusters, RAID, BCV, SRDF, ZDLRA.

• 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 DesignPre-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, and 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 (P 5 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)

PROFESSIONAL EXPERIENCE

Confidential, MI

Architect Specialist

Tools: Oracle 12c, Oracle Transportation Management, SAP HANA, WebLogic, OEN

Responsibilities:

• Analysis of upgrade strategies, Design and implementation of Oracle Transportation Management from 6.3.1 to 6.4.1
• Drive the upgrade process with hands on from OTM 6.3.1 to 6.4.1.
• Configured the entire system to High Availability and Scalability with multiple Web and Application server.
• Integrated with SAP PI and Rate Management Utility application to the upgraded 6.4.1.
• Copied Domain data from Test to Dev System.
• Performed performance tuning using load test and SAP PI integrated data.
• Setup monitoring and configured with Oracle OEM to measure and troubleshoot web and apps server
• Drive the overall cutover plan for migration and upgrade to 6.4.1

Confidential, TX

Cloud Database Architect

Tools: Oracle 11g/12c, Data Guard, Oracle Cloud, DBaas, Iaas, Backup as a Service, AWS, High Available and Disaster Recovery.

Responsibilities:

• Analysis of cloud strategies, Design and development of tools for Oracle Database deployment in Oracle Public Cloud (OPC).
• Drive the deployment of the customers Database workloads into Oracle Database Cloud Services by providing deployment guidance, supporting development of the customers cloud adoption model, and providing appropriate recommendations to overcome blockers.
• Took initiative to drive several POC’s with clients to show and implement Backup as a Service on Oracle Cloud from On-Prem databases. Restored the database on DBaas to test the D/R scenario and measure the RTO and RPO.
• Provided hands-on assistance to customers in design, implementation and rollout out Oracle Database and allied products to meet business needs.
• Installed and Configured OPC with On-Prem database on Cloud and integrated RMAN to run Backup of On-Prem database on Oracle Cloud as Backup as s Service.
• Lead deployment of projects, Creation and delivery of technical content, with dedicated focus on Oracle Database cloud services, and lift and shift of customer databases from On-Prem to Oracle Cloud and continuous synchronization with on-Prem databases.
• Designed and implemented Disaster Recovery for customer running OBIEE, SOA and other Fusion Middleware on Oracle Cloud Infrastructure as a Service with DBaas and Backup as a Service.
• Integrated Oracle Cloud with On-Prem SOA, OBIEE and ERP services by creating data sources.
• Hands on skills based onOracle Cloud, RAC, RMAN backup and recovery, Active Data Guard, Snap clone, enterprise manager and MAA and Performance tuning and code level technical trouble shooting.

Confidential, Cincinnati, OH

Senior ERP Application Architect

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, Confidential Resiliency initiative for High Available and Disaster Recovery

Responsibilities:

• 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 HighAvailabilityArchitecture for Multi Tierinstall for Endeca and OBIEE.
• Work with Onsite and Offshore Technical Apps Tech teamfor migrating Endecaextentions 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.
• Have implemented complete backup strategy for all controlled and non-controlled instances, this includes Snapshot setup for OTM 6.4.2 and FUSION Production instance.
• Upgraded and configured OTM 6.4.2 on Solaris 10 for the TEST and Development Instances.
• Installation and Integration of Oracle WebLogic Application 11g Services with OTM and E-Business Suite.
• Installed and Configured Multi Node Production instance of OTM on 3 Node.
• Involved in Integration and Setup of OTM 6.4.2 with Oracle E-Business Suite and Oracle BPEL Manager as integration layer for TEST and DEV instances..
• 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.
• 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 Confidential .
• 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 Confidential 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 underlying taxonomies.
• Presented Enterprise Mobile Platform for ERP at Confidential Tech Time
• Driving UX and mobile application design solutions for ERP based Applications.
• Architect/Lead and Initiated Aviation First successful OracleERP 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 Confidential 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. Overall 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 Confidential to showcase in Open World and to showcase how fast you can migrate to Exastack 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 Confidential 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.

Confidential

AWS/Oracle Cloud Lead Architect

Responsibilities:

• 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.
• Installed and Configured OPC with On-Prem database on Cloud and integrated RMAN to run Backup of On-Prem database on Oracle Cloud as Backup as s Service.
• Designed and implemented Disaster Recovery for customer running E-Business Suite, SOA and other Fusion Middleware on Oracle Cloud Infrastructure as a Service with DBaas and Backup as a Service.
• Hands on skills based onOracle Cloud, RAC, RMAN backup and recovery, Active Data Guard, Snap clone, enterprise manager and MAA and Performance tuning and code level technical trouble shooting.

Confidential, Houston, TX

Lead Oracle Apps/Project DBA

Responsibilities:

• Involved in Building the infrastructure for hosting Corporate E-Business site running on Application Stack 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.
• 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.

Confidential, Lincolnshire, IL

Lead Oracle Apps/Project DBA

Responsibilities:

• 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 Clusterfor 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.
• 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.
• Installed and Configured Oracle B2B Rel 11gSOA 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 data sources for RTD.
• Architecting and designing OracleSOA Suite, 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.

Confidential, Downers Grove, IL

DBA

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:

• 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 Clusterfor 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.

Confidential, CO

Performance Tuning Apps DBA

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

Responsibilities:

• 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.

Confidential, Downers Grove, IL

Lead Apps Implementation DBA

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:

• Involved in implementation the infrastructure for hosting corporate e-Business site running on Oracle Application Rel12 Multi Tier architecture on IBM AIX5.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.

Confidential, Lincolnshire, IL

Sr. Oracle Applications Lead DBA

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:

• 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 Confidential .
• 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.
• 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
• 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 Clusterfor 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 Table space structure as per new OATM (Oracle Applications Table space 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.

Confidential, Highland Park, IL

Oracle Applications Lead DBA

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

Responsibilities:

• Duties include the management of multiple requests for technical, development, system administration, architecture and networking assistance and guidance throughout the life of the project.
• Provided database administration services in Oracle ERP environment to efficiently support the business processes.
• Provided database solutions to the client area in support of the on-going and new business processes. Orchestrated and implemented a planned performance tuning process for the application data base that includes peer/project reviews.
• Managing and supporting Oracle Apps 11i (11.5.10.2) on HPUX 11.23 Server. Production and testing environments are a two-tier architecture with 10g Oracle database running in RAC using Veritas Advanced Clustering 3.4 for 10g. The application servers are running all 11i components (concurrent manager, forms, Discoverer, etc.) except the database.
• Conferred to project standards and procedures related to Configuration Management throughout the application software development/maintenance life cycle.
• Oversee installation, creation, management, support and security of application instances and ensure that application instances meet standards as identified by the DBA-Technical architect, and are functioning at optimal capacity (which includes: 24x7 support for all databases including monitoring, performance tuning database back-ups/recovery, troubleshooting/resolution and migrations and upgrades).
• Upgraded all databases to 10g and applied DST patches enterprise wide as recommended by Oracle.
• Mentored the staff assigned to the Support Services account to insure work is done in accordance with the terms and conditions of the customer contract as timely and efficiently as possible.
• Develop, test, and document procedures for cloning (using AutoConfig), RMAN backups, patching, upgrading to 10g, upgrading to 11i.

Confidential, Darien, IL

Database Team Lead

Tools: Release 11.5.9 with Oracle 9.2.0.6, Sun Solaris 9 Cluster, TOAD, Oracle Enterprise Manager, Data Guard, SRDF, BCV, DBARTISAN

Responsibilities:

• Lead a team of five to eight DBA's in the administration, maintenance, development and implementation of policies and procedures for ensuring the security and integrity of the company database(s).
• 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 11i, 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 functional DBA's in the installation of patches, upgrades and installation of application databases and other projects, ensuring that designs fall within the technical framework as identified by the DBA-Technical Architect.
• Oversee installation, creation, management, support and security of application instances and ensure that application instances meet standards as identified by the DBA-Technical architect, and are functioning at optimal capacity (which includes: 24x7 support for all databases including monitoring, performance tuning database back-ups/recovery, troubleshooting/resolution and migrations and upgrades).
• Implemented plan for innovative strategic solutions that will shift the organization's database administration into a more efficient and effective operation
• Responsible for Oracle Financials 11i implementation.
• Managing and implementing Oracle Apps 11i (11.5.9) on Sun Fire 4800 Server running Sun Solaris 9 cluster. Production and testing environments are a two-tier architecture with 9.2.0.3 (9i) Oracle database running in RAC using Veritas Advanced Clustering 3.4 for 9i. The application servers are running all 11i components (concurrent manager, forms, Discoverer, etc.) except the database.
• Provide database architecture and technical project leadership for selected new development projects. Maintain, tune, monitor and administer both development and production Oracle applications databases and application-tier technology components.
• Participates in defining standards and devising processes for subsequent revision to include new processes.
• Assisted developers in efficiently designing database objects and SQL, identified and corrected problem processes, and controlled all changes to the production databases.
• Reduced risk and guaranteed acceptable performance.
• Installed the production and test 9i databases, which included manual modifications of the Apps 11i environment.
• Performed a number of clones for testing and development. The Oracle 11i Apps production is currently running on version 11.5.8 in a 3-tier environment. The Web tier is load-balanced across two Sun Fire 280 servers. The database and concurrent manager server is running on a Sun Fire v4800. All are running Solaris 8. The Application modules running are HR, the Financial Suite, Supply Chain, iProcurement, iExpense and Purchasing.
• Architect RMAN (Legato Networker) scripts and implemented them into all environments. Installed and implemented OEM on Solaris server.
• Created testing environment for implementation of Load balancing components of the 11i tech stack
• Implemented StatsPack on test and production environments.
• Setup of regularly scheduled snap shots. Perform analysis on results. Also, developed and implemented maintenance scripts (Korne shell, SQL and PL/SQL, JAVA, JSP)
• Developed in house JAVA based monitoring tool to manage databases and application.
• Responsible for maintaining database and developed strategies to improve system performance
• Developed and tested Recovery procedures. The procedures detailed recovery’s of 11 Oracle Databases on Sun Solaris at a remote location.
• Successfully performed DR exercise for these Oracle databases and applications at the Hyde Park facility in Chicago.
• Mentoring and knowledge transfer to junior 11i DBA and staff. Develop, test, and document procedures for cloning (using AutoConfig), RMAN backups, patching, upgrading to 9i, upgrading to 11i.
• Configured and supported 9iAS (Apache) environment. Install and configure Data Guard for 9i release 2 instances.
• Installed and implemented Oracle Enterprise Manager (OEM) to manage and monitor all Oracle instances including the ERP instances.
• Upgraded Oracle Application Manager (OAM).
• Implemented Workflow 2.6.
• Installed and configured Apache server for in house web server for implementation
• Developed Disaster Recovery Strategy using EMC BCV and SRDF technology to bring database and application UP within an hour.
• Configured Physical Standby databases for disaster recovery situation.

Confidential, Schaumburg, IL

Sr.DBA

Tools: PeopleSoft 7.5 with Oracle 8.1.7.x/7.3.4, UNIX shell, Power Builder, Informix 7.2, Sybase System 10/11.

Responsibilities:

• Highly involved in managing multiple projects such as Bank Reconciliation, Ten99 System, Manual Checks, Postage Allocation System, and Deferred Acquisition Cost Management System.
• Designed and implemented intranet remote Database Administration and reporting tool for ORACLE/INFORMIX using JAVA Servlets and APACHE JAVA Servlet engine on Sun Solaris platform. The tool helps DBA and management people to monitor the activity within the database and server and print out reports.
• Selecting database storage strategies based upon the services required by users/clients.
• Duties include auditing and measuring the effectiveness of implemented database systems and procedures, provide technical solutions for the resolution of the deficiencies or disaster recovery in the database network, and design and implement appropriate measures to restart the database system without any delay.
• Developed strategies to Archive large quantity of data.
• Database recovery and restart procedures for primary database systems and applications.
• Responsible for directing the activities of subordinate personnel in the application of complex database systems programs.
• Involved in designing and implementing customized database access techniques.
• Developed procedures for the security, update and efficient and effective use of database systems.
• Responsible for providing technical guidance and assistance to subordinate and user/clients in the application of database techniques.
• Solely responsible for writing stored procedures and triggers for all the applications in SYBASE System 10/11 and INFORMIX 7.3
• Responsible for documenting both technical and instructions manual for operations/users.
• Responsible for writing C batch programs to load the data from Main Frame to the client/server platform. Used stored procedures embedded in C in SYBASE System 10/11
• Responsible for writing UNIX scripts to automate the batch processes for loading the data into client/server platform.
• Responsible for converting application from SYBASE System 10 to INFORMIX 7.3.
• Involved in writing UNIX shell scripts for updating tables for LAWSON integration and testing of Accounts Receivable System. The data resided as a flat file being feed directly from Clubs Management System (CMS).
• Extensively used UNIX shell script to validate and format the data according to LAWSON’s specification and then updated the tables which resided in INFORMIX 7.3 database.
• Solely responsible for training users in different application.
• Technically led a team of 5 people for the implementation of PeopleSoft Conversion from M&D.
• Responsible for installing and coordinating PeopleSoft 7.5 on Sun Solaris 2.6 and Oracle 8.05.
• Developed and designed strategies for Interfaces from old M&D system into PeopleSoft GL/AP.
• Responsible for making all customizations in GL/AP/PO implementation.
• Responsible for writing PeopleCode and SQR for various batch processes in GL/AP/PO implementation.
• Designed and developed in-house Journal Upload utility for GL implementation.
• Responsible for moving PeopleSoft GL/AP/PO into production.
• Involved in applying PeopleTools and Application upgrades into development and production database.
• Developed PO faxing strategies from PeopleSoft to various vendors from batch and online.
• Responsible for maintaining production database and developing strategies to improve system performance.
• Responsible for documenting all customizations and processes developed in-house.

Confidential, Detroit, MI

Database Programmer

Responsibilities:

• Developed and designed student inquiry and admission process using ORACLE 6.0 as backend and Power Builder 3.0 as a front end which resulted in an excellent and friendly user interface in a client/server environment.
• Responsible for training staff and faculty members.
• Accountable for the complete documentation and instruction manuals.
• Worked as a project leader, designed a medical supply inventory control application for the Nursing department using ORACALE 6.0 utilizing Power Builder 3.0 as front end to provide a very powerful user interface.
• Designed and developed an evaluation application program for Management that generates reports summarizing the standing of the staff using ORACLE 6.0 tools, SQL*FORMS, SQL*Report Writer.
• Involved in building the entity relationship diagram and normalizing the database.
• Developed various data entry, data display screens using SQL*FORMS 3.0.