SUMMARY:

• Over Nine years of experience in OBIEE (Oracle Business Intelligence Enterprise Edition)/Siebel Analytics, Oracle BI Applications and Oracle Apps(Oracle EBS) implementations.
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball and Bill Inmon Methodology.
• Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided Data Warehouse, OBIEE RPD development, OBIEE reports and Dashboards
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
• Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
• Facilitated JAD (Joint application development) sessions with business users and development teams to drive out detailed business requirements.
• Exceptional Documentation Skills for writing Use Cases, Functional Requirement Documents (FRDs), business requirements documents (BRDs) as well as for creating Use Case diagrams, Activity diagrams, time sequence diagrams, State chart diagrams based on UML Methodology. Also, created business process flow diagrams using MS Visio, Enterprise Architect and Rational Rose.
• Extensively worked on Installation and configuration of Financials, Supply Chain Analytics, Procurement Analytics and Spend Analytics.
• Extensively Worked on Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Expertise in Data Warehouse Administration Console (DAC) to configure, monitor and schedule ETL.
• Proficient within the Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration tool.
• Expertise in implementing Security Models for Dashboards, Row level, object Level, Role Level, Dashboard Level
• 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 UTL 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 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 .
• 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.
• Had Hands on experience oracle data integrator (ODI) and done conventional Extract Transform and Load tools. Had a knowledge on Oracle Data Integrator enterprise edition 10g.
• Strong Conceptual, Business, Analytical skills and highly motivated team player and ability to provide work estimates and meet deadlines.

TECHNICAL SKILLS:

Oracle Applications: Oracle Financials E-Business suite R12/11i (Order Management (OM), Inventory (INV), Purchasing, General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Fixed Assets (FA), IProcurement, Cash Management (CM),, Oracle Procurement and Spend Analytics, AOL, System Administrator).

Developer Tools: OBIEE10.1.3.x,11g,12c,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 10.1.3.4.1

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

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

Data Modeling Tools: ER Win, ER/Studio, Visio

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

OBIEE Administrator/Developer

Responsibilities:

• Proficient knowledge of configuring, administering, monitoring, trouble-shooting WebLogic Server and WebLogic running on Exalytics Appliance.
• Part of DevOps Team
• 24*7 Support provided to OBIEE Business Users.
• Supporting of DAC, Hyperion Tableau and Qlik view Applications
• Installed OBIEE 12C in Linux Environments, Configured LDAP, SSL, OHS, SSO
• Implemented Siteminder (SSO) and http Appache
• Configured Performance tuning.
• Applied Obiee patch in all environments
• Resolved Issues related to obiee 12c (exporting, Agents, Catalog Objects)
• Used Service now application for all the incidents
• Migrated RPD and catalog
• Winscp and mRemoteNG tools are used to connect to linux servers.
• Created Script for users to download and upload RPD from local machines.
• Involved with LB Team to control Server timeout.
• Worked with Informatica and database teams.
• Worked with Oracle Support team and found solution to download and upload to server from local machine

Environment: OBIEE 11.1.1.7.x,12c, DAC 11g(11.1.1.6), Tableau9.0, Qlikview11, Linux x86-64

Confidential, Charlotte, NC

OBIEE Administrator/Developer

Responsibilities:

