Data Analyst

KANCHAN PRASAD

Authorized to Work Without Sponsorship in USA

LinkedIn: http://www.linkedin.com/in/kanchanprasad GitHub: https://github.com/Kanchan07/Projects

Academia: https://bitmesra.academia.edu/KanchanPrasad Email:***********@*****.***

Phone:+1-480-***-****

Location: Chandler, AZ

SUMMARY

PhD with 6+ years’ experience across Statistical Analysis and Data Analytics, Modeling, Strong research and analytical mindset and highly detail-oriented. Project management with proficient ability to interpret data and offer insights. Proven team player and excellent at problem-solving with stellar academic credentials, Technical reviewer and around 10 publications on applications of analytical techniques in notable journals.

KEY TECHNICAL SKILLS

Analytics Software: Working knowledge of Alteryx, SPSS, SYSTAT, Tableau, MS Excel, SQL

Forecasting, Model classification, Data formatting, Visualizations, Data Modeling, A/B testing and Time Series Analysis EXPERIENCE

Data Analyst, Realtor.com, Scottsdale, AZ Aug 2018-Dec 2018

Forecasting of daily, weekly and monthly lead volume to understand the trend and growth from various sources.

Week over week data reporting to understand the frequency distribution of AHT(Average Handle Time) and ART (Average Response Time) for the agents

Forecasting of weekly Agent FTE for a weekly lead volume of ~6000 for the even scheduling of staff at peak hours

Develops queries, reports and dashboards for analyzing and interpret key performance metrics for the Concierge Team

Data extraction using SQL for insights, analyzing large-volume of customer lead data, reporting and providing analytical support to the team

Reporting using google sheets and MS Excel for data insights Research Fellow, Birla Institute of Technology, Mesra, India Jan 2012-Jan 2017

Utilized neuro-fuzzy techniques as a predictive analytical tool for more precise forecasting of regional air quality

Developed a multipollutant air quality health index using fuzzy-AHP to estimate the health impact in any region

Utilized collinearity test and forward search method as a new addition to the available algorithms to eliminate the data noise and reduce the number of input variables.

Calculated the R square value of 0.85 for the developed model using SPSS Project Coordinator, Parisar, Civil Society Organization, India Oct 2009-Dec 2011

Worked on developing a GIS (Geographical Information System) based transportation network for Pune city with a population of around 3.4 million under an initiative supported by the Centre for Policy Research, New Delhi

Analyzed walkability status in metros through a multitude of methods. Collected survey data of around 309 pedestrian and field survey data of 28.65 km of Pune area. Authored a report titled “Nowhere to walk”, towards the study funded by Clean Air Initiative (CAI), Asia.

Surveyed 87.5 km of cycle track of Pune city, and with the help of designed assessment tool, it was found out that the average score was 57.4 out of 100 indicating a bad condition of the existing cycle track in the city KEY ANALYTICS PROJECTS

Insight Generation & Reporting Using Transaction Data May 2018-Jun 2018

Wrote SQL queries using join, aggregation function etc., to extract and analyze data from a transactions database to identify that the beverages were the highest selling product with 26% of the total sale which was around ~ $122 k

Created a presentation with visualizations providing overview of various categories such as customers, products etc. Building Tableau Dashboards for Movie Database Jun 2018-Jul 2018

Used movie data base to build dashboards to understand how the genres have changed over time

Build dashboards to understand what attributes differ between different production houses

Created a Tableau story to understand popularity, average budget and revenue generated were higher for movies based on novels

EDUCATION

Nanodegree Business Analyst, Udacity, CA, USA Sep 2017-Jul 2018

Learned to clearly define business issues and implemented a variety of predictive analytical techniques PhD Environmental Science, Birla Institute of Technology, Mesra, India Jan 2012-Jan 2017

Awarded Institute Fellowship for being the top performer at the National level entrance examination

Selected as a Young Scientist to attend & present at International workshop MSc Environment Science, Institute of Environment Education and Research, India Aug 2007-May 2009

Analyzed socio-economic development using mapping, quantitative analysis, and qualitative social research BSc Science (Hons), University of Delhi, India May 2004-May 2007

Ranked among the top 1%

Contact this candidate