SUMMARY

• Over 7 years of experience in Business Objects Development using various Business Objects (BOBJ) Product Suite including Webi, Deski, Xcelsius Dashboards, Universe Development and Crystal
• Experience in Business Objects Enterprise (BOE) Development and Administrator through versions Business Objects 4.0/XI 3.2(R3.x) / XIR2/R1/6.x/5.x/5i/4.x and Xcelsius 2008 / 4.5.
• Experience in implementation of Enterprise Information Management (EIM) which include Enterprise data warehouse management, Master data management, Data integration and quality management, Information lifecycle management and Enterprise content management.
• Experience in Business Objects Data Services/ Data Integrator 4.0/3.2.
• Around 3 years in building dashboards using Xcelsius 2008/4.5 using QaaWS, Web service connections, Live Office, XML, flash variables and SAP BW Net weaver connections.
• Expertise in developing Universes for Customized Metrics and Goals to Create Metric Analytics and Goal Analytics.
• Major responsibilities include gathering requirements from the end user and developing Desktop Intelligence Reports, Crystal Reports and Webi Reports.
• Experience in using InfoBurst for a powerful and flexible report distribution and publishing solution that delivers business critical information to the right people, in the right format Confidential the right time.
• Extensive database architecture and design skills working on high performance solutions in large corporate environments.
• Developed BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions
• Strong Integration skills between External Portals with SDK and Xcelsius Dashboards.
• Server Intelligent Agent (SIA),Central Configuration Manager, Central Management Console, Business Objects Enterprise, BO Performance Management, Auditor, Crystal Reports, Crystal Xcelsius, Query as a Web Service (QaaWS), Voyager, Live Office, Dashboard Manager.
• Proficient in design, development, coding, implementation and Support.
• Handful of experience in SQL Development and SQL tuning.
• Experience in BO - BW integration includes Access, Analyze, Built, Test and Deploy.
• Define Integration road map, setup BOE server & Integration Kit, Modify and Build SAP BI queries and Objects, Build BOBJ Universes and Reports, Implement BOE based security as applicable.
• Experience in Unit test SAP BI and BOBJ components.
• Experience in using SAP NetWeaver Master Data Management (SAP NW MDM).
• Worked with various teams including Business Owners/ Users, Database and Front end Teams.
• Experience with Microsoft Active Directory Federation Services (ADFS), Claims based Authentication.
• Designed and linked Universes for query, reporting, and analysis using the Designer Module.
• Developed and supported in Extraction, Transformation and Load process (ETL) using Business Objects Data Services to populate the tables in Data warehouse and Data marts.
• Experience with different types of Data Marts like General Ledger Rapid Marts, Account Receivable/Payable Rapid Marts, Inventory Rapid Marts etc…
• Expertise in gathering, analyzing and documenting business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.
• Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Performing Migrations from earlier versions 5.x, 6.x to XI R1/R2 architectures and recreating security Models in XI.
• Implemented both Single Pass Method and Incremental Method for Migrations.
• Expertise in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design, physical and logical data modeling.
• Working with data service products like data integrator, metadata and data quality management.
• Good understanding of all the architectural differences between all versions of Business Objects.
• Solid Experience in writing SQL queries, stored procedures, stored functions, packages, database triggers, exception handlers, Cursors, PL/SQL records & tables.
• Expertise in databases to include Oracle 10g/9i/8i/7x, MS SQL 2005/2000/7/6.5, DB2,Tera Data and MS Access.

TECHNICAL SKILLS

OLAP/DSS Tools: Business Objects XI 3.1(R3.1)/R2/R1/6.x/5.x/5i/4.x,BO SDK, Crystal Reports, SIA, Central Management Console, Central Configuration Manager, Designer, Desktop Intelligence, Web intelligence, Webi Rich client, Info View, Report Conversion Tool, Translation Manager, Crystal Xcelsius 2008/4.5, Query As A Web Service (QaaWS), Performance Manager, Deployment Tool, Auditor, Crystal Report Explorer, Dashboard manager, Scorecards, Tomcat 4.0.6, Apache 1.3.x, Business Objects JAVA SDK

ETL Tools: SAP BO Data Services 4.0, XI 3.2 SP1(Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), SAP BO Data Integrator XIR2

RDBMS: Oracle 10G/9.x/8.x/7.x/5.x, DB2/400, SQL Server 2000/2005, TeraData, MS Access 2000, SAP BW.

Languages: HTML,JAVA,JSP, PL/SQL, SQL, Shell Scripting

Utility Tools: Erwin, TOAD, SQL* Navigator, Developer 2000, SQL*Loader

Operating System: MS-DOS, Windows 2003/XP/NT/2000/98/95, Unix, HP- Unix, Sun Solaris

Web Technologies: VBScript, HTML 3.2/4.0, IIS 4.0/5.0

Application Servers: Web Sphere, Web Logic, JBoss, Apache, Tomcat.

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NYC

Business Objects Report Developer

Responsibilities:

• Gathered the requirements using JAD sessions, provided the related Mock-ups for the particular Reporting Scenarios and documented them properly for future references.
• Involved in designing Functional / Technical Specification documents.
• Developed reports specific with these Delegated Search, Database Delegated, Open Document and Data tracking, data services new functionalities.
• Experience in installation Business Objects 4.0 and migrated reports from 3.2 to 4.0.
• Installed Crystal Xcelsius 2008 SP3 and developed dashboards using various components.
• Developed Xcelsius 2008 Dashboards on top of QaaWS and Live Office connections.
• Implemented Open Doc to drill down to detail webI report from Xcelsius Dashboard.
• Exported Xcelsius to repository to make it available for users through info view.
• Used relative path URL to migrate Xcelsius Dashboards from one environment to other Environment.
• Created WSDLs using Query As a Web Service (Qaaws) from different Data sources.
• Designed, developed, deployed and maintained universes used Business Objects designer.
• Created Web Intelligence Rich Client reports with Metadata using Metadata Universe.
• Experience in using SAP NetWeaver Master Data Management (SAP NW MDM).
• Content Consolidation - centralized cleansing, de-duplication and consolidation, enabling key mapping and consolidated group reporting in SAP BI. No re-distribution of cleansed data.
• Master Data Harmonisation - as for Content Consolidation, plus re-distribution of cleansed, consolidated master data.
• CentralMaster Data management- as for Master Data Harmonisation, but all master data is maintained in the central MDM system. No maintenance of master data occurs in the connected client systems.
• Created Account Receivable, Payable and Inventory Rapid Marts.
• Created the Local Repositories, Secured Central Repositories, Profiler Repositories using SQL server 2008 database and configured the Local, Profiler repositories with Job server and Management console.
• Scheduled the Jobs in Management Console.
• Experience in meetings which involve SAP functional team to prepare functional mapping and to give suggestion to achieve by using data services.
• Created the data stores for SAP and Legacy (by using ODBC connection to underlying legacy data base which is DB2).
• Used Business Objects Data Services interactive debugger to test the jobs and fixed the bugs.
• Experience in debugging execution errors using Data Integrator logs (trace, statistics and error) and by examining the target data.
• Scheduled, monitored and fixed the errors of the jobs.
• Performed tuned Business Objects Data Services Real time and Batch jobs, complex transformations in Data Flows to improve efficiency.
• Rich Product Content Management - Catalogue management and publishing. Uses elements of Content Consolidation to centrally store rich content (images, PDF files, video, sound etc.) together with standard content in order to produce product catalogues (web or print). Have standard adapters to export content toDesktop Publishingpackages.
• Used Aggregate Navigation with compatibility filters in universe to restrict the hierarchy.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Generated Reports from Different Data Providers in Business Objects using a Normalized Schema Database.
• Created Web Intelligence Ad-hoc and canned reports.
• Tuning the queries to improve the performance of the report refresh time.
• Created dashboards with multiple hyperlinks to various reports using Open Document Syntax.
• Worked closely with DBAs to create aggregate tables to support Universes and dashboard.
• Developed Webi Reports based on ETL Audit tables to track Record submission, loaded records, Errors in records and Error details.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.

Environment: Business Objects 4.0/XI 3.2 (Designer, WEBI, Web Rich Client, Crystal Xcelsius 2008, QAAWS), Data Services, Oracle 10g, SQL Server 2005, Toad, Apache/tomcat.

