Data Analyst - Finance & Healthcare Analytics

Sudarshan Jn Rao

DATA ANALYST

Herndon, VA 571-***-**** **************@*****.*** LinkedIn

SUMMARY

● Experienced Data Analyst with 3+ years in financial and healthcare analytics, specializing in designing, developing, and optimizing end-to-end data pipelines and reporting solutions.

● Skilled in extracting, transforming, and validating complex datasets from multiple sources using SQL, Python, and ETL tools to ensure data accuracy and reliability.

● Developed and maintained advanced reporting frameworks, dashboards, and visualizations using Tableau and Power BI to provide actionable insights for business, finance, and operations teams.

● Proficient in translating business requirements into technical solutions by collaborating with stakeholders, product managers, and QA teams in Agile environments.

● Expertise in revenue cycle, clinical quality, and operational analytics within EHR and Practice Management systems, including building SQL reporting views and Python-based analysis workflows.

● Adept at designing and implementing data validation, reconciliation, and exception reporting processes to maintain data integrity across financial and healthcare systems.

● Strong knowledge of business intelligence, data modeling, and statistical analysis techniques, including trend analysis, cohort analysis, and performance monitoring.

● Experienced in documenting technical specifications, business rules, and report logic to support knowledge transfer, cross-functional collaboration, and streamlined project delivery.

SKILLS

Methodologies: SDLC, Agile, Waterfall

Data Analysis: Exploratory Data Analysis (EDA), Descriptive & Inferential Statistics, Hypothesis Testing, ANOVA, Regression Analysis, Statistical Analysis, Data Mining, Data Cleaning, ETL Processes, Quantitative Analysis, A/B Testing, Cohort Analysis, Funnel Analysis Programming Language: Python, SQL, R

Packages: NumPy, Pandas, Matplotlib, SciPy, Scikit-learn, TensorFlow, Seaborn, dplyr, ggplot2 Data Visualization: Tableau (Interactive Dashboards, Calculated Fields, LOD Expressions), Power BI (DAX, Power Query, Data Modeling), Advanced Excel (Pivot Tables, Power Pivot, VBA Macros, VLOOKUP/XLOOKUP), SRSS

IDEs: Visual Studio Code, PyCharm, Jupyter Notebook, IntelliJ Database and Data Warehousing: MySQL, PostgreSQL, SQL Server, Oracle, MongoDB, Amazon Redshift Cloud Platform: Amazon Web Services (AWS), Snowflake Other Technical Skills: SSIS, SAS, Machine Learning Algorithms, ETL\ELT Tools, Apache Airflow, dbt, Data Wrangling, Data Cleaning, Data Transformation, Data Warehousing, Data Lakes, Data Storytelling, Technical Documentation, Cross-functional Collaboration, KPI Development, Metric Definition, Business Requirements Analysis, Executive Reporting, Requirements Gathering, Data Storytelling, Data Governance, Data Privacy, Financial Reporting, Sales & Marketing Analytics, JIRA, Confluence, Trello, Git, GitHub Soft Skills: Time Management, Leadership, Strategy Planning, Problem-Solving, Negotiation, Decision- Making, Documentation and Presentation, Analytical Thinking, Attention to Detail, verbal and written communication

WORK EXPERIENCE

Goldman Sachs Virginia, USA

Data Analyst Dec 2023 – Present

● Built a centralized reporting foundation for Global Markets by writing advanced SQL queries on trade, booking, and market pricing tables, creating a consistent source of truth for daily P&L and exposure reporting across trading desks.

● Developed Python (pandas) data transformation scripts to clean raw trade data, standardize instrument identifiers, handle currency normalization, and align booking hierarchies, improving the accuracy and consistency of P&L attribution outputs.

● Implemented Python-based data validation and reconciliation checks to compare source-level trade counts and key aggregates with transformed datasets, reducing data issues reaching business dashboards by approximately 35%.

● Designed and maintained Power BI data models aligned with Global Markets reporting requirements, ensuring correct relationships, aggregations, and performance at desk, product, and firm levels.

● Created Power BI DAX measures to calculate daily P&L movement, net and gross exposure, and rolling performance trends, allowing stakeholders to drill into results and quickly identify performance drivers.

● Improved report reliability and performance by refining SQL logic and Power BI refresh configurations, reducing dataset refresh times by around 45% and supporting same-day (T+0) reporting expectations.

● Worked closely with traders, risk managers, and operations teams to clarify metric definitions and translate business logic into SQL- based calculations, increasing trust in reported numbers and reducing follow-up questions.

● Migrated recurring Global Markets reports from manual Excel distribution to Power BI Service, standardizing report access and reducing daily reporting effort by about 60% across business and operations teams.

● Leveraged GenAI-assisted tools to accelerate SQL query optimization, support documentation of complex transformation logic, and assist in identifying recurring data anomalies, reducing development and investigation time by approximately 20%.

● Performed ad-hoc analysis using SQL during periods of market volatility to investigate unexpected P&L and exposure movements, helping business stakeholders understand drivers and take timely action. NextGen Healthcare India

Data Analyst Jul 2020 – Jan 2022

● Worked on clinical and financial reporting for NextGen’s EHR and Practice Management platforms, supporting outpatient practices with analytics on patient encounters, billing, claims, and reimbursements.

● Pulled and combined data from core EHR and PM tables using SQL Server, including encounters, procedures, diagnoses, charges, claims, and payments, handling close to one million records per month.

● Created structured SQL reporting views to standardize key metrics such as billed amount, allowed amount, payments, and outstanding balances, ensuring consistent reporting across more than 20 client practices.

● Developed SQL-based reports to track Accounts Receivable aging, claim status, and days in A/R, helping billing teams focus on delayed claims and improve overall collection timelines.

● Analyzed claim and remittance data at the payer level using SQL to identify frequent denial reasons and recurring billing issues, contributing to a measurable reduction in repeat claim denials.

● Used Python (pandas) to study trends in patient visit volumes and visit types over time, which supported operational teams in adjusting provider schedules and managing appointment backlogs.

● Implemented logic for clinical quality reporting by translating EHR documentation workflows into measurable indicators such as preventive screenings and chronic care follow-ups, improving data completeness and reporting accuracy.

● Built Tableau dashboards connected directly to SQL reporting tables, allowing practice managers and internal teams to view financial and clinical performance without relying on static reports.

● Performed routine data validation and reconciliation by comparing source EHR data with reporting outputs, identifying gaps such as missing encounters or unmatched charges and reducing reporting discrepancies.

● Prepared Excel-based audit and exception reports during monthly close cycles to highlight billing gaps and incomplete records, supporting finance and compliance reviews.

● Worked closely with product managers and QA teams in an Agile environment, reviewing requirements, validating report logic during testing, and addressing data issues before client releases.

● Documented report definitions, business rules, and data dependencies to support knowledge transfer and reduce follow-up queries from internal and client teams.

EDUCATION

Master of Science in Information Systems

University of Maryland Baltimore County, Baltimore, MD, USA Bachelor of Technology in Information Science

Visvesvaraya Technological University, India

CERTIFICATIONS

● AWS Certified Solutions Architect - Associate

Contact this candidate