Data Analyst Power Bi

RAJ KUMAR BADAVATH

Business Data Analyst

NJ, USA +1-201-***-**** *******************@*****.*** LinkedIn SUMMARY:

Insight-oriented Data Analyst with 3+ years of cross-functional experience in driving data-led decisions through a blend of analytical rigor, business acumen, and storytelling. Specialized in building scalable dashboards, translating complex data into clear narratives, and uncovering hidden patterns across healthcare, finance, and operations. Skilled in SQL, Python, Power BI, Tableau, and Excel, with hands-on experience in agile teams, UAT, and data governance. Recognized for simplifying ambiguity, optimizing workflows, and aligning analytical output with strategic goals and compliance frameworks. TECHNICAL SKILLS:

Data Querying & Databases SQL (PostgreSQL, MySQL, SQL Server, NoSQL), PL/SQL, Snowflake SQL Data Handling & Cleaning Microsoft Excel (Advanced: Power Query, Pivot Tables, VBA), Google Sheets, OpenRefine, Power Automate Data Visualization & BI Power BI, Tableau, Looker Studio, Google Data Studio, Qlik Sense, Excel Dashboards Programming for Analysis Python (pandas, NumPy, matplotlib, seaborn, scikit-learn), R Statistical & ML Tools R, Python (statsmodels, SciPy), Regression, Clustering, A/B Testing, Hypothesis Testing ETL & Data Integration Alteryx, Talend, Informatica, Apache NiFi, dbt (Data Build Tool), Power Query, AWS Glue Cloud Platforms AWS (S3, Glue, Athena, Redshift, Lambda), Google Cloud Platform (BigQuery, Cloud Storage) Workflow Automation Power Automate, Zapier, Apache Airflow (basic), Cron Jobs Data Warehousing Snowflake, Amazon Redshift, Google BigQuery, Azure Synapse Documentation & Reporting MS Word, Excel, PowerPoint, Lucidchart, Visio, Google Workspace, Confluence Agile & SDLC Tools JIRA, Confluence, Trello, Asana, Monday.com, BRD/FRD creation, User Stories Version Control Git, GitHub, GitLab (for collaboration with dev teams) EDUCATION:

Master’s in Business Analytics Jan 2024 - March 2025 Sacred Heart University, Fairfield, US

Bachelors in Electrical and Electronics Engineering Aug 2019 - May 2023 NIT Andra Pradesh, India

PROFESSIONAL EXPERIENCE:

Business Data Analyst Dec 2024 - Present

Tenet Healthcare, USA

Developed and optimized SQL queries involving joins, CTEs, and window functions to extract, transform, and validate healthcare and financial data from PostgreSQL, and SQL Server. Built advanced Excel dashboards with Power Query, pivot tables, slicers, and VBA macros for budgeting, forecasting, and variance analysis.

Followed SDLC principles to manage the end-to-end lifecycle of reporting and analytics solutions—requirement gathering, development, QA/UAT, and deployment; Used Python (Pandas, NumPy, Matplotlib) to analyze trends in healthcare costs, claim denial patterns, and utilization efficiency.

Collaborated with ETL developers to embed SQL logic into data pipelines for efficient processing; Shared Excel-based models with leadership for interactive financial planning and resource allocation.

Automated delivery of weekly and monthly reports through BI tools and email scheduling; Assisted in preparing data for ML models used in predicting patient readmissions and financial fraud detection.

Used Python (Pandas, NumPy, Scikit-learn) to clean, transform, and engineer features from clinical and claims data; Supported collaboration with data scientists on model evaluation, training pipelines, and performance tuning.

Worked with large-scale healthcare datasets processed via Hadoop MapReduce for batch data analysis; Integrated MapReduce outputs into dashboards for population health and treatment outcome reporting.

Used AWS S3 to store and manage large datasets securely, supporting data retrieval for dashboards and reporting tasks across departments; Queried data using AWS Athena and processed files with AWS Glue, helping automate ETL workflows and reduce manual data preparation time.

Used shell scripting in Linux/Unix environments for automating ETL workflows, scheduling jobs (cron), and performing system-level data validation; Managed log files, file transfers, and data ingestion tasks for secure financial and EHR systems.

Supported production and UAT deployments by validating data flow and troubleshooting script issues; Aligned deliverables with sprint goals and contributed to velocity improvements through backlog grooming.

Integrated Snowflake with BI tools like Power BI and Tableau to enable real-time KPI dashboards; Configured virtual warehouses for cost-efficient query execution and concurrency; Supported role-based access and data masking policies to ensure HIPAA and SOC 2 compliance. Data Analyst Nov 2020 - July 2023

Accenture, India

Wrote optimized SQL queries with joins, window functions, and CTEs in PostgreSQL, Oracle, and Snowflake to extract, clean, and validate large-scale financial data for regulatory reporting and dashboards.

Automated financial reconciliation processes and data validation tasks, reducing manual effort and increasing accuracy; Used conditional formatting and lookup functions (VLOOKUP, INDEX-MATCH, IF statements) to support audit-ready reports. Built ETL workflows using PostgreSQL procedures to load, cleanse, and structure claims and billing data for analysis.

Documented ML workflows and provided insights into feature importance and model interpretability; Collaborated with data engineers to optimize MapReduce jobs and reduce processing time.

Created impactful presentations combining Power BI, Tableau, and Excel visuals for quarterly reviews and strategy sessions; communicated financial trends, compliance risks, and operational gaps to executive teams.

Connected Power BI and Tableau to AWS Redshift to build interactive dashboards for business reporting and performance tracking; automated daily data pipelines using AWS Lambda and AWS Glue, enabling faster access to updated insights without manual intervention.

Maintained detailed documentation (BRD, FRD, change logs) to support audit and change management processes; ensured traceability from business needs to delivered dashboards and validated them through UAT.

Analyzed transaction-level banking data to detect anomalies and identify fraudulent patterns, collaborating with compliance teams to strengthen risk management strategies and support regulatory audits.

Created cash flow and liquidity monitoring reports by integrating multiple data sources including general ledger, treasury systems, and customer account data, enabling treasury teams to optimize capital allocation and meet reserve requirements.

Collaborated with ML teams on basic data preprocessing, model scoring, and insight generation; Used DAX for building calculated measures, time intelligence, and advanced slicers. Scheduled report refreshes via Power BI Gateway and enabled row-level security for different user groups.

Used storytelling techniques and data visualization to simplify complex analysis for non-technical stakeholders; Integrated SDLC checkpoints into BI tool deployment workflows using Confluence and versioning systems; automated data cleansing pipelines to prepare structured data for reporting and modeling. PROJECTS:

Credit Card Approval (Python, Machine Learning)

Built ML models (Logistic Regression, Decision Tree, XG Boost) in Python to predict credit approvals, boosting accuracy from 49% to 82%. Selected XG Boost(F1-score:0.83) for deployment; visualized insights via bar plots, heatmaps and scatter plots

Profit Trends Visualization Project (Tableau, Python) Analyzed 9.9K+ sales records using pandas and seaborn to visualize profit trends across regions, categories, and time. Created Tableau dashboards with filters and tooltips to enhance stakeholder insights

Global Supply Chain Optimization

Developed an inventory optimization model using correlation analysis to minimize costs and enhance decision-making. Visualized demand patterns using Python (matplotlib, pandas)

CERTIFICATIONS:

• Python for Data Science — NPTEL (IIT Madras), Score: 84%

• Databases and SQL for Data Science with Python — IBM/Coursera

Contact this candidate