Back to Developers
Ankur Rana

Ankur Rana

Data Analyst

Noida, India
77
Profile Score

About

Data Analyst with 2 years of experience in data analysis, backend pipelines and BI applications across Retail and Service domains. Strong in SQL, Python, pandas and PowerBI optimisation with proven impact in automation, performance improvement and onboarding efficiency. Seeking to leverage technical skills to build scalable, data-driven frameworks.

Skills & Expertise (12)

Python Advanced
8.3/10
2
Years Exp
SQL Advanced
8.1/10
2
Years Exp
Pandas Advanced
8.1/10
2
Years Exp
PowerBI Advanced
8.0/10
2
Years Exp
Data Analytics Advanced
8.0/10
2
Years Exp
ETL Advanced
7.5/10
2
Years Exp
Data Transformation Advanced
7.5/10
2
Years Exp
Data Extraction Advanced
7.5/10
2
Years Exp
Excel Intermediate
6.6/10
2
Years Exp
AWS Intermediate
5.5/10
1
Years Exp
MongoDb Intermediate
5.4/10
1
Years Exp
Snowflake Intermediate
5.4/10
1
Years Exp

Work Experience

Data Analyst

CIEK Solutions

Oct 2023 - May 2024

Revamped a scorecard reporting system, integrating real-time upstream data pipelines, boosting report accuracy by 20% and accelerating decision-making for stakeholders. Engineered a scalable data ingestion pipeline leveraging Python (Pandas, NumPy) and SQL, automating data cleaning and transformation, improving data integrity by 25%, and reducing manual intervention by 40%. Developed and optimized complex DAX expressions in Power BI for real-time KPI tracking, advanced logic, and interactive dashboards, boosting user insights 30%. Automated ETL job scheduling and SQL query tuning, slashing data processing time 40% for seamless refresh cycles.

Data Analyst

Epics

Aug 2024 - Nov 2025

Developed scikit-learn models (regression/classification) for financial risk prediction on 2TB dataset; collaborated with stakeholders to boost accuracy 35%. Performed EDA and feature engineering on large-scale financial datasets using Python, SQL, R; identified key risks/trends. Boosted accuracy 65% and relevance 42% via cross-validation with 5 external sources. Used Pandas for statistical analysis and implementing KPI dashboards to track risk exposure in real time. Implemented Data Warehousing solutions that optimized ETL pipelines and advanced analytics workflows for efficient risk assessment. Designed interactive Power BI dashboards for financial trends, credit risk, and fraud insights; cut manual analysis by 15+ hours/month, enabling data-driven decisions.

Education

Master of Science - Information Technology - Arizona State University

2022 - 2024 · Afghanistan

Bachelor of Technology, Computer Science - SRM Institute of Science and Technology

2018 - 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 17/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 77/100

Profile Overview

Member sinceApr 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation