Data Sap

Location:

Torrance, CA

Posted:

June 22, 2015

Contact this candidate

Resume:

Manish Kumar

Contact: 617-***-**** Ext. ***

Email: **********@*****.***

PROFESSIONAL SUMMARY

SAP BI/BW BO Consultant with 5 yrs. of IT experience in SAP BOBJ (Business Objects), SAP ABAP and SAP BI\BW 3.5, 7.0, 7.3 with strong knowledge of SAP R/3. With experience in industries like Retail, Banking - Financial Services, Utilities, Tax and Audit. Have good knowledge of SAP HANA.

Worked on activities ranging from requirement analysis, project planning, data model design, data loading, report design and development, BI\BW upgrade from 3.5 to 7.3. And I have experience with translating the functional requirements into technical designs.

Experience with installation and configuration SAP BO (business Objects). Creating Universes based on SAP Bex queries, infoproviders and non-SAP data base (Oracle).Worked in SAP BO 3.x universe designer and BO BI 4.1 IDT(information design tool).

Experience with SAP BO reporting, creating crystal reports, Xcelsius reports, BO Dashboards, Web Intelligence (WEBI) reports, MS Analysis tools. Knowledge of BI tools like Insight, OBIEE, Netezza, SAP LUMIRA, Tableau.

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 LO Cockpit, COPA extraction and SAP 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) and SPM (Spend performance management).

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 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, Data source enhancement using Badi implementations.

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 info cube indexing and compression, creating aggregates and Data load performance improvement by data package optimization and parallel processing optimization,

Use of BW accelerators.

Expertise in handling Post Production Support & Change Management issues. Worked on defect fixing and ad-hoc issue resolution.

TECHNICAL SKILLS

Business Warehousing: SAP BI NetWeaver 7.0, 7.2. 7.3 SAP Business Objects 3.1, 4.0

Reporting: SAP BO Web intelligence Reports, Crystal reports, Xcelsius Dashboards, Bex queries, Web Templates

ERP: SAP R/3

Platforms: Windows XP – Windows 7

Languages: ABAP, SQL, PL SQL

Internet Technologies: XML, HTML, XSLT

Tools &Utilities: BEx Analyzer, BEx Query Designer, Sap BO Dashboard, Web Application, Designer, BO Universe designer, IDT (information design tool) Business Objects, Xcelsius Platform, Business Objects Business Intelligence Platform

Business Domain: Auto lending, retail, Utilities, Consulting

Others: MS-Word, MS Excel, PowerPoint

PROFESSIONAL EXPERIENCE

Toyota Financial Services, Torrance, CA March 2014 – March 2015

SAP BW BO 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). SAP BO was used as reporting tool to create reports over Bex queries

Responsibilities\Achievements:

Requirement analysis and Technical specification documentation.

Prepare functional specification for extraction of data from ERP.

Worked with client and determined new KPIs (Key performance indicator) and suggested new reports to streamline the payment schedule which resulted in 20 % increase in average quarterly performance of Commercial Finance. Also done the technical implementation of those reports.

Suggested the client to implement SAP BO for reporting in telephony department and created BO universe based on Oracle database in information design tool (IDT).

Created test plans and, test case scripts for unit testing.

Determined the bottlenecks of data load performance and implemented various performance improvement technique like data package optimization, parallel process optimization, process chain optimization which improved the data load performance drastically.

ETL

Installation of Standard business content for SAP BW . LO Extraction, COPA extraction.

Developed Transformations, DTPs, and Start/End routines, User Exits using ABAP/4 to incorporate Business logic and perform data manipulation.

Created Process Chains to automate the data load.

Schedule, performance and monitored periodic data loads from R/3 to BW system, delta loading and DSO Loading process.

Creating and moving Transports from Development to Production using best practices.

Modeling

Installation, administration of SAP Business Object, creation of roles and authorization.

Created BO universe in information design tool based on Oracle database tables, used various functions like aggregate aware, Prompts, variables to create dimensions and measures.

Worked extensively in BO reporting tools, Business Objects 4.0/3.1/XIR2 (Universe Designer, CMC, CCM, Web Intelligence Rich Client, Import Wizard, Info view), Crystal Reports 2011/2008, Xcelsius 2011/2008.

Created data sources, DSO, Info cubes, Writing expert routines in transformations.

Writing ABAP routines, Start routines End routine as per requirement.

Worked on integration of SAP BW with other BI application (OBIEE) by sending analytical data from SAP BW through APDs (Analysis Process Designs) to other BI data marts.

Worked on reconciling ECC data with BW data.

Enhanced the standard BW extractors using Badi implementation.

Reporting

Created queries in Bex query designer based on the reporting requirements.

Created connections to the BEx queries in BW system through the BICS network layer in the Information design tool (IDT).

Created Webi Reports, Crystal reports and BO dashboards based on client’s requirement.

Created complex crystal reports based on sub reports, cross tab objects, formulas.

Created web services based on QAWS(query as a web service) based on query on Universe.

