Utkarsh Goyal Email & Phone Number

Gurugram, Hr, In

Noida, Uttar Pradesh, India

Optimized SKU volume data retrieval from Matrix Volume Research tool using SQL queries; validated data against customer contracts, ensuring accuracy and compliance.Spearheaded the implementation of a Power BI Dashboard, enabling real-time monitoring of SKU performance; leveraged data-driven insights to optimize distribution strategies, resulting in a 10% reduction in carrying costs.Automated reports through VBA (Visual Basic for Application) which impacted the performance and increased the report frequencies up to 3 times a day.

Gurgaon, Haryana, India

My key role was to automate, maintain and create reports and Dashboards with Excel and Power BI, automate reports with VBA (Visual Basic Application) reduce human efforts by 80% and impact the outcomes.Implemented a Power BI Dashboard for the collection team which highly impacted Account Receivables and reduced customer's aging Invoices and helped management to track employee performance.Designed Dashboards for optimizing the Avaya call quality, which has insights to monitor Total inbound and outbound calls, over-call resolution, Average time on a call, Mean time to receive a call and track calls escalated to level 2.

Gurgaon, India

Maintaining accounts receivable for individual customers, and comparing their version of outstanding receivable balances to the company's versionEnsure that transactions have been properly authorized. Especially, if the source documents are paper-based, review for potential changes to the document between approval and processing of transactions.Verify the recording of transactions in a timely manner. Review source documents to ensure they are processed and posted in a timely manner by the processing department. If not, follow up with the appropriate central office or processing department.

Bachelor Of Commerce - Bcom

B.com

Master'S Degree, Business/Commerce, General

Data Science, Data Science