SUMMARY

• Over 7+ years of experience as a Business Objects Developer in full life cycle design and development of Business Objects 4.0/XIR3.1/R2/6.5 (Info View, Web Intelligence, Import Wizard, SAP Crystal Presentation Design/Xcelsius, QaaWS, Live Office, Central Management Console).
• Extensive experience in all phases of the Software Development Life Cycle (SDLC) such as Requirements Gathering, Analysis, Design, Implementation, Maintenance and also involved in the Production Support.
• Involved in the Support, Design and help with Requirements gathering with respect to Data movement between ECC, BW and other application areas.
• Good knowledge on best practices in designing and supporting BI applications.
• Experience in Identification of Business and Data requirements and converting them into conceptual and data models.
• Good at Database Design, conceptual, logical and physical Data Modeling, Star Schema, Snowflake; FACT and Dimensions tables, slowly changing dimensions (SCDs) using ERWIN.
• Extensive experience working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
• Experience in designing Universes, writing LOVs, and good exposure with Slowly Changing Dimensions (SCD).
• Immense experience in solving loops and traps using Contexts and Alias, setting up Custom Hierarchies, Derived Tables, Aggregate Awareness to enhance the performance of SQL
• Experience in creating users and user groups, restricted access of the users as needed using Central Management Console (CMC). Involved in managing users, groups, folders and published reports using Central Management Console.
• Good hands on Experience in Migration and Up gradation from Previous Versions to the Latest Versions of Business Objects(6.5 to XIR1/R2 & XIR2 to XI3.1 & XIR3.1 to 4.0)
• Well capable in creating Multifaceted Canned/Ad - Hoc reports using Business Objects, Web I
• Created Highly Complex, Custom Line Graphs, Bar Charts with shared data of main and sub reports data using Crystal Reports
• Experience in creating interactive dashboards to visualize complex data quickly
• Experience in creating several reports in WebI with Business Objects functionalities like Breaks, Alerts, Filters, Variables, Formulas, Ranking, Query Prompts and Drill filters.
• Developed effective and Complex Reports using Drilldown reports, Sub-Reports, cross tab reports, Parameterized Reports and Formula Reports.
• Expert in tuning the performance of SQL queries and ETL process.
• Involved in using Xcelsius to transform Microsoft Excel spreadsheet data into interactive flash media files for the upper level management
• Highly efficient in creating dashboards using SAP Crystal Presentation Desgin / Xcelsius with metrics, alerters and analytic templates and generated Goals using Performance Manager for executives to monitor and track business performance.
• Experience in Import Wizard and Report Conversion Tool for migrating the Universes and Reports between different environments like Development, QA and Production.
• Strong interpersonal skills with the ability to interact with end-users, managers and technical personnel. Proficient in learning new technologies and quickly adapting to new environment.

TECHNICAL SKILLS

