Data Project

KHURAM HAYAT

Mobile: 267-***-****

Email: ************@*****.***

Career Objective:

Having 3 years of experience in SAP BW3.5 & BW7.0.

Expert level knowledge on SAP BW 7.3, Statistics, Microsoft Office

Good working knowledge on SAP BUISSNESS OBJECT 4.X, INFORMATICA

Knowledge on SAP Modules like PM, SD, MM & SD etc.

Team player and self starter with professional attitude, excellent analytical and

Communication skills

Professional Summary:

Having 3 yrs. of experience as an SAP BI/BW Consultant and Developer.

Strong expertise in Statistics usage and implementation both in SAP BI and SAS.

Strong Experience in interfacing with customers gathering requirements, Business Requirements and

Business Process, documentation and training.

Experience with implementation, configuration and solving of module level issues in data extraction from

FICO, FI SL, CO PA, SD & MM etc.

Expert level knowledge in working with different types of extractors like generic extractors, LO Cockpit,

functional modules, database views, flat files, XML.

Having good fundamental understand of Back end BW concepts. exploring the details of background of BW

which Involves Dialog Processes, Background jobs, IDocs, RFC Connections, tables used, events, etc.

Experience in planning, designing, implementing and upgrading InfoCubes, DSO objects, Transfer structure,

Transfer rules, DTPs, Update rules start/end routines and Info packages.

Knowledge on Performance tuning for Improving data loading and query performance by maintaining

Aggregates, Compression, Partitioning (physical and logical), Indexing of Info Cubes.

Expertise in Remodeling, Repartitioning and upgrading from BW3.x to BI7.2.

Created Queries with complex Filters, Exceptions and conditions, Variables, Restricted Key Figures and

Calculated Key Figures.

Good experience in Process Chains development to automate loading of Transactional and Master data in

background and managing events/emails in case of errors.

Experience in both Manual and Automated Testing. Testing done with scripting, data variations, regression

testing, etc.

Creation, Execution and Review of test cases as per the Functional Requirement

Experience in life cycle management.

Good working knowledge of SQL and basic working understanding of ABAP.

As part of Run and Maintain Project Strong Experience to monitor Process Chains running on daily, weekly

and monthly basis which executed data loads from various R/3 Systems and fixing any kind of issue related

data loads

Having good Knowledge in Informatica Power Center suite to pull and push data from ETL to BW.

Good knowledge on report development, formatting of report etc.

Created reports like Inventory and Sales etc.

Having good knowledge on Creating Universe from various sources like SAP BW, SQL Server, and Oracle

etc.

Ability to handle multiple tasks simultaneously and switch between tasks quickly

Communication skills to communicate with application developers, customers, support personnel and

management

Having Experience in Analytical, problem solving, creative thinking and design skills at multiple product

Ability to work independently and as part of a team

Work Experience:

Working as a SAP BW Consultant with ERP Workforce, Inc. from Mar 2012 till July 2013.

Working as SAP BW Developer with Accenture from Oct 2013 till (currently Employed)

Technical Skills:

Technical : SAP BW 3.5 and SAP BW 7.0, SAP R/3, Informatica

Functional: SAP SD, MM

Reporting tools: SAP BEx,

Languages : ABAP/4, C

RDBMS : ORACLE 9i/10g

Operating Systems : WINDOWS 7,8/2000/XP

Other Applications : Ms Excel, PowerPoint, Word

Project #1

Project Title : BI/BO Implementation

Client Name :EBSCO Industries, Inc.

Environment :SAP ECC 6, SAP BI 7.0, Business Objects 4.0

Duration :Mar’ 2012 till July 2013

Description:

EBSCO is medium sized very diversifies business. The main business is related to printing and publishing or

traditional and electronic media but the business span through construction equipment and carpet industries to

import and export or various manufacturing equipment. A lot of the business units were acquired over period of

time and hence run on very customized heterogeneous environment. Management decided to implement SAP

and SAP BI to consolidate the business into a central environment. The BI7.2 implementation required a lot of

custom extracts due to over 30 business units with custom data feeds to ECC. Some of the library and publishing

functions as well as publisher clearing business is not ECC based and data was extracted directly from various

tables and systems.

Project involved about implementation and enhancements to the business contents as well as custom extractions

and storage objects. Data was fetched in from ECC, legacy systems database tables and custom data sources

such as flat files and XML. Data from various company codes was transformed and loaded in consolidated DSOs

and InfoCubes. BEx reports were created and tested for accuracy. BusinessObjects (Webi & Crystal) was the

choice of final reporting tool.

Roles and Responsibilities:

Involved in design and development of objects like InfoCubes, DSOs, DTPs, Transformation &

Multiproviders.

Exposure to large and complex data loads with Process Chains running on daily and weekly basis in BI

7.0 system.

Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI Involved in Initializing

the LO Data source by Activating the Business Content Data Sources, Maintaining the Extract Structure,

Generating the Data Source.

Implemented Performance Tuning measures like Aggregates, Compression, Partition (Logical and

Physical) & Indexes.

Enhanced the Data source by using enhancement to fill the data into the fields newly enhanced.

Worked on BEx Query Designer in designing queries using Columns, Rows and detailed drill down data

analysis to required level of information. Created Restricted Key figures and complex Calculated Key

Figures per client’s requirement.

TRIOLE is a tool to create an incident on data load issues and users can also raise an incident for non

availability of data in the reporting area.

Involved in frequent client meetings to discuss project status.

Followed ASAP Methodology for project management.

Client training and support after Go Live.

Project #2

Project Title : SAP BW Developer

Client Name : DuPont

Environment: 6 SAP R/3 Source Systems, legacy Systems, SAP BW 3.5, Informatica

Duration :Oct’ 2013 and December 2014

Description:

DuPont is an American chemical company that was founded in July 1802. DuPont was the world's third largest

chemical company based on market capitalization and ninth based on revenue in 2012. It develops many

polymers, synthetic pigments and paints etc.

The BW 3.5 implementation required a lot of custom extracts due to over 30 business units with custom data

feeds to 6 SAP R/3 source systems.

Project involved about implementation and enhancements to the business contents as well as custom extractions

and storage objects. Data was fetched in from R/3 Systems, legacy systems database tables and custom data

sources such as flat files and XML. Data from various company codes was transformed and loaded in

consolidated DSOs and InfoCubes. BEx reports were created and tested for accuracy. Business Objects (Webi &

Crystal) was the choice of final reporting tool.

Roles and Responsibilities:

Have Experienced in Software Development Lifecycle includes, implementation, testing and deployment, user

support and training.

Creating and implementing technical unit tests for BI developed objects.

Supporting BIT and USAT Testing – including data loads and defect resolution

Creating successful transports to migrate objects to integration and production environments

Validating BI environments after BI environment builds/copies

Applying application specific BI OSS notes and BI application fixes

Analyzing and addressing basic defects or enhancement requests

Following appropriate work processes and applying DuPont CSAP standards in their work

Ensuring compliance with quality control processes required for development.

IBM LOTUS NOTE is a tool to create an incident on data load issues and users can also raise an incident for

non availability of data in the reporting area.

Experience with the use of problem tracking tool BMC remedy User

Involved in frequent client meetings to discuss project status.

Client training and support after Go Live.

Contact this candidate