Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic
Srihari S Vellampalli

Srihari S Vellampalli

Irving,TX

Overview

16
16
years of professional experience
1
1
Certification

Work History

Database Administrator

One Technologies, INC
03.2019 - 05.2019
  • 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
  • Migrated Various Application DBs from SQL Server Enterprise to Standard and consolidated various SQL environments to save licensing costs
  • Upgrade SQL Server 2014 to 2017 with the environments enabled with High Availability like Always On, Replication and Always on Groups
  • Involved in migrating SQL Server databases from On-Premises to AWS RDS environment
  • Deploying SQL Server Integration/Analysis and Reporting Services
  • Implemented Backup Strategies for AWS RDS SQL Server environments.

Sr. Oracle Apps DBA

Hudson Advisors
, USA
06.2009 - 02.2019
  • Worked on mapping AD groups to OFSAA users to communicate directly between AD and OFSAAI
  • Implemented REST API’s and API Catalog for IDCS
  • Worked on REST APIs to Create/Update/Delete and Authorize user
  • Managing IDCS users, groups, and applications
  • Performed OKTA integration with Oracle IDCS
  • Implemented SailPoint integration with Oracle E-Business Suite
  • Configure and Integrate Federated SAML SSO Between Oracle Analytics Cloud (OAC), Identity Management Cloud (IDCS) and Microsoft Azure Active Directory
  • Joined the team to support Oracle EBS upgrade from 12.1.3 to 12.2.8
  • Worked on Install/Configuring Oracle EBS environment with 3 node RAC and with 5 nodes Shared Appl_top environment
  • Worked on Install/configuring Oracle Demantra and integrate with Oracle EBS environments
  • Worked on Integrating OUD (Oracle Unified Directory) with Oracle Access Manager to enable Single-Sign-On (SSO) with Oracle EBS environments
  • Involved in TLS and SSL configuration for EBS environments
  • Involved in Transaction Data Encryption (TDE) for database
  • Worked on adding new OACORES and modifying memory settings for all OACORES to avoid unnecessary outages
  • Configured Oracle Exalogic-Exadata V2/X2/X3/X6 of 11g/12c databases with 2 node RAC up to 2 TB
  • Worked on adding new OAEA services to enable Single Sign On and integration with Oracle EBS environments
  • Experience in Installing, configuring Oracle Fusion Middleware applications (Oracle WebLogic Server 11g and SOA 11g)
  • Hands on engineering of middleware products, through a deep understanding of technologies such as: Oracle WebLogic & Fusion Middleware, ODI, Web center Content, Oracle IAM, Oracle E Business Suite, OBIEE
  • Involved in configuring Oracle 3-node RAC database for the EBS environments
  • Worked on OACORE memory settings and enabled trace to monitor and troubleshoot oacore crashes for EBS R12.2.5 systems
  • Worked on WebLogic Patches troubleshooting when the patches have conflicts and remove the patches using bsu utility
  • Worked on adding new OACORE on existing EBS R12.2.5 using WebLogic Admin Console
  • Worked on WebLogic Utility WLST to troubleshoot java.lang.OutOfMemoryError by identifying incident id, problem key and incident time
  • Deployed 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 with current capacity high count, deployment state, failed reserve request count, highest number available, higher number unavailable, leaked connection count
  • Worked on Oracle Demantra service request performance template for troubleshooting database performance problems.

Principal Consultant

Regal
Beloit, USA
07.2007 - 03.2009
  • 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

DBA

Unilever
, Singapore
02.2005 - 01.2007
  • Pr
  • Oracle Apps, 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
  • 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.

Sr. Consultant/Sr

NEC
, Malaysia
09.2003 - 12.2004
  • 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
  • Page 1 of 6

Education

Post Graduate Program - Cloud Computing

University of Austin
TX
01.2023

Post Graduate Diploma - Computer Science

Sikkim Manipal University
India
01.2001

Bachelor’s degree - commerce

Acharya Nagarjuna University
India
01.1996

Skills

  • ERP systems
  • Databases
  • Analytics
  • Enterprise Architecture
  • Governance
  • Oracle Cloud (IaaS, PaaS, SaaS)
  • Oracle Warehouse Management (WMS) Cloud
  • Oracle Cloud Networking
  • Oracle Cloud Architect
  • Oracle Cloud ERP Administrator
  • Oracle ERP Cloud Security
  • Oracle FAW (Fusion Analytics Warehouse)
  • Oracle Financial Services Analytical Applications (OFSAA)
  • Oracle Apps DBA, Oracle DBA
  • Oracle Cloud Managed Services
  • Database development experience
  • SQL Server DBA
  • Microsoft Azure Cloud

