SUMMARY:

• Over 7 years of experience as Oracle Business Intelligence and Applications Consultant with successful track record in gathering user requirements, designing, developing and supporting different Business Applications.
• Extensively worked on Business Intelligence and Datawarehousing with Kimball and Inmon Methodology using OBIEE and Informatica, DAC.
• Experienced customizing Intelligence Dashboards/Score cards with drill - down capabilities using global and local Filters, Analytics Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboards, Pages, Folders and Reports).
• Strong skills in Requirement Study, Gap Analysis, Scope Definition, Synchronization, Recommendations to Business Process Improvements.
• Extensively worked on Creating Users, Groups, and Initialization Blocks in Oracle Admin Tool to set up Security using LDAP.
• Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups
• Extensively worked on Installation and configuration of Financials Analytics, Supply chain and Order management Analytics, HR Analytics, and Procurement and Spend Analytics
• Created Dimension hierarchies, Time comparisons and Share measures along with ranks.
• Designed and developed variables and initialization blocks in the repository.
• Extensively worked on Extract, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Expertise in providing enterprise level security and powerful administration facilities using weblogic server.
• Worked extensively on OBIEE 11g components like oracle enterprise manager and weblogic server administration console.
• Proven Strength in Creating guidelines and templates for designing & developing BI Applications.
• Experienced in General Ledger, Account Payables, Accounts Receivable, Inventory, Purchase Order and Order Management.
• Experienced in providing end-to-end business intelligence solutions by dimensional modeling design, developing and configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots.
• Created workflows with Worklets and Sessions, scheduled and modified using DAC and workflow monitor.
• Expertise in customization of Noetix Views and Noetix Analytics.
• Developed and Scheduled workbooks using Discoverer Desktop.
• Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Adept at creating technical guides, user manuals and other related technical documentation, including Application Implementation Methodology (AIM).
• Very proficient in SQL tuning and optimization of queries.
• Experience in Requirement Analysis, JAD sessions, Business and Systems reviews and working sessions to understand the requirements and system design.
• Experience in supporting the production system and handling day-to-day issues.
• Worked Extensively on OBIEE Administration Tool and Presentation Services.
• Excellent analytical, problem solving and communication skills with ability to be an effective team member and have the capability to work under severe time constraints.

TECHNICAL SKILLS:

Oracle Applications: General Ledger, Accounts Receivables, Accounts Payables, Order Management, Inventory, Purchase Order.

Application Tools: OBIEE 11g/10g, Discoverer 10g/9i, BI Publisher 11g/10g.

ETL Tools: Informatica 9.x/8.x/7.x, DAC 11.x/10.x

Databases: Oracle R12/11g/10g/9i, MS SQL Server 2000

Languages: SQL, PL/SQL, C, C++, Java, JDBC, JSP, XML, UNIX shell scripting

Operating System: UNIX, Linux (Red hat enterprise) and WINDOWS 98/2000/NT/XP/7

Other Tools: Toad, SQL Navigator, SQL*Plus, SQL*Loader, SQL developer

PROFESSIONAL EXPERIENCE:

Confidential, MD

BI Apps Consultant

Responsibilities:

• Extracted the data from the custom and EBS 11i system, transformed the data and loaded into the OBIEE analytics warehouse using Informatica and DAC.
• Applied patches for OBIEE, WebLogic and HTTP Servers in UNIX environment.
• Installed and configured webGates plug-in for OAM on top of HTTP server for authentication and authorization.
• Configured OAM and OID with OBIEE to enable SSO.
• 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.
• Created user groups and roles and granted access to users and maintain security by using external table authentication and authorization.
• Involved in Performance tuning of sessions and mappings for better performance.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• Designed ETL Mappings using Informatica from Scratch to load the Data from Source System (Custom) to staging system (SDE mappings) and to target Analytics Warehouse.
• Modified prebuilt ETL mappings (AP, PO and GL) to bring the custom attributes.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Created custom subject areas, tasks and execution plans in DAC.
• Interacted with SME’s, Business Analysts and Users for gathering and analyzing the Business Reports Requirements.
• Conducted meeting with project managers, business users during testing and deployment stage of the application development life cycle.

Environment: Oracle Applications 11i (AR, AP, GL), Oracle 11g, Informatica 9.1, DAC 10.1.3.4, UNIX, Toad, OBIEE 11.1.1.6.6/11.1.1.7.150120

Confidential, TX

OBIEE Developer

Responsibilities:

