Subhendu Bhattacharjee

Experience

• 

  Reliance Communications

  Sept 2006 - Sept 2007

  Customer Care Executive

  Performed assignments in related to Reporting processAnalyze and acquire data from multiple data sourcesUsed Advanced Excel for preparing reporting template and for Reporting processesPreparing daily, weekly and monthly report regarding agents call details (AHT, ACD, ATT etc.)Preparing quality report for managementPreparing other MIS/ Ad-hoc reportsPreparing various charts for management

• 

  Wipro

  Jul 2008 - Jul 2009

  Senior Associate

  Performed assignments in related to Reporting processAssist and develop excel models and frameworks on excelAnalyze and acquire data from multiple data sourcesUsed Advanced Excel for preparing reporting template and for Reporting processesCreated various kind of Excel charts and graph for managementEnsured standard, ad-hoc reports are delivered as per scheduleMonthly Client Reporting and Analysis for Business PartnersReview and quality check other reports to ensure correctnessManage the claim processing activities as per aggressive deadlinesSupport other research team in answering data related inquiriesIdentifies and drives data issues to resolutionTaking care of claim inventoryParticipates in workflow analysis and business process analysis to identify and clarify requirements Show less

• 

  Unilever

  Feb 2010 - Dec 2010

  Zonal Sales Officer in HUL

  Performed assignments in related to Product Sales (Pure IT-Water Purifier)Responsible to achieve the sales target assign by HUL for 3 Zones (DTH) in Kolkata, Howrah and Hooghly (West Bengal)Manage a sales team size of approx. 45 members including 1 Assistant Manager and 3 team leaders for each Monitored day to day activities of all deputiesBeing a mentor needs to guide and showing the path of achieve the targets to all deputiesTaking care of other admin partAnalyzed and implemented sales strategy to achieve business requirementsMaintaining well relationship and affected communication with all distributorEducate distributor about Return of InvestmentTaking care of assignment of Post Graduate traineesUtilized the budget in affected and efficient way to do sales promotion Show less

• 

  Wipro

  Dec 2010 - Aug 2013

  Senior Associate

  Performed assignments in related to Reporting processAssist and develop excel models and frameworks on excelAnalyze and acquire data from multiple data sourcesUsed Advanced Excel for preparing reporting template and for Reporting processesCreated various kind of Excel charts and graph for managementEnsured standard, ad-hoc reports are delivered as per scheduleMonthly Client Reporting and Analysis for Business PartnersReview and quality check other reports to ensure correctnessManage the claim processing activities as per aggressive deadlinesSupport other research team in answering data related inquiriesIdentifies and drives data issues to resolutionTaking care of claim inventoryParticipates in workflow analysis and business process analysis to identify and clarify requirements Show less

• 

  Unilever

  Apr 2014 - Oct 2016

  Senior Software Engineer

  Perform assignments in related to Automation Process Lead and manage the automation effort for the team and identify and implement automation of manual activitiesProvide Cost Analysis and Time saving calculations associated with Automation ProjectPresent data and reports in an easy to ‘read and comprehend’ manner, bringing elements of design and automation which complement the Client’s objectivesEnsure standard, ad-hoc reports are delivered as per scheduleEstablishes Data Management standards, procedures and best practicesManage and process client reporting on specified scheduleReview and quality check other reports to ensure correctnessCompile and develop appropriate MIS for reporting to stakeholdersSupport a range of analytical projects includes report generation , complex automation using VBA codingWork on creative solutions that are robust and agile to further changePerform all requirements gathering efforts for assigned Reporting projects. Work closely with Business Process Owners and Business Process LeadsAnalyzes stakeholder needs, identifies gaps, and defines capabilities for an acceptable solution to the business problem Show less

• 

  Dimension Data

  Oct 2016 - Dec 2018

  Reporting Analyst

  Perform assignments in related to Reporting process Engineering, Data Analytics and Data Visualization Use Advanced Excel and VBA scripting for preparing reporting template and for Reporting process Automation Developing and publishing highly impacted Business/ Operation reports using Power BI for the Top Management (CEO, Sr. VP, VP and Director's level) Extract and load new data sources into SQL server using primarily the SSIS toolset Understand the new reporting requirement from various stakeholder and given appropriate solution to them Analyze and acquire data from multiple data sources Identify, analyze and interpret patterns in complex data sets Assist and develop excel models and frameworks on excel Analyze data to provide meaningful insights Participate in High level Reporting process Improvement discussion in related to effective and efficient use of resources Work with top management to prioritize business and information needs Taking technical interview (Advanced Excel) for all vertical of Dimension Data (Bangalore) Used to give Advanced Excel training to the new joiners (Once in a month with 2 session) Show less

• 

  Amazon

  Dec 2018 - now

  Being a part of Ops Excellence Program Team & key stakeholders to leverage our data to drive operational efficiencies, provide key data-driven insights, enable new opportunities and innovate on behalf of our Selling Partners Generating actionable Insights through Analysis of Key metrics across functions Identify the root cause through deep analysis of data to reach a point where actionable solutions can be designed Track, measure and report various initiatives to improve Selling Partner Experience Define Key metrics that need to be monitored to improve Selling Partner Experience Devise mechanisms for control, performance monitoring, and reporting to internal stakeholders Assist in investigating and drafting cost / benefit analysis and business requirements showcasing potential solutions for business initiatives Assist in the development of test plans for related new product launches and related compliance testing Working cross-functionally with business teams to ensure development and implementation of programs as per timelines Extensive uses of complex queries in Datanet (Oracle Redshift) Use Advanced Excel and VBA scripting for preparing reporting template and for Reporting process Automation Developing and publishing WW Ops Excellence reports using AWS Quick Sight Show less

  • Senior Business Analyst

    Oct 2022 - now

  • Business Analyst

    Dec 2018 - Oct 2022