Back to Developers
Shifa Anjum

Shifa Anjum

Data Analyst

Bangalore, India 80 · Excellent

About

Data Analyst with 2+ years of hands-on experience in Advanced Excel, data cleaning, transformation, and validation across large-scale datasets. Proficient in Pivot Tables, Power Query, INDEX-MATCH, Nested IFs, SUMIFS/COUNTIFS, Dynamic Named Ranges, Array Formulas, and Advanced Charting. Experienced in deduplication, descriptive data analysis, and building structured reporting workflows that improve data quality and support business decision-making. Strong attention to detail, analytical mindset, and a proven track record of improving data accuracy by 25% and reducing reporting effort by 30%. Immediate joiner, available for full-time remote engagement.

Skills & Expertise (23)

Advanced Excel Advanced
8.1/10
2
Years Exp
Tableau Intermediate
7.1/10
2
Years Exp
SQL Intermediate
6.5/10
2
Years Exp
Python Beginner
5.8/10
1
Years Exp
Data Validation ETL Pandas Power BI MySql Preprocessing Data Cleaning Deduplication Data Consolidation Text functions Conditional Formatting Countifs SUMIFS Nested IF HLOOKUP VLOOKUP Index-match Power Query Pivot Tables

Work Experience

Data Analyst

Trupp Global Technologies

Mar 2024 - Feb 2026

Performed data cleaning, deduplication, preprocessing, and validation across 250,000+ company and financial records, ensuring accuracy and consistency for downstream reporting and analytics. Applied Advanced Excel techniques — including Pivot Tables, INDEX-MATCH, SUMIFS/COUNTIFS, Nested IFs, Conditional Formatting, and Dynamic Named Ranges — to transform raw datasets into structured, analysis-ready formats. Used Power Query for data consolidation and transformation across multi-source datasets, reducing manual data preparation effort by 30% through automated refresh workflows. Built Advanced Charts and visual summaries in Excel and Tableau to communicate KPI trends, revenue signals, and funding patterns clearly to non-technical stakeholders. Conducted descriptive data analysis to identify patterns, anomalies, and business insights across large datasets — supporting prioritization of high-growth companies for investment decisions. Implemented data validation rules, Array Formulas, and Text Functions to enforce data quality standards and ensure consistency across reporting templates used by multiple teams. Improved overall data accuracy by 25% through structured enrichment pipelines, deduplication workflows, and automated quality checks across multi-source datasets. Documented all data processes, reporting standards, and transformation logic to ensure reproducibility and compliance with internal data governance requirements.

Education

Bachelor of Computer Applications (BCA) - GD Rungta College of Science and Technology

2019 - 2022 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceApr 2026

Availability Details

Visa Status

H1B

Relocation

Open to Relocation