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.
• 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.

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.

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.

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.

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.