Manager Sap

Email: ablgry@r.postjobfree.com

Phone: 714-***-****

Srihari Aravindakshan

SAP MDM ABAP Consultant

Summary:

. Over 8 Years overall IT experience in SAP Technologies which includes

over 4 years of experience in SAP MDM, 4 years of experience in SAP

BI/BW(ETL & Reporting) and 7 years of experience in SAP ABAP

development in SD, MM, FI/CO & CRM modules.

. Good knowledge of SEI CMM standards and have CMM Level 5 project

experience.

. Currently working at Ingram Micro Inc. as the SAP Netweaver MDM

Manager since Aug 2008. Prior to this was working with Miller Brewing

at Client Location and full time with SAP Labs, Mind Tree Consulting

and Patni Computers, India.

MDM

. Handling the large scale Global MDM Implementation at Ingram Micro as

the SAP Netweaver MDM Manager. This involves the Budgeting, Planning,

Defining Scope, Designing and Implementation of the SAP MDM rollout to

North America, Latin America, Asia Pacific and Europe regions.

. Involved in the requirement gathering, design of the MDM System and

systematic data migration of existing legacy application to MDM/ECC.

. Actively involved in building Governance around the Master Data

Management.

. My Role involves getting the business requirements by interacting with

business team across all regions.

. Installed MDM Components, Designed Data Models, Created/Archived

repositories, Created Clients/Ports/Maps. Designed Flat, Hierarchy,

Look ups, Qualifier, Taxonomy Tables and Tuples.

. Imported Data using the Import Manager through Excel/Access File

Formats and XML.

. Created Validations, Transformation, Rules, Matching Strategies and

Workflows.

. Syndicated data using the MDM Syndicator.

. Integrated SAP MDM with ECC, Portal, Business Objects, BW and ETL

Tools.

. Performed Data Cleansing using BO DS(Business Objects Data Services).

. Developed Java programs for MDM Business Processes. Performed MDM

Upgrades.

ABAP

. Proficient in generation of Classical Reports, Interactive Reports and

Module Programming.

. Experienced in ABAP/ 4 programming techniques like BDC using both

session and call transaction methods, Reports in SD, CRM and FI

modules.

. Experience in Data Migration and Data Uploads using BDC Programs and

LSMW.

. Developed objects in technologies of ALV, SmartForms, ABAP Objects,

BAPIs, User Exits and BADIs.

. Working Knowledge on Technologies like RFCs, ALE/IDOC and LSMW.

. Exposure to Performance Tuning and SQL Trace Tool.

. Developed Layout sets, SAP Scripts and creation and Maintenance of

Data Dictionary components.

BW/BI

. Involved in SAP BW Extraction, Modeling and Reporting using Bex.

. Extracted data from LIS/LO/FI-SL/FI-GL/COPA and Generic Data Sources.

. Designed and developed Info cube, ODS, Infoset and Master Data.

. Knowledge of Enhancing the Data Sources and Business Content.

. Experience in Bex / Web Reports in creating and usage of Restricted

Key Figures, Calculated Key Figures, Virtual Key Figures, Structures,

Conditions, Exceptions, Variables and Processing Types.

. Experience in User Exits/BADIs and user Profile Maintenance using the

Profile Generator.

. Extensive experience in Enhancements and use of User Exits/BADI.

GENERAL

. Good analytical and problem solving skills and also good

interpersonal, communication and presentation skills.

. A Self-starter with a positive attitude, willingness to learn new

concepts and acceptance of challenges. Clear written and oral

presentation of ideas, proposals and concepts. Strong listening,

interpersonal & analytical skills.

. Good understanding of the RDBMS concepts.

. Conversant in ASAP methodologies.

PROFESSIONAL ACHIEVEMENTS

. Received the Best Team Award in SAP practice, as a Part of the Pitney

Bowes SAP team at Patni Computer Systems, Mumbai.

. Received the Letter of Appreciation for contribution to the project at

Patni Computer Systems, Mumbai.

. Received Special Appreciation Award, as a part of the Pitney Bowes

team, which was selected for CMMi certification at Patni Computer

Systems, Mumbai.

. Received Appreciation for the KMD & TRAFFORD Project in SAP Labs

India.

Technical Skills:

ERP SAP R/3 Enterprise, SAP R/3 (4.6 C/4.7), ECC 5.0

Languages and Tools MDM 7.1, MDM 5.5, BW 3.5, ABAP/4, C, C++, SQL, Java

