SAP BI Consultant
Resume:
Certifications:
Business Objects Certified Professional - Business Objects Enterprise XI-
R2.
SAP Certified Application Associate - Business Intelligence with SAP
NetWeaver 7.0
Professional Summary
. 7.5 years of experience in SAP-BW/BI.
. 4 full life cycle implementation experience on Net weaver 2004s BI7.0
and BW 3.5 Configuration.
. Knowledge with Business objects XI-R2 and BO XI 3.1 in developing
reports using Web intelligence and Knowledge on Deski.
. Expertise in OLTP extractions from SAP R/3 using LO Cockpit, Generic
Extractions, Flat File Extractions, LES Extractions and Expertise in
DB Connect as well to extract the data from Relational Data base
systems.
. Creating & Maintaining InfoObjects, InfoCubes, DSO Objects,
DataSources, Insources, Update Rules, Transfer rules, DTP's,
Transformation etc. Activating Business Content, LO-Extractors
(Cockpit), Data Mart, Scheduling, Monitoring & correcting Data Upload,
Creating Queries using BEx Query Designer & Workbooks in BEx Analyzer
and Creating Web Reports / Web Templates with Web Application
Designer.
. Expertise in creating process chains for master data and transactional
data and Meta chains and maintaining and solving the errors and EMAIL
setup and SMS setup for Process chains.
. Experience of Open Hub to transfer data from Info providers to flat
files.
. Implemented ASAP methodologies: BW Project Management (Project
Scoping, Business Blueprint Phase) and Enhancing Query Performance.
. Expertise in SAP BI 7.0 concepts and Migration.
. Expertise on Net weaver Visual Composer and Generated Enterprise
Reports using Report Designer.
. Knowledge on SAP Visual intelligence, SAP Lumira and SAP BO Explorer,
Crystal reports 2011 and Crystal reports enterprise 4.0.
. Extensively worked on MPP for resource allocation depending on various
priority levels.
. Extensively Worked on Broadcasting and Exceptional Broadcasting.
. Expertise on Real-Time Data Acquisition.
. Reliable, resourceful and efficient team player / team lead with good
Communication skills, able to adapt quickly to new technologies.
. Provide POC for OBIEE/SAP Integration.
. Expertise in resolving BI Technical issues and faced technical
challenges.
Experience
Organization Designation Duration
Cheminova Sr SASP BI Consultant Apr 2012 - Till Date
Yash Technologies SAP BI Senior Consultant Aug 2010 - Apr 2012
Almarai SAP Functional Analyst Aug 2009 - July 2010
ATL BI Consultant June '08 - June'09
ACCENTURE Software Engineer Jun '06 - Apr'08
Technical Skills
SAP SCM 7.0, APO/DP, APO/SNP, APO/PPDS, BW 7.3, BI 7.0,
BW 3.5, R/3 4.7, ECC 6.0.
SAP BI Extraction, Modelling and Reporting using BEx
Query Designer, Analyser, Bex Web Application
Designer and Report Designer, Net weaver Visual
Composer.
Business Objects BO XIR2, BO XI 3.1 (Desktop Intelligence, Web
Intelligence, Knowledge on BI ONDEMAND, ONDEMAND
Publisher, Data Federator Designer, Universe
Designer and Live Office)
SAP BASIS CU Administration, Creating users, Assigning
logical systems and creating RFC connections,
Transporting the Objects through system landscape.
ABAP Routines (Start Routines, End Routines), Customer
Exits/User exits, INFOSET Queries.
MICROSOFT MS ONENOTE, MS VISIO.
Technologies
Trainings
Sl# Title Location Organized by Duration
1 Bex Web Application Hyderaba Accenture 3 Days
Designer d
2 Net weaver Visual Hyderaba ATL 5 Days
Composer d
3 BO XI 3.1 DUBAI ALMARAI 5 Days
Projects Profile
Project # 1 Cheminova Implementation & Integration & Production Support
Project Duration August 2010 to Till Date
Role Sr BI Consultant / Team Lead
Team Size 4
Environment SAP BI7, ECC 6.0, SCM 7.0 (APO/DP,APO/SNP)
Company/Client Profile:
[pic]
Cheminova is a manufacturer of fine chemicals, with its main business area
within plant protection products. Cheminova has developed a wide range of
plant protection products by in-house process and formulation development,
and markets its products globally through subsidiaries in 20 key countries
and through distribution partners in most other countries.
Contribution
. Working as Team Lead/Sr Consultant.
. Responsible for Deliverables and conducting weekly meetings with
ONSITE/OFFSHORE teams to discuss ongoing deliverables and future
developments and make sure the deliverables will be on time for the
business.
. Creation of Functional Specification and Technical Specifications for
SD, MM, PP, PM,PS HCM and FI and CO-PA Modules and Designed APO-BW
Data model Integration.
. Installing from Business Content and doing the GAP Analysis and
Enhancing the Data sources to meet the Customer Requirements.
. Designed and developed successfully APO-BW (APO-DP) Integration for
Actual and Forecast sales analysis.
. Done the enhancements for extractor which includes Master data and
Transaction data sources.
. Writing the User Exits and Replicated the Data sources and creating
the Data model Design document and created Transformations and
Extracting the Data from ECC System.
. Interact with business to gather requirements, prioritize work,
develop enhancements to the existing system, coordinate testing, and
perform change management/training for BW Reporting and applications.
. Design complex, custom BW solutions or component objects translating
complex requirements into an optimal BW design for BOM Extraction,
Sales conditions etc.
. Created Process chains for Master data, Transaction data Local chains,
and Meta/Remote process chains.
. Responsible for Performance management throughout all the areas right
from Extraction, Modelling and reporting.
. Implemented Various OSS Notes in order to minimize/restrict the
Process chain issues, conducted user trainings on various levels.
. Support for system upgrades and service packs installations.
. Created Incident management reports in solman 7.1.
. Provide training for end users and clarifies the reporting issues for
users.
Project # 2 Project APEx ALMARAI- IMPLEMENTATION & Support
Project Duration August 2009 to July 2010
Role Team member
Team Size 6
Environment SAP BI7, SCM 7.0, MM, SD, PP/PI, APO/DP, APO/SNP, APO/PPDS,
LES, ECC 6.0 and BOXI-3.1.
Company/Client Profile:
Almarai is the largest integrated dairy foods company in the world, with a
reputation for quality that is unmatched within the gulf countries in which
we operate. We're a company committed to healthy living, and to delivering
only the freshest and most delicious products to the people we care most
about - our customers.
Contribution
. Worked as a BI Team lead.
. Exposed to complete life-cycle environment right from project
definition, Business requirement gathering, analysis, developing
detailed design documents and Technical architecture, Development,
Unit Testing, Acceptance Testing, preparation of support
documentation, cut over plan through go-live support.
. Created Functional Specs Created Data Model Design for APO/DP and BW
and Technical Specs and Created Project Plan for the same.
. Created views and Generic Extractors on the ECC system to achieve
Material Derivation and Depot Derivation.
. Extensively used ABAP coding in start routine and Field routine of
transformations to achieve material and plant derivation since the
data is extracted from legacy system in APO DP whose data format
differs from ECC format.
. Created Transformations, DTPs, and Info Packages, DSOs for staging and
Cleansing purposes and Info Cube for Reporting purposes on Forecast
data.
. Created Data source on DP and SNP Planning areas, replicated the same
into BI system and created info objects, DSOs, Info cubes, Multi
providers and created reports, created process chains, Created
Transport strategy.
. Used ABAP coding in Info Package routine to fetch data basing on
particular time period.
. Created Queries using BEx Query designer using free characteristics,
restricted key figures, calculated key Figures, Formulas, Variables,
Exceptions, Filters and conditions.
. Created Ad-hoc Reports based on SKU and DEPOT universes.
. Although BI system is an add-in in APO system, requirement was to
fetch planning data into BI system and to be restored for a particular
time span. To achieve this requirement, Integrated APO system with BI
System.
. Created Partitions, Aggregates, DB Statistics and Compressed the Info
Cubes to improve reporting performance.
. Validating project plans, taking care of the implementation, testing,
validation and business acceptance for the completed tasks.
. Responsible for change-control procedures and up-to-date maintenance
documentation provided.
. Prepared the Training Documents and Given End user training.
. Created Process chains for master data, transaction data and created
Meta chains (for Daily and Weekly Loads) periodically and monitoring
the same.
. Alerts through process chains & Emails through Exceptional
Broadcasting.
Project # 3 Navbharat Enterprises - IMPLEMENTATION
Project Duration June 2008 to June 2009
Role Team member
Team Size 4
Environment SAP BI 7, SAP BI7.1, MM,SD,PP
Company/Client Profile:
Navbharat Enterprises is excellent line of Manufacturing & Research and
Development of Textiles Chemicals used in the finishing of the Textile
Cloth.
Contribution
. Worked as a BI Consultant.
. Worked in Analysis Authorizations and Created Roles and assign the
users to Roles and the Mass transportation.
. Involved in preparing the Technical Specs based on the Functional
specs.
. Involved in designing the reports based on the Clients requirement.
. Worked with Query Designer and Analyzer.
. Used Generic Extraction to retrieve the data from the Backend system.
. Experience in MM, SD and PP Standard Data source/Extract Structures.
. Created Queries using BEx Query designer using free characteristics,
restricted key figures, calculated key Figures, Formulas, Variables,
Exceptions, Filters and conditions.
. Extensively worked on LO Extraction, Involved in Setup table's
deletion, filling up of setup tables, and replicating the respected
Data Sources.
. Created Process chains for Data loading daily and weekly data loads
for both master and transaction data.
. Involved in Business Content Installation.
Project # 4 QinetiQ - Implementation and Support
Client QinetiQ
Organization Accenture
Duration 05/2007 - 04/2008
Team Size 16 ( 3 - Onsite, 13 - Offshore )
Environment ECC 6.0, SAP BI 7.0
Company/Client Profile:
QinetiQ is one of the world's leading defense technology and security
companies. QinetiQ has a long term agreement (25 years) with the UK
Ministry of Defense (MoD) to manage military ranges. It is a major
stakeholder in the UK Defense Technology Centre which places military
research contracts on behalf of the MoD. Carlyle Group (33.5%), UK MOD
(61.8%) Own staff (4.7%).
Contribution
. Created Technical Specifications based on Functional Specifications.
. Efficiently handled the tickets of priority raised through Clear Quest
ticketing tool by following Standard Operating Procedures (SOP), and
working on never missing the Service Level Agreement (SLA).
. Resolve issue by participation in conference calls with clients.
. Installed the Business content as and when required and modified the
Standard Structures.
. Involved in the creating and development of Info Cubes,
MultiProviders, Data Store Objects (DSO), Aggregates, and Info
Objects, Data Sources, Info Sources, Info Providers, Transformations,
DTP and generic data sources.
. Involved in Creating Different Data model sessions in HCM, SD, and MM
and PS.
. Created Process chains to schedule data loading into data targets on
periodic basis.
. Created Queries using Bex Query designer using functions like
calculated key figures, restricted key figures, free characteristics,
Filters, exceptions and Conditions, Created Workbooks for HCM queries
and used Wad Templates.
. Created Transported Strategy and led the team to transport the
objects throughout the System Landscape and resolved the Errors
faced while transporting efficiently and effectively.
. Involved in Different Technical Designs Reviews and KT
Sessions.
. Extensively worked on MPP to allocate the resources for various
objects and GDD.
Project # Diageo -Support
5
Client Diageo
Organization Accenture
Duration 06/2006 - 04/2007
Team Size 8 (2 - ONSITE, 6 - OFFSHORE)
Environment R/3 4.7, SAP BW 3.5, SAP BI7.0
Company/Client Profile:
Diageo is the world's leading premium drinks business with an outstanding
coverage of beverage alcohol brands across spirits, wine and beer
categories. These brands include: Smirnoff, Johnnie Walker, Captain Morgan,
Baileys, J&B, Jos Cuervo, Tanqueray, Guinness, Crown Royal, Beaulieu
Vineyard and Sterling Vineyards wines.
Contribution
. Info Package Management for data loads via PSA, Flat file
creation/load PSA (used to source data from legacy system into
BI).
. Migrated from Data sources from BW 3.5 to BI7.0.
. Expertise working with Emulated and Migrated Data sources.
. Created basic Info Cubes, created Info Sources, created
Transfer Rules and Update rules, created Data sources,
replicated Data sources, loaded Master Data from OLTP.
. Extensively involved in setting up of procedures for extracting
data from SAP R3 by using LO Cockpit by using enhancements.
. Created Process chains for both Master Data and Transactional
Data and monitored.
. Involved in creation of reports using BEx Query Designer using
free characteristics, Restricted key figures, calculated key
Figures, Variables, Exceptions, Navigational attributes,
Filters, Structures and conditions.
[pic]
Contact this candidate