Having over 5 years of work experience in Microsoft SQL Server 2005/2008 R2/2012, T-SQL, Business Intelligence Tools and .NET Environment.
Read More »
Experienced in T-SQL/BI/Data Warehousing applications architecture, design, development and implementations primarily using Microsoft SQL Server 2005/2008 R2/2012 BI Stack.
Experience in multiple domains i.e. on Sales and Health Care.
Aug 1, 2013|Database Development|$0|Completed
Jul 31, 2013|Database Development|$0|Completed
Hands on Experience in writing simple/complex queries, T-Sql, Views and Stored Procedures etc.
Experience in Performance tuning of the Queries.
Experience in SQL Server 2012, 2008 R2 and 2005 SSIS,Used the SSIS for extracting, transforming, and loading data into data warehouse.Created different transformations for loading the data into database/various destinations which includes (lookup, fuzzy lookup, conditional split, derived column, SCD, CDC, Pivot, multi cast, merge join, Data conversion, Script task and many more).
Experience in SQL Server 2012, 2008 R2 & 2005 SSRS, Created Tabular, Matrix, chart reports with and without parameters using SSRS, Implemented various functionalities in the reports such as Drill through, Drill down, Sub report, Actions, Formatting etc.,
Experience in scheduling /Data driven subscriptions and providing Security to the reports and deploying reports/Projects.
Experience in SQL Server 2008 R2 & 2005 SSAS ,Worked on Dimensions, Cubes, DSV, Partitions, Aggregations, Roles and Security, MDX, KPI’s, Calculated Members.
Experience in excel reporting on top of Cube/Database/MS Access Db.
Read More »