• Upgraded obiee 11.1.1.7 to obiee 11.1.1.9
• Installed OBIEE 12c on Windows Server 2012 servers.
• Implemented LDAP in all the environments.
• Migrated obiee11g to obiee12c
• Implemented Security by authenticating against the LDAP
• Effectively interacted with the end users for requirement gathering and defined requirement specifications document
• Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.
• Managed Security settings in OBIEE Administration Tool.
• Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment
• Worked with Oracle BI Repository like, Presentation Layer, Business Model and Mapping Layer (BMM), Physical Layer and migration of the Code, Repository (RPD), and Dashboard Reports from Dev to Test/QA and to Production and developed Folders, Dashboards, Pages Columns, Sections, Requests / Answers, Filters, Global Filters, Navigation Links, Views / Charts.
• Worked with Oracle BI (OBIEE) Installation, Oracle BI Server, Presentation Server, Oracle BI Repository (RPD), Oracle BI Administration.
• Responsible for configuring the Source and lookup files.
• Used OBIEE Web Catalog to set up groups, access privileges and query privileges.
• Added users and configured security in web logic console of OBIEE 11g.
• Managed security privileges for each subject area and dashboards according to user requirements
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
• Extensively worked on Answers, Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector and Table).
• Configured OBIEE iBots to deliver Analytics content based on schedule, automated iBot queries.
• 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 Query Tuning to maximize the performance of reports and Dashboards
• 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 on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.
• Caching options configured and defined overall cache strategy
• Created task in task scheduler for obiee start and stop services.
• Enhanced many existing reports based on user requests
• Created dashboards for Transaction Processing, insurance and HR applications
• Created reports for Insurance, Transaction Processing and HR application based on business user req.
• Created Ibots/agents and scheduled.
• Responsible for deployment of rpd, catalog, and BI Publisher reports across all environments.
• Performed Unit, Integration and Regression testing to validate reports and data.
• Performed Migration of Catalog and rpd from one environment to various environments
• Upgraded java versions in 11g - windows 2008 server r2 based on compliance team req.
• Changed weblogic passwords in obiee for every 30 days based on compliance team req.
• Resolved user login issues.
• Worked in Insurance, Transaction Processing (TRIP), HR and E-Trading Projects
• Hands on experience on SSIS and SSIS packages.
• Involved in SSIS package developing and maintaining.
• Resolved many bi analytics export issues
• Deployed all metadata in github and used Jenking to deploy all ssis packages in all environments (windows servers)
• Involved in troubleshooting the load failure cases, including database problems.
• Trained End Users about OBIEE Tools.
• Migrated RCU schemas from sql server 2008 to sql server 2012 for existing obiee application and updated SQL server information in OBIEE
• Migration of Catalog and rpd from one environment to various environments.
• Upgraded weblogic patch in 11g
• Ongoing production support of environments
• Created proper documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: OBIEE 11.1.1.7.x, 11.1.1.9.x, 12c. Windows server 2008 R2,windows 2012 R2, SQL Server 2008/2012, Java, JavaScript, HTML, XML/ Oracle BI Publisher 11.1.1.7.140715, MS Sql Server 2008 R2/SQL Server management Studio, MS Excel.

Confidential, MO

OBIEE Administrator/Developer

Responsibilities:

• Installed OBIEE 11.1.1.7 on Windows Server 2008R2.
• Implemented SSL in all the environments.
• Upgraded 11.1.1.7.13 .1.1.9 and applied 11.1.1.9.1 patch
• Part of redesigning RPD model
• Installed OBIEE 11.1.1.9 in a new windows 2012 servers and applied patch
• Modified existing reports based on user requirements
• Resolved Issues with MDS and BIPlatform Schemas.
• Knowledge transferred to BI team based on Deployments, MUDE, Installing client tool, SSL, BI Publisher services, GO URL, Best Practices of OBIEE.
• Made changes to the existing stored procedures to address the new reporting needs as part of change requests.
• Created multiple tables and enforced constraints on the tables to address the ETL needs
• Involved in creation of ad-hoc sql codes, to provide data extracts to various departments
• Created BI Publisher reports by using subject area, Data model and scheduled reports based on Business User requirements.
• Installed 11.1.1.9.0 on windows server 2012(dev,QP1,QP2,Qfinal,PROD1,Prod2) and applied 11.1.1.9.5 patch on top of it.
• Configured LADP and Implemented SSL on all new servers.
• Knowledge transferred to Application support team in regards to Installation and configuration of obiee and admin tasks
• Worked with BI development team to construct new rpd model and used ODS(operational data source) as source.
• Participated in OBIEE workshop conducted by Confidential .
• Documented best practices of OBIEE and explained it to BI team.
• Supported BI team in all development aspects
• Implemented shared catalog and RPD for qfinal servers and prod servers.
• Responsible for extracting Data from Oracle Apps Modules and loading into stage system and warehouse system.
• Worked with different Functional and technical teams to support financial module.
• Hands on experience in month-end closing process of financial modules.

