Candidates About

SUMMARY:

Lead full lifecycle implementation of Oracle E-Business Financial Accounting Hub [FAH], Oracle Revenue Management & Billing [ORM&B] projects, for a large Insurance company. Major role includes Infrastructure setup, database/application upgrades, components installation, clone, review and patch application of various Oracle E-Business Suite flavors on production, test & development instances along with offshore & onsite team co-ordination.

 

CURRENT ROLE & IT Experience:

Currently serving as Project Lead (Larsen & Toubro Infotech  Ltd., USA for client Marsh & McLennan Companies, USA)  with  12+ years of experience in IT .

 

PROFESSIONAL SUMMARY:

      Leading Oracle Database 11.2.0.2 to R12.1.0.2 upgrade project.

      Leading EBusiness Suite R12.1.3 to R12.2.0.4 upgrade project.

      Implementation of  Dell STAT project, used for EBS version control, ticketing system and online migration. 

      Full cycle implementation of  Financial Accounting Hub[FAH] & Revenue Management and Billing [RM&B] product.

      Lead these project along with team from Onsite & Offshore.

      Infrastructure setup and Installation for 11.2.0.2 Database and Revenue Management & Billing (RMB) Application.

      Environment preparation and Installation for 11.2.0.2 Database along with EBS R12.1.3 (FAH) Application.

      Implementation of DMZ P2P external application for iSupplier.

      Implementation of  Parallel Concurrent Processing (PCP) on 11.5.10.2 & R12.1.3 EBS applications.

      Installation of Oracle 9i/10g, Oracle 11.5.9, 11.5.10.2 and R12.1.3 on Linux/Solaris.

      Installation of Red Hat Linux 9.0, Enterprise Linux-2.1, 3.0 & 4.0

      Maintaining Oracle Apps 11i/R12 (single/multi node).

      Sysadmin, Cloning, Upgrades, Patch review/application activities on Oracle Apps 11i/R12 environment.

      Weblogic installation, setup and maintenance.

      Maintaining 24/7 high availability environments.

      Database and Application Cloning.

      RMAN setup for database backup.

      Database Audit setup and Quarterly Password change to comply with Sarbanes–Oxley (SOX) process.

      Review & Application of  CPU patches for Oracle database, EBS & Weblogic application.

      Cordination with Unix (system admin) and Network team to cater all the needs in infrastructure setup .

      Database [9.2.0.X, 10.2.0.X, 11.2.0.4] and Application [11.5.10.2, R12.1.3] upgrades.

      Daily activities [Adding datafiles, clearing file system, handling client issues]

      Raise and Follow up Metalink Technical Assistance Requests (iTARS) to resolve odd issues.

      Interacting with end-users, technical and functional teams for application issues.

 

TECHNICAL SKILLS:

Relational Database            Oracle R12c/11g/10g/9i/8i [DBA], SQL Server 2000, MS Access.

Oracle ERP                             Oracle EBS R12.2/R12.1.3/12.1.1/12.0.4/11.5.10.2/11.5.9

Operating System               RHEL 3-6.5, Linux AS 2.1/9.0, Solaris 5.10/5.8, Window 9x/2000, Windows NT 4.0

Languages                             Visual Basic 6.0, PL/SQL, Java 2[OOAD & UML], C, C++.

Data Structure                     Java 2.

GUI Tools                               Visio, Visual Studio 6.0, Crystal Report 8.0, Forte 4.0, SmartDraw 5.5

Computer Network            Layers and Sub layers, Protocols [TCP, UDP, IP], Berkeley Sockets.

Middleware                          Oracle Weblogic 10.2, IBM webSphere.

DETAILED WORK EXPERIENCE [PROJECTS HANDLED]:

Project Lead - Larsen & Toubro Infotech Ltd., USA (Client – Marsh & MCLennan Companies)               July 2010 –Till date

 

Oracle Database 11.2.0.2 to R12c upgrade for Revenue Management & Billing [ORM&B]:

 Ongoing Oracle Database R12.1.0.2 upgrade project from 11.2.0.2 database.

 Reviewing Oracle Metalink Upgrade notes and documentation and preparing an action plan for upgrade.

 Worked with Unix team, for the preparation of Server, compatible for this Oracle upgrade.

 Worked with Network team for creating required VIP’s, firewall port opening etc.

 Data Migration from Redhat Linux 5.11 to Solaris 5.10.

 Upgrading database from 11.2.0.2 to 11.2.0.4 and then to R12.1.0.2 using DBUA.

 

