Overview

• Over 14 years of experience in Information Technology in managing Oracle Databases, physical and logical database design, database performance tuning, database application tuning, database security, backup and recovery, implementing standby databases, Data Guard, replication, Real Application Cluster, RAC, OEM and Oracle Development.
• Expertise includes Installation, configuration and creation of Oracle database, Backups and Recovery, Performance Tuning, Migrating Oracle databases and Maintenance of production 24x7 databases and on-call support.
• Backup and Recovery - Implementing the physical and logical backup procedures. Writing efficient scripts for implementing Exports, Cold backups and hot backups. Technical support to Operators in taking LF backups. Working on the backup features of oracle like RMAN and Standby database for High Availability of the database for critical systems. Working on Recovery strategies for the Database. Responsible for exporting and importing of the database from Production to Test and development and vice versa.
• Responsible for scheduling the batch jobs and monitoring the jobs using OEM and cron. Responsible for maintaining production 24x7 and Test/Training/development databases Oracle 11g/10g/9i/8.x .
• Strong knowledge of UNIX and Windows scripting. Strong communications skills and ability to work closely with clients. Worked independently without any supervision.
• Experience in 11i E Business Suite as an Oracle Applications Technical Consultant in implementing ERP Oracle Applications GL, OM, AR, AP, PO, INV, TCA, ALERTS, SCM, Pricing, Shipping, CRM, AOL and Sys Admin
• Excellent skills in Oracle 10g/9i/8/7, front end development tools Developer 2000 Forms 10g/9i/6.0/4.5/3.0, Reports 10g/9i/6/2.5, Graphics 6i/2.5 , Discoverer 9i, PL/SQL, VB 5.0/6.0
• Worked extensively on developing RICE components.
• Experience in understanding business requirements for analysis, detailed design, database design development of applications
• Analyzing and understanding the source/existing/legacy system business functionality and preparing the functional and Technical Design Documents using AIM Methodologies
• Proficient in writing Stored procedures, Packages, Triggers and functions using SQL, PL/SQL and Performance Tuning of Sql queries, stored procedures and reports.

Technology Summary

• Database : Oracle 9i/10g/11g
• ERP : Oracle E-Business Suite 11i GL, AR, AP, PO, INV, OM, TCA, QP, ALERTS, CRM, AOL and Sys Admin
• Languages : SQL, SQL PLUS, PL/SQL, C, Pro C, Shell Scripts
• GUI : Oracle Developer 6i, Oracle Developer Suite 10g, Oracle Jdeveloper 10g
• Tools : OEM, Toad, Crystal Reports, Oracle Reports, Oracle 9i Discoverer, Exceed, ZOC/Pro 5.01,Visual Source Safe
• Operating System : WindowsNT/98/95/XP, Sun Solaris and Red Hat Linux.

Work Experience

Period:

Client Confidential

Environment: Oracle 10g, SunOS, TOAD, OEM, ASM, Forms 10g, Reports 10g, SQL Plus 8.1.7.3.0 , PL/SQL

Projects: MVA International Registries Program IRP , MDOT Fair Practices application OFP application, MDOT Contracts Tracking application MCON and MDOT Office of Environmental Programs and Policy EPP applications.

Roles and Responsibilities

• Responsible to install, configure Oracle software on Red Hat Linux, Oracle Enterprise Linux and Windows.
• Responsible to create, maintain and upgrade Oracle databases on Windows and Linux operating system.
• Responsible to setup Oracle 10g GRID and configure the agents on Windows and Linux environments.
• Installed and configure Oracle 10g GRID to monitor the databases and Oracle application servers. Implemented 9i OEM solution to monitor the databases using events and automate the export jobs for Oracle database.
• Responsible for planning and prepare the upgrade plan and implement efficiently in the process of Oracle database upgrade.
• Responsible for Oracle Application server installation and configure the forms for intranet and internet applications.
• Responsible to design and plan RAC implementation on Sun Solaris.
• Responsible to Install and configure 10g RAC environment on Sun Solaris. Responsible to create RAC database using ASM and QFS file system. Created and maintained 10g RAC database with ASM and QFS. Applied CPU and Oracle patches on RAC databases.
• Configure listener and tnsnames for RAC databases. Implement RAC high availability features like TAF and load balance features.
• Responsibility including writing automated script for backups and scheduling hot backups and cold backups and scheduling cronjobs. Responsible for setting the backup jobs using VERITAS backup software. Responsible for database recovery using cold/ hot backups from tapes and technical assist to operators as and when needed.
• Responsible for applying latest Oracle patches and security patches for Oracle databases and GRID control.
• Responsible for plan and implementing standard database security on the database. Responsible to create users, profile, views, synonyms and database links.
• Responsible for 24x7 on-call support. Experience in opening and resolving Oracle TAR's.
• Responsible for database and schema based refresh using export/import and datapump utilities.
• Design, development and maintenance of MVA International Registries Program IRP , MDOT Fair Practices application OFP application, MDOT Contracts Tracking application MCON and MDOT Office of Environmental Programs and Policy EPP applications.
• Provide on-site customer Support.

Confidential

Environment: Oracle Applications 11i 11.5.9 , Oracle 9i 9.2.0.6.0 , Forms 6i, Reports 6i, Oracle 9i Discoverer, SQL Plus 8.1.7.3.0 , PL/SQL, SunOS, TOAD

