SUMMARY

• Over Eight years of experience as an Oracle applications (E - Business Suite) consultant, technical developer with expertise in General Ledger, Account Payables, Accounts Receivables, Fixed Assets, Order Management, Inventory, Purchasing, Install Base, Service Contracts, System Administrator, and Cash Management.
• Extensive experience in Oracle Financials R12/11i (11.5.10/11.5.9/11.5.8/11.5.4 ).
• 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 , OBIEE.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux and Windows Environment.
• Expertise in developing OBIEE/Siebel Analytics Repository.
• OBIEE - Good experience in configuring DAC tasks and generating reports by using Answers and configuring and scheduling of iBots.
• Informatica - Expertise in Developing Mappings, Maplets, Workflows and Sessions using Informatica Power center.
• Good Experience in Performance Tuning of Informatica Mappings.
• Ensuring OBIEE Team’s adherence to Quality Norms and Conditions of Service Level Agreement with Client
• Extensive worked on Business Intelligence and Data warehousing with Kimball and Inman Methodology using OBIEE 10.1.3.x / Siebel Analytics 7.x and Informatica 8.x/7.x/6.x.
• Implemented 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.
• Good expertise in RICE (Reports, Interfaces, Conversions, Extensions) components.
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs, and worked on Interface/Conversions like GL Interface, Custom Invoice Interface.
• Strong Experience in Application Object Library.
• Experience in System Testing of Oracle Service modules (Service Contracts, Service RequestSales Order, Install base).
• Extensive Experience in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 7.x/ 6.x
• Detailed knowledge in Data warehouse Administration Console (DAC) and Informatica Servers.
• Extensively worked on Oracle Discoverer (Desktop, Administrator, Plus, Viewer), which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
• Designed Technical Documentation using AIM Methodologies (MD50, MD70, CV40 and CV70).
• Extensively worked on Shell scripts and used Bugster to track reporting errors.
• Expertise in creating, modifying, using and debugging Stored Procedures, Views, User Defined Functions using SQL Server/PL SQL.
• 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, SQL Server.

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, SSIS, DTS

PROFESSIONAL EXPERIENCE

Sr. OBIEE Consultant

Confidential, Lisle, IL

Responsibilities:

• Gather Information and Requirements for Financial Analytics (OBIA) and implemented.
• OBIEE Report Development includes RPD development and Dashboards Design.
• Worked on Oracle EBS systems.
• Security management for users, groups and web-groups using the various authentication systems (Database table, Dashboard / Report-level security).
• Developed many Dashboards / Reports for providing analytical information's using Oracle BI Answers and Dashboards. Created and used Oracle BI Delivers and IBots/Agents extensively.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Creating and maintaining the RPD.
• Deploying the RPD when new reports were created.
• Creating reports in Answers/Analysis and creating and managing dashboards
• Helping users to understand the reports, how to navigate the reports, and understand the report requirements.
• Sending daily BI Publisher emails to managers of different regions.
• Using OBIEE to pull data from Customized SQL Server Database.
• Tuning performance by increasing the number of connections in the RPD due to many users accessing the reports.
• Setting query limits for users so that they would not congest the system by accessing the reports at the same time causing performance issues.
• Database performance tuning and created indexes and cost based optimization.
• Data modeling after understanding the business requirement. Also, designed dimensional modeling for Data warehouse.

Environment: Oracle Applications R12, Accounts Receivable, Oracle 11g/10g/9i (9.2.0), OBIEE 10.1.3.4.1 / 11.1.1.6/ 11.1.1.7 , DAC 10.1.3.4.1 , XML/BI Publisher 5.6.3, SQL*PLUS, SQL*Loader, TOAD

Sr OBIEE Consultant

Confidential, Glendale CA

Responsibilities:

