ASHISH KUMAR AGRAHARI

Senior Data Analyst

Rentomojo•  September 2018 - Present

Roles & Responsibilities:  Manipulating, cleansing & processing data using Excel, R, Pyspark and SQL.  Responsible for loading, extracting and validation of data.  Analyzing raw data, drawing conclusions & developing recommendations.  Creating insightful presentations and visualizations using Excel & Metabase.  Designing, developing and implementing new functionality.  Supplying qualitative and quantitative data to colleagues & different departments.  Monitoring the automated loading processes.  Advising on the suitability of methodologies and suggesting improvements.  Making reporting system (Dashboards) for management and vertical heads.

Senior Engineer

L&T Hydrocarbon Engineering Limited•  March 2014 - November 2016

Roles & Responsibilities:  Planning all the project activities using Excel Spreadsheets.  Analysing required resources and available resources by using Excel Functions.  Making schedules of every project activity after consulting with client.  Monitoring and coordinating all the activities planning with their schedules.  Ensuring technical aspects of work and sorting out deviation.  Conducting review meetings and sorting of issues.  Making reports of progress in area specific format by using Pivot Tables & VLOOKUP.  Making graphs and dashboards by using Excel Functions and presenting it to the Managements.  Preparing and Analysing job costing, client and contractor bills.

Engineer

Zillion Infraprojects Private Limited•  August 2011 - March 2014

Roles & Responsibilities:  Plans, Controls and Coordinates all sites planning, scheduling with respect to the project.  Ensuring technical aspects of work and sort out deviation  Assists in preparing, updating, and monitoring schedules, and in preparing status reports.  Analysing the Sub Contractors schedule/Report: Sequencing, activity relationship, % completion.  Monitoring and updating of Daily, weekly and monthly plan and daily progress.  Preparing of RA bills and submitting to clients for approval.  Coordination with HO & site for procurement to ensure proper arrangement of resources.  Conducting review meetings and sorting of issues.