Zafar Ali Khan

Profile

Over ** years of extensive IT Management experience in System Analysis, Business Analysis, Business Intelligence Operation, Maintenance, and Integration using industry best practices that enhances business goals through effective design and technology management.

Comprehensive knowledge of Business Intelligence and data warehousing Operations for data management, directional analysis, gap analysis and to identify trends for business dealing.

Key expertise in the Business Intelligence/ Data Warehousing Operations

In Etisalat - UAE, working as Technical Expert – (Partner and Business Intelligence Applications Support). Leading the BI/DWH Projects to provide efficient support to the business stakeholders through the use of advanced analytics and predictive modeling.

Technical Expertise

Databases

Aginity Workbench for Netezza

Teradata v13 and 14

Optimization of SQL and Applications

Understanding of Performance and Tuning

Development Tools

IBM Tools (Cognos v10.1, 10.2, 10.2.1 and 11.0.11)

Control-M, Aginity Workbench (Netezza)

Tableau

Power BI

IBM BPM

Operating Systems

Windows, Linux

Professional Experience

Etisalat (Emirates Telecom U.A.E.) (Oct 2014 – to date)

Designation/Position:

Sr. Solution Architect / Data Platforms and automation support

IBM Cognos / Tableau / Power BI Administrator

Participation in requirements gathering from business users.

Developing reports using Power BI/Tableau BI/ IBM Cognos

Designing data models (Star Schema / Snowflake schema) in Power BI Desktop to fulfill the desired reports dashboards requirement.

Development of different types of advance reports/dashboards like (Decomposition Tree, Key Influencers, Paginated Reports, Funnel Charts, Ribbon Chart, Custom visualization, KPI Cards etc.

Creating parameters for dynamic data sources changes.

Creating measure using advance DAX formulas as per the user requirement.

Optimizing power BI existing reports/dashboards performance using best practice logical modeling in power bi desktop.

Creating reports based on Embed SQL queries in power BI desktop.

Implementing row level security(RLS).

Dashboards deployment from UAT to production server.

Creating Extract for the dashboards on the server and scheduling the extract refresh on the power bi server.

Scheduling dashboard and bursting dashboards to different recipient schedule subscription.

Creating users and user groups on Power BI server

Participation with Microsoft vendors in Power BI server upgradation from May 2020 to Sep 2021.

Maintaining Powe BI server

Operational Responsibilities

Providing an application support function including the coordination for all the enterprise system elements on the server-side applications components and the client side applications components with the other departments or teams.

Working on maintaining Data Standards and Data Governance across Data Warehouse and BI.

Managing cross-departmental dependencies to address data issues (i.e., defining data ownership, creating data quality improvement programs, performing business metadata management).

Managing vendors and ensure strong relationships with vendor to carry out and deliver the projects

Generate major & critical reports for Marketing/Finance Department and Higher Management which present the main input to make the decisions for Etisalat Products & Services.

Work with Business users and/or various departments of Etisalat (i.e. Finance, Marketing, Sales) to translate complex reporting requirements into functional specifications for reporting solutions.

Work with development team to finalize functional and technical design specifications to build a solution that meets the specification and to test / validate the solution all the way to production.

Manage data retention policies, Business Process Re-engineering, GAP analysis, Information System Audit among the various IT projects.

Well organized administrative and end-user documentation.

Ensure satisfactory resolution within agreed SLAs and communicate progress / issues to business users and/or various relevant departments.

Managing and administrating development, support and maintenance of the following Projects

Monitoring the jobs flow through scheduling Control-M tool.

Responsible for defect fixes in different production environments.

Following proper escalation process (Leve1-Contorlroom, Level2-Client team) during production issues

Spot fixing the issues during production support time based on time line and also creating tickets base on the severity.

Incidents resolving and doing Root Cause Analysis for the problems fix

Responsible for process improvements by continuous transition of know-ledge to team members for reduction of escalations

Involved in every phase of the ETL process starting from Analysis to Implementation

Familiarize the team with the customer needs, specifications, design targets, the development process, design standards, techniques, and tools to support task performance.

Analyses of Design documents and code as per the design document, prepare Unit test cases, conduct unit testing, capture the Unit test results & Responsible for code deliverables on time

Supported DataStage specific problems on call rotation 24/7.

Projects handled in Etisalat:

I was a part of the team what was migrating Cognos report from IBM Cognos Version 10.1.2 to IBM Cognos Versions 11.0.11.

I was a part of DWH revamp project managed by IBM Pakistan.

I was a part of OBI project implementation.

I was part of VAT project implementation in IT and all Cognos Reports.

IBM Cognos Upgrade to v10.2.1 and Data Migration.

Led the project, successfully migrated, and upgraded IBM Cognos Business Intelligence.

Application from v10.2 to v10.2.1

IBM Cognos Upgrade to v10.2 and Data Migration:

Led the project, successfully migrated and upgraded IBM Cognos Business Intelligence Application from v10.1.1 to v10.2

IBM Cognos Application Security:

Led the project concerned with overhauling of security on all three levels (user, objects, data) in the current organization’s Cognos Environment in accordance with the industry best practices.

Hyperion Upgrade and Data Migration:

Played an important role to successfully migrated and upgraded Hyperion Application to v11.1.1.

Upgrade Revenue Sharing System (RSS-VAS and RSS SDP):

Played an active role to enhance and modify the application which generates the critical management reports automatically for Finance and Marketing departments.

DWH and BI – (Teradata, Netezza, Data Stage, IBM Cognos version 10.2.1 and version 11).

MIS - Management Information System (Hyperion)

DWH and BI – (Teradata, Netezza, Data Stage, IBM Cognos version 10.2.1 and version 11)

China Mobile Pakistan - ZONG – Islamabad. (Apr 2012 – Oct 2014)

Designation/Position:

Sr. Business Intelligence Analytics / Team Lead

Job Description:

Involved in Requirement gathering from Business Users.

Created trained and implemented Churn models.

Responsible for development of post-Batch Jobs and BI (PL/SQL)

Analyzed the specifications provided by the clients and Developing specification documents for reports as per client requirements.

Involved in installation of Cognos 10.1 suite of tools and configuring LDAP for the secured authentication

Designed and Developed the Framework Manager models and published into server.

Involved in preparation of design documents

Created Business Objects Reports and maintained existing Universes for different departments.

Exported the Universes to the Repository to make resources available to the users.

Participated in the defining technical standards and guidelines that pertain to data and information use, security, access, and governance

Worked with project lead and business users to gather requirements, conduct analysis, and prioritize requests

Translated project requirements into functional and non-functional specifications for BI reports and applications

Responsible for Ad-hoc data requirement, analysis, and development

Responsible for training end user’s new vendor.

BI Implementation Project in China Mobile Pakistan (ZONG):

The aim of this system was to provide end-to-end organizational wide BI solution to the Organization. The solution includes identification of data sources, creating data warehouse on Oracle, developing metadata models and then produce reports. I worked as a member of the team. My main responsibilities were:

Reports designing and development which includes, drill through, active reports and complex master-detail relationship reports.

Implementation of security for Cognos by coordinating other departments of the organization.

Implementation of Cognos Portal Pages

Event Management in Cognos

Geographical BI implementation using MapInfo on Cognos

Administration of Cognos

Participation in the requirements gathering phase with system analyst to fully understand the requirements of Business Users.

Participation in physical data warehouse design to look it from BI semantic layer perspective.

SPSS Implementation for churn Prediction

Participation in the requirements gathering and implementation of SPSS for the churn prediction.

Unica Campaign Management.

Guide the Unica Campaign management team in identifying requirements to run campaigns successfully.

Optimization of the DWH Project.

I was a part of that team who participated in the Optimize the DWH to maximize the capacity of Reporting.

We worked on the proper use of Indexes.

Memory and storage requirement.

We worked on the proper use of Indexes.

Parallel execution of jobs.

We analyze the proper use of portioning.

We remove unnecessary jobs.

Shifa International Hospital - Islamabad (Jan 2011 – Apr 2012)

Designation/Position:

Software Developer (Oracle Forms and Reports)

Job Description:

Worked on Human Resource/Maintenance/EMR/Medical Record Systems of Shifa International Hospital

Customization and Development of New/Change requirements of the above-mentioned systems

Participated in Systems Requirement gathering and Analysis

New Requirements management and implementation

Change Requirements management and implementation

Client Coordination and existing Processes investigation and Analysis

Software Testing and Quality Assurance

Preparing and executing the Test Plans and Test cases according to the Functional, Incremental Integration, Stress, Volume, Usability, Performance and Load testing techniques.

Skills in Customer Support, Corporate Training and Technical Writing

Nazariya Pakistan Council (N.G.O) (Apr 2008 – Dec 2010)

Designation/Position:

Data Assistant

Worked as a data assistant in Nazariya Pakistan Council, Islamabad.

Roots School System - Islamabad (Jan 2006 – Apr 2008)

Designation/Position:

School Manager

Worked as a Manager in one of the Primary Branch of Roots School System Islamabad.

Professional Training by Microsoft

Microsoft Azure Fundamentals (AZ-900)

Microsoft Power BI Data Analyst (PL-300)

Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI (DP-500)

Data Engineering on Microsoft Azure (DP-203)

Educational Achievements

Master:

Degree: MC CS.

Institute: Shaheed Zulfikar Ali Bhutto Institute of Science & Technology, Islamabad, PK.

Duration: April 2012 – April 2017

Percentage: 3.05 GPA

Degree: MCS.

Institute: Phir Mehr Ali Shah University of Arid Agriculture, Rawalpindi.

Duration: April 2015 – Jul 2008

Percentage: 3.45 GPA

Personal Information

Date of birth: 1st October 1978

Marital Status: Married

Nationality: Pakistani

Language Skills: English, Urdu

Extra-Curricular Activities

First Position in Etisalat Mini Marathon 5 KM.

Got the Finisher Medal in SPRINT RACE in DUBAI (2015 and 2016).

Won the first position in China Mobile Pakistan (ZONG)’s Mini Marathon Race held in 2013.

Participated in comprehensive training on HL7 standards held at HUST – School of Electrical Engineering & Computer Science.

Participated in half day training session in “Business Startup: Establishment and Compliance of a private limited company” held on 18th August, 2011 at SZABIST, Islamabad.

Participated in a program for presenting a wetland model as educators of Wetland Conservation in Wetlands Pakistan.

Participated in a workshop on “CREATING A COMPETITIVE ADVANTAGE FOR YOUR ENTERPRISE" on Wednesday, 15 February 2012, from 2:30pm to 5:00pm at SZABIST Islamabad Campus.

Participated in Cancer Awareness Campaign held on 22nd Jan, 2012 to 4th Feb, 2012 at Shifa International Hospital, Islamabad.

Participated in Quarterly Training Program of on Communication & Interpersonal Skills arranged by HR at Shifa International Hospital, Islamabad.

References

Will be provided on request

Zafar Ali Khan

Cell #: +1-331-***-****

Email: ***********@*****.***

Contact this candidate