- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
- Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
- Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
- Extract, Transform and Load source data into respective target tables to build the required data marts.
- Created ETL process using SSIS to transfer data from heterogeneous data sources.
- Designed SSAS cube with Star Schema to hold summary data for Target dashboards.
- Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
- Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
- Responsible for gathering business requirements to create business user reports.
- Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
- Generated Reports using Global Variables, Expressions and Functions for the reports.
- Responsible for scheduling the subscription reports with the subscription report wizard.
- Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
- Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
- Hands-on experience of setting up schedules for push and pull delivery methods using Standard and Data Driven subscriptions in SSRS
Environment: Microsoft SQL Server 2008 Enterprise Edition, MS Access, ETL Packages (SSRS, SSIS), PL/SQL, VB.Net, ASP.NET, HTML, Visual Studio 2008 & 2005, SSIS, T-SQL, Oracle, TFS.