We provide IT Staff Augmentation Services!

Oracle Applications Techno Functional Analyst Resume Profile

  • Oracle Certified Professional with 10 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals such as Healthcare, Engineering Construction, Financials and Tele Communication.
  • Extensive experience in business analysis, system integration, design, development, customizations implementation, System/functional and integration testing of ERP applications.
  • Proficient in analyzing and translating business requirements into appropriate setups in application modules, design technical requirements for GAPS and data conversion and architecture.
  • Sound techno functional knowledge in the business processes such as Financial, Order to Cash O2C , Procure to Pay P2P , Supply Chain Management SCM of Oracle EBS 11i and R12 in the modules GL, SLA, FAH,AP, PA, FA, IBY Payments, AR, TCA, INV, PO, OM, FedAdmin, AOL and SysAdmin.
  • Specialized in the development of Oracle software solutions, utilizing expertise in requirements definition, and involved in all stages of development with strong implementation skills spanning Full life cycle implementations and production support.
  • Well versed in RICE components development Reports, Interface, Conversions and Extensions along with Oracle Workflow customizations. Excellent perspective on converting the functional specifications into technical design and development.
  • Strong database skills, Object Oriented Programming and development knowledge, experience in Oracle Applications Framework OAF .
  • 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.
  • Strong analytical and trouble-shooting skills, excellent communication and interpersonal skills, self-motivated, quick learner, and team player.

Technical Summary:

  • ERP Modules

Oracle Applications R12/11i GL, SLA, FAH,AR, AP, FA, IBY Payments, TCA, PA, OM, PO, FedAdmin, SysAdmin and Application Object Library

  • Development Tools

Developer 2000 Forms 6/9i, Report 6/9i , SQL Plus, SQL Developer, PL/SQL Developer, SQL Loader 6.0,Data Loader 4.0, Toad, Oracle Workflow builder, Discoverer Admin, JDeveloper, BI Publisher 11g, XML Publisher and Web ADI.

  • Change/ Config/ Quality control Management Tools

HP PPM Kintana , PVCS, CA Harvest, BMC Remedy and IBM RCC Rational Clear Case , HPQC-ALM 11.52.

  • Programming Languages

PL/SQL, SQL, Unix Shell scripting

  • Fusion Middle Ware

SOA BPEL and Oracle Data Integrator ODI

  • Web Technologies

HTML, XML WSDL and XSD

  • Databases

Oracle 9i/10g/11g, SQL Server

  • Operating Systems

Unix/Linux, Windows 98, 2000, NT, XP, Vista and Window7

Work Summary:

Confidential

The National Institutes of Health NIH , a part of the U.S. Department of Health and Human Services - Supporting scientific studies that turn discovery into health.

Environment Used:

Windows and UNIX, Oracle Applications R12.2.3, Oracle Database 11g SQL and PL/SQL , Oracle Forms/ Reports Developer 10g, Putty, Toad, SQL Developer, SVN, JDeveloper, SQL Loader and XML Publisher tools.

Oracle Applications Techno functional consultant

  • Techno-functional consultant for reporting and interfaces of Oracle EBS in AR, AP, SLA, FAH, FedAdmin and PA modules.
  • Participated in the design discussions of the project, contributing to deliverables like to-be process flows.
  • Worked on Project Accounting PA , Receivables, Payables related SLA Custom Sources for Fund type, apportionment category, based on Revenue distribution lines, Expenditure item and customer agreements.
  • Worked on Project Maintenance form customizations and personalization changes
  • Worked on customizations of Payment Process Requests as per CARS requirement for PAM, SPS Treasury payment formats.
  • Worked on GL interface between NBS Oracle EBS and Sunflower through FAH.
  • Worked on OPE/ORF interface through FAH
  • Worked on the Fed Confirmation Payment instructions LOV for the performance improvements .
  • Working on Special invoice selection and process flow to netting the AR/AP transactions.
  • Involved in the development of the customization of AR Invoice, Receipt creation/applying and credit memo generation process which includes analysis, design, development, testing and implementation of Oracle ERP solution.
  • Interacting with client, analyzing CEMLI requirements, impact analysis, and implementation of the same. Preparing MD70 from MD50 provided by Business creating TE20 and testing the changes and implementing the same in Test environment production.
  • Also responsible for Migrations of the technical objects from Development instance to other testing instances and production using the migration tools such as putty, HP PPM and SVN.

