Aarohi Tripathi
Data Analyst at Walmart
Data Analyst @ Walmart | #GHC20 Scholarship application Reviewer| Mentor @ Rewriting the Code | Power BI | SQL | Alteryx
I am currently working with Walmart as a Data Analyst preparing dashboards for customers using Power BI and extracting data from Google Cloud Platform using BigQuery. I graduated from The University of Texas at Dallas with major in Business Analytics with specialization in Big Data, Machine Learning, Data Visualization and Web Analytics.

Business Analytics shows the amazing amalgamation of technology and business which draws me towards it. It excites me to see business decisions driven by analytical numbers and technological developments that help business achieve great heights. There is so much data around the world and its definitely worthwhile to know the stories behind it.

As a dynamic, adaptable and result oriented individual, I believe in working on commitments and familiar to work on projects scheduled to deliver results in tight time-frames. 

I look forward to implementing my course knowledge coupled with my technical acumen in the exciting and dynamic field of business analytics

Below are the technical skills I have demonstrated: 
► Programming: SQL, R, Python,
► Databases: SQL Server, MySQL, MongoDB, Google Cloud Platform
►Analysis Tools: SAS E-Miner, Adv. Excel
► Tools & technologies: R Studio
Visualization tools: Tableau, Power BI


Please feel free to contact me via any of the following media:
Phone: +1-469-258-7955
E-mail: aarohitrip@gmail.com
Walmart
https://www.linkedin.com/company/walmart
Bentonville
https://media-exp1.licdn.com/dms/image/C560BAQHXJ3GqjqY2yg/company-logo_100_100/0/1625156541828?e=1655942400&v=beta&t=SNxG9zIqKylUMc8Z0ClTgdb4xnFtE60qqbQpC9dSf8g
Data Analyst
The University of Texas at Dallas
https://www.linkedin.com/company/university-of-texas-at-dallas
Dallas/Fort Worth Area
https://media-exp1.licdn.com/dms/image/C4E0BAQEBYU4_oEvArQ/company-logo_100_100/0/1601995944632?e=1655942400&v=beta&t=AnRV7ij_akzXcvgdMZPP4Q-b1r7Jm9AZckJIW0bMGxs
Graduate Teaching Assistant
Mastercard
https://www.linkedin.com/company/mastercard
1) Automated the manual  process of extracting data for customers from database for customers. Data being extracted from different systems.
2) Led the code review for the code being developed for the release.
3) Coordinated with teams across different locations(Pune, Chennai, St. Louis)
Pune Area, India
https://media-exp1.licdn.com/dms/image/C560BAQGOW4NIyYRRqQ/company-logo_100_100/0/1519856263087?e=1655942400&v=beta&t=AquwHUmT2tknqpEs3uydi4so8DaxQOgnCFf1dt-sav0
Associate Software Engineer
Central Glass & Ceramic Research Institute
https://www.linkedin.com/company/central-glass-&-ceramic-research-institute
Worked on Potentiostatic Deposition of Cuprous Oxide layer on Copper substrate then calculate its resistivity under a range of temperatures.
Kolkata Area, India
Internship Trainee  in Material Science Department
Graduate Student
I graduated as Master of Science in Business Analytics with a focused curriculum on Data Science.This STEM program gives a solid establishment in Quantitative Methods and Analytical strategies for the greater part of the diagnostic stages which are Descriptive, Diagnostic, Predictive, Prescriptive Analytics.

