Back to Developers
amarnath amal

amarnath amal

Data Analyst

Chennai
80
Profile Score

About

Experienced Data Analyst with 5+ years of expertise in Power BI, Excel, MySQL, and Python. Skilled in dashboard development, data modeling, ETL, and automating reports to support business decision-making. Strong in data cleaning, DAX calculations, visualization, and analyzing large datasets. Proven ability to work with cross-functional teams and deliver actionable insights.

Skills & Expertise (37)

Power BI Expert
9.0/10
5
Years Exp
Excel Expert
9.0/10
14
Years Exp
Data Modeling Advanced
8.5/10
5
Years Exp
DAX Advanced
8.5/10
5
Years Exp
Python Intermediate
7.3/10
1
Years Exp
ETL Transaction Analysis Data Cleaning Data Transformation validation Jira ServiceNow Confluence Kibana SFTP OTRS AMS Rundeck Sales Analysis Incentive Reporting Merchant Performance Metrics IF/IFS Countifs SUMIFS Pivot Tables Index-match XLOOKUP VLOOKUP VS Code Jupyter Notebook NumPy Pandas MySql Data Wrangling Power Query Snowflake Star Schema

Work Experience

Operations Support Executive

The Royal Bank of Scotland

Oct 2010 - Dec 2013

Managed new account creation ensuring compliance with KYC and RBI norms. Verified account opening documentation and resolved discrepancies. Coordinated with multiple business teams for smooth processing. Followed up with central operations to ensure timely account activation.

Senior MIS Executive

Nestle India Ltd

Mar 2015 - Aug 2019

Prepared and maintained Excel-based sales reports to monitor product, category, and region-wise performance for the South Region. Generated daily, weekly, and monthly sales reports to track targets, achievements, and overall business performance. Tracked salesperson performance and shared monthly summaries to support regional management decisions. Coordinated with South Region teams to review results, set targets, and align with overall business goals. Analyzed sales trends to identify strong-performing locations, low-performing areas, and opportunities for improvement within the region.

SME Support Engineer (Data Analyst)

Pagonxt Merchant Solutions India Pvt Ltd

Feb 2020 - Mar 2025

Analyzed merchant data to understand monthly revenue, transaction success, and dispute trends, helping the team identify top-performing and low-performing merchants. Created Power BI dashboards with filters and clear visuals so business teams could easily check merchant performance, payment trends, and daily/weekly KPIs. Reviewed payment data across POS, UPI, and 3D secure channels to find common failure reasons and shared insights to help improve payment success rates. Built simple and efficient data models in Power BI and used DAX to calculate important measures like success rate, failure count, and merchant-level performance. Automated repeated reports using Power Query and SQL, reducing manual work and improving report accuracy. Worked closely with Business Analysts and Account Managers by sharing clear reports, insights, and presentations needed for client meetings and internal reviews.

Senior Associate – Operations

Cholamandalam Investment & Finance Co. Ltd

Dec 2013 - Jan 2015

Managed business and collection incentive processes for multiple teams and branches. Prepared daily and monthly incentive reports for VF and HE business units, collection executives, and partner agencies. Created and distributed daily branch-wise MIS reports to zonal managers for performance tracking. Handled and resolved incentive-related queries received from PAN India locations through email.

Data Analytics Intern

RR IT Solutions

Apr 2025 - Oct 2025

Analyzed student performance and engagement data using Excel, SQL, and Power BI. Designed dashboards to track attendance, grades, and completion KPIs. Wrote optimized SQL queries for reporting. Automated data cleaning using Python (Pandas, NumPy). Validated datasets and ensured reporting accuracy.

Education

Bachelor of Computer Applications (BCA) - Thiruvalluvar University

2013 - 2016 · Afghanistan

Diploma in Computer Engineering - Dusi Polytechnic College

2005 - 2008 · Afghanistan

SSLC - Nehru Govt Boys Hr Sec School

2004 - 2005 · Afghanistan

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 sinceMar 2026

Skills (37)

Power BI Excel Data Modeling DAX Python ETL Transaction Analysis Data Cleaning Data Transformation validation +27 more