SUMMARY
7+ years of software development experience in IT Industry. Proficient in DWH Concepts, Data Modeling, OBIEE 11g/10g, BI publisher, Informatica & DAC Scheduling Tools.

• Exposure to Financial, Healthcare, Insurance, Industrial sectors and business with regard to data ware house development and Oracle BI Applications.
• Expertise in complete SDLC which involves requirement Gathering, Proof of Concept (POC), Gap analysis, converting functional to technical specification, design, development and Unit testing.
• Expertise in OLTP/OLAP system study, analysis and E-R modeling, developing and experience working with multi-dimensional data model, star schema and snowflake schema.
• Worked extensively on OBIEE Administration Tool, OBIEE Answers (ad-hoc querying, reports), OBIEE Dashboards, OBIEE Delivers (alerts) and Oracle BI Applications that are complete pre-built BI solutions like Oracle Financial.
• Experienced in design and development of all the 3 layers of OBIEE repository (Physical Layer, Business Model & Mapping and Presentation Layer) with best practices.
• Well versed in Importing the Metadata from Relational and Multidimensional Databases. Working knowledge in Multi user development Environment (MUDE).
• Experience on working Logical Tables, Logical Dimensions, Multiple Table Sources, Aggregate Tables,Fragmentation content, Bridge Tables, Lookup Tables, Time Series Function, Calculated Measures, Level Based Measures & Global Filter implementation in BMM layer.
• Experience in Managing Security, Joins, Variables & Projects in Metadata layer. Authentication setup for users using LDAP & External Tables. Implementation of Data and Object level Security.
• In-depth Knowledge of using variables like Repository & System variables to streamline Administrative tasks and dynamic change of Metadata content
• Extensive experience in designing Interactive Dashboards using Dashboard objects & Dashboard Prompts, Reports development using different views, Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Hands on experience in using Guided Navigation, Presentation variable, Customization of styles and skins in the UI, configuring Usage Tracking, Score card & KPI reports
• Familiar in configuring and customizing of Oracle BI Publisher/XML Publisher Reports.
• Good knowledge on the Data Analysis & writing DML and DDL queries.
• Experienced in writing, testing and implementation of Stored Procedures, Triggers, Functions, and Packages at database level using PL/SQL.
• Extensive experience in performance tuning, identifying bottlenecks and resolving to improve performance at database and reporting level.
• Extensively used the four basic Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Responsible for Unit, System and Integration Testing and performed data validation for all the reports that are generated from OBI/Siebel Analytics.
• Excellent problem solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS\

BI Tools : Oracle BI EE 10.x, Siebel Analytics 7.x, Oracle BI Apps 7.9.6/7.9.5, Oracle EPM suite
ETL Tool : Informatica PowerCenter 9.x/8.x/7.x
Database : Oracle (11/10g, 9i and 8i), MS SQL Server, MS Access
Database & Office Tools : TOAD, SQL Developer, MS-Office Professional
Scheduling Tool : DAC 7.8.5v
Languages : SQL, PL/SQL, C, C++, HTML, Java
Web Servers : Microsoft IIS, Apache Server 2.0, OC4J,Weblogic
Operating Systems : MS-Dos, Windows 95/98/XP/NT/2000/7, Mac OS, UNIX, Linux.

EDUCATION

• Bachelor of Computer Applications (BCA).
• Master of Computer Science (M.S).

PROFESSIONAL EXPERIENCE

Confidential, NY Mar'10 - Present
Sr. OBIEE Developer

Responsibilities

