SUMMARY

• Around 8+ years of IT experience with strong background in various Business Intelligence tools likeBusiness Objects reports generation, publishing and migrate reports using Info View, Import Wizard, Web Intelligence (WEBI), and Desktop Intelligence (DESKI).
• Developed WEBI reports/dashboards/Universes (using IDT) in BI4 Environment.
• Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Worked with the whole spectrum of Software Development Life Cycle, including requirement gathering, system designing, data modeling, application development, enhancement, deployment, maintenance and support.
• Good experience in creating reports using Business Objects XIR3/XIR2/6.x functionalities such as Queries, Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts.
• Experienced in developing the Webi reports using SAP Business objects 4.0/4.1.
• Experience on Upgrade Management Tool (Converted 3.1 reports to 4.0/4.1).
• Experience on converting UNV to UNX in BO 4.0/4.1
• Extensive experience in development of DATAWAREHOUSING technologies.
• Experienced in developing the Dashboards using Xcelsius 2008.
• Well experienced in writing complex queries, stored procedures, functions, cursors and packages using PL/SQL programming.
• Expert in Designing Universes on different relational databases such as Oracle 11g/10g, SQL Server 2008/2012,MS Access 2007.
• Experienced in developing the Webi reports/dashboard/Universes on top of BEx queries (SAP BW 7.3) in Business objects 4.0.
• Created connections to BEx queries and BW Info providers using Business Intelligence consumer services (BICS) in IDT.
• Experience in defining Hierarchies based on Business logic and creating drill down reports.
• Expertise in creating Xcelsius dynamic Dashboard using SAP BI data/BEx Queries. Valuable knowledge on Xcelsius Dashboard Components like charts, selectors (Filters, label Based menus, hyperlinks), canvas containers.
• Proficient in Business Objects Reporting using Crystal Reports, WEBI Rich Client, Live Office and Xcelsius 2008 for both SAP and Non SAP sources.
• Good functional knowledge on Auto & Home, health insurance, inventory.
• Experienced in Xcelsius 2008 to create interactive dashboards by using Query as a Web Service (QaaWS) and Live Office.
• Designed, implemented and migrated complex Universes and Business Objects Reports, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
• Design database objects like tables, views, indexes, constraints, functions, stored procedures, triggers etc.
• Extensively used all features of crystal reports like SQL Expressions, formula fields, conditional formatting using both crystal and basic syntax, parameters, shared variables, groupings, running totals, selections formulas, cascading prompts, linked sub reports, unlinked sub reports, on - demand sub reports, highlighting export, format painter etc.
• Experience in connectivity of client sources with enterprise servers in Business Objects.
• Created complex master details in web intelligence XI R3.1/4.0.
• Worked with Oracle, Microsoft SQL Server, Microsoft Access databases, and Excel Spreadsheet.
• Highlymotivated team player and aQuick Learnerwith good communication, strongproblem solving skillsand excellent in presentation and interpersonal skills. Extremely well organized, meticulous and highly self-motivated.

TECHNICAL SKILLS

Tools: BO 4.1/4.0/3.1 Webi reports, IDT, Universe Design Tool, Dashboard Design Tool (Xcelsius 2008), Explorer, Crystal Reports.

ERP: SAP BW/BI.

Functionalities: Master/Detail, Slice and Dice, Drill up/down, Conditions, Filters, Charts, Alerts, LOV, Context, Aliases, Universes, Reports, @Functions, Formulas, Scheduling, Cross tab, Joins.

Database: Oracle, MS SQL Server 2008, DB2, MS Access.

Languages: C,C++,SQL, PL/SQL, Java

ETL: SQL Server Integration Services (SSIS).

Operating Systems: Windows 98/2000/ XP/NT, MS DOS and Unix.

Packages: MS-Office

Web Servers: Web sphere, Apache-Tomcat.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles

Business Objects Developer

Responsibilities:

• Involved in Requirements analysis, Data modeling and technical implementation.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Created WEBI reports with complex calculations.
• Creating SAP BW universe connections for BEX queries and importing the structure to the BO universe.
• Migrated all the reports using “Import and Export wizard” from test environment to production.
• Used IDT for Converting 3.1 Universe (UNV) to UNX format.
• Involved in Upgrade the reports from (3.1 version to 4.0) using “Upgrade management tool” (Webi and Crystal).
• Involved in testing, after moving the reports from older version to higher version (3.1 to 4.0/4.1)
• Extensive Knowledge on Oracle, SQL Server databases.
• Designed and maintained Universes and exported them to the repository.
• Developed Webi reports on SAP BW Queries using BICS in Business Objects 4.0/4.1.
• Created WEBI reports & crystal reports and deployed them through Info View/BI Launch pad with Universe as source.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for Design of the universe with Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve the Loops and Traps.
• Creation of Live Office connections for the dashboards using web intelligence reports as data sources.
• Design and development of Xcelsius dashboards as per the requirement.
• Implemented the ETL process and business logic by using PL/SQL.
• Extensively involved in creating database packages, procedure functions, cursors and triggers using PL/SQL.
• Developed complex webi reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement.
• Worked towards optimal development of Universes by removing loops through the use of aliases and contexts, creating universe with number of Classes, many objects, and Derived tables using inner/outer joins as per requirement.
• Experienced in working with grouping, ranking, report variables and different functions in WEBI.
• Involved in data Connectivity to the databases by using like Qaaws’s.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Involved in the production support while migrating to the new version of BO.
• Extensive knowledge in SQL Server 2008, SSIS.
• Performance tuning of the reports.
• Used Collapse and Expand (outline) Functionality in Webi reports.
• Modified the default session timeout, for the info view as the users complained about being session timeouts frequently.
• Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats
• Implementing performance optimization techniques for the dashboard to reduce initialization and user interaction times.

