Data Analyst Power Bi

Rohan Patel

**************@*****.*** +1-469-***-**** Tampa, FL (Open to Relocate) LinkedIn

SUMMARY

Data Analyst with 5 years of experience in banking and healthcare, skilled in SQL, Python, Power BI, Tableau, and ETL/ELT pipelines on Snowflake, Databricks, and dbt. Transformed 1M+ financial and clinical records into governed insights that improved forecasting accuracy and scaled enterprise reporting across AWS and Azure. Trusted partner to senior leadership, known for solving high- impact business problems and driving data-informed decision-making in fast-paced, mission-critical environments. TECHNICAL SKILLS

Programming & Analytics: SQL, Python, R, SAS, Alteryx, PySpark, dbt, Predictive Modeling, A/B Test Design, Hypothesis Testing Visualization & BI Tools: Power BI, Tableau, Looker, Excel (Advance), KPI Dashboards, Data Storytelling, Data Modelling Data Platforms & Cloud Platforms: Snowflake, Databricks (Delta Lake, Delta Live Tables, Unity Catalog), Azure Synapse Analytics, Azure Purview, GCP BigQuery, AWS Redshift, Oracle, DB2, Teradata, MySQL, NoSQL, Data Lake Data Governance: Metadata Management, KPI Glossaries, Data Catalogs, Data Lineage Tracking, Regulatory Compliance (GDPR, HIPAA, SOX, Basel III), Data Quality & Data Validation Frameworks, Automated Reporting Narratives, Data Cleansing Collaboration & Delivery: JIRA, Confluence, Agile/SCRUM, Stakeholder Engagement, Power Apps, Git/GitHub Certifications: Power BI Data Analyst Associate (PL-300), Azure Fundamentals (AZ-900), AI Fluency: Framework & Foundations PROFESSIONAL EXPERIENCE

Data Analyst, Bluevine Jan 2025 - Present USA

Engineered interactive Power BI dashboards integrated with Snowflake and dbt pipelines, cutting manual reporting 40% and enabling 20+ banking leaders to track KPI trends in real time.

Optimized KPI monitoring by embedding Power Query and DAX validation rules, improving stewardship accountability and reducing finance audit rework 20% across regulatory dashboards.

Automated end-to-end data ingestion workflows from source systems to Snowflake using ADF and parameterized SQL, cutting manual file prep 50% and speeding up financial reporting cycles.

Built Spark-based anomaly detection logic in Databricks using SQL and Python, identifying outliers in 1M+ finance records and reducing false positives in fraud reports by 30%.

Partnered with finance and compliance executives to standardize KPI definitions, producing BI playbooks in Power Apps that cut analyst onboarding 40% and raised dashboard adoption 30%.

Streamlined 15+ governance policies in Snowflake and Synapse, reinforcing lineage and cleansing rules that reduced audit exceptions 25% and ensured SOX/HIPAA-compliant financial reporting. Senior Data Analyst, Capgemini Oct 2020 - Jun 2023 India

Built Tableau dashboards to monitor medical cost and utilization trends from claims and pharmacy data, reducing reporting time 40% and helping executives identify key cost drivers.

Designed SQL-based data models for forecasting medical spend and analyzing utilization trends, improving budget accuracy and cutting variance in healthcare costs by 20%.

Automated ETL pipelines in GCP BigQuery to integrate 500K+ eligibility and claims records, improving access for 15+ healthcare teams and reducing manual reporting by 35%.

Developed anomaly detection scripts in Python and SQL for healthcare claims QA, ensuring 99.9% data accuracy and reducing audit remediation in HIPAA compliance dashboards.

Streamlined reporting workflows using Excel (Power Query, VBA), reducing manual prep by 20+ hours/month and ensuring data governance in compliance with HIPAA standards.

Delivered Tableau training to 30+ healthcare analysts, boosting dashboard adoption by 25%, improving patient care KPIs visibility, and reducing report turnaround by 20%. Data Analyst, PwC Jan 2020 - Sep 2020 India

Designed and maintained Python and SQL data pipelines for 5+ client engagements, enabling reliable ETL from Oracle, SQL Server, and legacy systems, processing 100K+ records monthly.

Automated monthly reporting processes using Python and Excel VBA macros, reducing manual data preparation by 20+ hours per month and eliminating inconsistencies in financial reporting.

Collaborated with cross-functional teams to implement Azure Synapse Analytics and ADLS Gen2 solutions, delivering Power BI dashboards that reduced executive report generation time by 40% and accelerated decision-making cycles. EDUCATION

Master of Science, University of South Florida Jul 2023 - May 2025 Tampa, USA Business Analytics & Information Systems CGPA: 3.76 Bachelor of Technology, Vellore Institute of Technology Jul 2016 - Jun 2020 Vellore, India Computer Science and Engineering CGPA:3.33

Contact this candidate