Data Migration Leader
Advanced Electronics Company
Total years of experience :12 years, 4 Months
Client: Human Resources Development Fund (HRDF)
Link: https://www.taqat.sa/
Project: National Labor Gateway (TAQAT)
Role: Data Migration Leader
Environment: SQL Server, Oracle and Informatica
National Labor Gateway (TAQAT) is a major national initiative to build the largest virtual labor market platform in KSA. Its mission is to offer and facilitate employment and training services for job seeker.
Our mission in this project is migrating legacy data such as: Hafiz, Qarar5 and Taqat to National labor Gateway.
Responsibilities:
o Analyze requirements from business partners on development/enhancement.
o Estimate effort required for development or enhancement applications.
o Develop and incorporate ETL best practices and standards.
o Ensure overall quality of all the deliverables.
Prepare implementation plans when moving a code to production.
o Adhere to schedules and deadlines.
Client: Human Resources Development Fund (HRDF)
Link: https://www.taqat.sa/
Project: National Labor Gateway (TAQAT)
Role: ETL Developer
Environment: SQL Server, Oracle and Informatica
Responsibilities:
o Perform data profiling on legacy data to insure its quality.
o Perform required analysis to build the extraction logic.
o Develop technical designs and build Informatica workflows, session and mappings.
o Lunch ETL jobs to extract and load data.
o Write SQL overrides in source Qualifier according to business requirements.
o Configure and run the Debugger from the Mapping Designer to troubleshoot predefined mapping.
o Perform required data cleaning.
o Creating the test cases.
o Validate the Data Model and making necessary changes.
o Analyze Session’s log file to debug the production Issues and provide suggestion.
Client: Saudi Electricity Company (SEC)
Environment: SQL Server, ASP.NET and Crystal Reports
AMR is an advanced automated system that enables remote monitoring of electricity meters.
It provides the following:
Monitoring & Control
Reporting & Analysis
Setup & Configuration
Network Administration
Network Diagram
Executive Dashboard
Responsibilities:
o Design and develop electricity consumption reports using Crystal Reports 12.
o Create Crystal Reports using Crystal Reports formulas, Grouping, Parameters, Selection criteria to handle the customer's requests from Tables, Stored Procedures and Views.
o Work with SQL Server 2008 and create complex stored procedures and views according to report’s requirement.
o Optimize stored procedures to enhance reports’ performance.
o Deal with reports that contain several Static and Dynamic parameters.
o Export reports into various formats such as Excel, PDF and CSV formats.
o Work on existing reports to optimize and troubleshoot problems that occurred due to new business requirements.
o Diagnose and tune the server performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
o Optimize the database by creating various clustered, non-clustered indexes and indexed views.
o Taking full Database and Transaction log backup.
Seven months of training in Information and Learning Technology Center at The Institute of Banking (IOB), Saudi Arabian Monetary Agency (SAMA). At this period I developed two projects, which are:
• Conference Hosting Management System.
• English Language Studies Unit System.