Raunaq Kohli
Dallas,TX
Summary
Detail-oriented Data Scientist with a strong background in advanced analytics and machine learning techniques for driving business solutions. Proven track record in developing and deploying AI-powered solutions across diverse domains such as finance, real estate, and education technology. Proficient in Python, SQL, Tableau, and R, with exceptional skills in handling large datasets and extracting actionable insights. Certified AWS Cloud Practitioner with expertise in ETL pipelines, NLP, and data visualization.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Scientist
Citigroup N.A.
07.2023 - Current
- Assisted in the development of an internal chatbot using DistilBert transformers for Risk and Control function at Citibank to extract compliance information from complex text data, aimed at reducing regulatory fines by over 33%
- Built an ETL pipeline to extract text data from over 1000 manually entered audit reports per week and preprocess text data using SpaCy and NLTK Python libraries into vectors to be consumed by the LLM
- Developed a hybrid model to predict values the LLM was not able to extract using Random Forest Classifier and Cosine-Similarity with over 70% accuracy being achieved on average.
Data Scientist - Intern
Pioneer Realty Capital
05.2023 - 07.2023
- Interned in the Finance & Capital markets division of Pioneer Realty Capital, a commercial real estate investment firm
- Built a pricing model on R utilizing regression algorithms to assess profitability for an $84.3 million real-estate development project utilizing 7 easily obtainable parameters
- Developed a Python script to scrape listings and sales data from Zillow for over 10,000 comparable listings, performed feature engineering to extract suitable features from the data scrapped to build regression models
- Created Tableau dashboards to visualize insights achieved from the model, identifying and presenting key real estate investment opportunities for real estate projects valued at over $10,000,000 to high-net-worth investors.
Data Analyst - Intern
Smoothapps Consulting
01.2023 - 04.2023
- Smoothapps consulting is a boutique management consulting firm assisting its clients in implementing Agile principles into software development cycles
- Executed SQL queries to seamlessly extract employee performance data from Azure Devops and load into Python for over 1000 software development work items to extract insights for performance improvement
- Identified and presented key metrics and areas of improvement for performance optimization to business, assisting client achieve 15% reduction in time to market, leading to a quarter-over-quarter projected revenue increase of 12%.
Senior Data Analyst
Byjus- The learning app
09.2021 - 07.2022
- Byjus is a fast-paced, high-growth SAAS startup and the world's most valuable Education Technology platform, owning Epic and Osmo in the US in addition to it's India operations
- Led a team of 6 data analysts to design and maintain performance reporting infrastructure for marketing campaigns spanning over 16 states and 46 cities
- Decreased marketing performance reports generation time for over 1500 sales associates by catalyzing shift from legacy analytics systems to modern performance reporting dashboards utilizing SQL and Tableau
- Implemented a survey based and analytics intensive customer feedback program in coordination with sales and product teams, assisted in improving customer retention rate by 16% within 3 months of implementation.
Data Analyst
Byjus - The learning app
06.2019 - 09.2021
- Used Python numpy and pandas extensively to transform unstructured marketing data pulled from marketing data sources to load into Tableau dashboards and SQL server to generate reports and generate actionable insights
- Cross-Collaborated with leaders from Marketing to gather requirements and develop reports on Tableau on a daily, monthly and weekly basis
- Performed data mining using Python and SQL server on marketing campaign data to segment customers and identify successful marketing channels for new product launch, product achieved 126% of the launch sales target.
Education
Master of Science in Business Analytics - Data Science Specialization -
Southern Methodist University, Cox School of Business
Dallas, TXBachelor of Technology - Electrical Engineering -
Guru Gobind Singh Indraprastha University
Skills
- Python Programming
- SQL Databases
- Machine Learning
- Statistical Analysis
- Natural Language Processing
- Scikit-Learn
- R Programming
- Big Data Analytics
- Data Wrangling
- Data Mining
- Problem-Solving
- Analytical Thinking
Websites
Certification
- AWS Certified Cloud Practitioner
- Machine Learning Specialization
- IBM Data Science
Timeline
Data Scientist
Citigroup N.A.
07.2023 - Current
Data Scientist - Intern
Pioneer Realty Capital
05.2023 - 07.2023
Data Analyst - Intern
Smoothapps Consulting
01.2023 - 04.2023
Senior Data Analyst
Byjus- The learning app
09.2021 - 07.2022
Data Analyst
Byjus - The learning app
06.2019 - 09.2021
Master of Science in Business Analytics - Data Science Specialization -
Southern Methodist University, Cox School of Business
Bachelor of Technology - Electrical Engineering -
Guru Gobind Singh Indraprastha University
Similar Profiles
Michael AndersonMichael Anderson
Correspondent Lending/Senior Loan Specialist at Citigroup N.A.Correspondent Lending/Senior Loan Specialist at Citigroup N.A.
Jayson TenorioJayson Tenorio
Wealth Relationship Manager at CitiGroup, N.A.Wealth Relationship Manager at CitiGroup, N.A.
Troy ClementTroy Clement
Vice President/Business Support Manager/Account Manager/Account Associate at Wells Fargo Bank, N.A. (acquired by Computershare Trust Company, N.A. Nov.2021)Vice President/Business Support Manager/Account Manager/Account Associate at Wells Fargo Bank, N.A. (acquired by Computershare Trust Company, N.A. Nov.2021)