SUMMARY:

• Having 5+ years of techno - functional expertise in SAP with specialization in SAP NetWeaver BW/HANA, BODS and SAP R/3.
• Implemented full life cycle implementation projects in BW being involved in requirements gathering, business blueprint, realization (configuration, customization, unit testing, system & integration testing and data preparation for go-live), final preparation (end user training & cut over activities) and Go-Live & support.
• In depth experience of working on data modelling, extraction, transformation & loading, customizations & configurations, reporting, performance improvement and upgrade activities (ECC 6.0 upgrade and SAP R/3, BW 7.0,7.3, 7.5 upgrade).
• Expertise in SAP HANA Datareplication, DataModeling & BI.
• Expertise in Advanced Analysis for OLAP & Office with BW Queries

TECHNICAL SKILLS:

• SAP BW Powered by SAP HANA - Value proposition for SAP BW using new SAP HANA objects such as new composite provider, Advanced Datastore object and Open ODS views.
• Data Modelling - Extensively involved in business content activation, custom Info cubes, ODS objects, transfer and update rules, Multi providers & Info sets based on projects requirements.
• Extraction, Transformation & Loading - Experience of working on BW content extractors (LIS, LO cockpit, CO-PA and FI-SL) & generic extractors (based on view, Info sets & function modules) for loading master & transactional data.
• Reporting - Developed reports in BEx analyser & query designer. Built queries using calculated key figures, restricted key figures, variables, structures, exceptions & conditions, creating workbooks. Also created jump queries (report to report interface (RRI)), web templates & web queries.
• HANA Modelling- Modelling using Different types of views, SAP HANA Data provisioning using SAP Landscape Transformation and SAP Data services, DXC, Flat File Uploader, SAP HANA Architecture.
• BODS Experience- Developed Batch Jobs and Real-Time jobs. Created Work flows, Data Flows, Adapter Instances, Webservices, Central Repository’s, ABAP Work flows, Management Console.
• ECC 6.0 Upgrade - Worked on upgrade testing of ECC 6.0 with SAP BW 3.0 clearing delta queue, tRFC queue, processing IDOCs, correcting failed loads.
• Upgrade Experience (BW 3.0 to BI 7) - Worked on pre- & post upgrade activities, resolved issues occurred in UNICODE conversion, query validations, Infospoke etc.
• Performance Improvement - Implemented performance improvement technique for extraction, modelling and reporting.
• Data Load Monitoring - Data load monitoring, extractor checker, process chain creation and monitoring, & error handling (reload, repair).
• User Exits - Expertise in writing user exits for datasource enhancements and writing customer exit variables.
• BW Support - Strong hold in providing support & maintenance of BW systems and resolving issues on time.
• Miscellaneous Activities - BW transport management, BW statistics,

TECHNICAL SKILLS:

SAP Versions: SAP R/3, ECC 6.0

HANA Versions: SAP HANA (1.0)

BW Versions: BW 7.0, 7.3, BW powered by HANA 7.5 Upgrade

BODS Versions: BODS 4.2

Reporting suites: Business Explorer (BEx), Web application designer

Databases: HANA,Oracle 8i, Oracle 9i, Oracle 10G

Languages: SAP ABAP/4 and C

PROFESSIONAL EXPERIENCE:

Confidential

SAP BODS HANA Consultant

Responsibilities:

• Involving different Sprints in Confidential Project
• Installed & configured BODS XI 4.2 in Development & Production Server.
• Created Local, Central and in SQL Server 2008 R2 and configured Local and Profiler repositories with Job server and Management console.
• Configured the Data services to connect to the SAP R/3, BI and CRM.
• Developed workflows to load data into Customer, Material, Sales, Quality and Pricing tables from legacy systems.
• Created Transforms, Adaptors, Batch jobs, Real Time jobs, Webservices from ECC and SLT system.
• Worked extensively with Sales & Distribution team to design data migration from Legacy system to SAP.
• Used Data Integrator and Platform Transforms extensively.
• Worked on the vendor master, customer master and material master IDOCS: CREMAS, DEBMAS and MATMAS.
• Interacted with both Legacy and Functional teams to design the mapping to load data into Customer Master IDOC (DEBMAS06).
• Moved the projects from DEV to ST, ST to UAT and UAT to Production.
• Scheduled the jobs, managed users and repositories in Management Console.

Confidential

SAP BW HANA Consultant

Responsibilities:

