We provide IT Staff Augmentation Services!

Senior Bo Developer Resume

SUMMARY:

  • 6 years of IT industry experience with expertise in Data Warehousing and Business Intelligence, with key emphasis on Analysis, Design and Development.
  • Experience in Designing Universes and development of reports both in Desktop Intelligence (DeskI) as well as in Web Intelligence (WebI) using BO XI R2 and XI R3.
  • Extensively worked on Business Objects (BOBJ) Ad - hoc Reporting by accessing data using Universes, Personal data files, Free-Hand SQL and Stored procedures.
  • Expertise of admin tasks using Central Management Console(CMC) which includes the ability to administer, deploy, install and configure Business Objects.
  • Good Knowledge of Dimensional Data Modeling using Star schema, multiple star schema and snow flake schema.
  • Extensively worked with SQL Queries, and capable of handling various Databases like Sybase Enterprise 12.5, Oracle 9i, and SQL Server 2000 databases and also have good experience in Database Tuning, and performance techniques.
  • Used Import wizard to migrate the universes, Corporate Documents, users and groups from BO XI R2 to BO XI R3.
  • Hands On experience in Informatica 8 - Power Center, Workflow Manager, Workflow Monitor
  • Excellent understanding of the software development life cycle (SDLC).
  • Excellent Analytic skills with the ability to recognize and translate business problems in to technology-based solutions.
  • Strong experience with client interactions, understanding business applications, business data flow and data relations.
  • Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities and flexible in work schedules.
  • Good Interpersonal and communication skills, technically competent and enthusiastic team player.
  • Ability to work effectively with minimal direction/supervision

TECHNICAL SKILLS:

Operating Systems: Windows (98/NT/XP/Vista)

Markup Languages: HTML, XML

Database Technologies: Oracle 9i, MS SQL Server 2000, MS Access, Sybase Enterprise 12.5

DataWarehousing Tools: Business Objects (BOBJ) XI R2/ R3, Universe Designer, Desktop Intelligence, Web Intelligence, Crystal Enterprise 8.5/9.0, Informatica 8

PROFESSIONAL EXPERIENCE:

Confidential

Senior BO developer

Responsibilities:

  • Interacting with the clients for understanding and analyzing the client requirements, both documented and undocumented
  • Document reporting systems - Functional Specification Docs, Impact Analysis Doc, and Design Doc.
  • Troubleshooting support tickets for operational issues
  • Designing the universe based on the report requirements.
  • Implementing security through Universe and CMC, so that customer and company data is protected at all times.
  • Check for existence of loops and trap in the universe, and resolve them.
  • Responsible for creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, creating Indexes, views to increase the performance of the universe.
  • 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.
  • Develop custom Webi and Deski reports and customize existing BI reports. Reports are based out of multiple data providers like Universe, Free Hand SQL, and Stored Procedure etc.
  • Developing Cross tab reports, Drill up/Drill down reports, Drill through reports, Line charts, stacked charts and Bar graphs.
  • Creating the sub reports and linking them with the master reports.
  • Validating the report data against the database.
  • Performance tuning of the reports and universe.
  • Documented all the changes made to the Universes and Reports for future s.
  • Responsible for migration of the universes and reports between DEV,QA,UAT and PROD environments, and managing user access in each environment.
  • Use CMC (Central Management Console) to manage the universes, users/groups, reports and Security model to objects.
  • Troubleshoot any issues or bugs discovered during the course of a project and provide ongoing application support.
  • Analyze and decode existing Access reports and recreate them in Business objects.
  • Coordinating with the Infrastructure team for migration from XI R2 to XI R3.
  • Mentor junior consultants.

Business Domain: Investment Banking

Environment: Business Objects XI R2/XI R3, Informatica 8, Sybase Enterprise 12.5, MS Access Reports, Crystal Reports, Windows XP, Perforce, DBArtisan

Confidential

BO developer

Responsibilities:

  • Understanding business requirements and preparing System Requirement Specifications.
  • Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.
  • Involved in scheduling the Custom reports and process them for Business users.
  • Responsible for delivery of Business Objects Reports environment on time.
  • Responsible for end user to work on reports.
  • Creating classes, objects and hierarchies in the universe
  • Resolve universe problems like loops and traps.
  • Develop Webi/Deski drill up/down reports and cross tab reports.
  • Developing the sub reports and linking them with the master reports.
  • Maintain and enhance existing reports in Webi/Deski.
  • Validating the report data against the database using SQL.
  • Document reporting systems - Functional Specification Docs, Impact Analysis Doc, Design Doc
  • Performance tuning of the reports and universe.
  • Create transformations in Informatica using Power Center
  • ETL testing using Workflow Monitor, Workflow Manager and UNIX for running scripts.

Business Domain: Investment Banking

Environment: . Business Objects XI R3, Informatica 8, Oracle 9i, Windows XP, Visual Source Safe, DBArtisan

Confidential

BO Developer

Responsibilities:

  • Develop Webi/Deski drill up/down reports and cross tab reports.
  • Maintain and enhance existing reporting system.
  • Validating the report data against the database using SQL.
  • Developing unit test case and reviewing of Reports to create Unit Test Logs.
  • Creating classes, objects and hierarchies in the universe
  • Creating Design Documents and Unit Test Plans.
  • SCM Coordinator of the project
  • Create Report design documents
  • Document reporting systems.
  • Create reports in WebI.
  • Ensuring Quality Standards & Practices

Business Domain: Mortgage

Environment: Business Objects (BOBJ) XI R2 Enterprise, Oracle 9i, Crystal Reports, SQL Server 2000, Visual Source Safe, TOAD

Hire Now