SUMMARY

• Over 15 Years of Experience in IT and 9 years in Oracle EBS implementation and Enterprise Applications Practice with proven experience in Developing, Customizing and Supporting Oracle Applications (11i & R12), AOL of Oracle E - business Suite. These include Analysis, Design, Development and Implementation of different projects for applications based on Relational DBMS, and in the field of Oracle e-business Suite.
• Exclusive experience in 12.2.4 upgade
• Good Expertise in developing applications using SQL, PL/SQL, Database Triggers, Stored Procedures, Oracle 10g/9i/8i/8.0.5/7.x and Developer 6i and 10g.
• Expertise in RICEW (Reports, Interfaces, Conversions, Extensions and Workflow).
• Highly proficient in requirements gathering, business systems study, technical solution design, and system document preparation using AIM methodology
• Good Expertise in Query and Performance tuning in Oracle.
• Good Expertise in developing automated processes using Oracle Workflow 2.6 /AME
• Good Expertise in developing self service applications using Oracle Application Framework (OA Framework) using Oracle Jdeveloper 9.0.3/10g.
• Extensive experience in conversion of legacy data into Oracle Applications using SQL Loader and PL/SQL.
• Extensive experience in creating new reports and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications.
• Extensive Experience in using Oracle Application Object Library (AOL) features including implementation of Flexfields (Like Implementing Cross Validation Rules, Implementation flexfields in reports, Security rules), creating and scheduling of Concurrent programs etc.
• Experienced in Full software development life cycle implementation (SDLC).
• Extensive experience in design and development of applications under UNIX and Linux environments.
• Setup and Configured applications to support client requirements.
• Good Expertise in TCA (Trading Community Architecture).
• Good Expertise in functionality of Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Oracle Purchase Order(PO), Oracle Order Management (OM), Oracle Projects (PA), and Oracle Application Object Library (AOL).
• Good functional expertise on Open Interfaces (Includes both inbound and outbound interface) in Oracle Financials.
• Experience in E-R Modeling to create Data Models both Logical and Physical design using ER Win.
• Experienced in working with Huge Datasets comprising of at least greater than 10 Mill records.
• Competent in Tuning the SQL and PL/SQL Procedures by enforcing HINTS and OPTIMISER and by using SQL Trace, Explain Plan and TKPROF Tools.
• Exposure to data support on Multiple Environments like UAT, SIT, DIT, Training, and Production Environments on an Enterprise Level. Responsible for data consistency and integrity across the board.
• Enthusiastic to learn new skills with a shorter learning curve.
• Excellent Communication, Good Work Ethics and a Team Player.

TECHNICAL SKILLS

ERP: Oracle Financials Release 12, 11i, and Release 10.7. Accounts Receivables (AR) Accounts Payables (AP)General Ledger (GL), Oracle Projects (PA), Oracle Purchasing (PO), Oracle Inventory (INV), Fixed Assets (FA)Oracle Cash Management, Oracle iSuppliers, TCA

Others: Oracle Application Object Library (AOL)Oracle Workflow version 2.6.

Databases: Oracle 11g, 10g, 9i, 8.x/7.x/6.x, SQL Sever (v7.0).

Development Tools: Oracle Developer - Forms 10g/6.x/5.0, Reports 6.x/3.0/2.5 Oracle Discoverer 4i, 3.0, Oracle Jdeveloper 11g (OA framework)

Programming Languages: Java 2.0, PRO*C, SQL, PL SQL, HTML, XML.

Operating Systems: Windows 2000, Windows NT, Windows 98/95Unix, Sun Solaris, AIX, HP-UX, IRIX.

Hardware: Intel Based Servers and Workstations, HP DEC AlphaDEC VAX.

Case Tools: Oracle Designer 2000

Version Control Tool: CVS, RCS.

Tools: TOAD, SQL-Navigator, and SQL Loader.

Scripting: ksh/ C shell/ Bourne professional experience

PROFESSIONAL EXPERIENCE

Confidential - Dallas Texas

Sr. System Analyst

Environment: RICE Elements, R12.2.4, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Responsibilities:

• Lead in preparing 11i environment to readily available for R12 patching by coordinating with admin team in running the readiness reports and fixing the issues raised by readiness reports.
• Lead in running Panaya tool to identify all the impacted custom objects that has to be retrofitted.
• Lead the initiate of implementing 12.2.4 coding standards.
• Developed the OAF customizations in Customers pages which are changed from Forms to OAF.
• Developed I-Proc pages in accordance to 12.2.4
• Developed/Retrofitted AP check printing program according to R12.
• Retrofitted objects of AP, AR and GL in accordance to 12.2.4 standards..
• Co-ordinated with offshore team in compiling the custom forms and reports in 10g which are developed in 6i.
• Co-ordinated with offshore in retrofitting other module objects.
• Involved in arranging the sequence of objects for migration activities.
• Expertise in using the PVCS and Kintana tools for version control and migrating objects from instance to instance.

