Data Project

Muruganantham Angamuthu Cell # ***-

***-****

Certified SAP BI/BW Consultant Email:

**********.*@*****.***

PROFESSIONAL SUMMARY:

. Certified in BW 7.4 powered by HANA.

. Certified in BI (BOBJ) Clients and Application on HANA.

. SAP BI/BW Consultant with 10+ years of strong SAP BI experience

including SAP technologies, BW, BOBJ, HANA, BODS in implementation of

business applications for Manufacturing, Telecom, Chemical, oil & gas

and other industry sectors.

. Extensive experience in all stages of Project Development from

Blueprint Feasibility Analysis to Technical Design to

Realization/Development to Go Live Support and business User Training.

. Requirement Gathering: Understand and gathering requirements by

interacting with business analysts, Super users, and Data Architects.

. Involved in multiple implementation of BW and BOBJ Applications with

Web Intelligence reporting.

. HANA Studio : Experience in Hana data modeling Attribute view,

Analytical view and Calculation view, Data provisioning, extract Data

from BODS using SLT and BW on HANA

. BI Reporting: Creation of Universe, Webi reports, Analysis edition of

OLAP, Explorer, report Scheduling, Crystal report, Lumira, Dash Boards

and Qlikview.

. Extraction: Experience in extracting data from SAP R/3 using LO

Cockpit, FI, CO-PA, MM, SD, PP, HR, QM, CRM, generic extractors and

other OLTP Extraction like Transaction Data, Master Data Attributes,

Text, Hierarchies and BODS

. BW Data Modeling: Proficient in BW/BI data modelling, Info Cube

design, DSO object design, Multi provider design, info source design,

info object design, Transports and Integrated Planning.

. BW on HANA Modeling: Experience in ADSO(Advance Data store object),

Composite Provider, ODP(Operational data provisioning), Open ODS View

and SLT.

. BW Reporting: Expertise in reporting using BEx Query Designer,

Analyzer, Web Application Designer (WAD). Having hands on Experience

on Web Application Designer. Creating web templates, assigning queries

to template and publish reports in Portal.

. Business Content: Exposure to the Business Content and implementation

of the same in the appropriate functional area and to activate

business content.

. Source systems: Extracted Data from Flat File, ECC / R3, SAP BW (Data

marts), CRM, Oracle Data Base, JDE and Infomatica ETL systems.

. Data Staging & Loading: Experience with proper data architecture, PSA

maintenance, Info Packages, Data Transfer Process (DTP), Delta

functionality and debugging loads using the Data load Monitor

. Information Broadcasting: Used this tool to send Reports to Group E-

mail as well as Portal Publishing in different formats like HTML,

MHTML, and PDF.

. Performance tuning by maintaining Aggregates, Compression, Partition,

indexing of info cubes and use of statistics for the same and system

stability.

. Production support: Experience with Process Chains to schedule batch

jobs. Configured security roles and authorizations for BW objects,

reports, Portal and experience in Control-m tool.

. Data Migration: Experience in data migration from BW 3.5 to BI 7.0 to

BW 7.3 and Hardware Upgrade and Data Center Migration and Transporting

of objects.

. Testing: Experience in Unit test, Integration testing, User acceptance

tests (UAT).

Extensively involved in preparing User Manuals and End-User training.

. BW ABAP - Have moderate ABAP Knowledge, code debugging and enhanced

Transformations Start Routine, End Routine, user exit, C-MOD code for

LO standard Data source.

. Data Reconciliation: Solid experience in date reconciliation between

systems.

. Strong analytical and problem solving skills.

TECHNICAL SKILLS:

Data HANA, BODS, SAP BW 3.x, SAP BW7.0, BW7.3, BW7.4.

Warehousing

Reporting Bex Analyzer, WAD, Bex Broadcasting, BI Portal, BEx Query

Tools Designer, Webi, Analysis for Office, crystal reports,

Business Explorer, Lumira, Qlikview.

Business Areas MM, SD, HCM, QM, CO-PA, PS, CRM, FI-CO, HR, COPA.

ERP SAP R/3 4.7, ECC 5.0/6.0, CRM 5.0

Languages SAP ABAP, SQL.

Other Tools HP QC10, Control-m, Remedy and Sol-man

WORK EXPERIENCE:

Project #1

Client : SEALED AIR Corp. - Duncan, SC.

Project type : Development and Support

Environment : BW 7.3, ECC 6.0, Business Object (BI4.0), HANA, BODS,

Informatica and JDE.

Duration : December'12 - till date

Role : Sr. BW/BOBJ/Hana Consultant.

Responsibilities:

. Involved in HANA Modeling, Attribute view, analytical view, Calculation

view and data provisioning, and extracted data from BODS, SLT and SQL.

. Experience in BOBJ reporting and Universe design (UDT, IDT), Webi, Direct

BEx connectivity (BICS), Analysis edition of OLAP, Explorer, Dash board,

Crystal report.

. Responsible for Business objects report for users, scheduling daily,

weekly and Monthly reports.

. Extensively worked in various enhancements of existing Cubes, Query, Data-

source and Table view etc.

