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 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, Oracle11g/10g/9i/8i, MS SQL 2005/2000/7/6.5 , DB2, Teradata,IBM Netezza 5.x,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.
• Installed, Troubleshoot, upgraded and maintained the various Business Objects.
• Provided 24X7 supports 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, and 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 XI4.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 2005/2000/7.0/6.0 , Teradata V2R5/V2R4/V2R3, IBMNetezza 5.x, Sybase 12.x/11.x,SAP HANA.

PROFESSIONAL EXPERIENCE

Confidential, CHICAGO, IL

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 according to the requirements gathered and managing of pervious BO universes and standard reports in BO XI 4.1 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.
• 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.
• Was involved in the cut-over and go live activities.
• Provide technical advice for improvements of BO service.
• 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.
• Efficient in writing SQL queries in Oracle, Toad, and SQL Developer.

Environment: Business Objects XI 4.1,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

Sr. Business Objects Developer

Responsibilities:

• I 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 reports.
• 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

Confidential

Responsibilities:

• 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, and 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.
• 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.
• 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, Windows 2000.

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, and 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.