EBS R12.1.3 to R12.2.4 Upgrade for Financial Accounting Hub [FAH]:

 Ongoing Oracle Database R12.1.0.2 as well as E-Business R12.2.4 application upgrade project.

 Requirement gathering, documentation and upgrade notes review and action item preparation.

 Upgrading database from 11.2.0.2 to 11.2.0.4 and then to R12.1.0.2 using DBUA.

 

Oracle Critical Patch update July 2015 Patches:

 Patch review against several databases and preparing action plan for its implementation.

 Assisting team members in getting it implemented in all databases and applications.

 Troubleshooting in case any issue encountered.

 

Dell STAT Project:

 Implementation of STAT project for E-Business Suite.

 Infrastructure setup with 11.2.0.4 database.

 Setting up oracle client on each application servers along with its GUI configuration.

 Its being used for version control, ticketing system and online migration.

 

Internet Explorer 11 upgrade:

 Pre-requisite patch review against several flavors of applications to get it work for IE 11 browser.

 Successful implementation of patches and configuration.

 Troubleshooting issue, encountered during initial execution in non-PROD environments.

 

JRE 1.7 Upgrade:

 Patch review against different application to make it compatible for JRE 1.7.0.40 and highier.

 Successful implementation of patches, testing and rolled out at timely fashion.

 

Disaster Recovery (DR) test for all supporting databases & application:

 DR test is being performed on yearly basis for all the applications and databases we support.

 Infrastructure level setup, while setting up new environment, to comply with DR.

 Preparation of test document along with storage, unix and network team.

 Simulating a DR situation, requesting application team to put a fake transaction and failover the database.

 Storage, unix and network team’s assistance is required for presenting DR disks, import & mounting filesystems and DNS changes respectively.

 Services are being brought up at DR servers and the fake transaction are verified for successful DR test.

 

SSL Implementation:

 Implementation of SSL for all the application URL’s being supported.

 Creating CSR file on application servers.

 Requesting for certificate from authorized vendor.

 Installing certificates on application servers and performing post application steps.

 Verifing the same by performing sanity check of the application.

 

DMZ external iSupplier implementation for Financial Accounting Hub (FAH) R12.1.3 & 11.5.10.2 EBS applications:

 Infrastructure setup for new E-Business Suite application tier and proxy server for DMZ setup.

 Clone for external application from internal application tier

 Configuration setup and externalizing the new application node.

 Installation and configuration of IBM Websphere/Apache, used as a proxy server

 External facing ports being opened with assistance from network team.

 Troubleshooting of issues encountered.

 Testing performed and rolled out to business users.

 

RMAN Setup:

 As an infrastructure setup of new environments, backup are configured as per industry standard.

 Its being monitored on regular basis.

 In case, if any backup fails, it is being troubleshooted and backup is re-executed, ensuring successful backup.

 

AUDIT Setup:

 As an infrastructure setup of new environments, audit setup is configured as per Audit SOX policy.

 All object & configurational changes of databases are being monitored.

 Those changes are mapped with the ticket numbers along with approvals from approver are being gathered.

  Its helful and all change related proof are handy with us, during AUDIT process.

 

Financial Accounting Hub, EBS R12.1.3 implementation [FAH]:

 Review of Metalink notes and Oracle documents and other search engine  for R12 installation.

  Prepare a detail document for executation steps so that other DBA team member can follow it.

  Infrastructure setup and implementation of R12 environment.

  Providing guidance, leading other team member with 24 X 7 support.

  Troubleshooting the issues encountered by own and sometimes taking help from Oracle support.

  Updating client on timely manner with the status of this installation.

  Integration of Wells Fargo Adaptor to this application.

  Ongoing infrastructure, database & application support.

  Planning for its DB & application version upgrade.

 

Oracle Revenue Management & Billing implementation [ORM&B]:

  Successful implementation of Revenue Management and Billing product.

  Installation of all the required software, which includes Oracle 11.2.0.2 RAC database, Revenue Management & Billing 2.2.3 SP1, JDK 1.5.0_16, JRockit 5.0 R27.5, Hibernate 3.2.7, Perl 5.8.9, C3P0 0.9.1.2, MicroFocus 5.1, Weblogic 10.0 MP2, Framework 2.2.0 SP10 and FAH EBS R12.1.3.

  Installation, deployment, DBA support to all the DEV, QA, UAT and PROD environment.

  Integration of RMB product to various application including FAH EBS R12.1.3, Document Rendering, Msurety, OBIEE, Wells Fargo.

  Ongoing support of its database as well as applications.

  Performing new enhancements to DB & applications as Release migrations on quarterly basis.

  Planing for its DB & applications version upgrade in near future.

 