Expertise in MDM Design, Data Modeling, Configuration, Console, Data

Manager, Syndicator and Import Manager

Technologies in SAP Reports, BDC, ALV, SmartForms, ABAP Objects,

R/3 (ABAP) ALE/IDOC, User Exits, BADI, BAPI, RFC, SAP Scripts,

LSMW

SAP New Dimension MDM, BW, CRM - People Centric User Interface

(PC-UI), BO DS

Functional Domain Sales and Distribution, FI, CRM

Databases Oracle 8, MS SQL Server, MS Access

Operating Systems MS-Dos, Windows 9X, Advanced 2000 Server

SAP Project Experiences & Responsibilities:

Ingram Micro, Santa Ana, CA

Aug 2008 to Till Date

Ingram Micro Inc. is the world's largest technology distributor and a

leading technology sales, marketing and logistics company. As a vital link

in the technology value chain, Ingram Micro creates sales and profitability

opportunities for vendors and resellers through unique marketing programs,

outsourced logistics services, technical support, financial services and

product aggregation and distribution. Ingram Micro serves 150 countries and

is the only global broad-based IT distributor with operations in Asia. It

is among the top fortune 500 companies in the world. The IM Global Project

is one of the biggest SAP Implementations.

Role: SAP Netweaver MDM Manager

Environment: SAP MDM 5.5 & 7.1, R/3 4.7, ECC 5.0, BI 7.0, CRM 4.0, Oracle

8.0 and Win NT/2000.

Project: IM Global

Role: SAP Netweaver MDM Manager

Responsibilities as SAP Netweaver MDM Manager:

> As the SAP Netweaver MDM Manager my responsibilities included

interfacing with business (PTP and OTC) and Data Stewards to get

business requirements and translating them into Functional and

Technical Design.

> Design the Logical and Physical Data Models.

> Define SAP MDM Road Map in the Organization and align them with the

roll outs. Estimate Effort and Cost on MDM Projects and provide

business inputs.

> Work on Project plans. Manage, delegate and coordinate between the

onsite and offshore teams.

> Support countries that have SAP MDM rolled out and at the same time

plan for future roll outs.

> Work with Data Governance team to formulate data maintenance process

to maintain data integrity, consistency and ensure governance.

> Collect requirements for Material Master, Customer and Vendor.

> Coordinate with SAP PI, Portal and TIBCO Teams to realize the

technical design.

> Performed the Integration of MDM with SAP ECC, Portal, BW, Business

Objects and ETL Tools.

> Performed Data Cleansing using BO DS(Business Objects Data Services).

> Coordinate and Plan MDM Upgrades with SAP Basis.

> Developed Test Plan and Procedures for the Business Users

> Training Business and End Users on MDM. Creating "How To" Guides for

Users of the MDM System.

> Defining Roles and Provisioning Users on the MDM System.

> Creation of Operations "Run Book" for the MDM System.

> Defining Naming Convention and Standards for MDM Configuration and

Development.

MDM Development Activities:

> Involved in the Migration of data from Impulse and Adonis into SAP MDM-

ECC.

> Defined Business Rules and Validations for Data Migrated from Legacy

into SAP MDM-ECC. Developed a Process and Plan for Data Migration.

> Installed and Configured MDM Server, Import Server, and Syndication

Server.

> Configured the Transaction MDMGX in SAP ECC for the Reference Data

Extraction from ECC into MDM.

> Designed the MDM Data Model, Created/Archived repositories, Created

Clients/Ports/Maps.

> Designed Outbound/Inbound Interfaces for the Material Master MDM

Implementation.

> Designed Flat, Hierarchy, Look ups, Qualifier, Taxonomy Tables and

Tuples.

> Created Taxonomies for Material Classification and Material Variant.

Loaded Attributes, Attribute Values and Linked Attributes to Taxonomy.

> Designed Product Hierarchies.

> Imported Data using the Import Manager through Excel/Access File

Formats, XML and Flat files.

> Created Validations, Transformation, Rules, Matching Strategies and

Workflows to carry out the scheduled import through validations and

approvals.

> Designed Interfaces for Material Master(MATMAS), Configuration Profile

Dependencies(CNPMAS), (Classification)CLFMAS, ALEAUD and Product

Files.

> Syndicated data from MDM to ECC.

> Designed Product Enrichment Workflow Processes.

> Imported Data using Partitioning and Pivoting of Data from XML files.

> Interface and Configure the MDM Material Master onto SAP Portal.

> Used MDM Java API to fetch Material Classification (Taxonomy)

