Anil Mattipa

Data Analyst

Bangalore $15/hr Remote Full-time 0+ yrs exp 91 · Outstanding

About

MCA graduate (CGPA 8.70) with hands-on internship experience building Power BI and Tableau dashboards on 65K+ real-world loan records at AiVariant. Proficient in SQL, DAX, Power Query and Python with strong skills in data cleaning, KPI & Business Intelligence reporting and translating complex datasets into actionable business insights. Looking for a full-time Data Analyst role where I can apply my analytical thinking and BI expertise to deliver real impact from day one.

Skills & Expertise (20)

Power BI Advanced

8.5/10

0.5

Years Exp

Tableau Advanced

8.5/10

0.5

Years Exp

Dashboard Development Advanced

8.5/10

0.5

Years Exp

DAX Advanced

8.0/10

0.5

Years Exp

BI Reporting Advanced

8.0/10

0.5

Years Exp

KPI Monitoring Advanced

8.0/10

0.5

Years Exp

Data Modeling Advanced

8.0/10

0.5

Years Exp

ETL Development Advanced

8.0/10

0.5

Years Exp

Data Visualization Advanced

8.0/10

0.5

Years Exp

Power Query Advanced

8.0/10

0.5

Years Exp

SQL Intermediate

7.5/10

0.5

Years Exp

MySql Intermediate

7.5/10

0.5

Years Exp

NumPy Intermediate

7.0/10

0.5

Years Exp

Jupyter Notebook Intermediate

7.0/10

0.5

Years Exp

Pandas Intermediate

7.0/10

0.5

Years Exp

Python Intermediate

7.0/10

0.5

Years Exp

Matplotlib Intermediate

6.5/10

0.5

Years Exp

Seaborn Intermediate

6.5/10

0.5

Years Exp

Git Intermediate

6.5/10

0.5

Years Exp

GitHub Intermediate

6.5/10

0.5

Years Exp

Work Experience

Data Analyst Intern

AiVariant

Feb 2026 - Present

ETL Development, Data Modeling, Dashboard Development, KPI Monitoring & BI Reporting. Built 3 interactive loan analytics dashboards in Power BI and Tableau tracking 8 KPIs including delinquency rate, default metrics and revenue, enabling identification of high-risk loan segments. Wrote optimized SQL queries to extract, clean and aggregate 65K+ loan records, building an ETL pipeline that cut data preparation time by 30% and enabling accurate branch-wise and state-wise performance segmentation. Developed 15+ DAX measures and Power Query transformations to automate monthly KPI reporting, replacing manual Excel processes and surfacing trends such as a delinquency spike across specific loan categories. Presented loan dashboard KPIs to project supervisors, translating complex metrics into clear visual narratives.

Education

Master of Computer Applications (MCA) - AMC Engineering College

2024 - 2025 · Afghanistan

Bachelor of Computer Applications (BCA) - Vijayam Science and Arts Degree College

2020 - 2023 · Afghanistan

Certifications

Sql(Intermediate & Advanced)

HackerRank · 2026

Successfully completed HackerRank SQL (Intermediate & Advanced) certification, demonstrating proficiency in SQL queries, joins, subqueries, aggregate functions, window functions, Common Table Expressions (CTEs), database optimization, and advanced data retrieval techniques. Validated strong problem-solving and database management skills through practical coding assessments.