Senior BI Data Analyst & Data Engineer

SRIKANTH SARIPUDI

Senior Data Analyst Data Engineer BI & Cloud Analytics Expert

*****************@*****.*** • +1-940-***-**** • linkedin.com/in/srikanth-saripudi • United States (Open to Relocation)

PROFESSIONAL SUMMARY

Results-driven Senior Data Analyst & Data Engineer with 6+ years of experience architecting enterprise-grade data solutions across healthcare and financial services. Proven expertise in SQL Server, Snowflake, Azure (ADF, Blob Storage), AWS, Power BI, and Tableau. Delivered measurable business impact: reduced ETL processing times by 30%, improved query performance by 40-50%, cut manual reporting effort by 60%, and maintained 99.9% data accuracy across 2M+ daily patient records. Deep experience in HIPAA, Basel III, AML, and KYC compliance. Skilled in T-SQL, Python, SSIS, data warehousing, and Generative AI integration. Passionate about transforming raw data into actionable insights that drive operational efficiency and strategic decisions.

CERTIFICATIONS

Microsoft Certified: Azure Data Engineer Associate (DP-203) – Microsoft

Microsoft Certified: Power BI Data Analyst Associate (PL-300) – Microsoft

Microsoft Certified: Azure Fundamentals (AZ-900) – Microsoft

TECHNICAL SKILLS

Languages & Querying

SQL (T-SQL, PL/SQL), Python (Pandas, NumPy, Scikit-learn, Matplotlib), DAX, MDX, Bash

Databases & DW

MS SQL Server (2012–2022), PostgreSQL, MySQL, Snowflake, Oracle, Azure Synapse Analytics, Redshift

Cloud Platforms

Microsoft Azure (ADF, Blob Storage, Synapse, Data Lake Gen2, Azure SQL, Azure DevOps), AWS (S3, Glue, Redshift, Lambda), Databricks

ETL / ELT Tools

SSIS, Azure Data Factory (ADF), AWS Glue, Databricks Pipelines, Informatica, dbt

BI & Visualization

Power BI (DAX, Power Query, Row-Level Security, Dataflows), Tableau, SSRS, Excel (Advanced: Pivot Tables, VBA, Power Query)

Data Modeling

Star Schema, Snowflake Schema, Kimball Methodology, Dimensional Modeling, OLAP Cubes (SSAS)

DevSecOps & Tools

Git, GitHub, Azure DevOps, JIRA, ServiceNow, SQL Server Management Studio (SSMS), Visual Studio, Postman

AI & Advanced Analytics

Generative AI (Python), Predictive Modeling, Customer Churn & Credit Scoring, Statistical Analysis, Anomaly Detection

Compliance & Governance

HIPAA, Basel III, AML, KYC, MAS Regulatory Standards, Data Quality Frameworks, Master Data Management (MDM)

Performance Tuning

Index Tuning, Execution Plan Analysis, Query Optimization, Partitioning, Columnar Storage, Caching Strategies

PROFESSIONAL EXPERIENCE

Senior Data Analyst – Kettering Health Jan 2024 – Present

Miamisburg, OH

•Architected and deployed production-grade SSIS ETL pipelines integrating Epic Clarity, Lawson ERP, and Cerner EHR into a centralized SQL Server data warehouse — processing 2M+ patient records daily with 99.9% data accuracy and zero critical pipeline failures over 12 months.

•Achieved 40% query performance improvement across complex healthcare analytics workloads through systematic index tuning, execution plan analysis, T-SQL refactoring, and query rewrite strategies — reducing average report generation time from 8 minutes to under 5 minutes.

•Automated data reconciliation and validation workflows, eliminating 30% of manual effort (saving 120+ engineering hours/month) and enabling real-time dashboard refreshes for clinical and financial decision-makers.

•Engineered and published 15+ SSRS and Power BI dashboards tracking patient outcomes, hospital readmission rates, bed utilization, and revenue cycle KPIs supporting $100M+ annual healthcare operations — reducing ad-hoc reporting requests by 45%.

•Designed and implemented a data quality validation framework with automated anomaly detection across all HIPAA-regulated data pipelines, achieving 100% compliance coverage and eliminating data integrity issues flagged in prior audit cycles.

•Collaborated cross-functionally with clinical informatics, finance, and operations teams to translate complex business requirements into scalable data models and self-service BI solutions, cutting data turnaround time from 3 days to same-day delivery.

•Maintained comprehensive data lineage documentation, data dictionaries, and pipeline metadata for all warehouse objects — ensuring full auditability for Joint Commission and internal compliance reviews.

•Proactively monitored ETL job schedules and resolved 50+ pipeline incidents in ServiceNow, maintaining 99.5%+ SLA for data availability and integrity across all hospital departments.

