Jayalakshmi Parasaram_ SAP Business Objects Consultant_8+years

jayalakshmi.parasaram@gmail.com
Jayalakshmi.P
Phone: + 91 8978840303
Professional Summary:
♦ Over 8+ years of experience in Business Intelligence using SAP Business Objects4.0,XI-
R3.1/R2/6.x with Info view, Web Intelligence, Webi Rich Client, Desktop Intelligence,
Crystal Reports 9/10/XI/2008, Xcelsius 4.5/2008, Central Management Console (CMC),
Central Management Server (CMS), Central Configuration Management (CCM),
Query as a Web Service, Live Office, Business Explorer/Polestar XI 3.1, Publishing
Wizard, Import Wizard and Report Conversion Tool.
♦ Strong Knowledge and Experience in Business Objects tools & SAP Business Objects from
2006.
♦ Strong knowledge and Skill in Data Integrator & Data Quality Tools such as SAP Data
services 2.0 , Data Integrator XI
♦ Excellent experience in designing Business Objects universes, complex BO reports both
full client and Web Intelligence Reports.
♦ Involved in gathering, analyzing, and documenting business requirements, functional
requirements and data specifications for Business Objects Universes and Reports.
♦ Used Live Office and QAAWS (Query as a Web Service) to feed live data into Xcelsius
2008 (both Dashboards & Scorecards).
♦ Extensively worked on Business Objects Architecture & Administration. Created Users
and Groups and setting the rights on them using Central Management Console (CMC).
Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis. Debugging the
Problems in the Crystal Reports.
♦ Created reports from multiple sources & functionalities like slice & dice, drill down in Web
intelligence Reports and Crystal Reports.
♦ Extensive experience with SAP BW such as Info cubes, BEx Query designer, BEx Analyzer,
Data Modeling.
♦ Extensive knowledge in SQL, PL/SQL& T-SQL programming and trouble shooting
♦ Strong organizational, time-management and planning skills to deliver projects on
time/budget, despite intense pressure and aggressive timelines.
♦ Good Knowledge of Data Warehouse Concepts including Schemas and Data Modeling.
♦ Complete Software Development Life Cycle experience including requirements gathering,
analysis/design, development and testing.
♦ Excellent communication, interpersonal, training, analytical and technical skills.

♦ Good knowledge and experience in data warehouse development life cycle, requirement
analysis, dimensional modeling, and implementation of STAR, Snowflake schemas.
♦ Strong desire to adapt to latest technologies and ability to grasp new technologies.
♦ Good technical, logical and analytical skills that operate for the best outcome before
Deadlines.
♦ Proven track record of successful implementation of all project life cycle stages from
requirements gathering through implementation and enhancements.
♦ Has received Pat on Back for the contribution to the Project.
♦ Has received many appreciations from Customer apart from PM and Business Analyst.
♦ .Got ‘S’ (Star) Rating which is the Top rating recognition given in the Corporation.
♦ Experience with incident/ticket tracking tools like Remedy, Ticketnow.
Technical Skills:
BI Tools: SAP Business Objects 4.0, XI 3.1, R1/R2 6.5.x,Crystal Report 9/10/ XI/ 2008,Xcelcius
4.5/2008, Info view, CMC, CCM, CMS, BEx Query, BEx Analyzer, Desktop Intelligence XI,
Full Client, Web Intelligence, Business View Manager
ETL Tools: BO Data Integrator (ETL), SAP Data Services 4.2
Platforms: Windows (all flavors),
Databases: SQL Server 2000/7.0/6.5, Oracle 10g, 9i/ 8i, Access, Sybase
Languages: C, Java, .Net, SQL, PL/ SQL, T-SQL
Education:
Degree University Year of Passing
B.Tech J.N.T.U, Hyderabad, India. (04/2005)
Professional Experience:
Organization Designation Duration
IBM India Pvt. Ltd Senior System Engineer 04/2015 – Till date

