Abel A Email & Phone Number

Summary•A Microsoft SQL Database and BI developer with 5+ years experience: designing, coding, testing and supporting next-generation database solutions in SQL Server environment.•Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split.•Experience in Installing, configuring, administration and Maintenance of mission critical client databases in SQL server 2008R2, 2012, 2014 and 2016, 2017 versions.•Extensive Experience in Upgrading SQL Server (In place Upgrade and Side by side Upgrade) based on application compatibility and fixing the orphan users.•Experience in implementing SQL Server security and Object permissions like creation of users, granting permissions, and assigning roles to users, auditing SQL logins and applying encryption.•Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using ticketing tool.• Experience in utilizing tools and systems on the MS SQL server BI stack including SSRS, SSIS, SSAS, T-SQL, Power Pivot, Power Query, MDX and DAX.•Created jobs, alerts to run SSIS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQL Server Agent job•Experience on configuring and maintaining full backup, Transactional log backup, Differential backup and creating the maintenance plans for index rebuild, index reorganize based on fragmentation.•Experience in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS)•Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.•Created reports, sub reports, charts, Tablix, Matrix, using SSRS. •Excellent knowledge of performance tuning stored procedures, Queries using tools like SQL Profiler, Database Tuning Advisor, Execution Plans, DMV's and Efficient coding standards.- designing, building, and deploying reports and dashboards using Microsoft Power BI.- To use filters and graphs for a better understanding of the data. - To define and design new systems by analyzing current ETL processes. - To make technical changes to existing BI systems in order to enhance their working.