Shruti Ravindran
Data Science
Summary
Experienced data analytics professional with over six years of expertise in database management, statistical analysis, and data mining/storytelling. Skilled in Tableau, SQL, R, and Python to deliver accurate and consistent data sets and reports. Proficient in data mining, visualizations, statistical analysis, and predictive modeling to drive successful outcomes for various projects and stakeholders. Team-oriented and creative approach to problem-solving.
Overview
12
12
years of professional experience
6
6
years of post-secondary education
2
2
Certifications
Work History
Data Integrity Analyst
Wayne State University
10.2022 - 03.2025
- Created reusable SQL queries to port daily Alumni and Contribution data into R and My SQL server database resulting in improved production database performance over 12%
- Explored the historical and current student data and performed data manipulation using Power BI, SQL and R for various analytical projects that helped in generating crucial data points that led to successful networking fundraising events. The findings from my several projects enhanced and strengthened alumni engagement and donor relationships.
- Developed reusable and diverse R codes for reporting and data filtering/analyzing projects that generated quality data driven decisions, enhanced data quality and data safeguarding, reduced error handling and 10 hours manual querying and reporting work per week.
- Developed dashboards in Power BI using SQL which improved the integrity of the Wayne State Alumni data. My dashboard displayed all the remaining alumni data in real time that needed any specific updates or corrections. This was helpful for my colleagues and my supervisors to effectively complete their weekly data cleansing tasks and to visualize the data for generating accurate reports.
- Did several diverse successful projects that provided quality insights on the improvement of donor revenues based on crucial data points. My fundraising dashboard-based contributions and ethnicities using SQL, R and Tableau helped run a successful university campaign that helped fill the communication gap and built relationships among the marginalized communities effectively in 2023.
- Built an algorithm using Python and Machine learning for a crucial high priority project that successfully identified potential donors from marginalized groups of people that are most likely to donate to various Wayne State Foundations and causes.
- Worked with google big query on several independent projects that analyzed, filtered and cleansed alumni contact data and generated reports/ csv files for quick release projects with specific and accurate data points, indicators and fields.
Test Data Analyst
Blue Cross Blue Shield
08.2013 - 04.2019
- Processed diverse patient claims (DCNs) for satisfying Medicare insurance scenarios using SQL queries, mapped the data and built tables/reports using big patient and provider data with appropriate ICD-10 diagnosis codes to generated over 1000 meaningful production claims.
- Created accurate and successful test scripts to manage automated testing of certain products and features using Selenium and Java.
- Identified, mapped, and tracked defects with HP ALM [Blue-Chip] and supported developers in resolving problems with additional tests.
- Trained offshore automation teams on all BCBS insurance specific domains under the regression department. Played a key role in automating high level patient insurance claims by generating Python scripts in Excel.
Education
Master of Science - Data Analytics
University of Maryland
College Park, MD 08.2019 - 08.2021
Bachelor of Science - Major in Neuroscience
University of Texas At Dallas
Dallas, TX 09.2009 - 04.2013
Skills
- SQL
- R
- Excel Programming
- Python
- Google Big Query
- Data Visualization
- Data Validation
- Linear regression
- Logistic regression
- Sentiment analysis
- Natural language processing (NLP)
Phone
cell, (469)888-9431
Certification
Databricks Accredited Generative AI fundamentals
Timeline
Databricks Accredited Generative AI fundamentals
09-2024
Data Integrity Analyst
Wayne State University
10.2022 - 03.2025
Google Data Analytics Certificate (Coursera)
04-2022
Master of Science - Data Analytics
University of Maryland
08.2019 - 08.2021
Test Data Analyst
Blue Cross Blue Shield
08.2013 - 04.2019
Bachelor of Science - Major in Neuroscience
University of Texas At Dallas
09.2009 - 04.2013
Similar Profiles
SUE BROWN CLARKSUE BROWN CLARK
Business System Analyst II at Wayne State University – Fiscal Operation/Technical Support Services /University Information SystemsBusiness System Analyst II at Wayne State University – Fiscal Operation/Technical Support Services /University Information Systems
Steven S. BeaulieuSteven S. Beaulieu
Adjunct Instructor at Wayne State University; Oakland Community CollegeAdjunct Instructor at Wayne State University; Oakland Community College
Courtney Doty, MS, PA-CCourtney Doty, MS, PA-C
Professor of Physician Assistant Studies at Wayne State UniversityProfessor of Physician Assistant Studies at Wayne State University
Julie FoxJulie Fox
Data Integrity Analyst at Odyssey ISData Integrity Analyst at Odyssey IS
Stephanie WilliamsStephanie Williams
Data Integrity Analyst at Parkview HealthData Integrity Analyst at Parkview Health