SUMMARY

• Nine plus years of experience in Oracle EBS 11i/R12 and Oracle Business Intelligence.
• Extensive experience in the customization of Oracle based systems: design, development, testing and implementation of relational database management systems using Oracle 8.0/8i/9i/11i, Forms 4.5/6i/9i, Reports 2.5/6i/9i,Workflows and other Oracle tools under UNIX and Windows platforms.
• Excellent live experience in implementation and Production Support of Oracle Applications 11.0.3, 11i/R12 (Oracle Inventory, Oracle Purchasing, Order Management, Oracle Payables, Oracle Receivables, General Ledger, Oracle Projects, iReceivables, iExpenses, iSupplies)
• Expertise in writing stored procedures, Packages, Database Triggers and functions using PL/SQL.
• Expertise in BI(XML) Publisher Reports Creating Data Templates and complex XML Publisher Templates
• Experience with repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports, Alerts). Added Metadata changes to the OBI/Siebel Analytics .rpd.
• 2 years of experience in OBIEE10.1.3.4, Oracle BI Applications 7.9.4 which include building and configuring repository, creating and managing Oracle Intelligent Dashboards, Oracle, Oracle and Oracle (ETL - Informatica)
• Expertise in Design and development of Interfaces and Data Migration using SQL*Loader, Oracle open interfaces, database triggers, procedures, interface tables, APIs and UTL Files
• Good experience in Oracle Applications 11i/R12 Application Object library (AOL).
• Extensive Knowledge on TCA (Trading Community Architecture).
• Extensive work experience with AP, GL, AR, OM.
• Experience in Application System Administration activities like managing concurrent managers, application user set up, defining responsibilities, value sets, flex fields, registering menus and providing support to Apps end users.
• Worked with business team for creating functional (MD050) and technical (MD070) design document for customizing the Order to Cash cycle.
• Expertise in Procure to Pay cycle.
• Participated in the design, development, customization and support of Oracle 11i/R12 E-business applications.
• Resolved production related problems and enhanced applications according to requirements.
• Expertise in Production Support and Issue resolving and handling TARs with Oracle support.
• Worked on 24*7 environment to provide production support activities for Oracle 11i Application.
• Great learning skills to adapt the rapid changing technologies and implementing the same Confidential work.
• Ability to plan, monitor, support and deliver on time while within the budget in high pressure environments, proactive initiation and solution oriented proposition contribution.

TECHNICAL SKILLS

RDBMS: Oracle 8i/9i/10g, MS Access, SQL Server 2000

Oracle Applications: Oracle E-Business suite 11i/R12 (GL, AP, AR, PO, INV, OM, WSH, BOM, CRM, HRMS), R12, AOL, Sys.Admin

Application Tools: Forms 9i/6i/4.5 and Reports 9i/6i/3.0/2.5, Discoverer 3i/4i/9i/10g, TOAD, SQL Navigator, SQL*Loader, SQL*PLUS, XML Publisher, Noetix Views, KINTANA.

O/S: UNIX, Windows NT/XP/2000/98, Linux, MS-DOS

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

Scripting Languages: UNIX shell script.

PROFESSIONAL EXPERIENCE

Confidential, Irving,TX

Sr.Oracle EBS Developer

Responsibilities:

• Designed and developed a custom PL/SQL Program for Printing Dunning Letters in Oracle IEX Collections using Oracle Standard Dunning Letter Print Package IEX DUNNING PUB.SEND DUNNING CONCUR.
• Development of Interface Programs involving AR Customers Interface and Conversion programs included GL code combination Conversion program.
• Wrote UNIX shell scripts to automate the conversion from the legacy systems and also to ftp the files to the legacy systems and to send error message notifications to the user groups.
• Customized and developed several reports in AR, AP, PO modules using Reports 6i.
• Development of Interface Programs involving AR Customers Interface and Conversion programs included GL code combination Conversion program.
• Developed Customer Invoice, Purchase Order Report using XML Publisher.
• Worked on Asset Adjustments and Asset Retirements in FA.
• Designed and Developed Custom Report Templates in XML publisher for Printing Invoices, Pay Checks, Estoppel Letters, Dunning Letters, FA period Report by eliminating the Legacy presentation Formscape Software for printing solution.
• Developed Sales Order Conversion to load Historical Orders Data into Oracle Base.
• Designed and developed custom program to interface daily all invoices from different systems into AR using Auto invoice, with validation and audit report.

