eval2Hire.com

Resume

Around 7 years of IT experience with 5 years of experience in SAP R/3
and over 2+ years of extensive experience in SAP BW.
· Undergone 2 full life cycle Implementation of SAP BW3.0B,3.5 which
includes Data Modeling, Data Extraction, Generic Extraction, Data Loading
(Full /Delta Up-Load), Scheduling, Monitoring, Info-objects,
Info-cubes, Info-Source, Hierarchies, Logical Information System, LO Cockpit,
Multi-Cubes, ODS objects, Process Chains, BEx- Analyzer, BEx Query,
Workbooks & Web reporting/ publishing.
· Expertise in BW 3.5 upgrade in extracting data through connectors
like BI Java SDK, BI ODBO (for OLAP), BI SAP Query.
· Expertise in Data Modeling using MDM and BW extended star schema
models.
· Expertise in OLTP Extractions from SAP R/3 using LO Cockpit, LIS,
Generic Extractions. Also extracted data from the flat files.
· Extensively used formula editor in BW and ABAP to customize update
rules to load data into the info-cubes and ODS objects.
· Involved in the postproduction support of multiple projects, which
required minor changes to the data model, developing Adhoc queries as per
the requirements.
· Proficiency in Performance Tuning using Rollups, Partition and
Compression.
· Created Queries on Info cubes and ODS Objects using BEx Analyzer.
EXPERIENCE SUMMARY:
· 2+ years of experience in SAP BW3.0 Configuration.
· 5 years of experience in SAP R/3, ABAP - ERP implementation and
software development.
· Experience with Idoc, BAPI and RFC technologies.
· Solid industrial and academic foundations in Production Planning,
Sales and Distribution and Material Management Modules.
PROFESSIONAL EXPERIENCE:
Sep’04 – Present
SAP BW Consultant
Description: Bid to Cash (BTC) - Was part of the BTC team, which was
responsible to manage sales orders to account receivables.
Responsibilities include optimizing of sales process for individual markets. Design &
develop rules, priorities for Sales Order processing, Delivery
scheduling and routing.
Responsibilities:
· Worked extensively on standard and custom defined LIS, LO extractors.
· Installed relevant SAP business content.
· Used LO structures for extracting sales order, delivery information.
Logistics Cockpit configuration and customization, Tracing problem to
R/3 and resolution.
· Customized cubes such as Sales Order cube (0SD_C03), Sales Delivery
cube
(0SD_C05). Used ODS to stage the data before transferring the ODS
contents to the InfoCube. Done ODS reporting to give details of delivery
items and schedule line items.
· Data source enhancements, generic extractors, User Exits and
customized delta
built up for the datasources, V3 Updates, controlled by pull/push
principle from OLAP system. Used BI Java SDK together with the BI Java
Connectors to access data from a wide variety of multidimensional (OLAP)
data.
· Extensive experience in data design, data modeling, star schema and
extended
star schema, ASAP methodology, Info Cube partitioning, Setting
customized Info Cube. Data extraction from R/3 and Flat file, SAP BW delta
load, Info package creation, IPG
· Resolve and implement BW Query faults (Day to Day) and change
requests.
· Involved in BEx Query Design and formatting.
· Designed SAP Query for users who have no knowledge of the ABAP by
selecting the texts, and select fields and options can edit lists.
Environment: SAP R/3 4.6C, SAP BW 3.0B, 3.5, BEX, WAS, Web reports,
WindowsNT.
Mar’03 - Aug’04
Role: SAP BW Consultant
Description:
along with its flagship companies, its Industries are into the
manufacture of Industrial chemicals, pharmaceuticals and pharmaceutical
formulations. This Project is mainly focused on Sales and Distribution,
Material Management & FI CO Modules.

