Developer Sap
Resume:
B EN NY KALAN JOSE
SAP BUSINESS OBJECT DEVELOPER
B ENNYKALANJOSE@GMAIL .COM
S UM MARY
Areas of Expertise:
● 7 years of cross-functional expertise with Business Objects including creating and
supporting Universes, Web Intelligence, Desktop Intelligence & Crystal Reports.
● Involved in gathering, analyzing, and documenting requirements, functional and technical
specifications for Business Objects Universes and Reports.
● Hands on experience in developing reports in Web In telligence.
● Good understanding of Data warehouse concepts.
● Good understanding of Information Design tool and In teractive Analysis in SAP BO 4.1.
● Good knowledge on new features like Business layer, Data foundation, Security Profiles,
Row level Restrictions in SAP BO 4.1.
● Experience in creating reports with C rystal Reports.
● Experience in using functionalities such as Drill, Fil ters, Sections, Charts and Breaks to
create Complex Reports.
● Experience in data migration process between various t ransactional system using SAP
BODS.
● Expertise in creating Customized Objects, @prompts and Cascading List of Values
● Experience working with and building relationships with internal stakeholders
● Extensive experience on LCM (Life cycle Management)
● Good knowledge in administering Business Objects Enterprise
● Good knowledge in database programming like SQL
● Involved in reviewing test procedures, defining test cases, reviewing and maintaining test
scripts, analyzing bugs and User Acceptance Testing (UAT).
● Strong analytical, problem-solving, organizational, communication, learning and team
skills.
B EN NY KALAN JOSE
SAP BUSINESS OBJECT DEVELOPER
B ENNYKALANJOSE@GMAIL .COM
Technical Skills:
BO Tools Business Objects, Web-In telligence, Import Wizard, Crystal Reports
10, 11, Crystal Reports Explorer, Lifecycle Manager, Publishing
W izard, Report conversion tool, Designer, Planning, Metadata
M anager, Xcelsius, Dashboards 4.0, L ive Office, QaaWS, Dashboard
M anager, Broadcast Agent, Auditor, Web Admin tool, Supervisor, Web
I ntelligence/Infoview.
BO Versions Business Objects versions XI 4.0/3.1/XI-R2/R1/6.5/6.1
Operating Systems Windows NT 4.0/2000/XP/7, AIX, UN IX, Linux
Databases Oracle 11g, 10g/9i/8i, SQL, PL/SQL, SQL server, NetWeaver, DB2,
Sybase
Web Application Weblogic 7.0, Apache Tomcat 4.0, 5.5.26, IPlanet 6.0
Servers
ETL Tools SAP B usiness Objects Data Services, Informatica
Professional Experience:
Role: SAP Business Objects Consultant
Client: E rie I nsurance, Pennsylvania
Duration: April 2013 – Till Date
Responsibilities:
● Interacted with Business Users and Managers in gathering business requirements.
● Conversion of Deski reports into webi reports using Report Conversion Tool.
● Created reports using Business Objects functionalities like Queries, Drill Down, Cross Tab,
M aster Detail and Formulas.
B EN NY KALAN JOSE
SAP BUSINESS OBJECT DEVELOPER
B ENNYKALANJOSE@GMAIL .COM
● Created restricted or custom LOV’s in the universe objects as per the request.
● Created Joins, contexts and Aliases for resolving loops and checked integrity of the
u niverse.
● Developed various charts, graphs and drill down reports.
● Developed Analytical Reports, Webi Reports using BI Launch Pad.
● Involved in Data warehousing designs and have a good knowledge Star-Schema, Snowflake
Schema.
● Expert in designing and building universes by selecting and joining tables, detecting
cardinalities.
● Used various @Functions like @Prompt (for user defined queries), @Where (For creating
conditional fil ters),@Variable, and @Select.
● Used Derived tables to create the universe for best performance, and used context to solve
t he loops in Universe.
● Implemented more than 60 reports on scheduled and daily reports using Web In telligence.
● Extensively used TOAD to verify if the data pulled by the report is correct compare to the
database data and also to verify the joins at the Universe level.
● Responsible for migrating Universe and reports from lower environment to production.
● M igrating Deski reports, Webi reports, Users, Groups and other third party documents
using Import wizard.
● Involved in GAP analysis between requirements and data ware house in order to develop
u niverse.
● Worked in the designing and Building of Universes, Classes and objects
● Working w ith SAP support team to t rack product bugs and fix packs.
● Working with User Acceptance Testing (UAT) teams to fix the UAT issues and performing
sanity tests in Pre-Prod environment/Validation environments and smoke tests in database.
● Creating technical support documentation for Reports and Universe.
B EN NY KALAN JOSE
SAP BUSINESS OBJECT DEVELOPER
B ENNYKALANJOSE@GMAIL .COM
E nvironment: SAP Business Objects 4.1/4.0, Universe Designer Tool, Infoview, Web
I ntelligence, BI Launch Pad, Oracle 10g, Web Intelligence, TOAD, GAP analysis, M igration
Tool, Information Design Tool.
Role: SAP Business Objects Developer
Client: University Of Pennsylvania, Philly, Pennsylvania
Duration: May 2012 – Ma rch 2013
Responsibilities:
● Actively involved with business users by working at the client location to gather new
requirements, and made changes to fulfill the business needs
● Created Standard Reports utilizing all the features on Web Intelligence in BOE XI 3.1 like
Optional Prompts, Functions and Alerter etc.
● Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi
reports.
● Resolved loops and Traps using Contexts and Aliases while designing Universes.
● Set up Universe level conditions to restrict data based on report requirements.
● Developed and created classes with Dimension, Detail & Measure objects and Developed
Custom hierarchies to support drill down reports.
● Created restricted or custom LOV’s in the universe objects as per request from user
community.
● Designed and developed B usiness Objects Universe to support the Dashboard and Ad-hoc
reporting requirements.
• Created a backup of WEBI Reports and Universes in BIAR format using Import
W izard
● Resolved technical and logical issues evolved after going live.
B EN NY KALAN JOSE
SAP BUSINESS OBJECT DEVELOPER
B ENNYKALANJOSE@GMAIL .COM
E nvironment: SAP Business Objects 4.0/3.1, Universe Designer Tool, Infoview, Web
I ntelligence, SQL server 2008,, Oracle 10g, Windows Server 2003, TOAD
Role: Business Objects Consultant
Client: Di rect TV, LA
Duration: Nov 2011 – April 2012
Responsibilities:
● Gathered requirements from end users to create universes and reports.
● Buil t BO Universes utilizing designer module for end user adhoc report generation
capabilities.
● Created Full client, Web In telligence based on the END Users and Business requirements
and Modified the existing Reports based on the specifications and requirements.
● Developed custom hierarchies to support drill down reports.
● Involved in Building universe, Inserting tables, Detecting joins, Detecting cardinalit ies and
checked the integrity.
● Created reports using desktop Intelligence functionalities like sections, breaks, fil ters,
a lerter, slice and dice, drill down functions and formulas etc.
● Involved in the t roubleshooting of universe schema with loops, chasm and fan t raps, and
cardinality problems.
● Verified and validate report functionality utilizing TOAD in the backend.
Environment: B usiness Objects XI 3.1/Xir2/6.5 (Designer, Deski, Webi, I nfo view, Auditor,
C MC, and Import W izard), Oracle 10g, PL/SQL, and Windows 2003
B EN NY KALAN JOSE
SAP BUSINESS OBJECT DEVELOPER
B ENNYKALANJOSE@GMAIL .COM
R ole: Business Objects Developer
Client: TD Bank, New York
D uration: July 2008 – Oct 2011
Responsibilities:
● Designed and Document Universe and Report Requirements Definition templates, Security
s trategies, M igration strategies and Report Dist ribution strategies.
● Detected Joins and checked the Cardinalities.
● Resolved Universe problems such as loops and t raps using alias and context.
● Implemented the Object-Level Security and Row-level security in Universe. Implementing
t he Table Mapping in Universe to restrict certain data in a table to only one group of users.
● Used Business Objects free hand SQL to generate Adhoc reports.
● Created several adhoc reports on demand utilizing Web In telligence.
● Created fil ters in dashboard according to the prompts using components (Filters, Combo
box).
Environment: C rystal Reports 10/XI, SAP BO 6.5/XI R2, Web In telligence, Deski
I ntelligence, Universe Designer.
Education: Masters in Computer Science
Contact this candidate