DB Admin and development

• Over 17+ years of IT industry experience with Power BI, .NET, Microsoft SQL Server, SSIS/SSRS/SSAS,  Power BI, PostgreSQL in OLTP and OLAP (Data warehousing) environments. 
• Extensive knowledge on Application virtualization and Load Balancing.
• Worked in an Agile team of .NET developers for a fast-paced software development firm.
• Developed and provided maintenance for 20+ .NET websites, using ASP.NET MVC, jQuery, HTML, and CSS
• Advanced expertise in developing web and Client Server Applications and Hosting.
• Good work experience with ADO.NET and Entity Framework.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, DCL commands for various business applications. 
• Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions & features. 
• Experience in Error handling and debugging coding issues and troubleshooting production problems. 
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Functions, CTE’s, Table Variables and Stored Procedures. 
• Experience in SQL Optimization by using SQL server extended events, Index Tuning, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans. 
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data, Bulk Insert and BCP utilities. 
• Expert in automating process by creating jobs and error reporting using Alerts, FTP and SMTP. 
• Designed and develop packages to and data from various data sources into SQL server.
• Excellent analytical/Communication Skills, Team Play and very much result Oriented. 
•  Design and implement new ETL processes and adapt current ETL processes to accommodate.
• Advanced skills in creating Reports, Dashboard and perform Data Visualization using Tableau 8.2
• Proficient emotional intelligence employability skills including Integrity, Adaptability, Strong Work
• Ethic, and the ability to work well in teams.
• Experience in creating complex SSIS packages using appropriate control flow, data flow elements. 

With SSIS Standards like error handling, logging and working with package config files.

• Hands on experience in using different transformations like data conversions, look ups, derived column transformations etc. for data cleansing.