Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

PRANJAL VIJAYVARGIYA

BANGALORE

Summary

Perceptive and logical data analyst with proven ability to communicate with both technical professionals and clients to identify and translate business requirements. 4+ years of experience in data analytics, product analytics, business intelligence, and data warehousing. Currently working for a fintech company to build a smart, simple, and transparent financial platform to redesign the financial experience for the millennial.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Senior Analyst (Risk, Acquisition, Product and KYC)

Slice
Bangalore
02.2022 - Current
  • Insurance Premium - Developed an framework to calculate premiums, determine default opt-ins, and adjust dynamic rates, resulting in a monthly impact of approximately ₹2 crore and a 50% increase in revenue by enhancing pricing models and collaborating with cross-functional teams for seamless integration.
  • Personal loan product launch analytics - Managed the analytics team for the launch of a personal loan product, focusing on enhancing the funnel process and refining underwriting policies. Increased approval rate from 0.6% to 3%, order level success rate from 30% to 60% and revenue from 70 lakhs to 7 cr a month.
  • Credit Underwriting - Utilized advanced analytics in credit underwriting to identify less risky users, improving loan portfolio quality, significantly reducing default rates, and achieving a 4%-5% increase in approval rates without compromising risk.
  • NACH failure using AA data - Identified negative indicators related to NACH failure using Account Aggregator data to use that to penalize risky users either as limit capping or declining them resulting in declining 1% risky users.
  • Product analytics - Implemented user onboarding funnels to analyze the customer journey, identifying key touchpoints and drop-off points, resulting in a 10%-15% reduction in drop-offs at multiple stages.
  • KYC Analytics - Designed and deployed a suite of dashboards to proactively monitor key acquisition, risk, and KYC-related metrics, enabling real-time tracking and analysis of performance.

Senior Data Analyst

CU Rise Analytics
Ahmedabad
10.2019 - 02.2022
  • Email Performance Analysis - Created a report using Salesforce data to analyze key metrics (open rate, click rate, conversion rate, unsubscribe rate) for email campaigns, providing in-depth insights and facilitating data-driven optimizations that improved overall user conversion by 5%.
  • Campaigns - Executed targeted campaigns, including spend-and-get offers, credit limit increases, and festive promotions, resulting in incremental benefits and increased Gross Transaction Value (GTV).
  • Led analytical projects and performed portfolio reviews for credit unions, enabling data-driven decision-making and fostering portfolio growth by 3-4% YOY.
  • Led the development of an automated recurring transaction identification system, facilitating proactive member communication and streamlining credit card conversions.

Education

Bachelor of Engineering - Computer Engineering -

Gandhinagar Institute of Technology
05.2019

Skills

  • Languages: MSSQL, PostgreSQL, MySQL, Python, PySpark
  • Soft skills: Problem solving, Collaboration, Communication & Presentation skills , Stakeholder Management, Decision Making
  • Platforms: Databricks, Superset, Trino, EMR studio, Querybook, Jupyter Notebook, Airflow, Github
  • Tools: Amplitude, Power BI, JIRA/ Confluence, MS Excel, Powerpoint

Certification

  • Python for Data Science - Issued by IBM
  • Learning Data Visualization - Issued by LinkedIn

Timeline

Senior Analyst (Risk, Acquisition, Product and KYC)

Slice
02.2022 - Current

Senior Data Analyst

CU Rise Analytics
10.2019 - 02.2022

Bachelor of Engineering - Computer Engineering -

Gandhinagar Institute of Technology

Similar Profiles

CREATE PROFILE
PRANJAL VIJAYVARGIYA