. Responsible for collecting and releasing transports from Dev to Testing

and Production systems, End-User Training, Change Requests, Handled OSS

notes, Error resolutions, structural fix and system stability.

. Extensively designed and development of reconciliation report between

systems.

. Provided structural fix for BW report for multiple currency appear with .

. Involved in broadcasting the reports to users on daily basis and provided

structural fix for broadcasting issue which was failing

frequently/randomly.

. Provided permanent code fix to remove Bad Characters when load from

source.

. Involved in CITRIX BEx analyzer end to end testing for ERP wave 1 release

cycle.

. Provided structural fix for various repeated issues and improved the

system stability.

. Involved in migration of 3.x to 7.3 CMM flow and BW system integration.

. Experienced in Data Center migration, Unit, Regression and Disaster

Recovery testing.

. Prepared technical specification and unit test plan documents

Project #2

Client : Diversey Inc.- Racine, WI.

Project type : Implementation and Roll Out.

Environment : BW 7.0, ECC 6.0 and Business objects (BI4), JDE, Informatica.

Duration : December'10 - November'12

Role : Sr. BI/BW Consultant

Responsibilities:

. Successfully implemented BW 7.0 for AFME countries and roll out for

Turkey and South Africa countries.

. Implemented Gregorian - Fiscal calendar to normal calendar conversion.

. Extensively involved in hardware update of BW and testing.

. Extensively involved in Unit, regression testing, UAT and interacted with

user, fixed all the issues on time independently.

. Experienced in Go-live, post go-live support and end user training.

. Involved in Design document for the AFME, Turkey and South Africa.

. Worked in roles & Authorization and Transporting of objects across the

system.

. Worked in Integrated planning and Enterprise portal, APD process.

. Involved in Development and Enhancement of WAD reports and BEx Queries.

Project #3

Client : ERICSSON, - Stockholm, Sweden

Project type : Development and support

Environment : BW 7.0, ECC

Duration : Feburary'09 - December, 2010.

Role : BW Consultant

Responsibilities:

. Experienced in analyzing and solving customer tickets in FI / PS areas.

. Involved in Design change/enhancement activity.

. Worked in data loading & monitoring activity for incident ticket issue.

. Involved in transporting of objects to Quality system.

. Extensively worked with Incident, Demand and Expert support tickets.

. Extensively involved in reconciliation activity between SAP source and BW

system.

. Timely identified all BW data quality issue in FI Area and raised

internal ticket for the same using OVSC tool.

. Worked in resolving the BW data quality issue in FI area.

Project #4

Client : BP, - London, England.

Project type : One HR implementation.

Environment : BI 7.0, BW 3.5, ECC

Duration : May'07 - June'09.

Role : BW Consultant

Responsibilities:

. Involved in developing the backend objects like cubes, DSO, Info sets and

Multi providers.

. Worked extensively with BEx Query Designer and Web Application Designer.

. Major involvement in creating Reports by using free characteristics,

Restricted Key figures, Calculated Key figures, Variables and Formulas.

. Involved in identifying the availability of Info Objects in SAP BW and

created customized Info Objects per the Naming Standards.

. Enhanced the Standard Business Content Data Source's and written user

exit for the same.

. Worked extensively on Generic Extractors and enhanced the same.

. Involved in Development of Process Chains for Transaction, Master and

Text data load.

. Involved in collecting the objects, Data Target structures, Queries,

Transformations Etc. and transporting the same to quality system.

. Involved in installing the technical content of BI Statistics.

. Worked with BI Authorizations and transports.

. Involved in unit testing and end-to-end testing.

. Involved in reviews and documentation.

. Involved in go-live and post go-live support.

Project #5

Client : LENOVO, Morrisville, NC

Project type : Support & Load Monitoring

Environment : SAP BW 3.5, SAP R/3 4.7

Duration : January'05 - April'06

Role : BW Developer.

Responsibilities:

. Involved in production support like daily monitoring the data loads from

various source systems like R/3, Flat files by means of process chains.

. Correcting and maintaining work log for data loading errors.

. Scheduling Process chain and Monitoring the data loads on weekly and

monthly basis.

. Data loading was monitored and the failed data packets were analyzed and

manually edited.

. Roll up data from info cubes to aggregates, edit and maintain the

aggregates.

. Documentation in the area of change management.

. Maintaining Work History for all the tickets until it is closed down.

. Issues resolution for tickets of severity, regarding extractions,

performance issues and load failures

. Communicate to business data load status on daily basis.

Project #6

Client : Rajendra Textile Industries, Manufacturing Co.

Project type : CAD/CAM

Environment : AUTOCAD, SOLD WORKS

Duration : May'02 - April'04

Role : Design and Production Engineer.

Responsibilities:

. Drawing & Design and modeling of textile machine components.

. Supervisor for production of textile components.

. Inventory and stock Maintenance.

. Quality Inspection for finished goods.

. Receive the Sub-contract finished goods and inspect them.

Education Background:

. Bachelor of Engineering in Mechanical from Madurai Kamaraj University.

References:

. Will be provided upon request.

Contact this candidate