R Adesh Tilak
Gurugram,Haryana
Summary
Experienced data analyst skilled in identifying trends, patterns, and insights to aid in business decision-making. Proven track record in creating dashboards with Power BI, SQL (SSMS, Oracle SQL Developer), Microsoft Excel, and BIRT Business Intelligence tools for actionable recommendations. Self-motivated and adaptable with strong analytical skills, able to work independently. Enthusiastic about learning new technologies, improving project processes, and advancing knowledge management solutions.
Overview
8
8
years of professional experience
Work History
Consulting Senior Analyst
KPMG Global Service India Pvt Ltd.
01.2023 - Current
- As part of HR Analytics team, manage ServiceNow CORE HR reporting tickets and queries, ensuring timely resolution and high stakeholder satisfaction.
- Collaborate with the onshore Workforce Analytics team to gather, interpret, and fulfill complex reporting requirements.
- Deliver ad-hoc and scheduled SSRS reports, including modification and maintenance of .rdl files using Microsoft Report Builder.
- Spearhead benchmarking projects, crafting insightful presentations and visual reports using Microsoft PowerPoint to guide stakeholder decision-making.
- Designed and deployed ServiceNow dashboards to track and visualize SLA performance, KGS penetration, and ticket monitoring metrics.
- Develop and maintain dynamic HR dashboards using Power BI and Excel, supporting executive reporting and strategic reviews.
- Streamline manual processes through Alteryx workflows, enhancing reporting accuracy and operational efficiency.
- Work with the HRIS team to ensure alignment and consistency across HR data systems and processes.
- Leverage Generative AI to support data validation processes and enhance the accuracy of HR reports using advanced SQL logic.
Senior Business Analyst
Evaluserve (SEZ) Pvt. Ltd. Gurugram
04.2021 - 01.2023
- Prepare, validate and modify critical components of statistical procedures and reports, score reporting and technical documentation for internal and external clients. Contribute to research projects or special analysis.
- Worked for Microsoft client under consumer channel sales excellence project
- Successfully managed and analyzed sales data for Microsoft hardware products across the Southeast Asia region, leading to increased revenue and improved market share.
- Developed dashboards in Power BI using DAX queries and measures to interpret results as per business requirements.
- Communicated directly with clients on a weekly basis to identify data quality issues and determine appropriate solutions.
- Performed ETL in Power BI to extract data from SQL server database and visualize results aligned with business logic.
- Extracted records from database using SQL queries involving multiple tables
- Successfully validated numbers by generating and analyzing reports to ensure quality checks
- Ensured accuracy of data by implementing efficient data management techniques
- Effectively managed data by utilizing various tools and technologies
- Monitored key metrics to understand root causes of changes and identify opportunities for improvement.
- Executed data migration using SSIS packages to extract data from O2 database and load it to staging tables for data combination.
- Engaged in direct client communication to analyze inventory data reported by Microsoft partners and identify trends, gaps, and patterns.
Data Analyst
Voziq India Pvt. Ltd.
09.2020 - 04.2021
- Achieved 98% accuracy in customer retention by developing and updating dashboards in Elastic Search Kibana and Elastic Search Canvas using SQL queries
- - Performed query optimization and tuning based on business requirements.
- Developed advanced reports using Microsoft Excel functions for the senior management team.
- Utilized Python for data analysis to improve performance and reduce processing time. - Improved data analysis efficiency by 80% through spearheading EDA in Python using libraries for efficient calculations.
Content Review Data Analyst
Hay's Recruitment (Accenture)
08.2017 - 02.2019
- Managed staffing requirements for internal teams by analyzing contact center statistics and using regression and time series forecasting to project ticket volume, average handling time (AHT), and shrinkage.
- Executed capacity planning and generated schedules to optimize resource allocation and meet operational needs.
- Reviewed user accounts flagged for potentially sensitive content, ensuring adherence to company policies and procedures.
- Collaborated with team members to investigate and resolve policy violations effectively.
- Trained junior staff and independently ensured the timely delivery of key projects.
Education
Master of Science - data analytics
National College of Ireland
Dublin06.2017
Bachelor of Arts - Mathematics Honours
PGDAV College
New Delhi07.2010
Skills
- Power BI, Advanced SQL, Advanced MS Excel, Alteryx
- Sharepoint, Teams, and Outlook
- Market research
- Business intelligence analysis
LANGUAGES
English (UK), Hindi.
Hobbies and Interests
Travelling, Adventuring, Explore Destinations and Cycling.
Timeline
Consulting Senior Analyst
KPMG Global Service India Pvt Ltd.
01.2023 - Current
Senior Business Analyst
Evaluserve (SEZ) Pvt. Ltd. Gurugram
04.2021 - 01.2023
Data Analyst
Voziq India Pvt. Ltd.
09.2020 - 04.2021
Content Review Data Analyst
Hay's Recruitment (Accenture)
08.2017 - 02.2019
Master of Science - data analytics
National College of Ireland
Bachelor of Arts - Mathematics Honours
PGDAV College
Similar Profiles
Ankik MahataAnkik Mahata
Associate Consultant at KPMG Global Service Pvt LtdAssociate Consultant at KPMG Global Service Pvt Ltd
Aquib H. TorgalAquib H. Torgal
Associate Manager Cloud Architect at KPMG Global Service Pvt LtdAssociate Manager Cloud Architect at KPMG Global Service Pvt Ltd
Saumya ModiSaumya Modi
Assistant Manager at KPMG Global Service Pvt LTDAssistant Manager at KPMG Global Service Pvt LTD
Vandana ChaudharyVandana Chaudhary
Senior Software Solution Engineer at Gupshup Technology Pvt. Ltd.Senior Software Solution Engineer at Gupshup Technology Pvt. Ltd.
Naman AroraNaman Arora
Senior Finance Analyst at Jones Lang Lasalle (JLL)Senior Finance Analyst at Jones Lang Lasalle (JLL)