SUMMARY

• Having 8+ years of Business Intelligence experience in Business Objects BI4.1/XI3.0/XI R2/6.x/5.x using different modules like CMC, UDT, IDT, BI Launchpad, Report Conversion Tool and Import Wizard and SAP Business Object Explorer 4.X, SAP BO Dashboards 4.X, SAP Crystal Reports 2011.
• Exported crystal reports into several formats like Excel spreadsheet, PDF, HTML.
• Expertise in gathering, analyzing and documenting Business Requirements, Functional Requirements, System Test Cases and Use Cases, Performance Testing Requirements, and Data Specifications for Business Objects Universes, Web intelligence Reports and Crystal Reports.
• Expertise in using various Data Providers like Universes, Stored Procedures, Free Hand SQL and Personal Data Files for retrieving Data.
• Expertise in Designing/Developing Universes and Canned/Ad - hoc Reports using various Sources like Teradata, Oracle, SQL Server, MS Access and Excel.
• Created Simple, Complex and Ad-hoc Reports by using all the functionalities in SAP BI.
• Created reports using Desktop Intelligence, Web Intelligence, BI Launchpad and Crystal Reports.
• Extensively used advanced reporting functionalities such as Master Detailed, Hyperlink, Drill, Filters, Ranking, Sections, Graphs and Breaks.
• Expertise in creating standard reports, cross-tab reports, sub reports and drill down reports using Crystal reports2011.
• Expertise in creating Static, Dynamic, Optional and Cascading prompts in Crystal reports2011.
• Created Sub reports and added an existing report as a sub report in Crystal Report.
• Created hyperlinks in Crystal Reports to open a document in BI platform.
• Extensively used all the functionalities in Crystal Reports like Sort, Group, Hyperlink, Alert, Parameters, Formulas and Conditional Formatting.
• Expertise in developing Cross Tab Reports, Master Detailed, Slice and Dice, Top N Reports for highlighting significant data, summary reports with drill-down capabilities.
• Expertise in resolving Loops and Traps in the Universes using Aliases and Contexts.
• Expertise in creating and linking complex universes using Joins, Conditions, LOVs, Cardinality, Aliases, Contexts, Index Awareness, @Prompts, @Aggregate Awareness.
• Expertise in administration activities like creating and managing repositories, users, user groups, File based Events, Schedule based events, connections, Packages, folder security and working with privileges to users.
• Scheduled and published reports using CMC and BI Launchpad by using events and also monitoring scheduled packages.
• Created Business security profiles and data security profiles in Information Design tool for implementing data security.
• Created Rollback plan, UAT Signoff, Impact Analysis and Implementation plan documents for production move.
• Created BI Launchpad Navigation power point presentations to educate the Customers.
• Highly skilled, self-motivated, outstanding, excellent communication and interpersonal skills with result oriented dedication towards goals.

TECHNICAL SKILLS

Business Intelligence/ETL Tools: SAP Business Objects 4.1 SP3/XI 3.0/ XI R2/ 6.x/ 5.x, Web Intelligence XI R2/ 6.x, BI Launchpad, Info view, CMC, CCM, IDT, UDT, BCA, Performance Management, SAP BO Dashboards 4.X, Informatica 9.1, SAP Crystal Reports 2011 and SAP Business Objects Explorer 4.X.

O/S: Windows 2008R2/2003/2000

Database: Oracle 11g/10g/9i, SQL Server 2008 R 2/2008/2005/2000 , Teradata, MS Access 97/2000,Oracle SQL Developer, Teradata SQL Developer, TOAD.

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

SAP Business Objects Developer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Created complex reports stating revenue generation per year using cascading and user objects like measure objects by using @aggregate aware function to create the summarized reports.
• Created Complex Reports by using functionalities like Slice and Dice, Drill Down, Master Detail in the Web Intelligence tool.
• Checked integrity of the universe, resolved issues like loops, chasm and fan traps using aliases and contexts at universe level.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Defined BO 4.X user security model, define users, groups, and Role based user, Universe Security and Administration.
• Used Index Awareness effectively to take advantage of the indexes on key columns to speed data retrieval.
• Written complex SQL Queries, Stored Procedures, Triggers, Cursors and User Defined Functions to implement the business logic.
• Expertise in creating standard reports, cross-tab reports, sub reports and drill down reports using Crystal reports2011.
• Expertise in creating Static, Dynamic, Optional and cascading prompts in crystal reports2011.
• Created Sub reports and added an existing report as a sub report in Crystal Report.
• Created hyperlinks in Crystal Reports to open a document in BI platform.
• Expertise in using all the functionalities like Sort, Group, Hyperlink, Alert, Parameters, Formulas and Conditional Formatting.
• Exported crystal reports into several formats like Excel spreadsheet, PDF, HTML.
• Designed Highly Interactive Dashboards Using Advanced Multiple Drills Down, Dynamic Visibility and advanced filtering techniques.
• Designed dashboards using Web-connectivity components such as Web-Service Component, XML-Data Refresh, Live Office Connector, Business Intelligence Web Services, Query as a Web Service, Query Browser, URL Link button etc. to establish live connectivity to the dashboards with the database tables, views and BO universes.

