Vikram Arora Email & Phone Number

Noida, Uttar Pradesh, India

Noida, Uttar Pradesh, India

Data Modelling, Analysis and Governance by creating Power BI Dashboards on Service Now Tickets, Asset Configuration Management, Internal/External Applications and Project Financials

Noida Area, India

1. Data mining using SQL to pull out regional data logs related to various Dell products and brands2. Collected, cleansed and provided modeling and analyses of structured and unstructured data used for major business initiatives3. Created visually impactful weekly/monthly dashboards in Excel for data reporting by using pivot tables array functions and VLOOKUP.4. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information5. Performed ad-hoc requests for clients using Excel and customized SQL queries to extract and format requested information6. Designed queries for monthly and quarterly tracking reports for marketing and senior management7. Worked in conjunction with development team and senior management in preparation of data mapping reports, validation reports and business reports.8. Analyzed and implemented any enhancements related to assigned processes to reduce processing time to improve customer service and Identified gaps

Gurgaon, India

- Data mining from SAP to pull out liquidity reports related to WIP and Debts and other financial results. - Working on a client engagement which involves keeping records of financial transactions in terms of billing the client, making vendor payments and finally evaluating engagement profitability by the end of each month.- It involves updating dashboard monthly which gives management an overview from beginning of the engagement till current position in terms of profitability and how to use grade mix to maximize revenue.- The profile also includes analysis on Actual Vs. Billed on a monthly basis to see if we are in line with the forecasting or not.- Providing support to the client engagement team, finance team on raising invoices.- Helping employee’s in writing off their time and expenses related to a particular engagement.- Providing information on WIP through weekly and monthly reports which helps client facing teams in evaluating the chargeable time and expenses left to be billed. - Root cause analysis of any defects in process.- Maintain the data integrity during extraction, manipulation, processing, analysis and storage.

Gurgaon, India

Business Travel-- Providing weekly information to senior management on opportunities won as well as updates on high value opportunities lying in the pipeline.- Preparing reports on Actual Vs. Forecasted utilization of resources.- Providing information on team’s performance which is engaged in different client projects, to top management of fortnightly and monthly basis.- Worked on a crucial report related to sales allocation, which included collection of percentage on sales given to various team members given by Engagement Partners on the basis of their performance.

Bachelor Of Commerce (B.Com.), Commerce

Education record