Haider Bilal

Al Rigga ,Dubai.

Cell: +971553113668, Email: [email protected]

Skype:haider.bilal3

LinkedIn: https://www.linkedin.com/in/haider-bilal-21398337

Career Objectives

To be employed in a firm where I can put my Technical skills knowledge and Experience to be use in enhancing the Organization Systems, Developing App that will boost the company’s productivity and efficiency in Task processes and Analytical Approach of Evaluation.

Professional Summary
5 years’ experience of Business Domain Knowledge of Core Banking Systems with Complete Banking Operations supports and Database management  along with 4 years’ experience of Telecom Operations  and Technical Reporting , Perform Data reconciliation, consolidation in a Centralized Database with analytical and  Automated KPI meeting reports for  the concern stakeholders  along with almost  1 Year of extensive Experience in Dubai  Airport operations .

Database reporting, analytics and business intelligence experience in the Oracle platform (SQL developer, TOAD especially on SQL standards and Programing Development in Microsoft Framework C# ASP.NET using MVC)

Integration Services along with fast parallel processing of ETL Packages. Strong knowledge in writing SQL with complex Query and efficient Stored Procedures, Triggers, DB Scripts, DB Backup planning and scheduling Database Design, Data Modeling and maintain Databases along with DB support for other DB Administration related operations. DataStage,SSIS,PowerBI Strong ETL skills with OLTP, OLAP and ETL data processing concepts, Expert Multiple Databases Server (MS SQL, Oracle, MySQL) and connectivity among distributed databases and Data extraction. Query Performance tuning, Normalization, decomposition of data,

ERP applications in a detail oriented environment of multiple Modules. Manage all the stages of Software development. (Agile/Scrum JIRA, MS Project Management).Vendor Management, Service desk ,Billing along with Double Entry transactions Systems and Familiar Expertise of both Microsoft OS and Servers along with Linux Shell Scripting, Cento

Web Store Backend management running on Microsoft NOP Commerce. Ecommerce operation ,test and debug issues Manage Payment / Logistic Gateways
Experience
Organization
SD (Middle East) LLC(Dubai)   https://new.siemens.com/global/en/markets/airports.html
Designation
System Analyst ( June  2019   to date)
JOB Description

Perform Daily Airport  operational task for the all the terminals of Dubai Airports including

Manage Airport MIS system for  all Flights both(Arrival, Departure and Transfer) and maintaining Passenger/Flights Databases along with  System  and technical reporting.

Maintain Production applications and take Daily Backups(SQL data pump import/export) along with Performance utilization of Oracle database using Oracle Enterprise Monitoring
Maintaining online Data ware house database for the rapidly queries and Efficient Views for reporting Purpose along with developing utilities and tools for uploading and extracting data in ( Microsoft C# asp.net) and creating KPI and Dashboard Reporting and visualization of data ( using Power BI tool for the stakeholders.
Manage All the running VMware Servers  of  both applications and databases.
Perform automation of reports by running schedules ,batches and using   PLSQL packages  for extraction and population of data .
Perform Weekly and monthly maintenance  of all applications  server and database servers running for the Daily Airport operations activities
Database cloning, Mirroring  along with  Database Profiler and traces events on DB
Maintaining all IP and wireless Camera  Servers and creating Views as per stakeholder request
Give Support to all Running Application related to IT Support Level 2 and Level3.

Organization
Warid Telecom (Head office) http://www.waridtel.com/

Designation
Technical Reporting/ System Analyst (July 2014 to Jan 2017)
JOB Description

Develop Analytical Reports and Dashboard Reporting Visualization Charts for the concern Stake Holders. Providing  Technical support by maintaining internal Application System  Development, identifying and resolving technical issues raise by concern stakeholder’s and user. Creating and maintaining efficient and secure systems for recording data in a Production Database along with DB Administration and producing a relevant documentation.

·         DB user administration roles, Scheduling Job of databases backup in a timely and efficient manner. Database migration from different data sources (Oracle, MySQL) and maintained Centralized Database.

·         Prepare reports and properly utilize report data along with  analytical Dashboards and visualization(using Power BI) and extract reports from Cloud Databases(MS AZURE)

·         Perform Data integration with all regions data in a  centralized Database and perform Analytical Business Reporting  using Microsoft( SSIS,SRS,SAS),Power BI

·         Keep track of records regarding NOC Operation of Sites Alarm, Sites Power Outages causes and remedies to taken to resolved.

·         To perform daily, weekly or monthly analysis and present findings along with areas where you identify room for improvement by provide Pivot reports on them.

·         Data reconciliation, consolidation in a Centralized Database with analytical and  Automated KPI meeting reports for  the concern stakeholders .

·         Create Utility Tools for Uploading, Data Validation, and Data check, Data Cleansing in Microsoft C#.Net Framework) along with ASP.Net

Organization
Allied Bank Limited (Head office, Pakistan) Sept 2009 to  2014 https://www.abl.com/
Designation
System /Data Migration Analyst (2011-2014)

JOB Description

Responsible of Data migration from Legacy Banking System to New Banking System(Temenos T24).

Perform data migration of all the financial and static data of all the branches of ABL (Data upload and verifications). Perform Extraction of data from old Banking system (legacy system) into a required file format along with Data Mapping of fields.

Creating Different Databases schemas and Replication of DB along with updating patches.

Perform Staging of data, and conclude anomalies and exception of data and cleansing, Perform Mapping of data accordingly to the required field in Banking System.

Develop stored procedures/Functions/Triggers and Packages by using Oracle Plsql
.Software Development lifecycle in Oracle environment Administration of Oracle Applications
Performance optimization of query and DML operations on large scale online database.
Extensive knowledge of enterprise environment analyzing, designing and developing applications for Windows.
Perform Extraction and loading of data from different sources (textile, Excel, Emails, XML, External tables, Applications, Remote Databases.
Capable of performing data backup using import/Export utility and by using RMAN.
Also provide T24 Application Support regarding SMS roles & Application and user related issue along with deployment of T24 Application rollout in other branches and perform UAT
Capable of installing and developing a System on a Red Hat  Linux  platform  with all the .required Utilities ,Patches and RPM required to be configure and deploy.
Familiar with Linux Commands and shell Scripting and Complete Linux Administration of Rollout Server of a banking System.

Organization
Allied Bank Limited (Head office, Pakistan) Sept 2009 to  2011 https://www.abl.com/
Designation
software Engineer
JOB Description

Work as a team member in the development of  Inventory/Asset Management  System
Work as a team member in the development of Issue logging System (using C# .Net, ASP.net MVC and MS SQL), Provide ERP Application Level support L2 and L3.
Developed Email  an Alerts System/SMS system that identify any technical issues that arise Developed  web portal for reporting analysis of rollouts (C# Asp.net and SQL Server)
Monthly ,weekly Reports regarding processes of rollout and then upload them in SQL server by

Organization
Infotech Group (Head office, Pakistan) OCT2008 to  Feb 2009 http://www.infotechgroup.com/
Designation
IT Support Engineer
JOB Description

Capable of performing all kind of window Server and S/w installation & configuration.

LAN trouble shooting  installation of networking devices, OS Image creation with drivers

Troubleshooting support Installation of Linux System (RPMS and network configurations).

Good hands on experience on Active Directory Domain controller, Installing and configuration of services like (DC, DNS, DHCP, File server, Backup Server, Print server and Antivirus server. Having knowledge about Mail clients (Outlook, ActiveSync, and Mobile Email Settings).

Education
Bachelors of Information Technology Punjab University, Lahore                                                        2004 – 2008

Professional Trainings

·         Linux  System administration training

·         Oracle Certification Associate (OCA) (DBA)

·         Oracle 11g PL SQL Developer

·         Microsoft SSIS, SRS, SAS ,Power BI)
Technical Skills

MS SQL Server (2008, 2012), MS visual Studio(C# Asp.net), Complete MS office Suite (2007) Microsoft Excel, Oracle 10g/11g  development in PLSQL and oracle 11g Administration, Linux administrations (Red Hat 9 & Enterprise Linux 5.4), Php, My SQL (using Wamp server), Linux Shell Scripting& installation and deployment of all RPMs’, Case Tools: Erwin, Rational Rose, MS Visio,   Windows Server 2008-20012,Win 7,10

Microsoft Business intelligence(SSIS,SRS,SAS),PowerBI, JIRA, MS Project Management

Soft Skills

“Communication is the responsibility of “I“ , “Making it happened” ,“Motivational challenges in multi culture organizations”, “How to lead from front” ,“How to capture the fear”, “People don’t leave companies, they leave managers”.

Hobbies/Interests
Travelling for Adventure, cricket ,POOL snooker, and  helping hand and socially active, Making things possible.

Personal Details
Nationality             Pakistani

Marital Status        Married

Work Permit          UAE/Dubai

Language:              English         (I am highly motivated to learn Arabic)

Reference will be furnish when required.