SUMMARY

• Highly motivated and enthusiastic Oracle Applications Consultant/Developer with proven expertise in both Technical and Functional capacities.
• Outstanding technical skills in implementing Oracle Financials (several modules).
• Experienced in writing functions, procedures, packages and database triggers, Unix Shell Scripting.
• Experienced in Data Conversion Strategies Experienced in tuning SQL statements using proper Hints.
• Ability to work autonomously as well as a team player.
• Easily adaptable to change with an eagerness towards learning and expanding capabilities.

TECHNICAL SKILLS

ERP/CRM: Oracle Applications 10.7SC/11.0/11i/12i AOL, GL, AR, AP, INV, ONT(Order Management), Shipping, PO. SYSADMIN,EDI Gateway(Oracle EC - Gateway), BOM, WIP, MFG, WORK FLOW, Oracle Data warehousing, Service Contracts, salesforce.com, Working knowledge in BPEL(Business Process Execution Language).Retek(10.6)

OS: MSDOS, UNIX (HP,SOLARIS,IBM AX), LINUX, WINDOWS9x, NT,WINDOWS 2000,Windows XP, Windows Vista, Windows 7

4GL/Case Tools: C, SQL, PL/SQL, COBOL, PERL, SED, AWK, B-SHELL, K-SHELL CL/400, Cobol/400, RPG/400, FORTRAN, BASIC. DEVELOPER 2000(FORMS4.5/5.0/6.0(6i)/9i, REPORTS 2.5/3.0/6.0(6i)/9i),VISUAL BASIC, HTML, CICS, Synon 2e. SQL * Loader, SQL Trace, TKPROF utility, JCL, MVS, SQL Navigator, TOAD, Procedure Builder.PL/SQL Developer. GNOME, KDE, CDE. Pro*C, Designer/2000/6i/9i, Discover3i/4i/9i,A/S400,Synon4(e), Oracle Warehouse Builder, XML, JAVA2, Oracle JDeveloper,(Developing RIA Web applications with ADF), Working knowledge of BPEL(Business Process Execution Language), Cloud Computing, Informatica (ETL)10.X, Oracle BI Enterprise Edition(OBIEE)

DBA Skills: Installation of 9i, 10g, 11g Databases. Creating RAC instances. Administering the DBA tasks using Oracle OEM. Configuring Net using Oracle Net configuration assistant (configuring listeners, Naming methods configuration, Local net service naming configuration, Directory usage configuration). Creating databases, modifying the existing database parameters etc. Creating different kinds of tablespaces, users etc. Exporting, importing data files. Monitoring Users activities. Configuring web based isql* plus etc. Creating Backup schedules, exporting and importing Database Tables info. Web logic Server Configuration.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle EBS EDI Lead/EDI Architect

Responsibilities:

• Designed Inbound, outbound directory structures and associated archive, error directories. Where sterling to drop the files and from where sterling to pick up the file. Bank files (Payment Order files) to capture in separate directory structure for security reasons.
• Designed and developed automation process for inbound files. Inbound files are coming by country wise. Automation process is designed to handle all files of particular transaction by country are grouped and make a bulk file and file has to be pushed to native process to process.
• Designed and developed the EDI files audit process. In order to keep the data processing in sync we need auditing the files process (file received vs files sent by Sterling and File generated by EBS vs files received by Sterling.) etc. Inbound files are batched by country.
• Designed and developed EDI850 Purchase orders inbound process for stagnated documents.
• Designed and developed the item derivation Process based on lens parameters.
• Designed outbound director process for handling all edi outbound transactions that are created files in outbound directory.
• Incorporated the functionality of auditing the outbound files.
• Designed and developed the EDI850 POI Wrapper program to process the EDI850 file with legacy address ref and without EDI Location Code.
• Designed and developed ASN wrapper Program.
• Designed and developed INO wrapper program and extension process.
• Designed and developed POAO/POACO wrapper Programs.
• Designed Audit files report, Stage Documents Report, Item validations and deletion of interface data report.
• Designed multi-threaded triggering process for all inbound files.
• Designed multi-threaded triggering process for all outbound transactions.
• Assisted 3PL transactions (940/945) etc.
• Designed ASN, INO re-con reports.
• Designed Inbound ASNI wrapper program.
• Provided Use cases and user training in Oracle EDI.
• Resolved several issues with Oracle through Oracle SRs.
• Managed and trained several countries EDI personal for the client.

