Data Analyst Power Bi

Sharath Chandra Bandela

Nausha, NH, ***** 603-***-**** *****************@*****.***

Summary

Results-driven Data Analyst with 4+ years of experience in insurance and banking projects, specializing in risk modeling, claims analytics, and digital banking intelligence. Expertise in SQL, Python, Power BI, Tableau, Azure, Snowflake, and AWS. Skilled in building ETL pipelines, automating reporting, and developing interactive dashboards. Proven ability to collaborate cross-functionally and deliver actionable insights that optimize underwriting, improve customer engagement, and ensure regulatory compliance. Skills

• Technologies & Frameworks: Python, SQL, Java, Pandas, NumPy, Scikit-learn, Tableau, Power BI, Excel.

• Cloud & Databases: AWS (S3, Lambda, Redshift), Azure (Synapse, Data Factory, DevOps CI/CD), Google. Cloud Platform (BigQuery, Cloud Functions), Snowflake, PostgreSQL, MySQL, Oracle.

• Tools: Git, GitHub, Jupyter, Postman, VS Code, Docker, Apache Airflow, Azure Data Factory, dbt, Talend, Alteryx, KNIME, EasyMorph, Informatica, Power Automate, Zapier

• Data Techniques: Exploratory Data Analysis (EDA), Predictive Modeling (GLM, Logistic Regression), Data Cleaning, Data Visualization, A/B Testing, Cohort Analysis, Time-Series Forecasting, Funnel Analytics

• Collaboration & Project Management: JIRA, Confluence,Notion, Airtable, Slack (Workflows) Work Experience

Advanced Claims Intelligence & Policyholder Risk Scoring Platform March 2024 - Present Insurtech Systems Inc. Data Analyst NJ

• Developed Power BI dashboards with row-level security to visualize claims ratios, fraud triggers, and policy churn, enabling underwriters to take data-driven actions in near real time.

• Cleaned and optimized multi-terabyte policy and claims datasets from Snowflake using advanced SQL

(window functions, CTEs, partitions) for real-time risk segmentation and policy performance tracking.

• Built scalable data pipelines in Azure Data Factory and Databricks to automate ingestion, cleansing, and enrichment of third-party risk scoring feeds and internal actuarial tables.

• Replaced manual Excel workflows with Python automation scripts for loss triangle reports, renewal forecasting, and premium reconciliation, saving 10+ hours weekly across pricing teams.

• Collaborated with actuaries to develop and deploy GLM-based premium risk models using scikit- learn and PyCaret, increasing rating model accuracy and pricing efficiency across customer segments.

• Integrated telemetry and IoT device data (vehicle, home sensors) to build new risk indicators, contributing to improved underwriting decisions and smarter pricing for usage-based policies.

• Containerized data applications using Docker and scheduled model scoring jobs via Azure DevOps CI/CD pipelines, ensuring reliable deployment of analytics products in production.

• Produced detailed documentation for data lineage, pipeline orchestration, and dashboard governance to support compliance with NAIC standards and internal audit readiness. Customer Intelligence and Product Performance Monitoring for Digital Banking Virtusa Consulting Services Pvt Ltd Junior Data Analyst Hyderabad Ind Feb 2022 – Aug 2023

• Engineered real-time monitoring dashboards using Tableau and DAX to visualize digital banking channel usage, transaction funnel drop-offs, and service adoption metrics across customer segments.

• Integrated streaming and batch data from AWS Redshift, Kafka, and mobile app logs to build a centralized, cloud-based customer intelligence platform.

• Performed cohort analysis, time-series forecasting, and funnel analytics to identify friction points and behavioral trends across mobile, web, and ATM interactions.

• Designed KPIs and visual scorecards to track cross-sell, upsell, and product lifecycle performance, helping business teams adjust campaigns in near real time.

• Created REST API connectors to pull third-party digital engagement data (e.g., customer satisfaction, app ratings) and enriched internal records for advanced behavioral modeling.

• Implemented data masking, role-based access, and row-level security policies to meet enterprise-grade data privacy and compliance requirements.

• Collaborated with UX and marketing teams to run A/B tests and measure the impact of new product features on engagement, conversion, and satisfaction scores.

• Wrote dbt models and scheduled jobs in Airflow to automate transformations, metadata lineage tracking, and daily business logic refreshes.

• Supported CX (Customer Experience) team with journey mapping insights and built churn risk indicators using event sequencing and session analytics. Credit Risk Analytics and Reporting Automation for Retail Banking Jan 2021 – Feb 2022 Virtusa Consulting Services Pvt Ltd Intern Bangalore

• Wrote complex SQL queries to extract, join, and filter customer and loan data for segmentation, improving credit risk analysis and decision-making.

• Created dynamic Power BI dashboards to track loan KPIs, branch performance, and NPA trends, reducing manual analysis time for business stakeholders.

• Automated financial reporting in Excel using PivotTables, VLOOKUP, and VBA, minimizing manual errors and improving reporting turnaround by 25%.

• Developed Python scripts to clean, validate, and transform raw banking data for ETL pipelines, improving data accuracy and pipeline efficiency.

• Performed data profiling and exploratory analysis to support risk modeling, identifying trends, data gaps, and outliers across customer loan datasets.

• Collaborated with risk and compliance teams to gather requirements and design visual reports aligned with regulatory and business needs.

• Supported data reconciliation between legacy systems and digital platforms, identifying mismatches and improving reporting accuracy by over 40%.

Certifications

• IBM Python for Data Science Certificate (2024)

• Data Visualization - IBM

• ISQTB – Certified Tester Foundation Level

• SQL and Relational Databases – BDU

• Java Fundamentals – IBM

Education

Rivier University Nashua, NH

Master of Science in Computer Science: GPA: 3.9 / 4 Malla Reddy College of Engineering and Technology India Bachelor of Technology in Information Technology: GPA: 8.2 / 10

Contact this candidate