SUMMARY

• Having 7+ years of Professional Experience in Data Warehousing as Business Intelligence Reporter using tools like Business Objects XI R2, 6.x, 5.x and Experience in ETL Development.
• Strong understanding of Data warehousing Concepts.
• Well - seasoned Business Objects (XI R2, 6.x) Consultant with experience in Designer, Info view, Web Intelligence and Desktop Intelligence, Crystal Xcelsius, Dashboard manager.
• Experience in the Designing, Development, and Implementation of Business applications with Client/Server environment using Business objects on Windows platforms.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports. Documented the SDLC process definitions.
• Designed, Optimized, Deployed Universe using Designer.
• Created complex and sophisticated Business Objects Reports.
• Synchronized queries from multiple data providers, Drill-up and Drill-down slice and dice features using Business Objects.
• Sound Background in ORACLE and MS SQL-SERVER.
• Broad proficiency on working with universes, multiple data providers, free hand SQL.
• Good exposure to development, implementation, documentation, Testing and production support.
• Provides knowledge transfer to other team members.
• Excellent communication and interpersonal skills.
• Sound Knowledge in training End Users for Adhoc Reports.
• Dedicated and a very good team player with the ability to work independently.

TECHNICAL SKILLS

OLAP/Reporting Tools: Business Objects (XI release 2 & 6.5.1, 5.0/5.1.x) Reporter, Designer, Supervisor, Broadcast Agent Publisher, Web Intelligence (2.5/2.6.x), Info View, Query as web service, Crystal Reports (6/7/9/XI), Crystal Xcelsius, Performance Manager(Dashboard Manager) .

Programming Languages: SQL, PL/SQL, C++, C

Open Source/Application Server Technologies: IIS, Tomcat, HTML and XML

RDBMS: Oracle 10g/9i/8i, SQL Server 2005/2000 and MySQL

Operating Systems: Windows 2003/XP/2000/NT/98, UNIX

Hardware Environment: All IBM compatibles

PROFESSIONAL EXPERIENCE

Confidential, Towson, MD

Business Objects Developer

Responsibilities:

• Guided project at the inception phase like gathering and documenting requirements.
• Assisted in Designing and developing complex Universes
• Assist in defining the scope of a project, or phase of a project, utilizing qualitative criteria, technical and business specifications
• Provide creative source of ideas/solutions to address problems to enhance individual, team and client knowledge of Business Intelligence projects
• Defined various Contexts and aliases in Universe
• Implemented various Schema Modeling techniques like star and snowflake schemas
• Optimized different types of queries in enhancing the performance of the universe
• Created various Object hierarchies to allow users to perform multidimensional analysis
• Resolved loops, Chasm/Fan Traps problems by implementing the concepts of Alias and Contexts.
• Detected join problems graphically
• Used various functions like @Aggregate aware, @prompt, @select in designing the universe
• Organized data in the reports by using Filters, Sorting, Ranking, Breaking and highlighted data with Alerts.
• Done enhancements to the existing reports like linking the reports.
• Created Business Views.
• Developed several Complex Reports various features include Drilldowns, parameter fields, Running Totals and conditional formatting using Crystal Reports.
• Added the data table to chart using Xcelsius.
• Formatted crystal Xcelsius charts, linking a map chart for Interactivity.
• Setting the Dials to respod to clockwise mouse movements.
• Created waterfall chart in Crystal Xcelsius.
• Involved in documentation, Testing, Training users and production support.

Environment: Business Objects XI Release 2,, Web Intelligence XIR2,Crystal Reports, Crystal Xcelsius, Oracle 10g/9i, MS Access, MS SQL Server.

Confidential, Clear Water, Fl.

Business Objects Developer

Responsibilities:

• Created and managed Universe in the Designer.
• Testing Universe as per the Business report requirements.
• Created user interactive objects using @prompt functions in Designer.
• Implementing the Data base changes in the Universe like adding new columns, renaming the existing columns, changing the owner of existing tables in the data base.
• Converting the Desktop Intelligence documents to Web Intelligence documents by using the Report Conversion Tool.
• Involved in various discussions with end user to get more insight on the Business requirements.
• Developed Reports using various functionalities in Desktop Intelligence like slice and dice, Drill capabilities, Master & Detail, and Cross Tab tables, Breaks and Variables and Scope of analysis.
• Creation of documents both (full client and WebI), summary and detail with the functionality of drill down to detailed document.
• Created Alerter using Business objects to highlight columns based on the requirements of a client for KPI’s.
• Testing reports before posting them to the repository (query performance). Most of the reports involved using multiple data providers, Free hand SQL, Pie charts, Alerter’s, Formula and formatting using slice and dice panel.
• Linked table selector to chart for interactivity using Crystal Xcelsius.
• Making a map component default to a specifies state in Xcelsius.
• Exported Dashboard to an existing powerpoint presentation in Xcelsius.
• Created tab effects in existing Dashboards using Xcelsius.
• Worked with more than two series to a combination chart using Xcelsius.
• Created Key Business Metrics using Dashboard Manager and Performance Manager.
• Demonstrated product functionality and train clients on how to use the application going forward.

