Database & BI Tools: Microsoft SQL Server 2008/12/14/16/17, RDBMS, SQL Profiler, Data Architect , Database Optimization, SQL Server Data Tools (SSDT), Data Warehousing, Data Modelling, MDX Scripting & MDX Queries, Power Query, Power Pivot/ DAX, T-SQL, DTS, SSIS, SSAS, Data Cleansing, Data Scrubbing & Data Migration, Transact-SQL (DDL/DML) Queries, Index & View creation.
● Integration Packages: SSIS, SQL Server Import Export, Bulk Insert, BCP, Package Migration Wizard.
● Application Development: C#.NET 3.5 and higher, VB.NET, ASP.NET 3.0/4.5 and .NET Framework 3.5/4.5, Visual Studio, Object Orientated Programming (OOPs)
● Data Flow & Documents: ERWIN, Visio 5.0, Confluence, JIRA, Data Models & Data Flow Diagrams DFDs
● Reporting: Power BI, SQL Server Reporting Services SSRS, Tableau, Crystal Reports, SSAS OLAP cubes, dashboards and scorecards
● APIs: Web Services and Web/REST API
● Development Methodologies: Agile, Scrum, Kanban, Waterfall
● Source Control: GIT, Bitbucket, TFS, VSS
● Issue/ Project Tracking Software: JIRA, TFS, Fresh Service