Data Engineer | WinIT Solutions

May 2021 - Present

✔️ SQL Server Reporting Services SSRS. 

✔️ SQL Server Integration Services SSIS. 

✔️ Deliver knowledge sharing on Teradata DWH, SQL Assistant, Fastload, FastExport, MultiLoad, TPT, BTEQ, Teradata Studio & other utilities. 

✔️ DWH Soft Architecture completing all 4 layers namely Staging, Transformation (EL/TL), Foundation & Semantic (Dashboards & Reporting). 

🛠️ Power BI, M Language, DAX, Tabular Editor, DAX Studio, Power Automate, API Connections, SQL (DML), Dataverse, Sharepoint, Excel, PowerPoint, Word, Lists, Forms, Teams, Slack, Jira Asana, Planner, Trello, Notion, OneNote, Etc.

Database Developer | WinIT Solutions

March 2021 - May 2021

✔️ Writing Optimize queries and create stored procedures, User Defined Functions, and Views to validate business logic. • Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique, etc.). • Writing Complex T-SQL Queries, Sub queries, Co-related sub queries, and Dynamic SQL queries. 

✔️ Query Optimization, Explain Plan, Indexes partitions, Statistics, Viewpoint, do read and practice in details under query optimization Also, how to create a db., table, view, stored procedure, how to give rights to a user/db.