Hi there I am Ankit,
I'm a data analyst with a passion for using data to solve problems and drive results. I've worked on a variety of projects in both political consulting and e-commerce, using my skills in data extraction and visualization to help businesses make informed decisions. I'm also passionate about mentoring others and fostering their growth in the data field.
How to reach me:

• Led data integration efforts across diverse platforms (Shopify, Unicommerce, Razorpay, Zoho, Freshdesk, Clickpost) using Webhooks and APIs.
• Automated data retrieval from multiple tools by implementing cron jobs on Google Cloud Platform (GCP) virtual machines.
• Streamlined data fetching using cloud functions and Webhooks, ensuring seamless data flow and accessibility for analysis, reducing data processing time by 30%-50% and enabling informed decision-making.
• Developed a database in SQL using Webhooks and APIs, reducing the time users wait for data exports from various sources.
• Utilized v0 (Vercel AI) and cursor.ai to build data-driven apps and dashboard.
• Deployed a backend data app to assist the supply chain team in managing promise engine data, reducing dependency on analysts and enabling frequent updates to minimize Estimated Delivery Date (EDD) breaches from 5% to 3%, the app will have the following features:
  • Role-based access control and Google login integration.
  • A user-friendly interface allowing non-technical users to update SQL tables.
  • Audit logs for tracking changes, identifying who made updates and when.
  • A feature to schedule changes, reducing the need for off-hours adjustments.
• Provided valuable insights and recommendations based on comprehensive data analysis, contributing to business growth and optimization.
• Mentored a team of 6 interns, fostering a collaborative and innovative environment focused on continuous improvement and learning.

• Prepared dashboard for poll analysis using elections Form-20 data with Plotly Dash.
• Scraped 50K+ (204 GB) electoral PDFs from ECI website & converted into CSV using OCR.
• Building a web app for internal employee user login with Django framework, backend with SQL and MongoDB

• Working in a team of 2 members to perform analysis on sales data to find opportunities for growth
• Creating rich visualizations and interactive dashboards with Tableau, Power BI and AWS Lambda
• Writing pyhton scripts for enriching their database, and for data preprocessing to prepare the data for visualizations.
• Writing web-scraping scripts to scrape data from dun&bradstreets and LinkedIn to enrich partner companies data

• Courses: Python Programming, Fundamental of Statistics, Data Visualization, Machine Learning, Excel, SQL, Product Analysis
• Highlights: 500+ hours of course work, 3 capstone project, 1 open ended capstone project, 10 assignments.

• Courses:Linear Algebra, Modern Algebra, Ordinary Differential Equations, Operations Research(LPP), Real Analysis, Functional Analysis
• Highlights:Got skilled in Linear Algebra, Operations Research and a little bit in Functional Analysis.

• Analyzed Covid-19 vaccination progress with more than 35,000 rows of data
• Performed analysis and created Bar charts, Pie charts, Geo-scatter Plots and Subplots using Plotly
• Insights like: “vaccination percentage for top 10 most populous countries”, “vaccination progress for top 5 most rich countries”, created a mixed subplot to show the different aspects for a country

• Used BeautifulSoup4 and Requests library to scrape data of world’s top 500 companies by market cap
• Created two csv files one for listings of top 500 companies and the second for comparison between their market cap between 4 quarters of a year

• Working on a dataset with over 4 million rows, containing information about 45,000+ PUBG matches
• Built a regression model, made a prediction on the test dataset, scoring 0.08915 on Kaggle leaderboard
• Experimenting with different ML models - Ridge, Lasso, Random Forest, XGBoost and LightGBM

• Worked on a Bookshop excel workbook.
• Added three new sheets, created 3 visualizations and 1 pivot table to analyze the data.
• Created a Tableau dashboard with a number of visualizations using analyzed data from the sheet.