Professional Summary:

• Over 8 years of experience in Oracle Applications environment as a Technical Analyst, Programmer/Developer and Applications Developer.
• Worked on Oracle Applications Versions R12, 11i / 11.0.x and 10.7 involving Implementation and Upgrade and data migrations.
• Proficient in developing reports using Oracle reports 6i and 10g along with BI Publisher/XML Publisher reports.
• Worked on Oracle Workflow Builder in streamlining the approval process in various financial modules and also on Oracle Data Integrator.
• Experienced in Business Intelligence tools like OBIEE and Discoverer Reports spanning versions 3i to 10g.
• Worked in Business Intelligence views along with Noetix views.
• Proficient in developing concurrent programs using SQL, PL/SQL and UNIX Shell Scripting.
• Extensive experience in Oracle financial modules like Receivables, Payables, Purchasing, General ledger and Project accounting. (AR, AP, PO, GL, PA) building Interfaces, Conversions, Reports and Customizations also using APIs.
• Extensive experience on Manufacturing and Supply Chain Modules like Order Management, Inventory, Bill of Materials (OM, INV, BOM) along with Pricing Modules building Custom reports and interfaces.
• Experience in Oracle HR Modules with Benefits and Payroll. Familiarity with standard HR and Payroll business processes.
• Proficient in developing PL/SQL packages, stored procedures, triggers.
• Experience in SQL Tuning using Explain Plan and Tkprof utility.
• Experience in maintaining and supporting multiple servers in Production environment.
• Designed Technical and Functional Design Documents for many Interfaces and Customizations.

Technical Skills:

Oracle Applications

AR, AP, GL, PO, OM, AOL, PA, FA, GL, INV, BOM, HR, OAB, Payroll

Oracle Tools

SQL* Loader, SQL* Plus, Oracle Forms 6i, Oracle Report 6i/10g, BI Publisher, XML Publisher, OBIEE, Workflow Builder, AME, Discoverer 3i, 4i, 9i and 10g.

Languages

SQL, PL/SQL, XML, Java, Jdeveloper, Unix Shell Script.

Tools

TOAD, PL/SQL Developer, SQL Assistant.

Operating System

UNIX, Windows, Linux

Relevant Knowledge

System Development Life Cycle (SDLC), System Programming

Professional Experience:

Confidential,NE Oct ’12 Current
Role: Oracle Applications R12 and XML Publisher Developer

Roles and Responsibilities:

• Developed the Open PO Interface to load the Open POs from the legacy systems to the current version of R12.
• Created the Accounts Payables conversion program to bring over the existing AP Invoices from the previous instance to the current R12 environment.
• Built the PO Document to replace the existing Oracle standard document using XML Publisher.
• Customized the standard Oracle views, which the PO Document uses to pull in the fields into the PO Document.
• Built the Receiver Tag in order to retrofit it to the client’s requirements using XML Publisher.
• Involved in all end-to-end HRMS conversions including Employee, address, assignment, phones and taxes.
• Designed and developed and outbound interface that extracts active employee data from Oracle HRMS and sent it in form of output file.

Environment:Oracle E Business Suite (R12), PL/SQL, SQL *loader, UTL, Oracle Reports 6i/10g, XML Publisher, OAF, TOAD, UNIX, Korn Scripts, SSH CLIENT, Windows XP.

Confidential,Temple, TX Feb ’12 Oct ‘12
Role: Oracle Applications R12 Lead Developer

Roles and Responsibilities:

• Created the AR Auto Invoice Interface to import transactions from third party systems with error handling and error reporting techniques.
• Rebuilt the Standard AR Recon Report from the scratch and customized it into an XML Publisher report according to the company needs, breaking it down to Division level.
• Creating a Custom process for sending the Customer Statements and Pre Draft Notices to customers based on their choice of receipt using XML Publisher template and Email Bursting Techniques.
• Customized an existing OAF page for Customer Site search screen to include details into the existing page.
• Performed Post Production tasks like maintaining and stabilizing the instance and creating error logging and notification scripts.
• Worked on AR Claims and Collections and created XML reports to report on the Unapplied and Claim amounts in Receivables.
• Created a PL/SQL package to automatically inactivate data in the AIMS process of the AP interface and reported on the status using XML Publisher.
• Created UNIX shell scripts (Korn Shell Scripts) to ‘FTP’ the flat files of data into our ‘IN’ directory from external systems.

Environment:Oracle E Business Suite (R12), PL/SQL, SQL *loader, UTL, Oracle Reports 6i/10g, XML Publisher, OAF, TOAD, UNIX, Korn Scripts, SSH CLIENT, Windows XP, Forms 10g.

Confidential,Omaha, NE Aug ’11 Jan ‘12
Role: Oracle Applications R12 Lead Developer

Roles and Responsibilities:

• Created interfaces in in AP, AR and GL to import data from legacy systems using Custom PL/SQL code with the help of Unix shell scripting and SQL*loader.
• Retrofitted the existing interfaces and conversions in AP, AR, GL and FA modules to the upgraded R12 version.
• Created the Bank Reconciliation Open Interface in Cash Management module to reconcile the Bank Statements using custom PL/SQL code.
• Automated the process of receiving POs using the Receiving Transactions Processor Interface and built notification processes using PL/SQL.
• Customized the Oracle given packages to fit the company’s requirement of Account Generator Workflows.
• Set up rules for approvals of AR transactions and POs using Oracle AME.
• Created loader jobs using Unix Shell Scripting to bring over the legacy data into the Oracle systems and provided Production support to the interfaces and conversion after go live.
• Worked extensively on Oracle Workflow builder and developed new workflows in the PO modules to automate the Receiving Transaction Processor along with email notifications.
• Customized standard workflows in the PO and PA modules like the PO Account Generator and Project Expense report account Generator to fit the new needs.
• Built new Business areas in Discoverer 10g after installation and also created new custom views to be able to use in Discoverer.

Environment:Oracle E Business Suite (R12), PL/SQL, SQL *loader, Oracle Workflow Builder, AME, Discoverer 10g, Forms 10g, TOAD, UNIX, Korn Scripts, SSH CLIENT, Windows XP.

Confidential,Kansas City, MO Nov ’10 Jul ‘11
Role: Oracle Applications R12 Developer

Roles and Responsibilities:

• Created AP Invoice Import Interface in the R12 version using PL/SQL and UTL utilities in which data was fed in from flat files from external systems.
• Built Conversion scripts to bring over the existing AP Invoices from the previous instance of Oracle into the Current instance using data links and then importing them.
• Created the Account Receivables Import Interface into Oracle R12 using PL/SQL and developed an error tracking notification process.
• Created AR Invoice Import Conversion script to bring over the Invoices from the previous Versions of Oracle into the Current system.
• Built the Suppliers Interface in R12, completely customized without APIs to both bring over the previous Suppliers and also update Oracle with new ones.
• Involved in conversions for Payroll Direct Deposit Accounts, Current Salary conversion, employee conversion, pay balance conversion, assignment conversion and payroll W4 tax elements using API’s.
• Involved in defining of person types, employees, assigned employees to assignment and then for Payroll and the elements.
• Built three GL Interfaces using PL/SQL and to bring in multiple sources of GL transactional level data from flat files using SQL *loader.
• Built GL Conversion scripts using PL/SQL and UNIX shell scripting from various sources performed the validations and mappings based on the Cross Validation rules.
• Scheduled the Interfaces and Conversions using Oracle scheduler and developed an error Reporting report in Oracle reports to notify the users in case of errors at the end of each day.
• Gathered business requirements and designed the technical solutions using OBIEE.
• Prepared, enhanced and configured metadata and data models using OBIEE.
• Analyzed requirements and developed comprehensive business intelligence solution.
• Created a custom form using Forms 10g to validate the mapping of GL Code combinations.

