I am a graduate student pursuing my Master’s in Business Analytics and Project Management at University of Connecticut with a specialization in Data Science. I have 3 yrs of experience in the field of Data Analytics. I recently worked with Arista Networks as Data Science Analytics intern. During the course of my academic career, I have worked on many data science related projects.
I am skilled in Data Modeling and Visualization. Passionate about dealing with real-world business problems and ability to work in a fast-paced environment with multiple stakeholders.
Analytical Tools : R, Python, SQL, SAS Enterprise, MS-Excel
Visualization : Tableau, Power BI
Data Science : Supervised Learning Methods (Regression- Linear & Logistics, Lasso, Ridge, Decision Trees, Random Forest, Ensemble Models, SVM, NLTK) ; Unsupervised Learning Methods ( K-means, Hierarchical clustering), Hypothesis Testing
Other : Microsoft Word, Power Point, Risk Analysis, Agile and waterfall Methodologies, MS Project, JIRA, Agile
Certification : Introduction to Python, Data Manipulation with Pandas, Understanding Machine Learning, Intermediate SQL Queries
University of Connecticut,School of Business, Hartford, CT Expected May 2023
Master of Science in Business Analytics and Project Management GPA: 3.86/4
Major courses: Statistics using R, Predictive Modeling, Data Science using Python, Business Decision Modeling, Data management and Business Process Modeling , Web Analytics
Indira Gandhi National Open University, India Oct 2020
Post Graduate Diploma in Applied Statistics
University of Delhi, India Jun 2016
Bachelor of Science (Hons) in Mathematics
Review Airbnb Scores Rating Prediction (Python, Tableau)
Completed EDA on Airbnb data, analyzed regression algorithms for predicting review scores rating, achieving 90% accuracy
Created interactive dashboards to visualize the outcome, presented insights such as the average increase in scores rating and top 3 factors affecting the scores rating
EV charging stations in the US (Python)
Developed a classification model to predict the presence of electric vehicle (EV) charging stations for 30k zip codes and a regression model to estimate the count of such stations
Used MSE, precision, recall to validate the accuracy of the model
Google Ads recommendation for business Marketing of Optical Firm (Web analytics, R, Excel)
Understood the impact of advertisements on sales of an optical firm based on customer profiles using p-value < 0.5
Used metrics like Click through rate and Approved conversion rate to increase the brand awareness and firm’s revenue
Modeling a business process (E-Commerce) (Oracle, SQL, Lucid Charts)
Established a business process and Entity Relationship Diagram in Lucid charts forming the basis for the Oracle database to store all the relevant customer, orders, seller, and payment information
Generated complex SQL reports to strategically help in improving the e-commerce business
Arista Networks May’22-Dec’22
Data Science Analytics Intern
Collaborated with the audit team on channel compliance and developed a model to detect unusual discounts, resulting in a 60% increase in work efficiency by identifying outlier resellers, end customers, and sales orders
Implemented the discount model and collaborated with cross functional teams to perform customer analysis on Tableau
Conducted an exploratory analysis of 16k IT helpdesk tickets, using Python and Excel, to create a dashboard for analyzing ticket trends and optimizing staffing plans
Led the end-to-end process for ERM risk assessment reporting and designed a heat map in Excel to display top risks
Executed sentiment analysis on comments using TF-IDF to generate a top risks word cloud for the risk management team
Stanley Black and Decker Sep’22-Dec’22
Data Analytics Consultant
Cleaned and merged spend and protrak & productivity datasets containing 5M rows using Python
Delivered a Tableau dashboard for 1k+ SBD Finance users which allows to extract insightful and granular information
KIA, Royal Motors[Bhopal] Pvt. Ltd Nov’20-Jun’21
Business Analyst
Leveraged SQL and Tableau to aggregate data creating various dashboards and ad-hoc reports for Sales & Delivery managers improving sales performance by 18%
Conducted 3 workshops for various analytical skills such as Sql, Excel, Tableau for newly recruited employees
Mechanz Mar’17-Jan’19
Associate Data Analyst
Developed a classification model to predict customer churn rate based on their transactional behavior. It aided marketing teams in identifying the worst spenders to reduce churn by 30%
Prepared final analysis reports for the stakeholders to understand the data analysis steps, enabling them to take decisions
Performed clustering and market segmentation analysis for existing clients based on multiple factors ~ reducing marketing cost by 15%
Assessed the effectiveness of various marketing campaigns using A/B testing
Designed sales monitoring dashboards to plot relevant KPI enhancing sales performance by 12%
Continuing my journey in the field of Analytics, I’m excited upon applying the learning from my Master’s at Business Analytics program into solving real-life problems with companies. I seek roles with challenging tasks and which allows me to continue to learn and explore different Analytical techniques and master the tools.
My field of Expertise includes:
Predictive Modeling
Data Visualization
Data Manipulation
Contact details:
Primary Email ID: gyanvi.chauhan@uconn.edu
Secondary Email ID: gyanvi10@gmail.com
Mobile No.: +1(860)-834-2806
ResumeThank you for the consideration. I appreciate your time devoted to my candidature. I look forward to hearing from you. Any feedback are most welcome! I would certainly want to know on how can I continue to improve my profile and build a career in the field of Analytics.
P.S: This webpage is constantly under development and is built using RMarkdown. Please download the Resume file as a PDF