Confidential

Toshiba America Business Solutions Inc. manages product planning, marketing, sales, service support and distribution of copiers, facsimiles, multifunction printing products, network controllers, and toner products throughout the United States , Mexico , Latin America, and the Caribbean.

Environment Used: Windows and UNIX, Oracle Applications 11.5.10, Oracle Database 10g SQL and PL/SQL , Oracle Forms/ Reports Developer 9i, Putty, Toad, Kintana, PVCS, SQL Developer, JDeveloper, SQL Loader and XML Publisher tools.

Project Description:

Implementation and Support of Oracle applications 11i 11.5.10.2 and Tessaract Customer and Supplier maintenance.

Oracle Applications Techno Functional Analyst

  • Techno-functional analyst for reporting and interfaces of Oracle EBS in OM, AR and AP modules.
  • Participated in the design discussions of the project, contributing to deliverables like to-be process flows.
  • Worked on Customer, supplier portal maintenance and invoice customization, analysis, design, development, testing and implementation of Oracle ERP solutions.
  • Worked on Receivables invoice outbound process to meet requirements of the Southwest airlines invoice format.
  • Interacting with client, analyzing CEMLI requirements, impact analysis, and implementation of the same. Preparing MD70 from MD50 provided by Business creating TE20 and testing the changes and implementing the same in Test environment production.
  • Worked on Customer, Vendor and Receivables invoice inbound interface programs.
  • Worked on Sales Order form customization adding the Sales person in the Bill to/Ship to LOV.
  • Worked on Fixed Assets Locations Outbound interface Program.
  • Worked on custom triggers to prevent the receivables invoices generation in the oracle system, if the customer is not registered in the Torico system
  • Worked on Auto Lockbox interface program.
  • Worked on numerous Customer and Supplier form persolizations such as making the supplier site protected if the site is bill to site, disallowing users creating new customers and suppliers etc.
  • Responsible for Migrations of the technical objects from Development instance to other testing instances and production using the migration tools such as kintana.

Confidential

Environment Used: Windows and UNIX, Oracle Applications 11.5.10, Oracle Database 10g SQL and PL/SQL , Oracle Forms/ Reports Developer 9i, Putty, CA Harvest, BMC Remedy, PL/SQL Developer, JDeveloper, SQL Loader and XML Publisher/ BI Publisher 11g tools.

Oracle Applications Techno functional analyst

  • Techno-functional analyst for reporting and interfaces of Oracle EBS in Service Contracts, AR and AP modules.
  • Participated in the design discussions of the project, contributing to deliverables like to-be process flows.
  • Working on Revenue Billing Management process, responsible for Analysis, design, development, testing and implementation of customized Oracle ERP solutions for new implementation and upgrades.
  • Worked extensively on XML Publisher and XML Bursting, for the reports involving, AR Active Accounts and Billing to FTP the output files.
  • Worked on BI Publisher 11g reports involving, Out of Area network Summary Report, Detail and Backup charges on subscriber and member details and Reports.
  • Worked on AR Active Accounts Billing Report, Commercial and MedSupply Billing Report.
  • Interacting with client, analyzing CEMLI requirements, impact analysis, and implementation of the same. Preparing MD70 from MD50 provided by Business creating TE20 and testing the changes and implementing the same in Test environment production.
  • Responsible for Migrations of the technical objects from Development instance to other testing instances and production using CA Harvest and BMP Remedy tools.
  • Responsible for data conversion from ESS system to Oracle Service contracts.

Confidential

Citigroup is a multinational FINANCIAL SERVICES corporation headquartered in Manhattan, New York City, New York, United States, which has the world's largest financial services network, spanning 140 countries with approximately 16,000 offices worldwide. The company currently employs approximately 260,000 staff around the world.