DISD - Dallas Texas

Sr Application Analyst

Environment: RICE Elements, R12.1.3, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Modules: Oracle Inventory (INV),Oracle Payables(AP), Oracle Purchase (PO), Oracle General Ledger(GL), Oracle HRMS, Application Object Library (AOL), Oracle Order Management (OE/OM), Oracle Accounts Receivable (AR), Oracle Fixed Assets (FA), Oracle iSuppliers and Oracle Cash Management.

DISD implemented Oracle ERP 12.1.3 system for their ongoing business requirements. DISD maintains their Vendor information, Payment, Purchasing, HR and Payroll in Oracle ERP system. All expenses and vendor payments will be done through Oracle AP.

Responsibilities:

• Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology.
• Gathering User requirements and implement them in the best possible way and document the process.
• Experienced with P2P and O2C cycles.
• Defined the Autoinvoice in Accounts Receivable and confirmed the Auto applications.
• Configured AP, Payment Terms, Transaction Type, Tax, Auto Posting, Past-due & amp, aging.
• Interact with third Party vendors like Riskconnect, setup them as Vendors in Oracle AP module and process invoices, electronic payments for these Vendors.
• Automated Employee vendor Bank Account in synch with Payroll Bank Account for Electronic payment.
• Customised I-Supplier Self serviced pages to capture Bank Account Details.
• Developed INBOUND and OUTBOUND Interfaces based technical specifications.
• Developed custom reports (including BI Publisher) in Financial Modules based on user requirements.
• Configured descriptive (DFF) flex fields for storing custom information.
• Developed, Personalized & Configured through Oracle Forms, Oracle Reports, Oracle Workflow, Oracle ADI, Oracle APIs, Fast Formulas, Oracle 10g, PL/SQL, UNIX for Writing registration Scripts for Application Object Library objects, also used FND LOAD to migrate object from one instance to another.
• Developed OAF pages using Oracle Jdeveloper.
• Post production maintenance for the conversions and interfaces in Oracle Applications.

Confidential - Dallas Texas

Sr Application Analyst

Environment: RICE Elements, R12, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Responsibilities:

• Preparing MD070 documents based on MD050.
• Experienced with P2P and O2C cycles.
• Gathering User requirements and implement them in the best possible way and document the process.
• Done the Configuration for GL, AP, AR, and Cash Management modules as per the client needs.
• Interact with third Party vendors like OFFICEMAX to setup them as Vendors in Oracle AP module and process invoices, electronic payments for these Vendors.
• All store managers does have corporate credit Cards for their expense maintenance, American express sends these Credit Card expenses electronically, we load these transactions as Credit Card Expenses into Payables and these payment for these Credit Card transactions will be made through normal AP Invoice, payment Process.
• Designed Technical Designs for RICEW elements based on Functional Specs.
• Load OfficeMax XML formatted Invoices through Payables Open Interface Process in AP.
• Load and Pay (through EFT or checks) vendor Invoices.
• Projects Expenditure Transactions Process.
• Developed INBOUND and OUTBOUND Interfaces based technical specifications.
• Developed custom reports (including BI Publisher) in Financial Modules based on user requirements.
• Implementing Forms personalization.
• Internal Sales Order/Internal Requisition process was Configured to establish a simplified Intercompany sales across operating Units
• Developed custom self serviced pages using Oracle Jdeveloper.
• Development of Custom Packages, Procedures and Functions in ERP. Involved in Performance Tuning of the SQL Statements to reduce the process time. Conducted Business meetings for the Project plan.
• Writing registration Scripts for Application Object Library objects, also used FND LOAD to migrate object from one instance to another.
• Developed shell scripts to automate the processes using Autosys scheduler.
• Post production maintenance for the conversions and interfaces in Oracle Applications.

Confidential, TX

Application Developer

Environment: Oracle 9i / 10g (PL/SQL, Export / Import, External Tables, SQL*Loader, SQL Trace, Explain Plan, TKPROF, CRON TAB), HP-UX B.11.00, ER Win 3.5.2, TOAD, Developer 2000, DB Artisan, Win CVS, J2EE Architecture, MS Windows XP/2003, MS Office 2003, MS Project 2000, MS Visio.

Responsibilities:

• Developed GUI for PLMs to define/enter product data using Developer 2000.
• Developed procedure to extract data from National Console and populate the data in different tables.
• Involving actively in deriving the requirements with the Business Folks.
• Document these product changes and present them to development teams.
• Developed Stored Procedures that are available to the ordering system to pull products based on the needs.
• Using ER Win for Making changes to the physical data model based on the Business requirements.
• Refresh the monthly data of NPA/NXX/Switch clli from Telcordia in different environments.
• Developed product validation scripts based on the Business requirements.
• Generate scripts for new product change requests and load them in DIT/SIT for testing.
• Have scheduled jobs using CRON TAB to load the above in the Production after test certification.
• Looking in Bug tracking Tool Merant Tracker for IRs raised against PCAT.
• Document and Co-ordinate the new products changes with application development team and testing team.

