SUMMARY

• Over 7 years of experience in Information Technology with strong work experience as Business Objects Developer.
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
• Expertise in Business Objects enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM) and its deployment.
• Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.
• Experience in creating Adhoc reporting ready universes using Business Objects Universe Designer.
• Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.
• Excellent data - analysis skills and ability to translate specifications into a working Universe and/or Report.
• Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
• Extensively used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks.
• Installation and configuration of Xcelsius, QaaWS Client Server Modules and designing complex reports and dashboards in monitoring business metrics.
• Hands-on experience in developing Analytical Dashboards using Xcelsius with QaaWS and Live Office connectivity.
• Experience in Migrating Business Objects from one version to another.
• Experienced in Training & Supporting end-user reporting needs using Business Objects.
• Strong database experience in using Oracle 10g/9i/8i, MS SQL Server 2008/2005, MS Access.
• Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including both OLAP & OLTP data and complete lifecycle of project from design to development and implementation.
• Exposure to Dimensional Data modeling- Star Schema modeling and Snowflake modeling.
• Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals. 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 Objects Tools: Business Objects XI 3.1/3.0, XI R1/R2,6.5, Web Intelligence XI 3.1/3.0/XI R2, Universe Designer XI 3.1/3.0,XI R2, Desktop Intelligence, InfoView, CMC, Import wizard, Report Conversion Tool, Data Integrator 11.5/XI 3.0, Xcelsius 2008, Query as a Web Services(QaaWS), Live Office.

Databases: Oracle 10g/9i/8i/8.0, MS SQL Server 2008/2005, MS Access, Siebel, Sybase, Teradata, Informix.

Data warehousing: Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables.

Operating Systems: Windows Server 2003/2000/NT, Windows Vista/ XP/ME/98/95, DOS, UNIX.

Windows Utility: MS-Word, MS-Excel and MS-PowerPoint.

Programming Languages: SQL, PL/SQL, JAVA, HTML, C, C++, C#, .NET

Dimensional Data Modeling Tools: Dimensional data modeling using Erwin modeling (Erwin 4.1/4.0/3.5.5/3.5.2 ), Physical & Logical Data Modeling, multidimensional modeling, Snowflake Schema/ Star Schema modeling (Normalization / De-Normalization Techniques), Erwin, Visio.

Query Tools: TOAD, SQL*PLUS, SQL*Loader, SQLNavigator.

PROFESSIONAL EXPERIENCE

Sr.Business Objects developer

Confidential, VA

Responsibilities:

• Inventory, Accounts Payable and Purchase Orders were the different subject areas within the data warehouse.
• Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
• Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.
• Participated in the complete development lifecycle: analysis, design, build and test reports
• Created several complex Web Intelligence and Desktop Intelligence reports to help management to track and monitor contract, commodity and price compliance.
• Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.
• Created User Prompts, Conditions and Filters to improve the quality of report generation.
• Scheduled Reports using scheduler Infoview as well as CMC.
• Key metrics ‘procure to pay cycle times’, ‘diversity spend’, ‘cash discounts captured and missed’ spanning across different subject areas has been re-created using Xcelsius.
• Consolidation of reports by groups/regions and designing templates catering to the needs of sourcing/financial analysts & material and cost specialists.
• Providing support for the users on application usage and conducting training walk through of salient features of the application.

Environment: Oracle 10G, Business Objects XI 3.1, Web Intelligence, Infoview, Desktop Intelligence, CMC, Import Wizard, Universe Designer, Java script, PL/SQL Developer, Windows 2003 advanced server.

Sr. Business Objects Developer

Confidential, VA

Responsibilities:

• Interacted with Business Users, Business owners to know their Business requirements in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
• Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
• Exported the ad-hoc ready universes to the for making semantic layer available to the users.
• Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables required by the business objects universes.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Created Xcelsius dashboard for executive view covering selected KPI for the business function
• Created WSDLs using Query As a Web Service (QaaWS) from different Data sources.
• Migrated Xcelsius dashboards and deployed QaaWS to the new servers and fixed the hyperlinks and excel spreadsheet to be compatible in new environment.
• Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.
• Created complex reports by linking data from multiple data providers, stored procedures and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.
• Extensively worked with Ranks, Alerter, filters, prompts, variables and calculation contexts in designing reports.
• Built WebI reports Provided OLAP functionality and worked extensively with data warehousing.
• Set up groups and users for Business Objects deployment.
• Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
• Extensive testing and migrating the reports or objects from development to Production system.
• Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards and other Business Objects Applications in new environment.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.

Environment: Business Objects XIR3.1, WebI, Xcelsius, Universe Designer, Oracle 8i/9i, PL/SQL, Windows XP/7.

