Oracle Sales

Professional Summary

Extensive experience in System Analysis, Design, Development, Testing, Integration, and Implementation in Client Server environment using various software tools. Extensive experience in Oracle 11i/R12 EBS applications, Oracle 10g/11g, PL/SQL, Web Services, ETL tool, UNIX scripting, and Report Developing Tools. Excellent knowledge and experience in functional and technical skills.

Oracle 11i/R12 EBS Applications – 10 Years

Oracle Database/Programming – 12 Years

Work as Oracle Functional/Technical Analyst

Technical Skills:

Applications Oracle Applications 11i, R12 (GL, AR, AP, FA, OM, INV, PO, WIP, Oracle Projects & Billing, CRM, Cash Management, iSupplier, iProcurement, Depot Repair, Advanced Pricing, Human Resources, Payroll, MRP, ASCP, WMS, CRM, AOL), Vertex

Languages PL/SQL, SQL, C, PERL, KSH Shell, XML, HTML, JAVA, JSP, JavaScript

Operating Systems UNIX (HP-UX & SUN SOLARIS, AIX), Windows NT/2007, Windows XP, MS-DOS, IBM Mainframe, AS 400, P800

Development Tools Developer 6i/10g Forms & Reports, XML Publisher, JDeveloper, Workflow Builder, Discoverer 10g, AIM, SQL*PLUS, TOAD, SQL Navigator, OBIEE,

Web ADI, Informatica, Crystal Reports, PVCS, Data Loader, IB, TFS

Databases Oracle 10g/11g, Data Warehouse Builder, DB2, SQL Server, Access

Employment:

Xylem, Inc. Seneca Falls, NY Mar 2016 – Jun 2016

Sr. Oracle Applications Developer

As Xylem Team member, worked on designing and implementing the Oracle R12 Applications.

Work with business users to implement business requirements and created Technical Document and Unit Test Plan.

Worked with Procure To Pay and Order To Cash Process.

Designed, Coded, and Tested ShipTo Invoice Interface using TCA APIs and PL/SQL.

Performed Auto Invoice Open Interface and to import the Invoices from Legacy System.

Performed standard setups/configuration in Financial Modules.

Developed and Tested new AR Invoice package using PL/SQL Object Types and SOA.

Designed and Tested Purchasing related reports.

Resolving production tickets using Oracle production financial applications and Legacy System.

Worked with business user to test project objects and developed and test scenarios.

Creating/maintaining users, responsibilities, menus, concurrent programs, workflow administration, and Printer configuration.

Created Service Request and follow up of using Oracle Metalink support for functional or technical issues.

United Airlines, Chicago, IL Jun 2014 – Dec 2015

Sr. Oracle Developer

As United Team member, worked on designing and implementing the Oracle EBS R12 Financials/Supply Chain Applications.

Coordinated and partipiciated the entire phase of the project which included initial operations analysis, business process re-evaluation, integration, testing, training, conversions, customizations and documentation and implementation of modules.

Designed and developed Conversion Programs for importing the data using PL/SQL and SQL*Loader for AOP Inventory Project. Created and Tested Interfaces using Inventory and transactions APIs.

Performed Journal Import Open Interface and Item import interface to import data.

Supporting and Maintaining Accrual Log application using Oracle Applications Framework (OAF), Web ADI, and Hyperion.

Prepared Functional Documents and worked with Off Shore Team for development and testing.

Performed standard setups/configuration in Financial and Oracle Supply Chain Modules. Working and Testing on Oracle Projects/Billing implementation.

Working and Testing Oracle Order Extract and Suppliers invoice package. Created and modified SQL scripts, triggers, packages, tables and views.

Supporting, Maintaining and resolving issues in Oracle applications. Resolving production issues durning Month End Period Close and coordinates with business users.

Designing and Developing Oracle Finance/Inventory Reports using OBIEE and Oracle Reports.

Coded and Tested SLA Non-3rd Party Journal Interface to create Journals using GL APIs.

Developed UNIX shell script to call control file and load the data into Staging Table.

Designed, planned and conducted functional testing. Developed and maintained test scenarios and test scripts for project team and end users.

Designed and modified Security Forms. Designed and tested finance/OM/PO related reports.

Resolving complex production issues for existing Organizations and fixes bugs in the programs.

Lead in-house developer resources for on-going support of Oracle ERP Applications.

Creating/maintaining users, responsibilities, menus, concurrent programs, values sets, functions, workflow administration, and Printer configuration.

