PROFILE SUMMARY:

• Over 7+ years of experience in developing solutions using Business Objects Enterprise 4.0/ XI 3.1
• Involved in complete development life cycle of BI products - Analysis, Design, Development, Testing, Implementation and Support
• In-depth experience in performing analysis, design, implementation, and support of BO Universes and Reports; Expertise in designing and developing Web Intelligence, DESKI reports and Crystal Reports
• Experience in handling Business Objects modules like CMC, Designer-UDT/IDT, Web Intelligence rich client, Desktop Intelligence, Import Wizard and Xcelsius
• Expertise in translating functional requirements into technical specifications and providing BO solutions
• Experience in developing Universes from different databases including Oracle, SQL server, Optim (IBM)
• Expertise in designing Universes for Performance Management and Reporting needs
• Experience in developing Desktop Intelligence, Web Intelligence and Crystal Reports using different Data Sources
• Extensively worked with SQL Queries and capable of handling Oracle, SQL Server, MS Access databases and also have good experience in database tuning and performance techniques
• Proficient in Design, Development, Coding, Implementation and Support
• Excellent Communication and Interpersonal skills, Quick Learner and Adopts to new environments easily

TECHNICAL SKILLS:

BI Tools: Business Objects XI 4.0/R3.1/R3, SAP Information Design Tool, SAP Universe Design Tool, Universe Designer, Desktop Intelligence, Web Intelligence, Info View, Xcelsius 2008/4.5, Crystal Reports 2008/10, Query As A Web Service, Live Office 3.1, Supervisor, CMC, CCM, Import Wizard, Publishing Wizard, Report Conversion tool and Lifecycle Manager.

Languages: SQL, Oracle PL/SQL, MS SQL

Database Systems: SQL Server 2005/2000, DB2, MS Access, Oracle RDBMS 10g/9i, Optim (IBM)

Dimensional Modeling: Star Schema Modeling, Snow Flake Modeling, Fact and Dimensions Tables & Data Integrator

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. Business Objects Developer

Responsibilities:

• Involved in requirements gathering from Business Users and participated in jar sessions
• Analyzed Requirements and prepared Report Specification Document for crystal reports and BO reports
• Developed complex Ad hoc Webi & Canned reports on archived data
• Optimize various SQL queries to make the reports run faster and extensively used crystal reports advanced functionalities
• Created Universes from wide variety of databases with measures and dimensions objects, join conditions, filters, LOV, cardinality, resolving join path problems like Loops and Traps in the universes using Aliases, Contexts, Aggregate Awareness in Business Objects Designer
• Created different types of reports like Cross Tab, Charts and Master Detail using multiple data sources
• Developed Cross Tab Reports, Pie and Bar Charts, Parameter Reports, Running Totals, Sub-Totals and embedded linked and unlinked sub-reports to separate and organize key information and to promote reusability in data reporting
• Designed and Developed Webi Reports using the features like Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down to analyze the data
• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV
• Created Web Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL
• Created cascading list of values to enable cascading prompts in the reports using Designer
• Wrote several PL/SQL queries to query the database and use them as a command object for designing the reports
• Conducted User Acceptance Testing with business users
• Trained business users on Ad-hoc reporting
• Prepared unit test case documents and user guides
• Deployed Business Objects reports in different environments (Development, QA and Prod)
• Schedule the reports using BI Launch pad to run at specific times in a day/week as desired by the Business Users
• Scheduled Webi reports on daily basis and exported them in Excel/PDF format
• Provided Production Support and Technical Support to the Users and Business Analysts for Reports, Universe and day to day issues

Confidential, PA

Business Objects Developer

Responsibilities:

• Extensively worked with end user to understand business requirements
• Created Report Specification Documents and mock up reports based on the gathered requirements
• Developed universes with SQL server as data source and Imported/ Exported the Universes from/to repository to make them accessible to end-users
• Created universes using Business Objects Designer & Created reports using Desktop Intelligence/ Web Intelligence
• Implemented row and column level security in the Universe & Reports for confidentiality
• Created Classes, Objects and also tested them to ensure the accuracy of the data model
• Resolved loops, chasm and fan traps using contexts, aliases
• Created List of Values in the Universe Dimension Objects for specific report requirements
• Created parameterized summary and detailed reports and performed unit testing
• Developed critical reports like drill down, master/detail for analysis
• Created Webi reports using advanced features like Formulas, Groups, Sub Reports, Hyperlinks, Alerts, Cross Tabs, Charts and Parameters
• Developed and maintained the Crystal Reports based on the requirements of the End Users
• Developed crystal reports with command prompt with free hand SQL
• Prepared Design documents, Unit test plans and User guides
• Extensively involved in users with the BO interface and BO reports
• Conducted User Acceptance Testing and was involved in Production deployment of BO and Crystal Reports
• Provided Production and Technical Support to the Users and Business Analysts for Reports, Universe and day to day issues
• Implemented migration of repositories (Universes, Reports, Securities, Categories) from DEV to UAT and then to PROD
• Worked with BO Administrator on Users creation, User groups and defined the security using CMC

Confidential, FL

Business Objects Developer

Responsibilities:

• Created and updated complex SIMBA Reporting Universe
• Implemented Cordiality settings, Joins, Contexts, Predefined Conditions and Global Filters in Universe
• Worked on Aliases and Contexts to resolve looping problems and used Derived tables methods
• Installed and Configured Business Objects XI 3.1 on Unix with Web logic
• Generated Reports from Different Data Providers in Business Objects using SQL Server
• Worked on Call and Incident Management, (Tickets) Resolving the tickets raised by the User in relation to Reports not extracting data, Reports running for long time, Database connectivity Issues
• Involved in Request Management System: Adding Users Security in the environment (Ex: LDAP and Enterprise), deploying the universe and objects from Development to Production
• Configured BOBJ Reports, Ad-hoc and Dashboards with front-end portal using Assemblies
• Created Xcelsius dashboards, Scorecards on analyzing the data on Confidential resorts
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard and BIAR file methodology
• Developed Web Intelligence reports on status on Confidential World Resorts as Daily, Weekly, MTD and YTD as per the requirement
• Created complex reports stating revenue generation per year using cascading and user objects like measure objects by using @aggregate awareness function and also Smart Measure feature in XI3.1 to create the summarized reports
• Created Hyperlinks using OpenDoc functionality for Summary Report to Detail report analysis
• Created complex reports using various functions like Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection, Developed critical reports (like drill down) for analysis of parts benefits and head count
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure
• Used Breaks and Sections in Webi reports and used different graphical charts and bars
• Scheduled Webi reports on daily basis and exported them in Excel/PDF format

Confidential, NY

Business Objects Developer

Responsibilities:

• Converted business requirements into technical requirements with BO technical team
• Interacted with users for analyzing the database and reports
• Created classes, sub classes, objects in the development of universe
• Created Cardinalities, Joins and Aliases for resolving Loops
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements
• Created pre build conditions, LOV’S and Prompts in universe to make report development easier
• Created Views in Oracle for better performance and aggregation
• Prepared universe for Ad-hoc query functionality and educated users to create and run adhoc reports using objects in the universe
• Developed Universes to accommodate complex database design approaches
• Setup hierarchies in the Universe for providing drill down options in the reporting environment
• Created the reports using Business Objects functionalities such as Slice and Dice, Cross Tab, Master Detail and Formula's etc.,
• Tuned SQL queries to increase the performance of Business Objects reports
• Trained end users with business objects products like Info view and Web Intelligence Rich Client