Business Objects Developer

Confidential, California

Responsibilities:

• Involved in understanding the end-user requirements and business processes in creating and designing universes, queries and reports.
• Designed Universes, incorporating all the business requirements.
• Implemented object level security universe to in corporate security for sensitive information.
• Worked in migration of universe and reports between environments.
• Designed universes, solved loops by creating aliases, contexts and resolved traps.
• Created complex variables, breaks, sorts, filter and conditions for various reports.
• Created complex reports involving master/detail and cross-tab and Combined queries and sub-queries
• Linked multiple data-providers and Used calculation contexts/extended contexts
• Coordinated with DBA and Business objects designer group in solving various technical issues.
• Created multiple contexts for catering different functional areas in a single user query.
• Used Aggregate awareness function of Business Objects to route the query objects through the appropriate path while selecting from multiple contexts..
• Used prompts in the reporter as well as in the universe to create more interactive reports for running different kind of campaigns.
• Extensively used scheduler for report scheduling and deployment
• Generated various report templates for standardizing the reports throughout the organization.
• Involved in end user training and documenting the procedures.
• Involved in developing the financial reports for the Financial services Dept and successfully published the highly formatted reports and met with the end user requirements
• Resolved Year Ago Variance Calculation, Percentage Calculation in Cross Tab in Web I XI R2.
• Scheduled pre-canned reports through Scheduler for distribution and printing.

Environment: Business Objects XIR2, Web Intelligence, Xcelsius 2008 Oracle 9i

Business Objects developer

Confidential, CA

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Designed several universes and used various methods to optimize queries on database, universe and reporting level.
• Worked towards optimal development of universes by removing loops through the use of aliases and contexts.
• Creating Universe with number of Classes, many objects, Derived Tables using inner/outer and equiv. joins as per requirement.
• Created and tested classes and objects to organize the universe.
• Exported the universes to the Repository to make resources available to the users.
• Created reports for various Portfolios using the Universes as the main data Providers.
• Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc.
• Applied drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Extensively worked with Ranks, alerters, filters, prompts, variables and calculation contexts in designing reports.
• Created Business Objects Repository while building Business Objects solution.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Created Derived tables, Developed Stored Procedures, Packages and Triggers database using PL/SQL.

Environment: Business Objects XIR2, Web Intelligence, Universe Designer, Oracle 8i/9i, Windows NT.

Business Objects developer

Confidential, Denver, CO

Responsibilities:

• Information gathering - interacted with the end user to understand the requirement and business logic
• Analyzed the existing OLTP system and designed and managed universes based on the Business Requirements
• 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
• Customized the list of values (LOV’s) which helps the end users to select the values.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance
• Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports.
• Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas, etc.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Scheduling reports from the Broadcast Agent Server to only requested users.
• Worked extensively on Web Intelligence for any new requests and performance issues.
• Involved in installing Web Intelligence, creating users, user groups and categories
• Generated reports for web users using Web Intelligence and Info View.
• Created Web Intelligence documents and published them to corporate documents.
• Worked with Installation and configuration of Business Objects XI R2 using Tomcat and Apache as Application and Web Servers.
• Migrating Business Objects 6.5.1 version reports to new version XIR2.
• Converted the existing full client reports to WebI reports using Report Conversion Tool.
• Imported existing users, groups, categories, WebI documents, connections, universes and restrictions to BO XI environment using Import Wizard.
• Created reports using Desktop Intelligence and Web Intelligence in BO XI R2 environment.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Web XI R2.
• Extensive testing and migrating the reports or objects from development to Production system

Environment: Business Objects 6.5.1 (Supervisor, Designer, Reporter), Web Intelligence 2.x/6.x, BCA, BOXI R2 (CMS, CCM, CMC,), Oracle 10g, PL/SQL, SQL Server 2000, Windows 2000, UNIX, Crystal Reports XI/9.0, Crystal Xcelsius, PeopleSoft FMS 8.9.

Business Objects Developer

Confidential

Responsibilities:

• Analysis of Business Objects environment, Universes, Reports.
• Add more groups and change the profile of users via supervisor.
• Developed Universe using Designer module in Business Objects.
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Specified the Joins and checked the cardinalities.
• Implemented User Objects in Reports.
• Created Condition in Universe.
• Ad-hoc reports were used for Business Objects user modules for various portfolios using the Universes as the main Data providers.
• Resolved loops by creating Aliases and Context.
• Organized data in reports by using filters, sorting, ranking and highlighted data with alerts.

Environment: Business Objects 6.5, Web Intelligence, Oracle.