Data Analyst Power Bi

Rahul Vannoj

Data Analyst

**********@*****.*** +1-404-***-**** USA Linkedin

PROFILE

Results-driven Data Analyst with 3.5+ years of experience transforming raw data into actionable insights that fuel business strategy and operational efficiency. Proficient in SQL, Python, Power BI, and Tableau for advanced data analysis, interactive dashboard development, and predictive modeling. Skilled in designing scalable ETL pipelines, optimizing complex queries, and delivering executive-level reporting across domains such as insurance, finance, and enterprise operations.Adept at working in Agile environments and collaborating with cross-functional teams to translate data into strategic recommendations. Hands-on experience with cloud platforms (AWS, Snowflake, Azure) and modern data stack tools like dbt and Apache Airflow. Recognized for ensuring data quality, driving automation, and engaging stakeholders through clear data storytelling and business-aligned insights. EDUCATION

University of Memphis, Master of Science,Data Science Jan 2023 – Dec 2024 Memphis, TN, USA Jawaharlal Nehru Technological University,

B.Tech in Mechanical Engineering

Aug 2017 – Jul 2021 Hyderabad, India

PROFESSIONAL EXPERIENCE

state Farm, Data Analyst Jun 2024 – Present Remote, USA

•Analyzed over 10M+ policy and claims records to uncover trends in customer behavior, claims severity, and underwriting risk; enabled data-driven decisions that improved customer segmentation by 15%.

•Designed and maintained advanced Power BI and Tableau dashboards for KPIs such as loss ratio, premium leakage, and quote-to-bind conversion, reducing manual reporting by 40%.

•Built scalable SQL pipelines and automated data workflows using dbt, Snowflake, and Airflow, cutting ETL processing time by 50% across teams.

•Conducted predictive modeling and regression analysis using Python (pandas, scikit-learn) to support fraud detection and policy lapse prediction, increasing early detection accuracy by 18%.

•Collaborated with underwriting, actuarial, and marketing teams to provide business-critical insights that influenced product pricing and cross-sell strategies.

•Partnered with data engineering and governance teams to implement data quality monitoring and lineage tracking, ensuring accuracy and compliance with internal audit and regulatory standards.

•Participated in Agile sprints to deliver data products on schedule; wrote user stories, conducted UAT, and provided production support in CI/CD environments.

•Delivered executive-level data stories and strategic recommendations to senior stakeholders using actionable visuals and presentation-ready summaries.

Tata Consultancy Services, Data Analyst Sep 2021 – Dec 2022 Bengaluru, India

•Collaborated with cross-functional teams to collect, clean, and analyze large datasets using SQL, Excel, and Python, supporting business intelligence initiatives for global clients across finance and retail domains.

•Developed automated ETL workflows and maintained data pipelines using SQL Server, Python, and SSIS, improving data processing efficiency by 40%.

•Created interactive dashboards and reports in Power BI and Tableau to visualize sales performance, customer segmentation, and operational KPIs, driving data-informed decision-making.

•Designed and implemented data validation frameworks to ensure data accuracy, integrity, and consistency across source systems and reporting layers.

•Conducted ad-hoc and root cause analysis on client KPIs, presenting actionable insights and business recommendations to stakeholders and leadership teams.

•Partnered with onshore teams (US-based) in agile sprint cycles for dashboard enhancement, metric definitions, and change requests.

•Wrote optimized SQL queries and stored procedures to extract insights from large-scale databases (Teradata, Oracle), supporting reporting and analytics needs.

•Participated in data migration and transformation projects involving cloud platforms like Azure Data Factory and AWS S3.

•Ensured compliance with client-specific data governance standards and regulatory requirements (GDPR, HIPAA where applicable).

Cimpress India, Data Analyst Jul 2020 – Aug 2021 Remote, India

•Collected, cleaned, and organized large datasets from internal systems to support business reporting and ad hoc analysis.

