Ability to handlemultiple tasks,InitiativeandAdaptable.Self-motivated, organized team player wif strong problem solving and analytical skills and total commitment to teh organization goals.
Creating teh SQL Agents and running teh jobs directly and through Tidal. Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes. Deployment of SSIS Packages and Database components using GIT’s (Pipeline), SVN, TeamCity and Octopus. Experience in different type of reports including Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items, Charts and Sub Reports. Proficient in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency. Experience in designing teh logical data model and physical data model. Experience in creating new reports and ad-hoc reporting in SQL Server Reporting Services (SSRS). Strong T-SQL Query optimization and tuning skills, and experience wif SSIS, SSRS and SSAS. Expertise in generating reports using SQL Server Reporting Services (SSRS), and Microsoft Access & Excel spreadsheet. Experience in providing Logging, Error handling using Event Handler, and Performance Tuning in SSIS packages by using Row, Block and Unblock Transformations. Expertise in Extraction, Transforming and Loading (ETL) data using BI/SSIS creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities (Data Warehouse, Data mart). Strong experience in creating T-SQL objects, working wif DDL/DML, Performs most of teh SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches. Proficient Knowledge in dealing wif Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors. Extensive SQL Development experience in Banking and Healthcare environments wif a strong understanding of data and analytics. 
Expertise in MS SQL Server wif Business Intelligence using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) wif good knowledge on SQL Server Analysis Services (SSAS). Over 8 years of IT experience as MS - SQL Server/BI Developer, involved in Design, Development and Support of MS SQL Server 2016//2012/2008 R2.
0 kommentar(er)
