SUMMARY

• 7 years of IT experience in SAP Business Objects 4.1/4.0/XI 3.1/XIR2 (Universe Designer, Info View, Web Intelligence, Desktop Intelligence, Webi Rich Client, Import Wizard, Report Conversion Tool, CMC).
• 1+ Years of experience in Crystal Reports, Creating/modifying detail and summary reports using features such as cross - tab, sub reports, complex formula objects, parameter values etc.,
• 1+ Years of experience in Xcelsius 2008, Creating dashboards using Combo Box, List Box, Dynamic Visibility, What-if presentation, Slider, Filtered rows and Alerts.
• Good Knowledge in SAP Business Objects 4.0(Interactive Analysis, Dashboard Design Tool, Information Design Tool, Upgrade Management Tool) and BO Explorer.
• Involved in various stages of project life cycle such as Design, Development, Implementation, Testing and Maintenance.
• Expertise in creating and linking complex universes using Joins, conditions, Filters, LOV, cardinality, Aliases, Contexts, Index Awareness, @Prompts, @Aggregate Awareness.
• Expertise in developing complex reports using multiple data providers, employing functionalities like Merge Dimension, Prompts, Slice and Dice, Drill down, Variables, Functions and Filter.
• Experience in Migration of Business Objects from 6.5 to XIR2 and XiR2 to XI 3.1 and XI 3.1 to BI 4.1.
• Extensive knowledge in Data Warehousing concepts and Dimensional data modeling, Star Schema, Snow-Flake Schema, Normalization/Denormalization, Physical and Logical modeling.
• Extensive experience in working with Relational databases such as Oracle, SQL Server, and Teradata.
• Coordinated with ETL teams to identify the source systems and extract data.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.

TECHNICAL SKILLS

Business Intelligence Tools: SAP Business Objects 4.1/4.0/XI 3.1/XIR2/6.5 (Designer, Deski, Webi, Webi Rich Client, Import Wizard, CMC, Auditor, ZABO and Broadcast Agent), Crystal reports 2008, Xcelsius dashboards, Qaaws, and Live Office

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

ETL: Data Integrator, Data Services 4.0/3.2, Informatica Power centre 7.x/6.x

Bug Tracking Tools: HP-QC/Remedy / Bugzilla/ SunGard

Languages: SQL, PL/SQL, HTML, XML

Data Modeling: ERWIN 7.0/4.0, Visio

Operating Systems: Windows 7/NT/XP/2003/2008, UNIX, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, NY

Business Objects Developer

Responsibilities:

• Worked on gathering, analyzing, and documenting functional requirements and data specifications for Business Objects Universes and Reports.
• Prepared the Business requirement documents based on the User comments on their specifications and developed the mapping documents for designing the Universe and reports.
• Converted reports from desktop intelligence to web intelligence and built some reports from scratch.
• Installed and Configured BO Software on client machines and created User groups and users for PROD, DEV and TEST environments.
• Worked with end users to understand any of the complex report requirement during the conversion process.
• Migrated Universes and reports from UAT to production Using Import wizard.
• Involved in the designing and Building of Universes, Classes and objects.
• Created derived tables to support creation Webi reports that converted from Deski reports built using free hand sql.
• Scheduling and publishing reports onto WEBI to different destinations.
• Responsible for Created user-groups in CMC and implemented the security model on the groups created.
• Created LOV's in IDT (Information Design Tool) and relate them to the prompts to optimize the query. Converted UNV to UNX Universes using IDT as well.
• Created reports using Business Objects functionality's like Queries, Drill Down, Cross Tab, Master Detail and Formulas.
• Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports.
• Extensively worked with formatting the reports according to the user requirements.
• Maintained and Supported reports for new enhancements, modifications and created new reports.
• Setup Multi-Page Reports, Margins, Headers & Footers and provided users with Open Document Functionality features.
• Validated the data and the joins in the Universe by running BO reports and again testing it against the data that was fetched from backend tables using SQL Server.
• Documented all the changes made to the Universes and Reports for future references.

Environment: SAP Business Objects (SAP BOBJ) Enterprise XI 3.1 SP4/ SAP Business Objects Business Intelligence 4.1, BI Launch Pad (Info View), Information Design Tool (designer), Web Intelligence, Desktop Intelligence, SAP Business Objects Dashboards 4.0, SQL Server 2008

