OBJECTIVE

• To work smart in a technically competitive and motivated firm involving technical / functional development of ERP projects where I can be an asset to the company’s growth by exercising my skills, which includes Research, Design, Development and Support where I can exercise my existing skill set, gather wide range of new skills.
• To put my abilities to the zenith towards achieving the organization’s values and goals and to see myself as a mature and thoroughbred professional in the industry.

SUMMARY

• Around 11 Years of IT experience in ERP implementation and Enterprise Applications Practice with proven experience in Developing, Customizing, Supporting/Maintenance and Migrating / Up gradation of Oracle Applications E - business Suite R12 & R11i.
• These includes Analysis, Customizations, Design, Development and Implementation for applications based on Relational DBMS and in the field of Oracle e-business Suite and customer oriented, multitask professional with excellent analytical and logical skills possesses.
• Having excellent experience in development & maintenance of Oracle Applications R12& R11i
• Good Technical skills in developing RICEW or CEMLI Components in the domain of Oracle E-Business Suite
• Highly conversant with various modules of Oracle Applications Release R12 & R11i (SCM, MFG, Distribution, FIN, CRM & HRMS)
• Areas of expertise technical developments and having functional knowledge in Multi-org, MOAC, SLA, MRC, INV, PO, AP, OM, Shipping, Advance Pricing, AR, GL, FA, CM, ZX, WIP, BOM, WMS, Trading Community Architecture (TCA), Installable (CSI), Service Contracts (OKS) and Service Requests (CSF& CSD) & HRM modules
• Having 5 full life cycle implementations, 1 Migration and Sustaining Support experience with exposure to viz. AIM 3.0, Agile and OUM methodologies
• Having good knowledge on MD and CV documents for various components, good experience in development of functional/technical design documents
• Having excellent work experience with Oracle Business Intelligence Standard Edition Oracle Discoverer 10g and having knowledge on generating reports with XML / BI Publisher
• Good at development of interface and conversion programs for EDI using ODI, PLSQL and Oracle Standard APIs
• Having Knowledge on Data Warehouse Concepts (Informatica, ODI, OWB, EDQ & Reporting tools like OBIEE)
• Experience in importing data from legacy systems to Oracle Applications using SQL LOADER, UTL FILE, ODI, SOA, Oracle packaged APIs & Oracle Web ADI etc.,
• Expertise in Requirements Analysis, System Design, Data Flow Designs, Support, Development, Testing, Documentation and Design reviews
• Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120)
• Excellent experience in writing technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs)
• Rich experience in development and customization of Work Flow (WF), Oracle Application Framework (OAF), Application Development Framework (ADF) & Oracle APEX according to business needs
• Having knowledge on development of Business Process Engineering Language (BPEL) using Service Oriented Architecture (SOA)/FMW Concepts
• Strong in UNIX shell scripting and performance tuning of several objects using hints and several other processes, analyzing TK-Prof files and Explain Plan
• Having good expertise in Preparing Technical Documents, Unit Test Scripts (UTS), Code Review Checklist (CRC), Test Plan and Test Results documents based on the user/customer requirements
• Having Experience on Oracle Fusion Middleware 11g with ADF and JDeveloper and Oracle Cloud Fusion
• Rich Experience on documentation adhere to the JSOX, SOP & participated in Class Room Prototype (CRP)
• Expertise in working with end-users for support, troubleshooting and giving effective & efficient resolutions for the issues
• Analyze, design develop, troubleshoot and debug software programs for commercial or end user applications.
• Writes code, completes programming, and performs testing and debugging of applications
• Expertise in working in fast-paced, high-tech environments requiring skills in scheduling, management, team building and adopting new technologies.
• Very flexible and perform tasks are ad-hoc basis
• Team Player with Excellent Technical, Communication, Interpersonal skills & Leadership abilities

TECHNICAL SKILLS

OS/Environment: Ms-Dos, Windows, Linux and UNIX.

RDBMS (Database): Oracle 9i, 10g, 11g & 12c.

Oracle E-Biz Suite (EBS): Oracle Applications R12 & R11i.

