Ankur Ojha

Software Engineer Intern

Marqeta•  June 2023 - August 2023

• Conducted complex SQL queries within Snowflake to refine and analyze IT system data, leading to an 80% improvement in data processing and reporting efficiency. • Developed interactive Looker dashboards that utilized data from Snowflake to display 3.4 million minutes of app usage and track 40,000 weekly SSO events, enabling real-time analytics for proactive system management and policy optimization. • Performed exploratory data analysis on metrics such as system utilization rates and user access patterns in Jupyter Notebook using Python, leading to enhanced user access protocols, and contributing to a more efficient self-service portal. • Conducted statistical tests and cohort analysis in Python to uncover trends in application usage and incident occurrences, which aided in the proactive refinement of IT policies and access governance, effectively reducing system bottlenecks.

Data Analytics Consulting Practicum

Kiana Analytics•  January 2023 - May 2023

• Consulted clients to understand business processes, gather requirements, translate it into analytical solutions and KPIs. • Developed features like moving radius, centroid, and device location frequency map to identify movement patterns. • Classified devices as fixed or moving using clustering algorithms with 96% accuracy, and tagged devices as employees and visitors by movement patterns and active hours using Spark-ML for 200 million data points.

Business Analyst

R.K. Enterprises•  June 2020 - July 2022

• Implemented methods to enhance customer service, accurate forecasting and settle scrap efficiently by creating database using SQL server that can reflect allocation of resources to different departments to make strategic decisions. • Build a regression model for monthly sales prediction of bricks based on various input factors such as price, economic conditions, weather, marketing campaigns, and competition. Prepared dashboards about inventory cost control and storage capacity, developed weekly production plans and analyzed individual SKU KPIs in tableau to reduce wastage and increase productivity by 15%.

Software Engineer

BitVault Technologies Private Limited•  July 2019 - June 2020•  Lucknow, Uttar Pradesh, India

Implemented clickstream analytics by building real-time data pipelines using Python and Spark to monitor user behavior across client websites. This allowed us to identify and optimize underperforming user flows, increasing engagement by 20% and enabling faster, data-driven decisions for business teams. Optimized database designs by analyzing access patterns and usage analytics, reducing query response times upto 40% and improving system scalability , ensuring optimal performance during peak traffic. Built centralized data repositories across multiple products, reducing data silos and providing unified analytics, which streamlined cross-product reporting and enhanced operational efficiency. Developed ETL pipelines using Spark and Kafka for efficient data collection and processing, enabling real-time analytics. Also created real-time dashboards and data APIs to improve data accessibility and drive better decision-making across teams.

University of Southern California (USC), Los Angeles

Data Science, MS•  August 2022 - Present

Master of Science, Analytics (Data Science) GPA: 3.85/4.0 Courses: Predictive Analytics, Data Mining, Data Management (BI, ETL, SQL), Statistics, Fraud Analytics (ML), Text Analytics, Financial Analytics (LSTM, ARIMA, Time Series Analysis), Data Analytics Consulting (Data-Driven Marketing Decisions).

Galgotias College of Engineering and Technology, Greater Noida

mechanical engineering, B.Tech•  August 2015 - July 2019

Bachelor of Technology in Mechanical Engineering GPA: 3.44/4.0 Courses: Engineering Mathematics, Statistics, Operation Research, Project Management, Industrial Management.