SUMMARY

• More than 9 years of experience as a Techno Functional Consultant in Oracle Application implementations, upgrades, maintenance and support.
• Performed several end to end implementations, post production support, end user training and documentation.
• Expertise in filling the gaps using custom components based on the clients requirements.
• Experience in Oracle R12, 11i Full Life Cycle implementation in the areas of GL, AP, AR, PO, OM, and INV.
• Proficient with Order to Cash and Procure to Pay cycles, covering modules like GL, AP, AR, PO, OM, INV and BOM.
• Experience in global treasury functions including banks, Cash Management.
• Expertise in designing process flows for each functional area during the implementation, carrying out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and CRP’s.
• Experienced with the BAI electronic cash management balancing.
• Experienced in creating the signature image blocks.
• Extensive experience in designing and implementation RICE Components (Reports, Interfaces, Conversions & Extensions) and Data Migration.
• Expertise in Database management, Design and creation of schemas, writing stored procedures, functions, packages, views, DDL, DML, SQL quires .
• Worked on many form personalizations and hands on experience in using the Oracle Application frame work.
• Worked on Cash management Module for debugging the issues related to Lock Box programs.
• Created custom workflows, forms and reports using Oracle Workflow builder, Form builder, Report builder and XML publisher.
• Experience in working with multiple business integrations using Informatica and web methods for inbound and outbound processes.
• Strong Technical skills in using SQL, PL/SQL packages, procedures, functions, views for Reports, Forms and concurrent programs .
• Experienced in performance tuning, to achieve the best program to finish a task.
• Functional Testing, creating test scenarios, test data and execution of test cases to ensure application functionality meets the user requirements.
• Expertise in using different tools like Toad, Winscp, Putty, SQL Developer, SQL Loader etc…

TECHNICAL SKILLS

ERP Packages: Oracle Applications 11i, Oracle Applications R12

Modules: INV, BOM, PO, OM, AP, AR, CE, Global Treasury, GL

Software’s & Tools: Oracle Apps (ver. up to R12), Oracle Workflow Builder, Oracle Form Builder, Oracle Report Builder, SQL* Plus, SQL* Loader, XML Publisher, TOAD, Putty, Secure Shell, Winscp, Informatica, Web methods, Appworx, KintanaOperating Systems Microsoft Windows (up to Windows 8), LINUX

Languages: SQL, PL/SQL, Java, HTML, XML, CSS,C, C#.net, Unix Shell Scripting

Office Environments: Microsoft Office (ver. up to 2013)

PROFESSIONAL EXPERIENCE

Oracle Techno Functional Consultant

Confidential, Austin, Texas

Responsibilities:

• Created new processing constraints, defaulting rules, concurrent programs, form personalization’s, PL/SQL packages.
• Analyzed all the custom triggers on tables related to O2C cycle.
• Had several meetings with all the owners of the Business Units to understand their actual requirements and the need for the custom trigger.
• Analyzed the trigger functionality and standard ways to achieve the similar functionality.
• Worked on Cash Management Module, as one of the trigger functionalities are related to it.
• Worked on Global Treasury Functions.
• Worked on configuration for Account Receivables, Payables, Banks and Cash Management as per the new R12 features.
• Defined setups and configured AP, AR and GL modules with R12 new features
• Setting up System Profiles, Application Security (user, menus and responsibilities) Flex fields, Value sets, Ledgers, COA, Calendar and Currency.
• Worked on BAI electronic cash management balancing, to generate the BAI files.
• Defined Customer profile classes, bank accounts, payment terms, distribution sets and Credit.
• Worked with Oracle team closely and found many new patches that can fulfil the business requirements.
• Provided the alternate solutions to achieve the similar functionality of the trigger.
• Explained the owners of the BU’s how the trigger functionality can be achieved by using the Processing Constraints, Form personalization’s, defaulting rules, business events, concurrent programs.
• Based on the requirements we have provided an alternate solution to the BU’s and provided the fit to gap analysis.
• Developed a new interface process to import the Orders from different sources.
• Created all the Functional and Technical Requirements documentation.
• Disabled 80% of the triggers on Order Lines table.
• Worked with the load test team to develop the testing scripts so that they will hit the triggers.
• Worked with ASCP team to understand the ASCP functionality and disabled few triggers whose functionality can be achieved by ASCP (Oracle Advanced Supply Chain Planning).
• Co - ordinated with many BU’s for testing the changes and ensuring that the functionality remains same and performance is improved.
• Worked with Load test team, Compuware Team to measure the performance improvement.
• Worked with DBA team to take the traces and analyzed the traces to eliminate the costly SQL’s.
• Co-ordinated with multiple ongoing projects, so that no one is effected by the trigger changes.
• Modified the Oracle defaulting rules to meet the I-store Order requirements.
• Modified the Order Line workflow process by adding an additional process.
• Worked on all the issues and additional requirements during the SIT and IAT testing.

Environment: Windows8.1, Oracle Applications R12, Oracle ASCP, Oracle Istore, Oracle Workflow Builder, TOAD, HPQC, Winscp, Putty.

Oracle Techno Functional Consultant

Confidential, Schenectady, NY

Responsibilities:

• Responsible for BR100, BR150, CF250, Unit test document creations and performing unit test.
• Responsible for interacting with Confidential client for requirement gathering and code reviews and performing analysis on the components developed.
• Responsible for Conversion process for Projects and Tasks and Cost conversions from legacy system to Thermal ERP.
• Responsible for customizing few web based forms using OAF.
• Designed steps for implementation and prepared the business documentation for implementation and supporting of R12 using the SDLC/AIM Methodology and Advanced Global Intercompany System.
• Setting up Approval hierarchies for the applications of AR, CM, AP, and defined EB Tax such as Codes, Rates, Exceptions and Exemptions.
• Responsible for making the Initial setups in all the instances as per BR100, BR150 documents.
• Managing the work load by dividing the work with off shore team members and getting total productivity.
• Working with the team members and testing the functionality of each component to match the client’s requirements.
• Involved in SIT and UAT and also worked on few HPQC tickets.

Environment: Windows8.1, Oracle Applications R12, XML Publisher, TOAD, HPQC, Winscp, Putty.

Oracle Apps Techno Functional Consultant

Confidential, Cincinnati, OH

Responsibilities:

• As part of Implementation developed outbound interfaces in AR module.
• Worked on Customized Revenue AFF process for distributing revenue segments based on business requirements.
• Worked on few objects in RSP e-BOM integration. (RSP is Revenue Sharing Program, a custom module created for Confidential Aviation.)
• Worked on few objects in RSP Master Data maintenance process.
• Worked on few objects in RSP Inventory Management Process.
• Worked on few objects like compensation calculations, entitlement calculations, fallout, and Customer exceptions in RSP Finance recovery process.
• Worked on Custom process for Discount re-classifying accounts in AR.
• Worked on outbound interfaces like IBS, WAWF to extract AR invoices and send the file in required formats to process further in legacy systems.
• Worked on various SQL and XML reports on invoices using sub templates and calling various templates based on org and other validations.
• Worked on customizing user defined Costing process for all items in particular organization.
• Worked on warranty claims system process in AR with required validations.
• Worked on Cost Management System process which contains extraction of costs for outbound and inbound process.
• Processed defined for validating the costs and matching them for a given period.
• Customized process for journalizing the records and transferring to records to GL.
• Worked on building custom forms as per user requirements and few form personalization’s.
• Worked on creating a custom workflow for generating COGS account number as per the clients requirements.
• Worked on a custom process for generating invoices in Central AR operating Unit for collections purpose.
• Worked on various custom processes related to AR.
• Worked on form personalization for generating PDF and email that PDF to the user for Manual invoice in AR form.
• Worked on AR Unbilled Shipment Accrual Report, Inventory Value Report by Warehouse and Warranty customer sites report.
• Worked on QC at the time of SIT and UAT for defects resolutions.
• Worked on Appworx for scheduling chains in AR.
• Knowledge on Kintana tool for code checkouts and migrating objects from one instance to other.
• Responsible for CF250, BR100, Unit test document creations and performing Functional Testing.
• Responsible for interacting with Confidential client for requirement gathering and code reviews and performing analysis on the components developed.

Environment: Windows 7, Oracle Applications 11i, Oracle Form Builder, Oracle Workflow Builder, Oracle Report Builder 6i/2.5, XML Publisher, TOAD, SQL* Loader, Informatica, Web-Methods, Putty, Winscp

Oracle Apps Consultant

Confidential

Responsibilities:

• As Change Manager, involved in analysis, estimation, scheduling of enhancements and resources.
• Responsible for supporting all inbound and outbound interfaces of Confidential which were integrated with SOA architecture and BPEL process.
• Responsible for personalization and customizations in self service pages using OAF.
• As Enhancement team member, involved in design and development of various enhancements required by Confidential .
• This included working on workflows, reports, interfaces, shell scripts, PL\SQL codes.
• As Support Team Member, resolved technical, functional issues of business users. Analyzed Change Requests by the business, coding, documenting and testing the code changes.
• Supported already developed reports and customizations. Interacting with Confidential Corp and users for SR related activities.
• Resolving end users issue related to Purchasing, Setups and users setups in production environment.
• Extensive documentation to record new enhancements carried out. Also creation of test cases and test plans for the newly created enhancements.

Environment: Windows XP, Oracle Applications 11i, Oracle Workflow Builder, Oracle Report Builder 6i/2.5, XML Publisher, TOAD, Putty, Shell Secure.

Oracle Apps Consultant

Confidential

Responsibilities:

• Responsible for developing interfaces for Invoices Migration using API Payable, Open Interface Import and Receipts Migration using API Receiving Transaction Import.
• Responsible for developing interfaces in PO module for Vendor Migration using API Supplier Open Interface Import and Vendor TDS Migration
• Responsible for developing XML reports in AP, GL module.
• Developed Pick Slip report and Purchase Order Report using XML.
• Extensively used data loader tool to load the data into Oracle data base.

Environment: Windows XP, Oracle Applications 11i, Oracle Report Builder, XML Publisher, TOAD, SQL* Loader.

Associate Software Engineer

Confidential

Responsibilities:

• Defining Concurrent Programs, Executable and creating PL/SQL method of submitting Concurrent programs.
• Responsible for developing & Customizing reports in modules HRMS and Payroll
• Responsible for developing Oracle reports in HRMS module
• Used data loader tool to load the data into Oracle data base.
• Responsible for Creation of Value sets in various Modules of the application and developed Concurrent programs, PL/SQL API’s.
• Responsible for developing an interface program to load orders from the existing customers.
• Involved in converting existing customer information and adding new customers, customer sites using customer interface program.

Environment: Windows XP, Oracle Applications 11i, Oracle Report Builder, TOAD, SQL*Plus, SQL*Loader.