attributes to transform the MDM outbound XML files for Product

Enrichment.

> Workflow Management using MDM Java APIs.

> Designed SAP PI requirements for MDM.

> Developed Test Plan and Procedures for the SAP MDM-ECC System.

ECC ABAP Development Activities:

> Designing of the ABAP ALV Report for the new Materials Created and the

Extension of Materials.

> IDOC processing of MATMAS, CLFMAS, CNPMAS & ALEAUD for Material Master

Maintenance between MDM-ECC.

> LSMW (Legacy System Migration Framework) and BDC used for Data

Migration into SAP.

Client: Miller Brewery, Milwaukee, WI (NEA Consulting & IST)

Sep 2006 to Aug 2008

Miller Brewery in Milwaukee is America's oldest major brewery. South

African Breweries purchased Miller Brewing Company, forming one of the

largest brewers in the world, called SABMiller plc, with volume of more

than 130 million barrels, operations in 40 countries and hundreds of

brands.

Role: SAP MDM ABAP & BW Consultant

Environment: SAP R/3 4.7, ECC 5.0, BW 3.5, CRM 4.0, Oracle 8.0 and Win

NT/2000.

Projects: Migration of Bugs Eye Catalog to SAP MDM, SAP Archiving, RPM,

MAPS, CASH

Responsibilities:

> Gathered and documented functional requirements as part of updating

functional specifications for the Migration of Bugs Eye Catalog to SRM

MDM.

> Key player in Mapping Business Processes. Developed, tested and

implemented integrations according to the requirements.

> Coordinated and prepared Technical Documents to ensure that further

maintenance team understands the process flows well.

MDM Development Activities:

> Designed the SRM MDM Data Model.

> Carried out the Migration of Bugs Eye Catalog to SRM MDM Catalog.

> Involved in MDM Installation.

> Created/Archived repositories, Created Clients/Ports/Maps. Designed

Flat, Hierarchy, Look ups, Qualifier, Taxonomy Tables.

> Defined pricing using Qualifier tables.

> Setup UNSPSC Hierarchy to be used in SRM MDM.

> Imported Data using the Import Manager through Excel/Access File

Formats using the data from the SRM system.

> Created Validations, Transformation, Rules, Matching Strategies and

Workflows to carry out the scheduled import through validations and

approvals.

> Syndicated data using the MDM Syndicator to the SRM system.

> Configures OCI Mapping to connect SRM MDM to SAP Portal.

> Developed MDM Training Guides for Business Users.

ABAP Development Activities:

> RFC enabled Function Module developed to get the R/3 realigned data.

> Written Function Module to fetch the Internal Order Data.

> Report developed to load the Business Partner and Opportunities Data

in CRM.

> ALV Reports to display IO Owner Report.

> BAPI's used for the creation/modification/deletion of Business Partner

Employee, Accounts and Relationship.

> Developed Transfer Rules and Update Rules.

> User Exits written for Data Source Enhancements.

BW Development Activities:

Archiving:

> BW Archiving of PA Summary and Line item ODS. Scheduling is performed

using the Transaction SARA. Transaction SARI and SARJ were used for

retrieving and reporting on the archived data.

> Archiving also performed for the WORITEMS.

ETL:

> Developed ODS Objects and Cubes for the Revenue and Price Promotion,

to load the transaction data.

> Extracted data from LO, FI-SL, COPA Data sources.

> Loaded data from non-R/3 instances like Flat Files.

> Written/Modified Transfer rules/Update Rules.

> Created and Scheduled InfoPackages for Delta Initialization (Full Load

+ Selection Conditions) and Delta data loading in to InfoCubes Via

PSA, ODS objects.

> Scheduled InfoPackages to load regularly and also automatically

triggering the attribute change run using Process Chains (RSPC) and

Meta Chains.

> Created Infospokes to extract data from the ODS.

> Extensively involved in data design, data modeling, star schema and

performance tuning.

> Carried out Info Cube partitioning.

User Exits/BADI:

> BADI OPENHUB_TRANSFORM written to transform Infospoke data.

BW Reporting (Query Developing):

> Bex / Web Queries Developed using Calculated key figures, Restricted

key figures, Virtual Key Figures, Virtual Characteristics, Structures,

Variables, Conditions, Exceptions, Replacement Paths for Formulas and

Characteristics.

Performance Tuning:

> Resolved Query Performance issues using transactions like RSRT,

RSRTRACE, ST03N, RSDDSTAT, and BW Statistics.

