Summary

• Over 8+ years of experience as Software Engineer with solid experience in all phases of Software Development Life Cycle that includes Requirements, Design, Development, Testing, Implementation and Support.
• Hands on experience in building systems using Business Objects(BOBJ), Crystal Reports, SAP Business Explorer(Bex), SAP Query, SAP Infoproviders etc.
• Hands on experience in developing reports out of SAP BW.
• Experienced working with Universe Builder to build OLAP Universes from SAP BW data source like InfoCubes and BW Query.
• Experienced in working with Business Managers, Architects, End users and all the stake holders in documenting requirements, providing estimates, creating High and Detail Level design specifications.
• Hands on experience in administering BusinessObjects Enterprise, Crystal Enterprise.
• Thorough knowledge on BusinessObjects Enterprise Architecture.
• Extensive experience in using databases like Oracle, SQL Server, Sybase, MS Access etc.
• Extensive experience in writing Stored procedures, Triggers, Complex Queries, Sub Queries etc. using PL/SQL.
• Experienced in BusinessObjects (XIR3.1/XIR2/6.x/5.x), Designer, Universe Builder, Desktop intelligence, Web Intelligence, Crystal Reports and Business Objects Enterprise suite.
• Experienced in ETL tools like SAP BW, BusinessObjects Data Integrator, Informatica PowerCenter, SQL Server Analysis Services etc.
• Experienced in creating Dashboards using BusinessObjects Xcelsius.
• Expertise in Data Modeling using Multi Dimensional Model and BW Star Schema.
• Extensive knowledge on Data Warehousing concepts like Fact and Dimension design using Star Schema.

Education – Bachelors of Engineering, JNTU, India

OLAP Tools

• SAP Business Objects (XIR1/ R2/ R3/ R3.1) : Business Objects Universe Designer, Desktop Intelligence, Web Intelligence, WebI Rich Client, Universe Builder, Dashboard Manager, Voyager, QAAWS, Central Management Console, Info View, Import Wizard, Report Conversion tool, Report Comparison Tool, Live Office,
• Business Objects (5.0, 5.1.x, 6.x), Designer, Desktop Intelligence, Web Intelligence, Broadcast Agent.
• Crystal Reports 9/10/XI/2008
• Xcelsius 4.5, Xcelsius 2008
• SAP: Business Explorer(Bex), SAP Query, SAP Infosets, QuickViewer, Cognos Impromptu.

ETL Tools

BusinessObjects Data Integrator, SAP BW 3.0B/3.1C/3.5/BI7, Informatica Powercenter.

Programming Languages

PL/SQL, Transact-SQL, Shell Scripting, Perl, SAP ABAP, Java, J2EE, Advanced C, C++, COBOL, C# .NET, VB .NET, and ASP.NET.

Databases

Oracle 8/8i/9i/10g/11g, SQL Server 2000/2005/2008, Sybase, MS Access and IBM DB2, Apache Web Server, Tomcat.

Operating Systems

Windows NT, Windows 95/98/2000/XP, Linux, IBM AIX, Unix

ERP

SAP R/3 4.x

Client : Confidential,
New York, NY July 2010 – Till Date
Role : SAP BusinessObjects(BOBJ)/BI Consultant

Responsibilities:

