SUMMARY

• Having 8+ years of experience in providing viable business solutions using SAP Business Objects Suite BI 4.0/3.1 XI/R2/6.5,5.1.7, IDT, Designer, WEBI, Info view, DESKI, Import Wizard, Upgrade Management Tool, Report Conversion Tool, Publishing Wizard, Crystal Reports, BO Explorer and Visualizations tools Xcelsius and Tableau.
• Experience interacting with stakeholders, gathering requirements and assigning priorities to each of them.
• Expertise in creating complex Ad hoc Universe and reports using BOXI 4.x/R3/R2/6.5/5.1.7
• Worked in all the phases of the project life cycle using SAP Business Objects technologies.
• Experience working with Xcelsius 2008/ Dashboards 4.1 to create executive dashboards, integrating WebI reports with Dashboards.
• Used Oracle, SQL Server and SAP BW as the data sources.
• Experience in creating Xcelsius dashboards by using QAAWS and Live Office as data - connection.
• Expertise in designing Universes focusing on Performance and Reporting needs.
• Experience in defining and delivering complex application and technical architectures in Business Intelligence using BO and Tableau implementations.
• Good experience with Java SDK
• Experience in Installing, Configuring, Upgrading and administering Tableau server.
• Proficient in creatingBOBJ OLAP UniversesonSAP BWInfo cubes and BEx Queriesand using them inQuery As A Web Service (QAAWS), Live Office for data loading into Xcelsius.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Merged Dimensions, Combined Queries, Slice and Dice, Drilling methodology, Breaks, Report Filters, Input Control, Ranking, Section, Graphs, Alerts and Breaks.
• Detected Joins and checked the cardinalities. Resolved table joining problems like Chasm trap and Fan trap using context and Alias.
• Implemented Row level, Column level, Object level and Report level security in the universes to restrict the sensitive data.
• Involved in Admin activities like creation of Users, groups and user profiles.
• Experience in converting Desktop Intelligence reports to Web Intelligence documents using Report conversion tool.
• Migration of reports and Universe from BO 5.1.7 to BO XI R2 and from BO XIR3 to BO XIR4.
• Experience in administration activities like creating and managing repositories, monitoring/granting permissions and rights to users, user groups through Central Management Server
• Business Objects expertise includes full-client and web-based report development, Universe development, installation of client software, troubleshooting, scheduling, publishing and security.
• Good experience in developing reports on different types of Data Providers like Universes, Personal data files, BEx Queries.
• Experience in working on OLAP Universes.
• Experience on BO support projects to handle issues or incidents on priority. Managed incident tickets or problems based on customer requirement.
• Worked on SAP BO universe, Reports and Dashboard enhancement projects to handle new business changes.
• Experience in giving estimates on change requests, SLA’s and to work accordingly.
• Managed Incidents to take care as per SLA and working towards to meet the project specific deadlines.
• Good Exposure on migration from BO XI 3.1 to BO 4.0 using Upgrade Management Tool.
• Good Experience in creating dashboards using Tableau Desktop 7.0.x/8.1.x/8.2.x
• Involved in Admin activities like creation of Users, groups and user profiles using Tableau Server 8.0.
• Exposure to SAP Design Studio and BO Explorer.
• Hands-on experience in installation, administration and upgrading versions of SAP Business Objects. Also expertise in migration of repositories to different Business.
• Provided production support for the existing Business Objects contents and followed defect management process for defect resolution and change management process for any enhancements.
• Ability to quickly adapt to different project environments and an excellent team member.
• Possess excellent communication, decision-making, problem solving, analytical, and interpersonal skills, and Quick Learner with result oriented dedication towards goals.

TECHNICAL SKILLS