Environment: Oracle Application E-Business Suite 11.5.10.2, R12 (AR, AP, GL,OM,INV),Oracle 9i/10g, XML/BI Publisher, PL/SQL, SQL Bulk Loader, Oracle Reports 6i/10g,Oracle Forms 6i/10g, Workflow Builder, TOAD 10.1.1.8.

Confidential, Plano, Tx

Sr.Oracle EBS Developer

Responsibilities:

• Developed Order Management, Payables (GL) and Receivables queries to compare summary information of the standard and custom reports.
• Worked on custom Asset tracking system called CATS that keeps track of inventory(INV) and is interfaced to Fixed Assets (FA).
• Created SQL* Loader scripts to load data from legacy systems to Oracle Apps.
• Expertise in testing the flow of Order to Cash and Procure to Pay cycles.
• Developed a PL/SQL package for populating custom tables with cost of goods sold data.
• The data from Inventory (INV), PO and AP,FA is tied back to GL and the details are gathered to populate the tables.
• As per the company requirements, created and implemented XML Publisher reports for different products like AP, AR,FA and GL
• Worked on Asset Adjustments and Asset Retirements in FA.
• Customized some of the Reports using Xml publisher like Check printing, Bank Statement in AP, Customer Statement, Invoice Printing, Dunning Report in AR, Order/Invoice Detail in OM & RMA, in transit reports in INV.
• Registered the Templates and Data Definitions using XML Publisher Administrator responsibility.
• Worked on performance tuning of various views/tables for better report execution time.
• Created Request Groups and Value sets for reports.
• Developed the AOL forms using the TEMPLATE.fmb and built the code as per the AOL coding standards.
• Design and Development of Serialization solution by creating ZOOM forms Confidential the time of Receipt,Move order and Shipment.
• Involved in Unit testing, Integration Testing and writing the Test plans.
• Prepared system test cases and participated in system testing
• Interacted with Offshore team while code review and code merging.
• Involved in 24/7 on call production support.

Environment: Oracle 10g/11g, Oracle EBS R12, PL/SQL Developer, Reports 6i/10g, Discoverer9i/10g,XML/BI Publisher, Sun Solaris Unix, Shell scripts, Altova xmlspy, MS Excel.

Confidential, NC

Sr. Apps Consultant

Responsibilities:

• Develop PL/SQL packages, procedures and functions
• Extensive experience in development of various interfaces like Auto Invoice Interface and Customer Interface for AR.
• Customized various transactions in Accounts Receivables like Invoices, Receipts, and Credit Memos and Debit Memos etc.
• Worked on AR Invoice printing programs.
• Extensively worked with Open Interfaces in AR to create invoices from external feeder system through Auto Invoice and create receipts through Auto Lock box.
• Supported the TAR’s on AP, AR related APIs performance and bugs handling.
• Developed interfaces to load the GL Data from legacy system into GL JE BATCHES, GL JE HEADERS and GL JE LINES base tables using journal import concurrent program.
• Developed and implemented AP Invoice interface. This involved importing data from the legacy system into staging tables using SQL*Loader, validating the data using PL/SQL procedure, inserting data into interface tables and running the invoice import concurrent program to load the data into oracle AP tables.
• Developed SQL*loader and PL/SQL programs for importing AP invoice data file into staging tables and for validating imported data file.
• Developed GL code combinations outbound interface
• Developed checks information outbound interface
• Developed inbound interface program to load data in to AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE
• Developed custom program to call the standard payables open interface import to load data from payables interface tables to oracle base tables.
• Developed custom program to create attachments for invoices
• Developed BI Publisher reports with outputs as excel (tabbed sheets),
• Pixel perfect pdf’s, graphic rich flash reports.
• Present BI Publisher reports on OBIEE Dashboard.
• Create database MVs for quicker rendering of BI Publisher Reports.
• Scheduled BI Publisher excel outputs into shared locations as well as users emails.
• Created Warranty Returns Report with over 50 display fields in this pdf report.
• Created the hierarchies, drills and level-based measures on different dimensions in the repository.
• Worked efficiently in creating the session variables and also the assigning the security groups and users. Also, worked on the data-level security to restrict the data to certain groups of users.
• Worked closely in migrating the Security Groups, Id’s, Users Confidential the time of migration along with catalog.
• Also applied the different OBI Patches both on the Windows and Linux boxes.
• Worked on performance tuning on dashboard and BI Publisher reports working closely with the database developers on indexes and tuning the data in the tables with the appropriate facts and dimension measure in the tables.
• Performed Unit and Regression testing on all the reports developed to maintain consistency and efficiency to meet the user’s requirement.
• Documented all the Technical Specification Documents for VZW and Lost /Stolen Projects as well as worked with analysts for the Functional Design Documentations as well.
• Efficiently co-ordinate with the offshore team in taking the requirements between the client and team efficiently and meeting the deadlines and the deliverables on time.

