Omair Khan

Extracting, Cleaning and Analyzing Ministry Data using MS SQL Server 2012 DB, SSIS .Development of Analytical Reports for Higher Management using Qlikview. Performing Analysis of Data using R.
Preparation and Review of Data model
Working with Vendors for defining the Scope of Work, Technical reviews of proposals, Validation of customized MIKE and Kimball framework for NIC Projects
Preparing and planning project resource requirements
Preparation of Charter, Vision, Scope of Work, Requirements, Architecture, Test Plan and Test cases for NIC Projects
Review of RFP, Preparation of Technical Architecture, Work Breakdown Structure for NIC Projects

Enterprise Data Warehouse Administration and Maintenance. Tuning and optimizing the ETL jobs and EDW storage space, Requirement Analysis from Business Users. Developing Dimensional Models for Data Marts. Developing Facts and Dimensions based on the Dimensional Model. Developing ETL Jobs and Process Flows for the Facts and Dimensions. Ensuring Data Quality and Data Integrity in the Enterprise Data Warehouse (EDW)

Key projects:
-----------------
• BI implementation at KFUPM : Analysis of BI Implementation proposals. Preparation and Analysis of BI implementation Contract and Scope. Analysis, Design, Implementation of the Data Marts in BI Team Scope. Validating the Deliverables by the Vendor. Preparation and Analysis of Requirements Document for the target departments. Preparation of the Data Model for EDW as well as individual Data Marts for the Organization. Implementation of Enterprise Data Warehouse using OWB (Oracle Warehouse Builder). Design and develop BI Reports using IBM Cognos 8.1.2 Report Studio. Take over and lead complete expansion, development, support and maintenance of enterprise-wide BI System from BI project team to the BI Unit at the University
• eGovernment Services Assessment Project with Yesser eGovernment Program of Saudi Arabia: Data Warehouse and ETL Consultant for the Assessment of E-Services at Government Agencies Project. Identifying Reporting and Analysis requirement for the Project and work on the Data Model with the client. Developing Dimensional Data Model for the BI Reporting and Analysis. Implementation of the Data Mart in MS SQL Server 2008. ETL from the current and previous measurement data into the Data Mart using MS SQL Server SSIS. Ensuring Data Quality and Integrity
• Research Management System: Designed OLTP Database Model for the University Wide Research Development System. Implementation of the Database Design in MS SQL Server 2008

Research in topics of Computer Science including Speech Recognition, AI and Software Engineering.
Taught Programming Courses to Undergraduate Students.
Developed Software and Database Applications for Government clients through the Research Institute in KFUPM

Key projects:
----------------------
Developed a Corrosion Research Program using Oracle JDeveloper ADF Framework as Front End and Business Layer and Oracle 10g as Back End Database, for Center of Engineering Research, KFUPM.

Analysis, Design, Implementation and Deployment of Inventory Control System. Prepared Requirements and Functional Specifications of Software. Designed Application Layers and prepared Coding Guidelines. Guided Team members and End Users and held design and use briefings. Used VB6, Crystal Reports and MS SQL Server 2000 for Development. Used Erwin and MS Visio for Software and Database Design.

Involved in Design and Implementation of the Billing Module using Erwin, Oracle 8i Database and Oracle Forms/Reports6i.

Developed a Sales, Billing and Inventory System. Project involved Visual Basic 6 as Front-End Presentation Tier, SQL Server7 as Back-End Database and Crystal Reports as Reporting tool.