PROFESSIONAL SUMMARY:

• Ten years of experience in various phases of Software Development life cycle including design, development, testing.
• Extensive experience in interacting with business users, analyzing client business processes, documenting business requirements, performing design analysis, developing technical design specifications and performing code reviews.
• Experience in software development using agile and test driven methodologies.
• Extensive working knowledge in Energy, Supply Chain Management and Financial domains.
• Experience in Oracle E - Business Suite R12/11i development experience in various modules i.e. Oracle Inventory, Order Management, Oracle Shipping, Advanced Pricing, Oracle Payables, Oracle Purchasing, Oracle Receivables, Oracle General Ledger, Oracle Fixed Assets and Oracle Project Accounting.
• Extensive programming knowledge in Oracle 12c,11g/10g/9i, PL/SQL, UNIX.
• Experience in developing business process workflows using Oracle Workflow Builder.
• Experience is developing test scripts for UAT and BAT.
• Experience in customizing Oracle applications with Custom.pll library, Forms personalization, Template.fmb to create new functionality to the application.
• Experience in Application Object Library (AOL)such as creating custom responsibilities, custom menus, menus exclusion, form functions, Concurrent programs, creating value sets, profile options, messages, look ups, list of values, Flex Fields.
• Experience in customization and developing forms and reports as per the business requirements using Oracle Forms 10g/6i and Reports 10g/6i and Alerts.

TECHNICAL SKILLS:

ERP: E-Business suite 11i, R12.1.3

ETL Tools: Informatica, SQL *Loader, ODI

Development Tools: Oracle BI Publisher, Reports & Forms 6i/10g, Discoverer 4i/10g, Developer 2000, Workflow Builder 2.6, JDeveloper, Oracle Application Framework (OAF - 10.1.3.3)

Database Tools: SQL*PLUS, SQL*Loader, TOAD, PL/SQL Developer

RDBMS: Oracle 9i/10g/11g/12c

Languages: UNIX, PL/SQL, XML, JAVA, JSP

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle Financials Developer

Responsibilities:

• Extensively worked on Purchasing document approval, Supplier and Payment setups.
• Extended seeded view objects and personalized OAF pages in Payables and Receivables modules to provide record history feature in R12.
• Implemented custom password validation logic using java and Signon Password Custom profile option.
• Designed and implemented Automated PO Encumbrance Relief process.
• Developed Positive pay process (extract) for Wachovia Bank.
• Designed and implemented Month End Accrual process to generate reports and to post journals.
• Implemented custom program to update supplier business classification status.
• Implemented Customer import program to load customers form PENN ERA system in to Oracle Receivables.
• Designed and developed supplier maintenance programs to disable one time vendors, identify duplicate suppliers.
• Implemented Auto lockbox processing scripts to gather, validate and load lockbox files into Receivables and email reports to users using UNIX, PL/SQL, UTL FILE.
• Implemented custom program to synchronize enabled/ disabled code combination segment values in the application with GL code combinations.
• Implemented various customization in GL using forms personalization's and custom profile options to allow back posting for specific group of users.
• Implemented custom process to mass assign responsibilities to 900+ users in production.
• Developed custom reports using Oracle BI Publisher.
• Designed and developed a custom process using PL/SQL, SQL *Loader and UNIX to validate account segments that gets loaded into Oracle Hyperion system from Data warehouse.
• Participated in year activates like Dual year processing for Ben Financials and Budget load for loading budget from Planning Hyperion into Ben Financials.
• Coordinated with Oracle Support for several patches and data fixes.
• Involved in extensive performance tuning several custom processes and Oracle reports using indexes, global temporary tables, Tkprof, Explain Plan, partition pruning and Bulk Processing.

Environment: Oracle EBS12.1.3,iProcurement, iSupplier, PO, AP, IBY, AR, GL, Oracle Grants, JDeveloper 10, OAF, Oracle BI Publisher, Reports 10g, Forms 10g, Oracle 11g/12c, PL/SQL, UNIX, Change Man.

Confidential, Rockville, MD

Oracle EBS Developer

Responsibilities:

