SUMMARY:

• Senior Technologist possessing over Seventeen years of experience in the IT industry, with 15+ years of specific experience in Oracle Applications and 4 years in Oracle database administration.
• Good team player as Lead/Consultant/Programmer Analyst/Developer.
• Hands on Oracle R12/11i Application implementation and upgrade experience across project cycles. Involved in design, code, test and documentation phases of the project.
• Experience in SCM, OTC, P2P, CRM (Install Base, Service and Contract) and Oracle Financial modules.
• Hands on experience in conversion and interfaces building strategy in Oracle Applications ERP systems and external systems.
• Experience in Oracle R12 (12.2.6/12.1.3 )/11i (11.5.10/11.5.9/11.5.5/11.5.4/11.0.3 and 10.x) RICE development, SQL Tuning, Custom, Customization Workflow and PROD maintenance of Oracle ERP applications and e - Business Suites, migration of database and data synchronization.
• Experience in client-server development using Oracle Developer 2000, XML Reports and Discoverer.
• Worked in OM, PO, BOM, WIP, INV, WMS, OTM, EAM, Oracle Demantra, iProcurement, CRM, GL, PO, AP, AR, PA, FA, AOL, Alerts, Workflow, Forms, Reports, Oracle Business Intelligence (XML Publisher) Oracle Discoverer and Oracle TCA.
• Strong analytical, diagnostic, and troubleshooting skills and ability to work in a dynamic, team-oriented environment.
• Hands on experience in development and extension RICE components using SQL and PL/SQL, Customization of forms using CUSTOM.pll, reports using Report builder 6i, XML Publisher and exposure to WF.
• Have 5 full cycle end-to-end implementation and one support project(s) experience.
• Good at development of interface and conversion programs using PLSQL and Oracle Standard API's.
• Migration of legacy data to oracle using SQL*Loader and UTL FILE utilities
• Knowledge of underlying table structure of oracle applications modules for development of enhanced functionality.

TECHNICAL SKILLS:

Applications: Oracle R12/11i Manufacturing Inventory, Cost Management, BOM, WIP, OM; Advance pricing, shipping, Install Base, Service and Contract Workflow 2.6, AP, AR, GL, Purchasing, PA, FA, Oracle Quality

RDBMS & Utilities: ORACLE 11g/10g/9i and Oracle 8i Release 8.1.6.3, 8.1.5 ORACLE 8.0.5, 7.3.4 PL/SQL, SQLPLUS, SQL*LOADER, EXP, IMP, Forms6i, Reports 6i, Developer 2000, Sql*net2.x/Net8, Perl

Operating Systems: Linux Red Hat, HP UNIX 10.20, Sun Solaris 2.8/2.4, Digital UNIX, AIX UNIX, Open VMS V7.1, NCR UNIX, Windows XP, Windows NT/2000.

Data Modeling Tools: Erwin Data Modeling Tools Ver3.5.2

Tools: Used: ITG Tool, PVCS, Clearcase, Microsoft OPTIO, Microsoft Visio, T.O.A.D Ver12.0.0.61 and SQL Navigator 4.1, Docshare, CC Harvest, Atlassian SourceTree Ver 2.3.1.0 (GitHub)

PROFESSIONAL EXPERIENCE:

Confidential, Morgan Hill CA

Sr. Techno-Functional Consultant

Responsibilities:

• Responsible to analyze, design, develop, troubleshoot, and implement, standard and custom processes in Oracle application
• Involved in functional design for customer purchase, Order Transaction Type, Custom Lookups, DFF, Customer Relation and Inventory Templates
• Write programs using various languages and tools including, SQL, PLSQL, Oracle Forms, Reports, Forms Personalization, XML Publisher Reports
• Ongoing performance tuning on SQL, PL/SQL programs and maintains repository for all inhouse and 3rd party software/customizations and documentations
• Involved in Oracle r12 implementation for Manufacturing, Order management, Purchasing, Shipping, Inventory, BOM, WIP and Financial modules of Oracle r12 Applications
• Developed BI Publisher Packing slip, Pick Slip reports for multiple markets.
• Developed Custom forms to modify mass-update orders in Order management.
• Developed API for item category updates for fiscal classification
• Developed custom discoverer reports and Oracle reports using report writer.
• Ensures software issues are addressed and resolved in a timely manner with helpMonitors outstanding service requests, patch applications and associated testing
• Support existing production environment for 11i and R12.
• Resolved helpdesk production issues ticket and new enhancement based on user requirement in timely manner.
• Using GitHub tool for migrating objects to different environment in Oracle r12.

