• Leading the team for implementation of Facility Management tool (FM tool).• Coordinating with SAP team and FM tool service providers for data integration.o collection, transformation & updating the data in the SAP masters to be able to use the same in the new FM tool through integration.o Fetching the reports from SAP. Updating the SAP data as required.• Designing solutions for team requirements.o Make plans for timely & error free delivery of the projects.o Develop… Show more • Leading the team for implementation of Facility Management tool (FM tool).• Coordinating with SAP team and FM tool service providers for data integration.o collection, transformation & updating the data in the SAP masters to be able to use the same in the new FM tool through integration.o Fetching the reports from SAP. Updating the SAP data as required.• Designing solutions for team requirements.o Make plans for timely & error free delivery of the projects.o Develop Power BI solutions for analysing the data.• Conducting tenant satisfaction surveys using Microsoft Forms. Creating Power BI dashboards to visualise the Tenant responses.• Training the data collection team on cleaning and transforming the data• Capturing data for FM budgeting, legal compliances and certifications for LEED and ESG. Show less

• Leading and managing the MIS team, which is responsible for Data collection, data analysis, dashboard creation, KPI tracking, and handling ad hoc report requests.• Monitor the ETL process This involves ensuring the accuracy and quality of Employee details, badging data, and Building Occupancy data for reliable data analysis and reporting.• Establish connections between diverse data sources such as SQL Server, Web Applications, and Excel, perform data modelling, and link the data to… Show more • Leading and managing the MIS team, which is responsible for Data collection, data analysis, dashboard creation, KPI tracking, and handling ad hoc report requests.• Monitor the ETL process This involves ensuring the accuracy and quality of Employee details, badging data, and Building Occupancy data for reliable data analysis and reporting.• Establish connections between diverse data sources such as SQL Server, Web Applications, and Excel, perform data modelling, and link the data to Power BI.• Analysing stakeholder requirements to improve the Power BI dashboards, focusing on various facility management-related KPIs. Achieved this by using SQL queries, Power Query, M coding, and DAX for effective data analysis.• Troubleshooting the issues in previously delivered customized automation solutions, Power BI, Power Automate, Smartsheet projects.• Organizing project demos, documenting projects, and ensuring project lifecycle management.• Taking the lead in creating and automating various projects.• Define KPIs and automate the process of importing and exporting metrics into Excel for a KPI Metrics tracker using Power Query. Show less

• ETL (Extracting, Transforming, and Loading) tasks, including extracting data like Employee details, badging data, and Building Occupancy data from diverse sources such as SQL Server, Web Applications, and Excel.• Establishing connections between varied data sources, performing data modelling, and linking the data to Power BI.• Generating informative Power BI dashboards that encompass facility expenditures, the total portfolio area, employee count, building utilization, and performance… Show more • ETL (Extracting, Transforming, and Loading) tasks, including extracting data like Employee details, badging data, and Building Occupancy data from diverse sources such as SQL Server, Web Applications, and Excel.• Establishing connections between varied data sources, performing data modelling, and linking the data to Power BI.• Generating informative Power BI dashboards that encompass facility expenditures, the total portfolio area, employee count, building utilization, and performance against SLAs for completed FM tickets.• Utilizing a range of tools, including SQL queries, Power Query, M coding, and DAX, for thorough data analysis.• Provide tailored technology solutions for each business line, Select and design automation solutions for projects such as o Creating a Contract Management System with Power BIo Automating Facility Closure Forms with Power Automateo Implementing Smartsheet Workflows as per the team requirements.• Gathering Facility Management-related data for Avaya's global sites from diverse sources, such as Web Applications and Excel files.• Leveraging the capabilities of Power Automate Desktop and Power Automate (Cloud) to automate recurring tasks and business processes, tailored to the team's needs.• Uploading data to shared locations, folders, and SharePoint for easy access and collaboration.• Creating and sharing monthly management decks and PowerPoint presentations.• Contributing to the creation and maintenance of Facility Management data in Smartsheet to enhance team collaboration.• Demonstrating expertise in Smartsheet administration, automation, and providing essential training to team members. Show less

• Monitoring and coordinating work orders.• Budget analysis and variance communication.• Monitoring FM Work Orders and follow-up with Global Facility Managers for timely closure.• Generating and analysing Work Order reports for effective decision-making.• Handling data entry in the Facility Management tool for Avaya's global locations• Maintaining data related to space occupied by employees at global locations and efficiently tracking vacant spaces.• Making Power Point… Show more • Monitoring and coordinating work orders.• Budget analysis and variance communication.• Monitoring FM Work Orders and follow-up with Global Facility Managers for timely closure.• Generating and analysing Work Order reports for effective decision-making.• Handling data entry in the Facility Management tool for Avaya's global locations• Maintaining data related to space occupied by employees at global locations and efficiently tracking vacant spaces.• Making Power Point Presentations on business unit-wise space allocation, contributing to streamlined operations and cost optimization. Show less

• Monitoring and analysing work orders.• Data entry and space management.• Budget consolidation and invoice processing.

• Processing CAPEX and OPEX bills.• coordinate with finance and vendors, track maintenance expenses.• handle attendance reports and employee schedules.• organize safety trainings, and document preventive maintenance for utility equipment

• Trouble-shooting and ticket management.• Inventory tracking using MS Access• Generating daily and monthly ticket reports.

• Troubleshooting and ticket management.• Escalating high-priority incidents.• Generating the reports like Attendance report, Weekly Outage Tracker.