Oracle Application Technical Consultant Resume
IL
Summary:
- Oracle Applications Techno-Functional Consultant with 7 years of experience in Oracle Procure to pay & Order to Cash cycles. Participated in Life Cycle Implementation of Oracle in 11i environments, this includes Account Payables (AP), Account Receivables (AR), General Ledger (GL),Purchasing (PO), Cash Management (CE), Order Management (OM), Inventory (INV) and Service Contracts.
- Over 6 years of Experience in Developing, Customizing, Testing, Implementation and Support of Oracle Financial and Manufacturing modules.
- Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.
- Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
- Have thorough hands on experience in using PL/SQL, SQL, Oracle Reports 6i, Oracle Forms 6i, SQL*Loader, TOAD, SQL Developer, Workflow, SQL*Plus.
- Good working knowledge in Technical Documentation using AIM Methodologies. ( MD70, TE40, CV40 AND CV70)
- Highly motivated, hardworking, able to meet tight deadlines, thorough in project completion and possess excellent communication and analytical skills.
- Experienced in interacting with users, delivering solution which meets the business requirements, and drawing up Business Case Scenarios to enable the testing of system setups.
Professional Experience:
Client: Confidential, GA
Role: Oracle Applications Techno-Functional Consultant
Duration: Feb 2009 – Till Date
Confidential is the largest provider of fixed telephony in the United States, and also provides broadband and subscription television services. Confidential is the second largest provider of mobile telephony service in the United States, with over 90.1 million wireless customers, and more than 210 million total customers. AT&T has multiple releases of their New Horizons Project; I worked majorly on the NHR1/NHR2 which was to migrate the Procure-2-Pay process of CAPRI South East Region into Oracle SCM Platform. My scope here was interfaces, conversions.
Responsibilities:
- Prepared all the Technical Specification documents (MD70) and unit testing documents (TE40) according to the AIM Methodologies.
- Worked with the PROD Support in reviewing the BR100 documents and doing the setups in test instances.
- Participated in SIT/UAT cycles for successful implementations of the designed solutions.
- Actively participated in technical review, testing and CRP meetings to assist the cross-functional teams as and when needed.
- Migrated supplier data from CFAS to Oracle SCM instance for successful creation of Purchase Orders in Oracle SCM.
- Designed and developed Payables Interface Import Program to load invoices from the legacy system into the Oracle Payables Base Tables.
- Worked on Auto Invoice for importing invoices from TIRKS (external system) into Account Receivables (AR).
- Designed an interface program to load all the UPFRONT requisition into Oracle SCM instance. This interface was categorized into two parts, with the first one verifying the user credentials and sending it back to UPFRONT and the second part was to derive, validate and load the requisitions into the open interface and base tables.
- Worked on interfacing the approved Purchase Orders to external system which can receive against the PO.
- Interfaced PO receipt data to Order track Application (GUI for user to enter and search PO & SO).
- Interfaced PO status back to source requisitioning systems to keep them in sync with Oracle.
- Involved in setups like creating lookups, Profile options, DFF’s and value sets based on the requirement.
- Registering Concurrent Programs, creating Request Sets, Shell Scripts, SQL Loader Control files and custom Programs to load the data into interface tables.
Environment: Apps 11.5.10.2, PO, AP, GL, AR, Custom Responsibilities, Oracle 10g, Pl/SQL, SQL*Plus, SQL*Loader, TOAD, UNIX
Client: Confidential, CO
Duration: May 2008 – Dec 2008
Role: Oracle Application Techno-Functional Consultant
Confidential has sold out its printing system division to Ricoh and Infoprint is a joint venture of both these companies. I have joined the Technical Team on site and been a part of the Interface and Conversion teams. Through the course of the project, have worked on GL, Cash Management Interfaces and CRM conversions. Also have actively played part in the Data mapping sessions for some of the other components.
Responsibilities:
- Worked on preparing Technical Specification Documentations (MD70) following the AIM Methodology standards.
- Infoprint US Payroll Accounting Transactions – Designed an interface process which accepts flat files containing accounting transactions in a standardized GL inbound interface file from Ceridian.
- Worked on Citibank Bank Interface. Designed an interface to process Citibank statements into Oracle Cash Management. Completed the full life cycle of loading the BAI2 files, importing the statements and reconciling.
- Imported legacy Transactions (invoices) into Accounts Receivables.
- Defined the Invoice import related setups in Receivables across all instances.
- Converted Supplier Bank Accounts from legacy systems and loaded them into Oracle.
- Designed the upload and download scripts to migrate value sets, lookups and concurrent programs.
- Defined various DFF’s, value sets, functions, forms, Messages and lookup’s using application developer & Sys Admin responsibility.
- Infoprint had the need and requirement of having a common shared concurrent program which can be used across the board to process the data files. So designed a UNIX shell script program to process the data files on the server and load it into the pre-interface tables.
- Represented as point of contact from Oracle Technical Team in data mapping sessions.
Environment: Apps 11.5.10.2, GL, CE, AP, AR, Oracle 10g, Pl/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i/10g, TOAD, UNIX
Client: Confidential, IL
Duration: Jan 2008 – May 2008
Role: Oracle Application Technical Consultant
Confidential have recently acquired General Binding Corporation (GBC). Since the acquisition they were implementing Oracle Applications 11i at GBC which was running on BPCS. I joined the project in its second phase called BTO Phase 2 Implementation. My role as a Technical consultant involved preparingMD70’s, working on conversions and extensions. Also assisted the offshore team in development, testing of RICE objects.
Responsibilities:
- Prepared Technical Documentation MD70.
- Worked on extensions like Auto Credit in Receivables to Terminate “Unpaid Renewal’s” in Service Contracts.
- Worked on the Open Invoices Interface in the AP Module.
- Extensively worked on Receivables and Service Contract API’s like Okc_Contract_Pub and Ar_Credit_Memo_Api_Pub.
- Worked on Receipts and Transaction’s Conversion in Account Receivables including creating staging tables and writing control files
- Worked on Sales Order Conversion to import orders from legacy into oracle.
- Defined Transaction Types, Invoice Batch Sources, receipt sources, receipt classes in AR.
- Prepared promotion document’s for all the objects and uploaded them into PVCS, also worked on LDT’s to move various objects like value sets, responsibilities, flex fields, concurrent programs etc. from one instance to the other.
- Created UNIX Shell Scripts to download and upload all the LDT’s.
- Worked on Setup’s like Receipt Classes, Receipt Sources, and Transaction flexfield context, Lookups, Payment Terms, and Auto Accounting.
- Proficient in using System Administrator and Application Developer responsibilities.
- Resolved the bugs and improved the performance of the existing programs.
Environment: Oracle Apps 11.5.10.2, AR, OM, AP, Service Contracts, Oracle 10g, Pl/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i/10g, TOAD, UNIX
Client: Confidential, IL
Duration: Jun 07 – Dec 2007
Role: Oracle Application Technical Consultant.
Edsal is a manufacturing firm which produces storage systems and industrial furniture. They are widely spread through out the United States with three major manufacturing plants in Illinois, Tennessee and California. Performed the role of technical lead and worked extensively in developing forms and customizing the standard reports apart from the conversions and interfaces.
Responsibilities:
- As a Technical Developer, prepared documentation following the functional specification given by the functional team and primarily was a part of production support team.
- Worked as a liaison between the Business, Testing and Technical teams in ensuring that the processes were implemented as per the requirements. Coordinated with the intended application users to help them in successfully bolting onto the application.
- Migrated Inventory data from the legacy systems in oracle applications using Item Import Interface .
- Worked on Receivables Autolock Box functionality in migrating the receipts from Edsal’s EFACTS accounting system.
- Have done high end customizations in Quick Sales Order form according to the user requirements. Some of the customizations done were merging in the fields from two tab pages into one single page, printing in a report from a form etc.
- Extensively worked on customizations of standard reports like Invoice Print Selected Invoices and Shipping Detail Lines Report etc in XML Publisher.
- Provided support for the Production team and also actively took part in training users on using the forms and reports customized.
Environment: Oracle Apps 11.5.10.2, OM, GL, AR, BOM, INV, WSH, Oracle 10g, Workflow Builder 2.6, XML Publisher, Pl/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i/10g, XML Publisher, TOAD,UNIX
Client: Confidential, VA
Duration: Jul 06 – May 07
Role: Oracle Applications Technical Consultant
Confidential is a leading global technology services company delivering business solutions and EDS SOLCORP, a global business unit within EDS, is a leader in software solutions and consulting services. This project involved implementing Oracle Applications11i. Worked extensively on conversions and interfaces in OM, GL, AR, AP, PO, INV modules. Customized and developed reports using Reports 6i
Responsibilities:
- Developed interfaces to load GL data from legacy system to the oracle 11i general ledger and imported the journals using journal import program.
- Developed interfaces to load Open Invoice Interfaces from legacy system into Oracle 11i Account Receivables using Auto Invoice program.
- Designed and Developed Staging tables, Data Conversion SQL Loader Program to import the Open Sales Orders using Open interface tables in Oracle Order Management.
- Written several scripts to validate data in staging tables and developed SQL*Loader control files to load the data from flat files into the staging tables.
- Involved in Performance tuning of various queries using tkprof and Explain plan.
- Proficient with the System administrator responsibility, which included customizing the menus, adding new concurrent requests, request sets, registering the custom applications etc.
- Followed MD50 functional documents and written the technical (MD70) specifications, provided support for end users and documented the modifications.
Environment: Oracle Apps 11.5.10, OM, GL, AR, AP, PO, INV Oracle 9i, Pl/SQL, SQL*Plus, SQL*Loader, Forms 6i, Reports 6i, TOAD, Windows XP, UNIX
Client: Confidential, TX
Duration: Aug 05 – Jun06
Role: Oracle Applications Technical Consultant
Confidential this is a part of vignette’s consulting services mainly into ERP. This project involved implementation of Oracle Applications 11i and worked on conversions, interfaces in GL, AP, AR and PO modules. Extensive work was done in the customization and developing or several reports using Reports 6i.
Responsibilities:
- Involved as a team member that implemented the Oracle Purchasing module by interacting with the client to understand user requirements.
- Developed Conversion program to import Vendor/Supplier Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into Vendor information Base tables.
- Developed staging tables, conversion routines and interfaces to load the Open Legacy Purchase Orders, Payable Invoices.
- Journal Import: Developed an interface for monthly import of journal entries from Payroll system by using the journal import Interface provided by Oracle General Ledger.
- Wrote Technical (MD70) and Conversion Mapping document (CV40) for importing Legacy Purchase Orders into Oracle Purchasing, Legacy Payable Invoices into Oracle Payables.
Environment: Oracle Applications 11.5.10, GL, AR, AP, PO, Oracle 8i, Forms 6i, Reports 6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX.
Client: Confidential, IL
Duration: Sep 04 – Jul 05
Role: Oracle Applications Technical Consultant
Confidential is the leading industry in the mail and document processing sector and they implemented Oracle Applications 11i. Worked on conversions and interfaces in financial modules like GL, AP, AR and PO. Developed reports using Reports 6i.
Responsibilities:
- Developed MD070’s using AIM methodology by reviewing MD50’s and interacted with onsite functional team to build technical extensions.
- Developed SQL*Loader control file according to the mapping tables to populate the custom load tables using the extract file.
- Wrote PL/SQL packages for different validations, for processing data in order to create valid POs and Receipts and for populating the PO interface tables and called the seeded import programs to populate the base tables.
- Preparation of Technical Design Documents and Unit Test reports as per Oracle AIM standards.
- Developed PO interface to import Purchase Orders from legacy systems.
- Designed and developed Forms using Forms 6i as per the business requirements, provided Zoom functionality using CUSTOM.pll.
- Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program.
- Imported invoice information using Auto Invoice Interface Program.
- Imported journals into GL from legacy system using GL import interface Program.
- Performance tuning and query optimization for Reports and Interfaces using Explain plan.
- Designing, Developing and customizing Forms, Reports, Packages, Procedures.
- Registration of Concurrent programs, Creation of Value sets, placing the Reports and Interfaces in the AOL directory of the server.
Environment: Oracle Apps 11i (11.5.6), (AR, PO, GL, AP), Oracle 8i, PL/SQL, Forms 6i, Reports 6i, SQL*Loader, TOAD 4.0.
Technical Skills:
Oracle Applications: Oracle 11i / 11.5.10.2, 11.5.8, 11.5.6.
ERP: Oracle Financials & Oracle Manufacturing
Oracle Tools: Oracle Forms 6i, Oracle Reports 6i, SQL*Loader, SQL*Plus, SQL Developer, XML Publisher, Oracle Workflow Builder.
Languages: SQL, PLSQL, C, C++, JAVA, FORTRAN.
Operating Systems: MS DOS, UNIX, Windows (XP, 2000, 98, 95)
Education:
- Bachelor of Engineering: Computer Science Engineering
Confidential, Hyderabad, India