SUMMARY

• Around 7+ years of experience in IT Industry with 6 years of experience in OBIEE/Siebel Analytics, Design and Implementation of Data Warehouse/Data Mart, System Analysis, Design and Data Modelling.
• Proficient in implementation and customization of Oracle Business Intelligence Enterprise Edition (OBIEE) packaged and non - packaged analytical applications.
• Strong experience in developing and customizing Reports and Forms using Oracle Reports 6i/4.5/2.5 Discoverer 10g/4i/3i and XML Publisher 5.6.3/5.6.2 .
• Experience with specific subject areas (Finance, HR, Marketing, Supply Chain, etc.).
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas.
• Well versed with OBIEE plus components like OBI server, Answers and Interactive Dashboards.
• Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects.
• Experience in creating Metadata Objects and Web Catalog Objects (Dashboards, Pages, iBots, Reports) using OBIEE Admin Tool and Siebel Analytics Web.
• Developed several Interactive Dashboards with drill-down capabilities using global & local Filters.
• Ensuring OBIEE Team’s adherence to Quality Norms and Conditions of Service Level Agreement with Client.
• Extensively worked on Business Intelligence and Data warehousing with Kimball and Inman Methodology.
• Implemented Siebel Analytics security at the data and object levels.
• Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
• Extensive Experience in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 9.x/8.x/7.x/ 6.x
• Very strong in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Good Experience in Performance Tuning of sources, targets, mappings and sessions.
• Good expertise in RICE (Reports, Interfaces, Conversions, Extensions) components.
• Experience in System Testing of Oracle Service modules (Service Contracts, Service RequestSales Order, Install base).
• Detailed knowledge in Data warehouse Application Console (DAC) and Informatica Servers.
• Designed Technical Documentation using AIM Methodologies (MD50, MD70, CV40 and CV70).
• Extensively worked on Shell scripts and used Bugster to track reporting errors.
• Experience in supporting the production system and handling day-to-day issues.
• Experienced in interacting with users, gathering requirements, and drawing up Business Case Scenarios to enable the testing of system setups.

TECHNICAL SKILLS

Oracle Applications: General Ledger, Accounts Receivables, Accounts Payables, Order Management, Inventory, Install Base, Fixed Assets, Cash ManagementPurchase Order, Advanced Pricing, Service Contracts, Purchasing, AOL, System Administrator.

Application Tools: Reports 6i/4i, Discoverer 10g/6i/4i, Forms 6i, Oracle 9iAS, XML Publisher 5.6.3/5.6.2 , Oracle Web Application Server 4.0.8, Oracle Enterprise Manager (2.1.0),OBIEE.

Databases & Tools: Oracle 10g/9i/8i/7.x, TOAD, SQL Navigator, SQL*PLUS, SQL* Loader,DB2

Scripting Languages: Unix Shell scripts, K shell, C shell.

Languages: SQL, PL/SQL, JAVA, XML, C, C++.

Operating System: Sun Solaris, Unix, Linux, Windows NT/XP/2000/98.

ETL Tools: Informatica 6.x/7.x/8.x/9.x.

PROFESSIONAL EXPERIENCE

Confidential, GA

OBIEE/ETL Consultant

Responsibilities:

• Involved in installation and configuration of OBIEE.
• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Performed gap analysis and feasibility study for the given requirement.
• Analyzed technical requirements and used metadata designing principles to design repository and followed best practices
• Identified Facts and Dimensions (with levels & hierarchy)
• Design and Developed repository (.rpd) that consists of physical layer, business model / layers with aggregates & dimensions, presentation layers with catalogs & folders and external table security with session variables using Oracle BI Analytics Administration tool.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Developed many Dashboards / Reports for providing analytical information using Oracle BI Answers and Dashboards.
• Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Designed and developed Performance Measurement Dashboards/Reports that are Dynamic & Interactive with drill-down, drill-across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.
• Used Time series Functions Ago,ToDate.
• Created iBots using Oracle BI Delivers to deliver reports to different devices across enterprise.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Security management for users, groups and web-groups using the various authentication systems (Database table, Dashboard / Report-level security).
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment..
• Setup Multiuser environment.
• Exclusively Involved in Unit Testing, Peer Testing & Regression Testing and managed defect resolution processed during the test phases of the new integrated implementation.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Worked on Informatica Designer tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer and Server Manager to create and monitor sessions and batches.
• Developed complex mappings and SCD type-I, Type-II mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex mapplets for reusable purposes.
• Created Materialized views in source database and used them as source in the mappings,to increase performance.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Designed and Developed Sessions and Workflows.
• Developed Workflows using Tasks like Email, Event wait, Command.
• Created and ran Sessions & Workflows to load the data into the Data warehouse.
• Generated Unix shell scripts for automating daily load processes.
• Scheduled and unscheduled workflows and used command tasks to automate the entire process of fetching the source file from a different path and FTP it onto the server.
• Extensively worked in the performance tuning of the ETL process and Migrated the mappings to the testing and production environment.
• Involved in writing test scripts, unit testing, system testing and documentation for ETL process.

