Sathish Vellampalli ****, Mammoth Dr, Irving, TX - 75063

Cell: 630-***-****, adcoo5@r.postjobfree.com

linkedin.com/in/satish-vellampalli-b656365

Objective

A challenging position that will utilize my technical and leadership experience with opportunities for personal contribution to organizational goals and professional growth.

Eligible to work for any employer in United States of America.

Visa Status: GC-EAD and no sponsorship is required.

Summary

I am an Oracle Cloud Infrastructure Architect/Oracle Apps/Oracle DBA with 14+ years’ experience working on EBS (R12.2, 12.1, 11.5.10.2) as Apps DBA, Oracle Cloud (IaaS/PaaS, OCI, DBCS, JCS & IDCS),, Oracle Identity & Access Management, Fusion Middleware (WebLogic, OBIEE, WebCenter, SOA),, Web Tier (OHS, Apache), DBA (RAC, Data Guard, Parallel Concurrent Processing) and Enterprise Manager Cloud Control on Unix/Linux.

I have designed, and deployed Oracle EBS R12 on Oracle Cloud (both OCI & OCI-C) with Database Cloud Service (DBCS) including integration with Identity Cloud Service (IDCS) and On-Premise Microsoft Active Directory using Identity Bridge.

I have worked on some of most complex and highly available deployments including Disaster Recovery, Server Sizing, Capacity Planning, for both internal & external users. My task includes writing high-level designs, low level designs including sizing, implementation and operations manuals.

Oracle ERP Cloud

OCI/OCI-C Architect

Oracle Cloud (DaaS/PaaS/IaaS)

Oracle IDCS (Oracle Identity Cloud Service)

Oracle WebLogic Administration.

Oracle Database admin

Oracle Application Management Pack

Oracle Application Testing Suite (OATS)

Enterprise Manager12c/13c

Oracle Discoverer/OBIEE with EBS integration

Oracle Demantra

Oracle Hyperion integration with Oracle EBS General Ledgers

SQL Server DBA

Gilead Sciences, SFO, CA May 2019 to Mar 2020

Sr Oracle Apps DBA

Joined as a Consultant DBA with Travel (70%) and responsible for supporting Oracle Landscape (Oracle Apps, Oracle Databases, Oracle Access Manager, Hyperion, Oracle Demantra, DMZ, TLS, SSL, TDE) including the Hardware (RHEL systems).

oJoined to the team to support Oracle EBS upgrade from 12.1.3 to 12.2.8.

oWorked on Install/Configuring Oracle EBS environment with 3 node RAC and with 5 node Shared Appl_top environment.

oWorked on Install/configuring Oracle Demantra and integrate with Oracle EBS environments.

oWorked on Integrating OUD (Oracle Unified Directory) with Oracle Access Manager to enable Single-Sign-On (SSO) with Oracle EBS environments.

oInvolved in TLS and SSL configuration for EBS environments.

oInvolved in Transaction Data Encryption (TDE) for database.

oWorked on adding new OACORES and modifying memory settings for all OACORES to avoid unnecessary outages.

oWorked on adding new OAEA services to enable Single Sign On and integration with Oracle eBS environments.

oInvolved in configuring Oracle 3-node RAC database for the eBS environments.

oWorked on OACORE memory settings and enabled trace to monitor and troubleshoot oacore crashes for eBS R12.2.5 systems

oWorked on WebLogic Patches troubleshooting when the patches have conflicts and remove the patches using bsu utility.

oWorked on adding new OACORE on existing EBS R12.2.5 using WebLogic Admin Console

oWorked on WebLogic Utility WLST to troubleshoot java.lang.OutOfMemoryError by identifying incident id, problem key and incident time.

oWorked on deploying EBS Demantra WebLogic Domain configuration Auditor for tuning Oracle Demantra installation. Implemented this to verify WebLogic parameters as they relate directly to Demantra Implementation. This tool provides us current capacity high count, deployment state, failed reserve request count, highest number available, higher number unavailable, leaked connection count.

