Results-driven analyst with 2+ years of experience in planning, building and testing scalable data solutions that deliver measurable business impact. Proficient in Python, SQL, Alteryx and advanced Prompt Engineering, with experience in configuring internal automation solutions that leverage Custom GPTs. Proven track record in migrating Alteryx Designer 2020.3 workflows to robust and scalable Python and SQL-based ETL pipelines, optimizing data intensive I/O operations, thereby reducing turnaround time by 30%, and leveraging Generative AI to drive innovation. Successfully led 5 intra-CoE technical sessions, including 3 focused on GenAI, and organized a one-day bootcamp for 115+ participants, upskilling them on Custom GPT configurations, best practices for engineering zero-defect prompts, and highlighting potential AI-driven solutions for accelerating client-facing processes within Bain's Retail CoE.

• Retail Spotlight Award - Quarter 1, 2024, Bain & Company
  • Recognized for outstanding performance and valuable contribution to the Retail CoE (Centre of Excellence).

• Bain & Company | Senior Analyst
  Oct 2024 – present
  Gurugram, India

  • Technical Case Project: Developed Python-based ETL pipelines by migrating Alteryx workflows to modular scripts for an Australian pharmaceutical company, achieving a 33% reduction in data processing turnaround time.
  • Managed and processed client datasets exceeding 500 Gigabytes using Polars and Dask, scaling data operations and reducing retrieval time by 30% through strategic use of Parquet file formats.
  • GenAI Leadership and Solution Development Initiatives:
    1. Led 3 Skill Spark sessions for the Retail CoE, focusing on Generative AI and Python-based use cases, including configuration and testing of Custom GPTs and practical prompt engineering applications.
    2. Organized a comprehensive, 1-day Generative AI solution-building bootcamp, which significantly advanced project-oriented capabilities among over 115+ members of the Retail CoE.
  • Designed custom GPTs to summarize Tableau dashboards, automate conversion of text-based XML files to Python scripts, shrinking development time by 80%, and high-speed debugging, while adhering to ethical AI principles.

• Bain & Company | Analyst
  Jan 2024 – Oct 2024
  Gurugram, India

  • Technical Case Project: Developed Python and SQL-based ETL pipelines for a leading British and Irish retailer, migrating Alteryx workflows to Python scripts, resulting in ~27% reduction in turnaround time.
  • Built and optimized SQL queries to extract bulk client data from AWS Redshift, improving processing speed by 16%.
  • Contributed to the development of a Python-based automation tool to streamline SQL Server data refreshes for a case involving an American regional warehouse club chain, resulting in a ~50% reduction in upload time and ~70% reduction in manual efforts.
  • Collaborated on 4 POC projects by building interactive web-based apps using Dash to address limitations in Tableau.
  • Coordinated 2 high-impact case deliverables and internal automation tools using Git, ensuring efficient collaboration.

• Highradius Technologies Pvt Ltd | Product Engineering Intern
  Jan 2022 – Apr 2022
  Bhubaneswar, India

  • Created an advanced FinTech web application for managing B2B invoices, integrating AI capabilities.
  • Improved model accuracy by meticulously cleaning and refining raw datasets using Python, enhancing the performance of the machine learning pipeline.
  • Boosted predictive accuracy for customer payment dates by 12%, achieving a robust regression model score of 94%.

• Languages & Tools: Python, SQL, C/C++, HTML, CSS, Git, OpenAI
• Python Libraries: Pandas, Dash, Dask, NLTK, TableauHyperAPI, NumPy
• Data Visualization: Plotly, Matplotlib, Seaborn, ggplot
• Tech Stack: Visual Studio Code, SSMS, DBeaver, Alteryx, Tableau, Advanced Excel
• AWS Services: Amazon Redshift, Amazon S3 Buckets, Amazon EC2

Feel free to connect with me on LinkedIn to discuss analytics, data, or anything tech-related.