Summary

• SAP Business Objects Developer with over 7+ years of experience in Business Intelligence using SAP Business Objects 4.0, XI-R3.1/R2/6.x with Info view, Web Intelligence, Universe Designer, Desktop Intelligence, Crystal Reports 9/10/XI/2008, Xcelsius 4.5/2008, Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management (CCM), Query as a Web Service, Live Office, BI Web Services, Publishing Wizard, Import Wizard, Report Conversion Tool and Broadcast Agent.
• Extensively worked on Business Objects Architecture & Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Reports in CMC on Daily, Monthly, Weekly basis.
• Strong knowledge and skills on Data Integrator & Data Quality Tools such as Data Warehouse Concepts including Schemas and Data Modeling.
• Complete knowledge on Software Development Life Cycle experience including requirements gathering, analysis/design, development and testing.
• Experience in building multiple universes, retrieving data using universes, personal data files, and creating complex ad-hoc reports using the Business Objects universe and Web Intelligence/Desktop Intelligence tools.
• Experience on working with multiple databases like MS SQL Server 2008/2005/2000/7.0, Oracle 11g/10g/9i/8i/8.0/7.x, Teradata 12.0/V2R5, DB2 400, and MS Access, MS Excel.
• Worked on various BO environments linking data from multiple sources, applying several functionalities, and using various Data Providers
• Excellent experience in designing Business Objects universes, complex BO reports in both Infoview and Web Intelligence Rich Client.
• Extensively used ETL methodology for Data Extraction, transformations, loading using Data Integrator.
• Used Live Office and QAAWS (Query as a Web Service) and BI Web Services to feed live data into Xcelsius 2008 for dashboard creation.
• Strong SAP ECC Knowledge in SAP ECC 6.0 (FICO,MM,PP,SCM,SD)
• Strong organizational, time-management and planning skills to deliver projects on time/budget, despite intense pressure and aggressive timelines.
• Excellent communication, interpersonal, training, analytical and technical skills. Quick learning capacity and positive attitude towards new challenges.

Technical Skills

BI Tools:

SAP Business Objects 4.0, XI 3.1, R1/R2 6.5.x, Info view, CMC, CCM, CMS, Desktop Intelligence, Web Intelligence, Xcelcius 4.5/2008, Live office, QWAAS, BI Web Services, Crystal Report 9/10/ XI/ 2008, BEx Query, Business View Manager, SAP ECC 6.0, SAP BI/BW 7.0

RDBMS:

Oracle 11g/10g/9.x/8.x/7.x/5.x, SQL Server 2000/2005/2008, MS Access 2000, DB2/400, Tera-data12.0/V2R5.

Languages:

C, C++, SQL, PL/ SQL.T-SQL, Java (B)

Products:

SAP ECC 6.0/ BOBJ, SAP BI/BW 7.0, Microsoft Office

Operating
System:

Windows (all flavors), UNIX.

Education

• Bachelors of Technology in Mechatronics Engineering

PROFESSIONAL EXPERIENCE

Confidential,Cincinnati, OH Apr 2012-Present
Business Objects/Xcelsius Developer

Confidential, is a banking, financial services technology and payment procedure company which works with financial institutions to develop programs and tools to simplify payment strategies.The company’s cardsolutionsinclude credit cards, debit cards, prepaid cards, card production, card protection, management and reporting, rewards, portfolio management, electronic couponing and mobile banking.

Responsibilities:

