Summary:

• Over Eight years of experience in Business Intelligence and Transactional applications, Design and Implementation of DataWarehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling.

• Over 4 years of experience in all phases of design, development, and implementation of Financials, Procurement and Spend (P2P), Order Management and Inventory (SCM) Analytics.

• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball Methodology.

• Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.

• Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on (SSO).

• Expertise in implementing Security Models for Dashboards, Row level, object Level, Role Level, Dashboard Level

• Experience in creating Aggregate tables using materialized views and using Aggregate Persistence wizard.

• Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.

• Expertise in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).

• Expertise in implementing Oracle BIApps in all phases like implementing Out of the Box prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided DataWarehouse ,OBIEE RPD development, OBIEE reports and Dashboards

• Expertise in DataWarehouse Administration Console (DAC) to configure, monitor and schedule ETL.

• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, DataWarehouse Administration Console (DAC), Informatica Power Center.

• Strong experience in developing and customizing Reports using OBIEE 10.1.3.4.1/10.1.3.4.0/10.1.3.3/10.1.3.2, Oracle Reports 6i/4.5/2.5 Discoverer 10g/4i/3i , XML Publisher 5.6.3/5.6.2.

• Extensively Worked on Informatica Power Center 8.x/7.x.

• Extensively Worked on Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, Aggregator.

• Involved in development of RICE objects (Reports, interfaces and data conversions, customizations, extensions) for the Oracle Applications E-Business Suite implementation across major modules.

• Experience in design, analysis, development, testing and implementation of applications in Oracle E-Business Suite using PL/SQL, Developer 2000, Oracle Reports 10g/9i/6i, Oracle Discoverer 10g/4i, XML Publisher 5.6.3/5.6.2.

Education & Certifications:

• B.Tech Computer Science, JNTU, HYD, India.

• Oracle Certified Associate(OCA)

Technical Skills:

Oracle Applications Oracle Financials E-Business suite R12/11i (Order Management, Inventory, Purchasing, General Ledger, Accounts Receivables, Accounts Payables, Fixed Assets, Cash Management, AOL, System Administrator).

Developer Tools OBIEE10.1.3.x, Siebel Analytics 7.5/7.7/7.8, Oracle Reports 10g/6i/4i, Oracle BI Apps 7.9.x Oracle Forms 10g/6i/4i, Discoverer 10g/6i/4i, XML Publisher 5.6.3/5.6.2, TOAD 9.7.3/8.x, SQL*PLUS, Data Loader, SQL*Loader, SQL Developer.

ETL Tool Informatica Power Center 8.1.1, 7.1, 6.2, 5.1,DAC 7.8.5v

Operating Systems Windows NT/XP/2000/98, UNIX, Linux

Languages SQL, PL/SQL, C, C++, C#, HTML, XML

RDBMS Oracle 10g/9i/8i, MS Access, SQL Server 7.x, 2000

WORK EXPERIENCE:

US STEEL, Pittsburg, PA April 2010 – Till Date

Role: Sr. OBIEE Consultant

Responsibilities:

• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the DataWarehouse.

• Implemented Financial, Procurement and Spend Analytics.

• Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).

• Worked with Business Groups to identify, analyze, and document Business Requirements.

• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.

• Designed and Developed Data model for core Fixed Asstes module.

• Designed and Developed Custom Mappings, Workflows and Registered in DAC.

• Created Star Schema and Custom Subject Area in OBIEE RPD for Fixed Assets module.

• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.

• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.

• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to DataWarehouse (OLAP) system.

• Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.

• Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.

• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool. Migrated Analytics RPD and Web catalog from one environment to another.

• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.

• Implemented the single sign on (SSO).

• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.

• Involved in setting up Ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.

• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.

• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.

• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.

• Created and Customized Dimension Hierarchies to achieve the drill down functionality as per Business Requirements.

• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.

• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.

• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.

• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.

• Imported and Exported Execution Plan in DAC from one Instance to other Instance.

• Involved in Integrating Oracle BI Presentation Services with BI Publisher.

• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflex Schemas.

• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.

• Involved in customizing out of the box reports to support the business requirements.

• Involved in configuring and customizing sources, targets, tasks and execution plans using DAC.

• Involved in Query Tuning to maximize the performance of reports and Dashboards.

Environment: Oracle Applications R12 General Ledger, Accounts Payables, Accounts Receivable ,Inventory, Purchasing, Fixed Assets, OBIEE 10.1.3.4.1, Oracle BI Apps 7.9.6.2, Informatica Power Center 8.6.1, Oracle 10g, DAC 10.1.3.4.1, Toad , Linux/Windows, File-Zilla., SQL Developer

