Shivani Peddi
Business Data Analyst @UHS
Signup · Get unlimited contacts
WORK HISTORY
Business Data Analyst @UHS
US
Automated ETL pipelines using Apache Airflow and Python to aggregate data from claims, CRM, and patient databases, improving data integrity by 30%.• Engineered Tableau dashboards to track patient outcomes and financial KPIs, decreasing manual report preparation time by 40%.• Developed reports and dashboards leveraging CRM data to track customer engagement, lead conversion, and retention rates.• Built data pipelines with ADF, pulling data from SQL Server, Azure Data Lake, REST APIs, and Blob Storage.• Integrated Informatica with cloud platforms for seamless data movement to and from Redshift, Snowflake, BigQuery, Azure Synapse, and Data Lakes.• Extracted, transformed, and loaded (ETL) CPG data from sources such as SAP, Oracle Retail, Nielsen, and IRI into a data warehouse (Snowflake, BigQuery, Redshift).• Developed and maintained interactive reports using SAP BusinessObjects, enabling executive stakeholders to monitor performance metrics and reduce reporting turnaround time by 30%.• Designed custom DAX logic to handle conditional formatting, ranking, and cohort analysis within Power BI reports for enhanced data storytelling.• Integrated Salesforce with Snowflake using Fivetran, Stitch, or custom ETL pipelines for centralized data analysis.• Built customer segmentation models using K-Means clustering & RFM analysis to enhance targeted marketing campaigns.• Built interactive dashboards using R Shiny to provide stakeholders with real-time insights into business trends.• Conducted statistical analysis and hypothesis testing in SPSS to extract meaningful insights from large datasets.• Connected Power BI reports to diverse data sources, including Excel, SQL Server, REST APIs, and cloud platforms such as Azure and AWS.• Developed a comprehensive Power BI dashboard for policy renewal tracking, increasing renewals by 7%.• Executed A/B tests on patient communications using Google Optimize, boosting engagement rates by 12%.
EDUCATION
Mahatma Gandhi Institute of Technology
Bachelor
Southeast Missouri State University
Master's degree
Vedic Vidyalayam High School
SSC
ABOUT SHIVANI PEDDI
Business Data Analyst with 5 years of experience in leveraging data-driven insights to enhance business decisions across healthcare, technology, and consumer goods industries. • Expertise in data collection, cleansing, and transformation, combined with a track record of developing predictive models, performing advanced statistical analysis, and creating intuitive dashboards to communicate actionable insights. • Integrated Gen AI models to automate trend analysis, sentiment analysis, and anomaly detection for advanced data insights. • Proficient in conducting trend analysis, predictive modeling (regression, Random Forest, SVM, KNN, k-Means clustering), time series forecasting, and anomaly detection. • Expertise in designing scalable ETL pipelines and data workflows using tools such as Apache Airflow, AWS Glue, and Talend. Experience with Snowflake, Redshift, Hadoop, Databricks, and Kafka for big data processing. • Advanced proficiency in Tableau, Power BI, Google Data Studio, and QuickSight to create interactive dashboards and financial reports that drive business decisions. • Strong expertise in MySQL, PostgreSQL, Redshift, Amazon RDS, MongoDB, and Google BigQuery for large-scale data operations. • Knowledge with Git, GitHub, PyCharm, Jupyter Notebook, and IntelliJ IDEA for collaborative development. • Well-versed in Agile and Waterfall methodologies for project management and sprint planning.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.