Shahzeb Farrukh

**** *** *** ***** ******* Estate, IL 60192

Email : wlyvcy@r.postjobfree.com Cell Phone: 847-***-****

________________________________________________________________________________________________________________________________________________

EDUCATION

• Lahore University of Management and Sciences (LUMS) June 2010

B.Sc. (Honors), Computer Engineering

PROFESSIONAL EXPERIENCE

K.E.S.C June 2010-Present

SAP Business Intelligence Architect

(Electric Utility Company with 2.2+ million customers, 18000+ employees, Eight Generation Plants)

SAP BI/BW

• Implemented One complete life cycle of SAP BI/BW which included gathering business requirements, analyzing the business process, designing, configuring and customizing the business warehouse, unit/integration testing, go-live and post-go-live support in SAP IS-U (FICA, Billing, DM, EDM, CS) and SAP CRM functional areas

• Conducting ETL process with data loading from non-SAP source system; Oracle Legacy Billing Application, for Data Modeling using BW Extended Star Schema, with EDW layer in SAP BW 7.0 for various analyses

• Developing, Scheduling and Administering process chains in SAP BW

• Managing and maintaining user roles and authorization groups in the SAP BW for BEx Reporting

• Working with OLAP reporting in BW and the implementation of BEx Analyzer for developing reports, analysis, and Web reporting.

• Developing Queries using BEx Query Designer, using Calculated and Restricted key figures, Structures, Variables, Exceptions, Conditions, RRI, Web reporting and Workbooks.

• Debugging Data loads and Process Chain errors. Monitoring, Maintaining and Scheduling Delta Queues, PSA Tables, Master Data and ISU-BW Mass runs

• Conducting Power user training sessions for SAP BW, BEx Analyzer and Bex Query Designer

Enterprise Portal

• Configuring SAP Enterprise Portal for the first time at KESC and providing access to BW reports via BEx Web Analyzer

• Developing and deploying BI dashboards through Visual Composer for MM, FI, and CO

QlikView

• Setting up QlikView at KESC including installation and configuration of QlikView 10 Server, Web Client and Desktop Client

• Designing and developing executive dashboards in Qlikview 10, following the two tier architecture, for the top management with data sources from SAP, Oracle and Flat Files, using the SAP Connector and the ODBC Oracle driver.

• Extensively interacting with end users for gathering KPIs and business reporting requirements

SOFTWARE TOOLS:

• SAP BW/BI 3.5 and 7.0

• SAP Business Explorer (BEx)

• SAP Enterprise Portal

• Visual Composer

• SAP ABAP

• QlikView 10 (Server and Desktop Client)

• Oracle PL/SQL

• Programming skills in Java, C++, C, SQL

ADDITIONAL SKILLS AND EXPERIENCE

• President of the Music Society at LUMS. Key responsibilities: 2009-2010

- Managed and trained a team of 20 working members

- Built corporate relationships with various companies and acquired sponsorships for society activities (such as concerts, setting up a studio etc)

• Information systems coordinator for AIESEC, an international student organization 2008-2009

Contact this candidate