Vila  # 9 St # 16 Albarsha Dubai United Arab Emirates      Mobile  +971 50 9548229

E-mailsyedhaider79@yahoo.com

Syed Haider Ali
Qualifications

      "      MS in Management Engineering from University of Engineering (TAXILA)
"      Masters in Computer Sciences from BAHRIA University 2002.
"      Diploma in computer applications from STICS Islamabad (2000).
Certifications
      Certification Achievement:
"      Oracle Certified Professional (Database Administrator).
Trainings

"      Project management certification (PMP)
"      Oracle 9i Real Application Cluster
"      Oracle Certified Professional (Developer Track 6i)
"      Microsoft Certified SQL Server DBA.
"      Oracle Warehouse Design.
"      IBM DB2 UDB 8.1 DBA with HADR.
"      Mistakes Manager Makes (Management Training).
"      Software Project management/ Telecom business management
"      Problem solving and decision making.
Professional Experience      Nokia Siemens Network (NSN)  United Arab Emirates and .  www.nokia.com
(Feb  2007 till date)
I am working with Nokia Dubai on DU centralized backup project. My Role is to work as a Solution Architect of Backup project and a consultant Database Administrator for DU Databases. Backup solution engages implementation of EMC Networker/Legato base centralized backup solution on DU Broad Bands OSS VAS and IN systems using Clarion ADIC i2000. A replica Environment of this solution is also implemented as Test Bed using Clarion ADIC i500. Database backup policy is implemented using RMAN on single instance and cluster based oracle 10g, 9i and 8i, Informix, IBM DB2 8, MS SQL Server 2000 and MYSQL databases. My Role also includes responsibilities of consultant DBA for DU Engineering Databases (OS, VAS and Core Network databases). This Backup policy supports all OSS /VAS database (Oracle, Informix, My SQL) incremental hot backup using RMAN, logical backups using exports or extracts, and file system level backup using Ignite for HP Unix, BMR for Solaris, MS Windows and Linux File system.


UFone GSM. www.ufone.com  Pakistan
(Jul 2005 till 16 Feb 2007)
Worked With UFone GSM (Top GSM Telecom Company in Pakistan) as Sr. IT Executive (Databases/SYSADMIN). My Job Responsibilities include database/system Management, Vendor interaction for technology evaluation and Administration of more then 25 Production Database (OLTP and DW), Interacting with SAN and Unix Team for OS performance, monitoring, configuration issues and Supporting Data warehouse team in their data modeling, queries tuning and other DBA/DW Design Related Issues. Handling Latest technologies like RAC, Data Guard, and Replication on Multi platform and heterogeneous vendor environment. Also Supporting management in IT business related matters, product evaluation and business cases development and presenting them in management meeting and preparation of IT policy and budget, preparing SOP and initiating PR and RFPs etc.

LMK Resources Pvt. Ltd. www.lmkr.com 
(Sep 2004 till Aug 2005)
Worked in LMKR (Landmark Resources) as Database Team lead for Halliburton Projects.

Job Description
Includes Database Administration, Backup, Tuning activities and coordinating in design, Data Modeling and Analysis activates. Worked on Heterogeneous Operating System Platform (Linux SOLARIS and Windows). Interfacing, and communication of Databases with systems of different natures ranging from scientific to general information systems using C/C++, VC++, .Net and Java. Also participating in Technical Interviews with HR, CMMI achievement efforts of company along with project and department management issues resolving including peer review, technical review, progress/status meeting and project post mortem meetings.

DANCOM Pakistan (Pvt.) Ltd. www.dancom.com.pk 
(Aug 2002 Sep 2004)
Worked in DANCOM PVT. LTD. as Assistant Manager IT/Telecom and Head of Software Development and DBA Department.

Job Description
My Job Responsibilities as Department Head were to Manage Projects/Team of DBAs and Developers along with Operational System/database Administration, Software Analysis, and Design Activities. I have Participated as Manager and resource in Operational Database Administration, Tuning, and development of SOP for Database Administration of Real Time Telco systems like calling card and Internet Services and Software development project Like Billing system of Calling Card and ISP along with different Data marts/warehouses of calling Card data (CDR). Also worked with DBA of Software Operations Department in there daily DBA activities and defining Database Tuning/BACKUP/Administration SOPs.
Data Modeling, Designing and design approvals and Quality Testing. Coordinating with Sr. Manager IT on behalf of Team Lead of Software Development and Operations. Coordinating in CDR (Call Record) Data Extraction from production system, Quality testing and manipulation process and providing them to PTCL (Pakistan Telecommunication) twice a month. Participating in ETL process of CDR from production system and loading into different warehouses. Data Modeling and Data Designing of for Warehouse and OLTP System.

Handling ISP (Internet Service) Database and Radius and DSL Database as Designer and Administrator. Administration of Customer Support Database Distributed Environment as DBA. Administrating Databases of Already developed system and Training resources as Junior DBA and Developers. Analyzing and Defining Standard Rules for system being developed. Administrating, Tuning and Defining Backup and Recover for DBMS and Software systems.

