Data Analyst
Ranchi, Jharkhand, India
Created monthly revenue dashboard in tableau from scratch andmaintained it .Builed Project financial closure for clients (JBVNL,NBPDCL,SBPDCL)Created reconciliation for different warehouses stocks. and final closures.Developed complex query to fetch acute insights from data base.Developed and maintain accurate tracking, capturing and reporting of key data to analyse the on going projects.Performed data extraction ,cleaning , validation to assist the data append.Created master data after collection from various data source.Did a data miming and analysis using pivot tables and charts in excel forover all achievement summery sheet.Created month over months and week over week calculations for Business profit and loss . Responsible of end-to-end business for various clients and contractors.Fetching sales data from data base to generate supply bills.