Manufacturing, Distribution, Supply Chain Management (SCM): Inventory (INV), Work In Progress (WIP), Bills of Materials (BOM), Purchasing (PO), Warehouse Management (WMS), Order Quote, Order Management (OM/OE/ONT), iStore, Shipping Execution (WSH), Project Accounting (PA), Advanced Pricing, iProcurement, iSuppliers, Human Resource (HRMS), Sys. Admin & Appl. Dev.

Financials: Accounts Payables (AP), Accounts Receivables (AR), iReceivables, Cash Management (CM), Fixed Assets (FA), General Ledger (GL) & Oracle E-Business Tax (ZX).

CRM Modules: Installed Base (CSI), Service Contracts/Contracts Core (OKS/OKC), Service Requests (Field Service (CSF/CFS), Depot Repair (CSD) and Tele Services)/Customer Support/Customer Care (CS/CSS/CSC), Billing, CRM Foundation (JTF), Trading Community Architecture (TCA/HZ).

Languages, Scrips & Frameworks: SQL, PL/SQL, JAVA, OAF, ADF, SOA, Oracle APEX, C, C++, Shell, HTML, XML, Java Script and SQL Server.

Middleware: Oracle Fusion 11g (ADF & SOA (BPEL))

Front-end Tools (GUI): Forms 6i, 9i,10g & 10gR2, Reports 6i, 9i &10g, Jdeveloper10g, Work Flow Builder.

Business Intelligence (BI): Oracle Discoverer 10g, XML Publisher and OBIEE.

Tools: TOAD, SQL Developer, PL/SQL Developer, SQL Navigator, SQL*PLUS, SQL*LOADER, Winscp, Putty, FTP, WSFTP, JIRA, Lotus Notes, STATS, HP PPM, FileZilla, MS-Office, Open Office, ServiceNow, SQL Mgmt Studio & RStudio. Version Controls: SCM, Vault, SCCS, PVCS, Mercurial, Aegis.

Key Competencies& Skills: Client Relations, Business Analysis, Product Mapping and Consultancy, Data Migration Mapping, Test planning, UAT & Testing.

PROFESSIONAL EXPERIENCE

Confidential, MI

Senior Oracle EBS Consultant

Environment: Oracle Applications 12.1.3 & 12.2.6, Oracle 12c (SQL & PLSQL), Developer 2000 (Forms 10gR2 & Reports 10g), Work Flow, Shell Scripting, OAF, SOA, BPEL, XML Publisher 5.6, HP PPM, JIRA, Web Methods & ODI.

Responsibilities:

• My role is to adapts existing methods and procedures to create possible alternative solutions to moderately complex problems
• Worked for multiple region deployments & support in Europe, China, APAC and Latin America(GIS)
• Involved in design analysis and process changes for interfaces between EBS to third party systems
• Gathering and analyzing user requirements and interacting with business users to resolve issues
• Developed and updated Standard Operating Procedures manuals and helps to management that on different projects and applications.
• Interact with technical teams & business analysts to fulfil the requirement & help to signoff respective documents
• Participate in Class Room Prototype (CRP) meetings for gap analysis
• Created functional design documents (MD.050) for customizing to address business requirements and to address the labeling requirements and prepared respective MD070
• Leading the team who are all in different places globally and giving solutions to resolve the issues.
• Day to day status track of issues & Issue Tracking and Resolution and Involved in the post go-live support
• Help users to establish month-end procedures for closing and posting to GL
• Designed Technical Design for Oracle EBS inbound interfaces, extensions & reports
• Involved in Oracle EBS Upgradation from 12.1.3 to 12.2.6
• Worked on ODI, UTL PACKAGE, SQL*LOADER & SOA for the interfaces and conversions from legacy systems
• Working on Interface validations for third party system Hybris & AS400 systems for Customers (TCA), Orders(OM) & Receivables (AR)
• Working as OM& AR Modules Expert Resource at Client site to Review and Define Functional Setups
• Development and Enhancements various customizations of Oracle Receivables Module.
• Created New DFF's and Lookups in Oracle Receivables Module.
• Ensuring full traceability of deliverables throughout the project lifecycle using various tracking tools and Oracle AIM documentation
• Responsible for Interfacing systems and Master Data Management (MDM) to ensure appropriate synchronization and provision of data
• Worked in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 11g.
• Involved in JSP & JAVA object oriented related applications, customization and creation of JSP files & java classes.
• Involved in Order to Cash (O2C) Validations & developed bank related reports to avoid duplicate bank records in the system
• Developed Intergraded Test Scripts for testing Oracle Order Management and Oracle Contracts: Orders, Contacts, Quotes, EDI and Return Orders
• Developed custom OAF search page for in customers that shows unmasked Bank Account details. Only handful of users were given access to unmasked banking details
• Involved Data Migration and Cutover tasks
• Involved in real time actions of Orders & Customers integration using SOA and Webmethods.
• Supporting Oracle Cloud Fusion for Supply Chain and Financials.
• Assisted with Service Contracts and other CRM solutions with support, interfaces, upgrades and implementations
• Worked with Application Developer on data interfaces for Creating Service Requests, Install base and Contract/Warranty information.
• Involved in conversion validations (Items, Suppliers, Customers, Orders, IB & Service Contracts)
• Assisted in period closing and also daily production support by resolving system & user issues. Following up with Oracle Support on service requests.
• Reviewed and submitted performance test results & Production Support to users globally

