Summary
Overview
Work History
Education
Skills
Additional Information
Quote
Accomplishments
Work Availability
Software
Languages
Interests
Websites
Timeline
AdministrativeAssistant
Shahrukh

Shahrukh

Data Analyst
South Delhi,New Delhi

Summary

Experienced Data Analyst and MIS Reporting professional with 6 years of impactful experience and a proven track record of delivering actionable insights, automating complex reports, and driving strategic business decisions. Adept at stakeholder collaboration, financial data management, and creating dynamic dashboards to enhance organizational efficiency. Proficient in leveraging tools like Power BI, SQL, Power Query, and Advanced Excel to translate data into impactful business solutions.

Overview

5
5
years of professional experience

Work History

Senior BMO Executive

Successive Technologies Pvt. Ltd
03.2022 - Current
  • Executive Leadership Engagement: Conduct weekly ELT meetings, analyzing clients' projections, profitability, and margins at the resource, project, and client levels and strategizing to meet annual business targets
  • Global Invoice Analysis and Risk Mitigation: Prepare and analyze global outstanding payment reports and mitigate risks through effective stakeholder coordination
  • Resource Contract Management: Tracking all resources, extensions, and working closely with Account Management (AM) and Resource Management (RMG) teams to ensure timely contract renewals or resource allocation, effectively minimizing bench time
  • Pipeline and Deal Tracking: Responsible for tracking pipeline deals via HubSpot and analyzing leads categorized as dropped, lost, or on hold, to identify improvement areas and enhance closure rates
  • Comprehensive Sales Reporting: Create sales reports with detailed insights for the Executive Leadership Team, including region- and country-level booking and realization analyses, client performance metrics, and organizational trends
  • Cross-Department Coordination: Collaborate effectively with Account Management, Finance, Sales, Marketing, and Delivery teams to streamline processes and drive organizational goals
  • Document Management: Maintain and track critical client and vendor documents, including NDAs, MSAs, and contracts, using PandaDoc to ensure compliance and seamless access
  • Handling multiple reports and utilizing Power BI, Power Query, Google Sheets, VBA, formulas, pivot tables, pivot charts, and various other Excel sheet components for crisp, accurate data.

PMO Executive

IGT Solutions Pvt. Ltd
Gurgaon
03.2020 - 02.2022
  • Responsible for the client's monthly provisional and actual billing
  • Clients and project-wise revenue reports
  • Responsible for the preparation and maintenance of MIS reports
  • Prepare client- and project-wise headcounts
  • Handling Bench (Unutilized) Resource Management
  • Day-to-day follow-up and coordination with project managers
  • Responsible for report automation and dashboards.

MIS Executive

Policy Bazaar
Gurgaon
07.2019 - 03.2020
  • Preparing leads received and conversion reports
  • Responsible for agents' utilization reports
  • Responsible for agents' target vs
  • Actual reports
  • Preparing the MIS report and sales dashboard for the monthly review
  • Provided feedback to management concerning possible problems or areas of improvement
  • Responsible for data compiling and report automation using VBA macros
  • Managing time, office activities, and RNR activities.

Education

Bachelor of Commerce - Commerce

Delhi University
09.2019

12th - undefined

CBSE
05.2016

10th - undefined

CBSE
05.2014

Skills

  • Advanced Microsoft Excel
  • Power BI
  • Power Query
  • Data Modeling
  • Data mining
  • Data Transformation
  • Google Sheets
  • Dashboard creation
  • Data analysis skills
  • Report generation
  • Financial management
  • Interpersonal skills
  • Good team player
  • Focused, confident, and with a positive attitude

Additional Information

  • ACCOMPLISHMENTS , Constant Companion Award and Fitbit Sense 2 – Successive Technologies Star of the Quarter – Policy Bazaar Achieved Inner Circle Member status for exceptional performance and contributions. Awarded the 'Hero' title for demonstrating ownership and consistently fulfilling commitments.

Quote

There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins

Accomplishments

1. Constant Companion Award – Successive Technologies

2. Star of the Quarter – Policy Bazaar

3. Achieved Inner Circle Member status for exceptional performance and contributions.

4. Awarded the 'Hero' title for demonstrating ownership and consistently fulfilling commitments.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Software

POWER BI

Advanced Microsoft Excel

Power Query

Google Sheets

Languages

English
Intermediate (B1)
Hindi
Advanced (C1)

Interests

Cricket

Politics

Timeline

Senior BMO Executive

Successive Technologies Pvt. Ltd
03.2022 - Current

PMO Executive

IGT Solutions Pvt. Ltd
03.2020 - 02.2022

MIS Executive

Policy Bazaar
07.2019 - 03.2020

Bachelor of Commerce - Commerce

Delhi University

12th - undefined

CBSE

10th - undefined

CBSE

Similar Profiles

CREATE PROFILE
Shahrukh Data Analyst