Data Warehousing and Business Intelligence
• Performed Data modelling, Data Profiling on AdventureWorks Database using SQL Server
and ER studio Architect
• Devised Data Warehouse Model for Retail Data using Talend & SSIS to design jobs for integrating data from multiple sources
like SQL scripts, XML files, Excel, Spreadsheets &
implemented Slowly Changing Dimensions (SCDs) to integrate data in Talend
• Built dashboards in Power BI based on Product Sales, Online Sales & reject analysis to help stakeholders derive business strategies
Roles: Business Intelligence developer, Database Developer , Data Engineer
Technologies: ER studio Data Arch, SSIS, Qlik Sense PowerBI, Talend