Confidential, Portland, OR

Senior Oracle EBS Consultant

Environment: Oracle Applications 12.1.5, Oracle 11g (SQL & PLSQL), Developer 2000 (Forms 10g & Reports 10g), Work Flow, Shell Scripting, OAF, Oracle APEX & XML Publisher 5.6.

Responsibilities:

• Working as Senior Oracle EBS Applications Consultant
• Interacted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow
• Daily support to users based on service requests and tickets
• Performed GAP analysis to ensure that the requirements are captured properly
• Documentation for Unit Test Scripts, Test Plans, and Test Results
• Analyzed business requirements, designed, implemented business solution design and development.
• Prepared the Functional (MD 050), Technical (MD 070), Installation & Unit Test Case documents.
• Closely worked with users to understand business needs and objectives
• Post GO LIVE & Month End Support
• Invokedstandard API'swithin custom packages for creating and updating Customer, Sites and Contacts
• Imported new, changed and completed sales orders from legacy system to oracle usingorder import (order management open interface)
• Development of customer interfaces using Oracle standard TCA APIs including DQM rules
• Developed programs for GL Detail Journal Entries as per user requests
• Developed programs to extract Suppliers & Customers List Reports based on recent activity details
• Developed program for JE Tracker Report
• Responsible for validating data in temp table and importing data to GL interface table and runningGL BalancesImport
• ImplementedAP Invoice importthroughPayables Open Interface Import Program.
• Developed anoutbound interfacefor open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts, etc.,
• Developed Dash Boards, Pages for custom interfaces using Oracle APEX
• Developed Reports for Service Requests Summary and Details in Date Ranges
• Written anAPIfor ConvertingResources/SalesReps (OM)activities from Legacy System into R12 Production
• Developed program to get Supplier and Customer activity for 12 months
• Customized iStore reports as per user requirements
• Customized multiple reports and forms in GL, AP, PO, AR and OM modules according to the requirements.
• Customized Transaction register, Adjustment report, Receipts Register, Aging 7 buckets or 4 buckets Reports inAccount Receivables (AR)
• Used Custom PL/SQL API’S for converting Customers using TCA, Open AR Invoices,Open Purchase Ordersfromlegacy system to Oracle

Confidential

Senior Oracle Applications Techno Functional Consultant

Environment: Oracle Applications 12.1.3, Oracle 11g (SQL & PLSQL), Developer 2000, Discoverer 10g, Shell Scripting, XML Publisher 5.6, Work Flow, Oracle APEX, OAF, ADF, SOA, BPEL.

Responsibilities:

