Data Analyst Power Bi

Data Analyst with over * years of experience across healthcare, finance, and retail domains. I specialize in data analysis using Python, SQL, and R, and have built scalable ETL pipelines using SSIS, Azure Data Factory, and AWS Glue. My expertise includes EHR/EMR data, healthcare claims, and financial reporting, ensuring HIPAA compliance and performance optimization. I create interactive dashboards using Power BI and Tableau, and apply statistical methods like regression, ANOVA, and A/B testing. I’ve worked extensively on cloud platforms like AWS, Azure to deliver secure, analytics-driven solutions. Data Analyst Best Buy, Minneapolis, MN Sept 2024 – Present

● Processed 2M+ retail transactions using SQL and Python to identify purchasing trends and optimize inventory, improving stock turnover and reducing excess by 15%.

● Designed and maintained enterprise-wide data models and ER/class diagrams using Erwin Data Modeler and Visio; performed complex data mapping with SQL to integrate systems across WMS, OMS, POS, and e-commerce platforms.

● Built and maintained ETL pipelines using Informatica and IBM DataStage to transform and load data from MySQL, SQL Server, and Oracle into enterprise data warehouses for scalable analytics solutions.

● Built interactive dashboards using Tableau and Power BI to visualize KPIs, customer behavior, and sales trends, accelerating data-driven decisions across marketing, inventory, and operations teams.

● Conducted A/B testing and regression analysis to evaluate campaign performance, leading to an 18% increase in conversion rates through data-driven marketing decisions..

● Analyzed customer feedback using AWS Comprehend to extract sentiment, key phrases, and topics, uncovering insights that improved customer satisfaction and informed product enhancement strategies. Programming Languages Python, SQL, R.

Libraries & Packages Pandas, NumPy, Matplotlib, Seaborn, SciPy, Scikit-learn, TensorFlow, dplyr, ggplot2 Statistical & ML Methods Regression (Linear, Logistic), ANOVA, Hypothesis Testing, Clustering, Classification, Forecasting, A/B Testing, Confidence Intervals

Data Visualization Power BI, Tableau, Advanced Excel (PivotTables, VLOOKUP), ggplot2, Matplotlib, Seaborn Databases SQL Server, MySQL, PostgreSQL, Oracle, MongoDB, Amazon S3 ETL & Data Pipelines SSIS, SSRS, Azure Data Factory, AWS Glue, Custom Python ETL Scripts, ELT/ETL Tools Cloud Platforms AWS (S3, Redshift, Glue), Microsoft Azure, Google Cloud Platform Data Management Data Warehousing, OLAP & OLTP, Data Transformation, Data Governance, Data Integration, Data Storytelling Analytics Techniques Exploratory Data Analysis (EDA), Descriptive & Predictive Analytics, Data Wrangling, Data Cleaning Development Tools & IDEs Jupyter Notebook, Visual Studio Code, PyCharm, IntelliJ Version Control & CI/CD Git, GitHub, Jira

Healthcare Standards ICD-10, CPT, HL7, FHIR (domain-level knowledge), HIPAA Compliance Soft Skills Analytical Thinking, Time Management, Leadership, Documentation & Presentation, Communication, Strategy Planning

● Ensured data governance and integrity using Collibra by defining data lineage, enforcing standards, and improving cross-team consistency and audit readiness.

● Managed cloud-based data workflows using AWS S3 and Azure Blob Storage, improving data availability and cost efficiency by 30% while ensuring secure operations across retail analytics pipelines.

● Implemented Git-based version control and CI/CD automation for seamless deployment of analytics products across staging and production.

Healthcare Data Analyst ( Medica) GlobalLogic, Hyderabad, India Jan 2021 - may 2023

● Analyzed large-scale healthcare claims and EHR datasets using SQL and Python (Pandas, NumPy, Matplotlib) to identify service utilization trends, treatment outcomes, and cost variances across provider networks.

● Developed interactive Power BI dashboards to visualize KPIs such as patient readmission rates, length of stay (LOS), and procedure-level cost drivers, supporting hospital performance reviews and payer negotiations.

● Collaborated with product and clinical teams to map data to industry standards (ICD-10, CPT, DRG) and ensure consistency for downstream analytics and regulatory reporting.

● Built ETL pipelines in Azure Data Factory and SSIS to integrate EMR data with claims datasets, reducing ingestion and transformation time by 30%.

● Applied hypothesis testing, logistic regression, and correlation analysis using SAS and Python to identify clinical risk factors and patient stratification cohorts.

● Ensured HIPAA compliance by implementing PHI masking, access auditing, and encryption across analytics environments hosted on AWS S3, Redshift, and Azure SQL.

● Supported integration of third-party telehealth and RPM data into central analytics systems to monitor post-discharge patient adherence and flag early warning indicators.

● Participated in Agile ceremonies and contributed to healthcare-focused sprint deliverables, collaborating across IT, clinical, and business analyst teams to align use cases with patient care goals. Financial Data Analyst (Broadridge) GlobalLogic, Hyderabad, India Aug 2018 - Jan 2021

● Delivered $100K+ in annual cost savings, reduced reporting time by 40%, and accelerated monthly close by 3 days through automation, advanced analytics, and data pipeline optimization.

● Performed exploratory data analysis (EDA) using Python (Pandas, NumPy, Matplotlib) to identify revenue trends, detect anomalies, and support quarterly forecasting and budgeting.

● Wrote advanced SQL queries to extract, clean, and transform financial and transactional data from MySQL/PostgreSQL and cloud sources, ensuring high data quality and integrity.

● Built automated dashboards in Tableau, reducing manual reporting time by 40% and improving visibility into cost center performance and budget variance.

● Developed interactive Tableau dashboards with drill-down filters and KPI visualizations, enabling executive-level decision-making and department-level insights.

● Collaborated with finance, operations, and IT to define reporting requirements, align KPIs, and deliver scalable financial analytics solutions.

● Conducted root cause analysis and led gap analysis initiatives to resolve delays in monthly financial closes, enhancing accuracy and reporting speed.

● Integrated financial data pipelines using Snowflake and AWS Redshift to enhance scalability, performance, and support high-volume financial reporting and analysis.

● Applied statistical techniques to evaluate performance metrics, uncover cost-saving opportunities, and monitor budget adherence across departments.

● Operated in an Agile environment, contributing to sprint deliverables and ensuring timely delivery of analytics solutions.

Master of Science in Business Analytics Northwood University, Midland, MI, USA. Bachelor of Technology in Computer Science GITAM University, Hyderabad, India. AWS Cloud Practitioner Essentials AWS Certified Cloud Practitioner Google Data Analyst Professional.

Contact this candidate