Data Analyst Tableau

PANKHURI PACHORI

adg4sb@r.postjobfree.com 240-***-**** LinkedIn Tableau

EDUCATION

University of Maryland, College Park, MD (Aug 2018 – Dec 2019) Master of Science in Business Analytics, GPA 3.4

Tutor – Data Models & Decisions for MBA students

Vellore Institute of Technology, Tamil Nadu, India (July 2013 – May 2017) Bachelor of Technology, GPA 3.6

Special Achievers Award 2016 for recognition on International Platform

SKILLS

• Python ( Numpy, Pandas, Re, Scikit, NLTK, Matplotlib, Seaborn, Keras, OpenCV), R, Hadoop, MapReduce, Hive.

• MySQL, MSSQL, Tableau, Tableau Dashboard, Tableau Public, MS PowerBI, MS Excel (Pivot, Solver, StatTools), AWS.

• Data Modeling, Data Mining, Data Transformation, Data Visualisation, Business Intelligence, KPI Tracking.

WORK EXPERIENCE

Product Data Analyst, Sukhi CA (July 2020 – Present)

• Leading Analytics at the company and working with product/engineering teams. Revamped the product resulting in 60% increased user engagements. Responsible for end-to-end product development and launch.

• Used SQL queries to extract data from the internal database. Implemented statistical analysis in Python and R to analyse consumer behaviour and determined opportunities for improvements in the product.

• Converted analytical findings into PowerBI dashboards to assist the leadership track user engagement, performance metric. Capstone Data Analyst,

Principal Financial Group Iowa (Aug 2019 – Dec 2019)

• Built machine learning models like LSTM, Random Forest, Logistic Regression using Python, R to gain insights on the ability of text features to predict market trends to help the stakeholders reduce the risk of investments.

• Processed and aggregated the data using PostgreSQ to reduce rows from 5 million to 900 with 80% faster download time.

• Conducted variable selection and selected top 50 features out of 310 to be used in their existing models, resulting in improved prediction accuracy of their models and an optimized stocks portfolio.

Data Analyst Intern, Elexxea LLC MD (Aug 2019 – Dec 2019)

• Enabled data scraping using a script in Selenium and Webdriver in Python, reducing manual work by 62%.

• Converted the extracted data into reportable format and conducted exploratory data analysis using Python and R to address any inconsistencies like missing values, duplicate values, inaccurate values in the data for faster data processing.

• Designed a database schema to load the transformed data into the internal database and increased efficiency by 40%. Effectively communicated findings to the seniors using reporting dashboards in Tableau.

Data Analyst, MPOnline India ( June 2017 – June 2018)

• Used data to extend and enhance the service of various government departments like bill payments, reservations, university application etc. directly to common citizens by making these services online.

• Explored the impact and sustainability of these services using data, helping enhance the user experience of 28 million people and in turn resulting in increased user acquisition and 20% higher revenue.

• Enabled and provided ad-hoc reporting dashboards in PowerBI for Business insights. Optimized reporting by 30% by developing automated interactive dashboards by leveraging Power BI features and functionalities.

PROJECTS

Virtual Data Analytics Internship, KPMG (https://public.tableau.com/profile/pankhuripachori#!/) CA (Jun 2020)

• Analysed transactional and customer data to help boost the client’s business and optimise their marketing strategy. Assessed the data quality and recommended ways to clean the data and mitigate data quality issues.

• Worked on data cleaning, feature engineering and data modelling using Python, SQL to determine customer trends / behaviour. Identified target audience to drive the most value. Displayed insights using interactive dashboards on tableau.

Web App for Accommodation Search (Aug 2018 – Dec 2018)

• Curated a web app for UMD’s students and staff to facilitate accommodation search near the university. Created database schemas, performed ETL and wrote efficient queries in MySQL to develop and populate the database.

• Created action filters, parameters and calculated sets on Tableau; Designed interactive dashboards and published them on Tableau public; embedded the code from Tableau Public on the website. LEADERSHIP

Vice President Public Relations, Smith Masters Business Analytics Association (Dec 2018 – Dec 2019)

• Handled all aspects of planned publicity campaign & expanded relations. Organised workshops in R, Python,SQL and ML

• Convinced MPO to bring in influential speakers organised workshops/events for 300+ students studying in business school.

Head of Publicity and Marketing, Team Eklavya (ASCE) (Nov 2015 – April 2016)

• Led a group of 8 students to help the team improve public visibility and gain sponsors. Implemented new marketing strategies.

• Launched a crowd funding campaign and rounded up ~$10,000 to fund the requirements of the team without any aid from the university.

Contact this candidate