Dikshita Jain | Informatics Major

Dikshita Jain

Informatics Major

Based in Washington, USA

About

Pursuing a Master’s in Information Management at the University of Washington, I bring over two years of experience in data analysis from my role at Oracle Financial Services, where I developed and optimized SQL scripts to resolve complex customer issues. Additionally, as the co-founder of an apparel company, I leveraged data-driven insights to enhance operations and drive revenue growth. Passionate about the power of data to shape impactful business decisions, I am skilled in tools such as Power BI, Tableau, SQL, Python, and R. I am actively seeking opportunities in data analysis, business analysis, business intelligence engineering, and data science, where I can contribute to data-driven strategies that support business growth and innovation.

Skills

Projects

Formula One Data Analysis using SQL

Utilizing SQL, I conducted a comprehensive analysis of various aspects of Formula 1 racing. My objectives were to: 1. Evaluate driver performance across seasons and constructors. 2. Analyze pit stop strategies and their impact on race results. 3. Assess the dominance and championship performance

Hans Rosling GDP Per cap vs Life expectancy World Visualization

Inspired by Hans Rosling, I recreated a dynamic visualization to showcase the relationship between GDP per capita and life expectancy across countries from 1952 to 2007. Each country is represented by a bubble, where size indicates population and color represents the continent.

Thanksgiving Dinner Analysis and Dashboard

Analyzed a dataset of 1,058 survey responses on Thanksgiving dinner preferences, including demographic factors like age, income, and location. Created an interactive Power BI dashboard to uncover patterns in food choices and the impact of demographics on Thanksgiving celebrations.

Instagram Insights

Analyzing trends in what content type, post type, days work my Instagram account and visualize data collected for 100 posts in order to draw patterns. Reels, Travel, Pet and Weekdays work best for me to grow my Instagram account.

Amazon Apparels Sales Dashboard India

Dashboard for visualizing sales of apparels mainly in 9 categories and 11 sizes, to understand customer buying trends and patterns in Indian subcontinent.

OCD Analytics Dashboard

The "OCD Analytics Dashboard" project analyzes a dataset of 1,500 OCD patients using Excel to uncover demographic and symptom trends. Leveraging pivot tables, and pivot charts, the dashboard provides insights into patient characteristics by gender, race, marital status, and OCD symptom types

Aura - The Dating App for Long Term Relationships

Aura, a dating app designed to foster long-term relationships in the digital age. Key highlights: • Research-driven approach to address modern dating challenges • Innovative features like personality-based matching and curated cafe meetups • Comprehensive product development process from ideation

Experience

July 2021 - July 2023

Oracle Financial Services Software | Data Analyst

● Secured a $500k contract renewal by providing actionable insights on customer retention, executing complex queries in MySQL and PL/SQL to analyze a $4 billion financial portfolio serving 50,000 users ● Reduced operational costs by designing a SQL solution that decreased weekly incidents by 16%, based on pattern analysis of recurring issues ● Accelerated stakeholder decision-making by 70 minutes by creating a Tableau dashboard visualizing fraudulent loan activities with bar graphs, scatter plots, and pie charts

June 2024 - August 2024

Jumpstart CSR | Data Product Intern

● Increased project completion rates by 25% by implementing data-driven sprint planning and Key Performance Indicator (KPI) tracking, using Azure DevOps to analyze task trends and optimize product backlog ● Enhanced customer satisfaction by 20% through data-backed feature prioritization, analyzing user feedback and product specifications to deliver high-impact functionalities

September 2022 - July 2023

NJ Creations | Co-Founder

• Generated $20K revenue in six months by optimizing marketing campaigns, using Excel to analyze customer feedback and sales data for trend identification • Reduced stock shortages by 15% by improving inventory management, creating Tableau dashboards to predict demand patterns and adjust stock levels

June 2020 - September 2020

Arihant Enterprise | Business Analyst Intern

• Increased vehicle utilization by 25% and generated $100K in revenue by analyzing driver and vehicle performance data using Pandas and NumPy in Python to optimize operations for ride-hailing services like Uber and Ola • Secured $10K in additional revenue by forming partnerships with pharmaceutical companies during COVID-19, leveraging Scikit-learn for predictive modeling and Matplotlib to visualize key performance metrics, enabling data-driven decisions

Education

2023-2025

University of Washington | Masters of Science in Information Management

-Statistics -Data Visualization -Data Wrangling -Designing Information Experiences -Product Management

2017-2021

University of Mumbai | B.Tech in Computer Engineering

-Data Mining -Data Science -Relational Database Management Systems -Machine Learning -Advance Database Management Systems