Ujwal Gupta Email & Phone Number

New Delhi, Dl, In

Gurugram, Haryana, India

Gurugram, Haryana, India

● Engineered multiple performance reports, resulting in a remarkable reduction of agent downtime by an average of 0.30 hours/day● Orchestrated the seamless migration of a crucial data visualization process from Tableau to Qlik Sense, demonstrating autonomous leadership and technical prowess● Guided a dedicated team in the development of daily critical reports and processes, now acknowledged as industry standard in the field of reporting● Meticulously designed compelling Tableau dashboards, highlighting expertise in intricate calculations, parameter integration, geographic mapping, and performance optimization to elevate data visualization impact.● Guided junior team members in best practices related to business analysis techniques.● The implementation of capacity planning matrix led to a notable 1% improvement in attrition forecasting accuracy.

Delhi, India

● Established automated reporting systems for critical financial metrics in support of monthly public earnings for one of Uttar Pradesh, India's largest electricity distributors.● This initiative streamlined processes, saving 14 man-hours monthly by replacing manual efforts.● Teamed up with product and marketing departments to pinpoint pre-client interactions that significantly boosted conversion rates by 18%.● Engineered an advanced inventory tracker matrix to assess the weekly index quality of stock for a leading FMCG company.

Delhi, India

● Constructed over 50 comprehensive Tableau reports, dashboards, and metrics within the EDW, yielding a remarkable 45% enhancement in client efficiency● Established a robust data and reporting infrastructure employing Tableau, SQL, offering real-time insights into product performance, marketing funnels, and key business KPIs● This initiative resulted in an 11% boost in automation capabilities ● Implemented process enhancements via A/B testing and optimization of client data, leading to a notable 17% increase in conversion rates.

Delhi, India

● Brought forth strong analytical skills and judgment capabilities to solve complex business problems. Daily analysis of MIS Reports for follow up and coordination with cross functional teams to ensure timely flow of MIS.● Formed hypotheses and performed EDA techniques using Python and SQL to determine viability of datasets● Created various SQL queries to extract data from multiple sources for reporting purposes.

New Delhi, Delhi, India

● Used advanced Microsoft Excel like Pivot tables, V-Lookup, Macros, and Advance Filters etc.● Analysis of reports including process dashboards & initiate appropriate action plans.● Conducted due diligence and background checks as part of case preparation.

New Delhi, Delhi, India

● Financial model development in Excel using Pivot and solver base query.● Assisting other department in automating reports through charts and graphs.● Managing ongoing reports and databases for the project.● helping financial associates in critical and advance formulas.

International Certification In Product Management, Product Management

Post Graduate Programme, Data Science And Business Analytics

Bachelor Of Commerce (B.Com.)

Bachelor Of Laws - Llb, Law

Chartered Accountant, Audit

Senior Secondary School, Commerce

Secondary School