> Worked with Performance related issues related to InfoCubes like

Compression, Rolling-up of Aggregates, and Re-construction to re-

insert the deleted requests, BW Statistics and creation of Indices to

increase the performance, etc.

MindTree Consulting, Bangalore

May 2006 to Aug 2006

MindTree Consulting is one of the Top 10 Software Exporters in India. Mind

Tree crossed the USD 100 million in revenues in April 2006; the fastest

Indian IT company to achieve the target. MindTree is also the

world's youngest company to be assessed at both CMMi and P-CMM.

Role: SAP BW Consultant

Environment: SAP R/3 4.6C, BW 3.5, Oracle 8.0 and Win NT/2000.

Project: Saint-Gobain

BW Development Activities:

ETL:

> Identified data sources based on end-user reporting requirements, and

Created InfoCubes from data extracted from different modules: LIS, LO

Cockpit, FI-SL, FI-GL, CO-PA.

> Loaded data from non-R/3 instances like Flat Files, and Oracle

databases using DB Connect.

> BW Business Content datasource enhancements, generic extractors, User

Exits and customized delta built up for the datasources.

> V3 Updates, controlled by pull/push principle from OLAP system.

> Carried out LO Cockpit configuration and customization.

> Extracted Data from LO, FI-SL, FI-GL Data Sources.

BW Reporting (Query Developing):

> Bex / Web Queries developed using Calculated key figures, Restricted

key figures, Variables, Conditions, Exceptions.

SAP Enhancements (User Exits):

> Worked with Customer Exits in the SAP Enhancement RSAP0001 and

Function Modules or Component Enhancements for Transaction Data and

Master Data.

> Modified/Wrote Customer Exits to fill the appended extract structure

with the data.

> Used enhancement-RSR00001 and Component- EXIT_SAPLRRS0_001 for user

Exits for BEx Reporting.

SAP Labs India, Bangalore

Aug 2004 to Apr 2006

SAP Labs India is the second largest research and development center and

strategic hub for services and support in the Asian Region for SAP. Since

its inception in 1998, SAP Labs India established itself across SAP's full

value chain.

Role: SAP BW / ABAP / CRM Consultant

Environment: SAP R/3 4.6C, BW 3.5, CRM 4.0/5.0, Oracle 8.0 and Win NT/2000.

Projects: TRAFFORD, KMD

BW Development Activities:

To enhance the Business Partner functionality in CRM for the customer and

to web enable and make this data available in the BW for analysis and

reporting.

> Generic Data Source Creation (Master Data Attributes, Texts,

Transaction Data)

> Extraction (Full and Delta Upload).

> Modeling - Creation of ODS & Info Cubes & Info sets

> Extensive transformation code in transfer rules, update rules and

start routines.

> CRM Enhancement of Activity Data Source and the use of BADI to

populate the data for the enhancement components.

> Reporting(Query Developing) - Involved in creation of Restricted Key

Figures, Calculated Key Figures, Conditions, Exceptions, Variable

Reports and use of replacement paths and Customer Exits.

ABAP Development Activities:

The data in CRM was web enabled using the PC-UI (People Centric User

Interface) of mySAP CRM. For this purpose the following activities were

carried out.

> Development of interface programs (RFCs) for the business logic.

> Report to carry out records deletion on CRM side on successful update of

data.

> Creation of Classes and Methods for the CRM PCUI development.

> BDC created for Mass creation of Data Sources and Info objects.

> ALV Reports created for display of status.

ABAP Development Activities in CRM PCUI:

To enhance the Case Management functionality in CRM for the customer using

the CRM PC-UI(People Centric User Interface). The functionality for copying

of cases was also provided.

> Creation of ABAP Classes and Methods.

> Event handling.

> Use of BADIs for enhancements.

The CRM PC-UI was used for the following purposes:

> Creation of a Case Sheet and Case.

> Controlling the Case Categories using the BRF(Business rules

framework).

> Copying of Cases was implemented using the CRM BADI for the same.

Patni Computer Systems, Mumbai

Jul 2002 to Jul 2004

Patni Computer Systems Ltd. Is one of the leading global providers of

Information technology services and business solutions. Patni Computers has

serviced more than 200 fortune 1000 companies and is among the top 10

software exporters in India.

Role: BW ABAP Consultant

Environment: SAP R/3 4.6C, BW 3.0, Oracle 8.0 and Win NT/2000.

Projects: Pitney Bowes, SES-AMERICOM

BW Development Activities:

Supported and Maintained the BW system.

