PROFILE :

6+ years of comprehensive and in-depth experience in IT industry as a software developer in designing and developing Business Intelligence and Data Warehousing solutions.

• 6 years of Business Objects XIR3/R2 designing, developing and testing of Universes and Reports.
• Very good knowledge and exposure to BO4.0.
• Experience in Designing, Building and Maintaining the Universes, resolving the issues like loops and Traps using Alias and Context, designing complex objects.
• Successfully developed and implemented various Reporting needs for OLTP and OLAP using Web Intelligence and Crystal Reports.
• Business Objects XI3/R2 Administration & Security Configuration using Central Management Console
• 3 years of experience in Dimensional and Relational Data Modeling - Star Join Schema Modeling, Snow-Flake Modeling, Physical & Logical Data Modeling Erwin
• Expertise in building dashboards using Crystal Xcelsius 4.5/2008.
• Expertise in databases MS SQL Server 2008/2005, Oracle 10g/11g, SQL, PL/SQL, RDBMS, DB2, MS Access.
• Highlyproficient in communicating with Business users in analyzing the Business Process requirements to roll out the reports and maintain documentation for future reference.
• Experience in Live Office and QaaWs Services.
• Proficient in all phases of Software Development Life Cycle (SDLC) Requirement analysis, design development, testing and documentation migrating
• Expertise in developing BI solutions for Financial, Research & Development, Health and Retail sectors
• Effective inter-personal skills, adaptive to any environment & keep abreast with the latest technologies

SKILLS SET:

Data Warehousing Tool: Business Objects XIR 3/R2, Web Intelligence, Desktop Intelligence, Universe Builder, Designer, Crystal
Reports,CMC, Crystal Xcelsius 2008/4.5
Databases : SQL Server 2008/2005, Oracle 10g/11g/9i, My SQL, IBM DB2, MS Access
Languages : C, C++, VBScript, SQL, PL/SQL
Dimensional/Data Modeling : Star Schema Modeling, Snow Flake Modeling, Fact and Dimension Tables
Platforms : Windows NT/9X/2000/2003/XP

EDUCATION:

Bachelors of Engineering

PROFESSIONAL EXPERIENCE:

Confidential,FL
Business objects Developer/Reporting May 2012- Present
Responsibilities:

• Directly coordinated with business users/Analysts to gather the new requirements, converted into functional description and prepared a project plan
• Extensively used BO XIR3.1 environment for building universes and reports
• Specified the standards for universes, Classes, Aliases, Simple and complex objects.
• Created cascading list of values to meet business requirements
• Used aggregate tables and short cut joins to improve query performance
• Created filter objects, and formatted objects and measures within the universe for faster report generation.
• Created custom WebI reports and scheduled them to run on weekly and monthly basis for various financial groups using the Universe as a main data provider.
• Extensively used WebI features - Breaks, Alerts, Filters, Sorts, Query Prompts and Drill filters
• Performed Unit Testing and User Acceptance Testing for Universe, Reports and Security Management
• Provided detailed end-user training for power users and report consumers about XIR3.1 reporting features
• Implemented row level security in the universe
• Created User Groups and folder structure according to the Business requirments using CMC
• Setup user rights on folders level as well as at application level using CMC
• Defined security for universes and connections using CMC

Confidential,NJ Jan 2011 May 2012
Business Objects Developer
Responsibilities

• Directly coordinated with business users/Analysts to gather the new requirements, converted into functional description and prepared a project plan
• Extensively used BO XIR3.1 environment for building universes and reports
• Created and tuned the Universe, set-up Contexts & Aliases for resolving Loops and Traps in Designer
• Developed new hierarchies in the universes to meet Drill Analysis of the reporting needs
• Improved the performance and reduced the coding with the use of @ functions - @Select, @Prompt, @Aggregate_Aware, @Where
• Specified the standards for universes, Classes, Aliases, Simple and complex objects.
• Created cascading list of values to meet business requirements
• Used aggregate tables and short cut joins to improve query performance
• Created filter objects, and formatted objects and measures within the universe for faster report generation.
• Created custom WebI reports and scheduled them to run on weekly and monthly basis for various financial groups using the Universe as a main data provider.
• Extensively used WebI features - Breaks, Alerts, Filters, Sorts, Query Prompts and Drill filters
• Developed complex reports using multiple data providers
• Created Predefined client reports with prompts and deployed these reports in the Webi Server.
• Performed Unit Testing and User Acceptance Testing for Universe, Reports and Security Management
• Provided detailed end-user training for power users and report consumers about XIR3.1 reporting features
• Implemented row level security in the universe
• Created User Groups and folder structure according to the Business requirments using CMC
• Setup user rights on folders level as well as at application level using CMC
• Defined security for universes and connections using CMC
• Created regional sales dashboard using xcelsius 2008

Confidential, Harrisburg, PA Aug 2009 Dec 2010
Business Objects Report / Xcelsius Developer
Responsibilities:

• Interacted with Business Analysts, Business Users and Managers in gathering business requirements.
• Created derived tables at the Universe level to reduce the complexity of universe building.
• Extensively used Business Objects XIR 3 Web Intelligence, Info view, and Desktop intelligence for querying, reporting and analysis tasks.
• Involved in testing and fixing issues in Universes, Reports, Objects, Conditions and LOV’S (List of Values) .
• Used @functions (@select, @where, @prompt) to create predefined conditions, and prompts to filter the data in the universes.
• Specified the standards for universes, Classes, Aliases, Simple and complex objects.
• Defined cardinalities, Checked integrity, Detected loops and resolved them by using aliases and contexts to remove the cyclic dependencies.
• Proficient in using SQL, PL/SQL, T-SQL to study data in different systems and to validate reports.
• Developed Ad hoc reports using Business Objects.
• Built Xcelsius Dashboards for sales and marketing department for analysis
• Used Query as web service and live office as middle connector
• Built drilled down dashboards and linked master detail dashboards
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master Detail and Formulas etc.

Confidential,SpringField, IL May 2008 Jul 2009
Business Objects Developer/Designer
Responsibilities

• Completed the project from analysis to implemention following full SDLC
• Extensively used BO XIR2 environment to create universes and reports
• Created universes and reports to meet the business requirements
• Resolved Chasm, Fan trapes by aliases and contexts
• Linked the universes to easily mantain them
• Extensively used Web Intelligence and desktop intelligence to built complex reports for the business
• Evaluated reporting environment for performance and presented recommendations to senior management
• Use of CMC to create user groups and folder structure based on business requirements
• Setup up folder, universe and application level rights for different user groups

Confidential, NY Feb 2006 March 2008
Business Objects Developer
Responsibilities

• Involved in full project life cycle implementation (requirement gathering to production phase)
• Prepared the following business/technical writing of requirements, design templates, development standards document and detailed design documents.
• Analyzed existing database and Designed Universe by using BO Designer XI R2
• Analyzed data using Slice/Dice and Drill Mode
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts
• Combined Budget with actual data Spreadsheet from Oracle using Linking Feature
• Created and Published Reports through Web Intelligence, Info view portal
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Work on database connections, views, parsing of objects and hierarchies
• Design and develop standard reports and summary reports. Generate List of Values (LOV’s) from lookup tables. Create restrictions on objects and classes based on universes privileges
• Updated and maintained Universes based on changing user requirements and data source changes