SUMMARY

• Over 8 years of experience in Business Objects 4.0, XI3.1/XIR2/6.5, Crystal Report 2011/2008/XI.
• Experience in migrating Business Objects from XIR2 to XI 3.1 using Import Wizard.
• Solid expertise in Creating Complex Applications using Business Objects, Web - Intelligence, Import Wizard, Life Cycle Manager, Publishing Wizard, Report conversion tool, Designer, Planning, Metadata Manager, Crystal Enterprise 2008/XIr2/10/9/8.5/8, Xcelsius, Live Office, QaaWS, Dash Board Manager, Broadcast Agent, Auditor, Web Admin tool, Supervisor, Web Intelligence/Info view.
• Proficient in all phases of the Software Development Lifecycle(SDLC) including Requirements gathering, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Strong experience in building universes on Star schema & Snowflake Schemas.
• Experience in designing and developing Universes, Full Client/Web-Intelligence reports, publishing and scheduling using CMC and event manager
• Experience in creating Universes with measures and dimensional objects, Join conditions, Filters, LOV’s, cardinalities, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.
• Created canned reports, complex ad-hoc reports using Business Objects Web Intelligence tools.
• Strong expertise in creating reports using the Business objects functionalities like Prompts, Slice and Dice, Drill Mode, Filters and Alerter.
• Experience in development, testing and implementation of SAP Business Objects Explorer Info Spaces using Non-SAP Data Sources.
• Expert in creating Dashboards, Scorecards using BO Dashboard Manager/Xcelsius 2008.
• Expertise in scheduling the documents using Central Management Console / Broadcast Agent.
• Experience in creating reports with Crystal Reports and dashboards with Crystal Xcelsius.
• Experience working with Crystal Xcelsius to display summary-level business data in a rich and intuitive format.
• Involved in using Crystal Xcelsius to Transform Microsoft Excel spreadsheet data into interactive flash media files for the upper level management.
• Experience in using various RDBMS like Oracle 10g/9i/8i, SQL Server 2005/2000.
• Involved in designing Databases and data marts on Oracle/Access. Widely used TOAD (Oracle), and SQL Query Analyzer (SQL server).
• Strong skills in Oracle including SQL, PL/SQL (Packages, Functions, Stored Procedures and Database Triggers and Cursors).
• Strong analytical, problem-solving, organizational, communication, learning and team skills.

TECHNICAL SKILLS

Data Warehousing Tools: ETL

Business Objects: XI R2/6/5/11.7,3.0, Business Objects Data Services 4.0,3.X, Business Objects Data Integrator 3.X/ 6.5/11.5/11.7 , Informatica power center 8.1/7.1.3

Scheduler: Autosys, Cron, Informatica Scheduler

Data Modeling: Erwin

Data warehousing: Data mart, Aggregation, OLAP, OLTP, Star Schema, Snow flake Schema, Slowly Changing dimensions, Data Cleansing, Performance Tuning, SQL tuning.

BI Tools (OLAP): Business Object XI/6.0,cognos

RDBMS/DBMS/ERP: Oracle 10,9i/8i/8.0/7.0, TOAD, Teradata, MS SQL Server 2000, MS Access 2000, Flat files, Excel.

Application Software: PL/SQL, SQL, Visual Basic 6.0/5.0

PROFESSIONAL EXPERIENCE

Confidential, Franklin, TN

Business Objects Developer

Responsibilities:

• Created Secured (.cnx) connection in IDT(Information Design Tool)
• Designed Data Foundation (.dfx) using multiple data sources using IDT.
• Inserted calculated columns in tables at Data foundation level.
• Defined Business rules (Joins, Alias & Contexts) in Data Foundation.
• Published Data Foundation and Secured connection to Repository.
• Created Business Layer using Data foundation and defined @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
• Configured Parameters and LOV in Data foundation.
• Customized Business layer by assigning row level and column level security using security editor.
• Implement Aggregate awareness, hierarchy functionalities are developed in Business Layer(.blx)
• Provided a detailed analysis on multiple Universes and offered the suggestions inorder to enhance the performance of the reports dependent on the Universe.
• Performed various queries on the Universe and documented the possibilities of replacing them with new joins accordingly in order to enhance the back end SQL generated in BO
• Redesigned Universe Schema by inserting tables (from backend data source) into the structure pane in designer and developed Classes and Objects (according to business terminology) in the Universe pane.
• Created complex objects using various @functions such as @select, @prompt, @where at universe level.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Worked on Global filters at the universe level to restrict retrieval of data.
• Worked extensively on design and development of OLAP Universes and Reports using Web Intelligence (WEBI)/ Crystal Reports on SAP BI/BW BEx Queries and SAP BI Infoproviders.
• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specification for Business Objects Universes, database design, and developing Web Intelligence reports.
• Experience in fine-tuning the reports optimizing and fine tuning of the SQL queries for better performance.
• Worked closely with various departments to define, build and test reports.
• Worked on re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Created mock -up reports for initial user presentation in the process of designing Technical Specifications.
• Created Cascading LOV and define hierarchies, work with complex Metrics to get up-to the minute snapshots of key process indicators (KPIs) and tracking goals, and monitor day-to-day activity, used @aggregate aware function to create the summarized reports.
• Worked extensively with SQL*Plus, Toad for writing user defined queries in the process of testing the reports in UAT (User Acceptance Testing) stage.
• Extensively involved in processing and analyzing data in Teradata and Oracle 10g.
• Involved in Performance Tuning of reports against theOracle DBfor faster queries.
• Extensively involved in SQL coding creating complex queries, Views, Stored procedures, Functions to give better results at Crystal Reports.
• Hands on experience in developing SAP BI queries using Query Designer and importing the same to Business Objects for Universe Design and Reporting.
• Well Versed with Data Modeling concepts in SAP BI with respect to Infocubes, DSO’s and Multiproviders.

