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, Dashboards 4.0, Central Management Console CMC , Central Management Server CMS , Central Configuration Management CCM , Query as a Web Service, Live Office, BI Web Services, Query Browser, Publishing Wizard, Import Wizard, Report Conversion Tool and Broadcast Agent.
• Extensively worked on Business Objects 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.
• Complete knowledge on Software Development Life Cycle experience including requirements gathering, analysis/design, development and testing.
• 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.
• Strong knowledge and skills on Informatica, Data Integrator and Data Warehouse Concepts including Schemas and Data Modeling.
• 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 Info view 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, Query Browser to feed live data into Xcelsius 2008 for dashboard creation.
• Experience working on PL/SQL, and using Stored Procedures in Crystal Reports 2008
• 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

PROFESSIONAL EXPERIENCE

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, Dashboards 4.0, Central Management Console CMC , Central Management Server CMS , Central Configuration Management CCM , Query as a Web Service, Live Office, BI Web Services, Query Browser, Publishing Wizard, Import Wizard, Report Conversion Tool and Broadcast Agent.
• Extensively worked on Business Objects 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.
• Complete knowledge on Software Development Life Cycle experience including requirements gathering, analysis/design, development and testing.
• 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.
• Strong knowledge and skills on Informatica, Data Integrator and Data Warehouse Concepts including Schemas and Data Modeling.
• 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 Info view 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, Query Browser to feed live data into Xcelsius 2008 for dashboard creation.
• Experience working on PL/SQL, and using Stored Procedures in Crystal Reports 2008
• 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

PROFESSIONAL EXPERIENCE

Confidential

Business Objects/Dashboards Developer/Analyst

• Confidential is the leading source of residential mortgage credit in the Confidential
• secondary market, helping to build a sustainable housing finance system.

Responsibilities:

• Interacted with Business Users to determine the requirements and problems for the manual reports that need to be automated.
• Involved in Analysis, Development, Testing, and Maintenance and Resolved problems during SLDC process of a release.
• 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 maintained clear documentation on the progress of the project.
• Involved in gathering end-user requirements to modify and create reports.
• Created standard and ad-hoc reports and published the standard reports on to the
• 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, master/detail, cross tab, charts and alerts for creating Business Objects reports..
• Enhanced reports, which included standardizing format of report content, redefining query filters and prompt, linking summary report to a set of detail reports.
• 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 LCM.
• Scheduled the Web Intelligence reports using the CMC by creating event-based triggers.
• Used Xcelsius 2008 for enterprise dashboards.
• Worked on tableau 8.0 and tableau 8.2 for reports and dashboards
• Developed dashboards, which show the performance of the financial revenue the company generates on the daily basis depending upon the current year, prior year for different set of top 25 clients.
• Developed dashboards on drill down scale using the accordion menu for filtering deep into the data for particular sectors.
• Involved in Maintenance of Business Objects universes and reports, WSDL links and dashboards from Server to Server on the deployment.
• Strictly followed the Release Management schedule as per client guidelines.

Environment: SAP Business Objects XI 3.1 CMC, CMS, CCM, Designer, Web Intelligence, Info View, Dashboard Manager, Performance Manager, Import Wizard , SAP Business Intelligence 4.0 suite, Xcelsius 2008, SQL server 2008, TOAD, Tableau 8.0/8.2, Oracle 11g/10g, DB2, SQL Server 2005/2008, Teradata12.0, and Windows XP, 2007 environment.

Confidential

Business Objects/Dashboards Developer

The Confidential Worldwide Company, together with subsidiaries and affiliates is a leading ad agency and media enterprise.

Responsibilities:

• 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.
• 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 maintained clear documentation on the progress of the project.
• 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, 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 LCM.
• Scheduled the Web Intelligence reports using the CMC by creating event based triggers.
• Used Query Browser connections in Dashboards 4. 0 as source data.
• Linked the WSDL links to particular trigger cells and assigned them to the data blocks.
• Worked on mobile dashboards for BI 4.0 using HTML 5, and SAP app on iPad
• Created components compatible only on mobile for the mobile version.
• Developed dashboards which show the performance of the financial revenue the company generates on the daily basis depending upon the current year, prior year for different set of top 25 clients.
• Developed dashboards on drill down scale using the accordion menu for filtering deep into the data for particular sectors.
• Involved in Maintenance of Business Objects universes and reports, WSDL links and dashboards from Server to Server on the deployment.

Environment: SAP Business Intelligence 4.0 suite, Dashboards 4.0, LCM, Query Browser, SQL server 2008, Windows XP server, Windows 2007.

Confidential

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 card solutions include 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.
• Importing Source/Target tables from the respective databases and created reusable transformations and mappings using Designer tool set of Informatica.
• Worked on the Change capture concepts, Change capture deletes, Auxiliary change capture process, and Slowly changing dimensions using the IMAGE Table Concepts
• Error Handling and debugging using Informatica Debugger.
• Scheduled Workflows Using Workflow Manager Workflow Monitor.
• Involved in code review.
• Developed test plans, test cases and conducted Unit testing to check for the expected results.
• 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, Informatica 8.6.1, Oracle 11g/10g , DB2, SQL Server 2005/2008, Teradata12.0, TOAD, UNIX, Tomcat Server and Windows XP environment.

Confidential

Business Objects Developer

The ConfidentialCompany, 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.
• Provided technical assistance/support to analysts, business users and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• 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

Business Objects Developer

Confidential serves over 500 travel destinations in 30 plus routes across Confidential 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

