About Me
- Hi, I am Sanjana Kulshrestha.
- Currently pursuing Master of Science in Computer Information Systems (Data Analytics) from DePaul Univetrsity, Chicago.
- I am an experienced professional with having 3.5+ years in software development and Data Analytics. Skilled in Python, SQL, Tableau, Machine Learning, and Databases.
- I am looking for a Full-time Data Analyst / Data Scientist / Business Intelligence opportunity.
Expertise:
- Strategy Analysis
- Market Basket Analysis
- Customer Segmentation
- Time Series Forecasting
- Predictive Modeling
- System Analysis
Strength:
- Ability to solve complex problems and work with multiple data-sets by leveraging relevant tools.
- An effective communicator with strong interpersonal skills
- Collaborate with stakeholders and interact cross-functionally to conduct end-to-end analysis.
- Translate and communicate insights as concrete and actionable recommendations for the business.
- LinkedIn: https://www.linkedin.com/in/sanjana-kulshrestha-2008/
- Medium: https://medium.com/@sanjana.kul2008
Scroll down to learn more about me!
Education
DePaul University
MS in Computer Information Systems
3.7/4.0
2019-2021
- Courses: Data Analytics, Data Warehousing, Python Programming, Database Management,Fundamentals of Data Science, Data Analysis and Regression, Data Visualization, Data Analysis and Statistics, Enterprise Data Management, Database Design for Information Systems, System Analysis and Fundamentals of IT Project Management.”
University of Petroleum and Energy Studies
Bachelor of Technology in Computer Science
2013-2017
- Relevant Courses: Computer Programming using C, Embedded systems, Software Engineering, Data Structures using C, Management theory and Practices, Object Oriented programming with C++.
Experience
UnitedHealth Group
Engineering Specialist
July 2021 - Present
Microsoft Corporation
Microsoft Learn Student Ambassadors
January 2021- June 2021
DePaul University
Program Coordinator
October 2019- June 2021
Responsibilities
- Increased the enrollments by 12%: Handle multiple projects, conducts market segmentation analysis and visualize the Excel student data to create quarter wise report with KPIs and strategies and apply decision driven practices with marketing team.
- Data Preprocessing, wrangling the data using ETL(Extraction, Transformation, and Loading) with the help of Microsoft Excel, Vlookups, Pivot tables, VBA and analyzes the data.
- Generate reports and surveys both using Statistics Table visualization using Qualtrics.
- Develop the tables, visuals and charts from the raw data using Tableau and Microsoft Excel for data storytelling in the Final Quater Reports.
- Serve as an Advisor and assist students and guide them related to the academic programs offered during open office advising hours.
- Working as a Teaching Assistant in the University Internship Program courses.
DePaul University
Data Analyst
October 2020- Dec 2020
Responsibilities
- Achievement: Producer of Optimizing Digital Innovation (ODI) Conference 2020 with speakers from Fortune 500 companies.
ThinkChicago2020
Group Project Lead Participant
October 2020
Responsibilities
- I gained experience by working in a team with the country’s most talented students. Together, we worked on a civic tech challenge by giving our best ideas on how to improve efficiency and lower commute times by prompting public transit and high capacity models.
- Achievement: I was selected as 1 of the 200 top college students from across the U.S from STEM to participate in the ThinkChicago Ideas Week.
- Achievement: Got featured in the official ThinkChicago Chicago Ideas 2020 Resume Book.
Project Work Groups
Data Analyst Intern
June 2020- August 2020
Responsibilities
- Improved customer foot traffic of website: Led IT projects of 24 diverse people teams, collaborated with UX, Marketing and Data Science teams, requirement gathering and developed data pipeline, user-focused visuals and dashboards.
- Project: “Artificial Intelligence on Rural”, did data mining and data integration of 40 years of demographics data size 100k using Python on AWS, created visuals for country-wise model dashboard using Tableau categorically (health, food, water, etc.)
- Achievement: Featured in PWG Women Leadership Newsletter 2020.
- Achievement: Titled as “Young Leaders Shadow Board of Directors, under 25” program under aegis of Harvard Business Review.
- Achievement: Nominated and attended the United Nations Global Compact Summit 2020
- Achievement: Received weekly best performance award badges from Manager.
KPMG
Data Analyst Consultant Intern
May 2020- June 2020
Responsibilities
- Performed data wrangling, data modeled 360,000 accounting data by defining schemas using SQL, assessed data quality as per data governance, created dashboard using Tableau and documented business improvement strategies using PowerPoint presentation to the stakeholders.
Hash Analytics
Data Analyst Intern
April 2020- June 2020
Responsibilities
- Performed qualitative and quantitative analysis using Numpy, Panda, A/B hypothesis testing to present the KPIs on a complex data sets, followed by data visualization using Matplotlib and Tableau.
- Tableau portfolio: https://public.tableau.com/profile/sanjana.kulshrestha#!/
Embassy of India Student Hub
Volunteer
April 2020- August 2020
Responsibilities
- Built and designed the database by data extraction using ETL with the help of Advance Microsoft functions, data modeling, data mining followed by data visualization using Tableau, and reported the KPIs in the PowerPoint Presenation as a data storytelling for the team.
IBM
Service Delivery Specialist
January 2018 - June 2019
Responsibilities
- Developed a model after analysis of system’s workload, reported the behavior of mainframe system and workloads interactions and collaborated with SMEs of Performance and Capacity Management Team.
- Gather the data, cleaned it, and the predicted the time for planning a schedule for upgrading your z Systems and capacity planning.
- Conducted system metrics analysis by data mining, transformed over 2 Million of raw mainframe utilization data through ETL using SQL, VBA and developed a data model, evaluated it for optimization of data.
- Achievement: Certified as Big Data Expert.
- Achievement: Winner of IBM Master the Mainframe competition played at global level.
TATA Tele Services
Java Intern
June 2016 - August 2016
Responsibilities
- Developed “Authentication Based Face Recognition” using Eigenfaces algorithm on Java Server Pages for image processing.
Projects
Titanic Survival Predictor | April 2020 - June 2020
Performed exploratory and statistical analysis on Titanic datasets, and predicted 32% survival chances of passengers and crew on the ship using One Hot Encoding based on categories: gender, class, fares, age using scikit Machine Learning to do Logistics Regression, K-Nearest Neighbors and Decision Tree for training and validating data splitting and visualized the confusion matrix.
United Airlines - System Analysis | January 2020 - March 2020
Analyzing the system and system design of United Airlines and its functionality and adding new functionalities to the system by designing strategic design patterns, Data Flow diagrams, ER diagrams using Microsoft Visio.
Housing Market Predictor model | December 2019
Developed a system which used the California Census data 1990 to predict house sale prices in the Bay area with respect to proximity to the ocean by using Machine Learning algorithm, Linear Regression, Decision tree algorithms and Ridge Regression in Python using Numpy and Matplotlib for data visualization according to the population, dimension of houses, etc.
Time Series Decomposition of Supermarket | August 2019 - November 2019
Increased the customer churn rate by 23% : Performed a time series forecasting of retail store and customer data, analyze customer behavior and trends, accessed the Hadoop data in JSON, did data profiling using SPSS, created a dashboard using Elastic Search, Logstash and Kibana (ELK) algorithm and a report with KPIs for marketing strategies.
Social Network Analysis of LinkedIn | August 2019
Developed a visual live graph network after analyzing the total number of connections in LinkedIn as per their demographics.
Voice Translator Bot | August 2019
Developed a bot which translate between English and different languages. It also converts speech into text
System metrics analysis | February 2019
Conducted system metrics analysis by data mining, transformed over 2 Million of mainframe utilization data through ETL using SQL, VBA and developed a data model, evaluated it for optimization of data.
Technical Skills
- Data Management: Database Design and Management, Data Analysis, Pattern and Trend Identification, Visualization and Data Insights, Data Warehousing, Data Mining, Regression Analysis, Data Modeling, Predictive Analytics
- Programming Languages: Python, C++, Java, SQL
- Data Visualization: Excel, Tableau, PowerBI.
- BI and Reporting tools: MS Power BI, Tableau, Excel VBA, VLOOKUP, Pivot Table, Macros
- Database: MS Access, Oracle SQL developer, MYSQL, MS SQL
- ETL Tools: MS SSIS, IBM Infosphere Information Server
- Web Analytics: Google Analytics
- Statistical and Analytics techniques: Advanced SQL queries, Regression and Tree-Based Modeling, Hypothesis Testing, A/B Testing, Clustering, Variable Selection, Data Wrangling, and Data Visualization.
- Packages: TensorFlow, PyTorch, Keras, OpenCV, Numpy
- Machine Learning Algorithms: Decision Trees (Random Forests), Clustering (KNN, K-Means), Classification (Naïve Bayes, SVM), Unsupervised learning (PCA), Time Series Analysis, Image Processing, Pattern Recognition, Data Extraction, Business Intelligence (BI)
Certificates and Leadership
- Google Analytics Beginner.
- Google Analytics Advance.
- AWS certified Data Analytics fundamentals.
- SAP Data Intelligence for Enterprise AI.
- AWS Cloud Practitioner Essentials.
- IBM Professional Certificate of Data Science.
- Lean Six Sigma White Belt.
- Project Management Essentials.
- President of DePaul Information Systems Organization (2020 - 2021)
- Ex-President of Google Developer Club, DePaul University
- Social Media Chair of HerCDM, DePaul Uiversity( 2020 - 2021)
- Global Peer Mentor(2020)