ETL Developer
Saudi Commission For Health Specialties
Total years of experience :10 years, 8 Months
an ETL Developer for the SCFHS Data driven organization project involved in all the phases of the project from scratch and end to end and performed different roles in the different phases of the project.
•Detailed study and data profiling of all the underlying application systems and understood the data models. Identified and captured the right metadata from source systems.
•Developed the ETL pipeline proto-type using SSIS for single subject area over development environment to the business users for a proof of concept.
•Created ETL architecture 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 .
•Used ETL(SSIS) to develop jobs for extracting, cleaning, transforming and loading data into target tables.
•Worked Extensively on complete data mapping of the existing source systems as a part of data analysis.
•Extensively Used SSIS transformations such as multicast, Row count, script component, data conversion, lookup transformations, Data flow tasks using SQL .
•Experience with error handling, rejection records handling & re running the failed packages using checkpoints .
•Worked with Application developers team and provide necessary SQL scripts.
•Interface with Business analytics, developers and technical support to determine the best requirements specifications.
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 onreal time basis.
•SSAS is used to design/create SSAS Tabular Models to facilitate NWC Self Service BI initiatives .
•Ensured data quality & integrity throughout the reports development life cycle .i.e. Report design to UAT .
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.
•Monitoring and Performance Tuning of SQL Scripts (SQL, Oracle).
•Empowered business Users by introducing self-service BI & data literacy initiatives.
•Trained & managed ETL & reporting teams.