Environment: OBIEE 11.1.1.7.x, 11.1.1.9.x, Windows server 2008 R2,2012R2, SQL Server 2008/2012/2014, XML/ Oracle BI Publisher, MS SqlServer 2008 R2, 2014,2012/SQL Server management Studio

Confidential, Charlotte, NC

OBIEE Administrator/Developer

Responsibilities:

• Installed OBIEE 11.1.1.7 on Windows Server 2008R2.
• Implemented LDAP configuration in all Environments.
• Created Application roles in EM and Assigned users and User
• Upgraded OBIEE 11.1.1.7.0 to 11.1.1.7.140715 (Build 140622. bit)
• Customized Obiee Login Page and Home Page.
• Effectively interacted with the users for requirement gathering and performed GAP analysis.
• Implemented Shared catalog and RPD while migration.
• Participated in the weekly meeting to structure the timelines for the project.
• Day to day support for Business Users
• Worked in Insurance, Transaction Processing, HR and E-Trading Projects
• Documented High Level Design Development, Administration and Specifications Documents
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Created dimension hierarchies, logical levels, level keys, and level based measures.
• Used the expression builder utility for the new logical columns in the BMM layer and created Various calculation measures and Time series measures.
• Defined session variables, static and dynamic repository variables, and presentation variables.
• Worked on both data level security and object level security.
• Set up the Usage Tracking subject area in the repository to track the statistics of reports.
• Created the reports by interacting with the users and analyzing the legacy systems.
• Created RTF templates and Data templates for creating Master-Detail reports in BI publisher.
• Worked with Business Groups to identify, analyze, and document Business Requirements for OBIEE/DW Projects.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment
• Worked with Oracle BI Repository like, Presentation Layer, Business Model and Mapping Layer (BMM), Physical Layer and migration of the Code, Repository (RPD), Dashboard Reports from Dev to Test/QA and to Production and developed Folders, Dashboards, Pages Columns, Sections, Requests / Answers, Filters, Global Filters, Navigation Links, Views / Charts.
• Created Materialized views, Functions in the Database to map them in the repository.
• 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 Query Tuning to maximize the performance of reports and Dashboards
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Created Analysis using various analytics views like Table, Charts, Pivot tables, Column Selectors, View Selectors, Narrative, Static text etc.,
• Created analysis with direct database request.
• Created ibots(agents) depends on business requirements and scheduled as per requirement.
• Created dashboard prompts for making users to extract data based on that filter. Implemented dashboard prompt on page level and dashboard level.
• Created presentation variables by using dashboard prompts.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
• Involved in Unit Testing, Peer Testing and Regression Testing
• Responsible for deployment of rpd, catalog, and BI Publisher reports across all environments.
• Performed Unit, Integration and Regression testing to validate reports and data.
• Performed Migration of Catalog and rpd from one environment to various environments.
• Deployed .war files in Console to have unique URL.
• Configured and managed Agents based on user requirement and conditions.
• Developed various reports, (pivotal, chart, tabular, drill down, etc) and Predictive analysis.
• Hands on Experience on Qlikview and Tableau.
• Experienced with SQL Server and Oracle in conjunction with tableau.
• Develop reports, dashboards, SQL queries or aggregations using Tableau
• Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau and qlik view
• Experience in mathematical modeling of data

Environment: OBIEE 11.1.1.7.x, Windows server 2008 R2, SQL Server 2008/2012, Java, JavaScript, HTML, XML/ Oracle BI Publisher 11.1.1.7.140715, MS Sql Server 2008 R2/SQL Server management Studio, MS Excel, Tableau9.0, Qlikview11.

