SUMMARY

• Over 7+ years of extensive experience as Oracle Applications Technical consultant in implementation, upgrade and customization of Oracle e - Business Suite Applications (11i/R12/R12.2.5) in various modules with major focus in financial modules and supply chain modules.
• Proficient in developing RICEW components for concurrent programs, workflow, business events and OA framework personalization and customization.
• Having experience in Oracle R12.2.5 coding standards and editions concepts and deploying customizations.
• Experience in creating transactions in Oracle E-Business suite based on the interfaces from Red Prairie and other local systems.
• Experienced in calculating the on hand balances and interface balances to ATP systems.
• Extensive experience in implementation, customizationand Application supportactivitiesof various modules with major focus in General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Fixed Assets (FA), Order Management (OM), Inventory (INV), Purchasing (PO), Warehouse Management System (WMS).
• Proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
• Experienced in coding PL/SQL for Creating EDI files to Invoices for Customers.
• Extensively used TCA (Trading Community Architecture) to create customers in AR.
• Experienced in Oracle space developing PL/SQL against Order Management, AR, Inventory, and Channel Revenue Management modules.
• Familiarity with the functionality of the core Oracle Financial modules and their interplay in the overall accounting structure of an organization.
• Inherent knowledge of integrating Oracle Financials with Order Management and Costing.
• Proficient in development of interfaces and conversion programs to integrate Oracle Application Modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader, UTL FILE, Oracle Packaged APIs etc.
• Experience in Customization and development of reports using Oracle Reports 6i/10g and XML Publisher.
• Good knowledge of financial statements like balance sheet statements.
• Experienced in Tuning of SQL queries and PL/SQL code TRACE, TKPROF, PL /SQL profilers.
• Experienced in creating Tables, Constraints, Indices, Triggers and Packages with optimization techniques.
• Proficient in writing UNIX shell scripting.
• Expertise on designing and implementing Oracle Alerts and Lookups.
• Coded complex conversions to extract data from various partner systems using ODI (Relational databases, Files and AS400 libraries)
• Strong experience in using Dynamic SQL using EXECUTE IMMEDIATE and DBMS SQL packages to support volume.
• Strong Knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC)
• Experienced in Oracle SysAdmin and AOL-Registering Concurrent Programs, Request Sets, Form Functions, creating users, Defining Profile options and creating Flex fields using Application Developer and System Administration responsibilities.
• Expertise in writing Functional, Technical, Mapping, Testing and Training documents like MD050, MD070, MD120, CV040, CV060, TE020 etc. according to the business requirements.
• Good understanding of Oracle Applications Design, Data flow and integration between modules.
• Experienced in various test cycles like unit testing, System Integration testing, User Acceptance testing and test plan, test scenarios and test cases.
• Experience in Creating, managing Oracle service requests through metalink.
• Extensively used Technical Reference manual and Metalink to debug technical issues.
• Ability to work directly with business users to gather business requirements, analyze/translate into requirements document and develop specifications to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedule and possess good communication skills.

TECHNICAL SKILLS

ERP Applications: Oracle Applications 11i/R12 (GL, AP, AR, FA, CM, FA, PO, OM, INV, WMS)

Programming Languages: SQL, PL/SQL, Java

Tools: TOAD, SQL Developer, SQL*Plus, Data Loader, Web ADI, Discoverer.

Development Tools: Oracle Forms/Reports 6i/10g, XML Publisher, Workflow Builder, OAF

Databases: Oracle Database 9i/10g/11g

Operating Systems: Windows NT/XP/2007, LINUX, UNIX

Change Management: PVCS, Source Code

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Apps EDI Consultant

Environment: Oracle Applications R12 (Accounts Receivables, Order Management, Inventory, Purchasing), Workflow, Reports, XML Publisher, OAF, Oracle 11g/10g,TOAD, SQL Developer.

Responsibility:

• Analyzes, designs, and develops new applications/business systems and application enhancements according to business specifications and technical designs; creates technical specifications and documents deliverables
• Documents application requirements and models current/proposed information and process flows
• Ensures unit, system, and integration test plans exist, performs quality reviews of testing and coordinates testing across all teams
• Reviews work of others to ensure design approach and delivered product is consistent with business requirements
• Ensures all appropriate technical documentation is completed and up-to-date (program, system, change management, etc.)
• Assists in re-engineering system related processes
• Functions as subject matter expert in those areas where extensive knowledge is present
• Proficient in, and assists others in using programming aids and tools, utilities, database access methods, and systems software
• Addresses development issues escalated within the team
• Keeps abreast of current and emerging information technology and trends
• Managing Resources
• Assists in the following project efforts: creating project plans with timelines, resolving problems on scheduling, controlling projects, ensuring deadlines are met
• Assists in overseeing analysis, design, and development of new systems and enhancements according to internal customer expectations and technical design
• Assists in preparation of cost benefit analysis and estimates.

