Sandeep Mangu

Experience

• 

  Google India Pvt. Ltd.

  Jun 2012 - May 2013

  Business Process Associate

  Google India Pvt Ltd. Worked in a client location for “Google Merchant Center”, Deputed as “Business Process Associate" on behalf of Randstad India Pvt. Ltd.Work Description:Responsible for converting raw data from the feeds into useful information, after screening scrutinizing, and trimming the data; which are then used to upload onto their respective client’s E-Commerce website for online shopping. By doing so, the process helps the client to get global coverage, customer attraction, and better branding resulting in a 13 % increase in sales through these discount brochures.Responsibilities:• Raw data is in the form of PDF documents and useful information extracted from it is populated in Google Spreadsheets called Trix.• Responsible for creating feeds by compiling data in spreadsheets based on scanned PDFs (Feed) by the use of Google Cloud Storage, a product that gives fast data access, reliable infrastructure, and unlimited storage options, to share the PDF file.• Work with complex data feeds. Implement VB rules as necessary to improve data feed structure.• Responsible for mentoring/training new associates and floor support.• Reviewing and updating the team on new policies.Clients: • Wal-Mart• Macy• OfficeMax• Kohl's• Walgreens• Wal-Mart Canada• Office Depot• Rite Aid• Old NavyTechnology: • Google Spread Sheets, Google Drive, Windows 7. Show less

• 

  Amazon

  May 2013 - Apr 2016

  I was a PMO in Business operations drive various programs such as selection, creation, and selection quality across multiple categories for the Amazon Marketplace that result in improving the selection of products on Amazon and driving important business goals by improving the quality of the Catalog and the website through various projects aligned.Job Responsibilities/Accomplishments: • Designed, Conceptualized, and refined process for content and catalog audit, targeted content & catalog correction. • Performed root cause analysis & impact analysis of the problems detected and devise (mitigation & prevention) measures through data analysis, content & catalog audits. • Served as SME for the team and suggested tool improvement and process improvement ideas for multiple processes which resulted in significant efficiency improvements. • Targeted Catalog Corrections: Semi-automated duplicate, Variation, Essential Catalog Feature Review+A10• Catalog Quality Audits: Customer Perceived Duplicate (CPD), Variation, Normalization, Price Per Unit, SOPs for multiple projects while taking the ownership of flagging & fixing any process flaws.• Machine Learning Training Set Generation: Key Phrase Extraction (KPEX) review, Duplicate Detection review, working on managing the product detail pages • Content management of a detail page such as titles, descriptions, variations, images etc.• Correcting and enhancing existing content of products that have high visibility on the Amazon website but show poor content. • Played a pivotal role in streamlining the process, had created reporting Metrics on a weekly basis and delivering the report to discuss metrics, team issues, process improvement ideas, etc. For all major stakeholders associated with the Business Operations.• Created the SOP for SHELL ASIN's. This document is a one stop for training for identifying the Null ASIN's, Fake ASIN's, Detecting Duplicate ASIN's for sales team in major global sales center. Show less

  • Catalogue Specialist | Project Management

    Jul 2014 - Apr 2016

  • Business Operations Specialist

    May 2013 - Jun 2014
• 

  GATI-KWE

  Apr 2016 - Jan 2017

  Assistant Manager - PMO | Forecasting and Capacity Planning

  • Recognize, follow and analyze the market trends. • Month on Month Projections and Volume forecast across all E-Commerce Clientele accuracy of +-15%.• Review Historical Sales trends, Research activities to reconcile significant variances and refine the forecast model to reflect updated sales and marketing assumptions.• Closely coordinate and communicate customer’s action plan with ground operations, client Interaction for Volume growth and projections.• Responsible for analyzing lane wise Performance and interacting with clients for volume growth as well monitoring ground operations performance.• Ad-hoc Model for Market Place and FC Pick Up Model and IT Process Change Requirement as per business dynamics.• Capability and Capacity development.• Achieve consensus for operational demand forecasting by facilitating a collaborative planning process with sales, operations, capability and ground operations teams.• Review Sales plans, customer finance budget updates or latest estimates and demand drivers.• Review customer promotional planning with sales team.• Provide Ad-hoc forecasts, sales and prepare to achieve reports as requested to assist management decision.• Identify the process improvement opportunities and present them to senior management with recommendations and alternatives.• Conceptualize and work with cross-functional teams to create scalability tools to increase work efficiency. Show less

• 

  Deloitte India (Offices of the US)

  Feb 2017 - Feb 2021

  Resource Planning and Allocation:• Collaborating with project managers and engagement leaders to understand project resource requirements.• Assessing the skills, capabilities, and availability of resources within the organization.• Developing and maintaining a resource plan to ensure optimal utilization of available resources.• Allocating resources to projects based on their skills, experience, and availability.Talent Management and Development:• Identifying skill gaps and development needs within the resource pool.• Collaborating with HR and learning and development teams to develop and implement training and development programs.• Assisting in the career development and progression of resources within the organization.Resource Forecasting and Demand Management:• Collaborating with business leaders and project teams to forecast resource demands.• Analyzing project pipelines and resource requirements to anticipate future resource needs.• Participating in resource demand management discussions and decision-making processes.Resource Utilization and Reporting:• Monitoring and tracking resource utilization, including billable and non-billable hours.• Analyzing resource utilization data and identifying trends, patterns, and opportunities for improvement.• Generating regular reports and dashboards on resource utilization, availability, and performance.Relationship Management:• Building strong relationships with project managers, engagement leaders, and other stakeholders.• Collaborating with client service teams to understand project priorities and resource needs.• Managing conflicts or issues related to resource allocation and balancing competing demands.• Facilitating effective communication and coordination among project teams and resources. Show less

  • Resources Manager | Senior Analyst

    Jun 2018 - Feb 2021

  • Resource Management | Senior Analyst

    Feb 2017 - May 2018
• 

  NTT DATA Business Solutions India

  Feb 2021 - now

  • Deputy Manager - PMO

    Apr 2022 - now

  • Assistant Manager - PMO

    Feb 2021 - now