Back to Developers
Rohan Lokare

Rohan Lokare

Data Analyst

Pune, IN 4+ yrs exp 89 ยท Excellent

About

Highly analytical Business Data Analyst with around 5 years of experience in banking and credit card domains, specializing in large-scale transactional data analysis to drive business insights and optimize operational efficiency. Proficient in SQL, Hive and advanced multi-table analysis for robust data extraction and validation. Expertise encompasses credit card transaction analysis, customer behavior modeling, offer eligibility determination and precise rewards calculation. Adept at translating complex business requirements into actionable data-driven solutions, supporting strategic decision-making and performing Root Cause Analysis (RCA) within dynamic Agile/Scrum environments.

Skills & Expertise (32)

Advanced Excel Advanced
8.0/10
4
Years Exp
Data Analysis Advanced
8.0/10
4
Years Exp
SQL Advanced
7.8/10
4
Years Exp
MySql Advanced
7.5/10
4
Years Exp
Dashboarding Advanced
7.5/10
4
Years Exp
Power BI Advanced
7.5/10
4
Years Exp
Hive Intermediate
7.0/10
4
Years Exp
Agile Scrum Intermediate
7.0/10
4
Years Exp
KPI Reporting Intermediate
7.0/10
4
Years Exp
Tableau Intermediate
6.5/10
4
Years Exp
BigQuery Intermediate
6.5/10
4
Years Exp
GCP Intermediate
6.0/10
4
Years Exp
Frd Pivot Tables Postman Confluence Jira Process Mapping Gap Analysis Stakeholder Management UAT Support User Stories Conditional Formatting BRD Requirement gathering RCA Data Validation VLOOKUP XLOOKUP SUMIFS Microsoft Visio Countifs

Work Experience

Data Analyst

Infosys Limited

Oct 2021 - Feb 2026

Analyzed large-scale credit card customer transaction data to determine loyalty reward eligibility and ensure accurate points distribution. Developed optimized multi-table SQL joins and Hive queries to extract insights from terabyte-scale banking datasets, reducing report generation turnaround time by 30% for senior stakeholders. Performed data validation, reconciliation and quality assurance to maintain financial accuracy and minimize offer-related discrepancies. Led Root Cause Analysis (RCA) for high-priority production incidents, identifying data gaps in offer eligibility logic and implementing Corrective Action Plans (CAPs) that prevented CM harm. Managed Service Requests (SRs) by translating business requirements and stakeholder inputs into actionable analytical tasks. Collaborated closely with business, product and technical teams to resolve data and system issues efficiently. Supported API and system validations using Postman and Putty in production and pre-production environments. Maintained comprehensive documentation, user stories and issue tracking in Jira and Confluence. Worked in Agile/Scrum environments, actively participating in sprint planning, daily stand-ups and retrospective. Created dashboards and reports using Excel/BI tools for stakeholder insights. Performed data analysis using Advanced Excel (Pivot Tables, VLOOKUP, SUMIFS) to generate actionable insights. Built dashboards and KPI reports using Power BI and Advanced Excel to analyze business performance and support decision-making.

Education

Bachelors of Engineering (Electrical) - Dr D Y Patil Institute Of Technology Pimpri Pune, SPPU, Maharashtra

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

Profile Overview

Member sinceOct 2026