Sahil Vij

▪ Supporting the ongoing maintenance and optimization of the company’s website, while specializing in asset data management and analysis to drive informed decision-making.
▪ Designed and implemented a dynamic Excel-based asset management tool integrating Power Query automation, user-driven data inputs, and conditional logic, culminating in a Power BI dashboard for visualizing infrastructure condition across multiple asset classes.
▪ Leveraging the power of AI and automation to assess large datasets, uncover trends, and develop insightful dashboards with compelling visual narratives that help teams see the bigger picture.
▪ Aiming to make data not just accessible but actionable.

• Company Overview: A global leader in audit, tax, and advisory services.
• Developed a Payroll Diagnostics System for a large provincial utility, processing over 30 million rows of payroll data across three years and engineering 40+ custom rules to detect anomalies and ensure data integrity.
• Designed and implemented an AI Governance Framework for multiple clients, conducting AI readiness assessments and model risk evaluations across six+ business domains.
• Spearheaded internal enablement of artificial intelligence usage by conducting training on prompt engineering frameworks, promoting effective utilization of generative AI across teams.
• Created a Government Network Analysis Tool leveraging Natural Language Processing (NLP) to extract insights from federal mandate letters, and visualized strategic relationships and policy themes using Power BI network diagrams. Deployed the solution via Azure Databricks, Azure Synapse Analytics for building data pipelines.
• Built and deployed 31+ stored procedures on SQL Server to support enterprise KPIs and integrated row-level security in Power BI dashboards for department-specific data access.
• Supported clients in automating workflows with Power Automate, developing custom dashboards with Power BI, and assessing risk in complex SQL statements to ensure compliance and optimization.
• Delivered cross-functional internal tools using the Power Platform stack (PowerApps, Power Automate, Power Pages, and Power BI) to enable project managers to monitor resource costs, hour utilization, and project budgets with real-time insights.

• Enhanced second-hand car price prediction models by cleaning and preprocessing datasets of over 10,000 entries using pandas, and applying supervised machine learning regression algorithms to improve forecasting accuracy.
• Built interactive city roadmaps using Folium to visualize geographic data and support automated project tracking, enabling better planning and monitoring across city infrastructure projects.
• Modernized and optimized core database structures, including tables, views, and materialized views, using MySQL, improving data integrity and system performance for reporting workflows.

• Developed 6 to 8 components and designed them suitably for 'Chat Servers Applications' for HCL technologies warehouse based on JAVA language.