Hello
English
Open to Opportunities

Where raw data becomes strategic intelligence.

I'm a Data Analyst|

Data That Drives
DECISIONS.

4 years of experience in Banking & Insurance domains, building cloud-native data pipelines and BI solutions on AWS · Azure · GCP. Based in Richmond, VA.

View My Work → Download Resume ↓
Scroll
Data Engineering & ETL⚡ Power BI & DAX Analytics⚡ Azure Data Factory⚡ AWS (S3, Glue, Lambda)⚡ GCP⚡ Python & Machine Learning⚡ Databricks⚡ SAS · Hive · Impala⚡ Teradata⚡ Tableau & Looker⚡ Data Governance⚡ Informatica IDQ⚡ Collibra & Erwin⚡ Terraform · CI/CD⚡ Predictive Modeling⚡
Abhishek V S
AWS Certified

About Me

Turning complexity
into clarity.

I'm a Data Analyst with 4+ years of hands-on experience across Banking and Insurance domains. From modernizing legacy warehouses to building cloud-native pipelines on AWS, Azure, and GCP, I help organizations move from scattered data to strategic insight.

Currently modernizing a legacy banking warehouse on Azure & AWS at ACNB Bank — processing 10M+ records daily.

Currently at ACNB Bank driving a full-scale data warehouse modernization — processing 10M+ records daily across 25+ source systems. M.S. Computer Science from Virginia Commonwealth University.

4+ Years Experience
10M+ Records / Day
3 Cloud Platforms
2 Domains
GitHub ↗ LinkedIn ↗ Email ↗

Expertise

What I do best.

01
Data Engineering & ETL
Building robust ETL pipelines and modernizing legacy data warehouses to scalable Azure Data Lake & AWS environments.
AWS S3 · Glue · Lambda · Azure Data Factory · GCP · Informatica IDQ/IICS · Teradata · SAS · Hive · Impala
02
BI & Analytics
Developing interactive dashboards, KPI scorecards, and advanced DAX-based analytics to enable data-driven decision-making.
Power BI · DAX · RLS · Tableau · Looker · Excel Modeling
03
AI/ML & Python
Supporting PoCs and automation of data workflows using Python, Pandas, NumPy, and scikit-learn across cloud-native ecosystems.
Python · scikit-learn · Databricks · Predictive Modeling
04
Data Governance & Modeling
Leading metadata management and governance practices using Erwin and Collibra within enterprise Data Lake architectures.
Erwin · Collibra · Data Lineage · Metadata Management

Selected Work

Projects I've built.

ESG Investment Risk Analytics
View Project ↗
Python CVXPY SHAP Finance
ESG Investment Risk Analytics

Portfolio optimisation with ESG constraints — Monte Carlo VaR/CVaR, carbon stranded asset sensitivity, and benchmark comparison (CAPM alpha/beta).
Hospital Readmission & SDOH Analytics
View Project ↗
Python Scikit-learn Survival Analysis Healthcare
Hospital Readmission & SDOH Analytics

SDOH-enhanced 30-day readmission model (AUC 0.71→0.81), fairness audit by insurance type, and policy simulation showing 4.2× ROI on care interventions.
Telematics & UBI Insurance Analytics
View Project ↗
Python Isolation Forest Streamlit Insurance
Telematics & UBI Insurance Analytics

Telematics GBT claim model (AUC 0.64→0.84), K-Means UBI pricing tiers, and Isolation Forest fraud detection with an interactive Streamlit investigation dashboard.

Experience

Where I've worked.

Aug 2025 – Present
Data Analyst
ACNB Bank · Gettysburg, PA

Legacy Data Warehouse → AWS & Azure Lakehouse Platform

  • Built ETL pipelines via Azure Data Factory & SSIS ingesting 10M+ records/day from 25+ source systems
  • Delivered Power BI dashboards for KPIs, loan performance, delinquency ratios & compliance metrics
  • Reduced reporting issues by 40% collaborating in Agile/Scrum with Data Architects & Engineers
Azure · AWS · Power BI · Synapse · Databricks · SQL
Jan 2021 – Jul 2024
Data Analyst
Q-Dat IT Solutions · Karnataka, India

Insurance Data Platform Modernization & Cloud Data Integration

  • Improved data accuracy from 90% → 98% using SAS, Teradata, Hive, Impala, Python & SQL
  • Reduced reporting discrepancies by 30% via Erwin & Collibra data models and business glossaries
  • Cut manual processing time by 40% through Python-based PoCs and automated data workflows
AWS · GCP · SAS · Teradata · Hive · Collibra · Erwin · Terraform

Education

Where I've studied.

USA
M.S. Computer Science
Virginia Commonwealth University
India
B.E. Information Science
Presidency University

Technical Skills

Tools I master.

☁️ Cloud Platforms
AWS S3GlueLambdaRedshift CloudFormationCloudWatchAzure SynapseGCPDatabricks
📊 BI & Analytics
Power BIDAXRLS TableauLookerExcel KPI ScorecardsPower BI Service
💻 Languages & Scripting
PythonSQLSAS HiveImpalaShell Scripting PandasNumPyscikit-learn
🔧 Data Engineering
Informatica IDQIICSTeradata Azure Data FactorySSISAirflow Data LakeLakehouseHadoop
🏛️ Governance & Modeling
ErwinCollibraData Lineage Metadata MgmtBusiness Glossary Star SchemaFact-Dimension
⚙️ DevOps & Agile
GitCI/CDTerraform JenkinsCloudFormationJira RallyAgile/Scrum

Credentials

Certifications & recognition.

☁️
AWS Certified Cloud Practitioner
Amazon Web Services
Active
🌐
Associate Cloud Engineer
Google Cloud Platform
Active
🏗️
Architecting with Google Cloud
Google Cloud Platform
Active
🤖
Machine Learning
DataCamp
Active
🧠
AI For Everyone
DeepLearning.AI
Active
💡
Introduction to Artificial Intelligence
IBM
Active
🐍
Python Programming for Everybody
University of Michigan
Active
📊
Python & Machine Learning
Kaggle
Active