• AT TECH Limited (June 2020 to Current)- Worked on population health management platform (EZAnalytics.co.uk) to measure, evaluate, and optimize care quality outcomes. Branded, commercialized and deployed at-scale to several external organizations within the NHS, such as CCGs, GP Federations, and Primary Care Networks, with almost 2 million total registered patients.- Working as a BI Team Lead, interact with the AT MEDICS (UK) and Operose Health (UK) team, understand the business requirement, Gathering the Data from different sources such as SQL Server / Oracle / PostgreSQL / Excel. Transformed the data and produced the reports using the Power BI Platform, Optimized reports with a focus on usability and performance.- Assigned (EZAnalytics.co.uk) access to external organizations within the NHS and integrate Power BI Reports with (EZAnalytics.co.uk).- Created Power BI report for Dr. iQ APP, Uk based app is available for patients online consultation, and Develop a Data Warehouse for Dr. iQ Report, worked on Cloud ETL Azure data Factory to Extract / Transform / Load data into Dr. iQ DWH from different sources and created Dr. iQ report in Power BI Desktop and finally published the reports on Power BI Service.- Develop 50+ reports by utilizing knowledge of SQL queries, SQL Server Reporting Services (SSRS), (SSAS) and SQL Server Integration Services (SSIS)- Generated calculations systematic using the Data Analysis Expression (DAX).- Creating Roles and Groups to the end – user and provided Row Level security to them with Power BI Desktop and Integration with Power BI Service Portal.- Developed and Published Reports to Service.- Wrote M Queries in Power Query Editor to transform the data.- Wrote SQL Queries, Stored Procedures, Views, Functions based on the requirement. - Experienced with Power BI Data Modelling.- Experienced in optimizing reports and setting up Power BI Service, Gateways and Power BI incremental / Scheduling Refresh.

• UBL (Pakistan) – OBIEE 11.1.7.0.x Implementation (June 2017 – Current)Migrate the Oracle Discover RPD in OBIEE on Linux OBIEE server and configure the RPD variables and connection pool. Create Direct Database reports, Now the work is in progress at RPD side, Reports and Dashboards requirements, User creation and security privileges model.

• River Island (UK) – BI Apps 7.9.6.x Implementation (August 2014 – Current)Implement BI Apps module HR & Payroll, Finance and Procurement as a lead in River Island. Right now successfully created the Linux and windows based BI client server architecture also upgrade the OBIEE from 111170 to 111171. Migrate the BI Apps RPD and Web catalog on Linux OBIEE server and configure the RPD variables and connection pool. Now the work is in progress at RPD side, Reports and Dashboards requirements, User creation and security privileges model.

• Christies (UK) – OBIEE 11.1.1.x Implementation (January 2013 – July 2014)Working Onshore as a Team Lead. Involved in Data Modeling, Configured OBIEE 11g machines upgraded the christies custom model and merged it with vanilla one in OBIEE 11g. Responsible for all new developments regarding Administration Tool (Repository), Web development (Dashboards and Reports), Security related OBIEE 11g also the RPD and WebCatalog Migrations.

• Christies (UK) - Client Comments & Campaign Management (October 2012 – August 2013Worked as a ETL Consultant, the purpose of the Client Comments project is designed to enable the Team Managers to consider the progress of their Team, employees and life cycle of any Client Comments. The purpose of the Campaign Management is to provide a detailed functional design of, the to-be marketing process which will be used for targeting client audience directly within OBIEE, created the mappings and workflows in Informatica also created tasks in DAC for newly created mappings and add it up to the existing execution plan. Involved in Data Testing and Report Testing activities using SQL queries to ensure accurate results to client.

• Asia Capital (Srilanka) - Technical Architect/Technical Project Lead (June 2011 – December 2012)Working as a Repository Administrator, Created the new Stars for the Siebel Analytics (OBIEE) 11g, designed and created the Meta data repository, security aspects, reports and dashboards.

• Christies (UK) – Re – Design Repository (January 2010 – June 2011)Working as a Team Lead, In OBIEE10G created the new stars and Aggregated Fact through which we can do Effective Reporting against different Sales, Campaigns, which are authorised in the Christies, created reports and performed migration from one environment to other.• Created the new mappings and workflows for Repository Redesign in which 1 aggregate fact holds the major information of sales and lots. Also that fact contains the Bidders and registrants information.• Christies (UK) – ETL Performance Optimization & Events and Salutation ProjectWorked as ETL Developer with a Senior Resource, Created new mappings and workflows and updated existing mappings and workflows. Created and updated Tasks in DAC.• Christies (UK) - BI Usage TrackingSuccessfully Implemented BI Usage Tracking with OBIEE in Christies. Made all the necessary joins in the Repository and make the Usage Tracking Subject Area in Presentation layer visible and also done the complete testing of BI Usage tracking.

• BMW (Germany) – Siebel Analytics & Marketing Consultant (January 2009 – December 2009)Worked as team lead for BMW “ShowCase” Project. The Showcase Project is designed to enable user centric reporting in single point access to all data.Reduce number of facts tables & align business model mapping.RPD presentation layer optimization (holistic approach).Improve indexing strategy, Incorrect ETL/fact population with duplicate records.

• BMW (Germany) – Siebel Analytics & Marketing Consultant (January 2009 – December 2009)Worked as team lead for BMW “QuickWin” Project. The main idea for the project is to make repository presentation layer consistent in terms of user perspective without affecting any of the existing reports. Responsibilities include gathering requirements from clients, having knowledge transfer among team members and making sure all the requirements are completed accurately and timely

• Christies (UK) - Technical Architect/Technical Project Lead (January 2008 – December 2008)Working as a Repository Administrator, Created the new Stars for the Siebel Marketing & Analytics (OBIEE) 7.8, designed and created the Meta data repository, security aspects, reports and dashboards, segmentation requirements, list formats, marketing campaigns.This one and a half year span resulted in successful completion of the following Projects.Clients Comments ProjectCampaign Management ProjectClient Development ProjectConversion Rate Reports Project.

• Bank Alfalah POC – QlickView BI Consultant (June 2007 – December 2007)Developed POC for Bank Alfalah for their General Ledger application. Created the attractive reports and dashboards providing trend analysis, drill through charts, pivot and cross table reports

Sr BI Consultant (SQL Server SSIS SSRS SSAS SharePoint Power BI | BI4Dynamics | Microsoft Dynamics)

BIG DATA Projects• HBL – Habib Bank Limited (May 2019 – Current)Interact with the business, understand the problems prepare the Dimensional Model for Customer 360 Project and Branchless Banking Project. Work on the Cloudera Hadoop with team. Involved in Cloudera Hadoop activities to load the data from selected source tables to target tables. Reconcile the target data tables through Hive / Impala. Created reports in Power BI.