Mayank Gupta

About Mayank Gupta

I build data and automation systems that replace manual effort with reliable, scalable workflows.Currently working as a Data Analyst in a FinTech environment, focusing on process automation, MIS reporting, and operational analytics across trading, KYC, payouts, and compliance workflows.Most of my work sits at the intersection of Python automation, SQL-driven reporting, and business operations, where speed, accuracy, and auditability matter.What I specialize in:Designing Python-based automation pipelines to eliminate repetitive BAU tasks.Building SQL reporting layers for daily, weekly, and regulatory MIS use cases.Integrating REST APIs and external data sources into internal systems.Developing Power BI dashboards for ops, finance, and leadership teams.Translating business requirements into production-ready workflows.Impact delivered so far:Reduced manual operational effort by up to 90% across KYC, payouts, and reminders.Improved reporting accuracy and turnaround time for daily FinTech MIS.Enabled better traceability through structured logging and reusable ETL components.Supported cross-functional teams with clean, decision-ready data.Tools I work with daily:Python, SQL, Pandas, NumPy, Excel, Power BI, REST APIs, Flask, Git(Exposure to PySpark, Azure Databricks, MLOps concepts)I operate best in roles where data directly improves execution, not just dashboards.

Experience

1. Analyst

   Pocketful

   Oct 2024 — Present · Delhi, IN

   Engineered Python-based automation workflows using Pandas and NumPy to streamline BAU reporting, reducing manual effort and improving data consistency.• Integrated REST APIs and web-sourced data into internal systems for market and operational tracking.• Automated KYC checks, payout processing, and debit reminders via Flask services and Excel–Python pipelines, cutting human intervention by ~90%.• Constructed parameterized SQL reports with CTEs and complex joins to monitor trading activity and operational metrics.• Implemented structured logging with rotating handlers, improving debugging, traceability, and pipeline reliability.• Partnered with product and operations teams to convert ad-hoc requests into reusable reporting and ETL components.

Education

• University of Delhi

  Bachelor of Commerce - BCom, Business/Commerce, General

• Sarvodaya Bal Vidyalaya, Vikaspuri

  Senior Secondary Education (12th), Commerce with Maths

• Devtown

  Data Scientist Industrial Training and Internship