Environment: Business Object XIR2, WebIntelligence, Crystal Xcelsius, Performance Management XIR2(Dashboard Manager), Oracle 9i, SQL-Server.

Confidential, Irving, TX

Business Objects Developer

Responsibilities:

• Interacted with business representatives for Need Analysis and to define Business and Functional Specifications, gathering user requirements and documenting them.
• Created User defined Classes, Objects, Dimensions and Measures while creating Universes.
• Created Universes to be more User Interactive by defining @prompt functions and conditions with certain objects.
• Implementing security for users, groups and categories using Supervisor.
• Identified measure objects for the Key Performance Indicators and Dimension objects for the slices.
• Applied slice-and-dice and drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data
• Defined several custom hierarchies so that the user can use various analysis functionalities during reporting easily and efficiently.
• Resolved loops, Chasm/Fan Traps problems by implementing the concepts of Alias and Contexts.
• Submitted and presented the reports in user-defined formats like Tabular, Master Detail, and Cross Tab.

Environment: Business Objects 6.5, Designer, Supervisor, Broadcast Agent, Oracle, Windows NT

Confidential, Dallas, TX

Business objects Analyst / Developer

Responsibilities:

• Interacted with Business Users to know their Business views in developing and modifying Universes and Reports accordingly
• Involved in gathering, analyzing, and documenting business requirements and data specifications for Business Objects Universes and Reports.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked for the Integrity of the Universes.
• Provided support in resolving Fan Traps and Chasm Traps.
• Linked different Universes using Kernel Master and Component approaches.
• Used multiple data providers in the reporter module in generating reports.
• Extensively created and used alerter, rankings, sorts, and drill-down (using custom hierarchies) in reports
• Used Aggregate Awareness in universe to optimize query performance
• Exported the universes to the Repository to making resources available to the users.
• Assisted in creating aggregate BCA server and scheduled for daily refreshing
• Awarded as the most valued tables in-order to use in the Universes.
• Tested classes and objects to organize the universe.
• Linked universes in designers and Linked data sources in creating the reports
• Reports were published to a team player of the month
• Used CRM Applications for Improved Customer relations to keep track of individual preferences by maintaining one to one records.

Environment: Business Objects 6.5, Web Intelligence, Oracle 9i, Windows 2003/2000 Server.

Confidential, NY

Business Objects Consultant

Responsibilities:

• Prepared software requirement specifications, business rules interacting with business units and designed Star schema, logical and physical database design for Domains.
• Performed data warehouse modeling (Logical and physical data modeling based on star & snowflake schema).
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements.
• Development and Production Support with error handling and validation of mappings
• Deploying Business Objects Applications to the user community.
• Recommended and implemented design changes to warehouse fact tables and indexes to improve query performance.
• Security, server configuration, administration and maintenance of all Business Intelligence applications and tools.
• Created and designed Business Objects universes like General Ledger, Inventory, and Sales.
• Created Multi Dimensional analysis using Slice/Dice and Drill methods to organize the data along a combination of "Dimension" and "Hierarchies" giving the ability to the end-users to observe data from various viewpoints.
• Included data from different sources like Oracle Stored Procedures and Personal data files in the same report.
• Created Reports using Web Intelligence (thin client) and full client.
• Demonstrated product functionality and train clients on how to use the application going forward.

Environment: Business Objects 5.1.2, Web Intelligence 2.7, Info View, Broadcast Agent 2.7, Webi, Informatica 5.1/6.x, Crystal Enterprise 8.0/8.5, Sun Solaris 8.0, Windows NT, Oracle 9i, Excel 2000.

Confidential

Business Objects Consultant

Responsibilities:

• Met with the client to learn their Business.
• Assisted the business analyst in gathering the specification.
• Linked different Universes using Kernel Master and Component approaches.
• Created sophisticated Drill Reports and Slice and Dice reports
• Designed and developed tables in MS-Access Database
• Involved in the creation of different types of reports such as master, detail, cross tab, charts and tabular using universe as a main data provider.
• Worked on Slice-Dice mode for analyzing the Report Data.
• Created variables and formulas to populate cells and used text Alerter to highlight trends and exceptions based on conditions.
• Created monthly Reports for managers using business objects.

Environment: Business Objects 5.1, Oracle8, SQL Tools - Toad.

Confidential

ETL Developer

Responsibilities:

• Analyze the current data movement (ETL) process and procedures. Identify and assess external data sources as well as internal and external data interfaces. Responsible for design and development of ETL strategy, a scalable architecture from Source to the Data Mart.
• Extracted data from multiple sources like DB2, SQL server, Flat Files and Oracle.
• Cleansing strategy was designed and implemented before loading data into the Transient Area.
• Imported various Sources from existing systems such as Oracle and flat files and designed the ETL process utilizing the business rules, defining targets and determining the data load order for Fact and Dimension tables.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations, reusable transformations using Informatica Designer for conversion process from various sources to oracle staging area and from Staging area to the target tables.
• Developed mappings to track current and historical records simultaneously using Lookup, Update Strategy transformation and Router Transformation.

Environment: Informatica PowerCenter6.0, Oracle 8i, SQL Server, DB2,Unix,TOAD.