Sandeep Bhargav

Sandeep Bhargav

Lead HR Analyst

Followers of Sandeep Bhargav77 followers
location of Sandeep BhargavDelhi, India

Connect with Sandeep Bhargav to Send Message

Connect

Connect with Sandeep Bhargav to Send Message

Connect
  • Timeline

  • About me

    Working as Manager in Data Analytics with Genpact | Proficient in SQL, PLSQL, Hive, SAS, Python, VBA & Tableau

  • Education

    • DOEACC

      2003 - 2006
      'A' Level Computer Science

      Completed DOEACC 'A' Level modules from Aztech Computers, South Extension I

    • Deshbandhu College

      -
      Bachelor of Science (B.S.) General Studies

      Graduated from Deshbandhu College, Delhi University

  • Experience

    • Concentrix Technologies India Pvt Ltd

      Apr 2010 - Nov 2015
      Lead HR Analyst

       Planning & Execution: Reported development / modification through Oracle Business Intelligence (OBI), analysis and support BPM [Business Process Management] - rules modifications and analysis Support and analysis while performing Actions [Transfer, Termination, Promotions etc.] in Oracle Fusion and Taleo Oracle SR coordination Prepared training documents Handled the L4 issues Testing coordination with Oracle Meetings with KBASE Creation and execution of Macros Team Management: Contributed to a highly motivated, performance driven, professional, customer focused that shows the quality work and sharing the knowledge among the team Proactive decision and assisted team members whenever required Provided training and effective, on-time and objective feedback to team members  Quality & Continues Improvement: Ensured assigned task / activities line-items are verified and documented Acted with integrity in all matters. Ensured complete understanding and compliance with the Concentrix Business Conduct Guidelines and applicable law Participated in root cause analysis found in Testing and production environment Enhanced the self-skill & technology and participated in various training to provide the best support  Being responsive in compling with all business control requirements Show less

    • Home Credit India

      Nov 2015 - May 2016
      Senior Business Analyst

       Analysis & Reporting: Identified the irregularities in business operations and standards designs Ensured that company complies with the stipulated principles and standards Performed internal audits and connect with managers to evaluate their work processes Performed analysis of case management data identifying market trends, possible issues & opportunities Analysed data for anomalies and trends utilizing various reports to implement solutions pertaining to the effectiveness and efficiency of the organization's internal processes Updated workflows, business project models, team mapping and project planning Performed root cause analysis on data issues Developed a custom production issue report to increases visibility and communication to the operations, customer service, and management teams Maintained service level agreements for all business areas supporting within the multifamily division and vendors ensuring daily operations and longer-term projects to get completed in a timely manner Team Management: Led the monitoring and reporting of team performance, proactively increasing efficiency of operations Provided training to monitor skills and understanding about different processes Provided effective, on-time and objective feedback to team members Show less

    • IHS Markit

      May 2016 - Sept 2023
      Sr. Quality And Data Governance Analyst II

       Built dashboard that measured and reported on key performance indicators against individual threshold values Developed and automated a PLSQL package to fix incorrect surrogate keys and the associated records across different database tables Built 50+ Tableau reports to find areas of improvement for internal and external stakeholders and Gainsight reporting analysis Prepared data for use in predictive and prescriptive modelling Proactively analysed data to answer key questions from stakeholders or out of self-initiated curiosity with an eye for what drives business performance, investigating and communicating areas for improvement in efficiency and productivity Worked closely with project managers to understand and maintain focus on their analytical needs, including identifying critical metrics and KPIs, and deliver actionable insights to relevant decision-makers Provided recommendations on improving performance to teams based on data analysis Created Monthly, Quarterly and Yearly Business Reviews reports with deep dive trend analysis Query and manipulate large data sets in SQL, PLSQL, Hadoop databases using common coding languages (SQL, HiveQL, Python) Exposure to AWS Show less

    • Genpact India Pvt. Ltd.

      May 2022 - now
      Data Analysis Manager

       Led a team of data analysts to develop and implement advanced data analytics practices and strategies Experienced in writing complex SQL PL/SQL Queries, Stored Procedures, Functions, Creating Indexes, Triggers, Collections, Performance Tuning, Query Optimization and data loading from various sources for analysis Created interactive dashboards and reports to visualize and communicate key metrics related to fraud detection and investigation using Tableau and Excel Automated dashboard generation and reporting processes, reducing manual efforts and improving accuracy Collaborated with cross-functional teams to prepare to understand business requirements, for data insights, government audits, ensuring adherence to regulatory requirements Conducted in-depth data analysis to identify patterns, trends, and anomalies Analyzed data using Python libraries such as NumPy, & Pandas. Utilized SAS to communicate with SQL Server and Hive (Data Lake) for advanced data analytics Utilized Hive for big data analytics, processing and analyzing large volumes of data to identify potential risks Worked in Agile environment and was able to bring projects to completion. Exposure to Jira Show less

  • Licenses & Certifications

    • PL-SQL