· Around 6+ years of experience using Microsoft Technology SQL Server 2008R2, 2012, SSIS and SSRS,Tableau,Power BI
· Proficient in BI solutions using T-SQL, SSRS, SSAS (Tabular Model), SSIS with C#.
· Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, developing, maintenance and Deployment.
· Extract, manipulate and manage high-volume data to establish Key Performance Indicators to monitor database assets and the performance of internal operations, providing analysis and strategic insights to drive growth and performance using Microsoft environment.
· Experience in working with business analysts to identify study and understand requirements and translated them into code in Requirement Analysis phase.
· Responsible for taking end-to-end ownership of the system for all the technical aspects, delivery standards, implementing best practices and taking delivery standards in adherence to the roadmap set.
· Experience in designing and delivering Data Warehouse projects including Data capturing, Data staging, Data Transformation creating Source to Target definitions for ETL / data flow process.
· Worked with one of the largest data warehouses to deliver optimized data extracts, data visualizations, and detailed reports to support consulting engagements, CRM Analytics and business intelligence.
· Design, develop and implement database objects such as stored procedures, functions, triggers, tables, views etc., that meet business requirements