DRISHTI BHAYANA

ad3fvy@r.postjobfree.com Arizona, US +1-480-***-**** (USA) Whatsapp: +919********* https://www.linkedin.com/in/drishti-bhayana-bbb76789/

People Analytics Manager

Objective

Results-driven People analytics manager with a strong analytical background and a passion for extracting actionable insights from complex datasets. Seeking to leverage my expertise in data manipulation, statistical analysis, and data visualization to contribute to data-driven decision-making and business growth within a dynamic organization. Committed to continuous learning and staying updated with the latest data analysis tools and techniques.

Summary

• Accomplished Data Analyst with 7+ years of professional experience in data analysis, data management, and data-driven insights.

• Proficient in statistical analysis and data tools, such as Python, Power BI, SQL, SSIS, SSRS and Excel.

• Strong communication and leadership skills with experience managing cross-functional teams.

• Proficient in a wide array of data analysis tools and techniques, including statistical analysis, data visualization, and data manipulation.

• Proven track record of delivering data-driven solutions and recommendations that have positively impacted business performance and decision-making.

• Strong analytical mindset with a keen attention to detail, enabling the identification of trends, patterns, and anomalies within data.

• Effective communicator with the ability to translate technical findings into actionable insights for both technical and non-technical stakeholders.

• Experienced in collaborating across departments and teams to drive data-driven initiatives, improve processes, and optimize outcomes.

• Adept at working with various data sources, databases, and data management systems to ensure data accuracy, consistency, and accessibility.

• Consistently demonstrated a commitment to ongoing professional development and staying up-to-date with emerging trends and technologies in the field of data analysis.

• Passionate about leveraging data to solve complex problems, drive informed decision-making, and contribute to the overall success of organizations.

Work Experience

AsterDM Healthcare (Remote) Aug 2022 – Present

Assistant Manager, Talent Analytics

•Helped the team adopt Oracle recruiting system and facilitate clean up of the existing data and simultaneously streamlining and standardizing the captured data.

•Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.

•Expert in creating and using Stored Procedures, Views, User Defined Functions.

•Leading the Pilot for Clinicians Performance Management System with 60 doctors globally.

•Lead a team of people analytics professionals to deliver data-driven insights and recommendations to support the company's HR and business strategies.

•Develop and maintain Power Bi and Excel based HR dashboards, reports, and metrics to track key HR metrics such as employee engagement, turnover, diversity, and performance management.

•Conduct in-depth analysis of HR data to identify trends and patterns related to workforce planning, talent acquisition, and retention, and make recommendations to improve organizational performance.

•Collaborate with HR partners and business leaders to develop and implement data-driven solutions using Python and Excel to address key workforce issues.

•Manage HR data governance and data quality initiatives to ensure data accuracy, consistency, and completeness in HR systems and databases.

PwC, India (Remote) July 2021– Aug 2022

Senior Associate, Data Analyst

•People Analytics

oPerformed Sentiment Analysis on data collected from multiple surveys pertaining to feedback around engagement metrics.

oDeveloped Tableau based dashboards to fulfil reporting for 70+ reports.

oDeveloped multiple complex Alteryx based workflows to wrangle and calculate various HR metrics for multiple Surveys.

•End-to-end survey management

oManaged multiple surveys for various clients including Fortune 500 technology and healthcare clients. Handled survey setup, survey analysis and survey reporting modules.

oI drove the technical aspect of reporting for the Facebook’s Mobility survey, generating their quarterly reports. This entailed working with Alteryx and VBA based automations to incorporate quarterly survey, analyzing the data received for discrepancies.

•Project Management Office

o Responsible for the metrics evaluation and reporting for all data related to the team utilization. Assisted in the planning for FY21 and FY22 budgets basis the utilization analysis for the entire OWT team.

Gartner Gurgaon, India Dec 2018 – June 2021

Specialist, Data Analyst

•Diagnostic Benchmarking

o Collaborated with the team to build a Python based automation to calculate Benchmarks for Diagnostic Surveys. This involved:

Conducting interviews with key business users to collect information on business processes and user requirements.

Translating numbers and facts based on Interviews and collected data to deliver strategic business outcomes.

oConducted demonstrations for Clients for diagnostic surveys and support Client and internal requests to deliver practical solutions leveraging my data insights and python skills.

•SQL Server Database o Worked as Individual Contributor on a SQL Server based, Prototype Database to store 10 years’ worth of survey data conducted organization wide, thereby reducing manual effort on reporting by over 85%.

oAutomated ETL processes across billions of rows of data which reduced manual workload by 33% monthly

oUsed stored procedures, triggers, and views to provide structured data to business units by combining millions of rows of data from 9 disparate data sources

oDeveloped database objects, including tables, views and materialized views using SQL. o Performed data cleaning and designed schema data models to structure the Relational Database.

•Dashboard

oCreated visually impactful dashboards in Excel and Power BI for data reporting by using pivot tables and VLOOKUP. Extracted, interpreted, and analysed data to identify key metrics and transform raw data into meaningful, actionable information.

oBuilt out the data and reporting infrastructure from the ground up using Power BI and SQL to provide real-time insights into the product, marketing funnels, and business KPIs

•Automation

oBuilt out a real-time reporting infrastructure that standardized metrics across the company and saved 200 monthly hours of manual reporting using Python.

oDeparture View historic data migration from Verint to Gartner's in-house survey platform using dynamic SQL queries for ~230 member clients.

oUsing Python, SQL, and Excel I developed and owned the reporting for an yearly Turnover survey, saving ~100 hours of labour.

oConfiguring surveys on online Survey platforms, coordinating with vendors to obtain responses, and subsequently generating reports and data insights for the same.

Accenture Gurgaon, India Mar 2016 – Dec 2018

Analyst, Business Intelligence

•Configured over 80% of team’s survey requests on Verint along with their end-to-end reporting and handling all client interactions around the same.

•Well experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).

•Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.

•Expert in creating and using Stored Procedures, Views, User Defined Functions.

•Extensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation.

Skills

Python

Data Analysis

Power BI

HR Domain Knowledge

SQL

MS – Office

Database Management

Data Cleaning

SSIS

Excel Advance

ETL

Data Migration

Reporting

Data Modelling

Survey Configuration

Data Visualization

Pandas

Data Formatting

Benchmarking

Communication Skills

Problem solving

Organizational skills

Analytical

Critical Thinking

Business Intelligence (BI)

Resilience

Attention to Detail

Verint

Education

Bachelor’s in Technology (IT) 2011 – 2015

Guru Tegh Bahadur Institute of Technology (GGSIPU) Secured 75.4% Aggregate

Higher Secondary 2010 – 2011

Neo Convent Sr. Sec. School

Secured 90.2% Aggregate

Secondary 2008 – 2009

Neo Convent Sr. Sec. School Secured 90.8% Aggregate

Contact this candidate