SUMMARY

• Over 7 years of work experience as a Business Intelligence reporting Consultant using BusinessObjects Suite (XI R3/R2) and Crystal Reports(XI R2/2008).
• Extensive experience in Business Objects Enterprise products - Universe Designer , InfoView, Web Intelligence (WebI), Web Intelligence Rich Client , Desktop Intelligence, Central Management Console (CMC) , Central Management Server (CMS), performance manager, Dashboard Manager , Live Office, Xcelsius, Crystal Reports XI.
• Strong Experience in Software Development Life Cycle. Responsible for gathering requirements from end user to arrive at requirements for report generation. Analyzed the data to ensure required reports can be generated. Performed Validation of BI/BO reports as per the requirements.
• Excellent in universe designing techniques, creating webi reports with various functionalities like multiple data providers, merge dimensions, drill options, multiple tabs, filters, alerts etc.
• Expertise in Create Repository and maintained the Universe domain and Document domain.
• Extensively involved in migrating reports from Dev Environment to Test, Test to Production and experienced in publishing and scheduling.
• Extensive experience with the building of WebI reports on Ipad and Tablets as well.
• Assigned resources to the users. Trained Business users how to use all business objects reporting module and how to create reports.
• Good knowledge and experience in working with various databases like Teradata, SAP BI 7.x, Oracle10g/9i/8i, MS SQL Server 2005/2000.
• Extensive knowledge of InfoCubes, Info Objects, Info Sources, Extraction (LO Cockpit, CO-PA, FI/SL, LIS and Legacy extractions), ODS, architecture and BEX Analyzer.
• Strong in Enterprise Data warehousing concepts, Data Analysis, Data quality and various Data modeling techniques like Star Schema, Snow flake schema
• Expertise in Business Objects products like Import Wizard and Report Conversion Tool
• Having Good Experience in Creation of Dashboard, Score card and Webi Reports. Implemented Security Features of Business Objects like Row Level, Object Level and Report Level to make the data secure.
• Strong exposure to Software Project Development full Life Cycle (SDLC).
• Heavily involved in conducting end user training sessions related to InfoView and Web Intelligence reporting.
• Possess Excellent Communication and Interpersonal skills. Technically sound, Result-Oriented with strong Problem Solving skills. Innovative & efficient. Capable of working as a Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

Business Intelligence:Business Objects XI 3.1/R2/6.5, Web Intelligence, Crystal Reports XI/10, Universe Designer, InfoView, Live Office, Import Wizard, Publishing Wizard, Xcelsius 2008, CMC, CCM, Data Quality, Informatica power center, Data stage

RDBMS and other tools:Teradata, Oracle 10g/9i/8i, SQL Server 2005/2000, MS Access, Sql Developer, ERWIN 4.1/4.0, TOAD 6.5, Sql assistant, SQL Navigator 4.1, Lotus Notes, MS Office Suite

Programming:SQL, PL/SQL, UNIX Shell Scripts, HTML, DHTML, C, C++, VB 5.0/6.0, Basic Java

Operating Systems:Microsoft Windows ,Unix, Linux, Windows2000/2003 Enterprise Server.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX June 2010 - Till date
Sr. Business Objects Developer

Description: Confidential is a major contract driller of oil and natural gas wells with operations in many countries. Was a member of the SAP BO implementation team and was responsible for Data Extraction, Analysis and Report generation for the business data accumulated from worldwide locations.

Responsibilities:

• Requirement Gathering from business users with Business Analysts. Analyze the requirement with the data model and come up with technical and functional specification.
• Study the business, study the data sources and study the data model to implement a reporting system for MetLife business user’s requirement.
• Plan the technical design and prepare the technical documents and get approval from business users.
• Identify the tables, dimensions and facts. Identify the relationship between tables as per design doc. Link the tables and set the Parameters and cardinalities on the Universe Designer.
• Identify the loops, like Chasm traps and Fan traps loops and resolve it with Alias (mostly for tan trap) and Context (mostly for chasm trap) and perform integrity check.
• Create business logic classes and create objects like dimension, details, measures and conditions.
• Developed and maintained the linked Universe in the Universe Designer for defining the business oriented data structure from the Star Schema.
• Used Web Intelligence / Webi Rich Client from web based ad-hoc query and reporting.
• Used WebI to build reports on Ipads and Tablets to meet the business end user requirements.
• Creating report on Web Intelligence, Webi Rich Client, Crystal Reports and created Xcelsius Dashboard reports, Widgets and Business View Manager as per End User requirements.
• Used Slice and Dice, Drill Down, Filters, Master Details, Cross-Tabs and Developed customs Hierarchies to support drill down reports.
• Organized data in the reports by using filters, Sorting, Ranking and highlighted data using Alert.
• Create various Reports by pulling the OLAP data from Data Warehouse like Sales of Products, by Region wise, Reports Based on time like Year, Quarter, Month, Week, Geographic reports and Comparative reports.
• Experience in performing Administrative task by Using CMC Central Management Console and Installing and configuring BOXI services.