Environment: Business Objects XIR3.2, (Designer, WEBI, Web Rich Client, Xcelsius 2008, and Crystal Reports 2011/2008), Business Objects Explorer 3.2, Data Services, Oracle 10g, Toad9.7, ClearQuest7.0 & ClearCase7.0.

Confidential, Peoria, IL

Business Objects Developer

Responsibilities:

• Developed .unx file using 3 layer architecture (.cns, .dfx, .blx) stored in Project with IDT tool.
• Created Secured (.cnx) connection in IDT(Information Design Tool)
• Designed Data Foundation (.dfx) using multiple data sources using IDT.
• Inserted calculated columns in tables at Data foundation level.
• Defined Business rules (Joins, Alias & Contexts) in Data Foundation.
• Published Data Foundation and Secured connection to Repository.
• Experience in development, testing and implementation of SAP Business Objects Explorer Info Spaces using Non-SAP Data Sources.
• Extensively used WebI Info view, reporter and explorer for querying, reporting and analysis tasks.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Designed Universe Schema by inserting tables (from backend data source) into the structure pane in designer and developed Classes and Objects (according to business terminology) in the Universe pane.
• Created complex objects using various @functions such as @select, @prompt, @where at universe level.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Worked on Global filters at the universe level to restrict retrieval of data.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Designed Complex that involved complex calculations, grouping of dimension objects and measures with If then else logic, extensive usage of Local, Global, and Shared variables at report level.
• Developed WEBI reports from Info View and using advanced functionalities like Optional prompts, Merge function, Custom SQL at Report level.
• Worked in TCO Environment
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis.
• Developed Canned Reports and ad-hoc reporting environments using existing/modified universe by utilizing Dynamic and Cascading Prompts.
• Used various charts like pie, line and stacked bar charts to provide different visualizations.
• Performed extensive Unit Testing before submitting the reports for testing.
• Exporting the reports in PDF format and sending them to the user inbox and also posted reports on PCAOB website.
• Pulled data from Multiple Access databases using SQL
• Participate in weekly meeting with the management team and walkthroughs.
• Worked extensively with Xcelsius 2008 and created innovative Dashboards for the existing Summary level Reports using QAAWS.
• Worked with Xcelsius Web-connectivity components such as Web-Service Component, Live Office Connector etc. to establish live connectivity to the dashboards with the database tables, views and BO universes.
• Inserted different add-ons like Crosstab Modeler 2.0 to the Xcelsius 2008.
• Published The Xcelsius Dashboards to the users and involved in sharing Knowledge with Team members
• Trained the end users in working with the Business Objects user module, Dashboards and provided technical expertise.
• Designed complex sub reports with Linked and Unlinked sub report and used different Custom Functions and worked with various Financial Functions.
• Designed Report with sub reports and sharing values between main report and sub report. Also designed complex Cross Tab Reports.
• Designed reports with Parameter and Cascading Parameters.
• Designed reports with different types of Charts with Drill Down feature up-to 10 levels. And designed various types of Dashboard Reports. Designed Report Templates.
• Designed reports with all types Graphs and Charts as a Dashboard Reports.
• Designed reports with conditional hiding, formatting and suppressing the section and groups and conditional sorting the report columns based on the parameter.
• Designed report with multiple Groups, Group by intervals, Groups selection, Hierarchical Grouping, Summary Group and hyper linked reports.
• Designed and modified new and existing Universe as per the requirement.
• Designed complex Web Intelligence reports using Business Objects Enterprise XI R3.
• Provided Production support for the WebI, DeskI.
• Trained the end users to use the Business Objects reporting module (Desk Intelligence Web Intelligence).
• Worked on issues/tickets opened (in Clear Quest) by end users on a day to day basis.