> Interacted with the Management team and end users for designing the

data models.

> Analyzed the business requirements and translated into dimensional

data models by using extended star schema techniques

> Carried out LIS Extraction. Created custom InfoObject Catalogues for

Characteristics and Key figures.

> Created the info packages and scheduled data uploads such as Full and

Delta updates.

> Worked on creation of aggregates and hierarchies for the Info Cubes to

access data in an efficient and ordered level.

> Involved in customizing the business content to suit the Company's

specifications

> Responsible for design and development and extraction from R/3 Source

system and Flat files to BW

> Enhanced existing master data and transactional data extractors.

Modified and Created User Exit programs to accommodate additional

fields in the extract structure of the Data source.

> Managed & Monitored data loads with full update and Delta mechanism

and optimized the performance by adjusting Packet Size and data

Selections.

> Configured use of restricted key figures, structures, variables and

calculated key figures in queries.

> Created conditions, exceptions and filters for query evaluations,

including follow-up actions for mail and reporting agent.

ABAP Development Activities:

BDC:

> Auto Fulfilling for district consignment stock in SD -

For replacement orders where there is line item with specified item

category, there is need to create Outbound Delivery & do a PGI at time

of replacement order save. This would help in immediate recording of

status of replacement meter and update it.

ALV:

> Autoship shipments ALV Report in SD-

Created Autoship Delivery Notes Smart Forms in batch. If the report is

run online, we generate the report on the screen using full screen

ALV, giving details of ADNs sent in today's batch Job. Every day at

night batch job will be set which would print and send Autoship

Delivery Notifications, that are due in next 30 days to respective

customer. The same ABAP will do these 2 jobs depending upon mode in

which ABAP is running (Batch/Online).

> Automatic Purge of Open Return Orders in SAP SD-

An ALV Report of all the open return orders was created. The user

selects the orders to be purged from this report and assigns the

reason of rejection. A BDC is called and all the selected order items

are purged.

> Cash on Account ALV reports in FI-

The extracted data for all open items for the customers is displayed

in the report. It is displayed using an ALV report. The report will

have 3 options -

1. Summary report

2. Detail report

3. Aging summary report.

ALE/IDOC:

> IDOC for material master data transfer in MM -

Any Creation/Change of material master was captured and sent to Siebel

by extending the standard Idoc - MATMAS. Any change in the Material

Determination data of VB11 transaction was also captured and sent to

SIEBEL by creating customized Idocs.

Smartforms:

> Development of the Dunning Smartform in FI-

The Dunning form contains only open items sent out at fixed dunning

intervals. The remittance stub has only open items listed in it for

that particular page.

> Development of Smart Form for Consolidated Invoice in FI.

LSMW:

> Customer Master Data Load -

Loaded Customer Master Data into SAP R/3 using XD01 & XD02

transactions. LSMW direct input is used to load the data into the

target system.

Reports(FI/CO):

> This is a 5 Level Aging Report to notify the due amounts for the

periods inclusive of customer name, branch, document type, G/L account

number based on the level of selection. Provision has been provided to

get the excel download of the required reports.

> Automation carried for uploading Vendor Master data using BDC. This is

meant for ACH and AP wire transfer.

> Customization of the Payment Settlement List Report.

> Customization of the Payment Summary Report. This report consists of

the House Bank details along with the Vendor details.

> Customization of Service Order report.

SAP Scripts:

> SAP Script development for invoice, Interest Invoice and Statement of

Account.

Patni Computer Systems, Mumbai

Nov 2001 to Apr 2002

Final Semester(MCA) 6 months College project carried out at Patni Computer

Systems Ltd., Mumbai .

Patni Computer Systems Ltd. Is one of the leading global providers of

Information technology services and business solutions. Patni Computers has

serviced more than 200 fortune 1000 companies and is among the top 10

software exporters in India.

Environment: SAP R/3 4.6C, Oracle 8.0 and Win NT/2000.

Projects: Integration of SCM using WebMethods between SAP and Oracle

systems.

Development Activities:

> Integration of SCM Information using Integration Broker WebMethods

between the SAP and Oracle Systems.

> Defines ABAP APIs to facilitate the transformation of Information.

> Used RFC to get the relevant data for integration.

Educational Qualification:

MCA - Master of Computer Applications from PSG College of Technology,

Bharathiar University, India.

B.Sc (C.T) - Bachelor of Science in Computer Technology from Coimbatore

Institute of Technology, Bharathiar University, India.

Contact this candidate