SUMMARY

• 6.2 years of experience in Information Technology with strong work experience as Business Objects Developer.
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
• Expertise in Business Objects enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Info View) and its deployment.
• Experience in creating Adhoc reporting ready universes using Business Objects Universe Designer.
• Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.
• Excellent data - analysis skills and ability to translate specifications into a working Universe and/or Report.
• Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
• Extensively used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks..
• Experienced in Training & Supporting end-user reporting needs using Business Objects.
• Strong database experience in using Oracle 9i, MS SQL Server 2008/2005, MS Access.
• Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including OLAP data and from design to development and implementation.
• Exposure to Dimensional Data modeling- Star Schema modeling and Snowflake modeling.
• Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).

TECHNICAL SKILLS

BO Tools: Business Objects XI 4.1/ XI R2/R3, Web Intelligence XI 4.1/R3/R2, Universe Designer XI 4.1/R3/R2, Desktop Intelligence, InfoView, CMC, Import wizard, Report

Data warehousing: Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables.

Databases: Oracle 9i/8i, MS SQL Server 2008/2005

Operating Systems: Windows Server

Dimensional Data Modeling Tools: Multidimensional data modeling, Snowflake Schema/ Star Schema modeling (Normalization / De-Normalization Techniques

Query Tools: TOAD

PROFESSIONAL EXPERIENCE

Confidential

Business Objects Developer / Reporter

Responsibilities:

• Interacted with Business Users, Business owners to know their Business requirements in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Working on the SQL tuning and optimization of the Business Objects reports.
• 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.
• Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
• Exported the ad-hoc ready universes to the for making semantic layer available to the users.
• Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables required by the business objects universes.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Troubleshoot errors for reports,, and universes. Fixed them to work as per the business needs.
• Created complex reports by linking data from multiple data providers, stored procedures and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.
• Extensively worked with Ranks, Alerter, filters, prompts, variables and calculation contexts in designing reports.
• Built WebI reports Provided OLAP functionality and worked extensively with data warehousing.
• Set up groups and users for Business Objects deployment.
• Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
• Extensive testing and migrating the reports or objects from development to Production system.
• Developed testing scripts and test cases. Extensively tested Business Objects reports.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.

Confidential

Business Objects Developer / Reporter

Responsibilities:

• Perform troubleshooting of production Incidents/tickets and resolve issues with the batch jobs
• Perform first level analysis on the tickets and provide solutions/clarifications to users
• Assign helpdesk tickets to appropriate resource within/outside the project team for resolution
• Analysis of data discrepancies
• Address Business user Queries
• Interact with user for understanding ticket requirements to providing the resolution
• Perform database refreshed for non-production environments(upon request or need)
• Identifying recurring problems/bugs/Error & perform root cause analysis of failures and purpose short term and long term solutions
• Corrective Application Maintenance: fixing Problems/Bugs/Error in applications including those as a result of incidents
• Adaptive Application Maintenance; modifying application to adapt to changes in the technical environment
• Drive incident reduction though problem management by proactively identifying root cause of incidents and prevent them from repeating Minor Enhancements & New Reports Development
• Minor code changes in Business objects report as well as to create the new reports for user requirement Job Monitoring (during support window)
• Job scheduling, failure and Recovery in Production

Confidential

Business Objects Developer / Reporter

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Worked towards optimal development of universes by removing loops through the use of aliases and contexts.
• Creating Universe with number of Classes, many objects, Derived Tables using inner/outer and equiv. joins as per requirement.
• Created and tested classes and objects to organize the universe.
• Exported the universes to the Repository to make resources available to the users.
• Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc.
• Applied drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Extensively worked with Ranks, alerters, filters, prompts, variables and calculation contexts in designing reports.
• Published and scheduled Business Objects Reports to users using Scheduler.

Confidential

Business Objects Developer / Reporter

Responsibilities:

• Analysis of Business Objects environment, Universes, Reports.
• Add more groups and change the profile of users via supervisor.
• Developed Universe using Designer module in Business Objects.
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Specified the Joins and checked the cardinalities.
• Implemented User Objects in Reports.
• Created Condition in Universe.
• Ad-hoc reports were used for Business Objects user modules for various portfolios using the Universes as the main Data providers.
• Resolved loops by creating Aliases and Context.
• Organized data in reports by using filters, sorting, ranking and highlighted data with alerts.