Environment: Business Objects 4.0/ XIR3.1, (Designer, WEBI, Web Rich Client, Xcelsius 2008, Crystal Reports 2011/2008), Business Objects Explorer 3.1, Data Services, Oracle 10g, Toad9.7, ClearQuest7.0 and ClearCase7.0.

Confidential, TX

BO Developer

Responsibilities:

• Interacted with Business Usersto gather and analyze the Business Requirements to build the reporting applications.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Involved in creation of Stored Procedures and VBA procedures to retrieve the data faster and generate the reports quickly.
• Used various join methods like Equi-join, Outer-join in designing the universes.
• Designed Universe Schema by inserting tables (from backend data source) into the structure pane in designer and developed Classes and Objects (according to business terminology) in the Universe pane.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Used various charts like pie, line and stacked bar charts to provide different visualizations.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Fine-tune the existing universes to enhance their performance.
• Exported the universes to the Repository making resources available to the users.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments
• Scheduled daily/monthly reports using Broadcast Agent Server.
• Created Parameterized, Cross-Tab, Drill down and Summary reports with options such as grouping, sorting, drill down and prompts.
• Extensively involved in using of formulas fields, parameter fields, Running Total Fields, Group selection, record selection, and Crystal syntax in Crystal reports.
• Created Period reports: shift or daily report, weekly, monthly and annual reports.
• Used Broadcast agent for scheduling and batch processing of Business objects and Web intelligence documents.
• Created complex calculations, logics and applied ranking based on certain measures in reports.
• Created @ prompt functions, Union, combined queries for some of the complex reports.
• Did a through testing of all reports comparing to the database output. Captured each output in a document for users to do their UAT.

Environment: Business Objects XIR3.1/XIR2 (CMC, Universe Designer, Desktop Intelligence, Web Intelligence, Dashboards), Crystal Report s 2008, Crystal Xcelsius 2008, VBA, Oracle 10g, Toad9.7, Windows XP.

Confidential, NJ

Business objects Developer

RESPONSIBILITIES:

• Analysis of Client specifications and custom design applications.
• Worked on troubleshooting of different database connectivity, performance tuning.
• Installed Business Objects Enterprise and Published reports on Business Objects Enterprise Server and got involved in Business Objects Enterprise Administration.
• DefinedUsers, groups, categories & connections with CMC.
• ImplementedImport wizard & publisherfor migrating reports &universes.
• Facilitate with tech Support to Formulate a Strategy for Implementing good User support.
• Designed architecture & set up for development, production & test repositories.
• Implementedweb intelligencein distributed (clustered) Environment.
• Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database.
• Created Universes based on the dimensions, detail and measures required for the analysis.
• Experience in the development of reports for financial needs of the business using Business Objects Reports.
• Created Web Intelligence documents for user reporting needs, to retrieve data by building queries using Business Objects universes and to use Web Intelligence to enhance documents for easier analysis.
• Developed Webi reports with Parameters, Sub-reports based on Stored Procedures and Queries by using Business Objects reports.
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
• Worked on VB Macros SDK to extract the data from CMS to maintain the statistics of the environment.
• Experience in Scheduling the Reports using Business Objects Enterprise.
• Published Reports in Business Objects Enterprise via Publishing Wizard and Business Objects Management Console.
• Installed and configured Crystal Reports XI and Created and Maintained/administer User groups in Crystal Enterprise.
• Created interactive excel dashboards and charts and graphs, created scorecards, metric analytics with Crystal Xcelsius.
• Experience working with Crystal Xcelsius to display summary-level business data in a rich and intuitive format.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Participate in developing “best practices” data warehouse standards for production support environment.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

Environment: Business Objects Enterprise XI R2, Crystal reports XI, Xcelsius 4.5, Web-Intelligence, SQL SERVER 2005, SSIS, T-SQL, VB, UNIX and Win 2000.

Confidential

BO/Crystal Developer

Responsibilities:

• Actively involved in creating and updating users/user groups and maintained user profiles using Supervisor.
• Created Classes and Objects (Measure, dimension and detail) in the universe.
• 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.
• Designed and Maintained Universes and exported them to the repository.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• A developed report with VB Macros to pass parameters while the report is scheduled and automatically emails to end-users as agnostic document.
• Interacted with the business users to understand their requirements and documented the scope and specifications.
• Created reports using standard company templates. A few of them were created based on the Department requirements.
• Formatted reports as per the user’s requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Created user Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Involved in the creating the reports on the web using the WebIntelligence.
• Generated complex reports using Business Objects.
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, and Drill filters.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Provided extensive support for the users on application usage and trained users in the functionality of the software.

Environment: BusinessObjects 6.5/5.1, Supervisor 6.5, Designer 6.5, Desktop Intelligence 6.5, VB, Oracle 8i/7i, VBScript, MS Excel, Windows 2000.