Mogamat Shaheed ساماي

Responsibility:
1) (2001) Support/manage data extraction project to source data from 5 systems; (a) AR - Accounts Receivable MVS - Mainframe, (b) CSS - Customer Services System - MVS Mainframe systems, (c) BC - Billing Components(GSM), (d)IP - Internet Protocol billing, (e) MD - Mediation device - CDR info.

2) Involved in the Data Source Matrix project, mapping the source data onto the EDW database. (Data architecture)

3) Team Leader (Batelco team) for the TNL part of EDW project. Interact closely with the business users to establish the business rules for the TNL process. Wrote and test many of the scripts to do the loading part of TNL

4) Involved in the implementation of the EDW project to production October 2002.

5) Since implementation Support daily ETL interfaces to database. Provide analytical feedback to top management. On Customer behavior analysis, CDR traffic analysis, payment and product marketing analysis.

6) (2004) Team Leader - mapping data between newly installed CRM & TBMS systems and the EDW system.
7) (2007/10)Data Quality Controller - Manage all data quality issue and fixes. Responsible for all ETL current processes and all new project that requires ETL.
Projects such as - (1) 3G, (2)SDP (3)SPPS 4)Cons360

8) Perform the role and functions of the DBA when primary DBA is on vacation or absent from work.

9) Currently supports
EDW - Enterprise Data Warehouse.- Teradata base
DWS - Database for Prepaid subscribers - Ericson
Number Portabiliy System - Oracle database
Biz360 - 360 bussiness view of customers
Microstragegy - reporting system running on top of EDW
Business Object - reporting system running on DWS
Unix support - on EDW & Number Portabilty system

Experience Summary
Total of +/- 32 years of experience in the Information Technology sector. I have fulfilled many roles in IT over the past 32 years, have gone through the complete IT life cycle of coding, testing, implementation, project management, designing, data mapping and architecture. Given my level of experience I have the ability to adapt and learn any new system within reasonable time limits.

Key Positions Held at Batelco over 16 years

Current Position: Information system specialist -
Support/Maintenance Specialist: currently on folowing Systems:
1)EDW - Enterprise Data Warehouse.- Teradata base
2)DWS - Database for Prepaid subscribers - Erricson
3)Number Portabiliy - Oracle database
4)Biz360 - 360 view of customer - sharepoint SqL database
5)Microstragegy - reporting system running on top of EDW
6)Business Object - reporting system running on DWS
7)Unix support - on EDW & Number Portabilty system
Primary function : Data Quality Controller - manage all data quality issue
Secondary Function : Manage all the current loading processes. Also involve in all new project where ETL are needed.
Trouble shoot any production issues
Manage User access and roles
Action User request for reports on EDW & DWS systems

Team Leader:
Batelco ETL(Extraction, Transformation, Loading)
NCR Data warehouse implementation project (3 team members)
Managing SMX(Source matrix) project - data mapping between EDW system and new interfaces CRM & TBMS systems

Support/Maintenance application programmer:
MIS System. Skills Oracle SQL, Unix shell scripting on HP Unix platform.

Project Manager:
Migration of all our system from a K-class Unix machine running on oracle version 7.3 to a V-class Unix machine running on oracle 8.i

Application development programmer :
Batelco’s 1st NCR Autopay machine implementation project.

Business Analyst:
Batelco RAD project. Development of small/medium project. Skills IBM Mainframe Cobol

Application Development programmer - Y2k project.

Key Positions Held in South Africa:(16yrs)
Team Leader:
Old Mutual’s Flexi & Unit Trust - Systems support team. IBM Cobol Mainframe

Analyst programmer:
Unit Trust conversion team - IBM & ICL Mainframes

System Designer & Developer:
City council Account receivable & Dog license Systems

Trainee/Programmer:
Readest Digest - Mailing list systems

Department: MIS (Management information Systems)
Dates: October 1999 - January 2001.
Position: Senior IS Analyst
Machine type: HP/Unix
Software: Oracle Database.
Program Lang: SQL, Plsql, Unix and some Holos
Utilities: Sqlplus, sqlload
Responsibility: 1) Mainly data manipulation, ETL (extraction, transformation & load) of data.Support daily batch run of all interfaces to BBIS (Batelco Business information Systems) namely Service order, Complaints, Faults, Customer Data, KPI's, Billing & forecasting
Wrote complex sql queries for users.
2) Assigned the role of Project manager for the migration of all our system from a K-class Unix machine
running on oracle version 7.3 to a V-class Unix machine running on oracle 8.i
3) Part of EDW NCR Teradata Warehouse project team.

Previous Employment (5): Company: Batelco - Bahrain Telecommunication Company
In the STATE of BAHRAIN (Middle East)
Department: Legacy Systems.
Dates: October 1997 - September 1999.
Position: Senior Analyst programmer
Machine type: IBM 3090-4005
Program Lang: Cobol, CICS, and Oracle
Utilities: JCL, VSAM, SDF, and SQLPLUS
Responsibility: Application development and enhancements in the (RAD)
Rapid Application Development team.
Joinned Production support team for eight months.
Worked on more than 45 small projects and enhancements. Increased business knowledge about Batelco's telecommunication services. Managed projects from analysis phase through to the implementation phase.

Responsibility: Consultant and production support - Unit Trust System.
Consultant on New Unit Trust System to the application
team. Ensure that nightly batch runs completes successful and within the batch window. On lead standby for more than a year. Attended to online production support issues. Analyzing and debugging online abends. A member of the Quality assurance team checking all new programming code moved to production.
In September 1994 I was given the responsibility of team
leader and to manage the Flexi team consisting of 4 persons.

Reason for Leaving: Found employment overseas in the State of Bahrain at Batelco(Bahrain Telecommunication Company).

Program Lang: Cobol, Culprit
Utilities: JCL, IDMS, IDD, DML, OLM
Responsibility: To do maintenance on the old ICL Unit Trust System.
The main duties include.
Maintain and enhance the ICL Unit Trust System which consisted of about 100 programs. The Company implemented a new IBM system to replace the ICL sytem. Develop new skills on IBM to support the system.
Member of the ICL to IBM Data Conversion Team.
Reason for Leaving: To support the new Unit Trust System on IBM.

Company: Cape Town City Council
Date: November 1985 October 1989
Position: Programmer/Analyst; System Designer
Machine type: ICL 2972, 2958, 2966
Program Lang: Cobol, Report Master, Application Master
Utilities: Scl, Tpms, Altadata, Idms
Responsibility: Involved in the development of programs for the Person
System, the Voters Roll System and the Revenue System. Produce program specifications for new programs.
Assist in the design and implement the new Dog License
System. Liaison with the users of the various
systems.
Reason for Leaving: Better career prospects.

Previous Employment (1)

Company: Readers Digest
Date: August 1980 October 1985
Position: Programmer
Machine type: IBM 3070
Program Lang: Cobol /Cics
Utilities: Jcl, Easytrieve, Voice, Cics
Responsibility: The initial six months was spent Under going an in-house
Structured Cobol Programming course. Later I was assigned to the Name and Address Mailing System where I was required to write new programs and maintaining existing ones.

Reason for Leaving: Better career prospects.