Venkata Divya Bharathi Modapalli
Email ID: ****************@*****.*** Phone: 630-***-****
SUMMARY
Data Analyst with 5+ years of experience delivering BI solutions, predictive analytics, and compliance reporting across finance, telecom, and retail. Skilled in SQL, Python, and R for advanced modeling, with expertise in ETL pipelines (Airflow, dbt, ADF, Informatica) and cloud warehousing (Snowflake, Synapse, BigQuery). Adept at building interactive Power BI and Tableau dashboards, improving decision-making speed by up to 70%. Strong track record in churn prediction, compliance automation, and KPI design, driving measurable improvements in retention, risk management, and audit readiness. Collaborative professional thriving in Agile/Scrum environments, translating complex business needs into actionable analytics. SKILLS
• Programming & Querying: SQL, Python, R
• Databases & Warehousing: Snowflake, Azure Synapse, BigQuery
• ETL & Data Orchestration: dbt, Apache Airflow, Azure Data Factory, Informatica, SSIS
• Cloud Platforms: Microsoft Azure, AWS (S3, Glue, Lambda, Redshift)
• Databases: SQL Server, Oracle, MySQL, PostgreSQL, MongoDB, Cassandra
• Data Visualization & BI Tools: Power BI (DAX, Power Query, Data Modeling, Custom Visuals, Row-Level Security), Metabase
• Data Modeling & Architecture: Star/Snowflake Schema, Dimensional Modeling, Fact/Dimension Tables, Data Lakehouse Concepts
• Statistics & Analytics: A/B Testing, Hypothesis Testing, Regression Analysis, Forecasting, Predictive Modeling
• AI/ML: Data Preprocessing, Feature Engineering, Linear/Logistic Regression, Clustering (K-Means), Time Series Forecasting, Model Deployment
• Data Governance & Quality: Data Validation, Master Data Management, Lineage Tracking, Security & Access Controls, Compliance (GDPR, HIPAA)
• Collaboration & Workflow: Git/GitHub, Agile/Scrum, Jira, Confluence EXPERIENCE
Verizon Wireless Systems Sep 2022 – Current
Power BI Data Analyst
• Built and optimized ETL pipelines with SQL and Airflow, automating daily refreshes and saving 25+ hours monthly.
• Designed churn prediction models (logistic regression, survival analysis) with 85% precision, reducing customer churn by 10%.
• Implemented data preprocessing in Python (pandas, NumPy), improving churn model accuracy and boosting insight reliability.
• Defined retention KPIs in Power BI, enabling leaders to track renewal and LTV across 5+ business units in real time.
• Configured row-level security, custom visuals, drill-downs in Power BI, increasing dashboard adoption across regional divisions.
• Conducted A/B testing on 20+ campaigns, optimizing spend allocation and increasing retention ROI by 20%.
• Delivered dashboard training workshops for 5+ business units, boosting adoption and satisfaction by 35%.
• Integrated Azure Synapse pipelines with Power BI datasets, delivering real-time analytics across structured sources.
• Deployed DAX measures and Power Query transformations, boosting dashboard refresh speed by 45% for 2,500+ users.
• Automated threshold-based churn alerts via SQL Server Agent & Power BI subscriptions, cutting detection delays. Liberty Mutual Finance Nov 2019 – Sep 2022
Financial Data Analyst
• Designed data integration pipelines consolidating Oracle, SQL Server, and Snowflake datasets, ensuring 100% audit readiness.
• Developed validation rules in Informatica and Python, eliminating 95% of duplicates and improving compliance accuracy by 15%.
• Built ETL workflows with embedded SOX/GDPR/HIPAA checks, reducing manual review effort by 30+ hours per cycle.
• Implemented SQL-based risk scoring framework analyzing 1M+ monthly transactions, reducing missed high-risk cases by 18%.
• Designed compliance dashboards in Power BI/Tableau for 200K+ transactions daily, cutting reporting errors by 20%.
• Partnered with compliance officers to define 50+ regulatory KPIs, improving transparency & reducing audit discrepancies by 12%.
• Enforced role-based access controls across dashboards, ensuring zero security breaches and passing all internal reviews.
• Automated compliance workflows, reducing reporting cycle from 3 weeks to 5 business days and cutting costs by 25%.
• Collaborated with finance and risk teams on predictive Tableau models, detecting fraud patterns and reducing losses 9%.
• Migrated compliance reporting from Excel to Snowflake and Power BI, cutting manual errors and improving audit readiness 30%. EDUCATION
• Bachelor of Technology in Computer Science Engineering Jawaharlal Nehru Technological University, India