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.