Summary
Overview
Work History
Education
Skills
Software
Certification
Timeline
Generic

Ashna Villiyath

Data and BI Professional
Dubai,DU

Summary

A committed and competent data professional with 9 plus years of experience in working closely with business stakeholders to provide key organisational information through the effective implementation of data initiatives including data mining and analysis, data extracts, business intelligence reporting solutions, and by promoting a data aware culture throughout the organisation . Proficient knowledge in statistics, mathematics and analytical tools. Successful in meeting new challenges and finding effective solutions.

Overview

11
11
years of professional experience
6
6
years of post-secondary education
4
4
Certifications

Work History

<p > <b>Data Analyst- HR Intelligence & People Analytics</b> </p><p > Gargash Group </p><ul > <li > Responsible for identifying, designing and performing complex analyses and make recommendations on complex HR issues in partnership with the Head- HR Intelligence & People Analytics. </li> <li > Providing training to internal/external stakeholders on data interpretation, data evaluation, statistical and analytical techniques. </li> <li > Design and develop useful metrics, dashboards, analyses and data reporting to support variety of HR and business initiatives. </li> <li > Develop, prepare and analyze metrics to measure effectiveness of business outcomes. </li> <li > Produce clear, concise reports and/or presentations. </li> <li > Develop and prepare charts, tables, and other related documents and graphics. </li> <li > Manage multiple simultaneous work streams. </li> </ul>

Gargash Group
07.2021 - Current

<p > <b>HR Business Intelligence Analyst</b> </p><p > VPS Healthcare </p><ul > <li > Collects and compiles HR metrics and data from a variety of sources including the human resource information system (HRIS) and payroll outputs, management and employee surveys, exit interviews, employment records, government labor statistics, competitors practices, and other sources. </li><li > Analyzes data and statistics for trends and patterns with attention to recruitment, hiring practices, motivation, turnover, and compliance with employment laws and regulations. </li><li > Prepares reports of data results, presenting and explaining findings to senior leadership. </li><li > Identifies and recommends reasonable short- and long-term goals, milestones, and benchmarks for key performance metrics. </li><li > Based on metrics and analysis, makes recommendations for policies and activities to improve the organizational culture including suggestions to attract and hire qualified candidates, to motivate and retain employees, to address staffing issues, and to maintain legal compliance. </li><li > Proactively identify opportunities, create solutions and execute plans to optimize manpower cost and manage the compilation and dissemination of regular (e.g. weekly, monthly, quarterly, etc.) reports on manpower cost optimization plans.<br> </li><li > Assist HR leadership with staffing, recruiting, and departmental budgets. </li><li > Facilitates implementation of new training, development, recruiting, and other related initiatives.<br> </li><li > Ensures compliance with data privacy regulations and best practices. </li><li > Responsible for designing and implementing reporting & business intelligence solutions using Power BI and other tools.<br> </li><li > <p > Responsible for developing, enhancing and maintaining procedure documentation. Continually review procedures to ensure accuracy, validity and maximum efficiency. </p> </li><li > <p > Responsible for identifying opportunities to improve processes and strategies with technology solutions. </p> </li><li > Performs other duties as assigned.<p > <br> </p> </li> </ul><p > </p><p > </p>

VPS Healthcare
12.2019 - 06.2021

<p > <b>Master Data Analyst(Contract Assignment)</b> </p><p > Robinsons- Al Futtaim Group </p><ul > <li > Maintained data quality governance for SAP master data through data coordination and integration to ensure efficient processes and consistent data flows to business and stakeholders. </li><li > Created new SAP master data in key systems, as well as, development and documentation of processes with other functional data owners to support ongoing maintenance and data integrity. </li><li > Responsible for data quality improvements and helps to resolve data quality issues through the appropriate choice of error detection and correction, process control and improvement to meet business requirements while adhering to published data standards. </li><li > Conducted data cleaning to rid the system of old, unused data, or duplicate data for better management and quicker access. </li><li > Developed and implemented strategies to translate business requirements and models into feasible and acceptable data warehouse designs to ensure that business needs are met. </li> </ul><p > <br> </p>

Robinsons- Al Futtaim Group
05.2019 - 11.2019

<p > <b>Safety Data Analyst(Contract Assignment)</b><br> </p><p > Dubai Airports </p><p > </p><ul > <li > Part of the Corporate Health & Safety (H&S) Data Management team which handled the incident monitoring and analysis, document management and operational troubleshooting. </li><li > Developed and implemented data analysis, data collection systems and other strategies that optimize operational efficiency and quality. </li><li > Developed innovative reports and dashboards in Tableau and PowerPoint to the senior management. </li><li > Developed a strategy for an automated data management system in line with the requirements of the team. </li> </ul><p > <b><i><u>Major Tasks Completed</u></i></b><br> </p><p > </p><ul > <li > Designed and developed the team's annual report which included teams KPI performance, events and their strategy for Expo 2020. </li><li > Designed the quantitative plan for the team for expo 2020 by analyzing the incidents data and thereby forecasting the incidents rate for the year 2020. </li><li > Analyzed the team's data and identified critical challenges faced by the team and designed a work plan to work on these challenges. </li> </ul><p > <br> </p><p > <br> </p><p > </p><p > </p><p > </p><p > </p>