•Built interactive dashboards and visual reports using Power BI and Excel to track sales performance, customer trends, and operational KPIs.

•Conducted exploratory data analysis (EDA) to identify business patterns and deliver actionable insights for marketing and product teams.

•Automated routine data processing tasks using Excel formulas, macros, and Power Query, improving reporting efficiency by 30%.

•Assisted in designing A/B testing frameworks and interpreted results to support data-driven decision-making.

•Collaborated with cross-functional teams (marketing, sales, and finance) to gather data requirements and align on reporting objectives.

•Supported monthly and quarterly business review meetings by preparing concise data summaries and visualizations.

•Ensured data integrity and quality by performing regular audits and validation checks on source and transformed datasets.

SKILLS

Programming & Scripting: Python (Pandas, NumPy, Matplotlib, Seaborn, Plotly), SQL (T-SQL, PostgreSQL, MySQL), R

(tidyverse, ggplot2), DAX, Shell Scripting (Basics) Data Analysis & Visualization: Power BI, Tableau, Qlik Sense, Excel (Power Query, Pivot Tables, VBA Macros, Forecast Models), Google Looker Studio, Data Storytelling, Google Analytics Data Processing & ETL: Data Wrangling & Cleaning, Complex SQL Queries (Joins, CTEs, Subqueries, Window Functions), ETL Pipelines (SSIS, dbt, Apache Airflow), Alteryx, Power Query Cloud Platforms & Warehousing: AWS (S3, Redshift, Lambda), Azure Data Factory, Google BigQuery, Snowflake, Delta Lake, Data Lake Architecture (Basic to Intermediate) Big Data & Distributed Computing: Apache Spark, PySpark, Hive, MongoDB, Databricks, SQL-on-Hadoop (HiveQL), Distributed Data Processing Concepts

Statistical Analysis & Predictive Modeling: Linear/Logistic Regression, A/B Testing, Time Series Forecasting (ARIMA, Prophet), Clustering, Classification Models (Random Forest, Decision Trees), Exploratory Data Analysis (EDA) Automation & APIs: Web Scraping (BeautifulSoup, Selenium), REST APIs, Workflow Automation (Apache Airflow), Excel Macros, Task Scheduling (cron), CI/CD (GitHub Actions, Jenkins basics) Version Control & DevOps Basics: Git, GitHub, Bitbucket, CI/CD Pipelines (read/deploy), YAML, Docker (Basic for testing ETL pipelines)

Reporting & Business Intelligence: Interactive Dashboards, Executive Reports, KPI Monitoring, Self-Service BI Enablement, Financial Reporting, Operational Analytics, Data-Driven Storytelling Databases & Query Optimization: SQL Server, Oracle, MySQL, PostgreSQL, Snowflake, DB2 (Stored Procedures, Indexing, Query Optimization & Tuning)

Project & Collaboration Methodologies: Agile (Scrum, Kanban), Sprint Planning, Jira, Confluence, User Story Definition, UAT, Stakeholder Communication

Professional Skills: Cross-Functional Collaboration, Analytical Thinking, Business Acumen, Strategic Problem Solving, Stakeholder Engagement, Decision Support, Presentation & Data Narratives PROJECTS

Cloud Cost Optimization, AWS, Python, R, SQL, Power BI

•Analyzed AWS Cost Explorer data using SQL and Python to identify underutilized resources, achieving a 10% reduction in monthly cloud costs.

•Developed Power BI dashboards integrated with R scripts for FinOps reporting, enabling real-time cost visibility and decision-making.

Hospital Desert Analysis, Python, R, SQL, Tableau, AWS

•Utilized CDC and Census data on AWS to map underserved regions using Python (GeoPandas) and R for spatial analysis.

•Delivered actionable insights through Tableau visualizations, supporting the deployment strategy for cost-effective mobile health clinics.

CERTIFICATES

Data Science Specialization, Johns Hopkins University Star Team Award, On The Spot Award: TCS

Contact this candidate