Data Analyst A Team

Rohith reddy Appidi

Email: *******************@*****.***

Mobile: +1-937-***-****

Data Analyst

PROFESSIONAL SUMMARY:

Data Analyst with 5 years of experience demonstrating analytical thinking, attention to detail, and problem-solving skills, delivering data-driven solutions and communicating effectively with technical and non-technical audiences.

Proficient in connecting dots across applications to understand end-to-end views, utilizing strong PL/SQL skills to write and analyze complex queries and stored procedures, ensuring innovative thinking.

Developed data solutions using Oracle Exadata (10g and above) and Microsoft Office suite, working in Agile/Scrum teams for prioritization, resource assignments, and successful team collaboration.

Built ETL workflows to ingest and process multi-source datasets, enhancing data accuracy and reporting reliability, while functioning as a team player who can influence and guide others.

Designed dashboards for monitoring KPIs and business trends, empowering teams with real-time insights, while working well in a team environment with minimal supervision and willingness to ask questions.

Automated reporting, reducing manual effort and enabling stakeholders to track performance efficiently, demonstrating expertise in effort and financials estimation and good prioritization skills.

Proficient in SQL, Python, and R for querying and analyzing large datasets, supporting exploratory analytics and statistical reporting tasks, while managing multiple projects simultaneously.

Worked with structured and semi-structured data in PostgreSQL, MySQL, and BigQuery, enabling scalable analytical processing with strong data modeling practices and attention to detail.

Partnered with product managers and engineers in Agile environments to convert business needs into technical deliverables, iterating dashboards and datasets aligned with sprint goals and stakeholder priorities.

Built anomaly detection tools using Python and integrated them into dashboards, allowing users to detect and investigate data quality issues early, demonstrating problem-solving and analytical thinking.

Led root cause analysis on fluctuating KPIs and built drill-through capabilities in dashboards, empowering teams to act on data anomalies, metric shifts, and sudden behavioral patterns effectively.

Collaborated with engineering teams to implement SLAs and establish data lineage across reporting assets, ensuring traceability, reusability, and self-service analytics capabilities, communicating effectively.

Delivered executive summaries and dashboards to monitor financial, clinical, and risk metrics, using parameterized filters and trend lines to enable real-time monitoring and proactive business planning.

Currently pursuing a Master’s in Business Analytics with a focus on machine learning, forecasting, and statistical modeling to expand capabilities in advanced analytics and data-driven insights.

TECHNICAL SKILLS:

Data Analysis & Programming - SQL, Python, R, Pandas, NumPy, Jupyter, PL/SQL

Databases & Storage - PostgreSQL, MySQL, BigQuery, Snowflake, Oracle Exadata, Oracle 10g

Other Tools - Git, Excel, JIRA, Confluence, Agile/Scrum, Microsoft Office Suite

PROFESSIONAL EXPERIENCE:

CVS Health Feb 2024 – Present

Data Analyst

Responsibilities:

Demonstrated expertise in analytical thinking by building end-to-end analytical pipelines in GCP, modeling healthcare data in BigQuery to support real-time dashboards and executive reporting on key performance indicators.

Automated Looker and Data Studio reports, reducing manual reporting tasks by 75% and increasing visibility into operational performance, showcasing strong communication skills to pharmacy and strategy teams.

Collaborated with stakeholders to define business KPIs, operational metrics, and dashboard designs that supported pharmacy adherence initiatives, cost reduction, and clinical performance management, demonstrating attention to detail.

Conducted statistical analysis on claims data using Python and SQL, identifying high-risk patients, cost drivers, and care gaps that informed outreach campaigns and population health programs, showcasing problem-solving skills.

Created anomaly detection scripts in Python to monitor pipeline outputs, detect data quality issues, and trigger alerts integrated with dashboard interfaces for proactive QA resolution, demonstrating innovative thinking skills.

Designed and optimized star schema models in BigQuery for pharmacy and claims data, enabling faster queries and scalable analytics for reporting, forecasting, and operational visibility, using strong PL/SQL skills.

Delivered Looker dashboards with dynamic filters, alerting logic, and custom drill-downs, enabling field operations and regional managers to self-serve and act on critical adherence metrics, working well in a team environment.

Partnered with engineering to define transformation logic, SLAs, and metadata standards for analytics datasets, supporting lineage tracking, auditability, and downstream BI reporting accuracy, with minimal supervision.

Developed predictive models using BigQuery ML to forecast prescription fills, identify non-adherent patients, and recommend targeted interventions for clinical support teams, identifying priorities and managing multiple projects.

