PROFESSIONAL SUMMARY:

• 9+ years of total work experience with core expertise on Oracle E - Business Suite R12/11i analysis, design, development and implementation of database applications and solutions
• Experience working in Financial and Hospitality organizations
• Extensive technical and functional experience in Procure-to-pay (P2P) and Order-to-Cash (O2C) cycles
• Strong setup and testing skills of Oracle Financials modules
• Experience customizing OAF objects, performing pre and post validations, and providing post upgrade support for R12.2.4 version upgrade
• Led multiple projects during upgrade and enhancement phase to successful completion
• Exceptional skills in Agile Development and Test Driven Development
• Experience on setup and configuration of iCatalog store
• Experience on configuring AME setup for Purchase Requisition Approval and Invoice Approval transaction types
• Experience on customizing OAF Controller and View objects using Java skills
• Customized Oracle standard E-business suite applications in GL, AP, AR, PO, FA, CM and iProc modules to suite business requirements
• Good exposure to Revenue accounting and reporting engine, EBTax and SLA
• Solid knowledge of Application tables, Schema, Interfaces, APIs, TCA, MOAC secondary and reporting currencies Ledger
• Excellent skills in designing and development of applications using Oracle 11g/10g/9i, SQL, PLSQL, Oracle Forms 9i/6i, Oracle Reports 9i/6i and UNIX Shell Scripting
• Expert in the development of CEMLI, RICEW components
• Experience implementing PGP encryption around secure data files with PKZip PGP tool
• Worked extensively on Ref cursor, External Tables and Collections
• Extensive experience in developing Inbound/ Outbound interfaces using PLSQL
• Good experience on performance tuning (PL/SQL) using SQL Trace, Explain Plan Indexing and Hint
• Developed test scripts and test cases to perform Unit Testing, System Testing and Load Testing
• Experience working in Warehouse management System (WMS) and extensive experience in EBS Logistics
• Extensive experience in production support, on-call issue resolution, new implementation and application enhancements/customizations
• Good experience in development of functional/technical design documents
• Ability to work individually as well as in a team with excellent problem solving and trouble shooting capabilities
• Self-motivated and committed person with excellent interpersonal communication skills and willingness to learn new tools, concepts and environments.

TECHNICAL SKILLS:

ERP: Oracle iProcurement, Oracle Payables, Oracle Purchasing, Oracle Fixed Assets, Oracle Receivables, Oracle General Ledger, Oracle Cash Management, Application Object Library

Databases: Oracle 11g/10g/9i, MS Access 2000

GUI: Forms 9i/6i, OAF using JDeveloper 10g

Reporting Tools: Reports 9i/6i, Oracle BI publisher/XML Publisher

Integration Tools: BPEL using JDeveloper 9i

Languages: C, Java, SQL, PL/SQL, Unix Shell Scripting

Web Technologies: J2EE, HTML, XML, JavaScript, Servlets, JSPs

Operating Systems: Windows 2000/ NT/XP/7/8(beta), Unix, Linux

Specific Tools: Workflow Builder 2.6, SQL Loader, TOAD 8.5, Jdeveloper 10g, Pro*C, SQL Navigator, SQL*Plus, iSQL*Plus, Oracle ADI, Translation Builder and OA Extension (OAF self service pages), Microsoft Visio

Utilities: IE, Mozilla, Putty, Winscp, Perforce, VSS

Specialty Tools: PKZIP PGP encryption tool

PROFESSIONAL EXPERIENCE:

Confidential, Houston TX

Lead Consultant/ Sr. Applications Developer

Responsibilities:

• Led team of 3 offshore developers for R12 upgrade and enhancement projects
• Led and successfully implemented Cash Management module and iCatalog store
• Techno-Functional consultant for R12.1.3 enhancements, R12.2.4 upgrade and enhancements
• Designed and developed OAF customizations for Shopping Cart, Edit and Submit, and Update Single Line pages in iProcurement module during R12.2.4 upgrade project
• Worked extensively on setting up and modifying AME rules for PO Requisition approval and Invoice approval transaction types
• Worked on setting up audit trail on AP standard tables and developed a custom report to capture payment changes at supplier and site level
• Analyzed and interpreted business requirements to develop high level designs and participated in Functional spec/Technical spec review meetings with other team members
• Led the project and worked with third party Vendors to implement PGP encryption and decryption to secure data files
• Implemented custom logic in RTF template to dynamically print “VOID” text as watermark on face of a check when printing from non-production instance
• Incorporated custom logic in Invoice approval, PO approval and PO Requisition approval workflow using Workflow Builder 2.6
• Designed and developed custom process to bulk import and update assets in the application using standard Fixed Asset (FA)API’s, and customized Assets Addition and Assets Register report to suit business requirement
• Responsible for designing and developing interfaces for loading data from external systems into Oracle EBS application
• Developed custom reports using XML publisher and SQL, and implemented XML bursting to automatically send report outputs to the users
• Good understanding of procure-to-pay and order-to-cash cycle
• Responsible for fine tuning performance of long running reports like GL Account analysis custom report
• Created MD70 (Technical reference document) for all major enhancement requirements
• Created MD50 (Functional reference document) for icatalog implementation
• Responsible for development of CEMLI, RICEW components
• Present demos to business users on major implementations and enhancements
• Involve in handling production issues
• Perform testing and prepare test cases

