Power Bi Data Analytics

SRAVANI S

Email: Mobile:

PROFESSIONAL SUMMARY

● Over 5 years of experience in data analytics, with a strong focus on transforming large-scale datasets into actionable business insights across cloud platforms like AWS and Microsoft Azure.

● Proven expertise in analyzing complex data using SQL, Python, and BI tools such as Power BI, Tableau, and Amazon QuickSight to support decision-making across healthcare, insurance, and finance domains.

● Adept at building and automating data workflows using AWS Glue, Azure Data Factory, and PySpark, enabling real-time and batch reporting for key operational metrics.

● Experienced in designing cloud-based data models and optimizing Redshift and Azure Synapse Analytics for faster reporting and dashboard performance.

● Skilled in collaborating with cross-functional teams, preparing ML-ready datasets, and enhancing predictive analytics through tools like AWS SageMaker and Azure ML.

● Committed to delivering data-driven solutions that improve reporting efficiency, stakeholder visibility, and strategic outcomes.

TECHNICAL SKILLS

Programming Languages Python, SQL, Java, Scala, R, Bash, JavaScript, Go Cloud Platforms AWS, Azure, Google Cloud Platform (GCP) Data Warehousing & Storage AWS Redshift, Azure Synapse Analytics, Snowflake, BigQuery, AWS S3, Azure Blob Storage, ADLS, AWS RDS, Cloud SQL

Data Processing & Integration AWS Glue, Azure Data Factory, PySpark, Hadoop, Kafka, Kinesis, MapReduce, DBT, UDFs, Change Data Capture

Data Security & Compliance IAM, Azure Active Directory, AWS KMS, Data Encryption, Security Compliances, Data Governance

Machine Learning & AI AWS SageMaker, Azure ML, Google AI Platform, TensorFlow, Scikit- learn

CI/CD & DevOps Jenkins, Git, Docker, AWS CodePipeline, Azure DevOps, GitLab, Cloud Build

API & Data Integration API Design, REST APIs, GraphQL, Data Movement, Data Synchronization

Business Intelligence Tableau, Power BI, Looker, AWS QuickSight, SSRS, SSAS Monitoring & Automation AWS CloudWatch, Azure Monitor, Google Operations Suite, AWS Step Functions, Azure Logic Apps

PROFESSIONAL EXPERIENCE

Sun Life Jul 2024 - Present

Senior Data Analyst Seattle, WA

● Utilized AWS Redshift and Athena to analyze over 25TB of structured and semi-structured healthcare claims data, delivering insights that improved claims adjudication timelines by 22% and reduced error rates.

● Designed interactive Tableau dashboards sourced from AWS S3 and Redshift, enabling real-time monitoring of claim status, policyholder activity, and regional payout trends across all business units.

● Authored optimized SQL queries in Redshift to support ad hoc analysis by underwriting and fraud investigation teams, improving insight turnaround time by over 50%.

● Integrated data from 50+ sources using AWS Glue and prepared it for analytics consumption, reducing manual data stitching efforts and ensuring consistent KPIs across all reporting tools.

● Collaborated with actuarial teams to analyze historical claims and premium data hosted in AWS RDS, supporting pricing model validation and loss ratio monitoring.

● Automated claim KPI reports using AWS Lambda and CloudWatch Events, ensuring hourly data refreshes and eliminating over 20 hours of manual reporting per month.

● Configured Redshift Spectrum to query data stored in S3, supporting long-term claims trend analysis and reducing cold storage query costs by 30%.

● Led root-cause analyses on processing delays using enriched data from AWS Glue ETL jobs, uncovering operational bottlenecks that were remediated to improve SLAs by 18%.

● Partnered with data scientists to deliver pre-cleaned, feature-ready datasets from Redshift for training fraud prediction models in SageMaker, boosting fraud flagging accuracy by 12%.

● Created a metadata layer in AWS Data Catalog, standardizing data definitions and simplifying discovery for analytics users across departments.

● Implemented dynamic row-level access controls in Redshift via AWS IAM and Lake Formation, ensuring privacy for PHI and HIPAA compliance across 200+ report users.

