Obiee Consultant Resume
Houston, TX
SUMMARY:
- Over 8 (Eight) years of professional experience as Technical ERP Developer/Consultant in Oracle E - Business Suite Applications with expertise in General ledger GL, Account Payables AP, Account Receivables AR, Order Management, Purchasing PO, and Inventory INV.
- Over 5 (Five) years of experience as OBIEE Technical Consultant.
- Extensively worked on Installation and configuration of Financials and Supply Chain Analytics. Experience in using Data Warehouse Administration Console (DAC) to schedule the Informatica jobs and metadata management.
- Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
- Expertise in design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modeling, Repository Management (RPD), Extraction Transformation and Load (ETL).
- Proficient within the Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration tool.
- Experience in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, OBIEE Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
- Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
- Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
- Extensively worked on BI Server, BI Answers, BI Dashboards and BI Delivers (iBots).
- Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
- Proficient in Oracle Tools and Utilities such as SQL Developer, SQL*Loader, SQL*Plus, Data Loader, TOAD and Confidential FILE.
- Experienced in Complete Software Development Life Cycle (SDLC) which includes System study, Analysis, Physical and Logical design, Resource Planning, Coding, Testing and implementing business applications.
- Involved in development of RICE components (Reports, Interfaces, Conversions, 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, Oracle Reports 11g/10g/9i/6i, Oracle Discoverer 10g/4i, XML Publisher 5.6.3/5.6.2 .
- Extensively worked on Oracle Discoverer, which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
- Designed Report Templates using XML/BI publisher.
- Strong Conceptual, Business, Analytical skills & highly motivated team player and ability to provide work estimates and meet deadlines.
TECHNICAL SKILLS:
Oracle Applications: General Ledger, Accounts Receivables, Accounts Payables, Order Management, Inventory, Purchase Order, Purchasing, AOL, System Administrator.
Application Tools: OBIEE 11g/10g,BI publisher 11g/10g/ XML Publisher 5.6.3/5.6.2 ,Reports 10g/6i/4i, Discoverer 10g/6i/4i, Forms 10g/6i, Oracle Enterprise Manager (2.1.0)
Databases & Tools: Oracle 11g/10g/9i/8i/7.x, TOAD, SQL Navigator, SQL*PLUS, SQL* Loader.
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: Informatica8.x/7.x/6.x
PROFESSIONAL EXPERIENCE:
Confidential, Houston, TX
OBIEE Consultant
Responsibilities:- Developing migration project plan and estimates, eliciting and managing requirements, and providing progress reports for all OBIEE migration projects
- Server space management for various log files, cache files, back up files etc.,
- Providing on-call production monitoring and support for critical Business Intelligence processes on a rotation basis.
- Creating, maintaining, and scheduling automation scripts, and maintaining responsibility for creating and updating system documentation
- Installed and Configured DAC.
- Implemented Financial Analytics, Supply chain and order management and Procurement and Spend Analytics, integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
- Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System (EBS) to staging system (SDE mappings) and to the target Analytics Warehouse (SIL mappings).
- Involved in installation and configuring of Financial, Order Management (Supply Chain) and procurement and Spend Analytics.
- Technical experience in installation and developed reports through User Interface of OBIEE 11.1.1.3.0 Suite.
- Created new and opened Answers for adhoc reporting to the End users.
- Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables and Profitability.
- Monitored the Memory and the File System Utilization on the servers.
- Developed the Audit balance sheets reports from OBIEE dashboards.
- Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.
- Did gap fit analysis to migrate reports from Discoverer to OBIEE.
- Developed the GL Daily Balanced report from OBIEE dashboards.
- Extensively worked on Shell Scripting.
- Used Template, sub Template method for a creating single report with multiple Layouts.
- Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level.
- Worked closely with Oracle Product Development team to resolves issues.
Environment: OBIEE 11.1.1.7.0 /10.1.3.4, OBIA/BI APPS 7.9.6.3/7.9.5 , Seibel Analytics, Oracle Applications R12/11i (GL, AP, AR, PA), (Financials, Order Management, HR Analytics, Procurement & Spend, Project Analytics), Discoverer 10g, Database 10g, TOAD, SQL*Plus, Informatica 9.0.1
Confidential, New Jersey
OBIEE LEAD
Responsibilities:- Tech Lead for BI Development, leading 3 developers.
- Closely worked with business in gathering the requirements and created a business model.
- Worked with BA in creating Business Requirements Document
- Worked with International business analyst and business users in creating the mockups dashboards/reports
- Worked with Data Architect on designing the dimensional model
- Involved in Building the RPD based on the requirements
- Involved in building reports and customization of dashboards based on the requirements.
- Integrated OBIEE with EBS for Single Sign On (SSO)
- Have developed custom mappings for a third data source and integrated it with the existing analytic warehouse.
- Setup of Multi User Development Environment (MUDE) in OBIEE.
- Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures and Security using External Table Authentication, Session Variables, and Initialization Blocks.
Environment: OBIEE 11.1.1.6.2 /10.1.3.4, OBIA/BI APPS 7.9.6.3/7.9.5 , Seibel Analytics, Oracle Applications R12/11i (GL, AP, AR, PA), (Financials, Order Management, HR Analytics, Procurement & Spend, Project Analytics), Discoverer 10g, Database 10g, TOAD, SQL*Plus, Informatica 9.0.1
Confidential, San Francisco, CA
OBIA LEAD
Responsibilities:- Complete end to end production support.
- Implemented Financials analytics.
- Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
- Installed, Configured and developed BI Apps Financials, Supply Chain, Procurement and Spend, HR modules.
- Onsite Lead for the ongoing support of the OBI Applications solutions.
- Analyzing and fixing issues in OBIEE (analytics, dashboards, and repository layers, alerts etc.)
- Analyzing and fixing issues in the ETL (ETL mappings, workflows, and DAC execution plans)
- Implemented best practices for architecture, ETL, and business intelligence tools.
- Implemented migration techniques for OBI Apps components into various test and production environments.
- Optimization of the OBIEE (analytics, dashboards, and repository layers, etc.)
- Optimization of the ETL mappings, workflows, and DAC execution plans.
- Optimization & maintenance of the Data Warehouse, implemented strategies for the fact tables and indexing.
- Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.
- Interacting with business users and other stakeholders, assessing business requirements and designing appropriate Data Warehouse solutions also enhancement to existing BI solution.
- Assist users with problems and resolves issues independently.
Environment: OBIEE 11.1.1.5, Oracle 11g/10g, TOAD, PL/SQL, Informatica 9/8.6.1,Oracle EBS R12
Confidential, Denver, CO
OBIEE / BI Consultant
Responsibilities:- Implemented OBIA for Procurement and Spend, Financials and HR
- Worked with metadata modeling using BIEE, various modules of OBI Applications against source systems including E-Business Suite, Siebel CRM, PeopleSoft HCM, and Essbase.
- Experienced full cycle implementing specialist of Oracle Datawarehouse, BI Applications and OBIEE reporting solutions at several clients.
- Provided technical direction and leadership in positioning, designing, engineering and delivering Oracle DW / BI solutions.
- Proposed road map for Oracle BI Application Analytics, Custom BI Analytics and OBIEE.
- Designed Oracle BIEE/Siebel Analytics CRM/EBS/Peoplesoft solutions on projects, three end to end Oracle BI project.
- Participated in Designing enterprise-wide Business Reporting and Data warehousing solutions.
- Integrated OBIEE with Essbase as a data source for Oracle BI Repository
- Drove requirements to work effort estimation, project planning and implementation
- Reviewed and validated business requirements and provided design specifications for the OBIEE solution.
- Drove requirements to work effort estimation, project planning and implementation
- Experienced in Out of the Box implementation Oracle BI Applications, implemented and deployed out-of-box OBIEE Analytics against Oracle EBS R11, R12 and PeopleSoftHCM 9.1
- Experienced in Extract, Transform, and Load (ETL) for prebuilt EBS Adaptors, full and incremental load to Oracle Business Analytics Warehouse (OBAW)
- Experienced in configuring ETL metadata, including Informatica Source Analyser, Designer, Mapplets, mappings, and workflows and DAC metadata.
- Experienced Informatica developing Source Objects and Target Objects including Source Dependent Extract (SDE) and Source Independent Load (SIL) mappings
- Performed preload configuration steps for BI Applications
- Use Data Warehouse Administration Console (DAC) to configure execution plans, manage, and run ETL routines to populate the OBAW and monitoring the results.
Environment: OBIEE 11.1.1.6.7 , EbsR1213, Toad, Informatica 9.1.0, DAC 10.1.3.4.1
Confidential, San Jose, CA
BI Lead/Analyst
Responsibilities:- Implemented end to end customized application for business.
- Gathered required information and was involved in data analysis.
- Maintained and designed complete documentations such as BRD (Business requirement document) issue trackers, training manuals for end users.
- Integrated multiple source system for single source of truth as Teradata.
- Implemented Financial, Procurement and Spend Analytics.
- Application designed involved in integration of Java ON Boarding screens with OBIEE along with right back functionality on application specific tables.
- Worked on incremental and full load of data through Data Warehouse Administration Console (DAC) and Informatica.
- Developed the Incremental ETL processes i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions/tasks for data extraction from E-Business suite.
- Design, development, and implementation of Business Intelligence applications including Business Analysis, Dimensional Modeling, Repository Management (RPD).
- Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
- Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
- Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
- Wrote Custom SQL Codes for the reports.
- 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. Implemented the single sign on (SSO).
- Involved in setting up AGENTS to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
- Implemented Security by authenticating against the LDAP and external table. Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
- Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
Environment: OBIEE 11.1.1.5, Oracle 11g/10g, TOAD, PL/SQL, Teradata, Informatica 9/8.6.1,Oracle EBS R12 (General Ledger GL, Account Payables AP, Account Receivables AR, Inventory INV, Purchasing PO.
Confidential, Boston, MA
OBIEE Consultant
Responsibilities:- Responsible for OBIEE 11g upgrade.
- Identified & Created Facts, Dimensions and Hierarchies of the business model and mapping layer.
- Developed Segment Value Detail, Work Order Detail and OGA Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
- Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool. Migrated Analytics RPD and Web catalog from one environment to another.
- Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
- Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc reports according to the client needs.
- Configured Interactive Dashboard with drill-down capabilities using Filters, Metadata Objects and Web Catalog Objects.
- Applied Cascading Prompts and Multi Level Prompts on Dashboards.
- Identified issues, performance bottlenecks and optimized the Business Intelligence Dashboards and Reports.
- Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
- Wrote Custom SQL Codes for the reports.
- Applied Optimization Techniques for the better performance of the reports.
- Involved in Monitoring and Scheduling different process flows using Oracle Work Flow Manager.
- Used external tables to Transform and Load data from Flat files into target tables.
- Used Debugger to validate Mappings by creating break points to analyze and monitor Data flow.
- Involved in troubleshooting the load failure cases, including database problems.
- Implemented Security by authenticating against the LDAP and external table.
- Trained End Users and Pilot Users about OBIEE Tools.
Environment: OBIEE 10.1.3.4.1 /11.1.1.5, Oracle BI APPS 7.9.6.2/7.9.6.3 , DAC, Informatica 9/8.6.1, XML publisher 5.6.3,BI Publisher 10.1.3.x/11g SQL*Loader, Oracle EBS 11i/R12 (General Ledger GL, Account Payables AP, Account Receivables AR, Inventory INV, Purchasing PO, Order Management OM),(HR Analytics), Oracle 11g/10g, TOAD, PL/SQL
Confidential, Schaumburg, IL
OBIEE Consultant/Analyst
Responsibilities:- Worked on complete Software Development Life Cycle (SDLC), from gathering requirements to deployment.
- Implemented Financial Analytics, Supply chain, Procurement and Spend Analytics. Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
- Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
- Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
- Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
- Monitored incremental and full load of data through Data Warehouse Administration Console (DAC) and Informatica.
- Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBots queries to obtain daily and weekly reports.
- Created hierarchies, complex and foreign joins, initialization blocks for repository or session variables, presentation variables in answers calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
- Granting access to users and maintain security by using database authentication and authorization.
- Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
- Designing the collections for AR Transactions, Claims, Disputes, Cash On Account, Credit Memo, Receipts at Risk information using Oracle BI.
- Designing the Month End Closing Mechanism for Accurate Finance Reporting of AR Credit using Oracle BI.
- Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC) and Informatica.
- Involved in developing the Incremental ETL processes i.e., Mappings &Mapplets using various Transformations and Workflows with Sessions/Tasks for data extraction from E-Business suite.
- Used Heterogeneous sources in Informatica like flat files and Oracle apps tables.
- Customized out of box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics, Procurement and Spend Analytics.
- Customized Dashboard pages like Overview, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
- Involved in complete Procure-to-pay (P2P) and Order-to-Cash (O2C) life cycle.
- Customized Supplier Paid Invoice History Report, Supplier Audit Report, and Supplier Payment History Report in Account Payables (AP) using OBIEE.
- Worked on tools like TKPROF and Explain Plan for tuning of PL/SQL queries for better database performance.
- Resolved open issues with production system.
- Gathered requirements from the client for GAP Analysis, translated them into technical design documents.
Environment: Oracle EBS R12 (General Ledger GL, Account Payables AP, Account Receivables AR, Inventory INV, Purchasing PO, Order Management OM), Oracle 10g, TOAD, PL/SQL, OBIEE 10.1.3.4.1 /11g, Oracle BI APPS 7.9.6, DAC, Informatica 8.6.1,XML publisher 5.6.3,BI Publisher 10.1.3.x/11g SQL*Loader.
Confidential, Atlanta GA
OBIEE Consultant
Responsibilities:- Identified & Created Facts, Dimensions and Hierarchies of the business model and mapping layer.
- Developed Segment Value Detail, Work Order Detail and OGA Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
- Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
- Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc reports according to the client needs.
- Configured Interactive Dashboard with drill-down capabilities using Filters, Metadata Objects and Web Catalog Objects.
- Applied Cascading Prompts and Multi Level Prompts on Dashboards.
- Identified issues, performance bottlenecks and optimized the Business Intelligence Dashboards and Reports.
- Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
- Wrote Custom SQL Codes for the reports.
- Applied Optimization Techniques for the better performance of the reports.
- Involved in Monitoring and Scheduling different process flows using Oracle Work Flow Manager.
- Used external tables to Transform and Load data from Flat files into target tables.
- Used Debugger to validate Mappings by creating break points to analyze and monitor data flow.
- Involved in troubleshooting the load failure cases, including database problems.
- Implemented Security by authenticating against the LDAP and external table.
- Trained End Users and Pilot Users about OBIEE Tools.
Environment: OBIEE 10.1.3.2, Oracle BI Applications 7.1.3, Informatica8.1.1, DAC, Oracle 10g, SQL Developer, SQL*Plus, BI Publisher 10.1.3.x, XML Publisher, Windows-XP.
Confidential, Phoenix AZ
OBIEE Consultant
Responsibilities:- Involved in translating high-level business requirements into logical business dimensional model.
- Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
- Mainly Worked on Oracle HR and Financial analytics.
- Imported Physical tables from Oracle database and defined relations between Physical tables at the Physical Layer.
- Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.
- Created highly formatted reports using BI Publisher based Data Templates form different data sources.
- Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
- Identified and created aggregate tables to improve query performance.
- Created Reports using different Analytics Views.
- Created Session & Repository Variables to achieve desired functionality.
- Created web-groups for security purpose with access privileges
- Extensively worked in fine-tuning of Informatica Mappings and OBIEE Repository and Dashboards.
- Created OBIEE Intelligent Dashboards & Answers.
- Created dimensions in the Business model & Mapping layer.
- Assigned Data level & UI level security to the Users.
- Customized Reports look and Feel using Column Formatting, Conditional formatting.
- Customized Dashboard reports using drill-down capabilities.
- Prepared the ETL Mapping spreadsheet and Fact Dimension Matrix simultaneously prior to performing the ETL process.
- Designed Intelligent Dashboards for different user groups to view updated KPIs.
- Extensively worked on Data Extraction from Databases and flat files by using Informatica
- Created reports of using BI Publisher through OBIEE
- Created and scheduled iBots as per the business requirements
- Created the source and target instances and various transformations (Joiner, Aggregate, Lookup, Filters and Router Transformations) in informatica and also created mappings, sessions and workflow to run ETL process using Informatica Power Center
Environment: OBIEE 10.1.3.2, Oracle BI Applications 7.1.3, Informatica8.1.1, DAC, Oracle 10g, SQL Developer, SQL*Plus, Windows-XP.
Confidential, Columbus OH
Oracle Apps/OBIEE Consultant
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.
Environment: Oracle Applications 11i (11.5.10), General Ledger, Accounts Payables, Account Receivables, Order Management, Supply Chain(SCM), Inventory, Oracle 9i, Discoverer 10g,OBIEE,Informatica, Windows 2000/NT, SQL*Plus, TOAD, Reports 6i, Kintana, UNIX
Confidential, Detroit, MI
Oracle Apps Consultant
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.
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
Confidential
Oracle Apps Consultant
Responsibilities:- Extensively Modified Shipping INBOUND/OUTBOUND interface programs to accommodate changes in business process.
- Analyze, Design and Developed CP/CR Analytical Metadata repository (.rpd) as per the data requirements that consists of physical layer, multiple business model / layers with dimensions & time series objects, presentation layers with presentation catalogs, LDAP security using variables etc..
- Designed Customer Products Summary Report in Install base using XML/BI publisher.
- 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 Apps 11i, Siebel Analytics 7.8, General Ledger, Account Payables, Account Receivables, Oracle 9i, XML Publisher 5.6.2, Reports 6i, Informatica 6,Discoverer 10g, SQL,PL/SQL, TOAD, Sun Solaris, Unix