• Interacted with Business Users and Business Analysts to gather Information to enhance the Universe/Reports accordingly
• 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.
• 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 WebI reports with multiple data providers and synchronized the data using Merge Dimensions option in BO XI R3.
• 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.
• Worked on integration SAP BW and SAP BOBJ.
• Created BEX queries on Business warehouse and created reports out of it.
• 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.
• Involved in enhancing the performance of the slow running 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 BW, 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

Business Objects Developer

Confidential and Company 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. 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.

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
• 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.
• 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
• 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

Business Objects Developer

Confidential strategic partnership with Blue Cross and Blue Shield plans unique positions 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.

Environment: Business Objects XI R2, Supervisor, Web Intelligence, Desktop Intelligence, Import wizard, SQL 2005, Oracle 10g, Windows XP.

Confidential

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.
• 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.
• 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.

Confidential is the leading source of residential mortgage credit in the Confidential

secondary market, helping to build a sustainable housing finance system.

Responsibilities:

• Interacted with Business Users to determine the requirements and problems for the manual reports that need to be automated.
• Involved in Analysis, Development, Testing, and Maintenance and Resolved problems during SLDC process of a release.
• 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 maintained clear documentation on the progress of the project.
• Involved in gathering end-user requirements to modify and create reports.
• Created standard and ad-hoc reports and published the standard reports on to the
• 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, master/detail, cross tab, charts and alerts for creating Business Objects reports..
• Enhanced reports, which included standardizing format of report content, redefining query filters and prompt, linking summary report to a set of detail reports.
• 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 LCM.
• Scheduled the Web Intelligence reports using the CMC by creating event-based triggers.
• Used Xcelsius 2008 for enterprise dashboards.
• Worked on tableau 8.0 and tableau 8.2 for reports and dashboards
• Developed dashboards, which show the performance of the financial revenue the company generates on the daily basis depending upon the current year, prior year for different set of top 25 clients.
• Developed dashboards on drill down scale using the accordion menu for filtering deep into the data for particular sectors.
• Involved in Maintenance of Business Objects universes and reports, WSDL links and dashboards from Server to Server on the deployment.
• Strictly followed the Release Management schedule as per client guidelines.

Environment: SAP Business Objects XI 3.1 CMC, CMS, CCM, Designer, Web Intelligence, Info View, Dashboard Manager, Performance Manager, Import Wizard , SAP Business Intelligence 4.0 suite, Xcelsius 2008, SQL server 2008, TOAD, Tableau 8.0/8.2, Oracle 11g/10g, DB2, SQL Server 2005/2008, Teradata12.0, and Windows XP, 2007 environment.

Confidential

Business Objects/Dashboards Developer

The Confidential Worldwide Company, together with subsidiaries and affiliates is a leading ad agency and media enterprise.

Responsibilities:

• 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.
• 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 maintained clear documentation on the progress of the project.
• 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, 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 LCM.
• Scheduled the Web Intelligence reports using the CMC by creating event based triggers.
• Used Query Browser connections in Dashboards 4. 0 as source data.
• Linked the WSDL links to particular trigger cells and assigned them to the data blocks.
• Worked on mobile dashboards for BI 4.0 using HTML 5, and SAP app on iPad
• Created components compatible only on mobile for the mobile version.
• Developed dashboards which show the performance of the financial revenue the company generates on the daily basis depending upon the current year, prior year for different set of top 25 clients.
• Developed dashboards on drill down scale using the accordion menu for filtering deep into the data for particular sectors.
• Involved in Maintenance of Business Objects universes and reports, WSDL links and dashboards from Server to Server on the deployment.

Environment: SAP Business Intelligence 4.0 suite, Dashboards 4.0, LCM, Query Browser, SQL server 2008, Windows XP server, Windows 2007.

Confidential

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 card solutions include 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.
• Importing Source/Target tables from the respective databases and created reusable transformations and mappings using Designer tool set of Informatica.
• Worked on the Change capture concepts, Change capture deletes, Auxiliary change capture process, and Slowly changing dimensions using the IMAGE Table Concepts
• Error Handling and debugging using Informatica Debugger.
• Scheduled Workflows Using Workflow Manager Workflow Monitor.
• Involved in code review.
• Developed test plans, test cases and conducted Unit testing to check for the expected results.
• 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, Informatica 8.6.1, Oracle 11g/10g , DB2, SQL Server 2005/2008, Teradata12.0, TOAD, UNIX, Tomcat Server and Windows XP environment.

Confidential

Business Objects Developer

The ConfidentialCompany, 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.
• Provided technical assistance/support to analysts, business users and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• 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

Business Objects Developer

Confidential serves over 500 travel destinations in 30 plus routes across Confidential 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

• Interacted with Business Users and Business Analysts to gather Information to enhance the Universe/Reports accordingly
• 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.
• 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 WebI reports with multiple data providers and synchronized the data using Merge Dimensions option in BO XI R3.
• 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.
• Worked on integration SAP BW and SAP BOBJ.
• Created BEX queries on Business warehouse and created reports out of it.
• 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.
• Involved in enhancing the performance of the slow running 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 BW, 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

Business Objects Developer

Confidential and Company 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. 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.

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
• 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.
• 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
• 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

Business Objects Developer

Confidential strategic partnership with Blue Cross and Blue Shield plans unique positions 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.
• Environment: Business Objects XI R2, Supervisor, Web Intelligence, Desktop Intelligence, Import wizard, SQL 2005, Oracle 10g, Windows XP.

Confidential

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.
• 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.
• 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.