Data Analyst - SQL Python Tableau Power BI Dashboards

VISHNU VARDHAN

*******.*@*****.*** www.linkedin.com/in/nadendla-v https://github.com/vishnunadendla SUMMARY

Data Analyst with experience in production analytics, marketing performance analysis, and KPI-driven reporting. Proficient in SQL, Python, Power BI, Tableau, and Apache Airflow, expertise in data extraction, transformation, dimensional modeling, and building scalable analytics-ready datasets. Skilled in developing and maintaining enterprise dashboards, automating data pipelines, conducting data validation and reconciliation, and analyzing large multi-source datasets to uncover trends, campaign effectiveness, customer behavior, and operational performance drivers. Adept at translating complex data into structured insights and standardized reports to support stakeholder decision-making, SLA commitments, and data governance standards. Education

• Master’s in Computer Science, Rowan University, Glassboro, NJ

• Bachelor of Computer Science, Hindustan University, Chennai, India TECHNICAL SKILLS

• Programming & Scripting: Python, R, SQL

• Data Wrangling & Analysis: Data Cleaning, Exploratory Data Analysis (EDA), Pivot Tables, Descriptive Statistics, Outlier Detection, Missing Value Treatment

• Statistical Methods: Hypothesis Testing, A/B Testing, T-tests, Chi-square Tests, Linear Regression, Logistic Regression, Time Series Analysis

• Data Visualization: Tableau, Power BI, Looker Studio, Excel Dashboards, Plotly, Matplotlib, Seaborn

• Databases & Data Warehousing: MySQL, PostgreSQL, SQL Server, BigQuery, Oracle (Basic), SQLite, SAP HANA, ERP Systems (SAP, Oracle)

• Spreadsheets & Excel Tools: Advanced Excel (VLOOKUP, XLOOKUP, INDEX-MATCH, Pivot Tables, Power Query, Data Validation)

• Business Intelligence & Reporting: Tableau Desktop, Power BI Service, Looker Studio, Google Analytics (Basic), Excel Reporting Automation, KPI Tracking, Dashboard Design

• Data Sources & APIs: CSV/Excel Import, Google Sheets Integration, REST APIs (Data Retrieval), JSON Parsing

• Modern Data Stack (MDS): Apache Airflow (Astro CLI), dbt (Data Build Tool), Soda Core (Data Quality), Docker, Git

• Project & Collaboration Tools, Workflows & Methodologies: Jupyter Notebooks, Google Colab, Git, Jira, Confluence, Microsoft Teams, Slack, Agile/Scrum, Data Storytelling, Report Automation PROFESSIONAL EXPERIENCE

Data Analyst Epsilon, TX, USA Jan 2025 – March 26

• Developed and maintained Power BI dashboards in the production analytics environment to track campaign, customer, and operational KPIs, enabling consistent performance monitoring and stakeholder reporting.

• Performed data analysis and performance analysis on large-scale marketing datasets using SQL, extracting insights on campaign effectiveness, customer behavior, and churn trends.

• Analyzed and interpreted multi-source datasets to identify performance metrics, trends, and key performance drivers, delivering structured insights to marketing and business teams.

• Executed scheduled data extraction and transformation workflows within the production pipeline using Apache Airflow, ensuring timely and reliable data availability for reporting.

• Prepared analytics-ready datasets using dimensional modeling techniques, supporting standardized KPI definitions and scalable performance measurement across campaigns.

• Conducted routine data validation and quality checks to ensure accuracy, completeness, and reliability of production datasets used for dashboards and recurring reports.

• Utilized Python to perform data preparation, dataset analysis, and ad hoc investigations, resolving data issues impacting production reporting.

• Produced standardized reports and data visualizations in Power BI to support recurring business reviews, trend analysis, and operational decision-making. Data Analyst Tata Consultancy Service May 2021 - July2023

• Evaluated and analyzed production datasets from multiple client source systems to support operational KPIs, performance metrics, and management reporting.

• Wrote and maintained complex SQL queries and transformation logic to extract, cleanse, and structure data for enterprise dashboards and scheduled reports.

• Designed, enhanced, and supported Power BI and Tableau dashboards that enabled client teams to track trends, monitor performance drivers, and measure business outcomes.

• Interpreted large datasets to identify trends, inconsistencies, and performance gaps, converting analytical results into clear reports and stakeholder-ready insights.

• Automated data refreshes and recurring reports using SQL and Python, improving data availability, reducing manual dependencies, and supporting client SLA commitments.

• Verified production data through reconciliation checks and validation routines, ensuring report accuracy and alignment with client governance and audit standards.

• Calculated and maintained KPIs in accordance with agreed business definitions, supporting consistent performance measurement across client functions.

• Worked closely with client stakeholders, data engineering teams, and QA resources to investigate data issues, refine reporting logic, and maintain stable analytics delivery. PROJECTS

End-to-End Retail Data Pipeline (GCP)

• Designed and deployed a containerized data platform using Airflow and dbt on Google Cloud Platform to automate scalable ELT workflows. Implemented Soda Core data quality checks and enforced validation gates across transformation layers. Enabled end-to-end lineage tracking and DAG orchestration via Cosmos, improving pipeline reliability and observability. RFM Customer Segmentation (Machine Learning)

• Engineered an RFM-based customer segmentation model using K-Means clustering to classify retail customers into three distinct behavioral cohorts. Applied Power Transformer to correct feature skewness and improve cluster stability. Reduced dimensionality with t-SNE and visualized segment separability using Seaborn to support marketing strategy optimization. Advanced BI Analytics (Healthcare & Capital Markets)

• Developed interactive Power BI dashboards for healthcare operations, reducing patient wait times by 12% through KPI-driven workflow insights. Built dynamic DAX-powered financial analytics dashboards tracking Magnificent 7 equity performance, enabling real-time growth and comparative trend analysis.

Contact this candidate