Resume

Priya C

Mobile: +** 929*******

Email : iyr03l@r.postjobfree.com

Professional summary:

• Having 3.9 years of experience in SAP. Worked extensively on SAP Business Objects XI R3

• Exposure to Business Objects XI Enterprise suite using Designer, Web Intelligence reporting.

• Involved in Designing Universes using different Databases.

• Involved in creating the crystal reports with the help of SAP BW Query and publish the reports in business objects enterprise server. Proficient in understanding business processes / requirements.

• Worked with Web I for creating complicated reports including sub-reports, graphical reports, formula based, well-formatted reports, drilling reports, along with LOVs and data reports.

• Extensively worked in Designing (Involved in Defining Joins, Dimension, Measure, LOV, Hierarchies, and Derived tables, Resolving Loops and SQL Traps, Custom SQL) and Managing Universes (Involved in Linking, Deploying, and Securing & Maintaining).

• Extensively used Business Objects reporting functionalities such as slice and dice, drilling methodology, filters, alerter, ranking, sections.

• Having Experience in Creating Business Objects Reports with Various Databases/Data Sources like Universes, Oracle, SQL SERVER, MS-Excel.

• Extensive Knowledge in Data ware house Concepts and Efficient in testing SQL queries written in Oracle.

• Exposure in Extracting the Data from Heterogeneous Data Sources (SQL Server, SAP R3, oracle).

• Involved in doing Unit testing, writing test cases and data validations.

• Excellent written communication and strong interpersonal skills with ability to work successfully as part of a team or independently.

• Having Flexibility and Adaptability in regards to new technologies and environments.

Work Experience

• Working as a SAP BO Reporter for Keane India, Hyderabad from May 2011 to till date.

• Worked as a SAP BO Reporter for Polaris Software Lab Ltd, Chennai from April 2008 to April 2011.

Skill Sets

Business Intelligence Tool : Business Objects XI R3 (Universe

Designer, Web Intelligence), Crystal

Reports, Xcelsius.

ETL Tools : Informatica

OS : Windows, UNIX

RDBMS : Oracle 10g, SQL Server

Languages : SQL, C, C++, HTML

Education

• Bachelors in Computer Science & Information Technology from Jawaharlal Nehru Technological University

Projects Profile

Project # 3

Organization : Keane India Pvt Ltd,

Client : Washington Mutual, Seattle, WA, US

Role : SAP BO Reporter

Duration : June 2011 to till date

Description:

Washington Mutual is one of the biggest banks and having a series of banks throughout world. Data is available in abundance for the employees on which DSS was built. Client wants to understand their business needs, customer’s requirement in detail and more accurate manner. The bank requires different level of analysis regarding all about loans and loan schemes, type of customers, type of payments schedules, interest rates, payment recovery process, and Installment process and penalty interest calculations for managerial decision supporting system(DSS).

Responsibilities:

• Involved in designing and building of Universes, Classes and Objects by resolving complex loops by defining contexts and aliases.

• Involved in project planning sessions with project managers and team members to analyze business.

• Involved in updating multiple Universes for user Reporting and Linked these Universes to create complex reports depending upon requirements.

• Maintain project related documents.

• Imported data from various tables using SQL Server import wizard when needed fresh data from Production system to Development system (server).

• Use of various reporting functionalities like Drill, Filters, Alerter, Formulas, Variables, Multi Data Providers, Ranking, Merging, Sections, Query Panel, Report Panel, Formatting etc.

• Resolved Chasm &Fan traps and resolved loops using aliases, Contexts, shortcut joins

• Created Daily, Weekly, Quarterly reports for the management team and field operation managers using Business Objects reports.

Environment: Business Objects BOXI 3.1, Crystal Reports 2008, Web I, Query as a Web Service, Oracle 10g.

Project # 2

Organization : Polaris Software Lab ltd, Bangalore.

Client : MTN, South Africa

Role : SAP BO Reporter

Duration : June 2009 to April 2011.

Description:

MTN is South Africa’s leading Telecom provider. Launched in 1994, the MTN Group is a multinational telecommunications group, operating in 21 countries in Africa and the Middle East. As at the end of December 2008, MTN recorded more than 100 million subscribers across its operations. MTN Groups key operations are in SEA, WECA and MENA (Middle East & North Africa). As a part of Management decisions the team is Business Object Reporting application against their enterprise data warehouse.

Responsibilities:

• Involved in developing new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.

• One of the Core parts of Project’s Crystal Reports enhancements and migration to BOE.

• Used Derived tables to create the universe for best performance

• Created complex reports stating revenue generation per year using cascading and user objects like measure objects by using @aggregate aware function to create the summarized reports.

• Resolved Chasm &Fan traps and resolved loops using aliases, Contexts, shortcut joins

• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.

• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.

• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements

• Designed exceptional reports with “Alerter".

• Involved in creating Dynamic & Static crystal Xcelsius dashboards, crystal reports, Web intelligence reports, Rich Client reports with various Data sources.

Environment: Business Objects BOXI 3.1, Web I, Crystal Reports 10, Xcelsius 2008.

Project # 1:

Organization : Polaris Software Lab ltd, Bangalore.

Client : Shire pharmacy, USA

Role : SAP BO Reporter

Duration : May2008 to May2009

Description:

Shire pharmacy is a rapidly growing global specialty biopharmaceutical company. It has a global sales and marketing infrastructure with a broad portfolio of products and its own direct marketing capability in the US, Canada, UK, Republic of Ireland, Germany, As one of the world’s leading specialty biopharmaceutical companies, Shire has emerged to enable people with life-altering conditions to lead better lives. Its UK offices are in Basingstoke and its US offices are in Wayne, Pennsylvania and Boston. Shire is Acquired HGT pharmacy and it’s in process of incorporation. Shire using SAP platform among their major functional areas and it is using BOBJ as a major front end reporting tool.

Responsibilities:

• Understanding documentation preparation by gathering requirements with the Client Interaction

• Involved in preparation of Test Cases for Migration.

• Involved in Preparation of Standards and Checklists for Universe Design.

• Involved in Development of Standard Reports using Web-Intelligence, Scheduling the Reports.

• Created Web Intelligence Reports with query filters, Sorts, Breaks, alerts, Complex Operations (AND, OR).

• Exported reports into various formats like PDF, HTML, EXCEL, and WORD for user.

• Involved in resolving Chasm &Fan traps and resolved loops using aliases, Contexts, shortcut joins

• Created Daily, Weekly, Quarterly reports for the management team and field operation managers using Business Objects reports.

• Involved in doing Unit Testing.

Environment: Business Objects BOXI R2, SQL Server.