Back to Developers
Jeffrey Francis

Jeffrey Francis

Data Analyst

Kandivali, Mumbai, Maharashtra
84
Profile Score

About

Data Analyst with 3.5+ years of experience working with large structured datasets across finance and operations domains. Strong expertise in writing complex SQL queries (joins, window functions, aggregations), pulling data from SAS and relational databases, and performing data cleaning, validation, and transformation. Experienced in tracking operational KPIs, conducting ad-hoc analysis, identifying trends and anomalies, and delivering business-ready reports and dashboards. Comfortable combining SQL and Python for exploratory analysis and supporting leadership with data-backed insights while maintaining data quality and governance standards.

Skills & Expertise (14)

SQL Advanced
8.3/10
3.5
Years Exp
Power BI Advanced
8.1/10
3.5
Years Exp
Data Analysis Advanced
8.0/10
3.5
Years Exp
Advanced Excel Advanced
7.9/10
3.5
Years Exp
Bi tools Intermediate
7.7/10
3.5
Years Exp
Python Intermediate
6.5/10
1
Years Exp
ETL Intermediate
6.4/10
1
Years Exp
Data Engineering Basics Intermediate
5.8/10
1
Years Exp
Research Analytical Thinking Team Collaboration Attention to Detail Problem-solving Communication

Work Experience

Research Associate

Tata Consultancy Services

Jun 2021 - Jul 2023

Developed automated Excel dashboards that improved reporting efficiency by 40% and lowered manual error rates. Managed end-to-end data workflows — sourcing, cleaning, validating, transforming — delivering datasets with 99% accuracy. Delivered regulatory summaries and financial market reports to global stakeholders with high reliability. Wrote complex SQL queries (joins, subqueries, aggregations, window functions) to extract and transform data from relational databases and SAS environments for reporting and analysis. Awarded Accelerate Warrior (Top 5% Performer) for consistent and high-quality research output.

Data Research Analyst

Forbes India PVT LTD

Jul 2023 - Jan 2025

Improved dataset accuracy by 25% through structured validation checks and enhanced data-quality workflows. Designed interactive Power BI dashboards and Excel KPI trackers used by editorial and strategy teams, reducing manual reporting time by 60%. Collaborated with cross-functional teams to streamline research processes and improve delivery speed. Implemented a data-standardization framework that strengthened consistency across multiple projects. Tracked and monitored business KPIs including revenue growth, performance metrics, and operational indicators; proactively identified trends and anomalies to support decision-making.

Education

Bachelor of Commerce (B.Com) - Vivek College of Commerce, Mumbai University

- 2020 · Afghanistan

Certifications

Data Science Certification

Try Catch Classes · 2025

Google Data Analytics Professional Certificate

Coursera · 2025

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 19/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 84/100

Profile Overview

Member sinceMar 2026

Skills (14)

SQL Power BI Data Analysis Advanced Excel Bi tools Python ETL Data Engineering Basics Research Analytical Thinking +4 more