• Involved in preparation of Business Blue Print.
• Involved in implementing SAP BW. Involved in designing the data flow from R/3 to BW also responsible for deployment, Validation and Unit testing.
• Installation of relevant SAP Business Content and Customized when Required.
• Involved in creation of Customized Info Objects, Info Sources, Info Cubes, ODS, Info
• Package, DTP, Transformation, Info sets and Multi Providers.
• Generated and Maintained Aggregates and Rollup Activities.
• Setting up of procedures for Extracting data from SAP R/3 by using Generic Extraction and
• Customized LO Cockpit as per Requirements.
• Created Generic Data sources based on Table/View.
• Developed a Report (Fill Rate) displayed the customer deviations from their Schedule
• Requirements
• Created Process Chains for automating the loads.
• Responsibilities included requirement gathering, Data Modelling, Plan/Scheduling data input from
• Source Systems, Interface with users for Standard Reports, Gap Analysis, and Associated Solutions.
• Involved in creation of reports for SD, MM in Reporting Environment using, Query
• Designer and organizing Workbooks in BEx Browser.
• Designed and Developed Queries to Generate Reports in BEx Analyzer.
• Involved in designing the BEx queries using BEx Query Designer with - Structures, Calculated
• Key figures, Restricted Key figures, Variables, Conditions, and Exceptions.
• Installed Business Content Objects and analysed the fields and compared with the Reporting Requirements.

Confidential

SAP BI Application Consultant

Responsibilities:

• Performed requirements gathering for Asset Tracking functionality from various business units (Core ECC - Purchasing team and EBP (Enterprise Buyer Portal) SRM Procurement Team.
• Suggested high level design (HLD) for the BI reporting solution. Also issued technical design documents.
• Implemented end to end BI solution. Installed business content datasources (2LIS 03 BX, 2LIS 03 BF and 2LIS 03 UM) for Stock Initialization, Goods Movement and Material revaluation functionalities. Enhanced content datasources to populate additional fields required by business to satisfy customised reporting.
• Performed layered data modelling using DSO and cubes (0IC C03 - Goods Movement Cube) to populate data from above datasources. Worked on the non-cumulative KFs and in and out flow KFs.
• Delivered complete reporting suite having 7 workbooks to satisfy reporting requirements such as Vendor returns reports, Credited and Salvaged items reports, Fitting room KPI reports, QC KPI reports, Delivery completion reports, Stock overview reports and Average stock value positions reports.
• Also delivered reporting on EBP - Procurement targets (0BBP SC: Shopping Cart Individual Documents). The report delivered was – Stock transport order reporting on quantity ordered by different officers.
• Complete reporting suite was developed using CKFs, RKFs, Exceptions, Conditions, and Exception Aggregations etc.
• Delivered “Information Broadcasting” via Email into key officer’s mailbox to allow audit reports on grade C officers.
• Created Roles (Composite & reporting) and Authorisations for the new BI users.
• Helped external BAU Vendor to test functionalities implemented by their development team.

Confidential

SAP BW / ABAP Consultant

Responsibilities:

• Project was implemented to transform existing SAP R3 report suite into SAP BW 3.5 reporting suite.
• Captured business requirements to transform existing R/3 custom reports, producing functional specs, developing prototype & sign off from user.
• Understanding business logic, exploring SAP standard business contents matching the requirements & installing them. GAP Analysis and filling the gaps by append structures for content datasources, creating generic extractors, creating custom cubes, ODS objects, multiproviders and infosets in MM, SD, HR areas.
• Installed business contents for LO data extractions Ex. 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASCL for customer order extractions and 2LIS 12 VCHDR, 2LIS 12 VCITM for delivery data extractions. Enhanced extractors to satisfy custom field requirements (Ex. 2LIS 02 ACC – Purchasing data specific to account assignment & 0MM PUR VE 01 - Vendor evaluation data).
• Developed procurement related reports (0BBP PO Q004 – Purchase orders per cost centre, 0BBP PO Q006 - Purchase orders per vendor, 0BBP PO Q002 - Purchase orders per product category) using query designer.
• Created queries with filters, RKF, CKF, exceptions & conditions. Performance tuning of queries using aggregates, partitioning & compression. Creation of web templates using web items incorporating logos and organisational stationary in Web Application Designer.
• Provided jump targets (RRIs) for different reports, assigning web templates to roles, broadcasting reports into user’s mailboxes using reporting agent. Also worked on BPS functionality in project scenarios.

Confidential

SAP BW Developer

Responsibilities:

• Interacted with business analysts, end users and functional experts to identify and analyze the requirements and developed necessary reports.
• Involved in Creating and maintaining Info-Cubes, DSO, PSA, Info Objects, Info Areas, Multi-provider, Data Sources and Info Packages.
• Designed and developed process chains for master & transaction data Loads, and these Process chain are scheduled for periodic loads.
• Involved on analysis authorization restriction as per user roles by using RSECADMIN.
• Involved in writing Routine to load data Dynamically from Flat File to BW.
• Created custom Queries and defined Calculated Key figure and Restricted Key figure, Conditions and Exceptions, Text, Formula and Characteristics Value variables with Customer Exit, Replacement Path etc.,