Data Sap

CAREER OBJECTIVE

To seek a consulting or permanent position in the area of SAP BI / ABAP

PROFILE

. 7 years of IT experience in SAP as BI Techno-Functional Consultant and

ABAP Developer.

. Thorough understanding of SAP BI architecture including Modeling

custom infocubes, Data Store Objects, and Data Sources and Planning

Scenarios.

. Thorough understanding of SAP ERP Functional areas - FI, CO, PP, SD,

MM, HR.

. Proficient with Data Extraction, Transformation and Loading (ETL),

Transport management, Bex 7.0 Analyzer, query performance tuning, and

aggregates.

. Worked extensively with Process Chains, ETL (LO Cockpit), Delta

Initialization, performance tuning, APD'S and Open Hub Destinations.

. Extraction and enhancement of datasources from ECC system.

. Creation of generic Datasource using Function Modules and

Tables/Views.

. Involved in writing Routines (Start, End, Expert, and Infopackage).

. Extensive knowledge in Data source Enhancement, Generic Extractors,

User Exits, Data Loading (Full /Delta Up-Load), Scheduling,

Monitoring, Process Chains, MultiCube, and Open Hub Service.

. Expertise in understanding SAP R/3 system and experience in ABAP/4

programming techniques

. Extensive experience in Classical and Interactive Reports,

Transactions, BDC, Scripts, LSMW, ABAP/4.X Development Workbench, Data

Dictionary Objects, User Exits, Performance Tuning.

. Developed objects in the Domains of Retail, Pharmacy, Automotive,

Transports and Finance.

. Exposure to ALE, BAPI, IDOC

SKILLS:

|Data Warehousing |SAP BI 7.0 (Modeling, Transformations, Data loading, |

| |Process chains, Data flow Design and Data Reconciliation, |

| |BI Integrated Planning) |

|ERP |SAP R/3 4.6/4.7C, ECC6 - FI/CO, SD, MM, PP, PM |

|Reporting |Bex 7.0 Query Designer, Bex 7.0 Report Designer |

|Languages |ABAP/4, SAP Utilities ( IS-U) |

Expertise in SAP BI:

Modeling: Extensively involved in creating Info Objects, InfoSources,

Infocubes, DSO objects, MultiProviders, Data Sources, Update rules,

Communication structures, Extractors, Info packages, Info object catalogs,

Info Package groups and Process Chains. Involved in infocube and

Datastoreobject Re-construction.

Extraction: Lo, Generic, Flat file and Legacy systems for master and

transactional data. Activating Data Sources, setting up of V3 updates,

deleting setup tables and filling up of cluster tables, customizing and

enhancement of Extract Structures.

Reporting: Bex 7.0-analyzer, Report Designer, Condition reporting,

Exception highlighting, restricted key figures, Variables, filters, Free

Characteristics, Variants, and Structures.

Performance Issues & Tuning: Aggregates, Indexes, Partitioning and

Compression.

EDUCATION:

Master of Business Administration (M.B.A) from Periyar University,

2011.

Bachelor of Engineering in Electronics and Communication from Madras

University, 2001.

EXPERIENCE:

Client : ABBOTT Laboratories. Phase-I implementation, Waukegan, IL

Nov 2011 - June 2012

Company : IBM

Abbott laboratory is a global, broad-based health care company devoted to

discovering new medicines, new technologies and new ways to manage health.

Our products span the continuum of care, from nutritional products and

laboratory diagnostics through medical devices and pharmaceutical

therapies. Our comprehensive line of products encircles life itself -

addressing important health needs from infancy to the golden years.

Abbott has sales, manufacturing, research and development, and distribution

facilities around the world, close to where our customers need us to be. We

are recognized for our global reach and our ability to serve our customers

around the world.

Roles & Responsibilities: BI Developer

. Worked in complete BI flows for master and transactional data consisting

of various SAP Modules like MM, SD, and PP.

. Created generic datasource using Table/View, Function Module to extract

data from R/3 source system.

. Extensively involved in Activating Business Content for Standard

Infocubes, InfoSources & InfoObjects of S&D Module as per the Client

Requirements.

. Generated transactional Data InfoSources and Master Data InfoSources

(Texts, Attributes and Hierarchies)

. Worked with Transactional Data InfoSources to load Data from SAP R/3 and

Flat Files systems into SAP-BW.

. Loaded the data from R/3 to BW.

. Enhanced standard extractor to populate the custom fields using user

