Knowledge on SAB BW /BI :-

• Key focuses areas in Business Intelligence and Business Warehousing to enhance and improve business processes.
• Experince with SAP BI components including Data Source (OLTP-ECC, Flat files),Extract Structure, Extractors, Info Objects, Transformations, DTP, Loading Master data and Hierarchies, DSO, Info Cubes, Multi providers, Remote cubes, Open Hub, Process chains, Aggregates, Business content Enhancements, BEx Analyzer, BEx Browser, BEx Web reporting.
• Experience in extracting data from SAP & non-SAP systems. Sophisticated skills to work on Flat File Extraction, Generic Data Sources, BI Content Data Sources, Full and Delta Extraction Management.
• Experience in creating process chains, Data load management, Scheduling Start Process, event triggers, event chains.
• Worked on various kinds of Performance Tuning techniques such as compression, aggregates and rollups.

Professional Summary

• Total 4.5 years of IT experience in a SAP Xcelsius dashboards development and around 4 years of experience in SAP Business Objects. Created universes on the top of SAP BEx queries, By Using Single Sign on (SSN).
• Using Universe & Crystal Reports and Webi Reports as a Data source of Xcelsius to build the dashboards thru Use live office & QAAWS to getting the live data.
• Using SAP Netwear BW Connection to connect the SAP BEx queries into getting the data from Xcelsius Dashboards.
• Used Xcelsius Visualization of dashboards to pull the data from the required reports to Excel sheet by using Universe as data source. QAAWS & Web services, Live Office as a middle ware using Data feeding to Excel sheet. And analyzing, Designing and developing dashboards.
• Creation of Dashboards Converting Business Data requirements into Conceptual and logical data models. Commonly used excel functions ("VLookup, Hlookup, Index, Match and Conditional statements") Microsoft excel as a data source.
• Exported Dashboards to BOE Server Exported visualization contents to various file formats (pdf, ppt, and html, flash).
• Experience to developed Navigate the interface Creating Dynamic Dashboards. Data can be exposed different levels By Drill down functionality. Using these Reports the end user can analyze data at different levels like \'By age Group\', \'By Gender\' \'By Brand\' \'By Product\'.
• Maintenance, Migration, Testing, Change the color scheme for components in a dashboard. Dashboard gives the information of the Best 10 stores by Shrink (%), Worst 10 stores by shrink (%) by region.
• Applying Time standard Monthly Reports, Quarterly Reports – Annual Reports published by Revenue. Designed Dashboard Using SAP Xcelsius Tool. Using Add-on components to create the Dashboards. Creating user authentication for the dashboards.
• Excellent team player with good logical reasoning ability, coordination and interpersonal skills.

Educational Qualification

• Master of Computer Applications from Confidential University

Experience Summary:

• Organization : Confidential
• Designation : Software Engineer
• Duration : Jun 2007 - Till Date

Software skills:

Reporting Tools : Crystal Xcelsius 4.5, Xcelsius 2008, Dashboard Designer, Excel, QAAWS & Live Office, WSDL, XML Buttons etc. SAP Business Objects XI/R3, Webi, Info View, Universe Designer, Crystal reports.

Databases: SQL Server 2005/2008.

Operating systems: Windows 95/98/XP/Vista

Client side Scripts: Java Script.,

Key Skills

• Crystal Xcelsius 4.5,SAP Xcelsius 2008, SAP Dashboard Designer , Excel, QAAWS & Live Office,WSDL, XML Buttons etc.
• Web intelligence, Universe, Info view

Experience in Projects

Client:Confidential.

Role:SAP BO Xcelsius Developer

Duration:Oct2010 – Till date

Team Size:3 Members

Environment:Crystal Xcelsius 4.5,Xcelsius 2008, Dashboard Designer , Excel, QAAWS & Live Office,Webi,SAP Universe, WSDL, XML Buttons etc.

Project Description:-

The Confidential help organizations gain value from their corporate data by providing business intelligence solutions to enable more informed and timelier business decisions. They focus on business intelligence and performance management strategies, technologies, service and reporting. They are platinum partners of Business Objects.

Roles & Responsibilities:-

