Hassaan Yar Khan Email & Phone Number

United Arab Emirates

Abu Dhabi, United Arab Emirates

Team lead OBIEE ( Oracle Business Intelligence Implementation)

Dubai

Presales:Drive the problem analysis process with the business (Emirates Airlines). Working closely with the business to deliver the perfect solution to their business problem through application integration or database solutions. Helping customers to evaluate the value of the new initiated solution. Making a prototype to let business users have a feel for the product. Having regular meetings with users in order to quote down the requirements. Data warehouse Solution ApproachPlanning and analysis: •Working with senior management to create a data warehouse business case together with the project manager which clearly outlines management expectations, and project scope.•Getting data requirements, including logical data model ,dimension data model, data movement requirements, including source to target mapping (based on Ralph Kimbal or Bill Inmon methodology).This also includes data conversion ,historical data ,data quality and security requirements. Also Business intelli-gence reporting requirements including any business intelligence dashboard requirements.•Delivering data warehouse architecture, including all data base design documentation, data movement, data conversion, data quality, and business intelligence design specifications and providing technical leadership to the development, system testing, and integration test teams.Data warehouse implementationProviding on-going technical leadership, coaching and training to ensure successful implementation.BI & Data warehousing Experience :Defining, developing, and enhancing of two separate custom DW/BI systems for Crew planning and MIS. Primary responsibility include but not limited to coordinat-ing, planning, and conducting interviews with various business users in identifying and capturing business requirements, defining and developing project scope/plan, creating and developing two separate multi-dimensional data models using the Ralph Kimball methodology, performing source-to-target mapping,

Karachi

Presales :Served as a Data Warehouse Architect/Consultant took part in the presales for selling the data warehousing products to SCB (Standard Chartered Bank). Creating presenta-tions for clients as if what benefits the data warehouse and BI can give them using the Teradata FSLDM. Following tools and/or technologies were used in the development: Teradata, Cognos and Erwin.Development :Additional tasks included the creation of schema objects (tables, views, indexes, pack-ages, triggers, etc.) in Teradata environment, the expansion of a single dimensional data model (star schema) into multiple star schemas, source to target mapping, storage capacity planning and the support and maintenance of the Cognos EP Series 7 report-ing environment. The following tools and/or technologies were used in the develop-ment: MS Windows 2000 Server, Sun Solaris, Oracle8i, Sunopsis, PL/SQL, Cognos EP Series 7, Erwin, and Oracle Enterprise Manager.• Analyzing source system data structures and extracting them into the ware-house that includes mapping them into the target warehouse database.• Making views, functions and stored procedures for Cognos ROLAP reports and Multidimensional Cubes for Cognos Transformer.• Implement the reports and cubes on the client• Effectively used Cognos reports and Cognos framework manager to built the BI on top of the Data warehouse.

Served as a Lead Oracle Database Administrator in a development environment for an enterprise database application for the bank. The enterprise database application supports the banks business. Tasks include designing and building of logical and physical database structures, administrating several Oracle database applications and security, analyzing and translating end users requirements into database objects (tables,views,indexes,procedures,functions,etc.) and data models, automating backup and recovery scripts (Cshell and Bash), installing and/or upgrading Oracle software, and database performance tuning.Together with working on migration of the core banking solution from Pibas to Misys. Migration data from oracle to sql server .Migrating images stored in database into the new system. Creation of replication for CCIS (Core Misys) server.Working on Equation (I-Series).Developed Misys Reports saving software that actually extracted the content from I –series and then saved it according to the date /branch wise folders with compression nearly 50 percent of the original file Customizing and implementing Banking Core System (Misys) and migrated the signatures from the old PIBAS software to the Misys through mapping of accounts.Analyzing databases on SQL Server 2000, db2 and oracle. Deciding the storage structure and access strategy, Defining a strategy for back-up and recovery for Equation branch automation databases, Monitoring performance and responding to changes in requirements. Installing the central server (EBA-MISYS) and branches (EBA-MISYS) and linking them through SQL server 2000 replications and administrating it. Giving technical support to the branches with EBA. Maintaining SQL Server Log Shipping. Developed SQL Server Log cleaning software that truncated the SQL Server Log Automatically after the period has expired to save disk space. Supporting all software applications databases within the organization and resolving issues.

XTreme is a comprehensive order management suite that integrates trading and operational processes across front, middle, and back office environments. Developed by Kolachi Advanced Technologies, the system is easily deployable on existing desktop hardware. The only requirements are application servers, a market data provider and a means of reaching your execution destinations. Responsibilities: 1. Testing the Application manually (Black Box testing) and via tools mercury (white box).2. Making load scripts to test the load ability of the application Xtreme.

XuQa is an online reality game in which you must climb the social ladder to become the most popular and riches person in the XuQa network. Responsibilities:• Created the Database Design for the site and implemented the initial physical model.• Making scripts that will grab email addresses from Ldap servers.• Making messenger bots such as (yahoo and msn) by which people can invite their contacts to site.• Planning marketing scheme.

Masters In Data Science, Data Science

Bachelor Of Science, It

A And O Levels, Engineering