About
Data Analyst with 3+ years of experience in data analytics across e-commerce and enterprise domains. Strong hands-on expertise in SQL (Snowflake, Oracle), Python (including AWS Lambda), Excel, and Power BI for data extraction, validation, and dashboard reporting. Experienced in designing and executing automated data pipelines using AWS services such as S3, Step Functions, SageMaker, and EventBridge. Hands-on in Jenkins-driven CI/CD workflows and Git for version control. Skilled in revenue analysis, funnel analysis, data preprocessing, and working with large-scale datasets in cloud environments to support end-to-end analytics solutions.
Skills & Expertise (37)
Work Experience
Associate Engineer – I Data Analyst
Harman
Mar 2022 - Nov 2023
Analyzed 5M+ patient, claims, and HCP records from multiple sources to support healthcare reporting and business decisions. Wrote advanced SQL queries and stored procedures with performance optimization for data extraction and transformation. Designed and validated ETL pipelines with source-to-target reconciliation and data warehouse ingestion checks. Performed data cleaning, normalization, and validation to improve data accuracy and reduce coding errors. Conducted EDA using Python and SQL on claims, eligibility, and provider datasets. Built Power BI (Desktop & Service) dashboards using DAX functions and managed deployment pipelines. Executed data quality checks (completeness, accuracy, consistency, timeliness) across ICD-10, CPT, HCPCS, and DRG datasets. Supported Patient Journey analysis, physician targeting, and HCP profiling using claims data. Worked in Agile/Scrum environment, supported UAT testing, and documented business requirements.
Data Analyst - L2
CommerceIQ
Feb 2024 - Present
Engineered backend analytics platform delivering competitor intelligence to 100+ enterprise clients, contributing to $2M+ in tracked revenue impact across US, Canada, and EU5 markets. Implemented marketplace search scraping using Amazon browse/search parameters and validated product metadata in Databricks. Extracted client and retailer insights using advanced SQL (joins, subqueries, CTEs, RANK, ROW_NUMBER, indexing) in Databricks, improving query performance 30% and reducing manual reporting by 40%. Built NLP-supported taxonomy mapping frameworks for scalable product categorization across large e-commerce datasets. Utilized Python(Pandas,NumPy,Matplotlib) in JupyterLab for data preprocessing, feature engineering, transformation, and automation. Developed Excel-based classification models using INDEX-MATCH, XLOOKUP, Pivot Tables, and conditional logic for product group and attribute tagging across Amazon nodes. Applied A/B testing and funnel analysis for marketplace performance evaluation and analytical optimization. Performed precision-recall validation and clustering accuracy checks by retrieving outputs from Amazon S3 prior to Databricks ingestion and UI deployment. Managed AWS infrastructure (S3, Lambda, Step Functions, SageMaker, EventBridge) ensuring 99.9% pipeline uptime and 25% reduced processing latency. Designed Jenkins-driven CI/CD pipelines and maintained version-controlled configuration files (client_parameters.py, UDF scripts) using Git and Bitbucket within VS Code.
Education
Bachelor of Engineering (B.E) – ECE - Visvesvaraya Technological University (VTU)
- 2022 · Afghanistan