Environment: Oracle Apps R12,OBIEE 10.1.3.4. Oracle BI Publisher, Oracle 10g, TOAD, SQL Navigator, Windows XP, Linux.

Confidential, Washington, DC

Sr.Oracle Apps Developer

Responsibilities:

• Developed sql*loader control files to load the flat file Into intermediary tables finally into RA CUSTOMERS INTERFACE ALL,RA CUSTOMER PROFILES INTERFACE ALL Interacted with the employees and managers of the different Departments and gather the existing data and to understand the system of Oracle Financials, finally preparing the interface data model
• Developed interfaces to load the GL Data from legacy system into GL JE BATCHES, GL JE HEADERS and GL JE LINES base tables using journal import concurrent program.
• Involved in complete GL Balance Conversion, GL-AR balancing process (journal entries), and maintaining the GL sync with AR.
• Worked on Fixed Assets Mass External Retirement Interface in Fixed Assets Module (FA).
• Used Import Standard Purchase Orders and Receiving Transaction Processor interface programs to create purchase orders and receipts in Oracle Purchasing.
• Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas
• Added Aggregate measures using Aggregate Persistence Wizard
• Enabled Usage Tracking Table and Dashboards
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache
• Designed Interactive Dashboards and created dashboard prompts with multiple selections
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
• Involved in Requirement Analysis, Data Mapping and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation

Environment: Oracle 11i,Business Intelligence 10.1.3.4, Oracle 10g, Oracle Warehouse Builder 10g R2, Informatica Power center 8.1, Microsoft Windows Server 2003, SQL, PL/SQL, Linux, UNIX

Confidential, Memphis,TN

Sr.Oracle Apps Technical Developer

Responsibilities:

• Involved in Upgradation of 11i to R12
• Designed and documented the technical specifications of an Interface (MD70) using the available functional specification (MD 60) as per AIM.
• Prepared the conversion strategy and managed Conversions. Involved in identifying the data sources, mapping the data, design and develop the feeder system using SQL*Loader and PL/SQL and implementing the conversion.
• Developed Order Management, Payables (GL) and Receivables queries to compare summary information of the standard and custom reports.
• Designed the Subledger to GL Recon Report for both AR and AP.
• Developed custom PL/SQL program for loading AP Invoices using Oracle Standard AP Invoice Interface.
• Also developed a custom interface, to send payment information from AP (Payables) to external system.
• Customized standard Report RAXINVR for Printing New Invoices, maintaining the functionality of 11i.
• Customized Standard Report RAXINVRT for Printing Selected Invoices using Real Time Data, maintaining the functionality of 11i.
• Customized Standard Report RAXINV for Printing Selected Invoices and Print/Reprint Selected Invoices maintaining the functionality of 11i.
• Developed a script to exchange sites info in AP from one Operating Unit to another.
• Imported Journals from a legacy system into Oracle GL.
• Developed a new Oracle Report for AP Journal voucher.
• Customized AP Check report in accordance to clients check printing stationary.
• Customized Report for Cash/Bank Book Report.
• Involved in writing the Conversion Documents of GL and AP for the Data conversions from the Legacy.
• Oracle Inventory provides Customer Item Open Interface/conversion to easily import Customer Items from external systems to Oracle Applications
• Created SQL* Loader scripts to load data from legacy systems to Oracle Apps.
• Expertise in testing the flow of Order to Cash and Procure to Pay cycles.
• Developed a PL/SQL package for populating custom tables with cost of goods sold data. The data from Inventory (INV), PO and AP is tied back to GL and the details are gathered to populate the tables.
• As per the company requirements, created and implemented XML Publisher reports for different products like AP, AR and GL.
• Customized some of the Reports using Xml publisher like Check printing, Bank Statement in AP, Customer Statement, Invoice Printing, Dunning Report in AR, Order/Invoice Detail in OM & RMA, in transit reports in INV.
• Registered the Templates and Data Definitions using XML Publisher Administrator responsibility.
• Worked on performance tuning of various views/tables for better report execution time.
• Created Request Groups and Value sets for reports.
• Developed the AOL forms using the TEMPLATE.fmb and built the code as per the AOL coding standards.
• Design and Development of Serialization solution by creating ZOOM forms Confidential the time of Receipt, Move order and Shipment.
• Extended self-service applications usingOA Framework.
• As a Production support analyst solved issues related to AR, AP, GL, OM and INV.
• Performance Tuning of Custom PL/SQL Packages and Standard Oracle APIs.
• Developed new reports using Report Builder 6i/9i and also customized seeded reports in order management module.

