Sr. Business Objects Developer Resume
Charlotte, NC
SUMMARY
- 7+ years of IT experience and Business Objects XI 4.0/3.1/R2/6.5 with experience in CMC, Infoview, Desktop Intelligence, Import Wizard, Designer, Reporter, Web Intelligence
- Experienced the features of Business Objects XI R2, Crystal reports XI R2/2008, Crystal Xcelsius 2008/4.5.
- Experience in building Universes, retrieving data using Universes, Personal data files (MS Access, Excel) and creating complex ad - hoc Reports using the Business Objects Web Intelligence (WebI) modules.
- Experience in Installation, Administration, Design Universe, Reporting (Desktop Intelligence & Web Intelligence) and Migration of Business Objects XI R3/R2 /6.5.
- Experience in migration of Business Objects from BO XI 3.1 to 4.0.
- Extensive knowledge in Business Objects Full client & thin client environment.
- Worked on Web Intelligence (WebI) to develop and publish thin client reports.
- Experienced in setting up of Repository, creating, managing users and user groups
- Experience in migration from previous versions of Business Objects to its higher version
- Extensively worked in designing, implementing, distributing and maintaining Universes.
- Experience in creating Crystal Reports using Crystal Reports XI/2008 with expertise in developing various standard, graphical, formula based, well-formatted, drill-down, drill through, Summary and Parameters based reports and profound experience in developing complex reports using Sub-Reports (Linked and Unlinked), Cross-Tab, Stored procedures and Views.
- Expertise in developing dashboards using Xcelsius from Live Office. Used Query as a Web Service.
- Strong knowledge in building queries on different types of Data Providers Universes, Personal data files, Stored Procedures, Free-hand SQL, and Web connect.
- Experienced in setting up of Repository, creating, managing users and user groups.
- Good in development of Data warehouse/Data Marts, Data Modeling, designing the STAR and SNOWFLAKE schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling.
- Have experience working with databases like Oracle, DB2, Teradata, SQL Server and MS-Access.
- Expertise in Linux, UNIX and Windows environment. Good basic knowledge of Unix Shell Scripting
- Experienced in web publishing and scheduling documents using Broadcast Agent or Publishing wizard.
- Strong background in Data warehouse concepts - ETL, Data modeling, and Reporting
- Proficient in working with error handling and performance tuning to enhance database performance.
- Extensively worked with end-user requirements, business data requirements, analysis and study.
- Unique ability to understand long-term project development issues at all levels
- Strong Business Intelligence implementation knowledge of strategic planning, development and production in various core sectors
- Demonstrated excellent interpersonal skills and communication skills during identification of user requirements.
- Capable of working in a team or individually, self-motivated with good problem solving skills.
TECHNICAL SKILLS
Operating Systems: Win XP SP2/SP3, Win 2000, Win NT 4.0 and UNIX
Databases: SQL Server 2000/2003/2005 , Oracle9i/10g, DB2, Teradata V2R5/V2R4, Toad, MS Access 2000/XP/2007
Programming Languages: SQL, Pl/SQL
Web Technologies: HTML, DHTML
Reporting Tools: Business Objects XIR1/R2/3.1/4.0,6.5/6.0/5.x,Crystal Reports 2008/XI/10/9, Crystal Xcelsius 2008/4.5, Central Management Console (CMC), Central Configuration Manager (CCM), Import Wizard, Performance Management, Designer, Desktop Intelligence, Web intelligence, Crystal Xcelsius 2008
Application Servers: Apache 1.3.27, IIS 5.0 and Tomcat 4.0.6
Business: MS Visio and MS Front Page
UML Diagram Tools: Microsoft Visio
Microsoft Tools: Microsoft Office Suite (Word, Excel, Access, PowerPoint, and Outlook
UML Diagram Tools: Microsoft Visio.
PROFESSIONAL EXPERIENCE
Confidential, Charlotte, NC
Sr. Business Objects Developer
Responsibilities:
- Performed an initial study of the current reporting application, to finalize the data elements required for reporting.
- Installed and configured BO Software on client machines and created User groups and users of PROD, DEV, TEST environments.
- Created Repository for BO development, created Universes and Complex Reports.
- Created BI reports and dashboards usingTableaufor Senior executives to track and measure KPI for product efficacy and key financial metrics
- Involved in working with different database environments and moving of the universes and reports between PROD, DEV, and TEST.
- Created Complex Crystal Xcelsius Reports from the output of Business Objects report data.
- Created Xcelsius dashboards for the ORM (Owner Relation Management) application
- Used QaaWS to provide dynamic functionality.
- Used Sliders, Pie charts, column charts, Gauges, Dials, maps and other features in Xcelsius
- Extensively used Alerts while creating the Dashboards (Xcelsius).
- Added users, user groups and managed the access privileges of the user community using the CMC module
- 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.
- Maintained universes and Object Oriented Universe Design Techniques, working knowledge of Linked Universes.
- Working on creating Universes, Business Intelligence Layer for end users to develop the Adhoc/Canned reports.
- Designed Metadata Universe by creating the Business Objects Semantic Layer selecting/joining Tables, set cardinalities and creating objects and classified them into Dimensions, Details and Measures and give Business Name and group them into classes and sub classes
- Involved in creating the Aggregate tables at different levels.
- Created user objects including Dimensions, Details, Measures, Filters and Prompts, LOV
- Multilevel hierarchies are set up enabling the drill down functionality.
- Defined Report Level Ranking, Database Ranking and Alerts in Reports based on the specifications.
- Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in WebI.
- Resolved issues like Chasm traps, Fan Traps in the universe build by creating contexts and aliases as required.
- Resolved loops by creating aliases, contexts and short cut joins by resolving loops, cardinalities and integrity checks of the Universe before exporting.
- As a part of report development, created the reports using universe as a main data provider and using the Powerful business objects functionalities, and formulae. Involved in trouble shooting of various reporting errors.
- Created the complex WebI reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
- Created a set of Ad hoc reports with Business Objects and finally deploying them in Web Intelligence
- Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports.
- Worked on Import and Export of the Universes, with the changes in Database Objects by using Import wizard and Designer module.
- Generated ad hoc and canned reports for Business objects.
- Developed Crystal reports, which include the following features - parameter fields, formulas, conditional formatting, multiple grouping and running totals
- Developed Crystal reports using various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts.
- Modified the Parameter file in Universe Parameters to enhance the reporting on Teradata.
- Generated various report templates for standardizing the reports throughout the organization.
- Troubleshoots system errors and bugs and rectifies them.
- Involved in the Users in using this robust system.
Environment: Environment: Business Objects XI 4.0/R3/R2, Tomcat 5.5.20/5.0.27 , Designer XI R3/R2, Desktop Intelligence, Crystal Reports 2008,, Infoview, Xcelsius 4.5/2008, Teradata, SQL, PL/SQL, UNIX
Confidential, Plainsboro, NJ
Business Objects Developer& Data Information Analyst
Responsibilities:
- Involved in Analyzing the End users functional and technical requirements and respective impacts on reports.
- Used Business Objects XIR3 extensively and Involved in Full SDLC (software development life cycle) rules are followed for designing new components.
- Designed, created and maintained Universes for Business Objects and Web Intelligence users using Business Objects Designer Module.
- Created universes by defining Joins, Cardinalities between tables.
- Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.
- Created classes and objects by retrieving the data from various data sources and defining the necessary connections
- Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
- Responsible for creating & managing the Business Objects repository and coordinating/performing universe development.
- Created predefined conditions, prompts and custom hierarchies in the process of building the universes
- Created Contexts and Aliases for resolving Loops and join problems in the Universes.
- Deployed universes in the repository by exporting and importing universes between universe domains, and over different repositories.
- Created both full client(DeskI) reports and Web I reports using Info view and WebI Rich Client with many features of drill down and alerters and filters.
- Generated various reports on a daily, weekly and monthly basis using Business Objects Report module.
- Created reports using Business Objects functionality such as Slice and Dice, Drill Down, Master/detail, Crosstab, Prompts and Formulas, Breaks, Sorters and Alerters etc.
- Created Universes using @functions like @select, @where, @aggregate awareness and @prompt in the process of building the universes.
- Created derived tables and aggregated tables at the Universe level to reduce the complexity of universe building and increase the performance.
- Created various report specific formulae based on calculation contexts of the report.
- Involved in writing free hand SQL, as data provider for retrieving data when universe doesn’t provide required data.
- Knowledge of TibcoSpotfire, TABLEAU, Style Intelligence dash boarding tools
- Worked with Business Objects Professional services to build a online material using the SAP Knowledge Accelerator tool for reporting
- Involved in Scheduling reports based on Specific time, events and calendars and in various formats such as Excel and PDF in web Infoview portal.
- Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
- Involved with the group which provided support and ideas for migration from BO XI 3.1 to BO 4.0
- Used Central Management Console (CMC) in creating users and groups and assigning privileges to different groups and users.
- Applied row level and object level securities to different groups and users in the designer wizard.
- Created all types of reports using different functionality like Cascading Prompts, Cascading LOVs, Formulae and Grouping.
- Involved with a team in creating Dashboards using various visual analytics, themes to meet corporate standards using XCelsius.
- Created complex Crystal reports against Teradata
- Designed analytics sales Vs Inventory using the Crystal XCelsius analytics for the high end users
- Created Xcelsius dashboards using Query As A Web Service (QAAWS) and Live Office
- Created multiple Crystal and Web Intelligence reports and transformed into a single dashboard using Xcelsius
- Gave my thoughts and ideas to the data-modeling team in designing a new data mart for future reporting applications in a EDW warehouse.
- Coordinated with BO Admin in managing the Central Management Server to add/delete, enable/disable BO Servers.
- Coordinated with DBA and ETL in solving various technical issues and also to stream-line universe design and optimize query performance
- Worked on Informatica Power Center Source Analyzer, Data warehousing Designer, Mapping & Mapplet Designer and Transformation Designer.
- Conducted presentations sessions and created documents for the Business users on the use of Business Objects reporting tool and overview of the Universe.
Environment: Business Objects XI R3/R2, Designer XI R3/R2, Desktop Intelligence, Web Logic 6.0, Crystal Reports 2008, Infoview, Xcelsius 4.5/2008, Oracle 10g, SQL, PL/SQL, UNIX
Confidential, OH
Sr. Business Objects Developer
Responsibilities:
- Involved in gathering business requirements, functional requirements & data specifications and designing the whole system as per the user requirements and interacting with end users.
- Involved in different phases of Software Development Life Cycle (SDLC) like requirements gathering, preparation of technical specification documents, designing and developing reports, unit testing and UAT.
- Integrated metadata from various databases and extract, transform, load (ETL) products, and business intelligence (BI) components, such as SAP Business Objects universes.
- Exported the metadata centralized in the repository into SAP Business Objects universe, accelerating the design process using SAP Business Objects Metadata Management.
- Administered 1000 users and 40 user groups.
- Created different types of reports like Cross Tab, Charts and Master Detail using multi data sources.
- Created Web Based reports using Web Intelligence and Dashboards for various reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
- Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications usingTableau
- Provided inputs for the ongoing Business Objects 6.5 to Business Objects XIR2 migration and then from XI R2 to XI 3.1
- Created around 25 reports in Web Intelligence, Crystal Reports and Desktop Intelligence, Dashboard manager and Crystal Xcelsius.
- Created reports by linking Complex Excel Spreadsheets and Universe as data providers.
- Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports.
- Maintained and modified the reports based on the CR’s (Change Request).
- Extensively used Central Management Console (CMC) in setting up security in BOXIR2 and also manages security configuration for various reports and universe in both development and production environment.
- Created Complex Crystal Xcelsius Reports from the output of Business Objects report data.
- Created Xcelsius dashboards for the ORM (Owner Relation Management) application
- Used Sliders, Pie charts, column charts, Gauges, Dials, maps and other features in Xcelsius
- Extensively used Alerts while creating the Dashboards(Xcelsius).
Environment: Oracle 10g, SQL Plus, Informatica Power Center 8.6.1 (Mapping Designer, Workflow Designer, Workflow Monitor, Mapplet Designer), Crystal Xcelsius, Infoview, PL/SQL, Windows XP,VB Macros, Business Objects Enterprise Xi 3.1/ XI R2, BO Designer, Rich Client XI 3.1/Web intelligence XIR2, Desktop Intelligence XIR2/Full Client, Windows XP/2003,Business Objects Dashboard Manager XiR2, Crystal Reports XiR2.
Confidential, Charlotte, NC
Sr. Business Objects Developer
Responsibilities:
- System study, interaction with users, management and designing, coding, testing & implementation of the system.
- Involved in gathering user requirements.
- Created the Logical and Physical Model using classic Star-Schema.
- Defined categories of documents for different level of groups.
- Defined Complex Security set up for end users.
- Configured user rights and security.
- Built a rich looking Dashboard usingTableauwhich includes several Visualizations with hierarchies
- Involved in Sizing the BO XI r2 infrastructure.
- Migrated & upgraded Business Objects from 6.5 and Crystal Reports 10 to BO XI r2 Universe designing and establishing BO environment.
- Designing, creating, enhancing, testing BO universe, reports.
- Creation of reports like Reports by Period, Demographic reports and Comparative Reports using Business Objects Full Client application.
- System study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of the system.
- Designed Test cases for UAT of Reports for end users.
- Created the full client and Webi reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
- Used aggregate awareness in universes and Created Reports employing functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc.,
- Identified the CTQ (Critical to quality) KPI’s and Metrics as a part of the requirements gathering.
- Worked with the end users to create extensive use cases for the dashboards.
- Tuned the reports for better performance using SQL.
- Designed templates for Webi documents and customized Webi Front Page.
- Involved in Business Objects 6.5 Broadcast Agent and Supervisor.
- Mentored other IT staff & Conducted Corporate for end users on Business Objects XI.
- Involved in server side components of Zero Administration Business Objects (ZABO) applications.
- Developed functions and procedures and change control documents for BO.
- Linked Webi reports for different hierarchies.
- Mentored other IT staff & Conducted Corporate for end users on Business Objects XI.
- Trained the user community in making use of universe to create and publish reports.
Environment: Business Objects XIr2/6.5, Web Intelligence, Informatica, ZABO, Desktop Intelligence, Unit Test, CMC, Broadcast Agent Server, TOAD, Oracle 10g, DB2, Xcelsius, WEBI.
Confidential
Informatica Developer
Responsibilities:
- Transformed data using the following Informatica transformations: Source Qualifier, Normalizer, Expression, Aggregator, Filter, Router, Rank, Update Strategy, Lookup, Stored Procedure, Sequence Generator, and Joiner.
- Created sessions and workflow using workflow designer for designed mappings.
- Used workflow Monitor to monitor the performance of the Jobs.
- Involved in designing Mappings in Informatica by translating the business requirements.
- Performed data manipulation using basic functions and Informatica transformations.
- Developed mappings in the mapping designer to populate the existing data mart and tuned them accordingly.
- Extracted source data from Oracle, SQL Server, XML and Flat files using Informatica, and loaded into Oracle targets.
- Involved in the analysis, design, coding and testing data and warehouse build phase (ETL).
Environment: Informatica 5.1, Oracle 9i, PL/SQL, Toad, UNIX