● Generated insurer-wide performance dashboards in Tableau by sourcing data from Amazon QuickSight, comparing key metrics like loss ratios and processing times by region and product.

● Conducted impact analysis of policy changes by querying multi-year claims history via Amazon Athena, enabling leadership to adjust underwriting strategies proactively. Fiserv Oct 2020 - Aug 2022

Data Analyst Chennai, India

● Analyzed over 10TB of financial transaction data per month using Azure Synapse Analytics, uncovering anomalies and trends that improved transaction approval workflows by 17%.

● Designed and deployed Power BI dashboards connected to Azure SQL Database and Azure Blob Storage, enabling business users to track daily revenue, chargebacks, and customer behavior trends.

● Wrote complex T-SQL scripts in Azure SQL to support data slicing by product, region, and merchant category, helping leadership evaluate profitability at granular levels.

● Implemented Azure Data Factory pipelines to transform and prepare datasets for use in financial forecasting models, reducing time-to-insight for FP&A teams by 40%.

● Collaborated with compliance teams to build SOX-compliant data audit dashboards by leveraging Azure Monitor and Log Analytics, improving transparency in regulatory reporting.

● Automated daily and weekly KPI reports using Azure Functions and Power BI API, reducing report generation effort by over 30%.

● Built real-time fraud alert dashboards by integrating event-driven data streams from Azure Event Hubs, giving risk analysts visibility into potential fraudulent behaviors as they occur.

● Partnered with pricing strategy teams to extract and model transaction-level data from Azure Synapse for profitability analysis, influencing adjustments to fee structures.

● Consolidated 200+ data sources using Azure Data Lake Storage, creating a unified view of customer transactions to support analytics for marketing and customer experience teams.

● Implemented row-level security in Power BI tied to Azure Active Directory (AAD) roles, ensuring secure, role- based access across 150+ internal report users.

● Created forecasting visualizations by integrating historical data into Azure Machine Learning, boosting model accuracy by 15% for payment volume predictions.

● Built custom metric logic (LTV, churn risk, net revenue) into Power BI models, aligning KPIs across analytics and finance teams for consistent business tracking.

● Reduced reporting lead time from 3 days to a few hours by refactoring data transformations in Azure Data Factory and optimizing query performance in Azure Synapse. Cigna Health Jun 2018 - Oct 2020

Data Analyst Chennai, India

● Extracted and analyzed over 10TB of patient and provider data using AWS Athena and Redshift, generating insights into readmission rates, chronic condition trends, and utilization metrics.

● Built executive-level dashboards in Tableau and Amazon QuickSight sourcing from S3, enabling senior management to monitor care quality and cost-efficiency in real time.

● Developed automated data workflows using AWS Glue and Lambda, transforming raw EHR data into curated datasets for operational and compliance reporting.

● Partnered with clinicians and quality improvement teams to create KPIs for patient outcomes, visit efficiency, and care plan adherence, sourced directly from AWS RDS and Redshift.

● Conducted longitudinal analysis of patient care data using Amazon Athena, helping identify at-risk populations for targeted outreach programs.

● Delivered ad hoc analyses via SQL queries and dashboards to support operational decisions related to appointment availability, treatment delays, and care coordination gaps.

● Supported predictive analytics efforts by preparing and labeling 2TB of historical data used in disease progression and hospital readmission models in SageMaker.

● Enabled HIPAA-compliant analytics access by configuring secure S3 buckets with KMS encryption and row-level access policies across Redshift for 500+ internal users.

● Automated patient record refresh processes using Step Functions and Lambda, reducing reporting lag and improving dashboard accuracy.

● Reduced query runtimes by over 35% by optimizing Redshift schema design and creating efficient partitioning strategies for claims and patient data.

● Conducted quarterly data audits and completeness checks using custom scripts and AWS CloudWatch metrics, identifying and resolving discrepancies across multiple pipelines.

● Built statistical dashboards tracking provider performance metrics across regions, helping executives prioritize resources and training programs.

● Contributed to organizational data governance by defining clinical data standards and implementing cataloging policies using AWS Glue Data Catalog.

EDUCATION

Contact this candidate