Senior Data Analyst - 9+ Years in Healthcare, Government, Retail

NAME: Chandu N

Phone: +1-669-***-****

Email: ********@*****.***

PROFESSIONAL SUMMARY

Senior Data Analyst with 9+ years of experience delivering data-driven insights across healthcare, government, and large-scale retail environments. Proven expertise in analyzing complex datasets, building reliable dashboards, and translating business and regulatory requirements into actionable metrics that support executive decision-making.

Highly skilled in SQL, Power BI, Tableau, and Excel, with a strong focus on data quality, validation, and governance. Experienced in working with cross-functional stakeholders, supporting compliance and audit-driven reporting, and driving automation to improve reporting accuracy and turnaround time. Recognized for clear communication, analytical rigor, and the ability to bridge technical data with real business outcomes.

Senior Data Analyst with 9+ years of experience delivering advanced analytics, enterprise reporting, and dashboard solutions across healthcare, public-sector, and retail domains.

Senior Data Analyst with 9+ years of experience delivering advanced analytics, enterprise reporting, and dashboard solutions across healthcare, public-sector, and retail domains.

Extensive experience analyzing large, complex datasets to identify trends, performance gaps, compliance risks, and actionable business insights supporting operational and regulatory decision-making.

Senior Data Analyst with 9+ years of experience delivering advanced analytics, enterprise reporting, and dashboard solutions across healthcare, public-sector, and retail domains.

Strong expertise in advanced SQL development (joins, CTEs, window functions, aggregations, performance tuning) for large-scale relational databases including SQL Server, Oracle, PostgreSQL, and exposure to Teradata data warehouse environments.

Proven experience designing, developing, and maintaining enterprise dashboards using Power BI (data modeling, DAX, performance optimization) and Tableau, aligned with data visualization best practices and executive reporting standards.

Hands-on experience supporting legacy and enterprise reporting platforms, including SAP BusinessObjects and structured reporting environments, ensuring accurate and audit-compliant report delivery.

Practical experience developing and optimizing ETL/ELT workflows using Azure Data Factory and AWS-based services (S3, Glue, Lambda, Redshift), supporting scalable cloud-native data solutions.

Experience working with AWS analytics ecosystem (S3, Redshift, Glue, EMR exposure, SageMaker fundamentals) to support modern data pipelines, advanced analytics, and cloud migration initiatives.

3+ years of experience using Python and PySpark for data transformation, automation, and analytical data processing within cloud and distributed environments.

Experience designing structured data pipelines ensuring data quality, validation, reconciliation, governance, and compliance across distributed systems.

Strong understanding of data warehouse concepts including star schema, dimensional modeling, fact/dimension design, and source-to-target mapping.

Experience creating optimized queries for business intelligence and ad-hoc analysis, including exposure to enterprise BI query tools in structured reporting environments.

Proven ability to collaborate with data architects, engineers, business analysts, and application teams to translate business requirements into scalable reporting and analytics solutions.

Strong background in healthcare and public-sector reporting, ensuring adherence to HIPAA, compliance standards, audit requirements, and state-level governance policies.

Experience supporting Agile delivery environments and participating in sprint planning, backlog refinement, and DevOps-aligned release cycles.

Demonstrated expertise in performance tuning dashboards and reports, troubleshooting data inconsistencies, and improving report efficiency and refresh cycles.

Strong documentation skills including data dictionaries, reporting specifications, ETL mapping documents, and governance artifacts.

Effective communicator with the ability to present complex analytical findings to technical and non-technical stakeholders, executive leadership, and compliance teams.

Recognized for attention to detail, critical thinking, proactive problem-solving, and ability to manage multiple priorities in large-scale government environments.

TECHNICAL SKILLS

Category

Skills / Technologies

Data Analysis & Querying

Advanced SQL (joins, CTEs, subqueries, aggregations, window functions, performance tuning), complex data extraction & transformation, trend & variance analysis, large dataset analytics, KPI development

Databases & Data Warehousing

SQL Server, Oracle, Teradata Data Warehouse, PostgreSQL, MySQL, relational database design, dimensional modeling (fact/dimension), star schema concepts