Confidential, Plano, TX

Business Objects Developer

Responsibilities:

• Worked with Business Managers, DBA Architects and End users in documenting requirements, providing estimates, creating High Level Design and Detail design specifications.
• Developed Technical specifications based on functionally for the entire reports migration Project by exploring the existing reports.
• Gathered user information and developing WebI reports based on the gathered requirement and creating templates and involved in report documentation.
• Project planning & communication with clients and creating mock up reports for final design and development of reports.
• Creating Universes using Universe Designer Tool on SAP BI4.0 as per the user requirements.
• Involved in designing, developing & testing the universe for report generation.
• Mapped actual LOV data to more user-friendly labels that are displayed in the prompt LOV.
• Managed Business Objects application components, including users, groups, folders, and repository objects, and implementing row-level security in Universe
• Applied security features of Business Objects like reporting level and objecting level security in the universe so as to make the sensitive data secure such as SSN.
• Coding & development for the enhancement requests on BO reports, universes, PL/SQL procedures
• Used Business Objects free hand SQL to generate Ad-hoc reports.
• Handled various change requests and enhancements.
• Resolve incompatible objects in the universe-using context.
• Created and tested Universe, reports and supported Client in user acceptance testing.
• Involved in Writing Detailed Level Documentation for reports and Universe design.
• Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
• Communicated with the Users to get feedback and provide further modifications to the existing reports.
• Validating the Functionality of the Reports and the universes post migration.
• Use combine queries in WebI such as union, intersection, and minus.
• Researched/resolved problems and advice client regarding Business Objects issues and hot-fixes.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.

Environment: SAP Business Objects (SAP BOBJ) Enterprise XI 3.1 SP4/ SAP Business Objects Business Intelligence 4.1-4.0, BI Launch Pad (Info View), Universe Design Tool (designer), Web Intelligence, Desktop Intelligence, SAP Business Objects Dashboards 4.0, Import Wizard, Teradata, Oracle 8g, Oracle 10g, Oracle 11g, Toad 9, Toad 10, SQL, PL/SQL.

Confidential, Dallas, TX

Business Objects Developer/Administrator

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements for universe, reports and dashboards.
• Created sales and operation universe from scratch as a part of decision-making system in data warehouse environment.
• Modified BO Universe by integrating new additional data elements used for both Adhoc Reporting and Standard Reporting.
• Coordinated with BO Admin for migrating universes and reports from development to test to production and validated after that.
• Extensively used Universe features like @functions including @Aggregate awareness and Derived Tables.
• Build Ad-hoc reports using a native SQL and extracted data based on users request and assisted them further with the data related questions.
• Performed fit gap analysis. Worked with the DBA to create aggregate tables and materialized views to improve the performance of the query by cutting down on the size of the result set at the data provider level.
• Extensively used QaaWS (Query as a Web Service) and Live Office to retrieve the data from the universe objects and build dashboard on top of them.
• Extensively used Open Document functionality to seamlessly pass prompt values from summary report to detail report.
• All Webi system administrations like user activities/ sessions, enable/ disable users and modules (if required).
• Configuring all system (Webi) modules.
• Monitoring and improving the CMS performance and Resolving Admin related user cases on priority basis.
• Involved in Single-Sign-On (SOS) application team for the operations updates project.
• Maintained administration of users, user groups and folders and applied access rights on folders, universes, connections, and applications for specific user groups.
• Involved in performance tuning and optimization of Business objects reports.
• Created backup of repository on regular basis using Import Wizard.
• Implemented row-level security using Designer and Application, object-level security using CMC.

Environment: SAP BusinessObjects (SAP BOBJ) Enterprise XI 3.1 SP4/ SAP BusinessObjects Business Intelligence 4.0, BI Launch Pad (Info View), Web Intelligence, Desktop Intelligence,, Live Office, Xcelsius 2008 SP3, SAP BusinessObjects Dashboards 4.0, Import Wizard, Oracle 10g, Toad, SQL,PL/SQL.

Confidential, WI

Business Objects Developer

Responsibilities:

• Involved in constant Requirements gathering and business needs with executives and traders for Dashboard design and development.
• Converted Reporting business requirements in to Functional design and Technical design documents for Developers and testers.
• Working along with DBA/s, BA’s and Data modelers for data design and report design.
• Involved and designed the Enterprise level data security, report security level set up folder structure and User group access.
• Created Unit Test cases for Unit testing, UA testing and System testing.
• Administered user privileges, access, training and implementation for SAP BO XI R3.1.
• Created multiple Universes specific and Providers subject area.
• Implemented user friendly universes for users to create Ad hoc reports.
• Implemented aggregated data for Xcelsius dashboards and exported Xcelsius to BO environment (Info view).
• Xcelsius dashboards include drill down from reports, Combination charts, and Goal declaration.
• Created Executive dashboards with Drill, Drop down, details, Linking to BO Reports, Tabbed and also with Open doc statement.
• Implemented high data intensive reports using Crystal Reports against Crystal enterprise Business views.
• Interacted with Informatica ETL team for issues related to dataflow.
• Implemented scheduled and daily reports developed using Crystal reports and Desktop intelligence based.
• Implemented live office via QAAWS to generate reports.
• Created Technical Support documentation for Reports and universes.
• Used Import wizard extensively to promote Universes and reports between environments.
• Designed and managed groups and users using CMC and assigned them universes and documents specific to their Folders.

Environment: SAP Business Objects XI R3.1 (Web I/ Desk I), SAP BO XI R2, BO DI, Business Objects V6.5, Crystal Reports 11.5, .Net, Business views, Info Cubes, Xcelsius 2008, Performance Manager, Dashboard Manager, Project Management and SQL Server 2005, SAP BI/BW 7.0, Pl/SQL, IBM DB2.

Confidential, CA

Business Objects Developer

Responsibilities:

• Involved in Full life cycle design and development of Business Objects reporting Applications.
• Designed and developed various Universes by defining classes, objects, and defined Joins, Cardinalities between tables.
• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, @Functions and more.
• Analyzed the business requirements and worked with different application teams to develop various inventory and supply chain reports.
• Developed Master/Detail and company trending analysis reports using bar graphs and used Drill Filters for drilling down on graphs and tables to display data at various organizational levels.
• Extensively used Alerts, Variables, Prompts, and also generated hyperlink reports using Webi XI R2.
• Developed accounting reports based on the requirements, which involved complex calculations and use of calculation contexts.
• Developed various complex reports which involved use of combined queries and sub queries from multiple data providers.
• Created various summary reports that involved use of formulas, Grouping, Parameters, and Selection Criteria to handle the customer’s request from Tables, Stored procedures, Views and Command objects using Crystal Reports.
• Used personal data file data providers along with RDBMS data providers.
• Prepared Unit test cases using Quality Center and developed detail design documents for each report.
• Resolved number of defects discovered during System/UAT testing.
• Worked with Support team to complete design/code review.

Environment: BO XIR2/6.5, Designer, Web Intelligence, Desktop Intelligence, Info View, Import Wizard, Crystal Reports 2008, Data Integrator, Oracle 9i, Teradata, PL/SQL, UNIX, Windows 2000/XP.

Confidential, MN

Business Objects Developer

Responsibilities:

• Involved in analysis & development of business reports.
• Gathered Requirements from end users to create Universes and Reports.
• Created Universe, Classes, Objects and measures.
• Specified the standards for universes, Classes, Aliases, Simple and complex objects.
• Created joins, cardinalities, resolved loops and checked Integrity.
• Analysis of certain existing mappings, which were producing errors and modifying them to produce correct results.
• Used filters, conditions, calculations, etc.
• Used Universe as source for the Business Objects Reporting & analysis
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis).
• Organized data in reports by using filter, sorting, ranking & highlighted Data with Alerters.
• Customized charts to avoid data overlap.
• Extensively used Report Formatting elements like break, table level filters.
• Extensively created different variable and formulae to show different subtotals.
• Responsible for analyzing the source system architecture in SQL Server, involved in Unit Testing and User Acceptance Test.
• Performed Unit testing.

Environment: Business Objects XIR2.1 InfoView, SQL Server 2000, Oracle 9i.