Kapil Verma

*** **** ****** *** ***, Philadelphia, PA

Phone: 717-***-****

Email: acumdd@r.postjobfree.com

Objective:

Seeking a SAP Business Object Developer position to grow in other aspects of Report development and Business Object Administration activities.

Profile & Strengths:

SAP - Business Objects Professional with 5 years and 7 months of relevant experience with reputed CMMI Level-5 organization (Accenture Service Pvt. Ltd).

Associated with Business Objects Universe Designing using back-end databases like Oracle & DB2.

Expert in Web Intelligence Report (Visuals and Graphics) and Desktop Intelligence Design and Development

Well acquainted with Business Objects Administrative activities, Dashboard Designer and Xcelsius.

Well versed in On-site and offshore Methodologies.

Exposure to enhancements within existing applications in SAP BI 7.1 & BW 3.5.

Well acquainted in scheduling, creating Jobs/Process Chain with SAP Central Process Scheduling by Redwood.

Possess excellent interpersonal skills which have been put to good use in coordinating with clients and team in order to deliver the best possible solutions.

A very good team player with effective communication skills and proven abilities in resolving complex issues.

Education:

Bachelors in Computer Science & Engineering, Uttar Pradesh Technical University, India, 2010

Professional Experience:

Accenture Service Private Limited Dec 2013 - Present

Client:-Dow Chemical – Philadelphia, PA

Role: Business Objects Developer/ Tech Management Support

Responsibilities:

Gathering the user requirement and prepare the requirement specifications document. This involved interaction with the business users and understanding the current reporting system.

Installed & configured BCA Scheduler Publisher BCAP.

Created centralized Repository with all three domains (security, universe and document) and distributed the BO Main key among the enterprise.

Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.

Worked in creation of multiple universe and document domains for development, test and production Environments.

Worked on Teradata SQL tool to analyze the Teradata SQL and resolve the complex joins causing errors

Created users, groups and assigned roles, privileges and also set row level and object level securities to different users and groups using Supervisor module.

Good experience in creating and maintaining Secured, Shared and Personal connections.

Involved in designing and developing of Universe for reports generation.

Checked the integrity function for existence of loops and resolved them by using aliases and contexts.

Involved in the performance tuning of the SQL queries by restructuring the Joins, creation of indexes etc.

Manipulated the data by creating user defined objects using advanced database functions.

Involved in setting up of Aggregate awareness to enhance the performance of SQL transactions.

Created the Reports using the universes as the main Data providers and writing the complex queries including Sub Queries, Unions.

Trained users to Use Crystal Reports, Modify and enhance Crystal Reports, Save Crystal Reports.

Formatting the Reports based on the user requirements using all the functionalities in Business objects like Slice and Dice, Drill Down, Alerter, User response, and Formulas etc.

Developed complex reports using @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters), @Select and Cross Tab tables.

Created Master Detail and Cross Tab reports to view the data in an analyzed way and Hierarchies to provide the drill down functionality to end-users.

Created Full Client reports using different Data providers like Oracle, Excel sheets, SQL server.

Created report level contexts in Web Intelligence and Desktop Intelligence reports.

Used Broadcast Agent for scheduling and distributing the documents.

Gave my thoughts and ideas to the data-modeling team in designing a new data mart for future reporting applications.

Trained business users in creating web intelligence reports.

Accenture Service Private Limited July 2010 – Dec 2013

Client:-Dow Chemical – Bangalore, India

Role: Business Objects Administrator/Report Developer

Responsibility as an Administrator:

Involvement in Admin activities like creation of new users, giving permissions and rights to users and groups.

Giving application access and resolving access clashes.

Rebooting Servers

Migration of Report and Universes from one environment to other with overloads and permissions and user groups.

Migration performed using BIAR files and directly from one environment to others

Scheduling Reports for different timings and different formats to different users on mails FTP and Business Objects inbox.

Responsibility as a Report Developer :

Worked on Infoview, WEBI Rich Client and DESKI.

Created complex WEBI and DEKI Reports with multiple data providers and multiple prompts and multiple tabs.

The reports consisting of multiple charts with crosstabs, vertical, horizontal tables with pie charts line graphs bar graphs and mixed graphs.

Use of breaks, drilling reports, query stripping, scope of analysis, linked Reports, Use of complex report level variables, ranking, no drill functions and other complex report functions.

Use of Alerter in charts and tables and data tracking in reports.

Worked on Report Conversion Tool to convert simple and complex reports from Deski to Webi and rebuilding the non-converted parts to WEBI.

Worked on DESKI to WEBI Report Conversion in BOXI 3.1 which included detailed analysis of DESKI Reports.

I have worked extensively on WEBI for designing and developing medium to Complex Reports. I have worked on development on 10 WEBI Reports which involved the following:

Multiple Prompts.

Multiple Data Providers

Merged Dimensions.

Line Graphs, Bar Graphs, Cross Tabs and Vertical Tables

Combined Queries.

Complex Report Level Calculations.

Changing prompt text.

Creating object for display purpose in charts.

Application access.

Installing applications.

Technical skills:

Universe Designer and Web Intelligence Reporting Expert.

Reporting Tools Web Intelligence-2.0, 3.1, 4.1, SAP Crystal report-2013, Desktop Intelligece-2.0, 3.1, Cognos8.1, Xcelsius -2008 and Dashboards 4.0.

Report Conversion tool, Import Wizard, CMC-Central Management Console

SAP BI/BW (SAP BI 7.1 & BW 3.5)

SAP Central Process Scheduling by Redwood.

ETL Tool IBM Data stage Director Client 8.1 & IBM Data stage Designer Client 8.1.

Databases Oracle, MS Access and SQL Server.

Reference: Available upon request

Contact this candidate