Data Analyst
CurrentCleaning data and creating automation on Google sheet and Excel formula on advanced excel and making dashboards with help of Power BI.Data Visualization and dynamic/KPI dashboard through power BI and ExcelUsing advance formula and power query in MS Excel to solve and understand the company assets.Maintain and tracking the Sales and Purchase OrderRemoving corrupted data and fixing coding errors and related problemscreating dashboard/Meters and tracking orders on Zoho CRMBuild automated reports and dashboards with the help of Power BI and other reporting.Posting of customer’s payments based on different client’s payment filesClosure of accounts on basis of status of account (PIF/,SIF) and on client request.Monitor customer account details for non-payments, delayed payments and other irregularities.Account information such as customer’s name, address, SSN and other details.Changing status of account on basis of transactions performed with Ontario System Software.