Oct 2021 – Jun 2022 · 8 mos · Gurugram, Haryana, India

• Contributed as a member of Supply Analytics team by performing daily data queries on redash,
• managing dashboards and publishing various business reports on daily, weekly and monthly basis
• Replicated various reports to Power BI system for advanced visualization, optimisation and automation
• Managed and tracked various important KPIs in reports such as Occupancy, Bookability, Corporate
• hotel bookings, Competitors Meat/Beat rate plans and digital marketing campaigns etc

Apr 2021 – Oct 2021 · 6 mos

• Re-engineered processes to boost efficiency and effectiveness within the Corporate Planning team
• Conducted daily data queries and produced insightful daily, weekly, and quarterly reports
• Managed end-to-end data operations, including ETL, using Power Query, Power Pivot, Power View, and
• data catalog with Role-Level Security (RLS)
• Designed and maintained Power BI dashboards for Sales, KPIs, conversions, P\&L, Cash Flow, and
• Balance Sheet
• Contributed in Budget & KPIs planning, revenue & cost analysis and profitability analysis
• Exploring data, reports & key metrics in order to extract meaningful insights, which can be used to
• better understand and improve business performance through right decision-making by BUs,
• stakeholders or senior management

Apr 2019 – Apr 2021 · 2 yrs

• Along with existing responsibilities handled a team of 4 people for a data management project.

Jan 2017 – Mar 2019 · 2 yrs 2 mos

• Performing daily data queries and preparing reports on daily, weekly and quarterly basis.
• Exploring data and reports in order to extract meaningful insights, which can be used for
• better understanding and improve business performance.
• Using advanced Excel function to generate spreadsheets and pivot tables.
• Develop and initiate more efficient data collection procedures.
• Compile and validate data; reinforce and maintain compliance with corporate standards.
• Working with managing leadership to prioritize business and information requirements.

Sep 2016 – Dec 2016 · 3 mos · Gurgaon, India

• Worked in Planning Team: SKU's creation that is Stock Keeping Unit, resolve the issues related to SKU's by using backend server and change in any product attributes.
• Track and report website traffic as well as on app by using Google Analytics.
• In excel, I learned many formulas: vlookup, pivot table and visualization etc.
• Extract, compile, track and analyse data to prepare various business reports.

May 2015 – Jun 2015 · 1 mo · Bhopal

• My internship was on CCNA where i learned about the computer networks, routing concepts, implementation, IPv6 addressing, and Network Address Translation (NAT).

May 2014 – Jun 2014 · 1 mo · Jhansi

• My internship was on Core Java Programming where i learned about fundamental programming such as variables, conditional and iterative execution, methods etc. and be able to use the Java SDK environment to create, debug and run java programs.