SUMMARY

• Over Seven years of IT experience as a Technical consultant. Over Four years of experience in all phases of design, development, and implementation of Business Intelligence applications and my areas of expertise include BI application, Business Analysis, Repository (RPD) and implementing Business Intelligence reporting solutions using Oracle BIEE 11.1.1.x/ 10.1.3.3/10.1.3.2 and BI Apps 7.9.6/ 7.9.5.
• Over 3 years of Oracle Applications consultant, technical developer with expertise in Account Payables, Accounts Receivables, Order Management, Inventory, Purchasing and HR.
• Good knowledge in design and development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications.
• Good understanding of Forms 6i/9i/10g, Oracle Reports 10g/9i/6i, XML/BI publisher 5.6.2, Discoverer 10g/4i.
• Worked with Business Analysts/partners/Users to identify information needs and business requirements for reports and finalizing Requirement Specifications, Design Specifications, Traceability Matrices, Risk Analysis, Integration testing.
• Good knowledge in Oracle Financials, Manufacturing (11.5.10/11.5.9/11.5.8/11.5.4 ).
• Extensively worked on reporting tools i.e on Oracle Reports, Discoverer, BI Publisher and OBIEE.
• In - Depth knowledge of the Apps data model, which helps in all aspects of development cycle such as building Custom reports, data validation, data import etc.
• Designed and developed interfaces using Oracle open interfaces and Oracle Public API’s.
• Experience in System Testing of Oracle Service modules (Service Contracts, Service RequestSales Order, Install base).
• Experienced in interacting with users, gathering requirements, and drawing up Business Case Scenarios to enable the testing of system setups.
• Proven ability to quickly learn and apply new technologies with strong technical background.
• Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS

Oracle Applications: Accounts Receivables, Accounts Payables, Order Management, Inventory, Install Base, Fixed Assets, Advanced Pricing, Property Manager, HR, Payroll,Service Contracts, Purchasing, System Administrator.

Application Tools: Oracle Reports6i/4.5/2.5, Discoverer 10g/6i/4i., XML publisher 5.6.3/5.6.2 SQL Navigator, TOAD, SQL*PLUS, Export, ImportOracle Forms 6i/4.5, Workflow Builder.

Languages: SQL, PL/SQL, Web PL/SQL, C, C++, C#, Java, HTML, XML.

Operating Systems: Windows NT/XP/2000/98, MS-DOS

RDBMS: Oracle 10g/8i/9i/10g.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, IN

OBIEE Consultant

Responsibilities:

• Responsible to understand, articulate, document and present Reporting requirements (both business and technical).
• Interact with applications analysts and business users for requirements gathering and ensure no requirements are missed.
• 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.
• Responsible for OBIEE Repository development.
• Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Worked with Business to get the requirements and changing it in to Functional and Technical documents.
• Developed Ad-hoc and standard Reports/Dashboards with different Views within the OBIEE using Noetix views.
• Experienced in Design, Development and Implementation of Business Intelligence solutions using Oracle Business Intelligence, Noetix and Discoverer.
• Defined Connection Pools to the Source Database in the Physical Layer and created Logical Columns based on other Logical and Physical columns in Business Model & Mapping (BMM) layer.
• Experience in User training on OBIEE 11g.
• Involved in upgrade and testing of Operational reports and Dashboards from OBIEE 10g to 11g.
• Led a team of 6 in an onsite-offshore model.
• Performance testing of OBIEE 11g application using IBM Rational Performance Tester.
• Experience in coordinating with project various interfaceteams, admin and support teams.
• Built reports using Answers including drilldown objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
• Prepare detail design documents and assist the offshore team in doing the same.
• Resolved performance issues by running Explain Plan and TK Prof to improve performance.

Environment: Oracle Applications 11i/R12 (Accounts Receivable, BOM, WIP, Order Management & Inventory), OBIEE 11g/ 10.1.3.4.1 , OBIA 7.9.6, Noetix 6.0.1, XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, TOAD, IBM Rational Performance Tester.

Confidential, Evansville, IN

OBIEE Consultant

Responsibilities:

• Responsible for OBIEE Repository development.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Performed Repository (RPD) Testing and Validation before exposing Business Models in the Presentation Layer.
• Experience in migrating from Discoverer Reports to OBIEE Reports.
• Created new reports and customized existing reports using Discoverer.
• Created custom reports OBIEE according to user requirement.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views within the OBIEE.
• Designed, implemented and tested Security privileges on subject areas, dashboards and reports.
• Maintained effectiveness in creating the dashboards by appropriately including drilldowns. Setup the visibility of dashboards to employees with respect to their responsibilities.

Environment: Oracle Applications 11i, OBIEE 10.1.3.4.1 , XML/BI Publisher 5.6.3, Discoverer 10g, TOAD.