Business Intelligence: SAP Business Objects XI R4/R3/R2 6.5 & 5.1, (Designer, Information Design Tool (IDT), DeskI, WebI, Infoview, WebI Rich Client, Report Conversion Tool, Import Wizard, CMC, CCM, Upgrade Management Tool, LCM, Crystal Reports, BO Explorer, SAP BI 7.0

Data Modeling: Star-Schema Modeling, Dimensional Modeling, Snowflakes Modeling, FACT & Dimensions.

Visualizations Tool: Xcelsius 2008, SAP Dashboard Designer, Tableau 7.0.x/8.1.x/8.2.x

RBDMS: Oracle 11g/10g/9i/8i, My SQL, MS SQL Server 2008/2005/2000, MS Access 2003/2000/97, DB2, Toad, SQL Navigator

Languages: Sql, Pl/Sql

Operating Systems: Windows 2000 Server/ 2003/ XP, Windows Vista, Windows NT/2000

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Sr. SAP BI Consultant

Responsibilities:

• Worked as a BI Consultant in Installing and configuring BO XI 4.1 servers, along with configuring User groups, folder structures.
• Interacting with SME’s to understand the business requirements and change requirements during the course of the project
• Involved in administering BO CMC servers and implementing various security levels.
• Migration of BO content from BOXI R3 to BOXI R4 using Upgrade Management Tool.
• Develop Universe, Dashboards and reports using SAP BO 4.1 and testing.
• Functional testing of BO content in all the environments.
• Providing technical guidance and training the users on SAP BO 4.1
• Fixing of issues/defects of BO content which encountered after migration and capturing the same in Issue log document.
• Involved in designing and developing business objects WEB I reports against OLAP Universes using Information Design Tool and Universe Designer.
• Work closely with DBAs to create aggregate tables to support Universes and dashboard.
• Created performance analytics dashboards using Dashboard Designer using QAAWS connections.
• Standardized BI development by creating Design document, BI checklist, SQL checklist for developers.
• Involved in System testing, unit testing and UAT for deployed reports and Xcelsius, Live office dashboards.
• Created Training manuals for the deployed User reports and conducted Status meetings with developers.
• Training end users on Business objects ad hoc reporting techniques.
• Provide Migration approach and Test plan.
• Delegating work to team members and mentoring them.
• Providing Estimation on Development and Testing of Universe and Web I Reports.
• Perform root cause analysis for the challenging problems and to identify the alternative solutions.
• Preparing Technical design documents for Universe and WebI Reports.
• Provide UAT and Production Support.
• Tracking Project status and deliverables.
• Scheduling and Publishing of reports using Info view.
• Tracking the project progress and working towards meeting the project specific deadlines consistently.

Environment: SAP Business Objects XI 4.1, 3.1, Info view, WebI, CMC, CCM, Scheduling, Universe Designer, IDT, Upgrade Management Tool, Info Cubes, BEx Queries, SAP BW 7, Dashboard Designer, Oracle 11g and SAP BI 7.0

Confidential, Newark, NJ

Sr SAP Business Objects Developer

Responsibilities:

• Installing and configuring BO XI 4.1 servers, along with configuring User groups, folder structures.
• Interacting with SME’s to understand the business requirements and change requirements during the course of the project
• Develop Universe, Dashboards and reports using SAP BO 4.1 and testing.
• Involved in designing and developing business objects WEB I reports against Universes using Information Design Tool and Universe Designer.
• Implemented Default & Custom Hierarchies, conditions on LOV, Derived tables and @functions.
• Converting more than 400 reports from Desktop Intelligence to Web Intelligence in BOXIR4 using Report Conversion Tool.
• Created performance analytics dashboards using Xcelsius 2008 against Web I reports using live office.
• Migration of BO reports from BOXI R3 to BOXI R4 using Upgrade Management Tool.
• Involved in administering BO CMC servers and implementing various security levels.
• Involved in System testing, unit testing and UAT for deployed reports and dashboards.
• Created Training manuals for the deployed User reports and conducted Status meetings with developers.
• Training end users on Business objects ad hoc reporting techniques.
• Perform root cause analysis for the challenging problems and to identify the alternative solutions.
• Preparing Technical design documents for Universe and WebI Reports.
• Providing technical guidance and training the team on SAP BO 4.1
• Provide UAT and Production Support.
• Tracking Project status and deliverables.
• Standardized BI development by creating Design document, BI checklist, SQL checklist for developers.
• Scheduling of reports using Info view.
• Tracking the project progress and working towards meeting the project specific deadlines consistently.

Environment: SAP Business Objects XI 4.1, 3.1, Info view, WebI, DeskI, CMC, CCM, Scheduling, Universe Designer, IDT, Report Conversion Tool, Upgrade Management Tool, Dashboard Designer, Oracle 11g.

Confidential, San Francisco, CA

Sr SAP Business Objects / Tableau Developer

Responsibilities:

• Involved in Installation and configuration of BOXI 3.1 SP6 Servers and Client Tools.
• Interacted with business analysts in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module for generating reports.
• Created Classes, Objects, Prompts, Pre-defined conditions, cascading List of Values, Custom Hierarchies for drill down.
• Traps, Aliases and Contexts used to resolve the loops in the Universe.
• Applied security features of Business Objects like Row Level, Report Level & Object Level security in the universe so as to make the sensitive data secure.
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts Using different functionalities like Breaks, Filter, Sorts, Alerts, Section and Ranking to generate reports in WebI.
• Design and develop WEBI reports in BO 4.0 to evaluate new feature and functionality to support the future upgrade.
• Designed, developed, maintained and tested Universes for supporting adhoc queries.
• Migrated Universes and reports from development to Unit testing and production environments.
• Created parameterized Crystal reports and customized existing reports for presentations using Summary reports, Detail reports and Sub-reports.
• Worked with Crystal Reports for creating complicated reports including sub-reports, cross-tab reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Involved in Installation and configuration of Tableau Server and Desktop.
• Interacted with business representatives for requirement analysis and to define business and functional requirements.
• Creation and maintenance of users, user groups, roles, assigning security on projects/sites and Automation of Repository Backup and Mail notifications.
• Using TABADMIN commands to change the default configuration changes and Creating Audit dashboards to get the details about the USER activities and Server details.
• Create visually compelling and actionable interactive reports and dashboards and to manage ad hoc analytic requests from raw data through presentation quickly, efficiently and accurately.
• Extensively used hierarchies, attributes, measures, Calculations, Variables, Filters, Conditions, Sorting, Drill down, Parameters, Sets, Groups and Charts for creating Tableau reports.
• Demonstrate proficiency in analytics, trending, statistical analyses, interpretation of data and findings, and produce powerful visuals that present information in a meaningful and insightful way.
• Implemented Data level, Row Level and Column Level securities to restrict data.
• Preparing Test Case document, BRD and Technical design documents for Dashboards.

Environment: s: Business Objects 4.0/XI 3.1 SP6, Microsoft Sql Server 2008, Designer, Crystal Reports, Info View, SQL Developer, Tableau 7.1.x, 8.1.x, Vertica 5.1, Postgre SQL 9.1, Window 2003 Server.

Confidential, Newark, NJ

SAP Business Objects Developer

Responsibilities:

• Conducted Interactive sessions with the stake holders to understand and freeze the business requirements.
• Analyzing the report specifications.
• Created Classes, Objects, Measure objects, Joins, short cut joins, @prompts and predefined conditions in the universes.
• Defined Custom Hierarchies at Universe level to implement drill down functionality in the reports.
• Resolved loops in universes using Aliases and defining Contexts.
• Implemented Aggregate aware function and set up aggregate navigation with objects derived from standalone tables within the universes.
• Applied index aware functionality on non indexed column objects to increase the performance by directing the report query to select the index fields from the database for faster retrieval of data.
• Created Cascading Prompts at universe level for dynamic selection of data within a hierarchy as per the user requirement.
• Built drill-down reports using Scope of Analysis and drill filters functionality within Business Objects Web Intelligence.
• Created templates to customize style and structure according to the employer's needs.
• Conversion of reports from DeskI to WebI using Report Conversion Tool.
• Scheduling and Publishing of reports/Dashboards using Infoview.
• To troubleshoot the issues, understand the requirements, estimating the work efforts and distributing the work and ensured the deliverables are met in all the phases of the project.
• Designed BO universe for proper understandability of various sections of business.
• Provide production support for trouble - shooting issues on daily basis
• Making changes to BO reports as per change requests from users in the existing Universes/Reports.
• Modification of Universe and reports as per data model changes and testing and validating the same.
• Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats
• Preparation of Technical design document for Universe and reports.

Environment: Business Objects XI3.1(SP3), WebI 3.1(SP3), Java SDK, Designer, Info view, Crystal Xcelsius 2008, WebI Rich Client, Import Wizard, Report Conversion Tool, Oracle 10g, Toad, Windows XP.

Confidential, Newark, NJ

Business Objects Developer

Responsibilities:

• Involved in creating complex reports by using merge dimension.
• Created Ad hoc reports as per the client requirement.
• Design, Development and Maintenance of the Universe.
• Created Prompts using Designer module in Business Objects XIR2.
• Defined Custom Hierarchies according to user requirement.
• Used Version Control for checking in all versions of the objects used in creating the Joins in the Universe to keep track of the changes in the development, test and production environment
• Technical documentation of functional specifications and system design
• Created and maintained Universes using BO Designer.
• Created reports in Business Objects using functionalities such as Master/Detail, Slice and Dice, Cross Tab, Drill Down, Alerters, Breaks, Sorting, Ranking and Charts.
• Analyzed Database Tables and the joins present in between them.
• Supported the business users by resolving the tickets assigned within the given time.

Environment: Business Objects XIR2, (Info view, WebI, DeskI, CMC, CMS, Designer) Oracle 8, Windows XP.

Confidential

Business Objects Developer

Responsibilities:

• Involved in BOXI R2 Software Installation.
• Migration of all the 234 reports using Import Wizard in Business Objects XI R2.
• Conversion of Migrated Desktop Intelligence reports to WebI reports using Report Conversion Tool.
• Testing the report after Conversion process and Re developing the Not converted reports in Web Intelligence XI
• Preparation of check list for the conversion and Migration process.
• Preparation of Technical approach document for the Migration process.
• Scheduled the reports using Info view.
• Taking backup of all the servers with the help of Import Wizard using BIAR file.
• Involved in testing the Universe.
• Involved in testing the reports.
• Prepared Unit test cases for the Development, Migration and Conversion Phases as per the functional requirements.
• Testing reports and create test case and test results document.

Environment: BOXI R2, BO 5.1.7, Universe Designer, Import Wizard, DeskI, WebI, Report Conversion Tool, Oracle 10g, SQL Developer, Windows XP/2003 server.

Confidential

Business Objects Developer

Responsibilities:

• Design, Develop, Maintain and testing of the Universe.
• Designed new Universes and modified the existing Universes based on the report requirements.
• Uses of Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects, apply Contexts and Alias Tables to remove cyclic dependencies.
• Created Classes, Sub Classes, Dimension Objects, Measure objects in multiple universes, checked the Integrity of the Universes and exported the Universes to Repository to make them available to users.
• Involved in creating complex reports by using merge dimension.
• Generated the Business Objects Reports using the universe as the main Data providers and writing the complex queries including Sub queries, Unions, Intersect.
• Creating the Reports from Excel files using Business Objects through Personal data files
• Resolved Loops and Traps using the functionality of Aliases and Contexts.
• Created Ad hoc reports as per the client requirement.
• Preparation of Test case and Test results document.
• Prepared report guide to help the users understand the technical specifications and functionalities used to create, modify and test Universe, reports and metrics.
• Used Broadcast Agent for scheduling and distributing the documents.

Environment: BOXI R2, BO 5.1.7, Universe Designer, Import Wizard, DeskI, WebI, Report Conversion Tool, Oracle 10g, SQL Developer, Windows XP/2003 server.