• Performed the Setup, Installation and Configuration of the complete Analytics platform environment OBIEE, Informatica and DAC and the required connectivity for seamless integration with the data warehouse.
• Extracted the data from the source system EBS R12, transformed the data and loaded into the OBIEE analytics warehouse using Informatica.
• Implemented Financial Analytics, HR Analytics, Procurement and Spend Analytics, integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Analyzed, Designed, and Developed OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Implemented security by creating users & groups, setting up External Table Authentication.
• Migrated Discover reports to OBIEE using Noetix views (for transactional reporting).
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures
• Designed, implemented and tested security privileges on Dashboards and Reports.
• Worked with Catalog Manager to migrate Web Catalog among Instances.
• Involved in Performance tuning of sessions and mappings for better performance.
• Designed performance effective star schemas and replicated complex snowflake schemas from BO
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Built reports using Answers including drilldown objects, union based reports and formatted functions within the reports.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• 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.
• Implemented security using LDAP authentication in weblogic administrator console
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Developed and debugged many intelligence Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic/Interactive Dashboards with drill-down capabilities using global and local Filters.
• Customized Dashboard pages like AR Balance, Payments Due, Invoice Details and all AR Transactions in Receivables Dashboard.
• Customized Dashboard pages like AP Balance, Overview, Payments Due, Supplier Details and Invoice Details in Payables Dashboard.
• Implemented Time Comparison and Calculation measures in the business model using Time series wizard and modeled Slowly Changing Dimension Data.
• Developed many complex Full/Incremental Informatica Objects (Workflows / Sessions, Mappings/mapplets) with various transformations.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Customization and enhancement of standard Oracle applications reports in Account Payables module like Invoice Aging Report, Invoice Validation report, Cash requirement report using Oracle BI Publisher.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes using Oracle Reports 11g.
• Managed test cycles around defects and test cases in HP Quality Center.
• Documented and track defects, as well as produce detailed reports using HP Quality Center.
• Developed process and business rules around setup of new users (Logins, Responsibilities).
• Defined Dashboards, Filters, and Prompts as per user’s requirements.
• Conducted JAD sessions to gain clarity and finalize business requirements.
• Conducted meeting with project managers, business users during testing and deployment stage of the application development life cycle.

Environment: Oracle Applications R12 (GL, AR, AP, OM, PO), Oracle BI Publisher, OBIEE 11g, OBIA 7.9.6.3, Oracle 11g, Informatica 9.0.1, DAC, SQL*Loader, Unix, TOAD.

Confidential, WI

OBIEE Consultant

Responsibilities:

• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Defined Connection Pools to the Source Data warehouse tables in the Physical Layer.
• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Implemented Financial Analytics, Supply Chain and Order Management Analytics.
• Created Presentation catalogs/Subject Areas for Sales and Month End Account measures.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Merged repositories and migrated to multiple servers.
• Created production builds and getting approvals from senior management.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Granting access to users and maintain security by using database authentication and authorization.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management
• Created the physical and complex joins in the Physical and Business layers.
• Created Aliases and defined Role-Playing Dimensions.
• Created Repository Groups and Web Groups and assigned users to configure security in OBIEE.
• Worked on Dashboard and Page level prompts and Report filters.
• Involved in performance tuning by enabling the cache to improve the query performance.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• 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).
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Worked on application services such as web server functionality, business components and access to back end enterprise systems by using weblogic server.
• Developed Order/Invoice Detail Report, Sales Tracking Report and Back Order Detail Report in Order Management using Oracle BI Publisher.
• Customized Employee listing report Invoices on Hold report and Suppliers report as per the business requirements using Oracle BI Publisher.
• Modified several Customized Reports using Oracle BI Publisher like Credit/Debit Memo Report, Invoice History, Invoice Aging, Prepayment Status, and Invoice on Hold Reports as per changing business needs.
• Customized AR aging reports in Accounts Receivable (AR) and Chart of Account Detail Listing Report using Oracle BI Publisher.
• Conducted JAD sessions to gain clarity and finalize business requirements.
• Interacted with the end users to gather desired requirements, analyzed the requirements, and finally, developed and implemented various PL/SQL and Oracle Application routines to fulfill those requirements.

Environment: Oracle Applications 11i (AR, AP, GL, OM, INV, SCM), Oracle 10g, OBIEE 10.1.3.4.2 , OBIA 7.9.6.2, SQL*Loader, Unix, Oracle BI Publisher, Informatica 8.6.1, DAC, Discoverer 10g, TOAD, UNIX Shell Scripting.

Confidential, WI

OBIEE developer

Responsibilities:

• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Created Logical Columns based on other Logical and Physical columns in the BMM layer.
• OBIEE Server Administration (Setting up a repository, Administering the Query Environment, Scheduler, Query Caching).
• Created the physical and complex joins in the Physical and Business layers.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Defined Session variables and the corresponding Initialization Blocks for User Logins at dimensional levels.
• Defined Session variables in the repository to populate the current date filters.
• Worked on Dashboard and Page level prompts and Report filters.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• 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).
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Developed executive level Forms and reports for Invoice details by customer, by item, by product type using Oracle Forms, Reports, and Business Objects.
• Modified several Customized Reports like Credit/Debit Memo Report, Invoice History, Invoice Aging, Prepayment Status, and Invoice on Hold Reports as per changing business needs using XML/BI Publisher.
• Developed Responsible for creating backend procedures and triggers.
• Developed Involved in creating various reports which include tabular, Group by matrix and form letter types.