Environment: BusinessObjectsXIR3, IDT, CrystalReports, Xcelsius 2008, Web Intelligence 4.1/4.0/3.1, SAP BW, Oracle 11g/10g, SQL Server 2008/2012, Info view, Windows 2008 Server, .NET and Java based Applications.

Confidential, Richmond, Virginia

Business Objects Developer & Crystal Report Developer

Responsibilities:

• Involved in Installation and Configuration of all Components of Business Objects.
• Designed new Universes and modified the existing Universes based on the report requirements.
• Experience in writing SQL queries, testing optimizing and fine tuning SQL queries.
• Involved in the designing and Building of Universes, Classes and objects.
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Set up Universe level conditions to restrict data based on report requirements.
• Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports
• Created Web Intelligence Ad-hoc and canned reports in 3.1.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Troubleshoot issues with existing reports in the production environment.
• Created Views, Stored Procedures and validated data for the Performance.
• Designed plans and solutions in Business Intelligence.
• Developed various types of complex reports like Standard reports, Group reports, Detail and Summary reports, Crosstab reports, Graphical reports, drilldown reports, on Demand and Linked sub reports using crystal reports, tables, views, stored procedures, business views.
• Experienced in developing Dashboards using Xcelsius 2008.
• Provided daily production support and administration of portal operations, such as problem resolution.
• Testing, optimizing, and fine tuning crystal reports for better performance.
• Designed data mining processes for large files.
• Create complex reports against SAP R3 tables, ABAP function modules.
• Worked closely with Data Modelers in designing various data warehouse schema techniques
• Create complex reports against SAP BEx Queries.
• Created the reports on the web by using Web intelligence .
• Worked on the data provider that forms the basis of the ad-hoc analysis
• Extensively involved with end user training in business object explorer.

Environment: BusinessObjectsXIR3, Designer, Crystal Reports, Xcelsius, Web Intelligence, Info view, Oracle 10g, SQL Server 2008/2012, Windows 2003Server, .NET and Java based Applications.

Confidential, San Jose, CA

Business Objects Developer

Responsibilities:

• Involved in the design of the Application Business logic Components, which formed the architecture for distributed application development encapsulating business and data logic.
• Created, modified/maintained Products Universe.
• Developed components to connect database.
• Deployed universes in the repository by exporting.
• Created web based reporting using web intelligence.
• Created a component, which stores the total business logic of the portal, which contains many class modules related to business.
• Worked with crystal Xcelsius dashboards.
• Developed, deployed, and managed Commerce applications for the Web.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Wrote Complex SQL Queries for Data validation purpose.
• Extensively Used MS Excel to generate Purchase Order Reports and Manufacturing Reports
• Designed Excel Spread sheets and used V Lookup to merge different Reports, which are created worldwide.
• Utilized Pipeline Feature in Commerce server for more flexible order handling, easier shipping method maintenance, more flexible discount handling, and greater efficiency in pipeline loading and execution.
• Documents are placed according to the categories.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in reports.

Environment: Business Objects 5.x, Erwin, Windows 2000, IIS 5.0, ASP, Commerce server2000, SQL Server 2008, VB 6.0, COM, MTS, HTML, DHTML, MS Visual SourceSafe, VBA, Excel

Confidential, Denver, CO

Business Objects Developer & Crystal Report Developer

Responsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
• Created New Universes and Managed existing Universes
• Migrate, upgrade and test the Business Object XIR3 content/environment
• Setup, execute, and test the assigned programs utilizing BO XIR3 WEBI and DESKI tools
• Creation of multiple Universes and Linked Universes.
• Design complex Web Intelligence and Desktop Intelligence Reports
• Plan the implementation of migration to different Environments in Business Objects.
• Involved in the Data Warehouse design process
• Develop Dashboards for the higher management of the company
• Worked on extensive features of Business Objects XI including Index awareness, Derived tables and Input Controls
• Creation of reports, working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created reports using WEBI, DESKI, full client.
• Analyzed the reports using the Drill Through, Slice and Dice.
• Trained the users in viewing/scheduling the reports using the Info view and Designed security model for users to access the report
• Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects.
• Designed, developed, tested and maintained highly complex reports.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Deployed the reports by using Import Wizard (between DEV and UAT) and archived the reports.
• Used Business Objects supervisor to create repository, creating and managing the users, giving access permission for Business Objects Reports.

Environment: Business Objects XI 3.1/6.5(Web Intelligence/Desktop Intelligence), Designer, Import Wizard) Performance Management, Oracle 9i, DB2, AS/400, SQL Server, Windows XP.

Confidential

Business Objects Developer

Responsibilities:

• Complex reports were created to analyze plans, implemented complex business rules and reusable transformations.
• Implemented complex business rules by creating robust Mappings, Mapplets and reusable transformations.
• Extensively used ETL methodologies for supporting Data Extraction, transformation and Loading process.
• Used Transformation Developer to create the filters, Expressions, Lookup and aggregation transformations that are used in mappings.
• Created a wide variety of charts like2D and 3Dline charts,bar chartsandpie charts.
• Createdcustomized LOV’s and cascading promptsfor easy access to business users.
• Good Experience in usingSub QueriesandUnion queriesetc.
• Created various reports like Master/Detail reports, Cross Tab reports, Slice and Dice reports.
• Created complex reports using multiple queries and sub queries.
• Involved in Business objects reporting. Created universe with complex joins, Created Aliases, Multiple contexts for catering different functional areas in a single user query.
• Communicate effectively with all groups of users during design, testing and implementation phases.

Environment: Informatica 5.1, Business Objects 5.1(Designer, supervisor, Web Intelligence), Oracle 8i, PL/SQL.