Application Environment: SAP BI, SAP BO

Walmart Stores Inc. Jan 2013 – Feb 2014

SAP BW BO 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\Achievements:

Worked on upgrade of SAP BW 3.5 to SAP BW 7.3. customized objects after upgrade to ensure data integrity.

Worked with the client to determine the reporting requirements for SPM (spend performance management) in

GNFR (goods not for resale). Finalized the reports and their layout.

Suggested standard web template and dashboard template to client based on which reports were developed.

Worked on functional and technical design documentation and writing the post production maintenance

Manual.

ETL

Developed Transformations, DTPs, and Start/End routines, User Exits using ABAP/4 to incorporate Business logic and perform data manipulation.

Created Process Chains to automate the data load.

Schedule, performance and monitored periodic data loads from R/3 to BW system, delta loading and DSO Loading process.

Creating and moving Transports from Development to Production using best practices.

Modeling

Created data sources, DSO, Info cubes after installing the business content.

Enhanced the standard BW extractors using CMOD and function module.

Created BO universe based on SAP HANA Models in information design tool (IDT).

Worked on integration of BOBJ with SAP BW and SAP HANA.

Created universe in universe designer tool based on Bex queries to expose BW data to BO for creating Dashboards.

Reporting

Created Bex queries in Bex query designer based on reporting requirement.

Created web templates in WAD (Web Application Designer) based on Bex queries.

Created BO dashboards based on Universe created over BEx queries.

Application Environment: SAP BI, SAP BO

Welsh Waters Jan 2012 – Dec 2012

SAP BI BO Developer

Project: Developer Services 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 BW.

This was an end to end implementation from scratch.

Responsibilities\Achievements:

Full life cycle implementation, which involve Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.

Worked with client and determined new KPIs (Key performance indicator) and suggested new reports to streamline the business process. Prepared BRD, Technical / functional specifications documents.

Involved in technical design of BW data models and BO reports.

ETL:

Developed Transformations, DTPs, and Start/End routines, User Exits using ABAP/4 to incorporate Business logic and perform data manipulation.

Created Process Chains to automate the data load.

Schedule, performance and monitored periodic data loads from R/3 to BW system, delta loading and DSO Loading process.

Creating and moving Transports from Development to Production using best practices.

Improved data loading performance by limiting data packet sizes, scheduling index deletion and rebuilding Jobs as well as through ABAP tuning. As a result of these efforts data loads were conducted successfully within half the time

Modeling:

Created data sources, DSO, Info cubes, transformation, DTP, Writing expert routines in transformations.

Overcame the challenge of extracting SAP BPM data into BW system by creating custom BW data sources by using UD(universal data) connect feature of SAP BW.

Activation of the Business Content for Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA), General Ledger (GL), Human Resource (HR), Cost Center Accounting (CO-CA), CRM activity items cube and customizing them as per the client requirement.

Enhanced the standard BW extractors using Badi implementation.

Created BO universe based on Bex queries, BW info providers in information design tool.

Used APD (Analysis process Designer) to transfer analytical data from SAP to other BI systems.

Reporting:

Suggested standard web template and dashboard template to client based on which reports were developed.

Created Webi Reports, Crystal reports and BO dashboards based on client’s requirement.

Designing, reporting templates with Bex Analyzer and Bex Query designer using key figures, hierarchies, variables, properties, exceptions and conditions in the query definition.

Application Environment: SAP BI, SAP BO

KPMG International Cooperative June 2010 – Dec 2011

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\Achievements:

Full life cycle implementation, which involve Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.

Worked on functional and technical design documentation and writing the post production maintenance Manual.

ETL:

Developed Transformations, DTPs, and Start/End routines, User Exits using ABAP/4 to incorporate Business logic and perform data manipulation.

Created Process Chains to automate the data load.

Schedule, performance and monitored periodic data loads from R/3 to BW system, delta loading and DSO Loading process.

Creating and moving Transports from Development to Production using best practices.

Modeling:

Designed data model. Created DSO, transformation, DTP, Info cubes, multiproviders.

Creating custom data source to extract data from the source system.

Writing customer exits, start routines, end routines, expert routines in transformations to achieve data cleansing requirement.

Involved in Performance tuning and bottleneck resolution.

Used Error handling strategy for trapping errors in a mapping and sending errors to log table.

Used both initializations with Delta Update and Full Update methods depending on the business requirement.

Created Open hub destinations to transfer data to third party reporting tool (cognos).

Reporting:

Created classical and interactive reports using BEx Reports, Workbooks and Queries for the required Purchasing and Sales Order queries.

Extensively worked on Query building, filtering, free Characteristics, Restricted Key Figures and variables, using Bex query designer.

Created Web templates in WAD (Web application designer) and published them in Netweaver portal.

Used RRI (Report-Report Interface) in order to get detailed information by switching from summary to detailed reports.

Application Environment: SAP BI

Educational Summary

Highest Degree: B.tech in Computer Science and Engineering

Contact this candidate