Dubai Airports
12.2018 - 03.2019

<p > <b>Senior Data Analyst</b> </p><p > Ernst & Young, Cochin </p><p > </p><ul > <li > As a part of EY Global Travel Analytics team, analysed over millions of records of travel data patterns with a cumulative value of 2bn USD and provided recommendations for cost containment.<br> </li><li > Successfully led the ETL process of creating an in-house database for managing the consolidation of data from 150 countries and 4 Travel Management Companies to ensure data quality, dimension and reduce the turnaround time for generating dashboards. </li><li > Successfully led the functional and technical team for developing interactive stakeholder specific monthly travel dashboards in Tableau for 90+ countries.<br> </li><li > Developed and maintained various travel related KPI reports for the stakeholders using Tableau and Power BI.<br> </li><li > Collaborated with Category and Area Travel, Meetings & Events Operations Leaders to provide insights on data assisting with their Indirect Cost Reduction initiatives and support of stakeholder engagement.<br> </li><li > Liaised between technical (team) and non-technical (senior entity management globally) counterparts for arriving at an appropriate solution centered on business intelligence.<br> </li><li > Mentored team and enabled them to focus on maximizing their individual contribution, their professional growth and their ability to function effectively and cohesively as a team. </li> </ul><p > </p>

Ernst & Young, Cochin
01.2013 - 06.2018

<p > <b>Data Analyst</b> </p><p > Ernst & Young, Cochin </p><p > </p><ul > <li > Deployed data analytics approach for Audit Clients using Alteryx across the Middle East by data cleansing, blending andanalysed the journal entry and trial balance data to identify any discrepancies or anyirregular trends. </li><li > Developed an MS Excel template for the web-based tool designed for Capital ConfidenceBarometer (CCB) and analysed data using MS Excel. </li><li > Developed appropriate statistical model for forecasting the demand forhealthcare personals (Physicians, Nurses, and Allied Healthcare workers) for Saudi Arabia forthe next 10 years and bench marking it with high income group countries. </li><li > Developed and designedCustomer Satisfaction Survey report which was conducted for the Bahrain Government by analyzing the primary survey data. </li><li > Developed and designed a report for the compensation study done for amajor real estate firm in Middle East. </li><li > Developed Driver score and Engagement Quotient by analyzing the Employee Engagement Survey Data which was done for major players in Telecomand Travel industry in Middle East. </li> </ul><p > </p>

Ernst & Young, Cochin
01.2011 - 01.2013

<p > <b>Management Trainee</b> </p><p > Ernst & Young, Cochin </p><p > </p><ul > <li > Involved in the analysis and documentation of the key report in the Islamic Financial Services -WorldTakaful Report. </li><li > Assisted many advisory engagements and specialized support to Islamic Banking andTakaful companies. </li><li > Involved in the preparation of a weekly newsletter named Islamic Finance Weekly Roundupwhich caters to internal subscribers globally in EY which rangers from Partners to Directors. </li> </ul><p > </p>

Ernst & Young, Cochin
01.2010 - 01.2011

Education

undefined

Cochin University of Science and Technology, Master of InternationalBusiness
01.2008 - 01.2011

undefined

University of Calicut, B.Sc Applied Statistics
01.2004 - 01.2007

Skills

    Business Data Analytics using Statistics

undefined

Software

MS Office

R & SPSS

SQL & ALTERYX

TABLEAU,SPOTFIRE & POWER BI

SAP Successfactors

Python

Certification

• Recipient of Dubai Airport's Certificate of Appreciation for Outstanding Performance.

Timeline

Data Analyst- HR Intelligence & People Analytics Gargash Group Responsible for identifying, designing and performing complex analyses and make recommendations on complex HR issues in partnership with the Head- HR Intelligence & People Analytics. Providing training to internal/external stakeholders on data interpretation, data evaluation, statistical and analytical techniques. Design and develop useful metrics, dashboards, analyses and data reporting to support variety of HR and business initiatives. Develop, prepare and analyze metrics to measure effectiveness of business outcomes. Produce clear, concise reports and/or presentations. Develop and prepare charts, tables, and other related documents and graphics. Manage multiple simultaneous work streams.

Gargash Group
07.2021 - Current

