SUMMARY

• 5 years of experience in BO and SAP Business Intelligence with BO
• Have Extensive Knowledge and exposure with all modules in Business Objects 4, and Business Objects XIR3. (Infoview, Web Intelligence, Desktop Intelligence, Crystal Reports 2008, XCelsius,CMC)
• Proficient in implementing and providing business intelligence on data warehouse and data mart solutions
• Understanding of Data warehousing concepts and data modeling
• Knowledge in SAP Integration with BO desktop and server products
• Knowledge of Widgets and Business Objects Explorer
• Extensive Experience in corporate training
• Good Project Management skills
• Strong analytical skills to define business processes and ability to conduct JAD sessions to meet various business requirement
• Prepared Business Process Models that depicted modeling of all the activities of the business from the conceptual to procedural level

TECHNICAL SKILLS

Business Intelligence: Business Objects XI R3/R2, Central Management Console, Central Configuration Manager, Web / Desktop / OLAP Intelligence, Designer, Enterprise Performance / Information Manager, Dashboard Manager, SDK, Crystal Reports Server XI, Crystal Xcelsius 2008, Import Wizard, Publisher, Widgets. SAP integration with BO.

Data Modeling: Star - Schema and Snowflakes Modeling, FACT and Dimension Tables

PROFESSIONAL EXPERIENCE

Business/Project Analyst

Confidential, Nashua, NH

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
• Created Participated in design and development of Star and Snow - flake schema database and mappings between sources and operational staging targets by identifying suitable Fact and Dimensional tables for the schema.
• Designed the Universe on top of the Oracle, and SQL Server. Developed multi-source universes utilizing Information Design tool.
• Exported universe to the repositories to make resources available to the users.
• Checked integrity of the universe, resolved issues like loops, chasm and fan traps using aliases and contexts at universe level.
• Used @functions (@select, @where, @prompt) to create complex predefined conditions, and prompts to filter the data in the universes.
• Migrated the Users, Groups, Universes, Personal Folders, Connections, Reports (Webi), Excel, PDF and Instances to Production, Development and Test Environments using Import Wizard.
• Modifying the existing universes, adding new objects, editing joins, mapping the existing objects with renamed tables.
• Extensively used calculations, variables, and filters, conditions, breaks, sorting, Charts and alerts for creating Business Objects Reports.
• Created Joins, Aliases and Contexts for resolving Loops in the Universes and checked the Integrity of the Universes.
• Created Custom Hierarchies for using scope of Analysis and Drill Down options.
• Created the Reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice and Drill Down.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master Detail and Formulas etc.
• Created Web Intelligence reports using Merged Dimension while building reports using multiple Data providers.
• Worked on Developing Standard & Multi-Dimensional Web Intelligence Reports using features like Drills, filters, Sort, Rank, Sections, Breaks, Alerts, merge Dimensions, sub queries and Multiple Data Providers.
• Worked with the end users to create extensive use cases for theDashboards.
• Publishing and maintaining the developed reports on to the enterprise server, testing them and optimizing them for the performance sake.
• Participated JAD sessions for effective communication of views between stakeholders and gathered business requirements
• As part of testing, involved in report performance testing, Data Validation, Confirming data representation, report formats and layouts are meeting business requirements.

BOBJ Report Developer

Confidential, Hopkinton, MA

Responsibilities:

• Developed universes, reports using Designer, Web Intelligence and Desktop Intelligence.
• Exported the universes to the Repository to make resources available to the users. Created reports for various Portfolios using the Universes as the main data Providers
• Handled all the change requests to the existing universes requested by reporting team
• 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
• Used Dashboard Manager to build Dashboards and deploy them across the organization to monitor business performance
• Analyzed the business logic built into the warehouse and also gathered user requirements for the reporting work
• Performed extraction, transformation and loading of data warehouse and Data Marts
• Data modeled part of the warehouse tables and was part of the team in designing the final conceptual, logical, physical model.
• Attended Business meetings and assisted Business Analysts in gathering requirements, discussed the conversion work reviews and Auditing follow-ups
• Work with the onsite team to meet the specified project deadlines. Work in unison during product development

Reporting Analyst

Confidential, Bordentown, NJ

Responsibilities:

• Prepared Business Process Models that depicted modeling of all the activities of the business from the conceptual to procedural level
• Communicated and interacted on a regular basis with the project manager and development team during different stages of the product life cycle
• Conducted JAD sessions for effective communication of views between stakeholders and gathered business requirements
• Worked in conjunction with workflow managers and support engineers to optimize support centre processes and identified lags.
• Assisted in building and maintaining the reporting infrastructure in Support of the GTS, CSS operations.
• Developed forecast model reflective of the data trends in queues and re queues of SR’s.
• Provided an objective point of view on business performance
• Managed projects and regularly updated senior management about the progress.
• Performed both short term ad-hoc analysis and strategic scenario planning in support of the business
• Provided centralized reports to the Global Services community on a prescribed rhythm