Confidential, Palo Alto, CA

Sr. Techno-Functional Consultant

Responsibilities:

• Involved in functional Setups - Order Transaction Type, Custom Lookups, DFF, Customer Relation and Inventory Templates
• Decommissioned Service Contract and Install base (SFM services)
• Created Interface and conversion programs for Inventory, Order and Customer creation using PLSQL.
• Created Customer Data Extract program for Salesforce.
• Customer details update from Salesforce to Oracle.
• Item attribute update program to make Bill only and Hardware templates.
• Custom program to create Order line hold and line release for fulfillment portal.
• FTP all data file using UNIX shell program.
• Asset move program to Salesforce.
• Support existing production environment
• Create and customize the existing Oracle reports.
• Create Oracle Alert for Order Booking.

Confidential, Grand Terrace, CA

Sr.Techno-Functional Consultant

Responsibilities:

• Create Interface and Conversion programs for portal related modules.
• Create the interface program for data warehouse stratum server and integrate with Oracle server.
• Setup the AOL objects for Stratum integration (Lookup, DFF, Value sets)
• Designed Oracle outbound interface to extract the Customer Sales and Order data using PL/SQL program.
• Create the host (UNIX Shell) for FTP program an Oracle extracted text file into stratum server.
• Create the Item, Bill of Material (BOM), Routing conversion programs.
• Create OM, Pricing and Customer master data API’s for Portal integration.
• Converting the AP and AR invoice data from Legacy system to Oracle Open interface program.
• Create XML BI publisher report for Customer and Sales data.
• Interact with Oracle on Demand (OOD) for project related problems.
• Develop the custom report using Oracle Reports.

Confidential, Pleasanton CA

Sr.Techno-Functional Consultant

Responsibilities:

• Create XSL template file for AP Payments using BI Publisher
• Create template format and attached the XSL template file into template format.
• Setup the Mexico Payment Profile Process (PPP) template and Setup multiple Payment Process Request (PPR) based on Currency (Euro, CAD, USA, MXN, GBP).
• Configure the supplier CLABE#, BIC# and IBAN# for Mexico HSBC bank details payment.
• Developed the validation program to validate the supplier payment.
• Designed and developed custom program for Supplier Remittance, to email the process payment details to business users.
• Created host (UNIX Shell) program to move pdf file into custom Mexico specific folders.
• Created host (UNIX Shell) Program SFTP payment file to move the HSBC server with XML files to EDI server.
• Designed inbound program to get the accepted and rejected file from HSBC bank using XML parser.
• Developed custom report to keep track of the rejected and accepted supplier payment.

Confidential, Brea, CA

Sr.Techno-Functional Consultant

Responsibilities:

• Working as a Sr. Techno-Functional Consultant for Confidential in Oracle 11i, WMS, SCM, OTM implementation project.
• Involved in the custom delivery grouping rule engine to added new delivery grouping columns.
• Splits the delivery lines based on the custom reservation screen using sub-inventory quantity picked.
• Added the new functional columns into Delivery Grouping rule engine and updated the delivery rule dates for Hazardous products.
• Integrated with auto pick delivery in pick-light technology in warehouse as per the OTM (Oracle Transport Management) required.
• Created the new Pick Slip reports using the XML publisher.

Confidential, Sunnyvale, CA

Sr.Techno-Functional Consultant

Responsibilities:

• Worked as a Sr. Techno-Functional Consultant in Oracle 11i - Install Base and Service Contract implementation.
• Involved in full cycle of Oracle Install Base and Service Contract - renewals/ licensing Migration Projects.
• Designed Install Base API’s Program and data mapping from Siebel to Oracle.
• Designed Service Contract API’s program and data mapping from Siebel to Oracle.
• Designed the Install Base, Service Contract Concurrent Program, Executable, Request set, Values Sets and Report (RDF) file, shell script and PLSQL programs for applications.
• Convert the Service Agreement/ entitlement data from Siebel to Oracle.
• Developed the custom program for Oracle API’s and Interface Tables.
• Designed complete contract authoring execution solution to manage warranties, extended warranties, usage, subscription services, as well as complex service agreements in various data loading programs and documentation pertaining to different project phases.
• Designed the Oracle Service Item in Oracle based on the Siebel Agreements.

