Oracle Apps Techno Functional Consultant Resume
Charlotte, NC
EXPERIENCE SUMMARY:
- 10+ years of experience in Oracle Applications as Techno Functional Consultant in System Analysis, Design, Development, Customization, Interfacing, Implementation, Support and Maintenance of business applications using Oracle EBS.
- Worked for Big 3 consulting companies like Oracle Financial/Capgemini and learned best implementation and customization standards across Oracle modules.
- 3.5 Years of experience working in onsite offshore model and client facing role.
- Oracle Cloud Certified in Account Payables and Account Receivables.
- Extensive experience in implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in Procurement, Purchasing (PO), Accounts Payables (AP), Accounts Receivable (AR), General Ledger (GL), Cash Management (CM), Project Accounting (PA), IExpense.
- Proven hands on experience in gathering requirements from users, design and implementation of customizations including preparation of MD050, BR100, CV040, MD070, MD120.
- Development of technical objects like PLSQL packages, customization of Forms, Reports, Interfaces, API’s and Oracle Alerts
- Experience working in project management and providing weekly and monthly status report.
- Experience in running daily stand up calls with Team.
- Configuration in R12 related to Account Payable and Account Receivables Example: - Defining responsibility, Profile Option, Lookups, Financials Option, Payable Option, Special Calendar etc.
- Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions), Forms, XML/BI publisher, Workflow.
- Expertise on AIM Methodology, TCA and Multi org access control process.
- Experience in implementing third party vendor software which are integrated with Oracle. Example: Vertex, Markview, SMART Tool Etc.
- Excellent working knowledge in the area of Oracle 10g, Oracle 9i, Oracle 8i, Reports6i, and Developer/2000.
- Knowledge in Oracle Application Framework, Workflow Builder of Oracle Applications.
- Proven ability to conceptualize, design and implement solutions in Performance Tuning.
- Good experience in migration tools - Kintana, Clearcase (Version Controlling).
SKILLS:
ERP: Oracle EBS 11i/11.5.10, Oracle EBS R12 (12.1.3 & 12.2.4)
Ticketing System: Service Now
Source Control Tool: Source Version Check (SVN), Kintana, Clearcase
Modules: AOL, PO, Iprocurement, IExpense, AP, AR, GL, CM, PA
Database Language: SQL, PL/SQL, Advanced PL/SQL
Technical Tools/Application: Oracle Forms Builder, Oracle Report Builder, Workflow Builder, OA Framework, XML Publisher, Toad/SQL Developer, Vertex, Markview Oracle Financial Cloud Payables and Receivables.
PROFESSIONAL EXPERIENCE:
Confidential, Charlotte, NC
Oracle Apps Techno Functional Consultant
Responsibilities:
- As a Senior Oracle Apps Techno-Functional Consultant, was involved in R12 Financial Applications modules like General Ledger, Accounts Payables, Accounts Receivables, Cash Management, iExpense configurations.
- Interact with key client personnel to understand client's business processes, gather requirements and prepared the business process Requirement documents for Oracle Apps implementation.
- Conducted solution design sessions and CRP to demonstrate the solution in Oracle, involved in the unit test and integration tests and prepared test scripts and test scenarios.
- Actively participate in the design, development and maintenance of interfaces to and from the Oracle E-business Applications.
- Developed reports in Oracle Payables, Oracle Receivables, also customized several Oracle seeded reports.
- Used Auto Invoice Interface to import Standard Invoices from a Legacy system into Oracle Receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import program.
- Customized the Auto Accounting and Auto Invoice Programs in Receivables
- Converted Fixed Assets Data from Legacy System to Mass Additions Table using SQL Loader and developed programs for Conversion of Tax Data from flat Files to Tax Interface Tables
- Extracted data from AP tables and sending a flat file (checks cut in a period) using UTL FILE package at periodic intervals.
- Extensively worked on migration and testing of the deliverables in different instances.
- Imported Payments from legacy system into Oracle Receivables using Lockbox Interface. Involved in the process of splitting the bank file to feed Auto lockbox.
- Tested customized functions, programs under simulated environment and prepared the user manual for all customized and Standard Business Process, provided the support to users during Go-Live by way of problem solving and instructions.
Confidential
Oracle Apps Techno Functional Lead
Responsibilities:
- Interact with key client personnel to understand client's business processes, gather requirements and prepared the business process Requirement documents for Oracle Apps implementation.
- Conducted solution design sessions and CRP to demonstrate the solution in Oracle, involved in the unit test and integration tests and prepared test scripts and test scenarios.
- Developed Interface process for the Journals Import in GL, for Daily Journal processing from the legacy systems. Supported the program after implementing in production.
- Developed customized report for Journal reconciliation and error report for data validation error.
- Worked on debugging production issues of importing a Journal data.
- Defining concurrent programs, executable, forms, request set, values set.
- Worked on the design and approach to correct the customer addresses in production environment.
- Developed an interface to load the new customers in Oracle application.
Confidential, Charlotte, NC
Oracle Apps Techno Functional Lead
Responsibilities:
- Interact with key client personnel to understand client's business processes, gather requirements and prepared the business process Requirement documents for User Access Provisioning.
- Worked along with the business SME’s and CIO office in gathering the requirement and translating the same in technical terms.
- Responsible for creating designing the custom page for User access provisioning.
- Creation of custom lookups and value set.
- Design and development the custom Workflow to automate the approval process.
- Complete development of PL/SQL package used by the workflow approval process.
- Resolving Functional/Technical Issues, preparing move sheets to migrate the code across the instances.
Confidential, Overland Park, KS
Oracle Apps Techno Functional Lead
Responsibilities:
- Involved in R12 Financial Applications modules like General Ledger, Accounts Payables, Accounts Receivables, Cash Management, E-business Tax EBT, Fixed Assets, Projects Billing and Costing, Projects Time and Labor, gap analysis, configurations:
- Interact with key client personnel to understand client's business processes, gather requirements and prepared the business process Requirement documents for Oracle Apps implementation.
- Assisting clients in decision to buy ERP software package. Mapping the client's business requirement with functionality available in software and advising the best package for the client/industry.
- Interacted with business users to understand the legacy/3rd Party system and Involved in legacy data conversion into Oracle and cut-off activities.
- Conducted solution design sessions and CRP to demonstrate the solution in Oracle, involved in the unit test and integration tests and prepared test scripts and test scenarios.
- Tested customized functions, programs under simulated environment and prepared the user manual for all customized and Standard Business Process, provided the support to users during Go-Live by way of problem solving and instructions.
- Worked with design, testing and maintenance of oracle general ledger allocations and the monthly sub ledger and General Ledger closing process
- Worked with technical team to map the RICE Components like Inbound and outbound interfaces, Conversions, Form customizations, Reports and other Objects, Prepared functional specifications MD50 for all the RICE Objects.
- Analyzed the changes in financial custom reports and interfaces for upgrading the same to R12 XML reports such as check printing and Separate Remittance Advice report and sending the same as PDF attachment in email.
- Functional support to all end users on financial modules, procure to pay cycles and Project accounting
- Involved in post-production support and maintenance of the Applications and resolving user queries and to gather new requirements analysis, Knowledge Management, Test Planning and Test Design activities.
- Conducted sessions for the user group, was responsible for sending out weekly status report to the management.
Environment: Oracle EBS 12.1.3, Database Oracle 12c, Vertex O Series, JDeveloper 10g, Workflow builder, Toad, Oracle Form 10g, Oracle Reports, FileZilla, CRT
Confidential, Overland Park, KS
Senior Oracle Developer
Responsibilities:
- Requirement gathering and providing technical solution for it.
- Design complete Table structure and technical data flow diagram for the custom module.
- Designing Custom Oracle forms and Reports with XML publisher
- Developing complex Inbound Interfaces to pull data from NORAD to load EDI 850 and 860 details in Oracle.
- Develop outbound interface to send across invoice details as to NORAD for daily reconciliation between Oracle and NORAD.
- Developing complex request set containing sub programs to validate data and use standard API’s to import AR invoices into Oracle.
- Develop notification mechanism using shell to handle error reporting to the business stakeholders responsible for the activity.
- Form and OAF personalization of custom pages as per requirement.
- Preparing User Guide for the module as well as Technical document for the programs developed.
- Preparing scripts for data migration to Production.
- Educating peers and Support team about the ePOM module and helping them in fixing bugs.
Environment: Oracle EBS 12.1.3, Database Oracle 11g, Oracle Forms 10g, TOAD, FileZilla, CRT
Confidential, Overland Park, KS
Senior Oracle Developer
Responsibilities:
- Requirement gathering and designing the complete architecture of the process from Oracle perspective.
- Developed Functional and Technical design based on requirement.
- Developed PO Interface using Standard API’s.
- Adding and customizing the validations as per the requirement and accordingly processing data.
- Working with the Client and Third party independently and making them understand about the Oracle Process and data requirement to process in Oracle.
- Preparing User Guide for the module as well as Technical document for the programs developed.
Environment: Oracle EBS 12.1.3, Database Oracle 11g, Oracle Forms 10g, TOAD, FileZilla, CRT
Confidential, Albany, NY
Senior Oracle Developer
Responsibilities:
- Part of the R12 upgrades Team.
- Analyze existing 11i objects that would need change when upgraded to R12.
- Develop supplier interface in R12 using standard API’s in R12.
- Worked with business analysts to translate business needs into functional and technical specifications and process flows.
- Developed an interface that gets the data from the Legacy system for Project Interface and process it in SSS environment.
- Developed a Customized Request set with sub-programs.
- Developed PL/SQL validation procedures and loaded PO’s from legacy system to SSS using SQLLDR.
- Developed programs for mailer notification of error records through UNIX Shell.
- Provided day to day technical and functional support to end users.
- Worked on extensive troubleshooting problems of diverse scope.
- Done the Complete Unit testing of the project.
- Prepared installation scripts to move the code from DEV to UAT and PROD instances.
Environment: Oracle EBS 12.1.3, Database Oracle 11g, Toad, FileZilla, APPWORX, PVCS, RightFax.
Confidential, Albany, NY
Senior Oracle Developer
Responsibilities:
- Standardize the report which can be used across all GE business and supporting it with a single Package.
- Developed a Single package which can be used across all GE Business.
- Prepared COOK BOOK having complete setup process.
- Provided KT for the same for all the setup required.
- Effectively communicated to users in all the phases and the work was highly appreciated by the client.
Environment: PL/SQL, JAVA, ADF, Eclipse, RAD Tool, Rational Clear Case, Winscp