Business Objects Developer

Location:

Posted:

February 23, 2016

Resume:

Professional Summary:

Over * years of IT experience in application software analysis, design, development, implementation, maintenance, and documentation of various commercial applications in all phases of project life cycle includes expertise in Business Objects, Crystal reports, Crystal XCelsius.

Hands on experience in BI Tools, Business Objects 4.1/4.0/ XI 3.1/R3/R2/R1/6.5/5.1,Universe Designing and Information Designing Tool, Web Intelligence, Desktop Intelligence, Info View, Import Wizard, LCM,CMC, XCelsius Dashboards, Crystal Reports 2008/XI/9.0.

Hands on experience in project management, requirement analysis, documentation and good understanding of SDLC.

Experienced in developing Complex, Canned and Adhoc reports.

Developed, designed, supported and tested Universes and Reports.

Experience on Data Cleansing and Data Quality at Database Level and Universe Level.

Built, designed, and tested executive level OLAP reports using Business Objects.

Experience in using Import Wizard and LCM to migrate reports and universes between different environments like development, testing and production

Designed and linked various universes for query and reporting using Design Model.

Expert in designing, developing, maintaining and optimizing the Universes using Designer module and IDT in BI4.0.

Universes with classes, objects and condition objects. Designed, developed and maintained Universes by defining joins, creating alias and contexts.

The universes supported the creation of both pre-defined as well as ad-hoc reports. Extensively used @ functions and customizing LOV’s.

Expert in implementing aggregates, linked universes, drill-through and dynamic modules.

Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, and Drilling methodology, Filters, Ranking, Groups, Sections, Graphs and Breaks.

Having knowledge on creating Business Objects universes on top of Bex Queries.

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.

Tested business objects reports for data validation and compared results with TOAD.

Worked with various Relational Databases Oracle 11g/10g/9i/8i, SQL Server 2000, Teradata & IBM DB2.

Experience in Star-Schema Modeling, Snowflake Modeling, Fact, Dimension tables and Dimensional Modeling using Erwin tool.

Experience in various Crystal Environments extracting data from multiple sources, applying several functionalities and used different Data providers like OLEDB, ODBC, etc. Created compelling reports with charts and crosstabs using Crystal Reports 2008

Created Crystal Reports using Crystal reports Formulas, Grouping, Parameters and Static/Dynamic Cascading Prompts to handle the customer’s requests from Tables, Stored Procedures, and Views.

Building and publishing XCelsius visualizations Using Live Office and QAAWS.

Experience on Migration of business objects universes and Reports, User security and Connections using import wizard and report conversation tool. And Promotion Management in BI4.0.

Experience in Business Objects Security Model and experience with Business Objects Security Implementation (Row level, Object level, Command level in all 6.5 and BI4.0/R3/R2/XI).

Working knowledge in transforming data from various data sources to a Data warehouse using Informatica as the ETL tool and interacting with the Business Analysts in identifying the needs and the requirements of the system

Extracted Data from SQL and Oracle data sources by SAP Data Integrator

Experience in writing PL/SQL Stored Procedures, Functions, packages and Triggers using Oracle11g, SQL and PL/SQL.

Good knowledge and experience in data warehouse development life cycle, requirement analysis, dimensional modeling, and implementation of STAR, Snowflake schemas.

Good working Experience in deploying Web intelligence on different Web and Application servers like Tomcat, and IIS.

Provided training for end users for generating their own report including complicated report.

Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

Extensive experience in working with Ticket tracking applications like Remedy, Impact and CQ (Clear Quest).

Technical Skills:

BI & Reporting Tools

BusinessObjectsXI4.0/3.1/R2/R1/6.5/6.1/5.1,InformationDesigningTool, Web Intelligence, Desktop Intelligence, XCelsius Dashboard Designer, Universe Designer, CMC, Info View, Crystal Reports 2008/XI/9.0.

Data Bases

Oracle 11g/10g/9i/8i/7i, SQL Server 2000/2005/2008, MS Access, Teradata, DB2

ETL

