SUMMARY:

• Over 15 years of IT experience in Analysis, Technical Design, Development, Testing and
• Documentation including 13 years in BO, BOBJ, Dashboards/ Xcelsius, BI/BW, Crystal Reports.
• Expert at managing multiple projects simultaneously and handling multiple issues.
• Experience in Finance, Banking & Insurance, Healthcare, Pharmacy, Manufacturing, Energy domains.
• Expertise in Business Objects BI 4.2/XI3/XIR2/6.x - Administration, Designing and Development.
• Experience in Installation, Administration and Upgrading versions of Business Objects desktop and Server products.
• Very Good in developing Business Objects XI V3.1 OLAP Universes over several data sources from SAP BW, Oracle and SQL Server and Maintaining the Universes
• Expertise in Connections creation, Universe designing, linking, developing and generating complex Ad-hoc, Webi/Deski/Dashboard reports, business views, LOV's along with user acceptance test and data accuracy test.
• Very good experience of SAP BW Components like InfoCubes, MultiCubes, InfoSource, InfoObjects, ODS Objects, Update Rules and Transfer Rules.
• Undergone complete life cycle implementation of BW, which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring, LO Cockpit, CO-PA and BEx Query.
• Good understanding of Data Modeling including ER, Star and Snow Flake data models
• Expertise in requirements gathering, analyzing and documenting business requirements, functional requirements, translation of requirements into technical specifications
• Strong experience in Upgrading/Migrating Business Objects components using upgrade management tool from XIR2 to XI3.1, XI3.1 to BO 4.2
• Extensively worked on Designing, Developing the Universes and resolving the issues like loops and Traps using Alias and Context, designing complex objects using @prompt, @ Aggregate aware function and cascading LOV's.
• Extensively worked on End-user support, Production support experience
• Experience in Report Generation in BEX Analyzer in building Queries and saving in Workbooks (Excel work sheets) and created Custom Queries using Conditions, Exceptions, Variables & Structures and created Aggregates for frequently used Queries.
• Experience in creating POC on SAP Business Objects Mobile 4.2
• Experience with Oracle, MS SQL Server, DB2, Sybase and Teradata Expert in relational databases
• Experience in Dashboards using Xcelsius with an emphasis on live data services such as XML, Live Office and Query as a Web Service (QaaWS)
• Expertise in Support, resolving on-going maintenance issues, bug fixes, performance tuning of Reports, Troubleshooting issues and developing end user Notes.
• Experience in developing Mappings and Workflows with Worklets & Tasks using using various Transformations for ETL of data from Multiple Sources to Data Warehouse Data
• Services.
• Working experience in using Bex, SAP BW Queries, SQL Server, Oracle, SQL,
• PL/SQL, TOAD
• Highly motivated, committed and a natural team player with capability to work independently, with proven ability to adopt and react quickly in a high pressure, fast-paced environment. Ability to communicate technical ideas clearly and concisely.
• Unit, integration, performance testing and Participated in design reviews

TECHNICAL SKILLS:

BI: Business Objects XI Release 4.2/3.1/ 2 /6.x/5.x/4.x (Supervisor, Designer, Business Objects, Web Intelligence Release 4.0/3/ 2/6.x/2.x, Broadcast Agent Server, Infoview), Dash Board, Crystal Reports 2008, XI, 9.x/7.x/6.x., Xcelsius 2008, Live Office, BW, HyperionOLAP Tools OBIEE, Oracle Discoverer, Cognos, Jasper Reports and Micro strategy

ETL: INFORMATICA 7.1/ 6.x/ 5.x, Data Integrator, Data Federator

DWH Appliances Netezza TwinFin: and Exadata.

RDBMS: DB2 UDB, Sybase, Oracle 10g/9i/8i, MS SQL Server 2000/2005 and

Oracle Tools: SQL*LOADER, SQL*PLUS, TOAD, Oracle Workflow Teradata v2r5/v2r4

