SUMMARY

• Over Ten years of strong experience in design, development, architecting, analysis, testing, deployment and implementation of applications using ORACLE. Technologies include: Release 12i/11i/11.x/10.7, ORACLE Data base 10g/9i/8i, Developer/2000 (Reports 4.5/6i/9i/10g),Discoverer 4i/6i/10g, BI(XML Publisher 5.6.2), OAF, ADF, OBIEE, Analytics
• Proficient in Developing, Customizing and Implementation of Oracle Supply chain modules like Order Management, WMS, Inventory, BOM, WIP, Purchasing, Advanced Pricing, I - expense and Oracle Process Manufacturing (OPM)
• Experience in TCA architecture
• Lead Implementations of various modules and support the development team efficiently
• Excellent understanding of Business goals and solutions to support them as a techno-functional resource.
• Developed/Managed and implemented complete EDI solution - inbound and outbound for Oracle
• Expertise in Interfacing, Conversion, Data Modeling, Database Modeling, performance tuning and Data Migration from legacy systems to supply chain modules.
• Lead developer and analyst integrating supply chain third party solutions (Pick To Light, Pick To Voice) to Oracle WMS resulting in net savings of 800k annually to the client
• Expertise in System Administration including Oracle Applications activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs and Data conversion from legacy system to Oracle Database.
• Managed team of ten for supply chain (O2C and P2P) initiatives extending base functionality of Oracle EBS
• Data transformation using EDI, XDO, XSL, XSLT for 3PL operations
• Expertise in bug fixing, Production support and interacting with oracle support as a point of contact.
• Expertise in using tools such as TOAD, SQL*Loader, Discoverer 4i/6i/10g, Reports builder, XML publisher, BI publisher, Eclipse
• Expertise in making new and improvised recommendations for Architecture solutions
• Self motivated and committed person with excellent interpersonal communication skills and ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Excellent command over SQL, PL/SQL,OAF, Unix Shell scripting and working knowledge of java scripts,.net
• Commitment to excellence proven by an outstanding career track...

TECHNICAL SKILLS

ERP: 12.1.2, 12.0.6, 11.5.10, 11.5.9

Supply Chain Modules: OM, INV, BOM, WIP, WMS, PO, OPM, EDI, XML

Financial Modules: GL, AP, AR, FA, I-expense

Data Base: Oracle 7.3/8.i/9i/10g/11g

Language: SQL, PL/SQL, UNIX shell scripting C, C++, HTML, & Java, J2EE

GUI: Forms, Reports 2.5/4.5/6i/10g,Workflow Builder, XML PublisherOBIEE

Other Tools: Toad and SQL* Loader, FTP, Discoverer 4i/6i/10g, Business Intelligence, Inovis Biz Manager

Operating Systems: UNIX, Windows NT/XP/98/2000

PROFESSIONAL EXPERIENCE

Confidential - San Francisco

Lead Oracle Applications Developer

Responsibilities:

• Integrated custom WMS solutions for Pick to Voice Integration with third party systems.
• Developed key WMS Pick and Ship integration using API’s.
• Implemented custom EDI solution to support International trading partner requirements including: 850, 856,810, 816, 864, 832, 820, 860, 852
• Technical resource for BI integration leveraging OBIEE and MicroStrategy
• Configured WMS per Business functional requirements
• Performed the following duties to Implement Oracle R12
• Gather functional and technical requirements based on the business architecture and needs.
• Translate business functional requirements into technical requirements and design
• Developed various conversions from R11 to R12 including Vendor, Customers, Banks, Price list, Item on hand, po-intransit, item cross reference, wip, bom.
• Customized and retrofit various interfaces from R11 to R12 to meet the business requirements.
• Developed sales order interface to create sales orders using API’s to import from legacy systems.
• Developed OA Framework pages like Dash Board for Pick release, Item Inquiry, PO Print Management.
• Developed various OBIEE reports using oracle Business intelligence (10.1.3.4.1 )
• Developed Inventory, WMS,finance reports using BI
• Configured the Buy sell model for Purchasing and Internal Requisition process.
• Performed end to end testing per SDLC guidelines for all the business flows including OM, INV, Purchasing, WMS, AR,AP,GL,WIP,BOM
• Implemented and Integrated Pick to Voice System in the warehouse for picking using headsets and reduce operations cost.
• Worked and coordinated tasks on TCA architecture.
• Developed WMS interfaces to auto pick and ship confirm the orders using API’s coming from the Pick to Voice System.
• Integrated and developed framework to FTP, push and pull data from the Pick to Voice system into oracle and process transactions.
• Managed offshore development to meet the deliverables.
• Customized Mobile Apps MSCA screens like quick ship, receiving to meet the business requirements.
• Developed WIP and BOM interfaces.
• Implemented Buy sell and 3PL models for countries including Japan, Canada and UK.
• Created new OAF pages using java methods, java integration, VO’s, AM, AO, VL, controller classes.
• Made recommendations to Database modeling and restructure by keen evaluation
• Developed and Implemented fully integrated EDI solution (X12 documents include: 850, 852, 860, 864, 856, 810, 820, and 832)
• Configured the e-commerce gateway and XML gateway modules to generated compliant EDI documents for wholesale customers.
• Developed UCC-128 labels using Zebra Software and following the UCC standards.
• Worked through the SDLC life cycle and lead various team members to successfully develop and implement the requirements.
• Developed Shell scripts, cron jobs in UNIX to send and receive data using java methods.
• Interacted with the business users to gather functional requirements and proposed new features that are available in the modules.