Confidential, Lisle, IL

OBIEE Administrator/Developer

Responsibilities:

• Strong experience in OBIEE admin activities as well with managing Migration activities with respect to Dev to QA and QA to Perf (Performance environment) & Performance to Production environments.
• Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Worked on Linux platform (for OBIEE 10.1.3.4.0 ) and Windows platform (For OBIEE 11.1.1.6.5 ) to do the administrator tasks.
• OBIEE Admin work: New Id creation, Account modification of existing users, Password reset and Deletion of accounts.
• Integrated Ldap With OBIEE for Implementing security for both Authentication and Authorization
• Well worked on Administration - User profile creation, Dashboards, Groups - Users setup for Dashboards and security/responsibilities.
• Adding and removing users, roles and responsibilities thru using SRA Data Base.
• Gathered requirements from Business analyst for the Design of RPD metadata.
• Worked with data modelers to define the Joins between tables in the RPD.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
• Created Interactive Dashboards and Implemented Both Object level Security and data level security on them
• Experienced in OBIEE 11g application including web catalog, Web Center, and BI Publisher; and security administration and WebLogic doing web server administration in Oracle/Unix environment.
• Proficient knowledge of configuring, administering, monitoring, trouble-shooting WebLogic Server and WebLogic running on Exalytics Appliance.
• Successfully configured user security using Active Directory as the source for user id authentication combined with WebLogic Server for group and role management
• Adding users to the environment (Dev, test) by using WinSql.
• Worked on Migrations (RPD and Catalog)
• Worked on Linux environment as the OBIEE is installed on Linux server.
• While doing migrations, got expertise in Tera Term, WinSCP and PuTTY.
• Administering the OBIEE Dashboards and Reports, Data Visibility.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE.
• Worked with Oracle BI (OBIEE) Installation, Oracle BI Server, Presentation Server, Oracle BI Repository (RPD), Oracle BI Administration.
• Enhancements are done for some FT (Financial transitions) reports.
• Developed reports under MRAS Application (FT reports)
• Coordinated Onsite- Offshore Team for assigning the tasks and assisted Offshore team for
• OBIEE technical aspects.
• Developed well organized Integration setup document for OBIEE Admin Responsibilities.

Environment: OBIEE 11.1.1.6.5 /10.1.3.4.2,Oracle 11g, Windows server 2008 R2, Oracle Applications R12, General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Oracle 11g/10g, (OBIEE, Informatica), Informatica 8.6.1, XML/BI Publisher 5.6.3, Discoverer 10g, Repots10g, ANSI SQL, SQL*PLUS, SQL*Loader, TOAD, SAP BO, Data stage, putty, WinSCP 5.1.2, Tera Term 4.74

Confidential, Salt Lake City, Utah

Sr. OBIEE Developer

Responsibilities:

• Worked on integrating and configuring BI Publisher with OBIEE.
• Developed various reports based on Flow Status Code using XML/BI publisher to let the company know the booked orders which need to be shipped.
• Developed COGS (Cost of goods), balance sheet, profit and loss statement using BI Publisher.
• Customized Journal Entries (Ledger Report) and Billing History Report in Account Receivables (AR) using XML/BI Publisher.
• Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Designed and developed Detailed Landed cost Management (LCM) reports using BI Publisher and OBIEE which extracts the item cost tracking.
• Expertise in RPD Development, Oracle Answers/Analysis, Oracle Delivers BI Publisher
• Expertise working with BI XML Publisher, Data Templates, RTF, XSL Templates .
• Developed SQL and PL/SQL reports.
• Worked with XML Publisher Reports, Oracle Discoverer Reports and SQL * Loader.
• Working with Financial Analytics Dashboards:
• General Ledger: Overview, Balance Sheet, Cash Flow, Budget vs. Actual, Asset Usage, Liquidity,
• Financial Structure, GL Balance, Trial Balance
• Payables: Overview, AP Balance, Payments Due, Effectiveness, Payment Performance, Supplier
• Report Invoice Details, All AP Transactions
• Profitability: Overview, P&L, Margins, Revenue, Products, Customers,
• Project Invoices: Project Invoices
• Receivables: Overview, AR Balance, Payments Due, Effectiveness, Payment Performance,
• Customer Report Invoice Details, All AR Transactions
• Developed COGS (cost of goods) and inventory reports which differentiate the landed goods and not landed goods.

