• 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
Reviews For This Service