Informatica, Data Services, Workflow Manager, Work flow Monitor, ETL, Data mart, OLAP, OLTP, Transformations, SQL*Plus, SQL*Loader

Frontend Tools

TOAD, SQL Navigator

Programming

Unix Shell Scripting, Kernel Programming, Perl Programming, SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, VB, Java, C, C++

Environment

Sun Solaris (Unix), Linux, Windows XP/2000/2003

Professional Experience:

ALEXION, Cheshire, CT April-15 - Present

Business Objects Consultant

Description: Alexion Pharmaceuticals Inc. is an American pharmaceutical company best known for its development of Solaris, a drug used to treat the rare disorders atypical hemolytic uremic syndrome (a HUS) and Paroxysmal nocturnal hemoglobinuria (PNH).The company is also involved in immune system research related to autoimmune diseases. Alexion has employed a strategy of developing drugs to combat rare diseases. Since the targeted user base is small for such drugs, clinical drugs tend to be quicker and cheaper than those for mass market drugs.

Administration:

Created users and groups in the CMC (Central Management Console) and managed their roles, responsibilities and privileges based on their usage levels. Published the reports using CMC and scheduling the reports to the specific users on daily, weekly, monthly basis.

Working experience on publications to schedule the reports to particular group of users, whenever the data present in the reports.

Recommendations for best practices within BI environment so as to make sure the Enterprise BI architecture is at its best.

Information Designer (IDT):

Created Universes using SAP Business Objects 4.0 IDT tool, resolved loops with aliases and contexts, and created specific dimensions based off requirements expressed by the end users.

Optimized and created objects in Universes using Information Design Tool and Universe Designer.

Created derived tables allowing for complex expressions, and joins otherwise not possible in the IDT

Built filters at the universe level giving users the ability to use frequently used conditions

Developed multi source universe using IDT based on Inventory and Order.

Created Universe, Classes, Measure Objects, Dimension Objects, and Detail Objects and applied Hierarchies based on Business logic.

Developed and Managed Universes with Complex Predefined Conditions and created Measure Objects with Aggregate Aware, Select, Case-Functions for Ad-hoc and Canned reporting to Forecast Sales and for the users to create Webi reports and drill-down on channel by location for required duration.

WEBI Report Development:

Created reports using multiple data providers such as Universes and personal data files in generating reports.

Reports Developed with PL/SQL Procedures and Free Hand SQL

Created reports using Crystal Reports with Standard, Summary, Cross Tabs and Grouping

Generated various reports on Daily, Weekly, Monthly and Yearly basis.

Created and modified the Webi Reports for various financial groups using the Universe as a main data provider.

Used Master Detail Reports to avoid repeating values, to display subtotals, and split the large data representation into small block data representation.

Generated Tabular and Cross tab for flexible data representation for the financial reports.

Used Ranking attribute for showing the extreme ranges of data like maximum and minimum data representation.

Drill mode Analysis helped to find out the factor behind breakdown of sales.

Created Graphical charts for easy graphical representation of data.

Provided support for Business Objects end users regarding Reports creation and updates.

Migration:

Used Import Wizard to migrate the universes, reports and rights from Development to QA and then to Production and Vice versa.

Migrated 3.0 Webi reports and universes to BO 3.1 and BO 3.2 to BI 4.0 and BI 4.1 environments.

Spotfire:

Gathered Business requirements and designed technical requirements documentation.

Created various complexes Cross tables, Bar Charts, Line Charts and Tree map.

Created Data sources for Report creation.

Customized data by adding Property Controls, Filters, Calculations, Summaries and Functions.

Created Complex Information Links to pull the data from Oracle 10g/11g and SQL database.

Environment: Business Object 4.0/XI 3.1, Crystal Reports 2008/XI, XCelsius 2008, Designer, Desktop Intelligence, Web Intelligence, CMC, Informatica 8.1, Oracle 9i/10g, SQL Server 2008, TOAD, Windows XP.

T-Mobile USA Snoqualmie, WA Dec-13 –Mar-15

Business Objects Consultant