• Gathered and analyzed requirements from the business users and translated the business requirements into conceptual and detailed technical design.
• Worked with Oracle BI Apps, Oracle BI Server, Presentation Server, Oracle BI Administration Tool and Oracle BI Publisher.
• Performed GAP analysis between existing database tables and Business Process Requirements and recommended enhancements to metadata reporting in all 3 layers.
• Configured OBIEE repository (rpd) with 3 layers i.e., Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Configured dimensional hierarchies for drill down, aggregate navigation, level based measures and time series functions based on the requirements.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Implemented OBIEE Security (Object level and Data level Security in the OBIEE repository and answers) using repository variables, session variables and initialization blocks.
• Created security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Developed User Interface (UI) components folders, dashboards, pages columns, sections, requests/answers, filters, global filters, navigation links, and views/charts using Oracle BI Presentation Services.
• Developed different kinds of reports (pivots, charts, tabular) using global and local filters.
• Configured many Dashboards with different views (Pivot Table, Chart, Tabular and View Selector), dynamic dashboard prompts and guided navigation links.
• Performed performance tuning of dashboards/reports and made recommendations for changes to database.
• Configured iBots to deliver analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Created Oracle BI Publisher reports based on Oracle BI Answers request and designed using Microsoft Word.
• Worked on Multi-user development environment(MUDE) and created different projects.
• BI Apps/OBIEE implementation of Financial Analytics Subject Areas: Financials - AP Balance, Financials - AP Invoice Aging, Financials - AP Overview, Financials - AP Transactions, Financials - GL Balance Sheet, Financials - GL Budget and Expenses, Financials - GL Cash Flow, Financials - GL Detail Transactions.
  Worked with Financial Analytics Dashboards:
  General Ledger: Overview, Balance Sheet, Cash Flow, Budget vs. Actual, GL Balance.
  Payables: Overview, AP Balance, Payments Due, Effectiveness, Payment Performance, All AP Transactions.
• Involved in merging and migrating applications from development to production for deployment.

Environment: OBIEE 10.1.3.4/11g, Oracle 11/10g, DAC, Erwin, Oracle BI Applications 7.9.6,TOAD, Informatica Power Center 9.1, Oracle SQL, BI Publisher, Windows XP.

Confidential, NYC, NY Dec'08 - Feb'10
Sr. OBIEE Consultant
Confidential, is a major American financial services company based in New York City. It has the world's largest financial services network, spanning 140 countries with approximately 16,000 offices worldwide.
OBIEE is used as a reporting tool for providing interactive dashboard access to strategic business information from the company wide data warehouse analytical information assets in retail finance.

Responsibilities

• Worked with Business analysts as well as other business teams on requirement gathering.
• Developed OBIEE repository (rpd) at 3 layers i.e., Physical Layer, Business Model & Mapping Layer and Presentation Layer.
• Designing and developing physical and logical star schema using OBIEE admin tool.
• Developed the metadata repository (rpd) as per the requirements collected bydata analysis and applied business rules in the BMM layer.
• Import/create tables and add/change physical joins/keys.
• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Modified presentation layer dimensions and attributes to match user requirements.
• Created dimension hierarchies, time comparisons and level based measures.
• Created time series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Administered Nqsconfig.ini and Instanceconfig.xml configuration files.
• Created session and repository variables to achieve desired functionality.
• Worked extensively on various Cache Management techniques to increase the performance of the reports.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP, Database; and Database table authentication using Session variable features, as well as Dashboard / Report-level security by creating initialization blocks.
• Developed many complex reports/ad-hoc queries and dashboards with different analytics views drill-down/dynamic, pivot table, chart and column selector, with global and local filters using Oracle BI Presentation Services.
• Administered analytics intelligence dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and tables.
• Utilized delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
• Involved in creating the highly formatted parameterized BI Publisher reports that use various data sources such as BI Answers and Subject Areas.
• Actively involved in implementation of Oracle Financial (General Ledger, Payables and Receivables) & HR Analytics and developed custom reportsand created ad-hoc reports according to the client needs.
• Life-cycle support for migration efforts from development to QA to production analytics.
• Involvement with ETL (Extract-Transform-Load) development team to communicate the specification for the required dimensional, aggregate and indexed data tables.
• Involved in Unit testing and documentation.

Environment: OBIEE 10.1.3.3, Oracle 10g, Informatica Power Center 8.6.1, SQL Developer, Oracle BI Apps 7.9.5, Financial Analytics, TOAD, Windows XP.

Confidential, Claymont, DE June'07 - Nov'08
OBIEE/Siebel Analytics Developer
Confidential, is a global health services company provides benefits to the customers. Siebel Analytics BI platform solutions were implemented for providing interactive dashboard access to strategic business information from the company-wide data warehouse analytical information assets in Cigna.

Responsibilities