Confidential, Missouri

Oracle Apps Consultant

Responsibilities:

• Involved in customization of Matrix report based on depreciation projections by department and as per other business requirements in Fixed Assets.
• Developed the Billing Program for Contracts based on the Invoice Information.
• Involved in development and customization of Reports in Fixed Assets and HRMS modules as per the user requirements.
• Worked on fixed assets mass retirement process from 11i to R12.
• Worked on Payroll Action Extension Form using Forms 6i.
• Devloped Mass Termination Process and Batch Element Entry Process in HRMS.
• Involved in the support of Integration testing activities by fixing the defects/Enhancements.
• Involved in resolving defects that are raised in Interfaces.
• Devloped reports using XML/BI Publisher in HRMS.
• Creating technical specifications and test scripts for all customizations
• Extensively worked in developing and designing Documents (MD50), Technical Design Documents (MD70) using Application Implementation Methodology (AIM).

Environment: Oracle Applications 11i/R12 (Accounts Receivable, HR, Payroll, Fixed Assets), XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, TOAD.

Confidential, Atlanta

OBIEE Consultant

Responsibilities:

• 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.
• Responsible for OBIEE Repository development.
• 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), within the OBIEE suite.
• Involved in customizing out of the box reports to support the business requirements.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Migrated Analytics RPD and Webcat from one environment to another.
• Performed Repository (RPD) Testing and Validation before exposing Business Models in the Presentation Layer.
• Developed and worked on enhancements of Financial Dashboards.
• Involved in Production Support for all the components developed.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytic Views within the OBIEE.
• Involved in upgrade and testing of reports and Dashboards.
• Involved in the support of Integration testing activities by fixing the defects/Enhancements.

Environment: Oracle Applications 11i, XML/BI Publisher 5.6.3, OBIEE 10g,SQL*PLUS, TOAD.

Confidential, NC

Oracle Applications Consultant

Responsibilities:

• Involved in loading the invoice data in to Account Payables interface tables after validating the data in the staging table.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes.
• Customized the Open Purchase Orders Report and Purchase Order Distribution Detail report in Purchasing using XML/BI Publisher.
• Developed Summary Info of Vendors in Account Payables using Reports 6i.
• Used Template, sub Template method for a creating single report with multiple Layouts.
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG’s.
• Involved in interacting with the users to develop the reports.
• Involved in the upgrading process and involved in setup of EUL.
• Developed Over Due Vendor shipment report in oracle purchasing using XML/BI Publisher.
• Designed and Developed Checks Invoice Details report in Accounts Payables using Discoverer.
• Used the Totals/Subtotals/Group/Sort features of BI Publisher to make data intense operations happen at the template level.
• Involved in design of custom tables, views, multi-org views for the extensions functionality.
• Resolved open issues with the production system.

Environment: Oracle Applications 11i, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i.

Confidential, GA

Oracle Applications Technical Consultant

Responsibilities:

• Developed the PL/SQL validation program for the Vendor Interface process.
• Created Tax Report in Property Manager Using Discoverer.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context.
• Modified CUSTOM.PLL to activate zoom.
• Created Unbilled Report Using XML Publisher.
• Customized the Open Purchase report in Purchasing using Discoverer.
• Created Year End Employee Summary Report base on per all people f, per all assignments f and per all addresses tables using Discoverer.
• Customized the Purchase Order Distribution Detail report in Purchasing using XML/BI Publisher.
• Developed the Return to vendor report and Vendor performance report in purchasing using Reports 6i.
• Built Payroll reports such as Gross To Net (Deductions Report) and Employee.
• Involved in Production Support for all the components developed.
• Worked in solving critical issues on HR and Payroll reports like Organization Hierarchy and Headcount reports, Element and Payroll related reports etc.
• Defined auto invoicing rules, accounts for collections. Defined the statement cycle aging analysis definition for reporting.
• Exporting Business Areas, Folders, Work books, Item Classes and hierarchies from Development to Testing and then to production after validation.
• Coordinated with Oracle Support team for the raised Service Requests (SR’s), to get the issues resolved.

Environment: Oracle Applications (General Ledger, Accounts Payables, Accounts Receivables, Purchasing, Order Management, Inventory, Property Manager, Project Accounting, Service Contracts), Reports 6i, Discoverer 10g, XML Publisher.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Using the SQL * Loader viewed the errors in the log file and involved in rectifying the errors and then loaded the data into the interface tables.
• Developed customized Reports like Outstanding Invoices and Customer wise report for amount that is considered to be bad debt using Discoverer 4i.
• Developed the Physical Inventory Accuracy Analysis, item details and the Adjustments Report in Inventory using Discoverer 4i.
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents.

Environment: Oracle Applications, SQL*Loader, AIM Methodology, Windows NT, Discoverer 4i, Reports 4i.