Description: T-Mobile USA is one of the largest providers of wireless voice and data communication services in the US. The company operates the fourth largest wireless network in the U.S market with 49.1 million customers. The company’s nationwide network reaches 96 percent of Americans. It also provides wireless Internet access and other data services in airports and retail businesses through its T-Mobile Hotspot brand.

Administration:

Extensively worked as BO Administrator in Designing BOE environment and Security

Gathered the Business Needs and developed Functional and technical Specifications.

Successfully enabled LDAP for Business Objects

Supervised the Users and Groups in BO CMC.

Promoted Objects From DEV to QA to UAT and to Production using SAP LCM and Promotion Management, Including Security rights

Successfully Scheduled the reports based on Calendar based and Event based.

Prioritizing the Tickets and Resolving in effective manner to support Business.

Information Designer (IDT):

Maintained and developed universes for supporting ad hoc queries and reports according to the business requirements.

Resolved the potential issues for multiple fact tables and avoided the use of fact to fact joins.

Resolved the common critical path problems of Loops and Traps using the functionality of Aliases and Contexts.

Used Short-cut join, Self-restricting join and Outer join and set the cardinalities.

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 by creating Users/Groups/Sub-groups & assigning the privileges.

Involved in solving the discrepancies occurred in the ETL environment.

Evaluated the possible use of aggregate tables and worked with DBA team to create these tables

Designed hierarchies in universe for various reports and created user objects with calculations in universe

Used Views and created Derived tables at the universe.

Defined Row level and Object level security as per the requirement.

Responsible for Unit Test, SIT (System Integration Test) and UAT.

WEBI Report Development:

Developed Webi reports providing an easy-to-use interface with powerful query features. This reduced the report backlog and ensured business decisions were made in a timely manner.

Researched the existing reports, formulated and came-up with recommendations to create new semantic layers(s)/reports.

Worked extensively on Input Controls, Fold and unfold properties, Merge Dimensions and Data connections.

Created Ad-hoc reports using Business Objects functionalities like Queries, Drill Down, @Functions, Cross Tab and Formulas etc.

Worked extensively with almost all functionalities of WEBI to build the reports.

Crystal Reports:

Created mock-up reports for review and prepared time estimates for all Crystal reports developed.

Supported, modified and maintained Crystal reports currently in the production environment.

Developed custom, new, complex, production-level reports.

Developed complex formulas in Crystal Reports for reporting calculations and metrics.

Designed and implemented complex reports and sub-reports

XCelsius:

Exclusively Used QAAWS, Live Office, XML mappings as per the Dash board requirements.

Developed web services using Query as a Web Service Wizard (QAAWS) and deployed it to the server for developing XCelsius dashboards.

Performed QAAWS Sizing on the servers to perform the Queries run fast and display the dash boards.

Created multiple Flash variables in XCelsius and used them to pass data from one dashboard to other.

Developed on Demand Webi Reports which reads parameters from Crystal XCelsius.

Developed multiple dashboards so that the user can navigate from one dashboard to the other.

Tableau:

Design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.

Preparing Dashboards using calculations, parameters in Tableau

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.

End to end experience in designing and deploying data visualizations using Tableau.

District of Columbia Access System (DCAS) Feb-13-Nov-13

Business Objects Consultant

Description: The District of Columbia Access System (DCAS). DCAS will be a state-of-the-art health and human services solution that provides the District’s Health Benefit Exchange a new integrated eligibility system for Medicaid, private health insurance and other programs with new case management capabilities that span programs and agencies. This system will be used to determine eligibility and enroll individuals, families, and small businesses that purchase healthcare coverage through the Exchange’s online marketplace.

Project mainly focused on gathering business needs, interacting with the business. Creating functional and technical specs, designing Universe on BI4.0 Environment by using the IDT, and complex Webi Reports, and including creating end-user reports and some reports were built from data received from various branches and offered summarized view for optimized decision making.

Responsibilities:

Gathered and captured all existing Customization/enhancements in available BO system. Involved in preparation of BRD (Business requirement document) and GAP analysis in order to include each and every enhancement during Upgrade. Understand the business data flow.