• Worked with Business Managers, Architects and End users in documenting requirements, providing estimates, creating High Level Design and Detail design specifications.
• Worked on Migration of reports (WEBI, Crystal and XCelsius) from version XIR2 and XIR3. Unit tested the reports for compatability and fixed the issues that occurred during migration.
• Worked with migration project team (Project Manager, Business Objects Administrator and Testers) to identify and fix migration issues.
• Worked extensively on developing procedures,triggers,views on SQL server database.
• Designed and maintained Universes and exported them to the repository.
• Developed various reports using Desktop Intelligence and Web Intelligence using existing Universes.
• Extensively worked on WEBI and Crystal reporting using SAP BW Objects (BW Query, InfoCube and Multiprovider ) as data sources.
• Well versed with SAP BI Query Development and ETL process.
• Experience in both SAP BI Backend (ETL process, Data loading, Production Suport etc) and SAP Front End (Query Designer, Bex Variables, Calculated and Restricted Key Figures etc)
• Extensively used Xcelsius to build Dashboard reports for top level management. Used the new SAP plugin to connect SAP BI queries to directly connect with XCelsius.
• Responsible for designing the universes by creating the Business Objects data model selecting/joins, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
• Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
• Created different types of reports like Master/Detail, Cross Tab and Chart.
• Developed various full client and thin client reports using Business Objects and Web Intelligence.
• Widely used Drill mode and Slice and Dice techniques to modify the reports in accordance with the user’s analysis needs.
• Worked extensively on Bex Designer, Web Intelligence(webi), Desktop Intelligence(Deski), Crystal reports and Central Management Console(CMC).
• Developed Complex Reports (Used multiple data providers, Union, Intersection, Master/Detail, cross tab, Charts).
• Imposed several Joins, Filters, and Alerters to restrict the unwanted data and highlight the required data.
• Resolved loops with Aliases and Contexts.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces
• Worked closely with the Architects to address the performance issues from the server side
• Created the reports using Crystal Reports functionalities like Add Queries(Command), Sub Reports, Drill down, Cross-Tab, Formulas, Parameters along with Dropdown lists etc.
• Extensively used Calculations, Break points, Drill down, Slice and Dice, Functions and Formulas, Filters & Alerts for creating Complex reports.
• Published Crystal Reports on to Business Objects Infoview and provided access to the end users.

Environment/Technologies: BusinessObjects XIR2/XIR3, BusinessObjects Xcelsius, Crystal Reports, InfoView, SAP Query Designer, Oracle 11g, SQL Server 2008, RDBMS/ODBC.

Client : Confidential,
Batan Rouge, LA April 2008 – June 2010
Role : SAP BusinessObjects Consultant

Responsibilities:

• Developed Technical specifications based on Functional documents for the entire reports migration Project to SAP.
• Actively participated in Migration of Business Objects fron version XIR2 to XIR3. Worked on integration of Business Objects with SAP BI.
• Developed Account Recievable Reports and Financial reports.
• Tested reports after migration. Worked with business users and SME’s to identify and fix bugs occurred during migration.
• Worked with Universe Builder to build OLAP universes from SAP BW Data targets like InfoCubes.
• Testing the queries on SQL server .
• Worked with Voyager to develop analysis reports from OLAP Cubes.
• Created design plan for the universes and build the Universes using Designer.
• Created Web Intelligence and Desktop Intelligence reports for the business users.
• Created the reports in WebIntelligence using WebI Java Report Panel.
• Extensively used Calculations, Break points, Drill down, Slice and Dice, Functions and Formulas, Filters & Alerts for creating Complex reports.
• Worked on QAAWS, client tool to create queries from the universe and publish them as a standalone web service.
• Developed dash boards using Xcelsius 2008.
• Used Xcelsius 2008, connecting it directly to BO content using Live Office connector.
• Involved in the production support while migrating to the new version of BO.
• Used Import Wizard for the Migration process. Migrated users, universes, reports, securities etc from 6.5 to XIR2.
• Used Report Conversion Tool to convert the DeskI reports into WebI and maintained the folders in the Info view.
• Created the reports using Crystal Reports functionalities like Add Queries(Command), Sub Reports, Drill down, Cross-Tab, Formulas, Parameters along with Dropdown lists etc.
• Used Crystal Reports 2008 to develop reports out of SAP ECC database using Business Objects Integration Kit for SAP to connect to SAP BI.
• Published reports on to Central Management Console on Business Objects Enteprise.
• Worked as BusinessObjects Enterprise Administrator in addition to being a developer.