Confidential, Sunnyvale, CA

Techno-Functional Consultant

Responsibilities:

• Worked as a Sr. Consultant for RIVERBED Technology Oracle 11i OTC, Service and Contract implementation project.
• Involved in full cycle of Oracle Migration Projects.
• Modules involved include Order Management (OM), Bill of Materials (BOM), Inventory (INV), Pricing (QP), Purchasing (PO), Account Receivable (AR), TCA (HZ), Install Base (IB), Service (OKS) and Contract (OKC) in a Multi-Org, Multi-Reporting, Global Accounting environment.
• Designed various data loading programs and documentation pertaining to different project phases. Designed documentation and deliverable.
• Conversion of Legacy reports into Oracle BI XML Report.
• Generated XML from table data in PL/SQL for an individual check or BACS payment amount to a supplier.
• Developed Migration related installation script for moving one instance to other instance like Concurrent Programs, parameters,
• Executable, Request set, Values Sets and Report (RDF) file, shell script and PLSQL programs for applications.
• Designed interface/conversion program and mapping, UAT testing, related documentation.
• Developed the Install Base Conversion using oracle API’s (CSI ITEM INSTANCE PUB.Create Item Instance, CSI II RELATIONSHIPS PUB.create relationship) Inbound and outbound interface program.
• Developed the Install Base update status program for Loyalty customer installed product to recycled process.
• Convert the OPNET data from csv file to the staging table using SQL*Loader and Riverbed custom data load program did all the necessary validations before loading into Oracle API’s and Interface Tables.
• Developed the Service Contract Conversion API’s program, loaded the data from csv file to the staging table using SQL*Loader and did all the necessary validations before loading into Oracle API’s like OKS CONTRACTS PUB.create contract header, OKC CONTRACT PARTY PUB.create k party role, OKS CONTRACTS PUB.create service line,JTF NOTES PUB.create note, OKS CONTRACTS PUB.create covered line OKC CONTRACT PARTY PUB.create contact
• Developed the Outbound interface for BOM and Items.
• Developed the custom BI XML report for Invoice Common Print.

Confidential, Oakland, CA

Techno-Functional Consultant

Responsibilities:

