Ravindar Munjam Email & Phone Number

• Designed and Implemented the faster multi-dimensional aggregates(ROLLUP, CUBE and GROUPING SETS), PIVOT and UNPIVOT for extreme analytics engine, Kinetica DB• Designed and Implemented the multi-threaded multi-way sort/merge to compute the aggregates for the extremely faster database, Kinetica DB• Contribute to designs, reviews and implementation for high profile features of Teradata MPP RDBMS query execution engine that has huge code base with highly parallel environment.• Submitted five Invention Disclosure Reports in the area of database query processing including one patent-pending, on in-memory complex predicate evaluation.• Improved response time and CPU time for all queries that evaluate simple/complex predicates involving compressed data columns. Designed and implemented compression aware predicate evaluation for dictionary compressed data including numeric and non-numeric data.• Contributed to Teradata performance improvement by implementing vectorization for query predicate evaluation and join processing. The major benchmarks were seen with huge improvement in CPU Time and reflected in query throughput and response time.• Implemented code generation for new hardware technologies such as Haswell. Designed and implanted the changes to the existing register allocation algorithm to support new set of vector registers (SIMD) with a goal of minor changes and cheap cost. The database can now generate code based underlying hardware and can take the advantage of richer set of instruction to evaluate the queries.• Implemented exponentially faster temporal aggregation and normalize user-defined functions that are easy for customer usage. Implemented new index recovery for columnar.• Enhanced the external sort algorithm to make the temporal aggregation processing more efficient. • Improved the statistics gathering algorithm CPU and Disk I/O performance by adopting a dynamic aggregation method.• parallel row building for projections

Listed skills include Sql, Teradata, Oracle, C, and 16 others.