• Senior Oracle Application consultant and Hands-on Team Lead at offsite
• Active involvement in data gathering and processes study with functional team
• Gathering and analyzing functional requirements and Interacting with team and business users to clear the Requirements from different OpCos (Operating Countries)
• Post go live support to different countries (CN, HK, KR, MY, PH, SG, TH, TW, VN, AU and NZ)
• Support to FX-AU, FX-NZ implémentations
• Involve to providing functional specifications for customizations and developments
• Responsible for the overall design and implementation of Oracle ERP modules at technical end
• Involved to support workflows and frame work
• Documentation for Unit Test Scripts, Test Plans, and Test Results
• Involved to support business users in live
• Designing interfaces and integrations between modules in Oracle EBS
• Code Reviews for Vendor and Vendor Management
• Designed and developed reports using combination of Report 10g and XML publisher for modules like Purchasing and Order management
• Documented the training material, requirement gathering(RD20),setups (BR100) AS-IS, TO-BE (BP80)documents
• Enhancement on Forms, Performance tuning on Forms, Reports and PL/SQL
• Implemented several custom logics for Form Personalization using ZOOM Functionality
• Developed the programs for SOA to get the readings from Machines
• Worked on Unit/Functional Test ofCRM like Install Base, Service Contracts, Field Service, while developing the customized pages
• Technical analysis of existing RICEW components of existing components functionality
• Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher
• Customization and Development of forms, workflows and worked on Forms Personalization
• Worked on Oracle Reports & Discoverer reports to support based on user requirement
• Development of custom interfaces using Oracle standard TCA APIs including DQM rules
• Fully involved in CRM conversions for Migration & developed custom packages for migration
• Developed PL/SQL Procedures to convert data in custom tables to service contracts using APIs
• Developed conversion programs for Employee, Supplier, Items Masters, Service Contracts and Service Requests
• Design and Development of Contract Inbound Interface for Oracle Service Contracts (SC) & Oracle Service Requests(Field Service & Depot Repair)
• Procure to Pay (P2P) and Order to Cash (O2C) Validations
• Experience in customizing oracle workflows such as the PO approval process, Order/Line Flow to send user notifications based on the business requirement
• Developed program to import Orders and Customers to Oracle through Oracle API Order & Customer Import
• Customized the Invoice Aging Report to display only not paid Invoices with invoice status should be approved
• Customized Invoice History Report by adding few more details related to Bank details
• Extensively used TCA (Trading Community Architecture) to create customers in Oracle Receivables
• Involved in Journal Import with validations
• Design, debug, code and maintain Oracle APEX application
• Develop Oracle Application Express solutions to enhance the usability and adoption of the Analytics and Reporting Central application
• Customization ofOAF pages, extensions, personalization and creation of new OAF pages
• Design & developed UI components using ADF Rich Faces and worked with ADF View Criteria’s, LOV’s & Testing
• Worked on GL interfaces for balances Conversion, SQL, PL/SQL, stored procedures and packages
• Creating and Registration of Procedures, Concurrent programs and Reports through AOL
• Designed and implemented custom Summary Billing Utility in AR with integration to TCA and Receivables
• Designed and customized the following reports using Oracle Reports Builder 10g in OM and Service Contracts:

Confidential

Oracle Applications Techno Functional Consultant

Environment: Oracle Applications 11.5.10, Oracle 9i (SQL & PLSQL), Oracle Developer 2000, Work Flow& OAF.

Responsibilities:

• Application consultant and Hands-on Team Lead
• Development of technical design and installation documents
• Documentation for Unit Test Scripts, Test Plans, and Test Results
• Coordinated with key users and other key staff to resolve issues
• Helped users to establish month-end procedures for closing
• Involved fully on migration and production support
• Involved in the post go-live support
• Designing interfaces and integrations between modules in Oracle EBS
• Worked on Custom API’s in PL/SQL (Business Logic)
• Inventory Outbound Interface Program to extract the inventory item data from base tables to flat file using UTL FILE package
• Developed a program to load external data from legacy system into PO HEADERS INTERFACE and PO LINES INTERFACE
• Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system
• Developed a program to inactivate the vendors
• Supported AP Supplier Conversions (Vendors, Vendor Sites and Vendor Contacts) and Invoice Conversions using AP Interface Tables, PL/SQL packages, API’s
• Technical analysis of existing RICE components of existing components functionality
• Customization and Development of forms and workflows and worked on Forms Personalization
• Worked on Oracle Reports to support based on user requirement
• Development of custom interfaces using Oracle standard TCA APIs including DQM rules
• Fully involved in developed custom programs to support to user requirement in both CRM and SCM
• Developed conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs
• Procure to Pay (P2P) and Order to Cash (O2C) Validations and Form Personalization
• Conversion and reconciliation of Legacy AP Invoices and Payments into Oracle Applications
• Designed and developed Payables interface import program and interface tables to load invoices from the legacy systems into the oracle payables base tables
• Scheduled various concurrent programs and reports to run on a specified time daily without interfacing other standard programs using System Admin Responsibilities
• Creating and Registration of Procedures, Concurrent programs and Reports through AOL
• Support to modify Work Flows and Oracle Application Framework (OAF) based on business requirements

