I Having 2.8 years of Experience as an MIS Analyst with strong analytical skills.

•  Expert in understanding data and pivoting in excel.
   
   
• Analyze data and create reports in a presentable format.
   
   
• Convert raw data to usable and manageable information.

• Good experienced in VLOOKUP and logical functions such as if, Sum if, Sum ifs, Count if, Count A, Count Blank etc. are used to populate the report data based on the existing data.

• Mainly Using VLOOKUP, Hlookup, Match, Index, Pivot Table, and Auto-Filter for generating the Reports.

• Comfortable with generic excel formulas, conditional Formatting and data validations.

• Coordinate with process managers for data collation and reporting. 

• Consolidation reports by macros vba loops .

• Segregation by a loop reports