Responsibilities:
• Installation and configuration of SQL Server 2008R2/2016
• Implementation and delivery of BI platform solutions in developing and deploying ETL Packages, Analysis Services and Reports using SQL Server 2008R2/2016 (SSIS, SSAS, SSRS, SSMS).
• Maintained user/groups access and security permissions in accordance to policies and procedures.
• Developed Transact-SQL (T-SQL) Queries, Stored Procedures, Triggers, User Defined Functions (UDF), Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default.
• Involved in Migration of Databases from SQL Server 2008R2 to SQL Server 2016 using SSIS.
• Used Fuzzy Lookup transformation to perform data cleaning tasks such as standardizing data, correcting data, and providing missing values.
• Created various types of reports including matrix, sub reports, list, chart and linked reports in various formats (PDF, XML, HTML, and CSV).
• Created filters, prompts, and business calculations in Report Model of SSRS. This enabled end users in increasing the speed of Ad-hoc report generation.
• Used SQL Server Analysis Services 2008R2/2016 (SSAS) to create OLAP Cubes and defined data source, data source views, dimensions, measures, user defined hierarchies, calculated measures, KPIs and roles. ENVIRONMENT: SQL Server 2008R2/2016, MS-Access 2003/2007, MS-Excel 2003/2007, MS-Visio, Windows 2000, Windows XP, Windows Vista, Windows 2003 Server.