Confidential, Sterling, VA

Oracle Applications Techno Functional Consultant

Environment: Oracle Applications 11.5.9, Oracle 9i (SQL & PLSQL), Oracle Developer 2000 and ADF.

Responsibilities:

• Worked as Techno Functional Consultant
• Gathering and analyzing user requirements and interacting with onsite team and business users
• Day to day status track of issue logs
• Involved in the project meetings to define/direct project goals and objectives
• Architecting and developing customer specific solutions
• Design, Code, Test and code review Preparation of test scenarios/cases for all technical components bases on functional designs
• Quality Control and Quality Assurance
• Involved in the post go-live support
• Developing PL/SQL code to obtain the required functionality
• Worked on Custom API’s in PL/SQL (Business Logic)
• Involved in setup and implementation of Service Contracts depending on functional setup
• Customized Item Instance Query Report in Install Base IB using Template.fmb
• Involved in Field Service Setups for CRM Foundation, Install Base IB, and Service Contracts SC
• Worked on enhancements of Customer Facing Document Reports in Quoting and Service Contracts SC
• Customized and developed the forms and reports based on requirements
• Developed custom programs to interface the data into service contracts tables using Standard APIs
• Developed ADF Data Controls from Web Services & User Interface components using ADF Rich Faces
• Creating and Registration of concurrent programs, forms and reports through AOL
• Responsible for new development and change requests
• Customization and Development of forms and workflows

Confidential, Arlington, VA

Senior Consultant and Hands on Team Lead

Environment: Oracle Applications 12.1.3, Oracle 10g (SQL & PLSQL), Oracle Developer 2000, Oracle APEXWork Flow and OAF.

Responsibilities:

• Study and analysis of business process design document and involved in preparation of functional specs and technical specs documents
• Worked with the client team to understand the current Business Process
• Technical analysis of existing RICEW components of existing components functionality
• Resolving issues On Priority Basis and providing support to the end users
• Preparation of test scenarios/cases for all technical components bases on functional designs
• Developed test plans and scripts and conducted testing for quality assurance
• Involved in the post go-live support
• Custom API’s using PL/SQL (Business Logic)
• Order to Cash (O2C) Validations
• Developed Interface for the Standard Items of Sales Orders Import in OM
• Involved in the Functional setup of Order Management (OM), Inventory (INV) modules
• Customized the Sales Order Invoice Detail Report in Order Management
• Oracle Application Express APEX development
• Customized Pack Slip report, Shipping, Back Order Report and Freight Carrier Listing Report in OM
• Customization and Development of forms and workflows
• Involved in Developing and deploying Oracle reports& Discoverer Reports10g
• Registered Procedures, Forms and Reports in Oracle Apps

Confidential

Software Engineer

Environment: Oracle Applications 12.1.1, Oracle 10g (SQL & PLSQL), Oracle Developer 2000, Work Flow,, Oracle APEX OAF, Oracle Discoverer 10g, XML Publisher 5.6.

Responsibilities:

• Gathering and analyzing functional requirements and In-depth understanding of the client's business processes and business needs
• Interacting with onsite team and business users and architecting and developing customer specific solutions
• Technical analysis of existing RICEW components of existing components functionality
• Involved in Journal Import with validations
• Prepared Technical Documents, Unit Test Scripts, Test plans and Test results
• Design, Code, Test, code review and preparation of test scenarios/cases for all technical components
• Quality Control and Quality Assurance
• Involved in the post go-live support
• PO conversions using Interface
• Worked on Oracle Reports, Discoverer and XML Reports
• Developed many PL/SQL blocks for the forms validation and to obtain the required functionality
• Prepared Technical Documents, Unit Test Scripts. (MD.070, MD.120)
• Customized existing Oracle Reports in Inventory Module (INV), Pricing using Reports 10g
• Worked on OA Framework personalization and extensions
• Procure to Pay (P2P) and Order to Cash (O2C) Validations
• Responsible for Order import using Order Management OE ORDER PUB API to update sales order into respective base tables
• Creating and Registration of concurrent programs, forms and reports through AOL
• Developed outbound interface to extract supplier details data including Payment details with Check for a wide range of dates using UTL FILE Package
• Involved to Developing and deploying Oracle & Discoverer Reports10g
• PO Requisition, Open PO and PO receipt conversions using Interface
• Developed a conversion program to convert Fixed Assets from legacy system to oracle Fixed Assets (FA)
• Involved in developing open interface to transfer the data from Oracle Payables to base tables of Fixed Assets (FA)
• Developed Vendor conversion program to import vendors from the legacy system into Oracle with required validations
• Designed and developed custom program to interface daily all invoices from different systems into AR using Auto invoice, with validation and audit report
• Custom report to list PO-s waiting for Approval (related to PO Approvals) for 'X' days
• Custom Report on PO-s that are cancelled after 'X' days of creation
• Developed Order Status Summary Report to provide the status of orders in the system for given time period
• Developed XML reports in AP, AR, and OM
• Purchase Orders pending report showing how many orders were pending beyond their promised date (0-7 days, 7-30 days, above 30days)

