Data Project
Resume:
PATAN. VASEEM KHAN
Mobile No: +91-900*******
SAP BI Consultant
Email:***********@*****.***
Experience Summary
Around 3 years of experience in SAP BI/BW.
•
•
Good Experience in understanding Business Requirements and Business Process.
•
Good experience in all phases of BI implementation- Modeling, Data Extraction, Reporting
and Data Analysis.
•
Expertise in working with different types of extractors like generic extractors, LO-Cockpit.
Good experience in creating SAP BI components like Info objects, Info cubes, Info source,
•
Multi providers, ODS objects, Transfer structure, Transfer rules, Update rules and Info
packages.
•
Knowledge on Performance tuning for Improving data loading and query performance by
maintaining Aggregates, Compression, Partitioning, Indexing of Info Cubes
•
•
•
Involved in Extracting the data from R/3 to BI, Loading (Full/Delta Up-Load) and Monitoring.
Have knowledge in Remodeling, Repartitioning.
Created Queries having Filters, Free Characteristics, Exceptions and conditions, Variables,
Restricted Key Figures and Calculated Key Figures.
•
Good experience in Process Chains creation to automate loading of all Master and Transaction
data in background and sending mails in case of errors.
Worked on all kind of Transport activities in BI (Transporting of info cubes, ODS, Queries
•
etc)
Involved in extracting data from SAP R/3 and flat file.
•
Good Experience in generating the Reports.
•
Experience:
Presently working with TCS in Bangalore, as an SAP BI Consultant.
Education:
•
B.Tech (Mech) from Jawaharlal Nehru Technological University, Anantapur in the Year of
2009
Technical Skills:
ERP
Data warehouse
Reporting Tools
: ECC 6.0
: SAP BI 7.0 BW
: BEx Suite, SAP BO
Career Profile:
Project 3#
Client
Duration
Project type
Role
Environnent
Responsibilities:
•
•
•
•
•
•
•
Extensively worked with Basic Cubes, Dsos, Info objects, Data sources and Process Chains.
Involved in Installing and Customizing the Business Content Objects.
Activated and modified standard extractors as per Business Requirement
Created Generic extractors in Project System Module as per Business requirement
Worked on controlling Standard extractors like on Generic Extractor
Involved in standard master data source enhancement
Experience in Extracting data from SAP R/3 Source systems by using LO Cockpit and
expertise in extracting data from Generic Extractors
Improved data loading and query performance by compression, aggregates, indexes and
rollups onto Info cubes
Maintained routines for required objects.
Monitoring of Master Data and Transaction Data uploads via process chains
Actively involved in Rectification of Load failure Errors like Master Data Loads and
Transactional loads
Involved in validating data consistency in reporting with Data Target against PSA after
loading them to data targets
Involved in creation of Transformation and DTP (data transfer process).
Involved in defining queries using Filters, Variables, Conditions and Exceptions, Restricted
and calculated Key Figures in BEx Analyzer to facilitate data analysis
Involved in the Transport connections.
Involved in the designing of Queries on Info Cubes and on ODS
Created with the application specific and generic data extractors in Logistics.
•
•
•
•
•
•
•
•
•
•
: A.S Watson, USA
: August 2010 to Till Date
: Implementation
: SAP BI consultant
: ECC 6.0, SAP BI.
Project 2#
Client
Duration
Project type
Role
Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages
Involved in scheduling the data to info cubes, info objects and ODS objects daily, weekly and
monthly
Created Process chains for effective scheduling of various loading processes
and Info Package Groups for loading and scheduling, Delta and Full loads
Involved in Load Monitoring Using RSPC, RSMO, SM37 and SM50.
Involved in both the Activities monitoring and Production Support.
Involved in validating data consistency in reporting with Data Target against PSA after
loading them to data targets.
•
•
•
•
•
•
•
: Lupin Pharma, Kalina, Mumbai.
: Jan 2010 to July 2010
: Support
: Technical consultant
Involved in Debugging Update Routines, Start routines.
Involved in maintaining lot of documentation for all the Support Activities.
Maintaining Work History for all the tickets until it is closed down
Actively involved in Rectification of Load failure Errors like Master Data Loads and
Transactional loads
Have worked on Performance issues for Data loading and faster Query Execution
•
•
•
•
•
Project 1#
Client
Duration
Project type
Role
Performed Data Extraction and Data Staging.
Installed and worked with FI-AR (line items) and AP (line items) cubes. Also worked with the
standard ODS objects (line items).
Installed and activated the standard Info Cubes, ODS objects, Info Objects and various other
relevant objects.
Optimized the load performance by adjusting the packet size, number range buffering, etc.
Loaded the data from R/3 to BW using Initialization with delta update and full update methods
Involved in the designing of Queries on Info Cubes and on ODS
Worked with the standard SD business content Data sources and Cubes (Billing and Sales
Overview).
Involved in uploading both Master data and Transaction Data from the source system into the
SAP BW
Involved in Performance Tuning of Queries by maintaining Aggregates, Compression,
partitioning, indexing of Info Cubes, etc
Created with the application specific and generic data extractors in Logistics.
Worked extensively on BEx Analyzer and created queries using calculated and restricted key
figures. Structures, Variables, Conditions, Exceptions, Free characteristics and Filters.
Customized BEx Queries for Users Requirements
Created Workbooks and used RRI jump queries to drill down to others queries and R/3
transactions.
: Textrade International Ltd., Mumbai
: Mar 2009 to Dec 2009
: Support
: Technical Consultant
Contact this candidate