Career Objective:

I have developed a wide range of Dashboards using Crystal Xcelsius 4.5, Xcelsius 2008 and Dashboard Designer. Including Connectivity to the databases for largecompanies, startup companies and small businesses. My core competency lays in complete end-end management of a Dashboard development projects,

Knowledge on SAB BW /BI :-

• Key focuses areas in Business Intelligence and Business Warehousing to enhance and improve business processes.
• Expertise 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.
• Good 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.
• Expertise 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.

Working as SAP BO Xcelsius dashboards developer: -

• Total 4.5 years of experience in a SAP Xcelsius dashboards developer and around 4 years of experience in 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 from flat files. Using Add-on components to create the Dashboards. Creaating user authentication for the dashbards.
• Excellent team player with good logical reasoning ability, coordination and interpersonal skills.

Educational Qualification:

• Master of Computer Applications.

Experience Summary:

• Organization : BIR Solutions India Pvt Ltd
• Designation : Software Engineer
• Duration : Jun 2007 - Till Date

Software skills:

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

SQL Server 2005/2008.

Windows 95/98/XP/Vista

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

Confidential,

Client

Confidential,USA.

Role

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 BI builders 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.
• Responsible for Conceptual design of the Dashboard.
• Involved in Data Connectivity to the data bases by using like Qaaws’s.
• Responsible for the Performance tuning of the Dashboard.
• Migration of the Dashboards from crystal xcelsius 4.5 to Xcelsius 2008 and Dashboard designer.
• Responsible for Designing the Dashboard according to Color style guide given by client.
• Responsible for Conducted Unit Testing of the Dashboard.
• Responsible for Change Requests of the existing Dashboards.

Confidential,

Client

Confidential,USA

Role

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:-

• PETCO 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 petco 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:-

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

Confidential,

Client

Confidential,USA.

Role

Duration

Dec2008- Oct2009

Team Size

5 Members

Environment

Crystal xcelsius 4.5,Xcelsius 2008,Excel 2003

Project Description:-

Business Objects 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:-

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

Confidential,

Confidential

Role

Duration

Nov2007-Nov2008

Team Size

9 members

Environment

Crystal Xcelsius 4.5, Web services, QAAWS.

Project Description:-
Information on Demand 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:-

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