Yash Gondkar Email & Phone Number

United States

Mumbai Area, India

● Created BigQuery query to efficiently calculate minute wise and hour wise moving summary data from large data on connection requests using aggregate analytic functions, wildcard table names, query renaming, query nesting, query cross joining, query full joining and on-the-fly temporary table generation for natural number sequence ● The query also took care of missing hour window frames ● Performed data validation of moving hour aggregations returned by the query executed on pre-generated test data, using Excel formulas ● Designed and implemented BQ query to group multiple metrics like client IP, URL, country, etc. for charts like Sunburst. Used a recursive algorithm to generate the highly nested query for getting the ranked combinations and their day, moving hour and minute summary in one go ● Used Firestore queries for retrieving the summarized data for client ● Designed and implemented a smart ID generation algorithm avoiding the need to filter locally and to get only the required data from Firestore also avoiding creation of chart specific data ● Leveraged Firestore transaction to take care of race conditions ● Created a basic application using Segment Trees to aggregate data between any two endpoints ● Frequently used Java 8 lambdas, method references and streams for doing processing on multiple elements in more scalable and readable manner ● Created custom Logback Appenders and Filters in Java and also configured logback.xml for pushing the data in MySQL ● Handled JSONs in JAVA by parsing them using Jackson and mapping it to model classes / Maps / JsonNodes / Strings● Designed and implemented a recursive algorithm to generate JSON data required by the Sunburst chart ● Created REST APIs for accessing the summarized data for the client ● Used Spring Data JPA to store application monitoring data ● Configured REST API interceptor ● Configured Global Exception Handling mechanism ● Created CRUD APIs for configuration units like chart and process

Mumbai Area, India

● Created Image border detector app ● It used Matlab’s Sobel operator which generated a 1-bit color image emphasizing the borders ● The application was made for mobile and wear device using JNI and Matlab Coder ● Researched on free alternative to Matlab for parsing Matlab code to C/C++ ● Researched on SOLID design principles and Git VCS ● Performed UI / UX testing