rishabh-panda / color-space-translator Goto Github PK

Business Analyst with experience in the retail sector. Demonstrated expertise in developing products and tools using Python, with a strong focus on data-driven decision-making. A published author in IEEE. Proficient in leveraging SQL, Alteryx, and Tableau, transforming complex data into actionable insights. Adept at collaborating with cross-functional teams to deliver solutions that drive business growth and efficiency.

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

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

  • Reprogrammed client-side Alteryx Designer workflows into optimized Python scripts, incorporating ETL processes to reduce execution time by 27% and significantly enhance data processing efficiency and workflow automation.
  • Optimized SQL scripts in AWS Redshift, boosting data processing by 17%, and managed 500GB+ client data storage in Amazon S3 buckets.
  • Hosted a session in the Retail CoE, which comprises around 100 individuals, showcasing innovative business use cases solved with Python, including those integrated with AI, highlighting the practical applications achieved.
  • Utilized Dask framework for parallel computing & distributed data processing, effectively handling Big Data.

• Bain & Company | Analyst Intern
  Jan 2023 – Dec 2023
  Gurugram, India

  • Developed dynamic web applications using the Dash framework to overcome specific functional & visualization limitations inherent in Tableau.
  • Managed SQL Server databases for over 7 projects, writing complex queries, improving scalability.
  • Built a custom Python tool to streamline client-end raw data uploads, featuring a user-friendly menu for data manipulation directly on the server, improving efficiency and client data processing capabilities.

• 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.