RAMESH CHANDRA CHAUDHURY

BASIS/ ABAP/BW/Mercator

847-***-****

E-mail: abpnkr@r.postjobfree.com

More than 3 and half years of SAP R/3 experience in SAP BASIS, ABAP/4 (SD, MM, PP module), and MERCATOR with special emphasis on RFC, BDC, ALE, and EDI in addition to BW. Worked in 4.0/4.5B on sandbox.

Over five years of IT experience which involves analysis, design, development, implementation of application software on different hardware and software platforms and administration in UNIX, Windows NT, Oracle-7.1.

TECHNICAL SKILLS

SAP: BASIS, ABAP/4 (3.1 H and 4.0 DELTA), MERCATOR, RFC, BDC, ALE,

DIALOG PROGRAMMING, USER-EXITS, PRINT MANAGEMENT,

SAP REPORT WRITER (FI), Business Information Warehouse (BW),

SAP Script, SAP Profile Generator, CTS, WBO, Data Dictionary.

WEB TOOL: MS FrontPage 98, Active Server pages, JavScript.

O.S.: UNIX, Windows NT, Windows 95, and Windows 98.

SOFTWARE: POWER BUILDER 5.0, C, C++, JAVA, COBOL, INFORMIX ONLINE 4GL

HARDWARE: U-6000 (VT-100), SUN SOLARIS, COMPAQ

RDBMS: ORACLE-7.1, INFORMIX-4.0, SQLSERVER.

CASE TOOL: ERWin.

TRAINING

BASIS and ABAP/4 corporate training by Siemens Information Systems Ltd. (SAP Partner).

ABAP 4.0 DELTA training from SAP America Inc.

Oracle 7.1 DBA and PB-5.0 training by Hexaware systems Ltd.

CrossWorlds and Mercator training by CrossWorlds Inc, California.

Business Information Warehouse (BW) training from PRM Technologies Inc.

Windows NT conducted by Applitech Institute.

DETAILS OF BW TRAINING

Part I

Overview of Data ware housing and SAP business Information Warehouse (BW).

Data Staging.

Holding data.

Information extraction.

Data presentation.

Part II

Using Business Explorer and Business Analyzer.

Infocube design.

Define Info sources.

Dealing with flat files.

Attributes and hierarchies.

Defining Queries.

Part III

Scheduler and monitor (BW Administrator workbench)

Part IV

ASAP BW Implementation phases.

WORK EXPERIENCE

Oct. 98

- Senior Consultant, Dow Corning Inc., Midland, MI.

Present Primary responsibilities include creating the dialog programs, function modules,

(BASIS/ABAP) interactive and normal reports for Task Group Security system. The system provides security access control and management in SAP-3.0F. The system integrates with the SAP profile generator to provide a security solution to meet Dow Cornings business process and Task group methodology. This provides a decentralized access control. Majority of my work includes:

Function Modules:

Organization Filter: This calls a set of screens to request information for the organization filter selections.

Role Selection: Displays the process roles and allow the user to select various process roles.

Reports:

List Security profiles by business process, by Approver, by Task group. Listing Security profiles by business process is an interactive report, which calls a function module for users org. level selection and a multi selection data entry.

List Authorizations by Manager, by User, by Transaction.

List task groups by task group type, by process role, by Business process, by Transactions, by Owner.

List Courses by Business Process, by Process Role, by task Group.

List Task Group Relationship Map: Task Group is a key to many tables. This report will list all the entries for a task group. This is a help to identify any missing information or Discrepancies amongst the tables.

List Object Class by Authorization Object.

Loading Transaction data:

Load ZTGTT- Transactions for the Task Group. From generated profiles it populates the transactions for the task groups and loads the table ZTGTT.

May 98

- Consultant/Project Lead, Autodesk Inc., San Rafael, CA.

Sept. 98

Primary responsibilities include analysis of the current existing SAP-SD module

(ABAP) implementation, SCOPUS and MAGELLAN business applications and integrating the SAP R/3 system with these systems. CrossWorlds application sits in between SAP R/3, SCOPUS and MAGELLAN and synchronizes the changes in one application to other application.

