SUMMARY

• Above 10 years of IT experience in providing cost TEMPeffective solutions by using Oracle Applications and related technologies.
• Involved in full life cycle implementations using Oracle Applications.
• Expertise in various Oracle Applications modules (OM, AR, ASCP, INV, PO, FA, PA, HR, BOM, WIP and AOL).
• Strong in Oracle Forms, PL/SQL, Oracle Workflows, Oracle Reports and Unix Shell scripting.
• Self - motivated individual having exceptional work ethics, superior planning and good organizational skills.
• Strong Team leadership skills wif an ability to turn ideas into detailed executable strategic and operational plans.
• Self-starter wif potential, initiative and a positive attitude. Able to meet very stringent deadlines and always deliver the package.
• Keen and enthusiastic wif constant desire to learn and a commitment to excel.

TECHNICAL SKILLS

Oracle ERP: Oracle Applications 12.1.3/11. .5.9/11.5.8 (OM, AR, ASCP, INV, PO, FA, PA, HR, BOM, WIP and AOL), Workflow & Demantra

Operating Systems: MS-DOS, HP-UX, Microsoft Widows 7/XP/98/95, Solaris

Languages: SQL, PL/SQL, C, C++, Unix Shell Scripts, XML, Java, Matlab, HTML

Oracle Tools: Forms 6i/9i, Reports 6i/9i, Toad, SQL Navigator, Oracle Workflow Builder 2.6, SQL* Loader

RDMS: Oracle 8i/9i/10g

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Techno Functional Consultant

Responsibilities:

• Involved in 3 Full Life Cycle implementations using Oracle Applications 12.1.3 on the Network side for Confidential &T.
• Work involved customizations and enhancements in Order Management (OM), Purchasing (PO), Inventory (INV), Fixed Assets (FA).
• Worked as a Techno Functional Consultant that involved functional design, design reviews, functional and Systems integration testing.
• Worked as a Functional lead and managed a BSA team on the offshore.
• Performed Requirement gathering from the Business Users.
• Performed Functional Setups in Order Management, Purchasing, Inventory.
• Created forms using iRise tool to halp users understand the functionality.
• Created new forms personalization in Order Management, Purchasing.
• Created new Custom programs in Order Management (OM), Purchasing (PO), Accounts Receivables (AR), Inventory (INV) & Fixed Assets (FA) based on the business requirement.
• Created functional design for new Custom forms in Order Management to assist Market Planners and Supply Planners.
• Created functional designs for business object reports for showing supply and demand information.
• Created new custom workflows in Order Management.
• Involved in writing MD50 (Functional Design) & High level design documents for various projects.
• Coordinated between Business Users and Project Manager.
• Coordinated wif the offshore teams and also interacted wif the 3rd party shipping Companies in solving integration issues.
• Involved in continued Production Support after every successful completion of projects.
• Involved in solving complex problems in Production and also assisted in the solution design of the projects.
• Worked wif various development teams to solve various development issues.

Environment: Oracle Applications Release 12.1.3/11.5.10, Oracle 10g/9i, iRise Studio 9.1, IBM Quality Center, SQL*Loader, Forms 10g/6i, Reports 10g, Oracle workflow builder 2.6.1, Toad, HP-UX

Confidential, Houston, TX

Functional Consultant

Responsibilities:

• Involved in implementation of ASCP in one of the Manufacturing facilities belonging to the client to plan and forecast efficiently.
• Work involved Requirement gathering and functional design in Advanced Supply Chain Planning (ASCP), Work in Process (WIP), Bill of Materials (BOM).
• Performed Requirement gathering from the Business Users in the Manufacturing facility.
• Work involved functional design of new interfaces and conversions to create and update Routings, Move Operations, Bill of Materials.
• Performed Functional Setups as part of new implementation.
• Worked on setting up new ASCP plan in which planning was based on department level.
• Worked wif the business Users in the facility to design new custom reports in ASCP & Bill of Materials.
• Worked closely wif Business Users in the manufacturing facility.
• Involved in Production Support of existing projects in the facility and also worked on the functional designs of Enhancements requested by the business users
• Worked wif offshore development teams and in halping them resolve complex issues.

