SUMMARY:

• 14+ years work experience in Oracle Apps, Standalone Application, Client Server and Oracle database design and development. 9+ years of work experience in USA.
• Managed Team work assignments and delegation of tasks based on work schedule.
• Technical consultant in Oracle ERP with experience in conversions, interfaces, forms, reports and workflow customization; implementation; unit testing; support and migration in Oracle EBS R12/11i/10.7.
• Experience in design and development of Conversions, Interfaces, Forms, Reports and Workflow for Implementation in Service Contracts (SC), Install Base (IB), Trading Community Architecture (TCA), Warehouse Management System (WMS), Accounts Receivable (AR), Accounts Payable (AP), General Ledger (GL), Order Management (OM), Inventory (INV), Bill Of Materials (BOM) and Purchasing (PO) modules; Order To Cash cycle; Procure to Pay Cycle.
• Conversant with aspects of Application Object Library (AOL); AIM Functional, Technical and Migration documentation; MD50, MD70 and MD120 documents.
• Experience in designing and development of applications, Oracle Apex application and Data Base.

TECHNICAL SKILLS:

Programming Languages: C, PL/SQL, Unix Shell Scripts, AWK and SED.

Frameworks: APEX 3.2/4.0.2/5.0

RDBMS Oracle: 11g/10g/9i/8i/8.x/7.x

Tools: /Utilities: SQL*Plus, Developer suite, JDeveloper, Workflow Builder, SQL*Loader(SQLLDR), Export(EXP) and Import(IMP), SQL*Navigator, Toad, FTP/SFTP, Smart Term, Visio and Projects.

Operating Systems: Sun Solaris, HP - UX, AIX and Windows.

Software Configuration Management: PVCS, Star-Team, CVS

Clearance: DOT(NHTSA) and Department of Veterans Affairs projects needed OPM based Federal Agency Verification and Security Clearance

WORK EXPERIENCE:

Confidential, Oakland, CA

Lead Technical Consultant

Responsibilities:

• Interacting with functional team based on functional document.
• Design and Development/Modification of Apex based pages, PL/SQL stored procedures, functions and packages to business logic of HSA, HRA and FSA modules of Health Care Administration Software.
• Design and Development of Apex 5.0 application prototype for health care administration.
• Data Loading using SQL*Loader, scheduled to run using crontab.
• Unit Testing and Integration Testing of PL/SQL code.

Environment: SQL*Plus, PL/SQL, SQL*Loader(SQLLDR), SQL Developer, Apex 4.0.2/5.0, Unix and Windows

Confidential, Bakersfield, CA

Lead Developer

Responsibilities:

• Interacting with functional team based on functional document.
• Design and Development/Modification of Forms, Reports, Apex based pages, Shell scripting interfaces, PL/SQL stored procedures, functions and packages to business logic of Oracle R12 OPM implementation.
• Shipping Monitor screens for truck loading status with refresh of 30 seconds for each of the warehouses, delay in loading after threshold time would be highlighted in red for supervisor attention
• Dock or Door assignment for incoming trucks based on assignment orders.
• Pool allocation of fruits. Halos Pooling form changes for additional fields for COOP accounting of fruits from Ranch.
• Oracle file feeds to DataWarehouse (FTP/SFTP). File deletion and archive based on month.

Environment: Oracle ERP Application R12, Warehouse Management System (WMS), Order Management (OM), Inventory (INV), Purchase Order (PO), SQL*Plus, PL/SQL, Toad, Forms 10g, Reports 10g, Apex 4.0.2, Unix(AIX) and Windows

Confidential, Vienna, VA

Software Engineer

Responsibilities:

• Interacting with functional team based on functional document.
• Development of XSD, PL/SQL stored procedures, functions and packages to business logic of VBMS Correspondence System (VBMS-C) and Benefits Gateway System (BGS) in Confidential applications.
• Development process according to agile methodology.
• Unit Testing and Integration Testing of PL/SQL code. Verification of XML output based on XSD.

Environment: Oracle 11g, XML, XSD, SQL, PL/SQL, SQL*Loader, SQL*Plus, XML notepad, PLSQL Developer, DIM, ClearQuest, Reflection and Windows

Confidential, Lanham, MD

Oracle Developer

Responsibilities:

• Interacting with functional team/user to capture business requirement, mapping and prepared Design document based on functional document.
• Development of PL/SQL stored procedures, functions and packages to accept, validate and apply business logic of PDPS System using
• Development of APEX UI Screens/pages and APEX Reports.
• Created Templates for Pages, Reports - for standalone and Master-Detail.
• Development of shell scripts to be called from CRON jobs.
• Identify performance issues in the PL/SQL code and using indexes & hints to tune the SQL statements.
• Unit testing and Integration testing of PL/SQL code.
• Production Support and Development; resolution of issues in Production.

Environment: APEX 3.2, Oracle 11g, SQL, PL/SQL, SQL*Plus, Toad, Ksh, Unix(AIX) and Windows

Confidential, Walnut Creek, CA

Software Developer/Analyst

Responsibilities:

• Interacting with functional team/user to capture business requirement, mapping and prepared Design document based on functional document.
• Involved in the design and development of AIM document.
• Designed and developed conversions for GL Balances, Vendor/Supplier, Customer, Items.
• Production Support and Development; resolution of issues in Production.
• Unit testing and Integration testing of the PL/SQL code and providing production support.
• Improving SQL*Loader performance by using direct path option while loading large amount of data
• Documented business rules, functional and technical designs, test cases (Unit Test Plan).
• Designed and developed conversions for Customer, Customer Extract and Mapping, Blood pricing form. Customer mapping form
• Interacting with functional team/user to capture business requirement, mapping and prepared Design document.
• Development of PL/SQL stored procedures, functions, packages and database triggers to read the data staged into the staging tables, apply business logic and move to the permanent tables using TCA API's
• Development of data loaders using PL/SQL, SQL*Loader utilities to load data from flat files into staging tables
• Development of data extraction scripts in PL/SQL.
• Identify performance issues in the PL/SQL code and using indexes & hints to tune the SQL statements.
• Improving SQL*Loader performance by using direct path option while loading large amount of data
• Writing technical and functional documentation
• Shell script changes to Payroll; made changes to GL Update and Fixed Assets Interface for Puerto Rico addition.
• Service Fulfillment MACD Workflow - Implemented IB Interface workflow and CZ Post Processing node
• Designed and developed BOM Replication/Creation and Customer Conversion
• Developed interface to update account mapping from legacy system for the GL import process.
• Documented technical designs, Unit testing and Integration testing of the PL/SQL code test cases (Unit Test Plan).
• Developed Shell scripts and SQL control files to load data through SQL*Loader
• Lead import should read rows from a delimited file
• Based on Lead Type parameter, choose appropriate record format
• Check to see if customer and contact exist, if not create them
• Check to see if lead exists if not create it
• Create lead notes, and system generated notes
• If lead exists, update existing lead
• Interacting with functional team/user to capture business requirement, mapping and prepared Design document based on functional document.
• Involved in the design and development of AIM document for GL Balances, AR Open Invoice and AP Open Invoice.
• Designed and developed conversions GL Balances Conversion, AP Open Invoices AR Open Invoices Conversion
• Unit testing and Integration testing of the PL/SQL code.

Environment: Oracle Applications 10.7, Oracle Applications 11.5.10, General Ledger (GL), Account Receivables (AR) and Account Payables (AP), Oracle 9i, SQL*Plus, PL/SQL, Toad, PVCS, Sun Solaris and Windows

Confidential

Senior Software Engineer

Responsibilities:

• Interacting with functional team/user to capture business requirement, mapping and prepared Design document based on functional document.
• Point Of Contact for IFPROD instance across C&I, CBSI (AP), DataWarehouse, MES, migration of interfaces or other items to IFPROD.
• Owner on the performance or oracle feed of Interfaces, resolution of interfaces related tickets within SLA.
• Design/Development/Modification of UNIX shell Interfaces.
• Involved in maintenance phase of IFPROD instance and maintaining Interface scheduling through crontab.
• Development of WEB Reports which are accessed by C&I plants for their day-to-day activities. These reports form an integral part for plants to look up for information. These reports come out in DOC and XLS formats hence providing the end user an option to compile data based on his/her criteria.
• File Archive of feeds from different legacy systems across C&I based on archive policy.
• Developed Shell scripts and SQL control files to load data through SQL*Loader

Environment: Oracle Applications11i, Order Management (OM), Inventory (INV), Purchase Order (PO), Oracle 9i, SQL*Plus, PL/SQL, Ksh, Reports, Toad, Telnet, PVCS, Sun Solaris, Windows.