Parallel Concurrent Processing [PCP] implementation on E-Business Suite 11.5.10.2:

  Review of Metalink notes and preparing an action plan for team members.

  Configure Parallel Concurrent Processing feature to all the non PROD and PROD environment.

  Troubleshooting for the error encountered with the help of metalink Oracle support.

  With this feature Concurrent managers are available on both the nodes and upon failover of any node, requests are diverted to the other available node.

 

 

 

 

Core Services [I] Technologies Pvt. Ltd (www.coreservices.com – Oracle Hosting Service Provider)            Feb. 2006 to Aug. 2009

 

1] Project    :     R12.0.4 Application upgrade

    Client       :     YMCA International, United States

    Duration :     Feb 2009 to July 2009

    Role         :     Oracle Application DBA [Support]

    Environment :  EBS -- 11.5.10.2, Database -- 10.2.0.4, OS -- Linux

    Contribution    55%

Brief Project Profile:

              It was an application upgrade from release 11.5.10.2 to R12.0.4. My contribution was to continue with the upgrade process as per the steps provided by lead DBA, during my shift.

 

2] Project     :      9.2.0.8 to 10.2.0.4 Database upgrade

    Client        :      SOMA Networks, United States

    Duration   :      April 2009 to May 2009

    Role           :      Lead DBA

    Environment :  Database -- 9.2.0.8, OS -- Linux

    Contribution    100%

    Achievement      Appreciated by Client for project completion before time.

 

Brief Project Profile:

              This project was to upgrade the database from version 9.2.0.8 to 10.2.0.4. I have to review for 10.2.0.4 upgrade against PROD instance and prepare a detailed spreadsheet, so that we [DBA] should follow it during upgrade run for all the instances. As a lead DBA, I had to keep track of all the error’s encountered during test run, timings and need to update client time to time with the status/progress of the upgrade. The production upgrade was completed before the scheduled end time, without any error and was appreciated by client for the same.

 

3] Project     :     Build Standby Database

    Client        :     Arthur J Gallagher & Co. Ltd, United States

    Duration  :     March 2009

    Role          :     Lead DBA

    Environment :  Database -- 9.2.0.8, OS – Solaris 5.10

    Contribution    100%

Brief Project Profile:

              This project was to build a physical standby database for the PROD instance. It was successfully completed on time.

 

4] Project    :     Build R12.0.4 instance MIRU

    Client       :     Mirapoint Software, Inc., United States

    Duration  :     Nov 2008 to Jan 2009

    Role          :     Lead DBA

    Environment :  EBS -- 11.5.10.2, Database -- 10.2.0.4, OS -- Linux

    Contribution    60%

Brief Project Profile:

              This project was to build a new Release 12 instance [R12.0.4] instance on Linux server. I have to review and install Release 12.0.4 and licensed the required products as per client requirement to this new instance.

 

5] Project    :     10.2.0.4 Database upgrade & CPU Upgrade

    Client       :     YMCA of METROPOLITAN LOS ANGELES, United States

    Duration  :     Dec 2008 to Feb 2009

    Role          :     Lead DBA

    Environment :  EBS -- 11.5.10.2, Database – 9.2.0.8, OS – Solaris 5.10

    Contribution    90%

Brief Project Profile:

              It was a database upgrade from version 9.2.0.8 to 10.2.0.4 along with critical patch update Jan. 2009. My responsibilities includes review and provide detailed steps for both 10.2.0.4 upgrade and CPU upgrade, implement it on TEST and DEV instances first and then promote the whole process to PROD.

 

6] Project    :     Instance Build

    Client       :     Conservation International, United States

    Duration  :     Sept 2008

    Role          :     Oracle Application DBA [Support]

    Environment :  EBS – R12.0.1, Database -- 10.2.0.4, OS – Solaris 5.10

    Contribution    70%

Brief Project Profile:

              This project was for creating a new R12 on Linux server. I was involved with the installation of R12.0.1 as per provided spreadsheet.

 

