SAP BW, SAP BO reporting, BO universe design
Resume:
Manish Kumar
****.*****@*****.***
Objective
To obtain a challenging position in the area of Enterprise Resource
Planning, where my SAP BI skills can be utilized in maximizing company
profits, while providing career advancement opportunities.
Current Role Description
SAP BI Consultant.
PROFESSIONAL SUMMARY
SAP BI/BW Consultant with 6 yrs of IT experience with 6 years in SAP
BOBJ,SAP ABAP and SAP BI 3.5, 7.0, 7.3 with strong knowledge of SAP R/3.
My area of expertise are SAP BI\BW ETL, data modeling and reporting and SAP
BOBJ(business objects).
Experience with translating the functional requirements into technical
designs.
I have worked on activities ranging from requirement analysis, project
planning, data model design and development, data loading, report design
and development.
Experience with the BW technical content and Data for following process
Areas: FI (New G/L, AP, AR), FICA, CO, SRM(Supply Relationship Management),
SCM (Supply Chain Management), HR (Human Resource).
Worked on designing and developing standard and custom BW solutions,
including extractors, MultiProviders, info-cubes, data providers (DSO &
ODS), info sources, info-objects, and info-packages. Creating
transformations, transfer rules, update rules, DTP (data transfer
process).
Experience with with Master Data extractions (Attributes, Texts &
Hierarchies). Data extractions from SAP sources (ECC, CRM) and non SAP
sources (flat files, DB connect, UD connect).
Experience with writing ABAP routines, start routines, end routines,
expert routines, User Exits, Datasource enhancement using Badi
implementations.
Reporting experience of creating queries in Bex query designer,Bex analyzer
and web templates in WAD (Web application designer). Also publishing the
reports in a web based portal.
Experience with SAP BO (business Objects) in creating Universes based on
SAP Bex queries, infoproviders and non SAP data base ( Oracle).
Experience with SAP BO reporting, creating crystal reports, Xcelsius
reports, BO Dashboards, Web Intelligence (WEBI) Reports.
Strong knowledge of data transfers mechanism from SAP to non-SAP systems
using Open Hub Destinations and APD (analysis process designer).
Experience with performance tuning activities like infocube indexing and
compression, creating aggregates and Dataload performance improvement by
data package optimization and parallel processing optimization.
Expertise handling Post Production Support & Change Management issues.
TECHNICAL SKILLS
Business Warehousing : SAP BI Netweaver 7.0, SAP BO Web intelligence
Reports and Dashboards
ERP : SAP R/3
Platforms : Windows XP - Windows 7
Languages : ABAP
Internet Technologies : XML, HTML, XSLT
Tools &Utilities : BEx Analyzer, BEx Query Designer, Sap BO
Dashboard, Web Application
Designer,
Crystal reports, Webi reports.
Business Domain : Auto lending,
Others : MS-Word, MS Excel, PowerPoint
PROFESSIONAL EXPERIENCE
Toyota Financial Services, Torrance, CA
Oct 2013 - Current
SAP BI Consultant
Project: TOPS- AMM commercial finance
Project Description: Toyota Financial Services, Commercial Finance branch
has implemented SAP CRM and SAP FI module as source system with SAP BW. The
data from source system is extracted on daily\monthly basis and is
transformed, cleansed and loaded into various targets (cubes and DSO). The
data load are automated through process chain .There are various reports
which are integrated into a web based portal and some reports are
broadcasted in mails to selective users.
Responsibilities:
Production support activities.
To monitor the process chains and data load.
To ensure the availability of all the reports.
To maintain and ensure the availability of portal
To resolve tickets for any ad-hoc issue faced by user
Work on new enhancements and service requests.
Creation of APDs (Analysis Process Designs)
Designed SAP BO Universe. Created Webi Reports, Crystal reports.
Creating XML transformation using XSLT
Application Environment: SAP BI
Walmart Stores Inc. Jan 2013 - Sep 2013
SAP BI Developer
Project: PROFIT- ISM UK-PILOT
Project Description: Wal-Mart is an American multinational retailer
corporation that runs chains of large discount department stores and
warehouse stores. It offers a wide range of products to its customers at
very competitive prices. There are a wide range of applications that are
used to support this global sourcing initiative in the supply chain.
PROFIT- ISM UK-PILOT is SAP BI implementation project for reporting and
analysis in areas of Indirect Spend Management - includes P2P and supplier
management processes for new global initiative.
Responsibilities:
End to end report development.
Report frontend development in WAD, SAP BO Dashboards, Xcelsius Reports
and Crystal reports.
Participate in Technical system analysis.
Data flow design and development. Creation of
datasouces,DSO,Infocubes,transformation,Standard Datasource enhancements.
Creation of Open Hub Destination to send Data to Non SAP Sources.
Writing end routines in transformations
Functional and technical documentation.
Application Environment: SAP BI
Welsh Waters May 2012 - Dec 2012
SAP BI Developer
Project: Developer Service Design
Project Description: Welsh Water is the sixth largest of the ten regulated
water and sewerage companies in England and Wales. Responsible for
providing over three million people with a continuous, high quality supply
of drinking water and for taking away, treating and properly disposing of
the waste water that is produced.
Developer Services was SAP BI Implementation project for reporting and
analysis of the data generated in SAP BPM system which was extracted in BW
by RFC using UD connect feature of SAP BI.
Responsibilities:
Created BPM Data sources Using UD connect feature of SAP BI.
Prepared BRD, Technical / functional specifications.
Analyzing the business content data source and info objects
Participated in Data Modeling and Design
Creation of datasouces,DSO,Infocubes,transformation,DTP.
Writing expert routines in transformations.
Created reports in BEx Query Designer.
Created Process Chains to automate the data load.
Application Environment: SAP BI
KPMG International Cooperative April 2011 - April 2012
SAP BI Developer
Project: KPMG IBS Consulting Services
Project Description: KPMG is a global network of professional firms
providing Audit, Tax and Advisory services. It operates as an international
network of member firms offering audit, tax and advisory services. The
project involved creation of global template and subsequent rollout for
different members firms
Responsibilities:
Participated in end to end implementation
Participated in Data Modeling and Design
Created reports in BEx Query Designer.
Writing Customer Exits
Worked on Report to Report interface.
worked on Web Application Designer and BEx Query Designer
Worked on process chain monitoring
Involved in Performance improving related issues by creating Aggregates,Data package optimization .
participated in UAT and defect fixing.
Application Environment: SAP BI
HCL Infotech Ltd. June 2009- March 2011
SAP BI Developer
Worked in internal SAP projects and also imparted training to New joiners
with SAP BI and Bex reporting training .
Responsibilities:
creating Queries in Bex query designer
creating Web templates in Web Application designer
process chain monitoring and batch monitoring.
Give training on Bex query designer and WAD (Web application designer)
Visa Details
Visa type : H1B
Valid till : 15 Oct 2017
Educational Summary
Highest Degree : B.tech in Computer Science and Engineering
Contact this candidate