Data Analyst Tableau

DARSHIL SHAH

Houston, TX **************@*****.*** (preferred) 832-***-**** Linkedin:https://www.linkedin.com/in/darshilshah1996/

GitHub: https://github.com/Darshu0807

Summary:

Solution driven Business Analyst with around 2 years of track record analyzing business intelligence to support business growth.

Experienced in writing complex SQL Queries and worked with various database platform.

Team player with the ability to work independently and ready to accept challenges and learn new technologies.

Excellent written, communication, presentation, and interpersonal skills.

TECHNICAL SKILLS:

Data Analysis Tools: Hadoop (Spark), SQL Server 2019, Tableau, Power BI, MS Excel, Alteryx

Programming Languages: Python (Sklearn, NLTK, Pandas, Numpy, SciPy, Matplotlib, Seaborn), SQL

Data Modeling Tools: Visual Studio

Database Management Software: Oracle 11g-12c, MySQL, MS SQL Server, MS Access

Certifications: 1Z0-144 Oracle Database 11g: Program with PL/SQL

761: Querying Data with Transact-SQL (Microsoft)

ACADEMIC PROJECTS:

New York City Parking Violation Control System June 2019 - Aug 2019

Performed analysis on NYC Department of Finance dataset occurred between 2013-2017

Generated pivot tables and visualized trends in the data through MS Excel.

Observed that top 5 vehicle brands often violated the parking violations.

Concluded that some months had least, and some months had Highest amount of parking Violations.

Tools Used: MS-SQL server, Visual studio, Excel, Access

Airbnb Rentals in Texas Sep 2019 - Nov 2019

Analyzed an Airbnb dataset which includes details of four main cities in the Texas state

Deduced a surge of 58.3% in the average nightly price in all the bedroom categories from 2008-2017.

Examined an increase of 31.5%,36% among the average booking for 3 and 2 bedrooms respectively

Indicated a drop of 25% in the single bedroom category over the years

Inferred that year 2016 had 88% more rentals compared to the year 2008 which included more of single bedrooms.

Employee Information Dashboard Dec 2019 - Feb 2020

Analyzed a dataset taken from Udemy based on the employee information over 12 years which is from 1990 to 2002

Built a Tableau visualization dashboard along with SQL to represent gender-based employee distribution in an organization.

Performed detailed analysis (i.e determine the number of female and male managers per department, average annual employee salary over the years, Average employee salary per department, breakdown between male and female employees)

Tools Used: SQL, Tableau.

Power BI and Tableau Dashboard for Analyzing Data Mar 2020 - May 2020

Created Live Dashboard for visualizing Corona Virus Live update daily for countries using Power BI saving time.

Found a yearly pattern and relation between law and gun incident happening and suggestion to lower the crime rate.

H1B Data Analysis Jun 2020 - August 2020

Arranged, merged, cleaned H1B dataset for years 2011-2016.

Examined that the Data Analyst job title from the overall Data Science Job profile having Average Prevailing wage of 178370.01 and most no. of applications in 2016.

Achieved 65% F-1 score in predicting case status using SVC, Random Forest, Adaboost algorithm etc. based on wage level and location.

Tools Used: Python, Pandas, NumPy.

PROFESSIONAL EXPERIENCE:

Business Analyst, Rikhav Swayam Solution, India October 2017-November 2018

Analyzed and documented business needs to track KPIs like user growth, CAC (Customer Acquisition Cost), LTVs (Lifetime Value) and Campaign Analytics to support business growth.

Improved 5% revenue by optimizing campaigns to acquire high LTV users using historical campaign performance data.

Used Tableau and SQL to create impactful dashboards that assisted in tracking KPIs and help take critical business decisions.

Co-ordinated with business users to gather requirements and work with ETL team to provision required data sources to meet business needs.

Developed data cleansing rules to provide better data quality for business dashboards.

EDUCATION:

MS in Management Information System May 2019 - Present

University of Houston- Clear Lake (GPA:3.14)

Bachelor of Engineering in Information Technology July 2014 - June 2018

Gujarat Technological University, Gujarat (GPA:3.33)

Contact this candidate