Business Analyst

Pankhuri T

Salt Lake City, UT +1-385-***-****

*********@*****.*** https://www.linkedin.com/in/pankhuri-thakur-03489a1a5 EDUCATION

University of Utah, David Eccles School of Business Salt Lake City, UT Master of Science, Business Analytics August 2022 - December 2023

• Relevant Courses: Database Design, Data Science, Data Warehousing, Predictive Analytics, Machine Learning, Visualization Renaissance College of Commerce and Management Indore, MP Bachelor of Business Administration & Law August 2017 - August 2021

• Relevant Courses: Statistics, Finance, Information Technology Law, Cyber Security, Business Analysis, Project Management SKILLS

Programming: R, Python (Pandas, Numpy, Scikit-learn, Matplotlib, TensorFlow, Dask, Seaborn), pyspark Tools/Technologies: Databricks, Jupyter Notebook, Rstudio, Excel Databases/Big Data: SQL Server, MySQL, SQL, Oracle, Postgres Analytics/Visualization: Tableau, DOMO, PowerBI, ggplot Statistics: Descriptive & Predictive Modelling, Cross-Validation, Inference, Time Series Forecasting, Hypothesis Testing EXPERIENCE

Twigital Indore, MP

Business Analyst October 2021- August 2022

• Completed in-depth analysis for business optimization projects boosting revenue by 6.8%.

• Improved the website's performance of clients up to 40% by leveraging and analyzing big data.

• Provided useful overall market and customer insights to address key strategic plans. Collaborated with cross functional team to create SQL views and procedures for data analysis and reporting solutions

• Identified operating improvements from internal data with SQL, analyzes data to support a company's marketing efforts. Tracked, extrapolated, and interpreted data using Python, SQL, and Excel.

• Developed dashboards and visualized reports using Tableau for different KPI’s focused revenue and expenditure which led to an increase in profit by 10%

PROJECTS

Engineering new checkout system in Velo.com

• Performed A/B testing, calculated means using 2-tailed T-test, and conducted hypothesis testing on 2 checkout system versions

• Conducted EDA for customer spending using density plots. A Summary table with key statistics (mean, median, SD, and 95% CI) Tableau • • project Prepared Analyzed - Divvy data dashboard analysis with LOD using expressions calculations, to extract filters and weekly parameters rental dates. to visualize Compute key monthly metrics and revenue trends with related high data to bike usability rentals. (90%+)

• Visualized weekly bike rental trends with dual-axis line chart and bar chart, revealing seasonal patterns, customer preferences

• Provided analytical insights for more effective strategies to increase rental revenue by 75% Reverse Engineering of LinkedIn

• Created Oracle cloud schema for B2C needs and optimized B2B interactions for improved efficiency and user experience

• Developed 100% accurate set of models, including conceptual, logical, and physical models CERTIFICATIONS

• IBM Data Analytics with Python

• IBM Data Warehouse Engineer Professional Certificate LEADERSHIP EXPERIENCE

Student Philanthropy & Engagement Center – Fund Raiser

• I have effectively secured $8000 in funding to support the University of Utah Indian Students Association - PUBLIC RELATION SECRETARY

• Executed communication strategy, engaged stakeholders, maintained PR database

• Increased sponsorships by 50% with data-driven approach

Contact this candidate