Data Sap

FAISAL BASULEMAN

Summary of Qualifications

Mr. Basuleman has over 7 years of SAP experience working on high visibility

projects for public and private organizations. He has over 6 years of SAP

BI/BW experience in analysis, design, development and the implementation of

two full life cycles. Mr. Basuleman has experience working with

technologies of SAP Business Information Warehouse BW 3.5 and BI 7.0

(NetWeaver 2004s) for developing management and business applications. He

has worked extensively on Cognos Enterprise Planning for Business

Intelligence Development and Analytical Reporting as well as experience

working with clients in developing business requirements for Cognos Reports

in diverse enterprise environments. He has great knowledge of business

reporting tools including Workbooks, Query Designer, Business Explorer

(BEx) Cognos and designing and publishing queries on the web using Web

Application Designer (WAD). He has created business standard and custom

Data Sources, InfoSources, InfoCubes and Multi-providers and has worked

with both application specific extractions and OLTP/generic extractions. In

addition to his vast functional and technical experience, Mr. Basuleman is

also highly articulate in both oral and written communications. He is an

effective communicator and credible with all organizational levels, with

the specific ability to gain trust, creatively propose ideas, and

immediately and expertly resolve conflicts and concerns.

Professional History

Client: California Department of Water Resources (DWR), California

Role: SAP BW Solution Consultant

Duration: November 2008 to Present

Responsibilities:

. Government project: Market Redesign and Technology Upgrade (MRTU)

project as SAP BW Developer.

. Manage technical scope for BI objects and gather Functional

requirements for mapping.

. Develop and redesign the structures to extract the Data using DB

Connect Technology.

. Work on DataStage jobs conversions to DB connect as per the

requirement.

. Work with functional team for mapping the source data to the target

data source in BW for DB Connect Development

. Define the initial sizing requirements based on source data volume

estimate

. Conduct Functional Requirements gathering for water and Meter data

with end/business users.

. Perform Gap-analysis and identify deficiencies in current software

system.

. Mapping of Data elements, Data dictionary, custom Design of Info

objects, ODS, Info Cube.

. Develop the structures for extracting Water scheduling data,

Historical data and Master Data from legacy system (ACES) and State

Water Project Data (SWP) data from ECC system.

. Using DB Connect extracted the Audit scheduling, Water meter,

Historical, FERC and Master data from Legacy system to SAP BW.

. Resolve the data load issues in DataStage to SAP BW Development and

Quality Box.

. Monitor Data Stage jobs for the data coming into SAP BW landscape.

. Create transfer rules and update rules for newly developed structures

related to DB connect.

. Monitor the development of data model to satisfy the various

functional requirements by creating customized ODS objects and Info

Cubes for Audit and water scheduling data.

. Develop the process chains to automate the data load process.

. Resolve the issues related to data and fields which are not available

for extraction from Legacy system.

. Use TOAD tool to create views on Oracle side to extract the data in BW

using DB connect.

. Worked with Unix team to bring the required files from SAPFTP servers

to BW Application server.

. Develop the prototype and present the demo session for user

acceptance.

. Validate the data extracted using DataStage against data extracted

using DB connect.

. Mentor the team with both technical and functional understanding to

achieve the reporting task as per the requirement.

. Supporting the MRTU project activities.

Environment:

ECC 6.0, SAP NetWeaver 2004s BW 3.5, WAS 6.40/7.0, ABAP/4, Oracle,

Windows, Business Explorer Analyzer, Web Application Designer (WAD), Data

Stage

Client: Aruba Net Works, CA

Role: SAP BI Consultant

Duration: December 2007 to November 2008

Responsibilities:

. Defined and managed an integrated BI milestone plan.

. Managed technical scope for BI objects and gathered Functional

requirements for mapping.

. Responsible for Reporting to the Team Lead and Project Manager based

on assigned project and support activities. Worked closely with other

team members (Configuration, Development, ECC functional etc.)

. Effectively interacted with the Business community to gather/develop

requirements for projects, enhancements and identification of

problems.

. Worked with Executive Team to determine appropriate course of action

for Phase 1 of the project regarding scope and modules.

. Involved in preparation of Project Plan, Business Blueprint, Design,

and Development and facilitated the system for Final Preparation.

