SUMMARY:

• Eight years of techno functional expertise in Oracle Applications R12/11i versions specifically in Financial and SCM Modules. Extensive exposure to Design, Development and Production support of various RICEW Components.
• Attained proficiency in understanding client's needs and generate, modify existing data in Oracle Applications per the requirements and specifications
• Worked on various phases of Software Development Life Cycle (SDLC) such as Project Requirement Study, functional design, technical design, Coding, Testing, Quality assurance Documentation, Implementation, Maintenance and support of enterprise business applications
• Strong implementation knowledge of O2C (Order to Cash), C2C(Customer to cash), P2P (Procure to Pay) and Drop Ship end to end Cycle.
• Extensive experience on Oracle ADF Development (ADF, ADF Faces, ADF Task Flows and Business Components) with Web Services.
• Expertise in Customization, Upgrade, Implementation and Production Support of Oracle Financials, Oracle Project Foundation, Oracle Projects Billing, Oracle Project Costing, Oracle Process Manufacturing(OPM), Project Accounting(PA), ASCP(Advanced Supply Chain Planning), Oracle Quoting and System Administration(AOL) and Oracle Supply Chain modules (SCM).
• Experience with Trading Community Architecture (TCA)
• Extensively used UNIX scripts during development process
• In - depth understanding of Oracle Application architecture, experience with Multi-Org features of both R12 and 11i versions, Areas of expertise include technical developments in GL, AP, AR, FA, CM, Internet Expenses, Subledger Accounting, Quoting, FSG Reports, AME modules.
• Strong experience in Data warehouse concepts, ETL.
• Functional experience in configuration, setup, unit and integration testing of Advanced Pricing, Oracle Order Management, Purchasing, Inventory, customizations on Cycle Count, and Standard Costing solutions designed for meeting gaps in client requirement and application.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Excellent knowledge of Application Object Library (AOL) and System Administration Modules
• Created and maintained database objects like Tables, Views, Indexes, Sequences, Database links, Roles and privileges in an efficient way
• Strong experience and expertise in OBI/XML Publisher and Form Personalization's
• Proficient in creating functional and technical specifications as well as test plans and test scenarios using AIM methodology and documents such as BR 100, MD 50, MD 70, TE20, TE 40 and MD 120
• Good knowledge in Oracle Pricing, Service Contract, Installed Base, Advance Pricing, Quoting.
• Excellent skills in Database development of Oracle 9i,10g,11g environments using SQL,PL/SQL, Oracle Forms 6i, TOAD, PVCS, VSS, Java Script, VB Script, HTML and excellent hands on experience in developing various complex reports using Reports Builder 6i/10g, XML/BI Publisher and Discoverer Reports.
• Expertise in creating inbound and outbound interfaces, creation of automated processes using Application Program Interfaces (API).
• Excellent exposure to Oracle Financial Accounting Hub FAH and Sub-ledger Accounting SLA design for Banking Services industry.
• Having Extensive experience in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, collections, records, views, materialized views and Packages using PL/SQL.
• Extensive experience in customization of forms, Form Personalization, Customization of Reports, defining value sets and Defining Profile values by using Application Object Library (AOL).
• Experience in customizing Oracle workflows such as the Order/Line Flow, PO Approval process to send user notifications based on the business requirement.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Designed and Developed interfaces in various modules in Oracle Applications 11i and R12 environments using APIs, PL/SQL and UNIX Shell Scripts.
• Extensive experience in Oracle Project Accounting (Costing, Billing, Project Management, Project Contracts) and integration of Oracle Projects with other modules.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling .
• Good experience in creating various foundation objects including concurrent program registration, Custom forms, functions, menus, Responsibilities, Value sets, application registration, profiles and customizing Descriptive flex-fields.
• Proficient in administering/installing/configuring of Monitoring tools such as OEM11g,12c grid console for monitoring hosts, databases and Oracle applications through AMP plugins and Oracle OBIEE environments
• Designed and created entity relationship diagrams for Oracle based applications and interfaces
• Possess strong analytical skills with ability to follow project standards and decision-making capability
• Gained effective communication and leadership qualities. Have been a good team player and is constantly self-motivated
• Outstanding Technical/Functional Knowledge in Oracle Applications with Distribution and Supply Chain Management (SCM) Modules like (OM-Order Management, INV-Inventory, PO-Purchasing, WSH-Shipping), Financial modules like (GL-General Ledger, AP-Oracle Payables, AR-Oracle Receivables, CM-Cash Management, FA-Fixed Assets), iProcurement, iSupplier, iExpenses and iReceivables)

