Summary

4 years of experience in IT relating to SAP R/3, APO with BW.

Undergone specialized skilled training on APO-DP, BW and SAP-PP under guidance of Business Integration Solution US based company.

Performed many case studies on APO-DP, BW.

Worked on 2 SAP APO-DP and BW development and support projects. This includes SCM-APO Demand Planning and BW. Knowledge on BW Business Content BW Modeling, BW Interface with APO 2.0/3.0. Experience in R/3 SD, MM,

Strong skills in the integration of PP, BW, MM, APO-DP modules.

Expertise in SAP BW. Expert in designing, implementing Info Cube, Info Sources, Transfer and Communication Structures and BEx Reporting.

Expertise in SAP-APO-DP designs, development of info cubes, POS, PA, Planning books

Did end to end data loading between R/3 - BW-APO designs.

Have good knowledge is BW Extractors LIS, LO-COCK PIT, COPA, Business Content, TABLES/VIEWS0

Have good knowledge in MM, PP and SD modules. Capability to configure all the 3 modules.

Have good Analytical and Communication skills and is a good team member.


Employment

2002 -  2003

Education

Miscellaneous

Undergone specialized SAP-PP, APO_DP and BW end-to-end training by BIS, Inc

TECHNICAL SKILLS
SAP R/3 like MM, SD, PP, APO3.1 - DP
Windows NT, Windows 9x
C++, JAVA like JDBC, Servlets, RMI, J2EE.
HTML, DHTML, JAVASCRIPT, XML.
MS-Office, Visual Basic.

Highlights of SAP APO and BW Experience Involves :
Used Administrative Workbench to create Info cube with parameters, info objects, multiple characteristics and key figures with appropriate transfer and update rules.

Major functionalities used :
APO DP : -

Planning Object structure creation, Planning areas, Planning Book, Storage Buckets Profile and Interactive Demand planning, macro creation for copy key figures

Configured various planning books in APO which consist of tree controls, planning grids, graphics and etc and used them to extract and display results from Info cube.

Data Extraction from BW to APO system and from Planning Area to Info cubes.

Generates the BEx Reporting between actual data and planned data and facilitating the clients to analyze the Business scenarios.

Involved in Extraction and loading of SAP R/3 data like sales and distribution, Logistics etc.

Scheduled and monitored data loads.

Loaded DP Data Mart from LIS R/3 to APO, Non R/3 to APO and worked with generation of characteristics combinations and their validation.

Used and worked on generic data extractors, customer exits and. Creating and Customizing Info Cubes, Multi-Cubes, Remote Cubes.

Experienced in creating Roles and assigning various roles to Report trees.

SKILLS
of Business Information Warehouse :
BW Administrator Workbench, Modeling, Source System, Info Source, Info Object Catalog, Create Info Cubes, Multi-cubes, Extractors, Info Packages, Staging Engine, Key figures, Characteristics.

ODS Objects, PSA, Update rules, Hierarchies, Aggregates Scheduler, Metadata Repository Business Explorer, BEX Browser, Selecting and Organizing Documents, BEX Analyzer, Web Reporting, Queries in Workbooks Evaluating Query Data, Calculated/Restricted Key Figures, Defining Queries, Excel, Using Variables, Data Transfer, Data scheduler, Report Builder.

Integration BW, MM, SD, APO-DP.

Configure BW prototype Configure Data Extraction, Configure BW Master Data Structures, Configure BW External Hierarchies, Configure Transactional and Master Data, Info Sources, Configure Transfer Rules For Master and Transaction Data, Configure Update Rules, Configure Load Procedures.

SKILLS
of R/3 Production Planning

High level of SAP R/3 PP and APO Supply Chain management skills

Business process Analysis, Design, Configuration, Data Conversion, System testing, System Cutover strategy and go live expertise on SAP R/3 PP, MM, SD

4.0.B to 4.6 .C, 3.1I to 4.6, 3.1 .H to 3.1I

Organization : Business Integration Solutions, Inc

Feb 2003 to till date.

Environment : SAP R/3 4.5b/4.6c, APO3.0, BW 3.0B, MM, SD, PP, BW Administration Workbench.

Projects- LSI Logic

Role : BW consultant with APO Support

SAP R/3, APO and BW Experience :
This company manufactures storage systems, disk drives, controller modules, systems etc to various major global leaders like IBM, NCR, STK, Dell etc..

LSI has multiple sites globally but this project is based in US

We do development of all DP and BW objects and support some existing live sites for APO-DP and BW.

Details of the work :
Involved in analysis and design of APO-DP and BW designs for this plant.

Major functionalities used : APO DP : - Planning Object structure creation, Planning areas, Planning Book

Loaded DP Data Mart from LIS R/3 to APO, Non R/3 to APO and worked with generation of characteristics combinations and their validation.

Extended LIS Communication Structure to facilitate the design for the new structures. Developed User- Exits to populate the extended structure.

worked on activating the standard delivered business content of LIS in the form of Info Objects, Info Sources, Info Cubes, ODS and customizing it by creating new business content.

Created Info sources for Master Data and Transactional data, assigned Data Source to Info source, Created and Activated Transfer Rules, Maintained Communication structure, Created and Scheduled Info packages for data extract, set the update rules for Info cube and uploaded data.

Responsible for planning and implementing the overall batch load schedule for the data warehouse, setting up batch jobs, triggering events, use of event chains and Info Package groups