. Worked extensively on Finance (FI), Sales and Distribution (SD) and

Material Management (MM) modules as a part of the SAP BW Reporting

team. Other areas include Human Resources (HR) and Customer

Relationship Management (CRM).

. Master Data load for Customer Attributes Text and Hierarchy from ECC

and Flat files.

. Gathered and Mapped Sales Order Item attributes from CRM for BW

reporting purpose.

. Designed and developed/created InfoCubes, DSOs and DTPs.

. Activated necessary Standard Business Contents and used the required

standard queries

. Enhanced the Extractors to suit the requirements.

. Used LO and Generic extraction for extracting data from SAP and Non-

SAP Sources. Enhanced SAP extract structures using User Exit.

. Loaded Master and Transaction Data. Handled full, init and Delta

loading.

. Worked with BEx Tool to design and develop Queries and Reports.

. Developed highly customized analytical reports with Business Explorer

(BEx) Analyzer. Created and used Structures, Variables, Calculated Key

figures, and Restricted Key figures, RRI, Exceptions, Conditions and

Filters for user specific outcome.

. Designed and published reports on Web using Web Application Designer

(WAD). Involved in Documentation of Reports.

. Design the Ad hoc reports using Visual Composer tool and displayed the

result on portal for the users.

. Sent the events from Visual composer to Web Application Designer (WAD)

. Integrated SAP BI objects with Enterprise Portal, created views

assigned to roles and restricted to users for Security

. As part of team, involved in Designing Dashboard using Visual Composer

tool.

. Resolved various BW query performance and load performance to support

the implementation.

. Designed and configured Process Chains for entire BI load Process and

implemented email notification of load progress.

. Actively involved in preparing user and technical documentations.

. Analyzed the production support issues and searched the OSS notes to

fix the issues.

Environment:

ECC 6.0,SAP NetWeaver 2004s BI 7.0, WAS 6.40/7.0, ABAP/4, Oracle, Windows,

Business Explorer Analyzer, Web Application Designer (WAD), Visual Composer

Client: Amgen Inc, Thousand Oaks, CA

Role: SAP BW Analyst and Developer

Duration: December 2006 to November 2007

Responsibilities:

. Excellent administration through DW workbench. Involved in end to end

design and construction of BW objects.

. Conducted Requirements Gathering interviews and workshops with end

users.

. Performed Gap-analysis and identified deficiencies in current software

system.

. Mapping of Data elements, Data dictionary, Design of ODS, InfoCube,

and Multi Providers. Definition of key figures and characteristics.

Some areas are for FI (AR,AP,GL)

. Used BW Standard and Generic Extractors to fetch the data from ECC to

BW.

. Designed developed and modified InfoObjects, InfoCubes, ODS Objects,

DTP, Transformations, to suit the business requirements.

. Involved in the design and development of Infocubes for FI, FI-GL, FI-

SL, CO-PA, SD and MM modules.

. Implemented complex update rules and transfer rules.R/3 User exits for

transactional and master data attributes.

. Worked on data modeling. Worked on Infocubes such as 0FIAP_C02

(Account Payable), 0FIAP_C03 (Account Payable Line items), 0FIAR_C02

(Account Receivables), 0FIAR_C03 (Account Receivables Line Items),

0FIAR_C05 (Account Receivables Payment history) and developed custom

Infoproviders and ODS objects required for MIS to analyze data in

decision making.

. Migration of DataSources from 3.x to BI 7.0.

. Populated the Info Objects, ODS Objects and InfoCubes with Master data

and Transactional data from SAP R/3 via Data Staging area (PSA) by

creating InfoPackages.

. Involved in creating update rules and start routine. Designed and

developed technical architectural solution.

. Used Cognos query studio and PL/SQL queries to validate the data from

Legacy system.

. Worked with reporting team to generated reports in Cognos using Report

studio and designed queries on Query studio, BEX, Web query

development and Crystal reports from SAP BW as well as SAP R/3 for

presentable Dash Boards, Balance score cards etc.

. Developed enterprise IT strategic direction and able to influence IT

system decisions that are cost effective, supportable and scalable in

computing environment.

. Involved in creating MultiCubes, Infosets based on the requirements

and reporting on them using Cognos web reporting tool.

