SUMMARY:

• 7+ years of experience in Business Intelligence/Business Objects (BI/BO) enterprise solutions that include Business Objects architecture, software deployment, infrastructure maintenance, business objects and system administration, BOE Security, Universe/Report/Dashboard development, documentation, Production Support and user training.
• Experience working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
• Expertise in Business Objects XI4.0/3.1/3.0/XI R2/6.x/5.x( Desktop Intelligence, Web Intelligence, Universe Designer, Crystal Reports, Xcelsius, Central Management Console and Business Objects Administration, Live Office and QaaWS).
• Experience in full life cycle gathering requirements, documentation, developing, designing, implementing, testing and deploying BI Solutions.
• Extensive Experience in migration of Business Objects Universes and reports to newer versions.
• Extensive database architecture and design skills of working on high performance solutions in large corporate environments.
• Experience in Xcelsius to create dashboards using Live Office and QaaWS.
• Adept Designing/Developing the Business Objects Universes, Ad - hoc/ Canned Reports, Complex Reports using predefined conditions.
• Experience in creating reports and accessing queries using Business Objects Query Builder, Web application designer.
• Hands on experience in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, Physical and Logical data modeling.
• Proficient with various RDBMS technologies includingSAP ECC,Oracle 11g/10g/9i/8i, MS SQL 2005/2000/7/6.5 , DB2, Teradataand MS Access.
• Knowledge of SAP Business Warehouse BW 3.x/BI 7.x, Business Explorer (BEx), SAP R/3 and ETL process.
• Successfully applied fix pack and Service Pack patches on the Enterprise servers.
• Provided 24X7 support to the users.
• Involved in review meetings with Project Managers, Developers and Business Associates during Project Planning, Coordination and implementing various QA methodologies.
• Working knowledge on Migration tools like Import Wizard, Publishing Wizard, Report Conversion tool.
• Solid Experience in writing Transact SQL, SQL Sybase, stored procedures, functions, packages, data base triggers, exception handlers, Cursors.
• Worked as a team player with proven problem solving skills as well as independently with excellent communication and Interpersonal skills.

TECHNICAL SKILLS:

Business Intelligence: Business Objects XI 4.0/3.1/XI R2/6.5 (Supervisor, Designer, Info view, Business Objects SDK, Xcelsius, Voyager, QaaWS, Web-I SDK, Broadcast Agent, Publisher, Designer, Supervisor, Auditor, Application Foundation Dashboard Manager, Report Writer, BO Set Analyzer, Application Foundation 6.0/2.5 & Dashboard Manager), Crystal Reports XIR2/2008, Life Cycle Manager, SAP Integration Kit, SAP Portal.

Business Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design.

Databases: Oracle 11g/10g/9i, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/2000/7.0/6.0 , Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x.

PROFESSIONAL EXPERIENCE

Confidential Orlando FL

SAP Business Objects Developer

Responsibilities:

• Interacted with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Was responsible to see the scalability and security provided in distributing important reports to higher managerial level.
• Analyze operational performance and make configuration adjustments as necessary.
• Resolved loops, Chasm and Fan Traps using Contexts and aliases in Universe Designer.
• Created Ad-hoc reports using BO functionalities like Master Detail, Formulas, Alerts, Sliceand Dice, Drill Down and @ Functions.
• Upgraded Business Objects universes and reports from version Xi 3.1 to 4.0.
• Updated the Universe as per the changes of the Database table structure and notified the users about changes made to the Universe.
• Responsible to support the issues with reports on the BO environments (Development, UAT, Test and Production).
• Develop and implement test scripts for evaluating service packs and future releases
• Created Dashboards using SAP Business objects Dashboards 4.0(Xcelsius).
• Evaluate and design web services access points for data access in multiple and dynamic user interfaces.
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects XI connected to Oracle data source.
• Set up groups and users for Business Objects deployment in CMC.
• Developed WebI Reports as per the business requirements
• Developed Report Mock-up samples before User interaction to analyze the business requirements.
• When the source tables are very huge, developed PL/SQL procedures using Oracle to load the data into fact tables and used them in the universe.

Environment: Business Objects XI 4.0/3.1, Web Intelligence 2.x/6 and Info view,Universe Designer, Crystal Reports, Publication Wizard, Import Wizard, Dashboard Manager,Unix shell script, Oracle 10g/9i.

Confidential NJ

Business Objects Developer

Responsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Worked with End-To-End implementation with Data warehousing team and Implemented Star- Schema, Snow-Flake Schema.
• Linked two universes Sales and Patients using kernel approach.
• Created multiple universes and resolved Loops by creating table aliases and contexts to remove cyclic dependencies.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment to accurately assess the effort Vs the results of clinical activities
• Created reports on development data to test the functionality of universes with a group of power users.
• Created graphs/charts for the reports, created Master Detail and Cross Tab Reports to provide a transformational approach to the way staff members and clinicians access and report on data.
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Scheduled reports to business users and owners using Broadcast Agent.
• Created Dashboards using Crystal X-Celsius for senior management for business decision making.
• Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
• Created Users, User groups and assigned privileges to access and work with Universes and Reports.
• Worked on Crystal Reports reporting system including Crystal Server reports distribution infrastructure.

Environment: Business Objects XI 3.1, Designer, Web Intelligence and Info View, Windows XP, server 2003, Oracle 10g, Informatica Power Builder 8.6, Erwin Tool

Confidential, Westwood MA

BO Universe/Report Developer

Responsibilities:

• Developed Complex, Logical and Physical Data Models, using Erwin Tool.
• Designed/Modified the Universes as per the requirements adding new classes and objects as required.
• Used derived tables to create the universe for best performance, and use context and alias tables to solve the loops and traps in the Universe.
• Migrated & upgraded Business Objects from 6.5.1 to XIR2.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom sorts, Cross Tab, Master Detail and Formulae's etc.
• Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL.
• Worked on complex Crystal Reports that require running totals, sub-totals, sub-reports, prompts, cross-tab, multiple groups, hierarchical grouping and conditional display of groups, fields, and messages.
• Written free hand SQL queries using Oracle database and defined full client reports and webI.
• Created reports on web using Info View Portal and published the reports into info view for different groups and users.
• Extensively used calculations, variables, drill down, slice and dice, alerters in the creation of reports.
• Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.
• Expertise in writing and implementation of the packages, triggers, functions, views, materialized views and indexes using SQL.
• Prepared ad hoc supporting documentation for senior financial management.
• Exported reports into various formats like PDF, HTML, EXCEL, WORD for end users.

Environment: Business Objects XIR2/6.5/6.1,Data Integrator, Dashboard Manager, Xcelsius, Web I 6.1, DESKI, JSP, SQL, PL/SQL, Erwin, SQL*Loader, UNIX Shell Script, Windows 2000/NT, ORACLE, PL/SQL, SQL Enterprise Manager.

Confidential IL

BO Universe/Report Developer

Responsibilities:

• Interacted with Business Users to gather, analyze and record requirements/ specifications.
• Designed and Created Universes.
• Designed universes using @ functions like @ aggregate aware, @ prompt, @select and @where.
• Created Classes, Sub Classes, Dimension Objects, Measure objects in multiple universes, checked the Integrity of the Universes and exported the Universes to Repository to make them available to users
• Detected Loops and Traps and resolved them using aliases & contexts.
• Created reports using functionalities like Slice and Dice, Drill Down, Drill Up and Ranking that were used in reports.
• Managed users and groups and data security mechanism with multiple repositories/domains.
• Created different types of reports like Cross Tab, Charts, and Master Detail using multiple data sources.
• Involved in writing Free Hand SQL for creating complex Reports.
• Used Broadcast Agent Publisher, which enabled us to distribute information via email using an easy-to-use, subscription-based mechanism.
• Generated Ad-Hoc reports using Business Objects and hands on modified the existing reports as per the end user requirement.
• Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.

Environment: Business Objects XI 3.1, Web Intelligence 2.x/6 and Info view, Universe Designer, Crystal Reports, Publication Wizard, Import Wizard, Dashboard Manager,Unix shell script, Oracle 10g/9i.

Confidential

ETL/Report Developer

Responsibilities:

• Used Informatica Power Center for extraction, transformation and loading (ETL) of data in to data warehouse.
• Implemented logical and physical data modeling with STAR and SNOWFLAKE techniques in Data warehouse as well as in Data Marts.
• Worked on different data sources such as Oracle, SQL Server, XML, MS Access.
• Developed Complex WebI reports with data across different tabs for the daily, MTD, STD, YTD sales.
• Designed reports by using different functionalities like drill down, using calculations with variables, comparing with previous year data to get change % etc.
• Exported Reports to Excel based on User requirements.
• Worked with a Team to develop a complex universe and generated reports exclusively using Full client.
• Developed user friendly Universes using Business Objects Designer for various business needs.
• Created the reports using Universes as the main data provider.
• Worked on resolving some of the WebI issues which users had faced
• Created and modified Universe by using @functions, Short-cut joins, Hierarchies and wrote custom SQL in derived tables.
• Used Informatica Designer tools to design warehouse using source definition, target definition and transformations.
• Worked on adhoc reports according to user requirements like Deals, Tactical Initiatives, Strategic Initiatives using thin client.
• Documented all the changes made to the Universes and Reports for future references.

Environment: Business Objects 5.1.2, Informatica 5.1/6.x, Broadcast Agent Server (BCA), Oracle 8i & Windows 2000.