PROFESSIONAL SUMMARY:

• 8 + years of IT experience, SAP Business Objects 4.0/XIR3/XIR2/6.5(Universe Designer, Info View, BI Launchpad, Web Intelligence, Desktop Intelligence, Webi Rich Client, Import Wizard, Report Conversion Tool, CMC/Supervisor, Xcelsius, Crystal Reports.
• Extensive experience in planning, designing, developing, modifying, updating, maintaining and distributing efficient and user oriented Universes using Universe Optimization Techniques on BO XIR2 and BO XI R3
• Assisted in Installing Business Objects and Administered Business Objects using Central Management Console
• Good work experience in implementation and migration of SAP Business Objects XIR2 to XI R3.1.
• Proven ability in defining BO Administration security, creating Custom Access Levels
• Strong experience in creating complex and adhoc reports using Desktop Intelligence, Web Intelligence and Web Intelligence Rich Client.
• Experience in building Desktop Intelligence reports using Universes, Personal Data files and Free Hand SQL Methods.
• Worked with Crystal Report for creating complex reports that included creating sub - reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV(List Of Values).
• Involved in designing both static and dynamic dashboards using Xcelsius.
• Sound understanding of Dimensional Modeling, designing Star and Snowflake Schema.
• Introduced and implemented the new interactivity available in XI R3 to business like Offline Ad hoc reporting, Hyperlinked reports.
• Good experience in Full Life Cycle Implementation of BI/Data warehousing projects.
• Ability to quickly adapt to different project environments and an excellent team member.
• Excellent interpersonal, communication and presentation skills along with time management.

TECHNICAL SKILLS:

Business Intelligence: SAP Business Objects XI 3.1/Xi R2/XI R1/6.x, Designer, Supervisor, Deski/Webi, CMC, CCM, Crystal Reports 2008, Xcelsius 2008.

Data Modeling: Star-Schema Modeling, Dimensional Modeling, Snowflakes Modeling, Fact & Dimensions Tables, Physical and Logical Data Modeling.

Database: Oracle 11g/10g/9 MS Access, SQL, MS SQL Server 2005/2008

Utilities: MS Word, MS Excel, MS PowerPoint, MS Front Page, TOAD

Environment: Win 95/98, Win NT 4.0, Windows 2000/2003/2008 server, MS-DOS 6.22

PROFESSIONAL EXPERIENCE

Confidential, Portland ME

Business Objects Developer

Responsibilities:

• Involved in gathering the Reporting requirements from Data Analyst and Business Analysts who collected the report requirement from Business managers of the QPM system and performed Data mapping, Fit-gap analysis to translate report requirement to technical specifications for designing Universes and generating reports.
• Created New Users/Groups in CMC as per the Service Requests and involved in creating and applying Custom Security model for the Business User’s.
• Involved in the designing and Building of Universes for new Components making extensive use of Universe Optimization Techniques such as Aggregate Awareness and Index Awareness.
• Modified the existing Universes according to the Specifications, which were from different data sources like Oracle/SQL Server.
• Involved in creating Classes and Objects as per client’s metadata and applied Custom Hierarchies for creating drill reports based on business logic.
• Validating and verifying Universes and Reports created by the Off Shore team and making the necessary changes as needed.
• Involved in creating weekly BIAR backup for reports and universes
• Involved in Performance testing of the reports and universe module created by the team and suggested solutions to improve the performance.
• Created both dynamic and static dashboards using Xcelsius using QAAWS (Query as a Web Service), Excel Spreadsheet, Live Office and Crystal Reports.
• Trained the business users and conduct workshops for the Business Analysts and Business Users on BOXI 3.1.
• Involved in the Assessment Phase meetings to upgrade to Business Objects 4.0.

Environment: Business Objects XI 3.1 / R2, CMC, Designer, Desktop Intelligence, Web Intelligence, InfoView,, Import Wizard, Crystal Reports 2008/ X1 R2, Xcelsius 2008, Live Office, Oracle 10g/11g, SQL, PL/SQL, Windows XP.

Confidential, Abbott Park, IL

Business Object Developer

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements, Data mapping, conducting fit-gap analysis for BO universes and reports.
• Created power users/operational user groups and maintained row level and object level security using Central Management Console and assisted in Server Administration, setting up security, custom access levels.
• Involved in Migration of Business Objects system from version BO XI R2 to BO XI 3.1.
• Created weekly BIAR backup files and for Migration Support.
• Created efficient Universes according to business requirement making best use of Universe optimization techniques.
• Setting up security to users in universe module like row level and object level security.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, applying contexts and alias tables to resolve loops and SQL traps.
• Interacted with the Business Analysts to gather FRDs and developed prototypes in the form of PDF’s or Power Point Slides of the Dashboards for the initial presentation to the users.
• Developed complex reports in Business Objects XI R3.1 using OpenDoc functionality, creating local variables and utilizing the concept of scope of analysis in limiting drill down functionality.
• Designed crystal reports for daily and monthly reports, product list, and sales transactions.
• Used multi-value components and single value components in the development of the Xcelsius Dashboards.
• Unit testing of self work and for other team members.
• Trained a team of Analysts on Web Intelligence reporting techniques.

Environment: Windows Enterprise Server 2008, Apache Tomcat, BO XI R2/XI3.1, Crystal Reports 2008, Xcelsius 2008, Oracle 10g, XI, Universe Designer XI, Web Intelligence XI, Info View, CMC, SQL, PL/SQL, SAP Business Objects suite

Confidential, WI

Business Objects Developer

Responsibilities:

• Worked with Business Analyst team to interview the business users and capture simple, moderate and complex business requirements.
• Responsible for analyzing business requirement documents and developing queries and reports using BO full client and Info View to provide Web-enabled data analysis solutions to business clients.
• Extensively worked on Modules like Designer, Web Intelligence, Report Conversion Tool, Info View, Desktop Intelligence, and Crystal Report.
• Created New Users/Groups in CMC as per the Service Requests and involved in creating and applying Custom Security model for the Business User’s.
• Involved in creating BIAR backup, Report and Universe Migration Support.
• Designing Universe utilizing Universe optimization techniques, Predefined Conditions, Derived Tables, Custom and Time Hierarchies.
• Involved in enhancement of existing Universe’s and adding new tables & objects to the Universe as per the requirements.
• Created static and dynamic dashboards using Xcelsius 2008.
• Created reports using multiple data providers such as Universes and personal data files in generating reports.
• Extensively used report organization and formatting techniques like Sectioning, Ranking, Filtering, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae to develop the reports.
• Developed various multi-chart models that connect to real-time enterprise data using Query as a Web Service (QaaWS).
• Provide technical support for troubleshooting and fixing of business objects/web Intelligence reports.

Environment: Business Objects XI R2, Crystal Reports 2008, Xcelsius2008, SQL, Oracle 10g/9g, SQL Server 2005, Windows 2000/2003/2008.

Confidential, Peoria, IL.

Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Designing and development of Universes for forecasting the selling margin.
• Defined Derived Tables, Aliases, Classes, Objects, Dimensions, Measures, Details, Conditions, Joins, and Contexts. Creating complex objects, aggregate navigation, @prompts, @variables, and resolving traps (chasm/fan) among others and Verifying Integrity of universes.
• Responsible for Creating Complex using Master/Detail, Cross Tab, Slice and Dice, and Sub Queries.
• Extensively used Alerts, filters, Variables, Prompts, and also generated hyperlink reports using Webi.
• Created Reports like, Reports by Category, Reports by Region, and Reports by Time (Year, Quarter, and Month Date).
• Maintained existing reports and Created standard template for all reports.
• Provided production support for the existing reports/universe and modified them when needed.
• Created Corporate Dashboards from interactive Xcelsius dashboards, analytics and Webi reports.
• Created analytical, operational, relational, What-if Model Dashboards in Xcelsius using QAAWS, Excel Spreadsheets and Live office to enable executive’s view of the business performance.

Environment: BO XI 3.0/XI R2, Designer, Web Intelligence, Desktop Intelligence, Info View, Import Wizard, CMC, Crystal Reports 2008, Xcelsius 2008, SQL Server 2008, Oracle 10g/9i, Windows XP

Confidential

Business Objects consultant

Responsibilities:

• Translated business requirements into Universe design using Designer, Generated full client, thin client reports in Business Objects according to client specifications.
• Designed, developed, implemented and maintained Universes using Business Objects Designer, Resolved loops by creating Contexts and Aliases.
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Created the reports using Business Objects functionalities like Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas.
• Creating simple & complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, and List of Values (LOVS), local variables, Alerts, Ranking & multiple data providers. Created reports using Business Objects functionalities like Queries, Slice & Dice, inserting and organizing multiple breaks, Cross Tab, Master Detail & Formulas.
• Organized data in report Inserting Filters, Sorting, Ranking & highlighting data. Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Involved in Creating Users, User Groups and setting up the User Profiles using the Supervisor Module.
• Used @functions to create predefined conditions and prompts to filter the data and dynamic user selection.

Environment: Business Objects 6.5, Designer, Web Intelligence, SQL Server 2000, Oracle 9i, TOAD 6.3, Windows 2000/XP.

Confidential

QA Tester/Business Analyst

Responsibilities:

• Gathered data during Joint Application Development sessions to build baseline and initiated processes to improve baseline.
• Wrote Scope and Vision of the Document
• Extensively used SQL for data analysis.
• Developed concepts, business models, and used required technologies when necessary such as Data Flow Diagrams to manage the work effectively
• Defined detailed requirements through product development and other functions to support project team; wrote detailed description of user needs (Use Cases), program functions (Business Rules and Supplementary Specifications), and steps required to develop or modify computer programs.
• Executed efforts within the System Development Lifecycle parameters to ensure customer satisfaction and drove projects to completion throughout product deployment, implementation and configuration lifecycle
• Reviewed computer system capabilities, workflow, and scheduling limitations to determine if requested program or program change is possible within existing system
• Assisted Programmer/Analyst in resolution of work problems related to flow charts, project specifications, or programming
• Actively conducted User Acceptance Testing with a high degree of precision and explained to the end-users the testing methodology to get the various data points from the different interfaces.
• Participated in User Acceptance testing by getting the data points from the production environment.
• Monitored changes to the testing process and communicated errors found during and after User Acceptance Testing.
• Interacted with client regarding project status and feedback on UAT and discussed the information with the development team.
• Developed a Test Plan for testing the application after reviewing requirement specification document.
• Prepared workflow charts and diagrams to specify in detail operations to be performed by equipment and computer programs and operations to be preferred.

Environment: Windows2000, Quality Center,Microsoft Project 2000,HTML, Oracle, MS Visio, MS PowerPoint