oWorked on Oracle Demantra service request performance template for troubleshooting database performance problems with Demantra.

o

One Technologies, INC Mar 2019 to May 2019

Database Administrator

Joined as a contractor DBA for 3 months project to Consolidate SQL Server licenses and migrated the Applications to Std Edition where possible – Cost Savings of close to 1.5 million.

oMigrated Various Application DBs from SQL Server Enterprise to Standard and consolidated various SQL environment to save licensing costs.

oUpgrade SQL Server 2014 to 2017 with the environments enabled with High Availability like Always On, Replication and Always on Groups.

oInvolved in migrating SQL Server databases from On-Premises to AWS RDS environment

oDeploying SQL Server Integration/Analysis and Reporting Services.

oImplemented Backup Strategies for AWS RDS SQL Server environments.

Hudson Advisors, USA June 2009 – Feb 2019

Sr. Oracle Apps DBA/Oracle DBA/OCI

Managed and mentored a team of 5 DBAs. Responsible for supporting Oracle Landscape (Oracle Apps, Oracle Databases, Oracle Discoverer, Oracle Access Manager, Hyperion and OBIEE) including the Hardware (Sun Sparc systems), the applications were running on and SQL Server Environment. Helped team grow from supporting production systems to a value add to the projects by optimizing the processes, automating the daily routines and offloading tier1 tasks to offshore team.

Established Database COE and standardized policies & procedures globally.

Created 24/7 teams with staff in US, Europe and Asia for “follow-the-sun” support model. Delivered 99.99% systems uptime.

Consolidated Oracle and SQL Server licenses and migrated the Applications to Std Edition where possible – Cost Savings of close to 0.5 million.

Ensured best practices followed for the Database Installs/Upgrades/Administration. Data Security and periodic auditing was given priority and passed internal/external audits with no high/medium findings.

Guided the team and participated in the following projects(Hands-on) in addition to the team management and delivery.

R12.1.3 to R12.2.5 upgrade

oWorked with DBA team to upgrade to R12.2.5

oConfigured WebLogic OACOREs to ensure the system stability

oGained Experience on enabling logging/trace and debugging application tier components like OACORE, OAFM, WebLogic & OPMN services

JRE Upgrade – Serve side upgrade and ensured client environment compatibility

Oracle WebLogic Administration/Performance Tuning

oWorked on OACORE memory settings and enabled trace to monitor and troubleshoot oacore crashes for eBS R12.2.5 systems

oWorked on WebLogic Patches troubleshooting when the patches have conflicts and remove the patches using bsu utility.

oWorked on adding new OACORE on existing EBS R12.2.5 using WebLogic Admin Console

oWorked on WebLogic Utility WLST to troubleshoot java.lang.OutOfMemoryError by identifying incident id, problem key and incident time.

oWorked on deploying EBS Demantra WebLogic Domain configuration Auditor for tuning Oracle Demantra installation. Implemented this to verify WebLogic parameters as they relate directly to Demantra Implementation. This tool provides us current capacity high count, deployment state, failed reserve request count, highest number available, higher number unavailable, leaked connection count.

oWorked on Oracle Demantra service request performance template for troubleshooting database performance problems with Demantra.

Oracle Parallel Concurrent Processing (PCP)

oWorked on Parallel Concurrent processing in a 2 node Oracle Apps configured with Oracle database 12c with RAC and ASM.

oWorked on configuring PCP by setting up profiles like Concurrent PCP Instance Check to ON because of instance failover is required.

oWorked on Transaction manager using DBMS_PIPE to communicate by setting up profile Concurrent:TM Transport Type to QUEUE.

oConfigured Kernel Parameters like tcp_keepalive_intvl, tcp_keepalive_probes and also sqlnet.expire_time for DCP Dead Connection Detection to speed up PCP Failover.

oWorked on troubleshooting failover of concurrent manager process takes more than 30 minutes and resolved issue by applying patch 9074047.