Responsibilities:
· Involved in Data-modeling, Data Extraction, Data Loading, Scheduling,
Monitoring and Reporting for the MM, SD, FI/CO modules.
· Used delta update mechanisms for uploading the data to BW from R/3 in
specific intervals.
· Extracted data from MM modules and uploaded the data into the
Procurement Cubes via 2LIS_02_HDR, 2LIS_02_ITM, and 2LIS_02_SCL.
· Participated as a team member in discussion with business analyst and
end user for Data Modeling, Business Content, Granularity, and
Performance Tuning.
· Analyzing ERM, MDM and translated it to BW design. Identifying the
Key Figures, Strong Entities, and Attributes of the entities, Archiving,
Time Frame for Loading etc.
· Analyzing the SAP BW Business Content required, activating the
business content components.
· Assigned Data Sources to the Info Source, Defining Transfer
Structures, and Metadata maintenance for the Info Source and source system.
Configuring Metadata in the Administration Workbench for replication and
Updating of Data Source from the source system.
· Worked extensively on Remote Cubes in order to improve performance.
Extracted required master data from the Data Source of PSA to ODS.
Worked with ODS object, ODS query, Updating ODS object with RRI.
· Created custom Info Cubes including Update Rules. Created Queries by
defining rows, columns and free characteristics providing drill down
functionality in reporting using BEx.
· Implemented SAP delivered SD/MM Info Cubes in Business Warehouse.
Environment: SAP R/3 4.6C, SAP BW 3.0B, WAS, WinNT
Aug’02-Feb’03
Role: SAP Techno Functional SAP BW Consultant
· Involved in uploading master, transactional data related to customer
service
· Service CUBE modeling, master data modeling
· Extensively worked on BEX analyzer for creating min, max response
times, number of services attended by contact person.
· Created hierarchies for low-level service details – service area,
model name, contact person, etc.
· Wrote ABAP code for update rules to upload data into cube from ODS
based on certain filter conditions.
· Worked extensively on BEX analyzer and BEX browser. Developed
flexible queries using filters, navigational attributes in BEX analyzer to
facilitate data analysis in a drill down or summarized way to give
detailed levels of information.
Environment : SAP BW 3.0A, SAP R/3 4.6 C
Aug'01 - Jun’03
Role: Technical Consultant
Project:
Sole ABAP consultant supporting in all the areas of SAP R/3
implementation (PP, MM, SD) at clients location.
Responsibilities:
· Responsible for migrating legacy data to SAP R/3
· Developed several BDC programs to load data such as Personnel events,
Organization assignments, Personnel data, Work centers, Tasks/Routings,
BOMs, ECNs, Revision levels, Production orders, Sales Orders. Developed
various other programs to modify existing SAP data.
· Used standard SAP programs to load Material master data, Plant
maintenance, Vendors, Bills of Material and Routings.
· Developed batch programs to automate printing of Delivery-Due lists
and Transfer Order creation. Developed the required user exits for
multiple processing of Transfer Orders and Requirements.
· Developed/modified SAP scripts for Delivery notes, shipping orders,
Goods Issue slips.
· Developed an RFC function module to copy Work centers and Routings
across clients (R/3 to R/3).
· Analyzed and configured EDI in R/3's Sales and Distribution and
Materials Management. Involved in development of detailed design
documentation and testing plans. Developed data mapping schemes between R/3 and
the EDI Subsystem.
Environment: SAP R/3 4.6B, ABAP/4, Oracle 8i, ITS, Windows NT 4.0
Sep’99 – Jun ’01
Project:
AG markets a variety of home appliances. The sales and material
forecast is developed based on the vendors, customer. The historical data is
transferred through BDC.
Responsibilities:
· Develop interface and enhancements for SD and MM.
· Develop extracts and interfaces such as Vendor Extract, Customer
Extract, and Pricing Records.
· Develop interfaces for transfer of legacy data like vendor master,
material master, customer master, design coding and documentation.
· Used BDC for transferring and conversions data into SAP system.
· Modify and customize invoice, delivery note/packing list, order
confirmation, picking list, bill of shipping document in SD using SAP
Scripts.
· Involve in development of custom tables, data elements, domains,
views and Match codes using Data Dictionary.
Environment: SAP R/3 4.6B, ABAP/4, WinNT.