Environment: Business Objects XI R3/R2, Web Intelligence, Info view, Live Office, Crystal Reports, Xcelsius ,Informatica, Oracle 10g, Windows XP, Windows 2003 Server.

Confidential, Manteca, CA Aug 2009 –Jun 2010
Sr. Business Objects Developer

Description: Confidential brews a wide range of Wine products, which are supplied to the different parts of United States. This Project was implemented for Customer Billing, invoicing, payments and customer service purposes.

Responsibilities:

• Indentified and road mapped the Business requirements (functional & technical) with the Business users, which acted as a base the project initiation and implementation.
• Study the warehouse Tables to design Universes and to create Classes and Object.
• Developed New Universes using star schema as per the Specification and maintaining existing Universes.
• Identify the loops in the Universe and created Contexts and Aliases for resolving Loops.
• Experience in creating Reports on Webi Intelligence, Desktop Intelligence, Webi Rich Client, Crystal Reports, Xcelsius and created Dashboard reports, Widgets and Business View manager as per end user requirements.
• Migrated Universes and Reports from Business Objects 6.1 to Business Objects XI R2 using Import Wizard and Converted Desktop Intelligence Reports to Web intelligence Reports using Reports Conversion Tool.
• Created Complex Universes for the efficient development of Web intelligence XI R2 reports.
• Update and modified universes using universe Designer in Business Objects XI R2 based on reporting requirements.
• Developed different types of standard and ad-hoc reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Mater Detail, Variable Grouping, Filters, Ranking, Sorting, Parameter Prompts and Formulas.
• Created various reports in Web Intelligence R2 using the universes created based on requirements.
• Created various WebI reports on Ipad and Tablets for the convenience of end users.
• Implemented optimization techniques and performance tuning for the reports developed as well as the Universes created. 
  

Environment: Business Objects XI R2, Crystal Report, Crystal Xcelsius, Oracle 9i / 10g, Sql Server 2005, Windows 2003 Server.

Confidential, Warren, NJ Sep 2008- Jun 2009
BO Developer

Description: The scope of the project was to design a universe of analyzed financial data to generate financial reports for decision support. The reports included region wise, quarter wise, year wise financial reports for the credit cards departments. The reports helped the financial officers to analyze the volume of credit card sales as well as revenue generated by the credit cards. Business Requirements include recreating existing client reports, new client reports in Business Objects Web Intelligence. Also involved in creating reports in Desk Intelligence. 

Responsibilities:

• Involved in gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects universes and reports.
• Involved in creating repositories and setting up of groups and users forBusiness Objects users. 
  Implemented security for the end user based on groups and permissions. Prepared business/Technical Requirements, Development standards documents and detailed design documents.
• The company had more the 1500 Business Objects reports that delivered to its clients every month and as part of the reporting team I was Involved in managing and maintaining these report deliveries every month.
• Involved in testing and migrated Desk and Web reports from one environment to another. 
  Managed different levels of security access to the groups, folders, universes and universe connection.
• Interacting with end Users, to know their requirements and develop/modify universe and Reports accordingly.
• Developed and created classes with Dimension, Detail & Measure Object and specified the hierarchies.
• Exported universes to the Repository to make resources available to the Business Objects users. 
  Created reports for various product lines using the universes the universe as the main data provider.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice Drill Down, Function, Cross Tab, master Detail and formula etc.
• Inserted data from different data sources to meet the need of the client in comparing targets and sales.
• Reports ware published to a BCA server and scheduled for daily refreshing. Report viewing was strictly restricted to Info View.
• Created WebI reports on Tablets in different scenarios to meet the end user reporting requirements.
• Trained the end users in working the Business Objects user module and Web Intelligence.
• Created Dash Boards for senior for senior executives for executives for Business decision making.