Oracle OBIEE/Discoverer Integration with Oracle EBS

oWorked on Installing/Configuring OBIEE 12c to replace Oracle Discoverer 11g.

oWorked on Integrating OBIEE with Oracle EBS for reporting like Business users can view General Ledgers attachments on OBIEE Dashboard.

oWorked on Discoverer 10g to Discoverer 11g upgrades and familiar with Oracle Discover Admin and Desktop Tool configurations.

Oracle Hyperion integration with Oracle EBS General Ledgers

oWorked on configuring Hyperion Data Management integration with Oracle EBS General Ledgers using DRM (Hyperion Data Relationship Management) for chart of accounts values and chart of account hierarchies.

oWorked with Business users to trained them how to use Hyperion DRM for creating versions, hierarchies and nodes to maintain chart of accounts values.

Cloud Security using Oracle IDCS

oExperience in implementing Identify and Management on Premise and Cloud environments.

oExperience in Identity Secure Terminology SAML, OAuth and OpenID connect

oWork experience on Oracle IDCS

Registering for Cloud and Accessing IDCS console

Managing IDCS users, Groups and Applications as (IDCS Administration)

Customizations default notifications and settings

Managing IDCS applications using Token based SSO Auditing and IDCS reports

Familiar with IDCS Rest API’s

Monitoring IDCS Performance and IDCS instance tuning and troubleshooting

Oracle Access Manager

oInstallation, configuration, maintenance of Oracle Middle Fusion including OIM, OAM, OID and OUD on RedHat Linux 6

oUpgraded OAM 11gr2PS2 to OAM 11gr2 PS3.

oEnabled Single Sign On for E-Business environment.

oSelf-service functions, the plugin will redirect requests to the OAM/OAAM gateways for authentication and/or session management.

oEnabled "two factor" (knowledge-based authentication).

oIntegration and Setup of OIM 11gr2PS2 Reconciliation & Provisioning with Active Directory.

oSupported the Entire OIM/OAM system/servers during various stages.

oExtensive experience in implementing and supporting Identity and Access Management environments comprised of Oracle Identity Manager (OIM), Oracle Internet Directory, Oracle Virtual Directory, Oracle Access Manager (OAM) and MS Active Directory.

Oracle Cloud Architect Experience

oConfiguring OCI for EBS R12 & Database Deployment including configuration of VCN, Compartments, Compute and IAM Security Policies.

oPaaS: Oracle Identity Cloud Service (IDCS)-PoC for IDCS Deployment, Integration with Oracle E-Business Suite R12 using EBS Asserter. Integration with Microsoft Active Directory (using Identity Bridge).

oPaaS: Oracle Database Cloud Service (DBCS on OCI & OCI-C):Deploying 18c Autonomous and 12c User-Managed Database using DBCS on OCI & OCI-C. Migrating (Lift & Shift) Database from On-Premise to Cloud including common Administration like Backups & Patching.

oServer Sizing, Capacity Planning, Design and implementation of EBS R12/11i high availability, R12, Upgrade to 12.2, DMZ setup. Integration of EBS with OID, OAM, and OIM. Oracle Apps DBA Installation, Patching, Cloning, Upgrade (11i to R12, Forms & Reports), and Integration with WebCenter. DMZ setup for external facing applications and DR System for Business Continuity

oDesigning and implementation of highly available (Active/Active & Active/Passive) OAM, integration with Oracle E-Business Suite (R12/11i), OBIEE, WebCenter, SOA, UCM/ECM, ODI. Deployment in external/internal setup including SSL setup for Oracle Access Protocol (OAP). Integration with OIM for password management and self-service user management.

oOracle Internet Directory (12c, 11g, 10g, 9.0.x / SSO 10g, 9.0.x):

