Data Software Engineer

KIRAN K THIRUNAGARI

Mobile: 517-***-****

SAP BW Consultant

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

Over Seven years of experience in Information technology and about

five years of experience in SAP BW, BW experience comprises of development

and production support. Key strengths lie in the areas of Data Modeling,

Data Loading, Data Extraction and Production Support. Innovation coupled

with strong communication, quick learning, relationship building and

mentoring capabilities have been the hallmarks of career.

Summary

. Worked on Data Extraction and Data Modeling.

. Expertise in Back-end Business Warehouse Components Extractors, Info

Objects, Info Sources, PSA, Update rules, Transfer rules,

Transformations, Routines, ODS, DSO, Info Cubes, Multi cubes, Multi

providers and Info Packages, DTP and in reporting using Bex query

designer and Bex Analyzer.

. Hands on experience in building process chains.

. Good understanding in extracting data from SAP R/3. Also good

knowledge in using generic extraction and customized LO cockpit by

using enhancements and Delta management.

. Worked on SD, FI-GL extractors like Billing extractor and Line items

extractor

. Worked for production support serving complicated SLA on Business

Information reporting Systems.

. Good knowledge on Business objects 6.5, XI R2 (All Modules). Good

understanding in building Universes, Personal data files, creating

complex ad-hoc Reports using the Business Objects and Web Intelligence

modules.

. Sound knowledge in using Oracle Answers, creating dashboards from

OBIEE

. Sound knowledge on SAP Business Planning and Consolidation (BPC) 5.1

and 7.0NW.

. Excellent communication skills, leadership qualities, systematic

approach and ability to work independently interacting with functional

consultants effectively in fast paced environments.

Skill Profile

DW Application Tools Business Information warehouse

ERP Application Tools SAP R/3

Reporting Tools Business Objects, BEx, Crystal Reports

and Oracle Answers.

Languages ABAP, Visual Basic5.0/6.0, SQL, PL/SQL

SAP-Skills

Business warehouse

Modeling - Good understanding and hands on experience in handling the

Extractions from R/3 and also managing of Info Cubes, Info Objects,

ODS Objects, DSO Objects, PSA, Info Source, Application Component,

Data source, Communication Structure, Transfer Structure, Update

rules, Transfer rules, Info Packages, Data Transfer Packages, Process

chains and Roles, Reconciling the reports between BW and R/3. Good

knowledge about Business content.

Performance Issues - Good Understanding on Rolling up the data to the

Aggregates, and Compression of Info Cube and other issues relating for

Query performance.

Extraction - Involved in extraction of data from SAP R3 using

Customized LO Cockpit, FI/GL, and from Flat Files. Sound knowledge on

Generic extraction

Reporting - Experience in Business Explorer (Analyzer, Browser) OLAP

Query, Workbook. Able to Handle Web reports

Open Hub Sources - Good understanding about Info Spokes, Extracting

data from SAP BW to other systems

Business Objects

. Good understanding in building Universe, creating Reports using the

Business Objects and Web Intelligence modules.

. Good Knowledge in Supervisor, Designer and User modules.

. Good Knowledge in Crystal reports.

Business Planning & Consolidation

. Good understanding in creation of Appsets, Applications, Dimesions,

Properties, Memebers.

. Good knowledge in Data collection options, Data Manger packages,

Script Logic, Journal settings.

. Planning and forecasting reports using EvDRE and Expansion functions.

Education Credentials

. Masters in Business Administration in Information Technology from

Preston University, London U.K.(2002-2003)

. Bachelors of Engineering in Mechanical from Bangalore University (1994-

99)

Project Details

Palnar Inc

Jun'08 -Till date

SAP BW Consultant

Gerdau Ameristeel is the fourth largest steel company in North America. The

company has the capacity to manufacture over 12 million tons of mill

finished steel products annually. Gerdau Ameristeel's common shares are

traded on the New York Stock Exchange under the symbol GNA. The company is

headquartered in Toronto, with executive offices in Tampa, Florida. Gerdau

Ameristeel is one of the largest producers of reinforcing steel in the

United States; The Company is also a major supplier of merchant bars, wire

rod, nails, welded wire mesh, railroad spikes, structural shapes, and

pilings.

Responsibilities

. Loaded the data from R/3 to BW,(full initialize load) as well as current

data (daily delta load)

. Performed data extraction from SAP R/3

. Monitored daily and weekly data loads.

