Venkata Giri Ginjupalli
Phone # 302-399-7364(C)
# 303-325-7805(H)
Email : dbagiri@yahoo.com
Objective
To seek a challenging career in the areas of business analysis, development and maintenance of Internet, intranet, ERP applications(Oracle E-Business suite), where in my problem solving & analytical skills coupled with extensive experience and technical expertise shall be useful.
Experience Summary
Over Ten years of designing, development, maintenance, implementation, Database Administration experience in Oracle based ERP and Datawarehouse systems
Good understanding of Oracle Applications implementation methodology (AIM)
Around 8 years of experience in Oracle Applications 10.7NCA and 11i (11.5.4/11.5.7/11.5.9/11.5.10.2)installations, implementation, customizations and Database Administration
Worked on Oracle Applications(10.7 & 11i) Financials, Distribution, Manufacturing, CRM Modules & Embeded Data Warehouse (EDW)
Worked on Oracle 9i / 10g RAC( Real Applications Clusters) with E-Business suite 11.5.9/1.5.10 and Parallel Concurrent Processing (PCP) Configuration
Installation, Configuration and implementation of Oracle E-Business suite 11i and oracle9i/8i/7x on various platforms i.e. Sun Solaris 2.5 to 2.8, AIX 4.3.2/4.3.3, Linux 2.1/3.0
Configuration of Oracle Applications 11i with Oracle Portal 3.0.9 & OID
Configuration of Business Intelligence systems With Oracle Applications 11i
Upgrading Oracle Applications 10.7NCA to Oracle Application 11i(11.5.5)
Worked Oracle Application Database performance Tuning
Working knowledge of Oracle E-business suite Multi language support (MLS) and Installation
Good knowledge of functional aspects of Oracle applications GL, AP, AR, OM, INV, PO modules
Well versed with Oracle E-Business Suite Advanced configurations like Oracle HTTP Server with Cisco Loadbalancer, Forms Load Balancing, Jserv Loadbalancing etc.
Holding Oracle certification in Oracle 8, 8i, 9i & 10g Database administration
Worked on Large Oracle Ladabases ( 300GB to 1 TB)
Well versed with Oracle High Availability Solutions( Standby database in Oracle 8i and Data Guard in Oracle 9i) for E-Business Suite and Standalone Oracle Database
Well versed with Global database standards, SQL, Export/Import, SQL*Loader, PL/Sql Development, Shell Scripts, and User management
Extensive experience in the database design, capacity planning, administration of Oracle Database, Backup and Recovery, SQL Tuning, Disaster Recovery, Installation of Oracle Software, Oracle 9iAS portal v1.0.2.2, RMAN, Netbackup
Logical and physical database design for Datawarehousing and used ETL tools
Requirements gathering & analysis.
Project co-ordination
Worked for two of the big 5 consulting firms Oracle Consulting Services and IBM Global Services.
Certifications
Oracle Certified Professional Oracle 8, 8i,9i, 10g Database Administrator
Technical Skills
ERP : Oracle Applications 11i, 11.0.3,10.7NCA(Financial,
Distribution, Manufacturing & CRM Modules, BIS &
Portals, SSO, OID)
Application Servers : Oracle Application Server 4.0.8.1/ 9iAS / 10g
Databases : Oracle 7X ,8X, 9X & 10g, SQL server7/2000
Programming Languages : C, SQL, PL / SQL, Shell Script, JAVA
Operating Systems : MS-WINDOWS, UNIX (Sun Sloaris, AIX)
NT.Red Hat Linux 3.0
Front-end Tools : Developer 2000, Forms 6i, Reports 6i and Discoverer4.x, SQR Reports
DBA Tools : Oracle Enterprise Manager, OAM, TOAD, Export & Import , SQL Loader,RMAN,STATSPACK
ETL Tools : Tapestry/Informatica, Data Stage
Other Tools : SQL*Loader, Erwin,Designer 2000, NetBackup, Visio, MS project MS word , Excel etc
Jeppesen, CO May 06 till Date
Role : Consultant (Oracle Applications DBA)
Project Description
For more than 70 years Jeppesen has made it possible for pilots and their passengers to safely and efficiently reach their destinations. Today this pioneering spirit continues as Jeppesen delivers information and technology-based information management tool sets essential to navigation and efficient operations management to air, sea and rail operators around the globe. Jeppesen is a subsidiary of Boeing Commercial Aviation Services, a unit of Boeing Commercial Airplanes
Responsibilities
Installation and Configuration of Oracle E-business Suite 11.5.10.2 in RAC environment on Sun Solaris (2 Web Nodes, 2 Concurrent Processing /Database Nodes)
Configuring Parallel concurrent processing (PCP)
Upgrading Oracle Applications database from 10.1.0.4 to 10.2.
Configuration of Workflow Notification Mailer, OAM, OEM10g
Applying Oracle Applications patches (Maintenance Pack, Interoperability patch,Family pack, one of Patches etc)
Cloning Oracle Applications production system, for Testing and UAT and Devlopment purpose, using RAPID clone
Oracle Applications Systems Administration
Working with Functional consultants, Technical consultants and end users in code promotions, setups & resolving various issues during implementation.
Configuration of Oracle HTTP server load balancing with Cisco Load Balancer/Content switch/ SSL Accelerator
Configuring Autoconfig on 2 Node RAC E-Business suite.
Capacity planning for PROD, TEST, DEV and patching instances for E-Business Suite
Developing and Implementing Disaster Recovery(DR) Strategy for Oracle E-Business Suite (Standby Database)
Developing and implementing Backup and Recovery strategy
Cordinating with Developers & Testers in various phases of SDLC
Maintenance of Oracle Applications through Autoconfig.
Day-to-day database and Oracle Apps maintenance tasks like checking alert logs, analyzing tables, space mgt. and purging some of FND tables etc.
Interacting with Oracle Customer Support and logging iTAR as and when required
Patching security vulnerabilities as and when released by Oracle Support
Environment : Sun Solaris 9 / 10, Oracle Applications 11.5.10
(Financials , Distribution Modules & CRM Modules) Oracle 10gR2, Oracle
Applications Server 10g, Oracle Forms 6i, Oracle Reports 6i, OAM,
Licence Manager, STATSPACK, Rapid wiz, Rapid Clone, Auto upgrade,
Adpatch, Adadmin, Adctrl, Toad 7.3, Sqlplus, OEM, EMC Storage)
Kroll Factual Data, CO Jun 05 April 06
Role : Oracle Applications DBA
Project Description
Kroll Factual Data provides a wide range of customized information services to businesses across the United States that assist them in making crucial decisions, such as determining whether to make a mortgage or other loan, offer employment, accept new tenants, or enter into a business relationship. We are an industry leader in delivering our services over the Internet and in utilizing technology and focusing on customer service to provide our services with the speed, reliability, accuracy and customization that industry participants increasingly demand.
Responsibilities
Installation and Configuration of Oracle E-business Suite 11.5.9/11.5.10 in RAC environment on RedHat Linux Platform (4 Web Nodes, 2 Concurrent Processing /Database Nodes)
Upgrading Oracle E-business Suite 115.9 to 115.10
Configuration of Oracle HTTP server load balancing with Cisco Load Balancer/Content switch/ SSL Accelerator
Configuring Autoconfig on 2 Node RAC E-Business suite.
Upgrading RedHat Linux AS 2.1 to RedHat 3.0 AS
Capacity planning for PROD, TEST, DEV and patching instances for E-Business Suite
Researching and Implementing Archival and Purge solutions(OuterBay, Applimation & Solix) for Oracle E-Business Suite
Developing and Implementing Disaster Recovery(DR) Strategy for Oracle E-Business Suite (Standby Database)
Developing and implementing Backup and Recovery strategy for 1 TB size database
Upgrading Oracle Applications database from 9.2.0.4 to 9.2.0.6/9.2.0.7
Configuration of BIS (Discover 4i with E-business suite)
Configuration of Workflow Notification Mailer, OAM, OEM10g
Applying Oracle Applications patches (Maintenance Pack, Interoperability patch,Family pack, one of Patches etc)
Oracle Applications Systems Administration
Cordinating with Developers & Testers in various phases of SDLC
Maintenance of Oracle Applications through Autoconfig.
Tuning the Oracle Applications process viz. Auto Invoice, Statement Generation, Workflow & Adhoc queries for optimal performance
Cloning Oracle Applications production system, for Testing and UAT purposes, using RAPID clone
Day-to-day database and Oracle Apps maintenance tasks like checking alert logs, analyzing tables, space mgt. and purging some of FND tables etc.
Interacting with Oracle Customer Support and logging iTAR as and when required
Patching security vulnerabilities as and when released by Oracle Support
Environment : RedHat AS 2.1 / Red Hat Enterprise Linux 3.0, Oracle Applications 11.5.9/11.5.10 (Financials (includes iReceivables), Distribution Modules & CRM Modules) Oracle 9i R2(9.2.0.4 & 9.2.0.7) Real Application Clusters(RAC), OCFS 1.0.13.X, Oracle Cluster Manager 9i, Oracle 10gX, Oracle Applications Server 10g, Oracle Forms 6i, Oracle Reports 6i, OAM, Licence Manager, STATSPACK, Rapid wiz, Rapid Clone, Auto upgrade, Adpatch, Adadmin, Adctrl, Toad 7.3, Sqlplus, OEM, IBM Flash Copy / Volume Copy, IBM FastT Storage)
GE Access, CO May 04 May05
Role : Oracle Applications DBA
Project Description
GE Access, a premier value-added technical distributor of complex computer products, solutions and services, a General Electric company. As a Oracle Applications DBA I was reponsible for the following :
Responsibilities
Upgrading Oracle Applications from 11.5.4 to 11.5.9(Fin, Distribution & CRM Modules).
Installation and Configuration of Oracle Applications Server 9iAS / Oracle Application Server 10g (9.0.4) as part of integrating Oracle E-Business suite with SSO & OID, SiteMinder and Identity Minder
Applying Oracle Applications patches (Maintenance Pack, Interoperability patch,Family pack, one of Patches etc)
Configuration of Workflow Notification Mailer, OAM, OEM10g
Upgrading Oracle Applications database from 9.0.1 to 9.2.0.5
Oracle Applications Systems Administration
Cordinating with Developers & Testers in various phases of SDLC
Installation and configuration of Oracle Applications Manager(OAM)
Maintenance of Oracle Applications through Autoconfig.
Tuning the Oracle Applications for optimal performance( Auto Invoice , adhoc queries etc)
Cloning Oracle Applications production system, for Testing and UAT purposes, using RAPID clone
Registering concurrent programs, printers etc.
Day-to-day database and Oracle Apps maintenance tasks like checking alert logs, analyzing tables, space mgt. and purging some of FND tables etc.
Testing and Implementing latest features of Oracle like LMTs, Dynamic Memory Management
Interacting with Oracle Customer Support and logging iTAR as and when required
Patching security vulnerabilities as and when released by Oracle Support
Environment : Sun Solaris 2.8, Red Hat Linux 3.0, Oracle Applications 11.5.4/11.5.9 (Financials (includes iReceivables) Distribution Modules & CRM Modules) Oracle 9i R2(9.2.0.5), Oracle 8i(8.1.7.4), Oracle 9iAS Rel 2, Oracle Applications Server 10g, Oracle Forms 6i, Oracle Reports 6i, OAM, Licence Manager, STATSPACK, Rapid wiz, Auto upgrade, Adpatch, Adadmin, Adctrl, Toad 7.3, Sqlplus, OEM, PVCS, Kintana,Load Runner, Netgrity SiteMinder, Identity Minder)
Oracle Corporation NY Sep03 May 04
Role : Oracle Applications DBA
Project Description
Oracle Coportation, One of the leading ERP vendor involved in implementing Oracle Applcations(11i), Oracle Financial Services applications(OFSA), Oracle Enterprise Data warehouse, Oracle portals, Oracle workflow, Oracle Discoverer for one of their esteemed client JPMorgan Chase(JPMC) as a part of thier Global Financial Applications project. JPMC is one of the leading wholesale Financial instituiton, is in the process of reengineering their business operations through out the world with a concept of One Firm, One team and One Process. As a part of Global Financial Architecture, JPMC is implementing above mentioned oracle products all over the world. DBA's team consists of 10 members, As a senior Oracle Applications DBA I was reponsible for the following :
Responsibilities
Installation and Configuration of Oracle E-business suite 11i(11.5.7/11.5.9) & Oracle Enterprise datawarehouse
Upgrading Applications from 11.5.7 to 11.5.9
Converting Oracle Applications to Multi-Org
Installation and Configuration of Oracle Applications Server 9iAS
Applying Oracle Applications patches (Maintenance Pack, Interoperability patch,Family pack, one of Patches etc)
Configuration of Oracle Portals, Single Sign on with E-Business Suite 11i
Configuration of BIS Financial Intelligence (FI)
Upgrading Oracle Applications database from 8.1.7 to 9.2.0.3
Oracle Applications systems administration
Cloning Oracle Applications production system, for Testing and UAT purposes, using RAPID clone
Registering concurrent programs, printers etc.
Day-to-day database and Oracle Apps maintenance tasks like checking alert logs, analyzing tables, space mgt. and purging some of FND tables etc.
Installation and configuration of ADI
Configuration and monitoring Replciation
Testing and Implementing latest features of Oracle like LMTs, Dynamic Memory Management
Interacting with Oracle Customer Support and logging iTAR as and when required
Developing, Testing and Implementing Sound backup and Recovery Strategy
Developing Hot & cold backup scripts to automate the backup procedures
Project Co-ordination
Planning for storage spaces requirements and placing them for optimum I/O performance
Creation and maintenance of TEST/UAT databases as and when required
Tuning the Oracle Applications databases for optimal performance
Environment : Sun Solaris 2.8, Oracle Applications 11.5.7/11.5.9 (Financials Modules & Enterprise Datawarehouse (EDW)), Oracle Financial Services Applications (OFSA), Oracle 9i R2(9.0.2.3), Oracle 8i(8.1.7.4), Real Applications Cluster (RAC), Oracle 9iAS Rel 2, Oracle Applications Server 10g, Informatica, Datastage Oracle portal, Oracle Forms 6i, Oracle Reports 6i, Discoverer4i, OAM, Licence Manager, STATSPACK, Rapid wiz, Auto upgrade, Adpatch, Adadmin, Adctrl, Toad 7.3, Sqlplus, OEM.
Opentech Corporation Oct02 Jul 03
Role : Sr. Oracle Applications DBA
Project Description
The client is a local Oracle Partner engaged in providing Oracle consulting services for the Oracle E-Business Suite, offsite networking services, Sun Hardware and other offsite services. Opentech Coporation provides solutions that facilitate organizations to reach their peak performance, assisting them to transform their current technology setup from potential value to real value.
Responsibilities
Installation and Configuration of Oracle E-business suite 11i(11.5.7&11.5.8)
Converting Oracle Applications to Multi-Org
Applying Oracle Applications patches (Maintenance Pack, Interoperability patch,Family pack, one of Patches etc)
Configuration of Oracle Portals, Single Sign on with E-Business Suite 11i
Configuration of Notification Mailer
Configuration of BIS Financial Intelligence (FI)
Upgrading Oracle Applications database from 8.1.7 to 9.2.0.3
Oracle Applications systems administration
Cloning Oracle Applications production system, for Testing and UAT purposes, using RAPID clone .
Customizations requirements study, helping Developers in designing, developing and customization of Reports.
Registering concurrent programs, printers etc.
Creation of Menus,Responsibilities, users
Day-to-day database and Oracle Apps maintenance tasks like checking alert logs, analyzing tables, space mgt. and purging some of FND tables etc.
Installation and configuration of ADI
Testing and Implementing latest features of Oracle like LMTs,
Interacting with Oracle Customer Support and logging iTAR as and when required
Developing, Testing and Implementing Sound backup and Recovery Strategy
Developing Hot & cold backup scripts to automate the backup procedures.
Project Co-ordination
Planning for storage spaces requirements and placing them for optimum I/O performance
Creation and maintenance of TEST/UAT databases as and when required
Tuning the databases for optimal performance
As a team lead mentored a team of Jr. DBA and a developer
Environment : Sun Solaris 2.8, Oracle Applications 11.5.7/11.5.8 (Financials, Distribution and Manufacturing Modules), Oracle 9i R2, Oracle 8i(8.1.7.3), Oracle 9iAS, Oracle portal, Oracle Forms 6i, Oracle Reports 6i, Discoverer4i, OAM, Licence Manager, STATSPACK, Rapid wiz, Auto upgrade, Adpatch, Adadmin, Adctrl, Toad, Sqlplus, OEM .
IBM Global Services Apr01 to Sep 02
Role : Consultant / Oracle Applications DBA
Project Description
IBM Strategic Outsourcing Services is the management of a companies' applications and information technology (IT) systems. Customers strategically partner with IBM to manage and operate their applications and IT systems, generally under a mutually beneficial agreement. The outsourcing agreement may include the transfer of IT employees and IT assets to IBM. IBM provides service level assurances to ensure quality of service is attained and measured.
As a consultant / Oracle Applications DBA, I was responsible for the following:
Responsibilities
Installation and upgradation of Oracle Applications 10.7 /11.0.3/11i(11.5.3 & 11.5.5) (Financial & Distribution modules)
Day-to-day database and Oracle Apps maintenance tasks like checking alert logs, analyzing tables, space mgt. and purging some of FND tables etc.
Logical and Physical Database design
Upgradation of Oracle Applications from 10.7 to 11.0.3
Configuration of Oracle Portals, Single Sign on with E-Business Suite 11i
Configuration of Notification Mailer
Configuration of BIS Financial Intelligence (FI)
Upgrading Oracle Applications database from 8.1.7 to 9.0.1
Upgrading Oracle7.3.4 to 8.0.3 to 8.1.7
Oracle Applications systems administration
Applying Oracle Applications Patches/Maintenance packs/Family pack
Cloning Oracle Applications production system for Testing and UAT purposes.
Helping Developers in designing, developing and customization of Reports.
Registering concurrent programs, printers etc.
Installation of Oracle on Unix, and NT.
Instllation, configuration and maintenance of SQL server
Installation, configuration and maintainance of Standby database
Planning for storage spaces requirements and placing them for optimum I/O performance
Planning for necessary online and offline backup using Netbackup tools.
Developing and testing proper backup and recovery procedures using RMAN
Creating users, granting required roles and allocation of tablespace quotas.
Installation and using Oracle Enterprise Manager for some of the maintenance tasks.
Configuration and monitoring Replciation
Creation and maintenance of TEST databases upon clients request.
Developing and Testing Disaster recovery procedures.
Interacting with Oracle Customer Support and logging iTAR as and when required
Data warehouse Project
Software : Oracle 8.0.5, Oracle Discoverer 3 and Express Server
Tapestry(ETL Tool)
OS : AIX .4.3.2
Responsibilities
Logical and Physical Database design for staging area databases and data marts
Helping developers in designing, coding developing interface programs
UAT
Developing ETL scripts
Automating ETL jobs using shell scripts
Performing all daily database Maintenance tasks
Project coordination
Creating End user layers for Discoverer
Developing Discoverer reports
Wrote database export & import scripts to backup database structures.
Environment : Sun Solaris 2.5, AIX4.3.2, Oracle Applications 10.7NCA/11.0.3/11i(11.5.3) (Financial & Distribution Modules), Oracle 7.3.4 & 8.0.3/8i, Oracle WAS, OEM, Designer 2000. SQL Server 7/2000,
Johnson & Johnson Jul 99 to Mar01
Role : Systems Analyst
Project Description
Johnson & Johnson (J&J) is the world's most comprehensive manufacturer of health care products, as well as a provider of related services, for the consumer, pharmaceutical and medical devices and diagnostics markets. J&J has implemented oracle applications 10.7NCA financial & Distribution modules.
Oracle Applications 10.7 NCA: Aztech had implemented Oracle Applications 10.7 NCA, which includes Financials modules , Distribution and Manufacturing modules.
Quotation Management System (QMS): Aztech has developed this application to cater the needs of purchasing department using Oracle 8 as backend and VB as front end. This application is integrated with Oracle Application Order Entry module.
For Your Information (FYI): FYI is a data warehouse project developed to cater the needs of the top management using Oracle 8 as back end and Oracle Discoverer as front End. FYI database is populated with data from Oracle Applications database every day.
Responsibilities
Requirement study
Helping and coordinating with end users for smooth operations
Logical and physical database design for Data warehouse project
Configuration of Oracle Applications 10.7NCA, and Oracle Discover
Administering Oracle Applications databases.
Helping developers in designing, developing and customization of Oracle Applications
Oracle Applications System Administration
Applying database patches and Oracle Applications 10.7 patches.
Planning for necessary databases, their storage spaces requirements and placing them for optimum I/O performance
Refreshing UAT / TEST database
Designing and implementing database backup and recovery strategy using RMAN
Installation of Oracle 8x and creation of new database.
Data extraction from Oracle Applications database and uploading it into Datawarehouse database.
Wrote database export & import scripts to backup database structures.
Database reorganization to avoid fragmentation for better performance.
Creation and maintaining Test database
Customisation of reports
Developing interfaces to OM
Using SQL* Loader to upload data from flat files
Environment : Windows NT 4.0, Oracle Applications 10.7NCA(Financial, Distribution and Manufacturing modules), Oracle 7.3.4,8.0.3 Forms4.5, Reports2.5 and WebDB2.0, SQL Loader
Singapore Tourism Board, Singapore Mar99 to Jun99
Role : Consultant
Project Description
Singapore Tourism board has implemented Oracle Applications 10.7 NCA Financial modules GL, AP, AR, PO & CMfor streamlining their Financial Accounting system
Responsibilities
Customization of reports & forms
Day-to-day maintenance of Oracle Apps Database
Installation and configuration of Oracle, Oracle Applications 10.7NCA
Helping developers in designing, developing and customization of Oracle Applications reports and forms
Designing and implementing database backup and recovery strategy
Applying patches on Oracle Applications
Registering concurrent programs
Coordinating with other programmers
Interacting with Oracle support as and when required
Automating backups using cronjobs
Developing interface programs to upload bank statement to CM module
Environment : Sun Solaris 2.4, Oracle 7.3.4, Oracle Application 10.7 NCA(FIN), Forms4.5 & Reports2.5, SQL Loader
ESPN Starsports, Singapore May98 to Dec98
Role : Systems Analyst
Project Description
ESPN STAR Sports (ESS) is a 50:50 joint venture between two of the worlds leading cable and satellite broadcasters, ESPN Inc. and STAR. ESS is Asias definitive and complete sports provider
Responsibilities
Requirement Analysis.
Coding and Testing.
Customization / Development of new reports
Development of new reports using SQR Reports
UAT
Integration of Oracle Receivables with Order Entry (Legacy System) using PL/SQL.
Registration of concurrent programs
Customization of Oracle Applications forms
Oracle Financials Systems administration and Database Administration.
Day to day database administration
Environment : DG Unix, Oracle Applications 10.6SC, Oracle 7, forms 4.5 & Reports 2.5, SQR Reports
Price Watershouse , India Nov97 to May98
Role : Consultant
Project Description
Price Waterhouse consulting has implemented Oracle Applications 10.6SC, Financial modules for Usha Martin Telecom Ltd (UMT). UMT is one of the cellular services provider in Calcutta, India.
Responsibilities
Process Study.
Requirement Analysis
Mapping Analysis
Bespoke Development
Setup
UAT
Envoronment : Sun Solaris, Oracle Applications 10.6SC(Financial Modules), Oracle 7.3.2
Continental Informatics India Ltd, India Aug96 to Oct97
Role : Systems Design and Testing
Project Description
A system developed in-house for the Accounting department of the Continental Informatics India Ltd. This project includes a HR management module and a full-fledged Payroll processing system..
Environment : MS Windows, Oracle7.X, Forms4.5 and Reports2.5
Model Financial Corporation Ltd, India Aug94 to Jul96
Role : Requirements study, Systems design & End user Training
Project Description
The system consists of 5 modules viz. Accounts Master, Customer Master, Hire Purchase Master, Lease Master and Reports. The system was designed in Oracle 7.1 and Developer 2000.
Environment : MS Windows, Oracle7.X, Developer 2000
Education
19891992 B.Com Osmania University, Hyderabad, India
1992-1994 M.B.A Shivaji University, Kolhapur, India
1994-1995 PGDCA Intel Computer Training center, Hyderabad, India
Member number:9619
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2006 Venkata Giri Ginjupalli and Software Contractors' Guild,
Post Office Box 257,Nottingham, NH USA 03290-0257