Polaris Financial Technologies Consultant (01/2014) – (03/2015)
Tata Consultancy Services IT Analyst (10/2010) – (01/2014)
Satyam Computer Services Ltd. Software Engineer (03/2006) – (10/2008)
Projects Summary:
1. Project Name : EY AMS offshore
Client E & Y
Role Sr. Consultant
Organization IBM India Pvt Ltd, India
Duration (06/2015) – (03/2016)
Team Size Project : 100 + Module : 15 +
Environment
(with skill versions)
Software BI Tools : SAP Business Objects
Database : SAP ECC / GFIS
ETL Tools : SAP Data Services 4.2
O/s : Windows 2003
On the SAP side a Co-Existence (COEX) company code will be configured in the SAP
environment. Within this company code cost centres will be setup to represent the Country and
Sub Service Line combination for all non-deployed SAP Legal Entities. A mirror of the GFIS
interoperable engagement structure will be created in Co-existence company code and vice
versa.
Interfaces / Jobs will pick up the dataset for employee records from SAP Tables, generate XML
files (each for regions 1/2/3) and ftp the files to GFIS and vice versa.
Responsibilities:
♦ Involved in designing the Data Flow design documents, provided the solution document for
integrating the SAP and Non-SAP source systems
♦ Designing Workflows and Data flows using Business Objects Data Services (BODS) to
implement the conversion logic for Master Data and Transactional Data with large volumes
of history data.
♦ Involved in Creation of jobs that specify data mappings and transformations by using
Data Services Designer.
♦ Used Data Services to load data from different sources (SQL, Text files) to the target
database
♦ Performed Unit, System and Regression testing of the Business Objects Data services ETL
jobs
♦ Developed jobs using Business Objects Data Services designer to extract data from source
databases and flat files into staging area

♦ Created Jobs, Workflows, Transformations and Data Flows according to requirement to
integrate source data in to Target data ware house
♦ Analyzed various Data Warehouse Models like slowly changing models, Conceptual
Models, Logical Models. Also Designed and developed Data Integrator scripts for data
transformation.
♦ Involved as SAP BOBJ ETL Developer from Realization phase in End-to- End Data
Warehouse implementation project
♦ Schedule and Monitor Batch Jobs using Data Services Management Console.
♦ Designed an ETL Job which integrates Flat file and XML data, loads into single target using
XML_PIPELINE and MERGE Transforms
♦ Used BODS Data Integrator Transform PIVOT to apply the row level and column level
transformation according to reporting requirement
♦ Implemented Slowly Changing Dimension – Type 2 (SCD – Type 2) for the required
dimensions by using TABLE_COMPARISION Transform, HISTORY_PRESERVING
Transform and KEY_GENERATION Transform
♦ Used the LOOKUP_EXT and LOOKUP_SEQ functions to derive the columns in BODS
ETL by look upping the values in lookup table of type validity tables
♦ Experience in debugging execution errors using Data Services logs (trace, statistics, and
error).
♦ Experience in Data Profiling for Data Quality to Achieve Quality Data.
♦ Experience with using SAP ECC and Legacy systems as source and SAP as a target with
SAP Data Services
♦ Experience in doing extracts from both Non-SAP and SAP source systems.
2. Project Name : Risk Information Strategy for the Enterprise (RISE)
Client TD bank
Role Sr. Consultant
Organization IBM India Pvt Ltd, India
Duration (06/2015) – (03/2016)
Environment
Database : SQL server
ETL Tools : Data Integrator
O/s : Windows 2003
The Risk Information Strategy for the Enterprise (RISE) is a multi-year program launched by
Enterprise Risk Management (ERM) to conduct current state assessment, develop and implement
a future state vision and high-level strategic roadmap for TD’s risk information. The RISE
program aims to develop an institution-wide ability to manage risk within TD’s Risk Appetite
through more effective and efficient use of data and technology to comply with BCBS 239
principles.

