Trainer ID : XELAH

​

SQL Developer

• Expertise in T-SQL Query Writing.

• In-Depth knowledge of creating procedures, Triggers, Functions and Views.

• Expertise in writing queries using Sub-queries, Joins, CTE and temporary tables.

 

SQL Server Integration Services

• In depth Knowledge of Data warehouse.

• Initial loads and incremental loads.

• ETL Process (Change data capture and date time columns).

• Data quality services and master data services.

 

SQL Server Analysis Services

• Expertise in Data Modeling Multi-dimensional or Tabular

• Creating Cubes, KPI, Partitioning and Hierarchy.

 

Power BI

• Creating complex reports with visualization.

• Creating parameterized reports.

• Reports with Graphs and Maps.

• Reports automation, Drill through & Drill down.

​

Azure Cloud Data Platform

• Implementing Azure Cloud solutions.

• Creating and maintaining Azure SQL Databases

• Implementing HA on cloud

• Database migration from on premises to azure.

• Cloud Data-Science and Machine Learning

• Knowledge on Azure machine learning studio.

• Knowledge of different Algorithms Classification and regression.

• Initializing and optimizing Machine Learning Models.

 

Python

• Knowledge of python scripting.

• Knowledge of implementing machine learning models using libraries.

• Knowledge of creating python bases image processing, face recognition, natural language processing, self-learning Chabot.

 

IIS

• Creating & Publishing Website

• Integrating Django based applications

• Network Binding & Handler Mapping

• Configuring Fastcgi/Wfatscgi

 

Data Understanding

• Infrastructure & Mobility Data

• Health, Population & education

• Demographic & Macroeconomic

• IOT, CDN, Product & Market Analysis

​

​

Certifications

​

• Microsoft Certified Trainer (MCT)

• Microsoft Certified Solutions Associate (MCSA)

• Microsoft Certified Solutions Expert (Data Platform)

• Microsoft Certified Professional (MCP)

• Microsoft certified solutions expert (Data management and analytics)

• Information Protection Fundamentals

• Risk & Data Management

• Data Privacy (Client-facing)

• Emerging Technology

• Technology’s Impact on Business Landscape

• Acting with Integrity

​

​

​