Business Objects Developer/analyst Resume
Birmingham, AL
OBJECTIVE
- To work towards achieving the greater success in my career through hard work, consistency and the ability to work in teams to achieve organizational goals, aims and objectives.
SUMMARY
- Over 3+ years of experience in Information Technology with 3 years of experience in Business Objects Developer Suite XI - 3.1/XI-R2/6.x/5.x (CMS, CMC/Supervisor, Designer, Info View, Business Objects/Desktop Intelligence, Web Intelligence, Crystal Reports, Scheduler/Broadcast Agent),
- Expertise in all the modules in Business Objects Suite like Designer, CMC, CCM, LCM (Life Cycle Manager), Info View, Web Intelligence, Desktop Intelligence, Performance Manager, Dashboards, Live Office, infoburst, Xcelsius 2008. Extensively worked on Reporting and Designing module.
- Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.
- Extensive knowledge of Clinical data.
- Hands on experience with Power Insight.
- Worked on Web Intelligence to develop and publish thin client reports.
- Developed Xcelsius dashboard for Droid phones using Confidential ’s InfoBurst technology.
- Worked with Auditor database, to keep track of user actions performed.
- Good Knowledge of Star Schemas (ROLAP Data Models), also worked closely with EDW teams.
- Excellent interpersonal, communication, analytical and presentation skills.
- Trained end users extensively on Web Intelligence.
- Good analytical and documentation skills with ability to communicate at all levels.
- Worked on the trial version of SAP Business Objects 4.0.
TECHNICAL SKILLS
Database: Oracle 10g, 9i, 8i, Sybase 12, DB2 8.1, SQL server 2005, 2008,Teradata 12
Reporting Tools: Infoview, Web Intelligence Rich client, Designer,, Universe Builder, Query Builder, Xcelsius 2008, Live office, Infoburst, Business Objects 6.5/XIR2/XIR 3.1
Platforms: UNIX, Windows (XP, NT, 2000)
Web Application: Infoview, CMC, Open Doc
Web Server: Apache Tomcat 5.0, Web Sphere 6.1
Utilities/Tools: SQL Developer 2000, TOAD, Visio 2003 Professional, Business Objects Data Integrator 6.5
PROFESSIONAL EXPERIENCE
Confidential - Birmingham, AL
Business Objects Developer/Analyst
Responsibilities:
- Involved in designing and developing Ambulatory Summary patient report.
- Created Web Intelligence reports using CERNER product power-insight.
- Interaction with user and business leads to understand Business needs.
- Provide technical support to resolve production issues in Web Intelligence Reports.
- Constant Interaction with users in going over the use cases for new Business needs and validation of the existing implementations.
- Creation and testing of complex reports and documentation of test cases and report specifications.
- Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, master/detail, cross tab, charts, alerts etc. for creating Business Objects Web Intelligence reports.
- Created various 3D pie charts, Pie charts, Bar Charts and Line Charts.
- Created Web Intelligence reports to schedule and mail it to the users on daily basis.
- Trained more than 100 users in Web Intelligence to build reports and help them understand the business cycle.
- Developed best practices to improve testing effectiveness, product quality.
Environment: Business Objects XI 3.1, Oracle11g, Web Intelligence, UNIX
Confidential - Tennessee
Business objects developer
Responsibilities:
- Developed universe in Business Objects XI 3.1 for the Sales and Marketing Department to Analyze Sales and enable Marketing Team to make informed decisions.
- Responsible for gathering the requirements from the Users and designed the Detailed design specifications for the Business Objects Universes and Reports.
- Communicated with users and participated in meetings for requirements gathering and provided production and technical support to the users and business analysts like installing Business Objects desktops products on user machines etc.
- Validated Sql in Teradata for the validation of the reports in the production.
- Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, master/detail, cross tab, charts and alerts for creating Business Objects reports.
- Worked for production support and resolved issues for the end users.
- Resolved loops using Aliases and Context.
- Addressed chasm trap and Fan Trap using Multi Parse SQL.
- Imported data from Excel to compare Actual Vs Budget.
- Created drill down reports in Webi to dill down over individual sales Team.
- Created Ad-hoc reports with WEBI and DESKI including functionalities like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab Master/Detail various Charts reports and exported to Repository.
- Exported reports to the repository for Info View users.
Environment: Business Objects XIR 3.1, Universe Designer, Web Intelligence, Teradata 13
Confidential - Arizona
Business objects/Xcelsius Developer
Responsibilities:
- Deployed Infoburst and resolved issues related to it.
- Used Infoburst to feed data to dashboard. Created several Webi reports to feed data for dashboard. Created complex dashboard with 5 levels of drill down capability and interactivity between the quadrants.
- Created detailed webi reports and linked them to open in Xcelsius with the help of OPENDOC.
- Created BO reports using SAP BI(BEX Query).
- Used context operators like In, ForEach, ForAll in webi reports in order to meet the business requirements.
- Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL.
- Analyzed data using Slice/Dice and Drill Mode. Created Web Intelligence reports Ad-hoc and canned reports.
- Tested the Web Intelligence reports in System Integration and Testing environment and Testing (Staging) environment to validate performance testing of all the reports, which helped in analyzing its performance before moving into production environment. Created report designing documents for further reference.
- Redesigned the data by using various V-lookup and H-lookup functions for finance dashboard reducing from 60 to 15 components. Scheduled the Web intelligence reports and published them on weekly basis.
- Tuning the queries to improve the performance of the report refresh time.
- Created complex variables and calculation to meet the user requirements.
- Used filters, conditions, calculations to support user requirements.
Environment: Business Objects XIR R2, Universe Designer, Web Intelligence, SQL Server visual Studio 2005, Xcelsius 2008
Confidential - San Jose, California
Business Objects/Xcelsius Developer
Responsibilities:
- Developed reports and dashboards in Desktop Intelligence & Web Intelligence XIR2 and Xcelsius 2008.
- Participated in installation of Confidential ’s Infoburst application and integration with Business Objects.
- Hands-on experience with Infoburst.
- Created XDC’s and XDS using BO Universe and database as a source.
- Participated in designing the Oracle to Business Objects XI R2 Security Bridge.
- Wrote a full functional specification document for the security to be implemented in Business Objects XI R2.
- Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL.
- Created Custom Hierarchies for several groups.
- Oversee daily activities of the project SDLC process and coordinate activities of team members, ensuring that module goals are met within predetermined time frames.
- Provide the first level support to approximately seven groups .
- Re-define the security in XI R2 and implemented the best security model in XI R2 using new security features .
- Helped other developers in building complex reports.
Environment: Business Objects XIR R2, Universe Designer, Desktop Intelligence, Web Intelligence, SQL Server 2005
Confidential, California
Business Objects Reports Developer
Responsibilities:
- Involved in conversion of Crystall reports to Webi reports for ISI Department.
- Created WEBI/DESKI reports involving complex queries, sub queries, Unions and Intersection.
- Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects. Created various drillable Webi reports.
- Created ad-hoc reports with multi prompts to retrieve required data for the user and to minimize unnecessary load on the server Created Crystal reports with cascaded multiple prompts.
- Created Reports with heavy conditional formatting and functions to meet user requirement.
- Customized the reports with custom functions and loops to leverage the user reporting needs.
- Scheduled recurring daily, weekly and monthly reports (Webi, Deski, and Crystal Reports) in Info View and used Calendar based scheduling for the reports custom dates.
- Created various group based publications and distributed reports to the users.
- Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
- Created a complex prompts at the universe level like @prompt, @select, @where, @variable and @aggregate.
- Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
- Created different types of reports like Master Detail reports and cross tab reports for different business groups
- Created WEBI Reports with multiple variables at report level to get %, Average, Boolean etc values.
Environment: Business Objects XI R2, Crystal Reports 2008, Teradata 12, MS Excel, Web Intelligence