Created SR’s with Oracle Technical Support and follow up of for using Oracle Metalink support for functional or technical issues.

AAR Corp. Wood Dale, IL Dec 2009 – Mar 2014

Oracle Functional/Technical Developer

As an AAR Team member, worked on designing and implementing the Oracle EBS 11i/R12 Oracle Applications. – Order to Cash, Procure to Pay, and MFG Modules.

Coordinated and partipiciated the entire phase of the project which included initial operations analysis, business process re-evaluation, integration, testing, training, conversions, customizations and documentation and implementation of modules.

Involved and Performed functional setup/configuration for a new Sweden Organization to Oracle Financial and Supply Chain Modules.

Designing, coding, and testing interfaces, conversions, reports, forms, and extensions.

Developed and tested customers, Items, BOMs, Vendors, and Price Lists Conversions for Telair Sweden Implantation. Performed Import Process to load the data from interface to oracle tables.

Modified and Tested Lawson Financial and EDI Order Interfaces using APIs.

Performed Auto Invoice and Auto Create Process using Open Interfaces.

Designed, Modified and tested Employee Time Entry/ITAR forms and packages.

Designed and tested invoices/shipping related reports using XML Publisher, and Oracle Reports.

Performed and Resolved Oracle Workflow related issues/errors in OM/Purchasing.

Involved in designing and developing the Discoverer Workbooks, folders, Calculation items, Business areas, administering security and privileges. Developed complex workbooks for finance team.

Working with consultants to develop OBIEE Dashboard and Reports.

Performed and tested planning programs, review MRP workbench and process jobs and POs.

Performed technical specification design, development, unit testing, system integration testing, UAT and maintenance of Oracle e-business suite of Applications.

Assisting and Performing patche’s testing in dev, test, and production system.

Created and modified SQL scripts, functions, triggers, procedures, tables and views.

Assists the other developers in coding and testing using Oracle Applications.

Coordinate Oracle service requests and drive them to a final resolution for functional or technical issues.

Performed fundamental administrative tasks including registering applications, programs and reports.

Resolving complex production issues for existing Organizations and fixes bugs in the programs.

Motorola, Inc. Schaumberg, IL May 2009 – Dec 2009

Oracle ERP Consultant/Business Analyst (contract)

As a consultant, worked on designing, coding, testing, and implementing the Oracle R12 ERP Applications. - Order to Cash

Analyze, design and develop enterprise-wide application solutions based on the business requirements under ERP applications.

Involved in designing, coding, and testing interfaces, conversions, reports, forms, and extensions using Oracle ERP Modules.

Developed and Tested Orders extract program using SQL, PL/SQL, and DB2 COF system.

Performed and Involved Item/Customer Conversion, setup/uploaded new items/PTO models in the R12 ERP system.

Worked with consultants to prepared DRs and Technical Design documents on new business requirements. - Payment Term, Custom Credit fail, Export Compliance extensions.

Performed Shipping and Auto Invoice process.

Worked with functional consultant to perform the setup in OM/AR/GL modules.

Modifying and tested customers and orders related reports using Oracle Reports.

Assisting and Performing SIT and CAT Testing for Oracle e-business suite of Applications.

Involved in design of AIM (Application Implementation Methodology) documents (MD-50,

MD-70) for conversion, interfaces, reports and extensions.

Created and modified SQL scripts, functions, triggers, procedures, tables and views.

Helping users/developers in R12 ERP modules.

The Pampered Chef Ltd., Addision, IL Dec 2006 – Mar 2009

Oracle Applications Developer

As a member of the TPC team, worked on designing, coding, testing, and implementing the Oracle 11i ERP Applications. – Order to Cash, Procure to Pay, and MFG Modules.

Involved in complete software development life cycle (SDLC) of the system.

Analyze, design and develop enterprise-wide application solutions based on the business and users requirements under Oracle E-Business Suite environment.

Coordinated and partipiciated the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules.

Designed, Coded, and tested Sales Order Interface using Data Warehouse, and Oracle Import.

Designed and Coded Shipping Interfaces to loads the orders from P800 Legacy system to Oracle ERP system using PL/SQL, APIs, and custom interface tables. –Third party vendor.

Wrote conversion to process customers in Receivables from Prowess applications.

Worked and Tested customer payment interface using iPayment.

Designed, Coded, and tested Commission package using PL/SQL and SOAP Web Service.

Worked on AP Commission Check interface to process data from Prowess system.

Coded, and tested Purchase Order Conversion Program using PO Import process and SQL*Loader.