Oracle University (Islamabad) www.techno-ed.com 
(Feb 2004 till Date)
I am serving in Oracle University Pakistan as visiting faculty member since February 2003 (Training oracle 9i DBA and Advance courses).

NCR Pakistan (Islamabad) www.ncr-edu.com 
(June 2002 till Jul 2002)
I have been a part of NCR education and arranged training sessions in corporate sector with NCR.

NICON (Pvt.) Ltd. http://www.nicon-world.com 
(Mar 2000 till Dec 2001)
I have been responsible for Database Administration, Backup and Recovery, tuning of 14 databases in NICON Group of IT companies. Like Student Information System, Accounts system etc. I have been a part of and Faculty of NICON Group of IT companies. Also maintained Windows NT4.0 based Network for NICON.
Professional Training      "      CMMI L3 training (Process, Project management, QA Team Management)
"      5 days training of GEO Tools and integration with DB in LMKR.
"      Introduction of SAP Basis and Oracle Financial and their Installation and configuration.
DBA Tasks      "      Implemented and configured 10G RAC on Solaris 5.9 using ASM on production for provisioning, CRM and IVR database, implemented ORACLE 9i RAC on Windows, LINUX using OCFS (SAN XP 1024) for Ufone GSM.
"      Participating in planning, organizing, monitoring and control of all activities pertaining to the production and QA databases, including configuration, security, efficiency, documentation, resource planning, backup/recovery, and usage guidelines.
"      Working with Oracle Application Server 10g Administration
"      Managing with High Availability Issues using Oracle Data Guard, Replication and RAC.
"      Installation and configuration of ORACLE 11i in LMKR.
"      Installation of SAP/R3 in LMKR.
"      Managed Backup Oracle servers using RMAN for accounting and ERP other Servers for DANCOM and UFONE Pakistan also configured RMAN with Storage Area Network utility HP Data protector for production databases.
"      Interacting with network team to calculate data and system performance using different SNMP monitoring tools also MRTG graphs etc.
"      Impetration of customized replication for IVR database using oracle 9i etc.
"      Implementation of OID for single sing on using oracle dbsnmp and LDAP protocol etc.
"      Configuration and designing of ORACLE Management server for 24/7 monitoring and reports collections etc.
"      Administrating and Managing Solaris, Linux and windows based Warehouse and OLTP. Like Ufone Billing System, ISP/DSL, Inventory System, data warehouse etc.
"      Tuning Queries and system setting based on requirements and for future growth plan.
"      Storage and performance forecasting, design modification as data designer.
"      Analyzing new Methods of ETL and OLAP for existing system and implementation of them on Operational systems and warehouse of DANCOM.
"      Secure Network design and configuration for Oracle servers (ISP, DSL, Calling card projects in DANCOM and in PPR project of LMKR etc.).
"      Assigning Duties to Software Operation DBA, Verifying there codes and methods of DB Administration (DANCOM).
"      Installation, configuration and Tuning of IBM DB2 UDB v8.x on Linux and backup and export utility related work (Project: Automation of Ministry of IT).
"      Configuration of shared servers and Server side tuning management (PPR a Halliburton Project).
"      Configuration of management server for the automation of backup servers in DANCOM.
"      Managing over 25 databases (24*7 on-calls) in highly complicated and time constraint environment.
"      Design and Tuning Issues solving with DW, IVR and Customer Support Database Development Team.
"      Development and updating of product manuals and project documentation
"      Development and implementation of physical database design
"      Oracle RDBMS installation, configuration and effective administration on database and O/S ends
"      Writing SQL and PL/SQL Code and building Online DBA Software for Daily DBA Activities.
"      Conduct Backups & prepare and develop recovery plans (Hot Backups and RMAN)
"      Create test servers to provide test environment for application developers
Distinctions      Employee of Month award by LMKR based on Technical knowledge, development experience, will to deliver the best and client appreciation
Few Projects      Customized Management Server Database management system: System developed to monitor databases, OS and listener; performance and stores object details like analyze time, max extents and space limits, resource utilization in terms of IO, CPU and memory. It is also used for sending daily, weekly and monthly reports to DBA, collect statistics objects details, database loads and store information. It is also involved in capturing unauthorized access and sending different alerts.
Customized IVR System: System is developed to with two  schemas one was using real time replication and other schema was using merge based script to capture change data, transport bulk data to remote sites and purge data from master site.
PPR (People Performance Result HRMS) Hybrid System: PPR (People Performance Results) is a web based HR application used by Halliburton employees. My role was of an Application DBA/Data Modeler and was involved in data base design, SQL Tuning, Data Migration, PL/SQL development, Scripts and DBA activities. Oracle 9i, TOAD, Oracle Enterprise Manager, PL/SQL, ER-Studio.
Automation of Ministry of IT (ERP): It is a web based ERP/Workflow application used by Ministry of IT (MoIT) employees. My role was of an Application DBA/Data Modeler and was involved in data base design, SQL Tuning, Data Migration, Backup/HADR configuration, Scripts and other DBA activities. IBM DB2 UDB 8.2, TOAD, DB2 Control Center, ER-Studio.
 Cost Value Audit (CVA HRMS): Designed Database for this human resource system. Database independent software. Initially developed for MYSQL, DB2.