Websites

Certification

  • Oracle Cloud Infrastructure OCI Associate, https://catalog-education.oracle.com/pls/certview/sharebadge?id=3CBA726D561F846FB20919A596E8FF3FE02108D1CD28B7E35F2998BCCD82EC55
  • Oracle Cloud Infrastructure 2023 AI Certified Associate, https://catalog-education.oracle.com/pls/certview/sharebadge?id=3809B7D50B536CB823737432B7930DD394E82029E5D02F5B2967C24C6645B527
  • Oracle Cloud Fusion Analytics Warehouse 2023 Certified Implementation Professional, https://catalog-education.oracle.com/pls/certview/sharebadge?id=4B45B19CABB07CE5BD1077E024C4A66F5733A4D5A575873F9312A63C874BD899
  • Oracle Cloud Infrastructure 2024 Generative AI Certified Professional, https://catalog-education.oracle.com/pls/certview/sharebadge?id=638D4F9CB840AC7062C479ABF983BE7F5364BA383213D9C973FEEA19AD9AA2C2
  • Certified Azure Administrator Associate, https://www.youracclaim.com/badges/68f7a841-9978-46d7-8b0f-09eeb9345636

Timeline

Database Administrator

One Technologies, INC
03.2019 - 05.2019

Sr. Oracle Apps DBA

Hudson Advisors
06.2009 - 02.2019

Principal Consultant

Regal
07.2007 - 03.2009

DBA

Unilever
02.2005 - 01.2007

Sr. Consultant/Sr

NEC
09.2003 - 12.2004
  • Oracle Cloud Infrastructure OCI Associate, https://catalog-education.oracle.com/pls/certview/sharebadge?id=3CBA726D561F846FB20919A596E8FF3FE02108D1CD28B7E35F2998BCCD82EC55
  • Oracle Cloud Infrastructure 2023 AI Certified Associate, https://catalog-education.oracle.com/pls/certview/sharebadge?id=3809B7D50B536CB823737432B7930DD394E82029E5D02F5B2967C24C6645B527
  • Oracle Cloud Fusion Analytics Warehouse 2023 Certified Implementation Professional, https://catalog-education.oracle.com/pls/certview/sharebadge?id=4B45B19CABB07CE5BD1077E024C4A66F5733A4D5A575873F9312A63C874BD899
  • Oracle Cloud Infrastructure 2024 Generative AI Certified Professional, https://catalog-education.oracle.com/pls/certview/sharebadge?id=638D4F9CB840AC7062C479ABF983BE7F5364BA383213D9C973FEEA19AD9AA2C2
  • Certified Azure Administrator Associate, https://www.youracclaim.com/badges/68f7a841-9978-46d7-8b0f-09eeb9345636

Post Graduate Program - Cloud Computing

University of Austin

Post Graduate Diploma - Computer Science

Sikkim Manipal University

Bachelor’s degree - commerce

Acharya Nagarjuna University

Similar Profiles

  • Vyankatesh Wakharkar

    Vyankatesh WakharkarVyankatesh Wakharkar

    Team Lead at Tata Technologies Ltd, Tata Technologies LimitedTeam Lead at Tata Technologies Ltd, Tata Technologies Limited

  • Venkata Nagaraju Inakollu

    Venkata Nagaraju InakolluVenkata Nagaraju Inakollu

    Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)

  • Anurag Patel

    Anurag PatelAnurag Patel

    SERVICE DELIVERY ENGINEER at Norwin Technologies (Dell Technologies)SERVICE DELIVERY ENGINEER at Norwin Technologies (Dell Technologies)

  • Elizabeth White

    Elizabeth WhiteElizabeth White

    Independent Rideshare Driver | Lyft at Self-employeedIndependent Rideshare Driver | Lyft at Self-employeed

  • Alan Thomas

    Alan ThomasAlan Thomas

    Access Service Representative at Carrollton Regional Medical CenterAccess Service Representative at Carrollton Regional Medical Center

CREATE PROFILE
Srihari S Vellampalli