Jay Gupta Email & Phone Number

Noida, Uttar Pradesh, India

• Developed and implemented a detailed excel based invoice tracker, boosting invoice processing efficiency by 20% and improving the tracking of financial transactions by 40%.• Performed analysis on the financial Data and built & visualized sales, purchase, and profit dashboards using PowerBI, providing actionable insights that boosted financial reporting efficiency by 25%.• Engineered a Python-based automation script for invoice creation, eliminating invoice creation time by 75% and minimizing manual errors by 95%.

Agra, Uttar Pradesh, India

• Performed Sales Trend Analysis, Utilizing SQL and Advanced Excel to gather, sort and analyze 5L+ rows of data, identified top-selling products and key revenue metrics, which optimized assortment and guided strategic marketing initiatives.• Devised 4 HR dashboards, leveraging PowerBI and Excel, analyzed overtime patterns and demographic distributions, aiding in effective workforce management.

Noida, Uttar Pradesh, India

• Delivered financial statements mix models and key actionable insights for 2 clients, utilizing SQL and Excel which resulted in 30% increase in auditing accuracy. • Built 5+ financial dashboards using PowerBI that reduced manual reporting and saved 100+ monthly man-hours. and increase efficiency by 20%.• Formulated 3 new dashboards and 10+ reports including sales, cost reports and other key financial reports to enable regular KPIs tracking and facilitate data-driven decision making across business functions. Coordinated with 4 cross-functional teams to understand their requirements, to gather relevant data, and to streamline processes.

Gurugram, Haryana, India

• Led external audit of 7+ US Technology, Media, and Telecommunications (TMT) companies including Alphabet Inc. & Western Union Co., Focusing on audit areas such as investments, cash, equity & Derivatives.• Utilized advanced data analysis tools including Excel, PowerBI, and One GLA to examine clients’ financial documents, uncovered irregularities, resulting in a 20% increase in audit efficiency and accuracy.• Developed techniques to optimize quality checks of various financial documents, and identified and recommended process improvements to clients, leading to significant cost savings and a 15% increase in operational efficiency.• Leveraged advanced analytical and data management techniques to conduct comprehensive audits, resulting in the identification of key financial insights, leading to a 10% increase in overall financial reporting.

Shikohabad, Uttar Pradesh, India

● Systematically reviewed monthly GST transactions for discrepancies, leading to the recovery of ₹5 Lakhs in misreported taxes● Advised 20+ clients on compliance with tax regulations and deadlines and assisted them in monthly and quarterly GST returns filings, resulting in a 30% reduction in compliance-related queries and 100% on-time filing

Hyderabad, Telangana, India

Bachelor Of Commerce (B.Com.), Business Studies, 9.06

Business Analytics & Ai Master Program, Data Analytics

Intermediate

Intermediate, Accounting, 76%

High School, Accounting, 83.6%