Resume

---

Contact Information

• Email: [email protected]

• LinkedIn: itspawanhere

• Website: itspawanhere.com

  ---

Education

• Indian Institute of Technology, Kanpur
  Location: Kanpur, India
  Degree: Masters in Computer Science
  Dates: July 2016 - May 2018

• Indian Institute of Technology, Guwahati
  Location: Guwahati, India
  Degree: B.Tech in Computer Science and Engineering
  Dates: July 2010 - May 2014

Professional Experience

• Sophos, Bangalore, IN
  Senior Software Engineer II
  October 2023 - Present

  • Compound Detections: Created a Batch Processing framework in Amazon Managed Workflows for Apache Airflow (MWAA). This allows threat researchers to register their detection workflows. This new detection framework accelerated threat detection automation by approximately 10x.

    Tools/Technology used: AWS, Airflow, Spring Boot, PrestoSQL, Python

• o9 Solutions, Bangalore, IN
  Senior Software Engineer
  August 2021 - September 2023

  • Lightweight Scenario and Scenario Sharing: Implemented “Lightweight scenarios” for o9’s proprietary database, minimizing data replication and memory usage. Also developed a feature for scenario sharing, allowing datasets to be shared in read-only/write mode with specific users or roles.

    Tools/Technology used: C#, SQL Server, Redis, RabbitMQ, Solr, MongoDB, Visual Studio

  • Audit Trail: Implemented a robust auditing system that tracked all transactions on o9’s database, significantly increasing transparency and accountability. This reduced transaction tracking time by 10x and enhanced data integrity.

    Tools/Technology used: Java, Spring Boot, Hadoop, Lucene, Protobuf, HBase, SQL Server

  • Hadoop Agent: Collaborated on a project to synchronize data between o9’s proprietary database and Hive. Developed a service for seamless data and schema synchronization, enabling unified access to Hive data.

    Tools/Technology used: Java, Spring Boot, Hadoop, Hive, SQL Server

  • Health Check for Services: Designed and implemented a solution for Java-based services at o9 to regularly transmit health and configuration status to a centralized dashboard, improving SLA adherence by over 20%.

    Tools/Technology used: Java, Spring Boot, RabbitMQ, Elasticsearch, Kibana

• Goldman Sachs, Bangalore, IN
  Engineering Associate
  January 2021 - July 2021

  • Lumos: Enhanced LUMOS, an internal desktop application for GS, aiming to centralize open workflows, tickets, and notifications. Added features such as message boards and outage notifications, and improved response times for open tickets, which boosted overall efficiency by over 30%.

    Tools/Technology used: Angular, Electron, TypeScript, SQLite, HTML, CSS, Java, Spring Boot

• Eureka AI, Bangalore, IN
  Senior Software Engineer
  June 2018 - January 2021

  • Contact Tracing: Developed a user tracing system using Telco Data to identify potential sources of COVID-19 infection with user consent. Incorporated Point of Interest data to help identify potential infection sites. The system was used by government agencies to mitigate the spread of the virus.

    Tools/Technology used: Apache Druid, Leaflet, Spring Boot, React

  • Credit Score: Engineered an end-to-end system to ingest and query credit score data using the Eureka AI engine. The system enabled queries via mobile number or national ID, providing direct access to user credit scores.

    Tools/Technology used: Elasticsearch, Spring Boot, Bootstrap, React

  • Data Pipeline for Telco Dataset: Constructed “pipecore”, a data transformation tool automating the integration of Telco data into a proprietary format optimized for AI processing. Improved data pipeline efficiency by over 300%.

    Tools/Technology used: Java, Hadoop, Oozie, Spark, Hive, Python, Kafka, Elasticsearch, Kibana

  • Eureka User Profile Store: Designed and developed the UI and backend for a profile store, enabling deep exploration of Telco users and advanced data extraction through dynamic filters. This tool helped secure contracts with 6 telcos across 5 countries.

    Tools/Technology used: Java, Spring Boot, Elasticsearch, React, Bootstrap, ChartJS

  • Campaign Management System: Developed a CMS allowing directors to create and manage targeted marketing campaigns. Facilitated simultaneous campaign management and integrated complete BI and analytics, enhancing user tracking and campaign efficiency.

    Tools/Technology used: Spring Boot, MySQL, React

• Samsung Research Institute, Bangalore, IN
  Software Engineer
  June 2014 - July 2016

  • Splitbilling: Developed a robust and scalable billing system designed to allow system administrators to monitor call, SMS, and data usage across personal and enterprise accounts via a unified dashboard. This system significantly reduced company costs by controlling expenses related to personal usage.

    Tools/Technology used: Python, MongoDB, Flask, JavaScript, Bootstrap

  • Email Glue: Led the development of an advanced email automation system that created tasks and events from email content, supporting a zero-inbox policy for Samsung’s email application. Additionally, designed a Google Drive add-on for seamless integration with Samsung Email, enhancing email management and productivity.

    Tools/Technology used: Android, Java, Google Drive SDK, Android Studio

Awards and Honors

• Jury’s Favorite Award, Hackathon
  Recognized at an o9 Solutions hackathon for developing a customer support bot utilizing LangChain and OpenAI’s ChatGPT APIs.
  September 2023

• Employee of the Quarter, o9 Solutions
  Awarded for exceptional achievements and outstanding contributions in the workplace.
  January 2023

• Top 0.18% Rank, Joint Entrance Examination
  Achieved a ranking within the top 0.18% among over 500,000 candidates.
  May 2010

• Merit-cum-Means Scholarship, IIT Guwahati
  Awarded annually for outstanding academic performance over four consecutive years.
  2010 - 2014

• Certificate of Merit, CBSE
  Honored for being among the top 0.1% of students nationwide in Social Science.
  May 2008

• First Prize, State-Level Essay Competition
  Awarded first place in a competitive state-level essay writing event.
  May 2007

Skills and Other

• Programming Languages: Java, Python, JavaScript, SQL, Unix Scripting

• Tools & Frameworks: Spring Boot, Git, React, Chakra-UI, GraphQL, React, Angular, Electron, Docker, Kubernetes (K8s), Terraform, CI/CD, Nginx, LaTeX

• Industry Knowledge: AWS, Airflow, Hadoop, HBase, Presto, Iceberg, ELK Stack, MongoDB, PostgreSQL, RabbitMQ, Kafka, Redis

• Additional Skills: Consistently able to type at 90+ WPM.

Languages

• English: Fluent
• Hindi: Native