TECHNICAL SKILLS:

Oracle Database 10g/11g, MySQL, MS: Access, MS SQL Server.

Programming Languages: SQL, PL/SQL, Python, Java, Javascript, C++, Perl, XML, HTML, bash script.

Oracle Application Modules: Oracle R12 (12.0.6, 12.1.3, 12.2.4), Oracle 11i (11.5.3/11.5.8/11.5.9/11.5.10 ) General Ledger (GL), Subledger Accounting (SLA), Oracle Purchasing (PO), Accounts Payable (AP), iExpenses, iProcurement, EBTax, Cash Management (CM), Fixed Assets, iSupplier, Sourcing, Accounts Receivable (AR), iReceivables, Order Management (OM), Inventory (INV), Advanced Pricing, Quoting, Pricing Agreement.

Networking: TCP/IP, DNS, WINS, NFS, Agile development (Scrum, Kanban).

Development Tools: Reports Builder 6i/9i/10g, Forms Builder 6i/9i/10g, SQL Loader, TOAD, Discoverer Administrator, Discoverer Desktop and Plus 4i/10g, XML Publisher, EIS Reporting, SQL Trace, SQL Navigator, SQL Developer, Oracle Workflow Builder, JDeveloper, SQL Developer, Microsoft Office - Visio - Project, git.

Operating Systems: Windows 7/10, Red Hat Enterprise Linux 6/7, Oracle Enterprise Linux 6/7, Debian 7/8/9, Ubuntu, Mac OS.

PROFESSIONAL EXPERIENCE:

Confidential, Provo, Utah

Responsibilities:

• Responsible for assisting with the conversion of data during a systems integration process.
• Customized iRecruitment external webpage JSP forms for changing Company Logo, adding additional fields to show extra information using OA Framework.
• Mapping data from source to target, writing sql sripts, data transformation.
• Modified existing packages to add new functionality and to optimize the performance.
• Wrote stored procedures to provide extra functionality, including loading and modifying of data and retroactive business rule changes.
• Implementation of database security procedures, maintenance of Oracle databases using OEM, ASM configuration and movement of data across databases using data pump export/import utilities.
• Developing back-end PL/SQL packages, building UNIX shell scripts for data migration & batch processing.
• Experienced in Vertex (Quantum) and AVP Tax (Taxware) integration in Payroll and Receivables
• Interacted with the Business users for understanding the Requirements and subsequently developed the functional design to meet the client requirement.
• Analyzed the requirements and framed the business logic for the ETL process. Identified and designed process flows to transform data and populate the target databases.
• Prepared custom reports for various applications using XML Publisher, Reports Builder, Discoverer and EIS Reporting
• Developed Customer Conversion to load historical data into Oracle base tables and worked on Sales Order Conversion to load Historical Orders Data into Oracle Base Tables.
• Involved in Conversion of Benefit Enrollments from Third Party to Oracle for Open Enrollments
• Worked on Oracle Application Framework (OAF) to develop custom solutions for iExpense and iProcurement module. Development involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Prepared Unit Test (TE20) script for different testing scenarios to perform Preliminary data testing/loading and supporting the Integration and UAT System Testing.
• Analyzed, designed and prepared Technical document (MD 070) to implement PO Outbound to Trade shift (Legacy System).
• Developed new reports in HR, payroll and OAB modules using XML/BI and RDF. Performed unit testing and deployed them to production
• Worked on the interfaces such as, payroll costing, bank file transfer, FND user interface
• Customized forms using custom.pll and Form personalization to change the functionality of the standard PO forms.
• Extensions, Customizations and Personalization in Oracle Application Modules using Oracle Application Framework (OAF)
• Developed Transfer Rules and Open Inventory Balances Interfaces in OPM.
• Actively Involved in Design, development, testing, implementation and support inbound/outbound interfaces including - AP invoice interface, PO Import, Requisition import, Pick Release and Sales Order Interfaces, etc.,
• Troubleshooting the Production issues on Order Management, Advanced Pricing, Inventory modules.
• Testing the new functionality, identifying and resolving the issues in Advanced Pricing, Order Management (OM), Inventory (INV), Purchasing (PO) modules.
• Design and developed user interface components using ADF Rich Faces.
• Worked as a functional consultant for the implementation of Oracle Project Accounting (Costing & Billing).
• Created custom API to handle extraction, validation and migration of Sourcing Rules, Employees and Buyers.
• The implementation of the CANADA and US payroll system on GEAC Smart stream.
• Gather technical requirements and detailed interface and conversion specifications, including data mapping.
• Good Experience in Oracle Transportation Management, Logistics and Supply chain operation and Manufacturing
• Worked and resolved issues related to item images post upgrade in the iProcurement online search items for internal catalogues
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Environment: Oracle Applications R12 12.1.3 (AP, AR, GL, PO, INV, OM, iExpense, iProcurement, FAH/SLA ), Reports Builder 10g, Forms Builder 10g, Oracle Project Accounting (PA) module (Project Costing and Project Billing), SQL, PL/SQL, TOAD, BI Publisher, EIS Reporting, Workflow Builder and Administrator, SVN.

