ADARSHA THAKUR

New York, NY ***** adk9m3@r.postjobfree.com 832-***-**** Adarsha Thakur LinkedIn DATA ANALYST

Data analyst with 3+ years’ experience interpreting and analyzing large data sets for driving business solutions, building, and evaluating analytical models. Adept in ETL, SQL, Python, Advanced Excel, Tableau, and Power BI. EDUCATION

Pace University, NY Master’s Degree in Computer Science- Enterprise Analytics Expected Jun 2021 3.6 Awards: Received $10,000 Scholarship for winning Best academic Project (out of 50+) by Faculty vote. Osmania University, Hyderabad, India Bachelor’s Degree in Commerce- Honours 2017 3.7 Achievements: Dean’s List’ 2017 and President of Data Science club from 2015 to 2016. EXPERIENCE

Data Analyst- Process ADP, India April 2018 – August 2019

● Extracted, compiled, and tracked data, and analyzed data to generate reports. Developed quantitative analysis, tools, ad hoc reports, and models to support Stakeholder decisions.

● Analyzed existing client systems, interface requirements to build complex SQL reports for auditing $2.5 million of pay and benefits for over 150 individual records.

● Created interactive dashboards using SQL, Python, and Tableau to understand KPI and key insights reducing 45% Man-hours.

● Worked with cross-functional teams such as marketing and finance to deploy data quality across several pipelines and to set up processes to triage data issues, develop business cases, and marketing strategies. Data Analyst Vaishnavi Consultants, India May 2016 – April 2018

● Using SQL and Excel identified common complaints amongst new customers leading to process change that improved customer satisfaction by 14%.

● Analyzed the outcome from the email and Digital campaign using MS Excel and Tableau, which produced a 20% increase in click-through and conversion rate, eventually increasing revenue by 12%.

● Added $20K in revenue profit by highlighting Key insights to boost marketing efforts using SQL, Python, and Tableau.

● Generated and tested hypotheses to identify growth opportunities and improve customer experience by 45%.

● Streamlined and automated a key business report in Tableau that saved the team 10 hours of reporting each week. ACADEMIC PROJECTS

Predicting sales of Flights and Hotels using Rstudio and Tableau Jan 2021

● Performed extensive descriptive and explanatory analysis on 8 variables to predict sales of Flight and Hotels

● Performed predictive analysis to establish relationship between the sales of Flights and Hotels and the explanatory variables

● Designed interactive Tableau dashboards to visualize sales of Flights and Hotels. Customized Autonomous Driving System Analysis for Tesla with Python, MySQL, and Tableau Sep 2020 - Dec 2020

• Performed data preprocessing and data cleansing in Python, created a database in MySQL for more than 1 million rows and used triggers, views, stored procedures to analyze human driving behavior.

• Showcased a variation of 18% in driving patterns of individuals by transforming statistical data of velocity and acceleration in multiple scenarios using Tableau.

Data Architecture, Warehouse, and Visualization Using Informatica, SQL, and Tableau Jan 2020 – April 2020

● Integrated data in Informatica using Data servers such as SQL Server, Mongo DB while efficiently maintaining ETL pipeline.

● Performed detailed visualizations of output in Tableau and Power BI to answer business problems which include Period vs Period analysis, Hierarchy of products, Top N Brands by their sales amount. Developed Mobile Game using Python Aug 2019-Dec 2020

● Gathered requirements, designed UI/UX, and developed game logic by importing Jupyter library in python.

● Players select a letter and must guess the word by filling the blank variables, high score was stored locally.

● Won ‘Project of the semester’ for the intuitive game and user experience. LEADERSHIP & EXTRACURRICULAR

Team Leader Teach for All Feb 2018- April 2019

Joined Teach for All as a Team lead for teaching 27 underprivileged students, ensuring the flow of resources by raising funds through several platforms, hence increasing the overall literacy rate by 23%. TECHNICAL SKILLS

Programming: SQL, Python (NumPy, pandas, scikit-learn), MYSQL, SAS. Modelling: Linear and logistics regression.

Analytics: Tableau, Power BI, MS Excel, Google Analytics, and A/B testing.

Contact this candidate