Professional Summary:

• Over 6 years of IT experience in Business Objects XIR3.1/XI R2 Enterprise Suite like Infoview, Universe Designer, Desktop Intelligence, Web Intelligence, Central Management Console (CMC), Central Configuration Manager (CCM), Central Management Server (CMS), Import Wizard, Publishing Wizard, and Report Conversion Tool.
• Experienced in developing Dashboards, Pixel Perfect Reports using SAP BO Crystal Xcelsius, Crystal Reports and WEBI.
• Created Universe and generated DeskI reports, WebI reports using Business Objects XIR3.1.
• Created Universes using Designer, Created Reports using Business Objects, used multiple sources to create reports, Combined Queries, Slice and Dice, Drill Down, Crosstab and Master Detail Reports.
• Created cascading list of values to enable cascading prompting in the reports using Designer.
• Expertise in resolving joins path problems like Loops and Traps in the universes using Aliases and Contexts.
• Excellent experience with Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Business Objects.
• Worked with Crystal Report XI for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports and data reports.
• Experience linking Crystal Xcelsius to Business Objects Universe using LiveOffice and QaaWS (Query as a Web Service).
• Created Dashboards using Application Foundation.
• Vast experience using Oracle 10G/9i/8i, Microsoft SQL Server 2005/2000, Teradata, DB2 databases.
• Experience in RDBMS concepts creating, maintaining and tuning Views, Stored Procedures, Functions and Triggers using SQL, T-SQL, and PL/SQL.
• Expertise in designing the data warehouse using star schema/snow-flake schema and dimensional modeling, and creating Business Objects Repositories.
• Excellent knowledge in Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP) and Data Marts.
• Extensive experience working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
• Expert in planning, designing, developing, modifying, updating, maintaining and distributing Universes and Reports.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Capable of working as an individual and also as a part of team.

Technical Skills:

DW/Reporting Tools : SAP Business Objects XI 3.1, XI R2, 6.5 and 5.1.
Databases : Oracle 10g, 9i/8i, MS Access, SQL server 2005.
Tools/Utilities : Toad 8.x.
Languages : SQL, PL/SQL.
Operating Systems : Windows Enterprise 2008/2003 NT and XP.

Education Qualification:

Bachelor of Engineering in Computer Science.

Professional Experience:

Confidential,Tulsa, OK Oct11 to Present
Role: Business Objects Developer
Description: Williams is one of the largest providers of energy infrastructure in North America. Our businesses are interstate natural gas pipelines; midstream gathering and processing; natural gas and natural gas liquids transportation and production.

• Involved in gathering requirements from functional and end users and prepared technical Design documents.
• Involved in presenting demo’s to end users to understand BO environment and application.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down Slice and dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects.
• Maintained and updated complex crystal reports and published to BOE.
• Involved in developing and modifying universes.
• Created Deski reports using universe as data source and published to repository.
• Created different types of reports like Cross Tab, Charts and Master Detail using multi data sources.
• Created List Reports for various types of Charts (Pie, bar) for analyzing the data.
• Created standard and Ad hoc reports using business objects.
• Apply scope of analysis for creating the master detailed reports.
• Responsible to deliver the project within the timelines.
• Conduct on-going tuning and monitoring to maintain and improve the performance and stability of the environment.
• Publishing Crystal Reports to repository from Crystal Reports Designer and publishing Wizard.
• Maintaining Universes and Object Oriented Universe Design Techniques, working knowledge of Linked Universes.
• Involved in creating the Aggregate tables at different levels.
• Multilevel hierarchies are set up enabling the drill down functionality.

Environment: Business Objects XI 3.1 SP3, Web Intelligence, Designer, Desktop Intelligence, Crystal Reports, Info view, SQL Server and ORACLE 10g.

Confidential,Dallas, TX Feb ‘11 to Sep 11

Role: Business Objects Developer
Description: Superpages is the Internet\'s #1 online yellow pages directory and a leading shopping resource. With up to 17 million unique visitors per month, superpages.com also promotes advertiser goods and services through listings, web sites and shopping services according to their specific local, regional and national needs. With more than 177 million U.S. businesses listed, superpages.com links buyers and sellers in a rich online environment.

Responsibilities:

• Interacted with users and identified Business Requirements.
• Developed PL/SQL stored procedures for various purposes including test data preparation and for stored procedures that will be called before the reports are run. These procedures will parse existing data files and insert into tables.
• Used Business Objects XIR3.0 for developing reports.
• Involved in conversion of project from BO XIR2 to BOXIR 3 using Import Wizard.
• Created Users, Groups and assigned privileges to access and work with Universes and Reports using Central Management Console.
• Designed, Created and Maintained Universes for Users using Business Objects Designer module.
• Created Universes by defining Joins, checked the Cardinality between Tables.
• 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.
• Resolved Loops in Universes using Aliases and Contexts.
• Developed Hierarchies to support Drill down reports.
• Developed various reports like Loan scheme, Borrower Detailed Reports, Borrower loan Scheme wise sanctioned amount Reports, Borrower’s loan installment status report, Borrower scheme recovered Amount reports, and Unrecovered amount summary reports.
• Created user defined Functions and Variables.
• Deployed Universes in the Repository by Exporting and Importing Universes between Universes Domain, and over different repositories.
• Involved in BO Voyager by distributing the workspace to the users.
• Created the reports using Desktop Intelligence using functionalities like Slice and Dice, Filters, Sorter, Drill, Master/Detail, Combining Quires and Formulas etc.
• Generated various reports daily, weekly, monthly, and yearly basing on Business Objects report Module.
• Exported the Business Objects reports to Users using Web Intelligence and Crystal Reports.
• Involved in Scheduling reports based on Specific time, events, and calendars and in various formats using Broad Cast Agent.
• Employed Live Office in creation of analytics using Xcelsius.
• Reports are exported in to central Repository according to the Categories.
• Extensively involved with end user training in Business Objects Reports.

