SUMMARY

• A distinguished IT professional with more than 7+ years of Professional experience on Oracle Applications as a Techno - Functional consultant in Oracle ERP Application (R12, 11i)
• Main focus on Implementation, Upgrade, Production Support and tuning of Order to Cash, Oracle Financials, Oracle Manufacturing and Oracle Purchasing, Order Management and Supply Chain modules.
• Experienced in ERP Applications & Client Server Technologies, along with Development, Testing, Support, Upgrade and Tuning of Oracle Financials, Oracle Manufacturing, Oracle Purchasing, Order Management and Sales.
• Experience in all phases of the Software Development Life Cycle (SDLC) in an ERP environment.
• Outstanding Functional/Technical knowledge in Oracle Applications Oracle Financials like (GL-General Ledger, AP-Accounts Payables, AR-Accounts Receivables, FA-Fixed Assets, CM-Cash Management), PO-Oracle Purchasing, OM (Order Management/Advanced Pricing), Manufacturing (INV-Inventory, WIP-Work in Progress, BOM-Bills of Materials, WMS-Warehouse Management), Install Base, Service Contracts, iExpenses, iProcurement and AOL (Application Object Library).
• Strong implementation knowledge of O2C(Order to Cash), P2P(Procure to Pay) and Drop Ship end to end Cycles.
• Excellent skills in SQL, PLSQL, Developer 6i/2000 (Oracle Forms and Reports), Discoverer Reports
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Hands on experience in implementing RICE (Oracle Reports 6i/Forms 6i, Interfaces, Conversions, Extensions) components, workflows, Oracle Alerts, Lookups, OA Framework (OAF), ADF, JDeveloper, XML Publisher Reports.
• Extensive experience in design, development, customization and implementation of various business applications in different platforms using Client-Server Technologies.
• Hands on experience in using various Oracle technologies to effectively implement an end-to-end solution to an organization's strategic goals and objectives including: Oracle 11i E-Business Suite, Oracle Discoverer, Oracle Application Server and Oracle PLSQL and SQL and Oracle RDBMS, Oracle Developer (Oracle Forms and Reports Developer)
• Possess good expertise in developing programs using SQL*loader, Toad and PLSQL procedures to transfer data from legacy systems with knowledge in Unix Shell Scripting.
• Good Knowledge of Multi organization Access control (MOAC) architecture and understanding of MOAC Impact on custom programs development like report, forms, and workflow PLSQL packages.
• Experience in development of concurrent programs, customization and modifications of reports.
• Possess good project management skills and also have lead in many projects.
• Strong familiarity with AIM methodology in creating BRD, MD-50, MD-70, MD-120 and also Testing documents throughout multiple Projects.
• Knowledge and Experience of TCA (Trading Community Architecture).
• Expertise in developing custom reports in XML Publisher.
• Demonstrated ability to identify root causes/ debugging of problems and troubleshoot, considering both long and short-term impact of proposed solutions and developed workable solutions
• Inventory Item configuration for ASCP and OPM and also Demantra Demand Management.
• An Excellent Team Player with good problem solving approach having strong communication, leadership skills and ability to work in a time-constrained and team-oriented environment.
• Extensive Functional & Technical skills in the area of Business User Interaction, System Requirement gathering, Application Development, Customizations and Implementation of software applications in client-server, database and enterprise software environments.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite Versions 12i/ 11.5.10/11.0.3

Modules: Order Management (OM), Inventory(INV), Bills Of Materials(BOM), Account Receivables(AR),Purchase Order(PO),Fixed Assets(FA), Account Payables(AP),General Ledger(GL), Cash Management (CM), Application Object Library(AOL), Work In Process (WIP), Bill of Material (BOM), WMS (Warehouse Management), WSH (Shipping), Flex fields, Trading Community Architecture (TCA), CRM, Service Contracts, Service Fields, Sysadmin, INSTALLBASE

Tools: Toad, SQL * Loader, PLSQL Developer, Discoverer, Data LoaderBI/XML Publisher, Load Runner

GUI: Developer 6i, Developer 2000,Forms 6i/10g, Reports 6i/10g

