SUMMARY:

• Have around 12 years of experience in all facets of Software Development Life Cycle (SDLC) including technology/process development on Oracle ERP implementations, Business Systems Analysis, Project Management and technology development, technical support including assistance and direction to departmental staff.
• Adept at working on multiple concurrent projects across various Technology Groups globally, driving data collection, conducting analysis, deployment, roll - out, training and testing. Ability to communicate effectively with technical and non - technical stakeholdersfocusing on technical and functional areas of Oracle SCM (OM, INV, PO),Finance (AR, GL, AP) and Service modules. Extensive experience inanalysis,design, development, customization, maintenance and documentation of RICEW components, Forms extensions, Discoverer, XML Publisher reports, EDI interfaces (940,997,944,947,810,823)

TECHNICAL SKILLS:

Applications: Oracle APPS R12, 11i

Modules: Order Management, Inventory, Purchasing, Install Base, Advanced Pricing, Accounts Receivables, General Ledger, Accounts Payables, Teleservice, Trading Community Architecture

Oracle Tools: Forms 6i, Reports 6i, Workflow builder 2.6, XML Publisher, Discoverer

Languages: PL/SQL, JAVA

Database Tools: Oracle 9i, Oracle 8i/ 8.x, SQL*Loader, Toad, SQL Developer, UNIX Utilities

Operating Systems: Windows NT/9x/2000/XP, UNIX

Other Tools: Test Director, MercuryQuality Center,PVCS, WINSCP

PROFESSIONAL EXPERIENCE:

Confidential, IA

Sr. Oracle Techno Functional Consultant

Responsibilities:

• Proposed solutions for identified GAPsin migration of objects from 11i to R12.1.2
• Modified the existing business templates to the R12 version of Oracle
• Developed programs for Customer and Invoice conversions
• Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL/SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables
• Developed a custom package to perform Credit Check and apply holds on the sales order created
• Personalized Sales Order form to mandate entry of Order Reason field for orders with Zero unit selling price
• Developed Auto Invoice Interface program to import invoices from legacy systems to Oracle Receivables
• Developed an interface to load Service Requests, notes, attachments into Oracle from legacy system
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various custom PL/SQL Packages, Procedures and Reports developed
• Developed custom reports using discoverer/XML Publisher
• Open Orders and Returns Report
• Sales Order Shipping Report
• Sales Contract Report
• Open Invoices and Aging Report
• Inventory On-hands Report
• YTD Invoice Accrual Report
• Prepared design documents (MD050) and technical documents (MD070) for all the customizations.
• Prepared MD0120 Installation instructions, TE020 unit test documents
• Resolve issues with Work Orders in WIP
• Imported discrete jobs using WIP mass load
• Provided production Support

Environment: Oracle Applications 12.1.2, Oracle 10g, PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, XML publisher and UNIX.

Confidential, East Norriton, PA

Techno-Functional Consultant

Responsibilities:

• Involved in requirements gathering, gap analysis of existing business processes, user acceptance testing, go-live and post production support
• Participated in sessions with Confidential Business Subject matter experts and technology personnel of Confidential to define and document technical solution for EDI Integration/s.
• Provided technical design and solution to the IT Management on change request/s and enhancements.
• Prepared technical documentationsusing AIM Methodology
• Assisted both support and development teams on RICEW objects delivery
• Worked with Sabrixteam to debug the issues with tax calculation Sales Orders based on locations
• Developed and tested various interfaces for sales orders and invoices
• Send Sales Orders on EDI 940 and ship confirm sales orders received on EDI 945
• Perform Inventory Movements sent on EDI 947 in Oracle
• Load invoice data sent on EDI 945 into Oracle
• Load receipts into Oracle Receivables from third party systems using EDI 823
• Standing order contract expiration alert program
• Send RMA information to Confidential via email
• Update accounting classification code in Install Base
• Developed several custom reports using XML Publisher and Discoverer
• To see how many items ordered, shipped and not available in inventory
• Shows current A/R balance, credit limit and past 12-month transaction history for the customer(s) defined in TCA
• Shows the sales information with corresponding order number, invoice number, Item number, and PO and customer ship-to location
• Invoice Aging and Customer information reports
• Sales tax report
• Worked with SQL Loader and PL-SQL Built in packages to convert legacy data into Oracle Applications
• Created custom Shell scripts to handle the loading the data file into the custom tables and archiving of the data file.
• Modified the existing PO Requisition custom workflow in R12
• Customized the Horizontal Plan in ASCP
• Process / transact the WIP related move orders via background
• DeletedBOM Items using a Delete Group to reflect correct information on custom Sales Detail report
• Resolved issues with Inventory items not being shown on BOM
• Experience in integrating EBS with Legacy systems with SOA
• Involved in provisioning approvalcheck service in OSB
• Involved in importing WSDL from SOA server, and created Service Bus business service and Service Bus Proxy service and this proxy service is used to mediate access to the end point service producer for customer validation
• Developed custom interface for forecasting items
• Support Finance month-end close activities
• Day-to-Day support for SCM, Finance modules