Environment: OBIEE 10.1.3.4.1 , Informatica 9.x,ORACLE 10g,SQL * PLUS,TOAD,Unix,Ewin. .

Confidential, Tampa, FL

OBIEE/ETL Consultant

Responsibilities:

• Implemented Procurement and Spend 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.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Extensively worked on Shell Scripting.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• 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 LedgerDashboards in OBIEE.
• Designed and Developed Dashboard Pages Like Trends, Exceptions, Supplier Payables, Quality Performance, Delivery Performance and Price Performance in Supplier Performance Dashboard.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
• Designed and developed Delete Cancelled requisitions program to delete all the cancelled requisitions in iProcurement.
• Designed and Developed Custom Mappings in Informatica to bring the data from Legacy system.
• To implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• 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.
• Created several reports in AP (Account Payables) such as Preliminary pay register, Expense Invoice Register, Final Pay Register using BI/XML Publisher.
• Used Template, sub Template method for a creating single report with multiple Layouts.
• Used the Totals/Subtotals/group/sort features of XML/BI Publisher to make data intense operations happen at the template level.
• Developed and configured various reports in XML Publisher such as vendor listing, AP Invoices and Check Printing
• Created several reports in AP (Account Payables) such as Preliminary pay register, Expense Invoice Register, Final Pay Register using BI/XML Publisher
• Developed and configured various reports in BI Publisher such as vendor listing, AP Invoices and Check Printing
• Developed reports in GL like Bonus Accrual-Units, Bonus Accrual-Area Supervisor, Inter company transaction detail report, Hyperion Trial Balance using BI publisher
• 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.
• 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.
• Conducted training Sessions on Informatica power center.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.
• Involved in Unit Testing, System Integration Testing.

Environment: OBIEE 10.1.3.4, Oracle Applications R12, General Ledger, Account Payables, Accounts Receivable,Inventory, Order Management, Supply Chain(SCM), Service Contracts,Install Base,Oracle 9i (9.2.0),Informatica 8.x, XML/BI Publisher 5.6.3, BI apps7.9.6.2, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, Unix.

Confidential, GA

OBIEE Consultant

Responsibilities:

• Implemented Invoice level security in OBIEE depending on the user level access by integrating with EBS. Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services).
• Analyze,Design,and Develop OBIEE/Siebel Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Created Metadata repository - Physical layer, Business Model and Presentation Layer for contract activation report in Service Contracts
• Configured iBots in order to deliver the reports based on Schedule and automated iBot queries to deliver at scheduled timings.
• Responsible for the development of DAC tasks design and development which will call the Informatica workflows and updates the Image tables.
• Used various Transformations like Lookup, Expression, Filter, Joiner and for better data scrubbing and to cleansing and consistent data.
• Responsible for the development of DAC tasks design and development which will call the Informatica workflows and updates the Image tables.
• Performing tuning in Informatica Source and Target and Mapping and Target and Session level and oracle query tuning.
• Participated in Production Support and resolved problems that occurred during this phase.
• Developed repository and created logical columns, Hierarchies, Economical Source and Aggregate navigation in the Business model according to the requirements.
• Identified the granularity level of the data required to be available for analysis.
• Created hierarchy based Sales Card Dashboards and marketing dashboards (Buying segments, Purchase analysis) for different Business units and end users
• Developed Order and Invoice Revenue by Product dashboard in Procurement Analytics
• Developed Order Revenue Growth Over Previous Year dashboard in Procurement Analytics
• Developed Cumulative Order Revenue versus Last Quarter Dashboard in Procurement Analytics
• Created VPD security for reports in OBIEE.
• Developed many complex Initial/Incremental Informatica Objects (Workflows/Sessions,
• Mappings/mapplets with various transformations.
• Designed and developed logical model in BMM in Repository.
• Installed and Configured DAC.
• Created custom reports in Payables in OBIEE according to user requirement
• Modified the PO: Printed Purchase order report (printed) to meet the client’s requirement.
• Customized Standard Sales Order Acknowledgement Report using XML/BI Publisher.
• Customized existing Dunning report in Account Receivables using XML/BI Publisher.
• Converted Supplier Payment History Report in Account Payables from Report 6i to XML/BI Publisher.
• Developed OBIEE reports like Inventory details report, Price evaluation report and many other Inventory related reports.
• Implemented Financial Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).