Confidential, Chicago, IL

Sr. Oracle Apps Financial Technical Consultant

Environment: Oracle Applications R12 (General Ledger, Accounts Payables, Cash Management, Accounts Receivables, Fixed Assets, Order Management, Inventory, Purchasing), Workflow, Reports, XML Publisher, OAF, Oracle 11g/10g,TOAD, SQL Developer.

Responsibility:

• Involved in developing/reviewing Data Conversions, Data Mapping, Data Extraction and Open interfaces related to Finance modules.
• Involved in coding and unit testing of Fixed Assets and AR invoice conversion programs.
• Imported journals data into GL using Journal import interface.
• Worked on Auto Invoice Interface program to validate and load credit memos, debit memos and invoices from legacy system.
• Developed GL Exchange Rate interface program.
• Developed Fixed Asset Detail and Summary reports using XML Publisher.
• Customized AR-CE Bank Reconciliation Batch Info report.
• Customized AP Invoice Register XML Report.
• Worked on the Budget Upload Open interface to load data from legacy systems to GL Budget interface tables using SQL*Loader.
• Modified AP Fuel Payments report to get correct totals.
• Supported Procure to pay and Fixed Asset issues during month end performing additional configurations.
• Developed PLSQL program to calculate the balance based on Sales Orders, Purchase Orders, Warehouse Transfer Orders and Misc.
• Adjustments and interfaced to ATP systems, which are integrated with Order Entry system.
• Fully involved in month end closing process of financial modules.
• Performed customer data conversion using dynamic SQL and ODI.
• Developed common error logging package to support various errors from Reports, Interfaces, Conversions and Extensions.
• Provided conversion dashboard executive summary reports to management.
• Provided data quantity reports on the conversions and assisted team with data quality by providing data into excel.
• Performed customer conversion including Sites, Site Usages, Bank Accounts, Credit Cards, and extensible attributes.
• Designed reports on GL, FA and AP modules to show the ABGIL invoices and payouts.

Confidential, MI

Sr. Oracle Apps Techno-Functional Consultant

Environment: Oracle Applications R1225 (General Ledger, Accounts Payables, Cash Management, Accounts Receivables, Fixed Assets, Order Management, Inventory, Purchasing, Warehouse Management System), Workflow, Reports, XML Publisher, OAF, TOAD, SQL Developer.

Responsibility:

• Worked as technical consultant on numerous RICEW components.
• Developed Workflow components with messages, notifications, PLSQL Functions.
• Experienced with OA Page personalizations and customization.
• Performed data conversions for Install Base, Service Contracts using APIs.
• Coded customization to update serial numbers in CSI ITEM INSTANCES due to virtual warehouse fulfillment.
• Developed an outbound interface from EBS to GDW (Global Data Warehouse) for Service Contracts with Party, Account, Address and Item instance information.
• Wrote MD070 for multiple components.
• Involved in developing/reviewing Data Conversions, Data Mapping, Data Extraction and Open interfaces related to Finance modules.
• Performed customer data conversion using dynamic SQL and ODI. Created tables on the fly to segregate customer data and enable parallel processing.
• Coded Fixed Assets and AR invoice conversion programs.
• Involved in customer conversions to load customer details into HZ tables by creating staging tables and performing validations and finally loading them into base tables using TCA APIs.
• Imported journals data into GL using Journal import interface.
• Experienced in performance and tuning with trace options.
• Worked on the Budget Upload Open interface to load data from legacy systems to GL Budget interface tables using SQL*Loader.
• Developed custom AP Invoice Duplicate Report to verify INVOICE duplicates from vendors and validate against the checks paid for the INVOICES.
• Supported Procure to pay and Fixed Asset issues during month end performing additional configurations.
• Developed PLSQL program to calculate the balance based on Sales Orders, Purchase Orders, Warehouse Transfer Orders and Misc.
• Adjustments and interfaced to ATP systems, which are integrated with Order Entry system.
• Created custom PLSQL packages to support Cycle Counts by Items regardless of revisions.
• Holding Workshop sessions to dive into the key requirements, enhancements and Impact Analysis for all Financial Modules.
• Fully involved in month end closing process of financial modules.
• Performed customer data conversion using dynamic SQL and ODI.
• Developed common error logging package to support various errors from Reports, Interfaces, Conversions and Extensions.
• Provided conversion dashboard executive summary reports to management.
• Provided data quantity reports on the conversions and assisted team with data quality by providing data into excel.
• Designed reports on GL, FA and AP modules to show the ABGIL invoices and payouts.
• Developed Hyperion Actual interface to send the data from OEBS as outbound.
• Developed Currency Exchange Rates to load from SMERT system.
• Developed Pre-and Post-Processor extensions on AR Auto invoice to support Tax and Group Combination Orders.
• Developed interface to send dunning letters from OEBS to external system.