• Interacted with Business Clients and gathered requirements, designed the layout of the project, worked closely with the data architect and worked on development, validating and migrating onto production environment to go live.
• Worked on Business Objects XI 3.1, built universes and created prompts using cascading prompts, developed various filters for current year transactions, projections and forecast of the financial data for different set of filters as, previous completed 3 months, current year, current month and as of today.
• Used Derived Tables, @Aggregate Aware, @Index Aware, in the Universe using views to meet the Reporting Requirements.
• Encountered issues in Universe with Chasm Traps, Fan Traps and Loops and resolved the issue by using context or alias table.
• Developed web intelligence reports for different set of requirements in Info view. Worked on merged queries and created new variables in order to obtain calculations for different set of row types.
• Extensively used Calculations, Variables, Breaks, Sorters, Alerts, and Drill Downs for creating Business Objects reports.
• Worked on complex web intelligence reports to create variables using different @functions, @page functions.
• Generated BI Web Services link through Web Intelligence Rich client tool, from the generated web intelligence reports.
• Used BI Web Services links in xcelsius 2008 and used as a web connection to connect web intelligence reports as source data.
• Linked the WSDL links to particular trigger cells and assigned them to the data blocks.
• Developed 3 different dashboards which show the performance of the financial revenue the company generates on the daily basis depending upon the current year, prior year transactions and sales volume for the actual, forecast and projection data.
• Developed dashboards on drill down scale using the accordion menu for filtering deep into the data for particular sectors.
• Created Dashboards for using performance manager to enable and execute track progress and compare current and historical performance against established targets.
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008.
• Involved in Maintenance of Business Objects universes and reports, WSDL links and dashboards from Server to Server on the deployment.
• While migrating the dashboards, had to recreate all the WSDL links pointing to production server and re-map them to the data blocks.
• Maintained two same versions of dashboards for production and test environment for better performance of dashboards.
• Involved in enhancing the performance of the slow running reports.
• Deployed Business Objects Universes , Reports and Dashboards in a Secure Environment from One Server to Other Servers using Import Wizard and BIAR files
• Excellent knowledge in analyzing system needs, discuss desired function with upper management, and successfully interchanged programs to meet the needs of the organization and project deadlines.