Environment: Oracle E-Business Suite R12.2.4 Version Upgrade, Oracle EBS R12 iProc, AP, PO, FA, CM; Oracle 11g/10g, SQL, PLSQL, UNIX, OAF extensions with Jdeveloper 10g, XML Publisher, PKZIP PGP tool, Workflow builder, TOAD, VSS, WinScp, Putty

Confidential, Houston, TX

Tech Lead/ Applications Developer

Responsibilities:

• Technical lead for Confidential - Confidential back end integration project
• Developed PL/SQL program for processing the Data for customer validation and insertion into AR interface tables
• Designed and developed inbound and outbound interfaces to transact merchant information
• Developed custom reports to extract information from AR, INV and OM
• Developed sources to process CP2100 files from IRS, issue BNotices to merchants and withhold payments of out of compliance merchants
• Developed outbound interfaces for extracting new merchant information from Oracle EBS and FTP to data warehouse
• Designed and developed PLSQL stored procedures, functions and packages for validating inbound merchant information and exporting to data ware house
• Configuring Warehouse Management system (WMS) with Inbound & Outbound logistics, Storage and Facility management specifically staging warehouse locations in receiving hazardous storage materials (dye chemicals).
• Developed a custom process to periodically capture long running programs and all the programs that ended in error, and send the report to an email distribution list
• Enhanced and supported monthly run of Merchant’s Billing Statement
• Extensively used bulk collections for faster retrieval of data and better performance
• Developed interface programs to setup new customers in AR
• Involved in developing UNIX shell scripts to process merchant monthly data and generate statements
• Developed a custom form to process merchant address information using Oracle Forms Builder 6i
• Good exposure to Revenue accounting engine
• Developed PLSQL scripts for extracting merchant statement print information into flat files using UTL FILE package
• Used extensively advanced features of PLSQL like Records, Tables and Dynamic SQL

Environment: Oracle EBS 11i AR, INV, OM; Oracle 11g/10g, SQL, PLSQL, UNIX, Microsoft VISIO 2007, Forms 6i, TOAD, VSS

Confidential, Springfield, MO

Student Worker

Responsibilities:

• Provided attentive customer service
• Was responsible for training new joinees

Confidential

Sr. Systems Analyst

Responsibilities:

• Responsible for the development of conversions/interface programs to AR and GL
• Worked on Auto Invoice, Auto Lockbox, and Customer Interfaces in AR module
• Developed custom reports and forms using Reports 6i and Forms 6i
• Created database objects like Tables, Views, Materialized Views, Procedures and Packages using Oracle utilities like PLSQL, SQL*Plus, SQL*Loader and handled exceptions
• Participated in performance tuning using Explain Plan and TKProf
• Developed Pro*C programs to generate the usage report from database
• Developed shell scripts for automating the execution process
• Involved in gathering client requirements
• Provided estimates for all technical components
• Responsible for design and development of technical data flow charts
• Prepared technical design documents and test case documents
• Involved in code review, code migration and code test

Environment: Oracle Applications 11.5.10.2 - AR, GL; Oracle 9i, PLSQL, TOAD, SQL, Forms/ Reports 6i, Pro*C

Confidential

Systems Analyst

Responsibilities:

• Developed interfaces and reports for GL and AR
• Designed and developed a custom OAF page replicating customer screen for OAF customization’s pilot project
• Prepared MD50, MD70 and test case documents for nTAS (new archival system) project
• Performed gap analysis, and customized reports and PL/SQL program in order to fulfill the requirement necessary to integrate with FileNet
• Implemented document retrieval functionality in EBS 11i using FileNet API
• Developed customized reports using Oracle Developer 6i/9i and OBIEE
• Experienced in the usage of Explain Plan, Analyze and Hints to tune SQL queries
• Responsible for development of technical process flow charts

Environment: Oracle EBS R12/11i, GL, AR; Oracle 8i, Forms /Reports 6i, OBIEE, FileNet, AIX UNIX

Confidential

Systems Analyst

Responsibilities:

• Gather requirement and perform GAP analysis
• Trouble shooting technical and functional issues in AR and CM
• Responsible for technical analysis and development of RICE components in AR
• Providing data correction scripts for functional related issues
• Responsible for new development and change requests in custom modules
• Responsible for developing new customized Oracle forms, Oracle reports, self service pages using OAF, interfaces (text files, XML files), XML Publisher Reports, Concurrent programs using shell scripts
• Address operational problems, concerns, and questions posed by the business users
• Raise Service Request’s with Oracle for the resolution of standard issues in the application

Environment: EBS 11.5.10.2, AR, CM, Oracle 8i, PLSQL, XML Publisher, JDeveloper 10g