Data Analyst Power Bi

Manichandana Medishetty (Senior Data Analyst)

Ph: 804-***-**** Email: ***************@*****.***

PROFESSIONAL SUMMARY

Results-driven Data Analyst with 6+ years of experience across healthcare, retail, and finance industries. Proficient in data visualization, data modeling, and analytics using Power BI, Tableau, Snowflake, SQL, Looker, R and Python. Skilled in troubleshooting data discrepancies, optimizing data pipelines, and delivering actionable insights. Adept at working in cloud environments such as AWS, GCP, Azure, and Databricks. Strong communication skills, both verbal and written, with a keen ability to translate complex datasets into strategic business decisions. Passionate about data analytics, problem-solving, and cross- functional collaboration. Highly strategic in leveraging analytics to drive decision-making, improve operational efficiency, and uncover business opportunities. Passionate about data storytelling, and process optimization, delivering measurable impact across diverse industries.

TECHNICAL SKILLS

Data Visualization: Power BI, Tableau, Looker, Grafana, SSRS

Databases & Querying: SQL,SSIS, PostgreSQL, Snowflake, Google BigQuery

Programming & Scripting: Python, SAS, DBT

Data Engineering & ETL: Alteryx, AWS Glue, Azure Data Factory, Databricks, Informatica

Cloud Platforms: AWS, Azure, GCP

Data Governance & Compliance: HIPAA compliance, Risk adjustment analysis, Healthcare claims data, Regulatory reporting, Microsoft Purview

Version Control: Git, Gitlab

Reporting & Analysis: Excel (VBA Macros, Pivot Tables), Financial & Business Reporting, SSIS, KPI Reporting, R, trend Analysis, MATLAB, Statistics

Healthcare Data & Compliance: Risk adjustment analysis, Healthcare claims data, HIPAA compliance, regulatory reporting

Process Automation: ETL Pipelines, Workflow Automation, A/B Testing

Ticketing Tool: Jira, Hiver

Soft Skills: Strong communication skills, verbal and written communication, critical thinking, strategic decision-making, and problem-solving.

EXPERIENCE

Data Analyst Urgently Inc, VA, USA Aug 2024 – Present

Developed interactive dashboards in Power BI to visualize real-time road assistance request trends, improving response efficiency by 20%.

Designed Tableau reports for executive-level decision-making, integrating multiple data sources for enhanced business insights.

Created Tableau Prep workflows to automate data cleansing and transformation, reducing manual effort by 30%.

Automated data pipelines using DBT and SQL, reducing data processing time by 40%.

Built custom ETL workflows using Alteryx and Informatica to streamline data integration from multiple sources (customer support, telematics, and CRM).

Implemented Python scripts to identify fraudulent service claims, reducing false claims by 15%.

Created SQL queries to extract customer behavior insights, leading to targeted marketing campaigns that increased engagement by 10%.

Leveraged Azure Data Factory to schedule and manage data workflows, ensuring seamless data movement between systems.

Integrated Gitlab for version control in collaborative data projects, ensuring smooth tracking of changes and enhancements.

Conducted root cause analysis for data discrepancies in reports and automated issue resolution.

Designed KPI dashboards for monitoring service provider performance, enhancing SLA compliance.

Implemented forecasting models using Python (Pandas, NumPy, Scikit-learn) to predict peak demand times.

Developed anomaly detection models to flag inconsistent roadside assistance request patterns.

Collaborated with cross-functional teams to optimize dispatch routes using geospatial data analysis.

Developed statistical models using R to analyze trends in roadside assistance service requests.

Conducted time-series analysis in R to forecast service demand based on historical trends.

Created documentation for data models and ETL processes to maintain knowledge transfer and operational efficiency.

Environment: Power BI, Tableau, SQL, Python, Alteryx, DBT, Excel, Azure Data Factory, Gitlab.

Senior Data Analyst – Optum Health, Bangalore, India Aug 2021 – Feb 2023

Developed interactive dashboards using Business Intelligence tools like Power and Tableau to track patient health trends, reducing manual report creation by 40%.

Implemented DAX functions in Power BI to calculate complex healthcare KPIs dynamically, such as readmission rates and patient wait times.

Wrote complex SQL queries for claims data analysis, improving fraud detection and reducing false positives by 25%.

Utilized SQL Window Functions to segment patient demographics and healthcare trends.

Used Python for data cleaning and preprocessing, handling over 10 million patient records with optimized Panda’s workflows.

Designed Looker reports for executive-level decision-making on healthcare expenses and patient engagement.

Implemented Snowflake-based data warehousing solutions, reducing query execution time by 30%.

Developed data modeling structures (Star Schema & Snowflake Schema) for efficient storage and retrieval of patient records.

Integrated Alteryx workflows for automating data transformation, cutting down processing time by 50%.

Troubleshot AWS S3 and Redshift data pipeline failures, ensuring data integrity and reducing downtime.

