Khyati Lohe Email & Phone Number

Windsor, On, Ca

Canada

• Developed and maintained real-time dashboards and reports in Power BI and Tableau to monitor IT infrastructure performance, application uptime, and client SLAs, enabling proactive management and issue resolution• Conducted deep data analysis on system logs, network traffic, and application metrics to identify trends, detect anomalies, and support cybersecurity initiatives, contributing to enhanced security posture• Created automated data pipelines using Python and SQL to integrate data from multiple sources, including cloud platforms (AWS, Azure), on-premises servers, and third-party applications, reducing manual processing time by 40%• Designed and implemented a centralized reporting system for tracking project KPIs, resource utilization, and financial performance across multiple client engagements, improving transparency and decision-making• Performed regular data audits and cleansing activities to ensure data integrity across internal databases, client systems, and third-party integrations, supporting accurate reporting and compliance efforts• Utilized SQL, R, and advanced Excel techniques to develop customized reports and visualizations for internal stakeholders, helping to identify process inefficiencies and areas for improvement• Contributed to the development of machine learning models for predictive maintenance and failure analysis of IT infrastructure, improving service reliability and reducing downtime by 25%• Engaged in data governance and quality initiatives by creating and enforcing data management standards, ensuring consistent and reliable data across the organization• Collaborated with sales and marketing teams to analyze customer acquisition and retention metrics, driving targeted campaigns and product enhancements based on data-driven insights

Canada

• Designed and implemented customized dashboards to track project KPIs and performance metrics, enabling stakeholders to monitor progress and make data-driven decisions in real-time• Conducted in-depth performance analysis of project initiatives and processes to identified areas for improvement and optimization, driving efficiencies and maximizing project impact• Utilized Microsoft Power BI and Excel to analyze HR data and to present dashboards to clients Assisted in the migration of Excel reports to Power BI• Visualized CRM data to provide effective insights by using explanatory data analysis on a Tableau Dashboard Built operational metrics KPI that describe the trends in performance, management, and business side data• Responsible for maintenance and monitoring of the ETL Extract, transform and Load that updated the data in the MySQL reporting database used by the Meta base reporting tool• Extracted data for building reports, working on SQL Server database and ensuring data quality through sourcing, generation, normalization, and transformation• Generated data via advanced functions to create pivot tables, participating in 3 cross-functional teams to interpret analytics and outcomes• Designed, developed, automated, and supported complex applications to extract, transform, and load data Developed complex SQL queries using Temp tables• Leveraged understanding of the business environment and business partner needs to proactively identify opportunities through data analysis Build various Tableau dashboards for different metrics to be used by Senior leaders, and other internal business partners• Implemented advanced Excel Macros and VBA scripts to automate repetitive data entry and manipulation tasks, resulting increase in operational efficiency and improved data accuracy for inventory and sales reports

India

• Developed and maintained comprehensive databases to track and analyze sales metrics, trends, and performance indicators, enhancing data-driven decision-making processes• Utilized advanced analytical tools SQL and Excel to create detailed sales reports and dashboards, providing actionable insights to the sales and marketing teams• Conducted in-depth market analysis using Power BI to identify sales opportunities, forecast sales trends, and assess competitive market strategies, significantly contributing to an increase in sales efficiency and data-driven decision making• Managed the extraction, transformation, and loading ETL of large datasets, ensuring accuracy and integrity in the sales data reporting system• Implemented predictive analytics models using Power BI to forecast sales outcomes and identify key performance drivers, leading to a more agile and responsive sales strategy and enhanced data visualization capabilities• Actively monitored and ensured compliance with data privacy and protection regulations, maintaining the integrity and confidentiality of sales data• Improved data visualization and decision-making efficiency through Power BI dashboard implementation, achieving increase in data reporting accuracy with MySQL analyses• Reduced report development time by implementing best practices and utilizing custom visuals Collaborated with the IT team to streamline data collection resulting reduction in data processing time

Postgraduate Degree, Data Analytics For Business

Bachelor Of Science - Bs, Statistics