SUMMARY:

• Around 10 years of experience asOracle Business Intelligence Developer(OBIEE 11g/10g and BI Publisher) with successful track record in gathering user requirements, designing, developing and supporting different Business Applications, Oracle Applications R12/11i (E - Business Suite) Consultant, Technical Developer with expertise in Oracle Manufacturing Modules (OM, INV, PO, WSH), Financials modules (GL, AP, AR) and System Administrator.
• Extensive experience in providing clients the products and services needed to facilitate business process optimization and corporate vision fulfillment by maintaining a strong aptitude to lead, learn and teach has enabled me to continuously deliver high complex business and technology solutions that drive opportunity, profit and growth.
• Experienced gathering requirements, Proof of concept, gap analysis, design, development, Testing and Implementation of the OBIEE/ETL/Data Warehouse project.
• Over 3+ years of experience in Information Technology designing, developing, architecture, administration and implementation ofBusiness Intelligence,Data Warehouse Applicationsunder different environments. Core focus onData WarehousingandETLtoolsOBIA 7.9.6/ 7.9.5 Financials, Procurement & Spend and Order Management Analytics.
• Experience inBusiness Intelligenceand Transactional applications, Design and Implementation ofData Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling.
• Experience in Data Architecture, Data Analysis providing Business Intelligence solutions using OBIA 7.9.6, 7.9.5 upgrades/Siebel Analytics, Informatica (Power Center/Power Mart) with strong business understanding knowledge of Consumer Sector, Financial and Telecommunication domains on VLDB (Very Large Database) environments.
• Strong experience in developing and customizingOBIEE,Reports and Forms using Oracle Reports 6i/4.5/2.5, BI Publisher 5.6.3/5.6.2.
• Experience in ETL on Data Warehouse applications, responsible for the Extraction,Transformation&Loadingof data from multiple sources into Data Warehouse using Informatica.
• Experience in Performance tuning of Informatica mappings and Data Warehouse loads and resolve any data inconsistencies across loads.
• Experience in OBIEE such as Server Installations, Repository Configuration using Administration Tool across physical, semantic, presentation layers, Creation of Dashboards and Reports, iBots for Reports scheduling, Maintain Security Administration, Cache Management, and Metadata Migration to different environments.
• Development of Repository inMUDE( Multi User Development Environment)
• Expertise in Fit Gap analysis to gather, define and document Business requirements for both Data warehouse models and Business intelligence models.
• Experience in Data modeling to determine data definitions and establish referential integrity of the system.
• Experience in data warehousing such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification.
• Implemented complex Aggregation strategies forMetadata in semantic layer; Created reports in OBIEE Answers / Dashboard and trained the Business Users / Power Users to create reports in Analytics Answers and also led them into best practices in managing and sharing reports,
• Devised strategy for refreshing reports Query caching. Optimized database indexes and run statistics process for enhancing query performance.
• Implemented Data level security into Business Model that has both Position Based security and Geo based security for different user groups along with Object, Data level security
• Experienced in writing Performance & Tuning of Database
• Experienced in clustering of OBIEE environments using OBI cluster controller
• Experience in Installation, Configuration, and Development and Administration of Data Warehouse models for OBIEE Analytics.
• Installed and Configured DAC to manage ETL processes for OBIA Analytics.
• Created Custom Containers and ETL execution plans in DAC.
• Adept at development and customization ofRICE(Reports,Interfaces,Conversions, andExtensions) objects.
• Excellent Analytical, problem solving and communication skills with the ability to be an effective team member and the capability to work under severe time constraints.

TECHNICAL SKILLS:

Reporting Tools: OBIEE (11.1.1.7.x, 11.1.1.6.x, 11.1.1.5.x, 10.1.3.x),Siebel Analytics 7.x,Oracle BI apps 7.9.5

ETL Tools: Informatica(Power Center 9.x, 8.x, 7.x), Power Mart, DAC (10.x, 7.x)

Languages: SQL, PL/SQL, UNIXShell Scripting, C, C++

Operating Systems: Windows 2000/NT/XP/7, Windows Server 2008, UNIX, Linux

