SUMMARY

• Over (8) eight years of IT experience in Software Development, includes System Study, Design, Development and Post implementation maintenance and support of Oracle Applications eBusiness Suite 11i and R12.
• Specialized in the technical aspects of General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Purchasing (PO), Order Management (OM), Advanced Pricing (QP), Cash Management (CM), Bill of Materials (BOM), Work in Process (WIP), Shipping (WMS), and Inventory (INV) modules of Oracle Applications.
• Strong working knowledge of development tools such as PL/SQL, Oracle Forms 6i/9i/10g and Reports 6i/9i/10g, Workflow Builder, XML Publisher and have rich experience in RICEW (Reports, Interfaces, Conversions, Extensions & Workflow) components.
• Possesses an in depth knowledge on Business Flows of Order to Cash and Procure to Pay.
• Expertise in preparing User Manuals Technical Design Document (MD070) and Conversion Document (CV060).
• Well versed with design and development using Application Object Library (AOL) concepts such as Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters.
• Extensively worked on Performance tuning using Optimizer Hints, SQL Trace, TK - Prof and Explain Plan.
• Good Exposure to Oracle database Architecture, RDBMS Concepts and Oracle database management.
• Experienced at creating effective Test data and developing thorough Unit test cases to ensure successful execution of the data.
• Excellent organizational, leadership, team building, public speaking, and project management qualifications.
• Strong analytical and problem solving skills and a proven ability to be an effective team player with excellent time management skills.
• Exceptional Communicator - can effectively present ideas and concepts to upper management in a clear and concise manner.
• Experienced in working with clients from various backgrounds.

TECHNICAL SKILLS

ERP Versions: Oracle Applications R12/11i.

ERP Modules: Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets (FA), Purchasing (PO), Order Management (OM), Advanced Pricing (QP), Cash Management (CM), Bill of Materials (BOM), Work in Process (WIP), Shipping (WMS) and Inventory (INV).

Languages: C, JAVA, SQL, PL/SQL, Shell Scripting.

Tools: TOAD, SQL*Loader, Reports 6i/9i/10g, Forms 6i/9i/10g, XML Publisher, Workflow Builder, STAT

RDBMS: Oracle 10g/9i, SQL Server, and Ms-Access.

Web Technologies: HTML, XML, Java Script, and CSS.

Software Tools: Ms-Office, Photoshop, Dream weaver.

Operating Systems: Windows XP/NT/2000/98/95, DOS 6.0/3.0, UNIX, Linux, Windows server 2003 and Windows 7.

PROFESSIONAL EXPERIENCE

Confidential, PORTLAND, OR

Sr. Oracle Developer

Responsibilities:

• Responsible for the design, development and maintenance of modifications/customizations of the Oracle Applications eBusiness suite (Forms, Reports, PL/SQL, Discoverer queries) and deploying such modification/customization in Oracle eBusiness environment.
• Responsible for the maintenance of interfaces to and from the Oracle E-Business Applications and external applications.
• Participated in process analysis, design, mapping, and gap analysis.
• Developed technical design and documentation of Oracle Applications dependent interfaces, custom reporting, and custom applications including use of documented revision control.
• Created DB Links and Synonyms to connect the APEX Application Database to different databases.
• Developed Interactive Reports, Data Entry Forms, Hypertext Linked Reports using Oracle APEX 4.0
• Designed and Developed Customer Statements in Multiple Languages.
• Developed Customer Aged Analysis Summary and Detailed Reports.
• Customized BBBEE Vendors Spending Report and Supplier Listing Report.
• Managed and resolved Oracle TAR's with Oracle Support.
• Managed and resolved service tickets for internal customers.
• Responsible for the resolution & troubleshooting of issues during development and post production support.
• Created test scripts and performed unit testing.
• Resolved bug fixes within the SLAs outlined.
• Provided quality deliverables in aggressive timelines.

Environment: Oracle Applications R12 (12.1.2), AP, AR, GL, PO, Oracle RDBMS 11g, Forms 9i/10g and Reports 9i/10g, APEX, UNIX, TOAD and STAT.

Confidential, ANDOVER, MA

Techno Functional Consultant

Responsibilities:

• Coordinated with client to understand business requirements and translated them into technical specifications.
• Participated in CRPs to make sure program design are in line with business requirements.
• As an onsite coordinator my role was to understand business requirements from client, communicate to offshore team.
• Tracking all development activities and provide updates to the client on daily basis.
• Development of RICE Objects and co-ordinate the development objectives among the team members.
• As an additional organizational initiative I got Hands on few Vendor conversions (Include Vendor, Sites, Contacts) in AP Module.
• Designed, developed and deployed users friendly Customized Reports to serve important business processes very specific to the client.
• Such reports include Customer Invoice Report and What if Shortage Report.
• Customized the following reports using XML Publisher.
• Sales Order Acknowledgement Report.
• Pack slip Report.
• Commercial Invoice Report.
• Repair Report and
• Repair Estimate Report.
• Involved in customizing the forms for adding extra information through DFF’s.
• Customized the CUSTOM.PLL library to enable the zoom functionality.
• Analyzed the root cause of repetitive issues and proposed an action plan for improvement to the management with work around.
• Responsible for supporting, maintaining and enhancing the Oracle e-Business Suite Applications for Manufacturing module.
• Worked with the end users to ensure resolution of Service tickets or Incidents and provided on call support.
• Helped creating weekly metrics and owning the status reporting with the users and other stakeholders
• Managed the monitoring, follow-up and resolution of outstanding Service Requests with Oracle.

Environment: Oracle Applications11i, AP, OM, PO, BOM, WIP, INV, Oracle RDBMS 10g, Forms 6i and Reports 6i, UNIX, and Sql Loader.

Confidential, HOUSTON, TX

Technical Consultant

Responsibilities:

• Design, Documented (MD070, CV060) and developed Staging tables, Conversion routines, Custom PL/SQL API’s for converting
• Suppliers, Supplier Sites, Supplier Contacts
• Customers into Oracle Applications
• Developed and customized Financial Modules (AP, GL, AR, CM, PO), Interacted with end users to gather requirements and Draft specifications for development Phase.
• Worked on Auto Lockbox interface between Confidential and Account Receivable (AR) module for automatically processing receipts that are sent directly to the bank instead of manually feeding them in Oracle Receivables.
• Designed, documented and developed interface between Confidential and Cash Management (CM) module for uploading Bank statements.
• Customized the following reports using XML Publisher.
• Purchase Order Report.
• Request For Quote (RFQ) Report.
• Posted Payment Register.
• Unaccounted Transaction Report and
• Consolidation Journal Report.
• Developed Custom Reports for Billing History by Client, Invoices by Client Report and Projects NDR Report using Reports9i.
• Designed and developed new Form using TEMPLATE.fmb for Purchase Returns irrespective of Purchase Order Number.
• Did forms personalization to make view only forms.
• Customized the Accounts Payable (AP) Vendor Entry Form as per business requirements.
• Involved in Workflow administration for processing Requisition and Purchase orders.
• Designed and developed new workflow to send email notification to group of people when modifications to Item Attributes, or Modifications to Customer Address, or Modifications to Supplier Address.

Environment: Oracle Applications R12, AP, AR, CM, GL, PO, Oracle RDBMS 10g, Forms 9i/10g and Reports 9i/10g, UNIX, and Sql Loader.

Confidential, RICHMOND, VA

Techno-functional Consultant

Responsibilities:

• Involved with study of existing system, preparing the Technical (MD070) design document and Conversion Document (CV060) to extract data from legacy system into Oracle Applications open interface tables.
• Designed, documented and developed staging tables, conversion routines, Custom PL/SQL API’s for converting Purchase orders (PO), AP Invoices, AR Invoices, Bank branches and Bank accounts from legacy system (Mainframe) to Oracle Applications.
• Designed and developed an interface between third party billing system (INTUIT) and Oracle Receivables (AR) to load external invoices data on daily basis. Used SQL*Loader to import INTUIT invoices into Staging tables, and developed PL/SQL API for complete validation of data and inserting into Interface tables.
• Run the Invoice Inbound Program (INI), an E-Commerce interface program to import supplier invoices into Oracle Payables for manual and or electronic payments
• Designed, documented and developed an Interface between web based Order Management systems ODYSSEY to Oracle Order Management for Creation of Sales Order.
• Where I developed an UNIX shell script, which calls SQL Loader program to load data into custom staging tables and checks for uniqueness of the files in UNIX directory to avoid duplicates.
• Developed and customized the following reports using XML Publisher
• Accrual Reconciliation Report
• GL Trial Balance report
• Developed Dunning Letters and emailed to customer.
• Reports in different responsibilities like receivables and purchasing.
• Journal Entries Report in AR.
• Customized the following forms
• Customer Standard form
• Invoices form in AP and
• Transactions form in AR.
• Customized the following workflows
• Cost of Goods Sold (COGS) workflow.
• Order and Line workflow to send Email notifications when the line total crosses certain amount.
• AR Invoice Approval workflow.
• Responsible for providing production support for Fixed Assets (FA) and Account Payables (AP).