OS: UNIX, Windows NT/2000/2003, Window 9X

Tools: ERwin 4.1/4.0, MS Project, TOAD 6.5, SQL Navigator 4.1, Sybase, Siemens SIMATIC

PROFESSIONAL EXPERIENCE:

Confidential - Foster City, Ca

Sr. BOBJ Admin/Dev

• Build the new universes as per the user requirements on top of BEx queries by defining the universe connections.
• Created complex Web Intelligence reports by linking objects from different data providers and using Merge Dimension Option
• Created audit reports using Activity universe to keep track of users usage on reports BO Components to analyze the peak usage hours and critical dashboards.
• Involved in support and enhancements of the existing dashboards and reports.
• Migrated Reports, Universes and Users from Business Objects Xi3.1 to BI 4.0.
• Migration of content from the 3.1 system to bi4.0 using the Upgrade management tool.
• Involved in designing Universe and migrating existing .UNV to .UNV and .UNX.
• Tested the BI4.0 migration to ensure the reports are functioning as per expectations.
• Migrated Webi reports from BO 3.1 to BI4.0 for different environments like DEV, QA and PROD using life cycle manager.
• Installed XI3, BI 4.0 and updated patches and upgrades
• Created of user and user roles, and scheduling jobs and bursts
• Working on BOBJ Administration, security groups, users creation and trouble shootings
• Resolved connection issues which are created problem to access of Webi reports
• Worked through a root/cause analysis and following up on action items
• Migrated Universes, Reports, Dashboards from XI3 to BI 4.0
• Extensively worked as a BOBJ Admin by integrating with BW environment
• Troubleshooting production issues which related to Webi, Deski, Dashboards, Crystal Reports
• Scheduled & monitored reporting jobs and distributed the reports
• Did rerun failed jobs and identified the root cause for jobs failInvolved in working with BI Mobile to Access reports, metrics, and data from your mobile device.
• Use of Analyzer and
• Regularly synchronized the QA, DEV environments with Production reports
• Hosted Weekly status meetings to update and explain the work expected from them in coming week as well as get status on work completed to Webi.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Resolved loops by creating Aliases & Contexts and checked integrity in universe.
• Optimized the usage of user objects, conditions and universe level filters.
• Identified issues with some of the reports with ambiguous data and resolved the issues.
• Gathered the Users Information and Security levels in BO 3.1 to implement the new Security in BI4.0.
• Performed data validation by writing SQL queries and creating ad hoc reports using desktop intelligence and web intelligence.
• Resolved major issues affecting the reporting environment.
• Expertise in designing Universe(s) from scratch with multi source connection using Information design tool in BI4.0.
• Resolved user login issues with LDAP, SAP authentication
• Resolved various server issues and performance issues
• Managing promotions of reports through the development, test and production processesMigrated web services (QaaWS) from 3.1 to BI4.0.
• Customized the BI Lanch Pad page with Company Logo, User required information and redeployed the WAR files.
• Publishing the reports and maintenance of daily, monthly and yearly
• Installed Power Path on Linux servers
• Interact with users from Application teams and fill their needs (Install, Upgrade and Troubleshoot

Environment: BODI , SAP Business Objects XI 4.0/3.1,Designer, Explorer, Mobile 4.0,Web Intelligence Rich client/XI 4.0, BI Launch pad (InfoView), Xcelsius 2008, Oracle 10g, LINUX

Confidential - Smithfield, RI

Sr. BOBJ Admin/BI/Dashboard Consultant

• Involved in creating Universes with the Dimensions and Measures for standard reporting, ad hoc query, general business users and advanced business users.
• Migrated the Universes, reports, Users, groups from environment to environment using Promotion Management tool and management, including version control between multiple environments
• Created users/groups and set privileges using Central Management Console and security implemented.
• Worked on-call rotation and support administration including ticket reporting, queue analysis, and triage
• Confers with persons originating, handling, processing, or receiving reports to identify problems and to gather suggestions for improvements.
• Prepare reports and analyze existing portfolios for trends and performance
• Analyze data and reporting solutions to understand business impact, correlations/ discrepancies and to propose changes/alternate solutions
• Extensively worked on performance tuning and maintain system stability
• Created Folders, User roles, Security and Privileges.
• Converted Deski reports to Webi reports.
• Interacted with Business Users, Business Owners to know their Business views in developing and modifying Universes and reports development.
• With advanced SQL query programming, developing and migrating reports from Business Objects
• Troubleshooting production issues which related to Webi, Deski, Dashboards, Crystal Reports.
• Migrated Universes, Webi, Deski, Dashboard reports from QA to Prod
• Resolved user login issues with LDAP, SAP authentication
• Resolved various server issues and performance issues
• Created Bursts, Schedulers in Infoburst and created Cmd files to run the jobs
• Migrated Universes, Reports, Dashboards from XI3 to BI 4.2
• Extensively worked on Universe creation and inserted new tables, created joins created more than 1000 objects, created universe level filters.
• Created new Universe connections, Universes and inserted new tables, joins, classes and objects
• Created a wide variety of advanced reports of varying complexity including slice and dice, drill down
• Worked on Dashboard/Xelsius 2008 by using QAAS and Live Office connections
• Extensively worked on production support, go-live activities and coordinate guide the offshore team Involved in Unit, Integration Testing Involved in Unit, integration, performance testing, test cases preparation.

Environment: Business Objects BI 4.2/ XI3 (CMC, Universe Designer, IDT, Web IntelligenceDashboard / Xcelsius 2008, LCM), SAP BI 7.0, BEx Analyzer, SAP ECC 6.0, NetWeaver,, HANA, Oracle 10g, SQL, PL/SQL, SQL Server management, Cognos, Microstrategy, SQL query analyzer, TOAD

Confidential - Waltham, MA

BOBJ Admin/Developer

• Interacted with Business Analysts, Business Users and Managers for Gathering, Analyzing, Documenting Business Requirements, Functional Requirements and Data Specifications for Business Objects Universes and Reports.
• Defined BO Classes and objects in the Universe.
• Installed & Configured Business Objects Suite of Products XI 3.1/R2 on Windows Server.
• Setup, Execute, and test the assigned programs utilizing BO XI3.1 WebI and DeskI tools.
• Configure Email in Job server for Email notification.
• Using Data Integrator creation of project, batch jobs, work flows, data flows.
• Creating initial and delta loads.
• Designed, Developed and Maintained Universes for supporting Ad-hoc and canned reports.
• Created the Webi reports based on existing source system using Cognos.
• Involved in Migrating of the content store from Cognos 8.4 to Business Objects.
• Check the Job Server Trace, Job Server Monitoring and Job Server Error.
• Defined Cardinalities, Joins, Contexts and Aliases for resolving Loops, Traps and checked the Integrity of the Universe
• Handled Embedded Functions like @Prompt, @Select, @Where, and @Aggregate awareness in the designer to handle User requests for report generators.
• Defined custom hierarchies for implementing drill down, drill up capabilities In Business Objects.
• Created Custom and Cascading List of Values (LOVs) for better understanding of prompts by the end users.
• Applied Row level, Object level security in the universe to make the sensitive data secure.
• Analyzed all tables, created various indexes and set up Aggregate Awareness to enhance query performance.
• Created various reports like the Drill Down, Cross Tab, Master Detail, and Charts to make the reports easier for analysis.
• Designed Full client & Webi reports and published to corporate documents to be viewed in Infoview.
• Created complex Webi reports by linking objects from different data providers and using Merge Dimension Option.
• Involved in documentation of universe and added description to various objects based on users recommendations
• Implemented all the key functionalities in reports such as Drill down, Filters, Variables.
• Designed and developed various Metrics, Analytics like speedometer, Interactive Charts, Alerters and Goals for creating Dashboards using Dashboard Manager.
• Experience working with Crystal Xcelsius to display summary-level business data in a rich and intuitive format.
• Involved in using Xcelsius to transform Microsoft Excel spreadsheet data into interactive flash media files for the upper level management.
• Created Dashboards using data in Live Office Excel Spreadsheet.
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius.
• Prepared user documentation for hands on training for end user community
• Given Advanced BO learning sessions to the end users.
• Created users and groups using Central Management Console (CMC) and assigned privileges to different groups and users
• Created Query template for UAT for business users.
• Defined and handled production support strategy for the reporting issues
• Used Oracle RAC (Real Application Cluster) to create multinode for oracle databases
• Worked mainly on RHEL 4/5/6 servers supporting all the OS administration, application and hardware issues.
• Building Linux servers by using VMware ESXi 4.1

Environment: BODI, SAP Business Objects XI 4.0/3.1,Designer, Reporter, Web Intelligence Rich client/XI 4.0, InfoView, Xcelsius 2008, DB2 UDB 9.1, Oracle 10g, Windows 2008 and LINUX

Confidential - Cary, NC

BO Administrator/ Xcelsius Developer

• Migrated Reports, Universes, Users from Business Objects XiR2 to Xi3.1.
• Troubleshooting BO XI Installation and Migration Issues.
• Involved in day to day maintenance of Business Objects Servers (such as Back up the BO XI repository).
• Applied patches for Business Objects XI for registered bugs.
• Extensively used Business Objects Designer to design and maintain Data warehouse Universes.
• Exporting universes to the repositories to make resources available to the users.
• Used Business Objects Data Integrator XI R2 for ETL extraction, transformation and loading data from heterogeneous source systems.
• Created custom queries for complex reports as per business needs.
• Exported the reports to info view to publish it to the end user and schedule report according to the end user requirements.
• Migrated reports from Cognos 8.2, using universe and webi reports
• Organized data in the Report by Inserting Filters, Sorting, Ranking, Break, Section and highlighting data.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Worked on Crystal reports XI for advanced functionalities (Stored Procedure, Alerts within a graph and superimposing one graph over the other, multiple y-Axis) for custom reports.
• Created Sub Reports, prompt, groups in a report and created parameters, custom functions and expressions in Crystal Reports.
• Created hyperlinks to connect multiple reports. And exported reports to info view.
• Used LIVE OFFICE to interact with reports for Presentation and design.
• Expertise in transforming Microsoft Excel files to interactive dashboard files using Xcelsius. Used QAAWS to interact with Xcelsius.
• Developed complex high visibility Xcelsius dashboards to monitor standard KPI metrics.
• Involved in Installation and configuration of BOE 3.1.
• Involved in migrating and testing documents from BO XI R2 to BO 3.1 and moved objects between different domains using Import Wizard.
• Converted existing reports in Desktop Intelligence to Web Intelligence reports using Report conversion tool.
• Worked with CMC in Creating Groups, users, folders and categories and customized access levels to apply security accordingly for proper usage of the reporting system.
• Involved 24X7 production support
• Worked with the SAN group on new shared storage to configure new storage on servers
• Created/resized volumes as needed using VXVM
• LVM file systems management.
• Installed and configured EMC PowerPath
• Performed Daily system Monitoring/user administration

Environment: Business Objects XI R2/3.1, Data Federator XI 3.1, Crystal Reports 2008, Web Intelligence R2/3.1, Xcelsius 2008, Live Office, .NET, DB2, Sybase, MS SQL Server 2000/2005 and Windows 2000/2003 Server

Confidential - Mansfield, MA

BO Administrator/Dev

• Created BIAR (Business Objects Business Intelligence Archive Resource) files to allow rapid import and export of enterprise content between development and run-time environments (Test and Productions Servers).
• Developed Complex Security set up for end users with CMC.
• Defined categories of documents for different level of groups.
• Implemented object level security in the Universe using the Designer.
• User query as web server to communicate with BO universe
• Configure the Live office component extract data from Crystal Reports
• Creating and maintain live dashboards & Office in Xcelsius Consumer products
• Created universes and reports for Medical Device, Pharmaceutical, Consumer healthcare products
• Created folders, User groups and provided Security settings and managing access privileges to users.
• Created the Webi reports based on existing source system using Hyperion Essbase.
• Extensively involved in creating Parameters and Record Selection Formulas to allow the users to filter the Data.
• Created Hierarchies at various levels for drill down reports and Customized LOVs in Universe using designer.
• Implemented Row Level security and User restrictions at universe level.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance.
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts Query Prompt and Drill filters.
• Developed the T-SQL functions to process these data and populate them in the universe as derived tables.
• As a part of Universe development, created Classes, different kinds of Objects, Cardinalities, Strategies, resolving loops using Aliases and Contexts.
• Created Dashboards and Score cards to provide the users with business information using Performance Manager.
• Designed Logical & physical data models with use cases for web applications.
• Extensively used Business view manager for creating Business views from two different sources.
• Created the complex Webi reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
• Designed dashboard reports and scorecard formats with process analytics & predictive analytics.

Environment: Business Objects XI R2, Crystal Reports XI, Web Intelligence Release 2, Live Office, .NET, T-SQL, Teradata V2R5 and Windows 2000/2003 Server

Confidential - Memphis, TN

Business Object Developer

• Implemented Best Practices for using Business Objects Suite of products.
• Designed and developed requirement definition documentation, based upon previous interview sessions with business users.
• Extracted data from various sources and loaded into target database using Data Integrator XI.
• Developed Logical and Physical Data Models.
• Installed and deployed Business Objects Crystal Integration Pack.
• Provide solutions for imported data from Business Objects 6.5.1 and Crystal Enterprise to Business Objects Enterprise XI.
• Worked on Business views and Universes to Business Objects XI.
• Implemented Import Wizard and Publishing, Wizard for migration of reports and Universes.
• Fixed day to day problems in BO XI migration from 6.5.2
• Implemented Dashboard Manager and Performance Manager for dashboards and Scorecards
• Designed set analytics, Process Analytics and Performance Analytics
• Worked on Universes and Connection management process
• Edited reports in interactive view format
• Performed tuning of SQL queries for better performance.
• Optimize existing T-SQL code.
• Used complex queries, sub-queries, Aggregate functions for reports
• Defined metrics with goals for predictive analysis and set analysis.
• Prepared user documentation for hand on training for en user community
• Designed Production System support and handled opened user cases

Environment: Business Objects XI R2/6.5.2, Web Intelligence, Crystal Enterprise, BO SDK, EPM, ERwin 4.0, Oracle 10g, DB2

Confidential, NY

Business Objects Developer

• Directly coordinated with users to gather the new requirements and working with existing issues.
• Designed, developed and maintained Universes for supporting ad hoc and canned reports.
• Created various classes and objects in the Business Objects Universes
• Created user objects to enhance the reporting needs.
• Created measure objects and user objects keeping in view of the end-user requirement.
• Created Filters (Condition Objects) to improve the report generation.
• Created Hierarchies from providing drill down options for the end-user.
• Created Context, Alias to resolve the Loops in the Business Objects Universe.
• Modified the existing Business Objects Universes, Adding new objects editing joins mapping the existing objects with renamed tables.
• Developed various T-SQL stored procedures/functions for the Application.
• Utilized T-SQL on a daily basis in creating customs view for data and business analysis
• Created the Derived and Aggregate Tables.

Environment: Business Objects 6.5, Web Intelligence, Broadcast Agent, PL/SQL, MS Excel, T-SQL,TOAD, Oracle 9i and Windows 2000