SUMMARY

• Five Plus (5+) years of strong experience in decision support systems using Business Intelligence tools SAPBOBJ 4.0/3.1 / XI R3 / XI R2 / 6.5.
• Experience in building Universes. Retrieving data using Universes, Personal data files, Stored procedures, Free hand SQL methods. Creating complex ad - hoc Reports using the Business Objects and Web Intelligence modules. Experience in gathering requirements from the business users and prioritizing those requirements, which have the highest business impact in terms of analysis and decision-making. Worked with Business users to analyze the business process and made necessary changes to the schema objects.
• Proven track record of successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements. System / Software Product implementation experience
• Experience in building Business Objects Universes, Free Hand SQL methods and creating Complex canned and Ad-Hoc Reports using Business Objects reporting application like Web Intelligence, Crystal Reports XI R2 and interactive Dashboard with Lumira
• BOBJ Enterprise Tool set (Web Intelligence, Live office and SAP Crystal Reports.)
• Worked on web Intelligence (WebI), Crystal reports, SAP Lumira and Tableau.
• Expertise in Business Objects Enterprise products (Web Intelligence, Web Intelligence Rich Client, Desktop Intelligence, Central Management Console, Central Management Server, Central Configuration Manger ).
• Proficient in translating report requirements into detailed report specifications, confirm report design with business users and creating reports using Business Objects

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MD

SAP BOBJ LEAD DEVELOPER

Responsibilities:

• Customized existing reports for presentations using Cross-Tab reports.
• Developed Hierarchies for the users to Drill down reports by Region.
• Involved in Adding of new Objects to the existing Universe as per end users request.
• Prompts were used in reports as well as at the Universe level to create interactive reports for the users.
• Extensively worked with Ranks, Alerts, Filters, Variables and Calculations while designing reports.
• Developed ad-hoc and complex webireports for Web intelligence users using Web Intelligence.
• Scheduled Reports for the End users, Business users and Customers.

Environment: s: Business Objects 4.2, Information Design Tool, CMC, Launchpad, Web Intelligence, SSMS, SSIS, Jira

Confidential, Phoenix AZ

SAP BOBJ DEVELOPER

Responsibilities:

• Created ODBC connections in to various SQL Servers for IDT connections connectivity to the databases for tables and views retrieval.
• Joined tables in Data Foundation Layer and solved Loops and Chasm Traps using Alias or Contexts when appropriate for data integrity.
• Utilized SAP Lumira for graphs, charts, scorecards, pie charts and stacked column based visualized reporting and embedded to centralized portal.
• Created Dimensions and Measures in Business Layer and organized them appropriately for ease of understanding by user community.
• Provided hands on training for each universe to diverse group of users and set their security permissions in accordance to their role in CMC.
• Worked extensively with ETL and DBA teams for normalized tables, table design into STAR or SNOW FLAKE Schemas for reporting solutions.
• Maintained Crystal Reports environment and did break-fix on daily basis.
• Created complex Webi reports using drill down, breaks, and sections functionality for in pivotal display.
• Used Merge Dimension functionality to create complex report by using various data sources into a single report for deeper analytics.
• Worked with Project Manager to conduct meetings with user community to gather requirements and turn into functional documents.

Environment: s: Business Objects 4.1, Information Design Tool, CMC, Launchpad, Web Intelligence, SSMS, SSIS

Confidential, Indianapolis IN

SAP BOBJ DEVELOPER

Responsibilities:

• Gathering the reporting requirements from Business users and making Business requirement specification document.
• Preparing System requirement specification (SRS) document that includes logical and physical data model, report distribution strategy based on user inputs.
• Database connectivity was done using ODBC.
• Preparation of Unit Test Plans.
• Verification of functional specifications and review of deliverables.
• Complex SQL queries were used for data retrieval.
• Developed Packages, Procedures and function to maintain the Business logic using PL/SQL.
• Creating Database objects including Tables, Indexes, Views, Sequences and granting Roles, and Privileges to the system users.
• Created Universes using Information Design Tool
• Resolved the loops, cardinalities, contexts and checked the Integrity of the Universes.
• Formatting the Reports to the Users requirements using all the requirements in Business objects like Slice and Dice, Drill Down, @Functions and Formulas etc.
• Distribute BO reporting work among the team as per skill of team members
• Business Objects migration from version 5.x to 6.1a
• Making User Training documents for DW users which would help them working with Business Objects 6.

Environment: s: Business Objects XIR2 / XIR1, Web Intelligence XI R2/R1, Crystal Report 2008/XI, Information Design Tool