. Expertise in Production support for delta and full upload of

Transactional and Master Data

. Thoroughly analyzed Short Dump and Application Log reviews to debug

errors using ST22.

. Worked on BI 7 objects like DSO, DTP, Process chains, Transformation as

part of the ongoing new project.

. Scheduled Process Chains for periodic data loads to various Info

Providers

. Client interaction, end user training and documentation for power users

and end-users

Satyam Computer Services Ltd

July'07- Mar'08

SAP BW Consultant

Philips Medical Systems established in the year of 1918. Today, Philips

Medical Systems is a global leader in diagnostic imaging systems,

healthcare information technology solutions, and patient monitoring and

cardiac devices. Philips also provides customer services such as financing,

consultancy and maintenance & repair.PMS implemented the SAP Business

Warehouse to simplify reporting and analysis for business. This enabled

them make better and quicker business decisions with accurate, timely,

consistent information.

Responsibilities

. Monitor the Daily, weekly, and Monthly Data Loads by means of Info

packages and Process chains and analyzing the reasons for frequent

failures.

. Failed data packets were analyzed for quality check in PSA and reloaded

to ODS and further into Info cubes for reporting.

. Worked on system generated tickets and customer generated tickets as per

the priorities

. Worked extensively on flat file loading.

. Worked on multiple currencies in Reporting.

. Extensively worked on Info Package Groups

. Created info packages for Manual data loads.

. Fixed the Data load errors and interacting with onsite people to speed

up the error correction.

. Checked for data consistency of some wrong data loads and modified the

data in PSA before loading them to data targets.

. Running ad-hoc loads to meet the client requirements from flat files

like monthly loads and take up any escalation on data load issues and

solve them immediately.

Palnar Transmedia (P) Ltd

Jan'06 - Mar'07.

Roche is a leading healthcare company with a uniquely broad spectrum of

innovative solutions. For more than 100 years, Roche has been active in the

discovery, development, manufacture and marketing of novel healthcare

solutions. Roche's products and services address prevention, diagnosis and

treatment of diseases, thus enhancing well-being and quality of life. Roche

has two units: 1.Pharmaceuticals 2.Diagnostics.

Responsibilities

. Giving production support and solving operational issues in data

extraction, loading data into data targets and taking care of performance

issues.

. Troubles shoot the load failures and resolving the data issues within the

stipulated time.

. Created Process chains and also Info packages.

. Created info objects, ODS as per the business requirement.

. Created roles based on the existing templates.

. Carried out Transfer rule mapping as well as update rule mapping.

. Also written simple routines at transfer rule level and update rule

level.

. Activated Business content objects and installed them.

Palnar Transmedia (P) Ltd

Sep'04 - Dec'05.

Roche Diagnostics operates its business from different countries. There are

different BW and R/3 systems maintained for different countries. These BW

and R/3 systems are called as local systems and I was involved in the EMEA

- SD module.

Responsibilities

Extended Billing Item Extractor 2LIS_13_VDITM and also 2LIS_13_VDHDR to

pull BSTNK _VF PO i.e. Purchase order number.

Involved in setting up of procedures for extracting data from SAP R/3 by

using LO Cockpit.

Involved in extracting the planned data from a flat file to compare with

the actual data extracted from R/3.

Created BEx Queries and developed a report on the variance of planning.

Created Process chain and info packages in which created Info package level

routines that will pick automatically the Fiscal Period from master data

tables and loads the data into the data targets.

Giving production support and solving operational issues in data

extraction, loading data into data targets and performance.

Scheduling the daily, weekend, special period re-loads and on-demand loads.

Trouble shooting the load failures and resolving the data issues.

Logic Designers (P) Ltd

Oct 99 - Dec01

Software Engineer

As a Software Engineer was involved in the following:

. Developed an application to automate all the activities of a Petrol Bunk

and installed it in 6 Petrol bunks.

. Developed Pariksha, software for students who are preparing for entrance

examinations for Engineering and Medicine which helps to understand time

management and relative ranking methods.

. Developed a program to give a sales accounting system for Furniture

world, Hyderabad

. Developed a system to integrate all the departments of Rahul Automobiles,

a leading dealer for all Bajaj Vehicles

. Implemented s-mart at Cars Trust Apna Bazar, Hyderabad with 26 outlets

and a warehouse

Environment: Visual Basic 6.0, Crystal Reports, Oracle, Windows, MS Access.

Kiran Kumar. T

Contact this candidate