Piyush Rane
Associate-data Analyst @HGS
Signup · Get unlimited contacts
WORK HISTORY
Associate-data Analyst @HGS
IDFC FIRST BANKRISK CONTAINMENT UNIT• Developed, implemented, and optimized SQL queries to transform raw data into insightful reports, addressing critical business reporting needs on daily/hourly basis and achieving a 40% reduction in query execution time to enhance data retrieval efficiency for timely decision-making.• Leveraged Python\'s versatility and rich library ecosystem of Pandas, and NumPy to streamline data wrangling and analysis, resulting in efficient insights generation, and Falcon rule validation activities, crucial for compliance audits and reducing false positives.• Analyzed credit card usage trends and demographics to identify and address product abuse hotspots, developing and executing a targeted intervention strategy that achieved an approximate 5 crores monthly reduction in losses.• Automated the generation of daily fraud MIS reports using Python, providing concise summaries of fraud cases, actions, and resolutions to facilitate trend identification and auditability.• Analyzed UPI fraud data across transaction types like QR code, P2P/P2M with online/offline merchant splitsand key metrics like average ticket size, total business, fraud volume to inform process improvements in fraud monitoring and investigation, resulting in 15% reduction in average investigation time.• Solved business challenges by translating analytical requirements into actionable insights, addressing both ad-hoc requests and regulatory needs.
EDUCATION
IMS Proschool Pvt. Ltd.
Data science
Mgm College Of Engineering & Technology
Bachelor of Engineering - BE
S. H Jondhale polytechnic
Diploma
ABOUT PIYUSH RANE
Data analyst with 3 years of experience leveraging SQL and Python to transform raw data…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.