SUMMARY:

• 8+ 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, Dashboard Designer 4.0, Central Management Console and Business Objects Administration).
• 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.
• 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, Oracle11g/10g/9i/8i, MS SQL 2005/2000/7/6.5, DB2, Teradata,IBMNetezza 5.x,MS Access.
• Knowledge of SAP Business Warehouse BW 3.x/BI 7.x, Business Explorer (BEx), SAP R/3 and ETL
• Successfully applied fix pack and Service Pack patches on the Enterprise servers.
• Installed, Troubleshoot, upgraded and maintained the various Business Objects.
• 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, 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, IBMNetezza 5.x,Sybase 12.x/11.x,SAP HANA.

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Business Objects Developer

Responsibilities:

• Managing of all BO universes and standard reports in BO XI 4.0 which is used by nationwide users.
• Testing and successfully delivering reports timely, including performance tuning of BO full client and WebI reports.
• Developing of WebI reports involving complex calculations, tables from multiple data sources.
• Providing profitability reporting to business unit/channel, customer, vendor, category, product, region, etc.
• Modifying existing universes, testing objects in the universe, to ensure the correct mapping of the objects.
• Testing the universe structure to ensure the tables are properly updated.
• Promoting the tested content form Development to IT, QA and Production using Life-Cycle Manager.
• Providing key performance, security, and architecture assessments, documentation, and guidance for management, vendor management, and code reviews.
• Providing technical advice for improvements of BO service.
• Proactively monitoring and reporting continuous report failures, badly scheduled reports, long running reports and worst performing reports.
• Coordinated with the end users during BAT (Pilot Users) and UAT and fixed any bugs raised.
• Was involved in the cut-over and go live activities.
• Efficient in writing SQL queries in Oracle, Toad, SQL Developer.

Environment: Business Objects XI 4.0, XCelcius 2008, Crystal Reports 2008, Business Objects Explorer, Oracle 10g/9i, SQL/PLSQL, Windows AD, IE9, Designer, Infoview,Launch Pad, Web Intelligence, Windows 2008 R2/ 2003,Windows XP, Windows 7, Toad for DB2 5.0, Toad for oracle 9.

Confidential, San Jose,CA

Sr. Business Objects Developer

Responsibilities:

• Was part of the entire SDLC of the project.
• Involved extensively in gathering requirements from the business users through multiple JAD sessions.
• Was involved in LDM sessions to provide insights based on requirements to drive the modelling based on user requirements.
• Performed data validation using Data Flux.
• Created multiple documents including FRD, TDS and Test cases for the Unit testing
• Developed a comprehensive universe to meet all the reporting requirements.
• Prepared Source-to-target mapping document used for creating universe objects.
• Used multiple techniques and functions within the universe development. Used basic joins, shortcut joins etc. Used aliases and contexts to resolve loops and traps.
• Applied multiple securities Confidential Universe level, including Object level security and row level restrictions.
• Created multiple canned reports for the end users based on the requirement. Trained users create some ad-hoc repots.
• Used report based filters and created reports with drill down capability.
• Created reports from multiple data providers and then used merged dimensions to create reports.
• Created reports with multiple queries, sub-queries and combined queries using Union/intersection and minus functions.
• Performed administration activities, including creating of groups, folders and adding users in CMC.
• Assigned user security through CMC and also data level security using @variable(‘BOUSER’) function.
• Reviewed the test cases created by the QA team and fixed all the bugs raised.
• Performed performance tuning on long running reports. Checked the query plans and flow to avoid any full table scans where not necessary.
• Coordinated with the end users during BAT (Pilot Users) and UAT and fixed any bugs raised.
• Was involved in the cut-over and go live activities.
• Having precise expertise in understanding the R/3 and ECC 6.0 System and considerable experience in SAP BW/BI, documenting, design and Analysis of reports Using BExAnalyser
• Worked Extensively on Data Warehouse Workbench and customized info objects, info cubes, DSOs, Data Sources, DTPs, Transformations and multiproviders
• Was involved in gathering visualization and data requirements for the dashboard tabs.
• Created a POC to provide an initial view to the business users.
• Created multiple tabs within the dashboard with multiple visualizations using direct query binding and QaaWs.
• Used multiple components including but not limited to charts, text boxes, image, scorecards, combo box, push buttons, toggle buttons etc.
• Integrated BOBJ 4.0 with SAP HANA1.0
• Created Universes on top ofHANA calculation viewsand developed the Webi reports and dashboards usingIDT(Information design tool).
• Extensively used dynamic visibility to change visualizations based on user selection
• Created Non-SSO and SSO links for the users to access the dashboard.

Environment: Business Objects XI 4.0/3.1, Info view(Launch Pad), Universe Designer(IDT), Crystal Reports, Publication Wizard, Import Wizard, Dashboard Manager,Xcelsius dashboards,SAP-BW 3.5, Teradata 13.0, Dashboards 4.0,SAP HANA1.00.69

Confidential, Atlanta, GA

Business Objects Developer

Responsibilities:

• Interacted with the End Users, Business Analysts and responsible for Involved in training sessions to impart knowledge on designed universes and published reports.
• Created reports using Crystal Reports and also using Business Objects functionalities like Queries, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Worked resolving the loops in universes using Aliases and Contexts.
• Upgraded Business Objects universes and reports from version XI 3.1 to 4.0.
• Involved in testing the reports while migrating from XI 3.1 to 4.0.
• CreatedWebIreports with multiple data providers and synchronized the data usingMerge Dimensions.
• Developed WebI Reports as per the business requirements.
• DevelopedWebI Reports(on demand,AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Cross-Tab).
• Worked on various Business Object Reporting functionalities such as Slice and Dice, Master/detail, User Response function and different Formulas.
• Installed, Troubleshoot, upgraded and maintained the various Business Objects.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Updating databases, systems and business intelligence tools.
• Created Dashboard using SAP Business ObjectsXcelcius Dashboard and MS Excel.
• Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.
• Responsible for writing the SQL queries for the data validation and testing the reports.
• Exported reports into various formats like PDF, HTML, EXCEL and WORD for end users.

Environment: Business Objects XI 4.0/3.1, Web Intelligence 2.x/6 and Info view, Universe Designer, Crystal Reports, Publication Wizard, Import Wizard,Xcelsius Dashboard, Dashboard Manager,SAP BW 3.5, IBM Netezza 5.x,Attensity 360,Lithum.

Confidential, FL

Business Objects Developer

Responsibilities

• Involved in interacting 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, Slice and Dice, Drill Down and @ Functions.
• 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 objectsXcelciusDashboards.
• 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 3.1, Web Intelligence 2.x/6 and Info view, Universe Designer, Crystal Reports, Publication Wizard, Import Wizard,Xcelsius Dashboard, Dashboard Manager, Data Mining, Unix shell script, Oracle 10g/9i.

Confidential - Myers Squibb, 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, Informatics 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, alerts 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 and 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

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.