Headline

Data & AI Analyst @ Flipkart | SQL • Python • Machine Learning • Prompt Engineering • Power BI | Generative AI | Finance & Business Analytics | Ex-Web3 Analytics

About

Hi, I’m Arjun Pathak. I’ve been working as a Data Analyst for over two years, with experience spanning fintech and Web3. Most recently, I was at PYOR, where I built end-to-end data pipelines to automate large-scale crypto data scraping and developed dashboards in Superset to track key market metrics. I also collaborated with business teams on investment insights and social sentiment analysis. Before that, I worked at Mitiosys, where I focused on SQL optimization, customer analytics, and helped deliver dashboards that influenced marketing and sales strategies. I’m well-versed in Python, SQL, and data visualization, and I enjoy solving real-world problems with data. I’m particularly excited about GeoIQ because of its focus on spatial and hyperlocal intelligence—an area I’ve started exploring and would love to grow deeper in.

Location

Bengaluru

AI stack

claude code

cursor

langchain

lovable

ChatGPT

Chroma

Work experience

Data Analyst at Flipkart, Sep 2025 - Present · 1 yr, Bengaluru, Karnataka, India, Analyze and reconcile large financial datasets across banking and internal systems using SQL and Excel. Perform root cause analysis on reconciliation mismatches (OD/OC variances) to identify systemic issues. Build automated reconciliation and validation workflows using SQL and Python, reducing manual effort. Support month-end closing and audit processes through accurate reporting and variance tracking. Develop dashboards and reports for finance teams to monitor discrepancies and trends. Collaborate with finance, audit, and operations teams to ensure data accuracy and compliance. Explore automation and AI-assisted workflows to improve reconciliation efficiency.

Data Analyst at PYOR, Nov 2023 - Mar 2025 · 1 yr 5 mos, Bengaluru, Karnataka, India, Built automated web-scraping pipelines using Python (Scrapy, BeautifulSoup) to collect cryptocurrency market data. Reduced manual data collection effort by ~80% and saved ~70 hours/week. Performed exploratory data analysis on large crypto datasets to identify trends and anomalies. Built dashboards tracking price trends, trading volume, and market metrics using BI tools Supported venture investment decisions by delivering data-driven reports and insights. Conducted sentiment analysis and competitor intelligence using scraped social data. Transformed raw datasets into structured formats for analytics and modeling. Collaborated with business and marketing teams on data-driven initiatives.

Data Analyst at Mitiosys Services Pvt Ltd, Jul 2022 - Oct 2023 · 1 y 3 mo, Noida, Uttar Pradesh, India, Performed data cleaning and exploratory analysis on sales and customer datasets. Optimized SQL queries, improving execution performance by ~40%. Built dashboards and reports to support business decision-making. Conducted customer behavior and revenue analysis. Supported data-driven initiatives that contributed to revenue growth. Worked with structured and unstructured datasets for analytics.

Education

Bachelor of Engineering - BE, Mechanical Engineering, Maharana Pratap College of Technology

Public links

github: https://github.com/Arjun-A-Pathak