Zamin Abbas

As an ETL consultant for the SCFHS Data driven organization project involved in all the phases of the project from scratch and performed different roles in the different phases of the project. Created ETL architecture using SSIS as a part of development plan to extract and load data from source system to landing area , EDW Layer ,Presentation layer and to the Mart layer .

As a BI Consultant , Working in diverse roles ranging from ETL Consultant,Enterprise report developer to Metadata Management consultant .Involved in end to end implementation of Enterprise data warehouse life cycle supporting clients to enable data driven culture .

Design & developed logical & physical data model for Semantic/Reporting layer over the Data warehouse using MS BI stack(MSSQL,SSRS,Power BI).SSRS is used to generate ad-hoc reports/Subreports/Drill Down/Drill Through reports for NWC decision making .Power BI is used to generate operational & executive dashboards for SMT’s & operations team to monitor internal & organizational Key performance indicators on daily/weekly/monthly on real time basis.

-Designed, Implemented & supported In-House EDWH for Wateen telecom. -Implemented a reporting solution using the IBM Cognos Business Intelligence Suite & Power BI . -Developed the ETL to move data from the in-house custom-grown application to the reporting suite using windows batch scripting. -Identified strategic enhancements & automation opportunities, including integrating heterogeneous data across organization. -Test & Validate ETL & Decision support system(DSS) data & reports.

-Designed and implemented semantic/reporting layers for diverse clients in offshore mode using latest Microsoft technologies like Power View, Performance Point and Data tools from MS BI Stack 2012. -Designed Enterprise reports using SSRS , generated drill down reports, parameterized reports ,sub reports & linked reports ,filters, row level security. -Used SSIS and T-SQL stored procedures to transfer data from OLAP and OLTP databases to staging area and finally transfer into data marts.

Business intelligence , Data Warehouse , Data mining