Coursework:
• Business Analytics with R
• Machine Learning
• Big Data Analytics
• Marketing Predictive Analytics using SAS
• Database Foundations
• Applied Econometrics and Time Series Analysis 
• Prescriptive Analytics
• Statistics and Data analysis
• Web Analytics
• Business Data Warehousing
• Programming in Data Science
• Advanced Business Analytics with R
Business Analytics
https://media-exp1.licdn.com/dms/image/C4E0BAQEBYU4_oEvArQ/company-logo_100_100/0/1601995944632?e=1655942400&v=beta&t=AnRV7ij_akzXcvgdMZPP4Q-b1r7Jm9AZckJIW0bMGxs
The University of Texas at Dallas
https://www.linkedin.com/school/university-of-texas-at-dallas/
Bachelor’s Degree
Electronics  Engineering
https://media-exp1.licdn.com/dms/image/C4E0BAQH2G5aj0-1XFg/company-logo_100_100/0/1519900349146?e=1655942400&v=beta&t=S9Xrb8GNP5gMrNqIYKIm5548AJGiSlloIfo02DtZ9s0
Bharati Vidyapeeth
https://www.linkedin.com/school/bharatividyapeeth/
- Recieved for excellent performance provided to the client in a span of less than 7 months and exceptional performance in the project
Syntel Limited
Kudos Award
Business Analytics with R
BUAN - 6356
Database Foundations
BUAN - 6320
Predictive Analytics with SAS
BUAN 6337
Prescriptive Analytics
BUAN 6398
Statistics and Data Analysis
OPRE 6301
Wendy's is an American quick service restaurant.
•	Proposed a methodology to increase revenue by 11%
•	Segmented the price sensitive/insensitive groups of customers using elasticity modeling and segmentation. 
•	Performed Market Basket analysis to bundle products that go well together to increase profits.
•	Analyzed the data to find out what marcom and discount actions would lead to an increase in profit margins and loyalty base for Wendy's.
•	Finally, calculated the increase in revenue after applying the above techniques that amounted to 11%.
•	Received the best project remark and appreciations throughout.
Wendy's Marketing Analysis
https://github.com/aarohi92trip/Wendy-s-Market-Analysis
The data is the largest health survey conducted by CDC (Centers for Disease Control and Prevention) across 50 states in USA.
•	The objective was to conduct an exploratory analysis to understand factors influencing health related risk behaviors. 
•	Performed data cleansing in R and implemented various analysis techniques 
•	Analyzed factors like food habits and activity that influence health related risks using techniques like linear regression, cluster analysis such as k-means and Hierarchical clustering methods in R
•	Implemented classification technique like decision tree approach to classify different chronical diseases.
•	Documented complete summary including the results and conclusion along with the inferences.
Behavioral Risk Surveillance System
https://github.com/Prinshu12/Behavioral-Risk-Factor-Surveillance-System
A supermarket is offering a new line of organic products. The supermarket's management wants to determine which customers are likely to purchase these products. The supermarket has a customer loyalty program. As an initial buyer incentive plan, the supermarket provided coupons for the organic products to all of the loyalty program participants and collected data that includes whether these customers purchased any of the organic products

•	Cleansed the data, checked for null values and imputed values for continuous columns using linear regression.
•	Randomized the data and created partitions for test and train
•	Used decision tree model and logit regression model for classification
•	Used test data set for prediction and checked the sensitivity, accuracy, specificity and precision
•	Decide which model more suitable for the requirement
Classification-Techniques-on-Organic-products
https://github.com/aarohi92trip/Classification-Techniques-on-Organic-products
An equities analyst is studying the pharmaceutical industry and needs to explore and understand the financial data collected by the firm. The main objective is to understand the structure of the pharmaceutical industry using some basic financial measures. Financial data gathered on 21 firms in the pharmaceutical industry.

•	Our main objective is to understand the structure of the pharmaceutical industry using some basic financial measures.
•	Applied k-means and hierarchical clustering algorithms to find optimal number of meaningful clusters.
•	Gave meaningful names to the clusters and identified good and bad clusters from an investment standpoint.
Pharmaceutical-financial-data-analysis
https://github.com/aarohi92trip/Pharmaceutical-financial-data-analysis
The DUNGAREE data set shows the number of pairs of four different types of dungarees sold at stores over a specific time period

•	Cleansed the data, removed outliers from the data and applied k-means clustering algorithm to find meaningful clusters
•	Created a profile plot for cluster centroids and named them based on their profiles
•	Evaluated the cluster validity
Types of Dungarees
https://github.com/aarohi92trip/Types-of-Dungaree-analysis
Researchers at General Motors collected data on some U.S. Standard Metropolitan Statistical Areas in a study of whether air pollution contributes to mortality
•	Used cook’s distance to remove the outliers in the data
•	Ran the appropriate regression diagnostics (normality, homoscedasticity etc) to ensure that the assumptions of OLS are not violated
•	Used Linear Regression and Principal Component Analysis to determine whether air pollution is significantly related to mortality
•	Determined the best model using various factors
Mortality Analysis
https://github.com/aarohi92trip/Motality-Analysis
A store is interested in determining the associations between items purchased from the Health and Beauty Aids department and the Stationery Department. The store chose to conduct a market basket analysis of specific items purchased from these two departments.
Top-10-Product-analysis-using-association-rule-mining
https://github.com/aarohi92trip/Top-10-Product-analysis-using-association-rule-mining
LinkedIn
www.linkedin.com
Privacy by Design: Data Sharing
http://www.linkedin.com/learning/privacy-by-design-data-sharing
IBM
IBM DB2 9 Fundamentals
PUNEET SAXENA
      
          



            
              
        
              
  

    
        Aarohi has worked for me at Mastercard. She is intelligent and a quick learner. I was impressed with her work ethics while she was working for me and i also know she is an extremely dedicated individual. I was disappointed when she said she was leaving Mastercard but was also happy for her that she was pursuing higher studies. I wish her all the success in her studies and I know she will do very well when she gets into a job.  Sreejit B.
      
          



            
              
        
              
  

    
        Aarohi was one of the brighter students of my batch. Articulate and detail oriented, she is always up for a challenge. Excellent in prioritizing tasks and working on them independently, is what makes her stand out from the rest. I had the opportunity to team up with her at school, I realized she does possess some great analytical skills that helped the overall team towards the final goal. She is definitely a great value add for any team that she joins.
