Wamiq Haq

SKYPID:WamiqHaq, Email:ac5a7b@r.postjobfree.com, M:+1-647-***-****

Project Manager Data warehouse (EPM) •BWBI/BPC/BOBJ Architect • Business Analyst

PROFILE

Extensive experience in business intelligence, analytics, budgeting and consolidation demonstrated through SAP BI, SAP BOBJ/BODS, SAP BPC.

As EPM ( Enterprise Performance Management) lead I have successfully completed multiple project life cycles across manufacturing (SAP ECC) and energy (SAP ISU) sectors; demonstrating skill in project leadership, functional analysis, gap identification, functional design, quality assurance, maintenance, training and development.

Accomplished, dedicated and results driven Information Technology expert with 15+ years diverse experience in Network/SAP BWBI/BPC/BOBJ/BODS designing and implementation, technical analysis, network and database administration, tier 3 trouble shooting, team building and training. Strategic and analytical thinker with exceptional, project management, organizational and communication skills recognized as inspirational leader and motivator having exceptional rapport with clients, stakeholders, management and peers.

•Delivered based on technology agnostic but based on corporate culture and customer centric needs.

•Strong ability to establish relationships at all levels of complex organizations

•Extensive experience in technical support, server and workstation setup and installation, backup administration and user administration

•Strong Customer focus and dedication to quality management and process improvements

Strong ability to deliver on tight schedules and exceeding expectations

PROJECTS

City Of Toronto

SAP Sr.BW/BOBJ Consultant Mar 17–Mar 2018

Developed HR Work Force Dashboards for Age, Tenure, Hires and Exits using Xcelsius 4.1/4.2,BW 7.3/Hana, Design Studio, Lumira

Design and Developed HR Work Force Dashboards for 4 topics Age, Tenure, Hires and Exits out of 14

Worked with Business to understand requirement as per functional spec

Developed Mock-up design and architecture for Xcelsius/DesignStudio and BW/Hana

Source data identification and collection

Hana Modeling and structuring, Calculated views

Hana SDI for integration

Hana SDA for virtual tables

Bex Queries

Identification of design and data issues

Resolving data and design issues

Implementation of Authorization relevant org prompts and incorporating in frontend queries

Steering committee meetings for progress reports, identification of issues resolutions and delays if any

Cutover from dev to QA

Defect resolution

KT documentation and training for sustainment team

National Foods (Pvt.Ltd) FMCG August16-19-2016

BWBI Training

Budget: $8000

Modules: SAP BW7.4/BO 4.0 Tools

4 days Training of 5 participants on BWBI/BODS

DB concepts

HANA Data Modeling and Structure design, Extraction of Data Via BODS for reporting

ETL from Flat file and SAP ECC source systems

Work Bench navigation and usage

BOBJ reporting tools introduction

Working on IDT and Universe design tool

National Foods (Pvt.Ltd) FMCG April 2014-Ongoing SAP BWBI/BPC/BWIP/BOBJ-BODS on HANA Project Consultant

Budget: Open

Modules: SAP BW7.0/7.3/7.4/7.5, SAP BPC10.1 SAP ECC 6.0

Architecture designing and implementation of HANA and HANA sourced BPC/BW/BO

Project planning, Information gathering, gap analysis, reporting requirements, implementation requirements (HANA,BIBW,BO)

Historical and Transactional report planning with data integration from multi source with ETL process design

BPC/BW IP Consolidation, planning, budgeting and formulation, forecasting of sales/customer data from its operations, FP & A, PNL, Balance sheet, cash Flow Functional Budget, requirement gathering for sales discount & Promotions (trade promotions) TPM considering Intercompany Non-Competitive & Re sale Minus Transactions, trading partner, budget, Monthly forecasting (SOP), Roll-Forward Logic, domestic and export net/cost of sales & distribution expenses, audit trails

BPC Data Model designing capturing profitability and cost components using profit and cost centers, CO-PA, PCM

BPC Consolidation and reporting includes gather all information, applied business rules, journal entries and validation, reconcile/eliminate intercompany matching

Business warehouse analysis and design as per ASAP methodology

BODS reporting using HANA source system

