Data Analyst Power Bi

Aryan Shirwadkar

862-***-**** *****************@*****.*** LinkedIn Portfolio

SUMMARY

Experienced Data Analyst with over 3+ years of expertise in leveraging data-driven insights to optimize business decisions and improve operational efficiency. Skilled in data integration, ETL pipelines, data modeling, and advanced analytics, with hands-on experience in tools like SQL, Python, Power BI, Tableau, Talend, Alteryx, Azure, and AWS. Adept at collaborating with cross-functional teams to design interactive dashboards, automate reporting workflows, and develop predictive models that enhance performance and deliver actionable insights. Passionate about transforming complex datasets into meaningful business intelligence to drive strategic growth and innovation.

SKILLS

Data Analysis & Reporting: Data Cleaning, Data Transformation, Exploratory Data Analysis (EDA), Data Profiling, KPI Tracking Data Visualization & BI: Power BI, Tableau, Excel Dashboards, KPI Storyboarding, Interactive Reporting Data Integration & ETL: Talend, Azure Data Factory, ETL Pipeline Design, Data Warehousing, Automated Data Ingestion Database Management & Querying: SQL (Azure Synapse, AWS Redshift), Data Modeling, Query Optimization, Stored Procedures Cloud Technologies: Azure Cloud (Data Lake, Synapse Analytics, ML Studio), AWS (S3, Redshift, SageMaker) Programming & Scripting: Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn), Alteryx Workflows, Automation Scripting Predictive & Advanced Analytics: Customer Segmentation, Fraud Detection Models, Predictive Modeling, Churn Analysis. Reporting Automation: Excel Macros, Power BI Scheduled Refresh, Automated Report Pipelines, Dashboard Optimization WORK EXPERIENCE

Cigna Healthcare Group, USA Data Analyst Jan 2025 – Present

• Spearheaded the analysis of patient demographics, claims, and provider data by integrating multiple data sources using Talend, AWS Redshift, and SQL, enabling seamless access to consolidated healthcare insights.

• Orchestrated advanced data cleaning and transformation workflows leveraging Alteryx and Python, enhancing the quality and reliability of healthcare datasets and improving overall decision-making accuracy.

• Designed and developed interactive dashboards using Power BI and Tableau to visualize patient health risks, claims trends, and provider performance, empowering stakeholders to make faster and data-driven healthcare strategies.

• Delivered automated ETL pipelines and reporting solutions using Talend, AWS, and Power BI, reducing manual reporting efforts by over 60% and accelerating claims analytics and operational workflows.

• Enhanced patient outcome predictions by collaborating with data science teams and leveraging AWS SageMaker, Python, and SQL to build predictive models, improving early risk identification accuracy by over 80%. Hexaware Techno, India Data Analyst Jan 2021 - July 2023

• Led requirements gathering and collaborated with cross-functional teams to design a scalable analytics framework using Azure, Talend, and SQL, enabling seamless integration of claims, patient, and retail transaction data for unified insights.

• Facilitated data quality enhancement by implementing advanced cleaning and transformation workflows with Alteryx and Python, improving overall data accuracy and consistency across healthcare and retail datasets.

• Developed interactive dashboards and executive reports using Power BI and Tableau, empowering stakeholders to monitor real- time KPIs such as claims efficiency, fraud detection, customer churn, and revenue performance.

• Automated ETL pipelines and reporting workflows using Azure Data Factory and Talend, reducing manual intervention by over 60% while accelerating the delivery of healthcare claims analytics and retail performance insights.

• Executed customer segmentation strategies and predictive analytics leveraging Azure ML Studio and Python, enhancing personalized marketing campaigns and improving customer retention rates by over 25%.

• Partnered with business stakeholders to define KPIs like Customer Lifetime Value, Claim Settlement Rates, and Fraud Detection Metrics, integrating these into optimized dashboards for enhanced decision-making.

• Streamlined reporting processes by combining SQL, Power BI, and Azure Synapse Analytics, enabling leadership teams to access unified insights on healthcare claims processing and retail sales trends in near real-time. EDUCATION

Master of Science in computer science Syracuse University Syracuse, NY, USA May 2025 B. Tech in IT Engineering Vidyalankar Institute of Technology Mumbai, India May 2023 CERTIFICATIONS

• Google Data Analytics Certificate

• AWS Cloud Practitioner

• Data Engineering on AWS

• IBM Introduction to Cloud Computing

PROJECTS

NP-15 Day-Ahead LMP Forecasting Syracuse University (Jan 2025 – May 2025)

• Developed day-ahead LMP forecasting models using Python (Pandas, NumPy, SQL) and ML (XGBoost, Random Forest, Linear Regression), reducing MAE to 3.34 by analyzing and visualizing 3+ years of energy, load, and gas price data (Matplotlib, Seaborn). Geographical Crime Rate Prediction System Academic Project (Aug 2022 – May 2023)

• Built a web-based crime rate prediction system for Mumbai using Python, Machine Learning (Random Forest), and Data Visualization, achieving 80.78% accuracy.

• Built an end-to-end pipeline using Python (Pandas, NumPy) and geospatial analysis on government crime data; deployed with Flask for real-time hotspot prediction and visualized insights in Tableau.

Contact this candidate