Warehouse: (CDR Warehouse) Designed Developed Software of a Warehouse system for calculating Calls consumption, Calls and Call success Ratio, etc. on Basis of Call Detail Record (CDR) obtained from operational system DANCOM Calling CARD. A complete figure of Total, Zone wise, Region wise calculation of above figures are calculated using this. (Oracle8i, SUN Solaris upgraded to Oracle 9i later).
OLTP: Post Paid Telephone billing system (Calling Card) An operational system, to calculates call charges based on Callingno and Calledno, City Codes, Zone Tariff and Time of Call, Nation Wide and International calls and implements charging on basis of both Tariff and Zone Matrix using oracle 9i.
Hybrid (Data mart/OLTP): Customer Support system: It is a GRID based Distributed System. I did participate as DBA, Designer, and QA Engineer in this system analysis and Design. Also participated in Logical designing and testing team. Currently handling this Database as senior DBA. It maintains 6 months call history data of all Pakistan (200Gb to 300Gb) with customer complaints management system.
OLTP: I have administrated ISP Database Server (using Oracle 9i on Solaris) and ISP Radius Server (using Linux) of DANCOM in Islamabad and Peshawar Zone (remotely).
OLTP: I have been a part of Design and Development Team of ISP Billing System. ORACLE for SUN SOLARIS is used for Primary Database Server and LINUX is for Advance Radius Server.
OLTP: I have worked on RBS ISP Billing system enhancements
 Hybrid: Designed a Hybrid (postpaid and prepaid) Telephone billing system and Database.  Card Generation, Activation, Selling, Region and Authorities management for card selling. Black listed number management, Tariff Management and zone Matrix number management, Call charging from card amount and a huge reporting system.
Hybrid:  Designed, Developed and Software of Calling Card Activation, Locking and Unlocking management system using Oracle and Developer 2000 for DANCOM. A touch of Reporting system is also a part of this software.
Designed, Developed and Administrating DB and Software of Online Tariff for in House use of   DANCOM Pakistan Private limited using Oracle and JSP for DANCOM.
ERP (Automation of Ministry of IT): Developed logical database design for the (Internal Communication and Project Management) modules of MoIT (Ministry of IT) Automation Project. Tools used are ER Studio, DB2
ERP Module (Inventory & Sales) Systems: Designed, Developed, Implemented and Administrating DB and Software of many small solutions for MIS reports on Misuse pin code calculating system, country based calls checking, consumption and calls based for national and international calls for PTCL monthly Report using SQL Server, Oracle and Excel for DANCOM. http://tariff.dancom.com.pk, http://mktg.dancom.com.pk/  (accessible by Intranet of Dancom only).
Hybrid: (Sales ERP) Design Modification, Tuning and Administrating of DB and Software of Sales Module of ERP of DANCOM Pakistan PVT (Ltd) using Oracle and JSP for DANCOM.
Hybrid System: Designed, Implemented and Administrating a Web Based Card Inventory System. Some major functions related to Calling card are Generation, Activation, Issuance, consumption, Faulty Cards Replacement between Head office and Regions, Dealers, RSO and Outlets. Moreover a Detailed reporting according to dealer, Regional offices, RSO and Outlets Role in sales process and transaction of Faulty and misprinted cards back to head office.  (Oracle and JSP) http://www.pccs.dancom.com.pk/.
OLTP: Call Record Reconciliation and Converter System: A billing System Converter that converts Dancom CDR according to PTCL CDR format and reconciles it. Using heterogeneous DB Environment of Oracle and MS-SQL Server.  
VHRE: Designed Database for this human resource system. Database independent software. Initially developed for MYSQL, DB2.
DB Backup Server: I have designed and currently managing DB backup server using LINUX as OS and Oracle as Database. Its purpose is to handle Oracle Databases like Card Inventory System and Accounts Database of DANCOM Systems Backup using Oracle RMAN.
Professional Profile      Software A&D Tools: MS Project, MS Visio Rational Rose, ER Studio, TOAD and SQLTools.
Operating system: Solaris, HPUX, Linux Windows NT 4.0, 2000, Datacenter Server.
Programming: VB .Net, VC++, java, C++ and PL/SQL, ExtProc, Oracle Spatial, Oracle Heterogeneous Gateways, Oracle IDS, Developer 6i
DBMS: Oracle 8,8i and 9i 10g, MS SQL Server, MS Access, IBM DB2, MySQL.
ETL Tools: Oracle Warehouse Builder, SQL Loader, External Tables, MS DTS, and Synopsis.
WEB: Front Page, JavaScript, ASP and JSP.
Networks: LAN and WAN technologies From   Ethernet to ATM and Fiber Optics.
Storage Tools : MCA100, XP1024 (SAN), Clarion Disk Library. HP Data protector, EMC Networker