worked with Business Analyst in preparing TDS (Technical Design Specifications)

Development:

Gathered and Analyzed the reporting requirements with the business users/architects and come up with the technical Specifications for universe and BO reports.

Resolved universe problems such as loops, chasm and fan traps using aliases and contexts by testing the overall integrity of the structure using check integrity.

Modifying the existing universes, adding new objects, editing joins, mapping the existing objects with renamed tables.

At the universe level checked whether all the outer joins are created properly and also removed if there are any variables which are not used.

Implementing Object-level and Row-level security using Manage Restrictions on the developed universe restricting the end-users in accessing certain objects.

Designed and develop of various reports using BI4.0. Designing the Universes in Information Designing Tool (IDT), Classes and Objects are created in Business Layer (blx), Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes in the Data Foundation Layer (dfx).

Created Custom Hierarchies for using scope of Analysis and Drill Down options.

Improved the performance of the reports by removing any additional filters or alerter on the report. Turned the formula into a variable if it has any multiple uses.

Experienced in creating the Aggregate tables and Aggregate awareness implementation & Aggregate Objects Creation and using in the reporting.

Used functionalities such as sub-reports, cross-tab reports with Drill down feature of Webi reports to generate inventory, account receivables & payables, cycle and monthly reconciliation reports for billing purposes.

Extensively used Calculations, Sorting, Rank, and Drill down, Drill thru, Slice and Dice, Formatting, Breaks, Filters, Changing Displays and Prompts for creating Business Objects Reports.

Publish, distribute and schedule Web Intelligence reports using Info view.

Migrated Universes, Reports, and Securities from the Development to Production environment after System Integration Testing (SIT) and then followed by Business Acceptance Testing (BAT). Used Import Wizard, Life Cycle Manager and Promotion Management in BI4.0 for the Migration process across the environments.

Created reports using free-hand SQL, PL/SQL, and Universe.

Provided end user training for basic and advanced reporting skills on how to use templates to create their own reports and explained the hierarchy levels and incompatibility between the objects to make sure users take advantage of the existing universes.

Responsible for writing the SQL queries for the data validation and testing the reports (Comparing the report sql against the database by using the TOAD Analyzer)

Apple, Cupertino, CA Aug’12-Feb’13

Business Objects Consultant

Description: Apple founded in 1976 is a leading software and hardware company with over 170 retail stores around the world. It designs, manufactures and markets a wide range of products from personal computers, operating systems, network solutions, and the I-pod digital music player as well as distributing third party digital entertainment products through their I-tunes store. The company sells its products to a wide customer base, from individuals, educational institutions, and creative professionals, to small and mid-level business. In addition Apple Ins various products are sold through their online store as well as third party vendors worldwide.

Responsibilities:

Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.

Developed new universe as per the client requirements by identifying the required tables from Data mart using base queries, report mock-ups.

Understanding the user Requirements and prepared Low level Technical Specification documents for all the Webi reports.

Created reports from multiple data sources and from personal flat files.

Created complex reports by linking data from multiple data providers.

Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.

Developments of Crystal XCelsius components Grids, Pie charts, Bar Charts and developed the animation actions for those components.

Created QWAAS connectivity to Webi for refreshing XCelsius with current data.

Prepared project metrics and involved in status updates.

Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.

Designed Business objects semantic layers(Universe, Business view manager & Voyager) with SAP Warehouse and Non SAP warehouse

Designed and developed Business Objects universes (Reporting Universe, Metrics and Alert Universe) and Worked on Streaming Real-Time Data into XCelsius Applications

Created Universes using OLAP Data sources and Databases

Created users, users groups and maintained user access rights by using CMC.

Created aggregate awareness, LOV, Custom Hierarchies, Time Hierarchies and used @Functions with objects in Universe Design

Resolved Chasm &Fan traps and resolved loops using aliases, Contexts, shortcut joins

Created Daily, Weekly, Quarterly reports for the management team and field operation managers using Business Objects reports.

Maintained project related documents.

