M A Majeed

Experience

• 

  Han Digital Solution

  May 2017 - Aug 2018

  Reporting Analyst

  • Responsible to build a quality collection of interesting companies in the assigned industry by the client.• Performing Secondary research by going through the articles posted by the companies, annual reports and press release in-order to generate valuable insights.• Extracting the data from the source files using Vlookup, Hlookup, Index, Match, finding and removing duplicate values using advance duplicate technique.• Cleaning the data using string functions like trim, clean, left, right, mid, substitute and replace.• Creating Slicers, timelines and pivot charts in-order to analyze the data, preparing reports which may be in the form of visualizations such as graphs, charts and dashboards.• Conducting daily review meetings with manager, actively seeking feedback on the quality and implementing suggestions as required. Show less

• 

  Izmo ltd

  Sept 2018 - Sept 2019

  Reporting Analyst

  • Worked on an E-commerce project where my responsibility was to analyze the manufacture and build a list of automotive accessories sold by the manufacture.• Extracting data from source sheet and comparing the source sheet data with newly released report and check for the new automobile parts released by applying conditional formatting.• Gathering the data related to the car accessories such as part name, part description, make, year, model, cost, installation time using macros, vlookup, index and match.• Cleaning the data using string functions like trim, clean, left, right, mid, substitute, replace and expanding the car model names by referring models sheet.• Removing duplicate values from the sheet using advance duplicate technique.• Preparing price report by making use of arithmetic operators such as sum if, count if, average if and relation operators.• Performing quality check on the reports using pivot tables and finally load the reports into the backend server. Show less

• 

  Tesco Bengaluru

  Oct 2019 - Mar 2021

  Associate Data Analyst

  • Extracting the source files from the portal, cleaning the data using String functions such as Left, Right, Clean, Trim and preparing the sales report which provides the sales data generated by the stores on monthly basis• Preparing Sales evaluation reports using Arithmetic operators such as Sum If, Count If, Average If, studying purchase trends of consumer base and analyze consumer behavior• Preparing the Work Order report using lookup functions such as Vlookup to generate the number of Work orders closed by the technicians• Preparing the Refrigeration health reports which provides the temperature details of the devices operating in the stores• Creating Slicers, Timelines and Pivot Charts in-order to view and analyze the Sales data, Work Orders data graphically Show less

• 

  Singapore Based MNC

  Apr 2021 - now

  Confidential

  • Preparing financial reports using Arithmetic Operators such as Sum If, Count If, Average If in-order to provide the revenue generated by the accounts on monthly basis• Creating Pivot Tables, Analyzing and Interpreting financial data to identify revenue trends and forecast future revenues• Collaborate with Sales and finance teams to develop and implement revenue enhancement strategies• Preparing Line Graphs and dashboards to generate revenue trends and analyze the Sales performance• Fetching the data from the source files to the master file by applying functions such as Vlookup, Index and Match to generate salary report• Preparing Recruiter KPIs and dashboards to analyze Recruiter performance and providing insights to the team in-order to improve the performance Show less