Data Analyst Power Bi

Rohan Shah

**********@*****.*** +1-315-***-**** linkedin.com/in/rohanxshah

SUMMARY

Analytics Professional with 5 years of experience leveraging SQL, Python, and Power BI to develop scalable analytics solutions, drive cost savings of $130K annually, and automate reporting workflows. Led cross-functional teams, designing self-service BI dashboards, optimizing ETL pipelines, and conducted KPI analysis to inform executive decision-making. EDUCATION

May 2024 SYRACUSE UNIVERSITY Syracuse, NY, USA

Master of Science in Information Systems

May 2019 MUMBAI UNIVERSITY Mumbai, India

Bachelor of Science in Information Technology

EXPERIENCE

2024 - Now ICONSULT COLLABORATIVE

Senior Data Analyst Client - Albany Health Management Associates

• Saved $130K annually by developing automated data extraction and transformation workflows using Power Automate, integrating with AWS Lambda to eliminate third-party software dependencies

• Reduced data retrieval time by 40% by deploying an end-to-end ETL pipeline leveraging AWS (S3, SQS, Glue, Lambda, Redshift), enabling real-time ingestion and processing of sales records

• Spearheaded data governance initiatives using Databricks, for data inputs from on-prem and cloud sources to ensure data quality and access rights across the organization

• Reduced ad-hoc report requests by 30% by designing self-service Power BI dashboards with backend integration to Redshift, enabling faster data-driven decisions across finance and operations teams

• Increased dashboard adoption by 25% and reduced support queries by designing wireframes in Visio and delivering training sessions to 50+ employees on Power BI best practices, SQL optimization, and DevOps methodologies 2023 - 2024 ICONSULT COLLABORATIVE

Data Analyst Client - Nulia

• Saved 5+ hours weekly and enhanced operational visibility by 25% by streamlining reporting processes, migrating 20+ Excel reports to Power BI, and introducing automated refresh cycles

• Improved SQL query performance by implementing a Snowflake data warehouse with dbt for data transformation for 2M+ product usage records, enabling faster, data-driven customer journey insights

• Improved user engagement by 15% in 3 months through KPI tracking to device strategies influencing product adoption

• Cut data load time by 50% and delivered faster, high-performance visualizations for leadership reporting by enhancing Power BI report efficiency with advanced DAX calculations 2021 - 2022 KENNECT INC.

Product Analyst Client - GSK, Roche, AstraZeneca

• Improved in-app data accuracy by 13% by spearheading data governance initiatives, ensuring consistent and reliable reporting across sales, finance, and marketing teams

• Drove 20% revenue growth by implementing 12+ Tableau dashboards for sales KPIs, empowering sales leadership with actionable insights and optimized go-to-market (GTM) strategies

• Ensured precise incentive compensation calculations for 13K+ sales reps across 11 organizations by collaborating with engineering teams to automate data mapping workflows

• Increased report usage by 25% by leading UAT for 15+ BI reports, resolving data discrepancies, ensuring report accuracy 2019 - 2021 KENNECT INC.

Data Analyst Client - Sanofi

• Saved 4 hours weekly by revamping IQVIA sales data pipelines with AWS (S3, Glue, RDS), automating manual processes

• Boosted productivity by 15%, saving 40+ hours monthly, by automating data processing workflows using pandas

• Enhanced market positioning by delivering competitive benchmarking analysis for 35+ companies, generating actionable insights that informed executive-level pricing strategies

• Identified growth opportunities for the top 25 pharmaceutical brands by developing Power BI dashboards to track financial performance, providing executives with actionable insights SKILLS

Data Engineering: SQL, Python, PySpark, DAX, ETL, Databricks, Snowflake, CI/CD, Jenkins, DevOps, Fivetran, Airflow, dbt Business Intelligence Tools: Advanced Excel, Power BI, Tableau, Looker, Alteryx, DOMO, SSRS, QuickSight, QlikView Cloud Technologies: AWS (S3, SQS, Glue, Lambda, Redshift, EC2, Athena, IAM), Azure (ADLSGen2, Blob Storage, Synapse) Documentation: Business Requirement Document (BRD), Data Flow Diagrams (DFD), User Stories, Test Cases

Contact this candidate