PROFESSIONAL SUMMARY:

• 7+ years of Experience in Business Objects XI 3.1/XI3.0/XIR2/XIR1/6.x/5.x (Designer, Info view)/Business Objects Data Services(BODS), Central Management Console, Central Configuration Management, Desktop Intelligence, Web Intelligence, Import Wizard, Supervisor, Full client, Administration console, Reporter, Publisher) and Crystal Reports XI.
• Expertise in designing, development and deployment of complex Universes.
• Developed reports using SAP WEBI using BI 4.0.
• Created new Universes on Business Objects 4.0 relating to HR for In - house project.
• Expertise in planning, designing, developing, modifying, updating, maintaining and distributing Universes and Reports.
• Good experience of Data Warehouse Concepts including Schemas and Data Modeling.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star Schema, Snowflake Schema, Fact and Dimension Tables, Physical and Logical data modeling using Erwin 7.2/4.0/3.5, Toad Data Modeler, Microsoft Visio.
• Experience in Querying and Reporting modules of Business Objects Enterprise XI.
• Extensive Knowledge in using Business Objects functionalities like Slice and Dice, Drill down, @ Function, Cross Tab, Master Detail, and Complex Formulas.
• Worked on Info View to create Web Intelligence, Desk Intelligence Reports over the Universe Created.
• Experience in Installation, Administration of Business Objects Enterprise and Migration from Business Objects XIR2 /6.x to XI 3.1.
• Experience in building multiple universes, retrieving data using universes, personal data files and creating complex ad-hoc reports using Business Objects, Crystal Reports and WEBI.
• Extensively worked on Business Objects Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduling of Reports in CMC on Daily, Monthly, Weekly basis.
• Strong data analyzing experience in designing and implementing universes using Business Objects Designer involving the creation of underlying database structures, resolving loops, resolving chasm and fan traps, creating classes and objects, Conditional Objects and joins, and testing the integrity of the universe.
• Experience in performance tuning of the Business reports, universes and database and used @aggregate aware functions in the universe to improve the performance of the query by cutting down on the size of the result set at the data provider level.
• Worked with Crystal Reports 2008/XI for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports and data reports.
• Technical proficiency in creating interactive dashboards and scorecards using Xcelsius and Performance manager.
• Experience in Software Development Life Cycle of Business Intelligence and Data warehousing projects.
• Experience with Central Configuration Management (CCM), change control and source control Systems.
• Created complex Xcelsius dash boards by connecting directly with existing Crystal Reports and XML files.
• Excellent team player, interfacing across business and technical groups and ability to work independently and highly motivated. Exceptional ability to quickly master new concepts and applications.

TECHNICAL SKILLS:

Business Intelligence: SAP Business Objects XI R2/R3.1/6.1 (Designer, Desktop Intelligence and Web Intelligence), Crystal Reports 5.0/6.0/7.0/8.0/8.5, Forms 4.5, Reports 2.5, SAP BI 7.0, Xcelsius 2008.

Data Modeling: Star-Schema Modeling, Dimensional Modeling, Snowflakes Modeling, FACT & Dimensions.

Programming: C, C++, ASP, SQL, PL/SQL.

Utilities & Tools: Make, SCCS, PVCS, OLAP/OLTP, Rational Rose, GDB, Toad.

Operating system: Windows XP/NT/2000/98/95, Windows 2003, Solaris 10, UNIX

Database: Oracle 10g/9g/8g, Adaptive Server Enterprise 11.9.2 (Sybase), Informix, Teradata Database, MS Access, DB2, SAP BW 7

Project Management: Oracle ADI 11.2, MS Project, MS Access, MS Visio and MS Excel.

Environment: Win 3.x/95/98, Win NT 4.0, Windows 2000/2003 server, Sun Solaris 5.8/2.6, Sun OS 4.0, MP-RAS Unix, MS-DOS 6.22, Novell NetWare

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

Sr. Business Object Developer

Responsibilities:

• Interacted with Business Objects users by conducting meetings to discuss the projects/enhancements requirements.
• Drafting the functional and technical documents.
• Managed users and groups and implemented folder level and application level security in the CMC
• Created additional job servers and WEBI processing servers for load balancing in CMC
• Responsible for Developing and Maintaining and the Business Objects Universes.
• Identify and resolve the potential universe issues like loops, Chasm Traps and Fan Traps and resolved them using techniques like Contexts and Aliases.
• Extensively used formula fields, parameter fields, Running Total Fields, Group selection, record selection, and Crystal syntax in Crystal reports.
• Developed Hierarchies in the universes to enable the multi-dimensional analysis in the reports using the drill feature.
• Created crystal reports with Standard, Cross Tabs and Grouping.
• Created complex reports using functions like @variables, @prompt, condition Objects and aggregate Awareness Functions.
• Created reports using multiple data source, flat-files and merged the dimensions to synchronize the queries.
• Created WEBI reports and exported the report content as web service to feed the input to Xcelsius dashboards.
• Created IDT connections in dev., test and prod for active reporting.
• Created multiple new universes in BO 4.0 as per the requirements adding new classes and objects. These universes were designed to support multiple levels of hierarchies for drill down functionalities.
• Created web intelligence reports using combined queries.
• Gathering business requirements from users for Business Intelligence reports and Data Warehouse.
• Working with the Oracle team and the ETL team to bring in data in the required format in the Data Warehouse.
• Developed reports using universe and excel data source and used merged dimensions to synchronize the queries.
• Created publications using Dynamic Recipients and Enterprise Users. And delivered the report content as inline email using HTML format.
• Creating the Dynamic and static dashboards using Live Office and QaaWS as source.
• Providing the production support and maintaining the SLAs.
• Promoting the code between the environments.

