Employment History

Confidential

Sr. Technical Consultant

Responsibilities:

• Worked extensively on FI-CO, SD, CO, HR, COPA. Loaded the data from ECC to BI and used initialization with delta update and full update methods.
• Enhanced LO Structure to include additional fields using user exits
• Developed ODS object to load Sales Order Data using the LO structures
• Activated Sale cubes, purchasing cubes from Business Content
• Expertise in building Multi providers, multi cubes and info sets as per the query needs.
• Expertise in implementing SAP provided standard business content Extractors/Data sources LO Cockpit, COPA and implementing Customer exists, BADI to enhance standard data sources to fulfill the business requirements.
• Extensively worked on SD info cube 0SD C03 and data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider's 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
• Developed Info objects, Info Cubes, DSO, Multi-provider Process chains as per design and the documents.
• Written complex ABAP Codes for Transfer rules and Update rules, for custom designed ODS and Info cubes.
• Modified standard screens using Enhancement spots according to client requirement.
• Installing multiple of BW and using Logistics objects reporting SD PP
• Extending the standard IDOC for Outbound delivery VL02N .
• Designed and developed Several DIALOG DYNPROS to collect and trigger subordinate ALE processes that used custom IDOC and Function Modules.
• Conversion of the Material IDOC Message type: MATMAS to XML format and store the same in the application server for further use in XI/PI.
• Developed an interface program that would extract the Account line item display FBL3N items.
• Implemented a BADI for transaction fb60 such that it does not allow users to create duplicate reference for vendor invoice creation.
• Implemented BADI ME PROCESS PO CUST to update/overwrite functional area in purchase order.
• Implemented a purchase order duplicate check in USEREXIT USEREXIT CHECK VBAP.
• Modified standard Scripts and smart forms according to client requirement.
• Development of G/L account open line item list display based on G/L acct and purchasing entities.
• Utility development to fix bugs in the AR clearing program FI postings using special G/L.
• Worked on BAPI BAPI ACC DOCUMENT POST FB01 for uploading G/L Balances and Accounts Payable data.

ENVIRONMENT: ECC 6.0 B.W 3.5/7.X, SAP BI 7.3, SAP BO 4.0 MM, SD, FI , Win 2000/XP, MS Office.

Confidential

Sr. Technical Consultant

Responsibilities:

• Developed process chains to automate the initialization and delta updating of all data.
• Created aggregates on various cubes to improve the queries performance.
• Created Start routines, Transfer Routines and Update rules to meet various functionalities.
• Created batch processes coded ABAP programs as required for using in routines and start routines in the DTP, Transfer Rules and Update Rules.
• Set up statistics/aggregates rebuild and event-chains to notify end-user of report availability.
• Worked on Business Objects Universe Designer, Logistics objects reporting, Control Objects, and extensively used Central Management Console CMC .
• Created reports using Desktop Intelligence and Web Intelligence in BO XIR2 environment.
• Analyzed the info cubes and maintained the aggregates to improve the reporting performance for BEX Reporting.
• Created Open Hub extracts for a daily and monthly loads of finance extracts from Info Cubes and ODS.
• Created reports using APD Analysis Process Designer on top of these reports developed Info Spokes using Open Hub service to extract data from BW into .CSV format to a folder location.
• Developed new SAP BO Webi reports with bar charts, line graphs and crosstab reports, based on daily HR Weblogs to monitor the usage Daily, Weekly and Monthly
• Developed screen for creating user roles using ALV OOPS where the user can create, modify and delete the user and save to database.
• Developed complex reports using multiple data providers in Web Intelligence Rich client.
• Installing multiple of BW and using Logistics objects reporting SD PP
• Developed tab strips for creating authorization code and functional codes using ALV OOPS where the user can create, modify and delete the user and save to database.
• Developed tab strips for creating Default contract using ALV OOPS where the user can create, modify and delete the data and save to database.
• Evaluate performance of technical objects and tune objects for better performance.
• Created customized debit note, modified standard toolbar to add customized buttons and created customized search help for fields in ALV and added buttons in alv line items and worked on Modal Dialog box screen.
• Created customized tables as required and worked on table maintenance generator.
• Responsible for development of outbound interface for Purchase Order using IDOCS.
• Implemented BADI MATERIAL REF to add some default data to materials.
• Created user exits for Validation to check duplicate Vendor invoices developed configurable solution to enable duplicate check based on different fields.
• Developed IDOCS based inbound interface Function module to create Purchase Orders using inbound IDOCS data from Legacy System.

ENVIRONMENT: ECC 6.0 B.W 3.5/7.X, SAP BI 7.0, SAP BO XIR4, Webi 4.0 MM, SD, FI, WM, PM , Win 2000/XP, MS Office.

Confidential

Sr. SAP BI ABAP Consultant Team Lead

