Summary
Overview
Work History
Education
Skills
Timeline
Generic

Varsha Reddy Mandadi

Dallas,TX

Summary

Creative, efficient, motivated Data Analyst with: 5+ years SQL experience | 4+ years Tableau experience | 2+ years using Waterfall methodology | 3+ years Power BI experience | 3+ years working with complex data |1+ years in Python |1+ years in SSRS, SAS | Highly adaptable and able to prioritize work, meet deadlines, good team player and self-starter



Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Overview

6
6
years of professional experience

Work History

Data Analyst

Valley behavioral Health
01.2022 - Current
  • Created visualizations and reports using tableau
  • Created and modified complex stored procedures to extract data from SQL DB’s
  • Problem solving and quality checking reports generated by other team members
  • Enhanced patient care quality by identifying trends and patterns in healthcare data.
  • Prepared 30 presentations to board members in quarterly company meetings
  • Reviewing documentation for sql data pulls with API or SSIS for ETL processes
  • Presenting insights to stakeholders and new ideas for improvement with supervisor and team members
  • Worked with Click up and Zendesk for tracking and slack for collaborating with team members
  • Worked with C# code and SSIS processes using Visual studio
  • Managed ambiguity and develop solutions to unsolved problems
  • Maintain and prioritize series of tasks without direct input from managers
  • Familiar with EHR and streamline interface.
  • Empowered stakeholders with real-time access to actionable insights by developing dynamic visualizations tailored to their needs.
  • Conducted thorough quality assurance testing on all dashboards before deployment to guarantee accuracy and reliability of presented data.
  • Monitored and troubleshot data source systems for data flaws and errors and upstream data issues.
  • Developed and enhanced reports connecting to single or multiple data sources to improve performance.
  • Streamlined data analysis processes for improved decision-making by automating complex SQL queries and integrating them with Tableau.
  • Enhanced patient care quality by identifying trends and patterns in healthcare data.
  • Upheld HIPAA regulations and standards for protecting patient information.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.

Report Developer

Conservice
06.2020 - 12.2021
  • Create 30 visualizations and reports using SQL Server Reporting Services (SSRS)
  • Created, tested, and deployed visually appealing reports by gathering data using SQL queries and Stored Procedures
  • Optimizing current live reports through careful and intensive study
  • Created and modified complex stored procedures to extract data from SQL DB’s
  • Reviewing and quality checking reports generated by other team members
  • Reverse engineered C# code to extract SQL queries
  • Collaborated with cross-functional teams to gather requirements for custom reports, ensuring accurate and timely delivery.
  • Evaluated effectiveness of current reporting tools, recommending upgrades or replacements as needed to enhance team capabilities.
  • Implemented automated report generation processes for routine tasks, freeing up resources for more complex projects.
  • Increased user satisfaction by providing prompt responses to ad hoc report requests, addressing specific needs in timely manner.
  • Developed a library of reusable SQL queries, expediting the creation of future reports and minimizing redundancy.
  • Cut costs by 10% through development of effective tracking and saving programs.

Graduate Research Fellow

The Center, USU
01.2020 - 12.2020
  • Researched various topics related to economic policy, compiling resources, analyzing scholarly articles, and summarizing findings
  • Met regularly with peers, professors, and business professionals to discuss and gain insight on potential research topics
  • Documented and presented information in professional and concise manner in poster sessions
  • Performed fact and citation checks on peer’s work prior to publication

Teaching Assistant

Utah State University
09.2019 - 12.2019
  • Created visualizations using tableau and Power Bi
  • Worked on academic projects using python, SQL, Jupyter notebook
  • Assist instructor and help students in Business Intelligence course (class of 26)
  • Prepare notes and provide Disability Resource Center for students’ reference

Data Analyst Remote

Seattle Genetics
08.2018 - 08.2019
  • Created visualizations for various compounds and studies in Phase I-III using tableau
  • Visualizations to monitor various safety and efficacy parameters were created to facilitate clinical team in making better decisions
  • Created 20 visualizations containing dashboards and summaries of safety and efficacy data
  • Safety includes Baseline characteristics, Adverse events, Laboratory results
  • Efficacy includes Progression free Survival, Best objective response rates
  • Visualizations were able to track the study enrollment rates and clinical study progress rates
  • Created, tested, and deployed visually appealing reports by gathering data using SQL queries for Clinical data management department
  • Created and modified complex stored procedures to extract data from SQL DB’s
  • Reviewing and quality checking reports generated by other team members.

Data Analyst

Gap Inc
03.2018 - 07.2018

Designed and built 20 reports, information dashboards, data generators, and other end user information portals or resources

  • Advised business groups by providing technical and strategic reports that identify and address business issues and opportunities
  • Integrated data from multiple sources to produce requested or required data elements based on business requests and needs
  • Familiar building and using visualization and dashboard tools such as Tableau and Power BI
  • Utilized data visualization tools to effectively communicate business insights.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Used statistical methods to analyze data and generate useful business reports.
  • Optimized company resources allocation with detailed forecasting models based on historical data analysis.

Education

Master of Data Analytics - MIS specialization

Utah State University | Jon M. Huntsman School of Business
Logan, UT
12.2020

Skills

  • Languages:
  • SQL, Python, R
  • Database Management System: Microsoft SQL Server
  • Tools: SSRS, SSIS, Tableau, Power BI, Cognos, GitHub, SAS studio, R Studio, SAS, SAS enterprise miner
  • Data Analysis
  • Data Visualization and Presentations
  • Excel Functions
  • Data Cleaning, Data Modeling
  • Statistical Analysis
  • Attention to Detail
  • ETL processes
  • Report Writing
  • Software Development Life Cycle (SDLC)

Timeline

Data Analyst

Valley behavioral Health
01.2022 - Current

Report Developer

Conservice
06.2020 - 12.2021

Graduate Research Fellow

The Center, USU
01.2020 - 12.2020

Teaching Assistant

Utah State University
09.2019 - 12.2019

Data Analyst Remote

Seattle Genetics
08.2018 - 08.2019

Data Analyst

Gap Inc
03.2018 - 07.2018

Master of Data Analytics - MIS specialization

Utah State University | Jon M. Huntsman School of Business
Varsha Reddy Mandadi