Environment: Business Objects 4.1/ XI 3.1, Web Intelligence Rich Client, Crystal Reports 8.0, Desktop Intelligence, Import Wizard, Live Office, Xcelsius, QaaWS, Red Hat Linux 5, Tomcat 5/6, Oracle 11g, SQL Server (MS SQL) 2012/2007, SQL Server Management Console.

Confidential, Dublin, OH

Business Objects/Crystal Reports Developer

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes and responsible for analysis on crystal reports migration.
• Improved the performance and reduced the coding with the use of @aggregate aware and tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Created Universes on top of SAP BW Info Providers for reporting with Web Intelligence.
• Used Analyzer in Business Explorer to analyze the data in the BW with Web Intelligence reports.
• Scheduled the reports on daily, weekly and monthly basis by using Scheduler.
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the Web Intelligence report.
• Developed Web Intelligence 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 and Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis) using Web intelligence Rich Client.
• Worked extensively with the major functionality of Business Objects like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008.
• Migrated Business Objects XI R2 content (users/user groups, Universes, reports) in to Business Objects XI 3.0 environment using the Import Wizard.
• Migrated Crystal Reports 8 to Crystal Reports XI and also responsible for testing and publishing reports.
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.

Environment: Business Objects XI 3.0/R2/6.5, Web Intelligence Rich Client, Xcelsius 2008, Crystal Reports, Info view, Teradata 13.0, SAP BW, TOAD, Windows 2003 Server.

Confidential, KS

Business Objects Developer

Roles & Responsibilities:

• Designed and developed BO reports and universes accessing Oracle data warehouses
• Worked closely with DBA to design data warehouse for reporting requirements
• Created customized lists of values for dimension codes and descriptions
• Implemented aggregate awareness to enhance the performance of SQL transactions
• Coded PL/SQL functions and packages to create reporting objects
• Utilized TOAD and SQL*Plus for creating/testing queries

Environment: Business Objects XI 3.1/R2 SP2 (Supervisor, Designer, Business objects), Xcelsius 2008, QAWS, Live office 3.1, Oracle 9i (MS SQL and PL/SQL), Teradata, SQL Navigator, TOAD, SQL server, MS Excel, Crystal Reports XI MS Access, ERWIN 3.5.2.

Confidential, MO

Business Objects Developer

Roles & Responsibilities:

• Installed Business Objects Enterprise Product client tools on local machine.
• Analyzed the Functional Design requirements and converting them to technical requirements.
• Preparation of Detail Design Specification documents for Universe and Report Development.
• Assisted the Data Services team in the design of database summary tables and preparing the detail design document on ETL Process to load these tables.
• Involved in development of Business Objects data integrator jobs, workflows, data flows to extract, transform the source data and loading the target tables.
• Created Universes in such a way, that would enable to create Ad-hoc reports and analyze them in different angles using techniques like slice and dice, drill down, using Oracle as backend data bases.
• Created Classes, Objects, Measure objects, Joins, short cut joins, @prompts and predefined conditions in the universes.
• Defined Custom Hierarchies at Universe level to implement drill down functionality in the reports.
• Resolved loops in existing universes using Aliases and defining Contexts.
• Implemented Aggregate aware function and set up aggregate navigation with objects derived from standalone tables within the universes.
• Applied index aware functionality on non indexed column objects to increase the performance by directing the report query to select the index fields from the database for faster retrieval of data.
• Created Cascading Prompts at universe level for dynamic selection of data within a hierarchy as per the user requirement.
• Built drill-down reports using Scope of Analysis and drill filters functionality within Business Objects Web Intelligence.
• Created templates to customize style and structure according to the employer's needs.
• Involved in building applications from an ASP based environment that helps users for exporting reports and handling scheduling tasks.
• Used Crystal Xcelsius 2008 as a Data Visualization Tool to transform some Microsoft Excel spreadsheet data into visuals such as Pie-Charts, Bar Graphs, Scorecards that can be shared via PowerPoint and PDF files
• Involved in Migrating Business Objects system from version BO XI R2 to BO XI 3.1 using the Import Wizard Tool.

Environment: BO XI R 3.1 (Universe Designer, Reporter), BO XI R2 (CMC, CMS, Designer, Desk I, Web I), Web I XI R2, Info view, BO XI 3.0,IBM DB 2 version 6, PL/SQL, SQL, Crystal Xcelsius 2008, DB Visualizer 6.0.2,BO SDK, MS Access 2003, Windows XP Professional.

Confidential

Business Objects Developer

Responsibilities:

• Participates with internal clients to define software requirements for development, maintenance and improvements.
• Designed and Created universe based on user requirements.
• Organized the universe by creating Classes and Objects.
• Resolved Loops by creating Aliases and Contexts.
• Exported Universes to repository for making it available to users.
• Defines and develops BO reports for accessing/analyzing data in warehouse.
• Generated Multi-Dimensional reports, Drill up and drill down, Cascading prompts and Slice and Dice reports.
• Created business objects reports using free hand SQL and Store procedures.
• Using SQL*LOADER loads data from external files in to tables of oracle database.
• Created and formatted the Reports using Desktop Intelligence, Web Intelligence and Crystal Reports.
• Exported the Reports to Repository for making it to available for the Users.

Environment: Business Objects XI R2/6. 5, Infoview, Desktop Intelligence, Web Intelligence, Dashboard Manager, Crystal Reports, XIR2, Oracle10.g, SQL,SQL Server, PL/SQL, Toad, Erwin 4.0 and UNIX.