Environment: Oracle Applications 11i, AP, AR, GL, OM, PO, FA, PL/SQL, TOAD, Forms 9i/10g and Reports 9i/10g, SQL*Loader, SQL*Plus, UNIX, Shell scripts.

Confidential, DAYTONA BEACH, FL

Oracle Applications Techno Functional Consultant

Responsibilities:

• Worked on the conversion of Open AR Invoices from legacy to oracle using Auto Invoice import program.
• Worked on the conversion of GL balances from legacy to oracle using Journal import.
• Defined price lists, modifiers, qualifiers and qualifier groups in pricing.
• Worked on the conversion of Price List headers and Pricing qualifiers from legacy system.
• Worked on AR aging Report (4- Bucket and 7-Bucket) based on Invoice, Customer, Customer Site, Parent party and Collectors.
• Worked on Deferred AP Reconciliation Report and PO Fax Details Report.
• Worked on customizing standard Supplier Payment History Report in AP as per client requirements.
• Worked on customizing the following reports in INV, AR and PO using BI/XML Publisher
• Inactive Items report
• Account Status Report
• Billing History Report
• Purchase Order Detail Report
• Worked on Requisition Account Generator workflow as per client requirements.
• Developed PL/SQL Procedures to validate items for open item interface in Inventory according to business requirements.
• Used FNDLOAD, WFLOAD utilities to move Concurrent Programs, Value Sets, Request Groups, Request Sets and Workflows from one environment to another.
• Involved in performance tuning of AR Aging Report Queries using TKPROF and Explain plan utility (TOAD).

Environment: Oracle Applications 11i, GL, AP, AR, QP, OM, INV, PO, Oracle 9i, SQL, PL/SQL, SQL *Loader, TOAD, Reports 9i, Workflow, XML Publisher, UNIX and Windows.

Confidential

Oracle Team Lead/ Analyst

Responsibilities:

• Responsible for developing and customizing Reports and concurrent programs as per the client requirements in Oracle Apps 11i PO module.
• Registration of concurrent programs, defining value sets and parameters for customer reports.
• Development and modification of user friendly Oracle Forms and Reports for inventory procedures, stock ledger processing and management reporting etc.
• Using Forms 6i and Reports 6i and PL/SQL etc.
• Created Complex PL/SQL Stored procedures, functions, Triggers.
• Designed Data flow diagrams, E-R diagrams, Data structure, Tables, triggers, indexes, constraints etc. using SQL, PL/SQL, TOAD, SQL*plus etc.
• Modification and addition of Forms and Reports with new business requirements, Migration from older version to Forms & Reports 6i.
• Unit integration and testing, User training and troubleshooting.
• Import and Export of data between instances and schemas and data loading using SQL*loader.
• Analyzing the performance of application and made recommendations to improve performance.
• Continuous interaction with users and understanding user requirements. Modification and creation of forms and reports with new business requirements.
• With extensive use of timers, time conditions and alerts, developed various auto updateable forms and reports that displayed current information without manual interruption.
• Registering applications and managing forms and reports in 9i application server.
• Preparation of SDLC docs- Requirement specs, Design doc, Test cases.

Environment: Oracle Apps 11i, INV, PO, GL, Oracle 9i, Forms 6i/9i, Reports 6i/9i, PL/SQL, SQL, AOL, TOAD, SQL*plus, MS-office suite etc. on Unix Sun Solaris.

Confidential

Technical Developer

Responsibilities:

• Coordinated with client to understand business requirements and translate them into technical specifications.
• Developed Generic Packages using PL/SQL to build flat files to manage transmissions across Legacy and Oracle Systems.
• Developed Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables to store legacy data and to maintain data for staging interim phase.
• Developed SQL Loader control scripts to process the legacy data and to load them into Temp Staging Area.
• Developed an interface to calculate and in corporate the total cost incurred for sale of an item.
• Using this interface the information is compiled from Order Management, Receivables, Inventory modules and cost is calculated.
• Developed customized reports for showing total revenues, total costs and gross profits against each sales representative and their respective managers.
• Developed the price list report for Order Management for checking the products in various pricelists and expanding the items to option class and options using Bill of Materials (BOM).
• Customized the following reports in BOM and WIP
• Discrete Job Listing Report
• Discrete Job Value Report
• Bill of Material Comparison Report
• Bill of Material Parameters Report
• Deployed several users friendly Customized Oracle Forms and Reports for various Shipping functionalities.
• Post-Implementation production support.

Environment: Oracle applications 11i, AR, BOM, INV, WIP, OM, WMS, Reports 6i/9i, Forms 6i/9i, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell Scripts.