PROFESSIONAL SUMMARY:

• Over 8 years of IT experience, with 5 years of experience in Business Intelligence and Data warehousing.
• Have experience in doing excellent documentation on business requirements.
• Expertise in creating complex reports in Answers using various views. Expertise in debugging and optimizing the Oracle BI Dashboards / Reports.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like OBIEE.
• Expertise in understanding data model like star and snowflakes.
• Expertise in analyzing business issues and providing possible reporting solutions to end users.
• Installation, Configuration and Administration of OBIEE and have hands on experience with OBIEE 11.1.1.5,OBIEE 10.1.3.4.1, Siebel Analytics 7.8.4,7.7 and 7.5.3
• Strong understanding of data modeling and dimensional modeling
• Versatile team player with ability to perform under stress.
• Excellent problem solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.
• Extensive experience in OBIEE RPD Development, Answers Intelligent Dashboards, Delivers, iBots.
• Involved in performance tuning at the DB level, OBIEE - RPD, Dashboard Server Level
• Experience in development & customization of BI Publisher (XML Publisher) Reports.
• Worked with Oracle Utilities like Toad, Putty and expertise in SQL * Loader, SQL, PL/SQL and Shell scripting, MS Word, Visio for documentations and diagrams, and Excel spread sheets.

TECHNICAL SKILLS:

Methodologies: Dimensional Data Modeling

Reporting /ETL Tools: OBIEE 11.1.1.5, OBIEE 10.x and Siebel Analytics 7.x

Databases: Oracle9i/ 10g, MS SQL Server, DB2.

Languages: C, HTML, XHTML, XML, JavaScript.

Query Tools: SQL, PL/SQL, TOAD

Operating Systems: Windows 2003/2000/NT/XP

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, Ca

Sr. OBIEE Developer/Analyst

Responsibilities:

• Involved in requirement gathering and transforming the requirements into Business Intelligence solution.
• Developed Metadata Repository, Physical, Logical and Presentation layers based on business requirements.
• Worked on many reports using different Analytics views (Pivot table, graphs, Drill downs, Column Selector).
• Working closely with business teams to Identify the Key Performance Indicators.
• Involved in configuring Data Level security permissions and privileges to groups and users for Data visibility based on their role and responsibility.
• Involved in configuring Object Level Security to the Subject areas, Dashboards, pages and sections based on the business requirements.
• Involved in ETL (Informatica) development.
• Involved in OBIEE RPD, Report and Dashboards development.
• Involved in Data Cleansing, Performance tuning of the ETL’s.
• Supporting Data Analysis team to massage data according to their needs.
• Involved in unit, integration, system and business validation testing of generated reports and supported user acceptance testing team.
• Involved in production supportof reporting solutions that meet requirements of business users.

Environment: OBIEE 11.1.1.5.0, OBIEE 10.1.3.4.1 Standalone Version, Oracle10g/11g, Toad, Windows XP, Windows 7.

OBIEE Developer/Analyst

Responsibilities:

• Worked with Business representatives for gathering the reports and dashboards requirements and to define business and functional specifications.
• Involved in a documenting business procedure by recognizing the necessities and also concerned in searching the system necessities.
• Involved in unit, integration, system and business validation testing of generated reports and supported user acceptance testing team.
• Developed many reports with different Analytics views (drill-down, pivot table, chart, and column selector). Implemented dynamic dashboard prompts & filters to zoom into particular segments of the business in a performance-optimized manner.
• Involved in cache management, creating aggregate tables etc.
• Analysis, Design and Implementation of OBIEE reports and dashboards.
• Worked with operational dashboards like Order Management and detailed reports on order transactions, orders backordered, daily orders reports, inventory, and product divisions and shipping location.
• Analysis, Design and Implementation of MS Excel based reporting solutions.
• Configured iBots to deliver Analytics content based on schedule to obtain the daily and weekly reports.
• Involved in setting up usage tracking in Oracle BI to track usage of reports and dashboards.
• Participated in production supportof reporting solutions that meet requirements of business users.This includes documenting the processes to ensure standards and compliance.

Environment: OBIEE10.1.3.4, Oracle 10g, SQL Developer, SQL*Plus, Toad, Windows XP.

Confidential, NJ

Executive Management Analytics OBIEE Developer

Responsibilities:

• Gathered business reporting needs and prepared documentation based on requirements.
• Involved in creating reports that are used for analyzing the prescription sales information based on selected products, product inventory based on territory.
• Created Reports for Analyzing the Prescription Sales information based on the product per region.
• Coordination and implementation of changes to reporting as a result of a system upgrade.
• Used Oracle BI for generating Sales reports, which provides web based reports for executive, management individuals. Was responsible for the design, Development and Management of daily, weekly and Monthly reports from the database.
• Data Validation and SQL Queries using SQL Assistant.

Environment: OBIEE 10.1.3.2.0, Oracle 10g, PL/SQL, SQL, Excel, Window XP

Confidential, Dallas, Texas

HR Reporting System Siebel BI Analyst

Responsibilities:

• Interacted with Case Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Define the mapping from various physical databases to Business Layer to create the various subject areas in Presentation Layer.
• Implemented OBIEE security for users and groups in administrator tool.
• Created reports by applying views, filters, calculations and conditional formatting in answers.
• Designed Intelligent Dashboards for different user groups to view updated KPIs
• Created and scheduled iBots as per the business requirements.
• Provided technical and user documentation and .

Environment: Siebel Analytics 7.8.2, Informatica Power Center 7.1.3, Oracle 10g.

Confidential, Manhattan, NY

Sales Dashboards Siebel Analyst

Responsibilities:

• Gathered and refined requirements from the business users.
• Imported metadata in to the Physical layer, applied Business rules in the Business Modeling and Mapping layer, and created customized user views and set up catalog folders in the Presentation layer using administrator tool.
• Designed and Developed new subject areas/ Customizations.
• Interacted with users, developed and maintained Reports and Dashboards.
• Resolved application issues faced by users during user acceptance test.
• Responsible for Daily/Weekly/Monthly on time report delivery to the end users.
• Configured report level security and user interface designs.
• Thoroughly examined the source structures and leveraged existing hierarchies into the analytic reporting solution.
• Configured caching mechanism to improve performance.

Environment: Siebel Analytics 7.5.2, Oracle 9i, PL/SQL and Windows 2000.

Confidential, Bristol, CT

Finance Reporting System Siebel Analyst

Responsibilities:

• Responsible for overall project delivery, requirements gathering, data model
• Involved in Installation, configuration and administration of Siebel Analytics Server, Siebel Analytics repository.
• Analyzed and prepared Statement of Work and Requirement Definition Document.
• Performed Administration Tasks Related to the Development and Configuration of Intelligence Dashboards.
• Customized the Siebel Analytics Web User interface.
• Assisted developers in hand-on technical details and troubleshooting.
• Created derived column in BMM layer and exposed in Presentation Layer.
• Used TOAD and SQL/PL SQL tools for faster application design and development.
• Involved in testing, documentation and extensive support for the Implementation team.

Environment: Siebel Analytics 7.5.2, Informatica Power Center 6.2/5.1, Oracle 9i and Windows 2000

Confidential

Oracle Data Warehouse Developer

Responsibilities:

• Involved in the design, development, testing phases of the project and enhancements.
• Created packages for initial load and daily updates.
• Developed and tested Store procedures, Functions and packages in PL/SQL for Day to Day Production support.
• Root Cause Analysis and Fixing issues. Involved in fixing the bugs reported back after initial stages of implementation.

Environment: Oracle 8i, MS Access, SQL, PL/SQL, XML, Windows XP.