SUMMARY:

• Extensive IT experience on analysis, design, development, customization and maintenance of various business applications in an effective way to deliver business solution.
• Expertise in OBIEE 10G/11G, Oracle BI Applications 7.9.6, Informatica 8.6.1/9.0.1, ODI and DAC 10.1.3.4.1.
• Responsibility includes involvement in gathering business requirements, analysis, design, data modeling, development, which include in designing ETL Process, building and configuring repository.
• Expertise in Building Metadata Repositories .rpd Building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool.
• Expertise with developing dynamic and interactive Dashboards with drill-down drill-across capabilities, and Web Catalog using Oracle Business Intelligence Tool.
• Development of Business Reports, Business Alerts with help of Oracle/Siebel Answers, Oracle/Siebel Delivers and Oracle iBots, Oracle BI Publisher to create reports from multiple data sources.
• Experience in using Noetix Views for Oracle E-Business Suite.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series Caching.
• Experience in Configuring Usage Tracking to keep track of Query Performance, Query Log and Report Usage.
• Experience in Configuring Multi User Environment MUDE on Shared environment to allow Development team to work as well as Merge 2-Way and 3-Way Merging.
• Experience in Configuring Cache Purging Cache Seeding for Report Performance using BI IBots and Event Pooling Table.
• Experience in Setting up Dynamic, System and Non-System Variables.
• Implemented Data Level and Object Level Security using External Table Authentication, as well as Presentation Services
• Familiar with database Performance Tuning by implementing materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and analyzing query execution using the Explain Plan.
• Experience in Data Warehousing development using ETL tools such as Informatica Power Center.
• Experience with Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer, MappletDesigner, Mapping Designer, Repository manager.
• Experience in developing Informatica Mappings / Mapplets and Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Experienced with designing ETL execution plan and scheduling task using DAC.
• Experienced in Pre-Build, Packaged Oracle Analytics including Financial Analytics, Human Resources Analytics, Order Management Analytics, Procurement and Spend Analytics.
• Experience in analyzing test plan data using reports and graphs generated in Quality Center.
• Active participation in Presentation of Project concept, status, plans and progress.
• Good at prioritizing along critical path, meeting project milestones and deliverable dates.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.

TECHNICAL SKILLS

• Methodologies : Dimensional Data Modeling Logical / Physical
• OBIEE Tools : OBIEE 11.X/10.X, OBIA 7.9.5/7.9.6/7.9.6.1/7.9.6.2 DAC.
• ETL Tool : Informatica 8.6.0/8.6.1/9.0.1, Informatica on Demand.
• OBI Apps Modules : Supply Chain, OM, Financial Sales Analytics.
• Databases : Oracle 8i/9i/10g/11g, MS SQL Server2000/2005/2008, DB2, Teradata
• Query Tools : SQL, PL/SQL, TOAD
• Languages : C/C , C , Java, Visual Basic, XML, HTML, ASP, JavaScript.
• Operating Systems : Windows 98/00/NT/XP, Redhat Linux, Windows 2000/2003, UNIX
• Other : Visio, MS Office, Adobe Acrobat.

PROFESSIONAL EXPERIENCE:

Confidential

OBIEE DEVELOPER

RESPONSIBILITIES:

• Understanding the existing application architecture, designing and identifying the reporting requirements and prepare the requirements specifications document. This involved interacting with the business users and understanding the requirements.
• Installation, Configuration of OBIEE and TOAD.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, and testing and project coordination.
• Analyzed reporting Investment Reporting requirements for dashboard reports.
• Custom built the repository RPD from the scratch with Facts like Position Summary Trade Date, Holdings Trade Date, Holdings Settle Date and 9 Dimensions and 4 confirmed Dimensions.
• Performed high level and detailed design of the star schema.
• Created Reports, Dashboard Pages like Book of Business Summary View, Expanded View, Exposure View, Targets View, Aggregates View, etc.
• Used Filters and provided customized prompts filtering options appropriately to avoid excessive data showing up reports.
• Worked on Navigator Portal with Share Point team. Complete responsible for Book of Business and Portfolio Management reports.
• Developed GO URL's for various Reports, Dashboard Pages and Dashboard in Report, PDF, PowerPoint and CSV formats.
• Implemented Security using WLS Admin Console, EM Fusion Middleware and Identity Manager.
• Involved in upgrading from OBIEE 10g to OBIEE 11g.
• Worked on Oracle Enterprise Manager to activate and Deploy RPD, Security, Capacity Management etc.., in OBI 11.1.1.6.
• Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• Responsible for migrating the web catalog and RPD from DEV, SIT, UAT and PROD environments.
• Complete responsible for preparing the END to END Document.
• Worked with the QA team Onsite on SIT and UAT issues.
• Supported PROD environment.
• Daily coordination with offshore OBIEE development team.
• Worked towards the knowledge transfer with support team for smooth transition.

