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.

PROFESSIONAL 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, 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, Java 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, 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.

Software: 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 .

Solutions: INV, PO, AP, OM, AR, Advanced Pricing, iSuppliers, iStore, GL, EBS Tax (ZX) & CRM

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 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 Web methods.
• 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.

Software: 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.

Solutions: INV, PO, AP, OM, AR, Advanced Pricing, iSuppliers, iStore, GL, EBS Tax (ZX), Install Base, Service Contracts & Service Requests.

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
• Invoked standard API's within custom packages for creating and updating Customer, Sites and Contacts
• Imported new, changed and completed sales orders from legacy system to oracle using order 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 running GL Balances Import
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Developed an outbound interface for open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts, etc.,
• Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support
• Developed Dash Boards, Pages for custom interfaces using Oracle APEX
• Developed Reports for Service Requests Summary and Details in Date Ranges
• Written an API for Converting Resources/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
• Developed program to load external data from legacy system using SQL*Loader and Oracle APEX into AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE Interface Tables
• 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 in Account Receivables (AR)
• Used Custom PL/SQL API’S for converting Customers using TCA, Open AR Invoices, Open Purchase Orders from legacy system to Oracle

Confidential

Senior Oracle Applications Techno Functional Consultant.

Software: 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.

Solutions: INV, PO, WIP, BOM, AP, OM, AR, GL, HRMS, iProcurement, iReceivables, iStore and CRM (Install Base, Service Contracts & Service Requests).

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
• Identifying functional and technical gaps and adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion
• 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 of CRM 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
• Developed the Service and Contracts (SC) parts of the Population Report, monitored the report performance and handled data issues like missing contracts, invalid contract end date, null territory id
• 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 of OAF 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 and Hands on Team Lead at offsite.

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

Solutions: INV, PO, AP, WIP, BOM, OM, AR, GL, HRMS and CRM (Install Base, Service Contracts & Requests, Customer Care & Billing).

Responsibilities:

• Application consultant and Hands-on Team Lead
• Interacted with business owners, functional consultants and subject matter experts effectively to understand business requirements, functional designs, process flow and data flow
• 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
• Developed various Custom reports, Customized existing reports (PO Purchase Order, Releases Detail & Purchase Requisition Status Report) according to the functional specifications using Reports 6i & XML publisher
• 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 and Hands on Team Lead.

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

Solutions: OM, AR, GL, Install Base, Service Contracts, Service Requests, Contact Centre, Customer Care & Billing.

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 Changes/enhancements
• 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.

Software: Oracle Applications 12.1.3, Oracle 10g (SQL & PLSQL), Oracle Developer 2000, Oracle APEX, Work Flow and OAF.

Solutions: INV, OM, iStore, AR and GL.

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
• Developed many reports like Pick Slip, packing Slip, Mailing Label for Shipping and Orders by Item, Order Detail & Summary Reports for Order Management (OM) and also created new reports as per client requests
• 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.

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

Solutions: INV, PO, WIP, BOM, AP, OM, AR, FA, CM, GL and HRMS.

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
• Developed an inbound interface for open Payable Invoices, Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts, etc. from legacy system to Payables
• 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
• Customized seeded reports such as Invoice print report, Commercial Invoice, Customer Invoice report, Print Selected Invoice, transaction detail report, Account Status report in AR
• 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.

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

Solutions: INV, PO, AP, WIP, BOM, OM, AR and GL.

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.

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

Solutions: INV, PO, AP, WIP, OM, AR and GL.

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
• Worked on Purchasing Documents Open Interface to import Standard PO, Blanket PO into the PO Module using SQL*Loader and UTL file in PL/SQL
• 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