oDesigning and implementation of highly available OID (LDAP/ASR), integration with Microsoft Active Directory (MS-AD) for user synchronization and authentication, Integration with 11g/10g fusion middleware products, partitioning, Integration & Provisioning Services, Schema Management, Performance Tuning, Capacity Planning, Installation and Upgrades

oDesigning and implementation of highly available OIM, integration with Oracle E-Business Suite (R12/11i) using Employee Reconciliation and User Management, Integration with OID & Microsoft Active Directory (UM) using packaged connectors.

oOracle Database (11g/10g/9i/8i): Data guard, RAC and RMAN

Installation and Administration of database including RAC, Data Guard (physical standby) and backup/recovery (RMAN). Deployment of RAC databases on Exadata Machines.

oOracle Fusion Middleware: SOA, OBIEE, WebCenter, OSB, WebLogic

oDesign/Deployment/Configuration of WebLogic Server, SOA Suite, OBIEE, WebCenter and ESB. Upgrade of Fusion Middleware applications (SOA, OBIEE, WebCenter) from 10g to 11g, SSL configuration and Load balancer for high availability including Integration with Business Applications (EBS) and Identity Management components.

oOracle Enterprise Manager Grid/Cloud control (13c/12c/11g/10g):

Installation/Configuring of OEM Cloud/Grid control, deploying applications using virtual assembly builder, managing and monitoring WebLogic, SOA, R12/11i and Fusion Middleware using OEM 11g and 12c.

oE-Business Suite integration with Cloud Identity (IDCS) & On-Premise OID/OAM for Single Sign-On (SSO)

oOIM Integration with OAM for identity lifecycle management and single sign-on (SSO)

oOIM Integration with Microsoft Active Directory, Microsoft Exchange, and Oracle E-Business Suite for user provisioning and reconciliation.

oExcellent exposure on writing scripts using Python, KSH, Bash

oExcellent exposure on Terraform/Availability Domains/Virtual cloud network.

Oracle Apps 11.5.9 to 11.5.10 Upgrade

Oracle HR implementation

oSupported the implementation as techno-functional resource in addition to Apps DBA

oImplemented VPD based security (using CS*Secure) for the HR data - Top Down

approach for Data Visualization

oImplemented alerting mechanism to inform CIO and HR Director for unauthorized

access of HR Data

oIntegrated APEX with EBS to inherit EBS security, Developed HR Reports in APEX

oImplemented Data masking for HR data for downstream clonings

Oracle PO /SCM 11.5.10 implementation

Oracle Advanced Benefits Implementation

oSupported the implementation as techno-functional resource in addition to Apps DBA

oCo-managed the project as an SME

Oracle HR to ADP Migration

oSME on the Employee Data migration from Oracle to ADP

oEnsured Data retention of Oracle HR as per the policies

Migrated 11i instances from Japan, Korea and Taiwan to North America

Implementation of R12 (R12.1.3) - Global instance

oR12 New implementation - Consolidated multiple 11i instances into a Global instance

oSupported Setups, Data migration from 11i to R12

oSupported multiple CRPs (Business Simulations)

oCloned Various instances, Patching

oImplemented AMP for OEM for better monitoring and support of Oracle Apps

SQL Server Installations/Upgrades/Virtualization/Consolidation

oUpgraded from 2008 R2 to 2012/2014

oVirtualized SQL Servers on VMware

oEarly Adoption of SQL Server 2016 for Portfolio Management Group

oSupported 100+ Instances, 400+ Databases (Raging from few Gig to multi TB)

oMigrated Various Application DBs from SQL Server Enterprise to Standard and consolidated various SQL environment to save licensing costs

Disaster Recovery Setup/Manage using Hot Standdby/RMAN and SRM

Epicor Financials

oLead the efforts to bring in Epicor Systems from outsourced vendor to in-house

oSupported and Stabilized the system

Oracle DB Upgrades

oUpgraded from 9i to 10g, to 11g, to 12c

oVirtualized Oracle environment for Oracle Enterprise Manager (OEM) and RMAN