Performed functional setup to AP/AR/OM modules in dev and QA instances.

Developed a refund process interface program using PL/SQL AR APIs.

Designed OM/inventory related reports using Oracle Discoverer and Oracle Reports. Developed shipping and CRM forms using Oracle Developer 6i.Setup Personalization for payment history form.

Modified and tested the workflow to change the fulfillment status for kit/non-shippable line.

Created and modified SQL scripts, Shell scripts, triggers, packages, tables and views.

Actively participated in resolving complex production issues and fix bugs in the programs.

Assists the other developers in coding and testing using Oracle Applications.

Created TAR/SR and follow up of for using Oracle Metalink support for functional or technical bugs or problems.

Performed fundamental administrative tasks including registering applications, programs and reports, defining user menus, and setup value sets in the application.

Accenture, Inc., Chicago, IL Oct 2002 – Dec 2006

System Analyst/Consultant

Project: Toshiba, Inc

As a member of the Toshiba team, worked on designing, coding, testing, and implementing the Oracle 11i ERP applications.

Created detailed design documents, including data mapping documents, and interface requirements, Technical Design, and Unit Test Plan.

Coded and tested interfaces, conversions, and extensions using Oracle ERP 11i modules.

Designed and coded orders validation program. Performed Order import interface to import new, change completed sales orders or returns from data warehouse/legacy system.

Developed and tested Adjustments(RMA) process interface using Shipping APIs.

Designed and coded Suppliers conversion using SQL*Loader and PL/SQL.

Coded and tested open invoices interface and Export Compliance extension for the Sales Orders.

Designed Fixed Asset and sales orders related reports using Oracle Report.

Coded and tested UNIX shell script for mail merge program.

Designed and tested Backorder cancellation workflow.

Developed forms, scripts, views, packages and routines for transferring data from different version of the applications using SQL Loader, Toad, and SQL Plus extensively.

Modified and tested custom.pll to perform sales order/lines forms.

Performed standard setups within OM in support and test instances. Developed and tested customers and Price Lists Conversions. Setup and imported Price Lists in the Oracle ERP system using Price list import program.

Developed, tested, and implemented efficient, cost effective application solutions. Actively helped team members in developing and testing programs using Order ERP applications.

Project: EMC, Inc

As a member of the team analyzed and developed conversion and interface programs in an Oracle 11i ERP implementation.

Designed and developed Deferred Revenue Conversion Programs for importing customer revenue data using PL/SQL and SQL*Loader. Performed Journal Import Open Interface to import data.

Performed Payable Open Interface to import open invoices by passing GL date.

Designed and developed Outbound Sales Order interface.

Designing and Developing Oracle Discoverer Workbooks and Views.

Designed and modified Form Length Restriction Extension using custom.pll.

Developed UNIX shell script to transfer files from one node to another node.

Designed and coded GL details report using PL/SQL and Java.

Performed standard setups within GL, AR, AP and Customer profiles and modified defaulting rules and payment terms with some predefined transaction types.

Created and modified custom forms, SQL scripts, triggers, packages, tables and views.

Designed, planned and conducted functional testing. Developed and maintained test scenarios and test scripts for project team and end users.

Actively participated in resolving complex production issues and fix bugs in the programs.

Project: Constellation Energy Group

As a member of the Constellation Energy team, worked on implementing, upgrading, coding, and testing the Oracle 11i ERP applications.

Proactively interacted with client to understand their business practices and configure the system accordingly. Prepared Detailed Design documents, including data mapping documents, interface requirements, Technical Design, and Unit Test Plan using AIM Templates.

Worked as Report Team Lead and implemented 40 reports.

Coded Sales Order inbound/outbound interfaces to import data from other system using PL/SQL for Oracle applications.

Coded, and tested BOM Item load Interface to loads the data into oracle interface table.

Developed and tested EEDAS Purchasing Interface to create text files and transfer to other system.

Created and setup kit/components in BOM to dev, test, and prod environments.

Performed Item Open Interface to change other attributes on existing items.

Designed customer address cleanup interface using First logic, PL/SQL and location APIs.

Designed and tested reports such as Shipments, Items Inventory, Pick slip, Sales Orders and purchasing reports.

Created and modified custom forms, SQL scripts, triggers, packages, tables and views.

Actively participated in resolving complex project issues concerning multi-modular interfaces and integration in a non-networked environment.

Project: KeySpan, Inc

As a member of the KeySpan team worked on implementing, upgrading, coding, and testing programs in Oracle EBS Modules.