Web technologies: HTML, JavaScript, XML.

Tools: Toad, SQL*plus,SQL Developer

RDBMS: Oracle 11g/10g/9i/8i,EXADATA MS Access, MS SQL Server

Functional Skills: Business Analysis Requirement analysis, business rules, data flow diagramMethodologies:- Conceptual Modeling, RUP, OOP, OOD, OOAD, Agile, SDLC, Kanban, Jira

Modeling Tools: - MS Visio, Visual Paradigm, Rational Rose, Toad modelerOperating Systems:- Windows 95/98/2000/Me/NT/XP, Sun Solaris, UNIX

Testing Tools: - Load runner, Win runner, Mercury Test director Flowcharts, business process model, gap analysis, cost benefit analysis, decision tree, BRD, FRDWaterfall model, Spiral model, Use Cases, JAD, CMM, Erwin 4.0

PROFESSIONAL EXPERIENCE:

Confidential, PA

Lead OBIEE Developer

Responsibilities:

• Installed configuredandupgradedOBIEE from 10.1.3.4.1 to11.1.1.6.x to11.1.1.7.xin Dev, QA & Production environments
• ConfiguredMicrosoft Active Directory Ldapsecurity setup as primary security authentication in Weblogic Console.
• Migrated RPD,CatalogfromDevelopment to QAand fromQA toProductionEnvironments.
• Used OBIEE new views such as (Trellis, Trend, and Waterfall) for data visualization.
• Createdconditional - chained agentsto deliver business users based ofreal-time datathat is loaded every 15 minutes.
• Created Reports fromtwo different subject areasandadded drill downfunctionality using HTML GO Url script
• CreatedReal-time customercall volume reports to handle betterIVR(Interactive Voice Recording)
• Designed theLogical Table Sourcefor the Logical tables in the Business Model Layer to support the structure of the RPD for generating the desired reports.
• DevelopedTime Series objectsfor comparing the usage variations between the current and previous years and months.
• Configured measures in theBusiness Model Layerand mapped tomultiple logical sourcetables such as Essbase and SQL server Oracle DB.
• CreatedHierarchies,Levels,and implementedBusiness Logicby creatinglevel based measuresin OBIEE business model & mapping layer
• Implementeddata level securityby creating application roles in RPD by passing Business layer and presentation layer filters.
• Analytics ApplicationResponse-time Performance managementusing optimization efforts such asaggregatenavigation,indexes.
• Used manyRepository,Session and Presentation Variablesto obtain the user requirements and generate the reports.
• Developed variousAnalytical and OperationalOBIEEReports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets,Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Presentation Services.
• Performed Unit, Integration, and Regressiontestingto validate report and mapping functionality.
• Remediating the generated reports according to the feedback received from the end-users and FDIC to populate the data records in case of change in requirements.
• Generating the results in Toad by using the SQL generated behind the report in order to determine the behavior of the generated report in OBIEE.
• Extensive use of theMUDEEnvironment for making online changes in the RPD in parallel with the Development team using the Check in Checkout and Merge functions.

Environment: OBIEE 11.1.1.7.1/11.1.1.6.8/ 11.1.1.5/ 10.1.3.4.1 , Oracle 11g, RedHat Linux 5.x, Windows Server 2008, Toad Client, Informatica Power Center 9.x, File Zilla, Putty .

Confidential, CA

Sr. OBIEE Developer

Responsibilities:

• Interacted with the business representatives for gathering the Reports / Dashboards requirements and to definebusiness requirementsand functional specifications of the FDIC.
• Analysis of the requirements for generating the reports using the Data Model of tables and columns in the database.
• Identified the required Facts, Dimensions, Levels / Hierarchies of Dimensional and referential joins.
• Designed the Table relationships to support the reports to be generated.
• Designed and developed the OBIEE/ Metadata Repository (.rpd) using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-DownHierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Performance Tuning ofDashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc.,
• Extensive use of variousFilterson almost all the reports to display only the required data records on the reports.
• Responsible for setting up theframework architecturefrom front end perspective from high level to detail level reporting that include page/dashboard prompts, local/shared filters etc.
• Worked on Siebel Answers to buildOBIEEInteractive Dashboards with drill-down anddrill throughcapabilities.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• ConfigurediBotsto deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Analytics Application Response-timePerformancemanagement using optimization efforts such asaggregate navigation, indexes andCachemanagement.
• Debugged reports and OBIEE Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Used the BI Publisher for meeting the criteria of requirements that were not implemented using the Pivot Table view in OBIEE.

