Alpesh Patel
Solution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
  • Ahmedabad Area, India,
  • India
Member Since: 2010/11/10
Industry: Computer & IT
Top Skills:
Tech Certifications:
View All
CERTIFIED EXPERT

Provide a quick, creative biography in 140 characters or less.

More bio
Activity
Points this month205
Total points973,696
Questions: 8
Solutions: 685
Articles: 19
Videos:
Tutorials:
Posts:
Live: 1
Professional Background
Associate Consultant
Tata Consultancy Services
April 2015 – Present
Technical Architect.
Team Management
Develop MSBI solutions using SSIS, SSRS, SSAS
Generate SSIS packages using Mist, BIML, BimlScript and Meta-model
More
Education
Sikkim Manipal University
Master of Business Administration (MBA)
Project Management
2011 – 2013
V.V.P. Engg College of Engineering, Rajkot
Bachelor of Engineering (BE)
Information Technology
2003 – 2006
Government Polytechnic Gandhinagar
Diploma
Information Technology
2000 – 2003
Shree Vidhyanagar High School, Ahmedabad
HSC
Science
1999 – 2000
I N Patel Swaminarayan Vidhayalaya, Ahmedabad
SSC
General
1997 – 1998
More
Full Biography

Alpesh 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

More
Languages
English
Elementary Proficiency
Hindi
Elementary Proficiency
Gujarati
Elementary Proficiency

Level Progress

Current: Level 22
Alpesh needs 84,304 points to level up.
LVL 23
  • Overall
    22
  • Microsoft SQL Server
    15
  • Microsoft SQL Server 2008
    13
  • SSRS
    11
  • Microsoft SQL Server 2005
    10
  • SSIS
    7
  • .NET Programming
    4
  • ASP.NET
    4
  • SQL
    4
  • C#
    3
  • Microsoft Development
    3
  • MySQL Server
    2
  • Visual Basic.NET
    2
  • Windows Server 2008
    2
  • DB Reporting Tools
    2
  • Databases
    2
  • Microsoft Excel
    2
  • Web Languages and Standards
    1
  • Microsoft SharePoint
    1
  • Enterprise Software
    1
  • Microsoft Server OS
    1
  • Windows Server 2003
    1
  • Oracle Database
    1
  • Microsoft Applications
    1
  • Microsoft Access
    1
  • Programming
    1
  • Microsoft Dynamics
    1
  • SSAS
    1
  • Storage Software
    1
  • Web Development
    1
  • Active Directory
    1
  • Windows 7
    1
  • Visual Basic Classic
    1
  • Microsoft Legacy OS
    1
  • Microsoft IIS Web Server
    1
  • WCF
    1
  • JavaScript
    1
  • E-Commerce
    1
  • FoxPro
    1
  • VB Script
    1
  • Visual C++.NET
    1
  • Web Applications
    1
  • Web Browsers
    1
  • Windows Server 2012
    1