FMCG department analysis for BW data and reporting and usage of BW IP for General Ledger and Plan data (Balance sheet and profit loss), actual and plan data for Profitability Analysis.

Blueprinting and documentation for standard KPI’s

Data mining and table identification

ETL from ECC, Error handling and traceability, Data cleansing

Development of FRD’s, SOP’s, development of complete architecture/documentation

Customized HANA Data Modeling /BW structure and BOBJ reporting (Cost tracker report, Stock availability report BOM level) using ABAP, Pl/SQL, SQL

Team building

Working closely with BI/BPC managers and teams to deliver and plan for existing and new reporting technologies and way forward

NEEDS(ElectricDULiban/EDL)Lebanon/KVA/BUTECH June 2013-Jan 2014

SAP BI/BPC/BW IP/BO-BODS Consultant

Budget: $1.5 million

Modules: SAP ECC 6.0, BI/BO Edge BODS

Provided consultancy on 3DSP(Distribution Service Provider Integration) with EDL

Initialized project as per ASAP methodology

BW/BO infrastructure/modeling and team building from ground up

Setup and Configuration of servers with complete implementation

Special focus on ISU KPI’s Programs, Asset Management, Construction of Distribution Facilities, AMI Metering, Customer Services, Reporting and Management (PM,CM,AM)

Developed Reports/Dashboards as per KPI’s (SAFI,SADI, Feeder utilization, Distributer transformer utilization, Distribution system total loss, Average time to make an electricity connection, percentage of maintenance completed, Customer complaints, Average time to respond to complaints, work completed on time, Capital expenditure per MW of internal annual peak demand)

Designed multiple reports to cover management reporting

Developed reports for different SAP modules

Developed KPI based queries, Documentation

Complete FRD, RFP’s, SOP’s and handing over documentation

Advance ABAP concepts,functional modules.

Designed complete BW/BODS structure to ETL/Transformation- Error handling/resolution and monitoring/Scheduling and dashboards/document level reporting with what if analysis via BOBJ tools

Universe design for Ad-hoc reporting, working with IDT

Maintaining project time lines and complete updates to Steering Committee with transparency

Cloud Business Intelligence as A Service (BIAS) Client: BIAS, North America Sep 2012-Ongoing Environment

Solution Architect and Managing Consultant

Budget: Open

Modules: SAP Business Objects 4.0 SP4, Dashboard Design, Amazon Cloud Business Warehouse: SAP BW, Oracle, MS SQL

Designed and developed industry specific data models, management dashboards and reports for: Utilities, Retail, Education, Professional Services, Manufacturing, Hi-Tech, and Healthcare.

Built forecast applications with SAP Business objects to actively forecast and save custom results for future use and broadcasting.

Build dashboards with facility to comment on results and broadcast to other members.

Developed Executive dashboards using Latest SAP BusinessObjects 4.0 Tools.

Developed Web intelligence (Ad-Hoc) reports specifically for mobile viewing.

Incorporate and customize dashboards and reports using HTML5 technology to produce output on Mobile devices like I phones, I pads, Tablets and smart phones.

Deploy developed content on Amazon Server. Using Cloud technology and tools.

SAP BPC implementation Client: FFC (Fauji Fertilizers Company) Mar 2012-Sep 2012

SAP BPC Consultant

Modules: SAP BI 7.0, SAP Business Objects, ECC 6.0, Enterprise Portal Business Warehouse, BPC10 SP 15

Conducted Requirement Workshops with key stakeholders

Identified and structured BPC core team

Structured and designed complete BPC consolidation and reporting involving P&L, Cash flow, Forecasting sales and trade promotions, cost analysis and mismatching

Creation and customization of project plan Delivered SAP BPC user trainings

Streamline and document client’s implementation strategy Mapping legacy maintenance budgeting scenarios to BPC

SAP BusinessObjects 4.0 implementation

Client: FFC (Fauji Fertilizers Company) Sep 2011-Mar 2012

Business Objects Architect / Managing Consultant

Environment: SAP BI 7.0, ECC 6.0, Enterprise Portal Business Warehouse: SAP BW 7.0

Presentation Work shops guiding user on the role of particular BOBJ tools in a SAP landscape

Used BODS for direct source reporting

Power user training on WEBI report designer and Xcelsius

