SUMMARY:

• More than 12 years of IT experience including Oracle Application Consulting Experience.
• Development experience in requirement analysis, design, development and implementation of Oracle financials (AP, AR, GL) and supply chain & Manufacturing (PO, INV, Costing, OE/OM, WIP and BOM).
• Expertise in Design, Customization and Implementation of Oracle Applications Order Management, Inventory, Purchasing, Shipping, Receivables, Payables, Bill of Materials (BOM).
• Experienced in Performance Tuning of PL/SQL, SQL Queries.
• Experienced in data conversion, interface development, new & customized forms and reports development, oracle workflow builder, oracle alerts and upgrades.
• Expert in implementing, administering and supporting Oracle Discoverer 4i/9i.
• Experienced in developing database applications using Oracle 8i as back - end and Java based technologies for front-end web access.

SKILLS SUMMARY:

• Oracle 11i Applications - Implementation & Development
• Supply Chain - Purchasing, Inventory Order Management,
• Pricing, Shipping
• Manufacturing - Costing, BOM, WIP
• Financials - Receivables, General Ledger, Payables
• Others - Oracle work flow builder, Oracle Alerts

TECHNICAL SKILLS:

Oracle Development Tools: Oracle 9iDS (Forms 9i, Reports 9i, Discoverer 9i), OBIEE, Forms 4.5, 6i, Reports 2.5, 6i, Developer 2000, SQL* Plus, SQL Loader, AOL, Oracle Database 7.x and 8i,11g

Programming Languages: SQL, PL/SQL, Visual Studio 6.0, ASP, C, C++, Unix Shell Scripts, Basic, Pascal, Fortran, Cobol

Operating Systems: Unix (Sun Solaris, HP AIX), Linux (Red Hat), Windows XP/NT/2000/98/95/7 Enterprise

Tools: SQL*Explorer, MS - Office Tools, Win unner, Load Runner, Test Director, Informatica 9.1.0, MapReduce, Hive, Cassandra, Tableau

Others: HTML, DHTML, XML, ASP, SQL Navigator, MS-.NET, Delphi 5.0 Professional

Life Cycle Experience: Data Modeling, ER Modeling, Database Design, Legacy Systems Integration, workflow modeling, Data Warehousing, Big Data and Hadoop

PROFESSIONAL EXPERIENCE:

Confidential, Downers Grove, IL

Architect

Responsibilities:

• Modules Implemented: Oracle 11i - Order Management, AP, AR, Pricing, Shipping, Inventory
• Involved in the conversions in Order Management, PO, Inventory and AR.
• Performed Conversions /Interfaces programs using PL/SQL.
• Was responsible for data migration from various legacy systems to Oracle Applications
• Designed and developed new and customized reports.
• Registered the new reports to appropriate oracle modules and responsibility level.
• For new reports, registered concurrent program executables and concurrent programs in Oracle Applications using AOL. For concurrent programs defined the parameters and attached it to the respective value set.
• Developed various custom variance reports using Reports 6i and PL/SQL.
• Developed various BI Custom Reports.
• Developed Open Purchase Orders.
• Involved in Production Support Day in the Life by addressing fixes and failures.
• Involved in Data validations and Analysis as requested through the Ticketing Systems.
• Involved in preparing resolution documents and Incident Management process.
• Involved in implementation process for continuously onboarding new restaurants.
• Maintained Code Version and Code Base.
• Performed Migration/Deployment of new or enhanced objects/elements.

Environment: Oracle Applications 11i (AP, AR, GL, OM, PO, INV), Oracle 11g database, Windows 7 Enterprise, Linux, Quest Software Toad 9.7.2.5, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, Informatica 9.1.0, Java, .Net, WinSCP, Serena PVCS, CAWA (Computer Associates Workload Automation)/Cybernation, SNOW Henry Ticketing System, OBIEE, JDA (Manugistics)

Confidential, St. Louis, MO