Programming Languages: SQL, PLSQL, C, C++, Java, HTML5, PHP, UNIX Shell Scripting

Database: Oracle 9i/10g/11g, Microsoft SQL Server 2010, MS Access

Operating Systems: Windows 98/2000/NT/XP/7/8, Unix(Solaris, HP-UX), Linux.

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

Oracle Applications SCM Functional Consultant

Responsibilities:

• Working as an Oracle Apps SCM Functional IT Consultant, involved in various Implementations, Upgrade project from R12.0.6 to R12.2.4 and also in the Production Support Environment.
• Heavily involved in working on the Custom Object list and end to end testing of both the Seeded Forms/Functionalities along with the Custom Objects post upgrade.
• Developed Test plans associated to the Custom Object list which had to be executed in HP Quality Center 12.01.
• End to End flow in the Order to Cash (OTC) modules: OM, Inventory, Warehouse, Purchasing, Receiving and also very much involved in working on the WIP Process for all the Discrete Jobs during the assembly process for various ATO, PTO items.
• Possess experience with other standard and custom module integrations that deal with the following modules:WIP, BOM, WSH, WMS
• Involved in the Implementation phase on various projects, creating the Business Requirements (BRS) and also in the overall end-to-end Functional based testing for the associated Projects.
• Created the Business Requirements needed for the necessary changes to be implemented keeping the essential goal of this project intact which was to create special labels for the Customer that would comply by the Federal Regulations.
• Functional IT lead in the Defense related Project for the United States Air Force (USAF) called the ‘AFWAY Order Process’
• This would involve the use of a Special Label Item which would go on top of the Ordered Equipment and would contain the following specifications.
• AF Way Order Information (External to Oracle System).
• Equipment ID & Serial Number (From Oracle System)
• The label would be print using a special software called the Bartender and then a Verifier would be used to scan the Barcode that would grade the quality of the code, which is then verified which provides a detailed analysis about the Barcode’s quality which would be used to identify any print quality issues and would suggest a proper corrective measure to be taken.
• The label item had to be added as part of the BOM configuration for specific ATO models.
• Used the Mobile applications interfacing with Oracle during the WIP Job process (WIP Issue, WIP Move and Completion).
• Involved in the Item setups and Item assignment to specific warehouses depending upon the required specifications and conducted validations as part of the post Go-Live activities.
• Functional IT Analyst in an internal project related to Dropship Process (Baja Direct Shipment) for the Inventory flow across two entities. The project is dealing with moving out the existing process which is in a legacy system (NSP) to Oracle R12.
• Drafted out the project scope and the Requirement Specifications for physical shipment of Inventory and also the IT solution for the Dropship process.
• Involved in the design of the following interfaces:
• PO Outbound Interface from R12 to RCL (External Network)
• Order Status/Advanced Shipment into R12
• Created the mapping on the datasets for the file transfer procedures which included what data format was being sent to and fro from R12 and also to interact with the sourcing agent ‘HULFT’.
• Created the required valuesets and make the valid setups for the Process change for the shipment process.
• Documented the required test case scenarios using the HP Quality Center as the Test Management Tool in defining the scheduled releases, drafting the requirements and also creating the cook book (Mapping) that also included Defect Reporting and analyzing the test results.
• Involved in the Component testing, Regression and the whole end-to-end testing of the processes to ensure required readiness for User Acceptance Testing.
• Strong familiarity with AIM methodology in creating BRS, Technical Documents (MD-120) and also Testing documents throughout multiple Projects.

Environment: Oracle Applications R12.2.4/R12.0.6, Oracle Forms 6i, Reports 6i, PLSQL, SQL Developer, Toad (12.1), SQL * Loader, Putty, Microsoft Visio

Confidential, Ann Arbor, MI

Oracle Applications Functional Consultant - Production Support Lead

Responsibilities:

• Working in Masco CabinetryProduction support team as an Order to Cash and Supply Chain (SCM) support consultant.
• Production Support Techno-Functional Consultant with hands on experience in the Order to Cash (OTC) modules: OM, Inventory, Warehouse, Purchasing, Receiving and module integrations withOM, GL, AP, AR, PO, INV, WIP, BOM, WSH, WMSwithinthe EBSSystem.
• Worked on Product Information Management (PIM) and the related setups to and conducted exhaustive Data Analysis and possess knowledge of Master Data Management concepts & best practices.
• Worked on several custom modules including Lot Management (LM) and Customer Care Consultant Hub (C3H) along with Intelliquote (IQ) which are all customized accordingly for the business functionalities to run.
• Integral part of the team handling any kind of user related issues, any production related task to monitor the activities for the various business processes to function accordingly.
• Very good Knowledge and Experience of TCA (Trading Community Architecture).
• Resolving a high number of Production Support Tickets/ Work Orders with a very quick turn-around time which was captured in our ticketing tool, Track-It
• Working with third party vendors and end business users to work on the day-to-day production issues and also during business impacting changes and deployments in Oracle EBS to identify potential Setup/Request changes to be made, identify bugs and apply necessary patches and use various performance tuning techniques (if necessary) to fine tune the existing business systems.
• Experienced in Onsite and Offshore model by relaying the project details on a daily basis for requirement classification and delivery issues and also on any active Production support issues which also include any kind of Support Activity in 11i and R12 and the primary focus would be to identify the risks using a proactive approach and proposing solutions to resolve them.
• Handle the month end activities for period closure by monitoring and fixing the stuck transactions for the Transaction Open Interface errors (MTL TRANSACTIONS INTERFACE), pending transactions (MTL MATERIAL TRANSACTIONS TEMP MMTT) and the transaction history (MTL MATERIAL TRANSACTIONS MMTT) in order to check for any uncosted transactions so that the cost can be accounted.
• Working on several key issues in the areas of manufacturing, shipping and LPN receiving.
• Possess very good expertise in developing programs using Toad, SQL Developer and PLSQL procedures and APIs to transfer data from legacy systems with knowledge in Unix Shell Scripting.
• Created a high number of SQL scripts and written procedures using the PLSQL programming to load the data from flat files into custom tables for various cases (Using UTL and also SQL Loader)
• Explain Plan, TKPROF to analyze the performance aspect of several different long running programs and scheduled jobs using the standard tuning tools and also a custom Tuning tool called HOTSOS.
• Created and developed several XML/BI Publisher report according to the requirements which included the changes to be made to several custom reports after the Upgrade.
• Interact extensively with the Functional users during the various stages of testing during the Support Change fixes that include Unit Testing, Integration Testing and Regression Testing supporting the defined solutions.
• Monitoring the custom applications for business specifications and debugging any associated issues and fixing them accordingly.
• Hands on experience in understanding the Recipe configuration for batching in OPM which will allow ASCP to drive production plan.
• Check with the business teams for ASCP sourcing rules configuration that will allow ATP to define the source taken from which is based on the Customer’s sites region.
• Collaborate in definition of business processes, documentation of business processes and systems requirements, conceptual designs and/or feasibility studies for proposed system capabilities.
• Use ClearCase for version management for the code changes for the respective Packages, Reports (rdf and rtf) and Forms (fmb).
• Included having the assistance for making the required setups and also handling the request sets for scheduling the jobs that are to be run and monitoring them on a periodic basis.
• Worked on any bugs that were identified during the debugging process that were causing a discrepancy in the program or was not giving the expected results.
• Strong familiarity with AIM methodology in creating BRD, MD-50, MD-70, MD-120, D0-60 and also Testing documents throughout multiple Projects.

Environment: Oracle Applications R12.0.4, Oracle Forms 6i, Reports 6i, PLSQL, Toad (11.5, 12.1), SQL * Loader, WinSCP, Putty

Confidential, Ann Arbor, MI

Oracle Applications EBS Functional Consultant

Responsibilities:

• Was an integral part of the Data Conversion/Migration project O2C OU Consolidation.
• This project was essentially an Upgrade Project where the data was being migrated from different operating units of Confidential from UK and Spain into the US Operating Unit. The essential stages of this project:
• Open OM Conversion
• Open SC Conversion
• Closed OM Conversion
• Closed SC Conversion
• Open AR Conversion.
• Deferred OM Conversion
• Deferred AR Conversion
• Thorough analysis in understanding the requirements and constraints on the data which is being converted in order to ensure there is no data loss.
• Initially all the orders in the UK and Spain Operating Units that were in ‘Open Status’ were converted into the US OU through the conversion script.
• Developed Item Master Conversion and Sales order Conversions.
• Analysis and design of Application Security Documents and Multi Org Structure, Multiple reporting currencies.
• Developed an API to apply holds to the original orders in open status that were converted in the UK and Spain Operating Units
• The OM Conversion for orders in open status was followed by converting all the Service Contracts and the Open Invoices from Receivables into the US operating unit.
• Simultaneous work was being put on into creating the scripts to convert the Service Contracts, Orders and Invoices.
• Key user Training for the landed Costing custom Module and Integration with Oracle Purchase
• Extract program for Open orders information (Requisitions, Purchase orders, Internal Sales orders, Move orders information which are not materialized)
• Developed scripts including custom APIs in order to convert all the orders in ‘Closed’ status (Closed order conversion) in order to bring the closed orders into the US Operating Unit in ‘Open’ status where customized programs were already in place to automatically book those orders, Invoice those particular orders, Run the AR adjustment criteria, Run the Revenue Recognition and eventually generate the desired reports.
• The Service Contracts were flipped initially where in the contracts were divided into two batches based upon the Invoices, where in the first batch was converted/flipped initially itself while the second batch comprised those invoices from the Open AR conversion and they were adjusted accordingly.
• Customized the AR Invoice, Sales Tax Reports in Receivables using Reports 6i and XML Publisher.
• Actively involved in the whole Data Conversion process, with all the processes being worked on independently in order to achieve the desired results of migrating the particular data.
• Performed QA analysis on the data that was converted in higher environments of Oracle and was tested accordingly.
• Developed XML/BI Publisher report to identify the particular order deliverables that were held during the migration process.
• Worked on updating the Pro Forma financial templates of Confidential according to User specifications.

Environment: Oracle Applications R12.1.3, O2C (OM, AR, INV, GL), Forms 6i, Reports 6i, PLSQL, SQL* Loader, Toad 11.5, WinSCP

Confidential, Memphis, TN

Oracle Applications Techno-Functional/Upgrade Consultant

Responsibilities:

• Involved in the Order management -Landed Costing Custom module-Inventory-Account Payable and Purchase-Landed Costing Custom Module-inventory-Account Payable.
• This project is an Upgrade Project and developed the below Custom reports using Reports 10g as per the client requirements in OM module
• Consolidated Pick Slip
• Packing Slip
• Daily Inventory Report
• Shipping Exception Report
• Item Label Report
• Bill of Ladding Report
• Worked on obtaining solutions regarding delete reservations in Oracle Order Management (OM)
• Analysis and design of Application Security Documents, Multi Org Structure, Multiple reporting currencies and Financial Statement Generator reports.
• Key user Training for the landed Costing custom Module and Integration with Oracle Purchase (OP), Inventory, Order Management (OM) and Account payable (AP).
• Import Work Orders from various legacy systems to Oracle Enterprise Asset Management and Oracle Order Management (OM) system.
• Extract program for Open orders information (Requisitions, Purchase orders, Internal Sales orders, Move orders information which are not materialized) and corresponding stock amounts program, which shows the costing information for those open orders in Purchasing (PO) and Order Management (OM) and WMS (Warehouse Management).
• Was part of the team that identified the Gaps and bugs and performed Gap analysis in Oracle ASCP.
• Was involved in the later stages of testing the Demantra design and Application.
• The upgrade related issues were worked upon and the respective patches were suggested to the DBA while also implementation practices were performed.
• Hands on experience dealing with Install Base and Service Contracts with the associated business teams.
• Took part in interactions with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow.
• Support and administer core manufacturing applications inside the Oracle E-Business Suite such as Work in Process, Bills of Material, Warehouse Management (WMS),Product Configuration and Shop Floor Management.
• Customized the AR Invoice, Sales Tax Reports in Receivables using Reports 6i and XML Publisher.
• Involved in implementation Sub Ledger Accounting for Primary Ledger and reporting secondary ledger.
• Experience with implementation and support of Oracle 11i and R12 applications including Oracle Applications Framework, SQL, PLSQL, Oracle workflow, Form personalization, Oracle Alerts, OBIEE, XML Publisher, and Forms.
• Good Understanding of fundamentals of ADF/JDeveloper framework.
• Customized the Print Purchase Order Report based upon user requirements
• Customized the following workflows: PO Approval Workflow: Implemented notification reminder and Timeout needs for the PO Approval workflow, PO Account Generator Workflow

