EXPERIENCE SUMMARY

• Over8 yearsof experience in gatheringBusiness Requirements, assessing & developing Business Intelligence Program strategies, and designing and implementing Business Intelligence information & analytical solutions.
• Expertise in providing end-to-end business intelligence solution by configuring metadata & building AnalyticsRepository, dimensional modeling design, building business models, generating reports, and creating Inter-active Business Intelligence Dashboards using11g,OBIEE,Siebel Analytics.
• Worked Extensively on11g/Oracle BI/Siebel Analytics Administration Tool, Siebel Analytics Web / Presentation Services, Answers, & InteractiveDashboardsandSecurityImplementation.
• Strong in Business Model development with Dimensions,Hierarchies, Measures, Aggregation Rules, Time Series,Caching& Mapping.
• Expertise in implementing the Oracle BI / Siebel Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Extensive experience in building Interactive Dashboards with drill-down &drill-acrosscapabilities using global & local Filters, Contextual Navigation,Guided Analytics, Business Rules with User Identity & Roles, Profiles & Personalization.
• Very good in Debugging, Optimizing andPerformance Tuningof Oracle BI / Siebel Analytical Dashboards/Reports.
• Expertise in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 7.x/ 6.x.
• Very good experience in developingInformaticaMappings / Mapplets and Workflows with Worklets & Tasks using various Transformations (Update Strategy, Filter, Router,
• Expression, Stored Procedure, Lookup, and Aggregator) for ETL of data from Multiple Sources to Data Warehouse.
• Expertise inOracle PL/SQLand database Performance Tuning by implementing Parallel
• Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes.
• Multi-platform experience on UNIX / Linux and Windows Server family.
• Results oriented, self starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

EDUCATION

• BSin Computer Science and Information Technology

TECHNICAL SKILLS

• 11g,OBIEE10.x, Siebel Analytics 7.x (Admin, Webcat/Presentation Services, Dashboards, Publisher, Delivers, iBots)
• Informatica5.1/6.x/7.x (PowerCenter & PowerMart) , SSIS package
• Oracle11g/10g/9i/8, Oracle Applications10.7
• MS SQL Server 2000, SQL Server 2005, T-SQL, Lotus Notes
• SQL*PLUS 8.x/9.x, PL/SQL 8.x/9.x
• C, C++, Java, JSP, EJB, HTML, XML, Perl, UML
• Windows 95/98/NT/2000, Linux, Unix

EXPERIENCE DETAILS

Confidential, Richmond, VAMarch 10 Till Date
11g/10g OBIEE Consultant
Confidential,provides a comprehensive line of banking, brokerage, insurance, investment, mortgage, and trust and payment service. This project I managed single handed, involves integration of data from different sources to facilitate automated reporting process for Senior Executive Team using OBIEE tool.

Responsibilities

• Gathered, Analyzing and identifying theGapof Business Reports Requirements.
• Identified Facts and Dimensions (with levels & hierarchy) and developed Siebel Analytics Repository (RPD) at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Installed11g versionon 64 bit windows, upgraded 10g RPD and Webcat.
• Worked with Oracle indebuggingthe issues.
• Installed somepatchesinthe 11gversion based on Oracle recommendation
• Developed many Reports using different AnalyticsViews(Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards withdrill-downcapabilities, charts, tabular using global and local Filters. Extensively used Siebel Delivers andiBots.
• ImplementedSecurityby creating roles, web groups, and external tables.
• Coordinated the Analytics RPD and Web Catalog objectsmigrationfrom Dev environment to QA environment and to the Production environment.
• Developed the Initial and Incremental / DeltaETLprocess i.e., Mappings & Mapplets using various Transformations for new objects.
• Performed Unit, Integration and Regression testing to validate reports and mappings.
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd.
• 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.
• Worked extensively onperformance tuningof reports in the application layer.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 7.1.
• Extensively worked in fine-tuningof Informatica Mappings.
• Used different application development tools likeTOAD(Oracle)
• Created mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target table.

Environment:11g,OBIEE 10.x, Informatica Power Center 8.1, Oracle 10g

Confidential,NYSep ’08 Feb’10
OBIEE Consultant
Cares Application:
City of New York is implementing Cares Application for the Dept of Homelessness. The Database is Oracle 11g and application is Cares which is on Java Platform. OBIEE is implemented for generating reports. The ETL process involved extracting the data from Oracle database. There are about 30 reports generated as per client’s requirement.

Responsibilities

• Creating and modifyingBusiness Intelligencerequests using Oracle Business Intelligence Answers.
• Create and modify Interactive Dashboards and Creatingguided navigationlinks within Interactive Dashboards.
• Worked as a member of architect team in reviewing the code developed by different teams.
• Used Oracle Business IntelligenceDeliversto configure, schedule, and deliver personalized alerts to Interactive Dashboards by using Agents.
• Performingadministrative tasksrelated to the development and configuration of Interactive Dashboards
• Designed and BuiltOBIEE RPDat 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs.), test and validate the model
• Developed the Dimensions andTime Series Objectsin the Business Model and Mapping Layer with Security settings usingLDAPAuthenticationto setup groups, access and query privileges
• Customized the Oracle Business Intelligence Presentation Services interface.
• Interacted with Client Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Created Data Model Design andDocumentation(Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts).
• Set up Usage tracking and Scheduler in OBIEE.
• Created Database Report Layouts UsingBI PublisherDesktop (Template Builder) in MS Word.
• Integrating OBIEE and BI Publisher and Scheduling BI Publisher reports and Created BI publisher reports based on various data sources.
• Developed different levels of Security set-up are for the entities of the application (on both Repository file and Web catalog file).
• Developed andDebuggedInteractive Dashboards and Reports relating to Customer Feedback Analytics, with different Analytic Views (Guided Navigation, Pivot Table, Chart, View Selector, Column Selector, Filters, and Dashboard Prompts) using Presentation Services.
• ImplementedObject Level Securityfor the objects like Dashboards and Reports, and Data Level Security for Region and Product dimensions, usingSession Variables.
• DevelopedPerformance TuningStrategies for optimizing the performance.
• Organized testing schedules and test scripts. Managed execution and sign-off tests and also played an active role in product rollouts.
• Planned and supported end-usertrainingsessions on the new product, prepared and managed operations run book for continued support.