• Worked closely with Business Analyst in understanding the analytics requirements and generated reports as per the user requirements.
• Presented the overall repository (rpd) metadata development methodology.
• Configured Analytics repository (rpd) with implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.
• Modeling activities which included building star schema as per the business requirements and configuration of logical layer, logical tables, dimensions and columns in business model and mapping layer. Established the logical joins/keys required to support drill-down aggregation.
• Created aggregate tables, imported and configured in Admin tool to perform aggregate navigation.
• Implemented security by creating roles and web groups, checks with LDAP Authentication.
• Worked extensively on OBIEE answers to create the reports as per the client requirements.
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns.
• Implemented the delivery of iBots using Siebel Delivers to alert the associated teams.
• Extensive experience in performance tuning, identifying bottlenecks and resolving to improve performance at database and reporting level.
• Migrated the rpd metadata and web catalog contents to test and production environment.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the repository.
• Involved in developing Initial and Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions/Tasks.

Environment: OBIEE 10.1.3.2, Siebel Analytics 7.8, Informatica Power Center 8, Oracle 9i/10g, Windows 2000

Confidential, Little Rock, AR Feb'06 - May'07
Siebel Analytics Consultant
Confidential, provides telecom services such as wireless, local telephone, long-distance, Internet and high-speed data services to residential and business customers in 26 states across North America.Alltel required a complete solutions package Data mart for its Billing Department to analyze and report the consumer revenue trends. The Customer Billing and Maintenance project was implemented to establish and enhance a cost effective Customer Management Analytical System.

Responsibilities

• Worked closely with Business Analyst in understanding the analytics requirements and created the business model for generating reports as per the user requirements.
• Worked closely with the data modeler in designing the logical data model/physical data model (star schema).
• Installed and Configured the Siebel Analytics Server and the IIS.
• Createdand administered repository (rpd) with three layers Physical Layer, Business Model and Mapping Layer and Presentation Layer using Siebel Analytics Administration Tool.
• Imported data from different data sources, Oracle and SQL server into Siebel Analytics Repository.
• Created logical tables in the business layer and dimensional hierarchies in Subject Area.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Involved extensively in SiebelAnswers, Siebel Delivers and Siebel Intelligent Dashboards with Siebel Analytics Integratedimplementation.
• Worked with operational dashboards like Order Management and detailed reports on order transactions, orders backordered, daily orders reports, inventory, product divisionsand shipping location which provided instant insight for organization's business by providing them with relevant and timely information, allowing executives to instantly identify and apply appropriate check points to improve their efficiency.
• Used global and local filters and provided customized prompts (filtering options) appropriately to avoid excessive data visibility in reports.
• Created dashboards by embedding reports and providing intuitive drilldowns, interactive flash-based drillable charts and links to exploit the full benefit of Analytics.
• Created iBots and interactive dashboards to alert the marketing team about business changes.
• Involved in unit testing, integration testing of the reports generated using Siebel Analytics.

Environment: Siebel Analytics 7.8, Informatica Power Center 7.1, Oracle 9i, SQL Server, Windows NT

Confidential, India. Aug '05 - Dec'05
Siebel Analytics/ETL Developer
Confidential, is one of the most promising manufacturers, importer, exporter and traders in metal market. Siebel Analytics is used as a reporting tool to analyze the performance of Sales, Service and Marketing organization and helped executive to make strategic decisions. Client required greater visibility to forecasting, more control over actual sales versus forecasted sales.

Responsibilities

• Worked with functional and technical project leads, marketing, sales, finance, and other business groups to identify, analyze, and document business requirements.
• Enhanced existing business models & created customized dashboards using Webcat for various reports.
• Performed the detailed design of reports and dashboards using Siebel Answers and Webcat.
• Developed custom reports using Siebel Answers and assigned them to application specific dashboards.
• Included guided navigational links and drilldowns for maintaining the effectiveness in creation of dashboards.
• Developed different kinds of reports, with different views such as narrative view, pivot table, chart, view/column selector and tabular view using global and local filters.
• Setup the visibility of dashboards to employees with respect to their responsibilities.
• Worked on various Informatica mappings as per business requirement.
• Worked with Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.

Environment: Siebel Analytics 7.7, Informatica Power Center 7, Oracle 8i, SQL Server 2005, SQL, SQL *Plus, PL/SQL, TOAD.

Confidential, India. Apr '05 - Jul'05
SQL Developer

Responsibilities

• Gathered user requirements and created the business requirements documents.
• Created and managed database.
• Used the technical document to design tables.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, sequences, grants and synonyms.
• Created database triggers and stored procedures.
• Performance tuning of SQL Queries.
• Documented the technical specification for the reports and tested the generated reports.
• Prepared user manual and technical support manuals.

Environment: Oracle 8i, SQL, SQL*PLUS, PL/SQL, Windows NT, UNIX.