Brahma Reddy
E-Mail: abh4xw@r.postjobfree.com
SAP APO Technical Consultant
Summary:
. Have 9 years of experience in SAP as a Technical Consultant. Was part
of implementation teams, Rollouts and Production Support Teams at
multinational companies like Nike, Inc, Autodesk, Watson
Pharmaceuticals, Honeywell Aero, Honeywell SM, and GSK with working
experience in SD, MM, WM, IM, PM, AFS, APO and PP modules and
currently working in APO implementation project at Nike.
. Strong expertise in,
. Analyzing the requirements and Functional Specifications,
. Preparing Technical Specifications,
. Coding and Modularization,
. Optimizing and performance tuning techniques,
. Unit Testing,
. Reviewing the developed Objects.
. Extensive working knowledge of ABAP/4 Workbench, Data Dictionary,
Interfaces
. Expertise in Classical and Interactive Reporting, Dialog Programming
. Expertise in Advanced reporting tool ALV
. Good working Experience in SAP Scripts and Smart forms
. Experience in creating RFC interfaces and BAPI Programming
. Worked on Standard User Exits to enhance the functionality of Standard
Business applications and Enhancements
. Data Transfers using Batch Input methods, LSMW and Background
processing.
. Worked on developing the custom IDOC programs and ALE.
. Good conceptual knowledge in design and development of business work
flows.
. Knowledge in SAP BW 3.5
. Knowledge in SAP XI
. Work independently and collaboratively with team members to achieve
common goals, while maintaining responsibilities and commitments.
Excellent presentation and negotiation skill, easily communicate with
users, Software developers and executives to get the functional
requirements.
Technical skills:
ERP SAP R/3 in ECC, 4.7 and 4.6C
Operating Systems Ms-Dos, UNIX and Windows 95/98
Languages C, C++, JAVA and ABAP/4
Databases Oracle 8.0
Front End Visual Basic 6.0, SAP GUI
Professional Experience:
Client : Nike Inc., Beaverton, OR
Project Duration : Dec'07 to till date
Modules : SCM-APO and BI
Client Description:
Worked as an SAP ABAP Consultant for the client Nike which incorporated in
1968, who is engaged in the design, development, and worldwide marketing of
footwear, apparel, equipment, and accessory products .Nike sells athletic
footwear and athletic apparel, and sells its products to retail accounts,
through Nike-owned retail stores, and through a mix of independent
distributors and licensees, in over 180 countries worldwide
Responsible for:
. Involved in end to end development of copy booking macros
functionality in APO
. Performed the Role of CIF administrator during Go Live and post Go
live activities. Monitoring the system during the dry run and Cut over
activities to make the System available for Go Live in time.
. Also designed the entire batch design of CIF for all the geographies
and regions in Nike supporting the Business.
. Developed a custom program to upload the Notes from Planner DA System
into Planning Books as part of conversions in DP.
. Developed NIKE custom BAPI's used to load supplementary SNP data into
APO Custom tables built for DP-SNP Release. This data was used for DP-
SNP Release.
. Wrote user test case scenarios for custom developed ABAP Programs,
BAPI's, Standard Function modules required to load data into APO
through Informatica.
. Build and Activate Integration models for Integrating Master and
Transaction data.
. Monitoring the system activities during the data integration from R/3
to APO systems.
. Developed a custom program to change key figure values in the planning
book for Buy Bar project. Also did performance testing for this
program and reported bug in standard BAPI.
. Implemented BADI's to enhance the functionality of Standard BAPI's
used for extracting Delivery plan and Demand Plan from SAP.
. Modified user exits for Copy booking of key figures, Created user exit
macros in the planning book, Created activities, Created job numbers.
. Modified User exits for populating additional selection criteria in
the planning book, which does not exist in the MPOS.
. Developed a custom program to lock out users from the system while the
DP Batch is running.
. Developed a custom program for Planning Area notes realignment to keep
the notes and the changed CVC's in sync so that planner may not lose
the notes.
. Developed a custom program to mass upload the MRP controller field in
the MARC table and also strategy group controller. Used parallel
processing logic in this program.
. Developed a custom program to validate the data after DP2SNP and CTM
runs happen, this was a critical report.
. Debugging the CIF related function modules in case of any failed
queues to investigate the errors.
. Trained Informatica users to demonstrate the working of BAPI and how
to use BAPI's as Informatica transformations.
. Build ODS objects to load early shipment sales orders data from
TeraData to APO Staging.
. Build characteristics and key figures required for building planning
areas in APO DP.
. Created Info Packages for loading the data for the above mentioned
Info Objects through Informatica.
. Build Process for Copy booking of key figures for various regions,
build process chains for loading info objects.
. Build Info Spokes for loading data into TeraData staging from APO.
. Modified custom program to embed the logic which would update the
status of process chain jobs to Autosys scheduler to report the
correct status.
. Developed an RFC function module to create Purchase document numbers
by using BAPI (BAPI_PO_CREATE1), which has to trigger from the
external system(web methods)
. Developed an RFC function module to Change the Contracts by using BAPI
(BAPI_CUSTOMERCONTRACT_CHANGE), which has to trigger from the external
system(web methods)
. Designed and coded for the User-Exit to override customer material
number based on Custom table entries for particular doc types based on
certain criteria
. Developed wrapper program to fetch the Purchase order information
based on various selections and filling the same in dynamic selection
of ME2N and ME2K
. Involved in an on-call rotation to support the NIKE SCM Demand
Planning system.
. 1st level, 24/7 support including all batches, all systems. (Includes
Flexible Planner, PlannerDA, APO, BW, Oracle, i2 and UNIX-based
systems.)
. Supporting server outages which can impact the batch runs. Involves
batch planning, coordination and execution around outages. (Includes
weekend support and monitoring.)
. Performed batch setup, support and monitoring during twice-yearly
release testing cycles (HUT/SIT/WIL/Dry Run).
. Developed several Data dictionary objects and conversion Programs
. Used the Enhancement SDVFX002 and function module exit
EXIT_SAPLV60B_002 to populate proforma document number to assignment
field in FI documents(FI/CO)
. Worked on bug fixes to R/3 systems including FP/PDA & SRI.
. Worked on business approved enhancements to R/3 systems including
FP/PDA & SRI.
Client : Autodesk Inc., San Rafael, CA
Project Duration : July'07 to Nov' 07
Modules : SD and PS
Environment : SAP ECC 5.0, Oracle 9, O/S: WIN NT 4.X
Client Description:
Autodesk, Inc. is the world leader in 2D and 3D design software for the
manufacturing, building and construction, and media and entertainment
markets. Since its introduction of AutoCAD software in 1982, Autodesk has
developed the broadest portfolio of state-of-the-art digital prototyping
solutions to help customers experience their ideas before they are real.
Fortune 1000 companies rely on Autodesk for the tools to visualize,
simulate and analyze real-world performance early in the design process to
save time and money, enhance quality and foster innovation.
Responsible for:
. Analyzing the user's requirements
. Coding changes according to the client requirements, testing and
Preparing UTP for Objects
. On-Time Delivery
. Code review and unit testing
. Involved in user acceptance test
. Onsite-Offshore coordination
Contribution:
. Designed and developed Reseller commission report which will display
commission amounts based on credits issued.
. Developed backlog report which displays all the backlogs during the
last quarter. Backlog report shows all blocks and available backlog
buckets which when drilled into show order and customer level detail.
. Worked on adding two new fields to parameter overview screen of
replenishment monitor (WVM6). Requirement is to add material
description and actual days of inventory (On hand quantity converted
into days of coverage) to replenishment parameter overview screen.
Client : Watson Pharmaceuticals Inc., Corona, CA
Project Duration : Feb'07 to June'07
Modules : SD, IM, and PM
Environment : SAP ECC 5.0, Oracle 9, O/S: WIN NT 4.X
Client Description:
Watson Pharmaceuticals, Inc. is a leading specialty pharmaceutical company
that uses innovative science and market insight to develop responsive
products for a changing world. Since its founding in 1984, Watson has
pursued a growth strategy combining internal product development, strategic
alliances and collaborations, and synergistic acquisitions of products and
businesses. Watson is uniquely positioned with its infrastructure and
internal research and development capabilities to support its three
divisions: U.S. Generic, Brand, and Anda Distribution.
Watson Pharmaceuticals, Inc. (NYSE: WPI), headquartered in Corona,
California, is engaged in the development, manufacture, sale and
distribution of brand and generic pharmaceutical products.
Responsible for:
. Analyzing the user's requirements
. Coding changes according to the client requirements, testing and
Preparing UTP for Objects
. On-Time Delivery
. Code review and unit testing
. Involved in user acceptance test
Contribution:
. Added three new fields one for OMS and two for SOMS in 'Additional
data B' tab of t-code VA01. The new OMS field is the rounded product
of customer average per month multiplied by OMS multiplier. The new
SOMS one field is the rounded product of customer average per month
multiplied by SOMS multiplier and the new SOMS two field is the
rounded product of customer average per order multiplied by SOMS
multiplier. The new SOMS fields are visible only if the material
ordered is a controlled substance.
. Designed and developed SOMS investigation form. This smart form will
be generated for orders with line items that exceed the suggested
order limit based on a defined SOMS table. Customer support will
contact the customer to obtain the reason for the excessive purchase
quantity.
. Developed 'Price discrepancy history report' using the report tool
ALV. This report displays all price discrepancies that have been
resolved. The input for this need to be date range. The output must
include Order number, line number, order date, material number,
customer name, material description, condition type, price group id,
Order qty, sales UOM, Customer price, sales order price, billing
price, ext value paid and date released.
. Modified the existing program which is creating credit memos (Charge
backs, rebates and bill backs) to handle negative charge backs,
rebates and bill backs.
. Developed a program which will re-price open orders for changes in
contract prices. This helps in keeping open orders in sync with
contract price changes received via CARS-to-SAP interface by
identifying blocking and allowing users to verify, release and re-
price sales orders contract prices are correctly reflected in open
orders.
Client : Honeywell SM Films -Pottsville-PA
Project Duration : Dec'05 to Jan'07
Modules : SD, MM and PP
Environment : SAP 4.7& Oracle 9,
Client Description:
Specialty Materials, a US$3.2-billion dollar strategic business group of
Honeywell, is a world leader in high-performance specialty materials such
as fluorocarbons, specialty films, advanced fibers, customized research
chemicals and intermediates. It is also one of the top five providers of
materials and solutions to the semiconductor industry, and a major producer
of nylon 6 in North America.
Based in Morristown, New Jersey, the business has approximately 10,000
employees and 45 manufacturing and sales facilities. The business serves
diverse market segments including automotive, healthcare, agricultural,
electronic and food packaging, polymers and plastics, personal care, air
conditioning and refrigeration, security coding, lubricants, paper and
packaging, semiconductor, paints and coatings, commercial and residential
carpet, as well as body and vehicle protection.
Responsible for:
. Requirement Analysis, Collection of information from the client and co-
ordinate with to offshore team to accomplish the tasks.
. Code review and unit testing
. Participating in User acceptance testing
. Performance improvement process for the objects
. Responsible for the objects Signoff to production system.
. Responsible for Development, unit testing and documentation for the
SAP custom objects
. On-Time Delivery.
Contribution:
. Implemented BADI for the flow of long text from characteristic values
of repair codes and authorizing documents into service order operation
long text.
. Worked on enhancement to add a new field "Crtd by bus type" to
notification object. Existence of the new field in the notification
transaction should be controlled by the configuration of notification
type.
. Developed conversion program to create brand new ship to's.
. Designed and developed the conversion program to extend the existing
payers to sold to's using the transaction code XD07
. Designed and developed conversion program for making the changes in
existing sold tos. Changes involved updating Unloading point, contact
person tabs in General data, delivery priority, shipping conditions,
delivering plant and tax classification in sales area data tab
. Developed conversion program to upload customer material text and
manufacturing text.
. Developed a program which will update the proposed delivery route
based on the departure zone, destination zone, departure country,
destination country and shipping conditions.
. Designed and developed smart form for US order acknowledgement.
. Designed and developed smart form US Invoice
Client : Honeywell Aero, Tempe, AZ
Project Duration : Jan'05 to Dec'05
Modules : SD, MM, PP and Work flow
Environment : SAP 4.7, Oracle 9, O/S: WIN NT 4.X
Client Description:
Honeywell is a leading global supplier of aircraft components, engines,
avionics, and related products and services for commercial airlines,
business and regional aircraft, and spacecraft. Honeywell is a leading
global supplier of aircraft components, engines, avionics, and related
products and services for commercial airlines, business and regional
aircraft, and spacecraft.
Responsible for:
. Analyzing the client's requirements.
. Preparing the Technical Specification documents.
. Developing, Testing and Preparing UTP
. Scheduling the background jobs
. Make sure for On-Time Delivery of the Objects.
Contribution:
Reports
. Where used Report
Standard SAP has a where used report on BOMs (CS15). Given a
component, this report can find its immediate parent or the full tree
structure (implosion). But it cannot list all the end items alone
(Filter option won't solve the issue). Besides some custom fields are
also required which are stored in the Document info record and on the
BOM custom fields. The output is displayed in ALV grid.
. MRP List report
MRP List report will be used by the MPS Schedulers and the
Planner/Buyers to compare the MRP data of a given material between
different weeks. This report runs weekly and takes a snapshot of the
Stock/Requirement list of all the materials.
MRP is run everyday in the system and the standard MRP list provided
by SAP will only capture the latest planning run overwriting all the
previous MRP lists. In order to store the previous week MRP list, we
have developed this custom report.
The report output should be an attachment to SAP In-box. SAP
background jobs should be created for each MRP Area and should be run
after the respective weekly MRP run.
. Planned order schedule dates report
This ALV report gives production controller the visibility of schedule
dates when planning releases verses basic dates.
Standard SAP uses basic dates from reporting which is often not the
same as the basic date, hence a report is required to pull schedule
dates to get the accurate release time of production orders.
Interface/Batch input
. Developed BDC programs to upload condition records of different key
combinations using the transaction code VK11.
. Developed BDC program to convert variant material to configurable
materials.
SAP Script/Smart forms
. Developed the print program and layout set for quotation form
. Developed piece part label form.
Piece Part Label form will be used whenever a goods issue is done from
stores to an order. This label will be used to identify the components
that would be issued as well as to show that the parts are good from
quality perspective
Work flow
Designed and developed work flow object which will stop the payments
to vendors,
until the changes done to vendor master are confirmed. In this
scenario work flow will send the mails to approval authority to
approve the changes done to vendor master.
Client : GlaxoSmithKline UK
Project Duration : Jan'04 to Jan'05
Modules : WM
Environment : SAP 4.6C, Oracle 8, O/S: WIN NT 4.X
Client Description:
GSK headquartered in the UK and with operations based in the US, they
are one of the industry leaders, with an estimated seven per cent of
the world's pharmaceutical market. As a company with a firm foundation
in science, they have a flair for research and a track record of
turning that research into powerful, marketable drugs.
Responsible for:
. Analyzing the client's requirements
. Coding changes according to the client requirements, testing and
Preparing UTP for Objects
. On-Time Delivery
Contribution:
Interface/Batch input:
Interfaces between SAP and WM System
Developed two (I/B and O/B) interfaces between the Global ERP SAP R/3
system (version 4.6c) and non-SAP Warehouse Control systems at ERP
implementation sites that require this functionality.
The interfaces in Warehouse Control systems are responsible for the
optimisation and / or automation of the physical placement and removal of
goods in the warehouse.
There are various scenarios for interfacing SAP R/3 to Warehouse Control
systems. The variations are mainly concerned with the distribution of
functionality between SAP R/3 and the specific Warehouse Control system.
Technology Used: IDoc (Outbound) and ALE
Client : JNJ (BEACON), USA
Project Duration : Nov'03 to Jan'04
Modules : SD, MM,
Environment : SAP 4.6C, Oracle 8, O/S: WIN NT 2.X
Client Description:
Johnson & Johnson is a worldwide family of 200 companies, marketing
health care products in more than 175 countries. The companies' more than
109,500 employees are engaged in producing products that serve a broad
segment of medical needs. They range from baby care, first aid and
hospital products to prescription pharmaceuticals, diagnostics and
products relating to family planning, dermatology and feminine hygiene.
Johnson & Johnson is the world's most comprehensive and broadly based
manufacturer of health care products as well as a provider of related
services, for the consumer, pharmaceutical and professional markets
Responsible for:
. Analyzing the client's requirements
. Analyzing the hard repairs
. To upload legacy data into SAP system
. Coding changes according to the client requirements, testing and
Preparing UTP for Objects
. On-Time Delivery
Contribution:
. Involved in modifications of Reports, Batch input programs, layouts
and User Exits as per the client requirements.
. Worked in BO team for 6 weeks to support the BO team while extracting
data from SAP.
. To reduce performance impact on SAP
. To complete data loads into business objects in less than 4 hours
. To identify the net change activity in SAP tables.
Client : SOLVAY PHARMA USA
Project Duration : Feb'03 to Nov'03
Project Type : Maintenance and support
Modules : SD & MM
Environment : SAP 4.6C, Oracle 8, O/S: WIN NT 2.X
Client Description:
Solvay Pharmaceuticals Company is an ISO-9002 company is basically
a chemical and manufacturing industry existing in the market for over three
decades having sales offices located in prime cities in India and with a
wide product range of over 2000 products. Presently working on the testing
stage of entire Sales and Distribution module and the integration with
other modules after analyzing the requirements of the company.
Responsible for:
. Analysis of client requirements.
. Developing or modifying the objects, depending on the requirement.
. Code review.
. Optimizing the code using Performance Analysis tools
. Preparing the UTP.
. On-Time Delivery.
Contribution:
Reports:
. Requisitions to Purchase order details report.
The purpose of this report is to monitor requisitions that have been
approved and converted into purchase orders but modified in quantity
and price during the creation process. Currently the system
configuration allows for changes while converting purchase requisition
to a purchase order.
. Report for open Sales orders
Designed and developed a report which identifies Open, Delivered or
Invoiced Sales order and make a report layout.
. Consolidated packing list Report
Developed report to display consolidated packing list for all the
invoices as per the selection of sales organization, customer, and
shipment no. Joins are used to retrieve data from VTTK, VTTP, VBRK,
VBRP, VBAK, LFA1, VEKP, and VEPO tables. It had all the shipping
details of a particular invoice with respect to the user selection.
Download functionality was also present so as to download the data in
an excel file at the selection screen level only.
Interface/Batch input:
Developed Batch input program to upload purchase order details from
Legacy system to SAP R/3 database using Transaction Code ME21.
Client : Synthetic industries, INDIA
Project Duration : Aug 01 to Jan'03
Project Type : Up gradation project
Modules : SD & MM
Environment : SAP 4.6C, Oracle 8, O/S: WIN NT 2.X
Client Description:
Synthetic Industries having sales offices located in prime cities in India
and with a wide product range. Presently working on the testing stage of
entire Sales and Distribution module and the integration with other modules
after analyzing the requirements of the company.
Responsible for:
. Analysis of client requirements.
. Developing or modifying the objects, depending on the requirement.
. Optimizing the code using Performance Analysis tools
. Preparing the UTP for the Objects.
Contribution:
Reports
. Created an Interactive report to display details about the Sales
Order, corresponding Purchase Order number and the items in the Order.
. Created Interactive Report to display Material Status (MARA, MAKT, and
MVKE). The report made interactive by customizing it in such a way
that user clicks on the material number, the screen display material
details displayed using transaction MM03.
Scripts
. Made use of SAP Standard Report Program RSTXLDMC to upload TIFF files
(for logo) and display as Standard text.
. Developed new layout sets for Purchase Requisition.
Interfaces
. Material Master Conversion (MM). This inbound interface transferred
the Legacy system material data to SAP through MM01 transaction
. Vendor Master Conversion (MM). This conversion created vendor master
records in SAP using transaction XK01.
Performance Tuning:
. Using 'Runtime Analysis' analyzes the performance of Transactions,
Programs and Function modules created in ABAP Workbench.
. Using 'Performance Trace' Record access, Locking activities and remote
calls of reports and transactions in trace file and Analyze
Education June 1998 to Aug 2001
M.C.A. from Osmania University, Hyderabad, India