Confidential, Boca Raton, FL

Sr. Oracle EBS R12 Techno-Functional Consultant

Responsibilities:

• Enhanced and customized existing Oracle Applications, along with the AR, OM, INV and GL modules
• Prepared custom reports for various applications using XML Publisher, Reports Builder, Discoverer and EIS Reporting
• Good experience customizing and personalizing approvals using Oracle Approval Management (AME)
• Development of reports using OBIEE (using Administration, Publisher. Answers and Presentation Services)
• Developed conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs
• Created custom templates with Data Definitions for XML Publisher and Developed AP Invoice Register with POET Parameters and AP Invoice Distribution with POET Parameters reports using reports and registered as XML reports in applications.
• Developed mail notification alerts for employees, in order to settle advances in Oracle payable
• Actively Involved in Design, development, testing, implementation and support inbound/outbound interfaces including - AP invoice interface, PO Import, Requisition import, Pick Release and Sales Order Interfaces, etc.,
• Worked as a functional consultant for the implementation of Oracle Project Accounting (Costing & Billing).
• Developed Outbound PL/SQL Packages, Procedures, and Functions for validating the Purchasing, Receipts and Invoice Payments and inserting in staging table to transfer data to third Party and experienced in R12 migration analysis, mapping, conversion development and Testing.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Created custom API to handle extraction, validation and migration of Sourcing Rules, Employees and Buyers
• Gathering and reviewing of requirements specific to the International OTC & Supply Chain, review and testing of global CEMLI elements.
• Handling of other Functional issues across financial modules on a needy basis ( Receivables, Payables, Purchasing, I-Expense and General Ledger ).
• Customized various oracle standard reports to include business validations, additional parameters and columns using Reports Builder.
• Worked on building a new custom API to check the on-hand availability for a given sub-inventory and warehouse
• Process flow design & OTM Mapping with Fleet Management
• Requirement Gathering & process flow designing and configuration of OTM Solution
• Worked with functional analysts in ascertaining the requirements for the CEMLI components to be developed.
• Prepared Bank and Cash Reconciliation Reports and Other Financial Reconciliation and other standard reports
• Good Experience in Oracle Transportation Management, Logistics and Supply chain operation and Manufacturing.
• Developed various payment templates and Check printing report using BI publisher.
• Utilized Bursting feature of XML Publisher to generate remittance advices for suppliers from the PPR format Payments Output for individual supplier.
• Create and maintained party and customer information in Procure to Pay Process & Order to Cash life cycles
• Testing the new functionality, identifying and resolving the issues in Advanced Pricing, Order Management (OM), Inventory (INV), Purchasing (PO) modules.
• Worked and resolved issues related to item images post upgrade in the iProcurement online search items for internal catalogues
• Developed Adhoc Statement of Account for customer that serves as the check point before transaction.
• Customized Standard Forms Using Oracle Applications Frame Work( OAF )
• Prepared and laid out the Auto Accounting rules based on the segments configured and Project number was also considered as one of the segment values.
• Performed the standard configuration and setups for project accounting.
• Created API to handle the backordering of items that happened during the pick release process.
• Worked on Box or pallet entry validation of the quantity was completed by customizing the order entry screen.
• Developed a program to extract employee data from global temp tables as per the business requirement in a csv file format in the respective MAC server. Developed FTP scripts for moving the CSV file once employee extract is generated in oracle outbound temp data directory.
• Scheduled various concurrent programs and reports to run on a specified time daily without interrupting other standard programs using Sys Admin Responsibilities.
• Has very good experience in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively.
• As a solution architect used my technical expertise during various projects, system re-design and process improvements viz. ERP - SFDC integration using SOA, report conversion to XML, ERP upgrades etc.
• Customized PO Approval Workflow: Implemented notification reminder and Timeout needs for the PO Approval workflow and PO Account Generator Workflow.
• Executed code tweak in AMEX Transaction Loader Program to handle null transaction date and avoid transactions which business intend not to load into the oracle.
• Developed Custom PO requisition import program to validate and insert data in PO requisition interface table and call the Requisition IMPORT program
• Worked on creating a Custom Item Import program by loading legacy
• Built custom reports using Oracle Report builder and integrated them with the application. This was done to address the needs of clients as per their business requirements
• Performed systems and integration testing in multiple iterations using custom scripts
• Worked with a team to setup and import Internal Requisition and conversion to internal sales order.
• Designed and Developed Packages and custom API for applying and releasing Holds on Sales Order Header and line as business requirements using PLSQL.
• Worked with Business analysts and users on resolving critical month end issues.
• Developed Auto Lock Box interface in Oracle Receivables incorporating additional validation and loaded the data.

