Mohit . Email and Phone Number
Professional experience as an expertise in –Dashboards: Created visually impactful dashboards in Excel and Tableau for data reporting by using functions & formulas. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.Reporting: Organizing data into informational summaries in order to monitor how different areas of a business are performing.Analysis: Exploring data or Cleaning data and reports in order to extract meaningful insights, which can be used to better understand and improve business performance.Process Automation: Automated the process to take out the complex, most redundant steps from their processes and streamline them for simplicity.Goal: To obtain a long-term career and have desire to learn and explore new technologies with an organization, which provides good opportunity for enhancement of professional and personal status.Key Skills :- Business Intelligence, Tableau, Power BI, Dashboards, Excel, Advanced Excel, Reporting, Access, SQL- Server, VBA, Analytics, Analysis.
Macquarie Group
View- Website:
- macquarie.com
- Employees:
- 16295
-
Assistant Vice PresidentMacquarie Group May 2023 - PresentGurugram, Haryana, India -
Business Intelligence | ManagerHsbc Nov 2021 - May 2023Gurugram, Haryana, India -
Business Intelligence | Assistant ManagerBarclays Nov 2017 - Nov 2021Noida Area, IndiaExperienced in designing customized interactive dashboards in Tableau using filters, actions, parameter and calculations etc.Extensive knowledge in creating data visualizations using Tableau Desktops and regularly publishing and presenting dashboards.Experienced in Tableau to deliver KPI and trend information to management and stakeholders.Single handedly Tableau Desktop and Tableau Server. Created Bar charts, Columns charts, Butterfly charts, Lolipop charts, Water fall charts, Funnel Charts, Heat Maps, Bubble chart and Geographical Maps etc.Created Parameters to reports be more user friendly to end users.Connecting multiple data source with Data Blending technique and custom SQL Server query.Prepare drill down reports and also provide dynamic dashboard along with self-serve functionality.Managing incidents/ enhancements of Procurement’s BI tools and provide UAT support.Understanding of Business requirements, enhanced or improved Business through minor works working with technical team. -
Mi & AnalyticsPublicis Sapient Dec 2014 - Nov 2017Gurgaon, IndiaHaving more than 5 years of professional experience as an expertise in MS-Excel, Knowledge of MIS reporting and LOB Dashboard, VBA scripting (Macro’s) & Automation and Business Intelligence.• Build Dashboard for leadership, Clients and analysis the data to come up with Insides.• Work using Business intelligence tool, Power BI, Power Pivot, Power Query, Power View.• Design, Build and maintain dashboards and databases.• Daily, Weekly & Monthly Reporting and send to the seniors.• Usage of PowerPoint in the presentation of meetings and to prepare MOM’s for the meeting.• Align the data and create a report in excel. Before a report is draft, must assure data available for report is well aligned so that report should be errorless.• Work to meet deadlines established by stakeholder, client and leadership. -
Sr. Data AnalystExl Jul 2011 - Dec 2014Gurgaon, India• Daily, Weekly & Monthly Reports are prepared using Macro & Excel.• Frequently use of If, Sum if, Count if, V-lookup, H-lookup, Index & Match, Round, Is Error, Pivot Table, and Macros etc.• Having good command on Dashboard, Templates, Pivot Tables, and Charts.• Created Templates and Handle some projects.• Handling multiple reports with using VBA.• Creating and updating colleague’ productivity reports in Dashboard and share Dashboard to the seniors.• Having knowledge of SQL-Server and Access.
Mohit . Education Details
-
IcfaiMaster Of Business Administration (Mba) -
NiitA+ -
Bachelor Of Commerce (B.Com.)
Frequently Asked Questions about Mohit .
What company does Mohit . work for?
Mohit . works for Macquarie Group
What is Mohit .'s role at the current company?
Mohit .'s current role is Business Intelligence Lead at Macquarie || Ex-HSBC || Ex-Barclays || Ex-Sapient || Power BI || Tableau || Alteryx || Data Visualisation || Tableau Prep || Data Analytics || SQLServer ||.
What schools did Mohit . attend?
Mohit . attended Icfai, Niit, Delhi University.
Who are Mohit .'s colleagues?
Mohit .'s colleagues are Tony Bothof, Garima Singh, Mohit Mittal, Dharshini Krishanthan, Lucy Derbyshire, Marl Danica Quirimit, Jihan Cabacis.
Not the Mohit . you were looking for?
-
Mohit ..
Project Manager At Lcx Crypto Exchange | Blockchain & Cryptocurrency |Fintech | Defi | Nft | Web3Gurugram1108ideaspace.com -
Mohit Sadaani
Gurgaon3gmail.com, snapdeal.com, themomsco.com -
Mohit .
Utsuk | Cfo | Business Advisor | Transformation | Growth & Profitability | StorytellingHyderabad1gmail.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial