Isha Gupta Email & Phone Number

Auckland, New Zealand

Auckland, New Zealand

I pride myself in being a resourceful Data Analyst and visionary, experienced in managing large data sets and deriving actionable insights. I love balancing the analytical mind with creative data visualisations to represent complex analytics. I believe that any question can be answered with the right data and curiosity.I’m always looking to be challenged.

Auckland, New Zealand

Ellerslie

• Rigorously and effectively examine large data sets and derive insights for the management
• Automating reports using Macros and VBA to minimize human errors
• Led the effort to utilize VBA to automate the process; resulting in cost savings of $4K
• Designing and development of interactive dashboards in Excel for various campaigns
• Managing and preparing the massive Payroll Excel file for 200 employees every fortnight
• Creation of Commission Calculators for Agents and Team Leaders in Excel using Macro

Ellerslie

Gurgaon, Haryana, India

• Supported Market Relations Group for a U.S. based Bank.Responsibilities:
• Periodically conduct research on diverse topics for executive management meant to support CEO’s letter to shareholders, speeches and conferences etc.
• Preparation of Excel, Word document, PowerPoint using databases like SNL financial, IPREO etc. comparing an entity’s financial condition with its peers on different financial parameters - Revenue, Liquidity, Operating.
• Financial data of 33 banks was used to create the report for in a single document
• Address several Ad-hoc requests in a timely manner by working closely with team
• Leading weekly calls with the senior management of the Bank

Greater Noida, India

• Supported Credit Analysis Group for a U.S. based bank.Responsibilities:
• Financial Statement Analysis, which includes spreading of Financial Statements of companies and personal guarantors in Moody’s Risk Analytics (MRA) as per the bank’s guidelines
• Analysis of Income Statement, Balance Sheet and Cash Flow Statement
• Covenant Testing based on the definition in the credit agreement
• The quality of statements includes Audited Statements, Tax returns (Form 1065/ 1120S) and Internally Prepared Statements for Private companies and 10K/10Q for Public companies
• Individual’s Credit Analysis through Personal Financial Statements and Personal Tax Returns (Form 1040)

Gurgaon, Haryana, India

• Supported Credit Analysis Group for a U.S. based bank.Responsibilities:
• Spreading the Financial Statements of companies and personal guarantors in a rating tool as per the bank’s guidelines
• Analyzing the financial ratios of companies to check the credit worthiness, covenants test and profitability
• Analysis of Current Assets, mainly Accounts Receivables so as to check borrowing base of the companies for the working capital loan
• Individual’s Credit Analysis through Personal Financial Statements and Personal Tax Returns
• Preparation of detailed Credit Bureau reports for Individuals to analyze the credit history