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, that brings out the best of my abilities is what motivates me. I enjoy analytics and enjoy presenting data in a visual way. I love what I do.

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• In-depth working knowledge of BI tools like Qlik and Salesforce• Finding solutions to the data management and reporting problems and adapt and modify solutions based on the changing requirements• Using analysed data to create reports identifying process improvement opportunities• Address several Ad-hoc requests in a timely manner by working closely with the Management

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 Expenses, Net Income, Profitability etc. • 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• Solely leading the team in manager’s absence• Leading client presentations during their visit

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)• Debt Service calculation and analysis of companies and individuals• Review of Deliverables to ensure that quality standards are maintained

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 • Worked on Moody’s Risk Analytics (MRA)• Provide training to new as well as existing team members• Was part of the Quality Check team within 6 months of joining• Review of Deliverables to ensure that quality standards are maintained