exits.

. Worked in LO extractors and activation of LIS datasources.

. Created Open Hub Destination to load the BW data to 3rd party system.

. Worked in ABAP routines - Start routine, End routine and Expert Routines

in transformations - written codes for master data look-up, filtering

data from source package, used function module for various conversions,

etc.

. ABAP coding in ECC side - creating Programs for append structure fields

in CMOD, worked in Function Module for generic datasource.

. Worked in Data Modeling - Creating InfoObjects, Datasource, Infopackage,

DTP, Transformations, DSO, Infocubes, Open Hubs, etc.

. Worked on Bex report; Condition reporting, Exception highlighting,

restricted key figures, Variables, filters, Free Characteristics,

Variants, and Structures.

. Data loading and unit testing with proper documentation.

. Involved in the activity of Process Chain creation for Master and

Transaction data.

. Involved in the Transport collection activity for moving the objects from

Dev to QA system.

Client : Cardinal Healthcare MBT, DUBLIN, OH

Aug 2010- Oct 2011

Company : IBM

Cardinal Health, Inc. is a health care services company based in Dublin,

Ohio. Cardinal health specializes in health care supply chain services,

providing pharmaceuticals and medical products. Cardinal has an existing

implementation of one or two SAP modules. The current implementation will

be implemented across 5 geographies for the entire SAP BI module.

Roles & Responsibilities: BI Developer

. Customized Info Objects, Info Sources and Info Cubes.

. Worked extensively on standard and custom defined LO-Cockpit, and

Installed relevant SAP business content.

. Used LO structures for extracting sales order, delivery billing

information.

. Created and worked on daily basis with Extractors, Generic Extractors

. Designing of Info cubes and DSO objects by considering the different

business scenarios.

. Worked in complete BI flows for master and transactional data consisting

of various SAP Modules like MM, SD.

. Created generic datasources using Table/View, Function Module to extract

data from R/3 source system.

. Enhanced standard extractor to populate the custom fields.

. Created Open Hub Destination to load the BW data to 3rd party system.

. Worked in ABAP routines - Start routine, End routine and Expert Routines

in transformations - written codes for master data look-up, filtering

data from source package, used function module for various conversions,

etc.

. ABAP coding in ECC side - creating Programs for append structure fields

in CMOD, worked in Function Module for generic datasource.

. Worked in Data Modeling - Creating InfoObjects, Datasource, Infopackage,

DTP, Transformations, DSO, Infocubes, Open Hubs, etc.

. Data loading and unit testing with proper documentation.

. Involved in the activity of Process Chain creation for Master and

Transaction data.

. Involved in the Transport collection activity for moving the objects from

Dev to QA system.

Client : PALL CORPORATION

Jun 2009 to Jul 2010

Company : IBM

Pall Corporation is a Port Washington; New York based global business in

the diverse field of filtration, separations and purification. Total

revenues for fiscal 2006 were $2 billion, with over 10,200 employees and

$56.2 million in R&D investment and listed in the S&P 500. Pall's business

is being split into two broad businesses: Life Sciences (c.40%) and

Industrial (c.60%). These businesses provide total fluid management

products and systems to meet the demanding needs of customers in

biotechnology, pharmaceutical, transfusion medicine, energy, electronics,

municipal and industrial water purification, aerospace, transportation and

broad industrial markets.

Roles & Responsibilities: BI Developer

. Involved in installing Business Content.

. Involved in extracting data from SAP R/3 to BI system.

. Created generic datasources to extract data from custom tables.

. Created DSOs and infocubes.

. Enhanced standard datasources by adding custom fields and written code to

populated data.

. Bex report; used the query elements formulae, Selections, Calculated Key

Figures, Restricted Key figures and Variables for different reporting

scenarios.

. Written User-exits for variables to populate default values to the

variable.

Client : Arla Foods

Apr 2008

to May 2009

Company : IBM

Arla Foods is Europe's largest dairy company and receives 7.1billion kg

milk per year. Arla Foods is a co-operative owned by approx. 13,650 milk

producers in Denmark and Sweden. The 7,100 Danish co-operative owners

