About

🚀 Vinith Singh – Microsoft Specialist

💼 Professional Summary

Results-driven IT professional with over 3 years of experience in Data Engineering, Azure Administration, and Business Intelligence (BI). Skilled in designing and managing end-to-end data pipelines using Azure Data Factory, Databricks, and Microsoft Fabric, with strong hands-on experience in SQL, SSIS, and Power BI. In addition to cloud-based ETL, I actively work on the administration and automation side of Azure, including Azure Logic Apps, Synapse Analytics, Azure Automation, and monitoring. I also bring practical expertise in maintaining on-premises BI solutions such as SSRS, PBIRS, SSAS, and enterprise SQL Server environments, enabling seamless hybrid cloud solutions across data platforms.

🛠️ Technical Skills (ADE)

• Cloud: Azure (ADF, Data Lake, Fabric, Microsoft EntraID, Automation, Synapse, 365 Admin, SQL), GCP
• Tools: SSIS, SSAS, Databricks, Power BI, SSRS, PBIRS, Delta Lake, Azure Data Studio, SSMS, SSASDiag, Wireshark, Fiddler
• Languages: PySpark, SQL, HTML, Java, C++, PowerShell
• DevOps: Azure DevOps, GitHub Actions
• Security: Unity Catalog, RBAC, Kerberos, RLS

🛠️ Technical Skills (DBA)

• Database Expertise: SQL Server 2022, 2019, 2016, 2012, MySQL, Azure SQL Server, Oracle, Snowflake, Fabric Administrator
• Cloud/Azure: Azure Services, Azure Analysis Services, Azure Active Directory, Power BI Administrator
• Languages: SQL, T-SQL, DAX, MDX, C++, Java, HTML, Power Query, PowerShell Scripting
• Reporting Tools: SQL Server Reporting Services, Power BI Reporting Services, Microsoft Report Builder, SSDT Tools
• Data Modeling Tools: SQL Server Analysis Services, Power BI Desktop
• Tools & Services: SSMS, Azure Data Studio, Scale-out, SAN, iSCSI, DNS, AD, Windows Server, Linux, NLB, HA, FCI

🛠️ Technical Skills (Power BI Analyst)

• Data Visualization:Power BI (DAX, Power Query, Power Pivot), Tableau, SSRS, SSDT Tools, Excel
• Data Analysis & Query Languages:SQL, MDX, DAX, Power Query, C++, Java, Python
• Data Warehousing:Microsoft SQL Server, Azure SQL Database, MySQL
• Data Modeling & ETL Tools:Star/Snowflake Schemas, ETL Processes, SSIS, SSAS, SSRS, Synapse Analytics, Microsoft Fabric
• Soft Skills:Problem-Solving, Communication, Stakeholder Management, Agile/Scrum

🏢 Experience

Microsoft Data Engineer @ LTIMindtree (Jun 2022 – Present)

• Collaborated with cross-functional teams to deliver secure, scalable, and maintainable data solutions aligned with business needs
• Ingested data from on-premise, SFTP, and cloud platforms (Azure, GCP) using ADF, Azure SQL, and Data Lake Storage.
• Performed complex data transformations using PySpark, ADF, and SQL to ensure data quality and consistency.
• Developed end-to-end data pipelines with ADF and Databricks
• Worked with Delta Lake, Unity Catalog, and RBAC
• Created dynamic pipelines using ADF parameters to support flexible and scalable data workflows.
• Implemented Unity Catalog and RBAC policies in Databricks to govern data access and enhance security.

Database Administrator @ LTIMindtree (Jun 2023 – Present)

• Streamlined database warehouse management by implementing database partitioning, achieving a 40% reduction in query response times and supporting exponential data growth
• Revamped backup and recovery strategies across multiple SQL servers, shortening recovery time objectives by 75% and delivering a robust disaster recovery plan
• Proficient in setting up, configuring, and administering Microsoft Business Intelligence tools including SQL Server Reporting Services (SSRS), Power BI Report Server (PBIRS), SQL Server Integration Services (SSIS), and SharePoint Integration
• Collaborated with cross-functional teams to transition to a cloud-based infrastructure, integrating Azure SQL Database services and facilitating a 50% cost saving on maintenance
• Led a team of 8 and collaborated with Microsoft FTLs, managing MSBI (SSRS, SSAS) admin tasks and providing end-to-end support for SSRS, Power BI, and SSAS, including setup, deployment, maintenance, and troubleshooting

SQLBI Developer @ LTIMindtree (May 2022 – Present)

• Enhanced data integration strategies, effectively consolidating data sources by 15%, which streamlined reporting functions
• Engineered reporting solutions using MySQL, SQL Server, SSRS, PBIRS, SSAS, & Power BI; streamlined data visualisation and analytics, reducing report generation time by 40% and enhancing data-driven decision-making by 25%
• Leveraged Power BI, DAX, and SQL to construct dynamic dashboards displaying key business metrics, increasing decision-making efficiency by 35%
• Constructed 15+ interactive SSRS reports, automating data visualization for stakeholders, boosting data-driven decision-making by 40% and improving insights into key performance indicators based on KPIs
• Visualized complex data sets with Power BI to create user-friendly dashboards, enabling the leadership team to identify key performance indicators and improve operational efficiency by a quantifiable 20%
• Implemented parameterized dashboards and reports with SQL Server Reporting Services (SSRS)

