Shivananda Reddy Medida
Shivananda Reddy Medida
Hi, I'm Shivananda!
A
-
Desinger
-
Developer
- Desinger
- Developer
An Innovative Data Analyst with over 4 years of experience turning healthcare and business data into measurable results
Hi, myself Shivananda Reddy Medida
Data Analyst | Healthcare and Business Analytics
I am a Data Analyst with over 4 years of experience turning healthcare, claims, and business data into insights that drive better decisions. I hold a Master of Engineering Degree in Computer and Information Sciences from the University of Cincinnati.
Currently I work At Cigna Healthcare, Where I analyze Medicare and Medicaid claims using SQL, Python, Snowflake, and Power BI. My reconciliation work has reduced reporting discrepancies by 18% and helped prevent approximately $240K in annualized reporting adjustments. Before that, at Mphasis, I delivered retail and financial analytics that identified approximately $215K in annual savings.
I care about accurate data, clear dashboards, and insights that teams can act on. I am open to Data Analyst opportunities where I can help organizations make confident, data-driven decisions.
YEARS OF EXPERIENCE
0
+
PROJECTS COMPLETED
0
+
TECHNOLOGIES USED
0
+
- EXPERIENCE
Everything about me!
-MAY 2024-PRESENT
Data Analyst
-Cigna Healthcare
– Analyze Medicare and Medicaid claims and EHR data in Snowflake using SQL, CTEs, and window functions to identify anomalies and provider utilization trends.
– Reconcile EHR and claims datasets with validation checks, reducing reporting discrepancies by 18% and improving data retrieval efficiency by 27% for recurring analytics.
– Build Power BI dashboards that track claims, utilization, and HEDIS and CMS quality measures, improving reporting visibility by 12% for stakeholders.
– Perform root cause analysis on recurring claims exceptions and resolve ICD-10 and CPT/HCPCS coding inconsistencies, preventing approximately $240K in annualized reporting adjustments.
-MAR 2021-JUL 2023
Data Analyst
-Mphasis
– Analyzed retail sales, expense, and inventory data using SQL and Excel to identify revenue and cost variances and investigate underperforming product segments.
– Integrated and reconciled data from multiple retail sources with validation controls, reducing financial reporting exceptions by 16% and month-end adjustments by 14%.
– Used Python and Pandas to clean and validate data, accelerating financial reporting by 22%, and created Tableau visualizations for revenue, margin, and sales trends.
– Examined transaction trends and profitability drivers, identifying opportunities that saved approximately $215K annually, and presented the findings to management.
- SkILLs
SQL
90%
Power BI
90%
Excel
85%
Tableau
85%
Python (Pandas)
80%
Data Validation and Reconciliation
90%
Healthcare and Claims Analytics
85%
Snowflake
75%
Angular
87%
JavaScript
85%
React
70%
Bootstrap
92%
Html
99%
CSS
96%
Tailwind CSS
90%
Spring Boot
93%
MySQL
84%
MongoDB
83%
Git
92%
Azure
82%
Java
92%
C++
85%
Node.js
85%
- SERVICES
My Services
medidashivanandareddy@gmail.com
01
Data Analysis and Insights
- Healthcare and claims analytics using Medicare, Medicaid, EHR, ICD-10, CPT/HCPCS, HEDIS, and CMS quality measures
- Financial and retail analytics, including variance, trend, and profitability analysis
- Root cause analysis to identify the source of recurring data issues and prevent them
02
Dashboards and Reporting
- Building reports and dashboards that give stakeholders clear visibility into performance.
- Interactive Power BI and Tableau dashboards for KPI tracking and performance reporting
- Report automation with Excel and Python to reduce manual effort and speed up delivery
- Requirements gathering and data storytelling to present insights clearly to stakeholders
03
Data Preparation and Quality
- Making sure data is accurate, consistent, and ready for analysis.
- SQL data extraction and transformation using CTEs and window functions on platforms such as Snowflake
- Data validation and reconciliation across multiple sources to find and resolve discrepancies
- Data cleaning to improve data accuracy and integrity
04
Enterprise Java & Backend Systems
- Java 11–17, Spring Boot, REST & GraphQL APIs
- Event-driven architectures using Kafka & RabbitMQ
- Scalable microservices for high-traffic enterprise platforms
05
Full-Stack Development
- Frontend interfaces Using React.js,Angular, JavaScript, Vue.js, HTML, CSS, Bootstrap, Tailwind CSS.
- RESTful & GraphQL API integration.
- Git & GitHub for collaborative development.
- Backend-to-UI integration.
06
Database & Cloud
- Performance tuning with PostgreSQL, DynamoDB, and Redis.
- Cloud-native systems on AWS,Azure using Docker, Kubernetes, Terraform
- Secure, automated CI/CD using OAuth2, JWT, and zero-downtime releases.
- PROJECTS
Recent Completed Works
Amazon Clone
A web-based e-commerce platform that allows users to browse products, add them to a cart, and complete purchases.
AI Chatbot
An interactive assistant that provides instant responses using AI models.
Spark SQL Evolution and Performance analysis
Highlighting its advanced query optimization through the Catalyst Optimizer.
Phishing Website Detection
Detecting the phishing websites by analyzing URL structures, security protocols, and domain identity.
Stock Price Evolution
To analyze market trends, Compares various classification algorithms for best accuracy and performance.
Face Mask Recognizer
Identify individuals and determine mask compliance. Analyzes captured images to detect faces and classify mask usage in real-time.
- CERTIFICATIONS
My Achievements
- LET'S CONNECT
Get in touch
I’m eager to join a visionary team where I can craft seamless digital experiences as a Front-end/Full Stack Developer/Data Analysis/Data Engineering Roles.