Simran Saha

Experience

• 

  Capgemini

  Aug 2016 - May 2020

  Associate Consultant

  • Worked as a Data Analyst in the project to analyze data requirements used to support business processes.• Experienced in managing, cleaning and EDA of large datasets using statistical packages in R and Excel Macro Programming.• Writing the SQL queries to produce desired data, tuning the SQL performance and doing validations• Review the requirements and analyze the data using statistical techniques. Collect any missing details required from the onsite coordinator. Coordinate with the team and get the insights delivered within the promised timeline• Use Web Data Connectors to pull in data from website and produce visualization on the live data. Responsible for dashboard design, layout and development. Use parameters and input controls to give users control over certain values. Show less

• 

  Amazon

  May 2020 - Dec 2021

  Data Analyst

  * Developed and deployed a sales prediction model for a leading brand using decision trees, random forests, and gradient boosting. Conducted extensive data gathering and analysis, incorporating historical sales, customer demographics, product information, pricing, and marketing campaign data to identify key sales performance driversCreated an automated reporting dashboard utilizing Redshift SQL, Excel, and Tableau for Amazon's* Launchpad team, reducing manual efforts by 60% during high-traffic events like the Great India Festival and Prime Day* Developed a Seller Retention Model using regression techniques to predict 3-month seller attrition based on behavior, transaction history, performance metrics, and marketplace dynamics. Identified key churn factors to inform retention strategies Show less

• 

  Tredence Inc.

  Dec 2021 - now

  * Engineered and automated a price elasticity model using ML algorithms (Double ML, GAM, Log-Log) within Spark for large-scale data processing. Conducted data engineering, feature engineering, and model building, and developed pricing dashboards for detailed insights and analytics.* Implemented test-control mapping using K-Nearest Neighbors (KNN) and regression techniques, enhancing prediction accuracy and model reliability. Applied advanced algorithmic optimizations and computational efficiency improvements, reducing model runtime from 1 hour to 15 minutes.* Generated dashboards with quick filters, parameters, and sets for efficient data views, and optimized advanced SQL queries for data extraction and error reconciliation for Walmart accounts Show less

  • Associate Manager

    Jan 2023 - now

  • Data Science Consultant

    Dec 2021 - Jan 2023