Shivam Gupta Email & Phone Number

Hyderabad, Telangana, India

• Established a BI team for centralized supply chain reporting and analytics.• Developed a Supply Chain Control Tower and mobile app, enhancing operational efficiency.• Led data architecture development using various tools, creating automated reports and dashboards.• Led Process Transformation projects including standardize and centralize the global projects using technology and process revamping.• Implemented data governance processes, enhancing data quality and reliability.

Hyderabad, Telangana, India

• Lead and manage data analytics projects for clients across various industries and sectors• Design and develop analytics modules and data mining/ analysis initiatives using various tools and techniques• Implement projects via Design-Built-Operate-Transfer approach for clients across sectors• Manage the development of data lake, data warehouse and analytics platforms to support business intelligence, predictive modelling, and advanced reporting capabilities• Collaborate with cross-functional teams to design and implement data-driven solutions for complex business challenges and opportunities• Set up procurement analytics function for a consulting firm and optimize payment terms and discounts• Champion an algorithm on AR data and increase collection rates during covid-19 period

Gurugram, Haryana, India

• Managed delivery of data analytics services to Business, Audit and Forensic teams to improve the effectiveness and efficiency of audit coverage• Created and delivered effective solutions to gather data, analyze it and provide information to key stakeholders, developing business strategies, and helping to increase revenue levels and reduce costing• Kept abreast of new tools and technologies to assist the team in creating the most efficient and effective data strategies• Analyzed and gathered the requirements in collaboration with the process/IT audit teams using various data analytics tools such as Alteryx, Power BI, Tableau, ACL, SQL, IDEA, MS Excel, MS Access and Monarch

Gurugram, Haryana, India

• Skilled in identifying the technical solutions and managing the delivery of data analytics services to Internal Audit teams to improve the effectiveness and efficiency of audit coverage• Led a large team of analysts to perform 300+ financial analytics projects for US clients using multiple tools and techniques. This included: o Analysing various financial and operational processes and internal controls o Performing revenue recognition and AP analytics for telecom industry o Conducting vendor management analytics using data visualization and automation tools o Managing data migration project• Gathered and analysed business data, made improvement suggestions• Contributed to providing objective assurance & advice that added value; influenced change that enhanced risk management, control & governance; and improved liability for results

Gurugram, Haryana, India

• Reviewed 10+ business processes of telecom clients to identify risks, investigate their root cause, quantify the loss and recommend solutions to mitigate them• Identified problem areas, gaps in existing solutions/processes and prepared gap analysis report with suggestive corrective measures• Conducted Internal Audit reviews of multiple business processes for a Metal and Mining client.

Gurugram, Haryana, India

• Performed critical research of airline ticketing databases and tools to control the cost written off on monthly basis for unrecoverable & untraceable amounts from customers• Created MIS reports for every month to analyze the working of team on different criteria & check the profitability on different matrix based on quality i.e. Six Sigma

Gurugram, Haryana, India

• Maintained financial model for 100+ different reinsurance program with coverage of 1K+ Corporate clients and ensured proper ceding of claims and expenses to the reinsurer as per the terms of reinsurance program• Controlled the expenses and looked at revenue generation by analyzing the claims and expense data on MoM, QoQ and YoY basis

New Delhi Area, India

• Managed 30+ bank accounts and intra-branch accounting of the broking firm• Generated MIS with key information related to all the bank accounts, minimum balances and the trade volume comparisons, bank reconciliations, Identify charges, penalties and interest levied• Ensured minimum balances in the bank accounts based on thousands of intraday transactions daily to meet the NSE’s requirements

Master Of Business Administration, Finance

Activities and Societies:  Council Member of Rotaract Club in college.  Active member of Alumni Committee of college.  Member of Toast.

Ca Intermediate

B. Com, Commerce

Bachelor of Commerce