Confidential, Somerset, NJ

Software Engineer

Environment: Oracle Applications 12.0.6, Oracle 10g, Oracle Developer 2000, Work Flow, Shell Scripting, OAF, Discoverer 10g, XML Publisher 5.6.

Responsibilities:

• Gathering, study and analyze requirements from client and interact with offshore team
• Interact with Business Analysts and business users for clarifications to resolve issues
• Ensured that all Oracle and specified development standards were met
• Responsible for delivering technical programs and design documents as per functional requirement
• Handled the tasks of supporting testing and solving testing issues
• Involved in End-to-End Developing the Discoverer Reports
• Involved in Post Production support
• Upgrading of R11i reports to R12
• Customizing seeded reports in R12 based R11i customization
• Designing and developing oracle reports, XML data template, RTF templates
• Raising SR with oracle, following them and closing them
• Production support for the business
• Documented all the work done for future reference
• Creating the scripts for executable and concurrent programs for interfaces and custom reports
• Developing SQL *Loader control files to transfer data from flat files to pre interface tables
• Developed some adhoc reports using discoverer according to the client requirement
• Worked on Purchase Orders conversion.
• Responsibilities involved configurations, data mapping using SQL*Loader to import legacy Suppliers into Oracle
• Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, forms and reports
• Customized the Print Purchase Order Report based upon user requirements and added bitmap image of company logo to the report
• Developed a new report to get users who have Purchase order and requisition open and are out of the company
• Worked on Open Item Interface to convert Purchased Item Information from Custom Purchasing System to Oracle INV module
• Customized Invoice Register Report by appending additional columns like invoice terms, supplier site promotions cost and descriptive flex field information
• Prepared User Requirements document (URD) for Data Migration from legacy to Oracle Apps
• Responsible for following the development standards as per the project
• Maintaining good communication channel with the onsite and offshore team
• Post-Production implementation support of enhancement and customizations
• Resolved QC and UAT bugs

Confidential, Mahwah, NJ

Software Engineer

Environment: Oracle Applications 11.5.10.2, Oracle 9i (SQL & PLSQL), Oracle Developer 2000(Forms 6i & Reports 6i), Discoverer 10g, XML Publisher 5.6.

Responsibilities:

• As a Team member interact with Team lead and Manager for requirements
• Study the Functional Design Documents (MD 050) for requirement and gathered requirements from Client
• Study the Requirements and interact with Onsite Business Analysts and business users
• Responsible for developing the assigned RICE components
• Testing the developed components with front and Applications
• Involved in customize the Product
• Performed System Study, Design, Development and Implementation of the system
• Developed custom reports, discoverer reports and registered with Oracle Applications
• Customization of standard reports in different modules
• Created different types of value sets
• Customized Reports in OM and inventory
• Worked on different kind of concurrent programs like SQL*Plus, PL/SQL
• Extensive use of PL/SQL programming like Procedures, Functions, Triggers & Packages and Used Dynamic SQL in stored procedures
• Involved in preparation of Technical Design Documents based on Functional Design Documents
• Fixing Bugs in Forms and Reports previously designed
• Development of screens in forms using oracle at backend according to the requirements of Clients
• Registration of reports using AOL script
• Designing the Technical Documents for the Assigned Components
• Testing with available data in the modules like Purchasing and Inventory
• Involved in testing of components, which peers developed