Summary:

• Over 10 Years of Extensive IT experience in Analysis, Design, Coding, Testing, Implementation, User Training and Post-implementation Support of EBS, Business Intelligence Analytical Solutions.
• 6 years of extensive experience in Oracle Business Intelligence EE 11g and Siebel Analytics 7.x
• 4 years of live experience in implementation and Production Support of Oracle Applications 11i/R12 using Oracle Reports, Oracle Discoverer, Oracle XML Publisher.

Technical Skills:

• Oracle Applications Oracle Applications Release 11.0.3 to R12,
• RDBMS Oracle 7.x/ 8i,/9i/10g, Access, SQL Server 7.x, 2000, Sybase
• BI Tools: OBIEE 10g/11g, Siebel Analytics, Oracle Discoverer 10g/11g, BI Publisher
• Tools Oracle Forms 6i/9i/10g, Reports 6i/9i/10g,Crystal Reports 9.0, SQL Navigator, TOAD,SQL Developer, SQL Loader, Informatica Power Center 7.1/6.1
• O/S UNIX, Windows NT/XP/2000/98, Linux, MS-DOS
• Languages SQL, PL/SQL, Web PL/SQL, SQL server 2000/2005, C, C , C , Java, HTML, XML, X Path, XSLT, JavaScript, JSP, ASP, ASP.Net.
• Web Tools Java Applets, Servlets, JSP, ASP, Java Beans, JDBC

Professional Experience:

Confidential

Lead Analyst Oracle BI Report Developer

OBIEE/Data warehouse

• Highly involved in gathering and analyzing the Business Requirements in collaboration with the Sales, Marketing and Finance Subject Matter Experts SMEs , Business Analysts and Users
• Designed, Developed, and Configured OBIEE 11g Oracle BI Metadata Repository .rpd using complex joins, and multiple business models.
• By using Oracle Discoverer Metadata Conversion Assistant, migrated Discoverer metadata from the EUL's to an Oracle BI EE Semantic layers, then by using the newly generated RPD files, created reports using Oracle BI Answers/Analysis.
• Analyzed the system for the functionality required as per the requirements and created System Requirement Specification document Functional Requirement Document .
• Designed the Data Mart model using Dimensional Modeling methodology in conjunction with data architects and ETL team.
• Designed and implemented Physical and Logical Star Schemas/Diagrams using Fact, Dimension, Alias and Extension tables as well as Foreign and Complex joins
• Configured and enhanced Repository using Administration Tool
• Worked on the Time Series Wizard and implemented time comparison measures.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features to meet the business requirements.
• Responsible for implementing Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Region and Product dimensions, using Session Variables.
• Developed various Dynamic and Interactive Dashboards/ Reports with intuitive drilldowns, drill-across and drillable charts using Oracle BI Publisher and Oracle Answers/Analysis.
• Performed Migration of Repository and Web Catalog objects from Development to QA to Production environments, using Catalog Manager.
• Involved in setting up Session and Repository variables using various Initialization blocks.
• Configured and scheduled iBots using Oracle Delivers, to deliver customized Reports to key Business Users on daily and weekly basis, to their email, mobile, and hand-held devices.
• Created strategic and innovative Reporting Templates by utilizing KPI's and business performance Metrics
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Materialized Views, Cache Management and re-organizing data.
• Used filters and provided customized prompts to avoid excessive data visibility in reports.
• Created custom ETL extract to load data warehouse tables on daily basics from OLTP system.
• Developed and Implemented Usage Tracking Reports.
• Trained End User's to familiarize with BI Answers, Bi Dashboards, Discoverer Plus and Viewer.
• Created updated and closed several Tar's to solve issues related to Discoverer and XML Publisher.

Confidential

EBS/BI Publisher/Discoverer