Environment: MS SQL Server, SSIS, SSRS, Power BI, Epic Clarity, Cerner, Lawson ERP, T-SQL, Python, Azure Blob Storage, Git, ServiceNow, JIRA, HIPAA.

Senior Data Analyst – Capgemini Apr 2021 – Jul 2023

India (Remote – US Clients)

•Engineered end-to-end ETL/ELT pipelines for 3 major business units (Reyes Beverage, Coca-Cola Bottling, Reyes Holdings), migrating 50+ TB of historical and transactional data from SQL Server to Snowflake via Azure Data Factory — completing on schedule with zero data loss.

•Designed scalable star-schema and snowflake-schema data models in Snowflake supporting supply chain, sales, and distribution analytics for 3 enterprise clients — reducing data redundancy by 35% and improving query response times by 50%.

•Built 20+ executive Power BI dashboards with Row-Level Security (RLS), DAX measures, and automated dataflows — delivering real-time KPIs for inventory, sales velocity, and distribution logistics to 200+ business users across multiple time zones.

•Developed a Generative AI solution using Python (OpenAI API + SQL) that automated root-cause analysis of data anomalies, achieving 30% improvement in data processing efficiency and reducing manual investigation time from 4 hours to under 30 minutes per incident.

•Monitored and maintained 15+ data pipelines in Azure Data Factory with proactive alerting, resolving 200+ ServiceNow incidents and maintaining 99.5% SLA for data availability and integrity across all client environments.

•Implemented incremental load strategies and partition pruning in Snowflake, reducing pipeline runtime by 40% and cutting cloud compute costs by approximately $15K/year per client.

•Collaborated with onshore/offshore Agile teams in 2-week sprint cycles, delivering data engineering tasks on time with 95%+ sprint velocity and participating in daily standups, sprint planning, and retrospectives.

•Created comprehensive data governance documentation including data dictionaries, lineage maps, and SLA agreements, ensuring consistent data definitions across all 3 client organizations.

Environment: Snowflake, Azure Data Factory, Azure Blob Storage, Azure Data Lake Gen2, SQL Server, Power BI (DAX, RLS, Dataflows), Python, Generative AI, SSIS, Git, Azure DevOps, ServiceNow, Databricks.

Data Analyst – DBS Bank Jan 2020 – Apr 2021

Maharashtra, India

•Built and maintained automated ETL workflows integrating 5+ core banking systems (Core Banking, Credit Card, CRM, Trade Finance, Loan Origination) into a centralized data warehouse supporting 5M+ customer accounts — reducing data latency from 24 hours to 4 hours.

•Optimized 100+ critical SQL queries and implemented indexing strategies, reducing average execution time by 50% for financial reporting, risk analytics, and regulatory submissions — enabling overnight batch jobs to complete within SLA windows.

•Designed and delivered Tableau and Power BI dashboards for Basel III capital adequacy, AML transaction monitoring, and KYC compliance — meeting MAS (Monetary Authority of Singapore) regulatory standards and passing 2 consecutive annual compliance audits.

•Automated monthly and quarterly financial reporting processes (P&L, risk exposure, liquidity ratios), reducing manual effort by 60% (saving 80+ hours/month) and enabling self-service analytics for business users across risk, treasury, and retail banking.

•Developed Python-based predictive ML models for customer churn prediction and credit risk scoring using logistic regression, random forest, and gradient boosting — improving targeting accuracy by 25% and reducing NPL (non-performing loan) provisioning errors by 15%.

•Partnered with risk management, compliance, and retail banking teams to define data requirements, validate model outputs, and present analytical findings to senior stakeholders including C-suite leadership.

•Maintained data integrity across all regulatory reporting pipelines with automated reconciliation checks, zero regulatory filing errors, and full audit trail documentation for all Basel III and AML submissions.

Environment: MS SQL Server, PostgreSQL, SSIS, Power BI, Tableau, Python (Pandas, Scikit-learn), T-SQL, Azure, Oracle, Excel (Advanced), Git, MAS/Basel III/AML/KYC Compliance.

EDUCATION

Master of Science – Data Science

University of North Texas, Denton, TX

Bachelor of Engineering – Mechanical Engineering

Sathyabama Institute of Science & Technology, Chennai, India

CORE COMPETENCIES

ETL/ELT Pipeline Architecture • Data Warehousing (Snowflake, SQL Server, Synapse) • Cloud Analytics (Azure, AWS, Databricks) • Power BI & Tableau Dashboard Development • T-SQL & Python Data Engineering • Query Optimization & Performance Tuning • Data Governance & MDM • HIPAA / Basel III / AML / KYC Compliance • Generative AI & Predictive Modeling • Self-Service BI Enablement • Dimensional Data Modeling • Cross-functional Stakeholder Communication • Agile / Scrum • Root Cause Analysis

Contact this candidate