Power BIQlik SenseQlik ViewMS SQL ServerSSISSSRSOracleETLDatabaseVBAMacros
Summary
11 years of experience in design, development, Testing and Implementation of BI applications using multiple technologies such as Power BI, Qlik Sense, Qlikview,MSBI (MicrosoftBusiness Intelligence), SSIS, SSRS, SSAS, SAP BO (WEBI), SQL Server, Oracle etc.
Experience in creating robust data models with transformation of data using Power Query and building dashboards in Power BI Desktop using DAX language and charts/visuals available.
Good understanding of Qlik Script coding, functions, with creating robust data model to be used in visualization and creating interactive reports and dashboards in Qlik sense with the help of different KPIs, charts, tables etc.
Understanding of BI concepts, ETL/DWH concepts, data modeling, dimensional & relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
Experience in developing ETL solutions using SSIS packages.
Experience in creating Parameterized reports, Drill down, Drill through, Sub Reports, Matrix Reports and Linked reports using SSRS (SQL Server Reporting Services)
Expertise in SQL Server/Oracle development and good hands on creating Indexes, Views, complex Stored Procedures, user defined functions, cursors, and Triggers to facilitate efficient data manipulation and data consistency.
Experience in Advance MS Excel, MS Access, VBA, VB 6.0, Macros and Automation of Reports.
Worked in Agile methodology environments and involved in scrum meetings.
Involved in Onsite-Offsite coordination in delivering BI Solutions.
Ability to handle complex problems with strong troubleshooting and problem-solving skills.