Dharani Pulipaka

About Dharani Pulipaka

As a Data Analyst at Allstate, my expertise in SQL and Tableau transforms complex datasets into clear, actionable insights. Our team\'s initiatives, leveraging my education in computer and information sciences from Rivier University, have notably reduced claim processing times, enhancing customer satisfaction.Collaboration with cross-functional teams underscores my approach, where interactive dashboards reflect real-time performance metrics. These efforts, rooted in my comprehensive education and bolstered by certifications in networking and cybersecurity from Cisco, drive operational improvements and strategic decision-making.

Experience

1. Data Analyst

   Allstate

   Sep 2024 — Present · US

   Analyzed large volumes of structured and unstructured data to enhance data-driven decision-making processes.• Designed interactive dashboards using Tableau and Power BI, streamlining reporting and reducing manual effort.• Developed and optimized SQL queries to improve data retrieval efficiency and support business intelligence reporting.• Automated ETL pipelines to reduce data processing time and ensure seamless integration across systems.• Conducted predictive modeling using Python (scikit-learn) and R, improving forecast accuracy and business planning.• Performed A/B testing on marketing campaigns to identify key drivers of customer engagement and improve outcomes.• Collaborated with cross-functional teams (finance, marketing, operations) to translate business needs into actionable analytical solutions.• Implemented data validation and quality checks to minimize inconsistencies and improve data reliability.• Presented data-driven insights to C-level executives, influencing strategic decisions and operational improvements.• Migrated data to AWS Redshift, optimizing cloud storage and enhancing query performance.• Ensured compliance with data governance policies, strengthening data security and regulatory adherence.• Reduced customer churn through segmentation analysis and predictive modeling, improving retention strategies.• Automated complex data blending workflows using Alteryx, integrating multiple data sources (CRM, ERP, Excel) to unify reporting and reduce manual preparation time.

Education

• Rivier University

  Master's degree

  2023 — 2024