RAMPRASAD RAI

Greater SF Bay Area /Remote 650-***-**** adt1m4@r.postjobfree.com linkedin.com/in/irnlogic/

Performance and Data Architect Database and Big Data Engineer

An experienced, hands-on technical leader that plans, builds, and optimizes big data solutions. Designs and tunes databases, data models, and pipelines. Builds high-performance real-time analytics. Achieves year-over-year target objectives. Builds rapport with inter-company functional areas to achieve team objectives. Core competencies include:

Realtime Analytics Data modeling Data strategy Database Query Optimization Distributed System Design Performance optimization High throughput pipelines Plan Capacity Optimize TCO Drives complex projects via Cross Team Collaboration Team Player Customer and User Focus Empathy

TECHNICAL SKILLS

Languages: Python SQL Java Typescript (Formerly C, C++, Scala, Assembly language)

Database: HANA Postgres Presto Azure Data Explorer

Technology: Kubernetes Docker Spark Azure IoT Django GCP Wagtail CMS

Concepts: Data modeling Performance Distributed systems IoT Data pipelines Auto-observability

Courseware: SQL/Relational algebra by CJ Dates Web applications Spark Kubernetes

Data Science: Feature Engineering Spark Data pipelines

EXPERIENCE

Meta/Facebook, Menlo Park, CA 2021 – Present

Software Infrastructure Engineer

Help separate a high traffic Ads Manager into its own subdomain, thus helping unlock clear insights.

●Migrated critical workloads from 5k+ large 256 GB machines to 10k smaller 64 GB machines, eliminating ~1000 machines by reducing memory footprint and by improving parallelization.

●Built autoregression detection and root causing for Ads Manager by ingesting and leveraging UI events: Saved 10% of Ad dollars leakage by applying a set of well-established time series algorithms on generic UI event logs.

SAP, Palo Alto, CA 2002 - 2021

Performance and Data Architect, Hyperscaler connector, 2020 - 2021

Led cross-location throughput and system design initiatives for the Hyperscaler Data Connector Team

●Drove performance optimization of Azure IoT data acquisition pipeline consisting of IoTHub, Azure functions, EventHub, and Azure Data Explorer: Advised structural changes, helping drive throughput from 1000 messages per second to 30,000 messages per second.

●Came up with a capacity planning guide for Azure cloud resources helping customers quickly estimate the costs of owning the solution.

●Developed Kubernetes-based tooling for automating the execution of load tests

Database and Data Architect, 2015 – 2020

Led the distributed system design efforts for the IoT organization

●Built high-performance analytics and deep dive into large datasets spanning classic enterprise and modern big data by building optimal data models and pipelines tuned to specific workloads. Also, see patents.

●Led cross-team and cross-location development of Spark-based streaming aggregation pipeline, ramping up throughputs to higher than 1 billion messages a day.

●Trained employees in Docker and Kubernetes, helping them to ramp up to work on distributed cloud-based applications quickly.

RAMPRASAD RAI adt1m4@r.postjobfree.com PAGE TWO

Data and Performance Architect, Supply Chain-Integrated Business Planning Analytics, 2010–2014

The team's data modeling and performance lead, starting from a team of 10 until IBP became a successful analytical application in the industry

●Drove performance and data architecture best practices for the team from day one and helped build an analytical engine capable of executing complex queries in sub-seconds by deploying optimal data architecture and queries.

●Enabled near real-time analytics by optimizing the performance of the SLT pipeline by rewriting critical SQL statements to take advantage of the column store, thus reducing the ingestion time for one customer from 10 hours to 25 minutes a day.

●Helped several large customers with data organization and performance optimization. On several occasions, reduced the query time of complex reports from several minutes to under 2 seconds by re-organizing planning data and custom queries: enabling a truly interactive experience for supply chain planners.

●Built a tool to perform hardware capacity estimation and helped IBP customers plan tiers based on data and usage patterns

Performance Standard Owner, 2007 – 2010

●Served as performance lead for a 500-developer unit, leading to an improvement in performance by 30% in a major SAP product by leveraging hands-on optimizations and deploying know-how via a distributed performance team

●Designed SAP Business Object Layer unlocking enterprise business functions for access by modern tooling and built a java server-based access layer ( see patent ‘session coupling’ and https://www.sap.com/documents/2015/07/a067d9b9-5b7c-0010-82c7-eda71af511fa.html)

EDUCATION

Bachelor of Computer Science, UVCE, Bangalore, India

PATENTS

●Session coupling - https://patents.google.com/patent/US7171478B2/en

●Automated data acquisition and correlation - https://patentimages.storage.googleapis.com/81/60/13/36fbd5d22a39bb/US20180357595A1.pdf

●Machine Learning and Anamoly detection - https://patents.google.com/patent/US11250343B2/en

●Smart visualization of large datasets - https://patents.google.com/patent/US10929421B2/en

●Geospatial analytics - https://patents.google.com/patent/US10387442B2/en

BLOGS

A Practical Step-by-Step Guide to Understanding Kubernetes

●https://medium.com/better-programming/a-practical-step-by-step-guide-to-understanding-kubernetes-d8be7f82e533

Debug Your Kubernetes Service in 5 Easy Steps

●https://medium.com/better-programming/debug-your-kubernetes-service-in-5-easy-steps-1457974f024c

5 Easy Tips for Troubleshooting Your Kubernetes Pods

●https://medium.com/better-programming/5-easy-tips-for-troubleshooting-your-kubernetes-pods-34f594e03ba6

ConAgra experiences superlative performance with SAP Total Margin Management on SAP HANA

●https://https://blogs.sap.com/2015/10/08/conagra-experiences-superlative-performance-with-sap-total-margin-management-on-sap-hana/

KAGGLE

Top 7% in a forecasting competition, www.kaggle.com/ramrai

HOBBIES

Organize social tennis around Palo alto and led competitive tennis teams -https://www.meetup.com/paloaltotennis/

Contact this candidate