Environment: Oracle Applications R12 (AP,AR, GL) modules, Oracle Database 11g, Forms 6i/10g, Reports 6i/10g, Discoverer9i/10g,XML/BI Publisher, JDeveloper,Workflow Builder,PL/SQL, UNIX, SQL *Loader.

Confidential, Pittsburgh, PA

Sr. Oracle Apps Technical Consultant

Responsibilities:

• To prepare MD.070 design documents for Inbound and custom programs
• Used SQL* Loader and UTL FILE Packages for data conversion and interfaces.
• Developed custom PL/SQL program for loading AP Invoices using Oracle Standard AP Invoice Interface.
• Developed custom PL/SQL conversion program for loading GL Balances using Oracle Standard GL Interface program.
• GL interfaced legacy system is used for Journal Import. GL JE BATCHES, GL JE HEADERS and GL JE LINES transaction tables are used to run Journal Import using PL/SQL.
• Worked on Interfaces for Journal Import (GL) and Budget Upload (GL).
• Defined the descriptive flex fields and key flex fields.
• Created Value sets for report parameters and registered in application using AOL.
• Worked on Auto Lockbox Open Interface for automatic processing of receipts in AR module of Apps based on electronic bank statement data.
• Developed PL/SQL Package to check data in the auto lockbox tables for compatibility with receivables and transfer the data into Quick Cash tables for the application receipts to the corresponding open transaction & update customer's balances.
• Expertise in Creating and managing customers Using TCA (Trading Community Architecture) in AR module.
• Developed a custom reports for summarizing AP expense report expenditures by department and customized Check Printing Report in AP module.
• Wrote UNIX shell scripts to automate the conversion from the legacy systems, to ftp the files to the legacy systems and to send error message notifications to the user groups.
• Performed Tuning using Explain Plan, Tkprof, Hints and Indexes. Used TOAD, PL/SQL developer tools for faster application development
• Implementation of business specific custom programs by writing PL/SQL stored procedures and UNIXscripting.
• Customized various reports in AP Module including the following:
• Supplier Payment History Report (AP)
• Invoice Aging Report (AP).
• Involved in reports generation and customization using reports 10g.
• Changes done to Amendments form using Form Builder 10g to amend unit prices in bulk.
• Customized several forms using Custom.pll and Forms Personalization.
• Developed customer invoice, Purchase Order Report using XML Publisher
• Was involved in Application System Administration activities like managing concurrent managers, application user set up, defining responsibilities, value sets, flex fields, registering menus and providing support to Apps end users.
• Helping the users test the application and testing from development point of view. Also was responsible for End-to-End Testing.

Environment: Oracle Apps11.5.10(GL, FA, AP, AR, PO, Pricing, OM,),Oracle 9i/10g, Database, PL/SQL, SQL Navigator, Bulk Loader, Oracle Reports 6i/10g,Oracle Forms 6i/10g,Workflow Builder 2.6, Developer 2000, UNIX Shell scripting, Discoverer, XML/BI Publisher.