Environment: Oracle E Business Suite (R12), PL/SQL, SQL *loader, UTL, Oracle Reports 6i/10g, OBIEE, TOAD, UNIX, Korn Scripts, SSH CLIENT, Windows XP, Forms 10g.

Confidential,Omaha, NE Jul ’09 Oct ‘10
Role: Oracle Applications R12 Developer

Roles and Responsibilities:

• Developed the Payables Import interface in AP, which handles file systems from two different legacy systems.
• Generated log file and output files for the above process using UTL utilities from within the code and email the file and its location to a group of users after successful completion of the import.
• Developed AR and AP Conversions from Legacy to Oracle R12.
• Developed the Auto Invoice Import interface in AR using PL/SQL and UTL utilities, which uses APIs to automatically create the code combinations in GL during import.
• Mailed the rejections report after the import is completed to users to maintain reconciliation between Oracle and the Source system.
• Created UNIX shell scripts passing parameters from other scripts to validate the internal data.
• Set up Oracle AME and created approval rules and approver lists using Oracle AME.
• Created XML Publisher reports to validate the data after AR and AP load imports for further analysis.
• Created PL/SQL packages with database triggers like ‘After Insert’ and ‘Before Insert’ to alter the data being loaded into interface tables.
• Created extracts from Oracle to the Legacy systems intending to reconcile the data after the AP and AR imports.
• Used Custom forms to create error-reporting strategy for interfaces and conversion using Forms 10g.
• Developed Cash Application Reports using XML Publisher to calculate the amount pending by Customers and also maintained the aging report of the same.

Environment: Oracle E Business Suite (R12), PL/SQL, SQL *loader, UTL, Oracle Reports 6i/10g, XML Publisher, AME, TOAD, UNIX, Korn Scripts, SSH CLIENT, Windows XP, Forms 10g.

Confidential,Baltimore, MD Jun ’08 Jul ‘09
Role: Oracle Applications Developer and Reports Admin

Roles and Responsibilities:

• Created the AP invoice Interface to upload invoices and also automated the process of invoice upload using WEBADI and UTL file utilities.
• Created XML Publisher reports to get the Snapshot (as of date) information of Account Payable invoices.
• Effectively used public APIs in the AP Interface Process and other Financial Modules.
• Modified and customized the ‘Financial statement Generator’ (FSG) reports to break it down to sub department levels according to company requirements.
• Worked in the Oracle Applications (ERP) version 11.5.10 Procurement Process surrounding all the Procure-to-Pay modules and customized the workflow process.
• Extensively used SQL *loader and UNIX shell scripting to automate the data load process from the third party vendor into our systems.
• Developed a PL/SQL Package to generate alerts if any AP Invoice payment batches was above a certain amount for further approval and send email alerts to the concerning approvers using Workflow Builder.
• Implemented MRC (Multiple Reporting Currency) to report simultaneously in up to 12 currencies into modules like AP, PO, FA and GL along with Cash management.
• Business Intelligence reports converted into custom made discoverer reports according to business needs.
• Created EUL, Business Areas for Financial Modules and identified custom reports that needed to be developed in Discoverer and XML Publisher.
• Gave User training sessions in discoverer along with presentations to the user community comprising of 10 - 15 users and handed out custom made prep material for their convenience.

Environment: Oracle E Business Suite (11.5.10), PL/SQL, SQL *loader, SQL * Plus, UTL, Discoverer 10g, 9i, 4i, 3i, Desktop, Administrator and 10g Plus (Web Version), TOAD, UNIX shell scripting, SSH CLIENT, Forms and Reports 6i, XML Publisher, Windows XP.

Confidential,Fond du Lac, WI Nov ’06 May ‘08
Role: Reports Administrator and Oracle Applications Developer.

Roles and Responsibilities:

• Gathered requirements from Business Users, both Sales and Purchasing and created Reports 6i and Discoverer reports and PL/SQL Extracts.
• Worked on Discoverer 4i, 9i, 10g Administrator and User editions; and with 10g Admin, User and Plus.
• Performed Discoverer Admin responsibilities like Creating User, granting access to roles and responsibilities, Scheduled Worksheets, Exported and imported EULs into various versions of Discoverer.
• Have extensively worked on the Daily Business Intelligence and (BI) Publisher and created reports to satisfy the user requirements in both Order Management and Purchase Orders side of the Business.
• Conducted user training for discoverer Desktop and Plus editions in the latest version 10g for both Desktop and Citrix Solutions Platform.
• Worked with the data warehousing teams and also reported on the data thus transformed and loaded using Business Objects and Discoverer.
• Created interfaces in the Project Accounting area with customizations on the existing interfaces too.
• Analyzed data models based on their schemas and developed appropriate SQL Scripts and UNIX shells to extract data.
• Developed reports and extracts on Sales, Freight, Invoices and Purchases, Advanced Collections, Pricing and GL.
• Involved in developing, customizing, tuning and Optimization of SQL, PL/SQL scripts according to business requirements.
• Fine-tuned existing SQL and PL/SQL scripts, to improve the performance and reduce overhead.
• Created reports in Oracle reports 6i on Project accounting and calculated the Budgets for an accounting segment per quarter.
• Created Custom Views or ‘Folders’ in OM, PO, PA, AR, INVand GL as an addition/ enhancement to the existing seeded views to cater to the needs of Business requirements.

Environment:Oracle E Business Suite (11.5.10), PL/SQL, Discoverer 10g, 9i, 4i, 3i, Desktop, Daily Business Intelligence, Administrator and 10g Plus (Web Version), TOAD, UNIX, SSH CLIENT, Oracle Designer, Windows XP.

Confidential,San Diego, CA Aug ’06 Nov ‘06
Role: Oracle Applications Developer

Roles and Responsibilities:

• Converted multiple reports in modules like AR, AP, OM, INV and Shipping from 11.0.3 to 11i reports.
• Developed many Conversion scripts using PL/SQL for Items Conversion, Item Cost and Item history from legacy systems to the current Oracle version.
• Retrofitted various Interface and Conversion packages in AR, OM and Shipping modules to fit the upgraded version of Oracle.
• Designed and developed Item pricing conversion program for migration of legacy/updated item pricelist into oracle.
• Designed and developed AP Bank historical audit files outbound interface which run annually for the audit purpose.
• Designed and developed AR auto invoice pre interface table error correction form and web requisition form.
• Written various triggers, Stored procedures, Oracle alerts and Budget Analysis reports (GL), Invoice, Vendor, Purchase related Reports (AP/PO) using SQL, PL/SQL.
• Developed/Modified new PL/SQL packages to migrate data from the 11.0.3 tables to 11.5.10 tables after studying and comparing them.
• Converted many scripts and reports from 11.0.3 to 11.5.10 to adapt to the new changes in the up gradation in the OM, OE and WSH responsibilities.
• Developed procedures to migrate the data in tables among various instances using Database links.

Environment: Oracle E Business Suite11.5.9, 11.5.10, 11.0.3, Discoverer 3i, 4i, 9i, 10g, Reports 6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, HP-UNIX 11, Windows XP.

Confidential,, Selbyville, DE Apr ’06 Jul 06
Role: Oracle Applications Developer

Roles and Responsibilities:

• Developed the Items Interface package using PL/SQL packages.
• Customized the BOM Item Interface and fixed the existing issues.
• Involved in customization of Sales Order Interface to import Sales order from legacy system.
• Customized a Sales Order report using Report 6i along with numerous Discoverer Reports to get the active suppliers.
• Build Workbooks as per user requirements in Order Management, Receivables, and Payables.

Environment: Oracle E Business Suite (11.5.10) 11i, OM, INV, BOM, PO, PL/SQL, Discoverer 10g, Reports 6i, UNIX, Windows 2000.

Educational Background:

• Masters in Computer Science and Engineering
• Bachelors in Computer Science and Engineering