Summary
Overview
Work History
Education
Skills
Timeline
Generic

Rishi Bhatia

Noida,Uttar Pradesh

Summary

Total 15+ Years of experience of using Power BI, Power Apps, SQL Server, Advanced Excel, Expertise in BI Dashboards (Power BI). Personal qualities include positive attitude, Analytical thinking, good problem solver, quick learner, persistent, adapt.

Overview

15
15
years of professional experience

Work History

Application Process Lead

Rockwell Automation
Noida, Uttar Pradesh
02.2022 - Current
  • Understand business requirements in BI context and design data models to transform raw data into meaning insights.
  • Create dashboards and interactive visual reports using Power Bl.
  • Identify key performance indicators(KPIs) with clear objectives and consistently monitor those.
  • Analyzing data and present data through reports that aid decision making.
  • Convert business requirements into technical specifications and decide timeline to accomplish.
  • Perform DAX queries and functions in Power BI.
  • Create customize charts and custom calculations as per requirements.
  • Design, develop and deploy business intelligence as per requirements.
  • SQL querying for best results, use of filters and graphs for better understanding of data.
  • Work with users and team members at all level of performance improvement and suggestions .

Senior Reporting Analyst

Rockwell Automation India Pvt Ltd
Noida, Uttar Pradesh
03.2020 - 02.2022
  • Create dashboards and interactive visual reports using Power Bl
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Developed metrics derived from raw company data to track improvements in organizational efficiency.
  • Designed customized data collection models for specific visualization tasks.
  • Responded to specific BI requests, creating data packets with requested information in easily understandable formats.
  • Researched and compiled tailored monthly analytics and reports for senior management with Microsoft Power BI.
  • Created workflow diagrams and charts to clearly demonstrate processes and timelines.
  • Optimized BI reporting capabilities for secure server environment.
  • Created data analysis tools to allow teams to query acquired information for unique details.

Analyst- Asia Pacific

Rockwell Automation India Pvt Ltd
Noida, Uttar Pradesh
01.2018 - 02.2020
  • Responsible for generate and distribute daily and weekly performance reports, periodic data analysis to identify root cause and other reports as requested.
  • Extract and process source data from different systems, ensure the quality of acquired data, and generate information delivered in different reporting formats including Excel, Macros and VBA.
  • Automation of various ongoing Reports using VBA Programming.
  • Collecting and processing data and conducting analysis, ideally for management and decision-making processes.
  • Analysis Ad-hoc reports within required time to maintain SLA.
  • Create Presentation for Operation team and Management of related to SLA Metrics on weekly, monthly, and quarterly basis.

Analyst - India Operations

Rockwell Automation
Noida, Uttar Pradesh
01.2014 - 12.2017
  • Responsible for generate and distribute daily and weekly performance reports, periodic data analysis to identify root cause and other reports as requested.
  • Extract and process source data from different systems, ensure the quality of acquired data, and generate information delivered in different reporting formats including Excel, Macros and VBA.
  • Automation of various ongoing Reports using VBA Programming.
  • Collecting and processing data and conducting analysis, ideally for management and decision-making processes.
  • Analysis Ad-hoc reports within required time to maintain SLA.
  • Create Presentation for Operation team and Management of related to SLA Metrics on weekly, monthly, and quarterly basis.

Business Coordinator

Rockwell Automation India Pvt Ltd
Noida, Uttar Pradesh
03.2008 - 12.2013
  • Responsible for streamlining office operations for marked productivity gains, creating standardized documents, highly
  • Accessible filing system and detailed information database.
  • Organization & co-ordination: Prioritize and manage the Business Heads functions and daily activities, managing schedule, dealing with calendar issues in ‘Zero lead time'.
  • Prepare time utilization sheet, order & shipment dashboard, expense reports, conduct reconciliations, and resolve discrepancies and maintaining the performance data in SAP System.
  • Point of contact for all internal & back office processes and activities.

Associate

EXL Service.com
Noida, Uttar Pradesh
06.2007 - 03.2008

• Auditing of 150 Bills of Lading on Daily Basis.
• Ensure 100% Quality while Auditing Bill of Lading.
• Auditing of Bills of Lading for the specific 15 Fields and making Correction if any in a way generating revenue for the clients.
• Persistently achieve the daily/weekly/monthly target.
• Achieve the SLA (Service level agreement) on day-to-day basis.

Education

Bachelor of Commerce - Commerce

Delhi University
Delhi
04.2004

Computer Applications -

Advance Diploma in Computer Application
CMC Limited , A Unit Of Tata Enterprise
04.2004

Skills

  • Power BI
  • Power Apps
  • Power Query
  • Operations Analysis
  • Data research and analysis
  • Data Visualization
  • DAX Functions
  • SQL Server
  • Advanced Excel
  • Business Intelligence

Timeline

Application Process Lead

Rockwell Automation
02.2022 - Current

Senior Reporting Analyst

Rockwell Automation India Pvt Ltd
03.2020 - 02.2022

Analyst- Asia Pacific

Rockwell Automation India Pvt Ltd
01.2018 - 02.2020

Analyst - India Operations

Rockwell Automation
01.2014 - 12.2017

Business Coordinator

Rockwell Automation India Pvt Ltd
03.2008 - 12.2013

Associate

EXL Service.com
06.2007 - 03.2008

Bachelor of Commerce - Commerce

Delhi University

Computer Applications -

Advance Diploma in Computer Application
Rishi Bhatia