Environment: OBIEE 10.1.3.4, Oracle Applications 11.5.10, General Ledger, Account Payables, Accounts Receivable,Inventory, Order Management, Supply Chain(SCM), Service Contracts,Install Base,Oracle 9i (9.2.0),Informatica 8.x, XML/BI Publisher 5.6.3, BI apps7.9.6.1, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, Unix.

Confidential, MA

Siebel Analytics Developer

Responsibilities:

• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Identified the granularity level of the data required to be available for analysis.
• Implemented comprehensive security functionality by creating users & web groups, external table security using session variables, test and validate the model using Siebel Analytics Server Admin tool and associating catalog objects and Web modules with the created users and groups.
• Developed Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data Model and Web Catalog Objects as per the data requirements using Siebel Analytics Admin and Web tool.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
• Designed the business model conforming to functional mapping, defined logical and complex joins for the dimension tables.
• Configured Sales and Distribution Facts using analytics and generated reports according to the business requirement.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives, provided optimized analytics request using column selector.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of Analytics that includes (.rpd, Dashboards, Security etc.).
• Generated queries and placed filters in Siebel Answers and created numerous executive level reports. ‘Dashboards’ were generated to provide insight into the sales/marketing/financial data.

Environment: Siebel Analytics 7.8, SQL, Data stage, Windows, SQL Plus.

Confidential, Wilmington, DE

Siebel Analytics Developer

Responsibilities:

• Primary responsibilities included gathering business requirements, designing functional and technical specifications for reporting needs Worked closely with the DBA and ETL Teams in designing the logical data model/physical data model (Star schema).
• Configured and created repository using Siebel Analytics Administration Tool.
• Created and administered the Physical Layer, Business Model,
• Created and administered the physical layer, Business Model and Mapping Layer and Presentation Layer in a Siebel Analytics Repository using Siebel Analytics Administration tool.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Worked with the Security manager in the Administration tool by creating users, User Groups and Hierarchies.
• Involved extensively in Siebel Answers, Siebel Delivers, and Siebel Intelligent Dashboards with Siebel Analytics Integrated implementation (Siebel Business Analytics Applications).
• Created Security settings in Siebel Analytics Administration Tool to set up groups, access privileges and query also managed security for groups in Siebel Answers.
• Used filters and provided customized prompts (filtering options) appropriately to avoid excessive data visibility in reports.
• Performed unit testing and supported end users during various test cycles.

Environment: Siebel Analytics 7.5, Informatica, Oracle 9i, SQL Query Analyzer, Windows.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Involved in Vendor Conversion from legacy system to Oracle System.
• Developed Payables Open Interface Import program to create payable invoices from invoice data in the Payables Open Interface Tables.
• Developed new AP Third Party Operations reports.
• Customized the AP Invoice History report as per client requirements using Report 6i.
• Involved in development and customization of Forms and Reports in Purchasing, Fixed Assets GL, PO, AP and AR modules as per the user requirements.
• Developed new Summary Info of Vendors report.
• Customized the Procurement Process as per business logic by adding new programs.
• Customized standard Sales Order Acknowledgement, Credit Exposure Report using Report 6i.
• As an Oracle Application Technical Consultant participated in building business areas, workbooks according to user requirements and also involved in creating adhoc reports using Discoverer.
• Created new concurrent programs using PL/SQL scripts.
• Involved in enabling Key and Descriptive flex fields and other relevant setups.

Environment: Oracle Applications 11i Account Payables, Account Receivables, Purchasing, Order Management, PL/SQL,TOAD, UNIX, SQL Plus, Discoverer 4i and Reports 6i.