Expertise includes flat file extraction of master data and transaction data of Non-SAP R/3 systems into BW through data staging to PSA and Info Cube or ODS.

Used delta update mechanisms for uploading the data to BW from R/3 in specific intervals. Created Info Sources, Info Cubes, Aggregates, ODS for incoming sales orders according to sales organization, distribution channels, ship-to-party customers, material, vendor line items and creating ledgers.

Created customizing LIS and LO Cockpit extract structures and data sources in sales and distribution, inventory management and material management to facilitate the data extraction to BW and to reporting using classification of various data elements. Extended the extract structures by adding new fields and populating them with the user/function exits.

Develop end-to-end integrated process test scripts and fix the failed test scenarios. The testing involved security profile checks and printing of multiple documents.

Project :
Offshore design and development project

Created and Activated Custom Info cube as per the Data model for Sales area covering

Studying the User requirements, Preparing High Level Technical Specifications, Preparing Technical Specification, Preparing Unit Test Strategies, Test Cases, Test Plan, Coding and Testing the Unit Test Plan, Documenting the Test Results and Train the User.

Studying the User requirements and existing Developed Programs and Layout Sets,
Modified Print Programs, Transactions and Layout Sets to get the User required Output.

Honeywell

Worked extensively on Info Cubes. Have a strong understanding of database design, data modeling, OLAP and knowledge of SAP BW components and end-to-end cube development.

Requirement gathering

Study during the initial phase,
Detailed design by looking at their existing used reports,
Designed details of all info cubes required

Data modeling of various activities and
Data storage design in R/3 towards staging.

We used existing SOP structures and plans. We used various standard and custom attributes tables and characteristics for effective reporting through BEX and interfaced with Informatics reports which are used there.

Master Data Configuration : Created material groups, setup quantity, value, valuation control and valuation area grouping and valuation classes.

Organizational Data Configuration : Created plants, storage locations, purchasing organizations and groups. Assigned plants, purchase organizations to company code, Assigned factory calendar to plants and plants to purchasing organization.

Configured planning strategies and requirements type, creation of MRP elements, basic and lead time scheduling, strategy group and strategy group to MRP group assignments, define MRP controllers, plant parameters, lot size calculations, planning horizons, material availability in blocked and stock in transfer, basic dates determination, BOM explosion control, storage location MRPs.

Set up raw material planning using MRP. Set up bulk item in such a way that rail or truck shipment schedules are updated by MRP using scheduling agreements.

Helped on users issues and post implementation support of issues.

Designed and Conducted Regression testing, Unit testing, Integration testing.

Did simulation of various BEX reports and integrated with PP, MM, SD

In production planning created materials, Bill of materials, Work centers, Routings, created all configuration related to Production planning in IMG and did plant parameters setting and MRP group setting and all other settings related to production planning orders, operations, release procedures, confirmation and back flushing procedures and etc

Case Study-APO-DP

Created info cubes, info objects required for APO-DP and BW.

Designed data model and batch job sequence for automation of all batch jobs by creating activities, mass processing jobs and sequenced them and successfully product ionized them.

Created POS, PA, planning books with different data views and macros.

Worked with CIF for transfer of master data and transactional data required for APO-SNP.

Worked on APO data mart.

Experience in Development, Customizing of Application Software, Production Support and ERP solutions.

Provided trouble shooting in demand planning for all users from time to time.

Participate with process teams to identify conversion and interface requirements to SAP and implement techniques for interface construction, error detection and data recovery or synchronization. Based on client required was involved in complete design and build for APO-DP and BW and R3 - MM, SD, PP master data as well.

Worked and supported on APO-DP configuration and transports.

Created user documentation and test scripts for integration testing

Case Study BW

As a team member involved in standard or customized infocubes and ODS objects.

Installed BW standard business content infocubes and technical cubes.

Worked extensively on standard and custom defined LIS, LO extractors.

Used LO Structures for extracting sales order and delivery billing information.

Logistics cockpit configuration and customization for sales order overview.

Developed and scheduled Business content data extraction from SAP R/3

Created update rules, transfer rules as per client requirement.

Data Extraction from R/3, creating info packages, event scheduling.

Used ODS to stage the data before transferring the ODS content of the Info cube.

Uploaded master and Transactional data from files and SAP as the OLTP source.

Worked Extensively on administration workbench.

Customized info-objects, infosources and infocubes.

Used Bex Analyzer for normal query designing.

Bex Query reporting, install Business Content, Generic Extraction

R/3 - PP/MM Case Study

Have configured IMG part of R/3 relating to MM, SD and PP modules. Have configured the company and all the necessary parameters.

Have worked on various plannings like Forecast Based Planning, Reorder point planning, MRP, MPS.

Have worked on planning strategies like Make to order, Make to Stock, Planning with Final assembly, Planning without Final assembly.

Have created Contracts, Scheduling agreements, Quota Arrangement, Automatic Creating of Purchase Orders.

Have created Bill of Material, Work center, Routings and designed Product Groups in PP.

Have worked on Sub Contracting, third party processing, Intra Company stock transfer, Cross Company Stock Transfer.

Have good knowledge in Inventory Management.

Have implemented the complete MM, PP, SD cycle and integrated them.

Training by Business Integration Solutions, Inc

APO-DP

BW

SAP-R/3 - PP, MM