Environment: Business Objects 4.1/4.0, BI Launchpad, Webi Rich Client, CMC,CCM,IDT,UDT Oracle 10g/11i,Oracle SQL Developer, Crystal Reports 2011, BO Dashboards 4.X,MS-Office 2010/2013,Report Conversion Tool

Confidential, Columbus, OH

SAP Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Designed, Developed and Maintained Universes by defining joins cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Developed complex universes by using features like aggregate aware, Index aware, Conditions and hierarchies to Perform linking of universes to optimize the universe development and performance improvement.
• Developed various Complex Ad hoc and Complex Canned Reports Using Mainly Universe as the main Data Provider.
• Defined Row level and Object restrictions for the Universes using Manage Access Restrictions in Designer to restrict Key Financial information for the various Spectrum bands.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.
• Worked extensively with the functionalities like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Created Information space based on a Universe.
• Extensively applied Filters, Sort, Rank on the data with in information space.
• Created calculated measures, Emailed data to a recipient and exported data in several formats like CSV, Excel, and Image.

Environment: SAP BOBJ XI/4.X (CMC, Universe Designer Tool, Information Design Tool, Web Intelligence, Info View, Report Conversion Tool), BO Dashboards 4.X, SAP Business Objects Explorer 4.X, Oracle SQL Developer, Oracle 10g/11i.

Confidential, Deerfield, IL

SAP Business Objects Developer

Responsibilities:

• Interacted with Business users, Business Analysts to understand reporting requirements and transform them into technical specifications.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Defined Derived Tables, Aliases, Classes, Objects, Dimensions, Measures, Details, Conditions, Joins and Contexts in Universe.
• Created complex reports by linking data from multiple Data providers, using SQL and functionalities like combined Queries.
• Created Sub reports and added an existing report as a sub report in Crystal Report.
• Expertise in using all the functionalities like Sort, Group, Hyperlink, Alert, Parameters, Formulas and Conditional Formatting.
• Resolved Join path problems like Loops and Traps in the Universes using Aliases and Contexts.
• Created Folders, Groups, Users, Assigning privileges to users and maintaining the Repository.
• Created Ad-hoc and standard reports using functionalities such as Multiple Data Providers, Merge Dimensions, Master/Detail, cross tab, Multi-Dimensional Analysis, Drill Analysis, Scope of Analysis, Filters, Charts, Alerts, Breaks, Sub Queries and Combined Queries.
• Created power users/operational user groups and maintained row level and object level security as part of administration using Central Management Console.

Environment: SAP BOBJ XI (Designer, DESKI, WEBI, Info View, Crystal Reports XI) and Teradata.

Confidential

Oracle/Business objects Developer

Responsibilities:

• Created, modified and maintained Business Objects universes and metadata using Designer.
• Involved in design of applications using SQL, PL/SQL,
• Created cross tab reports and tabular reports and sectional reports.
• Setup and maintained user security using Supervisor.
• Implemented BO monitoring features and usage reports to understand user activity and system use
• Assisted with all systems integration issues that impact the Business Intelligence reporting infrastructure
• Tuned Universe by creating Joins, Contexts, and Aliases for resolving Loops and checked the Integrity of the Universes using Business Objects Designer.
• Created derived tables and shortcut joins in designer to optimize the performance.
• Created reports like Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports
• Designing the Database tables, creating Packages by using stored procedures, Functions, Exceptions, and Cursors.
• Generated Reports using SQL procedures to view Patient Information, Doctor Itineraries, Hospital Administration, Inventory and Sales.
• Generated IO Billing and Budgetary activities, Finance, Accounts, Payroll and Statistical Analysis Reports as per the end user requirements.

Environment: Business Object 6.5, Broadcast Agent, Oracle 8i/9i, PL/SQL, Windows 2000.