SUMMARY:

• Around 6 years of experience in all modules of SAP Business Objects suite (BI 4.0, BO XIR3.1, XIR3, XIR2 & 6.x) with experience in Central Configuration Manager (CCM), Central Management Server (CMS), Central Management Console (CMC), Desktop Intelligence, Web Intelligence, Info View, Universe Designer and Crystal Reports Enterprise.
• Experience in Crystal Reports reporting systems using version 8.5/10/XI/R2/2008.
• Solid understanding of SAP best practices and methodology for gathering requirements, generating and measuring business cases.
• Extensive experience in gathering and documenting user requirements, report development, setup security infrastructure at Data and Business levels as part of setting up reporting infrastructure.
• Experienced in interacting with Business users to analyze the Business process, requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• Experienced in creating and modifying functional (requirements) and technical (design) aspect. Also interacting in report design, test script creation, unit testing, UAT and end user training.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as Designing, Developing, Testing, Migrating, Administrating, Security Management and Production Supporting and also have successful track record in large - scale with two full life cycle global implementations.
• Expert in writing canned reports, complex ad-hoc reports using SAP BOBJ Desk Top Intelligence (DESKI), Web Intelligence (WEBI), Designer, Import Wizard, Web Intelligence Rich Client, QaaWS, Publishing Wizard, Broadcast Agent, Live Office, BI Web Services, BI Widgets, Business View Manager tools and profound knowledge on Crystal Reports.
• Strong experience in creating Ad-hoc queries, List Reports, Cross-tab Reports, Standard Reports, Dashboard Metrics, Chart Reports, Map Reports, Financial Reports & Repeater Table using Query Studio, Report Studio & Analysis Studio containing functionality such as conditional formatting, prompts, bursting and drill-through.
• Have clear understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL Tools of Informatica Power Center, Abinitio, Data Stage, SAP BODS & Others.
• Good knowledge of Data Warehousing Models, RDBMS concepts, Data marts in Oracle and SQL Server, experienced in gathering requirements, Proof of concept, gap analysis, design, development, Testing and Implementation.
• Good exposure to Databases SQL, PL/SQL & JDBC/ODBC interfaces to Oracle, Sybase, and Teradata & DB2.
• Excellent Inter-personal & Communication skills & ability to adapt quickly to different situations.
• Willingness to work under stringent deadlines with teams as well as independent.

TECHNICAL SKILLS:

BI /DSS Tools: Business Objects 4.0/XIR3/R2/6.5/5.5,Crystal Enterprise 8.5/10/XI, Crystal Reports 9.0/10/XI, SSRS

RDBMS: Oracle 9i, 10g (SQL, PL/SQL), MS SQL Server, MS Access,DB2

Database Tools: Toad, Aqua data Studio, SQL Developer

Languages: SQL, PL/SQL, C, C++, VC++, Java, MS SQL

GUI: Visual Basic, TOAD, Oracle Enterprise Manager MFC, C#, .net, php

Web Technologies: HTML, DHTML, XML, Java Script, CSS

Tools & Utilities: SQL Programmer, DTS, SQL Enterprise APOS, SQLNavigator, ClearCase, ClearQuest, Remedy and Oracle Enterprise Manager

Operating Systems: DOS, UNIX (SUN/SCO), Windows 95/98/2000, Windows NT, Linux

PROFESSIONAL EXPERIENCE

Confidential, PA

Business Objects Developer

Responsibilities:

• Designed and delivered seminar to introduce a team to Agile Work principles, practices and disciplines in an interactive fashion that assists in teambuilding and finding ways to apply Agile Work to existing problems.
• Interacted with Business Analysts, Business Users and Managers in gathering business requirements for Dashboard and reports.
• Created an Information Design Tool from scratch, maintained and updated the ‘Data Foundation’ & ‘Business Layer’ based on Logical Model, linked other Database which has Employee & Department Names table’s information, by Data Foundation in Information Design Tool, by creating multisource Relations Connections, for the information using Business Objects XIR4.0.
• Involved in Migration from current system BOXI R2 to BI 4.0 by using upgrade management tool on 2 phases.
• Analyzed specs and databases models to generate the reports for the sign-off specs.
• Created joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Created Custom and Cascading List of Values (LOVs) for better understanding of prompts by the end users.
• Converted existing Microsoft Access reports to Web Intelligence and Crystal Reports.
• Create different types of Web Intelligence reports and Crystal reports including: Cross-tab, Conditional, Drill-down, Top N, Summary, Sub reports.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance.
• Edited Joins, resolved the loops using aliases and contexts in the Data Foundation & Business Layer in Information Design Tool and exported to repository.
• Created Dimension, Measure & Detail Objects that are needed for reporting following the business usability.
• Created Detail design documents for all the Reports, Data Foundations & Business Layer.
• Created different types of reports such as Master/Detail, Cross Tab and Chart, use of Filters, Conditions, and Calculations.
• Created reports, setup alerts, ranking, graphs, and report level variables.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Web Intelligence Rich Client.
• Provided Business Objects Universe design changes to address performance, usability and data reliability issues.
• Created complex WebI reports by linking objects from different data providers and using Merge Dimension Option.
• Created complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Developed new reports and provided Technical support for the report development team in all reporting tools.
• Used QaaWs (Query as a Web Service) and live office to feed data into Xcelsius.
• Unit tested Web Intelligence reports before pushing them to complete testing phase and wrote complete report specs.
• Exported Business Layer to the Repository for making resources available to the users and coordinating users in both onsite & offshore & gave 24/7 Production Support.

Environment: SAP BI 4.0, Business Objects (Web Intelligence Rich Client, BI Launch Pad, Information Design Tool (Data Foundation & Business Layer), Upgrade Management Tool, QaaWS), Crystal Reports XIR2/2008, Oracle 11g, MS Office.

Confidential, Columbus, IN

Business Objects/Crystal Reports Developer

Responsibilities:

• Prepared the following Business/Technical Requirements, Design Templates, Development Standards document and detailed design documents.
• Created Functional Requirement Document (FRD) and technical specifications for universe and reports.
• Involved with Development team for Migration of SAP Business Objects from XIR2 to XIR3 version and also involved in CMC to provide the User Security settings and Creating User groups in Rich Client 3.1.
• Created Universes (Activity, Account, and Contact & Opportunity).
• Defined cardinalities, Performed Check integrity, Resolved Loops by creating aliases and contexts to remove the cyclic dependencies.
• Fine tuning the performance of Universe and Reports.
• Modified the Universes, add additional Dimension, Detail and Measure Objects according to the requirements.
• Defined and created dimension objects, conditions, user and measure objects to capture complex formulae.
• Created joins, cardinalities between tables applying contexts and alias tables.
• Designed, Developed and Maintained Universes for supporting Ad-hoc and canned reports.
• Performed the migration of all the Content & Resources from Source to Destination repository using Import Wizard.
• Created Web Intelligence Reports (canned & Ad-hoc) that include functionality like Sections, breaks, Grouping, Sorting, Drill-down, Variables and Slice and Dice using Universes & SQL as Data Providers.
• Designed and Developed Crystal Reports according to requirements from Store Procedures and SQL Command.
• Used Business View Manager to create Crystal Reports cascading prompts/LOV.
• Extensively used breaks for white spaces and sections and also created user information in the footer level for better navigability.
• Scheduled Web Intelligence reports and Events in Infoview.
• Used Xcelsius for presenting Dashboards to End users.
• Created Xcelsius dashboards using live office, XML data Providers.
• Worked on Multi-source data integration in one report to provide a flexible, data warehouse neutral solution enabling easy access to SAP BW data.
• Involved with Business Users one to one session of all Reports and pointed to defects log for any formatting issues, data issues and any other changes or performances issues and validated Reports.
• Mentor and coordinated the offshore team with Universe Designing/Reporting/Admin and Crystal Reporting Design/Development/Validation/Testing and Production Migrations
• Involved in Unit Testing, Integration Testing and Performance Testing of reports and Universes.

Environment: SAP Business Objects XI 3.1 (Web Intelligence Rich Client, Infoview, Designer, Import Wizard), Crystal ReportsXI/2008, Windows 2000, MS Office.