Environment: Business Objects XI 3.1 SP3, Web Intelligence, Designer, Desktop Intelligence, Crystal Reports, Xcelsius 2008, Live Office, Import Wizard, Central Management Console, Info view, SQL Server and ORACLE 10g.

Confidential, Apr ‘10 to Jan ‘11
Role: BO Developer
Description: This Data warehouse was designed to generate reports for the Health Department in Laurus Pharmaceuticals. This warehouse is to generate reports and analyze the sales of various products. The product data is categorized depending on the product group and product family. Generated the reports using business objects as reporting tool and created different kind of reports like monthly sales, product wise sales, profit and target sales. This warehouse is also used to analyze the usage of product at different times of the year. This warehouse reports the historical data stored in various databases like Oracle and Flat Files.

Responsibilities:

• Perform an Initial Study of the Current Reporting application, to finalize the data elements required for reporting.
• Installed and Configured BO Software on client machines and created User groups and users of PROD, DEV, TEST environments.
• Created Repository for BO development, created Universes and Complex Reports.
  Involved in working with different database environments and moving of the universes and reports between PROD, DEV, and TEST.
• Row level security is implemented in the supervisor to restrict the data to the respective divisions.
• Maintaining Universes and Object Oriented Universe Design Techniques, working knowledge of Linked Universes.
• Involved in creating the Aggregate tables at different levels.
• Created different types of reports like Cross Tab, Charts and Master Detail using multi data sources.
• Multilevel hierarchies are set up enabling the drill down functionality.
• As a part of report development, created the reports using universe as a main data provider and using the Powerful business objects functionalities, and formulae.
• Involved in trouble shooting of various reporting errors.
• Created Web Based reports using Web Intelligence.
  

Environment: SAP Business Objects XI R2, Oracle 10g, Windows 2003, Toad 8.6.1.

AMB Confidential, Properties Reporting. Apr ’09 to Mar ’10
Role: BO Developer
Description: AMB is a leading realtor in the current USA market operating from different parts of the world. This project deals with extracting the data from SAP Bex Queries/Info cubes and creating the
Reports using crystal reports/Web Intelligence Reports. Reports developed and published to the Infoview through BW Publisher. All the crystal reports/Web Intelligence Reports are scheduled based on the time zones and exported to the users on PDF formats. In Crystal Reports using the Sap integration kit the queries are directly accessed from Sap BW and generates the reports.

Responsibilities:

• Creating Business Objects Universes and reports.
• Creating AD- hoc reports (web intelligence reports).
• Involved in creating charts using Web Intelligence.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down
• Slice and dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects.
• Created List Reports for various types of Charts (Pie, bar) for analyzing the data.
• Created standard and Ad hoc reports using business objects.
• Apply scope of analysis for creating the master detailed reports.

Environment: Business Objects XIR2, Oracle8i, Toad, Sap Bex Queries.

Confidential,Aug ’08 to Mar ’09
Role: BO Developer
Description: Avanex is the leading Telecom solution provider company across the world. This project deals with extracting the data from SAP R/3 Systems and creating the reports using business objects reports. Once developed the reports and publishing the reports to the Business Objects environment. All the BO reports need to ran the instances and exported the data for users on PDF formats.

Responsibilities:

• Involved in creating reports from various Data providers and reports from excel to business objects and vice versa.
• Involved in creating reports from various data sources by clubbing different data providers.
• Developed and formatted the reports as per the user’s requirements using all the facilities in Business objects like slice and dice, drill down, @functions and formulae to analyze the data.
• Developed reports for the web users using the web intelligence 6.5 Info view. Reports are created using the Web Intelligence explorer and report modules support.
• Created, updated and maintained Business Objects technical documentation.

Environment: Business Objects 6.5, Web intelligence 6.1, Oracle 8i, Windows NT.

Confidential, Jun ’06 to Jul ‘08
Role: Business Object Developer
Description: Allianz is a leading Insurance agency in the areas of Life Insurance, Health Care, Group Insurance Benefits, and Accident & Health. The projects main objective is to create a central database for data and to provide a set of standard reports to give better analysis to the financial group.

Responsibilities:

• Interacted with the Business Users to analyze the business process and gathered requirements made necessary changes to schema objects to fulfill their reporting and business needs.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Used @functions like @select, @where and @prompt function to create prompts which helps the user to select the values dynamically.
• Exported universes to the Repository for making resources available to the users from various groups.
• Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports.
• Extensively used the Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports.
• Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
• Worked in creation of multiple universe and document domains for Development, QC and Production Environments.
• Tested the all the reports with different scenarios like query balancing, look and feel and formatting of the reports based on the specifications.
• Involved in scheduling of documents monthly, weekly and daily through Broadcast agent console.
• Involved in creating reports using the Business Objects and Web Intelligence.
• Created various complex reports using Crystal Reports.
• Extensively involved in creating Crystal Reports using Parameters and Record Selection Formulas to allow the users to filter the Data.

Environment: Business Objects 5.1 (Supervisor, Designer, Reporter), Web Intelligence, Crystal Reports, MS SQL Server and Windows 2000.