Environment: SAP Business Objects XI 3.1 (CMC, CMS, CCM, Designer, Web Intelligence, Info View, Dashboard Manager, Performance Manager, Import Wizard, Xcelsius 2008, Crystal Reports 2008, SAP Data Integrator 12.2, TOAD, XML, Broadcast Agent, Oracle 11g/10g , DB2, SQL Server 2005/2008, Teradata12.0, TOAD, UNIX, Tomcat Server and Windows XP environment.

Confidential,Orlando, FL Jan 2012-Apr 2012
Business Objects Developer

Confidential,together with subsidiaries and affiliates is a leading international family entertainment and media enterprise with five business segments: media works, parks and resorts, studio entertainment and consumer products.

Responsibilities:

• Worked on the Report Conversion project which involved in installing the SAP Business Objects 3.1, Web intelligence and Broadcast Agent Server.
• Interacted with Business Users to determine the requirements and problems with the fully converted reports.
• Involved in Analysis, Development, Testing, and Maintenance and Resolved problems during Migration.
• Involved in creating the Repository, creating users, user groups and assigned privileges to the users using Supervisor.
• Involved in creating different set of folders in the CMC in order to archive the desktop intelligence reports, user required web intelligence reports and partially converted reports for different set of departments.
• Converted reports from Desktop Intelligence XI 3.1 to Web Intelligence 4.0 using Report conversion Tool
• Not converted reports from Report Conversion Tool were again re-created to Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Provided technical assistance/support to analysts, business users and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Created user defined objects including dimensions and measures for complex financial calculations.
• Prepared user documentation for hands on training of end user community and mainted clear documentation on the progress of the project on a shared drive on citrix in order to have clear idea on the target to achieve.
• Designed application by integrating product knowledge with client requirements.
• Synchronized reports using data from multiple data providers in Web Intelligence 4.0 by merged dimensions functionality.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, master/detail, cross tab, charts and alerts for creating Business Objects reports.
• Checked the integrity of the Universe schema for any errors in objects, joins, conditions, loops and cardinalities of the Universe which were causing the reports to be partially converted.
• Enhanced reports which included standardizing format of report content, redefining query filters and prompts, linking summary report to a set of detail reports.
• Used @Functions such as @Prompt to restrict return values and to enter prompt, @Select- to reuse the select statement of another object, @Variable- to restrict the currently logged user etc.
• Migrated Universes/Reports from Development to Test environment and finally into Production environment after UAT (User Acceptance Testing) using Import Wizard.
• Strictly followed the Release Management schedule as per client guidelines.
• Scheduled the Web Intelligence reports using the CMC by creating event based triggers

Environment: SAP Business Objects 3.1, 4.0, Web intelligence, Report Conversion Tool, Import Wizard, Supervisor, Broadcast Agent, SQL server 2008, Windows XP server.

Confidential,Nashville, TN Oct 2011 - Dec 2011 Business Objects Developer

Confidential,is the service revenue performance company. They partner with technology-based companies to maximize maintenance, support, and subscription revenue while optimizing customer loyalty. Service Source addresses the critical steps of renewal process, including data management, quoting and renewal of business intelligence. Client satisfaction is at the top priority, which includes having consistent communication and providing them with a variety of customized reports. Once the client’s reporting needs are understood, the reports are generated.ing service revenue, profitability and customer
Responsibilities:

• Interacted with Business Clients and also worked as a Business Analyst to gather and document the Requirements and translate these to Technical specifications.
• Responsible for defining BO XIR2 best practices for Production Administration Support for Universes, Reports( Desk I , Web I) change management, impact analysis , monitoring user activities security, backup and recovery process and procedure.
• Preformed Business Objects XI upgrades and Migration from DEV, TEST to PROD Environments.
• Resolved the issues related to Universes and Reports in the process of migration from 6.5 to XI R2.
• Designed and modified the Universes, which suits the standard, analytical reporting requirements of the business users using BO XI Designer application.
• Analyzed the existing database schema, retrieved the Fact and Dimension tables and created joins as identified in the Universe design.
• Defined Cardinalities on tables manually in the universe and resolved the loops using Aliases and Contexts joins. Implemented standard and best practices for Business Objects XI R2 environment.
• Created new Classes, Sub-classes and Objects as per the standards that were put in place during the Strategy process and identified Objects as Dimensions, Details or Measures.
• Created List of Values (LOV’s) and custom Hierarchies to support drilling functionality for in depth analysis in reports.
• Used WEBI, Reporter and Explorer for querying, reporting and analysis tasks.
• Extensively used Calculations, Variables, Breaks, Sorters, Alerts, and Drill Downs for creating Business Objects reports.
• Generated complex Financial Business Unit Performance Web Intelligence documents with multiple tabs per document by writing complex queries.
• Prepared many critical Web Intelligence reports by using master detail and drill mode on tables and graphs as per the requirements of the end-user.
• Migrated Universes/Reports from Development to Test environment and finally into Production environment after UAT (User Acceptance Testing) using Import Wizard.
• Strictly followed the Release Management schedule as per client guidelines.
• Scheduled the Web Intelligence reports using the CMC by creating event based triggers.

Environment: SAP Business Objects XIR2(CMC, CMS, CCM, Designer, DeskI, Web Intelligence, Info View, Dashboard Manager, Performance Manager, Import Wizard), Business Objects 6.5.4(Supervisor, Designer, Reporter, Web Intelligence), Broadcast Agent, Crystal Reports, Xcelsius 2008, Oracle 9i,10g ,SQL Server 2005, TOAD, SQL, PL/SQL, UNIX, Windows 2007 Server.

Confidential,Wilmington, DE Jan 2011 - Oct 2011
Business Objects Developer

Confidential, serves over 500 travel destinations in 30 plus routes across North America for travelers. The reports generated measure the performance against the predetermined financial specifications. Once the company’s reporting needs are understood, the reports are produced according to the company’s requirements.

Responsibilities

• Developed the technical specifications based on functional Specs.
• Understood the AMTRAK AS-IS process followed for budget formulation.
• Working with different transformations like Query, Key Generation, Pivot, Map operation, Table Comparison in Data Integrator.
• Migrated user reports and universes from Business Objects 6.5.4 to Business Objects XI R3.
• Managed the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.
• Implemented Standards and best practices for Business Objects XI R3 environment.
• Defined BO XI R3 user security model, users, groups, Universe Security Authentication and Active Directory.
• Created and maintained users and user groups to use within multiple Global projects for both application and data level security.
• Management of content and data migration through Development, QA and Production environments.
• Used Derived Tables, Aggregate Aware, Index Aware, in the Universe using views to meet the Reporting Requirements.
• Used WEBI, Reporter and Explorer for querying, reporting and analysis tasks.
• Extensively used Calculations, Variables, Breaks, Sorters, Alerts, and Drill Downs for creating Business Objects reports.
• Migrated Universes/Reports from Development to Test environment and finally into Production environment after UAT (User Acceptance Testing) using Import Wizard.
• Strictly followed the Release Management schedule as per client guidelines.
• Scheduled the Web Intelligence/CR reports using the CMC by creating event based triggers.
• Worked in collaboration with Project Manager, Business Analyst, Data Analyst, Solution Architect, BI Developer, DBA to deploy the reporting solutions.
• Handled Embedded Functions like @Prompt, @Select, @Where in the Designer.
• Involved in the designing and building of the Universes, Classes and objects for the client requirements.
• Created Web I reports with multiple data providers and synchronized the data using Merge Dimensions option in BO XI R3.
• Generated web intelligence reports on Business objects latest version 4.0.
• Developed Crystal Reports utilizing existing Business Objects Universes as data provider. Created complex Xcelsius dashboards. Used Crystal Reports XI advanced features like Dynamic and cascading prompts, command objects for building reports.
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008.
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using Xcelsius 2008.
• Worked on trouble shooting all the issues in Crystal Enterprise and Business Objects Enterprise.
• Involved in Maintenance of Business Objects universes and reports from Server to Server on the deployment.
• Interacted with Business Users and Business Analysts to gather Information to enhance the Universe/Reports accordingly.
• Involved in enhancing the performance of the slow running reports.
• Created Default users using Central Management Console for the Application to verify the Reports.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard and BIAR files
• Excellent knowledge in analyzing system needs, discuss desired function with upper management, and successfully interchanged programs to meet the needs of the organization.

Environment: SAP BOBJ XIR3(CMC, CMS, CCM, Designer, Desk I, Web Intelligence, Info View, Dashboard Manager, Performance Manager, Import Wizard),Crystal 2008, Business Objects 6.5.4(Supervisor, Designer, Reporter, Web Intelligence), Business Objects 4.0, SAP Data Integrator 12.2, TOAD, XML, Broadcast Agent, Crystal Reports Enterprise Edition XI, Crystal Reports 2008, Xcelsius 2008 , Oracle 9i/10g ,DB2,SQL Server 2005/2008, Tera- data12.0, TOAD, UNIX, Windows 2003 Server.

Confidential,IN Nov2009 - Dec2010
Business Objects Developer

Confidential,is a leading, innovation-driven corporation committed to developing a growing portfolio of best in class and first-in-class pharmaceutical products that help people live longer, healthier and more active lives. Lilly products treat depression, schizophrenia, attention-deficit hyperactivity disorder, diabetes, osteoporosis and many other conditions. Customer satisfaction is at the top priority, which includes having consistent communication and providing them with a variety of customized reports. The product data is used in order to generate reports on the sales performance of the product. These reports measure the performance against the predetermined quality specifications. Once the costumer’s reporting needs understood, the reports produced according to the customer’s requirements. The data

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the requirements and translate these to Technical specifications.
• The product data is used in order to work on the sales performance of the respective products
• Created several Universes using Designer according to the requirement.
• Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.
• Improved the performance with the use of @function (@aggregate aware, @select, @prompt, @where)
• Defined Alias and Contexts to resolve loops and tested them to ensure that correct results are retrieved.
• Created new classes, objects and made structural changes to Universes/ Metric Universes in Designer, which includes adding new objects, updating tables and joins
• Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.
• Created filter objects, and formatted objects and measures within the universe for faster report generation, created Measure class for measures, and created separate class for conditional objects.
• Setting up the security levels to the users in universe module like row level and column level security.
• Involved in CMC (Security Administration) and User administration
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master Detail and Formulas etc
• Implemented Dashboard Manager & Performance Manager for dashboards & Scorecards
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Generated Reports from Different Data Providers in Business Objects using Oracle Database.
• Developed different types of reports using Desktop Intelligence, Web Intelligence, Crystal Reports and Xcelsius 2008.
• Created dashboards using live office connection using Xcelsius 2008.
• Documented all the changes made to the Universes and Reports for future references.
• Exported the universe to the Repository to make resources available to the users
• Scheduled the universes on daily, monthly and weekly by using Scheduler
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Trained end users to use various functionalities of Business Objects and provided technical support.

Environment: SAP Business Objects XI R2 (DeskI, WebI, Designer and Infoview), Crystal Reports 2008, Xcelsius 2008, Oracle 10g, Windows.

Confidential,is a thought leader in pharmacy benefit management strategies. Our strategic partnership with Blue Cross and Blue Shield plans uniquely positions us to benefit our clients with clear contract terms, competitive rates and the full discount from our pharmacy network. Created clear financial value reflecting total health costs and synchronizes pharmacy and medical programs for total health care management

Responsibilities:

• Worked with customer service based group and involved in modifying existing Universe and created various canned and ad-hoc reports
• Involved in gathering end-user requirements to modify and create reports.
• Created complex report variables
• Exporting & importing universes across different domains and keeps maintaining universe versioning.
• Created standard and ad-hoc reports and published the standard reports on to the repository.
• Used prompts in the reporter level to create more interactive reports.
• Used business objects functionalities like break, sort, alerter, filter and condition.
• Used aggregate awareness in universe to tune the performance
• Scheduled Full client reports and thin client reports using BCA
• Linked different data providers and used sub queries in reports
• Published and scheduled Business Objects Reports to users using Scheduler.
• Developed complex reports using @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters), @Select and Cross Tab tables
• Analyzed reports using Slice and Dice, Drill down and Master Detail
• Worked with the customers to resolve various issues associated with the reports.

