Data Sap
Resume:
SUSHMA PRAKASH
Tel: 813-***-****
**********@*******.***
Status : US Permanent Resident
________________________________________________________________________
Summary
. Over 6 plus years of professional experience in design, development
and implementation of business applications that includes 5 years in
SAP BW and 1 year of ABAP.
. Implementation of 3 full life cycle BW projects providing key services
such as data modeling, design support, data management advisement,
global and cross-functional metadata definition support, as well as
cross-functional technical design support for other SAP BW project
teams related to FI-CO, SD, MM, PP, SRM and CRM modules.
. Extensively involved in creating custom objects (Infocubes, ODS,
InfoObjects, Infosources etc) for meeting the customized requirements
of the clients. Involved in extracting data from non-SAP systems and
integrating with the data extracted from SAP R/3 modules to provide
consolidated analysis to the management.
. Experience in development of technical specifications from functional
requirements.
. Experience in the design, development and testing of Multi dimensional
Data Models, Info Cubes, MultiProviders, Operational Data Store (ODS),
Aggregates, InfoObjects, Data Sources, InfoSources, InfoProviders,
Transfer rules, Update rules, enhancements to data sources with User
Exits, generic data sources, BEx Analyzer, jump targets, work books.
. Expertise in Application Specific (LO-COCKPIT, COPA, SAP R/3) as well
as Generic Data Extraction methods (Views, Infosets, ABAP query
builder).
. Involved in writing ABAP/4 routines for Transfer rules, Update rules,
Start routines, enhancing standard Business Content datasources.
. Experience loading data from non-R/3 data sources - flat files and
external Databases using UD Connect, DB Connect.
. Extensive knowledge in process chains.
. Experience in communicating with SAP on BW Production Issues,
Performance Tuning, and applying recommended OSS Notes.
. Extensive experience of Queries, Calculated and Restricted key
figures, Exceptions, Conditions, BEx Analyzer, InfoSet query, Formula
builder, RRI (Report to Report interface) and Web reporting.
. Proactive performer and a team player with excellent documentation and
communication skills.
Project Experience:
JABIL
July 06 - Till Date
Sr. SAP BW Consultant
Jabil is an electronics solutions company providing comprehensive
electronics design, production and product management services to global
electronics and technology companies.
Responsibilities included designing data models, DataSources for BW 3.5
implementation.
> Involved in implementation of SAP BW for Purchasing area.
> Design, test and implement BW functionality, both back-end and front-
end.
> Created Technical Specifications.
> Completed the feasibility study of the current business process and
identified the relevant areas for customization
> Customized info objects to match report requirements by creating
variables in BEx and creating info cubes based on the data content.
> Created the required info sources and info packages to load the
appropriate data via ODS and directly in the cube based on
requirements.
> Involved in design, development and extraction from R/3 systems for MM.
> Worked extensively on standard and custom defined extractors, used to
facilitate the data extraction to BW.
> Used delta update mechanisms for uploading data to BW from R/3 in
specific intervals.
> Created & maintained transfer rules, transfer routines, update rules,
start routines to maintain data consistency.
> Extensively worked on enhancing the business content /custom data
sources for Purchasing to meet the business requirements, worked on
function modules, ABAP coding and error handling for the same
> Customized Data sources using ABAP code for functional enhancement
(User-exits) for Master and Transactional Data in to BW
> Created multi-providers for reporting.
> Designed and Created process chains.
> Worked on BEX Query Designer in designing queries using filters,
variables, navigational attributes and structures to facilitate
flexible, detailed drill down data analysis to the required level of
information.
> Training Users, Super Users in designing SRM reports and other custom
Reports for BW/BEX Reporting.
> Transported the objects from Development for QA testing and to
Production.
> Participate in meetings, as required
> Perform Knowledge Transfer to end users .
> Involved in resolving production support issues and extensively worked
on end user support.
Environment: SAP BW 3.5, SAP R/3 4.7, PUR, MM, ABAP/4, BEx Analyzer.
SBC Communications, Inc.
April 05 - July 06
Sr. SAP BW Consultant
SBC Communications, Inc. (SBC) is the second largest local telephone
company in the U.S. SBC primarily serves its traditional client set in the
thirteen (13) southwestern, mid-western and western states of the U.S. SBC
companies provide a full range of voice, data, networking and e-business
services as well as directory advertising and publishing. SBC companies
currently serve fifty-five million (55M) access lines nationwide. In
addition, SBC companies have holdings and investment in 26 other countries
worldwide. It is a Fortune 30 company traded on the NYSE under the symbol
of SBC. SBC Management have identified an opportunity to significantly
improve the sourcing of materials and tracking within the SBC enterprise.
They have also identified that by adding SAP's SRM to the project it would
solve several current problems with their Commerce One legacy system.
Responsibilities included requirements gathering from the business users
and designing data models, DataSources for BW 3.5 implementation.
> Involved in complete life cycle implementation of SAP BW for Sales and
Distribution, Inventory Management, Purchasing and Supplier
Relationship Management modules.
> Design, test and implement BW functionality, both back-end and front-
end.
> Created Technical Specifications.
> Completed the feasibility study of the current business process and
identified the relevant areas for customization
> Customized info objects to match report requirements by creating
variables in BEx and creating info cubes based on the data content.
> Created the required info sources and info packages to load the
appropriate data via ODS and directly in the cube based on
requirements.
> Involved in design, development and extraction from R/3 systems for SD,
SRM and MM.
> Worked extensively on standard and custom defined extractors, used to
facilitate the data extraction to BW.
> Used delta update mechanisms for uploading data to BW from R/3 in
specific intervals.
> Created & maintained transfer rules, transfer routines, update rules,
start routines to maintain data consistency.
> Extensively worked on enhancing the business content /custom data
sources for Purchasing and SD to meet the business requirements, worked
on function modules, ABAP coding and error handling for the same
> Customized Data sources using ABAP code for functional enhancement
(User-exits) for Master and Transactional Data in to BW
> Created multi-providers for reporting.
> Designed and Created process chains.
> Worked on BEX Query Designer in designing queries using filters,
variables, navigational attributes and structures to facilitate
flexible, detailed drill down data analysis to the required level of
information.
> Published the Queries on the web portal, developed unique approach for
query design to work with end-user web dashboard presentation
requirements.
> Training Users, Super Users in designing SRM reports and other custom
Reports for BW/BEX Reporting.
> Transported the objects from Development for QA testing and to
Production.
> Participate in meetings, as required
> Perform Knowledge Transfer to SBC BW Staff.
> Involved in resolving production support issues and extensively worked
on end user support.
Environment: SAP BW 3.5, SAP R/3 4.7, PUR, SD, MM, ABAP/4, BEx Analyzer.
Forest pharmaceutical Inc. Dec 04 -
April 05
Sr. SAP BW Consultant
Forest pharmaceutical Inc. is implementing SAP BW Data Warehouse and
Reporting solution to integrate and consolidate the SAP CRM 'Sales Force
Administration data' with the 'IMS data'.
Responsibilities included requirements gathering from the business users
and designing data models, DataSources for BW 3.5 implementation.
> Identified required standard business content objects, installed and
activated the same. Enhanced some of the data sources with append
field structure and populated additional data in customer-function.
> Worked on Data Modeling for custom InfoCubes for IMS Alignment data to
integrate with the Call Activity data from SAP CRM.
> Designed custom ODS Objects for Call Activity, Extracted data from CRM
using Views/tables and InfoSet Query.
> Designed ODS staging layer to store transaction data from 'Early
View',
> 'Xponent' and 'IC Org Sales' sources. This enables the Data
transformation and provides delta capability for the huge volumes of
data.
> Developed MultiProviders across basic cubes to provide consolidated
query view on IMS Prescriber Monthly and weekly aligned data.
> Coordinated with Informatica team to load the IMS data from legacy
systems.
> Designed the interfaces to map external data from Informatica to SAP
BW using Informatica Power Connect.
> Extracted data from BW InfoProviders using InfoSpokes with Open Hub
Functionality to external systems through flat files and separate DB
tables.
> Extracted Sales Territory, Call Panel data into SAP CRM systems using
Analysis Process Designer tool.
> Responsible for the SAP OSS management and Transports to coordinate
with Basis team.
> Completed successfully the Unit Test and System test. Prepared the
test scripts. Conducted the walk-through for each business scenarios.
> Loaded the Master data for Business partner, Product and Territory.
> Designed, built and extracted the sample allocations data from SAP
CRM.
> Designed, built and extracted the R/3 data such as returns, inventory
and Orders into BW.
> The Time Off Territory data is extracted into BW from SAP CRM.
Environment:SAP BW 3.5/3.1c/3.0b/2.1c, SAP R/3 4.6c/4.0b, ABAP/4, SD, MM,
FI/CO, SAP BW, Business Explorer (BEx), WAS 6.2, Web Application Designer,
MS-Office, MS Proj, SQL, C, C++, Java, Java Script, HTML, Oracle 8i,
Windows 9X, XP, 2000,NT, SAP CRM 4.0
Pittsburg, PA Jul 03 - Nov 04
SAP BW Consultant
Environment: SAP BW 3.1c, BW Business Explorer, ABAP/4, SAP R/3 4.6c,
ORACLE 8.1.7.2.0, Windows 2000, UNIX.
As a team member involved in the complete SAP BW (Business Information
Warehouse) implementation for integrating and consolidating data from
FI/CO, SD, MM, CS modules into SAP BW system.
Responsibilities:
> Involved in gathering business requirements from business analyst for
sizing and data modeling.
> Analysis of data requirements and translation of these requirements
into dimensional data models using star-schema and extended star-
schema data modeling techniques, with an emphasis on actual
implementation in BW.
> Handled Transport process in BW to move Metadata from Development to
QA server and finally to production server.
> Installed and extended standard Business Content based on client
requirements for enhancing DataSources for transaction data and master
data.
> Created InfoObjects, DataSources, InfoSources, Data targets,
InfoPackages and InfoCubes to load Master and Transactional data from
SAP R/3 system into BW system.
> Developed Transfer Rules to extract data from various DataSources into
transfer Structures. Extensively involved in ABAP/4 routines for
Transfer/Update rules, Transfer/Update routines, Start routines,
enhancing standard Business Content datasources.
> Extracted data from SAP R/3 using LO Cockpit (LBWE), COPA and Generic
extractors, also extracted data from non-R/3 systems using flat files
with the help of Infosources.
> Created Process Chains and event Triggers for job scheduling.
> Created, Maintained and modified existing queries on different
InfoCubes related to SD, MM, CS and FI/CO modules. Extensively worked
on Query building, filtering data, Structures, Variables.
> Preformed various tuning techniques (aggregates, statistics and
partitioning) to optimize the query performance.
> Involved in Go-Live and Tested everything in the production
environment.
> Involved actively in supporting the various issues addressed by the
Users from the client side and providing them with required solutions
> Developed a training plan and communicated with the Super Users on a
regular basis to ensure successful execution of the plan.
Rochester, NY
May 02 - Jul 03
SAP BW Consultant
Environment: SAP R/3 4.6C, SAP-BW 3.1, SD, FI and MM, Windows 2000/NT.
The goal of this implementation was to replace the current R/3 reporting
instance with Bex Reporting (BW 3.1 version).implemented BW as its data-
warehousing tool for its strategic reporting needs.
> Involved in complete life cycle Implementation which includes Data-
Modeling, Data Extraction, Generic Extraction, Data Loading (Full
/Delta Up-Load), Scheduling, Monitoring, Info-cubes, Info-Source,
Logical Information System (LIS), LO Cockpit, Multi-Cubes, Remote
Cubes, CO-PA, FI-SL, ODS objects, Bex- Analyzer, Bex Query, Work books
& Web reporting/ publishing.
> Managed SAP teams, conducted design workshops, and built interfaces
and conversions to/from SAP systems and external systems.
> Developed technical guidelines for reusable interfaces and
conversions.
> Involved in solving the problem encountered during master data as well
as transaction data loading in production system and solved it
applying OSS Notes.
> Worked on BEX Query Analyzer, defined Restricted and Calculated Key
Figures, Structures, Multiple Structures in one query, Hierarchies,
Attributes and Formulas.
> Used characteristic Hierarchy and Hierarchy Node, test and Formula
Variables. Different Processing types like Manual Entry/Default Value,
Replacement Path, Customer Exit, SAP Exit and Authorization
> Worked extensively on the RRI (Report to Report interface) feature to
jump between the queries to analyze the data.
> Assigned queries to different User Catalog on client specification.
> Involved in Go-Live and testing in the production environment.
> Handled post-production support and development of new design cycles
simultaneously
Milpitas, CA
Nov 01 - May 02
SAP BW Consultant
Environment: SAP BW 2.1C/2.0B, SAP R/3 4.6C, BEx Analyzer, MM, SD modules.
> Involved in complete life cycle Implementation of BW 2.0B which
includes Data-Modeling, Data Extraction, Generic Extraction, Data
Loading (Full /Delta Up-Load), Scheduling, Monitoring, Info-cubes,
Info-Source, Logical Information System (LIS), LO Cockpit, Multi-
Cubes, Remote Cubes, CO-PA, FI-SL, ODS objects, Bex- Analyzer, Bex
Query, Work books & Web reporting/ publishing. Exposed to full
software lifecycle right from analysis, design specification,
development, performance tuning, testing, documentation, maintenance,
trouble-shooting etc
> Prepared functional specifications based on requirements in
procurement and inventory Management
> Developed basic cubes for sales and controlling areas like procurement
cube, cost center cube, order status cube
> Uploaded master data and transactional data from SAP R/3 Via Data
staging to PSA, ODS and Info cubes and worked with data flows from SAP
R/3 to BW
> Created Data Sources Via RSO2 R/3 using Database views and info set
queries for Master and transactional Data
> Configured and customized data sources, info sources and Info cubes
> Created info package groups by Setting up of info packages for master
data, transactional data
> Worked on LO- Cockpit, application specific and generic extractors
> Created roles and authorizations on InfoObjects, info cubes, and
variables
> Tailored transfer structures, communication structures and update
Rules
> Executed Hierarchy /attribute changes for reporting
> Created Queries, variables, filters, calculated key figures,
restricted key figures and workbooks.
ABAP/4 Programmer Dec 00 - Nov 01
Environment: SAP R/3 4.6a, ABAP/4 Development Workbench, Win NT.
> Provided ABAP/4 Support in the implementation of SAP R/3.
> Generation of Classical Reports and Interactive Reports, Dialog
Programming using Screen Painter, Flow Logic and Module Pool program.
> Worked on Data Dictionary objects (tables, structures, views, data
elements, domains) ABAP/4 tools (Menu Painter and Screen Painter
etc.,) and Modularization Techniques.
> Developed and modified existing SAP forms and written Print Programs
for layout sets using SAP Scripts.
> Report 1 - Source Code for Materials showing stocks existing in
various types and at different Organisational levels like Company,
Plant and Storage Location.
> Report 2 - Source Code for list of PO's under a Plant and Vendor along
with Quantity, Material, and Order value as consolidated screen.
> Report 3 - Delivery Due List Report: This report gives the detailed
information orders to be delivered in due.
> Report 4 - Material Usage Report. This report gives the detailed
information of raw material Consumption.
> Designed SAP Scripts based on client requirement by using paragraphs,
pages, windows and page windows. Designed variable windows on a page
based on client requirements. Worked on SAP Script with graphical
format.
ABAP Programmer, Jun 00 - Dec 00
Environment: SAP R/3 4.6C, ABAP/4 Development Workbench, Win NT4.
> Created Report in Material Master that outputs Material Vaulted Stock,
grouped by Material type and Plant. The output shows Material No.,
Storage Location, Unit of Measure and Description in addition to group
totals.
> Created missing quantity list that gives the difference between sent
and received quantities during Stock Transfer.
> Created an interactive report program to give details on Sales orders
Customer-wise and stock availability at each stock location.
> Created an interactive report program for listing the pending items to
be ordered, received and invoiced for a given purchase requisition on
each purchasing organization and purchasing group.
> Created Vendor- Performance Report that lists Vendor Name, Materials
Supplied, Planned & Actual Delivery Times, Payments Terms and Prices.
> Created a Report to display a list of Purchase Requisitions with
details like MRP Controller, Release Date and Unit of Measure along
with standard details.
> Uploaded data from sequential file to create multiple material master
records.
> Uploaded Material master-Consumption, Pricing and Purchase info
records from legacy system to R/3.
> Developed BDC Program for transferring Customer Master record and
Purchase information record with multiple item details using Session
and Call Transaction method.
Education/Certifications
BS
Technical Skills
SAP BW 3.5, SAP R/3 4.7, SRM 4.0, CRM 4.0
SAP BW 3.1c/3.0b/2.1c, SAP R/3 4.6c/4.0b, ABAP/4, SD, MM, FI/CO, SAP BW,
Business Explorer (BEx), WAS 6.2, Web Application Designer, MS-Office, MS
Proj, SQL, C, C++, Java, Java Script, HTML, Oracle 8i, Windows 9X, XP,
2000,NT.
Contact this candidate