7] Project    :     10.2.0.4 Database upgrade

    Client       :     Ulticom, Inc., USA; LipoScience Inc., USA

    Duration  :     July 2008 to Aug 2008

    Role          :     Lead DBA

    Environment :  Database – 9.2.0.8, OS – Solaris 5.8

    Contribution    60%

Brief Project Profile:

              Database was upgraded from 9.2.0.6 to 10.2.0.4. I was involved in review, spreadsheet creation for the steps required for upgrade and implementation of it on TEST, DEV and PROD instances.

 

8] Project    :     11.5.9 to 11.5.10.2 Application Upgrade

    Client       :     YSI Incorporated Inc., United States

    Duration :     Sept 2007 to Dec 2007

    Role         :     Lead DBA

    Environment :  EBS – 11.5.9, Database – 9.2.0.8, OS – Linux

    Contribution    100%

Brief Project Profile:

              This project was to upgrade the application from release 11.5.9 to 11.5.10.2. I was involved in review of maintenance patch against 11.5.9 PROD instance, creating spreadsheet and application of all the patches on TSET, DEV and PROD instances.

 

9] Project     :     9.2.0.6 to 9.2.0.8 Database Upgrade

    Client        :     Genta Incorporated, United States

    Duration   :     April 2007 to June 2007

    Role           :     Lead DBA

    Environment :  EBS – 11.5.10.2, Database – 9.2.0.6, OS – Solaris 5.10

    Contribution    100%

    Achievement    Appreciated by Client for timely update and completion of project on time.

Brief Project Profile:

              This project was a database upgrade from version 9.2.0.6 to 9.2.0.8. My contribution was to review the patches required for 9.2.0.8 upgrade. It was tested first on TEST and DEV instances and successfully promoted to PROD instance.

 

1] Project              :               Payroll System

Client                    :               Emmessar Biotech & Nutrition Ltd., Mumbai.

Duration              :               Dec. 2005 to Feb. 2006

Designation        :               Programmer

Environment      :               VB 6.0, Oracle 9i, Crystal Report 8.0, Windows 2000.

Brief Project Profile:

This module is going to be added in the previous project. The daily attendance of every employee is recorded and maintained by this project. Administrator has full privileges to create different formula of earnings and deductions for different employee, set rules for leaves, login permissions at various levels. At the end of the month, salary is calculated for each employee according to his breakup fixed by the account dept.

Role:

• Back end programming
• Generating salary slip for each employee and useful reports.

 

2] Project              :               Sales Analysis System [Pharmaceutical]                                                      

Client                    :               Emmessar Biotech & Nutrition Ltd., Mumbai.

Duration              :               May 2005 to Nov. 2005

Designation        :               Programmer

Environment      :               VB 6.0, Oracle 9i, Crystal Report 8.0, Windows 2000.

Brief Project Profile:

                It’s a client server application that deals with daily sales of its product to different parties (Distributors, Physicians, Exporters, and Institutional Buyers etc.). In this Sales and Analysis system, product is purchased through suppliers and is sent to various warehouses. The stock is maintained at its office as well as at the respective warehouse. From office the invoice is raised for different product and challans are generated & is sent to the desired warehouse. The goods are then shipped to the party from its warehouses and the stock is updated by maintaining its batch no.

                It also keeps detailed information about the receivables (with different tax structures) and payments raised against the invoice. It provides several user-wise reports that help in analyzing their periodical sales and inventory status of their products.

Role:

·         Specification requirement collection, interface designing, coding and testing.

·         Database designed utilizing DBA’s concept [manual database creation considering its logical and physical storage structure (tables, views, indexes), backup & recovery (Export/Import, RMAN)].

·         Different statistical reports for daily use.

 

3] Project              :               Sales Analysis System [Garment Outlet]                                                      

Client                    :               Millionaire, Juhu & Millionaire, Malad.

Duration              :               Nov. 2004 to Mar. 2005

Designation        :               Programmer

Environment      :               VB 6.0, Oracle 8i/SQL Server 2000, Crystal Report 8.0, Windows 2000.

Brief Project Profile:

                It’s a client server application for a garment outlet that monitors daily and periodic sales of its garment products (formal & casual).            Vouchers or receipts are raised against the payment. 

                Authorized employee can analyze their sales, stock, receivables, delivery and  payment status etc. by using the respective reports.

Role:

·         Specification requirement collection, interface designing, coding and testing.

·         Different statistical reports for daily use.

<span style="fo