Bhavya C Email & Phone Number

Charlotte, North Carolina, United States

• Responsible for providing data analysis that focused on improving user experience and optimizing user retention.• Wrote complex ad-hoc MySQL queries involving correlated subqueries, window functions and common table expressions to track user activity metrics such as retention rate and daily active user. Optimized existing queries to run faster on large dataset. Advanced information management and new data processing techniques may be applied to extract the value locked up in this data called Hadoop (HDFS) along with processing large data sets in parallel across a Hadoop cluster and the utilization of Hadoop MapReduce framework.• Created a multi-page report dashboard in Google Looker (Data Studio) using Google Big Query data. • Write Complex SQL queries to reflect those rules and be able to validate the mappings by running these test scripts and checking if the data in target table populates correctly by writing complex SQL queries.• Worked with project management business teams, and departments to assess and refine requirements to design/develop Bl solutions using Tableau.• Use Power BI to analyze complex datasets and visualize data trends, patterns, and outliers to aid in decision-making processes Produced and enforced data standards and maintain a repository of data architecture artifacts and procedures.• Researched and developed hosting solutions using Tableau and other 3rd party hosting and software as a service solution.• Designed and maintained MySQL databases, and created pipelines using user-defined functions and stored procedures for daily reporting tasks.• Developed dashboards in Tableau and present data to track KPIs and product performance using data from various sources such as MS Excel, AWS S3, AWS RDS, AWS Redshift, JSON and XML.• Built ETL pipelines to retrieve data from NoSQL databases and load aggregated data into the analytical platform.

Connecticut, United States

We grant the wishes of medically eligible children (i.e., those diagnosed with critical illnesses — a progressive, degenerative or malignant condition that has placed the child's life in jeopardy).

Charlotte, North Carolina, United States

• Responsible for creating reporting dashboards, performing data mining and analysis to understand customer purchase behavior.• Created real-time dashboards in Tableau to visualize and monitor key metrics and A/B test processing using both external and internal data.• Collaborated with the marketing team to analyze marketing campaign data and perform analysis involving segmentation, cohort analysis.• Designed MySQL table schemas and implemented stored procedures to extract and store customer purchase and session data.• Queried data from MySQL database and validated and detected inconsistent data using Python packages Pandas and Numpy.• Actively involved in designing A/B tests, defining metrics to validate new user interface features, calculating sample size and checking statistical assumptions for tests.• Performed statistical analysis such as hypothesis testing, regression analysis, confidence interval and P-value calculation using R to find insights to increase click through rate and sales and built web applications for ad-hoc interactive dashboard.• Performed Exploratory Data Analysis to identify trends using Tableau and Python (Matplotlib, Seaborn, Plotly Dash).• Wrote scripts to store data into Hadoop HDFS from various sources including AWS S3, AWS RDS and Web API and NoSQL Database MongoDB.• Deployed Big Data tool Spark and Hive to analyze large datasets up to 2TB stored in Hadoop HSDF, including performing filtering and aggregation using SparkSQL based on Spark DataFrame.• Developed Python scripts to do data preprocessing for predictive models including missing value imputation, label encoding and feature engineering.• Implemented machine learning model including Decision Trees and Logistic Regression to predict revenue from returning customers to help the market team take appropriate promotion strategy using Python.

India

• Performed data lookups (VLOOKUP, HLOOKUP, and INDEX-MATCH) to efficiently merge and cross-reference data from different sources developed and maintained Looker dashboards and reports to provide actionable insights• Performed exploratory data analysis and identified data patterns that can translate into business rules.• Deployed MS SQL Server platform to store transform and query data for data analyzing and reporting.• Wrote T-SQL queries involving multiple joins, subqueries and common table expression to perform data aggregation for reporting.• Performed statistical analysis such as T-test, F-test, ANOVA, MANOVA, Confidence interval calculation and Distribution identification using R, and generated reports using R Markdown.• Used ETL tool SSIS to extract data from both external and internal sources including csv json excel and load data into database. Ensure data integrity, accuracy, and consistency work with data engineering teams to manage data pipelines and ETL processes, ensuring data is easily accessible and usable.• Designed and implemented robust data models within Power BI to ensure efficient data integration and reporting processes integrated data from multiple sources into DOMO for comprehensive analysis and reporting.• Collected data from various sources using Python and loaded data into Pandas Dataframe to detect outliers and imputing missing values.• Visualized data from MySQL and MS Excel using Tableau Dashboard to monitor email performance. connected to MySQL database using R package RMySQL and retrieving data for statistical analysis and visualization.• Performed exploratory data analysis (EDA) to find insight such as difference efficiency among different devices using ggplot2 in R.• Worked on performing quantitative analysis for credit portfolios, data quality control and data profiling.

Hyderabad, Telangana, India

We grant the wishes of medically eligible children (i.e., those diagnosed with critical illnesses — a progressive, degenerative or malignant condition that has placed the child's life in jeopardy).Prospect research on donors, foundations, and corporationsAssist with stewardship thank you calls and notesProduce donor acknowledgements and other stewardship piecesRequest in-kind donations for events and wish needsIdentify opportunities for local partnerships and manage research resultsBuild and strengthen donor and corporate relationsConduct research and outreach related to major projects, campaigns and fundraising eventsSupport team in planning and executing fundraising initiatives, including internal and external events, campaigns and more

Master Of Science - Ms, Data Science With Artificial Intelligence, 3.4

Bachelor Of Technology - Btech, Computer Science, First Class With Distinction

Activities and Societies: coordinator for cultural fest from 2016-2017 Participated in paper presentations and short films and received.