oSupported 30+ Instances, 100+ Databases (Raging from few Gig to TB)

Platform Migration of R12 (R12.1.3) from Solaris to Linux

oInstallation and Patching of R12 on Linux

oMigrated Data using Data Pump and other Export/Import utilities

oManifest Implementation to get the Linux environment to the latest R12 level

Windows 7, Office 2013 and IE 11 Upgrades

oPatching Oracle and Oracle Apps environments to ensure the certification for Windows 7 Office 2013 and IE 11

oWorked with windows groups to resolve various client side issues

Supported various Data Center Upgrades/Moves

Cloud Automation Tools

Experience in implementing Azure DevOps

Experience in writing scripts on PowerShell and Bash

Experience in Agile methodlogies

Supported Oracle Workday Cloud implementation, Data Sync to MS AD

Discoverer Upgrades from 9i to 10g, 10g to 11g

Evaluated multiple products for Discoverer replacement – Eis Tech, Excel for Apps, Polaris RWB, ORBIT and Measure IT

RegalBeloit, USA Jul 07 – Mar 09

Principal Consultant

Oracle Apps & database(s) upgrade and support

Production support for Oracle Apps

Upgrade Planning for Oracle Apps from 11.5.9 to 11.5.10

Unilever, Singapore Feb 05 – Jan 07

Pr. Oracle Apps DBA

Oracle Apps & database(s) upgrade and support

Upgraded Oracle Apps from 11.5.9 to 11.5.10

Upgraded database(s) from 8i to 9i.

Implementing Discoverer 4i

SOX Compliance & Remediation–Implemented password control and aging in Oracle Apps.

Implemented DB Audit Tool to resolve SOX SOD issue.

Evaluating VERITAS Clustering for Fail-Over/High availability of Oracle Applications 11i.

AIMS High Availability Setup

Setting up Sun-Fire V440 servers in a High Availability (HA) cluster configuration using VERITAS Storage Foundation (VSF) and High Availability (HA) solutions.

Oracle 9i Installation, patching, DB creation, Oracle Net Configuration, Hot backup setup.

Worked with Unix Admin to define VCS service group(s) and tested the failover.

Post Upgrade Support

Supported and maintained Oracle Apps 11.5.9, WDS 6.x and the corresponding DBs for Production/Stdby/Dev/Test environments

Oracle Apps Cloning & Patching.

User Administration, space mgmt, performance tuning, troubleshoot.

Defining Menus, Responsibilities and printers. OCM administration and data purging.

Supporting Manugistics/WDS MFG applications and database(s).

Implemented HOT Standby and RMAN for all the business critical DBs.

Hot standby server setup using HOT stdby DB and Oracle Apps cloning (Rapid Clone).

Participate in Code reviews, CAB reviews and Security reviews.

Apps and DB configuration Control & change management.

Develop/Enhance Discoverer EULs and customizations/bolt-ons.

Upgrade and Migration of ERP Software/Systems

Installed Oracle applications 11.5.0 on SUN Solaris 8.

Consolidated Oracle Apps 10.7 and 11.0.3 Instances.

Did a test upgrade to Oracle Apps 11.5.0 and to 11.5.4

Tailored and documented the upgrade process using oracle’s upgrade template.

Team Lead - completed the project on time, under budget. Won performance incentive.

Upgraded Oracle Apps 10.7 & 1103 on DEC to 11.5.9 on SUN servers.

Migrated Oracle Apps DBs and other Oracle DBs from 7.3.x on DEC to 8i on SUN.

Implemented Oracle HR employee self-service.

Implemented Web ADI for financial data (budgets, expenses etc) uploads.

Customizations migration, Training Super users and End users.

Cutover planning, execution and post-upgrade stabilization.

Enhanced overall system performance by 50% from a pre-upgrade baseline.

Applications Support

Production/Post-Implementation support for Oracle Financials, Projects and HR modules

Oracle Applications and Database Admin.

Setting up development and documentation standards.

