Over 9+ years of experience in analysis, design, development, testing, performance optimization and documentation using in MS SQL Server suite of products like SSIS, SSAS and SSRS of MS SQL Server 2012/2014/2016/2017, Power BI ASP.net MVC, JavaScript, and Tableau for Data Analytics, Talend.
• Worked with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Experience as ETL Team lead and lead of the code review team for ETL.
• Experience with multiple Hadoop distributions like Apache, Cloudera.
Extensive experience in data warehousing tools including Tableau,SSIS, SSRS, SSAS using different databases.
• Experience in developing applications using ASP.NET MVC, ASP.NET Web Forms, WebAPI, [login to view URL], Entity Framework, JavaScript, J-Query, AngularJS, LINQ and Windows Communication Foundation (WCF).
• Effectively manage the business cycle process from client consultation to closing including identifying requirements, developing focus, presenting demos and providing tactical IT solutions.
• Experience in full BI implementation cycle in Client’s organization from installation and configuration of BI Tools, freezing client’s requirement, designing ETL, cubes & data models, developing reports/dashboards as per client requirement.
• Expertise in Business Intelligence Tools – Talend, Tableau ,Cognos , Microstrategy, MSBI (SSIS, SSAS, SSRS), BIRST Cloud BI, Qlikview , Tableau
• Expertise in ETL Tool like SSIS and developed OLAP cubes using SSAS & Cognos Transformer.
• Designed data structures, procedures and functions in SQL Server for ETL and reporting layer.