Environment:

BW 3.5/Netweaver BI 7.0, ECC 6.0 WAS 6.40/7.0, ABAP/4, Control M,

Windows, Business Explorer Analyzer, BEx Query Designer, Cognos

Client: Morrison Homes, GA

Role: SAP BW Analyst and Developer

Duration: February 2006 to November 2006

Responsibilities:

. Worked as a part of the new SAP BW (3.5) implementation team.

. Analyzed and mapped Business Processes to BW and involved in

blueprinting using ASAP methodology. Clarified the goal and defined

the Implementation Strategy.

. Key tasks included Designing, Data Modeling, Building, Extraction and

Loading (ETL). Also facilitated the reporting team by sharing

requisite information.

. Conducted Workshops to verify the participant's role and gathered end

user requirements.

. Analyzed and activated business content for Financial and Logistics

modules.

. Worked with SEM-BPS team to request PHEADER master data for Alignment

of Master data in BW

. Involved in Architecture of the Cubes in Order fulfillment (SD),

Procurement (MM), Finance (FI) and Controlling (CO).

. Worked with CO-PA and Standard Business Content Cubes for accounting

reports on Cost-Center and Profit Center.

. Developed InfoCube, MultiCube, ODSs, define DataSource and load R/3

data using extractors for Sales Order, Sales document, Billing,

Delivery, Materials, Purchasing, Orders, Customers, General Ledger,

Account Receivable, CCA plan and PCA plan.

. Involved in developing the Extractor program to get relevant data from

various R/3 tables. (VBAK, VBAP, VBEP, LIKP, LIPS, BSEG, BSIS, BSAD,

COEP, EKKO, EKPO etc.)

. Scheduled and monitored Daily/Weekly/Monthly data loads to InfoCubes

and ODS-objects through process chains. Involved in setting up on Full

and Delta Loads for SD Business Content and Custom Data.

. Worked with trouble-shooting for data integrity problems, monitor load

performance, tuning and optimization.

. Widespread use of ABAP/4 programming skills for numerous enhancements,

Start routines, Update rules and Transfer rules.

Environment:

SAP R/3 4.7, ECC 5.0 SAP BW 3.5, ABAP/4, Oracle, Windows, Business Explorer

Analyzer, Test Director

Client: The Schwan Food Company, Marshall, MN

Role: SAP BW Consultant for Front-end Development

Duration: August 2005 - February 2006

Responsibilities:

. Conducted workshops and presentations to congregate and match

requirements of end users with BW / Business Objects solutions.

. Wrote several reports in FIAR, custom Billing cube, backorder cube,

orders ODS and custom Purchasing ODS using BEx and modified several

BEx front-end reports to suit the user requirements, by creating

various Structures, hierarchies, variables, filters, restricted key

figures and calculated key figures.

. Built many workbooks for Legal, Management and Users.

. Used RRI jump queries using the transaction RSBBS for drill down to

other queries and R/3 transactions. Mentored the BW users in handling

BEx analyzer and browser.

. Extensive use of MS Excel for designing specific patterned reports

using formulas, cross-cell referencing, conditional formatting and VBA

macros.

. Worked with Web Application Designer to modify and create Client

headers and attach input variables to display vital information like

name of the decision makers of the report, time when cube was last

updated, region being viewed etc.

. Worked with Query performance (RSRT Transaction) to look up the

performance efficiency of the queries.

. Ensured appropriate security for the generated query.

. Trained the production support team and super users and prepared

necessary documentation of the whole process.

Environment: SAP R/3 4.6C, & 4.7 SAP BW 3.5, InfoSet Query, ABAP/4,

Oracle, Windows, MS Excel, BEx (Business Explorer) Analyzer

Client: Carvnet Inc., Duluth, GA

Role: SAP BW Techno-Functional Consultant

Duration: January 2005 - July 2005

Responsibilities:

. Worked as one of the Key Developers for Designing and Data Modelling

by creating Data mart from the data warehouse using Star Schema.

. Coordinated the work of 2 other consultants in the team to achieve

effective and speedy completion of work process.

. Created Multi-Providers to extract data from Multiple Data Targets for

providing information to the queries for Sales/Billing Reporting.

. Heavily involved in customizing and activating standard delivered BW

