As a management consulting professional, I drive execution of data science roadmap with clients across geographies by defining business problems, consolidating findings and hypothesising the solution.Previously, I have helped retail clients optimize their category management, pricing, and vendor negotiations. I have partnered with leading retailers, e-commerce and wholesale players to deliver significant margin improvements and COGS savings, using tools such as Tableau, Alteryx, Power BI, SQL, Python, and Excel.I graduated with an MBA degree from the Indian Institute of Management, Shillong in April 2022. I have 5+ years of prior experience in retail analytics and data warehousing, enabling businesses to make data-driven decisions. I am passionate about mentoring teams and fostering a culture of excellence and continuous improvement.
-
Senior ConsultantMonitor DeloitteHyderabad, In -
Management ConsultantSigmoid Jun 2024 - Present• Analyzed data and consolidated findings to hypothesize the solution for logistics network optimization for OTC Pharma client• Helped OTC Pharma client develop analytical solution to increase visibility on their UK outbound logistics network and identify opportunities to reduce the cost to serve through order consolidation and MOQ optimization• Drove execution of the data science roadmap on a $500K project for a US Based med-tech client by demonstrating techno-functional consulting & stakeholder management capabilities in collaboration with data science SMEs and teams -
Project LeaderBain & Company Apr 2024 - Jun 2024Bengaluru, Karnataka, India• Led teams of up to 8 members, prioritized and allocated work, set expectations with stakeholders and developed solutions with highest standards of analytical rigor• Partnered with leading e-commerce player to transform fashion category management process (including category roles, assortment width and depth, brand trade terms and pricing) to unlock margins• Developed a Tableau toolkit to track supplier input cost inflation, a major lever in negotiations for a European wholesaler• Support strategy-setting, assortment resets and vendor negotiations for ~30 major categories for a US-based wholesale club, delivering ~$40M+ in COGS savings (~2-5% of COGS, depending on the category)• Developed training modules for client workshops on merchandizing and helped retail practice leadership in building the storyline for a client pitch on assortment localization • Mentored associates, analysts, and interns in the newly formed Bangalore team for a smooth transition into the role• Heavily involved office building activities such as organizing CoE offsites, fun events and L&D initiatives at BCN Bangalore • Designed and conducted interactive workshops on technical topics like SQL and PowerBI -
Senior AssociateBain & Company May 2022 - Apr 2024Bengaluru, Karnataka, India -
Office Bearer, It CommitteeIndian Institute Of Management, Shillong Nov 2020 - Mar 2022 -
Summer InternBain & Company Apr 2021 - Jun 2021 -
Data AnalystSymphony Retailai Jan 2020 - Aug 2020Bengaluru Area, IndiaAnalysed transactional and loyalty card data to solve problems related to client’s business.Distilled key insights from customer data that address the objectives of the analysis and prepared client-ready presentations that deliver these insights effectively.Provided actionable recommendations to address the business question asked.Used segmentations, summative analyses, and predictive modelling to deliver solutions to client challenges.Created detailed process document and QA checklist for all projects.
-
Programmer AnalystCognizant Nov 2018 - Jan 2020Bengaluru Area, IndiaDatawarehouse Developer working on technologies such as Teradata, Hive and Amazon Redshift. -
Programmer Analyst TraineeCognizant Nov 2017 - Nov 2018Kochi, Kerala, IndiaWorked in the Artificial Intelligence and Analytics department as a Datawarehouse developer.
Ankan Dutta Skills
Ankan Dutta Education Details
-
Master Of Business Administration - Mba -
Computer Science
Frequently Asked Questions about Ankan Dutta
What company does Ankan Dutta work for?
Ankan Dutta works for Monitor Deloitte
What is Ankan Dutta's role at the current company?
Ankan Dutta's current role is Senior Consultant.
What schools did Ankan Dutta attend?
Ankan Dutta attended Indian Institute Of Management, Shillong, Institute Of Engineering And Management, South Point High School, Kolkata.
What skills is Ankan Dutta known for?
Ankan Dutta has skills like Teradata, Data Warehousing, Microsoft Powerpoint, Data Analysis, Load, Retail Sales Analysis, Hadoop, Amazon Redshift, Microsoft Office, Database Management System, Microsoft Excel, Automation Tools.
Who are Ankan Dutta's colleagues?
Ankan Dutta's colleagues are Shawn Seungju Lim, Raihyun Kim, Vittoria Delsedime, Zihan(joe) Chen, Leo Wang, Sunny Shekhar, Sib Atif.
Not the Ankan Dutta you were looking for?
-
Ankan Dutta
Consultant @Fractal.Ai| Ex Ipsos | Marketing Mix Models, Machine Learning, Optimization StrategiesBangalore Urban1ipsos.com -
Ankan Dutta
Bengaluru -
ANKAN DUTTA
Trainee @ Labvantage | 3× Azure Certified | Ieee Author | Ex-Intern @ Stqc; Celebal Technologies; Persistent Systems | Sbh-2023 FinalistKolkata
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial