SUMMARY

• Procured over 7 years of experience in Business Objects XI R3/R2/6.5/5.5, CMC, Designer, Info view, Web - Intelligence XI/6.0/2.7, Supervisor, Auditor, Business Objects Reporting, OLAP, OLTP, Broadcast Agent, Publisher.
• Various levels of OLAP and OLTP reporting systems were built designed and tested using Business Objects product suite.
• Worked in all the environments of project’s life cycle- was part of Build, Testing and had been in Production support.
• Knowledge of SAP BW concepts, BEx queries and Control-m jobs.
• Strong understanding of Data Warehouse concepts, Star Schema, Snow Flake Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, Fact & Dimensions tables, Physical & Logical Data Modeling & ER diagrams.
• Developed many Standard reports and created Ad-hoc (prompted) Reports using the Business Objects and Web Intelligence Tools.
• Expertise in Universe designing, developing and generating Adhoc, dashboard Reports, Business views, List of values(LOV) along with User Acceptance Test and data accuracy Test.
• Strong expertise in setting up of repositories, Connections, Creating and managing users/groups, Assigning Resources to Users, Importing/Exporting users in CMC.
• Managed creation of complex universes and solved loops, chasm and fan traps.
• Worked on various backend databases including Oracle, SQL Server, Sybase, Teradata etc.
• Strong experience with Xcelsius dashboards using QAAWS and Live Office.
• Acquaintance with different business domains, Finance, Pharmaceutical, Supply chain and Manufacturing sectors.
• Strong experience in performance tuning and query optimization.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed IT solution
• Experience using SAP Info cubes with Business Objects.
• Conversant in Migration of Business Objects 6.5 to BO XIR2 Enterprise using Import wizard.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
• Expertise in Crystal reports and Crystal Enterprise.
• Created formulas, performed grouping data and conditional formatting formulas in Crystal Reports.
• Strong interpersonal skills, excellent problem resolution and communication skills with the ability to work under pressure in a highly visible role.

TECHNICAL SKILLS

Operating Systems: Windows 95/ 98/ 2000/ 2003/ XP/ NT, DOS, Unix.

ETL Tools: Informatica 5.5, 6.0, 6.1/ 7.1, Data Stage, AbInitio

Reporting Tools: Crystal Reports, SQL Reporting Services, Active Reports.

