Harshitha Olla
+1-309-***-**** **** North Underhill street, Peoria, IL, 61606 *************@*****.*** https://www.linkedin.com/in/harshitha-olla/
PROFESSIONAL SUMMARY
Data Analyst with 2+ years in Python scripting,SQL and advanced expertise in developing analytics dashboards in Looker and Power BI. Skilled in building ETL workflows, automating reporting processes, and delivering actionable insights from diverse data sources. Experienced in addressing stakeholder data requests, optimizing queries for performance, and enabling data-driven decision-making. Strong interest and growing experience in Generative AI and LLM applications to develop AI-powered analytics products.
PROFESSIONAL EXPERIENCE
Verizon -Business Analyst Jan 2024 - May 2025
Designed and launched 10+ Tableau and Power BI dashboards to visualize KPIs, reducing executive decision-making time by 35%
Resolved post-release issues by leading root cause analysis and drafting test plans, decreasing incident rates by 30%
Embedded risk mitigation protocols into SDLC, resulting in 100% compliance and a 22% drop in rework
Streamlined cost accounting workflows using SQL and Excel, improving accuracy by 25% across reporting cycles
Engineered automated claims dashboards, accelerating processing by 40% and lifting customer satisfaction by 18%
Directed Agile-based change management efforts, reducing backlog volume by 28% in Q1 202
Composed internal documentation and knowledge guides that elevated platform adoption by 50% within six weeks
Apollo Hospitals -Data Analyst May 2021 - Apr 2023
Evaluated 1M+ patient records to identify patterns, reducing claim denial rates by 30%
Devised and implemented 12 predictive models in Python to anticipate billing errors and enhance compliance metrics
Systematized 10+ manual reporting workflows, trimming report cycle time by 45%
Partnered with cross-functional teams to craft Power BI dashboards for executive and operational use
Maintained SQL-based ETL pipelines across branches, boosting data consolidation efficiency by 35%
Investigated 100+ billing discrepancies, driving a 20% increase in recovery outcomes
Minimized IT service requests by 28% through process automation and diagnostic tools
Authored audit-ready documentation for risk and compliance procedures across multiple departments
Produced real-time SQL visualizations to enhance billing visibility, increasing transparency by 33%
Educated 30+ team members on BI tools and data processes, improving data utilization and literacy by 40%
Apollo Hospitals -Data Analyst Intern May 2020 - Aug 2020
Audited 500K+ patient records to detect billing errors, reducing inefficiencies by 18%
Contributed to development of a centralized data warehouse, improving access for 3 departments
Assembled SQL dashboards to track patient treatment trends, decreasing report creation time by 40%
Collaborated with compliance teams to detect anomalies, leading to a 12% reduction in risk flags
Applied Excel techniques (VLOOKUP, PivotTables) to uncover root causes in 22% of late claims
Presented KPIs and insights to stakeholders, helping initiate 3 improvement projects
Drafted SOPs for risk reporting and claims processes, supporting onboarding and audit readiness
TECHNICAL SKILLS
Languages & Tools: SQL, Python, R, PHP, Excel
Data Analysis & Visualization: SQL, Python, R, Tableau, Power BI, Microsoft Excel (Advanced), Word, PowerPoint
Database Management & Warehousing: MS SQL Server, Azure SQL Database, MySQL, MS Access, Snowflake, SQL
Cloud & Infrastructure: Azure, AWS(S3, EC2), Docker
Frameworks & Platforms: Agile, SDLC, Jira, ERP, CRM
Predictive Modeling: Linear Regression, Logistic Regression, Random Forest, Decision Trees, Clustering, XGBoost, Neural Networks
Professional Strengths: Analytical Thinking, Stakeholder Communication, Technical Documentation, Time Management
EDUCATION
Master’s in Computer Science -Bradley University, USA Aug 2023 - May 2025
Relevant Coursework: Data Visualization, Agile, Software Engineering, Machine Learning, Project Management, Artificial Intelligence
CGPA - 3.75
Bachelor’s in Electronics and Communication Engineering -JNTUK,India Aug 2019 - Aug 2023
CGPA – 3.6