In my previous role, I extracted data from client databases and loaded it onto the server using ETL tools. I visualized data using Tableau for tracking progress, generating reports, and creating dashboards, and utilized Intellicus for reporting purposes. I standardized DBLINK in Volumetric ETL, scheduled and monitored reports, and conducted Data QA. I am proficient in using Joins (Inner and Outer) and all types of Joins. Moreover, I developed visuals using parameters, groups, joins, interactions, and hierarchies.
Additionally, I have knowledge of SSAS and SSIS, as well as skills in schemas, keys, and indexes. Additionally, I am proficient in Views and Materialized views, and have knowledge of Triggers, Stored Procedures, and Functions.