Built SQL templates to standardize metric calculations across teams, reducing duplication, improving data consistency, and enabling faster dashboard rollout across domains, demonstrating willingness to ask questions.

Huntington Bank Jun 2023 – Jan 2024

Data Analyst

Responsibilities:

Designed Tableau dashboards to track customer engagement, fraud signals, and loan KPIs, providing leadership with strategic visual insights into operational performance, customer trends, and compliance health, using innovative thinking.

Engineered BigQuery and Dataflow pipelines to automate ingestion, transformation, and cleansing of transaction and CRM data, ensuring accuracy and timeliness in marketing, finance, and risk reporting processes, showing attention to detail.

Built Looker dashboards for executives to monitor branch-level performance, delinquency trends, and financial metrics, integrating dynamic filters and drill-through logic for seamless performance monitoring and business planning, using strong PL/SQL skills.

Partnered with compliance teams to build AML monitoring scripts in Python and SQL, detecting suspicious patterns across transactional data and supporting audit readiness and regulatory adherence efforts, demonstrating problem-solving skills.

Delivered predictive models using BigQuery ML to flag high-risk accounts and early attrition indicators, enabling preemptive customer engagement and reducing portfolio-level retention risks, showing analytical thinking.

Collaborated with finance on Power BI dashboards showing departmental expense patterns, budget variances, and profitability metrics, helping leadership identify cost-saving opportunities and financial risk areas, using Microsoft Office suite.

Created semantic layers and governed metrics in dashboards, empowering analysts and business teams to self-serve critical KPIs while improving metric consistency and reducing dependency on manual reporting, working well in a team environment.

Implemented QA processes using SQL validation scripts and anomaly detection models to ensure regulatory reports and operational datasets met completeness, accuracy, and consistency standards, with minimal supervision.

Integrated survey feedback and support case data into sentiment analysis pipelines using Python, helping product managers identify service pain points and prioritize user experience improvements, demonstrating strong communication skills.

Participated in Agile/scrum teams for prioritization of work and resource assignments, iterating dashboards and metrics with sprint-based feedback loops to align deliverables with business value and strategic analytics objectives.

FedEx Jul 2020 – May 2023

Data Analyst

Responsibilities:

Designed Tableau dashboards visualizing logistics KPIs including on-time deliveries, delivery exceptions, and routing efficiency, helping operational managers make data-driven decisions to improve service and reduce delays, using analytical thinking.

Built scalable ETL pipelines using GCP BigQuery and Dataflow to ingest, clean, and transform multi-source logistics, tracking, and warehouse datasets supporting company-wide performance monitoring and reporting automation, showing attention to detail.

Created predictive models using BigQuery ML and Python to forecast delivery delays based on route congestion, weather disruptions, and package density, supporting proactive re-routing and operational risk reduction, using problem-solving skills.

Developed exception dashboards for tracking failed deliveries, missed scans, and SLA breaches, enabling warehouse and fleet managers to resolve errors quickly and improve service-level compliance across regions, using innovative thinking.

Integrated Salesforce service data with tracking logs to analyze case resolution time, escalation drivers, and issue trends, driving improvements in support processes and customer satisfaction response time, using Microsoft Office suite.

Automated daily delivery performance reports using Cloud Composer and SQL scripts, eliminating manual refresh delays and ensuring consistent visibility into distribution metrics for all field operations, using strong PL/SQL skills.

Wrote Python-based anomaly detection scripts to flag lost packages, failed scans, and abnormal shipping routes, which helped compliance teams identify risk patterns and improve operational integrity, working well in a team environment.

Optimized BigQuery SQL models and views to support faster dashboard response times, reducing query load on large datasets and improving data accessibility for business intelligence users, with minimal supervision.

Collaborated with warehouse engineers to analyze package flow data, scan frequency, and processing time, leading to layout redesigns and more efficient sorting operations in high-volume facilities, demonstrating strong communication skills.

Maintained comprehensive documentation for ETL jobs, KPI formulas, and dashboard metadata, supporting governance, knowledge sharing, and onboarding of analysts across transportation analytics teams, identifying priorities.

Certifications:

Tableau Desktop Specialist\ Certified Data Analyst

Microsoft Certified: Power BI Data Analyst Associate

Educational Details:

Master of Science in Business Analytics - Trine University

Bachelor of Technology in Mechanical Engineering - Jawaharlal Nehru Technological University, Hyderabad

Contact this candidate