+91-9959911066 (Preferred) : Rakesh Samuel Pilli
+91-9959911066 (Preferred) : Rakesh Samuel Pilli
+91-9959911066 (Preferred) : Rakesh Samuel Pilli
[email protected] (Corporate)
[email protected] (Preferred)
+91-9959911066
Summary:
:
:
:
:
:
:
:
:
[email protected] (Corporate)
[email protected] (Preferred)
+91-9959911066
CERTIFICATION
SUMMARY OF EXPERIENCE:
Presently working as Software Engineer / BW Consultant in LGS Global Systems Ltd.
Client
Duration
Position
: NSL, Hyderabad
: April 2009 to Till Date
: Software Engineer
Customized Sales Overview (0SD_C03), Purchasing Data (0PUR_C01) as per the clients
requirement and enhanced the datasources and loaded into the data targets.
Created Process chains for Master data and Transaction data loads to automate the data
loading in the organization and these process chains were scheduled for periodic loads.
Configured and extracted Inventory management data from LO Cockpit extractors by making
use of the SAP defined datasources like 2LIS_03_BF, 2LIS_03_BX, 2LIS_03_UM.
Development of Transformations, DTP, Data Sources (flat file source system), Update Rules
and Transfer rules for BI data flow and 3.x data flow.
Creation and maintenance of BI objects (InfoCubes, DSO objects, Infoset, Multi Providers).
Scheduling and periodic monitoring of extractions through Info Packages and Process Chains
Involved in documentation for the mapping, technical specifications, data validations and Test
cases
Created universes, classes and objects by retrieving the data from various data sources and
defining the necessary connections.
Involved in migration and deployment of the universes and reports across multiple domains
Used Business Objects Developer Suite (Publisher View, CMC, Designer, and InfoView) to
perform various tasks specific to every component.
Preparation of Project plan and HDD, LDD of Universe and reports.
Used supervisor module for disabling / enabling access to documents and access to universes.
Creating standard full client reports and WebI reports.
Performed the Integrity check and finally exported to the repository.
Involved in requirements study, design reviews and analysis of input/output flow.
Environment: Business Objects Data services, Business Objects XI Enterprise R3/R2, 6.5.x, , MS SQL Server 2000,
Windows 2003/Unix, Apache Tomcat, IIS.
Client
Period
[email protected] (Corporate)
[email protected] (Preferred)
+91-9959911066
As a responsible member in Load Monitoring prepared work schedule for the team
BW Data load Scheduling, Monitoring and Troubleshooting data extraction/ load Problems.
Maintaining the queue related to the system generated tickets and customer generated
tickets.
Collecting the load failure data and analyzing the load failures for frequency of load failures in
loads and providing RCA to the client in order to get their approval.
Scheduling the Backfills to be done for the week with the required break-ups.
Designed Infopackage Groups and scheduling based on time and events.
Involved in monitoring and scheduling of Info package groups and Process chain.
Involved in Converting InfoPackage Groups to Process Chains.
Ensure that all periodic schedules like daily/weekly and monthly are successful.
Analyze the errors occurred while uploading the data if the request fails and make the latest
data available in data target.
Involved in on going Knowledge Transfer activities including user documents preparation.
Analysis of Short Dumps and interaction with the BASIS Support Consultants to rectify issues.
Worked on Optimization of data loads.
Analyzed production load errors and rectified the same in stipulated time.
Defined various background jobs for Info package groups.
Wrote Routines to handle Invalid Characters.
Involved in creating and moving Transports from Development to Production using specific
transportation tool GSKC (Global SAP Knowledge Center)
Client
Period
: SRSL,
: Oct 2007-Nov 2007
Generic POC has been sent to SRSL giving the new functionalities of BI 7
Has been a team member in preparing POC
Standard BEx Reports with the new look and feel of BI has been delivered.
Web Reports are given with the functionalities of Reporting Agent.
Process chains were designed for standard extractors
[email protected] (Corporate)
[email protected] (Preferred)
+91-9959911066
Written code at Update Rules, Transfer Rules and also in Start Routines
Created Transport requests for developed objects and updated in GSKC site.
Preparation of Technical Specifications
Preparation of Test Cases.
Preparation of Data Validation in Production server.
Modified Info source, Data Targets and writing Backfill programs for Info Providers.
Written Start Routines, Transfer Routines & Update Rules
Worked on data extraction of SAP R/3 system using generic extraction and non-SAP systems
(via DB-Connect).
Used Info package groups for scheduling purposes of master and transactional data.
Defined various background jobs for staging tables & Info package groups.
BW Data load Scheduling, Monitoring and troubleshooting data extraction/ load Problems.
Worked with Object Transports from Development, Quality, Production and rectifying the
errors.
Created and maintained start routine to filter out prior unwanted data while loading for
functional enhancement during data update in update rules and transfer rules.
Education:
TRAININGS UNDERGONE
SAP- BOXI
SAP-ABAP
SAP-DS (BODI)