• Extensively worked with Panaya upgrade automation tool to retro-fit CEMLI objects from 11.5.10.2. to R 12.1.3
• Involved in Requirement Analysis and Client Interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec)
• Worked on various GL ledger, Purchasing approvals, Mass allocations setups for 12.1.3.
• Extensively worked on customizing Purchase Order approval workflow to let users access documents attached to the Purchase Order from the approval notification email itself.
• Customizing Purchase Order approval workflow to send email notifications to requestor of service when a PO is approved along with a copy of PO as PDF attachment to the email.
• Used TCA APIs for customer conversion for customers, addresses, contacts and contact points.
• Developed several Event based Alerts to notify the owner when certain holds are removed from Sales Order.
• Modified the payments module IBY EXTRACT EXT PUB package to customize Outbound Payment Instruction as part of R12 upgrade.
• Designed and developed an interface between custom.net based ordering portal and OM to transfer orders in to Oracle SCM.
• Worked with standard shipping module (WSH) API’s to fulfill orders that are shipped from warehouse to close the cycle in SCM.
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program.
• Developed Item conversion program for assigning Items to Item category set and Categories.
• Involved in entering transactions like Regular Orders, Inter Company Invoicing, Regular Invoicing, Invoicing with Rules and different methods of Receipt Processing and application in OM.
• Involved in customizing standard forms using Custom.pll.
• Personalized Sales Order entry form to restrict the order type LOV based on the responsibility.
• Created scripts to load Projects, Budgets and Agreements.
• Worked on CO, VO extensions for Requisition workflow OAF customizations.
• Retrofitted forms personalization’s from 11i in R12 for customer page by extending CO and VO in OAF pages.
• Developed reports using XML Publisher.
• Used FNDLOAD to download and upload AOL data from one instance to another instance.

Environment: Oracle EBS 12.1.3/ 11.5.10.2, Oracle Forms 6i/10g, Reports 6i/10g, Discoverer 10g, Oracle 11g, PL/SQL, XML Publisher, PL/SQL Developer, JDeveloper, UNIX, Panaya.

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• Used Agile and test driven development methodologies.
• Participated in Functional Design reviews and technical code reviews.
• Prepared technical design specifications and impact analysis documents.
• Involved in database modeling, database design and Normalization of tables.
• Involved in design and development of the settlements estimate architecture. Implement 30+ settlement estimate algorithms using PL/SQL that allow NMarket participants to settle invoices with CAISO.
• Implemented generation offers, bids and schedules life cycle business logic using PL/SQL for transaction manager UI.
• Developed several PL/SQL interfaces to for NMarket using SQL* Loader, XML style sheets, global temporary tables.
• Implemented custom debugging module for NMarket software using PL/SQL.
• Created Packaged procedures, pipelined table functions required to implement the validation SQL‘s required for the Hierarchical data load in various tables.
• Proposed and Implemented rebuilding indexes online on the tables which were slowing down because of referential and index constraints on the tables.
• Involved in Writing Complex Hierarchical queries using clauses such as Connect by Prior, PIVOT, Analytical functions such as (Rank, Dense Rank, Lead, Lag, Nth Value).
• Involved in major code rewrite effort to increase performance by normalizing the data and using index organized tables.
• Performed application SQL tuning using Explain plan, TKPROF, Indexes, Partition Pruning, Bulk Processing and Hints.
• Developed the Informatica mappings to extract, transform and load, populating and refreshing tables.
• Created various types of Chart Frames like Bar and Pie Graphs using crystal reports.

Environment: Oracle 11g, SQL, PL/SQL, SQL*Plus, PL/SQL Developer, Informatica Power Center, XML, XML Spy, UNIX, VSS, NMarket, ER/Studio, WebEx.

Confidential, Jamesburg, NJ

Oracle Apps Developer

Responsibilities:

• Implementation and customization of Oracle FIN and SCM Modules - AP, INV, OM, PO.
• Responsible for Item Interface and material transactions in INV and also Currency, calendar, Key Flex Fields, Descriptive Flex Fields, Profiles, Value Sets and Lookups.
• Developed Load statements (control files) for SQL*Loader to load legacy data from flat files in to oracle tables.
• Implemented Pl/SQL Stored Procedures to load data from staging tables to interface tables.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Developed UNIX Shell Scripts and PL/SQL procedures to extract and load data for month-end batch processing.
• Developed interface for loading supplier invoices from various sources.
• Developed Auto invoice program for loading customer invoices.
• Responsible for Month Close, Quarter close process for General Ledger.
• Working with oracle support to resolve TAR and performance issues.
• Provided support for Data conversion from legacy system into oracle.

Environment: Oracle Application 11.5.10 Finance and SCM Modules (AP, INV, OM, PO), Oracle 9i, Oracle Reports/Forms 6i, TOAD, UNIX Shell Scripts, PL/SQL, SQL Loader.