Experience

WyzMindz Solutions Pvt. Ltd.

• India
• Information Technology & Services
• 200 - 300 Employee

• MIS Reporter

  • 2014 - Present

  Total Experience only 8.7 years.  Presently working for Lenovo from Wyzmindz Solution Pvt. Ltd.as analyst in MIS Reporting (Metrics) since April 2014. Job profile includes: 1. I have down loading data from Lenovo Tool and interpreting the same in excel in various forms as mentioned below.  Expert in analyzing data using the advance features of excel  Analyzing data using advance excel feature and functions  Ability to automate the repetitive task performed in excel, by using VBA/Macros  Generating summarized report using Pivot Tables  Creating Dashboard by charting of summarized report in excel  Develop graphs, reports, and presentations of business results Technical Skills:  Expert in Usage of advance “MS Excel” features,  Pivot tables Analysis and Charts, advance complex functions  Linking of one file to another file.  Usage of more than If formulas.  Usage of many excel functions like Conditional formatting, Auto formatting, Filter & Advanced Filter, Match index, Lookup, V Lookup, H Lookup, Sum, Sum if, Sum product, Average ,Count if , Validation, Define creation & Macro creation.  Constructing various charts, graphs. ex:- bar graphs, line graphs.  Ability to create presentation using PowerPoint  Working in SAP for MMR creation, BOM creation, and Routing display. 2. Responsible to send the daily, weekly and monthly reports to the managers which include parameters like efficiency, productivity & OEE reports. 3. Responsible to check the purchase orders and ensure weekly report of all the orders placed has been circulated internally. Implement and maintain 5S system for efficient House keeping. Qlikview • Have knowledge about creativity and design • Ability to create simple queries, both Load, Left join, Right join, Mapping and Chart • Ability to understand Pivot Table, Hyperlinks and can use joins effectively while retrieving data Show less