ENVIRONMENT: OBIEE 10.1.3.4.1/11.1.1.6, OBIA, Oracle EBS, Informatica 8.6.1, DB2, TOAD, JIRA, Windows XP, UNIX, Share Point, Version 1, Navigator Portal.

Confidential

OBIEE DEVELOPER

RESPONSIBILITIES:

• Captured and documented Management information/BI requirements from clients, via workshops, ensuring suitable balance of business needs and delivery feasibility.
• Created Functional and Technical specifications.
• Involved in developing OBIEE RPD and Reports.
• Involved in UPGRADE of OBIEE 10g to 11.1.2 version and applied relevant Patches based on need.
• Worked closely with ODI team to understand and implement primary key, foreign key and composition key relationship among physical facts and dimension tables.
• Provided content filtering at BMM layer and used complex joins on logical data source LTS to join tables in BMM layer.
• Created and managed different functionalities of Siebel/OBIEE such as Oracle Answers combined reports, action link, Navigation link etc Catalog, Dashboard, Delivers iBots , briefing book etc
• Developed security matrix for enterprise users based on their role and provided role based security using variables.
• Automated cache purging process using iBots and configured cache management at various layer i.e. BI server, presentation server, browser etc. Configured Event Polling for clearing the stale cache.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day Repository, Scheduler iBots.
• Used OBIEE environmental and Multi-User development MUD migration process to check out projects, merge changes, publish changes to network, and create migration plan to move repository .rpd respective environments
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Region and Product dimensions, using Session Variables.
• Enhanced Query performance, by analyzing modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution
• Configured Oracle BI scheduler in an application server that manages and schedules defined jobs.
• Responsible for migrating the web catalog and RPD from DEV, SIT, UAT and PROD environments.
• Worked with the team and a DBA to communicate and negotiate data needs

ENVIRONMENT: OBIEE 10.1.3.4.1/11.1.2, OBIA7.9.6.1, Oracle EBS, ODI10g, Oracle 11g, SQL plus, PL/SQL, TOAD, DB2, Quality Center, Windows XP.

Confidential

OBIEE DEVELOPER

RESPONSIBILITIES:

• Studying the existing application architecture, designing and identifying the reporting requirements and prepare the requirements specifications document. This involved interacting with the business users and understanding the requirements.
• Performed Project Scoping, Project Organization and Management including Business IT Requirements, Priorities.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships Foreign Keys Physical Logical between tables
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Experience in BI Applications in development of rpd, data models and integrating with EBS, SFDC for development
• Created Facts like Opportunity, Project for Project Portfolio Subject Area.
• Created Metrics like Conversion rate, Amount in USD.
• Created Customized Dashboards like Pipeline, Project Portfolio catering to provide insight into the sales / marketing / financial data.
• Created different types of Customized Reports Drilldown, Aggregation, Levels to meet business requirements. Generated various Analytics Reports like Formulary Report, Union Report and Direct Sales Report using global and local filters.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Worked on OBIA on Supply Chain module in organizing data and implementing security.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes and managed day-to-day Repository, Scheduler iBots.
• Managing appropriate security privileges on subject areas Data Level and dashboards Object Level according to business requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Integrating and automating Informatica workflow loads using DAC.
• Created tasks and execution plans in DAC and scheduling the ETL run.
• Developed customized mappings, sessions and workflows for some of the Subject Areas, using the Informatica Power Center Designer, Power Center Workflow Manager.
• Created new reports in BI Publisher and made substantial modifications to existing reports, to meet new needs.
• Involved in unit testing, integration testing, Functional testing to analyze and fix the issues encountered.
• Performed end-user training to develop ad-hoc reports using OBIEE Answers.