Environment: Oracle Applications R12 12.1.3 (AP, AR, GL, PO, INV, OM, iExpense, iProcurement, FAH/SLA ), Reports Builder 10g, Forms Builder 10g, Oracle Project Accounting (PA) module (Project Costing and Project Billing), SQL, PL/SQL, TOAD, BI Publisher, EIS Reporting, Workflow Builder and Administrator, SVN.

Confidential, Chantilly, VA

Sr Oracle EBS Consultant

Responsibilities:

• Developed In bound Custom PL/SQL Package for validating the PO Acknowledgement, and Invoices from the legacy.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Implemented Oracle R12 FAH and GL module to act as a consolidated hub for client's all accounting data and regulatory reporting requirements.
• Analyzed, designed and prepared Technical document (MD 070) to implement PO Outbound to Trade shift (Legacy System).
• Customized forms using custom.pll and Form personalization to change the functionality of the standard PO forms.
• Extensions, Customizations and Personalization in Oracle Application Modules using Oracle Application Framework (OAF)
• Developed Transfer Rules and Open Inventory Balances Interfaces in OPM.
• Actively Involved in Design, development, testing, implementation and support inbound/outbound interfaces including - AP invoice interface, PO Import, Requisition import, Pick Release and Sales Order Interfaces, etc.,
• Troubleshooting the Production issues on Order Management, Advanced Pricing, Inventory modules.
• Testing the new functionality, identifying and resolving the issues in Advanced Pricing, Order Management (OM), Inventory (INV), Purchasing (PO) modules.
• Design and developed user interface components using ADF Rich Faces .
• Worked as a functional consultant for the implementation of Oracle Project Accounting (Costing & Billing).
• Created custom API to handle extraction, validation and migration of Sourcing Rules, Employees and Buyers
• Good Experience in Oracle Transportation Management, Logistics and Supply chain operation and Manufacturing
• Worked and resolved issues related to item images post upgrade in the iProcurement online search items for internal catalogues
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked as a functional consultant for the implementation of Oracle Project Accounting (Costing & Billing).
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Worked on Quote Management in OM including creation of versions for the Quotes.
• Inventory Items configuration for OPM, ASCP, Forecast, ISO and Quality capable.
• Developed approval rules based on invoice amount for the following transaction type Payables Invoice Approval using Oracle Approval Management (AME) and configured action types and actions and set up the profile option to work for Payables only and also the required setup through Payables Options form
• Developed Adhoc Statement of Account for customer that serves as the check point before transaction.
• Customized Standard Forms Using Oracle Applications Frame Work( OAF )
• Implemented silent features of Project Accounting such as rate schedule, transaction control and auto-accounting rules, Implementation of labor cost rate schedules.
• Prepared and laid out the Auto Accounting rules based on the segments configured and Project number was also considered as one of the segment values.
• Established effective department communication and updates such as project status, release management, application downtime, upgrades and recommendations to PMO.
• Performed the standard configuration and setups for project accounting.
• Created API to handle the backordering of items that happened during the pick release process
• The PO Approval Workflow is used to approve new documents as well as approve revisions to the Purchase Orders using workflow builder.
• Used Custom PL/SQL API’S for converting open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AR Invoices, and open Purchase Orders from legacy system (Mainframe) to Oracle Applications.
• Developed an Interface to create the Drop-ship Sales Orders and Blanket Purchase Agreements against High volume transactions sourcing from Third party applications
• Developed an Interface to Hold / Release Sales Orders using Order Management APIs
• Developed PO Requisitions Interface to create new/Pre-approved requisitions
• Implemented custom Interfaces using Advanced Pricing User Hook APIs to create the Custom Price and Modifiers.
• Created FSG Consolidation Balance Sheet, Income statement and P& L reports.
• Worked on Accounts Payables (AP) Holds report to find out information on hold records.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• DBMS advancements include building data migration scripts using Oracle SQL*LOADER and UTL packages.
• Developed e-text format and electronic payments through XML Publisher for various banks, registered them as templates and assigned to Payment formats.
• Customized various forms to include additional information such as adding IBAN number on Invoice, mandatory description for Invoice Header line, etc.,
• Deployed customizations from one system to another test system as a part of UAT testing and moved the changes to the production.
• Worked on set-ups for WMS replenishment tasks. Created WMS picking rules and all WMS set ups.
• Designed the load program which loads the data from staging table to inbound interfaces of inventory, purchasing and order entry through concurrent programs.
• Worked on iExpense production fixes such as duplicate lines for AMEX transactions, incorrect
• Develop Open Purchase Orders report using XML that queries all Open PO's at header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.

