About me
👋 Hi, I’m Ankit Malhotra—a Data Analyst dedicated to transforming data into powerful insights that drive strategic growth and efficiency. I specialize in building advanced data solutions using SQL, Python, predictive analytics, and business intelligence tools. My work has impacted organizations from fast-paced startups to established brands like Uber, where I developed and automated KPI dashboards and predictive models, reducing manual efforts and enabling data-driven decision-making.
With a strong background in ETL and data warehousing, I have extensive experience optimizing data pipelines and ensuring seamless data flows. From creating workflows in Snowflake to leveraging tools like Alteryx, Redshift, and Informatica, I bring expertise in designing systems that improve data accessibility and reliability. I’ve also worked extensively with a variety of databases, including MongoDB, PostgreSQL, Cassandra, and MySQL, each adding a layer to my ability to manage and analyze data across diverse environments.
Currently pursuing my MS in Business Analytics at UC Riverside, I am a Beta Gamma Sigma honoree and serve as a Graduate Ambassador. As the President of the Programming Club, I have led initiatives to foster collaboration and innovation among peers, further refining my leadership and analytical skills.
💻 My projects reflect my commitment to impactful solutions, from developing a customer churn prediction model for telecoms to creating FinAI, an AI-based financial news tool aimed at simplifying investment decisions. With each project, I aim to push the boundaries of what data can do in practical, real-world scenarios.
Outside of work, you’ll find me immersed in personal projects, exploring the latest in machine learning, playing the guitar, or enjoying a good gaming session. Let’s connect and discuss how we can use data to solve complex business challenges together!
Cerifications & Awards
-
Data Science Certification
Beta Gamma Sigma Member
Inducted as lifetime member of Beta Gamma Sigma (BGS). BGS recognizes and honors the top students and all doctoral candidates from around the world in business schools accredited by The Association to Advance Collegiate Schools of Business (AACSB).
-
Machine Learning Certificate
Data Science Capstone Certification
Data Science with python certificate
Python for Data Science certification
Tableau Certification
Skills
-
AWS(EC2,S3)
-
Python
-
Advanced SQL
-
R & Julia
-
PyTorch
-
Scikit-Learn
-
Generative Ai
-
Microsoft PowerPoint
-
Django, Flask
-
JavaScript, HTML, CSS
-
Google Data Studio
-
Microsoft Excel
-
Data Mining
-
Statistical Modeling
-
Keras
-
Statistical Data Analysis
-
Tableau
-
PowerBI
-
Git
-
SPSS
-
C/C++
Resume (Link)
Education
-
University of California, Riverside
2023 — PresentMaster's of Science Business Analytic
Concentration : Financial Analytics
-
VIT University, Vellore
2015 - 2019B.Technology in Electronics & Instrumentation
Achievements
-
Graduate Ambassador
@ AGSM, UCR -
President at Progromming Club , UCR
University of California, Riverside -
President of Student Organization, Visual Bloggers' Club
VIT University, Vellore -
Represented University for one of India's biggest "Tech in medical Industry" Hack-a-thon.
VIT University, Vellore -
Published 3 research publications and 1 book-chapter on transfer and semi-supervised learning.
VIT University, Vellore
Work Experience
-
AI Product Development Lead
Apr 2024 - Jun 2024 ( internship )We Are InPower
• Managed end-to-end project development, including design, implementation, and continuous improvement.
• Focused on inclusive and empathetic communication to ensure effective and sensitive interactions.
-
Aritificial Intelligence Analyst
Apr 2024 - May 2024 ( internship )iSYNC Technologies
• Integrated SAP ERP S4Hana with Python, developing methodologies for AI-generated reports using Gemini-Pro LLM and Hugging-Face API.
• Analyzed critical financial and controlling modules to automate reporting and data inflow, enhancing financial transactions and internal cost management.
-
Senior Data Analyst
August'22 - June'23Uber | IndiumSoft Technologies
•Point Lead on Uber Cash and Gift Cards with Payments and Risk team, for Uber eats, rides and logistics for US&C, EMEA & APAC regions.
•Assisted the team in extracting valuable information on all aspects of Uber Cash data in the ecosystem.
•Performed Deep-dives on top-ups of uber cash, and optimized several pipelines for the FinProd Uber Cash vertical.
-
Data Analyst + Back-end Developer
Feb'20 - August'22Financepeer (now Leo1)
• Core Data Analyst at a start-up, developing a DBMS for the firm from scratch using all open source Technologies.
• Created a customized DBMS for the entire firm accross 4 different products along with 100+ Dashboards and Visualizations.
• Developed, optimized & reconciled amortization + scheduling algorithm for several different types of Financial products
• Developed an OCR system for automating the process of data entry through financial & KYC documents with 85% + Accuracy.
• Developed and Integrated a CRM system from scratch for internal team members, resulting in smoother transition of workflow from one team to another.
-
Data Science & Analytics Mentor
Aug'23 onwardsNewton School (Freelance)
• Core Data Analyst at a start-up, developing a DBMS for the firm from scratch using all open source Technologies.
• Responsible for mentoring & coaching a cohort of 15 - 20 students in Data Science & analytics with Python, SQL, MS Excel, R, Tableau along with Data Warehousing and Statistics.
Projects
-
customer churn in telecom subscription based business
jupyter
Analyze customer churn in telecom to improve retention and profitability. Identify at-risk customers, reduce churn, and use CLTV analysis for strategic decisions and better customer insights.
-
Spotify Cohort Analysis
MongoDB | Express.js | Node.js | React
This project uses cohort analysis on Spotify to segment users by signup date, revealing patterns in behavior to optimize retention strategies and enhance long-term user loyalty.
-
Classification Exploration
React | Redux-Toolkit | Tailwindcss | Appwrite
Explores classification algorithms' efficacy in predictions using logistic regression, decision trees, random forests, and SVMs. Focuses on implementation, tuning, and comparative analysis for optimal results.
-
Hepatagon Consulting DBMS
Vanilla JavaScript | CSS | HTML
Tailored for Hepatagon Consulting, this DBMS project optimizes data management with efficient schemas, SQL queries, and performance tuning, empowering insightful analysis and informed decisions.
-
PM-roadmap-finAI-financial-news-tool
This repository showcases a product management project focused on developing an AI-powered financial insights tool. The project demonstrates key skills in building product vision, road mapping, user research planning, competitor analysis, and UI/UX design thinking.
-
Operation BluePrint
Express.js | Mailchimp API | Bootstrap
Operation BluePrint optimizes project workflows with task allocation, progress tracking, team collaboration, and resource management, ensuring exceptional efficiency and project success.
Contact
I'm currently pursuing my Master's of Science in Business Analytics from University of California, Riverside. Looking for internships and/or Full-Time Job opportunities in Data Science, Machine Learning, Business Intelligence/Analytics and Data Analytics.
However, I am always up for new projects and opportunities. I can help with the following:
-
Consulting for Data
Analytics Deep Dives, Machine Learning, Artificial Intelligence.
-
Database Design,
creation, warehousing, optimization.
-
Educating &
Mentoring.
-
Web Application
Development.
-
Options and Futures
Trading (Stock Market Derivatives).
-
Honestly, Anything
related to Tech and/or Finance!.
Recommendations
-
Ankit Malhotra is an absolute powerhouse of motivation and skill! Working together for 2.5 years was a joy as he showcased brilliant creativity and technical prowess. Ankit not only aced RDBMS optimization but also rocked a 10-month project, flaunting his wizardry in algorithms and mathematics. His kindness and generosity are heartwarming, and paired with his stellar analytical skills, he's truly an invaluable asset. Recommending Ankit is a no-brainer – he's the kind of professional dreams are made of! 🚀
DebiPrasad Baral Co-Founder & CTO, Financepeer (now Leo1)Ankit Malhotra is an exceptional professional, showcasing unparalleled skills in problem-solving, technical execution, and leadership. His dedication to academics, coupled with a passion for continuous learning, sets him apart. Ankit's collaborative spirit and outstanding performance in diverse projects make him an invaluable asset. I wholeheartedly recommend Ankit for any academic or professional endeavor; his commitment and expertise speak volumes.
MohanaSundaram R. Senior Assistant Professor, VIT University, SCOPE (School of Computer Science Engineering)