Responsibilities:

• Worked in BI 7.0 on DW Workbench, DTP, DSO, Transformations, PSA, BI Accelerator and remodeling Info Providers.
• Data Flow modeling in BI/BW with Administrator workbench Info Objects, Info Source, Info Cubes, Multi-Providers, Aggregates, ODS/DSO's, Transfer Structure, Transfer / Update Rules, Data Transfer Processes, Info Sets and Data Sources.
• Extracted data using LO Cockpit, CO-PA data sources from ECC 6.0, utilities source systems.
• Configured and extracted data from the LO Cockpit extractors, SAP Inventory management by making use of the SAP defined data sources like 2LIS 03 BF, 2LIS 03 BX and 2LIS 03 UM.
• Using BEx broadcaster, distributed the customized reports by region and exported to the Enterprise portal.
• Extensively worked on custom cubes, used Transfer rules, Update rules to translate the business processes into end reporting objects.
• Involved in Designing and Developing the Customer/Vendor Tracking Project which will populate a Data mart with the customer extract information from all SAP business units as well as other business units running Non-SAP R/3 systems.
• Generated Export Data Sources to transform data from one Info Cube to other Info Cube.
• Schedule Daily/Weekly/Monthly data loads schedule new jobs.
• Performed performance tuning for Info Cubes / Queries through Indexing, Aggregates, and Compressing etc.
• Extracted Data from Existing BI Info Providers and ECC Custom Data Sources using Generic extraction and also using Flat files.
• Built aggregates on various cubes to improve the performance of queries
• Modified the standard program 'RFBILA00' to split by profit center for financial statement.
• Modified the standard Script 'F110 PRENUM CHCK' for check printing.
• Developed the upload program for T-code GP12N Kp06.
• Modified the standard script for Payment voucher.
• Developed user-exits for the T-code Fnv2 in the correspond tab to auto generate the file number.
• Installing multiple of BW and using Logistics objects reporting SD PP
• Developed various reports smart forms and performance tuned the programs.

• Modified DUNNING form for the T-code F150. To generate reminder letters to customers for overdue items according to the client requirement.
• Developed smart form for T-code FNI2. This form is a contract and will be issued to customer at the contract stage.
• Developed an Upload program to modify the S.W.I.F.T format to add Bank Auto debit data and Client data.

ENVIRONMENT: ECC 6.0, SAP BI 7.0, SAP BO 3.1 B.W 3.5/7.X MM, SD, CO, WM, FICO , Win 2000/XP, MS Office.

Confidential

Sr.SAP BI ABAP Consultant Team Lead

Responsibilities:

• Customized and maintained Data Sources such as billing 2LIS 13 VDHDR , Sales Order 2LIS 11 VAHDR , and Delivery Order 2LIS 12 VCHDR for the SD module and Purchasing Order Item 2LIS 02 ITM for MM.
• Enhanced business content Info Cubes for SD sales overview, customer and FI general ledger .
• Handled performance tuning of query response time by building aggregates and indexing on Info Cubes and Info Cube compression.
• Defined Transfers Rules Update Routines.
• Responsible for loading Master data Texts, Attributes and Hierarchies .
• Created Process Chains for loading Master and Transaction data and running subsequent processes.
• Develop custom data model using Info Objects, Standard ODS, Info Cubes and business logic.
• Installing multiple of BW and using Logistics objects reporting Control objects SD PP
• Managed, monitored data loadings, Error Debugging and rectification, solving issues, problems faced during Data Uploads.
• Involved in increasing the Load performance of the BW system while loading into ODS objects and Info cubes.
• Resolution of performance related issues using Aggregates, Partitioning and Compression of info Cubes, BW statistics, Aggregate, Roll-up, and Process Chain monitoring.
• Developed Upload program for t-code F-02 using BAPI. This program is to Upload Firm Expenses to GL accounts.
• Modified the standard Script for the check printing for t-code F110.
• Developed Mass upload for asset master creation AS01 using BAPI.
• Implemented BTE for transaction FB02.
• Developed payment interface file for the bank to the external system for direct debit.
• Developed Mass upload using BAPI Material creation MM01.
• Developed Mass upload using BAPI for Purchase Order ME21N.
• Developed Payment advice with check printing using table control and smart form, where the program can Send Mail with PDF attachment, Fax and SMS .
• Involved in creating custom Master data info Object with compounding characteristics and document characteristics as navigational attributes.
• Used Exit in MV45AFZZ to populate sales agreement on the Sales Order Line Item.
• Used Exit MV45AFZB to trigger pricing when determining a new agreement.
• Used Exit EXIT RMCAF000 001 in Enhancement RMCAF000 to update various LIS tables.