Confidential,Hyderabad, India Sep 2006 – June 2008
BOBJ Developer
Project Details: - Worked for Several Clients who needed a Semantic layer and easy platform to Query and get reports to answer several questions regarding their Business. So mainly set up Roles, Rights, Build Universes, and designed reports to provide better interaction and better Data Visualization.

Responsibilities:

• Created & Modified Universes for various functional areas of high level reports group using Designer.
• Customized LOVs in Universes for quicker performance of reports. Created Joins, Contexts, and Aliases for resolving Loops & Universe Tuning and checked the Integrity of the Universes.
• Used SQL against the database to check data retrieved.
• Changed the universe parameter settings to optimize the performance of universe.
• According to the customer information created complex report using Universe as main data provider.
• Exported the universes to the Repository making resources available to the users.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom sorts, Cross Tab, and Formulae\'s etc.
• Created reports according to different requirements Such as Summary Charts etc Using Wizards and Web intelligence2.x.
• Exported the Reports to the Broadcast Agent and used the Broadcast Agent server to Schedule and Monitor the Reports.
• Used Supervisor, Info View to manage Users etc.
• Various Programming tasks included developing Reports using free hand PL-SQL, and T-SQL procedures.
• Created reports using Crystal Reports 9/10 with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Created various analytical reports like Market Share, Trending, Rank reports from multiple data providers. Interacted with the various users for reporting requirements.
• Provided end user support and problem resolution for various issues related to BO.
• Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.

Environment: Business Objects (Designer, Reporter) 6.1, Supervisor, Broadcast Agent, Crystal Reports, Oracle 9i, PL/SQL, T-SQL, Web intelligence2.x.