SUMMARY:

• Five years of Complete Life Cycle or End-to-End (gathering Business Users Requirements, System Analysis, Design & Data Modeling, Development, Testing) implementation experience of Business Intelligence using Oracle Business Intelligence Enterprise Edition(BI)
• Very strong in Oracle Business Intelligence, Siebel Analytics, Presentation Services
• Involved in developing Oracle BI / Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer).
• Experience in installation and configuration of Oracle BI EE 10g in the windows environment.
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Contextual Navigation, Guided Analytics, Alerts, Security Setup (groups, access privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Implemented security by creating roles and web groups using external tables and LDAP.
• Expertise in debugging and optimizing the Oracle BI/Siebel Analytics Dashboards and Reports.
• Good at performance tuning of Oracle BI/Siebel Analytics Repository & Dashboards and Reports, by implementing Aggregate tables, Indexes and managing Cache.
• Strong experience in testing and tuning OBIEE metadata and reports.
• Very strong in SQL, Oracle PL/SQL programs, Procedures, Packages, Functions, Triggers and other object.
• Experience in designing star schema. Experience in Designing Fact Tables and Dimension Tables.
• Experience of creating reports with Guided Navigation and Drill through Capabilities.
• Have extensive hands-on technical proficiencies in application development using Oracle 10g/9i/8i/7.3 using SQL* Plus, PL/SQL, SQL* Loader and Import/Export utilities.
• Experienced in assessing, designing, building, testing and implementation phases of the existing applications.
• Experience in ETL tools like Informatica
• Experience in working with different operating systems like UNIX, Linux and WindowsNT/2000.
• Excellent communication skills and experience working with business user’s community and leads/managers.

EDUCATIONAL QUALIFICATION:
MBA in Information Technology

TECHNICAL SKILLS:
Operating Systems: Windows Vista/XP/NT, UNIX/LINUX, DOS
Programming: C, C++, SQL, PL/SQL, Visual Basic, Java, Javascript, HTML, XML
Database: Oracle 9i/10g, MS Access
Applications: Oracle Business Intelligence (OBI) EE 10g (Admin, Presentation Services), Siebel Analytics 7.8.5.2, SQL*Plus 8.x/9.x, PL/SQL 8.x/9.x, Developer2000, Toad, SQL developer, Informatica

WORK EXPERIENCE:

Confidential,Mountain View
5/2009– Till Date
OBIEE/Siebel Analytics Developer

The project was to customize the OBI Apps (Procurement & Spend Analytics and Supply Chain & Order Management) modules and build OBIEE reports to have the same functionality and data content as the already existing SAP BW reports which Business users were already sing.
This involved requirement gathering with business users to understand the SAP BW reports, their data content and customizing the pre-built ODI interfaces to extract and load data from SAP R/3 system to Oracle BI Application database, analyzing the OBI Apps Rpd to see what all needed to be customized/developed in the OBIEE rpd for building the OBIEE reports which would match the SAP BW report’s functionality and data content.

Responsibilities:

• Responsible for full cycle implementation of OBIEE.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities based on organization’s and product’s hierarchies.
• Gap Analysis of OBI Apps module to check what needed to be customized for building the OBIEE reports.
• Requirement gathering from business users.
• Implemented data level and object level security.
• Implemented different views of report i.e. charts, Pivot table, Titles, Graph, Filters etc. and added column selector, view selector and narrative view to the reports.
• Generated Dashboards and customized it as per user requirements.
• Created users, groups, configured the permissions in the administration tool and verified the Permissions of the users in web catalog.
• Customized the OBIEE Rpd and designed OBIEE reports on top of it.
• Configured web catalog objects (Dashboards, Pages, Folders, Reports)
• Performed Unit, Integration, and Regression testing of various Dashboards / Reports
• Involved in UAT with business users that involved comparing the functionality of OBIEE reports with that of SAP BW reports.
• Used global and column prompts to filter data to customize the report according user requirement and to increase performance
• Performed Unit, Integration, and Regression testing of various Dashboards / Reports and Repository.
• Developed reports as per user requirements and included them in the dashboards.
• Extensively used SQL queries, Procedures, Triggers.

Environment:
Oracle BI Application 7.9.6, OBIEE 10.1.3.4.1, Oracle Data Integrator 10.1.3.5, SAP ECC 6.0, SAP BW 3.5 and Oracle 10g

Confidential,San Francisco, CA 9/2008– 4/2009
Siebel Analytics Developer/ OBIEE

Blue Shield of California is a not for profit health plan. Their mission is to improve the lives of the people it serves and the health of its communities. In 2006 Blue Shield was recognized as an excellent health plan for service and clinical activity. Blue Shield of California became the first health insurer in the country to propose a specific plan for universal health coverage. The project was to centralize decision making system as part of data management which involved integrating and simplifying by dropping unwanted data elements, introducing new elements and combining data using ETL processes by providing composite and meaningful views to users.

Responsibilities

• Participated in User Meetings to understand the requirements.
• Responsible for full cycle implementation of OBIEE.
• Built the OBIEE repository/metadata (Physical Layer, Business Model and Mapping Layer and Presentation Layer) and created the subject area where reporting and analysis are centered around.
• Developed calculated measures and dimension hierarchies in the Business Model and Mapping Layer.
• Configured web catalog objects (Dashboards, Pages, Folders, Reports).
• Created Logical tables and Logical columns in the Business Layer of the repository (RPD).
• Implemented data level and object level security.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities based on organization’s and product’s hierarchies.
• Implemented different views of report i.e.charts, Pivot table, Titles, Graph, Filters etc.
• Generated Dashboards to provide insight into Sales Analytics, Activity Analytics.
• Created users, groups, configured the permissions in the administration tool and verified the Permissions of the users in web catalog.
• Created Dashboard prompts for customizing the reports as per user requirements.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Tested and debugged the application using SQL scripts and appropriate log files.
• Managed the Analytics Cache environment.
• Developed user guides for the end users. User guide contained some screenshots of high level reports and also provides instructions in accessing them.
• Also participated in developing ETL design using Informatica, used Transformations like Aggregator, Joiner, Update, Filter, Lookup, Sorter.

Environment:
Oracle 10g, Informatica 8.1.1, OBIEE 10.1.3.2, DAC, BI Publisher, Toad, SQL, SQL * Loader, PL/SQL Procedures, Windows 2000, UNIX, Shell Scripts.

Confidential,CA 10/2007 - 08/2008
Siebel Analytics Developer/ OBIEE

Logitech User Experience (LUE) software records the usage of all Logitech devices (namely mouse & keyboards). The Arlberg project dealt in creating business intelligence solutions to analyze the product usage data collected by the LUE software to calculate the Logitech product’s performance and lifetime.

Responsibilities:

• Participated in requirements gathering by meeting with the business user and base lining the details, preparing the documents and conducting application demonstration.
• Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle Business Intelligence (OBI) Analytics platform.
• Created Mock reports based on the initial requirement and finalized the reports after the extensive discussions with the business users.
• Developed new Reports (20)/Dashboards (4) with different analytics views (drill down, pivot table, chart, column selector, View selector, gauge, tabular with global and local filters) using OBIEE presentation services.
• Extensively used the Narrative and Static view in the reports.
• Used global and column prompts to filter data to customize the report according to user requirement and to increase performance.
• Created Materialized views to improve the performance of the reports & dashboards
• Implemented security by creating groups using external tables and LDAP.
• Worked with the ETL team to design the table structure for the database.
• The staging tables were loaded through xml data files using SQL scripts and web applications. OWB mapping was used load data from staging tables to Facts and Dimensions..
• Involved in solving production issues raised by other OBIEE projects.
• Documented every phase of the project- Business Requirement, UI functional Specification Doc, User Guide, Test cases.

Environment:
Oracle Business Intelligence (OBI) EE 10.x, Oracle 10g, Oracle Warehouse Builder, Toad, SQL developer, XML editor .

Confidential,Houston 10/2006 – 9/2007
Siebel Analytics /OBIEE Consultant

Hewlett-Packard Company commonly referred to asHP specializes in developing and manufacturing computing, storage, and networking hardware, software and services. Major product lines include personal computing devices, enterprise servers, related storage devices, as well as a diverse range of printers and other imaging products. The project was to provide reports regarding customer billings, collections and service requests solution to Cingular’s wireless customers and also helped them segmenting customers to enhance decision-making process and marketing process with respective to generate revenue and service management and target new markets.

Responsibilities:

• Extensively worked on answers and dashboards.
• Installed and configured Siebel Analytics on Windows and Unix environments.
• Built physical layer, BMM layer and presentation layer in the repository.
• Created users and groups in the repository and assigned privileges to them.
• Implemented security in repository using repository variables and filters.
• Involved in gathering requirements from end users
• Reviewed documentation for correctness and clarity.
• Was involved in testing the reports and fixing the bugs.
• Extensively used the SQL queries to test data.

Environment:
Siebel Analytics 7.7.1, Oracle 9i, SQL, PL/SQL, Toad

Confidential,Bangalore, India 5/2004 – 9/2005
Database Developer

ITC Info Tech provides a comprehensive suite of IT services and solutions with professional well versed in various technologies in demand by the current IT industry.

Responsibilities:

• Wrote several stored procedures/triggers in Oracle (PL/SQL) for the enterprise portal application and data merge.
• Worked on very large database environment and tuned queries for performance. Created and maintained parallel queries for very large datasets.
• Creating temporary tables and indexes for loading and updating data.
• Worked on queuing for sending XML data to the calling java APIs.
• Data loading using SQL *Loader.
• Imported/exported several databases through various environments
• Involved in creating test script and testing modules.

Environment:
Oracle8i, SQL, PL/SQL, XML, SQL*Loader