Harika Surada

Harika is a Consultant at Sand Cherry Associates, with 4 years of data analysis, business analysis and business intelligence analysis experience spanning the wireless, telecom, broadband, manufacturing and education verticals. Harika is an integral part of our firm's ongoing success in the design and delivery of strategic customer-centric initiatives through digitally-native, data-empowered solutions.

Harika has applied her skills and knowledge in data analytics, data integration, data architecture, and data visualization to support various business functions and objectives. She has worked with cross-functional teams to gather requirements, design solutions, develop dashboards, and provide insights that enable data-driven decision-making. Their more recent work has centered on data workflows, SQL, and Tableau-empowered cross-functional teams and led to substantial cost savings and process efficiencies. She's known for her capacity to generate impactful data-derived insights, streamline processes effectively, and translate analytical and technical expertise into insightful business results.

Prior to Sand Cherry Associates, Harika was the Data Analyst II of Retail Wireless - Margin Assurance at DISH Wireless, where they were responsible for delivering tangible business outcomes through her analytical and technical expertise.

• Data Products: Developed Tableau dashboards and automated reports for subscriber activations, deactivations, and monthly recurring charges, reducing Fraud Cases rate by 5%. Replicated Domo dashboards to Tableau and added new KPIs, enhancing revenue analysis for the TSP Billing System; resulting in a 10% cost savings by transitioning from the vendor’s dashboards.
• Data Workflows: Engineered robust data workflows on Redshift, PostgreSQL, and Snowflake databases, automating fraud prevention processes and saving 20+ hours per week, resulting in a 30% reduction in fraudulent activities. Spearheaded the creation of a comprehensive self-service dashboard, leveraging Tableau and SQL, to monitor critical customer profitability metrics such as ARPU, recurring revenue rate, and churn rate; empowered cross-functional teams to optimize revenue streams and achieve a 20% increase in overall profitability.
• Presenting Insights: Orchestrated end-to-end process mapping initiative, identifying key stakeholders, and creating comprehensive process flowcharts, documentation, and SOPs resulting in 30% reduction in turnaround time and increased team efficiency by 25%. Presented department’s project communications and updates to the leadership, weekly.
• Identifying Success Metrics: Worked closely with stakeholders and identified success metrics to predict student program success. The key success metrics such as graduation rates increased by 15%. Improved student GPA by 23% by building Assignment Completion Rates, Performance in Key subjects and GPA Trend Analysis.
• Root Cause Analysis: Performed root cause analysis to identify issues causing student attrition, ultimately increasing student retention rate by 25%. Analyzed customer behavior by pulling data from MYSQL, to increase gross revenue by 115%.
• Stakeholder Management: Actively engaged with stakeholders to understand specific business needs and translated these requirements into actionable solutions and well-defined project specifications. Developed business cases that highlighted tangible benefits and ROI of proposed initiatives.
• Revenue Impact: Created revenue models and reports in Tableau that contributed to almost $200k in revenue. Improved chargeback cost by 5% through forecasting models built on Tableau. Analyzed customer behavior by pulling data from MYSQL, to increase gross revenue by 115%.

• PL-300 certification: Microsoft Power BI Data Analyst/ DA-100
• Investment Housing Property Value Prediction, using Pyspark, ML
• Database System for a Local Day Spa using DBMS, SQL
• MS, Data Analytics & Information Systems, Texas State University

• Won First place in Datathon conducted by USAA 
• Awarded for Academic Excellence by Beta Gamma Sigma society at McCoy College of Business