SUMMARY:

• Having 8+ years of Strong experience in Complete Software development Life cycle (SDLC) of Database, Data warehouse and Business Intelligence Applications which includes experience in OBIEE 10.1.3.x/Siebel Analytics 7.x, which includes Administration tool, Intelligent Dashboards, Answers, Delivers, iBots, Oracle BI Publisher, and Oracle BI Applications 7.9.5 (DAC).
• Experience in ETL methodology using Informatica Power Center/Mart.
• Core competencies include data modeling, design and development of ETL Data mart, Development/Administration of DAC, Informatica and OBIEE repositories, and building OBIEE Dashboards/Reports.
• Expertise in different stages of handling data viz. requirement gathering, identifying data sources/targets, data structure,data modeling, data cleansing, data loading.
• Proficient in defining key metrics, dimensions, hierarchies, attributes and building Star and Snow flake schema.
• Used DAC (Data Warehouse Administration Console) to configure, administer, load and monitor modular data warehouse applications.
• Exclusively worked on OBIEE Administration (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Job Manager, Catalog Manager, BI Publisher, Marketing and Disconnected Analytics.
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse
• Working Knowledge of tables, processes and configurations
• Expertise in converting and using Oracle pre-build rpd's (Finance Analytics) according to business requirements.
• Experience in configuring OBIEE Security integrated with Active Directory
• Experience in Implementing QA,Generating test scripts and Writing Test Case.
• Sound Knowledge and Experience on E-Commerce, Retail Market, ERP (Enterprise Resource Planning), HR (Human Resource), SCM (Supply Chain Management), CRM (Customer Relationship Management) sectors.
• Strong expertise in Implementing MUD (Multi User Development) Environment.
• Good hands on experience in using BI Publisher to create reports from BI Answers, BI server.
• Good experience in using Application Implementation Methodology (AIM)
• Strong knowledge of business processes involved in Supply Chain Management.
• Interacted with clients, customer, end users and team members to provide quality product.

SKILLS:

DW technologies & OLAP: Oracle Business Intelligence (OBI) EE 10.1.3.x, Siebel Analytics 7.5, 7.7, 7.8, ETL Informatica 8.x/7.x/6.x, ODI.
Data Modeling: ER Diagram, Entities, Attributes, Cardinality, Relational Modeling, Physical Modeling, Logical Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Erwin 4.5/4.0/3.5.2.
Databases: ORACLE 10g/9g/9i/8i, SQL Server-2005/2000/7.0/6.0, Sybase SQL, DB2, EBS, Ms-Access.
Languages: C,C++,C#, SQL, PL/SQL
Tools: Microsoft-Office, Microsoft Visio, IBM Rational Rose Requisite.
Web Technology: HTML,CSS, XML, Java Script.
Web Server: IIS, HTTP 1.1, Weblogic, Apache Tomcat.
Operating Systems: Windows 95/98/NT/XP/Vista, Server 2003/2007, UNIX, Linux Red Hat.
Utilities: SQL * Loader, Toad 9.0/8.5.1,SQL Developer, OID.

EXPERIENCE:

Confidential, (Exchange Place, NJ)
Sr. OBIEE Developer
Jul10 - Current

Confidential, is to provide transparency and reporting for Hedge Fund Investors. The standard set of reports has been defined through intensive consultation with Investors and Hedge Funds, and may have bespoke modifications at the request of the client. The project is to provide the clients with high quality, tailored transparency risk reports across its portfolio holdings.

• Worked closely with Business Analysts in understanding the BI requirements and created Business Models for generating Reports as per the requirements.
• Installed OBIEE and Oracle 11g in Windows Professional Environment and configured them for the end users.
• Worked and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in BI Repository (.rpd) using Oracle BI Administration Tool.
• Developed many Reports/Dashboards with different BI Views (Pivot Table, Chart, View Selector, and Column Selector, with global & local Filters using Oracle Bl Analytics Web.
• Created Filters and provided customized prompts appropriately to avoid excessive data.
• Created Users, Groups and giving the permissions in OBIEE Administration Tool and verifying the Permissions of the users in OBIEE web.
• Performed Tuning of Dashboards/Reports by aggregate navigation, and cachemanagement.
• Responsible for unit testing, integration testing of the reports generated using BI analytics.
• Involved in the migration of catalog from Dev to QA and Production and providing permissions and access to the end users.
• Supported the Business with the publishing of daily and weekly reports, fixing the codes and bugs, designing the layouts.
• Imported Sources and Targets created Mappings and developed Transformations using Informatica.
• Created mappings and transformations using expressions, aggregators, filters, sorter to develop and populate Database.

Environment: OBIEE 10.1.3.4, Oracle 10g/11g, SQL Developer, Informatica Power Center 8.6, Windows XP Professional.

Confidential, (Santa Ana, CA)
Sr. OBIEE Developer
Jun09 - Jun10

Confidential, is one of the largest post secondary education company having more than 105,000 students all over USA and Canada. The projects main focus was to build different financial reports for the presidents and the vice presidents of the different campuses to provide insight to the business.

Responsibilities

• Gathering requirement from user and modeling according to technical specifications.
• Performed Data Warehouse analysis and identified the required Facts, Dimensions, Levels / Hierarchies of Dimensional and referential joins.
• Devised a model plan to implement the analytical repository from an Oracle Business Intelligence perspective.
• Performed the setting up, installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Involved in developing the Incremental ETL process (Mappings & Mapplets) using various Transformation and Workflows with Sessions/Tasks, executed workflows through shell scripts using pmcmd.
• Designed and developed Metadata Repository (.rpd) using Oracle BI by importing the required objects with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies), Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Developed different financial analysis Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of Analytics that includes (.rpd, Dashboards, Briefing Book, Catalog Management, Security etc.).
• Designs the integration of Hyperion Essbase into legacy and OBEE environments.
• Worked with Hyperion Essbase in Revenue, Expense and in Workforce application.
• Worked for 5 reports in Crystal ReportX and for Student Accounts.
• Created stored proceduresand views and import them to crystal report and worked with campusvue to publish the reports.
• 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 Siebel Analytics Repository.

Environment: OBIEE 10.1.3.4, OBIEE Apps 7.9.6, Informatica Power Center 8.6,DAC 7.8, Oracle 10g,SQL Server 2005,DB2,Toad 10,Flat Files, Oracle EBS Apps, Erwin, Hyperion Essbase 11, Windows 2003 Server, Crystal X,CampusvueWindows NT.

Confidential, San Jose, CA
Sr.OBIEE Developer
May08 - Feb09

Confidential, an online auction and shopping website in which people and businesses buy and sell a broad variety of goods and services worldwide. The project main focus on Supply Chain Management of product and services required by customers, generate reports and dashboards to analysisandforecast the sales. This Project was aimed at building both Data warehouseandData marts for eBay Clients. The Data warehouse and the Data marts are constructed for managing huge number of disability Clients. Data warehouse will be loaded into various different individual data marts which will be used in report generation by business users.

Responsibilities

• Participating in User Meetings to understand the requirements.
• Working closely with the data modeler in creating logical data model (Star Schema).
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Designed and Developed OBI Repository at 3 layers i.e., Physical Layer (connecting to Data Warehouse & imported objects with joins), Business Model / data mapping (create Logical tables, Drill-Down Hierarchies & complex joins) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Developing Calculated Measures and dimension hierarchies in the Business Model and Mapping Layer.
• Configuring Web Catalog Objects (Dashboards, Pages, Folders, Reports)
• Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Generating Dashboards to provide insight into Sales Analytics, Activity Analytics.
• Created guided navigation links to help files within the dashboards to help the end users.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Generate Crosstab Reports, Hypertext Reports, and Templates for Dashboard pages.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Extracted data from heterogeneous legacy system like DB2, Flat files, MS SQL Server and application like Oracle EBS (Supply Chain Management) and XML files.
• Creating Deliverables and scheduled ibots.
• Tested application to meet user needs using UserAcceptance Testing (UAT).
• Created Session variables, Repository variables and initialized the variables using the Initialization blocks.
• Implemented Quality Assurance (QA) to track down bugs, defects, issues etc.
• Worked on Multiuser development environment.
• Developed user guides for the end users. User guide contained some screenshots of high level reports and also provides instructions in accessing them.

Environment: OBIEE 10.1.3.3,OBIEE Apps 7.9.5.1, Informatica Power Center 8.1.1, Flat files, Oracle 10g, DAC 7.8, MS SQL Server 2005,Oracle EBS(SCM), DB2, Erwin 4.3, PL/SQL, UNIX Shell Scripting, Toad,Windows NT.

Confidential, San Diego, CA
OBIEE/ Informatica Developer
Sep07 - Mar08

Confidential, is one of the largest insurance claims processing companies in the world. It has 300 insurance company customers and delivers many of its applications based on the software as a service or hosted model. Create OBIEE metadata reports and dashboards and integrate the application with Oracle Mapviewer in a highly secure, extranet environment.

Responsibilities

• Designed and populated dimensional models both star and snowflake schemas for a data warehouse and Datamarts.
• Used Parallel extender (Informatica 7.1.1) while running jobs for bulk data splitting and to pass the data into subsets to all available nodes for best job performance.
• Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle Business Intelligence (OBI) Analytics platform.
• Involved in the design of the BAL (Business Analytics Layer) & designing the DW for the BAL.
• Configuring OBIEE with LDAP server for Security.
• Designed and Developed OBI Repository at 3 layers i.e., Physical Layer (connecting to Data Warehouse & imported objects with joins), Business Model / data mapping (create Logical tables, Drill-Down Hierarchies & complex joins) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Implemented security at Object Level & Data Level for different level of hierarchies & Subject Areas.
• Developed different kinds of Reports pivots, Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters using Siebel Analytics Web.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas
• Installed and configured OBIEE. Admin tool and Siebel web components including Intelligence Dashboards, answers, delivers and Analytics web and BI Publisher.
• Developed strategy for migration from Siebel Analytics 7.9.5 to OBIEE 10.1.3.3.
• Performed the benchmark and SLAs for up gradation process and runtime of OTB and new reports while doing migration from Siebel Analytics to OBIEE.
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.
• Extracted data from heterogeneous sources for ETL process
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying mappings.
• Performance tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures.

Environment: OBIEE 10.1.3.3, Informatica 7.1.1, DAC 7.8.5, OBI Publisher 10.1.3.3, Siebel Analytics 7.9.5, SQL Server 2005, Oracle 9i, TOAD, Windows XP

Confidential, Morgantown, WV
Sr. Siebel Analytics Developer
Jan07 - Jul07

Implemented Mylan Pharmaceuticals Applications with focus on Syndicated data related to Mylan pharmaceutical companies for their drugs, FDA audit and also for Sales Rep to cover different territories. This project is implemented for rolling syndicated sales data, which was being provided by third parties for their two types of drugs.

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics requirements and created Business Models for generating Reports as per the requirements.
• Designed Technical documents for the conversion programs and Interfaces from Functional documents.
• Created and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository (.rpd) using Oracle BI Administration Tool.
• Developed many Reports/Dashboards with different Analytics Views (Drill-Down & Drill-Across, Pivot Table, Chart, View Selector, and Column Selector, with global & local Filters using Oracle BI/Siebel Analytics Web.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and user Security.
• Created Filters and provided customized prompts appropriately to avoid excessive data.
• Developed Accounting and Collection Time Series Object (Oracle BI Time-Series Functions) for comparing the Billings, Collections and Adjustments.
• Created Users, Groups and giving the permissions in Siebel Analytics Administration Tool and verifying the Permissions of the users in Siebel Analytics web.
• Enforced Row Level Security for Managers to View the Reports pertaining to their Region.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Performed Tuning of Dashboards/Reports by aggregate navigation, and cachemanagement.
• Worked on SA Delivers and Configured iBots to deliver Analytics content based on a schedule.
• Developed many complex Informatica mappings and mapplets to build key interfaces using reusable transformations (Source Qualifier, Lookup, etc.) for loading data into Data Warehouse.
• Used Informatica Power Center to develop ETL mappings, transformations, and to load data.
• Used Informatica transformations like Normalizer, Expression, Filter, Aggregator, Update Strategy, Lookup, Joiner, etc. extensively to create complex mappings and mapplets.
• Responsible for unit testing, integration testing of the reports generated using Siebel analytics.

Environment: Siebel Analytics 7.8, Informatica Power Center 7.7.1, Data, Windows XP, UNIX/Linux, Shell Scripting, Oracle 9i, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential, Dallas, TX
Mar 06 - Nov06
Siebel Analytics Developer

• The purpose of the Flashboard Project is to assist sales and marketing Department to calculate their market share in different segments based on geographical area. Also help the Management to forecast their markets accurately, Identify the factors that most impact each segment\'s profitability. The project is focused on developing various detail and summary reports that will prove helpful for the sales and marketing teams.

Responsibilities:

• Gathered the business requirements and specifications from end users, marketing executives and managers.
• Analyzed, Designed and Developed Siebel Analytics Metadata repository (.rpd) with aggregates, dimensions, Time Series Objects, Catalogs, Folders, enforced external table security using session variables.
• Developed calculated measures & assigned aggregation levels based on dimension hierarchies.
• Informatica was used to translate the Business requirements into mappings, and to load data into Data warehouse.
• Built and debugged various Dashboards with drill-down capabilities based on hierarchies using local and global filters using Siebel Answers.
• Designed Reports with different Analytics Views (Pivot Table, Chart, Tabular & View Selector)
• Developed mappings using transformations like Connected and Unconnected lookups, Aggregator, Update strategy, Router, and Sequence generator.
• Developed different reports using pivots, charts, global and local filters using Siebel Answers.
• Used the expression builder utility to create new logical columns and calculation measures.
• Customized prompts appropriately to avoid excessive data showing up in Reports and Graphs.
• Created new Time series measures using AGO and TO Date functions for forecasting.
• Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Environment: Siebel Analytics 7.7.4, Oracle 9i, PL/SQL, UNIX, SQL*Plus, Windows 2k/XP.

Siebel Analytics Developer
May 04 - Dec 05

Confidential, for it's Human Resources products and services. HR Helpdesk Management: Helpdesk Management solution leverages on technology that is "tried and true" in concert with best practices in HR management. For each case or service request received, based on its complexity, the case is routed to the most appropriate authority. The project involved analysis, design, testing and deploying the data from the various source systems to the Data warehouse system according to the business requirements of the users.

Responsibilities

• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer
• Defined Connection Pools to the Source Data Mart tables in the Physical Layer
• Created Logical Columns based on other Logical and Physical columns in the BMM layer
• Created Presentation catalogs for Sales and Month End Account measures.
• Siebel Analytics Server Administration (Setting up a repository, Administering the Query Environment, Scheduler, Query Caching)
• Created the physical and complex joins in the Physical and Business layers
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns
• Created Aliases and defined Role-Playing Dimensions
• Used Time Series Wizard to create alias fact table in the BMM and Physical Layers to compare measures and spot trends.
• Created Repository Groups and Web Groups and assigned users to configure security in the Siebel Analytics Server
• Defined Session variables and the corresponding Initialization Blocks for User Logins at dimensional levels
• Defined Session variables in the repository to populate the current date filters
• Developed/Customized Siebel Dashboards, Siebel Answers, Siebel Delivers (I-Bots)
• Created Reports based on user requirements
• Worked on Dashboard and Page level prompts and Report filters

Environment: Siebel CRM 7.8, Analytics 7.7, Oracle 9i, Informatica 6 & Windows 2003.

Confidential, India
Mar 03 - Mar04
Crystal Reports Developer

This Reporting solution was intern solution for the HR department to leverage their organizations operational. The reporting solution ensure compliance with government regulations, provide improved service to the employee base and more effectively manage all matters related to human resources. Reports are being generated by using Crystal Report 7.0.

Responsibilities:

• Was responsible for creating reports using Crystal Reports 7.0
• Mostly engaged in report creation with many sub-reports and number of report section.
• Good experience in working with watermarks.
• Customized reports in human resources.
• Created numbers of complex formula in sub report using different type of variables likes shared variable and retrieved them from master report.
• Created reports with number of sub-reports using different type sub-report (Linked, Unlinked and On demand Sub-report)
• Developed Reports with Dynamic Prompts and Static prompt parameter
• Strong experience in creating stored procedures and views.
• Very good experience in creating multiply level Cascading prompt for both static and dynamic parameter.

Environment: Microsoft SQL Server 7.0, Visual Basic 4.0, Crystal Reports 7.0, Crystal Report 6.0,MS-Access, PL/SQL, Windows 98.

EDUCATION:

• Bachelors in Computer Technology