Vedant Faye

System Engineer @Infosys

Pune, IN

Developed Interactive Power BI Dashboards and reports to visualize key business metrics and KPIs,catering to key stakeholders facilitating in decision making. Implemented Incremental Data refresh for large datasets from Data sources like SQL Server based MISplatform, Excel, Azure Datalake, Hadoop Spark clusters using SparkSQL, etc. Developed and maintained complex SQL queries, CTEs, Temp Tables, Database Schemas, Tables, Views,Stored procedures, Functions and Triggers, Constraints, Indexes, etc on SQL server Database. Optimized legacy SQL queries, Stored procedures, views by introducing concepts like Clustered and Nonclustered indexing, Common Table Expressions, eliminating use of unionall and replacing them withefficient joins, etc resulting in decrease of query runtimes by upto 70%. Collaborated with Senior Analysts, Data scientists, Product Managers across Cross-functional teams tooptimize and Improve key insights and Dashboards helping stakeholder achieve upto 5x growthannually. Developed DAX functions to create additions calculated columns, custom time attributes like day-onday, Month-on-Month, Year-to-date (YTD), etc. Interacted with various Business users, Analysts, stakeholders for gathering report requirements as BRDand translating then into dynamic Power BI Dashboards and reports.