3Day Special KPI Gathering training for Xcelisus

Installation of BO Edge environment with Oracle64bit

SAP integration configuration with BOE

Configured reverse proxy server for access to system from live IP

Configured SAP single sign on, on BOE Handled logic built into BI calculated keyfigures within the QAAWSscope

Designed real-time ABAP FM Web Services directly on ECC environment and consumed in Xcelsius.

Designed dashboards for top management users, covering major analytic/score card scenarios.

End user navigation and design manuals Dashboard Performance optimization through data scheduling and staging

SAP NetWeaver BI Upgrade + Business Objects BI Implementation

Client: NFL (National Foods Limited) Dec 2010-Aug 2011

Environment: ECC6.0

SAP BI/BO Track Lead

Prepared and delivered presentations to convey SAPBI/BOBJ-BODS Road Map

Reviewed existing BI implementation and presented work estimate document for individual functional areas

Drafted and presented proposed implementation plan.

Delivered a comprehensive scope document against 40 analytic requirements from the client across FI, CO, COPA, MM, PP, PM and PS modules

Remotely managed onsite delivery team.

Successfully reviewed and conducted unit testing for multiple BOBJ reports.

Audited BO universe scheduling and under lying BI process chains.

Sent out regular project and resource status updates to central PMO

SAP NetWeaver BI Implementation

Client: Karachi Electric Supply Company (KESC) Mar 2010-Aug 2010

Environment: SAP BI 7.0, ISU 4.72, CRM 6.0, ECC 6.0

SAP BI Team Lead

Designed and managed a full BI project plan / Road Map

Held work shops to identify functional stakeholders and structure BI core team

Presented business intelligence concepts in contrast to OLTP requirements to business users

Held session on utility industry KPIs

Activated complete SAP BI standard content scenarios relevant to utilities to ensure that the proposed solution has no issues once report building is started

Created test scripts to stress test BI data loading and warehousing abilities for IS-Udata

Configuration of source systems in the BI server to connect to IS-U/CRM

Activation of BI 7.04 content on SAP-ISU and CRM servers

Activation and Installation of BI Content on BI Servers

Change Control Board Compliance

Managed master data for more then 2.8million customers and devices

Extraction of Delta Sources for Billing and FICA using specialized mass delta runs

Enhancement of Extract Structures on the source systems

IMG preparation activities on ISU and CRM to extract data to BI

Extraction of dummy data into BI Info providers(Info Cubes/DSOs)

Multiple integration testing and mock run exercises before final deployment

Process chain maintenance for complete ISU scope

Designed complex ABAP triggered process chains for near real time capability

PROFESIONAL EXPERIENCE

Head Of BI (SAP BI/BO- ISU Track Lead) Virtual Matrix Synergies Pvt.Ltd. Dec 2007-Jan2014

Pre-Sales - Project Management/Lead authority on technical business intelligence project delivery

Technical delivery of BI solutions on cloud platform

Manage prototype / demo design for business development.

Member of central management/quality assurance Committee

Provide structure and training to Analysis Bridge technical resources pool

Architect business intelligence solution for clients

Design and manage proprietary “rapid-bridge” BI Solution

Vertical technical lead for SAP BI/BO-BODS implementations.

Centrally manage all ongoing BI projects.

Architect and document BI solutions specific to client requirements.

Technical delivery of SAP BI / BO solutions.

Develop business development collateral for presales.

Conduct client and employee trainings

Build and conduct technical presentations.

Network Team Lead EPS (Enterprise Platform Support-Networking) Microsoft Canada VMC/VOlt Toronto, Canada Dec 2003-June 2007

Tier 3 level Microsoft Network Support for Americas, Analytical and problem solver, think outside the box

Lead team of 15 SE’s, point of escalation

Training and mentoring; conducting triages, CVG India convergence

Conduct workshops / trainings for internal and external audiences

Conduct MS health assessment-Error handling, analytical resolution of issues for clients and prospects.

Tech Lead DB/WEB servers WES Agilent Technologies USA SanJose, CA Dec 2000-Mar 2003

Management of Microsoft WEB IIS servers with over 3000 internal websites/DB servers

Provide support to internal customers

Lead consultant for internal projects

SKILL SET

