Vinith Singh

Experience

• 

  Mindtree

  Apr 2022 - Nov 2022

  Junior Data Engineer for Microsoft

  ✅ SQL Developer with 2+ years of hands-on experience in developing database applications, as well as administering database and information systems. Possesses In-depth knowledge of database development, IT solutions, MS SQL Server, software development, business analysis, systems administration, process re-engineering, and management information services.✅ SQL BI:• Played a pivotal role in the design, creation, and maintenance of SQL databases, employing Structured Query Language (SQL) to execute CRUD commands, ensuring optimal database functionality.• Drive stability, reliability & performance by optimising in-application SQL statements and design user-focused database.• Utilised Joins and sub-Queries to simplify complex queries involving multiple tables while optimising procedures and triggers to be used in production.•Troubleshooting on Kerberos issues, Authentication issues and Migration in SSRS, SSAS, and PBIRS.• Troubleshooting on Scale-out Deployment in SSRS, SSAS, and PBIRS. Knowledge of database security, backup and recovery, and performance monitoring standards.• Designed and developed robust reporting frameworks with Microsoft BI technologies, addressing both paginated and Power BI formats; improved report accuracy by 30% and reduced troubleshooting time by 50% through efficient data management.• Engineered comprehensive reporting solutions using MySQL, SQL Server, SSRS, PBIRS, SSAS, and Power BI; streamlined data visualisation and analytics, reducing report generation time by 40% and enhancing data-driven decision-making by 25%.• On-prem Analysis Service Associated with SSDT Tools and Visual Studio, Configurations, Setup, Bugs, Limitations, Design & Tabular Models etc. Show less

• 

  LTIMindtree

  Nov 2022 - now

  Microsoft Data Engineer

  ✅ SQL Developer with 2+ years of hands-on experience in developing database applications, as well as administering database and information systems. Possesses In-depth knowledge of database development, IT solutions, MS SQL Server, software development, business analysis, systems administration, process re-engineering, and management information services.✅ SQL BI:• Played a pivotal role in the design, creation, and maintenance of SQL databases, employing Structured Query Language (SQL) to execute CRUD commands, ensuring optimal database functionality.• Drive stability, reliability & performance by optimising in-application SQL statements and design user-focused database.• Utilised Joins and sub-Queries to simplify complex queries involving multiple tables while optimising procedures and triggers to be used in production.•Troubleshooting on Kerberos issues, Authentication issues and Migration in SSRS, SSAS, and PBIRS.• Troubleshooting on Scale-out Deployment in SSRS, SSAS, and PBIRS. Knowledge of database security, backup and recovery, and performance monitoring standards.✅Azure Data & AI:• Design tabular & multidimensional model projects using Visual Studio with Analysis Services projects extensions (VSIX).• Utilised Azure Automation and PowerShell Runbooks to perform automated data refresh, tier scaling, and job creation operations on Azure Analysis tabular models.• Proficiency in troubleshooting connectivity issues using advanced diagnostic tools, including Fiddler, Wireshark, Browser Traces, NetMon Traces, Windows Event Logs, and SQL Profiler.• Troubleshooting performance issues, connection issues and also deal with connectivity issues for SQL, Azure Analysis Services and Azure products.✅ I work with network analysts to review, diagnose, and treat technical problems related to computer networking operations and work with software and hardware* Microsoft BI technologies, including SSRS, PBIRS, SSAS, and SharePoint. Show less