CAMERON CORPORATE, Houston, TX Jun’09 – Mar 2010

Role: OBIEE Consultant

Responsibilities:

• Implemented Financial and Supply Chain Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).

• Gathered requirements from the client for GAP Analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.

• Extensively worked on SRs as per the client’s requirement to get the reports for the Business Analyzation.

• Integrated OBIEE with EBS for Single Sign On (SSO).

• Worked on integrating and configuring BI Publisher with OBIEE.

• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.

• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.

• Created Environment Variable on Unix/Linux Environment.

• Involved in development of Data mapping process, functional design, technical design, integration test, acceptance test and schedule creation of tasks and milestones.

• Worked on Map Gap Analysis for Financial/Procurement Analytics.

• Worked on SR’s with Oracle in solving issues.

• Used ETL processes to load data from Flat files, Oracle Databases into the target OLAP databases.

• Designed and Developed Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard.

• Designed and Developed Procurement and Spend and Supplier Performance, General Ledger, Payables, Receivables, Profitability, Dashboards in OBIEE.

• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.

• Designed and Developed Custom Mappings in Informatica to Load the Receivables Data from Legacy system.

• To implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.

• Extracted various sources like Oracle tables and imported Flat files using Informatica Power center.

• Extensively developed mappings on various business areas in the project by employing the available Transformations.

• Responsible for extracting Data from Oracle Apps Modules & loading into stage system and warehouse system.

• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.

• Customized Dashboard pages like Overview, AP Balance, Payments Due, Essectiveness, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.

• Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.

• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.

• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.

• Imported and Exported Execution Plan in DAC from one Instance to other Instance.

• Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.

• Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.

• Developed Custom Reports from OLTP without creating any Views or Tables in EBS Database in IProcurement, Payables and General ledger.

• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE.

• Created Dimension hierarchies to achieve the drill down functionality.

• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.

• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.

• Designed and Developed Sessions and Workflows.

• Conducted training Sessions on Informatica power center.

• Designed, implemented and tested security privileges on subject areas, dashboards and reports.

Environment: Oracle Applications 11i/R12 General Ledger, Account Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets, BI Apps 7.9.6, OBIEE 10.1.3.4.1/10.1.3.4/10.1..3.3/10.1..3.2, Informatica 8.6.0, DAC 10.1.3.4.1, XML/BI Publisher 5.6.3, ,SQL*PLUS, SQL*Loader, TOAD, Unix.

RICOH, NJ Aug’08 – May’09

Role: OBIEE Technical Consultant

Responsibilities:

• Customized Dashboard pages like Overview, AP Balance, Payments Due, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables in OBIEE.

• Customized OOB Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics.

• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses Out Of Box dashboard pages in Procurement and Spend Analytics.

• Customized Dashboard pages like AR Balance, Payments Due, Invoice Details and All AR Transactions in Receivables Dashboard.

• Involved in all major aspects of Oracle BIEE development. Oracle BI repository configuration, security administration, web catalog maintenance, Dashboard and report development, delivers, and cache management.

• Involved in Designing, building and testing of Analytics solutions.

• Repository configuration using OBIEE Analytics Administration Tool.

• Integrated OBIEE with EBS for Single Sign On (SSO).

• Setup Multi User Development Environment (MUDE) in OBIEE.

• Created new requests and opened Answers for adhoc reporting to the End users.

• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.

• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.

• Designed Schemas using Facts, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.

• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBots queries to obtain daily and weekly reports.

• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.

• Designed, implemented and tested security privileges on Dashboards and reports.

• Developed Customer Hierarchy to generate reports on the Region/Country/Time zone.

• Migrated web catalog by using Catalog Manager from one instance to another.

• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.

• Monitored Incremental and Full load Work Flows through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.

• Involved in Creating and registering Concurrent programs, Executables, SQL* loader scripts, Functions, Procedures, Reports using system administration responsibility.

• Imported and Exported Execution Plan in DAC from one Instance to other Instance.

• Developed RMA Detail Report in Order Management by using OBIEE.

• Customized Dashboard pages like Overview, Margins, Revenue, Products and Customers in Profitability Dashboard.

• Designed and Developed New Dashboard pages in General Ledger, Payables, Receivables, profitability, Procurement and spend and supplier performance Dashboards in OBIEE.