MERCATOR is used for creating type trees and maps for all systems and mapping is done across the systems.

Through this process, ABAP programs are written:

To create events in the events table when a customer is created in SAP.

Writing match codes for De-duplication of the SAP customer data.

Creating customers and contact records in SAP at users choice.

Uploading the customer information through BDC programs.

Other Works involved

Transporting the Crossworlds and ABAP applications to SAP R/3 testing and production servers.

Coordination in installing CrossWorlds applications (SQL-Server and Oracle).

Installing and configuring the Connectors for Informix and Oracle.

Creating type trees and data maps for customer and contact in MERCATOR Type tree and mapping tool.

Creating Collaborations using CrossWorlds Designer.

Trouble shooting Connectors.

Logging and tracing of InterChange Server, Collaboration and connector.

Taking backup using repos_copy.

Writing the stored procedures and triggers in Informix and Oracle for SCOPUS and MAGELLAN.

Development of Power builder program to create/delete/modify customers in SCOPUS and MAGELLAN.

Creating the event table in SCOPUS and MAGELLAN.

Creating customers and contact records in SAP at users choice.

Dec. 94

- IT Systems Executive, Crompton Greaves Ltd., India

.

Apr. 98

Primary responsibilities included administration of Servers, Analysis, Design, programming and trouble shooting as indicated below:

Coordination in SAP Installation and upgradation.

SAP BASIS activities.

ABAP/4 programming.

NT-3.51

Server Administration.

Unix Administration.

Network TCP/IP settings.

Oracle-7.1 Server Administration.

Power Builder- 5.0, Informix Online 4.0 programming.

Analysis, Design and programming of the BOM (Bill of Materials) System.

SAP BASIS AND ABAP/4 PROGRAMMING (SD, MM, PP)

As a member of the Developer team, I initially undergone ABAP/4 training provided by Siemens Information Systems Ltd., (SAP Partner in India). Completed the Basis, Reporting, On-line Programming, User-Exits and RFC. Additionally, SAP Architecture

and BASIS, SAP installation, Client copy, Transportation, Backup, Profile generation, SAP DBA and Users administration were covered as part of this training.

DETAILS OF BASIS EXPERIENCE

Created Activity groups, authorizations for the transformer division using Profile generator and assign the security profiles to users.

Created the _ALL profile for Transformer division.

Created profile for managing printing activities.

Created the test client 037 on CG2 (Development Server) and transported the customizing data through Client copy. Application data is not transported. Here the master data is loaded through the BDC programs.

Partial Client Copy

According to the requirement of the PP-group the rows are selected for the work center and the routing tables using the transaction SE30, CA03 and CR03. Through create request transaction (SE01) the request is created in client 030. In addition, through the transaction (SE09) the tables are included in a request. Here the filter conditions for the table rows are specified. In client 090 (target client), the partial client copy is run for copying the rows from source client 030 to the logged on client.

CTS

Initializing and configuring the work bench organizer (WBO) for Integration and Consolidation systems.

Using Transport control program (TP) for export, Import and analyze.

Setting the TPPARAM file parameters.

For work centers and routings data the Application tables are transported from the development server to the new test server. This uses the tp program.

Backup, Restore and Archive

Parameters setting in the init file initeg2.sap for backup type, compress mode, tape_size, volume_archive, volume_backup, tape_use_count, expir_period.

Offline backup is regularly taken for the production server and the development server using SAPDBA.

Query optimization for ABAP users.

Processes and User administration.

Performance monitoring of the servers.

Troubleshooting with trace, logs, echo and core-dumps.

Printer installation and print management.

Details of the ABAP projects are listed below:

DIALOG PROGRAMS (ABAP/4)

BDC Wizard:

This program accepts the user name, transaction and input file name, and validates those in the system. In the second step it accepts the input file format (fields and its length). The next unlimited number of steps accepts the program name, screen number and the corresponding fields for that screen. Then it generates an ABAP/4 BDC program for that transaction.

Request And Issue Of Accessories:

