Rehan Jain is a graduate of the University of Delhi with a Bachelor's in Commerce and a minor in Economics. He further enhanced his skills with a Professional Certificate Program in Business Analytics from IIT Roorkee. His professional experience includes roles as a Business Analyst and Data Analyst, where he managed projects for international and Indian clients. He has a proven ability to establish processes and ensure the smooth delivery of projects.
Experience
Business Analyst
CBS Global Group
Drafted process flows for the preparation of Performance summaries using, by employing nested formulas and power queries for automatic & quick data fetching, was able to reduce the reporting time by 80%. Designed dashboards customized to meet client requirements, using Domo and Power BI. Made a custom dashboard displaying 7 KPIs based on real time data fetched from database hosted on AWS Redshift. Directed a team of six collections agents, employed advanced analytics to dissect an $8M accounts receivable (AR) portfolio. Generated insights through comparison reports, resulting in a 35% reduction in AR balance.
Data Analyst (Intern)
SPYNE AI
Used advanced SQL queries to extract KPIs and improve the overall quality control process, overseeing an 8-member team to enhance operational efficiency. Successfully showcased Proof of Concepts (POCs) to enterprise clients and spearheaded the onboarding process for a significant international client from the Middle East, leading to a monthly revenue increase of $15000. Identified revenue drop-offs linked to client rejections; addressed these challenges by fine-tuning models to align with client specifications., reducing the drop-offs from 40% to 13%. Implemented Automation related to data restructuring and renaming according to client specifications, reducing TAT significantly by around 20%.
Freelancer
AltF
Solved Data extraction from image-based sources by an Optical Character Recognition (OCR) solution, works with over 95% accuracy. Developed custom web scraping solutions using BeautifulSoup and Selenium for extracting marketing data such as reviews and contact details, utilized prompt engineering techniques for efficiency.
Education
Indian Institute of Technology
Professional Certificate Program in Business Analytics and Generative AI
Business Analytics
Courses: MS Excel, Database Management, SQL, Python (Data Analysis and Automation), Tableau
Dyal Singh College, University of Delhi
Bachelor of Commerce (Hons)
Commerce
Courses: Managerial Economics, Organization Theory, Marketing Management, Costing, Law, Marketing
Modern School
Class XII - Percentage: 92.7%; Class X - CGPA: 9.0
Licenses & Certifications
IBM Mathematical Optimization for Business Problems
IBM
BCG Introduction to Strategy Consulting Virtual Experience
BCG