business contents in the areas of Sales and Distribution,

Profitability Analysis, Account Receivable and Account Payable.

. Identified the tables for generating the custom data sources that are

to be utilized as InfoSource on BW for custom reporting. This process

involved identifying the R/3 reports and underlying tables to

implement the same reports in BW.

. Developed custom queries for user specifications. Created variables

and associated user exits to assign the default values such as sales

organization and purchase organization.

. Modified the User exit programs to accommodate the additional fields

in the extract structure of the DataSource with ABAP.

. Advised delta loading and ODS Loading process. Performed Delta repairs

whenever required.

. Provided the knowledge transfer to the client team. Developed best

business practices in terms of system architecture and system

deployment in multi-system landscape.

. Provided support in pre-production and production mode.

. Managed and monitored several data loadings, captured the errors and

corrected the bugs and applied several OSS notes for the errors

encountered while loading the data.

. Involved in Pre-Validation testing.

Environment:

SAP R/3 4.6, SAP BW 3.1 c, ABAP/4, Oracle, Windows NT

Client: Moen, OH

Role: SAP BW Consultant

Duration: June 2004 - December 2004

Responsibilities:

. Analyzed the requirements and met with Project leads and end users

regularly and communicated the applications and extent of

customizations required for reports.

. Performed GAP analysis on the metrics available in the report and the

requirements and contributed valuable inputs for reconciliation.

. Suggested changes in the project design of several BW Projects to

incorporate Enterprise data warehouse model to reduce redundancy in

data extracts from R/3 and external systems.

. Prepared Business Change Requests for bridging the gaps between

reports available and requirements specified.

. Checked the credibility of the metrics involved in key figure creation

in reports to authenticate the purpose of the reports.

. Assessed and solely designed a Client Master Data reports to identify

duplicate DUNS numbers, among all other reports.

. Designed and formatted BEx reports, web based reports and also

published reports on the web.

. Created ODS as a part of interface work with required fields to run

reports to be used as input for legacy systems.

. Handled formatting of high priority reports like decision maker's

dashboard reports and published them into roles.

. Created formulas, structures and conditions to achieve desired results

in the reports.

. Solved Technical Problem Reports (TPRs) consisting of critical, high

and medium priority within a turn over time of 24 hours during the

testing phase.

. Identified reporting and loading issues while solving TPR's.

Environment:

SAP BW 3.1c, SAP R/3 4.6c, BEx Analyzer/ Browser/Web Application Designer,

and Windows XP.

Client: KBR, Houston

Role: SAP BW Consultant

Duration: March 2004 - June 2004

Responsibilities:

. Product architecture involved custom InfoSources, InfoCubes and ODS,

as well as enhancement of SAP standard Business Content.

. Supported the entire process from data loading, transformation, data

integration, consolidation, and cleansing to data provision for the

analysis and interpretation of consistent information.

. Carried out Initialization of Transaction data on OLTP side.

. Activated, changed and created business warehouse components,

InfoObjects, InfoSources, Update rules, Transfer rules, and InfoCubes

for loading data.

. Designed (custom) and implemented the monitoring and notification

mechanism for daily data loads. In this process used SAP events,

triggers and external e-mail mechanism to report the load status.

. Transported objects across the landscape from Development to QA and to

Production environments. Worked extensively with transport management

system to transport Workbench objects and BEX objects.

. Planned and executed Unit, Integration tests and Upgrade tests.

Involved in designing User Acceptance Tests and Procedures.

. Validated data in BW Data targets against R/3 to identify missing data

and corrected them.

Environment:

SAP B/W 3.0b 3.1, SAP R/3 4.6

Client: Essar Global Group, India

Role: BW Consultant - Data Maintenance and Data Modeling

Duration: September 2003 - January 2004

Responsibilities:

. Project deals with technical support of SAP Business Information

Warehouse. As an SAP BW consultant involved in the designing of custom

CUBE and ODS for Material management and data maintenance in PSA area.

. Customized the business content to suit the Company's specifications.

. Analyzed, designed and created several extract structures, InfoSources

in Logistics.

. Involved in the extraction of data for Material Management from SAP

R/3 system.

. Custom designed and implemented a monitoring and notification

mechanism for data load.

