SHWETA ARANDE

Data Analyst with *+ years’ experience in Consumer & Marketing Analytics, Data warehouse & BI adjknk@r.postjobfree.com linkedin.com/in/shweta-arande-79867515b shwetarande.wordpress.com EDUCATION:

MS-Business Analytics Major-Data Engineering/Analytics CSU, East Bay Aug 2019 – Dec 2020 Courses –Database Management Systems, Data Warehouse and Business Intelligence, Big Data, Optimization Methods, Data Analytics, Data Mining, Statistics. MBA-Finance S.R. Luthra Institute of Management, India Aug 2014 – Apr 2016 PROFESSIONAL EXPERIENCE:

Data Analyst, KPMG Virtual Intern May 2020 – Jul 2020

• Developed quality control metrics for the data acquired from client. Formed strategies to cleanse the data, fill the missing values and remove outliers leading to almost 99% error free good quality data.

• Performed activities like understanding the data distributions, data transformations and modelling.

• Build complex analytical SQL queries in MySQL DB to identify Top 1000 high value customers using domain knowledge and historical transaction records of the customers.

• Created Dashboards in Tableau to present insights to clients. Axis Bank, India Data Analyst Jul 2016 – Feb 2019

• Researching, gathering and analyzing business data for Sales/product managers.

• Designing and carrying out social, economic, and marketing surveys to capture over 100 data points, as well as demographic studies to define target markets and their buying habits and preferences.

• Using BI tools like Microsoft SQL Server and Excel to model current customers and to identify new ones leading to increase in overall sales by 10% every quarter.

• Preparing reports and dashboards on market trends, consumer habits, and outcome. TECHNICAL SKILLS:

• Data warehouse/Visualization: Tableau, MySQL, MS Sql server, Dimensional modeling, ETL

• Programming : SQL, Python, R,

• Frameworks/Libraries: Pandas, Numpy, Matplotlib, sklearn, Seaborn, BeautifulSoup

• Machine learning: Time series forecasting, Regression, Classification, Associative rule mining

• Big Data: HDFS, Hive, Pig, Python-MR, AWS EMR, S3

• Finance: Risk Management, Equities & Mutual fund analysis, Payment card processing PROJECTS:

Amazon stock price prediction [ Time series, ARIMA, Trailing MA, AES, Regression, R ]

• Extracted Amazon stock data from Yahoo finance for last 5 years and analyzed in R.

• Identified Trend, Seasonality and error in the data by creating ACF plots in R.

• Built & compared models such as Holt-Winter’s model, ARIMA, Regression model and Trailing MA.

• Choose Holt-winter’s model based on low RMSE & MAPE value for future forecasting. Retail Data warehouse [MySQL, Tableau, Partitioning, Indexing, Dimensional modeling]

• Created BUS matrix to identify Facts and Dimensions that supports in Decision making and analytics.

• Developed ETL jobs to populate SCD type 2 dimensions and Facts conforming to a star schema.

• Build Datamarts for adhoc analysis and Dashboards in Tableau for data visualization. NCDC temperature data extraction/analysis [AWS EMR, Hadoop, Hive, Pig, S3]

• Extracting and cleansing temperature features of NCDC data on AWS EMR.

• Developed pig scripts to analyze and create summary statistics of the data.

• Created Hive external table to run SQL like queries to get insights and reports. VOLUNTEER EXPERIENCE:

San Mateo County Libraries, San Mateo, CA Volunteer Apr 2019 – Nov 2019 Conducted craft sessions for school students at San Mateo county Library

Contact this candidate