Email :- [email protected]
1.Having hands on strong experience in RDBMS Concepts, Database Management Systems, Database design, ETL ,Reporting.
2.Experience in T-SQL DDL, DML creating stored procedures, functions, views.
3.Knowledge of developing packages using SSIS.
4.Experience in SQL Server Reporting Services
5.Experience in Power View (Denali)
6.Experience in SQL Server 2012
7.Experience in Data Warehousing.
Responsibilities include :-
• Design the data model.
• Designed and developed ETL using SSIS to move the data from upstream sources to Datamart.
• Design the stored procedures to make the aggregated data flow from Data Mart to Reporting DataBase.
• Design the tables, developed the stored procedures, functions and views using SQL Server 2012.
• Developing the reports using SSRS.
• Created Design Specifications and database designed document.
• Created the requirement analysis to meet the business requirement.
• Performed Code changes to meet business requirement
• To solve production/pre-production issues