Data Analyst Business Intelligence

RITHIKA GURRAM

+1-680-***-**** • *******.********@*****.*** • linkedin.com/in/gurram-rithika/

SUMMARY

Insight-driven Data Analyst with a passion for building intelligent data systems that scale. Skilled at bridging the gap between raw data and strategic decisions through cloud-native pipelines, intuitive dashboards, and automation across Azure, AWS, and modern BI tools. SKILLS & CERTIFICATIONS

Programming Languages: Python, PySpark, R, DAX, M Query, VBA Macros Databases: MySQL, SQL, NoSQL, MongoDB, PostgreSQL, Snowflake, Data Lake, Azure Data Factory, Databricks Cloud Platforms: Microsoft Azure, AWS Cloud, GCP Cloud, Snowflake, Google BigQuery, Docker, Kubernetes, DevOps Libraries: Pandas, Scikit-learn, NumPy, Matplotlib, SciPy, Seaborn, XGBoost Business Intelligence Tools & Data Visualization: Microsoft Power BI, Tableau, Tableau Prep, SSRS, Looker, Qlik, Matplotlib, Seaborn Other Tools: MS Excel, MS Word, MS Power Point, SAP, BluePrism, Git, SAP HANA, Jira Soft skills: attention to detail, communication skills, problem-solving, process improvement, growth mindset Certifications : OCI AI Foundations Associate(2024), Snowflake - Hands On Essentials, Microsoft Office Specialist: Excel Associate(Office 2019) EXPERIENCE

Research Data Analyst, Syracuse University, New York May 2024 – May 2025

Designed and deployed a serverless data pipeline using AWS Step Functions, orchestrating Glue Crawlers and Athena to automate ingestion and querying of 1.5MB+ patient facility data from S3, reducing manual data refresh time by 90%.

Engineered an ETL workflow to catalog hospital performance metrics using AWS Glue and queried structured insights

(e.g., hospital ratings, emergency services, safety indicators) with Athena, enabling fast access to KPIs via SQL.

Developed interactive dashboards in Amazon QuickSight to visualize top-rated hospitals and state-level safety comparisons, improving stakeholder reporting turnaround by 80%. Data Analyst, Cognizant Technology Solutions, Hyderabad, India. Jan 2022 - July 2023

Designed and optimized large-scale data pipelines using Apache Airflow, dbt, and SQL, reducing batch processing time by 50% and improving end-to-end workflow efficiency.

Transitioned ETL architecture from Informatica to Talend, cutting licensing costs and improving modularity while ensuring seamless migration with minimal downtime.

Built distributed data workflows using Hadoop, MapReduce, Delta Lake, and Cassandra, enhancing real-time analytics by significantly reducing query latency across high-volume datasets.

Automated AWS infrastructure provisioning using Terraform to deploy and manage S3, EMR, EC2, and RDS instances, boosting deployment scalability and lowering cloud operational costs.

Developed Mulesoft API integrations for financial data ingestion with automated validation logic, which reduced billing discrepancies by 30% and powered real-time revenue dashboards via Power BI for monetization stakeholders. Data Analyst, PYBOTs LLC, Gujarat, India Jan 2021 - Jan 2022

Built and maintained robust ETL pipelines using Python and SQL to process clinical and environmental datasets, reducing data retrieval time by 40% and improving data consistency through anomaly detection techniques.

Translated stakeholder data requirements into actionable engineering plans, leading to the development of a Snowflake-based data warehouse and PostgreSQL backend that enabled cross-country ecological analysis.

Designed real-time dashboards using Tableau and Dash (Plotly), providing decision-makers with actionable insights into KPIs and enhancing visibility across clinical and environmental domains. PROJECTS

Customer & Revenue Insights Platform – FudgeFlix Feb 2025 - Apr 2025

Built a scalable ELT pipeline using Azure, Snowflake, and DBT to ingest and orchestrate streaming data across six business domains, enabling analytics for billing, subscriptions, and user engagement.

Engineered star schema models with fact and dimension tables, reducing redundancy and improving query efficiency; boosted DBT model performance by 30% using incremental loading and lineage tracking for transparent content and customer analytics.

New York State Open Budget & Actuals Feb 2024 – Apr 2024

Designed and developed a Tableau dashboard analyzing New York State’s budget data from 1994 to 2024, visualizing spending trends across $804.1 billion in actual expenditures and $1.09 trillion in CPI-adjusted values, enabling stakeholders to plan effectively.

Implemented advanced visualizations, including treemaps and stacked area charts, to analyze key budget categories such as Health

(29.52%, $18.59B in 1996) and Education (20.14%, $12.69B in 1996), uncovering spending patterns across 30 years of data.

Enhanced user interactivity with filters for year-over-year comparisons and top -N breakdowns (e.g., top 5, 10, 50 agencies), enabling focused analysis of key contributors like the Department of Health and Education, which accounted for over $1.47 trillion and $861.8 billion, respectively.

E-commerce Data Analytics Oct 2024 – Dec 2024

Optimized data pipelines and analytics by processing 100K+ e-commerce records using SQL and Python (Pandas, NumPy), reducing data cleaning time by 30% and improving query performance for large-scale datasets.

Developed interactive Power BI dashboards to visualize customer behavior and sales trends, improving sales forecasting accuracy by 15% and enhancing customer segmentation insights by 20% through statistical modeling. EDUCATION

Syracuse University, New York, USA, Master of Science, Applied Data Science Aug 2023 - May 2025 Relevant Coursework: Applied Machine Learning Quantitative Reasoning for Data Science Database Management System Business Analytics Introduction to Data Science Human-Computer AI Apps Cloud Management Data Visualization IIIT Dharwad, Karnataka, India, Bachelor of Technology, Computer Science Engineering. Aug 2018 – May 2022 Relevant Coursework: Data Structures and Algorithms Operating System Object Oriented Programing

Contact this candidate