• This project involved enhancements to the custom built application in the Oracle Applications framework and upgrade of this custom application from version 11.5.1 to 11.5.9.
• Made enhancements to the Custom Built ABC Reports
• Auditors used to generate multiple reports for ABC analysis by submitting multiple concurrent programs. Developed a concurrent program which automatically generates all the reports required for the ABC analysis.
• Upgrade of the Custom built application from 11.5.1 to 11.5.9
• o Created inventory of the Custom built Forms, Reports, Concurrent Programs, Value sets, shell scripts and database tables.
• o Created MD60, MD70 and MD120 for all the modules
• o Created ldt files for the Concurrent Programs and the value sets.
• o Created installation scripts for migrating Oracle forms, reports.
• o Created installation scripts for migrating of Concurrent Programs and Value Sets from ldt files.

Confidential

Oracle Purchasing

Environment: Oracle Applications 11i 11.5.10.2 , Oracle 9i 9.2.0.6.0 , Forms 6i, Reports 6i, SQL Plus 8.1.7.3.0 , PL/SQL, SunOS, TOAD, RAC

• This project involved implementation of Advance Pricing and integration with Oracle Advance Planning 11i Modules.
• With the implementation of Advance Pricing, the List Price and Market Price will be maintained in Advance Pricing instead of item master. Created a function to return Market and List Price from Advance Pricing modules which were used in interfaces L F and other technical components to get list and market price.
• Created interface to import List and Market Prices from a flat file into to Advance Pricing base tables. ATD users use a customized Excel Form to enter Pricing information and then save it to a flat file. Created a interface which reads the data from the flat file and validates the data and then calls the API to process data into the Advance Pricing base tables.
• ATD Planner/Buyer release group of Planned Orders from Advance Supply Chain Planning Workbench to meet certain agreements and to take advantage of certain offers the Vendor provides. Created PO Zoom Customization which allows ATD Planner/Buyer to group Planned Orders by Organization, Planner, Vendor and verify if it meets the minimum vendor criteria or if they need to add another X number of days of supply.

Confidential

Project: Oracle Order Management / Inventory / Financials Suites 11i Implementation

Environment: Oracle Applications 11i 11.5.6 , Oracle 9i 9.2.0.5.0 , Forms 6i, Reports 6i, SQL Plus 8.1.7.3.0 , PL/SQL, SunOS, TOAD Tool for Oracle Application Developer , Oracle Workflow, Oracle 9i Discoverer

• The scope of this project involved implementation of Oracle Order Management, Financials modules 11i and migration of legacy Configurator to Oracle Configurator.
• As Information Analyst responsibilities included:
• In the GL module, designed and developed packages for Journal Import Interface to import journals information into the system. Developed PL/SQL package to validate and insert the validated data into interface tables.
• In the OM module, designed and developed Interface Programs for Importing Purchase Orders using Import Standard Purchase Orders.
• In the INV module, designed and developed Inventory Purchasing requirements Report in extension of inventory min-max report. This report gives all item information including minimum, maximum, on hand, available, reorder as well detail level of supply /demand type, supply/demand quantities, projected on LF hand and other useful information.
• In the PO module, worked on Purchasing Documents Open Interface to import Standard PO, Blanket PO into the PO Module using SQL Loader and PL/SQL.
• In the AR module, customized the standard forms in AR using CUSTOM.pll to make some fields required and to disable fields as per the business requirement.
• In the AR module, developed SQL Loader Program and PL/SQL program to migrate the Customer information captured from the text files and performed data massaging in the staging tables.
• In the AR Module, developed interface for importing customers into Oracle AR using TCA API s.
• Developed AP Invoice import through Payables Open Interface import.
• Customized Invoice aging report, Transaction Aging report, Preliminary payment register report and Transaction Detail Report and Key indicators report using Report 6i Tool.
• Interacting with various module users/functional leads to understand and design the required interfaces reports and forms.
• Involved in generation of FSG reports according to the client requirements.
• Resolving technical issues, guiding the client on various technical setups, Oracle apps technical methodologies to enable client to achieve strong technical foundation for apps project, to achieve high performance and to establish systematic standards and procedures.
• Designed an interface to provide configuration information to Engineering group for developing the Seating and Floor Plans.
• Created interface to supply Order Information for Thomas Bus Warranty System.
• Involved in Registration of Concurrent Programs and defining new users, menus and responsibilities.
• Creating SQL, Object Views, PL/SQL database objects
• Tuning the SQL/PLSQL processes. Analyzing trace files

Confidential

Platform: Solaris 2.5, Windows NT 4.0, Oracle 7/ 8i RDBMS

Tools: OEM, Toad, PL/SQL, SQL Plus, SunOS.

Responsibilities:

• Creating users, roles and assigning resources to the users.
• Creating Objects Tables, Indexes, views etc
• Configuring SQL Net
• Tuning the SQL statements for optimizing performance.
• Tuning the application using Tools like EXPLAIN PLAN
• Monitoring the databases and optimizing them.
• Writing stored procedures and packages.
• Rebuilding the Indexes
• Creating Database links.
• Optimizing statements of Client s application

Confidential

Project: Patent Information Management System

Tools: Solaris 2.5, Windows NT 4.0, Oracle 7/ 8i RDBMS, Developer 2000, SQL Forms, SQL Report 1.1.

Description of the system Role and Responsibilities:

• This system aid the Office of General Counsel of Xerox Corporation in monitoring the Patents filed for their products in various countries, payments made to different countries and agents. My primary role in this position is to support the system and provide technical expertise as and when required. I have been involved with:
• Upgrading the system from Forms v 3.0 on Solaris 2.5 platform to Forms v 5.0 on Windows NT 4.0 platform.
• Functional Y2K Testing and documentation
• Creating Oracle Terminal key mapping for users in Forms v 5.0 to emulate the key mapping in Forms v 3.0 VT100 .
• Developed alternate code for fixing Oracle bugs.
• Made enhancements to the COST module of the system to meet changing business requirements.
• Developed Maintenance Tracing System which would assist the system support personnel to effectively monitor the changes made to the system.