Confidential, TX

Oracle Developer

Environment: Oracle 9i, (PL/SQL,CRON TAB, Export / Import, External Tables, SQL*Loader, SQL Trace, Explain Plan, TKPROF), Sun Solaris 5.8, RH Linux AS 2.1, Win CVS, Merant Tracker.

Responsibilities:

• Actively participated in the Business and SSP Architectural Meetings.
• Document the Business requirements and design.
• Based on the Test Feeds, took the ownership of mapping the corresponding data elements in SSP.
• Developing the necessary loading scripts for loading the source data using SQL*Loader and External Tables and resolving any Data Type related Issues.
• Installing and Maintaining the Version Control System - WinCVS.
• Installing and Maintaining the Bug Tracking Tool, Merant Tracker.
• Developing the Packages, Stored Procedures and Triggers to in corporate the Business Logic.
• Developed a Parallelization process at the UNIX Level, which fastens up the process thereby reducing the Application Downtime.
• Developed a module for Address Conversion from USPS to G1C1 Format using a third party tool called G1 SW.
• Extensively used the DBMS OBFUSCATION package for handling sensitive customer Data.
• Developed a Java Component using XML, that Parses Addresses from a G1C1 XML Service. Further along, parallelized this process as a Batch Mode.
• Taking the Database Dump using Export / Import Utility to provide data to other environments like UAT, SSP Training and PLE on adhoc basis after the mock runs.
• Post Conversion -- Generating the required External Feeds to various systems like ARBOR, Remedy, VIS etc
• Actively involved in planning the System Downtime and Co-Ordination during the actual Conversion Process.
• Documented the Archival of the old Source System effort.

Confidential, TX

Oracle Developer

Environment: Oracle 9i / 10g (PL/SQL, Export / Import, External Tables, SQL*Loader, SQL Trace, Explain Plan, TKPROF, CRON TAB),Developer 2000, HP-UX B.11.00, ER Win 3.5.2, TOAD, DB Artisan, Win CVS, .NET Architecture, MS Windows XP/2003, MS Office 2003, MS Project 2000, MS Visio.

Responsibilities:

• Involved actively in deriving the requirements with the Business Folks.
• The entire Front end is done in Developer 2000.
• Using ER Win, designed the Data Model for the Tool.
• Loading the flat files into Source tables in the schema using Oracle External Tables and SQL* Loader.
• Developed the necessary Packages and Stored Procedures to in corporate the Business Logic.
• Tuning the SQL’s by enforcing HINTS, choosing optimizers and Tuning utilities like SQL Trace, Explain Plan and TKPROF.
• Developed the necessary Shell Scripts to facilitate the automation of the process from loading and until the Refresh is complete with necessary notification processes.
• Developed a Parallelization process at the UNIX Level, there by reducing the refresh time from 24hrs to 8hrs.
• Have scheduled recurring jobs using CRON TAB.
• Refreshing the data from and to various environments like UAT and PLE by using Export / Import Utilities of Oracle.
• Monitoring the Activity.
• Post Production, held the responsibility for smooth transition of Production support to the Off shore Teams.

Confidential

Oracle Developer

Environment: Oracle 7.3, Developer 2000, SQL, PL/SQL,SAS, Unix, Brio, HTML, Visual Basic, Word, MS SQL Server, Windows NT.

Responsibilities:

• Involved in the system analysis and designing for the upgrading of manual Sales Ordering System into Computerized system using Oracle 7.3 and Developer 2000.
• The complete process of Sales Order Processing, maintaining records and keeping track of all the daily transactions with the provision of getting periodical Reports from the desired departments of the Organization.
• The database, which was maintained manually in MS Access, after a thorough analysis has been divided into various modules and the same, is stored in the form of tables by using ORACLE.
• Extracted data from existing data source by using SQL, PL/SQL, and UNIX.
• Created tables, views, procedures, SQL scripts.
• Received training as a junior DBA
• Physical and Logical Database Backups. Export/Import Tables.
• Developed forms using Forms 4.5 using advanced GUI features like pop-ups, stacked canvasses etc.
• Designed & developed reports using Oracle Reports, SQL, PL/SQL.
• Responsible for generation of DDL, DML Queries and Sub Queries. Responsible for writing various Database Triggers & User level triggers. Responsible for writing stored procedures.
• Developed the GUI using Developer 2000. Developed Records, Views, Panels, Panel Groups, and Menus. Validations (Data Validation, User Validations) were performed depending on the criteria.