Yusuf Mohammad

DWH – ETL/BI Solution Specialist and consultant with over 22 years of experience in the Information Technology, designing and deployment of OLAP (SAP Business Objects, IBM Cognos, Oracle Discoverer, etc.), Analytics (SAP BI Dashboards, Tibco Spotfire, Power BI etc.) and ETL(Data Stage, Informatica, etc.) systems in a client/server architecture and network environment. Comprehensive understanding of Database design and methodology from multiple perspectives. Hands on experience in development including complex SQL development, BI Dashboards and OLAP development, ETL coding, requirements documentation, report creation. Reputation for high-quality work and a commitment to user satisfaction. Significant domain knowledge in the airline business. head the Business Intelligence Unit.

• Advanced DataStage for Enterprise Edition V8 provided by KAC
• Trained on Hyperion Essbase
• Trained on TIBCO Spotfire

1) KAC, Kuwait   Specialist &Projects Leader DBA ,Expert DBA  08/09 – 08/24

Environment : SAP BO 4.1/4.3 Data stage 8.X/11.7 UNIX, Oracle 11G/12C, Windows, Power BI

Roles and Responsibilities:

· Reports - Design/Development/SIT/UAT/Deployment to Production server.

· SAP Dashboards-Design/Development/SIT/UAT/Deployment to Production Environment.

· Universe Development/SIT/ Migration to Production.

· Enhancement of the Universes.

· Automation of BO Reports.

• Writing complex Derived Tables SQL scripts to achieve certain functionality reports and to Create Dashboard report on the Derived Tables to enhance the performance.

· Writing data patching SQL Scripts to cater the user’s needs.

· SAP BO Administration activities.

· Second level SAP BO production support.

· Provide SAP Business Objects training to the users when required.

· Performance tuning of SAP BO Dash Boards / Business Objects Documents.

· Consolidation of Business Objects Documents / Dash Boards.

· Publishing local developed SAP BO Dash Boards to production server.

· Perform admin activities like Creation of New Folder, Users and migration of Universe between environments and also issuing Grants to users and restricting the folder containing the Report in order to establish Data security.

· Data validation and Testing to validate data accuracy after source file loading or in case of Data patching.

· Universe changes to support new requirement, SIT and deployment to Production server.

· Aid ETL team to provide the data or required information based on few business rules set by Business Users.

· Possess in-depth knowledge of the Airways domain

· Adept at troubleshooting and resolving report issues that arise in production.

• Conduct unit testing and participate in integration and system testing as required.
• Built ETL models to enhance business processes and automate data extraction.
• Create, execute, and document unit test plans for ETL and data integration processes and programs.
• Support weekly and monthly DWH production support.
• Provide for the creation, maintenance, development, improvement, and overall performance and function of OLTP Databases, Data warehouse and reporting and analysis environments.
• Solve production issues as needed and do production support on round robin
• 24 X 7 On call production support on rotation basis for supporting ETL jobs
• Designed the mappings between sources and Operational staging targets.
• Used the ETL tools to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Collecting client requirements and implementing them.

2) CREDIT SUISSE BANK, Singapore  ETL Consultant      06/07 - 08/08

Environment  :  Informatica 6.1, Sybase, UNIX, shell scripting, PERL scripting, PL/SQL, C++ and Cron Tab Scheduler.

· To Work with New York, London, and Zurich users to gather the requirements for the Feed Development.

· To work on the Feed Development by using Informatica 6.1 version, Most of Transformations includes Expression, Joiner, Aggregator, lookup, normalizer, sorter, and filter and router transformations.

• To do the necessary testing in development and UAT environment and to promote the mappings to Zurich production environment.

· To work on Data Cleanups basing on the GPM (Global problem Management) Raised. The cleanups should be done by writing the PL/SQL scripts by using Sybase database.

· To work on DQC (Data Quality Issues), this DQC's mostly include the work like amendment of shell scripts, perl scripts and stored procedures.

· To do the knowledge transfer to the Production support team on the new development done and need to help them in resolving the issues.

· To work on C++ loader programs to perform the aggregation on insight data populated by informatica mappings and also need to help the users in resolving the front-end data issues.

• To help the server team in order to schedule the jobs in Cron Tab.

3) HP, Singapore    ETL Developer     11/06 - 04/07

Environment :  Windows2000, Informatica8.1, Oracle 10g, Sqlsever2000.

• Involved in the installation of informatica 8.1 version
• Involved in the requirement gathering from various source systems.
• Prepared Technical and Functional specification documents.
• Developed informatica mappings and loaded the data to SABA.
• Completed SABA certification from SABA University (internal training provided by HP).
• Administering the informatica repository and informatica server.

4) Prudential Service, KL, Malaysia   ETL Developer   11/05 - 09/06

Environment  : UNIX, As/400, DataStage7.5, Business Objects, Oracle9i, DB400

• Assist in the preparation of functional and technical specifications for ETL jobs.
• Evaluate user requirements and recommend solutions. Perform coding and unit testing.
• Conduct system and integration testing and support user acceptance testing.
• Developed different Jobs to extract and load the Data into the Oracle DB.
• Worked with different components of Datastage called Datastage designer, Datastage Manager and Datastage Director and Datastage Administrator.

5) Hewlett-Packard, Singapore   System Analyst   04/05 - 10/05

Environment : Windows 20003, Informatica 6.2, SQLServer 2000, Sqlserver DTS, Business Objects 5.1/6.5.1,Oracle 9I

• Analyzed the requirements from the various countries business users.
• Developed informatica mappings. Migrated DTS packages to Informatica mappings.
• Generation of Web Intelligence and Business Objects reports.
• Designed the workflows and schedule the jobs. Involved in the Universe designing and generated different types of Thick and thin client reports for users.

6) Hewlett-Packard, Singapore   System Analyst    09/04 - 03/05

Environment  : Windows 20000, Sqlserver 2000 DTS, Informatica 6.2, Oracle 9i and Business Objects 5.1

· Migrated oracle stored procedures in to Informatica mappings.

·  Involved in designing and developing of Informatica mappings. Enhanced the universe and Generated BO reports as per user’s requirements.

· Generation of Web Intelligence and Business Objects reports.

7) Telekom Malaysia, KL, Malaysia   OLAP Developer   03/04 - 08/04

Environment  : Windows 2000, Oracle 8i, ONYX-Cognos impromptu 7.1, Power play 7.1, ASP, Datastage 7.1

· Involved in the Installation of Cognos Series 7.2 Version. Designed and prepared the system specification.

·  Involved in the designing of Distributed Catalog and established joins between table and views.

·  Generated Impromptu reports and published them to Upfront News boxes.

· And also generating Power Cubes for multi-dimensional analysis for Telekom Malaysia’s Sales.

· Worked with IWR server to publish the impromptu reports to the upfront News boxes.

· Published the Power Cubes on the Web by using Power play enterprise server.

· Developed different types of data stage server jobs. Worked with different components of Data stage called Data stage Designer/Manager/ Director and Administrator.

8) Motorola – PCS-INFO, India    Programmer     02/02 - 02/04

Environment : Windows2000, Informatica6.1, Business Objects5.1.7, Oracle8i, UNIX, Citrix Client and Server, Toad, Remedy Application.

· Analyzing the Business process, Gathering the Requirements from the client and writing the Detailed Design Documents.

• Creating the New Mappings, Modifying the existing Mappings, and creating the Sessions. Migrating the Mappings and sessions into the Test Instance.

· Code Review and Unit testing. Analyze the production support tickets and resolve the Tickets.

· Provide the production for 24/7 hours and resolve the tickets in time.