♦ Involved in requirement gathering from Business users.
♦ Responsible for understanding end user requirement and convert into functional
requirement and involved in preparing project plan.
♦ Worked on the Proof of Concept for the new reports and submitted the challenges.
♦ Worked with the design team to create new report designs as per changing user
requirements.
♦ Analyzing system functionality requirements, documents and scope of the work.
♦ Work included Universe Designing, Requirement Gathering, Setting up Joins,
Cardinalities, and Solving Traps using Contexts and Aliases and Updating Universes
based on additional Requirements etc Using IDT.
♦ Work included Developing, Testing and enhancing existing Business Objects Universes;
work required modifying, testing and promoting to the Repository.
♦ Worked on the universe requirements documents which specify the required fields on the
reports.
♦ Developed the Trust Universe on top of the Trust data. Defined and created Classes,
Objects, Conditions, Filters, derived tables and @prompt objects.
♦ Used @aggregate aware to improve the performance for aggregation.
♦ Have resolved loops, Fan Traps and Chasm traps using context and alias and also have
built custom hierarchies and predefined filters to facilitate easy drill down and addressed
performance issues.
♦ Developed crystal reports and web intelligence reports as per the requirements.
♦ Developed, Tested, Promoted and Maintained the WEBI Reports, also had modified the
existing reports based on user requirements, Also solved any issues/errors encountered
♦ Responsibilities required acting as the Key Person for maintaining Universe's with
creation of joins, Cardinalities, Contexts, and solving the loops, Testing, Data
analysis etc.
♦ Created reports using Business Objects functionalities like Slice and Dice, Drill Down,
Cross Tab, Alerter and Formulae etc. using Web intelligence.
♦ Formatted Reports as per the User requirements using extensively the functionalities in
Business Objects, which allows the users to analyze the data.
♦ Extensively used Calculations, Variables, Break points, and Sorted inputs, Drill
down, Slice and Dice, Alerts etc. in Creating Reports, formatted old reports,
generated charts, bars etc as per user requirements using Crystal Reports 2008,
Xcelsius 2008 and integration as well.
♦ Manipulating data through various presentation styles using Crystal Reports 2008 such
as charts cross tabs, slice and dice, user response, alerts, prompts, nested loops and
filters.

♦ Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
♦ Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
♦ Created complex reports using multiple queries and involved in tuning the reports in
order to improve the performance of the reports.
♦ Created sub reports as required.
♦ Developed the reports with consistent drill-down functionality including Drilldown
Reports, Summary Reports and Detail Reports.
♦ Developed Manual Running Totals and used Complex Formulae in the reports.
♦ Created variables and defined formulae to capture user responses to a prompt and to
display document information for Webi reports.
♦ Worked on the technical specification documents for the new web intelligence reports.
♦ Created Folders and categories in Infoview to logically differentiate BO content.
♦ Worked on CMC (Central Management Console) to perform Administrative tasks like
Setting up user profiles, assigning rights and privileges for groups, setting up
categories, and maintain BO servers
♦ Trained the users in viewing/scheduling the Trust reports using the Info view.
♦ Testing and validation of the data on backend and on Info view reports and collecting the
testing evidence.
♦ Created Change request tickets to migrate the BO Universes and Reports to production.
♦ Resolved all kind of issues that arise from Business Objects components including
performance.
♦ Done extensive testing across various scenarios to see the Webi report working across
multiple complex and varying scenarios.
3. Project Name : Assets Management –Offshore
Client HDFC
Role Team Member
Organization POLARIS FT, India
Duration (01/2014) – (02/ 2015)

Environment
ETL Tools : SAP BO Data Integrator
O/s : Windows 2003
Project Description:
HDFC Bank has a nationwide network of 1,725 Branches and 5,231 ATM's in 780 Indian
towns and cities. This project mainly divided into 4 modules as Assets, Liabilities,
Profitability and Cards. For each module one separate universe was created to meet the
ad-hoc reporting requirements by the client HDFC.
Responsibilities:
♦ Involved in using Job Server in creation of batch jobs. And also involved in Performance
tuning at source, transformation, and target levels.
♦ Creation of ETL Processes for the added new Subject areas, Develop Data Extraction,
Transformation and Loading Program using Data Integrator.
♦ Involved in Creation of jobs that specify data mappings and transformations by using Data
Integrator Designer.
♦ Used Data Integrator to load data from different sources (SQL, Text files) to the target
database
♦ Performed Unit , System and Regression testing of the Business Objects Data Integrator
ETL jobs
♦ Used Business Objects Data Integrator XI R2 for ETL extraction, transformation and
loading data from heterogeneous source system.
♦ Developed jobs using Business Objects Data Integrator XI designer to extract data from
source databases and flat files into staging area
♦ Created Jobs, Workflows, Transformations and Data Flows according to requirement to
integrate source data in to Target data ware house
♦ Analyzed various Data Warehouse Models like slowly changing models, Conceptual
Models, Logical Models. Also Designed and developed Data Integrator scripts for data
transformation.
♦ Developed, Tested, Promoted and Maintained the WEBI Reports, also had modified the
existing reports based on user requirements, Also solved any issues/errors encountered
♦ Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
♦ Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.

4. Project Name : BP R&M-Mfg AD T&M-Offshore
Application Name : Whiting Timesheet Reporting
Client British Petroleum (BP)
Role Team Member
Organization Tata Consultancy Services, India
Duration (08/2013) –(01/2014)
Environment
ETL Tools :Informatica
O/s : Windows 2003
Whiting Timesheet Reporting is an application used for end users to generate adhoc reports
based on the database for reporting time of an employee/contractor .Employees while entering
and exiting the BP site swipes their smart cards (ID badges) against the access control and the
information is stored in the WTR Reporting database (WHITSRPRD01).Whiting Timesheet
Report is the site access control, alarm monitoring and ID badge system for security
management installed at the Refinery. It manages all badges in, badges out events and feeds the
database.
The following are some important features of WTR:
♦ Analyse the information in a Business Objects Webi reports
♦ These adhoc reports are intended for TRACK and Non-Track vendors apart from BP
personnel and contractors
♦ Key Business Persons creates adhoc reports on WTR applications.
Contribution:
As a developer, was responsible for

♦ Directly coordinating with user to gather the new requirements and working with
existing issues.
♦ Designed & Implemented security architecture for Business Group.
♦ Involved in Data Modeling and SQL server Database
♦ Designed Universes for payroll system and Order processing
♦ Created Objects and classes in universes based on the business requirement
♦ Involved in joining the tables by creating aliases to resolve the loop
♦ Involved in creating contexts to resolve chasm and Fan Traps in universe
♦ Involved in creating Derived tables on complex SQL queries
♦ Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
♦ Implemented Security Features of Business Objects like row level, object level and
report level to make the data secure.
♦ Tested the Business Objects reports involving complex queries, sub queries, Unions and
Intersection.
♦ Performed unit testing, system testing and user acceptances test (UAT) for universe, reports
and security management.
♦ Developed universe user documentation guide for the end users reference
5. Project Name : Telenor Duplo AM/AO Offshore
Client Telenor - Norway
Role Team Member
Organization Tata Consultancy Services, India
Duration (07/2011) – (08/2013)
Environment
Database : Oracle, Microsoft and Sybase database middleware
ETL Tools :Informatica
O/s : Windows 2003

The SAP Business Objects is a reporting tool is being used across all the division of Telenor
Norge for viewing & analyzes the data in report form. Telenor Norge has divisions called
Business, Consumer, Distribution, operation, Finance, Wholesale, SIT.
Four servers (2 for prod, dev and test) servers are being used for developments, testing and for
the user. For better performance the tomcat server hosts the web applications/portals is installed
on another H/W platform not on the BO production server. Production platform is having 4 CPU.
There is a dedicated production server for Siebel sales purpose since sales platform require data
in real time mechanism.
Salient Features
• A very big account for TCS with around 200 + associates
• Integration of more than 50 different source systems into a single Tool
• Currently there are approximately 2000 users are defined in SAP Business Objects
application, and around 1500 are active users. And 2000 + public or shared reports and
8000 private reports exist in SAP Business Objects application
• Dependency / criticality of application are very high as so many users’ uses the BO
reports / Xcelsius dashboards to analyze the sales / Business data.
• The availability of all the environments is very critical as 10000 + users will be affected.
• Versatile ETL and Data Model Design to include any source system.
Contribution:
As a Administrator/developer, was responsible for
• To resolve critical incidents raised by client on critical issues SAP Business Objects
For maintenance of servers (Dev/Test/PROD1/PROD2) of SAP Business Objects.
• To maintain performance of the servers of BO
• To delete /remove users as per the security compliance.
• To disable users who are inactive from a particular period of time on monthly basis
• To work on change requests on existing universes and reports for all the report
scheduling a maintenance.
• Migration of Universes, Reports, Securities from the Development to
TEST/Production environments after System Integration Testing(SIT) and then
followed by Business Acceptance Testing(BAT). Using Import Wizard for the
Migration process across the environments.
• Administer and supervise the BO environment by monitoring/granting permissions
and rights to vast users, creating and publishing reports and implement Folder
and object level restrictions.
• Importing the groups and users from windows Active Directory into SAP
Business Objects and granting the users and groups with appropriate rights through
Central Management Console.
• Administer and supervise the BO environment by monitoring/granting
permissions and rights to vast users.

• Used different Web services like Live Office, QAAWS to make a live connectivity
between the Crystal Xcelsius Dashboards and BO Enterprise 3.1.
Other Projects:
Project Name Organization Technologies Duration
USAA EOR
Offshore
Tata Consultancy
Services, India
BI Tools : SAP Business
Objects , SAS 9.0
Database : Oracle, Microsoft
and Sybase database
middleware
O/s : Windows 2003
(10/2010) –
(07/2011)
Drilldown
Reports
(DDR)
Satyam
Computers
Objects,MS Analysis
Services 2000
Database :SQL Server 2000
ETL Tools :MS DTS
GUI : ASP 3.0,Java Script,
VB Script
Languages : .Net 2.0 with C#,
Java scripts, MDX
O/s : Windows XP
(07/2006) –
(10/2008)
Monthly
Review
Reports
(MRR)
Satyam
Computers
Objects,MS Analysis
Services 2000
Database :SQL Server 2000
ETL Tools :MS DTS
GUI : ASP 3.0,Java Script,
VB Script
Languages : .Net 2.0 with C#,
Java scripts, MDX
O/s : Windows XP
(07/2006) –
(12/2007)
Personal Details:
Name Jayalakshmi.P
Address
W/o B. Venkata Raja,
D.No 5/554,
Near devanga kalyanamandapam,
Vinayak nagar,
Proddatur. AP
India.

Email Id Jayalakshmi.parasaram@gmail.com
Passport details Passport Num: K6899943
Date of issue: 25 -oct-2012
Expiry date:24-oct-2022
Place of issue: Hyderabad, India.
Contact Numbers Mobile: 8978840303

Jayalakshmi Parasaram_ SAP Business Objects Consultant_8+years

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Viewers also liked

Viewers also liked (18)

Similar to Jayalakshmi Parasaram_ SAP Business Objects Consultant_8+years

Similar to Jayalakshmi Parasaram_ SAP Business Objects Consultant_8+years (20)

Jayalakshmi Parasaram_ SAP Business Objects Consultant_8+years