Environment: OBIEE, Oracle 9i, Informatica 7.1, SQL server 2008

Confidential,Overland park, KSApr ’07 - Aug ‘08
Business Intelligence Consultant
Revenue & Sales Analysis (RSA)
Amdocs Limited is a provider of software and services for billing, customer relationship management (CRM), operations support systems (OSS). Sprint is its traditional client for telecommunications. The project involved in creating Business Intelligent Solutions for various work streams by comparing and contrasting data from various sources and then consolidating them at the Report/Dashboard levels. The reports are generated by various users to cater the needs of all levels of sales organization from sales representatives to executives.

Responsibilities

• Involved in Analysis,Requirementgathering, Functional/Technical Specifications, Development, Deploying and Testing.
• Installed and configuredOBIEE/Oracle Financial Analytics 7.9.5.
• Designed Physical Layer, Business Model, Mapping Layer and Presentation Layer in the repository after connecting to the database engine.
• Installed and configuredBI Publisherand integrated with OBIEE Servers.
• Identified Facts, Dimensions &Hierarchiesof the Business Model.
• Implemented various kinds of reports as per the clientrequirementsusing OBIEE Answers & Dashboards.
• Developed various kinds of Reports (Pivots, Charts & Tabular) using global and localfilters.
• Security management for users, groups andweb-groupsusing the various authentication systems such asLDAPauthentication using Session Variables, as well as Dashboard /Report-level security.
• Created groups in the repository and added users to the groups and grantedprivilegesexplicitly through group inheritance.
• ConfiguredIBotsto deliver Analytics content based on Schedule to obtain weekly reports and sent notifications Alerts.
• ImplementedCacheManagement techniques to improve the performance on both real time and non-real time reports.
• Implemented prompts to provide dynamic filter conditions to end users.
• Customized report look and feel using column formatting and conditional formatting.
• Tuned OBIEE Reports to improve theperformance.
• Created Session & Repositoryvariablesto achieve desired functionality.
• Imported physical tables from SQL Server 2008 and defined relations between physical tables at the physical layer.
• Created complex stored procedures in SQL Server 2008 to retrieve the data required to generate reports.
• Involved in developing the testing documents like estimates, test strategy, test plan, use cases, test cases, test scenarios and test data according to requirement specifications, experience in preparing test execution reports.
• Implemented triggers in order to enforce complicated business logic and integrity constraints and to enhance data security at database level.

Environment: OBIEE 10.1.3.4, BI Publisher, SQL Server 2008, T-SQL, TOAD, Windows XP/Server 2003, Informatica 8.6.

Confidential, Dallas, TXJul ’06 - Mar ‘07
Sr. Business Intelligence Consultant
Sales Distribution Analysis (SDA)
Access Pharmaceuticals is a specialty pharmaceutical company engaged in the research, development, sales and marketing of branded and generic prescription pharmaceuticals used primarily to treat and manage pain. The project deals in creating an enterprise data warehouse consisting of the sales, distribution and location subject areas as data marts. The sources being dealt are extracted from various databases and flat files. Database warehouse was built in order to provide standardized reporting process for the sales force data. Oracle BI platform solutions were implemented for providing dashboard access to strategic business information from the company wide data warehouse.

Responsibilities

• Participated in completelife cycleof the project from project initiation to development and maintenance.
• Customized the Siebel Anaytics/OBIEErepository (Physical Layer, BMM and Presentation Layer).
• Modified Presentation layer to add presentation tables and defined joins in the physical layer of the repository.
• Createdconnection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies,aggregates, and keys in the BMM layer.
• Used thesecuritysettings in OBIEE Admin tool to setup users, Groups and Access privileges.
• Created materialized views and aggregates to improveperformance.
• Customized reporting with OBIEE Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts andview selector.
• Created dashboards with global prompts,column selectors, navigation, and automatic drill-down.
• Created user level security for intelligence dashboards based on Business Requirement.
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Created Dashboards with Dashboardprompts, Charts, Pivot tables.
• PerformedData Validationof data in the reports and dashboards.
• CreatediBotsto send pre-processed reports using OBIEE Delivers.

Environment: Siebel Analytics 7.7/OBIEE, Oracle BI Application 7.9.4, Informatica 7.1.3, DAC, Oracle 9i, Toad, PL/SQL, Windows Server 2003/XP