Provide a quick, creative biography in 140 characters or less.
More bioAlpesh Patel, who is having 8+ Years of relevant experience in MSBI and 12+ Years of Experience on Microsoft Technologies.
Following is the brief technical competencies:
o Technical Competency
• Designing & Developing Business Intelligence Solutions
• Designing & Developing Reporting Solutions
• Large Scale Data Migration
• Designing SQL Server Database
• Performance Tuning and Optimizing SQL Server Database & Query Performance
• Designing & Developing Relational Database Solutions
o Technologies
• Microsoft SQL Server Database Engine (2005/2008/2012/2014)
• Microsoft Business Intelligence Tools (SSIS, SSRS, SSAS, BIML) (2008 R2/2012/2014), Mist 4.0
• T-SQL and PL/SQL
• Reporting Tools (Crystal Report, Tableau, SSRS, Power BI)
• Microsoft .Net Technologies (C#.Net, VB.Net, ASP.Net)
• OLAP & MDX
• Microsoft Azure (Blob, SQL Server, Data warehouse)
o Specialties
• Architecturing and Developing OLTP & OLAP Database Solutions
• SQL Server, Database and Query Performance Tuning
• SQL / T-SQL / PL-SQL Querying and SQL Database Objects Development
• Designing & Developing Data Warehouse & ETL Solutions
• Analysis Services Cube Performance Tuning
• Data Migration / ETL Operations with SSIS
• Generate SSIS packages using Mist, BIML, Biml Script and Metamodel
• Report Development with SSRS, Power BI and Tableau on OLTP Databases and OLAP Cubes
• Defining and Implementing Database Maintenance Plan
• Managing SQL Server Databases
• Mentoring & Managing Team Members
• Delivering high quality solution on schedule
• Experience of SDLC using WaterFall and Agile