Environment: Oracle Applications Release 11.5.10, Oracle 9i, SQL Navigator, HP-UX

Confidential, Alpharetta, GA

Technical consultant

Responsibilities:

• Involved in implementation of various projects on the Network side for Confidential &T.
• Work involved customizations and enhancements in Advanced Supply Chain Planning (ASCP), Order Management, Project Accounting, Inventory, Purchasing, Fixed Assets, Oracle Demand Planning (ODP) & Demantra.
• Worked as Functional Consultant as well as Technical Consultant that involved functional design, technical design, Development & Testing.
• Performed Requirement gathering from the Business Users.
• Performed Functional Setups in Order Management, Project Accounting, Inventory & ASCP.
• Worked on setting up Sourcing rules in ASCP.
• Created new forms personalization in Order Management, ASCP.
• Created new Custom programs in Accounts Receivables (AR), Advanced Supply Chain Planning (ASCP), Order Management, Inventory, Purchasing, Fixed Assets & Demantra modules based on the business requirement.
• Created functional design for new Custom forms in Order Management to assist Market Planners. .
• Created Projects, Tasks in Project Accounting and linked them to the Purchase Requisitions when released from the ASCP.
• Created functional designs for business object reports for showing supply and demand information.
• Created new workflows in Order Management using standard APIs and workflow builder.
• Involved in writing MD50 (Functional Design) for various projects.
• Involved in writing MD70 (Technical Design) for all the enhancements and new customizations.
• Coordinated between Business analysts, Users and Project Manager.
• Coordinated wif the offshore teams and also interacted wif the 3rd party shipping Companies in solving integration issues.
• Involved in continued Production Support after every successful completion of projects.
• Involved in solving complex problems in Production and also assisted in the solution design of the projects.
• Worked wif various development teams to solve various development issues.
• Used Kintana, clear quest for migration of Forms, packages, Concurrent Programs, Request Sets, Valuesets, Request groups & shell scripts.

Environment: Oracle Applications Release 11.5.10, Oracle 9i, SQL*Loader, Forms 10g/6i, Reports 10g, Oracle workflow builder 2.6.1, Toad, HP-UX

Confidential, Atlanta, GA

Technical Consultant

Responsibilities:

• Involved in implementation of the Equipment Planning and Logistics (EPL) Phase 2.
• Customized the Sales Order Form to resemble the old Order management system.
• Developed new workflows in order management, Account Receivables using standard APIs and workflow builder.
• Worked on automating Item attribute synchronization in inventory.
• Performed Functional Setups under Project Accounting, inventory and Order Management related to Items, Price Lists, Document Sets, Grouping Rules, and Sales Orders.
• Created Custom profile options according to the business requirement.
• Developed outbound/inbound interface to export order information between the third party shipping system and oracle applications.
• Coordinated between business analysts, users and project manager.
• Involved in writing technical documents MD70.
• Involved in Production Support after go live.
• Used Kintana for migration of Forms, packages, DB triggers.

Environment: Oracle Applications Release 11.5.8, Oracle 9i, SQL*Loader, Forms 6i, Oracle workflow builder 2.6.1, Toad, HP-UX

Confidential, Washington, DC

Technical Consultant

Responsibilities:

• Involved in the Conversion of the Corporate Logistics System (CLS) User Community to the Consolidated Financial System (CFS).
• Designed and developed carton Label for shipping purpose using Zebra Designer and XML enabled Zebra printers.
• Involved in Functional Setups under Inventory and Order Management related to Items, Price Lists, Document Sets, Grouping Rules, and Sales Orders.
• Developed Worksheet Upload Program to load information from a spreadsheet, validate and upload to AR interface tables.
• Worked on Inbound interfaces for TCA.
• Involved in design and Development of Pick Slip and Pack Slip reports using Reports 6i.
• Developed outbound/inbound interface to export and import delivery information between third party shipping system and oracle applications.
• Used forms personalization for adding quantity restrictions to customer functionality in the sales order form.
• Coordinated between business analysts, users and project manager.
• Involved in writing technical documents MD70.
• Used Clear Case to maintain versions of reports, packages and xml templates.

