Data Project

Arun Mortha

SAP BI CONSULTANT

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

Mobile: +91 - 973-***-****

Professional Summary:

. 3.2 years of experience in SAP as SAP BW/BI Consultant.

. 3+ years of SAP Business Information Warehouse (BIW) worked in the

versions of BW 3.5, BI 7.0 and currently working in BI 7.0

environment. Worked in the areas like development and production

support. Having good working knowledge of ASAP methodology, data

modeling, rich experience in data extraction from LO Cockpit and Flat

files. Have worked on SD, MM modules.

. Good comprehending abilities, interpersonal and communication skills.

SAP BI Skills

. Having good working knowledge of ASAP methodology.

. Involved as a key member in the project implementation through the

phases of realization, quality & testing, go-live and post

implementation support for SD Module.

. Worked in the areas of modeling, extraction and reporting.

. Experienced in Activation and Installation of Business Content.

Business content data extraction, Application specific and Cross

Application extraction like LO Cockpit and flat files data extraction.

. Having good experience in developing info cubes, DSO's, multi

provider, transformations, info packages and DTP's.

. Worked on Initialization of Data Sources (Full/Delta Upload), Process

chain, Open Hub Destination, scheduling, Monitoring and Error

handling.

. Created & maintained the process chains to automate the data loads

from ECC and R/3.

. Worked in the extraction of logistics data (SD & MM) from ECC to BI

and scheduled V3 jobs for delta loads.

. Worked with BEX query designer, BEX Analyzer, designed the reports

using Conditions, exceptions, filters, free characteristics,

structures, formulas, CKF and RKF, cell definition, exception

aggregation, characteristic variables, text variables.

. Good knowledge in performance tuning activities like re-partitioning,

indexes, aggregations, compression and query designing techniques.

Educational Qualifications:

. BTech (CSE) from JNTU, Kakinada in March 2010.

Experience Summary:

. Currently Working in Sasken, Bangalore from May 2013 to till date.

. Worked for ARM, Bangalore from Feb 2012 to April 2013.

. Worked for Seal InfoTech, Chennai from Jan 2011 to Feb 2012.

Technical Skills

. Data Warehouse: SAP BI 7.0, SAP BW 3.5, ECC 6.0.

. Reporting Tools: BEX Query Designer, Analyzer.

. Languages: C, SQL.

. Operating Systems: Microsoft Windows 9X/ NT/2000/XP

Project Details:

PROJECT 1:

. Company : Sasken, Bangalore

. Client : Sasken

. Duration : May 2013 to till date.

. Team Size : 12

Client Description:

Sasken is an embedded communications Solutions Company, that helps

businesses across the communications value chain accelerate product

development life cycles. Sasken offers a unique combination of research and

development consultancy, wireless software products and software services,

and works with Network OEMs, Semiconductor Vendors, Terminal Device OEMs

and Operators across the world. Global Fortune 500 and Tier 1 companies in

these segments are part of Sasken's customer profile. Sasken is a member of

premier technology bodies including ITU, 3GPP, GCF, MPEG-ISO, WiMAX, NFC,

Open Handset Alliance, DLNA and ATM, DSL & SDR forums.

Responsibility:

. Involved in the data loads monitoring and production support

activities.

. Create job definitions, time windows, submit frames and configured the

jobs for scheduling in Redwood. Tool (SAP CPS).

. Working with the CPS tool where all the process chains are scheduled.

. Upon the user requirement, scheduling the process chains immediately

and held from CPS.

. Involved in the rectifications of the master data load and

transactional load failures.

. Worked on Error DTP and handled the data loadings with error handling.

. Successfully resolved the issues as raised by the users (tickets) as

per the SLA's.

. Involved in the transportation of the objects like cubes from

development to production in case of any new developments has be done

as per the user requirement, and responsible for to make sure that

development and production are in sync.

PROJECT 2:

. Company : ARM, Bangalore

. Client : ARM

. Duration : March 2012 to April 2013

. Team Size : 12

Client Description:

ARM Holdings is the world's leading semiconductor intellectual property

(IP) supplier and as such is at the heart of the development of digital

electronic products. Headquartered in Cambridge, UK, and employing over

1700 people, ARM has offices around the world, including design centers

in France, India, Sweden, and the US

Responsibility:

. Facilitate the process of transforming functional requirements to

technical specifications.

. Involved as a team member in the project team through all the phases

of realization, go-live and post implementation support in SD.

. Installed the business content and developed the customized objects.

. Transported the developed objects from development to production.

. Extensively worked on multidimensional models to meet the end user

requirements and designed custom DSO's & Cubes and extracted data from

ECC using Standard Extractors in SD.

. Involved in filling the setup tables, loaded historical data from ECC

to BI, successfully did the initialization and enabled the delta.

. Created & modified queries based on the user requirement using

Calculated Key Figures, Restricted Key Figures, Free Characteristics,

Navigational attributes, Filters, Structures, Variables, Text

Variables, Conditions, Formulas, Exceptions.

. Involved in Performance Issues like Creation of aggregates,

Partitioning, Indexes and Compressed the Info Cube to improve the

query response.

. Created the Process Chains for automating the Data loading process as

per the dependencies.

. Worked in the production support after go live.

PROJECT 3:

. Company : Seal InfoTech Pvt.Ltd, Chennai

. Client : Lenovo

. Duration : Jan 2011 to Feb 2012.

. Team Size : 8

Client Description:

Lenovo strives to be a new world company that makes award-winning PCs for

customers. Lenovo operate as a company uninhibited by walls or

organizational structures using world sourcing to harness the power of

innovation across global team. Lenovo design innovative and exciting

products and services to meet our customers' needs. Lenovo introduces the

first dual-core ThinkPad notebook PCs, improving productivity and extending

battery life for up to 11 hours.

Responsibility:

. Involved in loading daily & weekly flat files and actively involved in

Rectification of Load Failure errors like Master Data Loads and

Transaction Loads.

. Expertise in tickets handling raised by users & resolving them with in

SLAs.

. Ensuring that all periodic schedules like daily/weekly loads are

successful.

. Analyzed the short dumps during data loads and fixed the issues.

. Involved in ongoing Knowledge Transfer activities.

. Did the re-initialization for sales document header data source.

. Escalating the issues if the issue has to be resolved by other

Technical/functional teams.

. Reporting to Client and Onsite team in case of any delay in the

Regular Batch cycle.

. Responsible for performance tuning, resolving loading issues and Query

performance issues.

. Reconciliation of data loads in BW as well in R/3 system with the

selection criteria of the load.

Contact this candidate