Bilal Shahid

Experience

• 

  Dee&Zee

  Jul 2008 - Dec 2010

  Project Coordinator
• 

  Linkagoal

  Apr 2011 - May 2011

  User Interface Designer
• 

  Pfizer Pakistan

  May 2011 - Mar 2016

  Sale Force Automation Administration

  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

• 

  Sanofi

  Mar 2016 - Sept 2019

  Application Developer & Support Executive

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

• 

  United Bank Limited

  Oct 2019 - Jan 2020

  Business Intelligence Analyst

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

• 

  Summit Bank Limited

  Jan 2020 - Oct 2021

  Manager (Technical Analyst Core Banking/MIS)

  - Management of Core banking, operational and reporting tasks.- Management of Sybase database and SQL reporting servers.- Cognos administration Content, Environment and Frameworkmanagement.- Development and Management of Routine Data Warehousing tasks (ETLProcess) data dumping/transformation activities.- Development of Packages/Scripts for Migration of Core Banking data fromhPLUS to iMAL.- Development of Reports and Dashboards for Regulatory and BankingDepartments. Show less

• 

  Blutech Consulting

  Nov 2021 - Mar 2022

  Business Intelligence Consultant

  • 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

• 

  Khaadi

  Mar 2022 - Aug 2023

  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 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

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

    Sept 2022 - Aug 2023

  • Business Intelligence Lead

    Mar 2022 - Sept 2022
• 

  ZUE

  Aug 2023 - Feb 2025

  Sr. Manager - Head of Business Intelligence and Analytics

  In my role as Sr. Manager - Head of Business Intelligence and Analytics at ZUE, I led the BI team to analyze data, identify trends, and implement solutions for strategic growth. Also developed and implemented BI solutions to optimize business operations and drive revenue growth.Business Intelligence (BI) · Microsoft Power BI · Microsoft Azure · Microsoft SQL Server · Team Leadership · SQL Database Administration