• Created Basic Dimension Build rule files
• Loaded data and controlled calculation process, Developed and tested calculation scripts
• Installation, configuration, troubleshooting and application demo presentations of Hyperion 9.3.0 and Datawarehousing platforms on Windows and Linux versions to US Clients.
• To assist pre sales team in making architecture recommendations specific to ETL, Database, Datawarehouse, Dashboards and ad-hoc reporting.
• Lead definition of Hyperion Essbase application architecture standards, best- practices and design methodology.
• Provide deep-level Hyperion Essbase and data warehouse subject-matter expertise and consultancy to the team in areas of functional design data warehouse design, dimensional model design, ETL, dashboards and optimization.
• Provide analysis and design consultancy of data models in-line with project requirements on an as-needed basis.
• Participate in and contribute to business/functional analysis and requirements definition.
• Prepare RFI and review for complete BI and Datawarehousing tools available.
• Lead troubleshooting, diagnostic and solution implemented for production issues.
Assist in the internal knowledge transfer of Oracle Corporation.
• Provided POC’S For customers like AT& T, T-Systems, PWC and many other clients.
• Had done RFI’S for customers and had done demo calls.
• Training of customers and partners.

Environment: Hyperion 9.3.1(Administration Console, Foundation services, Reporting and Analysis,Interactive Reporting Studio)

Confidential,Jan 2008 to Sep 08
Oracle India (Presales Consultant)
Hyperion 9.3.1 Presales Consultant

Description:
The objective of Presales team is to Sell Oracle Hyperion to the Desired Client. I Acted as team member for the Presales team.
Responsibilities:

• Provide deep-level Hyperion Essbase and data warehouse subject-matter expertise and consultancy to the team in areas of functional design data warehouse design, dimensional model design, ETL, dashboards and optimization.
• Provide analysis and design consultancy of data models in-line with project requirements on an as-needed basis.
• Participate in and contribute to business/functional analysis and requirements definition.
• Prepare RFI and review for complete BI and Datawarehousing tools available.
• Had done RFI’S for customers and had done demo calls.
• Training of customers and partners.

CUSTOMER RELATIONSHIP MANAGEMENT Feb 07 to Dec 07
Confidential
Hyperion Consultant (Presales Consultant)

Description:
Customer Relationship Management projects consists of three modules Customer, Billing and Service Order. Involved increating databases,Building rules files,Reporting with smart view for office. It contains information about services like Telephone, Basic Cable, Internet, Voicemail, Call forwarding etc. Billing holds the customer information and Service Order Universe holds the information about the new services ordered by customer.

Responsibilities:

• Involved in requirements gathering from the business users to build the reporting application
• Installed Hyperion 9.3.1
• Created basic dimension build rule files.
• Created attribute dimensions
• Loaded data
• configuring the data sources
• Retrieving the data using multidimensional data and label placement guides
• creating reports with smart view for office.
• Creating small calculation scripts.
• reporting with Essbase Spread sheet add-in

Environment: Hyperion Essbase 9.3.1, Administration,Smart view for office, spread sheet add-in, Oracle 9i, SQL, MS Office, Windows 2000.

Project:2
21st CENTURY INSURANCE
Confidential,CA Jan 06 Feb 07
Business Objects Presales Consultant

Description:
21st Century Insurance is the seventh largest personal auto insurance company in California and insures over 1.2 million automobiles. The company\'s data come from different operational source and stored in a data mart and then data is transformed and loaded into a centralized data warehouse for various strategic business reports. This application gives to the marketing representatives and agents about the product offering and revenue generated from different product lines.

Responsibilities:

• Interacted with the functional experts to gather the requirements for ongoing modification of the system as well as Cognos presales expertise .
• Used Business Objects Designer to create universes containing complex dimensions, measures, conditions and prompt objects to be used in Business Objects and Application Foundation.
• System setup of Application Foundations 6.0 including creating connections & dimensions, updating universes, creating systems & custom calendars
• Create user level security to applications, menus and sub menus using the Apps Security tool to restrict user access.
• Development and deployment Business Objects 5.1/6.1c and Cognos 7 to create reports using multiple data providers, in accordance to the client needs.
• Use Business Objects to create reports containing complex charts to present the end users with a better graphical representation of the data.
• Used Business Objects report level functions like Alerts, Breaks, Customized filters to display relevant data
• Involved in production support by modifying and correcting production reports
• Created technical and user documentation which has the step by step process of creating reports and using the functionality of Business Objects.

Environment: Business Objects 6.5 (BO Reporter, Designer, Broadcast Agent, Supervisor, WebIntelligence, Info View),Oracle 8i, MS Office, Windows 2000

Project:1
Confidential, NEW JERSY Sep 04 Jan 06
Business Objects Consultant

Description:
Company deployed Business Objects for Analytical and Reporting purposes for their Home Equity Loan Process, Sales forecasting and Business needs. The project was to audit their current deployment and performance and to create complex reports involving sub-reports based on custom database queries.

Responsibilities

• Worked with supervisor module in creating users and users groups for different areas and setting privileges to them. Created repository created and maintained users, domains and database connections.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Created Universes, classes, objects, Measure objects, prompts, conditions, Joins.
• Involved in resolving the loops, fan traps, chasm traps using contexts and aliases, checked the cardinalities and Integrity of the Universes.
• Created the reports using Business Objects functionalities like Slice and Dice, Drill down, Cross Tab, Master/Detail and Formulas etc.
• Developed complex queries and sub-queries using different data providers in the same report.
• Exported the Business Objects reports to WebI to be viewed by all users on the intranet. Created and published reports through WebIntelligence.
• Standard templates are created for future Ad-hoc reporting needs.
• Scheduled Reports using Broadcast Agent. Published reports to users to their e-mail addresses by using Broadcast Agent Publisher.
• Deployment and Installation of Business Objects products like Broadcast Agent, Broadcast Agent Publisher, and Business Objects Auditor.
• Documented processing times for each module, developed test cases and used them to run through each process. Tuned the matching parameters based on test results.
• Designing, developing and testing the different mappings according to the requirements.

Environment: Business Objects 5.1 (Supervisor, Designer, Reporter), WebI 6.1, Broadcast Agent 6.1, MS Access 2000, PL/SQL, InfoView