Environment/Technologies: BusinessObjects Enterprise XIR2/XI/3.1, XCelsius, Crystal Reports 2008, BusinessObjects InfoView, SAP BO Integration Kit, SAP BI7.0, Oracle 10g,SQL server 2008.

Client : Confidential,
Clearwater, FL January 2007 – March 2008
Role : BusinessObjects/SAP BI Developer

Responsibilities:

• Gathered requirements from the end users and by exploring the existing reports.
• Developed Technical specifications based on Functionals for the entire reports migration Project.
• Prepared detailed specifications document to decide whether it is better to develop a specific report using BusinessObjects or Crystal Reports.
• Worked on Universe Builder to build OLAP universes from SAP InfoCubes.
• Worked on Designer to develop Universes.
• Designed and developed Universes, Classes and Objects for Sales as well as Budget.
• Used Desktop Intelligence as well as Web Intelligence in order to develop reports using Universe.
• Extensively used Calculations, Break points, Drill down, Slice and Dice, Functions and Formulas, Filters & Alerts for creating Complex reports.
• Migrated around 40 reports developed on Cognos Impromptu using Cognos Catalog to BusinessObjects Universe.
• Migrated around 50 reports developed on Microsoft Reporting Services using Report Model to BusinessObjects Universe.
• Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie Charts etc in Crystal Reports as a part of developing new set of reports.
• Created Groups and assigned corresponding users on BO Enterprise CMC.
• Created and tested Universe, reports and supported Client in user acceptance testing.
• Created various reports along with sub reports using Crystal as well as Reporting Services.
• Conducted Training to the end users in order to let them understand the functionality.

Environment/Technologies: BusinessObjects XI, Business Objects Enterprise XI, Crystal Reports 9/XI, SAP BW.

Atos Orgin, Banglore, India
Client : Confidential,
USA April 2005 – November 2006
Role : BusinessObjects Application Developer

Responsibilities:

• Worked with Business Managers, Architects and End users in documenting requirements, providing estimates, creating High Level Design and Detail design specifications.
• Actively involved in the creation and modification of user/user groups and maintained user profiles using Supervisor.
• Coordinate with the data team to develop the data models that suits the business requirements, worked closely with the Data Integrator team.
• Designed and maintained Universes and exported them to the repository.
• Used Designer Module to implement Universes, Joins between Tables, and created prompts and queries, parsing of Universes, and created Contexts and Alias Tables to remove cyclic dependencies.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Created reports using standard company templates. A few of them were created based on the Department requirements.
• Extensive use of BusinessObjects functionalities in formatting reports.
• Created user Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Monitored Business performance using Business Objects Dashboard Manager.
• Used Dashboard Manager to build personalized Dashboards and deploy them across the organization.
• Creating the reports in WebIntelligence using WebI Java Report Panel.
• Used Report Bursting technology to secure the data, based on user profiles.
• Extensively used Calculations, Variables, Drill down, Slice and Dice, Alerts in the creation of reports.
• Generated complex reports using Business Objects.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Used Broadcast Agent for publishing the reports.
• Used Broadcast Agent Console for monitoring the load on the BCA server and prioritizing the scheduled jobs.
• Provided extensive support for the users on application usage and trained users in the functionality of the software.
• Planned, coordinate and execute BusinessObjects deployment for End-users and documented the entire project.
• Used Informatica Powercenter tool as a part of ETL process.
• Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie Charts etc by using Chart expert using Crystal Reports.

Environment/Technologies: Business Objects XI, Crystal Reports SDK/XI, Crystal XCelsius, Informatica PowerCenter

Client : Confidential,
Banglore, India January 2003 – March 2005
Role : Reports Developer/Software Engineer.
Responsibilities

• Created Universes, DESKI and WEBI reports in Business Objects.
• Created Formatted Reports using BusinessObjects.
• Added Users and Assigned roles on Crystal Enterprise.

Environment/Technologies: Business Objects , DESKI, WEBI, Crystal Enterprise.Sql Server.