Technical Lead Consultant

Responsibilities:

• Modules Implemented: Oracle 11i - Order Management, AP, AR, Pricing, Shipping, Inventory
• Involved in the conversions in Order Management, PO, Inventory and AR.
• Performed Conversions /Interfaces programs using PL/SQL.
• Prepared technical mapping documents (MD’s).
• Was responsible for data migration from various legacy systems to Oracle Applications
• Designed and developed new and customized reports.
• Registered the new reports to appropriate oracle modules and responsibility level.
• For new reports, registered concurrent program executables and concurrent programs in Oracle Applications using AOL. For concurrent programs defined the parameters and attached it to the respective value set.
• Developed various custom variance reports using Reports 6i and PL/SQL.
• Developed various BI Custom Reports.
• Developed Open Purchase Orders with Discoverer 10g.
• Developed various Anchor Reports.
• Developed Customer Price List Report.
• Developed Inventory On-hand Detail report.
• Developed Orders to be Shipped Report in Order Management.
• Developed Shipped on time Report.
• Developed AR Invoice Report with Discoverer 10g.
• Developed Accounts Receivables Customer Interface.

Environment: Oracle Applications 11i (AP, AR, GL, OM, PO, INV), Oracle 10g database, Windows 2000, Sun Solaris 8, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, Discoverer 10g

Confidential, Bristol, PA

Technical Consultant

Responsibilities:

• Modules Implemented: Oracle 11i - Order Management, AP, AR, Pricing, Shipping, Inventory
• Involved in the conversions in PO, Inventory and AR.
• Imported data from legacy system to Oracle 11i using SQL*Loader.
• Performed Conversions programs using PL/SQL
• Designing and developing of Vendor Conversion
• Created complex packages using PL/SQL.
• Developing Customer Conversion
• Performed data cleansing using pl/sql functions like trim, lpad, nvl for the data received from the legacy.
• Created Stored Procedures to dump the validated data to the output table from where the Oracle 11i interface programs can import them to the system.
• Performed validations for different base tables of Inventory for Material Details, AP for Vendor Details, AR for Customer Details, etc.
• Developed exception details for the records which didn’t fit the validation criteria and conveyed back to the business for appropriate action.
• Loaded the data to the input tables with the help of sql loader and performed the column mappings as suggested by the business and the Oracle 11i Application system.

Environment: Oracle Applications 11i (AP, AR, GL, OM, PO, INV), Oracle 8i database, Windows 2000, PL/SQL, SQL*Plus

Confidential, Spokane Valley, WA

Technical Consultant

Responsibilities:

• Modules Implemented: Oracle 11i - Order Management, AP, AR, Pricing, Shipping, Inventory
• Involved in the modifications/creating reports, Forms and conversions in Receivables, Order Management and Inventory. Developed Custom reports & forms in reports 6i and forms 6i.
• Imported data from legacy system to oracle applications using SQL*Loader.
• For new reports, registered concurrent program executables and concurrent programs in Oracle Applications using AOL. For concurrent programs defined the parameters and attached it to the respective value set.
• Performed Conversions /Interfaces programs using PL/SQL
• Designing and developing of Vendor Conversion
• Designing and developing of new forms in 6i and created menu's and sub menu's using AOL.
• Created complex packages using PL/SQL.
• Developing Accounts Receivables Customer Interface
• Designing and developing various reports in reports 6i and Discoverer
• Developed the Open Sales Order Report
• Developed the Open Sales Order Report with holds.
• Developed New Booking Report depicting the variance from the sales history in the line level
• Customized AR Invoice with Project Details in the line level
• Used Discoverer 4i to access information from organization database for analysis and Reporting to extend the functionality and capability of the End User

Environment: Oracle Applications 11i (AP, AR, GL, OM, PO, INV), Oracle 8i database, Windows 2000, Sun Solaris 8, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, Discoverer 4i

Confidential, Bloomington, IN