• Extensively involved in EBS R12 Implementation, Data Conversion and Data Migration, Remediated all the custom reports and programs
• Designed and developed PL/SQL procedures, functions, packages and triggers. Created indexes and hints to speed-up a performance.
• Worked Extensively on Oracle Discoverer 10g /11g Administrative Edition, Discoverer Plus and Viewer, to develop various reports in Financing, Order Management, General Ledger, Projects and Fixed Assets modules.
• Migrated Discoverer metadata from the EUL's to an Oracle BIEE 11g Semantic layers
• Worked Extensively on BI Publisher 10g/11g against Oracle Applications 11.5.10/R12
• Created 'rtf' excel templates for seeded oracle reports such as Invoice, Purchase order Sales order Ack.
• Created complex templates, using Sub templates, Dynamic images, complex charts, and dynamic parameters to produce the output in PDF and EXCEL formats.

Environment: Oracle Apps R12/11.5.10, GL, AP, AR, PO, CM, OM, FA, PA, INV, WSM, BOM, CST Oracle 10G, PL/SQL, SQL Plus, SQL Loader, Reports 10g,Discoverer 10g/11g,BI Publisher10g/11g, OBIEE 11g, Shell Scripting, TOAD, Windows XP, UNIX, Serena.

Confidential

Oracle BI Consultant

Responsibilities:

• 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.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE 10g Administrator tool.
• Monitored incremental and full load of data through Data Warehouse Administration Console DAC and Informatica.
• Was involved in the installing and configuring of Financial, Order Management Supply Chain and Procurement and Spend Analytics.
• 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 10g.
• Worked on integrating and configuring BI Publisher with OBIEE 10g, Designed and Developed General Ledger, Payables, Receivables, Profitability, Spend and Supplier Performance Dashboards.
• Configured Financials and Procurement Spend Analytics.
• Created MUDE Multiple user Development Environment environment by utilizing projects.
• Created and customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Developed Performance Tuning Strategies by implemented cache Management.
• Worked Extensively on XML Publisher 5.6.2 against Applications 11.5.10, to develop various reports in GL, AP, AR, OM, INV,PO,FA,PA,CST,BOM, and WSH modules.
• Interacted with Business Users, Functional and Business Analysts to write Functional and Technical Specifications.
• Restructuring customers by implementing TCA Trading Community Architecture customer relationships and building customer hierarchy.
• Designed and created over 55 XML Publisher Reports from various modules.
• Designed Data Definition and Templates to produce output in user required formats
• Created complex templates, using Sub templates, Dynamic images, complex charts, and dynamic parameters to produce the output in PDF and EXCEL formats.
• Created templates for seeded oracle report such as Customer statement, Invoice, Purchase order, Sales order Ack, Trial Balance, Assets Addition, FA Assets Transfer.
• Worked Extensively on Discoverer 4i/10g Admin, Desktop and Plus Editions to develop various reports in GL, AP, AR, OM, INV,FA,PA
• Designed and Developed Custom Views to meet the reporting requirements.
• Created Apps Mode End User Layer EUL and imported seeded business areas and workbooks.
• Designed and created over 25 Discoverer workbooks from various modules.
• Worked on Noetix views.
• Trained employees and End User's on Oracle XML publisher, Discoverer Plus and Viewer.
• Resolved several high priority and critical defects under given time frame.
• Imparted Best Practice's to be followed to User's during Training.

Environment: Oracle Apps 11.5.10, GL, AP, AR, PO, CM, OM, FA, PA, INV, WSM, BOM, CST Oracle 9i, PL/SQL, SQL Plus, SQL Loader, Forms 6i, Reports 6i,Discoverer 4i/10g,XML Publisher, OBIEE10g, Shell Scripting, TOAD, SQL Navigator, Workflow Builder 2.6, Windows XP, UNIX, Kintana, PVCS, Mercury

Confidential

Oracle Application Technical Consultant

Responsibilities:

• Created complex templates, using Sub templates, Dynamic images, complex charts, and dynamic parameters to produce the output in PDF and EXCEL formats.
• Designed Data Definition and Templates to produce output in user required formats
• Created Discoverer Business Areas and Custom Folders for various modules.
• Worked Extensively on Discoverer 4i/10g Admin, Desktop and Plus Editions to develop various reports in GL, AP, AR, OM, INV,FA,PA
• Developed a feeder program to load external data from legacy system using SQL Loader into AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE Interface Tables.
• Designed and developed a custom package to import Open POs from Alpha System using PDOI.
• Customized XML Publisher report for AR invoice in the client specified layout.
• Involved in customization of several standard reports to serve important business processes very specific to the client. These Reports were developed since the already existing Oracle Report was not friendly enough to suit the client needs. Such reports include Purchase Order Detail Report in PO, Invoice on hold report, vendor, payments, and analysis reports in AP, and also Customer, receipts, invoice, and adjustment reports in AR.
• Using TEMPLATE.FMB to develop forms in accordance with Oracle coding standards.
• Sales Order Form Customization. Involved developing new forms to display Item Information, Delivery Information.
• Used descriptive flexfields extensively to capture additional information in standard as well as customized forms.
• Extensively worked on customizations and configuring the Oracle Workflows.
• Customized standard Aging 4 buckets and 7 buckets reports.
• Interacted with users and business owners to capture the requirements and prepare AIM documents e.g. MD050, MD070 .
• Created Discoverer Business Areas and Custom Folders for various modules.
• Involved in Production Support, problem resolutions and bug fixing. Actively involved in raising issues and coordinating between the Management Users.
• Preparation of Technical specifications and User Reference Documents.

Environment: Oracle Apps 11.5.10, GL, AP, AR, PO, CM, OM, FA, Oracle 9i, PL/SQL, SQL Plus, SQL Loader, Forms 6i, Reports 6i, Shell Scripting, TOAD, Workflow Builder 2.6, Windows XP, UNIX

Confidential

Oracle Application Technical Consultant

Responsibilities:

• Developed Order compliance report that generates all the possible information related with the orders using Reports 6i.
• Worked on AR transaction distributions Report using Discoverer 4i.
• Technical support on AR invoice interface.
• Developed a custom interface, to send payment information from AP to external system.
• Worked on customer open invoices conversion in AR. Created request set for calling sql loader control files, custom pl/sql procedures and seeded auto invoice interface program.
• Responsible for requirement analysis and reviewing MD-50 writing of technical design MD-70.
• Developed concurrent programs to interface customer data from legacy systems to oracle receivables.
• Designed and developed GL interface program.
• Involved in Creating the Oracle table spaces, tables, indexes, constraints, triggers, synonyms, database links, roles etc.
• Developed Packages, Function, Procedure and Database Triggers.
• Analyzing the Design and functionality.
• Responsible Co-ordination with Client.
• Worked on custom validation report in AR receivables .
• Contributed in business and process prospective during design review.
• Involved in the development of solutions to need business needs and support process improvements.
• Involved in gap analysis, creation of setup documents and in the process of mapping the business requirements.
• Developed SQL Loader program to import PO Receipts data file into staging table from third party system.
• Extensively used of PL/SQL Procedures, Functions, and Packages.
• Designed and developed custom form in Oracle Purchasing.
• Customized and enhanced transactions register report in purchasing.
• Was able to work successfully in a fast paced environment and developed the reports in time.

Environment: Oracle applications 11i, Discoverer 4i, Oracle forms 6i, Reports 6i, Oracle 9i, Sql, Pl/sql, TOAD

Confidential

Oracle Developer

Responsibilities:

• Developed SQL Loader programs to load legacy data into custom tables.
• Developed code for GL conversions to extract legacy journals to load into GL INTERFACE table.
• Worked with Reports development customizations.
• Worked with CUSTOM.pll to enable ZOOM function and make mandatory fields.
• Involved to make technical specifications for reports and interfaces.
• Used Order Import to import data into Order Entry/Shipping for processing.
• Wrote a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices into auto invoice interface tables.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Responsible for giving technical support on the financial and manufacturing modules of Oracle Applications 11i.
• Trained end users.
• Involved in creation of Technical Docs User docs as well.

Environment: Oracle Applications 10.7, GL, AR, AP, Oracle 8i, SQL PLUS, PL/SQL, Forms 4.5, Reports 2.5, TOAD