Environment: Oracle Applications Release 11.5.10, Oracle 10g, XML, SQL*Loader, Forms 6i, Reports 6i, SQL Navigator, Sun Solaris

Confidential, Eden Prairie, MN

Technical Consultant

Responsibilities:

• Involved in design, Analysis, Development, Testing and deployment of reports, Interfaces and Extensions in and around Oracle Applications 11i GL, AR, AP, FA, WIP, INV, BOM and PO modules.
• Involved in writing a PL/SQL package to perform the validations on the imported data and then load the data to the Interface tables.
• Developed Open Interfaces for Receivable, invoices and Customer import from external system to Receivables using PL/SQL procedures, functions, packages, SQL*Loader and UNIX shell scripts.
• Extensively utilized the Application Object Library to register SQL*Loader programs, Shell Scripts, PL/SQL procedures and reports. In addition, also used the System Administrator responsibility to create users, responsibilities, Value Sets and Request Sets
• Involved in customization of forms using custom library (custom.pll)
• Developed a custom form for Confidential in house banking and added a button to interface wif AR. Called receipt API to create and apply the receipts in AR.
• Involved in automation of applying Credit memos to their related invoices using the AR Receipt API.
• Involved in automation of XDRC printing triggers in the WIP module to print the barcode labels for the WIP material transactions entered by the user and also to insert into inventory interface table for component return.
• Involved in setting up descriptive flex fields in Assets and created a database trigger to pass the DFF values from AP to FA in order to track the budgeted capital expenses.
• Involved in Customization of PO form using custom.pll.
• Worked on following Custom Reports such as Confidential Packing List, Confidential MX Sales Order in Order Management module.
• Created MD 70 for the customizations.
• Coordinated between business analysts, users and project manager.
• Used PVCS version control manager to maintain versions of custom forms, custom.pll, db triggers and reports.

Environment: Oracle Applications Release 11.5.10, Oracle 10g, SQL*Loader, Forms 6i, Reports 6i, SQL Navigator, HP-UX

Confidential, Cincinnati, OH

Oracle Reports Developer/DBA

Responsibilities:

• Worked on enhancement of Siebel based Customer Spending Breakthrough (CSB) System.
• Involved in the design, Analysis, Development & testing of Oracle reports.
• Involved in design, Analysis, Development, Testing and deployment of reports,
• Created custom table and SQL*Loader control file to load the data into Oracle.
• Designed and developed numerous packages and procedures to load data into temporary tables.
• Designed and developed Materialized views to solve performance issues.
• Created temporary tables and developed SQL*Loader control files to load data from external systems such as NCS and NASA into temporary tables.
• Coordinated between business users, architect and project manager.
• Developed new custom reports using Report 6i.
• Setup, testing and training for Custom Reports.
• Optimized the Reports by running Explain plan on the Report queries wif the auto trace on Created tables wif complex constraints applicable to the business rules.
• Created Design Document for the customizations.
• Used Mercury Test Director 8.0 to track the defects in the reports, packages.
• Version control of all the reports, procedures, functions, table scripts, packages using CCC Harvest Version Manager 4.1.2.

Environment: Oracle 9i, Siebel, Oracle Reports 6i, SQL*Loader, Toad 7.4.0.1, HP-UX

Confidential, Kalamazoo, MI

Graduate Research Assistant

Responsibilities:

• Worked as Graduate Research Assistant for Electrical and Computer Engineering Department.
• Involved in Design, research and development of a packages to identify bridge cracks on the concrete bridges using Matlab software.
• Worked on creation a database involving digital Images.
• Involved in research of cancerous cell detection in mammograms.
• Wrote Master's thesis on "Feature Detection using Linear Structure modeling and PCA"