Highly analytical and results-driven Data Analyst with a Master's in Computer Science, experienced in transforming complex datasets into actionable insights that drive strategic decisions. Proven ability to develop robust ETL pipelines, create dynamic visualizations, and apply machine learning models to optimize performance, enhance efficiency, and support data-driven policy recommendations across diverse sectors.
Senior Consultant - Data Analyst (Volunteer)
Remote, N/A, US
→
Summary
As a Senior Consultant, Shivani led data analysis and ETL development for a community network, providing critical insights to inform policy recommendations and streamline data processes for improved outreach.
Highlights
Analyzed large, multi-county datasets from diverse food access sources to identify trends, gaps, and anomalies, directly supporting data-driven policy recommendations for Indiana communities.
Developed automated Python ETL workflows to clean, validate, and integrate multi-source data into BigQuery, reducing processing time by 40% while ensuring data accuracy and compliance with unified schema standards.
Created impactful Tableau visualizations from BigQuery datasets, delivering clear and actionable insights to cross-functional teams and stakeholders, enabling faster decision-making for outreach programs.
Data Analyst Intern
India, N/A, India
→
Summary
As a Data Analyst Intern, Shivani analyzed marketing and campaign performance, developed BI dashboards, and built data pipelines to support strategic budget allocation and optimize campaign effectiveness.
Highlights
Analyzed marketing and campaign performance data across multiple channels to detect anomalies and identify optimization opportunities, supporting department reporting requests for enhanced campaign effectiveness.
Developed Power BI dashboards and executive reports, presenting conversion metrics, CSAT scores, and revenue forecasts to business leaders, enabling strategic budget allocation decisions.
Built automated SQL and Python data pipelines to extract, transform, and load multi-source marketing data, reducing manual reporting by 20% and improving data reliability for analytics.
Supported cross-functional teams in designing and analyzing A/B tests, applying statistical methods to identify high-impact trends and communicate findings.
Communicated complex analytical insights to both technical and non-technical stakeholders through presentations, translating predictive model outputs into clear, actionable marketing recommendations.
Programmer Analyst - Data Analyst
India, N/A, India
→
Summary
As a Programmer Analyst and Data Analyst, Shivani developed ETL pipelines, supported platform upgrades, and delivered analytical reports, significantly enhancing client satisfaction and operational efficiency.
Highlights
Developed ETL pipelines using Transform Maps to migrate and standardize complex datasets, ensuring end-to-end data integrity and accuracy across production environments.
Assisted during platform (Paris to Rome version) upgrade cycle across Dev, Test, and Prod by executing comprehensive testing, participating in code reviews, identifying and resolving 30+ critical issues to achieve 100% successful deployment.
Prepared weekly analytical reports and presentations summarizing incident trends, data anomalies, and workflow insights delivered in clear, accessible formats for technical and non-technical teams.
Developed and implemented data-driven troubleshooting and onboarding guides for 150+ clients, resulting in a 30% reduction in support ticket volume and improved client satisfaction.
→
Master of Science
Computer Science
Grade: 3.75/4
→
Bachelor of Engineering
Computer Engineering
Grade: 3.45/4
Published by
International Journal of Science and Research (IJSR)
Summary
Co-authored a research paper titled 'Human Computer Interface for Physically Impaired', published in the International Journal of Science and Research, Volume 10 Issue 6, pp. 1017-1020.
Tableau, Power BI, Looker, Excel, A/B Testing, BigQuery, Hive.
Python, R programming, PySpark, C++, HTML/CSS, Git/GitHub, SQL.
MongoDB, Snowflake, BigQuery, Hive.
Airflow, dbt, ETL Pipelines.
AWS Certified Cloud Practitioner, ServiceNow Certified System Administrator, ServiceNow Certified Application Developer, DataCamp - Google Cloud Platform (GCP), DataCamp - NoSQL, ServiceNow.
MS Office.
→
Summary
Developed a medical insurance cost prediction model (R2 = 0.89) using LightGBM, explained cost variance with SHAP values, and ensured fairness using Fairlearn.
→
Summary
Analyzed 3,000+ interaction records to uncover engagement patterns and performance drivers, built KPI dashboards, and developed a SARIMA model to forecast short-term activity trends.
→
Summary
Performed Recency, Frequency, and Monetary (RFM) analysis in Python to segment customers into groups (e.g., Champions, At-Risk) and visualized results with Plotly.