Environment: Oracle Applications R12, General Ledger, Account Payables, Accounts Receivable, Inventory, Order Management, Landed Cost Management, Oracle 11g/10g, (OBIEE, Informatica), Informatica 8.6.1, XML/BI Publisher 5.6.3, Discoverer 10g, Repots10g, ANSI SQL, SQL*PLUS, SQL*Loader, TOAD, SAP BO

Confidential, Atlanta, GA

Sr OBIEE Consultant

Responsibilities:

• Analyzed Business Requirements/Functional Documents and prepared Technical documents.
• Involved in installation and configuration of OBIEE, Informatica and DAC.
• 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.
• Involved in the installing and configuring of Financial and Supply Chain Analytics.
• Built Siebel Analytics Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs).
• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
• 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.
• Configured the Analytics repository (RPD) and implemented the security to authenticate and authorize Oracle users.
• Extensively used Transformations like Lookup, Router, Normalize, Aggregator, Source Qualifier, Joiner, Expression and Update Strategy.
• Designed and implemented Informatica Power Center 8.6 for ETL to load target Oracle 11g database.
• 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.
• Designed and developed BI Publisher reports according to client requirement
• 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.
• Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Configured Row Level Security, Column Level Security and Object level security to allow users to view their respective data only according to the requirement.
• Performed Unit, Integration and Regression testing to validate reports and mappings.

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 11g/10g/9i (9.2.0), OWB, SAP BO, OBIEE 10.1.3.4.0, SIEBEL Analytics 7.x, RPD, Dashboards, Delivers(iBots), Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, Unix(shell scripting).

Confidential, Jacksonville, FL

OBIEE Technical Consultant

Responsibilities:

• Worked with business users to gather business requirements and provided reports in Financial, manufacturing and Supply Chain modules.
• Designed and Developed Financial Dashboard like General Ledger, Payables, Receivables.
• Created AD hoc reports in Account Payables.
• Developed Dashboard pages like Finance Structure, Cash Flow and Asset Usage in General Ledger Dashboard.
• Developed Dashboard pages like 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.
• Was part of the installation team to install OBIEE BI Apps.
• 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, Account Payables, Accounts Receivable, Inventory, OBIEE 10.1.3.3/10.1.3.2, XML/BI Publisher 5.6.3, Discoverer 10g, SQL*PLUS, SQL*Loader, TOAD, UNIX.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes.
• Designed and Developed AP Check Printing Report, Invoice Detail Report by Supplier, Payment Schedule Report in XML/BI publisher.
• Customized the standard AR Aging Report and Invoice History Report using XML/BI publisher.
• 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.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.
• Developed new report Credit Memos in AR using Discoverer.
• Developed GL journal Import interface program in General Ledger.
• Customized Chart of Account Detail listing, Trial Balance, Summary Income Statement in General Ledger using FSGs.
• Converted Order Detail Report, Credit Order Summary Report, and Orders by Item Report in Order management from report 6i to XML/BI publisher.
• Created new responsibilities and involved in defining the required system profile options.
• Loaded data to the interface tables and populated data to Standard Tables through Standard Order Import Program.

Environment: Oracle Applications 11i (11.5.10), General Ledger, Accounts Payables, Account Receivables, Order Management, Inventory, Oracle 9i, Discoverer 10g, Windows 2000/NT, SQL*Plus, TOAD, Reports 6i, Kintana, UNIX.