SAP Business Intelligence (BW)

Data Warehouse Design

Requirement Workshops

Data Modeling

Development Standards

Business Content Usage

Blueprint Documentation

ETL & Development

Generic / functional module data sources(DS)

LO and CMOD enhancements

Custom BI InfoProvider

Transformations/DTPs

ABAP routines ( Transformation / Expert)

Process Chains

Custom BI Authorizations

Performance Tuning

Deployed BI Technical Content

Reporting & Planning

Integrated Planning Apps

Query Designer

Bex Analyzer / Bex Web

Visual Composer

SAP BOBJ – Business Intelligence

Universe Designer

Designed Universes on top of SAP BI Query / Info cube.

Query As A Web Service(QAAWS)

Built multiple QAAWSs

WEB Intelligence

Reports for different subject areas

Extensive use of Drill down functionality

Crystal Dashboard(Xcelsius)

Designed (Forecast/Trend) dashboards based on LiveOffice and QAAWS

Export to SAP NetWeaver Portal

Explorer(Polestar)

Generated and indexed multiple InfoSpaces from different areas.

Design Studio

Designed Dashboards

CSS

Bail

Administration

Setup BOE 4.0 with 64bit Oracle

Reverse Proxy setup

Integration with SAP BI,ECC, Portal

SAP BO - Business Planning and Consolidation

Application Design

Business process review and improvement

Forecasting & budgeting analysis

Workshops for training and facilitation

Solution Prototype and Blueprint.

Application Development

“Application” design & maintain Dimensions.

Dynamic Template creation

Built Input Schedules

Maintained Transformation / Conversion files

Imported data from flat file and SAP BI.

Designed Business Process Flow and work status configuration

Script Logic / BADI enhancements

Reporting

Multi level drill down reports

Dynamic / EVDRE Reports

SPECIALITIES

Five years of SAP experience in multiple full cycle implementations and one technical upgrade project in more than 5 different businesses

Cloud Solution design for “BI as a Service” based on SAP Business objects 4(BOBJ), Mobile intelligence and Amazon Elastic Cloud.

Implementation experience on SAP Business Intelligence and BOBJ Business Intelligence tools encompassing Xcelsius, Web Intelligence, Crystal Reports and Desktop Intelligence and Explorer

SAP HANA trained; developed prototype solution for international demo.

Management Dashboards ( Desktops ) via SAP NetWeaver Portal and Visual Composer and Xcelsius (Crystal Dashboard)

Integration expertise in NetWeaver Portal, SAP BI, backend systems

and SAP Business Objects platform, using BOBJ Data Services platform.

Comprehensive implementation experience for planning and consolidation using SAP BPC ( Unified Planning and Consolidation) 7.5

Coaching and mentoring – I take great pride in leading a team through complex projects, motivating them to perform, providing direction and ultimately delivering results above expectations.

Roles Handled:

SAP BI/BOBJ Vertical(track) Lead

SAP BPC Consultant

SAP BI/BOBJ team lead

SAP BW Consultant

SAP Version worked on:

SAP BPC 10

SAP BOBJ Enterprise 4.0 SP4

SAP HANA 1.0 SP2

SAP BO Edge 4.1

SAP BI 7.3/7.4

SAP ECC 6.0

SAP R/3

SAP IS-Utilities

SAP Data Services 4.0

Types of project handled:

End-to-End implementation

Functional Upgrade

Technical Upgrade

Support

TRAINING

Course Name

Duration

Medium

Trainer

SAP NetWeaver BI 7.0 Certified

30 Days

Instructor Lead Classroom

Siemens Pakistan

SAP Unified Planning and Consolidation (BPC) 10NW

40+ hrs

Online Instructor

HOWTODO

SAP Business Planning and Consolidation (BPC) 7.5NW

48 hrs

Instructor Lead Classroom

SAP/CPM

SAP Business Objects BI 4.0

40+ hrs

Online Instructor

Online Expert

SAP HANA – In Memory Appliance 1.0(TZHANA )

SAP HANA – Implementation & Modeling( TZH300)

30+ hrs

Online Instructor

Online Expert

MCSE Certified

CCNA Certified

Education

Bsc.(Hons 1999

B.Com……… 2010

Contact this candidate