Sanjoy Dutta Email & Phone Number

Bengaluru, Karnataka, India

• Provided administrative support to the immigration program by assessing applications, thoroughly examining their completeness as per the regulations of Immigration Refugee Protection Act (IRPA) and adhering to high standard of values and ethics.• Lead the Client Service Unit that was responsible for responding to external enquiries by adhering to standards and timeliness.• Devised and published quarterly snapshot on client enquiries using PowerPoint, utilizing Advanced Client Enquiry Triaging System (ACETS) to categorize, compare and analyze emails based on their use-cases.• Supported the administrative needs of the Immigration Program section, by organizing activities, liaising with the vendors for purchase of office materials, researching for flights on behalf of IPM and others.• Collaborated with team members to raise funds for Government of Canada Workplace Charitable Campaign (GCWCC) • Created an excel-based tool that helped in segregation of files by scanning bar codes and matching them with the extracted data simultaneously. This process resulted in reducing effort & time. • Extensively used virtual platforms like Microsoft Teams to collaborate, schedule meetings, train other team members during Covid.• Received Spirit Award 2019-2020 in recognition for team work and contribution towards public service.

Bengaluru Area, India

Analyzing new startups globally related to Food-Tech, Online Grocery and Retail sector based on their coverage, potential, funding, and business model. Rating them based on their performance, and publishing them in the company’s platform, that helped the investors in identifying companies for investment.  Everyday work includes identifying investible companies, doing background research about the founders, profile of the company, scope for growth, competitor’s analysis, publishing analyst notes, updating current news about the sector.  Managing a team of 5 members, with emphasis on quality, progress and throughput.  Helped clients with custom analysis requests and due diligence requests to help identify potential investments/acquisitions.

Bangalore

• Work with some of the major syndicated data like Europanel, Canadean, Euromonitor, Nielsen;preparing data using Advanced Excel understanding central tendency, deviations, outliers etc.• Day to day Analysis includes Driver Analysis, Equity Pyramids & Scores to understand brand's salience & disposition, their landscape, motivations , consumption etc.• Understand client’s brief, and fulfilling analysis as per their requirement by providing them insights to help them track their progress on monthly basis• Conduct extensive analysis for major beverage brands & competency mapping to track market trends and competitor moves and hence recommend strategies to sustain and improve the market share • Ensure absolute accuracy and strict adherence to the prescribed time lines & get repeat business by delivering client delight on every project undertaken• Understand data-outputs, identify patterns to conclude findings; stitch them into actionable insights and convert them into business presentations

Kolkata Area, India

• Analyzed Tiles Industry and its financials in order to provide support to the Sales Team with insights and recommendations which helped the front-liners in better sales pitch.• Examined Performance Review, Sales Plan, Stocks by extracting data from SAP; using Pivot, Adv Filtering, Conditional Formatting and given valuable insight at regular intervals• Tracked Daily Call Reports of the Regions and made several improvements e.g. finalizing on the optimum calls & the quality of data gathered• Prepared Month End Reports and Presented in the Zonal Managers Meet• Conceptualized, Analyzed & Tracked the New Product Development Activity and executed the marketing plan to launch the new Digital Tiles vis-à-vis the competitors across regions• Prepared the MIS for the Region & coordinated with HO for reports• Send Communications time to time to the Business Partners regarding Promotions & PR

Chennai Area, India

• Worked as Project Trainee (Market Research) for an extensive project on Usage & Attitude Study• Coordinated with the Field Centers on Quota achievement and daily status update• Checked for Outliers, Data Sanitary Check, Gathered insights on issues pertaining to the project• Actively participated in Preparation of Questionnaire and Analysis Plan• Prepared the Final Draft of the Presentation, e.g. charting out data from spreadsheets to display consumer profile and usage habits• Understood the different aspects of the project e.g. Brand equity, Disposition, Salience, Motivators & De-motivators, Awareness

Bangalore, India

• Promoted to Store Manager with T (top)-25 rating to manage LEE, WRANGLER Showroom.• Analyzed the past sales trend using Excel across various variables e.g. sex, age, sizes, apparel categories, that successfully helped in planning the stock for the upcoming season.• Administered customer relationship management program by maintaining database of the customer profile communicating them on regular basis which ultimately led to increased footfalls. • Maintained optimum inventory level for the store and prepared format for replenishment, stock take which led to better Control & Loss Prevention.• Created various Reports, Managed Sales, Billing, Stock Inward & Outward using ‘Shoper’, directed Visual Merchandise Displays, In-Store Promotions

Mba, Marketing Research, 7.66/10

Activities and Societies: SIFE (Name changed to Enactus)- Students in Free Enterprise, the world’s best-known and most successful program.

Bhm, Hospitality Administration/Management, 70%

Enjoyed learning about various cuisines of the world, helped in my personality development, made me aware about the hospitality services..

10+2, Computer Science, 79%

Activities and Societies: NCC A & B Certificate, Quiz, Debate, Cultural Programs, Sports & Games Physics and Mathematics were my favorite.

10Th, Cbse, 82%

Activities and Societies: News Reading, Quizzing, Running, All games & sports, Art & Craft