Charan Kumar Rayaprolu

•Developed automated data integration processes between client systems and Medicare/Medicaid databases, improving data transfer turnaround times by 25% and reducing manual intervention. •Standardized validation protocols and dataset onboarding documentation, which led to a 40% reduction in new dataset integration times. •Identified and eliminated repetitive manual steps in the data pipeline, saving over 10 working hours weekly and allowing for redeployment of analyst time to higher-value activities. •Built real-time KPI dashboards in Power BI and Excel for lien resolution tracking, increasing operational transparency and enabling faster decision-making for cross-functional stakeholders. •Delivered weekly performance reports using data quality metrics, project KPIs, and health indicators that supported senior management decision-making. •Conducted workshops with stakeholders to refine report requirements, enhancing reporting accuracy and reducing the average rework cycle by 60%. •Collaborated with legal and product development teams to resolve cross-platform inconsistencies, improving data.

•Consolidated and cleaned data from 5+ disconnected systems, enhancing data consistency and increasing reporting accuracy by 35%. •Led enforcement of new data governance protocols, driving a 98% accuracy rate in monthly operations reporting. •Partnered with marketing and operations teams to optimize ETL pipelines, improving daily report generation timelines by 25%. •Tuned complex Snowflake SQL queries, improving performance and reducing dashboard load times by 50%. •Built executive-facing Power BI dashboards, reducing reporting preparation time by 40% and increasing visibility into key operational KPIs. •Presented insights from multivariable analysis to executives, influencing strategy decisions and QBR outcomes. •Applied statistical modeling to customer satisfaction data, identifying key drivers that contributed to a 15% boost in satisfaction scores. •Built predictive models in Python for anomaly detection, boosting fraud detection rates by 18%.

• Designed and implemented SQL stored procedures to efficiently manage and process large volumes of data. • Managed data migration from on-premises systems. • Created interactive Power BI dashboards to track key business performance metrics and enhance decision-making.

Dean’s excellence scholar Coursework :- Database foundations for business analytics System analysis and project management Marketing management Operations management Big data Adv stats Business analytics with r Crm with Salesforce American health care Digital consulting project Cloud computing

Scholar with high distinction Programming with C Object oriented programming with C++ Web technology Database management systems E-commerce applications