Energizer – Business Intelligence Management (PAK, GCC, Europe)

• Sep 2022 - Present

Responsible to lead the architecture, design and management of business intelligence solutions & applications. Also, to manage Power BI Cloud and SSAS dashboards for the organization and design applications through power platform to fulfil business requirements.Responsibilities:-Solution Design and Architecture for Business Problems-Technology Assessment for multiple alternatives-Design, Development and Deployment for both external and in-house developed solutions-Business Intelligence technology architecture design, development and deployment-In-House Maintenance and Support for Khaadi's Power Platform eco-Azure (Data Lake, Synapse , Databricks, Data Factory) Show less

Business Intelligence Lead

• Mar 2022 - Sep 2022

Responsible to lead the architecture, design and management of business intelligence solutions & applications. Also, to manage Power BI Cloud and SSAS dashboards for the organization and design applications through power platform to fulfil business requirements.Responsibilities:-Solution Design and Architecture for Business Problems-Technology Assessment for multiple alternatives-Design, Development and Deployment for both external and in-house developed solutions-Business Intelligence technology architecture design, development and deployment-In-House Maintenance and Support for Khaadi's Power Platform eco Show less

Business Intelligence Consultant

• Nov 2021 - Mar 2022

• Working as senior BI consultant (acting BI Team Lead). • End to End BI Projects Deliverables and conversions from business BRDs. • Creation of stored procedures, Functions and Views for Power BI as data source. • Creation of stored procedures, Functions and Views for SSRS reports and BI product. • Create visuals and analytics for business from scratch using Microsoft Power BI. • Develop as well as customize existing multidimensional SSAS cubes for self service projects. • Manage and work on big data (Data lake) for BI products Hue | Impala | Cloudera. • Perform query performance steps if there is performance issue in any step of BI process. • Change in the logic as well as designing of the SSRS reports. • Create and customize SQL server agent jobs for different purposes. • Resolve critical tasks with accuracy and give understanding of the issues to functional consultant. • Complete development of BI Architecture for business projects from Raw Data on Data Lake to collection model from collection model to reporting zone and from reporting zone to semantic layer building end to end Cubes, Reports and Dashboards as presentation layer. Show less

Manager (Technical Analyst Core Banking/MIS)

• Jan 2020 - Oct 2021

- Management of Core banking, operational and reporting tasks. - Management of Sybase database and SQL reporting servers. - Cognos administration Content, Environment and Framework management. - Development and Management of Routine Data Warehousing tasks (ETL Process) data dumping/transformation activities. - Development of Packages/Scripts for Migration of Core Banking data from hPLUS to iMAL. - Development of Reports and Dashboards for Regulatory and Banking Departments. Show less

Business Intelligence Analyst

• Oct 2019 - Jan 2020

Using Oracle Business Intelligence to Create, Expose, Publish reports for Digital Banking Departments. Using Access, Toad, Excel to execute various Ad Hoc queries. Using Oracle Business Intelligence to Create, Expose, Publish reports for Digital Banking Departments. Using Access, Toad, Excel to execute various Ad Hoc queries.

Application Developer & Support Executive

• Mar 2016 - Sep 2019

In-house Applications Development: Using ASP.net, MVC with C# and Oracle 11g as a database. Mobile Intelligence Administrator (CLM for advance detailing) Sales Data Management. Company Discount Data Management. Using Qlik View for designing Various Dashboards for multiple Departments (Sales, Business, Finance etc.) Supporting Vendor in Deployment of Developed Applications to the standard of company architecture. Using PLSQL and SQL Developer with Oracle 11g to generate adhoc quires and designing database structures for application. Coordination with international vendors and cross functional teams to support global applications. Support and trained sales force regarding CLM and Sales Applications and Procedures. Training: ASP.net, C#, Windows App development form Mind Scape (Sponsored by Sanofi Pakistan) QlikView Training from Reveal Soft (Sponsored by Sanofi Pakistan) Show less

Sale Force Automation Administration

• May 2011 - Mar 2016

Mobile Intelligence Administrator -Customer Relationship Management Mobile Intelligence is a System for reporting, planning and analysis. Job Description: • Administrating a CRM System for Pfizer Field Force. • Training Field Force for Mobile Intelligence. • Managing Coordination with Support staff and Sales Dept. • Managing TRA (Territory Re-Alignment), Product Port Folio and Team Structure in MI. • Administrating Customer Data Management in MI. • Providing support to the Field Force regarding application issues • Updating application with new Field Coaching template. • Implementing POA in application according to the data provided by PM’s Performance Eye (Sales Data Management) -Performance Eye is a Application for analyzing Pfizer Sales at Brick level. Job Description: • Designing Geographical Structure for Sales Force. • Implementing Geographical Data in SDM Application • Implementing employee’s data in SDM Application. Cognos Admin (MOLAP Reporting Tool) -Cognos is integrated with Pfizer CRM and provides KPI Reports and Interactive Dashboards for Sales Force. Job Description: • Creating multi dimensional reports based on verity of measures. • Creating Interactive Dashboards for National , District and Representative Level SAP Business Object WEBi Admin -Business Objects is integrated with Pfizer CRM and provides KPI Reports and Interactive Dashboards for Sales Force. Job Description: • Creating multi dimensional reports based on verity of measures. • Creating Interactive Dashboards on SAP DASHBOARDS for National, District and Representative Level • Creating several reports as required by Business. • Maintaining Automation of reports for Sales Force. • OLA support to business in tracking performance record. • Supporting team in Creation of Ad-hoc Reports. Trainings: • International: Mobile Intelligence Administration Training Held in Dubai by CEGEDIM International. • Domestic: Performance Eye training held in Pfizer Head Office Karachi. Show less

User Interface Designer

• Apr 2011 - May 2011

Project Coordinator

• Jul 2008 - Dec 2010