Environment Used: Windows and UNIX, Oracle Applications R 12.0.6, Oracle Database 11g SQL and PL/SQL , Oracle Developer 9i, Putty, HP PPM, PVCS, SQL Developer, JDeveloper, SQL Loader, workflow and NDM tools.

  • Oracle Applications Techno Functional Consultant
  • Responsible for Analysis, design, development, testing and implementation of customized Oracle ERP solutions for new implementations and upgrades.
  • Requirement gathering requirements from business leads, and translating in to technical requirement and convey them to offshore leads and team member
  • Techno-functional analyst for reporting and interfaces of Oracle EBS in integration with GL, AR, AP,PO, SLA and FAH modules
  • As a Sr. Oracle Techno Functional consultant responsible for Enhancements and Production support of RICE components in GL, SLA, FAH, AP, PO and AR with BI / XML Publisher Reports.
  • Involved in the Interface and Reports solution for account standardization project.
  • Worked most of the GL Outbound/inbound Interface/ Conversion programs and their Autosys jobs using JIL Job Information Language and NDM Process, which was used to control and trigger the interface Jobs.
  • Development of Custom Reports using XML Publishers, Developer 2000 and Discoverer.
  • Made changes in the logic for PO Account Generator and Requisition Account Generator to accommodate new account changes.
  • Custom interface to import Contract Purchase Agreements into Oracle. Invoking Standard Workflow to approve the imported CPAs. This was done after studying APIs involved while approving a PO through the Forms.
  • Preparation of Documentation for Technical and Installation using AIM methodology such as MD70 and MD120.
  • Uploading the developed components and the documents into version control tool PVCS and promoting them using Kintana HP PPM to UAT and PROD instances.
  • Performance and tuning of several customized interface programs
  • Raising TAR/ SR with the oracle support team and monitoring them.
  • Deliver new and complex high quality solutions to clients in response to varying business requirements

Confidential

Project name: OMIM Oracle Order Management and Inventory Management Implementation and Support 11i Apr'09 Mar'11

Sprint Nextel Corp is a United States-based holding company that operates multiple wire line and wireless networks serving consumer, business and government customers in the United States, Puerto Rico, and the U.S. Virgin Islands primarily under the Sprint brand. Sprint Nextel, through its various subsidiaries, also offers wireless services under the Boost Mobile, Virgin Mobile and Assurance Wireless brands

Environment Used: Windows and UNIX, Oracle Applications11.5.10.2, Oracle Database 9i SQL and PL/SQL , Oracle Developer 6i, Putty, SQL PLUS and SQL Loader.

Project Description:

  • Implementation and support of Oracle Applications 11i Order Management and Inventory.
  • Oracle Apps Techno Functional/System Tester
  • Responsible for a project team in delivering solution to our customer in the Communication sector, deliver new and complex high quality solutions to clients in response to varying business requirements
  • Utilize in-depth knowledge of functional and Technical experience in Oracle EBS and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
  • Interacted with Functional team to know current business process, document and identify any GAP's which could not be fulfilled using standard oracle functionality, interfaces with other systems and data conversion.
  • Worked on design and solution part of Sales order/RMA 90Day Close program functionality.
  • Worked on custom profiles such as 'Custom Pick Release Rule',' Order Prioritization Sort', 'Disable Scheduling Privilege'.
  • Responsible for setting up OM and INV modules, documenting the setups using BR100 document.
  • Worked on the preparation and analysis of test scenarios/cases such as TE-40's of various customized processes of the Oracle ERP applications, and identifying the issues and risks.
  • Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
  • Worked on the CR Advance Serial Search form using OAF partial page rendering concept as per the business requirements. Also Implemented OAF Personalization as per the business logic.
  • Worked on the SOA BPEL web services integration with Oracle EBS.
  • Testing and analyzing the quality and preparation of test documents with various test cases and peer review of the objects before deployment.

Confidential

Environment Used: Windows and UNIX, Oracle Applications11i, Oracle Database 9i SQL and PL/SQL , Oracle Developer 6i, Putty, SQL PLUS and SQL Loader.

Project Description:

  • Implementation of Oracle Applications Financial and HR Modules GL, AP, AR and HRMS applying global standard process and regional characteristics
  • Oracle Apps Techno Functional Consultant
  • Worked as an offshore team member, involved mostly in the UAT and Go-Live phases of Implementation.
  • Development and customization of Reports using Developer Suite 6i.
  • Designing and development of conversions and interfaces using PL/SQL programs.
  • Involved in design, development and customization of reports using XML Publisher and Oracle Reports.
  • Involved in for system as well as unit testing.
  • Prepared Technical Documents MD 70 as per the client requirement.

Hire Now