VASU DHAMA
Mohali,Haryana
Summary
Offering abilities in data management and analysis, leveraging expertise in ETL processes, Advanced Excel, and automation to enhance data quality and reporting efficiency. Skilled in integrating data into dashboards for insight generation, and collaborating with teams to define data requirements and validation frameworks.
Overview
6
6
years of professional experience
Work History
Senior Technical Analyst
Iota
Mohali
06.2026 - Current
- Support creation of load files and manage large-scale data extractions using advanced Power Query methods, maintaining accuracy and efficiency across varied datasets.
- Build custom macros and VBA scripts to automate repetitive tasks, simplify workflows, and meet changing client needs.
- Create automated notification report cards to keep clients informed on project status, data quality, and compliance metrics.
- Run ETL processes for extraction, transformation, and loading, with focus on data cleaning, validation, and consolidation to support faster delivery and better decision-making.
- Handle sensitive PII and PHI datasets securely in alignment with GDPR and HIPAA requirements.
- Work with cross-functional teams to identify document patterns, extract key components, and deliver structured outputs from unstructured and scanned documents.
- Use Excel advanced functions, Power Pivot, and SQL scripting to build dashboards, performance reports, and automated refresh processes for real-time insight.
- Serve as key client contact for requirements gathering, amendment review, and clear communication throughout project work.
Data Analyst
United lex Private Limited
Gurugram
02.2021 - 06.2026
- Performed end-to-end ETL data extraction, transformation, and loading of highly sensitive PII/PHI datasets, ensuring GDPR-aligned handling, confidentiality, compliance, and audit-ready traceability.
- Utilized Advanced Excel + Power Query to automate complex data-processing pipelines, including multi-source ingestion, column-level transformations, table merges, text normalization, data type enforcement, and custom function creation.
- Designed robust data-cleaning and validation frameworks using ETL logic, eliminating duplicates, resolving inconsistencies, profiling data quality, and ensuring 100% accuracy before downstream reporting.
- Developed dynamic MIS workflows by integrating Excel (Power Pivot), Power Query, VBA/Macros, and SQL scripts, reducing manual intervention and significantly improving reporting efficiency.
- Conducted secure extraction and sanitization of PII/PHI attributes using controlled ETL steps, conditional filters, lookup logic, encryption-friendly processes, and privacy-preserving transformations.
- Automated recurring data refresh processes through Power Query parameters, incremental loads, scheduled refresh logic, and reusable ETL templates to ensure consistent, real-time reporting.
- Used Advanced Excel techniques (Power Pivot, INDEX-MATCH, XLOOKUP, array formulas, dynamic ranges, nested logical functions, error handling) to structure, analyze, and transform complex data files.
- Collaborated with cross-functional teams to define data requirements, attribute mapping, transformation rules, and quality thresholds for PII/PHI-linked operations and regulatory reporting.
- Extracted, validated, and processed PHI/PII datasets with strict adherence to GDPR, HIPAA, and internal data-security frameworks, ensuring zero-breach handling and audit readiness.
- Conducted rigorous data-quality checks, anomaly detection, integrity validation, and accuracy audits before exporting or sharing sensitive datasets.
Education
High school -
Archana memorial
10+2 -
K.K Jain Inter college
Bcom -
K.K Jain SD college
Skills
- Microsoft Excel and Power BI
- Data analysis and visualization
- Power Query and Power Automate
- Dashboard creation
- Conditional formatting techniques
- Automation and RPA
- SQL programming language
- Team management skills
- Data validation
- ETL processes
Personal Information
Title: Data Analyst
HOBBIES AND INTERESTS
Graphic design, UI/UX learning, Digital organizing & workspace setup, Creating Wordpress websites, Minimalist planning / journaling
AWARDS
Hi-Five Award – Exceptional teamwork, Legal Eagle Award – Best productivity with zero errors, Star of the Month Relentless Performer Award – Dedication & late-hour project support, Study Staller Award -Awarded for showcasing strong commitment, accountability, and problem-solving, especially during peak workload cycles where consistent performance was crucial.
Timeline
Senior Technical Analyst
Iota
06.2026 - Current
Data Analyst
United lex Private Limited
02.2021 - 06.2026
High school -
Archana memorial
10+2 -
K.K Jain Inter college
Bcom -
K.K Jain SD college