ENVIRONMENT: OBIEE 10.1.3.4, OBIA 7.9.6, Oracle EBS, ODI 10g, Oracle 11g, SQL plus, PL/SQL, TOAD, DB2, Quality Center, Windows XP.

Confidential

OBIEE DEVELOPER

RESPONSIBILITIES:

• Installation, Configuration and Administration of Informatica Power Center Client , Server 8.6.0 ,Oracle 10g and OBIEE 10.1.3.4
• Understanding the existing application architecture, designing and identifying the reporting requirements and prepare the requirements specifications document. This involved interacting with the business users and understanding the requirements.
• Extracted data from various source systems like relational data bases, Flat files and data into the data warehouse using Informatica On Demand.
• Extensively used Informatica On Demand for replicating the data from Sales Force to local Database.
• Developed new Adapters using Informatica 8.6.1, complete end to end development against Salesforce.com source.
• Extensively worked in developing Salesforce Adapters for Sales and Opportunities.
• Worked on extracting the legacy data from the application.
• Created Facts like Opportunity Lineitem, Opportunity History, Sales, Budget, Goals and dimensions like Opportunity, PriceBookEntry, User, Region, Account,
• Created reusable transformations and mapplets and used them in mappings.
• Performed Execution plans in the DAC Console.
• Custom built the OBIEE repository RPD from the scratch with 4 Facts and 9 Dimensions and 4 conformed Dimensions.
• Created metrics like MTD Sales, QTD Sales, YTD Sales, MAGO Amount, QAGO Amount and MTD Expected Revenue, Opportunity Amount.
• Performed high level and detailed design of the star schema as well as the reporting metadata.
• Analyzed reporting requirements for dashboard reports.
• Created some Reports for analyzing the Trend in Opportunities, sales and Sales Reps Efficiency.
• Developed complex and rich Reports using pivots tables, charts, and view selector. Used global and local Filters for data abstraction.
• Developed various test scripts for business users for UAT and assisted them to use and understand the functionality of the tool.
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots.
• Developed process for object level migration of web catalog, for post production release of - enhanced and bug fixed reports
• Created different types of Customized Reports Drilldown, Aggregation, Levels to meet business requirements.
• Complete responsible for preparing the END to END Document.

ENVIRONMENT: OBIEE 10.1.3.4, Informatica 8.6.0, DAC 10.1.3.4, Informatica on Demand, Sales Force, Flat Files, Oracle10g, Windows XP, PL/SQL, TOAD.

Confidential

OBIEE DEVELOPER

RESPONSIBILITIES:

• Involved in gathering technical requirements and preparation of Requirement Specifications documents from various end users.
• Involved in design and development of repository Creating / Modifying objects in Physical, Business and Presentation layer and the process of repository migration.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Designed and built Oracle BI Analytics data model, customized Star and Snowflake schemas by extending Fact and Dimension tables.
• Created Dimensional Hierarchy, Logical columns, Aggregate columns, Level based Measures and Aggregate navigation in BMM layer.
• Involved in cleanup and tuning of repository to meet client requirement after study of pre-built BMM Subject Areas and pre-built Intelligence Dashboards.
• Multi-user Development Environment MUDE is implemented to facilitate parallel development.
• Developed Ad-hoc and Standard Reports/Dashboards with different Analytics Views using Oracle BI Presentation services.
• Created proactive agents iBots and interactive Dashboards to alert End users about business changes.
• Configured Row Level Security and Object level security to allow users to view their respective data only according to the requirement.
• Monitored and Scheduled ETL along with reducing application configuration and development time by using DAC.
• Installed and set up Informatica environment and responsible for administration and migration of repositories between various environments.
• Developed many complex Informatica mappings and Mapplets to build key interfaces using transformations reusable transformations Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator for loading the data into Data Warehouse.
• Performed Error handling strategies using various Mapplets to optimize the data.
• Implemented the session partitions, for Performance Tuning of Informatica Sessions and Complete ETL load time by running parallel sessions, re-arranging the session's dependencies etc.

ENVIRONMENT: Siebel Analytics 7.8.4/7.8.5, OBIEE 10.1.3.2, Oracle BI Applications 7.8.x/7.9.0, Informatica Power Center 7.1, SQL Developer, PL/SQL, SQL Plus, Oracle 10g, SQL Server 2000/2005, UNIX, Windows Server 2003, DAC.