Confidential, FL

Sr. Oracle Apps Techno Functional Consultant

Environment: Oracle Applications 11.5.10.2/R12 (General Ledger, Accounts Payables, Cash Management, Accounts Receivables, Fixed Assets, Order Management, Inventory, Purchasing, Trading Community Architecture), Workflow, Reports, XML Publisher, OAF, TOAD, SQL Developer.

Responsibilities:

• Actively involved in Interface/Conversion of Financials & Supply chain modules such as GL, AP, AR, and FA, CM, OM, INV and PO modules.
• Developed AP Positive Pay Extract report in Oracle Payables to send the transactions from Source system to Bank.
• Involved in the month end closure and reconciliation activities to close the periods on respective financial modules
• Designed and developed customized solution for Oracle Fixed Assets to resolve depreciation issues.
• Created new packages and procedures for a new RL export file using the existing procedure that contains only RL information.
• Customized the following reports as per business requirements
• Customized the Standard Trail Balance Report as per the business requirements.
• Adjusted the current methodology to bar general record accounts just for the RLC and from the SCDCT sections that post every month end before the end of financial year.
• Developed custom program that creates receiving transactions for inter-company sales orders associated internal purchase order is interfaced to AR.
• Provided daily user support for financial modules and applied patches as and when required to resolve the Application issues.
• Perform database tuning, performance monitoring and perform general technical troubleshooting.
• Worked on Various UNIX scripts to invoke FTP files, email reports.

Confidential, PA

Sr. Oracle Apps Technical Consultant

Environment: Oracle Applications 11.5.10.2/R12 (General Ledger, Accounts Payables, Cash Management, Accounts Receivables, Fixed Assets, Order Management, Inventory, Purchasing, Trading Community Architecture), Workflow, Reports, XML Publisher, OAF, TOAD, SQL Developer.

Responsibilities:

• Involved in the up-gradation of the Application for all financial and supply chain modules like GL, AP, AR, FA, CM, OM, PO and INV.
• Customized Auto Lockbox interface such that the receipt file from the bank is automatically imported into Accounts Receivables.
• Designed and developed multiple FSG reports on Budget and Actual balances, crossing over fiscal periods as per business requirement.
• Data mapping for Open Invoices, Customer, Supplier in AP and AR with standard and custom Interface.
• Worked with Procure to Pay process flow, specifically working with the Oracle Purchasing (PO) and Oracle Accounts Payable (AP) modules.
• Worked on Importing Asset Information into Oracle Assets Using Mass Additions in Fixed Assets (FA).
• Extensively registered various AOL objects such as Value Sets, Custom responsibilities, Security profiles and Lookup values.
• Developed reports using reports 6i and XML Publisher in GL, AP, AR modules.
• Involved in transforming Data Marts from warehouse builder to Oracle Discoverer business areas in Admin edition.
• Customized payables transfer to General Ledger report; Invoice Validation and Invoice On Hold Reports in Oracle Payables.
• Involved in developing various reports like Trial balance, trading account, Profit & Loss account, balance sheet etc., instantaneously for a given period of time.
• Customized the Invoice, Sales Tax Report in AR.
• Developed SQL Loader Programs and PL/SQL procedures to load data into Oracle from various feeder systems.
• Developed Backorder Report that will give the output in Excel format as per the client requirements.
• Designed and Developed Outbound Programs for orders and shipping, which picks data based on released status.
• Worked on Various UNIX scripts to invoke FTP files, email reports.

Confidential

PLSQL Developer

Responsibilities:

• Assisted in Data modeling and created tables using normalization.
• Extensively used PL/SQL and SQL.
• Responsible for the complete system analysis and design.
• Wrote SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Created indexes for the system performance.
• Worked on various backend Procedures and Functions using PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created various Database triggers using PL/SQL
• Generated a number of reports for management to review for system functionality as against the old legacy system.
• Worked with various functional experts to implement their functional knowledge into working Procedures.
• Assisted data generations using UTL FILE and scheduled FTP jobs.
• Maintained Job execution log history.