Rajat Sharma

Experience

• 

  Xceedance

  Jan 2018 - Apr 2021

  • Utilized excel functionality to gather, compile and analyse data from pivot tables and created graphs/charts.• Assisting underwriters to unleash quotes which requires analysing premium, based on various factors like size of group, past-experience, medical network opted and studying their history.• Provided analysis on any claims data discrepancies in reports or dashboards.• Organized system infrastructure documentation and operating procedures, strengthening controls and enhancing overall performance.• Created SQL tables with referential integrity and developed advanced queries using stored procedures and functions using SQL server management studio.• Proficient with data management, data analytics and relational database.• Mapped processes to holistically examine business flow and identify improvement opportunities and developed various tools (Census Report, Coverage Output, Territory Tool) using excel and macros and was awarded PAT-ON-THE-BACK for the same. Decreased AHT by 20mins per case.• Handling daily reports through dashboards generation and automation using VBA & Excel.• Performed detailed analysis on key trends and findings; summarized and presented findings to managers. Show less

  • Senior Analyst

    Jan 2020 - Apr 2021

  • Analyst

    Jan 2018 - Jan 2020
• 

  KPMG Global Services (KGS)

  Apr 2021 - Dec 2022

  Senior Analyst

  • Collaborated with teams to consolidate data and provide insights. Employed analysis andtroubleshoot reporting issues and used forecasting techniques for sales verification.• Transformed and created Power BI report for tracking Deal Board meetings, applying datatransformations and DAX queries.• Developed customized ETL applications and updated database designs.• Resolved CRM queries and automated chasing process with VBA macros for bulk chasers.• Collaborated to enhance efficiency, automating reporting processes, saving 500+ hours annually.• Enhanced data integrity by reviewing processes, conducted WND cleanse to reduceengagements open on SAP, saving 800+ hours in data consolidation Show less

• 

  Reliance Retail

  Dec 2022 - Nov 2024

  Deputy Manager

  • Implementing new practices and systems, using SQL, Python, & Excel to automate reports andstreamline processes saving 1000+ Hrs. annually.• Creating a database with SQL & Python to enhance efficiency and accountability.• Fostering agile communication and synergy across departments by collaborating seamlesslywith Category, Marketing, Operations, & Revenue teams.• Streamlining reporting with the Category team, emphasizing product stock analysis andenhancing inventory management.• Presenting actionable insights through visually compelling reports and dynamic dashboards.Integrating detailed KPIs into comprehensive reports for strategic decision-making.• Co-developing targeted achievement reports to empower city managers in meeting andsurpassing targets.• Developing an efficient Below-The-Line (BTL) pipeline using Python and Google Sheets forcomprehensive analysis and tracking across cities.• Collaborating with revenue and marketing teams to establish precise permission cost brackets,reducing variable costs during BTL activities. Devising segmented strategies to enhanceAverage Order Value (AOV), fortify retention, and assist in liquidation, optimizingprofitability.• Providing strategic allocation of resources aligned with organizational needs and goals. Offeringperformance KPIs for effective resource allocation and measurement against objectives. Show less

• 

  Publicis Global Delivery (PGD)

  Nov 2024 - now

  Senior Data Analyst