• 11+ years of extensive work experience as a Microsoft Expert and in depth proficient experience in OLTP, Dimension Modeling, Data warehouse, OLAP and ANALYTICAL TOOLS Technologies. • Over 9+ years of experience in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS. • 2+ years of experience in BI tools like TALEND, Tableau & POWER BI. • MAPR Certified HADOOP Developer and exposure on CASSANDRA, HIVE, SQOOP and YARN Architecture. • Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and Dimensional Modeling for OLAP. • Experience in TALEND & SSIS (ETL), SSRS (Reporting), Dashboards TABLEAU & POWER BI. • Created and Configured Data Source & Data Source Views, Cubes, Dimensions, Measures, Partitions, KPI’s, Perspectives & MDX Queries using MS SQL Server 2005/2008/2012 Analysis Services. • Extensive experience in ETL design/development using SSIS/TALEND jobs & Packages with proven ability in utilizing ETL tools and successfully delivered hundreds of packages. • Using Various Data Flow tasks, Logging Features, Package Configurations, Use of Checkpoints and Package Deployment. • Using various techniques in TALEND like Components, Logging, Metadata reusability, Contexts environments & Job Configurations/Scheduling on TAC. • Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes. • Extensive experience in developing Stored Procedures, Views, Triggers and Complex Queries on SQL Server 2005/2008/2012 • Proven experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance. • Broad experience in Query Optimization and performance tuning of stored procedures, functions etc. • Evaluated database performance and performed maintenance duties such as Tun