. Designed and created BW components to load the historical data via

flat files.

. Used Start Routines for data manipulation in transfer/ update rules,

created Update rules.

. Responsible for design and development and extraction from R/3 Source

system and Flat file to BW.

. Developed various data extraction procedures for master data (full and

delta load), for attributes, texts and hierarchies and transactional

data (full and delta) using LO Cockpit and generic extractors for

customer-defined tables.

. Defined new update rules, changed existing update rules for SD, FI-AP

Info cubes

. Created Process chains for effective scheduling of various processes.

. Worked closely with the functional consultants in providing functional

specifications to enhance the current objects and developed new ODS

(MM) and InfoCubes (MM).

. Involved in multiple drill-through reports from BEx Queries and worked

extensively with restricted key figures, calculated key figures and

variables to implement various reporting needs.

. Actively involved in preparing user and technical documentations.

Client: T System India Pvt Ltd, Pune, India

Role: SAP ABAP Consultant

Duration: January 2002 - August 2003

Responsibilities:

. Contributed from the Realization Phase to Go-live as an ABAP/4

Consultant.

. Uploaded Material master-consumption, Pricing, and Purchase

information records from legacy system to R/3.

. Involved in Dialog Programming, Data Dictionary, Table Maintenance

Generator, Function Groups, Area Menus and assignment of Area menus to

roles. Developed Bank Guarantee Alert Program in FI Module involving

Dialog Programming.

. Developed Function Exits, Customized standard Scripts.

. Source Code corrections to enable certain customized Transactions.

. Created missing quantity list that gives the difference between Sent

and Received Quantities during stock transfer.

. Created report for tracking the items that has to be disposed based on

manufacturing date and Shelf period. Created Report presenting Raw

Material consumption with respect to production. Report for Rejected

Materials. Reports to show Raw Materials Issued & Received. Created

sales order report, which covers all organization levels, delivery

status, invoice status, shipping details and partner function details.

. Designed and developed a Price Deviation Report to List Item Price vs.

Material loaded price to identify order and order line. Prepared Sales

lead report to monitor sales prospects for daily sales analysis. Day

billed report prepared to monitor revenue for daily bill contracts.

Environment:

SAP/ABAP 4.5B

Client: Academic Project in Digital Libraries

Role: Developer

Duration: August 2001 - November 2001

Mathematics and Computer Science Department.

University of Osnabrueck, Germany.

Responsibilities:

. Designed and developed prototype for browsing scientific research

papers.

. Created various services in Digital Libraries.

. Developed web pages for Digital Libraries for subject based browsing

using DDC Classification.

. Used Open Archive Initiative Protocol for Metadata Harvesting.

Environment:

PHP, MySQL, Apache Server on Unix Platform

GLink PROJECT

Role: Perl Programmer

Duration: April 2001 - July 2001

Mathematics and Computer Science Department.

University of Osnabrueck, Germany.

. Developed mathematical web portal www.mathematik-21.de funded by

German Federal Ministry of Education and Research (BMBF).

. Parse the RDF pages of projects and link the terms defined in the

projects' glossary.

. Techniques used were developing and implementing Stemming Algorithm

with Scripting in Perl and Java

Technical Skills

Operating System Microsoft Windows NT, 2000, 2000 Server, 2003 Server,

XP,Vista

Language ABAP/4, C/C++, Perl, PHP

Datawarehouse SAP BW 3.X - 7.0

ERP ECC,SAP R/3 4.5B/4.6C, SAP R/3 Enterprise 4.7

Reporting Tool BEx Analyzer, Query Designer, Web Application

Designer, Cognos tool set, Crystal reports

Web Development HTML/DHTML, XML, RDF/S, OWL, CSS

Databases & Tools: Oracle 8/9i/10g, MS ACCESS, MS SQL Server

7.0/2000/2005

Web Server WAS 6.20/6.40/7.0

Methodologies ASAP

Platform Client - Server, NetWeaver (NW '04s)

Testing Test Director

Others Microsoft Office applications, Visio 2000/2003, MS

Front Page 2000/2003, PSpice, Dreamweaver 8

Additional Skill: Good working knowledge of German Language.

Education

MSc Computer Science, from Osnabrueck University - Germany

Contact this candidate