Environment: Oracle 10g, EBS 11i, OBIEE 10.1.3.4.1 , OBIA 7.9.6, XML/BI Publisher, Discoverer, Informatica 8.1.1, SQL Loader, TOAD, Windows NT, UNIX.

Confidential, Fairfield, NJ

OBIEE Developer

Responsibilities:

• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Defined Connection Pools to the Source Data Mart tables in the Physical Layer.
• Created Presentation catalogs for Sales and Month End Account measures.
• OBIEE Server Administration (Setting up a repository, Administering the Query Environment, Scheduler, Query Caching).
• Created the physical and complex joins in the Physical and Business layers.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Created Aliases and defined Role-Playing Dimensions.
• Created Repository Groups and Web Groups and assigned users to configure security in the OBIEE Server.
• Defined Session variables and the corresponding Initialization Blocks for User Logins at dimensional levels.
• Defined Session variables in the repository to populate the current date filters.
• Created complex Reports based on user requirements.
• Worked on Dashboard and Page level prompts and Report filters.
• Interacted with functional consultants for mapping legacy data to Oracle tables.
• Developed conversion mapping documents (CV40) to map legacy journal entries, inventory items, and AP vendors and purchase orders to Oracle 11i.
• Developed several workbooks using Discoverer Desktop.
• Scheduled workbooks using Discoverer Desktop.
• Designed and developed reports like pack slip report, trip report, Open Purchase order report, AR aging report and AP trial balance report and registered the developed reports using AOL.

Environment: Oracle 10g, EBS 11i, OBIEE 10.1.3.2, Discoverer and Toad.

Confidential, Pittsburgh, PA

OBIEE Developer

Responsibilities:

• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Created Logical Columns based on other Logical and Physical columns in the BMM layer.
• E-business suite Server Administration (Setting up a repository, Administering the Query Environment, Scheduler, Query Caching).
• Created the physical and complex joins in the Physical and Business layers.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Defined Session variables and the corresponding Initialization Blocks for User Logins at dimensional levels.
• Defined Session variables in the repository to populate the current date filters.
• Created item classes, conditions and joins using Discoverer Administrator.
• Registered functions using Discoverer Administrator.
• Developed workbooks in various formats like tabular, page detail tabular, cross-tab and page detail cross-tab format using Discoverer Desktop and Plus.
• Used SQL* Loader and UTL FILE Packages for data conversion and interfaces.
• Involved in customization of reports for giving statistical data as per requirements.
• Customized various standard reports like Purchase Order Summary, Purchase Orders Outstanding, Purchase Order Detail Report, Invoice Detail Report, Invoice Payment Register, Invoice Payment Outstanding, General Ledger Account Analysis Report etc using Reports 6i.
• Developed new forms using TEMPLATE.FMB and customized existing forms in the OM module according to the client’s requirements.
• Customized standard oracle reports like Check Formatting Report, etc as per client's requirements.

Environment: Oracle 10g, Windows/NT, PL/SQL, EBS 11i, OBIEE 10.1.3.2, Reports 6i, Discoverer 4i, TOAD 7.3, SQL Loader.

Confidential

Oracle Technical Consultant

Responsibilities:

• Worked as part of the Reports Development team.
• Designed and developed Actual Income Budget Statement, Cumulative Balance Sheet and Budget/Actual Report, Income Statement with Variance, Cumulative Balance Sheet and Income Statement Consolidated report.
• Developed various Mailing list reports and Form letter reports using Reports 6i.
• Customized Supplier Paid Invoice History Report, Supplier Merge Report, Supplier Audit Report, Chart of Account Detail Listing Report and Supplier Payment History Report in Account Payables using Oracle Reports 6i.
• Created new custom reports in XML/BI publisher, upgraded Standard 6i reports to XML/BI publisher reports.
• Generated Inter Company Transaction Detail Report, Open-Debit Memo Report in General Ledger using Reports 6i.
• Extensively Modified Shipping INBOUND/OUTBOUND interface programs to accommodate changes in business process.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various custom PL/SQL Packages developed.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.
• Created required shell scripts for secured FTP with error handling capability.
• Developed design and implementation documents such as MD050, MD070, MD120, Unit Test scripts and user-documentation.

Environment: Oracle Applications 10.7 Account Payables, Account Receivables, Order Management, Inventory, Purchase Order, General Ledger, Oracle 9i, Unix, Reports 6i, Forms 6i, SQL*Loader, TOAD, UNIX Shell Scripting.