Environment: Oracle Applications R11.5, 10.2 (AR, AP, GL, PO, FA), Solaris, Oracle 9i, Forms 6i, Reports 6i, Discoverer 4i, PLSQL, SQL* Loader, Toad.

Confidential, Belcamp, MD

Oracle Applications Functional Consultant

Responsibilities:

• Responsible for requirements gathering and definition, conversion of business requirements intotechnical specifications,technicalproject plans, overseeing the development work etc.
• Was actively involved in this Implementation project in the following modules OM, PO, WSH, WIP, INV, AP, Service Contracts.
• Manage the data integrity and timely completion/closing of shop orders and material information in shop floor data systems and MRP.
• Developed APIs to create temporary tables and SQL*Loader control files to load the item legacy data into the temporary tables.
• Loaded the vendor’s information from the legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
• Developed BI reports per business requirements.
• Developed AP Invoice interface to load data from legacy system to AP interface tables.
• Imported Open Payables Invoices from legacy system into Oracle AP using Ap Invoices Interface and Ap Invoice Lines Interface tables.
• Worked on the Budget Upload Open Interface to load the data from legacy systems to the GL Budget Interface table using SQL*Loader.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Used Template, sub Template method for a creating single report with multiple Layouts
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level
• Developed Business Areas, Custom folders, Item classes, Hierarchies in Discoverer Administration Edition
• Created Workbooks based on the Custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer Plus and Discoverer Desktop.
• Worked on developing XML/BI Publisher reports which also included developing the Supplier Demand Data that specified a lot of custom process detailed data.
• Involved in Performance tuning of the discoverer reports.
• Actively involved in System integration and User Acceptance phases.
• Modified and created new concurrent programs as well as executable files when new reports were created.
• Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
• Development/modification of custom reports in purchasing and payables
• Developed PLSQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.

Environment: Oracle Applications R12/11.5.10, Reports 6i/10g, SQL, PLSQL of Oracle 9i/10g,PLSQL on UNIX, Windows 2000/NT environment, Forms 6i/10g, Discoverer10g, XML/BI Publisher, Toad, SQL * Loader.

Confidential, North Wales, PA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Understanding the existing system and working in a Confidential ERP implementation project as an Oracle Applications Technical Consultant.
• Worked with the functional team while extracting non-Oracle data and Converting to Oracle with validations.
• Designed & Developed AP Invoice Open Interface and AP Invoice Audit Report for the different Sources in Oracle Payables.
• Work with functional setups to create AP invoice sources, Accounting flex field, Chart of accounts.
• Implementation and Customization of MODULES AP, AR & GL, FA, Service Contracts, Install Base in Multi - Org environment.
• Responsible for creation of MD070s for AP Invoice import.
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger, Purchasing and Payables and Fixed Assets Module.
• Responsibilities included technical design, development and support for “Order to Cash” (O2C) and “Procure to Pay” (P2P) business processes.
• Also worked on PIM related issues during the item creation to check the process on a broader scale.
• Developed a custom layout XML format according to the user specifications and worked on incorporating it to the standard print Purchase Order and Invoice reports using XML Publisher (BI Publisher).
• Developed conversion program for validating and importing Open AR Transactions (Invoices) from legacy system to Oracle interface tables. Used Auto invoice Master Program to load the interface table data into Oracle AR base tables.
• Created new custom reports in XML/BI Publisher and used Template, sub Template method for a creating single report with multiple Layouts
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level
• Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Worked with the GL Journal Import, AP Invoices, AR Invoices, Item conversions
• Developed custom forms and reports to correct interface errors and send the error messages to legacy system owners.
• Using SQL*Loader loaded the data into staging table, Developed PLSQL packages to validate the data and load into interface tables.
• Involved in the setup for customers using the TCA Model.
• Involved in Developed Advanced Shipment Notice (ASN) process and printing.
• Designed and Developed the Commission payments project, which loads the all rep groups and percentages information to the custom tables.
• Involved in migrating developed objects between instances. Developed custom shell scripts to create synonyms and grant necessary permissions for the objects which are being migrated into new instances.
• Developed an outbound interface to export GL data to third party systems, also inbound interfaces to import into GL by populating GL Interface Table.
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM).
• Developed new and customized existing Oracle and Discoverer reports as per the user request.
• Involved in testing existing FSG reports.
• Developed AIM Documentations for the components.
• Involved in Peer review and Unit testing.
• Involved in resolving daily business issues in Quick time.