DSS Tools: Business Objects XIR3.1/R2/6.x/5.x (Supervisor, Designer, Business Objects, Web Intelligence 2.x/6.x/XI, Broadcast Agent, BO SDK, Webi SDK, Crystal Reports, SQR, Desktop Intelligence, Info View, Broadcast Agent and CMC.

Packages: Microsoft Project, MS-Word, MS-Excel and MS-PowerPoint.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005/2008 , DB2, MS Access.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Business Objects Administrator

Responsibilities:

• Supported and monitored over 12 applications of Business Objects XI R2 and XI R3 and XI R3.1 with Oracle and SAP BW backend in Global Finance Technology’s production environment.
• Enhanced existing standard reports and created Adhoc reports upon user demand and functional design requirements.
• Performance tuning for the long running BO reports.
• Month end scheduling activity for the user groups and efficient in managing Quarter end processing providing on 24x7 support.
• Implemented a new BO application in General Ledger and migrated BO applications from Oracle 10 to SAP BW.
• Efficiently handled BO admin role, Managed over 4000 users and 50 user groups.
• Worked with DBA’s and System Administrators to back-up the repository and database.
• Scheduled and conducted weekly and monthly BIAR back-ups for BO reports and universes on production and UAT environments.
• Worked production tickets and recognized by peers for resolving priority tickets promptly.
• Troubleshooting and error correction across BO/BW environments.
• Had taken part in Disaster Recovery tests for the databases and validated Business Objects from time to time.

Environment: Business Objects XIR2/R3.1 (CMS, CMC), Oracle 10g, 2.1.1.64, SAP Business Explorer BI 7.100.2.8

Confidential, Atlanta

Business Objects Report Developer

Responsibilities:

• Developed different kinds of reports which include Budget reports, Pharmacy reports, Formulary reports, Prescriber reports, Drug Utilization reports.
• Created complex budget reports with as many as multiple tabs using Web- Intelligence XI R3.
• Created complex variables.
• Used multiple data providers for a single report to enhance data quality and performance optimization.
• Developed, tested and maintained complex reports using multiple data providers.
• Built reports with complex derived tables from child universe derived from parent universe.
• Used @Functions like @Select, @Where and @Prompt in the process of data validation using database (Oracle/SQL developer 2.1.1.64 )
• Extensively used Calculations, Variables, Break Points, Drill and Slice and Dice for creating Business Objects reports.
• Created YTD reports, applied ranking for Pharmacy and Formulary reports.
• Built customized hierarchies which helped users dynamically adjust scope of analysis.
• Built multiple section reports, cross tab reports, list reports.
• Performed unit testing of universes and reports.
• Scheduled reports on monthly/weekly basis to user groups.
• Actively involved in various phases of the testing cycle such as Functional, Regression, Integration, End-To-End Testing and User Acceptance Testing.

Environment: Business Objects XIR2/R3 (CMS, CMC, CCM, Designer, DeskI, WebI, Live Office), Oracle 10g, 2.1.1.64, SQL, Windows2003 Server.

Confidential, Texas

Sr. Business Objects Developer

Responsibilities:

• Migrated Business Objects XIR2 content (users/user groups, Universes, reports) in to Business Objects XI R3 environment using the Import Wizard.
• Assisted the Business Intelligence Architect with Universe design for optimal report performance and increased report functionality.
• Worked towards optimal development of universes by removing loops through the use of aliases and contexts, Creating Universe with number of Classes, many objects, Derived Tables using inner/outer and equiv. joins as per requirement also using Master, Kernel and Component approach for linking of universes for specific needs.
• Knowledge in using Data federator and Integration.
• Exported the universes to the Repository to make resources available to the users.
• Modified and re-branded legacy reports of the acquired company into client company’s reports. Resolved several report design and formatting issues encountered in the conversion of reports that was required as result of the acquisition.
• Created reports for various Portfolios using the Universes as the main data Providers.
• Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc.
• Applied slice-and-dice and drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Extensively worked with ranks, alerter, filters, prompts, variables and calculation contexts in designing reports.
• Developed reports using Crystal Reports 9.0 depending on the user requirements.
• Set up groups and users for Business Objects deployment. Managed user profiles using Supervisor.
• Created Business Objects Repository while building Business Objects solution.
• Extensively used Business Objects Knowledge Accelerator tool to create user training sessions, simulations, and performance evaluation modules as a part of development of XI R3 learning solution for end users. The training tracks centered primarily on Web Intelligence, Desktop Intelligence, and Crystal reports and were interfaced with Learning Edge’s learning platform.
• Trained and provided support for first time Business objects users.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Created and Derived tables, Developed Stored Procedures, Packages and Triggers database using PL/SQL.

Environment: Business Objects XIR2/R3 (CMS, CMC, CCM, Designer, DeskI, WebI, Knowledge Accelerator, Live Office), Informatica 5.5, Crystal Reports, Oracle 10g, SQL, Windows2003 Server, UNIX.

Confidential, Texas

Sr. Business Objects Developer

Responsibilities:

• Installed and configured Business Objects Enterprise XI R2 Suite of Products on Windows 2003 server using Apache Tomcat.
• Managed the Servers using the Central Configuration Manager (CCM).
• Responsible for setting up the Users/Groups, assigning the privileges to the Users using Central Management Console (CMC).
• Involved in the migration of universes and reports from development to test and test to production environment.
• Used Import wizard to import existing User accounts, Groups, Categories, Universes, Reports (FC and Web I), Connections and Universe restrictions to BO XI R2 environment.
• Good comprehension on Planning Migration, Best Practices for Migration, Migration Process, Analyzing the Repository and Import Wizard functionality
• Knowledge of Products in XIR2 including Business Objects Full Client, Web Intelligence, Crystal Reports, Designer, Info View and Publishing which is used for full client documents only.
• Explored the migration options Single pass and Incremental.
• Generated grouping, parameters and complex reporting features in Crystal reports
• Designed and Developed Technical User Documentation and involved in training the End Users.
• Used @Functions like @Select, @Where and @Prompt very extensively in the process of creating objects in the universes.
• Used the functionality of linking universes so as to have the flexibility to use the objects defined in one universe in another.
• Created standard Full Client and Web I reports based on business requirements.
• Developed, tested and maintained complex reports using multiple data providers.
• Organized data in the reports using Filters, Sorting, Ranking and highlighted data using Alerter.
• Used Broadcast Agent for scheduled and batch processing of Business Objects and Web Intelligence documents.
• Extensively used Business Query for Excel in creating reports as per the Business Users requirements.
• Involved in fixing/converting Crystal Reports to Business Objects full client report.

Environment: Business Objects XI R2 (Reporter, Designer, Supervisor), Web Intelligence, Info view,, Crystal Reports 7.0, Teradata, MS SQL Server 2000, PL/SQL, HP Unix, Windows 2000, Sun Solaris.

Confidential, Commack, NY

Business Objects and Crystal Reports Developer

Responsibilities:

• Responsible for setting up the Users/Groups, assigning the privileges to the Users using Central Management Console (CMC).
• Worked with supervisor module in creating users and user groups for different areas and setting privileges to them.
• Involved in the migration of Business objects 6.x to XI R2.
• Created new classes, objects and made structural changes to Universes in Designer to include new objects, updated tables and joins. Also handled testing and debugging of Universes after enhancements and modifications were made.
• Resolved join problems such as Loops, Chasm and Fan traps by creating Aliases, Contexts and using the features available in the Designer to separate queries on measures.
• Linked universes, used Aggregate Awareness tables and resolved connection issues for multiple domains.
• Modified existing Full Client reports and created new Full client and Web Intelligence reports
• Extensively used features like slice and dice, drill up/down/across, prompts, and created reports like Charted/Graphed reports, Cross tabular reports, and Aggregate reports.
• Created various complex reports with multiple data providers.
• Organized data in the report inserting Filters, Sorting, Ranking and highlighting data.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Created both Full client and Web I reports based on the business requirements with drill down functionalities.
• Scheduled Reports to different groups and in various formats like PDF, Excel and .rep on a timely fashion using Broadcast Agent (BCA).
• Performed unit testing of universes and reports.

Environment: Business Objects 6.5, XIR2 (CMC, Supervisor, Designer, Reporter), Web Intelligence, SDK, BCA, Informatica 5.2, Oracle 9i, PL/SQL, SQL Server 2000, Toad, Erwin, Windows 2000 Server/ XP/Professional and Unix

Confidential ., Brooklyn, NY

Business Objects and Crystal Reports Developer

Responsibilities:

• Migration from Crystal 10 to XIR2
• Involved in four phases of Migration including Planning & Assessment, Migration, Validation, and Deployment.
• Implemented the import wizard to import from crystal reports 10i, 9 to Business Objects XIR2.
• Exported the Reports to the Broadcast Agent Server for Scheduling and Refreshing.
• Created reports using Full client as well as ZABO (Zero Administration Business Objects).
• Created crystal Reports using more than one different source, crosstab, parameters.
• Created more than 25 sub reports in each report.
• Generated complex reports like Inventory, Buyers, Excess Materials, Products sales, revenues, regions wise demand and exported them to the corporate repository.
• Created Mailing labels, sub reports and complex charts in Crystal reports.
• Provided end user and production support after deploying the application into the production environment.
• Designing Dashboards using Xcelsius and development of analytical applications.
• Created Complex formulas in the reports, by using crystal syntax and SQL.
• Reports Created using more than one data source and worked with more than one databases
• Create complex Dashboards based on requirements using and PL / SQL queries.
• Worked on trouble shooting of migration issues in reports and universes

Environment: Business Objects 6.5, Desktop Intelligence, Web Intelligence XIR2, Auditor, PL/SQL, MS Access, MS Excel, Toad, Oracle 9i, UNIX, Windows Server NT/2000.

Confidential

Business Objects Developer

Responsibilities:

• Implemented security for the end users based on groups and permissions.
• Reports were mainly related to the production environment and dealt with different aspects like Yield, Loss, Work in Progress which made use of current as well as historic data.
• Was in charge of both Development and Production environments.
• Create new repositories and update connections and features.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.
• Interacting with end Users, to know their requirements and develop/modify Universe and Reports accordingly.
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae etc.
• Generated report using Web Intelligence (thin client) and full client.
• Inserted data from different data sources to meet the needs of the client in comparing targets and sales.
• Effective use of Open document and WebI to link reports.
• Reports were published to a BCA server and scheduled for daily refreshing. Report viewing was strictly restricted to Info View.
• Trained the end users in working with the Business Objects user module and Web Intelligence
• Created Dash Boards for senior executives for business decision making.

Environment: SQL server 2000, Business Objects 5.1.7/5.1.8 , Web Intelligence 2.7.4, BCA 5.5, Windows Server 2003 (Enterprise Edition), Windows Server 2000 (Professional).