Business Intelligence & Reporting

Power BI (data modeling, DAX, performance optimization, drill-through dashboards), SAP BusinessObjects (enterprise reporting), Crystal Reports, Tableau, Hummingbird BI/Query (exposure), Microsoft Excel (advanced formulas, PivotTables, Power Query)

Cloud & Data Engineering (AWS Focused)

Amazon S3, Redshift, Glue, Lambda (analytics support), EMR (exposure), Kinesis (conceptual exposure), SageMaker (analytics support), cloud-based data processing workflows

ETL / ELT & Data Integration

ETL/ELT workflow support, data pipeline validation, source-to-target mapping, data transformation logic, Azure Data Factory, AWS Glue, data lake concepts

Programming & Distributed Processing

Python (data analysis, automation), PySpark (data transformation & distributed processing), data structures fundamentals, JSON/CSV processing

Data Governance & Compliance

Data validation & reconciliation, audit-ready reporting, regulatory reporting, data traceability, data quality controls, HIPAA-aligned governance, state compliance standards

AI & Advanced Analytics Support

Support for cloud-native analytics platforms, ML dataset preparation, structured data preparation for AI/ML initiatives

Tools & Collaboration

Git (GitHub, Bitbucket), JIRA, PowerPoint, Agile documentation tools

Methodologies

Agile / Scrum, Hybrid delivery models, DevOps collaboration exposure

Domain Experience

Healthcare analytics (HIPAA-compliant), Public Sector & Government reporting, Regulatory & legislative reporting, Retail & Supply-chain analytics

PROFESSIONAL EXPERIENCE

Client: Maximus Health – Reston, VA. Aug 2023 – Present

Role: Sr Data Analyst

Supporting large-scale healthcare and public health programs by delivering enterprise reporting, advanced analytics, and cloud-enabled data solutions. Working closely with healthcare operations, compliance, data engineering, and leadership teams to analyze complex datasets and build scalable reporting frameworks aligned with regulatory and governance standards.

Responsibilities:

Lead end-to-end data analysis and reporting initiatives, from business requirement gathering through dashboard development, validation, and executive presentation.

Analyze high-volume healthcare datasets including eligibility, enrollment, claims, utilization, and quality metrics to identify trends, performance gaps, and actionable insights.

Design, develop, and maintain interactive dashboards using Power BI (data modeling, DAX measures, drill-through capabilities, performance tuning) aligned with enterprise visualization best practices.

Develop and optimize advanced SQL queries (CTEs, window functions, aggregations, indexing strategies) across SQL Server and Oracle environments to support operational and regulatory reporting.

Create structured reporting datasets and reusable SQL views to standardize KPI calculations and improve reporting consistency across programs.

Support enterprise reporting modernization initiatives, including structured report migration and optimization within standardized BI environments.

Collaborate with data engineering teams supporting AWS-based data platforms (Amazon S3, Redshift, Glue) to validate datasets, refine transformations, and improve pipeline reliability.

Contribute to cloud-based ETL/ELT workflows, performing data validation and reconciliation on datasets processed through AWS services and enterprise data warehouses.

Utilize Python and PySpark for data transformation, exploratory analysis, and automation of recurring validation tasks within distributed data environments.

Ensure data quality, governance, and compliance by implementing reconciliation checks, traceability validation, and audit-ready documentation aligned with healthcare regulatory standards.

Partner with business and compliance stakeholders to translate regulatory reporting requirements into technical reporting specifications and measurable KPIs.

Support state and federal reporting mandates by ensuring accuracy, completeness, and documentation of data flows and reporting logic.

Perform performance tuning of dashboards and backend queries to improve refresh times and optimize report usability.

Participate in Agile/Scrum ceremonies, sprint planning, and backlog refinement to align analytics deliverables with evolving healthcare program priorities.

Provide technical troubleshooting support for reporting tools and assist in resolving discrepancies across distributed data sources.

Maintain documentation including data dictionaries, transformation logic, KPI definitions, and reporting standards to support governance and knowledge sharing.

Mentor junior analysts on SQL optimization, healthcare data interpretation, reporting standards, and data governance practices.

