Gopala Medapuram
Email: abqezi@r.postjobfree.com
Address: **** ********* ****** ** #*
City: North Canton
State: OH
Zip: 44720
Country: USA
Phone: 330-***-****
Skill Level: Management
Salary Range: $120,000
Willing to Relocate
Primary Skills/Experience:
ERP DBA Offshore work mgmt Mentoring Lead work
Educational Background:
Bachelors Degree, Mathematics Physics Chemistry
Sri Venkateswara University, 04/1983 - 08/1986
Tirupati, AP, India
Not Selected,, Not Selected
Job History / Details:
Gopala Medapuram
North Canton, OH 44720
H: 330-***-**** / C: 330-***-****
abqezi@r.postjobfree.com
www.linkedin.com/pub/gopala-medapuram/4b/b25/920
Global Oracle Applications DBA Lead
Enterprise Resource Planning ~ Systems Analysis ~ Database
Administration
Accomplished Global Business / IT Management Professional
delivering value creation through the alignment of business and
technology strategies. Demonstrated success leading innovative
solutions in business relationship management, project
management, business and systems analysis, architecture
definition and design in areas of business applications,
business intelligence, and data management. Results-oriented
individual with proven ability to implement enterprise change
that delivers business results. Solid leadership skills, capable
of influencing and motivating individuals to maximize levels of
productivity while forming cohesive global team environments.
Exceptional communicator focused on building strong
relationships. Specific expertise in the following:
* Collaborative / Innovative Leader
* Process Improvement
* Project Management
* Business Intelligence
* Business Relationship Management
* Data Integration Process Management
* Business Analysis
* Data Management Strategies / Governance
* Application Development Management
* Strategic Planning
* BI Program Management
* Managed & Coordinated Global Teams
* Employee Development
TECHNICAL SKILLS
Oracle Applications:
Oracle Applications (11.0.2, 11.5.1 - 11.5.10, 12.1.3)
Databases:
Oracle 5, 6, 7.x, 8.x, 8i, 9i, 10g, 11gR2
Technical:
Database and System Administration, Application Object Library,
Flex fields, Oracle Web Application Server, 9iAS, OAM, Platinum
3.1-5.1, Oracle Framework (5.7, 5.10), Autoconfig, OAM, OEM
Modules:
HRMS, SCM, Financials, Manufacturing, Order Management, CRM
modules, Self Service Web applications, Workflow
Operating Systems:
Linux, Sun Solaris, HP, Windows (95/98/2000), AIX
Front End Tools:
Forms, Reports, Discoverer, Framework
Oracle Related Software:
Vertex (for HRMS US legislations), Statspack
Software Languages:
SQL, SQL*PLUS, PL/SQL, SQL Developer
Other Systems / iAS / Tools:
HP PPM, Kintana, Demantra, GRC, SOA, SQL*Loader, TOAD, MS Office
Suite, AIM, Data Loader, SharePoint, WebLogic, Apache
PROFESSIONAL EXPERIENCE
Diebold Corporation, North Canton, OH
2004 - 2012
A multinational corporation providing integrated self-service
security systems and services.
Oracle Applications Lead DBA / Release Manager
2006 - 2012
Led projects viz., 11.5.8 to 11.5.10 upgrade, GRC implementation,
Demantra implementation, Moving HR from 11i to R12.
* Served as DBA liaison for on-shore / off shore activities;
coached / mentored DBAs on / off shore; orientation; training;
knowledge transfer.
* Release manager activities: conducted / led quarterly releases
for 11i / R12 instances for database upgrades, database security
patches, apps patches, promoted HP PPM`s packages on:
development, test, patch, SIT, UAT, performance, and production
instances.
* Led migrate 11gR2 instances from Oracle Linux 5 to AIX 7.1.
* Continued interaction with help desk team leads on improving
customer support for technical solutions, which led to more
quality solutions and knowledge base.
* Continued interaction with QA team lead in order to assure
good performance tests.
* Led 24 / 7 support of ALL production Oracle apps (11i, R12)
and non-apps (local grown) instances.
* Maintained release track instances: development, test, patch,
SIT, UAT, and performance instances.
* Installed, cloned, and patched R12 Oracle RAC Non-RAC
application instances.
* Provided technical documentation on installation / strategic
planning / topology and various issues resolved. Helped
Sutherland helpdesk team in building knowledge base documents.
Sr. Oracle Apps DBA
2005 - 2006
Served as Production support lead for Oracle applications,
including: Financials, HRMS, and HTML applications - SSWA.
* Responsible for resolution of production issues.
* Patched applications, including: one-off, patch-set, mini pack,
and maintenance release.
* Cloned (Multi-node to Single-node; Multi-to-Multi node) and its
related issues.
* Supported family pack patching, release upgrade, and its
related issues.
* Processed streamlining, including: JavaMailer, Concurrent
Managers, Autoconfig, GSM, OAM, HTTP Load Balancer, PJC Jspell,
and ADI WebADI.
* Worked with Oracle support in resolving various `Service
Requests`.
* Documented the established processes.
Environment: AIX, Windows, Oracle applications (11.5.7,
11.5.10)
Oracle Apps DBA / Database Supervisor
2004 - 2005
Provided complete support to clients` production, test, and
development 11i application instances. Supported Oracle
Financials, including: GL, AP, AR and Oracle HTML applications -
SSWA modules and Supported Oracle manufacturing modules,
including: Discreet Mfg. / Inventory / Order Entry / Product Hub
/ WMS. Supervised a team of eight DBAs / developers.
* Managed multiple instances; cloning production instance every
weekend (Multi-node to Single-node; Multi-to-Multi node).
* Monitored day-to-day support of development activities.
Supervised all Oracle and Application Servers.
* Provided an instance, Installing or Cloning, on Linux on a
weekly / fortnightly basis.
* Designed and supervised sandbox for testing and development.
* Supported the maintenance activities, including: system
backups, patching, compiling forms, and reports.
* Led and supported on-line and offshore community of DBAs /
developers / users.
* Supported Oracle upgrade 11.5.3 - 11.5.9.
* Served Clientele including: American Greetings, OH; Sunrise
Greetings, IN; Bridge Stone Consulting Inc., TX; SystemGuru Inc.,
NJ; and GE Fort Wayne, IN.
Environment: AIX, Sun Solaris, HP Unix, Linux, Windows NT;
Oracle application (11.5.7 - 11.5.9)
dB Professionals, Rolling Meadows, IL
2003 - 2004
Managed servicing and training company.
Oracle Apps DBA / Database Supervisor
Senior DBA responsible for installing, maintaining Oracle
databases, and supervising team of three DBAs / developers.
* Responsible for Remote administration of Oracle application
servers.
* Upgraded applications from 11.5.8 to 11.5.9.
* Worked extensively in different modules like OM, AR, AP, PO,
FA, GL, and HRMS.
* Wrote Unix shell Scripting for batch jobs.
* Monitored applications 24 / 7 through customized scripts and
Oracle Applications Manager.
* Troubleshot Oracle Applications using TAR and Oracle Support
For the same.
* Led QA efforts before any move into production, which increased
quality solutions.
Environment: Linux and Windows NT; Oracle application (11.5.8 -
11.5.9)
Oracle Corporation, Redwood Shores, CA
1999 - 2003
Leading Database and ERP Solutions Company.
Senior Consultant
Performed Oracle applications installations (11.5.2 - 11.5.8),
setup, maintenance, support, performance tuning, and
troubleshooting of Oracle Applications Database, HTTP server
(Web / Apache Server). Provided extensive on-line and off-line
application support to 75 technical, functional consultants, and
general users.
* Worked on the internal implementation of the following
business flows, which were published in metalink.oracle.com and
supported by Oracle: Accounting to Financial Reports, Call to
Resolution, Click to Resolution, Contract to Renewal, Dispatch
to Repair, Depot to Repair, Order to Cash, and Procure to Pay.
* Supported major modules involved in the project: GL, AP, AR,
FA, INV, OM, WSH, PO, PA, HR, MRP, INV, WIP, BOM, CRM BFA
modules, People-to-Paycheck (part of HRMS).
* Cloned instances using various methods like adclone, rapid
clone, and traditional instance copying.
* Responsible multi-node installation on HP and Sun systems.
Implementation of flows, Technical documentation.
* Wrote Unix shell scripting for batch jobs.
* Worked closely with client`s functional and development team
during the implementation.
* Configured and worked with forms server, web server, Apache
Server, Oracle Alerts, Workflow, OAM, and Discoverer.
* Troubleshot Oracle applications and database issues using TAR
and Oracle Metalink for the same.
* Responsible for database upgrades from 8.1.6 to 8.1.7 and 8i
to 9i.
* Served clients including: Oracle Corporation, CA; University of
Chicago Hospitals; City of Chicago; Chicago Police Department;
Allstate; Ameritech; Motorola, IL; ResoDirect, VT.
Environment: Sun Solaris, HP Unix, Linux, Windows-NT; Oracle
applications (11.0.2, 11.5.2 - 11.5.9); ERP financials / CRM,
Self Service Web apps, iStore, iProcurement, call-to-order,
click-to-order, people-to-paycheck, Discoverer, OAM, HR - Vertex
Interactive Business Systems, Oakbrook, IL
1998 - 1999
An IT solutions and staffing company.
Senior Oracle DBA, Consultant
Provided database conversion and technical support.
* Managed conversion of an Oracle based customer information
database from Novell NetWare 3.11 to WINDOWS NT 4.0, and from
Oracle 6.0 to 7.3.3 Enterprise Version.
* Compiled and debugged the Pro*COBOL programs, utilizing
Micro-focus COBOL and the Pro*COBOL pre-compiler.
* Performed TAR maintenance.
* Served clients including: Harza Engineering, Chicago, IL
Environment: Toad, Oracle internal switch tools, Oracle8i, Sun
Solaris, AIX
BrilaSoft Inc, Sunnyvale, CA
1996 - 1998
Leading global information technology services company providing
business process consulting and business solutions.
Senior Oracle DBA, Consultant
Provided configuration and support of two production databases: A
technical support database and a human resources database running
under PEOPLESOFT. Database Conversion and technical support was
the main purpose of the project.
* Provided space management installation, performance tuning,
troubleshooting, security management, and documentation of the
128 GB Oracle 7.3 database.
* Provided configuration and support of two production databases:
a technical support database and a human resources database
running under PEOPLESOFT.
* Served clients including: PacifiCare Insurance, Cyprus, CA;
Chicago Bridge and Iron, Plainfield, IL
Environment: Platinum DBA tools, Toad, Oracle8, Sun Solaris,
AIX, and Windows-NT
FIIT, VSPGS, Hyderabad, India
1989 - 1996
IT Training and Software development company.
IT Dept Manager / Senior Oracle DBA
Managed and supervised a team of 12 DBA`s / developers /
instructors.
* Supervised database development, conversion, and technical
support to different projects including hospital, material,
transport, and library management systems.
* Assisted with initial case study, installed systems, required
software, maintained software, and established connections.
* Served as a programmer Analyst for the institute affiliated to
a major common wealth university, developed and administered a
variety of database applications, including a Student Management
System and a Financial Accounting System. These applications
were written using Oracle 6.0 and 7.1 under SCO UNIX, NetWare,
WINDOWS 3.x and MS DOS.
Environment: Oracle 5, Oracle 6, Oracle7.3, SQL*Plus, SQL*DBA,
SQL*Load, SCO Unix, Novell Netware, Windows 3.0 (Work group
server) and MS-DOS
EDUCATION
Bachelor of Science (BS) in Mathematics, Physics, and Chemistry
SV University, Tirupati, India
Diploma in Computer Programming and Applications
National Computer Center, AP-Tech, Hyderabad, India