Business Intelligence Reporting Tools: Business Objects 4.0/3.1/XIR2/R1/6.5 (CMC, Info View, Supervisor, Reporter, Broadcast Agent, Repository Migration Wizard, Designer, Web Intelligence, Desktop Intelligence, QAAWS, Live Office, SAP Crystal Presentation Design / Xcelsius 2008

Utilities: Erwin 3.5, TOAD, SQL * Loader

Operating Systems/Platforms: Windows Xp/NT/2008, UNIX

Database/Data Warehouse Servers: Oracle 11g/10g/9i, SQL Server 2008,Teradata,DB2,MS Access, Netezza

Programming Languages: SQL, PL/SQL, Java, C++, C, Unix Shell Script, HTML, XML, Java Script

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Sr Business Objects developer

Responsibilities:

• Interacted with Business Users to know their Business needs to effectively develop and modify Universes and Reports.
• Involved in gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Involved in Full life cycle of Business Objects reporting Application right from requirements gathering till the deployment of the Business Objects reporting system on to the production.
• Defined and Created Hierarchies as per the business rule for the reports to be viewed at selected reporting level. Checked the Integrity of the Universes and exported the Universes to Repository for making available to users.
• Interacted with users to know their approach and assisted in developing and modifying Reports accordingly.
• Created different Ad-hoc and Complex Canned Reports using Master/detail, Cross Tab and Charts for graphical representation in the reports.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Created Queries, Calculations, Variables, Breaks, Section, Ranking, Filtering, Sorting, and Formatted Presentation Styles (Graphical) and Alert’s to draw attention to a particular block of data by highlighting it. Most of the reports involved using multiple data providers, Free hand SQL, 3D Pie charts, Formula and formatting using slice and dice panel.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.
• Involved in displaying data from legacy systems and relational databases and also in creating, modifying reports using tables, views, functions and stored procedures.
• Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.
• Analyzed the Client Requirements and prepared the Dashboard specification document.
• Used SAP Crystal Design Presentation of dashboards to pull the data from the required reports to Excel sheet by using Universe as data source. QAAWS & Web services, Live Office as a middle ware using Data feeding to Excel sheet. And analyzing, Designing and developing dashboards.
• Responsible for improving the Business Objects query performance by tuning the Queries, Database and server parameters.
• Reverse engineering of SAS reports using ETL (SSIS) and Business Objects universes and reports.
• Provided end user and production support after deploying the application into the production environment. Also provided extensive support for the users on application usage and trained users in the functionality of the software.

Environment: Business Objects 4.0, Designer, Web Intelligence, Info View, CMC, SAP Crystal Presentation Design 2011, Query as a Web Services(QaaWS), Live Office, Informatica 8.1, Oracle 11g, MS SQL Server 2008, TOAD, Windows 2008.

Confidential

Business Objects Developer

Responsibilities:

• Involved in developing, testing and deploying reports to the production environment.
• Developed BO reports and dashboard visualizations for profitability and monthly sales analysis, forecasted sales with what if analysis.
• Identified and defined Universe structure required by business users to build the reporting application.
• Experience on merging data from multiple universes.
• Developed Universe objects and report mappings for Reports, Modified the universe, created classes and objects by retrieving the data from various data sources.
• Created predefined conditions, prompts and custom hierarchies in the process of building the universes.
• Resolved loops using contexts and aliases to remove the cyclic dependencies.
• Hands-on experience in developing Analytical Dashboards using SAP Crystal Presentation Design with QaaWS and Live Office connectivity.
• Applied Time standard Monthly Reports, Quarterly Reports, Annual Reports published by Revenue. Used Add-on components to create the Dashboards.Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, inserted calculations, Filters, Sorts.
• Involved in designing Business Objects Queries, and Reports.
• Created Index Awareness and Derived Tables to improve the performance.
• Worked extensively with @functions like (@select, @prompt, @where @aggregate aware) to write flexible SQL queries.
• Created reports with Multi-Level Scope of Analysis using drill down.
• Created standard Web Intelligence reports.
• Migrated and Imported Universes, Web Intelligence Reports from XIR3.1 to XIR4.0 using Import wizard.
• Worked on complex reports for a report generation based on user needs.
• Involved in Troubleshooting the data problems associated with reporting.
• Provide technical support for troubleshooting and fixing of business objects/web Intelligence reports.

Environment: Business Objects 4.0/XIR3.1, Universe Designer, Central Management Console, Web Intelligence, SAP Crystal Presentation Design 2011, Import Wizard, Oracle 10g, SQL Server 2008, TOAD, SQL * Loader, Windows 2008, UNIX.

Confidential, Orlando, FL

Business Objects Consultant

Responsibilities:

• Interacted with Business Users and End Users to know their Business views in developing and modifying Universes and Reports accordingly.
• Worked on full life cycle of the project including requirements gathering, prototyping, Effort estimate, Impact analysis, development, UAT, Production and Postproduction support.
• Analyzed business model and, created Business Functional Specifications, Functional Design Specifications, and Detailed Design Specifications.
• Assisting the client through analysis of their existing system, challenges, and business needs
• Documented the reporting requirements, dashboard design requirements by thorough interactive sessions with Business users by building prototypes for developing the interactive executive level dashboards.
• Designed, Developed and Maintained Universe in BOXIR3 Designer by defining joins and indicating cardinalities between tables in star schema (fact and dimension table) from data warehouse, creating Aliases to resolve the Loops, subdividing into Contexts to remove cyclic dependencies.
• Created the objects, which are grouped into classes for convenience in Business Objects Designer. Created custom List of Values. Used @Aggregate Aware, @Where, @Select, @Variable, @Prompt and @script functions when required.
• Created WebI reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Created Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Created complex reports using complex variables, multiple breaks, sorts, cascading prompts, Union Queries, Slice and Dice, Drill Down, Master Detail, Custom Sorts, Templates, Pivots etc. Extensively used breaks for white spaces and sections for better navigability.
• Tested all the reports with different scenarios like query balancing, look and feel and formatting of the reports based on the specifications.
• Analyzed and provided inputs for enhancing the process of migration from Business Objects XIR2 to Business Objects XIR3.1.
• Documented procedures and strategies involved in setting up the environment for Business Objects XIR3.1
• Set up groups and users for Business Objects deployment. Managed user and user group profiles using Supervisor.
• Responsible for SQL tuning and optimization using Explain Plan, TKPROF, Indexes and optimizer hints.
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.

Environment: Business Object XIR3.1/XIR2, Xcelsius 2008, Designer, Web Intelligence, Info View, CMC, Informatica 8.1, Teradata V2R7, SQL, PL/SQL, SQL Server 2008, SQL Assistant, Erwin 6.1, Windows 2003.

Confidential, Hartsville, SC

Business Objects Developer

Responsibilities:

• Created prototypes of the reports for user presentation in the process of requirements gathering.
• Installing, upgrading and troubleshooting the Business Objects Enterprise.
• Created new users in XI 3.0 using Central Management Console and set restrictions, assign privileges based on their profiles.
• Interacted with Business community to gather and analyze the Business Requirements in developing and modifying Universes and building the reports.
• Resolved Chasm traps, Fan Traps & Loop problems by using contexts and aliases to reduce the complexity of the universes.
• Extensively used the @functions, worked on back end functions, procedures, tables, views required by the business objects universes.
• Created Dynamic Filters and Dynamic Conditions in universe level as per Business rules.
• Created custom List of Values (LOVs) for better understanding of prompts by the end users.
• Improved the performance and reduced the coding with the use of @functions like @Prompt (for user defined queries), @Where (for creating conditional filters), and @Select to create duplicate objects in the process of building the Universes.
• Defined Customized Hierarchies in Universe level.
• Applied User and Group Restrictions in selected objects in universe level based on User and Group.
• Designed and Developed WEBI reports, created charts and graphs for quick analysis.
• Created Report Level Variables, Objects and Formula to create new columns based on the result set.
• Preparation of Critical, Master Detail, Sub Reports, Cross Tab and Summary reports using WebI Reports, features includes functions, running totals, parameters and conditional formats.
• Created Dashboards using Xcelsius for senior management for business decision making.
• Developed Dashboards and Scoreboards for detailed analysis using Xcelsius.
• Provided user support and in using Report Designer for creating Adhoc reports.

Environment: Business Objects XI R3.0, CMC, Designer, Infoview, Xcelsius, Toad, SQL, PL/SQL, Oracle 9i,SAAS,WebLogic 10.3g, SQL Server, Windows NT.

Confidential

Business Analyst / SQL Developer

Responsibilities:

• Determined user/business/functional requirements. Created vision, scope, and use case documents; Design diagrams.
• Worked with SQL queries for data manipulations.
• Designing and developing softwareapplications, working following rules of SDLC (SoftwareDevelopmentLife Cycle)
• Developed several Oracle stored procedures and functions for reports
• Worked on database connections, views, parsing of objects
• Designed data models using compare, forward/reverse engineering naming standards.