Data Analyst Visualization

RADHIKA LAKHANI

github.com/radhi***

San Diego, California 623-***-**** ********@*******.*****.*** linkedin.com/in/Lakhani-Radhika SUMMARY

A highly competent and goal-oriented data analyst with a track record of gleaning important insights from complicated datasets to support wise business choices. Strong analytical attitude, expert data manipulation skills, and in-depth knowledge of statistical analysis and data visualization using various tools and computer languages, such as SQL, Python, and data visualization programs.

TECHNICAL SKILLS

Languages: Python, R, SQL, NoSQL, Scala, Shell script Data Architecture: Data Modeling, Data Flow, Data Warehousing Statistics: Statistical Techniques, Mathematics, SAS Business Technologies: HTML5, Tableau, Power BI, MS Excel, Google Sheets Database Technologies: SQL Server, MySQL, MongoDB, Redis, Oracle DB, Microsoft Access, PostgreSQL Data Visualization: Tableau, Power BI

EXPERIENCE

Sculptsoft, Gujarat, India July 2020 May 2021

Data Analyst

● Developed a Tableau dashboard that analyzes sales revenue data (over $2m).

● Created a tableau reporting structure across the marketing and product business teams. Improved KPIs by 15% by developing an interactive group analysis report with filters and parameters.

● Identified procedural areas of improvement through customer data by performing business analysis and improving the profitability of the organization by 8%. KPMG Data Analytics Virtual Internship February 2022 May 2022 Data Analyst Intern

● Successfully detected high-value customers based on customer demographics and attributes using RFM analysis marketing technique for Sprocket Central Pty Ltd, a medium-sized bikes and cycling accessories organization.

● Converted raw data into meaningful insights by applying exploratory data analysis. Distinguished top three industry sectors contributing the maximum profit.

● Technologies: Pandas, NumPy, Matplotlib, Seaborn PROJECTS

Air Fare Prediction August 2021 December 2021

• Preprocessed 100k rows of data with more than 30 characteristics to determine which attribute had the greatest influence on the target variable Price.

• Trained Machine Learning models to forecast airplane ticket prices for multiple airlines, compared their performance, and hyper-tuned models with an R-square value of roughly 85%.

• Technologies: Random Forest Regressor, Label Encoder, Mutual Information Yelp Dataset Challenge Big Data August 2022 December 2022

• Conducted data wrangling over 8 million reviews running SQL queries on data bricks with applying CoNVOs framework. Using Tableau, compared elite and non-elite reviews for voter count.

• Discovered elite users with 35% of total users.

• Technologies: SparkSQL, Pyspark, NoSQL

SoDistant February 2023 May 2023

• Created computer vision technology to assist live-feed cameras located in public locations in monitoring people's social distancing.

• Coded front-end including dashboard page where end-users can enter a camera URL or a video file from their local system for analysis.

• Detection of objects is done YOLO library, and the Euclidean distance between the centroid of the delimited boxes around the objects is then determined.

• Displayed results as graphs showing number of violations and videos depicting bounding boxes around people.

• Technologies: Python, Flask, HTML, CSS, React, React-bootstrap, React-plotly, AWS (EC2 with Load Balancer, S3)

EDUCATION

Master of Science, MS in Computer Science, California State University San Marcos, CA Bachelor of Technology, BTech in Information Technology, Gujarat Technological University Gujarat, India

Contact this candidate