Technical Consultant

Responsibilities:

• Modules Implemented: Oracle 11i - Order Management, AP, AR, Pricing, Shipping, Inventory, Costing, Bill of Materials, and Work In Process.
• Involved in the modifications/creating reports, Forms and conversions in Accounts payable, receivable, General Ledger, order management and inventory. Developed Custom reports & forms in reports 6i and forms 6i.
• Imported data from legacy system to oracle applications using SQL*Loader.
• Done Conversion/Interface programs using PL/SQL.
• For new reports, registered concurrent program executables and concurrent programs in Oracle Applications using AOL. For concurrent programs defined the parameters and attached it to the respective value set.
• Performed Conversions /Interfaces programs using PL/SQL
• Designing and developing of Supplier Conversion
• Designing and developing of new forms in 6i and created menu's and sub menu's using AOL.
• Created complex packages using PL/SQL.
• While implementing Oracle Applications 11i Order Management had a chance to work on Oracle Trading Community Architecture mapped all the Data Warehousing Order Entry queries to the corresponding queries using HZ tables
• Developing Accounts Receivables Customer Interface
• Designing and developing various reports in reports 6i and Discoverer
• Customized Sales Order Forms
• Developing Accounts Payables Vendor Loading from legacy system into Oracle, as there is no API for the vendor load so directly loading in subsequent Oracle tables through a PL/SQL procedure
• Used Discoverer 4i to access information from organization database for analysis and Reporting to extend the functionality and capability of the End User

Environment: Oracle Applications 11i (AP, AR, GL, OM, PO, INV, BOM and WIP), Oracle 8i database, Windows 2000, Sun Solaris 8, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, Discoverer 4i

Confidential, San Jose, CA

Technical Consultant

Responsibilities:

• Implementation of Data Conversion from legacy systems to Oracle Application Modules for Customer and Contact Information.
• Implementation of Data Conversion from legacy systems to Oracle Application for Item Master, Item Category Assignment, Item Cost, Approved Supplier List, etc.
• Customized workflow for order lines in Order Management to in corporate ATP check in standard line flow and in Purchase Order Lines for min purchase quantity and budget availability.
• Developed Vendor Interface to bring supplier data in Purchasing module from legacy system
• Developed, tested and implemented the necessary PL/SQL code and SQL*Loader control scripts for Customer Interface, Auto Invoice interface, Invoice Import Interface
• Customized various reports as per customer requirements such as Open Sales order report, Min-max report with historical usage and range of suppliers, item-vendor report, PO/items expediting report, Open sales orders reports etc.
• Customized standard PO reports like Printed Purchase order report, Change Order, Cancellation Notice for look and feel.
• Designed and Developed necessary feeder system i.e. staging tables, validation routines using SQL* Loader, SQL and PL/SQL procedures

Environment: Oracle Applications 11i OM, INV, BOM, WIP, PO, Oracle 8i, Reports 6i, Forms 6i, PL/SQL, Stored Procedures, Data base triggers, SQL* Loader, SQL*Plus, Windows 2000, UNIX, AOL

Confidential

Software Programmer

Responsibilities:

• Quality Assurance and Testing
• Project Designing
• Implementation, Maintenance and User Training

Environment: Visual Basic 6.0, MS-.NET, SQL Server, MS-Windows-9x/NT, IBM Compatible PC

Confidential

Software Programmer

Responsibilities:

• Quality Assurance and Testing
• Project Designing and part of the coding team
• Implementation, Maintenance and User Training

Environment: Visual Basic 6.0, MS-.NET, SQL Server, MS-Windows-9x/NT, IBM Compatible PC

Confidential

Software Programmer

Responsibilities:

• Quality Assurance and Testing
• Project Designing and part of the coding team
• Implementation, Maintenance and User Training

Environment: Visual Basic 6.0, SQL Server, MS-Windows-9x/NT, IBM Compatible PC