Environment: Oracle Applications 12.1.2, Oracle 10g, PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, SOA, CVS, SQL*Loader, XML publisher and UNIX.

Confidential, Duluth, GA

Techno-Functional Consultant

Responsibilities:

• Gather business requirements, GAP analysis, Module setup, Configuration, training end users and production support
• Setup new order sources, shipping methods, Defaulting Rules, Order types
• Setup Price list, Qualifiers, Modifiers and other advance pricing processes
• Design and implemented order import process using Order Import interfaces for legacy system (Great Plains) orders.
• Design and implemented data migration from legacy system to Oracle Applications for Customer Import, Install Base data Import
• Involved in loading state, county, city, zip ranges, GeoCodesand jurisdiction code from the Vertex data file into the Oracle AR TAX INTERFACE table
• Resolved various open Tax Issues during Integration Testing
• Design Customer Information form for Customer Services, which enables user to view important information of the Customer, Open/Closed Orders, and aging information and roll up summary of the Customer
• Design and implemented the shipping process to calculate freight charges and tracking information for the deliveries
• Developed a custom Sales Order Shipping Details page using OA Framework
• Month end closing for Inventory, AR and resolve the issues for the unprocessed transactions
• Develop custom discoverer reports
• Supporting production issues in SCMand Finance modules

Environment: Oracle Applications 11i, Oracle 10g, PL/SQL, SQL, Forms, Reports, SQL*Loader, XML Publisher and UNIX.

Confidential, Sunnyvale, CA

Techno-Functional Consultant

Responsibilities:

• Involved in requirement analysis, preparation of data migration strategy and data conversion Templates
• Involved in development of custom program for uploading customer’s data
• Developed PL/SQL packages to import Purchase Ordersfrom Legacy System
• Worked On GL Daily Rates Inbound Interface
• Developed Requisitions Interface to upload the requisitions data into Oracle Apps base tables from the flat file
• Developed report to display purchase order number, line no, quantity and unit price with buyer details
• Provided support for QA and UAT

Environment: Oracle Applications 11i, Oracle 9i, PL/SQL, SQL, Forms, Reports, Discoverer

Confidential, New York, NY

Business Analyst / Java Developer

Responsibilities:

• Involved in struts actions and Struts validation framework to handle transactions.
• Developed stored procedures, Triggers and functions using PL/SQL and mapped it to Hibernate Configuration File and also established data integrity among all tables.
• Hibernate and JDBC was used to support the communication between business layer and persistence layer, which is on the Oracle database using DAO Pattern.
• Developed User Interface screens using struts tags, JSP, HTML and used JavaScript for client side validation.
• Integrating with other upstream systems using Grand Central in extracting, transforming and loading data
• Managed builds and Deployments, Created Ant Scripts to customize EAR, WAR and JAR files and automated UNIX packaging using Hermes and xenv.
• Developed role based access control to restrict the users to access specific modules based on their roles.
• Developed AJAX components like Type ahead and form validations using apache commons and Ajax.
• Involved in conducting UAT, Implementation and maintenance of the application.
• Implemented design patterns - Singleton, Abstract Factory Method, DAO and Value Object patterns.
• Developed an XML parser using Apache XERCES, for retrieving data from the XML response given by the Location server.

Environment: J2EE1.4/1.5/1.6, WebSphere 5.0/6.1.0.13, Struts1.2, Hibernate, WebLogic 8.1, ALBPM5.7(Fuego), eclipse, Oracle10g, Ant6.1, ELF, ESF, Bullet framework, XML, DOM, Apache Xerces, jaxp, Toad, Actuate 8.1, iText, Autosys, sftp, Unix, Microsoft Office, Microsoft Excel, Microsoft Visio