Helping developers with coding & performance tuning of SQL and PL/SQL.

Reduced production support issues by 40%.

Reduced the runtime for the custom monthly invoice generation routine from 24 to 8hrs.

Developed Positive Pay process for AP to help reconcile.

Resolved the short FY issue with Fixed Assets when FY was cut short due to acquisition.

Principal Contributor to recovering/restoring databases, applications during a server crash.

NEC, Malaysia Sep 03 – Dec 04

Sr. Consultant/Sr. Oracle Apps DBA

Post-Implementation support for Oracle Apps

Active Oracle Apps and DB support for Rel 10.7 and 11.0.3

Consolidated Oracle Apps 10.6 and 10.7 instances to Oracle Apps 10.7

Refresh of Dev and Test Instances and performance tuning.

Developed/Enhanced customizations and reports for Oracle HR & Financials.

Developed shell scripts to automate DB maintenance & data refreshes for periodic

report (s) generation.

Converted in-house applications from MS-Access to Oracle environment.

Developed PL/SQL routine(s) to validate data conversion by comparing source &

target data.

Oracle HRMS Implementation – Rel 1103

Installation and setup of Oracle Applications 11.0.3

Installation & configuration of Oracle web server.

Upgraded the Oracle RDBMS from 7.3.x to Oracle 8.0.5, Apps DB from 10.7 to 11.0.3.

Oracle Applications patching and maintenance.

Configured (Flexfields, Benefit elements, SIT/EITs etc) & Implemented Oracle HR for

all KAEC divisions.

Data Conversion from legacy and HR 10.7 to Oracle HR 1103 using Data Pump/HR APIs

Converted Employee Job & Salary History from CBAS to Oracle HR special info types

Converted & enhanced the Reports, Discoverer EUL to fit multi BG setup & security.

Developed Mass Update Routines for automating Employee benefits eligibility.

Implemented Role based HR Security.

Technical Summary

Programming Languages : SQL, PL/SQL, Shell scripting, Perl, C, Java, Pascal, COBOL

Operating Systems : Solaris 8/9/10, HP-UX, Digital UNIX, IBM-AIX, SVR UNIX,

Redhat LINUX, Windows – 95/98/NT/XP/7

ERP Software : Oracle Applications Rel 10.5 thru R12.2.5, WDS 6.x,

SAP HR, Oracle Hyperion, Autotime, ADP PCPW.

Database Environments : Oracle 7.x/8.x/8i/9i/10g/11g/12c, SQL Server 2008 R2

thru 2014, MS-Access, ODBC, JDBC, dBASE

Software Tools & GUIs : Power Builder, Visual Basic, Pro*C, SQL*Plus, Oracle

Developer Suite, Oracle Workflow Builder, OEM, TOAD,

PL/SQL Developer, DB Audit, ViaTil/Remedy, Veritas

Cluster Manager

Case Tools : Logic Works Erwin/ERX, Oracle Designer 2000

Source Control tools : Clear Case, PVCS

Web Tools/Software : Web Logic, Oracle iAS, HTML, XML, Java Scripting,

Apache

BW/BI Tools : OBIEE, Power BI, OWB, Oracle Discoverer, SAP BW, Bex

Analyzer

Planning/Presentation Tools : Microsoft Project, Microsoft Office and Visio.

Hardware Platforms : Sun Sparc v880/v440, HP9000 E45/E55, DEC-Alpha

1200/2100A/DS20, HCL-Magnum, HP

EDUCATION, CERTIFICATIONS & TRAININGS

M.S. in Software Systems from Madurai Kamaraj University, INDIA.

Oracle DBA OCP..

Foundation certificate in IT Service Management.

Big Data and Hadoop Fundamentals

Data Science Foundation & Data Scientist toolbox

R Programming

Oracle Workflow

Oracle Performance tuning

Oracle 12c - New Features for Administrators

Weblogic 12c Administration

Visa/Immigration Status: Green Card -EAD

Contact this candidate