Created Universe Custom Connection Parameters and Designed Cascading list of values and Reusable Lists of Values and Designed Reusing Interactive Objects with &prompt & @Where Conditions

CA-MMIS, West Sacramento, CA June’10-Aug’12

Business Objects Consultant

Description: The Department of Health Care Services (DHCS the State agency) administers the Medicaid program with Federal oversight from CMS. California Medicaid management information system (CA-MMIS) processes both Medicaid and non-Medicaid claims. IBM provides the Technology Services like Data center, IT Infrastructure, IT strategy, IT transformation, Services, Application Development and Support to State of California.

Responsibilities:

Assessing the impact of changes in business requirements, evolving the strategy, and providing alternative solutions design to address ongoing changes.

Coordinating with end-users and business analysts to understand the scope of business requirements, user expectations, and ensure the accuracy of reporting specifications.

Created folders and also given privileges to the groups on folder level and also implemented different levels of security in CMC.

Migrated existing Business Objects BOXI R2 version to Business Objects XI 3.1 in development, Testing and Production environment. Resolved issues during and after migration.

Involved in the designing and Building of Universes, Classes and objects.

Implemented various @functions like @Prompt, @variable and @Select.

Worked on Master and Component approach during the linking of universes.

Resolved loops and Traps using Contexts and Aliases while designing Universes.

Set up Universe level conditions to restrict data based on report requirements.

Provided Row level and Object level security in the Universe for sensitive data.

Created dynamic Cascading LOV’s based on report requirements

Implemented aggregate awareness using @aggregate aware functionality and Aggregate/Summarized Tables to improve performance.

The project involved development of reports using WEBI to cater Ad-hoc reporting needs.

Joined multi data providers using merge dimension option of web intelligence.

Linked reports in Web Intelligence using Open Document function.

Created Business Objects Webi reports, Queries with constant interaction with the end users. Trained end users in understanding the reports. Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.

Migrated reports from Development/Testing environment to Production Environment.

Worked with Multiple data providers including Personal Data files, Stored Procedures and Freehand SQL to create reports.

Created Dashboards using Crystal XCelsius.

Creating and published a web service Using Query as a Web Service (QAAWS) tool.

Building and publishing XCelsius visualizations in SWF file using Qaaws and live office data source.

Creating different types of charts like line charts, pie charts, bar charts and enable drill down using XCelsius.

Delivering a training program to enhance end user understanding, perspective, and usability of the new BOXI reporting, analytical functionality, and utilization the system on a daily/ad-hoc basis.

Environment: Business Object XI 3.1/XIR2, Crystal Reports 2008/XI, XCelsius 2008, Designer, Desktop Intelligence, Web Intelligence, CMC, Informatica 8.1, Oracle 9i/10g, SQL Server 2008, TOAD, Windows 2000/XP.

Argus Info Solutions, Bangalore, India Jan‘07 – Jan‘08

Business Objects Developer

Description: Argus Info Solutions is a contraceptive and birth control products marketing company. Data was gathered from the various databases like SQL Server and Oracle, and loaded into a Data warehouse. Universe was created for analyzing the sales pattern among the southern states of Andhra Pradesh, Karnataka, Tamil Nadu and Kerala.

Responsibilities:

Gathering information pertaining to the creation of the universe and transaction level reporting

Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.

Creation of transaction level reports using concepts such as drill down to produce that effect required using reports in Excel for their specific purpose.

Solved Chasm Traps, Fan traps and Loops using Contexts, Aliases methods.

Generated Hyper Link reports to provide flexibility to the user in viewing reports

Created different types of reports like Master/Detail, Cross Tab and Chart.

Used Analyzer and Explorer to view reports from different prospect. For this used Slice and Dice and Drill down.

Exported the Universes to the Repository to make resources available to the users.

Send the Documents to Broadcast Agent and Schedule the reports.

Published reports on the intranet using Web Intelligence.

Saved the generated reports in pdf format.

Environment: Business Objects 6.5.1(Designer, Broadcast Agent, Web Intelligence), Windows 2003, Oracle 9i.

Contact this candidate