Dharvin Raj Jayasangar
Senior Business Analyst
Summary
Experienced professional adept at driving data-driven excellence and fostering junior talents. Proven track record in leading complex analytics projects.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Senior Business Analyst
Securitas Guarding Services
01.2023 - Current
- Leadership in Business Analytics: Guided non-technical DSOMs in analysis and mentored them to develop consulting-style presentations with a strong emphasis on data storytelling. Achieved nearly 100% participation and awareness among DSOMs in OKRs, fostering a culture of data-driven decision-making and proactive measures in APAC.
- Strategic Framework Development: Designed OKR framework from a MSFT DCPS Senior Leadership-level perspective, facilitating its dissemination to other regions for enhanced efficiency and analytical prowess.
- Strategic Analysis and Risk Mitigation: Spearheaded divisional strategies through robust analysis, resulting in an outstanding 38% reduction in access violations across APAC. Executed temporal analysis of vendor-induced access violation incidents, achieving a notable 100% reduction in Singapore and effectively mitigating recurring vendor-related incidents in Pune.
- Insightful Data Analysis: Examined datacenter age dynamics, revealing a notable trend: older facilities exhibited higher access violation rates in production spaces due to increased foot traffic. This discovery challenged conventional assumptions, providing valuable insights for decision-makers.
- Process Optimization and Automation: Engineered an application to streamline project submission and approval processes, eliminating manual intervention by automating email notifications to submitters. Anticipated time savings for submissions and approvals to reach approximately 90%.
- Executive Reporting and Communication: Developed extensive PowerBI report for executive leadership, providing a comprehensive overview of project progress and status in APAC. Anticipating 60% progress and completion rate within the next 8 months, while also expecting a 70% increase in viewership attributed to enhanced UI/UX design, emphasizing improved usability and viewer experience.
- Stakeholder Management and Alignment: Managed stakeholder expectations through transparent communication and timely status updates, ensuring alignment between project deliverables and business objectives.
Data Engineer
Micron Technology
03.2022 - 02.2023
- Enhanced data processing efficiency through optimized ETL pipelines and streamlined database design.
- Collaborated on ETL tasks to uphold data integrity and ensure pipeline stability.
- Improved data quality via meticulous cleaning, validation, and transformation processes.
- Designed scalable data models to support business intelligence and reporting requirements.
- Implemented advanced analytics solutions with Power BI and SPLUNK, leading to 80% decrease in incident resolution time and enhanced system reliability within 1 hour.
- Established Data Virtualization for secure access, preventing direct entry to production database, and enabling data science team to access 95% real-time data continuously.
- Documented and communicated database schemas using accepted notations.
Senior Reporting Analyst
Concentrix
09.2021 - 03.2022
- Leadership & Mentorship: Prioritized junior analysts' growth by conducting comprehensive training sessions on effective reporting, analysis, and data storytelling. Fostered culture of continuous learning, fortifying team cohesion, and ensuring skilled professional pipeline for success.
- Revolutionized Reporting Automation: Led state-of-the-art reporting automation initiative using Power Pivot and Power Query in Excel. Integrated diverse data sources, crafted intricate data models, resulting in impressive 80% reduction in reporting cycle time and 100% improvement in data accuracy, establishing new benchmarks for efficiency and precision.
- Championed Data-Driven Decision-Making: Led organization-wide embrace of data-driven decision-making, resulting in impressive 80% surge in operational efficiency and substantial cost savings. By advocating for evidence-based strategies, catalyzed transformative improvements across key business functions.
- Unearthed Key Insights for Client Satisfaction: Proactively analyzed CSAT, SSAT, and ASAT scores, revealing critical trends and actionable insights. For example, precise CSAT analysis identified recurring pain points, leading to targeted service enhancements and tangible boosts in client satisfaction.
- Tailored Interventions: Utilized advanced statistical method to pinpoint root causes of client satisfaction fluctuations, enabling precision-targeted interventions. Notably, analysis of SSAT scores revealed direct correlation between agent responsiveness and satisfaction levels. Implemented customized training programs to enhance agent responsiveness, resulting in remarkable 90% improvement within 8 months.
- Leveraged advanced Excel functions and macros to automate repetitive tasks, increasing overall productivity
Reporting Analyst
Accenture
09.2020 - 09.2021
- Led Ad-Review Processes for Key Client: Analyzed metrics like utilization, occupancy, Average Handle Time, Throughput, and agent quality to ensure client policy adherence. By optimizing agent scheduling based on occupancy metrics, achieved 95% increase in productivity within 3 months.
- Developed Centralized Reporting Repository: Managed centralized repository for ad-review reporting, reducing duplicate efforts by 100% and fostering better collaboration among teams. Standardized reporting templates to minimize errors, resulting in 100% reduction in reporting discrepancies within 3 months.
- Implemented Industry-Leading Report Design Practices: Introduced report design practices tailored to ad-review metrics, resulting in 95% increase in report usability and effectiveness. Incorporating interactive dashboards enabled stakeholders to gain real-time insights, facilitating quicker decision-making and action.
- Collaborated for Process Improvements: Engaged in cross-functional collaboration to identify and implement process enhancements, resulting in 100% increase in operational efficiency and cost savings. Leveraged Power Query to automate repetitive tasks, achieving 100% reduction in manual errors and increase in throughput within 5 months.
Education
Bachelor of Science - Actuarial Science (Hons)
Universiti Kebangsaan Malaysia
Bangi, Selangor, Malaysia 04.2001 -
Skills
SQL Proficiency & Database Management
App Development
Microsoft PowerBI, DAX, Power Query
Python
Tableau
Stakeholder Management
Project Management
Process Optimization
Communication & Interpersonal Skills
Certification
Exam PL-300: Microsoft Power BI Data Analyst
Timeline
Exam PL-300: Microsoft Power BI Data Analyst
01-2024
Senior Business Analyst
Securitas Guarding Services
01.2023 - Current
Data Engineer
Micron Technology
03.2022 - 02.2023
Senior Reporting Analyst
Concentrix
09.2021 - 03.2022
Reporting Analyst
Accenture
09.2020 - 09.2021
Bachelor of Science - Actuarial Science (Hons)
Universiti Kebangsaan Malaysia
04.2001 -
Similar Profiles
Guganesvaran RajaduraiGuganesvaran Rajadurai
Control Room Supervisor at Securitas Guarding ServicesControl Room Supervisor at Securitas Guarding Services
Kasturi RamachandranKasturi Ramachandran
Field Training Officer at Securitas Guarding ServicesField Training Officer at Securitas Guarding Services
Martin NtindaMartin Ntinda
HSSE Supervisor - Hamad Port, Mwani Qatar (Mesaiee at European Guarding and Security ServicesHSSE Supervisor - Hamad Port, Mwani Qatar (Mesaiee at European Guarding and Security Services