Badges

55 Points
9 Years

User Activity

Over 9 years ago
As you are using Microsoft Services, the best solution would be to utilize the Excel PowerView tool. It has great visualizations, charts and can be integrated with SQL Cubes easily Also go through this post by Richard which has a nice explanation on different Viewers -…

About me

7 years of extensive experience in data warehouse complete life cycle using SQL Server 2005/2008/2012 suite of products SSIS, SSRS, and SSAS.
--Strong experience in SSIS (Integration Services) package design, constructing, and
deployment.
--Strong Experience in creating database objects like Stored Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
--Experienced in writing Stored Procedure/TSQL coding, Performance Tuning, Physical and logical Database Design and Database Partitioning.
--Extensively used tools like SQL Profiler, Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
--Performed Successful migration from SQL server 2000 to SQL server 2005, SQL Server 2005 to SQL server 2008.Migration of DTS packages to SSIS
--Excellent communication, analytical, personal skills and ability to learn new concepts.
--Ability to handle multiple tasks, initiative and adaptable. Proactive team player with capability of
handling responsibilities independently as well.
--Knowledge in developing Data warehouse, Data marts, Database Setup and BI Packages
--Knowlwdge of BASE SAS programming Language,SAS DI Studio, SAS Enterprise guide, SAS/ACCESS, SAS/SQL, SAS Macros
-- Also have experience working in Product Based Firms, Involved in End to End Product Development using Agile Methodology

Qlikview 11.20:-
-- Trained on Designer and Developer Course by Qlik team
-- Design and development of dashboards, KPIs, Trends, What if Analysis, Charts, Comparative Analysis etc in Qlikview
-- Writing SQLScripts to load data in Qlikview from Different sources like Excel, Flat file, databases, SQL server, Oracle, MS Access etc
-- Creating Mapping Tables, Link tables, Master Calendars, Input Fields, Inline Tables, Local and Global variables, Joins, concatenation,
-- Dealing with Synthetic keys, circular references, Preceding Loads, Interval Match, Class