KANARAM T
Hyderabad
Summary
Results-driven Data Analyst with a proven track record at Nineleaps, specialized in advanced SQL, Python, data visualization, data manipulation, ETL, Databricks, and predictive analytics to enhance API stability by 22% and optimize routing strategies. Adept at developing impactful KPI dashboards using Power BI, Tableau, Looker Studio, and collaborating across teams, I excel in problem-solving and delivering data-driven insights that drive significant business improvements.
Overview
4
4
years of professional experience
Work History
Data Analyst 1
Nineleaps
Bengaluru
11.2022 - 09.2025
- Investigated and debugged root causes of payment failures across multiple PSPs, wallets, and network layers during degradations and downtimes, improving API stability (auth/charge/refund flows) by 22% and reducing high-impact incidents.
- Contributed to weekly driver pay optimisation analysis by identifying payout delays, drop-off patterns, and incentive gaps-improving ontime earnings visibility and helping increase new driver partner onboarding by 10%.
- Queried large-scale transactional datasets using advanced SQL (CTEs, window functions, subqueries) to verify PSP success/failure rates, validate stakeholder-reported issues, and cross-check operational impact with 99% data reliability.
- Built KPIs & reports using Power BI tracking PSP success/failure rates, user-impact counts (100s-1000s per incident), financial loss estimates, and unique user churn, enabling leadership to improve routing decisions and reduce financial exposure by 18%.
- Designed KPI-driven reporting on PSP degradations, frequency trends, and transaction flows, helping leadership optimise routing strategies and improve PSP-level operational efficiency by 25%.
- Developed financial-impact dashboards forecasting quarterly losses per PSP, supporting negotiation discussions and helping reduce partner-related cost impact by 15%.
- Collaborated with engineering, product, and business teams during live incidents, reducing diagnostic time by 30% and enabling quicker mitigation actions.
Data Analyst
Future Step Solutions
Bengaluru
11.2021 - 11.2022
- Designed and maintained SQL-based segmentation reports by performance, location, and income tier, enabling the business team to identify high-conversion prospects and improve targeting strategies.
- Collaborated with internal BAs and operations teams to gather data requirements, ensure timely updates, and improve data workflows.
- Built interactive dashboards in Looker Studio to track outreach funnel, counseling stages, and conversion metrics, providing real-time visibility for leadership and improving follow-up timing by approximately 12%.
- Developed a recommendation framework by integrating SQL queries with historical trend analysis, improving the accuracy of recommendations by 30% and supporting data-driven decision-making.
- Analyzed large-scale student performance datasets (approximately 500+ cases) to identify trends, drop-off reasons, and high-affinity segments, leading to a 9% increase in conversion rate.
- Improved business outcomes by applying a data-driven outreach strategy, identifying underserved segments with higher conversion rates, and boosting overall conversion by 18%.
Education
B.E - Information Science
MVJ College of Engineering
Bangalore, India01.2020
Skills
- Python
- Predictive analytics
- Dashboard creation
- KPI development
- Statistical analysis
- Data analysis
- ETL processes
- Tableau
- Problem solving
- A/B testing
- Microsoft power BI
- EDA (Exploratory Data Analysis)
- ETL
- Data collection
- Predictive modeling
- Data modeling
- Looker Studio
- Cross-functional collaboration
- Trend analysis
- Performance optimization
- Excel
- Databricks
- PySpark
- SQL query Optimization
- Data visualization
Languages
- Hindi
- Kannada
- English, Proficient
- Hindi, Proficient
- Kannada, Proficient
Key Accomplishments
- Feather on the Hat Award, Received the 'Feather on the Hat' award twice for exceptional monthly performance and strong contributions to data-driven issue resolution.
- Client Appreciation, Recognised by client managers and the Payments Lead for proactively analysing a failure spike in Edenred (France), delivering SQL insights that helped MarketOps identify the root cause and mitigate PSP-level issues.
Timeline
Data Analyst 1
Nineleaps
11.2022 - 09.2025
Data Analyst
Future Step Solutions
11.2021 - 11.2022
B.E - Information Science
MVJ College of Engineering