Liked by Aarohi Tripathi
https://www.linkedin.com/signup/cold-join
Dear Linkedin Community - I m reaching out to you on behalf of 300+ students that I have in my program (MS In Business Analytics at UT Dallas). They…
Liked by Aarohi Tripathi
https://www.linkedin.com/signup/cold-join
I’m happy to share that I’m starting a new position as Software Engineer at Microsoft!I want to thank my family & friends for constant…
Liked by Aarohi Tripathi
https://www.linkedin.com/signup/cold-join
Good Evening Everyone! I would like to announce I have a new business venture￼￼ launching￼ January 26, 2022 at 7 pm est. Join us via Facebook Live…
https://in.linkedin.com/in/aarohi-tripathi-7bb533141
Lucknow
Aarohi Tripathi
Student at Babu Banarsi Das University, Lucknow
https://in.linkedin.com/in/aarohi-tripathi-4b1990b5
India
aarohi tripathi
--
https://in.linkedin.com/in/aarohi-tripathi-826681a3
Dhanbad
Aarohi Tripathi
Research Professional
https://in.linkedin.com/in/aarohi-tripathi-91b4a3231
Kakori
Aarohi Tripathi
--
Amazon interview Prep
https://static-exp1.licdn.com/sc/h/4h1ldzvvebtszyx75ve7dst1v
https://www.linkedin.com/groups/13833747
Microsoft University Recruiting Team
https://media-exp1.licdn.com/dms/image/C5607AQFO-fto2EJ1cg/group-logo_image-shrink_92x92/0/1631008161791?e=1647694800&v=beta&t=uJyGZGi0emtwg3yyTIS2KcAHkCbWktUT3zy8l_CVDt0
https://www.linkedin.com/groups/12125564
Data Mining, Statistics, Big Data, Data Visualization, AI, Machine Learning, and Data Science
https://media-exp1.licdn.com/dms/image/C4D07AQHC5_oHcJZLpw/group-logo_image-shrink_92x92/0/1525133044361?e=1647694800&v=beta&t=DgFGkQYOnqeNdqDqVrSU7luyknEfda_Cm_0Uoa3G5qg
https://www.linkedin.com/groups/152247
Artificial Intelligence and Business Analytics (AIBA) Group
https://media-exp1.licdn.com/dms/image/C4E07AQHsCFbktnq6FA/group-logo_image-shrink_92x92/0/1631000142355?e=1647694800&v=beta&t=RnTsJjuBKiOYNCLra0rbq-tnhHHbM2nYsb_0JNxWXG4
https://www.linkedin.com/groups/62438
Grace Hopper Celebration of Women in Computing
https://media-exp1.licdn.com/dms/image/C4D07AQFNz6ml3Tt0zg/group-logo_image-shrink_200x200/0/1631370143995?e=1647694800&v=beta&t=7Bdi_jO2hRzerUf36l7NzJ2NFPhNviH2To56XIWqSP4
https://www.linkedin.com/groups/2118727
Business Intelligence, Analytics & Data Visualization (Moderated)
https://media-exp1.licdn.com/dms/image/C5607AQFl-D6m1dwq1w/group-logo_image-shrink_92x92/0/1544605905422?e=1647694800&v=beta&t=_JNRDueWLo1rlHumfNweQ_sB1RQGOGZhdKcXEBJAycQ
https://www.linkedin.com/groups/40057
Indian Students Association at UTDallas
https://media-exp1.licdn.com/dms/image/C4E07AQFzDgRuzAJNIw/group-logo_image-shrink_92x92/0/1631002607118?e=1647694800&v=beta&t=lsFdw3Ji3fn6d4g2ZC_fOMdKb8P5JMkqE30kqBjAmoY
https://www.linkedin.com/groups/3882144
Big Data, Analytics, Business Intelligence & Visualization Experts Community
https://media-exp1.licdn.com/dms/image/C4D07AQH2q7TKmljeSw/group-logo_image-shrink_200x200/0/1631354674766?e=1647694800&v=beta&t=cMcZyUXETzunRhYBhMGcR3UkcMo6zTn-IoYbEU2t9XU
https://www.linkedin.com/groups/23006
Big Data and Analytics
https://media-exp1.licdn.com/dms/image/C4D07AQFNPg4NMiT96Q/group-logo_image-shrink_200x200/0/1630999429915?e=1647694800&v=beta&t=ilcl9RAq73KJdf9jTWLJTsZRoJF7Bmi9muPPkHWd6zs
https://www.linkedin.com/groups/4332669