Requisitions from various departments entered on line for floppies, printers, printer ribbons, printer cartridges etc., are accepted by the system through an electronic signature of the user. The system produces the report for the next designated number of days required for the whole division. The program also handles the issue of items to the users with a security check.

SAP SCRIPT & LAYOUTS

Printing Stores Order:

This program accepts the plant, work centers, storage locations, start date and end date as input parameters and prints the stores order in the particular official format. The detail part of the order contains serial number, material code, material description, storage location, storage location description, unit of measure, quantity required, quantity in stock, quantity to issue. This involves finding the tables used by the system and appropriate printer adjustments.

Printing Purchase Order:

By running the program RSTXR3TR the layout set is imported from the floppy and by running transaction SE71 it is copied to the current working client. Modification is done here according to the companys format. The company logo is attached to the P.O. by using the MACRO concept (saving the logo as TIFF file and run the program RSTXLDMC to convert it to a text).

NORMAL REPORTS

List of open purchase orders created with reference to the rate contract.

Record of all amendments to the rate contract.

List of items where stock level is below safety stock quality.

List of items received through project sites.

Work center wise inventory valuation.

INTERACTIVE REPORTS

Finding Tables and the Relations for a particular Transaction

This program takes the report produced through the transaction SE30 as input and reports all the tables used for that. Then it takes the program name and the dynpro number as input and finds out the names of the fields for that dynpro. It cross checks with the tables from transaction SE30 and suggests the table names of the corresponding fields for the transaction.

BDC Programs

Material master uploading (MM).

Source list uploading (MM).

Customer master uploading (SD).

BOM and Routing uploading (PP).

BUSINESS SYSTEMS MARKETING

(INFORMIX, UNIX)

This package contains the activities of tendering information maintenance, bidders offer, preparation of comparative chart, preparation of price proposal, enquiry status view, X-enquiry data library maintenance, IEEMA circular entry and price variation clause (PVC) calculation.

UNIX / INFORMIX Administration:

Creating users for UNIX system and Informix.

Taking backup with Tar twice a day.

Monitoring system logs.

Space management with cooked files.

Printer Installation and management.

BILLS OF MATERIAL (Power Builder, Oracle-7.1)

A Bill of material is a sheet that describes the quantity of materials required and its Technical Specifications pertaining to a job. This is a coordinated activity between the Design, Planning and the Stores groups. This program has the facilities for Entering Master Drawings, Work Order Compilation, Downloading data to use in BDC program, Uploading data generated from BDC program, Super user management, Report generation.

ORACLE Administration:

Creating database for BOM application.

Creating around 150 users for the application and granting the authorities.

Creating triggers and stored procedures for the application.

Management of table spaces.

Performance tuning.

Backup and recovery of database.

OTHER PROJECTS

LINE EDITOR

(Language: C)

The editor is designed to open certain encoded files in a different security mode for different users. It accepts the user name and the password to open a confidential file by decoding them. Every file contains the decoding rule at the end of the file. For some users it allows the editing and modification but for others its only in red only mode. Along with that it also includes the editor facilities like- Add new line, delete line, modify a line, copy a block of line etc. This also used certain graphics while the processor is busy doing certain task.

Following Projects are developed using PB-5.0 with Oracle as backend.

NON-CONFORMITY DATA PACKAGE (NCD)

Non-Conformity is an event that stops the workflow in a department in the regular job scheduling. The Quality Assurance department primarily handles this. The program deals with creation and maintenance of Non-conformity data register, External Data importing and MIS report generation.

PERSONNEL INFORMATION SYSTEM

Entry and maintenance of all personal data of the employees. This includes the provident fund, nominee, family, awards, movement of the employee, disciplinary actions against the employee, increments, training and performances data. Middle management and top management uses this.

Jun. 94

- Systems Analyst Programmer, Elin Electronics Ltd., India

.

Dec. 94

Responsible for the analysis and design of the purchase activities, which include the activities starting from purchase requisition to invoice verification, and raising of credit and debit memo receipt.

EDUCATION: Masters

in Computer Applications, S.V.U. College of Engineering, India, Dec. 1993.

Bachelors of Science

in Physics, Utkal University, India

PERSONAL Willing to travel and relocate

Contact this candidate