Data Sales

SYED ABDUL MAJID

TEL # 832-***-****

E .mail *******@*****.***

CAREER OVERVIEW:

To obtain a challenging Position as a SAP BW/BI Consultant where my education

and work experience will have a valuable application.

SUMMARY:

Over 5 years of Professional experience in Design Development and Implementation of

Business applications it includes SAP BW/BI NET WEAVER 7.0 / BW 3.5 / 7.3 / 4.0 as

Functional Consultant.

EXPERIENCE:

Worked in Production which includes Process chain maintenance and build Info packages, to

•

schedule full / init / delta loads, Data load monitoring and fixing failed loads.

Work Experience on Data Cleansing, Data Modeling and Performance Tuning and building

•

Aggregate.

Solid 5 years experience in ETL and Report Development in SAP / BW /BI, this include Data

•

Modeling, Extraction, transformation and Loading.

Implemented 2 full Life Cycle SAP /BW /BI Projects.

•

Experience in Business Content, Activation, Data Extraction, Generic Extraction, Info Objects,

•

Info Sources, DSO Objects, Info Cubes, Info Packages and Hierarchies.

Participated in all Phases of life Cycle including Requirement Gathering, Development of

•

Queries, Reports, Work Book and Web Reports, Publishing, BEx Query Designer, BEx

Analyzer and Web Application Designer WAD Crystal Reports, Web Intelligence and

Xcelcius.

Extensive Exp in Business Process across SAP / FICO/ MM / SD Modules.

•

Extensively worked with G/L, A/P, A/R, Data Sources for Extraction and Loading Data from

•

FI to BW.

Hands on experience with front end Business Warehouse Component which involved

•

Constructing Custom Queries using Variable Structures, Conditions and Exceptions, Restricted

and Calculated Key figures and Cell editors.

Extensive Experience in Business Objects, reporting in the context of developing the Universe,

•

using the Universe Designer and the Analytics using Xcelcius WEBI and Crystal.

Created complex ADHOC and Drill down, Cross tabs, and Multiple Data Providers.

•

TECHNICAL SKILLS:

Hardware: HP9000, HP3000, IBM compatibles.

Databases: Oracle, SQL Server, MS-Access,

Tools: Microsoft VISIO 2003, SQL Utilities

Scheduler: UNIX CA-Scheduler

Languages: PL/SQL, HTML.

O/S: UNIX, (HP 11.0, AIX), WIN 2003/NT

EDUCATION:

BACHELOR IN COMMERCE/ACCOUNTING

•

SAP FICO CERTIFIED ECC 6.0..

•

SAP HANA CERTIFIED

•

THE KEY RESPONSIBILITIES I PERFORMED ARE:

Maintain Business Warehouse/ Business Intelligence ( BW/ BI ) Modules of SAP and SAP

•

Business Objects.

Design Configure, Test and Implement changes for new or changed Business requirement

•

documents Modification to Configuration.

Analyze user request to obtain effective solutions.

•

Enhance and Support the System.

•

Worked with Administrative Workbench, did Configuration of Info provider and Time

•

Independent Master Data Hierarchies, SAP BW Data Modeling, Data Staging and Data

Extraction.

Enhancement/ User Exits in R/3 and BW.

•

PREMIER TECHNOLOGIES HOUSTON TX SEP 2011 TO JUL 2012

DESCRIPTION:

Premier Engineering organization, provides world class products and services in Power,

Transmission and Electronics sectors. It has 14 Manufacturing divisions, 4 Power Sector

Regional Centers, 8 Service Centers, 18 Regional Offices and a large number of Project sites

spread in US premier has acquired certifications to Quality Management Systems ISO 9001

Environmental Management Systems ISO 14001 and Occupational Health & Safety

Management Systems OHSAS 18001 and is also well on its journey towards Total Quality

Management.

RESPONSIBILITIES:

Monitoring of process chains and analyzing and rectifying the data loads failures of process

•

chains.

Worked on Aggregates and providing drill down functionality in reporting using Bex.

•

Dealt with Compression of Info cubes.

•

To communicate with the customer who posted the tickets through ticketing tool.

•

Resolving the tickets as per the SLA.

•

To inform the on site people if there are any dead locks.

•

Maintaining reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the

•

data loads.

As per weekend activity used to do rescheduling and de scheduling of a process chains.

•

Worked on Transport Mechanism for transporting objects from Development to quality.

•

CENTERPOINT ENERGY HOUSTON TX JUNE 2010 TO JUNE 2011

SAP BW/BI DEVELOPER

Center Point Energy is an electric and natural gas utility serving several markets in the U.S

southern states. Center Point energy is headquartered in Houston Texas.

RESPONSIBILITIES:

Involved in the full life cycle implementation of SAP BW, which includes Data gathering, gap

•

analysis, application specific data extraction, generic extraction, data loading, scheduling,

monitoring and web reporting.

Actively involved in Transports, Troubleshooting and Data Validation

•

Performance tuning of Queries by maintaining Aggregates, Compression and Partition of info

•

cubes

Involved in Business Content Activation, Enhancement of data sources and writing user exits

•

(Master data and transaction data) on R/3 and BW

Extensively involved in setting up of procedures for extracting data from SAP R/3 by using

•

Generic Extraction and Customizing LO Cockpit by using enhancements.

Worked in FI/CO, SD and MM modules creating and working on Data store objects and info-

•

cubes.

Created Process chains for Master data and transaction data loads.

•

Loaded Transaction Data and Master Data via Flat files.

•