Confidential, Bentonville, AR

Business Objects Developer

Responsibilities:

• Prepared the following Business/Technical Requirements, Design Templates, Development Standards document and detailed design documents.
• Created user groups and managed access privileges, using Central Management Console (CMC).
• Worked on the Migration of Reports and Universe from 6.5 to XIR2.
• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Installed and Deployed BO XI as well as Info Advantage Application system.
• Designed, developed and managed Universes in Business Objects Designer
• Defined Aliases and Contexts to resolve loops in the universes.
• Designed the mock-up report templates and report design templates.
• Created complex reports using multiple data providers and synchronized the data providers by linking the common objects to achieve required output.
• Scheduled daily reports using the scheduler function in CMC and Infoview.
• Fixed the defects in System testing phase and UAT testing phases.
• Extracted Data using SQL and performed Unit testing and helped the client in user acceptance testing (UAT).
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Created Business Objects reports like matrix reports, standard reports, Adhoc reports, charts and graphs.
• Involved in the designing and building of Universe, Classes & Objects
• Analyzed different data connectivity that can be used in connection to BOBJ Enterprise like QaaWS, Live Office, BI Web Services, BI Widgets and Business View Manager.
• Create different type of Web Intelligence and Crystal reports including: Cross-tab, Conditional, Drill-down, Top N, Summary, OLAP, Sub reports and cascading prompts.
• Designed and Developed Crystal Reports according to requirements by using Crystal Reports formulas, grouping, Selection criteria from tables, Store Procedures, views and Command Objects.
• Developed Web Intelligence Documents through Web Intelligence Rich Client by using Universe as a source through local server.
• Suggested different options to modify the dashboards which had performance issues and prepared a Gap analysis to explain the client on the standards.
• Created Analytics and Dashboards using SAP BO Xcelsius to enable executives track progress and compare current and historical performance against established targets.
• Involved in technical and business analysis aspects of BW data warehouse project development, creation of test plans and scenarios, testing, and implementation; including significant hands-on work.
• Using BEx Query designer and formatted Reporting and designing queries with hierarchies.
• Involved in Bug fixing for the reports testing using Mercury Quality Centre.

Environment: Business Objects XIR2/6.5 (Web Intelligence, Desktop Intelligence, Infoview, Designer, CMC), Crystal Reports XI/10.0,Microsoft SQL Server 2008/05, Oracle 9i, Data Integrator XI 3.0, UNIX, Toad9.0, Teradata V2R5, ERwin 4.0, Windows 2003

Confidential, Denver, CO

Business Objects/Crystal reports Developer

Responsibilities:

• Created Dynamic and cascading prompts in Crystal Reports.
• Explored the functionality of storing a single prompt definition in the repository and sharing among multiple reports, improving both runtime scalability and design-time productivity.
• Implemented Parameterized sorting wherein the reports had the sort values driven by a formula.
• Created Complex formulas using CASE, IF STATEMENTS and STRING CONVESRION and DATE CONVERSION functions.
• Involved in testing reports to compare the row count, response time in 6.5 and XIR2.
• Used the Report Conversion Tool to migrate the existing Desktop Intelligence reports to Web Intelligence. Tested the migrated reports for any cosmetic modifications.
• Created a wide variety of charts like pie chart, 2D and 3D charts reflecting the current information versus the forecasted information.
• Created Hierarchies to provide the drill down functionality to end-users.
• Extensively used ranking, Alerters, Filters and prompts in reports.
• Created highly complex reports using Desktop Intelligence and ad-hoc reports using Web Intelligence.
• Created various report formats such as Sub Reports, Cross Tab Reports, Standard Reports, OLAP Reports and Master Detail Reports.
• Created customized LOV's and cascading prompts for easy access to business users.
• Developed Shell Scripts on Aix Server for upgrading the Jobs.
• Performed various operations like publishing and retrieving reports from corporate documents

Environment: Crystal Reports 10/9.0, Business Objects XIR2, 6.5, Desktop Intelligence, Data Stage 8.1, AIX, Windows 2000, MS-Office, XML 1.0, SQL Server 2005 & MS-Access.