HARINI GRANDHI

AWS Certified Cloud Practitioner

Boston, MA 617-***-**** adi4vx@r.postjobfree.com Readily Available /harini-grandhi/ PROFESSIONAL EXPERIENCE

Elevate Labs – Data Analyst (Part time) Aug 2020 - Present

Developed complex SQL with window functions to identify root causes and create measurable metrics for ad-hoc requests

Created app performance dashboard in Looker, assisted product team to implement and analyze A/B tests using Amplitude

Working on migrating derived tables from Looker to Snowflake with DBT to change ETL to ELT by tracking scope through JIRA Wayfair – Data Analyst, Sales & Operations Co-op Jul 2019 - Dec 2019

Identified metrics driving $3M issue resolution costs and developed business strategies to reduce 40% of resolution costs

Implemented Binary Classification using TF-IDF on feedback to improve categorization by reducing False Positives by 32%

Built SQL quires for customer interaction, suggested process-change increasing usage by 48% improving customer experience

Performed Statistical Test in Excel using advanced formulae and Lookup to reduced 5-20% transport costs based on routes

Created dashboards in Looker to automate reporting of product-level financial statements to facilitate managerial decisions

Collaborated with technical and business teams to have end-to-end ownership of projects and re-prioritizing as necessary

Created process documentation, presented detail-oriented analysis to senior leadership for cross-functional use of reports

Honors: Recognized as ‘Number Cruncher’ by Senior Administration for contributing towards the team goals Northeastern University – Graduate Research Assistant Jan 2019 - Dec 2019

Mined 17M+ Brexit related tweets of 1M+ unique users; Restructured 11GB database using SQL facilitating opinion analysis

Labeled 333K+ tweets from 25K users with polarized keywords to build ground truth; constructed a Neural Network with 84% accuracy to predict Brexit polarity of tweets and users and made through documentation of method and process Accenture Solutions Pvt. Ltd – Reporting Analyst May 2016 - Dec 2017

Evaluated many ETL Transformation scripts in SAS to ensure Data Quality and Data Completeness from source to target

Troubleshooting on 1M transactions data per day and developed reject codes for duplicates in SQL to deploy in production

Developed interactive Ad-hoc reports to analyze sales KPI’s in Tableau, collaborated with stakeholders to report findings

Improved ETL transformation time by 5 hours by tuning SAS mappings, automated ETL status updates using Excel & Linux TECHNICAL SKILLS

Scripting/Programming Language Python, R, C, C++(Expertise in Algorithms & Data Structures), Linux Database SQL, Oracle, Teradata, Hadoop (Pig, Hive, Map Reduce), PySpark, AWS, Azure Visualization & Analytical Tools SAS, Google Analytics, Amplitude, Advanced Excel, Power BI, Tableau, Looker Statistical Testing Hypothesis testing, ANOVA testing, T-Test, Z-Test Data Science skills Regression, Classification, Clustering, Dimensionality Reduction, NLP, Time Series EDUCATION

Masters in Data Analytics Engineering - Northeastern University, Boston, MA Jan 2018 - May 2020 Bachelors in Electrical and Electronics Engineering - Osmania University, India Aug 2012 - May 2016 PROJECTS

Image Classification and Text Extraction - Deep Learning (Python) Jul 2020

Classified different forms using VGG-16 and Resnet-50 and maintained accuracy above 95%

Extracted data from the forms using tesseract. The hand-written text has been extracted by optimizing the functions E-Commerce Marketing Strategies - Digital Marketing (Python, AWS, Salesforce) May 2020

Developed customer segmentation, pricing strategies, personalized recommendation to improve customer retention rate

Deployed model in AWS, developed warehouse with star schema in Redshift, built Salesforce Einstein Analytics dashboards Stock Price Prediction - Web Application, Machine Learning (Python, Flask, Heroku) Jun 2019

Fetched Stock Closing price from Yahoo to feed as input for Neural Network, tested RNNs like LSTM and GRU with auto encoders

Designed Web App using Flask, deployed prediction algorithm on Heroku, where users can fetch results for selected companies Data Warehousing, Integration & Visualization for Contoso Retail (Talend, SQL, Tableau) Dec 2018

Designed star schema of the crimes database by Integrating multiple source files (Flat files, CSV, Oracle, Teradata) into SQL Implemented slow changing dimensions, reject codes and performance tuning with 48M rows, built dashboards in Tableau Adventure Works Data Analysis - Big Data (Hadoop, Tableau) Mar 2018

Implemented Map Reduce using Summarization, Top K, Secondary Sorting and Filtering patterns. Improved performance using partitioners & combiners. Queried data in Pig using Pig Latin scripts, visualized analysis results in Tableau Stories

Contact this candidate