Environment: PeopleSoft 9.1 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing,Fixed Assets, OBIEE 11.1.1.5/ 10.1.3.4.1 , Oracle BI Apps 7.9.6.1, Informatica Power Center 8.6.1, Oracle 11g, PL/SQL, DAC 10.1.3.4.1 , Toad, Linux, File-Zilla.

Confidential, NJ

Sr. OBIEE Solution Consultant/Business Analyst

Responsibilities:

• Collected the business requirements based uponproject scopeandRUP methodology
• Conducted1-to-1 interviews and user meetingswith key users to collect requirement and business process information.
• HeldJADsessions with the system users, management and the development team.
• Performed extensiveRequirement AnalysisincludingData Analysis and Gap Analysis
• Organized and documented business requirements usingRational Requisite Pro.
• Developed and implemented processes and tools forrequirements gathering and analysis,by UML modelingusingRational Rose
• Deviseddiagrams and flowsto illustrate steps and describe logical operational steps of the system, by utilizing analysis tools such as data flow diagram, process models and data models Using MS VISIO
• Setting up OBIEE 10.1.3.4.1 in Development, Testing & Production.
• Implemented Security by creating roles & web groups, checks with External tables and LDAP to set object level and row level security based on roles and responsibilities.
• Participated in gathering and analyzing the Business Requirements in collaboration with the Sales, Marketing and Finance Subject Matter Experts (SMEs), Business Analysts and Users.
• Performed the detailed design of Reports / Dashboards using OBIEE Answers and Webcat, Analytical Data Model (Metadata / .rpd) and performed Fit / Gap Analysis
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Enabled Multiuser (MUDE) for development users to work on the same subject area in the rpd
• Configured and Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribe users.
• Created Presentation Variables for prompts to filter results based on user logins and user selection.
• Involved in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Implemented Usage tracking reports which read statistics from the usage tracking database. These reports helped identify performance bottlenecks for further tuning.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Wealth Management Queries (Reports, Dashboards, Security and Star schema).
• Responsible to analyze, create and maintain 2 Dashboards, 20+ reports
• Gathered and documented Business Requirements from Business Users.
• Developed 2 Dashboards / 18+ Reports using different Views (Pivot Table, Chart and Column Selector), with drill-down and drill across capabilities, guided navigation and dashboard and page prompts.
• Performance Tuning using optimization efforts such as re-organizing the data, aggregate navigation, Cache Management, indexes, Oracle materialized views and reports changes.
• Worked with ETL Team for enhancement to Facts / Dimensions in developing the Initial and Incremental ETL process.
• Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Table execution path by making use of hints, Creation / Re-building of Indexes and managing Cache etc.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.

Environment: Oracle Business Intelligence suite 10.1.3.4.1 , Informatica 8.x, Oracle11g, Toad 9.7,UNIX, Putty, File- Zilla, Windows XP,UML, RUP, Requisite Pro, Microsoft Suite (Access, Excel, Word, PowerPoint, Visio, MS Project)

Confidential, Ohio

OBIEE Developer/Business Analyst

Responsibilities:

• Gathered requirements, interacting with users and created requirement specification artifact.
• Involved in developing techniques for requirement gathering including interviews, brainstorms and meetings with stakeholders.
• Organizedworkshops with Subject Matter Expertsto obtain domain level information.
• Developed a vision document that defined the primary goals and objectives of the project.
• Created Business Object,ERD, DFD ModelsandUse-Case ModelsusingRational Roseto depict Actors and Use-Cases in various Business Processes.
• Implemented an integrated RUP solution with complete line of trace ability for all the artifacts of web development projects.
• Prepared Business Process Models that included modeling of all the activities of the business from the conceptual to procedural level.
• Designed and developed Quality Assurance standard and processes to all levels of project team.
• Proven ability to strategically plan, lead, inspire and mentor project team.
• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Siebel/Oracle Business Intelligence (OBI) Analytics platform.
• Performed the detailed design of Reports/Dashboards and Analytical Data Model (Metadata/.rpd).
• Participated in the installation and configuration of Oracle BI EE 10.1.3.3.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository.
• Created the High Level Design Document (HLD) and Technical detailed design document (TDD) of Repository and Webcat (reports/dashboards).
• Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc,...
• Implemented Security by creating roles & web groups, External tables and LDAP.
• Worked on iBots using Delivers to create Alerts based on results.
• Developed many delta / incremental complex Informatics ETL process and Oracle Packages i.e., Mappings & Mapplets using various Transformations.
• Performance Tuning of Informatics Sessions and Complete ETL load time by implementing the session partitions, sql-overdrive, running parallel sessions, re-arranging the session’s dependencies etc.
• Developed many Oracle PL/SQL Packages for performing the data reconciliation / sanity check between Operational Data Store (ODS) and Burgundy Data Warehouse.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.3, Siebel Analytics 7.8.4, Oracle 10g,Teradata,Informatica PowerCenter8.7, Toad, Win XP, UNIX

Confidential, NJ

Siebel Analytics Solution Design Engineer / Business System Specialist

Responsibilities:

• Participated in the Business requirements gathering meetings with the end users/business people.
• Enforce data quality measures and data elements naming standards at the time of validating logical data model components
• Installation and Requirement Gathering & Analysis
• Experience in Conceptual, Logical and Physical Modeling
• Extensive experience in designing dimensional models such as Star Schemas
• Involved in Siebel Analytics gap analysis related to SRMW Data Model and ETL, creation of detailed design documentation, accurately mapping requirements into Siebel Analytics functionality
• Responsible for preparing the Technical Design document keeping in view the end user requirements.
• Involved in Usage tracking and scheduler implementation
• Involved in Data level and object level security model in OBI presentation catalog to view there report according to the user level/position and permission
• Responsible for creating custom columns in the BMM layer to calculate the percentage changes in the sales.
• Created various Ad-hoc reports for day-to-day business requirements making use of global and shared filters with different views in accordance with the requirements
• Created sales reports to compare Current cycle and previous cycle sales using Pivot table views.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
• Generated I Bots using the Delivers to send notifications to the users.
• Used Mercury Quality center for Unit testing to validate the functionality of the dashboards/reports

Environment: OBIEE 10.1.3.X, Oracle 10g, DAC, Informatica PowerCenter 7.x, Microsoft Windows Server 2003 and XP.

Confidential

Siebel Analytics /OBIEE Developer

Responsibilities:

• Designed the application by gathering the requirements from Business Users and Subject Matter Experts, reviewing the Functional Design Document and Creating the Technical Design Document
• Involved in Installation of OBIEE on AIX and Windows environment and also configured BI Server
• Developed The OBIEE Metadata Repository Model that involve creating the Physical, Logical (BMM) and Presentation Layer
• Created hierarchies, variables, time series objects, joins, aggregate navigation and event poll strategies in the repository
• Enhanced Performance by creating Dimension Hierarchy sources for each level of aggregates and also by identifying aggregate levels for measures
• Created various Dashboards based on the subject areas that were used for managerial decisions and created various Reports in multiple views (Pivot Table, Charts, Tabular, View Selector), configured Global Filters and Prompts. Configured implicit fact columns, Bridge & Helper tables
• Performed Performance Tuning of Dashboards / Reports by implementing strategies like aggregate navigation, cache management, materialized views
• Implemented Security (Object Level, Data Level, and Column Level) by setting up users, groups, access privileges and query privileges and also, implemented row-wise Initialization
• Administered NQSConfig.ini and Instanceconfig.xml configuration files
• Used BI Server as data source for loading data into custom tables and integrated them using ODI and JDBC driver of BI Server
• Worked with other developers on a repository in a MUDE environment
• Configured iBots to deliver Analytics content and automated iBot queries for daily and weekly reports