Â· Twenty plus years of extensive and diversified technical experience in Information Technology industry of which, over 14 years of consulting experience in a variety of Oracle software and customer environments. Â· With wide, varied and deep experience of Oracle’s internals, architecture and features, on various versions of Oracle products, Performance Tuning, implementing and maintaining Real Application Cluster (RAC) and GRID, Oracle Application Server as Oracle Applications DBA/ Technical Architect, for many mission critical, high volume, VLDB Oracle projects for over 100 different clients throughout North America. Â· Experience includes I/O design for performance and troubleshooting on various UNIX / Linux Operating Systems and clustering tools. Â· Best practices and long term plan being followed makes me a unique and a capable candidate for lead and key roles in Installations, Upgrade, and Performance Tuning. Â· Technical skills include database management and administration, relational database design and implementation, capacity planning, benchmarking and mentoring. Have been an implementer and also played lead roles on numerous projects, and involved in post implementation support and technical workarounds. Â· With in-depth knowledge of result-oriented troubleshooting in Oracle Database, E-Business Suite and Oracle Application Server. Â· Expertise in various Operating Systems (Sun Solaris, HP-UX, AIX, Linux) on a variety of hardware and infrastructure. Â· Being part of the team in building successful proposals for fresh installs and upgrades, defining the hardware and other system requirements based on the implementation needs and along with manpower planning for various projects both for Private and Public sector. In short, been a Solution Provider for various projects. Â· Consistently produced high quality work results under time and cost constraints by leading heterogeneous teams of varying sizes. Quickly assume a productive lead role on any project and also provided Technical / Team Leadership to various clients. Efficient problem solving and reasoning skills on issues with innovative technical know-how is a specialty. Â· Team / Project Management with Leadership Capability to manage resources and to achieve the goals on time, Conflict Resolution capability, with excellent communication, interpersonal and organizations skills. Managed teams of size between 12 and 30 members on various projects and as Consulting Manager. _______
Education and Certifications
Masters in Statistics – Loyola Autonomous College, University of Madras, India
Diploma in Computer and Applications Software – University of Karaikudi, India
Databases: Application Servers:
Oracle RDBMS (5.x – 11g) Oracle 9iAS, 10g AS, Web Logic Server
e-Business Suite Operating Systems: Oracle Applications 10.7 SC, 10.7 NCA, Solaris, HP-UX, AIX, Linux
At SmartDog Services, I was in the OnDemand DBA team taking care of various clients. More particularly,
Â· trouble shooting, issue resolution, performance tuning of Oracle Databases (RAC and non-RAC), Oracle Applications.
Â· Configuring Oracle Grid Control for backup and recovery.
Aleris Nov ’11 – Aug ’12
At Aleris, I was
Â· Instrumental in implementing the best practices for Oracle Applications re-implementation of R12.1.3.
Â· Implemented 11g Grid Control and deployed configured agents on various VM servers,
Â· Configured RMAN thru Grid Control for backup and recovery.
Â· Trouble shoot and resolved many day to day issues
Â· Documented for further future reference.
Federal Reserve Board Aug ’11 – Nov ’11
At FRB, I was called in to
Â· Perform an upgrade from R11i to R12.1.3 along with OATM migration.
Â· Documented the OATM migration and the upgrade process with comments on issue resolution for further upgrade iterations.
Washington Suburban Sanitary Commission Oct ’10 – May ’11
At this assignment, I was involved in
Â· Upgrading the Oracle e-Business Suite from 126.96.36.199 to R12 (12.0.6) on Linux RAC with Oracle 10g DB.
Â· implemented Oracle Time and Labor.
Â· Test 11g R1 RAC install for learning and training purpose of their DBA’s on a Linux server.
Â· Provided recommendations on Single Sign-On and Identity Management processes and implemented it.
Geokinetics Sep ’09 – Oct ’10
Initially I went into this client for
Â· Stabilize and maintain the Oracle R12 (12.0.4) e-Business Suite application on Linux VM Ware (both the DB and the Apps Server) with the DB version being 11g R1.
Â· Upgrade 12.0.4 to 12.1.1 with 2 other languages.
Â· Implement OEM 10g and 11g for performance monitoring.
Â· Implemented Data Guard too.
Jacksonville Electric Authority Multiple assignments
Here at this client, it was a upgrade reimplementation of Oracle Applications from 11.5.9 to 12.0.6 on a single node RAC. Initially the cluster software installed on a two nodes, and then due to the implementation of OBIEE, this was converted to a single node RAC, with RAC cluster software left running, with the easiness of adding servers at a later date. I was also the architect for OBIEE implementation. This was an Oracle implemented project. Provided recommendations on Single Sign-On and Identity Management processes and implemented it.
US Concrete Multiple assignments
At this client it was a fresh implementation of Oracle e-Business Suite (R12.0.4) on a 2 node Sun Cluster with ASM. Initially the software installed on a single node server then migrated the DB to ASM and the converted it to RAC. I was also involved in performance tuning the server and the software. Provided recommendations on Single Sign-On and Identity Management processes and implemented it.
Sun Systems Apr ’08 – Jul ’08
I was called in to stabilize the instances on RAC. This was an Oracle e-Business suite implementation with huge customizations.
PayPal Sep ’07 – Feb ’08
At this client site my responsibility was of a DBA maintaining the instances on 8i and then had the opportunity to upgrade them to 10g and also to convert them to RAC with ASM.
Sherwin Williams Jan ’07 – Aug â€˜07
In this assignment I was responsible to lead a team of 8 Apps DBA’s in implementing Oracle Financials and Enterprise Asset Management apart from maintaining the Benefits and related modules that were live. This was three projects running concurrently and I was the point person for Technical Architecture with modernizing the backup and recovery, implementing Disaster Recovery and also instance / server management.
USDA (Part-Time) Sep ’06 – Jan â€˜07
In this assignment where I was responsible for the technical architecture and maintenance of the instances for Proof of concept for Oracle Financials, Supply Chain and also Order Management product families. I was leading a team of 3 Apps DBA’s. Provided recommendations on Single Sign-On and Identity Management processes and implemented it.
ECSS (Part-Time) Sep ’06 – Jan â€˜07
In this assignment where I was responsible for the technical architecture and maintenance of the instances for Proof of concept for Oracle Financials, Supply Chain and also Order Management product families. I was leading a team of 5 Apps DBA’s.
HAVA Project Jul ’06 – Sep â€˜06
This project is for Florida State Government. Here, I was involved in installing 10g CRS, RAC Database on HP Hardware with HP Service Guard as the cluster software. I job role also involved applying HP-UX, HP Service Guard patches. After the installation, I performed various testing scenarios involving hardware and software components.
HIGLAS: DBA Team Lead Jun ’05 – May â€˜06
Leading a team of 4 DBA’s in maintaining the live customer with more contractors being added on a quarterly basis. The job involves allocation of tasks and also performing the technical activities to upkeep 16 instances of which 3 instances are on RAC.
Caterpillar financial Services Apr ’05 – May â€˜05
In this assignment, I was assisting the DBA team to build and implement best practices for their Global single Instance (GSI) implementation of Oracle Financials and Lease Management. The team consisted of offshore developers in India, near shore developers in Memphis and users in UK and Nashville, US. The Apps DBA team was involved in day-to-day upkeep of the e-Business Suite applications and also involved in patching, cloning and tuning these applications. Provided recommendations on Single Sign-On and Identity Management processes and implemented it.
U S Navy, N10 Assignment Jan’ 05 – Mar â€˜05
In this project, I was responsible for installing Linux Operating System on 3 Dell machines, prepare them for network connectivity, enable security and install Oracle Applications 11i and migrate the similar database from Sun Solaris Operating system into these Linux servers. I was also responsible for cloning, patching and performance tuning this instance apart from migrating tables from the data warehouse database into the 11i e-Business suite.
Centre for Medicare and Medicaid Services Jun ’04 – Jan â€˜05
This is a project to combine Medicare’s many outdated accounting systems into a single, unified system. This is to replace the 54 current different systems in use by private contractors that process and pay 4.5 million Medicare claims every day with an Oracle 11i System. As a lead for the Oracle Performance Architecture team Assisted ASP DBA team with maintenance, upgrades, patching, cloning and backup / recovery. Ã˜ Responsible for capacity planning and for setting up and enforcing performance budgets through a combination of developer training, code reviews, tuning and architectural recommendations. Ã˜ Architected solution for data warehouse using Streams technology and for Disaster Recovery using Data Guard and Veritas Volume Replicator. Ã˜ Worked on migrating a single instance 1.2TB database from Sun Solaris to a two node Real Application Cluster instance with OATM on IBM AIX. PCP was configured for handling concurrent processing. Ã˜ Designed and monitored stress tests to identify and resolve performance bottlenecks. Ã˜ Assisted in the migration effort from one ASP to another. This involved O/S, storage and data center migration. Ã˜ Assisted prime vendor on implementing efficient application setups for users, responsibilities and job scheduling and to evaluate various third party tools to assist application and database administration. Ã˜ Led effort to Benchmark system at full load at the IBM-Oracle competency center.
Stuller Settings Multiple assignments
At Stuller Settings, I was involved in Ã˜ Technical Architect. Ã˜ Upgrading Oracle Applications form 11.5.3 to 11.5.6 and then to 11.5.8 (Financials, HRMS, Order Management and CRM) Ã˜ End-to-End Performance tuning and load testing using Mercury’s Load Runner. Ã˜ RMAN implementation. Ã˜ Import and export of Oracle Applications for uniform segment size and automatic segment space management. Ã˜ Migrating middle tier from HP-UX to Linux (30 machines). Ã˜ Implement SSL for Apache based connectivity. Ã˜ Configuring the hardware load balancer (Net Director).
Unocal November â€˜03
PBGC December â€˜03
At the above to clients,
Involved in performance health check of the Oracle Applications along with various components encompassing it. Identifying and resolving Ã˜ Hardware and Operating system bottlenecks. Ã˜ Network bottlenecks. Ã˜ Database tuning. Ã˜ Oracle Applications tuning. Ã˜ Suggesting steps and also laying down a template for future performance tuning and monitoring of the various subsystems.
St. Paul Re., Multiple assignments
At St. Paul Re., Ã˜ Involved in upgrading the Oracle Applications 11.5.4 to 11.5.8 – Financials Ã˜ Transfer of knowledge in best practices, cloning and maintenance.
Belkin Multiple assignments
Initially involved in performance tuning the Oracle Applications ATP process
Later, called in to lead and perform the following: Ã˜ Upgrade and migrate the Oracle Applications 11i from Sun Solaris to HP-UX. Ã˜ Performance tune the various product families used (Financials, HRMS, Supply Chain and CRM). Ã˜ Design the disk subsystem for optimal performance. Ã˜ Transfer of knowledge in best practices and cloning. Ã˜ Laid down the procedure for backup and recovery process.
Kinetic Concepts Inc., Sep â€˜03
At Kinetic Concepts Inc., Ã˜ Lead a team of 3 Oracle Applications DBA’s. Ã˜ Upgraded the Oracle Applications 10.7 to 11.5.8 on a IBM AIX operating system. The size of the 10.7 database was 280 GB. Ã˜ Performance tuned the upgrade process and brought it under 40 hours. Ã˜ Knowledge transfer of cloning and best practices in maintaining the Oracle Applications. Ã˜ Assisted in tuning the AIX operating system.
Essilor Aug â€˜03
At Essilor, one of the huge transactions involving Oracle Applications Order Management product family: Ã˜ Performance tuning of Oracle Applications and the HP-UX operating System. Ã˜ Coordinated with Oracle development to fix the performance issues of the product. Ã˜ Knowledge transfer of best practices and cloning process.
Michaels Inc Jun’ 04 – Jul â€˜04
At Michaels, the chain Arts and Crafts store, Ã˜ Technical Architect – unique requirement to bypass the network limitation. Ã˜ Installed Oracle Applications 11.5.5 and upgraded it to 11.5.7 for Oracle HRMS product family. Ã˜ Performance tuned and also assisted in cloning of Oracle Applications. Ã˜ Knowledge transfer to the in-house DBA. Ã˜ Implement SSL for both Apache and Forms.
H B Zachary Apr’ 04 – May â€˜04
At H B Zachary, a Construction company, Ã˜ Upgrade Oracle Applications 11.5.1 to 11.5.6. Ã˜ Configuring the hardware load balancer (Load Director). Ã˜ End-to-End Performance Tuning. Ã˜ Cloning of Oracle Applications. Ã˜ Knowledge Transfer to the client Apps DBA’s and remote support.
Key Bank May â€˜03
At Key Bank, Ã˜ Technical Architect. Ã˜ Migrate Oracle Applications 11.5.2 from HP-UX to IBM AIX. Ã˜ Upgrade Oracle Applications 11.5.2 to 11.5.8.
Technicolor Nov ’02 – Apr â€˜03
At Technicolor, Ã˜ Technical Architect for implementing Oracle Applications on an active – passive cluster for DB server. Ã˜ Infrastructure team lead. Ã˜ Lead a group of 2 other Oracle Applications DBA’s. Ã˜ Performance tuning of Oracle Applications 11i – Financials and Order Management. Ã˜ Upgrading Oracle Applications 11.5.5 to 11.5.7. Ã˜ Configuring the software load balancer for round robin connectivity.
Hallmark Cards Multiple assignments
At Hallmark, Ã˜ Installing Oracle Applications 11i – HRMS and performance tuning and also upgraded Oracle Applications 11.5.5 to 11.5.9 Ã˜ Oracle Consulting was brought in to perform a health check and assist on the upgrade of an E-Business suite implementation on AIX. Ã˜ Assisted the DBA team to develop a patching strategy to reduce downtime and make it more efficient. Ã˜ Identified and resolved a variety of issues related to performance and availability on the Concurrent Processing, Forms and Database tiers. Ã˜ Worked with the functional and development teams to architect a high performance data warehouse solution. Ã˜ Helped design backup and cloning procedures.
Hertz Multiple assignments
At Hertz, Ã˜ Installing Oracle Applications 11i – HRMS and performance tuning. Ã˜ Oracle Consulting was bought in to diagnose the health and suggest fixes for an E-Business suite implementation on HP-UX and EMC Symmetrix. Ã˜ Developed standards and processes for the DBA staff for better control of the performance and manageability for the implementation. Ã˜ Implemented processes and scripts to monitor and measure performance in the middle tier and the database.
AT&T Jun’ 02 – Aug â€˜02
This was one of the implementation of a very large CRM installation for this client on Sun Solaris and Hitachi Freedom storage. Ã˜ Worked with the ASP DBA’s to install and clone 11i instances. Ã˜ Monitored database and Middle Tier performance and suggest and implemented fixes to improve performance. Ã˜ Led a SQL tuning exercise and worked with Oracle Development and Support to obtain fixes. Ã˜ Patching and cloning of Oracle Applications 11i (Financials, CRM). Ã˜ Led a team to design and conduct Stress tests and related system tuning for a CRM implementation Ã˜ Configuring the hardware load balancer.
Shaw Group Apr â€˜02 Ã˜ At Shaw Group, I was involved in installing Oracle Applications Server 9i (9iAS) on IBM AIX operating system and configuring Web Cache. Ã˜ Knowledge transfer for performance tuning Oracle Applications and Oracle applications Server 9iAS
Diamond Offshore Drilling Inc., Mar â€˜02 At DODI, Ã˜ Upgraded Oracle Applications 10.7 to 11i (11.5.2) along with same hardware migration. Ã˜ Troubleshooting Forms server.
Value Vision Nov’ 01 – Dec â€˜01 At Value Vision, Ã˜ Installing and patching of Oracle Applications 11i (CRM). Ã˜ Trained on-site client DBA and knowledge transfer.
CMGi/uBid Multiple assignments
Lead a team of 5 other very experienced Oracle Applications DBA’s in performing the following tasks: Ã˜ HRMS performance tuning. Ã˜ Sun Solaris operating system tuning along with relaying of the disk subsystem for better throughput. Ã˜ Patching and cloning of Oracle Applications 11i (Financials, CRM, HRMS and Supply Chain). Ã˜ Configuring the hardware load balancer.
Ingresoll Rand Mar’ 01 – Apr ’01 Lead a team of 3 Apps DBA’s in proof of concept assignment: Ã˜ Installing and cloning of Oracle Applications 11i (Financials and CRM) and patch maintenance. Ã˜ Knowledge transfer to client Apps DBA. Ã˜ End-to-End Performance tuning of Oracle applications. Ã˜ Configuring the hardware load balancer.
ALCOA Multiple assignments At ALCOA, in San Antonio, Ã˜ Upgraded Oracle Applications 11.0.3 to 11i on HP-UX operating system. Ã˜ Assisted the DBA team to develop a patching strategy to reduce downtime and make it more efficient. Ã˜ Identified and resolved a variety of issues related to performance and availability on the Concurrent Processing, Forms and Database tiers. Ã˜ Worked with the functional and development teams to architect a high performance data warehouse solution. Ã˜ Configuring the hardware load balancer. Ã˜ Helped design backup and cloning procedures.
Sulzer CarboMedics Jul â€˜00 Ã˜ At Sulzer CarboMedics, Oracle Applications 10.7 was upgraded to 11i from Data General Systems to Sun Solaris operating system. Ã˜ Designed the technical hardware requirements for this upgrade and migration. Ã˜ Trained on-site client DBA and knowledge transfer.
Purina Global Jun â€˜00 Ã˜ At Purina Global, I was involved in Installing Oracle Applications 11i – Financials, Supply Chain. Ã˜ Assisted the client in configuring Oracle Enterprise Manager with Management Server to monitor Oracle Applications. Ã˜ Configuring the hardware load balancer for 3 middle tiers based on HP-UX.
American Air Tran May â€˜00 Ã˜ American Air Tran was one of the first customers to go-live with HRMS product family of Oracle Applications 11i. Ã˜ Installation of Oracle Applications 11i and initial on-site support and then remote support.
MOTB May 99 – Jun â€˜99
At Marketing-Out-Of-the-Box client: Ã˜ Migrating Oracle Applications 11.0.3 from Sun Solaris to HP-UX. Ã˜ Performance tuning the Financials and Supply Chain product families thus migrated.
JDS Uniphase Multiple Assignments
Initially, I was called in to performance tune Oracle Applications 11.0.3 with the following product families:
Financials, CRM, Supply Chain Ã˜ Tuning and distribution of I/O, tuning kernel parameters, tuning application queries for efficiency. Ã˜ Oracle Managed Services implemented and managed the E-Business suite installation for this client at Oracle’s Data Center. Ã˜ Performed System Administration tasks on Red Hat Linux and Netapp filers. Ã˜ Monitored key database performance indicators and statistics. Ã˜ Coordinated support activities on the System and database Administration tickets. Ã˜ Configuring the hardware load balancer for 12 middle tiers on Linux. Ã˜ Assisted a team of DBA’s in upgrading Oracle Applications 11.0.3 to 11i along with CRM 3i.
Raytheon Nov’ 98 – Dec â€˜98
At Raytheon, I was involved in: Ã˜ Installing and tuning Oracle 8.0 for custom application for Kraft Foods on a HP-UX machine. Ã˜ Distributing tablespaces regarding data based on partitioning, indexes, rollback segments & temporary tablespace for optimal performance. Ã˜ Designing and implementing backup strategies involving hot and cold backups. Used SQL Backtrack for backups.
Michigan Family Insurance Agency Jul – Oct â€˜98
Texas Mills Supply Jan – Dec â€˜99
Enterprise Products Oct ’98 – Mar â€˜99
At the above-mentioned clients, the following tasks were performed: Ã˜ Implemented Oracle Applications 11.0.3 – Role Oracle Applications DBA – Installing Oracle Applications (Financials), patching and maintenance. Ã˜ Defining Architecture needs. Ã˜ Tuning and distribution of I/O, tuning kernel parameters, tuning application queries for efficiency. Ã˜ Detecting and resolving application bottlenecks. Ã˜ Performing performance tuning and audit of Oracle Applications on the whole and the individual product families, products, and also analyzing and implementing End-to-End Performance Tuning. Ã˜ Defining procedures for developing, testing and performance tuning customizations / extensions before implementing. Ã˜ Applications Troubleshooting & End User Support. Ã˜ Analyzing current performance and implementing recommendations on expensive SQL operations.