|
|
|
|
Oracle Oracle 11i Application Consultant/ Developer Resume
|
| Desired Industry: Information Technology |
SpiderID: 5047 |
| Desired Job Location: cincinnati, Ohio |
Date Posted: 1/23/2006 |
| Type of Position: Part-Time Temporary |
Availability Date: |
| Desired Wage: |
|
|
U.S. Work Authorization: |
| Job Level: Experienced with over 2 years experience |
Willing to Travel: |
| Highest Degree Attained: |
Willing to Relocate: |
Objective:
7 years of experience in Design, Coding, Testing and Implementation, Customization, conversions and Interfaces of Oracle based business applications in IT industry. Worked in Oracle Applications Release 11.5.3i, 11i consisting of AP, AR, GL, Order Management, Purchasing, Inventory, AOL, Sys Admin, Alerts and Workflow modules. Strong technical skills in Oracle Forms 4.5/6i, Reports 2.5/6i, SQLPLUS, PL/SQL, and SQL*Loader. Experience in Oracle AIM technical documentation and familiar to Oracle 11i Upgrade and its Implementation.
Strong interpersonal skills, ability to interact with people at all levels, good communication and presentation skills. Experience in working with Oracle Support to investigate and resolve critical problems with systems identified during system Implementation.
Experience:
Experience:
May ’05 – To date
Cingular Wireless, Dallas, Texas as Oracle 11i Application Consultant
§ Working on challenging Oracle 11i enhancements and new custom developments providing that uses all Oracle Financial (AP, AR and GL), manufacturing (INV, BOM and WIP), order management and purchasing modules. Extensively worked on Purchasing, Inventory, Order Management and all financial modules.
Technical Contributions:
§ Working on the existing interface packages. Have developed new error handling package for handling all the errors generated by all the existing interfaces.
§ Have worked on AP Invoices, PO Receipts, Open Purchase Orders, Inventory Adjustments, Open Sales Orders Interfaces and also already existing inbound and outbound interfaces.
§ Have created a common error handling utility package by using Oracle seeded message dictionary.
§ Created custom forms to display the information for both error scenarios and resolutions for a particular error created by the interface to the user by using PLSQL tool kit and Java Script.
§ Developed a Custom Cingular Interface Names form by using TEMPLATE.fmb Oracle seeded form.
§ Have created test cases and test scripts for testing the existing interfaces.
§ Have prepared MD070, MD120 and TE020 documents.
§ Have created migration scripts by using shell scripts. Migrated all the objects from DEV instance to UAT, QA1 and PROD by using Cingular DBA’s.
§ Designed and Developed Stored procedures, Functions and Triggers in PL/SQL to implement complex business rules.
Functional Contributions:
§ Interacting with super users, participating in discussions for collecting the required information and its analysis for the design and development of customizations.
§ Helped the users in performing their daily transactions. Worked and resolved on their logged issues.
Other Contributions:
§ Creating new users, assigning responsibilities, Registering new custom application process and scheduling concurrent request submissions. Defined concurrent programs, functions, menus, Flex fields and registered forms. Creating Value sets, Values.
§ Involved and assisted in preparation of upgrade plans, project status reports, maintaining log of issues and resolutions, Migration of files to appropriate place in production and other environment systems, generation of files and compiling database objects.
§ Have done performance tuning for the complex queries by using EXPLAIN PLAN.
Dec ’04 – May ‘05
Engenio Information Systems, Wichita, Kansas as Oracle Applications Developer (Consultant)
Oracle Payables:
§ Have done Vendor Conversion.
§ Have worked on Payable Open Interface.
Oracle Receivables:
§ Worked on customer Interface to convert customer data from 11.5.8 to 11.5.10
§ Developed a Custom form to view and update Invoice Interface lines.
Oracle Purchasing:
§ Have done PO Conversion.
§ Have created custom PO conversion errors report.
Oracle Inventory:
§ Have done Item and Categories conversions
§ Developed a SQL*Loader script to load the accounting segment flex field values from excel sheet in to the staging table.
§ Developed a SQL*Loader script to load the template names from excel sheet in to the staging table.
Other Contributions:
§ Have done successful coordination between LADDBA’s, OnDemand Team and Offshore DBA’s to export data from 11.5.8 instance to 11.5.10 instance.
§ Have created Shell and SQL scripts for all the export and import utilities.
§ Created SQL Loader scripts to load the data from excel sheet to staging tables.
§ Code review of the team members
§ Technical help to the team members.
§ Prepared CV040’s, CV60’s, CV70’s and CV120 documents.
§ Gathering the requirements from client and passed the information to the offshore team.
§ Prepared installation scripts to move the code from DEV to UAT, QA1 and PROD instances.
§ Have done performance tuning for the complex queries by using EXPLAIN PLAN.
§ Created Alerts as per the business requirement.
May ’04 – Dec ‘04
American Tire Distributors, Charlotte, North Carolina as Oracle Applications Consultant
§ Worked on the following tasks for an Oracle Applications implementation:
Purchasing:
§ Have done major customization for PO form.
§ Major customization for PO approval (POAPPRV) workflow.
§ Have done CUSTOM.pll customization for PO form.
§ Have done PO conversion and Vendors Conversion.
Payables:
§ Have worked on Payable Open Interface.
Inventory:
§ Have done Item and Categories conversions.
Alerts:
§ Created Alerts as per the business requirement.
Other Contributions:
§ Have done major customization for PO form.
§ Prepared CV60’s, CV70’s and CV120 documents.
§ Prepared installation scripts to move the code from DEV to UAT, QA1 and PROD instances.
§ Attended End user testing phases in UAT, QA1 instances and resolved the issues immediately.
Education:
Education:
BSc Electronics. Nagarjuna University. India.
Master of Computer Applications (MCA). Nagarjuna University, India
Skills:
Worked in Oracle Applications Release 11.5.3i, 11i consisting of AP, AR, GL, Order Management, Purchasing, Inventory, AOL, Sys Admin, Alerts and Workflow modules. Strong technical skills in Oracle Forms 4.5/6i, Reports 2.5/6i, SQLPLUS, PL/SQL, and SQL*Loader. Experience in Oracle AIM technical documentation and familiar to Oracle 11i Upgrade and its Implementation.
Additional Information:
Oct ‘03 – May‘04
Imagistics, US Filters and USG, as Oracle Applications Technical Consultant
§ Worked on various custom application developments.
§ Worked on all open TAR’s.
§ Worked on customizations and extensions.
§ Prepared MD070, MD120 and TE040 documents.
§ Have created shell scripts and registered as a concurrent programs.
Jun‘03 – Sep‘03
Diebold Systems, as Oracle Applications Technical Consultant
§ Have done customizations for Order Header (OEOH) and Order Line (OEOL) workflows.
§ Have done customizations for SO-PO workflow.
§ Have designed and implemented custom progress billing forms.
§ Prepared MD070, MD120 and TE040 AIM documents.
§ Have created a package for Sales Order Org Conversion Unschedule.
May‘02 – Jun‘03
Sanmina, as Oracle Applications Technical Consultant
§ Have done customizations for Order Header (OEOH) and Order Line (OEOL) workflows.
§ Have done Item Conversion.
§ Created various value sets depending on the business requirements.
§ Prepared MD070, MD120 and TE040 AIM documents.
§ Have created SQL*Loader scripts for loading the data from source system to the Oracle staging tables.
§ Created a package for Custom BackOrder Cancellation.
Jul‘01 – Apr‘02
Logitech, as Oracle Applications Technical Consultant
§ Have created custom forms.
§ Have done code review and unit testing
§ Prepared unit test cases and test scripts.
§ Prepared MD070, MD120 and TE040 AIM documents.
§ Custom Sales Orders Ship From Organization Update Report.
Feb‘01 – Jun‘01
P&O Nedlloyd Ltd, as Oracle and Unix shell script developer
§ Have worked on a Production Support System & gave the support for 24 X 7 basis.
§ Installing the patches and releases in different Environments.
§ Customizations of scripts in all the environments as per the business requirements.
§ Data Loading from one Environment to another Environment & Job Setups.
§ Solving the tickets as per the business priority.
Aug‘00 – Jan‘01
Cisco Systems, as Oracle, PERL and Unix shell script developer
§ Coding and Maintenance of the existing System.
§ Bug Fixes and Enhancements.
§ Preparing test scripts and code walk through.
§ Database Related Work (Creating Tables, Indexes, Sysnonyms, Altering tables etc).
§ Solving the tickets as per the business priority.
Jul‘99– Jul‘00
Swastik Systems, Pune, India as Oracle and Developer 2000 developer
§ Designing forms and generating the reports as per companies’ requirement.
§ Writing triggers, procedures, functions and packages.
§ Trouble shooting, maintaining the existing system.
§ Created Tables, Indexes, Synonyms and prepared Altering tables scripts.
Jan‘99 – Jun‘99
National Informatics Centre, Hyderabad, India as Oracle and PERL developer
§ Designing the required database tables.
§ Writing triggers, procedures, functions and packages.
§ Coding and Unit Testing.
§ Designing Homepages by using FrontPage 98 and HTML forms
Candidate Contact Information:
This candidate has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response. |
|
|
|
|
|