Analyzed, designed and developed enterprise-wide application solutions based on the business and users requirements under Oracle E-Business Suite environment.

Prepared detailed specifications and technical documentation from which programs will be written.

Designed, coded, and tested interfaces, conversions, reports, extensions, and workflows using Oracle GL, AP, AR, PO, and INV modules.

Developed and customized a form for mass update functionality for item routing information. Developed/modified over 15 reports.

Developed GL Code combination Outbound Interface.

Performed Order import open interface to import new, change completed sales orders or returns from legacy applications and internal orders created from Oracle Purchasing internal requisitions.

Designed, planned and conducted functional testing. Developed and maintained test scenarios and test scripts for project team and end users.

Reviewed programs written by programmers and helped to resolved technical issues.

Participated on production support team and resolved complex production issues with permanent long term solutions.

Project: Ricoh, Inc

As a member of the ERP team, worked on implementing, upgrading, coding, and testing the Oracle ERP applications.

Developed Conversion Programs for importing Vendor data along with their bank account information from legacy systems into Oracle Financials database using PL/SQL.

Designed and developed customer parties account conversion.

Imported large amount of invoices, debit memos and credit memos from legacy system into AR module using Auto invoice, PL/SQL programs (for data validation) and SQL *Loader.

Designed and developed Outbound Receipts interface.

Designed, coded, and tested Substitute Item extension.

Designed and tested GL/Oracle Fix assets reports.

Developed Custom PL/SQL API to source the value of attributes, Map custom attributes using attributes mapping form.

Developed and modified custom forms and reports.

Project: Avis Budget Group, Inc

As a member of the RICE team, worked on implementing, upgrading, coding, and testing Oracle Human Resources/Payroll applications.

Prepared Detailed Design documents, including data mapping documents, and interface requirements, Technical Design, and Unit Test Plan.

Designed and coded Employee Job Outbound Interface.

Designed and coded Locations and Organization Conversion.

Designed and coded Human Resources and Benefits reports using Oracle 6i and Discoverer Report.

Designed, coded, tested and employee Staywell Extension using API.

Modified and tested custom.pll to perform employee/assignment forms.

Imported data from legacy system to temporary tables using SQL*Loader.

Created and modified custom forms, SQL scripts, triggers, packages, tables and views.

Project: Walgreen, Inc

As a member of the team, worked on implementing, upgrading, coding, and testing Oracle Store Dash Board application using Oracle, Java, ETL, and JSP. Involved in complete software development life cycle (SDLC) of the application.

Prepared Detailed Design documents, including data mapping documents, and interface requirements, Technical Design, and Unit Test Plan.

Designed and coded extract programs using PL/SQL and ETL Tool. Developed SQL Reports.

Worked with Business Users to get correct formatted files from Mainframe and validate the data after loading/processing in Oracle.

Designed, coded, tested Perl and shell scripts to call the procedures and load the data.

Reviewed programs written by programmers and helped to resolved technical issues.

Designed, planned and conducted functional testing. Developed and maintained test scenarios and test scripts for project team and end users.

Motient Communication Inc., Lincolnshire, IL Sept 1998 – Sept 2001

Programmer/Analyst

As a member of the Ensemble billing team worked on designing, coding, and testing the new Ensemble Billing system and Elink web system using UNIX/Oracle. Involved in complete software development life cycle (SDLC) of the system.

Designed and coded conversion/loading programs from binary files into Oracle table using Perl & SQL loader. This program loads 15M records in 25 minutes and calls daily packages which performed daily processes in three hours. This is extremely high performance compared to the existing billing process (three hours).

Designed, developed and implemented packages, stored procedures, triggers and functions for Billing process using PL/SQL. Designed, developed and coded error processing which logs user defined and Oracle errors during daily and monthly billing processes to detect failure of process.

Designed, developed, and implemented credit cards encryption web package to be used for securing credit card numbers in the Order Entry and Billing application.

Coded and tested Ensemble billing forms and reports.

Used EXPLAIN PLAN and SQL Trace to optimize the performance of queries.

Wrote Java External Program to convert device value into SU Hash value to perform device registration process.

Participated in Ensemble database design, data modeling, physical capacity planning, creating tables and indexes. Worked with DBA to complete system performance monitoring, measuring, and database tuning.

Researched and resolved complex production issues with permanent long term solutions.

Education: Northeastern Illinois University, Chicago, IL

Master of Science, Computer Science

Northeastern Illinois University, Chicago, IL

Bachelor of Science, Computer Science

Contact this candidate