• Modules involved include Accounts Payable (AP), Account Receivable (AR), General Ledger (GL), Purchasing (PO), Project Accounting (PA), Fixed Assets (FA) USA locations in a Multi-Org, Multi-Reporting, Global Accounting environment.
• Designed various data loading programs and documentation pertaining to different project phases. Designed documentation and deliverable.
• Conversion of Account payable BRIO reports into Oracle Reports.
• Developed installation script (ldt file) for moving one instance to other instance like Concurrent Programs, parameters,
• Executable, Request set, Values Sets and Report (RDF) file, shell script and PLSQL programs for applications.
• Designed interface/conversion program and mapping, UAT testing, related documentation.
• Developed the AP Suppliers Conversion and Inbound Interface program, loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations before loading into AP SUPPLIERS INT, AP SUPPLIER SITES INT tables and Calling supplier open interface Import and supplier sites open interface Import Program.
• Developed the Purchasing Item and Cross Conversion program, loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations before loading into MTL SYSTEM ITEMS INTERFACE, tables and Calling Item Import Program.
• Developed the AP invoices Conversion Interface program, loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations before loading into AP INVOICE INTERFACE, AP INVOCIE LINES INTERFACE tables and Calling Payable Import Program.
• Developed the customized Oracle AP Invoice Voucher inbound interfaces (Freight Voucher, Commercial Payment Voucher, Insurance payment vouchers, Vendor payment vouchers and Workman's comp check confirmation) program from legacy system to Oracle AP.
• Developed the custom AP Check Confirmation outbound interface from Oracle AP to 3rd party system.
• Developed the conversion program for Purchase Order from legacy system to Oracle application PA base tables.
• Involved purchasing interface program.
• Developed the customized Oracle PO Requisition/Receipts inbound interfaces program from legacy system to Oracle AP.
• Developed on GL Journal Imported and GL total balance import from legacy system to Oracle General Ledger (GL) tables using the Oracle open interface program.
• Developed Custom Reports and Discoverer Report based on Client requirement (AP, AR, GL and PA)
• Developed Custom Error correction forms for AP Suppliers and Inventory Items.
• Involved a package on AR Auto Invoice interface, Imported invoices from legacy system to Oracle Receivables (AR) tables using the Auto Invoice import program and wrote a custom program in grouping the invoices based on the requirement.
• Worked on the Oracle Customer Conversion using API’s, which perform actions on Creating, Updating the customer data.

Confidential, Fremont, CA

Sr. Principle Consultant

Responsibilities:

• Involved in Production support and enhancement for Confidential project (Oracle Application 11.5.10).
• Worked sql report on Financial Revenue Reconciliation Report for identified the every quarterly to identify the revenue processed.
• Create the Oracle Business Intelligence (OBIE) Reports for iProcurement, MFG, OM, Shipping Execution, Sales Compensation Modules.
• Concurrent Programs, parameters, Executable, Request set, Values Sets file, shell script and PLSQL programs for applications.
• Created the iProcurement Approval Notification and Send the approver for pending approvals.
• Designed interface/conversion program and mapping, UAT testing, related documentation.
• Designed custom XML reports, XLS reports SQL reports and customized existing reports as per the client requirement.
• Using KINTAN tool (IT Governance) to use UAT and PROD custom code migration tool from development and Test instance.
• Designed various data loading programs and custom Interface Inbound program to update the Confidential custom tables.
• Developed the Order import Interface program (AP I's), loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations before loading into Oracle tables and Calling concurrent program.
• Developed the custom script to update the SNI data fix for PROD Instance.
• Using Oracle Quote and Oracle Pricing modules API’s to convert the data into Oracle base tables.
• Developed Oracle Sales audit commission and compensation reports

Confidential, Alpharetta, GA

Techno-Functional Consultant

Responsibilities:

• Involved in SCM and Demantra Production support and enhancement for Cox project (Oracle Application 11.5.10).
• Designed various data loading programs and custom Interface Inbound program to update the Cox custom tables.
• Designed customized shell script and technical design documentation (MD070) and deliverable.
• Developed shell script for Retail Responsibility Installation script (ldt file) for moving one instance to other instance like Concurrent Programs, parameters, Executable, Request set, Values Sets file, shell script and PLSQL programs for applications.
• Designed interface/conversion program and mapping, UAT testing, related documentation.
• Designed custom reports and customized existing reports as per the client requirement.
• Using KINTAN tool (IT Governance) to maintain the team code and move code all the object to Development instance to TEST and UAT instance.
• Developed the Order import Interface program (AP I's), loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations before loading into OE ORDER HEADER and OE ORDER LINES tables and Calling Order Import Program.
• Developed the Order, Order returns, shipping and in-transit query for Product development team.
• Using Install Base (IB) API’s to convert the IB data into CSI Item instance tables.
• Wrote a Outbound Interface package on BOM interface from Oracle system to Brightstar 3PL system.

Confidential, Overland Park, KS

Techno-Functional Consultant

Responsibilities:

• Involved in full cycle of Oracle OTC Implementation project (Oracle Application 11.5.10).
• Designed various data loading programs and custom Interface Inbound program to update the Sprint custom tables.
• Designed customized reports and report documentation (RD060) and deliverable.
• Customized of order fulfillment crystal reports into Oracle Reports.
• Developed detailed data mapping from the source legacy system to the EAM Asset Data Conversion.
• Designed inbound interface programs to interface legacy to Oracle EAM using MTL EAM ASSET NUM INTERFACE, MTL EAM ATTR VAL INTERFACE
• Developed installation script (ldt file) for moving one instance to other instance like Concurrent Programs, parameters, Executable, Request set, Values Sets and Report (RDF) file, shell script and PLSQL programs for applications.
• Designed interface/conversion program and mapping, pre-production testing, related documentation.
• Using Docshare to maintain the team code and documents file system management.
• Maintained proactive interaction with the client to understand business practices to aid in data conversion and In-bound program.
• Developed the Order import Interface program, loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations before loading into OE ORDER HEADER and OE ORDER LINES tables and Calling Order Import Program.
• Developed the production custom views to get back-order quantity, custom Hold quantity, Order quantity, On-Hand Quantity and Reservation quantity for Product development team.
• Developed the Order, Order returns, shipping and in-transit query for Product development team.
• Using Install Base (IB) API’s to convert the IB data into CSI Item instance tables.

Confidential, Austin, TX

Techno-Functional Consultant

Responsibilities:

• Worked on behalf of Confidential as a consultant for DELL NOVORA project.
• Involved in full cycle of Oracle Financial upgrade project (11.0.3 to 11i).
• Modules involved include Project Accounting (PA), Accounts Payable (AP), General Ledger (GL), Purchasing (PO), Fixed Assets (FA) for Europe, Asia Pacific, Japan, Australia, China and USA locations in a Multi-Org, Multi-Reporting, Global Accounting environment.
• Designed various data loading programs and documentation pertaining to different project phases. Designed customized reports and all documentation and deliverable.
• Conversion of Account payable BRIO reports into Oracle Reports.
• Developed installation script (ldt file) for moving one instance to other instance like Concurrent Programs, parameters,
• Executable, Request set, Values Sets and Report (RDF) file, shell script and PLSQL programs for applications.
• Designed interface/conversion program and mapping, UAT testing, related documentation
• Using Oracle iProjects Oracle Files is an innovative file management system that allows you to access and manage data while working collaboratively. Streamlining your data through Oracle Files
• Using VSTS to maintain the Dell oracle application file system management.
• Maintained proactive interaction with the client to understand business practices to aid in system configuration.
• Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations before loading into AP INVOICE INTERFACE, AP INVOCIE LINES INTERFACE tables and Calling Payable Import Program.
• Developed the customized Oracle Project Accounting inbound outbound interfaces program from legacy system to Oracle PA.
• Developed the conversion program for Project Accounting from legacy system to Oracle application PA base tables.
• Involved Project Accounting and purchasing Card interface program.
• Wrote the Program to insert data into Receiving Interface tables RCV TRANSACTIONS INTERFACE, RCV TRANSACTIONS INTERFACE tables based on the different Transactions and Receiving Transaction Processor process data from the interface tables and the quality updates are done.
• Wrote a package on AR Auto Invoice interface, Imported invoices from legacy system to Oracle Receivables tables using the Auto Invoice import program and wrote a custom program in grouping the invoices based on the requirement.
• Worked on the Oracle Inbound Ship Confirm API’s, which perform actions on Deliveries, Updating shipping attributes, updating the Freight costs, through WSH DELIVERIES PUB, WSH DELIVERY DETAILS PUB and WSH FREIGHT COSTS PUB shipping API’s

Confidential, Roseland, NJ

Technical Consultant

Responsibilities:

• Worked as a Senior Oracle Applications Technical consultant responsible for the implementation of Oracle Manufacturing (Item, Item Category, Item Catalog and Bill of Material), OM (Order Entry and advance pricing), Configurator and Install Base
• Involved in the implementation of Item, Bill of Material, Oracle advance Pricing and Deposit checks, Cash receipts, Install Base, Product Configurator on Technical side.
• Created the custom service API’s to all updates i.e., additions, terminations and changes
• Developed account receivable (AR) for the deposit checks, cash receipt and update cash information such as commitment flag to Install base from legacy system
• Convert the historic receipts using Auto Lockbox for processing daily receipts.
• Developed Inventory conversion program for Item, Item Category, Item Catalog and Bill of Material
• Developed the pricing API’s to create the corporate, client and agreement pricing
• Used Application Program open Interface to import service requests into Oracle Applications (Service module).
• Involved in Service Agreements conversion design for Confidential Service as part of Global Oracle Service Implementation.
• Developed conversion design pertaining to the Service Requests for Open Cases for Support Calls, Open Service Orders and Service Orders that have been closed in the last 1 Year.
• Involve in Warranty Agreements conversion design for Confidential Service as part of Global Oracle Service Implementation.
• Developed shell scripts for data load and data validation program call.
• Dynamically script identified the transaction type to create, update and delete the conversion process.
• Gathering User Requirements.
• Creating and customizing User Interfaces for product configurator.
• Converting data using Oracle API’s for loading data into Oracle TCA tables.
• Documentation:
• Developed oracle AIM methodology document for strategy document (CV.010)
• Data Mapping document (CV.040)
• Conversion technical design document (CV.060)
• Actual Code document (CV.080)
• Test documents (TE.110)
• Installed Conversion Programs (CV.120)
• Interface technical design document (MD.070)
• Involved functional design (MD.050) complying with Oracle AIM standards.

Confidential, Richmond, VA

Technical Consultant

Responsibilities:

• Worked as a Senior Oracle Applications Technical consultant responsible for the implementation of Oracle Shipping, OM and MFG Modules: INV, Cost Management, BOM, WIP OM and WMS
• Involved in the implementation of OM Shipping on Technical side
• Worked on Conversions to import orders and invoices from legacy system
• Wrote interfaces between OM and Shipping by using Shipping API's
• Customized various reports in OM, Shipping Reports (Bar Code used), Pre-Pick LPN Detail Report, and Customer Sales Representative
• Customized Discrete Jobs Dispatch report, Discrete Job Pick List Report, Discrete Job Routing Sheet report
• Customized the Packing slip, Pick Slip and sales order Acknowledgment report
• Developed Custom forms to modify License Plate information.
• Customized Commercial Invoice and Bill of Lading reports
• Developed custom Discoverer reports like PO returns report and Bin replenishment report.
• Involved in attaching new BOM components to the existing BOM structure according to the rules provided by the Business.
• Worked on License Plate Number contents data conversion for using open interface table.
• Involved customizing the Pick Release and the Allocation process.
• Developed MS Excel feeds using Discoverer Reports for Revenue Recognition, Product Shipped and various other requirements.
• Design and code custom Pick List report to accommodate LPN information.
• Implementing for Bar Code for LPN to make easy to search the available and reserved LPN.
• Participate in day to day production activities on an ad hoc basis.
• Developed functional mapping for existing legacy system to Oracle Apps. (Utilizing functionality of Key flexfields and Descriptive flexfields)
• Customized various reports in INV like Customer Items Report, Customer Item Cross s Report and Inactive Items Report
• Using Oracle TCA tables for Customer information report.
• Developed technical design and test documents complying with Oracle AIM standards

Confidential, Little Neck, NY

Technical Consultant

Responsibilities:

• Worked as a Senior Oracle Applications consultant responsible for the implementation of Oracle ERP Modules: INV, Cost Management, BOM, WIP and AP and GL
• Involved in functional discussion pertaining to Inventory, WIP, MRP, Purchasing
• Developed functional mapping for existing mainframe system to Oracle Apps. (Utilizing functionality of Key flexfields and Descriptive flexfields)
• Requirement study and design on Oracle open item interface to bring in Item information and Category Interface to legacy reporting systems
• Design and developed the custom interface for Catalog’s, Cross and Attachment Interface to bring the data from legacy system
• Developed interface for Post Sales details to Oracle Install Base to update the Serial Number in Install based instances using Oracle Install Base API’s, The principle role of the interface is to update the Sub-Product Instances (child instances) with additional information of serial number in the Oracle Install Base repository after shipment and instance creation.
• Developed the Open Invoice interface to bring in freight information, sales and marketing interface to legacy reporting systems
• Brought the purchase orders and converted the vendor information from legacy data
• Designed and integrated add-on Bar-coding module to Oracle Applications with UL and CUL information
• Designed the scanning add-on module and integrated it with Oracle applications. Used Tec logic scanner
• Developed custom documents move tickets, bumper stickers and spool labels for Oracle applications
• Customized the receipt transactions to make multiple receipts and generate multiple move tickets
• Performed the legacy cost data conversion using the oracle open interface
• Designed check printing using Microsoft Option software
• Developed and customized numerous reports in WIP, INV, BOM, PO, AP and GL modules
• Wrote generic scripts for AUTOSYS to submit the oracle concurrent requests
• Developed custom procedures / Triggers to handle the relief feature of Oracle MRP for specific data from legacy (Warehouse and Inventory Control System in mainframe (WHICS System))
• Converted the data from legacy systems into 11i. Developed control files for SQL*Loader and PL/SQL programs for loading, data mapping, data conversions and validating the data into the interface tables of GL,AP, AR.
• Loaded Legacy Journals data into GL INTERFACE table using SQL*LOADER and run Journal Import in to GL JE BATCHES, GL JE HEADERS and GL JE LINES tables and Integrated in oracle Applications. All interface programs are designed to run as concurrent programs.
• Developed custom form and Report to report physical inventory for the phantom sub-assemblies
• Designed solution and developed concurrent program to customize the UOM conversion for items belonging to different organization. Currently, Oracle does not allow conversion rate for an item to vary across organization
• Developed for user required custom interface program, report modifications and developed new reports from scratch
• Developed custom Quality Data interface for oracle Quality Elements and Specification data from legacy
• Involved for custom quality chart for Quality module
• Resolved the business requirements through custom.pll and change the functionality
• Developed custom procedure to creates budget data. Then create new budget report for totals invoices for a BOM commodity, determines if an A, B, or C item
• Developed custom reports for demand/excess inventory in a Supply chain environment. This involved extensive use of formula columns, format triggers, and data grouping
• Developed technical design and test documents complying with Oracle AIM standards.

Confidential, Pittsburgh, PA

Technical Consultant

Responsibilities:

• Technical and production Consultant for RICE team involved data conversion for the leader in Aluminum manufacturing Company ( Confidential )
• Involved ISC Europe Order management data conversion requirements for US as well as European operations
• Design and documentation of conversion strategy to convert data from legacy system into all the financial, manufacturing and HR modules
• Documentation of technical standards and coordinate data conversion impact with interfaces and customization
• Provide periodic status reports to the project senior management
• Development of data load scripts and data mapping in Order Management
• Written Data loading scripts in GL, AP, INV, BOM, OM
• Developed Oracle Open Interface for Item Categories. The configured item bill and routing is created. The standard oracle workflow creates the item but does not store categories for configured item. Determine the item number that was generated and then retrieves the categories from the attributes table. It then invokes the open interface for item category insert. The custom script and API can be used by any BU. The API could be called from a custom conversion program
• Involved User requirement changes reports and Developed New FND Reports
• Developed User Listing Reports and Responsibility Verification Reports
• Custom Report developed to track Over-aged Sales Orders for ISC-Europe
• An ATP Inquiry, Order Process & Order Hold done through Workflow for Marked Carton Substitution Processing (MCSP) program. This workflow is run to determine item availability and checking the pricing engine for item having discount, surcharge and any kit attached. Ship sets will be utilized to insure that all lines can be scheduled and shipped together as each order is a single truckload
• Developed technical design and test documents complying with (MD70 and RD70).

Confidential, Manfield, MA

Technical Consultant

Responsibilities:

• Worked as a Technical consultant implementing Oracle ERP modules Inventory, BOM, Cost Management, Order Management/Shipping and Advanced Pricing.
• Involved in the Functional setup of Cost Management, Order Management & Advanced Pricing.
• Loading of Bill of Materials and revisions from legacy data file.
• Created Engineering BOM and successfully implemented it in manufacturing.
• Wrote WIP Job scheduling interface, to bring in all the work orders that has been created by the legacy System.
• Wrote WIP Move Transactions interface, to bring in all the shop floor move transactions occurring in the legacy System.
• Involved in development of both High level and Detail level Design and Deliverable for all the customization.
• Generating New Price Lists with different rates and effective dates each year for some year specific items.
• Involved in setups of Installed Base
• Involved in setup and implementation of Service and Contracts Modules.
• Responsible for data conversion to load data into the Installed Base
• Developed a custom workflow for tracking service requests, and notifying users about the status of these service requests.
• Used Application Program Interface (API) to import service requests into Oracle Applications (Service module).
• Involved in the installation & Setup of Oracle Contracts.
• Created Service module Depot repair and Spares status reports
• Created workflow for contract approvals, which sends notification to appropriate user when contract is approved.
• Involved in creating flexible service agreements tailored to customer requirements with the exact level of product service.
• Created Shipping entities like trips, stops, Delivery, Delivery Line and Delivery Leg.
• Created and registered. Custom reports to fulfill the user requirements
• Developed a custom workflow for tracking service requests, and notifying users about the status of these service requests.
• Performed system administration functions such as creation of users, creation of responsibilities, defining value sets, managing concurrent manager, creation of concurrent programs and executable, registering applications
• Worked with interface tables for Reservation, UN-reservation, and move Sub-inventory quantity with regard to sales order.
• Customization of various reports as per the user requirements.
• Design and developed the custom interface program for pricing attributes, Pricing Header and Pricing Line Interface to bring the data for oracle advance pricing cycle.
• Designed and developed various reports as per the user requirements.
• New report designed and developed to report all the items ordered by the customer with qty and price details under a Service Order (a list of items with prices - Product Offerings) for a given period.

Confidential, Pittsburgh, PA

Oracle DBA

Responsibilities:

• Working as a DBA team lead for a group of Three DBA’s
• Installed and configured an Oracle 7 server on Window NT and Sun Solaris 2.x
• Established centralized SQL*Net connectivity in a TCP/IP network environment
• Installed Quest software products like Spotlight on oracle, schema manager and TOAD for efficient database monitoring and effecting the database operations
• Maintaining the physical and logical Oracle databases through Erwin 3.5.2 Data Modeling Tools.
• Define Object to Relational Mapping schemes for distributed data access (multiple databases). Database schema updates were promoted from the data model to the database. This process helped control the promotion process from the Domain Models and transition into a data dictionary for the database development instance to the test and production instances. This included the creation of data alteration scripts to preserve the data as table structures were updated.
• Created scripts to promote look-up table data from one instance to another through Data Model.
• Background in SQL, PL/SQL, batch/shell scripting, Implemented data communication between databases by creating database links and by using Oracle utilities, including import, export, and SQL*Loader.
• During product development and deployment. Responsible for installations, upgrades and applies patches to databases
• Performs database maintenance activities such as partitioning, index reorganization, and transporting tablespaces.
• Performs database security and user management activities including system security. Defining and managing users, policies and roles.
• Assisted the development team in creating packages, stored procedures, and triggers. In particular, helped tune SQL statements and resolve performance or system issues.
• Installed and Upgraded Database Configured for Family-Net project team.
• Built and maintained a large data warehouse environment and generated reports using Cognos tools
• Created Data Marts and Date Warehouse Dimensions, facts and Cubes.
• Assisted in developing Materialized views for the Data warehouse team to access data in an efficient and fastest manner.
• Planned for backup and recovery of database information. Maintained archived data on tape and disk.

Confidential

Oracle DBA

Responsibilities:

• Establishes and maintains data structures and Parallel Server database environments to support very complex, large, multi-platform development, testing, and production activities.
• Meets with database users, developers, testers, and technical staff to identify critical data elements and logical data element relationships within the database structure.
• Develops overall structure for the databases by translating logical relationships among data elements into appropriate physical design using various database techniques (e.g. pointers, indexing).
• Identifies appropriate changes to data definition, placement, and organization by monitoring database performance and access activity, researching industry trends (e.g. technological methods, new approaches to database problems), and executing limited pilot project to assess the viability of changes to the hardware/software environment.
• Assists application development personnel with logical design of the database structure, physical structure of the database (e.g. storage mode, file placements, page size/access strategies), and coding database definitions applicable to specific data structures as necessary.
• Generates processing environments using RDBMS functions to support application development, testing, and production according to the data needs of the application life cycle.
• Reviews and executes the migration process to move data structure from flexible application test environments into secured production operations using Advanced queryingPL/SQL
• Develops strategies to address various RDBMS design issues (e.g. storage efficiency vs. retrieval and processing speed, complexity vs. usage, amount of data independence.)
• Tunes RDBMS configuration by modifying system parameters, relocating data files, and recommending application software changes to meet management performance objectives.
• Maintains database security by administering user accounts through documented change procedures and requiring user identification through standard data access paths for database tablespaces and data dictionaries.
• Prepares RDBMS related policies, standards, and procedures and presents proposed changes to supervisor and/or manager for approval.
• Provides resource estimates and progress reports to database systems manager.
• Performs problem resolution and support activities. Ensured 24x7 database availability.
• Monitors database operations and reviews database reports to identify error conditions (e.g. slow response, limited disk space).
• Resolves performance problems and recovers from system outages (e.g. recovers files, resets system parameters).
• Monitors Parallel Server database application design (e.g. adherence to data security requirements, disk space allocation).

Confidential

Oracle DBA

Responsibilities:

• Designing Database tables, views, synonyms and all schema objects in Oracle.
• Database Backup, which is a Daily routine and Hot Backup also.
• Maintenance of user privileges, creating new users.
• Database Tuning and Optimizing.
• Data Communication between Databases is using Oracle database links, Import/Export Utility.
• Trouble shooting, Auditing, Testing, Implementation, Data maintenance.
• Created database backup shell scripts, maintained user privileges, and created new user accounts.
• Performed Oracle database tuning and optimizing.
• Audited, Recovered, Maintained, and resolved problems with the data.
• Development supporting using Forms 4.5 and Oracle Reports.