Sumant Kumar Email & Phone Number

Delhi, India

Gurugram, Haryana, India

1. Led full Data life cycle-KPI creation,SQL data pulls and Linear regression forecasting. Orchestrated comprehensive dashboard and stakeholder management, driving a 7.8% increase in Trailer utilization.2. Actual Vs Forecasted: Developed a dashboard that analyzes actual vs budget variance and forecasts operational expenditure using time series forecastingtechniques. Applied ANOVA to assess the statistical significance of variations between forecasted and actual values, ensuring accurate identification of trends and3. Highlight the tracking of operational KPIs (e.g., work order completion rates, energy consumption) and how you identified trends that improved operationalefficiency4. Created a Lease Admin Dashboard that integrated real estate market trends and interest rates, allowing stakeholders to renegotiate leases and optimize occupancycosts based on macroeconomic conditions5. Transitioned the CBRE's global quarterly KPI and financial reporting from static reports to an interactive self-serve dashboard model based on Box and Tableau Server.6. Acted as the conduit between technical teams and the business, translating unstructured data into a consistent visual language that helped end-users make insightful decisions.7. Led skills-development workshops and training sessions to educate internal and external end-users on how to utilize the dashboards.8. Took ownership of defining guidelines for data requirements, visualization best practices, and management of user licensing.9 .Developed a Facility Management Dashboard incorporating macroeconomic data such as labor costs and energy prices, enabling strategic decisions to optimizeresource allocation and reduce operational costs

Noida

Oversee multiple business intelligence projects with annual costs exceeding $250M, serving high-profile clients such as Marriot hotels, AmazonAnalyzed operational data for the hospitality and real estate sectors, developing comprehensive P2P dashboards to track KPIs like Supplier Defect Rate andPurchase Order Cycle Time.Supported the performance monitoring and KPI tracking process, helping Marriott Hotels identify process inefficiencies and improving procurement operations by12%.Due to exceptional customer satisfaction and project success, spearheaded process improvement initiatives, including:Developed over 50 dashboards and wrote SQL code to analyze data across various domains such as customer satisfaction, facilities management, finance, health and safety, project management, lease administration, and transactions management. Utilized systems including Survey Monkey, Maximo, SI7, Oracle, JDE, MyHSE, Expesite, Kahua, CoStar, HarborFlex, and Transact.

Gurugram, Haryana, India

1) Created T-SQL stored procedures, Triggers, Functions, and Performance tuning for maintenance of data integrity2) Data Governance: Collaborate with data governance teams to define data quality standards, policies, and procedures, ensuring compliance across the organization.3) Data Quality Metrics: Establish and monitor key data quality metrics (e.g., accuracy, completeness, consistency, timeliness) to assess the health of the data.3) Extracting and harmonizing data coming from various channels and digital channels.4) Performing QA on weekly basis for 15 M rows of Data5) Handling Adhoc requests and project tracker to ensure client SLA are met 5) Language and Technologies: Python, SQL, SSIS

1) Developed Tables, views and materialized views using SQL2) Generating Daily Weekly and Monthly Sales reports.3) Augmenting the revenue by 30 percent by regularly monitoring the KPIs and seeking strategic solution 4) Language and Technologies: SQL, Microsoft excel

Master Of Business Administration - Mba, Business Analytics

Bachelor Of Technology - Btech