Commercial Analyst

• Mar 2022 - Present

Commercial Analyst

• Mar 2022 - Jun 2022

• Identify KPIs with clear objectives, analyse data and present it through reports that can help in decision-making.• Develop Business performance reports in Power BI from DW and Database connections, perform DAX queries and functions in Power BI. Built high level interactive Tableau dashboards catered to CXO suite.• Review Weekly, Monthly, Q’ly packs for Sr management, CXO suite. • Using advance analytics on Customer data related to Loyalty, redemption, repeat customers’ buying patterns, sequences, price bands etc.

Reporting Analyst

• Jan 2020 - Feb 2022

• Worked with Business Managers to understand current list of reports, its data sources which needs to be transformed to NetSuite. • Designed, developed, tested, and maintained Tableau functional reports based on KPIs and user requirements. • Created various customised reports by joining/ blending several data sources using SQL queries and further enhanced by calculated fields, and interactive dashboards by using parameters and sets and user filters. • Analyse the performance of retail stores (offline) Vs Online for Traffic, ATV, UPT, ASP metrics for key products • Applied Advance Analytics on Customer data from Google Analytics related to customer searches, products, conversion, reviews and feedback. Shared the outcome with E-Commerce business head.

Data Analyst

• Jan 2019 - Dec 2019

• Understand the Requirements and Functionality of the application from specifications.• Gathered Requirements from 37 Business Requirement Documents across various Streams and Divisions of the Bank. Liaison with stream owners to prioritise the recommendations.• Governance Reporting – Managed Traceability Matrix across 25 Business units on 450+ lines of codes – changes recommended by ABA• Worked on various regulatory data for APRA reporting.• Manage stakeholder mapping and prepare communications and respond to stakeholder enquiries• Adhere data models as per enterprise standards and appropriate as per business requirements.• Measuring and reporting to management on the progress of data quality improvement. • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Data Analyst

• Jun 2018 - Dec 2018

• Understand and gather the requirements, prioritise and finalise timelines.• Evaluated large datasets for quality and accuracy. Identify, compare, and resolve data quality problems.• Cleanse and normalize data in MS Excel by combing from various data sources.• Data blending implemented on SQL databases and in Excel.• Analysed customer data, transactions, size of business, nearest branches, staff data and other info.• Created actions, filters, Level-of-Detail (LOD) expressions parameters, hierarchies, calculated fields, sorting, groupings, live connections, in-memory in Tableau.• Created rich Tableau Dashboard to deliver actionable insights.

Data Analyst

• Jan 2017 - May 2018

• Collected extensive data from Oracle to analyse the types of payments and the proportion of auto hit rate. • Ensure adherence to data quality standards. Resolve internal data exceptions in timely and accurately. • Interaction with business stakeholders, gathering requirements and managing the delivery. • As part of the Development team, Design and develop innovative dashboard, analytics, and reports. • Developed SQL Queries to fetch complex data from different tables in remote databases using joins. • Created Technical Documentation for reports and maintenance/enhancements of existing Reports • Building, publishing customized interactive reports and dashboards, report scheduling

Credit Analyst

• Oct 2014 - Jan 2017

• Collaborate with Hotel Sales managers, Controllers to review the potential customers’ credit worthiness. • Analyse Credit Risk for probable customers using 4-5 parameters using credit grid and D&B report in getting the credit score of the probable customers • Generate report from Salesforce to see the customers’ orders, event types, size of business etc. • Analyse and forecast the revenue, cost and margin based on the probability at each level of success • Collaborate with Hotel Sales managers, Controllers to review the potential customers’ credit worthiness. • Analyse Credit Risk for probable customers using 4-5 parameters using credit grid and D&B report in getting the credit score of the probable customers • Generate report from Salesforce to see the customers’ orders, event types, size of business etc. • Analyse and forecast the revenue, cost and margin based on the probability at each level of success

Reporting Analyst (Asst Manager)

• Nov 2010 - Oct 2014

• Financial Budgeting, Forecasting, Cost and Project margin management. Overall revenue size of $80M+ • Managed 10 Business units across USA & Australia handling the reports and status of Financial Strategic Budgets, Cost, Forecasting • Monthly reporting of Financials - Budgets Vs Forecast – variance analysis and providing insights. • Financial Budgeting, Forecasting, Cost and Project margin management. Overall revenue size of $80M+ • Managed 10 Business units across USA & Australia handling the reports and status of Financial Strategic Budgets, Cost, Forecasting • Monthly reporting of Financials - Budgets Vs Forecast – variance analysis and providing insights.