Back to Developers
Nikhil Rana

Nikhil Rana

Data Analyst

Dwarka, New Delhi 6+ yrs exp 90 ยท Outstanding

About

Analytics professional with 6+ years of overall experience, including 3+ years focused on data analysis, reporting and BI dashboard development. Strong expertise in SQL, Python, and enterprise reporting tools including IBM Cognos, TIBCO Spotfire and Apache Superset. Skilled in data validation, workflow automation and cross-functional reporting across regulated pharmacovigilance and HR-tech environments.

Skills & Expertise (20)

SQL Advanced
8.0/10
6
Years Exp
Python Advanced
8.0/10
6
Years Exp
Pandas Advanced
7.5/10
6
Years Exp
AWS Advanced
7.5/10
1
Years Exp
Data Cleaning Advanced
7.5/10
6
Years Exp
Exploratory data analysis Advanced
7.5/10
6
Years Exp
NumPy Advanced
7.0/10
6
Years Exp
Excel Advanced
7.0/10
6
Years Exp
Statistical Analysis Advanced
7.0/10
6
Years Exp
Data Validation Advanced
7.0/10
6
Years Exp
Lambda Advanced
6.5/10
1
Years Exp
ECS Advanced
6.5/10
1
Years Exp
S3 Advanced
6.5/10
1
Years Exp
Apache Superset Advanced
6.5/10
1
Years Exp
IBM Cognos Advanced
6.5/10
1
Years Exp
SQS Advanced
6.5/10
1
Years Exp
Jira Advanced
6.0/10
3
Years Exp
Power BI Intermediate
5.5/10
2
Years Exp
Postgresql Oracle

Work Experience

Associate Consultant

YouWeRaise Pvt. Ltd.

Jan 2025 - Jun 2026

Developed and enhanced IBM Cognos reports using prompts, filters, calculations and report layouts to support pharmacovigilance reporting and compliance requirements. Built interactive Spotfire dashboards using filters and document properties, with JavaScript-based HTML forms and working exposure to IronPython scripting for dashboard customization. Contributed to Argus Safety data configuration and transformation tools, including Easy Config, E2B Gateway and ESynch (E2B(R2) to R3), ensuring compatibility with upgraded Argus Safety versions. Managed client support requests through JIRA, including configuration changes, user access management, testing and deployments across Development, Validation and Production environments; contributed to IQ/OQ documentation and change-control activities.

Data Analyst

SourceEase HR Services Pvt. Ltd.

May 2023 - Oct 2024

Automated manual data management processes using Python scripting and dashboards, reducing processing time by 50% and enhancing workflow efficiency. Conducted in-depth data analysis and developed SQL queries and database views to optimize data structure, enabling faster data retrieval and more effective decision-making. Designed and implemented interactive dashboards using Apache Superset, providing real-time insights into daily operations and key performance metrics. Contributed to AWS infrastructure (ECS, Lambda, S3, SQS) and supported on-prem Linux servers, assisting with deployments and basic troubleshooting.

Support Assistant

National Informatics Centre (NIC), MeitY

Jul 2019 - Apr 2023

Maintained Excel records of resources allocated across multiple ministries, ensuring accurate and organized data tracking. Generated detailed reports and dashboards using Pivot Tables and Pivot Charts, enabling strategic analysis of resource allocation and supporting data-driven decision-making.

Education

Diploma in Data Science - Indian Institute of Technology, Madras (IITM)

2022 - 2024 ยท Afghanistan

B.Tech, Civil Engineering - MDU, Rohtak

2014 - 2018 ยท 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 15/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 90/100

Profile Overview

Member sinceOct 2026