Snehal Bhanje
Summary
A challenging role leading the MDM domain, involving the resolution of existing issues and enhancement of client processes to facilitate goal achievement. The objective is to augment expertise in MDM, ETL, and to acquire additional skills.
Overview
1
1
Certification
6
6
years of professional experience
Work History
Data Engineer
Axtria - Ingenious Insights
Bangalore
02.2022 - Current
- Built end-to-end ETL pipelines across 3-layer (Staging → INT → DWH) architecture integrating 10+ heterogeneous sources, with PHI compliance checks and dual-format date normalization reducing data errors by ~20%.
- Developed tokenization pipelines invoking external binaries via Python subprocess, managing 5+ config/version variants and processing 1M+ records securely.
- Designed fact/dimension tables enabling patient analytics across 20+ milestones, reconciling grain across multiple source systems into unified territory, HCP, and patient data marts.
- Built multi-CTE SQL pipelines with window functions and incremental MERGE logic, cutting full-refresh runtime by ~30%, and delivered RRD layers powering 10+ Power BI reports.
- Integrated specialty pharmacy (CVS, PantheRx), hub (CoverMyMeds), and industry platforms (Veeva, IQVIA, GPO) data, unifying 5+ systems into a single patient journey analytics pipeline.
- Delivered a Power BI patient journey dashboard tracking 20+ milestones (enrollment to adherence), driving KPIs for transfer tracking, enrollment gaps, copay participation, and adherence across thousands of patients.
- Used Databricks (Delta Lake), Snowflake, and Python to engineer pipelines at multi-million-row scale, automating backfills and cutting manual effort by ~25%.
- Authored STTM docs/data dictionaries for 10+ source systems, led gap analysis with 5+ stakeholder teams, and auto-generated Excel workbooks via openpyxl, saving ~5 hrs/week.
- Developed and implemented Python-based fuzzy algorithms for custom data matching, enhancing accuracy and integration processes beyond standard MDM rules for more than 6 sources
QA Analyst
HCL Technologies
Bangalore
12.2020 - 02.2022
- Executed test cases for functional, validation, end-to-end, and regression testing, ensuring comprehensive coverage for web applications.
- Contributed to product testing for finance project, developing test plans and executing tests to ensure timely delivery of quality solutions.
- Monitored change request activities to support software development processes.
Education
Bachelor of Science - Information Science
KLS GOGTE INSTITUTE OF TECHNOLOGY
Belagavi06-2020
Skills
- ETL
- Data management
- Data integrity
- Data storage
- Data assessment
- Python
- SQL queries
- Redshift
- MySQL
- AWS
- UNIX
- Information security
- System optimization
- Microsoft Excel
- Data transfer
Certification
- Udemy Microsoft Power BI Desktop for Business Intelligence, 02/01/24
- IBM Python for Data Science, 03/01/21
Timeline
Data Engineer
Axtria - Ingenious Insights
02.2022 - Current
QA Analyst
HCL Technologies
12.2020 - 02.2022
Bachelor of Science - Information Science
KLS GOGTE INSTITUTE OF TECHNOLOGY