HR Business Intelligence Analyst VPS Healthcare Collects and compiles HR metrics and data from a variety of sources including the human resource information system (HRIS) and payroll outputs, management and employee surveys, exit interviews, employment records, government labor statistics, competitors practices, and other sources. Analyzes data and statistics for trends and patterns with attention to recruitment, hiring practices, motivation, turnover, and compliance with employment laws and regulations. Prepares reports of data results, presenting and explaining findings to senior leadership. Identifies and recommends reasonable short- and long-term goals, milestones, and benchmarks for key performance metrics. Based on metrics and analysis, makes recommendations for policies and activities to improve the organizational culture including suggestions to attract and hire qualified candidates, to motivate and retain employees, to address staffing issues, and to maintain legal compliance. Proactively identify opportunities, create solutions and execute plans to optimize manpower cost and manage the compilation and dissemination of regular (e.g. weekly, monthly, quarterly, etc.) reports on manpower cost optimization plans. Assist HR leadership with staffing, recruiting, and departmental budgets. Facilitates implementation of new training, development, recruiting, and other related initiatives. Ensures compliance with data privacy regulations and best practices. Responsible for designing and implementing reporting & business intelligence solutions using Power BI and other tools. Responsible for developing, enhancing and maintaining procedure documentation. Continually review procedures to ensure accuracy, validity and maximum efficiency. Responsible for identifying opportunities to improve processes and strategies with technology solutions. Performs other duties as assigned.

VPS Healthcare
12.2019 - 06.2021

Master Data Analyst(Contract Assignment) Robinsons- Al Futtaim Group Maintained data quality governance for SAP master data through data coordination and integration to ensure efficient processes and consistent data flows to business and stakeholders. Created new SAP master data in key systems, as well as, development and documentation of processes with other functional data owners to support ongoing maintenance and data integrity. Responsible for data quality improvements and helps to resolve data quality issues through the appropriate choice of error detection and correction, process control and improvement to meet business requirements while adhering to published data standards. Conducted data cleaning to rid the system of old, unused data, or duplicate data for better management and quicker access. Developed and implemented strategies to translate business requirements and models into feasible and acceptable data warehouse designs to ensure that business needs are met.

Robinsons- Al Futtaim Group
05.2019 - 11.2019

Safety Data Analyst(Contract Assignment) Dubai Airports Part of the Corporate Health & Safety (H&S) Data Management team which handled the incident monitoring and analysis, document management and operational troubleshooting. Developed and implemented data analysis, data collection systems and other strategies that optimize operational efficiency and quality. Developed innovative reports and dashboards in Tableau and PowerPoint to the senior management. Developed a strategy for an automated data management system in line with the requirements of the team. Major Tasks Completed Designed and developed the team's annual report which included teams KPI performance, events and their strategy for Expo 2020. Designed the quantitative plan for the team for expo 2020 by analyzing the incidents data and thereby forecasting the incidents rate for the year 2020. Analyzed the team's data and identified critical challenges faced by the team and designed a work plan to work on these challenges.

Dubai Airports
12.2018 - 03.2019

Senior Data Analyst Ernst & Young, Cochin As a part of EY Global Travel Analytics team, analysed over millions of records of travel data patterns with a cumulative value of 2bn USD and provided recommendations for cost containment. Successfully led the ETL process of creating an in-house database for managing the consolidation of data from 150 countries and 4 Travel Management Companies to ensure data quality, dimension and reduce the turnaround time for generating dashboards. Successfully led the functional and technical team for developing interactive stakeholder specific monthly travel dashboards in Tableau for 90+ countries. Developed and maintained various travel related KPI reports for the stakeholders using Tableau and Power BI. Collaborated with Category and Area Travel, Meetings & Events Operations Leaders to provide insights on data assisting with their Indirect Cost Reduction initiatives and support of stakeholder engagement. Liaised between technical (team) and non-technical (senior entity management globally) counterparts for arriving at an appropriate solution centered on business intelligence. Mentored team and enabled them to focus on maximizing their individual contribution, their professional growth and their ability to function effectively and cohesively as a team.

Ernst & Young, Cochin
01.2013 - 06.2018

Data Analyst Ernst & Young, Cochin Deployed data analytics approach for Audit Clients using Alteryx across the Middle East by data cleansing, blending andanalysed the journal entry and trial balance data to identify any discrepancies or anyirregular trends. Developed an MS Excel template for the web-based tool designed for Capital ConfidenceBarometer (CCB) and analysed data using MS Excel. Developed appropriate statistical model for forecasting the demand forhealthcare personals (Physicians, Nurses, and Allied Healthcare workers) for Saudi Arabia forthe next 10 years and bench marking it with high income group countries. Developed and designedCustomer Satisfaction Survey report which was conducted for the Bahrain Government by analyzing the primary survey data. Developed and designed a report for the compensation study done for amajor real estate firm in Middle East. Developed Driver score and Engagement Quotient by analyzing the Employee Engagement Survey Data which was done for major players in Telecomand Travel industry in Middle East.

Ernst & Young, Cochin
01.2011 - 01.2013

Management Trainee Ernst & Young, Cochin Involved in the analysis and documentation of the key report in the Islamic Financial Services -WorldTakaful Report. Assisted many advisory engagements and specialized support to Islamic Banking andTakaful companies. Involved in the preparation of a weekly newsletter named Islamic Finance Weekly Roundupwhich caters to internal subscribers globally in EY which rangers from Partners to Directors.

Ernst & Young, Cochin
01.2010 - 01.2011

undefined

Cochin University of Science and Technology, Master of InternationalBusiness
01.2008 - 01.2011

undefined

University of Calicut, B.Sc Applied Statistics
01.2004 - 01.2007
Ashna VilliyathData and BI Professional