• Analyzing the Client Requirements and preparing the Dashboard specification document.
• Worked on modification of Universes.
• Developed Webi reports using various functions, operators, report filters and variables.
• Developed the WebI reports and created live office objects to these reports.
• Worked on Conceptual design of the Dashboard.
• Involved in Data Connectivity to the data bases by using like Qaaws’s.
• Worked on the Performance tuning of the Dashboard.
• Migration of the Dashboards from crystal xcelsius 4.5 to Xcelsius 2008 and Dashboard designer.
• Worked on Designing the Dashboard according to Color style guide given by client.
• Worked on Conducted Unit Testing of the Dashboard.
• Worked on Change Requests of the existing Dashboards.

Client:Confidential, USA

Role:Xcelsius Developer

Duration:Nov2009-Sep2010

Team Size:5 Members

Environment:Crystal Xcelsius 4.5,Xcelsius 2008, Dashboard Designer , Excel, QAAWS & Live Office,Webi,Universe, WSDL, XML Buttons etc.

Project Description:-CONFIDENTIAL is a chain of retail stores that offers pet supplies and services such as grooming and dog training. The main aim of this Project was to know the active and closed Confidential stores information. This dashboard gives complete analysis on Trend of Inventory Adjustment as a % to particular inventory of individual store by fiscal month and also comparison of this trend to the Average of Regional Trend and Average of Country Trend. This Dashboard gives the information of the Best 10 stores by Shrink (%), Worst 10 stores by shrink (%) by region.

Roles & Responsibilities:-

• Worked on analyzing the client Requirements.
• Worked on preparing the Dashboard specification Documents.
• Worked on conceptual design of the dashboard.
• Worked on Data connectivity to the data bases by using different methods like WSDLs, XML Buttons.
• Worked on performance tuning of the Dashboard.
• Worked on in Resolving the Data Connectivity Errors.
• Worked on in Designing of the Dashboard according to color guide given by client.

Client:Confidential, USA.

Role:Xcelsius Developer &Testing

Duration:Dec2008- Oct2009

Team Size:5 Members

Environment:Crystal xcelsius 4.5,Xcelsius 2008,Excel 2003

Project Description:-

Confidential has developed new version (Xcelsius 2008) to the existing Xcelsius version 4.5 with some additional features. This product was tested by BIR before releasing it to the Market. Product is tested in all aspects for the existing functionality in 4.5 and for the new functionality added to the latest version and also product is tested for the backward compatibility i.e. migration from lower versions to latest version.

Roles & Responsibilities:-

• Worked on preparing the test cases for the product testing based on the existing vs. new functionalities of the tool.
• Worked on preparing test design documents.
• Worked on test cases execution.
• Worked on testing of the product on different Operating systems.
• Worked on testing of the product for different connectivity options like WSDL, XML Buttons etc.
• Worked on preparing test summary report.
• Worked on the Development of Sample Dashboards to incorporate in the product.

Client:Confidential

Role:Xcelsius Developer

Duration:Nov2007-Nov2008

Team Size:9 members

Environment:Crystal Xcelsius 4.5, Web services, QAAWS.

Project Description:-
Confidential is an iStore maintained by Business Objects. This iStore provides different type of reports and dashboards to the Business People (End Users) on the basis of Buy and Subscribe. The main aim of this project was to develop and upload the CR Reports and dashboards in to Business Objects iStore (Server) from where the end users can buy and analyze the Reports. The Reports developed in this project gives complete analysis on eBay marketing at different products like DESKTOPS, LAPTOPS, CDs, DVDs, and AUDIO DEVICES etc. By using these Reports the end user can analyze data at different levels like \'By age Group\', \'By Gender\' \'By Brand\'. Administrative tasks are done in maintenance such as deploying the dashboards and reports to the testing server, after successful phase of testing we used to migrate those files to the production server.

Roles & Responsibilities:-

• Worked for analyzing the client Requirements.
• Worked on preparing the Dashboard specification Documents.
• Worked on conceptual design of the dashboard.
• Worked on generating WSDLs by using QAAWS based on the existing universes.
• Worked on the development of Dashboards.
• Worked on deployment of the Dashboards in IOD testing portal.
• Worked on deployment of the Dashboards in IOD production portal.
• Worked on migration of Dashboards from DEV environment to QA environment.
• Worked on the unit testing of the Dashboards.
• Worked on performance tuning of the Dashboard.
• Worked on in Resolving the Data Connectivity Errors.