Ensure strict adherence to HIPAA, data privacy regulations, and enterprise access-control policies when handling sensitive health information.

Environment:

SQL Server, Oracle, Advanced SQL (CTEs, window functions, performance tuning), Power BI (DAX, data modeling), Tableau, AWS (S3, Redshift, Glue – analytics support), Python, PySpark, ETL/ELT workflows, healthcare data validation & reconciliation, KPI & regulatory reporting, Agile/Scrum, HIPAA-compliant data governance.

Client: state of Wisconsin – Madison, WI. Mar 2020 to Jul 2023

Role: Sr. Data Analyst

Served as a Senior Data Analyst supporting statewide public-sector analytics and enterprise reporting initiatives. Delivered large-scale data analysis, regulatory reporting, and dashboard solutions across multi-department programs. Partnered with program leadership, IT, and data warehouse teams to modernize reporting frameworks and improve data governance, accuracy, and transparency across state systems.

Responsibilities:

Led end-to-end data analysis and enterprise reporting initiatives, from requirements gathering and technical specification development to dashboard delivery and executive presentations.

Designed and optimized advanced SQL queries (CTEs, aggregations, window functions, indexing strategies) across SQL Server, Oracle, and Teradata data warehouse environments to analyze multi-year administrative and financial datasets.

Developed and maintained enterprise dashboards and KPI scorecards using Power BI and Tableau, aligning with data visualization best practices and statewide performance reporting standards.

Supported structured enterprise reporting environments, including SAP BusinessObjects and standardized BI query tools, ensuring consistent and validated data outputs for program oversight.

Created optimized data extracts and reporting datasets to support regulatory, legislative, and audit-driven reporting requirements.

Partnered with data warehouse and ETL teams to support data transformation processes, validation checks, and source-to-target mapping documentation.

Contributed to modernization efforts involving migration toward centralized BI platforms and enhanced reporting frameworks.

Collaborated with cloud enablement teams during early-stage adoption of AWS-based analytics services (S3 and Redshift exposure from 2021 onward) supporting scalable reporting datasets and centralized storage.

Conducted data reconciliation and validation across multiple source systems to ensure data integrity, traceability, and compliance with state governance standards.

Performed trend, variance, and budget analysis to identify operational inefficiencies, funding gaps, and resource allocation opportunities.

Supported development of reusable SQL views and standardized KPI logic to improve reporting consistency across departments.

Assisted in performance tuning of reports and backend queries to improve refresh times and optimize user experience.

Played a key role in enforcing data governance standards, documentation practices, and audit-ready reporting methodologies.

Documented data definitions, business rules, and transformation logic to ensure transparency and knowledge continuity.

Responded to urgent legislative and audit requests by performing deep-dive ad-hoc analysis on large-scale datasets.

Participated in Agile and hybrid project environments, aligning analytics deliverables with IT modernization initiatives.

Acted as liaison between technical teams and non-technical stakeholders, translating policy and operational requirements into structured reporting solutions.

Mentored junior analysts on SQL optimization, reporting best practices, and data validation techniques.

Ensured compliance with state privacy, security, and records retention policies when handling sensitive public-sector datasets.

Environment:

SQL Server, Oracle, Teradata Data Warehouse, Advanced SQL (CTEs, window functions, performance tuning), Power BI (data modeling, DAX), Tableau, SAP BusinessObjects (reporting exposure), Structured BI Query tools, AWS (S3, Redshift – analytics support from 2021+), ETL validation & source-to-target mapping, KPI & legislative reporting, Data governance & audit compliance, Agile/Hybrid collaboration.

Client: Autozone, Memphis, TN Nov 2017 – Feb 2020

Role: Data Analyst

supported enterprise retail and supply-chain analytics initiatives across large-scale automotive retail operations. Delivered structured reporting, dashboard development, and performance analysis solutions that supported merchandising, inventory optimization, pricing strategy, and executive decision-making across thousands of store locations.

Responsibilities:

Analyzed high-volume retail sales, inventory, and supplier datasets using advanced SQL to identify demand patterns, performance trends, and operational inefficiencies.