Environment: Oracle Applications R12 (Order Management, Inventory, Purchasing, General Ledger, Accounts Payables, Account Receivables), Oracle 10g, OBIEE 10.1.3.4.1, Informatica 8.6.1, XML Publisher, Discoverer 10g, Reports 10g, Windows 2000/NT, SQL*Plus, SQL*Loader, TOAD, PL/SQL, UNIX.

FedEx, Memphis, TN Mar’07 – Jul’08

Role: OBIEE Developer

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.

• OBIEE 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.

• Developed/Customized BI Dashboards, BI Answers, BI Delivers (I-Bots).

• Designed and Developed New Financial Dashboard pages in General Ledger, Payables and Receivables.

• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.

• Used various Transformations like Lookup, Expression, Filter, and Joiner for cleansing the inconsistent data.

• Optimized performance by tuning the Informatica ETL.

• Designed and developed various Dashboards that are Dynamic & Interactive with drill-down & drill-across capabilities with local & global filters.

• Developed executive level Forms and reports for Invoice details by customer, by item, by product type using Oracle Forms, Reports, and Business Objects.

• Modified several Customized Reports like Credit/Debit Memo Report, Invoice History, Invoice Aging, Prepayment Status, and Invoice on Hold Reports as per changing business needs.

• Designed and Developed AP Check Printing Report, Invoice Detail Report by Supplier, Payment Schedule Report by using XML/BI Publisher.

• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes by using XML/BI Publisher.

• Customized the standard AR Aging Report and Invoice History Report by using XML/BI Publisher.

• Created item classes, conditions and joins using Discoverer Administrator.

• Registered functions using Discoverer Administrator.

• Developed workbooks in various formats like tabular, page detail tabular, cross-tab and page detail cross-tab format using Discoverer Desktop and Plus.

• Developed Open interface to import orders from legacy system to apps.

Environment: Oracle Applications 11i (11.5.10) , Order Management, Inventory, Purchasing, General Ledger, Accounts Payables, Account Receivables, OBIEE 10.1.X, Informatica 7.x, XML/BI Publisher, Oracle 9i, Discoverer 10g, Financials Analytics , Windows 2000/NT, SQL*Plus, TOAD, Oracle Reports 6i, UNIX

Fisher Scientific, PA Nov’05 – Feb’07

Role: Siebel Analytics Developer

Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details.

• Involved in installation, configuration and administration of Siebel Analytics server/repository, Informatica server/repository, DAC client/server.

• Configured out-of-the box and custom Analytics/Dashboard reports using Siebel Answers.

• Involved in designing and development of building Physical Layer, Business model and presentation layer and report development.

• Designed and built Siebel Analytics data model, designed and customized Star and Snowflake schemas by extending Fact and Dimension tables.

• Improved ETL performance by removing unused batches, rearranging batches by dropping and recreating indexes and DAC enables parallel loading for high performance ETL.

• Developed data maintenance strategy which included proven data standard rules.

• Implemented Security by creating roles, web groups, external tables and LDAP.

• Developed delta/incremental complex Informatics ETL process and Oracle Packages i.e., Mappings and Mapplets using various transformations.

• Implemented the session partitions, for Performance Tuning of Informatica sessions by running parallel sessions and re-arranging the session’s dependencies.

• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.

• Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.

• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.

• Managed day-to-day Rpd, Siebel Delivers, Scheduler & iBots.

• Managed security privileges for each subject area and dashboards according to user requirements.

• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.

• Handled Full load and refresh load via staging tables in the ETL Layer.

• Involved in Design and Data Modeling using Star schema.

• Designed & assisted Informatica ETL developer to create new Aggregate.

• Created Informatica mappings for initial load and daily updates.

• Developed several mappings to load data from multiple sources to data warehouse.

• Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL and also performed Data conversions.

Environment: Informatica 7.1, PL/SQL, Oracle 8i/7i, MS Access, Windows 2000, UNIX Shell Scripting, Siebel Analytics 7.8/7.7.2, DAC, TOAD, PL/SQL.

KLR Rigs, Hyderabad, India Jun’03 – Sep’05

Role: Oracle Developer

Responsibilities:

• Gathered the requirement from the client and translated the business design into Technical design.

• Monitor performance and changing performance requirements through application of database tuning and performance optimization techniques.

• Triggers, procedures and functions are developed in this reports using PL/SQL.

• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.

• Prepared Mapping documents and design documents for data conversion.

• Developed validation procedures and error reporting on the data in the intermediate tables. Created user defined Exceptions while handling exceptions.

• Troubleshooting production problems and worked effectively with other team members to identify and address problem.

Environment: Oracle 8i, Reports 4i, Discoverer 4i, SQL * PLUS, SQL * Loader.

Contact this candidate