Developed DBT models for transforming raw claims data into structured insights, enhancing analytical efficiency.

Automated Excel-based financial reports using VBA, reducing monthly reporting efforts by 20%.

Implemented Microsoft Purview for data governance in healthcare compliance, ensuring secure patient data handling.

Utilized Snowflake-based data warehousing solutions, reducing query execution time by 30%.

Developed data modeling structures (Star Schema & Snowflake Schema) for efficient storage and retrieval of patient records.

Integrated Informatica workflows for automating data transformation, cutting down processing time by 50%.

Configured Google BigQuery for ad-hoc analysis, reducing query cost by 15%.

Collaborated with stakeholders to define KPIs and built self-service BI solutions.

Migrated legacy reports to Tableau, enhancing report performance and adoption.

Utilized Azure Synapse Analytics for large-scale data processing, optimizing cloud costs.

Ensured compliance with HIPAA regulations by implementing security best practices for patient data protection.

Demonstrated strong problem-solving skills by debugging and optimizing ETL workflows, reducing processing errors by 35%.

Used Git for version control and collaboration on analytics scripts and dashboards.

Environment: Power BI, Tableau, ETL Workflow, SQL, Python, Looker, Snowflake, Alteryx, AWS Redshift, Microsoft Purview, Informatica, DBT, Excel, Google BigQuery, GCP, Azure Synapse, HIPAA.

BI Engineer – Walmart Global Tech, Bangalore, India April 2019 – July 2021

Built Tableau and Power BI dashboards to track sales trends across 1,500+ stores, improving inventory planning accuracy by 25%.

Utilized SQL for ad-hoc reporting, enabling category managers to analyze customer purchase behavior.

Optimized SQL queries using Window Functions (RANK, PARTITION BY) to efficiently segment customer purchases.

Developed Python scripts for sales forecasting, improving promotional campaign effectiveness.

Conducted exploratory data analysis (EDA) using Python (Pandas, NumPy, Matplotlib).

Leveraged Snowflake cloud data warehouse, reducing data retrieval time by 40%.

Designed data modeling structures for product categorization and sales analysis, implementing fact-dimension tables for better query performance.

Developed DAX measures in Power BI to track sales trends and product performance in real-time.

Integrated Looker ML models to segment customer purchasing patterns, improving personalization strategies.

Deployed AWS Redshift-based ETL pipelines, optimizing data ingestion from various retail sources.

Created Excel macros for pricing analysis, streamlining competitor benchmarking.

Conducted A/B testing in Python, optimizing product pricing strategies.

Built Alteryx workflows for automating data cleansing, reducing manual effort by 50%.

Managed Google BigQuery datasets, optimizing query performance and reducing storage costs.

Designed Azure Data Factory pipelines for seamless integration of online and offline sales data.

Developed SAS-based statistical models to analyze the impact of promotions.

Managed version control for analytics scripts using Git to maintain code integrity and track changes.

Improved Databricks-based data pipelines, reducing compute costs by 20%.

Applied strong analytical thinking to develop insights for pricing and supply chain efficiency.

Environment: Power BI, Tableau, ETL Workflow, SQL, Python, Looker, Snowflake, Alteryx, AWS Redshift, DBT, Excel, A/B testing, SAS, Databricks, Google BigQuery, Azure Data Factory.

Data Analyst – ICICI Bank, Hyderabad, India Jan 2017 – March 2019

•Designed and implemented ETL pipelines to extract, transform, and load data from multiple sources into the data warehouse, improving processing time by 30%.

•Automated daily financial data ingestion from external sources, reducing manual intervention and minimizing errors.

•Optimized SSRS reports by indexing database queries, reducing report load time by 40%.

•Wrote complex SQL queries to analyze customer transactions and identify fraud patterns, aiding in fraud detection and prevention efforts.

•Developed automated Excel reports using VBA macros, saving analysts 10+ hours per week on repetitive data processing tasks.

•Performed pivot table analysis to uncover trends in customer behavior and present actionable insights to stakeholders.

•Utilized SAS for statistical analysis of customer spending habits, influencing marketing strategies for personalized banking offers.

•Managed data analytics projects in JIRA, tracking task progress, reporting bottlenecks, and ensuring timely delivery of insights.

•Collaborated with cross-functional teams to resolve data discrepancies and reporting issues, improving data accuracy by 20%.

•Developed SQL-based fraud detection queries, flagging suspicious transactions and reducing fraudulent activity by 15%.

Environment: SQL, SSIS, SSRS, Excel, VBA Macros, ET Pipelines, SAS, JIRA, ETL, Grafana, KPI Reporting, Data Modeling, Trend Analysis.

EDUCATION

Bhoj Reddy Engineering College June 2013 - Jul 2017

Bachelor of Technology, Computer Science, Hyderabad.

Contact this candidate