Confidential, St.Louis, MO

Business Objects Report Developer

Responsibilities:

• Documented user requirements, translated Functional requirements into Technical Requirements and develop implementation plan and schedule.
• Developed Report Mock-up samples before User interaction to analyze the business requirements.
• Worked in the Team closely with Functional Architect, DBA and Analysts to get a clear understanding on the Application.
• Developed dashboards using Xcelsius 4.5 using live office and Qaaws as the data sources.
• Developed universes to accommodate complex database design approaches.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Streamlined SQL generation from Universes by implementing Aggregate Aware functions and @Variables.
• Created highly formatted reports to visually represent data.
• Created Webi Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Created live reports in a drill down mode to facilitate usability and enhance user interaction.
• Created Rapid Data Marts for Accounts Analysis.
• Developed Dashboards using Crystal-Xcelsius with data source as Live Office.
• Developed customized Webi reports as a source data for Live Office.
• Collecting report & Visual requirements from users/business owner.
• Troubleshooting and rectifying Universe, Webi & Live Office errors.

Environment: Business Objects XI R2,Crystal Reports, Crystal Xcelsius 4.5, Live Office, Oracle Database, Tearadata, PL/SQL, SQL scripting and Windows 2000 server.

Confidential, Princeton, New Jersey

Business Objects Administrator/Developer

Responsibilities:

• Installed and Configured Business Objects on Both Client and Server Installations.
• Converted reports from 6.5.1 to XIR2 using the report conversion tool.
• Worked on the WEB.XML file on the application server to enhance auto user logout from infoview with the parameter customization and then users are redirected to a custom JSP page.
• Created user defined @prompts and complex conditions Confidential Universe level for better performance.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure.
• Generated Reports from Different Data Providers in Business Objects using Oracle Database.
• Created Compound Analytics, Charts and Goals on the Dashboard Manager.
• Created Analytics on top of Metrics for the Performance Manager.
• Opened tickets in the Tracker for Reporting purpose to track all the Report statuses purpose.
• Created Cascading Prompts on the Reports.
• Implemented Filters, conditions in the Universe to the run the Reports quickly.
• Created single sign-on for many reports using the URL functionality to access them directly .
• Created Analytic Dashboards for upscale users on the Financial Actual Budget and Target Budget.
• Created Views, Stored Procedures and validated data for the Performance.
• Used the Broadcast Agent Server to Schedule and Monitor the Reports.
• Prepared universe for Ad-hoc query functionality to educate users.
• Audit reporting system implementation on UAT and Production Environments.
• UAT was one of the important processes that we had developed during this project.

Environment: Business Objects 6.5.1, XI R2, Oracle 10g, Essbase Hyperion Analyzer, DB2, Sun Solaris and Web Logic.

Confidential, Omaha, Nebraska.

Business Objects Consultant

Responsibilities:

• Documented user requirements, translated Functional requirements into Technical Requirements and develop implementation plan and schedule.
• Supported Business Objects Environments as a Primary Role.
• Worked in the Team closely with Functional Architect, DBA and Analysts.
• Created Derived Tables in the Universe to meet the Reporting Requirements.
• Installed and Configured Business Objects on Both Client and Server Installations.
• Created Default users using Central Management Console for the Application to verify the Reports.
• Worked with User Interface (UI) Developers to create Urls for Single Sign-on, passing the Required Parameters to run the Report.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Created user defined @prompts and complex conditions Confidential Universe level for better performance.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Generated Reports from Different Data Providers in Business Objects using a Normalized Schema Database.
• Created few Crystal Reports to Email and Ipage to the Customers.

Environment: Business Objects XI R1, Crystal Reports XI, Oracle 9i, LDAP, Vitria, Sun Solaris and Web Logic.

Confidential

PL SQL Developer

Responsibilities:

• Analyzed the business requirements of the project by studying the Specification document.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL,SQL *Plus, SQL*Loader and Handled Exceptions.
• Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
• Created PL/SQL stored procedures by using bulk bind for inserting, updating data in process tables.
• Designed the front end interface for the users using Forms 6i.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures,Triggers, Packages, Records and Collections.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Performed Unit Testing.

Environment: D2K 6i, Oracle 8i, PL/SQL, Windows NT