📚 Certifications

• Microsoft Certified: Azure Fundamentals
• DP-700: Fabric Data Engineer
• SQL Bootcamp
• Power BI – Beginners to Advance
• Azure Data Factory For Data Engineers
• Microsoft Fabric: The Ultimate Guide (with Projects)
• DP-300: Administering Relational Databases on Microsoft Azure
• Azure Analysis Services Foundational
• CompTIA A+ (PC Technician), N+ (Networking)
• AWS for Beginners
• Power BI Paginated Reports Foundational
• Power BI Report Server Foundational
• Microsoft 365 Fundamentals
• Microsoft SQL Server Analysis Services – SSAS (Tabular DAX)

📂 Projects

1. Microsoft | Enterprise Data Ingestion and Transformation Pipeline Using ADF

• Designed and implemented parameterized and dynamic ADF pipelines for automated data ingestion from public APIs and flat files.
• Configured data flows and mapping transformations for cleaning, filtering, and shaping ingested data before loading into curated zones.
• Scheduled and orchestrated daily data ingestion using ADF triggers and monitoring via Azure Monitor and alerts.
• Optimized pipeline performance with parallel execution, reuse patterns, and modular datasets.
• Integrated processed data with Power BI dashboards for business insights and analytics.
• Collaborated with cloud architects and data engineers to ensure cost-effective storage and processing using best practices.
• Contributed to CI/CD automation of pipelines via Azure DevOps (if practiced during course or job).

2. Microsoft Fabric (Preview Testing)

• Worked together with the Microsoft client to test the newly launched Microsoft Fabric in preview mode.
• Developed a data pipeline and notebooks using Azure Bing Services.
• Tested ADF and ADB features in Fabric.
• Utilized Notebooks, Pipelines, PowerBI, Data Activator, Spark Definition, Semantic Models, Data Flow Gen 2, and One Lake house.
• Managed data storage using One Lake.
• Automatically generated PowerBI reports using Fabric.
• Participated in multiple sessions with the Microsoft product team.
• Initiated an IcM with Microsoft to review bugs with the product team.

3. Microsoft Database Administrator

• Installed, configured, and maintained SQL Server 2022, 2019, and 2016 in development, test, and production environments, ensuring seamless operation and optimal performance
• Configured and maintained Fail-Over Clustering using SQL Server, enhancing HA and disaster recovery capabilities
• Configured and maintained Replications, Log Shipping, and Mirroring for High Availability, ensuring data redundancy and uninterrupted access
• Conducted database and SQL/T-SQL performance tuning activities, optimising query execution and database performance
• Scheduled and automated various database-related activities using SQL Server Agent, including backups, monitoring database health, and disk space management
• Utilised Azure Automation and PowerShell Runbooks to perform automated data refresh, tier scaling, and job creation operations on Azure Analysis tabular models. Implemented security protocols to ensure proper roles, permissions, and data protection
• Managed and administered the Power BI Service, including user access, workspaces, data sources, and security configurations. Coordinated the integration of on-premises and cloud data sources for secure, seamless connectivity
• Received commendation for exceptional client support, resulting in a 95% client satisfaction rating as an Azure Analysis Services Specialist. Proficiency in troubleshooting connectivity issues using advanced diagnostic tools, including Fiddler & Wireshark

4. Analysis Services Matrix & Usage Dashboard (Power BI)

• Developed a Power BI dashboard to monitor Azure Analysis Services server performance, including refresh schedules, errors, crash reports, model refresh times, and server upgrades, using Kusto queries for data extraction.
• Integrated data from Azure Log Analytics, reducing manual monitoring efforts by 50% and improving server uptime through proactive issue detection.
• Integrated data from CRM systems and Azure SQL Database, automating monthly updates.
• Built a Power BI solution to track sales KPIs across regions, reducing reporting time by 35% and improving forecasting accuracy.

5. MSBI Support (SSIS, SSAS, PBIRS)

• Acted as Subject Matter Expert (SME), supervising a team of 8 members to deliver technical solutions and support.
• Conducted regular interactions and weekly meetings with Microsoft FTLs to align on project goals and issue resolution.
• Handled support and administration activities for MSBI components including SSRS, SSIS, AAS and SSAS.
• Provided end-to-end technical support for SSRS, Power BI, SQL and SSAS—covering setup, deployment, troubleshooting, performance tuning, and ongoing maintenance.
• Utilized diagnostic tools such as Netmon, Fiddler, Wireshark, Procmon, Profiler Traces, SSAS Diag and Perfmon for issue analysis and performance optimization.