Back to Developers
Hemant Rawal

Hemant Rawal

Data Analyst

Remote 1+ yrs exp 82 · Excellent

About

Data Analyst with experience in financial data analysis, reporting, and bank reconciliation. Skilled in Advanced Excel, data validation, and OCR-based financial data processing, with hands-on project experience in Power BI and SQL. Proficient in identifying discrepancies, preparing reports, and generating business insights from data.

Skills & Expertise (31)

Advanced MS Excel Intermediate
7.3/10
1
Years Exp
Analytical Thinking Intermediate
7.0/10
1
Years Exp
Problem Solving Intermediate
7.0/10
1
Years Exp
Attention to Detail Intermediate
7.0/10
1
Years Exp
Cash Flow Analysis Intermediate
6.5/10
1
Years Exp
Data Validation Intermediate
6.3/10
1
Years Exp
Data Cleaning Intermediate
6.3/10
1
Years Exp
Quality Checks Intermediate
6.0/10
1
Years Exp
Power BI Beginner
5.5/10
1
Years Exp
SQL Beginner
5.0/10
1
Years Exp
Team Collaboration Communication Time management Adaptability MIS Reporting Multitasking Ownership Accountability Deadline management JSON Handling CSV Handling Bank Reconciliation Standardization Macros COUNTIF SUMIF If XLOOKUP VLOOKUP Pivot Tables Financial Reporting

Work Experience

Analyst

Blucognition

Jul 2025 - Present

Performed financial data analysis and reconciliation by validating transaction records, balances, and debit/credit movements to ensure data accuracy and consistency. Analyzed and transformed raw financial data extracted through OCR tools into structured datasets for reporting and business analysis using Excel. Conducted data quality checks to identify anomalies, duplicate transactions, missing records, and reconciliation mismatches through analytical validation techniques. Created and maintained analytical reports and MIS dashboards in Excel using Pivot Tables, VLOOKUP, and advanced Excel functions to track reconciliation status, cash flow patterns, and financial performance metrics. Generated actionable financial insights through transaction trend analysis, expense categorization, and structured reporting to support business decision-making. Delivered high-accuracy analytical reports and datasets in Excel, CSV, and JSON formats while ensuring compliance with data governance and confidentiality standards.

Retainer

eClerx Service LTD

Dec 2024 - Mar 2025

Analyzed daily product data with a focus on 'Share of Navigation' and 'Share of Search' metrics, improving visibility insights accuracy by 15% across 170+ eCommerce platforms. Executed file crawling and validation processes to ensure data completeness and consistency, reducing discrepancies by 20%. Delivered validated data on time with 98% accuracy, performing thorough post-delivery audits to maintain quality across the product lifecycle. Automated data processing using Excel macros, increasing operational efficiency by 30% and reducing manual errors. Managed and transformed large datasets using advanced Excel functions (VLOOKUP, Pivot Tables, TRIM, Remove Duplicates, Flash Fill), streamlining workflows for 170+ eCommerce sites. Onboarded 50+ new eCommerce websites during global expansion, ensuring seamless data integration and adherence to quality standards. Collaborated with development and operations teams to improve workflow efficiency and enhance data integrity across the delivery pipeline.

Education

Bachelor of Business Administration (BBA in Finance) - Sahyog College of Management Studies

2021 - 2024 · Afghanistan

Higher Secondary (12th Grade - Commerce) - Babaji Sakharam Patil, JR College Of Commerce and Arts

2019 - 2021 · Afghanistan

Secondary School (10th Grade) - Babaji Sakharam Patil Vidya-Mandir English High School

- 2019 · 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 7/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 82/100

Profile Overview

Member sinceJun 2026