Amoghavarsha Ramappa

Experience

• 

  Siemens Technology India

  Mar 2002 - Jun 2002

  Summer Intern

  Thesis: 3D Surface Modelling of Serially Acquired Medical Images.

• 

  Oracle

  Jan 2003 - Aug 2007

  Member Technical Staff / Senior Member Technical Staff

  Data Access Layer - OCI, OCCI, SQLJ, OTT:• Designed and implemented features for the Data Access Layer of the Oracle RDBMS - Oracle Call Interface, Oracle C++ Call Interface, SQL Java and Oracle Type Translator.• Open Source Work - Zend PHP drivers for Oracle RDBMS

• 

  Lehman Brothers

  Jul 2008 - Aug 2008

  Intern

  Credit Analytics

• 

  Columbia University in the City of New York

  Sept 2008 - Dec 2008

  Teaching Assistant

  COMS W4111 Introduction to Databases (Prof. Luis Gravano, advanced undergraduate and graduate level course)

• 

  RSA Security

  Mar 2009 - Oct 2009

  Senior Software Engineer

  RSA enVision - Security Information and Event Management (SIEM)

• 

  Oracle

  Oct 2009 - now

  • Currently lead a seven-member development team to design and implement security features which are primary offerings of Oracle Data Safe, Oracle’s next generation regional cloud service. • Led a two-member team to build Data Safe support for SQL Server on Azure and MySQL.• Enhanced Label Security to work with Oracle Parallel Query and Logical/Physical replication scenarios.Database Security - Discovery & Masking Cloud Service:• Discover and mask sensitive data - available as a service on Oracle Cloud Infrastructure (OCI).* Microservices-based architecture - responsible for all functional and design aspects.• Implemented REST API’s to expose masking functionality.• Developed new masking algorithms to mask user data. Fixed existing algorithms to ensure Crypto-agility.• Implemented a fault-tolerance feature that lets discovery and masking to continue operating in event of software and hardware failures.• Implemented multiple product fixes to use parallelism in the database and the application server. This helps improve throughput and reduces latency and allows to scale for large datasets.• Added support to discover and mask Edition View objects. This was a major feature required by newer versions of Oracle E-Business Suite.User & Security Assessment Service Cloud Service:• Implemented features ground up. Responsible for all aspects, from building a prototype to showcase the idea to design and development.• Designed and developed an approach to normalize abstract database aspects like access control and security policies and come up with a value score for each database user. The score is based on a threat matrix which includes user privileges, presence of sensitive data and database security controls. Show less Database Security - Oracle Label Security (OLS), Virtual Private Database (VPD):• Led a four-member team to redesign major parts of Oracle Label Security and Virtual Private Database.• Redesigned major parts of the product that implement row-based access control to use in-memory caches.• Implemented changes to core layers of the Oracle Database kernel to optimize security checks during DML and SQL queries. This feature is available as a generic service and can be reused by database kernel developers when implementing features inside DML and Query processing layers.• Implemented a feature to construct and cache user profiles and reuse cached profiles on re-logins.• Obtained large performance benefits and reduced instruction counts from redesign – instruction counts were reduced by 98% and 75%, and elapsed times by 35% and 92% for DML/Queries and logon• Enhanced label security to work with Parallel Query (PQ) - Changes implemented to propagate in-memory session state across parallel query slaves.• Enhanced label security to work in a distributed system - Designed and implemented features to propagate policy metadata to Logical Standby and in-memory cache contents to Physical Standby replicas. Show less

  • Consulting Member of Technical Staff

    May 2018 - now

  • Principal Member Technical Staff

    May 2012 - May 2018

  • Senior Member Technical Staff

    Oct 2009 - May 2012