Environment: Oracle Apps 11.5.8, Procure-2-Pay, Oracle 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PLSQL, AP, GL, PO, AR, OM, INV, TCA, TOAD, Discoverer, XML Publisher, SQL*Developer, Forms(6i), UNIX, Shell Scripting, WINDOWS XP.

Confidential

Oracle Developer/PLSQL Intern

Responsibilities:

• Worked actively with the Reports Development Team in creation of specific customized reports according to user needs.
• Developed new Custom Oracle 6i, SQL, PLSQL Reports as per the business requirement.
• Was primarily involved in the design and development of certain reports like Income Statement with Variance, AI (Annual Income) Budget Statement, Cumulative Balance Sheet (CBS) and Budget/Actual Report, CBS and Income Statement consolidated report.
• Involved in the requirement gathering, analysis and design of the interfaces and reports.
• Creation of new customized reports in XML/BI publisher and upgraded Standard 6i reports to XML/BI publisher reports.
• Developed various Form letter reports and Mailing list reports using Reports 6i.
• Customized Supplier Paid Invoice History Report, Supplier Merge Report, Supplier Audit Report, Chart of Account Detail Listing Report and Supplier Payment History Report in Account Payables using Oracle Reports 6i.
• Extensively Modified Shipping INBOUND/OUTBOUND interface programs to accommodate changes in business process.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various custom PLSQL Packages developed.
• Created required shell scripts for secured FTP with error handling capability.
• Developed design and implementation documents such as MD050, MD070, MD120, Unit Test scripts and user-documentation.

Environment: UNIX Shell Scripting, Developer (Forms & reports 6i, XML publisher), PLSQL, SQL*Loader, TOAD, Oracle Apps (OM, WSH, INV, BOM, WIP, PO, AR, GL)

Confidential

PLSQL Intern/ Developer Intern

Responsibilities:

• Extensively involved in coding of the Business Rules through PLSQL using the Functions, Cursors, Triggers, Stored Procedure, and Packages in the server side.
• Participated actively in the technical and functional discussions.
• Extensively involved in designing the project and coordinating a highly professional team.
• Customized PO Approval workflow process using Workflow Builder and define processes based on the purchasing amount and ship to location.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Designed ER diagrams and normalization of database.
• Involved in the complete Order to Cash, Procure to pay cycle, Oracle Grants and Projects implementation.
• Implemented Order Management Workflow extension for RMA Finance approvals for various financial validations which Carnival requires during Order to Cash process.
• Seeded OM Workflows are copied and customized.
• Developed scripts to create tables, views, procedures and functions and executed them using SQL*Plus.
• Seeded OM workflows were copied and customized accordingly.
• Worked on the entire life cycle of the project starting from Requirements Gathering, Analysis, Design, Development, System Testing and Production support
• Migrated the data from external files into Database tables using SQL *Loader.
• Extensively involved in performance and tuning of all SQL and PLSQL code.
• Used Built-in Packages provided by oracle for debugging.
• Reviewing / Testing Procedures & Functions developed by the team members.
• Wrote triggers to handle user-generated events.
• Developed UNIX shell scripts to schedule the cron jobs.
• Used Developer 2000 to generate reports of statements for users.

Environment: Developer 2000, SQL, PLSQL, Oracle 9i, UNIX, Windows 2000