Environment: Business Objects XI R2, Crystal Reports 8.5, Oracle 9i, Windows, UNIX.

Confidential, Reston, VA Jun 2007- Aug 2008 
Business Objects Developer

Description: Confidential is one among the nation\'s leading online provider of wireless services and phones. Developed various universes and reports from NDW database using business objects for operations group that enable them to run Canned or Ad-hoc reports on sales activity, subscriber usage, customer base and Customer Experience.

Responsibilities:

• Involved in interacting with users, gathering and analyzing requirements, logical and physical design of the reporting system.
• Designed new Universes and modified the existing Universes based on the business requirements.
• Created Universes by joining the tables, creating prompts and queries and apply Contexts and Aliases to remove loops.
• Created User Objects including Dimensions, Details and Measures.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Created Reports using various data providers such as universes, SQL and personal data files (excel sheets and text files).
• Created Reports from multiple data providers and used the merge dimension option to synchronize the data in WebI reports
• Involved in creating the Reports as per the business like Customer information, Usage of Off peak minutes and Peak minutes, Long distance call and prepaid services.
• Created reports for Subscriber Usage, Billing, Account, Subscriber Status and Equipment Information.
• Generated the Business Objects Reports involving complex queries, sub queries, Unions and Intersection.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice to develop the reports.
• Created reports on the web using Web Intelligence and distributed them to different users through info view portals.
• Used Broadcast Agent for scheduling and distributing the documents.
• Supported the application by solving the Trouble Tickets which was created by the users.
• Coordinated with Business Objects Deployment and documented the entire project.
• Involved in installing Business Objects, creating Repository, Users, and User Groups and prioritizing Security Levels for Users and User Groups.

Environment: Business Objects XIR2, SQL, PL/SQL, Oracle 9i, Windows.

Confidential, New Castle, DE Jul 2006- May 2007
Business Objects Report Developer

Description: Confidential is a research-based, global pharmaceutical company responsible for the discovery and development of some of today\'s most innovative medicines. A Data warehouse has been developed for maintaining customer, employees and service data. The system monitors the information such as services provided to the customers, receivable, etc. This system integrates the sales, marketing, and finance departments. The project required development of various analytical reports using Business Objects.

Responsibilities:

• Involved in Installation and Configuration of all products of Business Objects.
• Created Repository and assigned privileges to users and groups using Supervisor.
• Analyzed the existing database and designed Universes using Designer module for generating reports.
• Used various data providers like SQL to extract data from different sources and tuned for better performance.
• Resolved loops by creating Aliases & Contexts and checked integrity of universes.
• Exported universes to the repository and making use of Universe as the main data created Reports to the users.
• Created Reports using the Universes and SQL as data providers.
• Worked on Query Panel, Prompts, Report Layout and formatting.
• Involved in development and deployment of Complex Reports.
• Created Reports showing the sales of various Drug products in a particular Year, Quarter and Month using Business Objects and reports based on DDD (Drug Distribution Rx Data).
• Created the Reports to monitor the 21CFR PART 11 Compliance information of various Drugs’s provided to Physicians.
• Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
• Automated document Scheduling, Publishing and Distribution for WebI and Info View clients using Broadcast Agent server.

Environment: Business Objects 6.5 (Supervisor, Designer, Reporter and web intelligence) SQL, PL/SQL, Oracle 9i, Windows NT.

Confidential, San Francisco, CA Apr 2005- Jun 2006
Business Objects Developer

Description: The Group\'s principal activity is to provide credit card and deposit products throughout the United States. Providian Group markets consumer loans and deposits using distribution channels such as mail, telephone, and the Internet. The present project included development and deployment of a Business Intelligence System for Global E-commerce division. Business Objects was used to support the middle management and executives for their planning activities.

Responsibilities:

• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Created Universes by defining connections and retrieving data from database.
• Created Aliases and Contexts for solving the Join Problems in Business Objects.
• Created New Classes and User Objects in designing the universes.
• Exported the universes to the Repository to make resources available to the users.
• Generated various Reports on Daily, Weekly, Monthly and Yearly basis.
• Created and modified the WebI Reports for various financial groups using the Universe as a main data provider.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs. Some of these reports are extremely complicated and retrieve data from multiple data sources
• Created Charts to display summary data using universe as main data provider.
• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.
• Published Reports using Info View, and trained users for Ad-hoc reporting.

Environment: Business Objects, MS Access, Oracle 9i, SQL, PL/SQL and Windows 2000.