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 XI 4.1/4.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 including SAP, Oracle 11g/10g/9i/8i, MS SQL 2008/2005/2000/7/6.5, DB2, Teradata, IBM Netezza 5.x, MS Access.
• Experience on HRM Systems for Payrolls and employ performance including Ceridian.
• Knowledge of SAP Business Warehouse BW 3.x/BI 7.x, Business Explorer (BEx), SAP R/3 and ETLProcess.
• 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.1/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 2008/2005/2000/7.0/6.0, Teradata V2R5/V2R4/V2R3, IBM Netezza 5.x,SAP HANA.

PROFESSIONAL EXPERIENCE

Confidential, Montvale, NJ

Sr. Business Objects Developer/Analyst

Responsibilities:

• Worked closely with end user for requirements gathering to develop the reports.
• Interacting with the business customers to design objects and user interfaces that facilitate ad-hoc reporting and extracts needed for business analytics.
• Documented all requirements, change requests, universe, user support documentation and report design.
• Upgraded Business Objects universes and reports from version XI 4.0 to 4.1.
• Involved in testing the reports while migrating from XI 4.0 to 4.1.
• Managing of pervious BO universes and standard reports in BO XI 4.1/4.0 which is used by nationwide users.
• Developed WebI reports for various hierarchy levels Confidential Market, ASM, Territory, retailer, retailer outlet using complex calculations, tables from multiple data sources.
• Developed a new Bex Queries as per the user requirement using query designer.
• Developed BO WebI reports using these Bex Queries according to the requirements.
• Delivering profitability analysis reports (COPA) to business unit, customer, Product, region, etc.
• Moving reports form Development to QA and Production using Life-Cycle Manager.
• Providing key performance, security and documentation, and guidance for management, vendor management, and color code reviews.
• Interacting with the end users during BAT and UAT and fixed any bugs raised by user.
• Involved in testing the reports while migrating from XI 4.0 SP6.
• Part of cut-over and go live activities.
• Provide technical advice for improvements of BO service.
• Worked and reported continuous on report failures, wrong scheduled reports, long running reports and bad performing reports.
• Involved in migration of reports from one environment to another.
• Bursting & scheduling of developed BO reports to the end users with the 3rd party tool Info Burst to distribute reports to Territory Rep’s, ASM and MGM.

Environment: Business Objects XI 4.1/4.0, Infinium, Informatica 9.1, SAP BW,SAP Integration Kit, Business Objects Explorer, Oracle 11g/10g,Bex Query Designer, SAP Hana SPS 9, SQL/PLSQL, IE9, Information Design Tool, Web Intelligence, Info Burst, Window 2008 R2/2003,Windows XP, Windows 7.

Confidential, CA

Sr. Business Objects Developer

Responsibilities:

• Involved in gathering the requirements from End users for implementing the data model.
• Developed universe on IDT BO XI 4.1/4.0 according to the requirements gathered and managing of pervious BO universes and standard reports in BO XI 4.1/4.0 which is used by nationwide users.
• Developing of Provider Detail, Claims, Case summary WebI reports involving complex calculations, tables from multiple data sources.
• Providing profitability reporting to business unit/channel, customer, vendor, category, product, region, etc.
• Interacting with the business customers to design objects and user interfaces that facilitate ad-hoc reporting and extracts needed for business analytics.
• Testing and successfully delivering reports timely, including performance tuning of BO full client and WebI reports.
• 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.
• Coordinated with the end users during BAT (Pilot Users) and UAT and fixed any bugs raised.
• Documented all changes to system.
• Designed user support documentation.
• Was involved in go live activities.
• Proactively monitoring and reporting continuous report failures, badly scheduled reports, long running reports and worst performing reports.
• Involved in migration of reports from Dev environment to Production.
• Extensively involved in release management using CCRC clear quest.
• Maintaining documentation on universe and report design.
• Efficient in writing SQL queries in Oracle, Toad, SQL Developer.

Environment: Business Objects XI 4.1/4.0,Crystal reports 2011, XCelcius 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

Role: 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
• Coordinated with users for information exchange.
• 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,Informatica Power Center 9.5, Xcelsius dashboards, SQL Server 2008, MS Excel 2003/2007, SAP-BW 3.5, Teradata 13.0, Dashboards 4.0,SAP HANA

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.
• Developed WebI 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 Objects Xcelcius 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, 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.
• Created reports on employ performance, payroll, labor efficiency using HRM system.
• Created reports showing employ sales performance using HRM system for management.
• 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, SQL server 2005, MS Excel 2003/2007,Ceridian, 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.