ENVIRONMENT: ECC 6.0, SAP BI 7.0, SAP BO 3.1, B.W 3.5/7.X MM, SD, CO, FI, and WM , and Win 2000/XP, MS Office.

Confidential

SAP BI ABAP Consultant

Responsibilities:

• Responsible for writing and reviewing several Customer Exits in BW based on report requirements.
• Responsible for writing routines Start Routine, end routine for data cleansing and post processing.
• Worked extensively in the Data Modeling of COPA, SD, and MM Info Cubes, created Generic Data Sources
• Enhance Standard BI/BW Extractor Using BADI.
• Developed reports using BI 7.0 Reporting tool and handled various complex layouts in FIGL, AR, AP.
• Improved Query Performance by Creating Aggregates, Indexes and Compressed Info cubes To Improve the Load and Query Performance.
• Created master data flat files for GL grouping across entities.
• As part of the development, developed several data targets such as DSO Objects ODS and Cubes, Multi Cube and Info-sets.
• Involved in monitoring the info package groups and process chains.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
• Interfacing with the users for clarifying queries regarding tickets posted by them.
• Maintaining Work History for all the tickets until it is closed down.
• Created report to display list of stock for a material with subtotal of stock for each storage location and grand total of the stock at end of the plant
• Daily monitoring of Info cubes and ODS object requests.
• 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
• Created multiple methods in the Implementation Class of a BADI for certain calculations like currency conversion, pricing simulation.

ENVIRONMENT: ECC 6.0 B.W 3.5/7.X MM, SD, CO, FI, PP, QM , Win 2000/XP, MS Office.

Confidential

SAP BI ABAP Analyst

Responsibilities:

• Replicating the required data sources from ECC system to the BI system.
• Applying the transformations as per the business requirements in the info sources.
• Exporting the data sources and creating the data mart set up to meet the business functionality.
• Aggregates and the index creation for improving the query performance.
• Data Source enhancements, generic extractors, User Exits and customized delta built up for the data sources, V3 Updates...
• Created Transformations and applying routines for restricting and transforming data.
• Involved with PSA in monitoring data transfer from source system into BW.
• Involved in performing unit testing in development server and transporting to Quality server.
• Worked on the Bapi concept to release and change the Purchase Order by concern person using the Bapi BAPI PO CREATE1 and BAPI PO CHANGE respectively for that input field purchase document no EBELN using table EKKO and EKPO.
• Developed Smart form Barcode printing for carton Pallet label for their lot traceability system.
• Modified the standard Script for the check printing for t-code F110.
• Developed Script for Payment Voucher For T-Code FB62.
• Involved in support work which includes Daily process chain monitoring, Background jobs, Support calls which needs to be fixed on priority basis.
• Designed and coded a BDC program for open purchase orders of known vendor ME21 in Materials Management.
• Created Info Areas, Application Components, Info Objects and Info Sources to build Master Data Tables, ODS Objects, Info Cubes and Aggregates. Loaded Transaction Data and Master Data via Flat Files in CSV format.

ENVIRONMENT: 4.7E MM, SD, CO, FI, WM , BW 3.5/7.X Win 2000/XP, MS Office.

Confidential

SAP ABAP Consultant

Responsibilities:

• Developed a Sales Report to monitor order information flow of billing.
• Developed a report to check the planned goods movement.
• Developed an upload program to post sales data using BAPI.
• Modified standard script for Credit Note and Debit Note.
• To track accurately Service Orders and Notifications developed a report called Warranty Order report. Clubbing of two standard transactions IW39 IW59.
• Developed the Report for Global stock status for external procurement of finished goods using ALV.
• Analyzed and redesigned the reports on FI to improve their performance using in ABAP/4 Performance Tuning.
• Developed the Report for material variance BOM Explode using ALV.
• Performances tuned the P L report and fix the bugs.
• Created an Interactive Report for displaying plant status report to know the status of a particular material.
• Certificate receipt incoming goods for INBOUND DELIVARY VL31N, VL34N and Included logic using function module in Sap Standard program MV50AFZ1.
• Created user exits for modifying the sales order application as per the user requirement.
• Modified SAP Standard Program called REVENUE RECOGNITION Program to capture the posting period and fiscal year based on the user time zone and date.
• Developed SAP Script Layouts and associated ABAP print programs for different versions of Purchase Orders and Debit Memos.
• Developed BDC program to migrate Vendor Master Data from legacy system to SAP.
• Studying the User requirements, existing developed Programs, Layout sets, Modifying Programs, Transactions and Layout sets to get the User required Output.
• Developed BDC program to migrate Sales Order data from legacy SAPR/3 database using Batch Input Method.
• Involved in flat file interface for conversion transferring data received through text files for Purchase orders.

ENVIRONMENT: 4.6C ECC 6.0 MM, SD, CO, FI, IM , Win 2000/XP, MS Office.