supply 4.0 billion kg milk to Arla Foods every year (while the 6,500

Swedish owners supply 2.2 billion kg.

Roles & Responsibilities: ABAP Developer

. SPDD and SPAU analysis

. Maintain development objects in hierarchy through solution manager

. Identification and fixing of impacted custom developments

. Fixing of Custom Developments

. Maintain technical specification

. ABAP unit testing.

. Maintain SDMS-TAC.

Client : Sempra Utilities

Feb 2007

to Mar 2008

Company : InfyLogic Technologies

Sempra Energy is a Fortune 500 energy services company based in San Diego,

California. Their 2007 revenues were $11 billion. The Sempra utilities

based in California - San Diego Gas & Electric Co. and Southern California

Gas Co. - serve more than 20 million consumers. The OpEx 20/20 program

includes separate initiatives focused on Sempra assets, technology, field

operations and their customers. The Company has developed a long-term

operating vision and roadmap to enhance, update and integrate technology

and business processes used to deliver services to customers. The

implementation program will execute over twenty discrete and highly

integrated projects to be implemented over the next several years in the

areas identified below (Work-streams):

- Field Force

- Asset Management

- Smart Grid

- Customer Care

- IT Infrastructure

Roles & Responsibilities: ABAP Developer

. Worked on reports related to plant maintenance

1) Create notifications based on orders selected & assign it to

orders.

2) To ensure corrective (follow-up) orders meet their compliance

date, an enhancement will need to be created to

automatically notify the job owner when a notification may be in

jeopardy of not meeting its compliance date.

. Worked on ALV report i.e. the Work Order Cycle Time Report calculates the

average amount of the total time the work orders hold certain user

statuses.

. This calculated time is from the moment the status is associated with a

work order until the instance which the status has been removed from that

work order.

. Worked on Adobe form designing with the tool Adobe Life Cycle designer

related to plant maintenance.

. Creation of structures, Interface, binding to the respective fields in

the Adobe life cycle designer.

. Worked on Adobe forms related to Plant maintenance Valve Inspection,

vault inspection, Filter replacement, Regulator replacement & Inspection,

Instrument replacement, customer Inspection.

. Maintain CDF (Complexity Determination Form)

. Maintain technical specification

. ABAP unit testing.

Client : Olive group

Dec 2005

to Jan 2007

Company : InfyLogic Technologies

Olive group is ISO 9001:2000 accredited. In less than five years Olive

group has become a leading security provider for six of the world's top 10

Oil and Gas majors. Sectors of Olive are Transport, Real Estate, and

Insurance and Financial Services. The scope of the project is creating

report of material details and monthly sales report and resized the

standard layouts.

Roles & Responsibilities: ABAP Developer

. Created a report which tells the user the contracts that are going to get

affected with price changes in the near future

. Created a report to be issued every quarter giving the average

manufacturers price for all materials sold during the quarter to certain

customers.

. ALV Reports

. Used inbound interface for uploading mass quotation received from vendor

and populated BDC data for Transaction code 'ME41' and for 'ME47'.

. Uploading logo to standard Text by program RSTXLDMC. Resizing the

standard layout set windows.

. Repair standard Text standard SAP functionality to interpret INCLUDE

statements embedded with Sap script - Create a Custom program ZCAREPAIR

and a form to determine if an embedded "INCLUDE" statement exists. And

Create a Custom form to resolve all of the text within a Standard Text

object.

. Copied standard form i.e. LVSTAEINZEL to ZForm and then made changes as

below.

a) Field 'T333B-TRATX' - must be replaced with 'WM Transfer'.

This will remove the dynamic title in Standard SAP that

makes this title

the description given to the Shipment Type.

b) Make a new line under the Transfer Order field '&LTAK-TANUM&' to

make

box for the barcode.

C) Change Bar Code reference from 'BARCLVS' to

'C128A'.

Under this field add the following statement:

'<BC> &LTAK-TANUM&

Similarly for three more standard forms changes

done.

Client : Panasonic

Jan

2005 - Nov 2005

Company : InfyLogic Technologies

Panasonic is one of the largest electronic manufacturers in the world,

comprised of over 600 companies. Its headquarters is in Japan. The scope of

the project is creating report of sales order and material details, and

updating customer master data.

Roles & Responsibilities : ABAP Developer

. Created an interactive report to display the details of sales order

header data in one list and the drill down lists contain item details and

the material details.

. Coded BDC programs to update and change Customer Master Data by session

method for transactions XD01 and XD02 to update KNA1 table in SD.

. Design and developed letter for due payments of customers using SAP

Scripts.

. Modified the layout set RVINVOICE01 according to the User Requirement.

. Scheduled jobs in background processing mode at a specific date and on

the occurrence of a particular event.

Contact this candidate