Environment: Oracle Applications 12i (12.2.3)/ (Oracle Payments, Oracle Field Service, Oracle Depot repair, Oracle e-Commerce Gateway, Oracle Release Management, Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management (EAM), Advanced Collections, Oracle Quality. Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory, Receivables, Purchasing, Payables, Service Contracts, Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i, 9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE. Gentran 4x, XML Publisher (BI Publisher). Biz Talk B2B translator.

Confidential

Sr. Techno-Functional Consultant/EDI Tech Manager

Responsibilities:

• Integration of Oracle Payments System with Third Party Payments System (Tsys) for Credit Card Authorization Funds Capture and Funds Disbursement.
• Configuration of Oracle Payments System.
• Developing the interface INT-CSP001-I for Inbound Scrap Adjustments to Oracle Field Services.
• Developing INT-CSP002-O outbound Interface for sending Scrap Pos and Requisitions to UPS.
• Developing INT-CSP015-I for Vendor Scrap Adjustments for REPAIR and SORT vendors importing for repair and scrap items into Inventory Miscellaneous Transactions
• Developing the second part of the above interface for REPAIR sourced items to create internal requisitions into Oracle Field Service.
• Coordinating with Other functional teams for information gathering for developing the interfaces.
• Coordinating to peers for their development for interfaces.
• Coordinating Oracle Corp for SR creation on Oracle Payment Systems and follow ups.
• Coordinating DBA team for Oracle recommended setups and generating logs and debug files and uploading to Oracle etc.
• Coordinating off shore team for integration.
• Developing Technical docs (TDD), DOUs etc.

Environment: Oracle Applications 12i (12.1.3)/ (Oracle Payments, Oracle Field Service, Oracle Depot repair, Oracle e-Commerce Gateway, Oracle Release Management, Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management (EAM), Advanced Collections, Oracle Quality. Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory, Receivables, Purchasing, Payables, Service Contracts, Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i, 9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE. Gentran 4x, XML Publisher (BI Publisher). Biz Talk B2B translator.

Confidential

Sr. Techno-Functional Consultant

Responsibilities:

• Training the Confidential team in RLM setups for Frozen, Firm, Forecast demand needs,
• EDI gateway setups.
• Correcting Customer, Item X refs, Customer Cross reference setups.
• Correction of Forecast Source lists by customer etc.
• Creation of mapping templates for the above two transactions.
• Guiding X12 mapping team for Oracle ERP suitable file translation.
• Unit testing, flow through testing for the above two transactions.
• Developing Gap Documents for Customer ASN transactions.
• Developing technical document Using Extensible Architecture for Customer ASN Transactions.
• Whirlpool Consignee order shipments and ASN Customization.
• Assisting Whirlpool IRSO transactions etc.
• Assisting Order Management/Shipping related issues etc.
• Designing Inbound Product activity Data Transaction EDI852.
• Developing Process for EDI852 Process.
• Assisting Auto-invoice issues.
• Assisting Receiving Transaction issues.
• Toyota Customer DSNO Pre-Validation Report Process design.
• Honda Customer DSNO Pre-Validation Report Process design.
• Developed RLM Transactions Trouble Shooting Strategies.
• Designed Testing Strategies for RLM Transactions.
• Creation of MD50, MD70s for Consignee Order DSNO process.
• Creation of MD50, MD70s for Consignee Org Receipt Process.
• Creation of Oracle SR for Global Forecast List usage for RLM and resolving the issue.
• User Training for RLM transactions.

Environment: Oracle Applications 12i (12.1.3)/ (Oracle e-Commerce Gateway, Oracle Release Management, Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management (EAM), Advanced Collections, Oracle Quality. Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory, Receivables, Purchasing, Payables, Service Contracts, Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i, 9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE. Gentran 4x, XML Publisher (BI Publisher). Biz Talk B2B translator.

Confidential, Venice, FL

Sr Technical Consultant.

Responsibilities:

• Designed and Created Wip to Bom Sub inventory Transfer process for Decoration and Label Items.
• Designed and created Discoverer Reports (Many of them have the Pre-process PLSQL packages). Some of them are,
• Enhancements for EDI 944 Transaction for Blanket Pos.
• Enhancements for EDI943 Transaction.
• Enhancements for EDI945 Transaction.
• Flow Testing from 3PL warehouse to EBS and EBS to 3PL warehouse via Biz Talk services.
• Configuring the Dunning Letters of different degrees using Advanced Collections/Receivables.
• Modifying the Dunning Letters suitable to Tervis Needs.
• Creating Different Kinds of FSG reports.
• Enhancements for Integration processes for Flow Schedules, Price Lists, Items, BOMs, Store Locations etc.
• Designed and created process for internal requisitions integration and receipt against internal requisitions.
• Creating Migration Scripts to move database objects from instance to instance to instance.
• Data reconciliation for deliveries, orders, customer, items, requisitions between EBS, RMS, MES, WCS etc.
• Creation of data discrepancy reports across instances and across multiple platforms.(EBS, RMS,MES,WCS, EMU, SIT, UAT etc.).
• Creation of SRs with Oracle and resolving them.
• Creation of process for Internal Org Transfers.
• Resolving Freight Amounts info from 3PL Warehouse Ship Confirmation Messages on Invoices.
• Performance and Tuning for Sales Orders Outbound View and Manufacturing Data Collection Pre-Processor.
• Provided User Training on RMS -> EBS -> RMS internal requisitions and internal sales orders.
• Configuring Smart Bare QA Complete/Test Complete. Selenium software for Testing.
• Configured Oracle Data Integrator (ODI) for data imports into custom tables from Flat Files, to replace informatics tool.
• Configuring Ignite Software for Database Performance monitoring.
• Configuring Web-logic Server for SOA.
• Configuring BAM and SOA servers.
• Developed standalone ADF pages for Manufacturing Data Collection, Integration Processes, EDI Processes.
• Technical Resource planning and Tasks Planning.
• Organized Technical discussions with other peers and associates. Functional discussions with end users.
• Trained end users in Applications Navigation, and running reports etc.
• Involved in designing ‘Double Blind Shipments’ process. And modifications for Pick slip and Pack slip reports for this kind of shipments.

Environment: Oracle Applications 12i(12.1.3)/ (Oracle Purchasing, Oracle Work In Process, Oracle Bill of Materials, Oracle Enterprise Asset Management(EAM), Advanced Collections, Oracle Quality. Order Management, Warehouse Management, Shipping, Oracle e-Commerce Gateway, Oracle xml gateway, Inventory, Receivables, Purchasing, Payables, Service Contracts, Application Developer, System Administration), Oracle database10g/11g, Oracle Developer 2000 6i, 9i and 10g. SQL Navigator, PL SQL Developer, HP UNIX., RICE . Gentran 4x, XML Publisher(BI Publisher). Biz Talk B2B translator.