Involved in creating and maintaining Info Cubes, DSO, PSA, Info Objects, Info Areas, Info

•

Sources, Data Sources, and Info Packages.

Assisted in transporting objects from Dev Server to QA Server.

•

Participated in GO LIVE and Production support.

•

Generated reports using BEx with variables, exceptions, restricted key figures, calculated key

•

figures, conditions, formulas, filters, drill down methods.

Scheduled Process Chains for full and periodic data loads.

•

OBJECTWIN TECHNOLOGIES HOUSTON, TX AUG 2009 TO APR 2010

BI CONSULTANT

ROLES & RESPONSIBILITIES:

• Master and Transactional data from flat files and SAP as the OLTP source.

• Worked extensively on administration workbench (RSA1). Customized Info Objects, Data

Sources and Info Cubes.

• Worked extensively on standard and custom defined LO-Cockpit, Installed relevant SAP

business content. Used LO structures for extracting sales order, delivery billing information.

• Created and worked on daily basis with Extractors, Generic Extractors.

• Designing of Info cubes and DSO objects by considering the different business scenarios.

• Extraction of data from SAP R3 for various Info cubes including Sales Center performance

data, Statistical Key Figures info cube, Regional Sales, Sales order Info cube, Customer Info

cube, Material info cube and various other info cubes.

• Data upload for both Master data and Transactional Data from the source system into the SAP

BI.

• Installation of Business Content from Production, Sales and Marketing areas, Activation of

standard Info Cubes and definition of new Info cubes & enhancement of Business Content

• Scheduling Info packages for loading Master Data, Transaction Data & Monitoring.

• Daily monitoring of Info Cubes and ODS object requests.

• Daily monitored the data loads and resolving the tickets occurred in the process.

Created and Maintained Process Chains by scheduling nightly/weekly/monthly jobs for

•

periodic loads.

Created reports with calculated key figures and filters.

•

SMUD.SACRAMENTO,CA

DURATION: AUG 2008 TO JUN 2009

POSITION : SAP BI/BO CONSULTANT .

The Sacramento Municipal Utility District is a community owned electric utility governed by

a seven member board of directors.

RESPOSIBILITIES:

• Interacted with the end users to understand their reporting requirements and creating documents

performed analysis, design,development, and implementation of standard customized info cubes

and ODS objects for MM/SD and FICO modules.

• Worked on customized and standard info cubes.

• Generated and customized data sources from APO, DP Planning areas.

• Used multi providers and info sets to extract data from tables and table joins.

• Extensively worked in LO Cockpit extraction to load sales, purchasing and inventory data.

• Extracted data from standard content sales,PO and inventory extractors and custom built

extractor depending on requirement.

• Defined transformation,created DTP and info packages for scheduling loads to data targets.

• Created process chains and meta chains for period upload of text data,master data and

transaction data and monitored data loads with full update and delta mechanisms.

• Performed performance tuning of query using dices, aggregates, compression and partition.

• Actualized various types of BEx query variables including user exits, replacement path, text and

formula variables, created calculated and restricted key figures, structures, conditions, filters

and cell definition within queries, maintained query setting and tuning.

• Involved in complete life cycle of SAP BI/BO.

• Developed Universes using SAP BI/BW queries as source data.

• Involved in developing, designing and maintaining new and existing universes by creating

joins and cardinality responsible for the creation of universe with classes, objects and condition

objects.

• Blue printed the requirements of KPI/ KPM for Dash board reporting.

• Used data federator to create connections to different databases including SQL server,SAP BW,

lAWSON and other systems.

HORN SOLUTIONS TX MAR 2007 TO MAY 2008

SAP BI CONSULTANT

RESPONSIBILITIES:

• Worked extensively with Data Warehouse Workbench (RSA1).

• As a Member of BI team, Analyzing the data involved in Business content Installation,

Activating and Modifying the Standard Info Objects, Data Sources, Info Cubes, DSO Objects

for Sales and Distribution.

• Worked with Transactional Data and Master Data (Attributes, Text) Data Sources to load data

from SAP ECC and Flat Files systems into BW.

Worked extensively on LO-Cockpit LBWE. Extracted and configured Sales & Distribution

•

data sources in SAP ECC for SD cubes 0SD_C01 Customer 0SD_C02 Delivery 0SD_C04

Delivery Service via 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VASCL.

Resolved the respective Issues aroused in the Loading.

•

Modified the respective data in the PSA for the incorrect records and sent to the respective

•

Data Targets.

Designed Generic data extractors RS02 to extract and transform the data sources to suit the

•

Business Warehouse model.

Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly Data

•

Loads using Process Chains.

Actively Involved in Rectification of Load Failure errors like Master Data Loads.

•

SENIOR OPERATIONAL MANAGER

CH &RIDE INC. NEW YORK JAN 1991 TO DEC 2006

ROLE:

Analyze revenue statistics, identify and solve problems through team organization

•

Daily and weekly sales team meetings.

•

Develop and Implement comprehensive plans to achieve increased productivity, utilization,

•

network optimization, and asset management.

Manage the TRI-STATE region which includes one supervisor and 5 fleet security managers

•

controlling 300 plus drivers.

Directed the hiring, training, and reviewing of all operations, customer service, sales, billing

•

and driver personnel.

Working under enormous pressure and at a very fast paced environment,providing limousine

•

and packaging services to clients like Goldman Sack, J.P. Morgan, Chase Bank, Citi Bank, Leh-

man Brothers, Solomon Brothers.

REFERENCES CAN BE PROVIDED ON REQUEST

Contact this candidate