Nidhi Arun Harwani

Data Analyst @Tata Consultancy Services

Created a dashboard using Spotfire to give a holistic view of cash performance. Developed automated ETL processes in Talend to populate the report weekly- Designed a drill-down feature in the dashboard to get a detailed transactional view based on divisions and product lines to give more visibility to the users. Created a Confluence doc to communicate the feature to stakeholders- Backfilled data for previous years to reallocate the invoices to relevant divisions- Automated the allocation of invoice data into divisions and highlighted top customers using an Alteryx workflow that reduce runtime by 70%- Refactored legacy queries that helped reduce time spent during deep dives. Optimized PostgreSQL queries to reduce the cache time by 60% to faster dashboard refreshes- Initiated the process of eliminating underutilized dashboards from our system. Decommissioned 20% of the overall reports developed by the finance team- Built a monthly roll forwarding report that used the Invoice and Customer level data to showcase customer debt.