• Implemented Financials, Supply Chain and Procurement & Spend Analytics.
• Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Involved in installation and configuration of OBIEE, Informatica and DAC.
• Analyze, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Responsible for configuring the Source and lookup files.
• Custumizing the existing informatica repository and adding new mappings and workflows based on the requirements.
• Created Dimension hierarchies to achieve the drill down functionality.
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Designed and Developed Custom Mappings, Workflows and Registered in DAC.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse (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 snowflake 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.
• Designed and Developed Sessions and Workflows.
• Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
• Adding new Tables,Tasks and rebuilding the subject areas in DAC based on the changes done to the informatica repository.
• Configuring the Anlaytics repository(RPD) and implementing the security to authenticate and authorize Oracle EBS users.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & iBots.

Environment: Oracle Applications R12, General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Oracle Purchasing, Oracle 10g/9i (9.2.0), OBIEE 10.1.3.4.1 , Informatica 8.6.1, DAC 10.1.3.4.1 , XML/BI Publisher 5.6.3, Discoverer 10g, Repots10g, SQL*PLUS, SQL*Loader, TOAD, Unix

Sr OBIEE Consultant

Confidential, Milwaukee, WI

Responsibilities:

• Was involved in the installing and configuring of Financial and Supply Chain Analytics Analytics.
• 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.
• Responsible for customizing the out of box reports and creating new reports and dashboards.
• Developed Reports/Dashboards by implementing different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).Created Environment Variable on Unix/Linux Environment.
• 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.
• 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.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• 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.
• 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.
• 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 Dashboards 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.
• 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 and OBIEE.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.

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

Sr OBIEE Consultant

Confidential, LA,CA

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, and 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: 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, XML/BI Publisher 5.6.3, OBIEE, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, Unix.

Sr OBIEE Consultant

Confidential, CT

Responsibilities:

• Worked with business users to gather business requirements and provided reports in Financial, manufacturing and Supply Chain modules.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Implemented Financial Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables.
• Created AD hoc reports in Account Payables.
• Developed Dashboard pages like Budget Vs Actual, Finance Structure, Cash Flow and Asset Usage in General Ledger Dashboard.
• Developed Dashboard pages like Overview, Effectiveness, Invoice Details and Payment Performance in Receivables Dashboard.
• Developed Dashboard pages like Overview, Payments Due, Effectiveness and All AP Transactions in Payables Dashboard.
• Created Dashboard prompts and advance filter criteria.
• Created reports in Answers and embedded them in Dashboards according to the requirements.
• As part of the installation team installed OBIEE BI Apps.
• Configured and validated OOTB Profitability and Payables Analytics.
• Designed and developed custom Dashboards.
• Designed and developed Customer Interface, Auto Lockbox Interface.
• Extensively Modified Shipping INBOUND/OUTBOUND interface programs to accommodate changes in business process.
• Designed Customer Products Summary Report in Install base using OBIEE.
• Created and ran Sessions & Workflows using Informatica Workflow manager to load the data into the Data warehouse.
• Worked on Service Contract interface program by using the standard API’s.
• Generated Inter Company Transaction Detail Report, Open-Debit Memo Report in General Ledger using Reports 6i.
• Customized Supplier Payment History Report in Account Payables to meet client requirements.
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG’s.

Environment: Oracle Applications 11i (11.5.10), General Ledger, Accounts Payables, Account Receivables, Order Management, Supply Chain(SCM),Service Contracts, Install Base, BOM,WIP, Inventory, Oracle 9i, Discoverer 10g,OBIEE,Informatica, Windows 2000/NT, SQL*Plus, TOAD, Reports 6i, Kintana, UNIX

Oracle Apps Techno-Functional Consultant

Confidential

Responsibilities:

• Design, Development, Implementation and Technical support of complex business custom extensions for Oracle Financial, Manufacturing modules. Designed and recommended solution for custom processes flow integrated with standard applications.
• Provided customer support for Oracle standard and custom built Applications.
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface Program.
• Involved in Customization of Cancelled Orders Report, Orders Summary Report.
• Involved in Open Sales Order conversion based on client specifications.
• Used TCA API's for creating Parties, Party Accounts, Contacts, and Account Sites.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns.
• Migrated Business Areas/Item Classes/Hierarchies from one Instance to the other.
• Involved in Unit Testing and Performance Testing for reports.
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents.
• Performed unit, system, integration testing with reference to interfaces to non-oracle applications
• Created and have setup Resources using public packages.
• Responsible for techno design documentation of the reports.

Environment: Oracle Apps 11i, Siebel Analytics 7.8.4, General Ledger, Order Management, Informatica 7, Inventory, Accounts Receivables, System Administrator, Supply Chain(SCM), Oracle 8i, Reports 6i, Discoverer 4i, SQL, PL/SQL, SQL*Loader, Sun Solaris OS 2.8, Unix Shell scripting, PVCS

Oracle Developer

Confidential

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects likeProcedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server 2000.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist withcoding,designandperformance tuning.
• Managed user access. Created and managed new security accounts.
• Backupandrestoredatabases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created theDTSPackagethroughETLProcess to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics info for both the old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2000, T-SQL, DTS Designer, MS-Office, Ms-Excel, VSS