Developed and optimized complex SQL queries (joins, aggregations, subqueries, CTEs) within enterprise data warehouse environments to support recurring and ad-hoc reporting needs.

Designed and maintained operational dashboards using Power BI and Tableau, tracking KPIs such as sales velocity, stock-out rates, inventory turnover, margin trends, and regional performance metrics.

Supported structured enterprise reporting using SAP BusinessObjects and standardized BI query tools to generate validated reports for merchandising and operations leadership.

Partnered with merchandising and supply-chain teams to translate business requirements into measurable data metrics and reporting solutions.

Performed trend and variance analysis at store, regional, and product-category levels to identify underperforming segments and recommend corrective actions.

Supported pricing and promotional impact analysis by evaluating campaign effectiveness and revenue lift across product lines.

Conducted data reconciliation and validation across multiple transactional and warehouse systems to ensure reporting accuracy and data consistency.

Created reusable SQL views and reporting templates to standardize KPI calculations and reduce manual reporting effort.

Collaborated with IT and ETL teams to troubleshoot data discrepancies and improve source-to-report reliability within warehouse environments.

Assisted in inventory forecasting and replenishment analysis, contributing to improved inventory turnover and reduced stock-out scenarios.

Generated executive-ready reports and presentations supporting planning, budgeting, and operational reviews.

Documented data definitions, KPI logic, and reporting methodologies to support transparency and internal audit processes.

Participated in Agile/Scrum environments, aligning analytics deliverables with business priorities and technology releases.

Ensured adherence to enterprise data governance, access controls, and reporting standards when handling sensitive operational data.

Environment:

SQL Server, Oracle, Enterprise Data Warehouse, Advanced SQL (joins, aggregations, CTEs, performance tuning), Power BI, Tableau, SAP BusinessObjects (enterprise reporting), BI Query tools, Microsoft Excel (advanced formulas, PivotTables), Data validation & reconciliation, KPI & operational reporting, ETL collaboration, Agile/Scrum.

Client: Syntel Ltd, India Oct 2015 – June 2017

Role: Data Analyst

Worked as part of the analytics and reporting team supporting enterprise business units with operational reporting, data validation, and performance tracking initiatives. Contributed to standardized reporting frameworks and data quality improvements that enhanced transparency and reduced manual reporting effort.

Responsibilities:

Analyzed cross-functional business and operational datasets to identify trends, performance gaps, and efficiency improvement opportunities.

Developed and executed SQL queries (joins, aggregations, subqueries) across Oracle and SQL Server databases to support recurring weekly and monthly reporting cycles.

Generated structured operational reports and KPI summaries used by management for SLA tracking and performance monitoring.

Built standardized Excel-based dashboards using PivotTables, advanced formulas (VLOOKUP, INDEX/MATCH), and macros to automate reporting workflows.

Supported early-stage BI reporting initiatives, contributing to basic Tableau and Power BI dashboard development (2016–2017 timeframe).

Assisted in creating business performance scorecards tracking service metrics, operational turnaround times, and compliance indicators.

Performed data cleansing, validation, and reconciliation to ensure accuracy prior to report publication.

Collaborated with IT teams to troubleshoot data extraction issues and support enhancements to reporting datasets.

Documented SQL logic, KPI definitions, and reporting standards to promote consistency and team knowledge sharing.

Conducted ad-hoc analyses in response to stakeholder requests, translating business questions into structured data insights.

Supported month-end and quarter-end reporting by preparing variance analysis and summary tables.

Ensured adherence to internal data governance and security standards when handling sensitive business data.

Participated in Agile team meetings and planning sessions to align reporting deliverables with business priorities.

Environment:

Oracle, Microsoft SQL Server, SQL (joins, aggregations, subqueries), Microsoft Excel (PivotTables, macros, advanced formulas), Tableau (basic dashboards), Power BI (early exposure 2016+), MS Access, Data validation & cleansing, KPI reporting, Reporting automation, Agile collaboration.

EDUCATION

Siva Sivani Institute of Management India

Bachelor of Technology in Computer Science JULY 2015

Contact this candidate