Environment: Apps R12.1.3 (GL, AP, AR, INV, PO, Fixed Assets, iProcurement), Oracle Database 10g, Reports 10g, Forms 10g, EDI, PL/SQL, TOAD, XML Publisher, Workflow Builder, JIRA WINSCP, UNIX, SQL*Developer.

Confidential, Redwood city, CA

Oracle Techno Functional Consultant

Responsibilities:

• Worked on the development of interfaces using Oracle open interfaces and Oracle public APIs
• Responsible for identifying concerning areas and took corrective actions. Suggested viable solutions, analyzed functions including the identification of key trends and challenges in the industry
• Wrote PL/SQL procedures to process data in material procurement module, which enables floor engineers to procure items required for production and maintenance of machinery.
• Extensively work done on RFQ's, and Quotes in Oracle Purchasing.
• Extensively worked on Change Requests (CR's) and preparing the BRD's, FD's on OM, Advanced Pricing module
• Design and developed SPSS wizard components using ADF task flows (BTF and UBTF), train stops, regions, templates and fragments.
• Extensively worked on Price Lists, Modifiers, Qualifiers, Pricing Attributes in Advanced Pricing and created the setups in TEST instance
• Created management analysis reporting using Parallel Queries, Java stored procedure, HTP Package and WEB .SHOW DOCUMENT . Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
• Customizing and personalizing approvals using Oracle Approval Management (AME)
• Developed custom reports as per client requirement in OPM Forecasting module.
• Created Discoverer Reports for GL, AP, AR, ASCP and OPM modules using Discoverer Administrator and Desktop Edition. Created Custom Folders, Business Areas, and Workbooks. Assigned Privileges and registered the reports in Oracle Applications.
• Integrated client's all external Source systems with Oracle R12 FAH and GL module in phases as wells as integrate Oracle 11i GL, which is their current Oracle EBS environment, with R12 GL.
• Applications. Customized the Workbooks by adding additional functionality (conditions, calculations, parameters, sorting, etc.) and scheduling them for the users.
• Involved in creating UNIX shell Scripting . Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Gathered and analyzed business requirements. Documented functional requirements pertaining to financial modules and security features in Project Accounting and OTL.
• Worked on Billing events, Project costing, Budgeting and Project Management.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle .
• Converted reports to XML version (BI publisher) to generate XML output, thus avoiding the use of RDF and resulted in better performance
• Customized existing Dunning Report and Invoice Printing Report in AR using XML publisher
• Fine-tuned PL/SQL procedures and SQL queries for improved performance. Adopted Explain Plans to analyze and used SQL Hints wherever required.
• Developed various payment templates and Check printing report using BI publisher.
• Utilized Bursting feature of XML Publisher to generate remittance advices for suppliers from the PPR format Payments Output for individual supplier.
• Design and development of custom POA Inbound Process to process the external subledgers accounting data in form of Pass-through/Event to Oracle GL using FAH and SLA Create Accounting Process.
• Performed benchmark studies/trend analysis, analyzed business processes, using various tools to assist in the critical decision making process.
• Involved in setup and implementation of Service Contracts depending on functional setup changes/enhancements.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Responsible for the development of conversions/interface programs - Barter Tax interface, Conversion of service contracts from quotes
• Analyzed, Designed and developed Interfaces for AR (Customer, Auto Invoice and Auto Lockbox) and Cash Management (Bank Statement Interface) developed custom check format program in AP.
• Worked on the Auto Lockbox in receivables that automatically creates receipts using the electronic information that the bank provides.
• Developed interfaces and conversion programs with respect to financial modules to integrate Oracle Applications modules
• Prepared functional and technical specifications and test scenarios using AIM methodology
• Developed reports using Reports Builder and PL/SQL. Manpower forecast and planning, daily and monthly production, goods receipt note, inspection report, acceptance & rejection reports, issue of material, material utilization.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Involved in providing consultancy services on business operations inclusive of entry strategies & executing targets in given timeframe.
• Used SQL*Loader and UTL FILE Packages for data conversion and interfaces.
• Hands on experience on advanced SQL/PLSQL concepts as Advanced Queues, Materialized views, Records, Collections, Dynamic SQL, Ref Cursors, DBMS XMLGEN, autonomous transactions etc.
• Wrote pre-migration validation package to capture foreseen inventory migration errors from 11i to R12
• Worked on life cycle implementations using Oracle applications R12
• Experience in working with PL/SQL, SQL Loader, Workflow 2.6, Oracle 10g, manufacturing and sales distribution modules
• Undertook the responsibility to prepare master schedules for projects, including resource schedules, execution methodologies, milestones, cash flow projections / budgets, and periodic monitoring
• Customized order management, shipping, and inventory reports, which include pack list, bill of lading, sales acknowledgement report among others

Environment: SQL Developer, Oracle Applications 11.5.10.2/12.0.6 (EBS), (GL, OM, PO, AP, AR), Oracle Database 10g (SQL, PL/SQL), SQL *Loader, SQL *Plus, Forms/Reports builder 10g, BI Publisher, UNIX

Confidential, NY

Sr. Oracle Techno Functional Consultant

Responsibilities:

• Worked as an Oracle Applications Consultant for Oracle Apps R12 suite including AP, AR, GL, PO, OM and INV as part of the customer requirement.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the Customers using TCA (Parties, Party Sites, Party Accounts, Party Account Uses), Items, Item Categories, Item Revisions, Open Sales Orders etc., from legacy system.
• Developed and modified a number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Wrote Shell Scripts for Data loading and DDL Scripts .
• Configuration of Oracle Project Costing Auto Accounting to standardize and streamline the account generation for material, labor and miscellaneous transactions.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc
• Performed Server & Application fine-tuning & troubleshooting. Monitored MS SQL Server performance and network issues.
• Setting up Pricing Attributes, and Pricing Contexts in Advanced Pricing.
• Creating Multi-Currency conversion setups in Advanced Pricing for various items.
• Developed Warehouse Rules and Production Batches interfaces in OPM.
• Utilized VB DLL, EXE, XML, XSLT, XML Schema, Source Safe.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Used Oracle JDeveloper to support JAVA, JSP and HTML codes used in modules.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
• Configuration of key areas in Project Costing, Project Billing and suggesting suitable Business flow setups to the client
• Defined Project related setup options, Project Resource calendar and identified the Project organizations, Project types, Project Templates, Task related setup and Project related workflow and profiles
• Involved in customizing the Project Accounting suite for reporting activities in order to record and see the monthly P&L by Project Number.
• Development and testing of Quotes created from Service Contracts which is known as Super Quotes using oracle standard API
• Involved in creating UNIX shell Scripting . Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Involved in code review, code migration and code test.
• Developed approval rules based on invoice amount for the following transaction type Payables Invoice Approval using Oracle Approval Management (AME) and configured action types and actions and set up the profile option to work for Payables only and also the required setup through Payables Options form.
• Worked on Auto Lockbox Open interface for automatic processing of receipts in AR module.
• Worked on Suppliers, Supplier Sites conversion and Invoices for the players using AP Invoice Interface.
• Development of customer interface using Oracle standard TCA API's including DQM rules .
• Responsible for development of AP--AR Netting Interface, de-activation of Parties and Customer Accounts in AR/TCA.
• Developed packages to validate and to load data from staging table to interface tables related to procure to pay life cycle.
• Developed New Forms for the warehouse inventory management using Oracle forms 10g and deployed them to the Application server.
• Implementation of the Manufacturing and Supply Chain Management applications of the Oracle e-Business Suite, including Work In Process, Planning, Production Scheduling, Shipping, Order Management, Bills Of Material, Inventory and Costing.
• Customized Purchase order and receipt history forms to find the Inventory status.
• Responsible for converting all the Historical Invoices using Payables Open Interface Import into Production.
• Developed Interface to Make Adjustments and Earnings for the offers using OZF FUND UTILIZED PUB.Create Fund Adjustment in Trade Management.
• Purchase order Inbound EDI Interface (850/Orders).
• Performed daily administration, maintenance and support of Oracle Database and Applications Servers used for web-based ERP environment and SQL Server environment
• Developed PO Receipts Inbound interface reads the data from the custom table and performs PO inspection and creates Accept and Delivery transactions in Oracle Purchasing. On successful creation of Delivery transaction the interface will generate an email notification to business users.
• Developed custom interface for allocating number of cases per New Item Release per Territory.
• Developed many inbound/outbound interfaces using Oracle Standard APIs for Pricing Modules and Order Import Processes.
• Developed custom program to validate and load the Sales orders from a third party into Oracle Order Management interface table. Used Order Import Open Interface program to load the data into Oracle base tables.
• Developed Reports in Various Models using XML/BI Publisher
• Lot Traceability Report
• Supplier Audit Report
• Closed and open Order Reports
• Inventory Item Report
• Weekly Sales Report
• Brokers Commission Reports
• Developed custom layouts for user facing documents like invoice and receipt using XML Publisher and generated data definitions for these reports using report10g.
• Performed migration of lookup types, value sets, Descriptive Flex fields, Profiles, XML templates, concurrent programs, request sets, request groups, menus, responsibilities, and alerts between database instances.
• In addition, also used the System Administrator responsibility to create users, responsibilities, custom profiles, request groups, request sets and Value sets.
• Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions.
• Developed Custom Customer View only responsibility using OAF.
• Experience in using Oracle Applications Framework (OAF) Personalization tool & developed OA Extension using JDeveloper with OA Extension.
• Design of Oracle Discoverer reports based on requirements.
• Excellent analytical skills in Analysis and business requirements gathering from end users to the client and experience in design using MD50, MD70 documents.
• Interacted with users to resolve any issues during the production, development and enhancement phases.

Environment: Oracle Applications R12, Oracle 10g, Forms 10g, Reports 10g,Discoverer10g, Workflow Builder 2.6.3.5, XML/BI Publisher, SQL,PL/SQL,TOAD,OAF,EDI and SQL* Loader.

Confidential, Pittsburg, PA

Oracle Applications Developer

Responsibilities:

• Wrote PL/SQL packages, procedures, and functions scripts to validate data before loading into Oracle HR tables. End date non-active user responsibilities
• Involved in the performance enhancement of the applications by tuning PL/SQL, SQL scripts
• Provided support for the applications after the production migration
• Created new PL/SQL packages, modified existing packages as per client requirements, worked with team members on the usage of PL/SQL related development
• Implemented order returns with and without credits, which involved setting up transaction type, loading order using SQL Loader, creating receipts to close the order
• Used Oracle JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like Java, .Net and Hierarchical databases like Oracle and Access.
• Customized check printing report to give XML output according to client requirements to feed a third party check printing utility, invoice print report, etc.
• Developed auto apply credit to invoice (AR) and implemented a unique solution to resolve manual application of invoices to credit memos using AR RECEIPT API PUB
• Worked on employee benefits extraction for third party venders like CIGNA, DELTA DENTAL, using utl file utility
• Worked on personalization of forms for HR related validation purpose and to append the fields in the form
• Development and enhancements of the reports for core HR, Payroll, OAB modules using Reports6i and XML Publisher
• Wrote shell scripts for FTP, SFTP, encryption, and decryption
• Customized New Hire V4.0 workflow process for contingent worker maintenance
• Extraction of employee, payroll and benefits data from HR, PAY and BEN tables using custom views
• Worked on extraction of Oracle HR and payroll data, which requires ADP for processing the payments
• Created business areas for multiple business requirements in Discoverer Administrator and created multiple workbooks using Discoverer Plus. Created security profiles for Discoverer 10g end users
• Worked on auto creation of purchase orders for catalog items with valid vendor information. Updated vendor and buyer details based on deliver to location codes and category types
• Worked on back feed of processed payroll data from the third-party payroll provider (ADP) to the current HRMS application

Environment: SQL Developer, SQL *Loader, SQL *Plus, PL/SQL, Oracle Database 10g, Oracle Applications 12.1.3 (EBS), Forms/Reports builder 10g, Function State Generator (FSG), System Administration, Oracle Workflow 2.6, Application Object Library (AOL)

Confidential

Oracle EBS Techno Functional Consultant

Responsibilities:

• Analyzed the various reports that require customization in OM and Inventory. Customized Sales Order Acknowledgement report to meet the business requirements for Retail orders.
• OM Customization - Forms Personalization for Related Item Price and Quantity.
• Prepared categorized iProcurement catalog for different kind of items used in the company.
• Created Oracle Business Areas and Workbooks using Discoverer.
• Developed many inbound/outbound interfaces using Oracle Standard APIs for Pricing Modules and Order Import Processes.
• Migrated Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports from 11i to R12.
• Work flow customization to auto creates PO for Low Value requisitions.
• Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.
• Involved in Process Mapping, Gap Analysis and Module design and implementation for iprocurement.
• Involved in adding new descriptive flex field in Order Management to capture additional data.
• Created and customized reports using XML Publisher/BI Publisher in OM, PO, AP, AR and INV.
• Developed Auto Invoice Interface program to import invoices from legacy systems to Oracle Receivables.
• Used Auto Invoice to import Standard Invoices into Oracle Receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import Program.
• Customized the existing workflow by adding notifications at the time of Purchase Order approval and also involved in customizing Requisition package in iProcurement modules as client requirements .
• Customized PO Approval workflow process using Workflow Builder and define processes based on the purchasing amount and ship to location.
• Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions.
• In addition, also used the System Administrator responsibility to create users, responsibilities, custom profiles, request groups, request sets and Value sets.
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components.

Environment: Oracle EBS 11.5.10.2 (OM, INV, PO, AR, AP), SQL *Loader, PL/SQL, XML Publisher, Forms and Reports, TOAD.

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in the complete Order to Cash, Procure to pay cycle, Oracle Grants and Projects implementation.
• Developed Auto Invoice Interface program to import invoices from legacy systems to Oracle Receivables.
• Used SQL*Loader for import into custom tables and PL/SQL for complete validation of data and inserting into interface tables.
• Preparation of SQL *Loader Control Program and PL/SQL script with validation to upload data from flat file to oracle Applications base tables.
• Configured, tested and built all the financials modules (AP, AR, CE, GL) and assisted in the Oracle Projects setup.
• Development of GL Daily Rates Inbound Interface to upload data from flat file to Oracle Applications base tables.
• Performance monitoring and tuning on UNIX systems. Develop step-by-step method using predesigned worksheets to eliminate much of guesswork in performance monitoring and tuning.
• Developed new Custom Oracle 6i, SQL, PL/SQL Reports as per the business requirement.
• Customised of AP invoice aging report as per client requirement.
• Preparing the MD070 Documents based on MD050 for each component.
• Developing Custom Interface Programs and XML Publisher reports.
• Extensively utilized the application object library to register SQL*LOADER programs, PL/SQL procedures, forms and reports.
• Developed reports for Order management, BOM modules.
• Development and customization of reports.
• Integration Objects Cross checking with Account Payable, Account Receivables & General Ledger Modules.
• Create and define template and data definitions for Open Purchase Order report. Conditionally display company logo information based on run time parameters.

Environment: Oracle Applications 11i (OM, PO, FA, GL, GA, AP, AR), Workflow Builder, SQL * Loader, PL/SQL, Developer 2000/6i, XML Publisher, TOAD.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Develop Open Purchase Orders report using XML that queries all Open PO's at header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.
• Worked with SQL Loader and PL-SQL Built in packages to convert VAX data into Oracle Applications as necessary.
• Customize and convert existing RDF reports that will run compatible as per the new multi-org structure and user requirement.
• Created and customized reports using XML Publisher in OM, AR, AP and INV.
• Developed Sales order conversion using standard API.
• Wrote PL/SQL packaged procedure to be scheduled as concurrent program to identify and place payment holds for 'Contract Retention' invoices.
• Converted Oracle 6i Reports and SCM reports to BI publisher reports.
• Created and customized reports using XML Publisher/BI Publisher in OM, PO, AP, AR and INV.
• Customizing & enhancements on Forms.
• Imported Bills and Routings through BOM Interfaces.
• Extensively used SRW packages in Oracle Reports.
• Created Discoverer Reports for GL, AP, AR, ASCP and OPM modules using Discoverer Administrator and Desktop Edition. Created Custom Folders, Business Areas, and Workbooks. Assigned Privileges and registered the reports in Oracle Applications. Customized the Workbooks by adding additional functionality (conditions, calculations, parameters, sorting, etc.) and scheduling them for the users.
• Creation of Value sets in various Modules of the application.
• Uploaded all the concurrent program details into another instance by using FNDLOAD commands.

Environment: Oracle APPS 11i (OM, INV, PO, AR, AP, GL), SQL, PL/SQL, Discoverer, Developer 6i, TOAD, Oracle Developer 2000(Forms 6i and Reports 6i).