Environment: Oracle applications 12.1.2,12.0.6, 11.5.10.2(OM, INV, WMS, BOM, WIP, I-expense, PO, AP GL, AR), UNIX, Oracle 10g, Forms 6i, Reports 6i, XML Publisher 5.6,People soft v9,discoverer 4i/10g,OBIEE,OAF, SQL* Developer and TOAD, Inovis, BizConnect- BizManager

Confidential - San Francisco

Senior Oracle Applications Developer

Responsibilities:

• Implemented Auto lock box functionality and co-ordinated between the IT resources for testing with the designated bank.
• Developed interfaces to interface between third-party systems like Sales Force data for processing billing and commission details.
• Developed Interfaces and extensions in AR, AP and GL modules.
• Developed AR cash receipts Interface using cash receipt API to create receipts for the payments received from customer transactions.
• Created and extended oracle and discoverer reports to meet the business requirements
• Developed AR statements reports using XML report publisher
• Trained discoverer admin and desktop viewer to business users for developing reports
• Developed AP invoice extracts for I-expense to ftp to payroll vendors
• Used various Java methods for integrating legacy data into oracle financials.
• Implemented I-expense module to enable expense reports to users and
• Worked with Web services team to integrate data into oracle applications,
• Customized/managed several workflows to meet the Business Requirements in Finance modules.

Environment: Oracle applications 11.5.10.2(I-expense, PO, AP GL, AR), UNIX, Oracle 10g, Forms 6i, Reports 6i, XML Publisher 5.6, Discoverer 4i, SQL* Developer and TOAD

Confidential - San Francisco, USA

Oracle Apps Developer

Responsibilities:

• Successfully implemented R12 Supply chain modules as a senior technical developer in UK organization
• Developed interfaces, conversions, reports(XML, Reports, Discoverer)
• Developed a complete EDI solution including customizations
• Developed interfaces including setups for setting up 3PL organizations(Warehouse, OM, etc)
• Developed and integrated complete Pick to light (PTL) system in the warehouse using third party vendor-Dematic including customizations involving WMS API’s and custom solutions.
• Developed a framework to push and pull data (ETL) from the third party system for Pick to light (PTL) implementation (WMS).
• Customized the Packing Workbench form(Oracle WMS) according to the business needs for the warehouse (splitting case packs, enable packing multiple lines into single LPN, etc)
• Managed and developed WIP and BOM interfaces using API’s, UNIX shell scripting, API’s, UTL Files etc.
• Trained discoverer admin and desktop viewer to business users for developing reports
• Customized Mobile apps screens to meet the warehouse requirements like increasing the size of the fields in screens, skipping fields etc.
• Implemented I-expense module to enable expense reports to users and trouble shooting approval issues via email
• Key architect for I-Expense integrating with Payroll Company for payment process via Pay Check.
• Recommendations to Mainframe environments to Oracle Environment
• Customized/managed several workflows to meet the Business Requirements in Supply Chain and Finance modules.
• Major role as a lead in implementing EDI module in oracle
• Gathered functional requirements from the business group to support various EDI documents & configuration of EDI gateway in oracle
• Setup process rules, Seed Data reconciliation, EDI mapping in oracle
• Customized the Packing Workbench form(Oracle WMS) according to the business needs for the warehouse (splitting case packs, enable packing multiple lines into single LPN, etc)
• Managed the development team for Business Intelligence(BI) and other data warehouse reporting
• Developed complete in house EDI solution for trading EDI documents across trading partners using Oracle e-business suite
• Developed a new complete custom EDI ASN 856 program in compliance with the trading partner specification (SOPI)
• Implemented 3PL org for Japan warehouse to auto receive internal sales orders and wms applications
• Implemented fully integrated EDI solution replacing third-party service provider (X12 documents include: 850, 852, 860, 864, 856, 810, 820, 846 and 832)
• Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF to tune SQL queries
• Performed Key role in implementing Oracle WMS module and other supply chain modules in the organization following complete SDLC methodologies
• Created technical requirement documents for technical developers
• Developed Custom Interfaces, conversions, data base triggers, forms, reports for implementing OM,INV,Purchasing,BOM,WMS modules
• Worked with large volumes of data including performance tuning of the data base.
• Worked on UPS interface in sending and receiving shipping data from UPS. This includes mapping into World ship and custom interface development for deriving and updating delivery information
• Customized forms using forms personalization on sales order form.

Environment: Oracle applications 12.0.6, 11.5.10.2(OM, INV, WMS, BOM, WIP, I-expense, PO, AP GL, AR), UNIX, Oracle 10g, Forms 6i, Reports 6i, XML Publisher 5.6, OAF, People soft v9,discoverer 4i, SQL* Developer and TOAD, Inovis, BizConnect- BizManager

Confidential, Pennsylvania

Oracle Technical Lead

Responsibilities:

• Worked on customization of Order Import Interface in Oracle Order Management.
• Worked on Form Personalization in Order Management.
• Worked in development of new reports in Order Management and Process Manufacturing modules like 1. Sales Log Report & 2. Finished Goods Stock Status Report
• Worked on tuning various reports and bug fixing in various environments.
• Validation of custom data before writing into Oracle Tables for financial modules.
• Writing conversion scripts invoking APIs to convert and write legacy data into Oracle tables.
• Lead technical developer in creating order interface, pricing interface, and vendor interface and discoverer admin.
• Expertise in writing Functional and Technical Requirement documents using AIM and other methodologies.
• Gathered Database statistics and made recommendations to improve the performance of large data bases with huge volume of data.
• Developed and made recommendations to the infrastructure.
• Developed RICE components for Supply chain modules like OM, WMS, INV, PO etc.
• Provided the users with detailed vendor reports on existing vendors from legacy system.
• Evaluated various existing methodologies for optimum behavior of the systems.
• Experience in 3PL integration with external warehouses and applications.
• Developed various interfaces using ETL with PL/SQL
• Interacted affectively with the Client and the Functional team.
• Developed the SQl loader scripts and successfully loaded the data from the interface tables and error tables (legacy system) into the base tables (oracle environment).

Environment: Oracle applications 11.5.9(OM, OPM, GL, AR, AP, INV), PeopleSoft v8, UNIX, Oracle 9i, Forms 6i, Reports 6i, SQL*Loader, XML Publisher, Discoverer 4i and TOAD.

Confidential, Palo Alto, California

Senior Technical consultant

Responsibilities:

• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the interface tables from the Legacy system.
• Experience in developing Order Import interface for Order Management and Process Manufacturing Modules.
• Experience in working with interface tables in Account Receivables (AR)
• Worked in GL INTERFACE tables for Journal Import in General Ledger (GL) module.
• Created FSG Reports as per Business User's Requirements.
• Created and Customized standard reports in AR like
• Account Status Report, Actual Receipt Report and Print Invoice Report.
• The development includes the interface and conversion of the data from legacy systems to the oracle database and creates the custom reports for the client.
• Developed many new reports like Customer Order status Report, Backlog Detail Report, Backlog Summary Report, Backlog by Item (Line Level) Report, Cycle Status Report.

Environment: Oracle applications 11.5.9(AR, GL), UNIX, Oracle 9i, XML Publisher, Forms 6i, Reports 6i, SQL*Loader, Discoverer 4i and TOAD.

Confidential, Irving, TX

Technical consultant

Responsibilities:

• Defined executables, concurrent programs, Request Set of Concurrent Programs, Creating Staging Table, and Journal Import procedure etc. in Account Receivables (AR) General Ledger (GL), Fixed Assets (FA) modules.
• Designed and developed various packages and procedures which can be used in various programs.
• Developed control files for SQL*Loader and PL/SQL scripts for loading and validating data into interface tables from legacy system.
• Worked on General Ledger Interface Tables like GL INTERFACE table to Import Data into GL Tables
• Performed System Administration work to register customer developed reports & schedule concurrent jobs

Environment: Oracle Applications 11.5.8(GL, AR, FA), Oracle 9i, Forms 6i, Reports 4.5, XML Publisher, Windows XP, UNIX, SQL*Loader, Discoverer 4i.

Confidential, Grapevine, TX

Technical consultant

Responsibilities:

• Worked on Account Payables interface inbound process applications.
• FTP invoices from vendors site then importing data from Legacy system using SQL*Loader from .CSV files.
• Created new reports and Customized the standard reports in AP
• Running the open Interface to import the data from the external system into Oracle

Environment: Oracle Applications 11.5.8(AP.GL), Oracle 9i - Oracle Forms/Reports 4.5, SQL*Loader, Discoverer 4i.

Confidential, Parsippany-NJ

Oracle Financial Technical consultant

Responsibilities:

• Worked on programming and implementing Oracle App release 11i modules like General Ledger, Purchasing, Payables, and Receivables.
• Experience with creating and customizing Reports using Reports 4.5.
• Worked on Purchase Order interface and receivables interface by loading data into staging tables from the legacy system. Validated data using PL/SQL by loading into interface tables and running import programs to load them into main tables.

Environment: Oracle Applications 11.0(PO, AP, AR), Oracle 8i, Forms 4.5, Reports 2.5, UNIXWindows NT, TOAD, SQL*Loader