SUMMARY

• Having 10+ years of experience as a Techno Functional Consultant in Implementation, Upgradation and Customization of Oracle EBS 11i/R12.
• Commendable experience in Complete Project Life Cycle Implementation involving design & development, Systems configuration & data migration, User training and Documentation.
• Expertise in SCM (PO, INV BOM, WIP and OM) and Financial modules (AP, AR and GL)
• Extensive experience in design and development of Data Conversion Programs, Interfaces, validation programs, Data Extract, Dynamic Insertion, Data manipulations, customizing forms, reports, Alerts and workflows using PL/SQL, UTL FILE, Oracle Internet Development Suite (Forms & Reports 10G/9i/6i), Discoverer, Oracle Workflow Builder, Shell Scripts, PL/SQL Advanced Techniques, SQL, TOAD, XML/BI Publisher and other software tools.
• Proficient in Designing Relational Data Structures, writing Stored Procedures, Packages and Functions using PL/SQL, SQL.
• Expert in Custom Form Development from scratch, Form Personalization and customization using CUSTOM.PLL.
• Experience in building applications, extending and personalizing pages using Oracle Applications Framework (OAF).
• Experience in working on cross functional modules in the environment of Procure - to-Pay (P2P) and Order-to-Cash (O2C) Cycles.
• Performed requirement study, FIT-gap analysis, development, tuning, and user testing and production support of RICE (Report, Interface, Conversion and Extension) elements with AIM documentation.
• Expertise on designing and implementingOracle AlertsandLookups.
• Proficient in System Administrator activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Involved extensively in preparing test scripts, migration scripts and change management scripts as per the requirements.
• Expertise in Performance Tuning of Queries, Reports and high-volume transaction processing.
• Expert in developing Functional and Technical design documents (MD50/MD070), Test documents (TE020), Conversion (CV40/CV050) and Migration documents (MD0120).
• Strong understanding of Agile Project Management using Scrum Framework by utilizing the CA Technology - Rally tool to support upstream and downstream teams throughout SDLC.
• Created service requests(SRs) and follow up, conducted Oracle Web Conference (OWC) with Oracle for speedy resolution for all high prioritized issues.
• Used version control, change management and migration tools like CVS, PVCS, Kintana and HP PPM. Also, used Project Portfolio Management tools like HP Quality Center(QC) and training & learning tools like Oracle User Productivity Kit (UPK).
• Worked extensively in onsite-offshore models for all projects following strict timelines.
• Excellent interpersonal, communication skills and understanding of Business applications.

TECHNICAL SKILLS

Oracle ERP: Oracle Applications/Oracle E-Business Suite 11i (11.5.10.2)/ R12(12.1.1, 12.1.3)

Modules: Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets, (FA), Cash Management (CM), Purchasing (PO), iProcuremnt, iSupplier, iExpense, Inventory (INV), Order Management (OM), Work in Process (WIP), Bill of Materials (BOM), ASCP, AOL, Sysadmin and others.

Programming Languages: SQL, PL/SQL, J2SE,J2EE, HTML and Java Scripts

Database: oracle 9i/10g/11g

Operating System: Windows NT/2000/XP, UNIX, LINUX

Tools: & Utilities: Report builder(6i/9i/10g), Discoverer 11g(11.1.13.0), SQL*Loader, Workflow Builder, XML/BI Publisher, OBIEE, ADI, SQL* PLUS, Shell Scripting, MS office

Configuration and FTP Tools: WINCVS, PVCS, Integra, WINSCP, FileZilla and Core ftp

PROFESSIONAL EXPERIENCE

Confidential - Jacksonville, FL

Oracle Techno functional consultant

Responsibilities:

• Responsible for production support, bug fixing, enhancements and actively support month-end close activities.
• Developed and customized RICEW objects (reports, interfaces, workflows and forms) in various application modules including GL, AP, AR, CM, FA, OM, BOM, WIP, INV, PO and ASCP
• Worked closely with users in gathering the requirements, design and development for end users
• Enhancement of Critical Interface for Order Management. The data records need to be imported from Centerpiece ERP to Confidential -Aviation via WebMethods
• Developed a GL interface module using SQL LOADER for data loading for preprocessing of data used PL/ SQL and for integration with Oracle Applications developed UNIX shell scripts to import Journal entries from external source
• Developed Payables Open Interface Import Program to load invoices from multiple sources like legacy invoices into AP in a periodic basis and designed a report using XML/BI Publisher
• Used SQL*Loader to import receipts data into AR Payments Interface table after defining Lockbox, and running Lockbox interface form transferred data into Oracle Receivables
• Worked on Customer Ship to Address OAF page to make accounting flex field as required
• Worked on Supplier OAF page to add DFF
• Personalized Customer OAF page to make demand class field as required
• Customized Colour of the items using CSS class in Oracle Applications Framework (OAF)
• Personalized Customer OAF page to add custom tips
• Developed and customized RTF/XML Templates for various BI Publisher Reports in across the modules
• Tuned the SQL Scripts to improve performance which are taking longer time
• Provided measure and Weekly Operation Metrics (Weekly Rhythm) progress on deliverables to stakeholder on regular frequency
• Working in Agile model - Daily Scrum, creating user stories and updating weekly status as part of retrospective meeting
• Created Service Requests (SR’s) and prioritized as SEV2 and SEV3 and conducted Web Conference to resolve the high priority issues
• Developed interfaces from ERP side to help Demantra implementation team
• Involved in troubleshooting issues including creation of oracle service requests and conducted quality reviews of code developed by other development staff
• Involved vigorously in Migration team to Migrate AOL, File based objects from one instance to another instance using HP PPM Migration tool and through FNDLOAD scripts
• Communicating with offshore team and ensuring Delivery with quality with in required time

Confidential

Oracle Techno functional consultant

Responsibilities:

• Involved in Full-Cycle Implementation and responsible to prepare and present conversion strategy with business partners
• Prepared functional specifications based on user requirements
• Prepared technical specifications based on functional requirements
• Prepared and executed test scripts based on functional documents
• Responsible for the functional configuration of Purchasing and OM modules with the co-ordination of the project team and end-users
• Implemented Procure to Pay (P2P) and Order to Cash (O2C) business flow successfully
• Create and maintain Functional and Technical design documents for data migration
• Developed Master and Transactional data conversion entities using PL/SQL and SQL*LOADER utilities
• Master: Item, Supplier, Customer, Employee, ASL and BOM
• Transactional: AP Invoices, AR Invoices, AR Receipts, Journals, SO, PO, Item on hand, Sourcing Rules, BPA, Item categories, Item cross references, wip transactions and Item costs
• Executed successfully all conversions as part of cutover and get the sign off from users after reconciliation
• Responsible for design and development Custom components (Interfaces and reports) as per the business requirements
• Involved in troubleshooting issues including creation of oracle service requests and conducted quality reviews of code developed by other development staff
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements
• Provided support in raising Service request(SR), applying patches and problem-solving
• Performed debugging of the applications and helped team members in troubleshooting and debugging.
• Involved vigorously in Migration team to Migrate AOL, File based objects from one instance to another instance using HP PPM Migration tool and through FNDLOAD scripts
• Provided post go-live and post implementation support.

Confidential

Oracle Technical consultant

Responsibilities:

• Worked on the project which involved the up gradation of Oracle Applications 11i to Oracle Application R12 and Involved in following modules AP, AR, FA, CM, GL, DTR, IB, OM, BOM, WIP, QUALITY, PLM, ASCP and INV
• Review and analyze existing application customizations and extensions. Develop strategies for leveraging out-of-box functionality to develop and enhance Oracle EBS applications
• Worked on preparing test scenarios, test scripts on different applications to help the users for better understanding the application
• Identified objects (interfaces, form personalization’s and custom objects) to modify as per the R12 requirement
• Customize and convert existing RDF and XML/BI Publisher reports that will run compatible as per the new multi-org structure and user requirement
• Developed and customized Oracle seeded reports in Order Management and Shipping. Reports were generated for Pick Slip, Pack Slip, Purchase Order and Shipping Label
• Redesigned and modified various custom codes developed in 11.5.10.2, to work with R12.1.3 applications including, Manual Transaction Workflow, Ship confirm and Delivery detail identification, Drop ship process to block Sales Order Changes, etc.,
• Actively involved in Functional and Technical Design for new interfaces
• Extended OAF pages as per the requirements to map the gap from 11i to R12
• Involved in Pre-upgrade and Post-upgrade activities as per the cutover plan
• Involved in troubleshooting issues including creation of oracle service requests and conducted quality reviews of code developed by other development staff
• Involved vigorously in Migration team to Migrate AOL, File based objects from one instance to another instance using HP PPM Migration tool and through FNDLOAD scripts

Environment: Oracle Application 11i/R12.1.3 BOM, WIP, OM, INV, PO, AP, AR, DTR, IB, PLM, FA, CM, ASCP and GL, Oracle 11g, Discoverer 10g, Report Builder 10g, PL/SQL, SQL *PLUS, SQL*Loader, SQL Developer, Windows 2007, XML Publisher, Linux x86.

Confidential, Dallas, TX

Oracle Technical consultant

Responsibilities:

• Involved in Requirement analysis, Design and Develop custom application in OAF. This include analyzing MD50 (Functional Design Document) and then writing MD70 (Technical Design Document)
• Development of custom self-service pages using the Oracle Application Framework(OAF)
• Making the self-service pages to access anywhere within Oracle EBS
• Consolidating multiple AR Invoice/Receipts images into a single PDF
• Sending email/fax the PDF as single attachment
• Developed OAF Extensions on iExpense and Customer pages
• Writing Unit Test cases and testing after completion of the Object
• Prepared documentation and end user training documents for future reference
• Log, monitor, and follow up on service requests (SRs) - Oracle Support
• Responsible for designing, developing, unit testing, implementing and maintaining the custom extensions for Oracle Applications
• Involved in troubleshooting issues including creation of oracle service requests and conducted quality reviews of code developed by other development staff
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements
• Involved vigorously in Migration team to Migrate AOL, File based objects from one instance to another instance using FNDLOAD scripts
• Actively involved in all phases of the Software Testing like Analyzing System Requirements, Test Strategy, Test Planning, Test Case Design and System Testing

Environment: Oracle Application R12.1.3, OM, INV, PO, iProcurement, iSupplier, iExpense, AP, AR and GL, Oracle 10g, PL/SQL, SQL *PLUS, SQL*Loader, SQL Developer, Windows 2007, XML Publisher, Linux x86.

Confidential, Jacksonville, FL

Oracle Technical consultant

Responsibilities:

• Actively involved in day-to-day support activities for OracleEBS R12 FinApps Multi-Org stream by troubleshooting, providing solutions and communicating with the users through Support tickets.
• Analyzed user requirements, functionalities and mappings within the PO, INV and OM Modules
• Prepared test scripts and conducted unit and integration testing
• Attended weekly and monthly review meetings with business partners on ticket inflow and new projects
• Preparation of estimations for project execution/deliverables
• Delivery of solutions with high quality as per the project schedules
• Design and developed INV, PO and OM Reports
• Customized Oracle Reports to get output in excel format
• Developed PO Utility custom form
• Personalized PO Requisition form
• Personalized OAF page in isupplier
• Customized View Object and Controller OAF page using jDeveloper in iProcurement
• Customized Supplier Registration Workflow
• Taking care of all functional issues and setups
• Raised Service Requests (SR) and worked with oracle to resolve the issues.
• Providing Maintenance and 24/7 on call support for the applications and maintained the system stability
• Involved vigorously in Migration team to Migrate AOL, File based objects from one instance to another instance using Integra Migration tool and through FNDLOAD scripts.
• Developed UNIX Shell scripts to archive inbound/outbound files and report outputs
• Day to day status track of issue logs

Confidential

Oracle Technical consultant

Responsibilities:

• Developed Technical Design Documents as per the Client coding standards & Project Quality plan.
• I have involved in developing the interface between Oracle AR Cash Receipts and Mainframe RMS for Confidential Transportation
• Developed Account Receivables Auto Invoice Conversion and Interface programs
• Developed Lockbox preprocessor interface and conversion program
• Developed Auto Receipts Outbound and inbound program
• Developed an extract with Receipt Detail
• Developed Report Builder/XML/BPA Reports
• Developed the Aging file extracts and send it to a UNIX path as mentioned by the user requirements
• Provided technical bug fixes during User Acceptance testing on the interfaces developed
• Provided functional support in Account Receivables for the customizations developed during User testing
• Development/modification of SQL scripts and PLSQL programs for project requirements as part of project implementation
• Log, monitor, and follow up on service requests (SRs) online- Oracle Support
• Involved in of Pre-PROD/PROD migration cutover plans
• Provided post production Go-Live support for the issues reported by users

Environment: Oracle Application R12.1.3, OM, INV, PO, iProcurement, iSupplier, iExpense, AP, AR and GL, Oracle 10g, PL/SQL, SQL *PLUS, SQL*Loader, SQL Developer, Windows 2007, XML Publisher, Linux x86.

Confidential

Oracle Technical consultant

Responsibilities:

• Designed and Developed Staging tables, Data Conversion SQL *Loader Program and Custom PL/SQL to import Sales orders from legacy system
• Resolving Period Closing and Regular issues with matching and hold in Order Management
• Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs
• Designed various custom codes developed in R12.1.1 applications including, Manual Transaction Workflow, Ship confirm and Delivery detail identification, Drop ship process to block Sales Order Changes, etc.,
• Created various Business areas, Folders, Item Classes, Hierarchies, Workbooks, Worksheets for Financials and Order Management (OM) modules
• Developed UNIX Shell scripts to FTP the Flat file from External Server to Oracle UNIX Server location Automated the process of encrypting and archiving
• Use a concurrent program to execute a PL/SQL stored procedure to call standard Receipt creation API to create receipts and apply it to the Invoices
• Customized Reports like the Order Summary Report, Pick Slip Report and Packing Slip Report in Order Management using XML/BI publisher
• Used FND LOAD extensively for downloading LDTs for form personalization migration to TEST, UAT and production environments
• Preparation of SQL *Loader Control Program and PL/SQL script with validation to upload data from flat file to oracle Applications base tables
• Worked on Workflow Business Events for triggering the email procedure whenever the Concurrent program completed with normal status
• Trouble shoot issues with run time performance of the reports and use lexical parameters and bind variables wherever required to improve the performance
• Involved in Testing in Various Phases like Unit, SIT, UAT Testing's
• Provided post production Go-Live support for the issues reported by users.

Environment: Oracle Applications 11i/R12.1.1, Account Payables (AP), Account Receivables (AR), Order Management (OM), TCA, AOL, Reports 10g, Forms 10g, UNIX, XML Publisher, Work Flow, Oracle10g, SQL, PLSQL, TOAD.

Confidential

Oracle Technical consultant

Responsibilities:

• Creating the SQL*Loader control programs and PL/SQL validation procedures to execute along with Auto Invoice Interface, Journal Import Interface, Vendor Conversion supporting the business requirements
• Involved in setup and customization ofOraclePayables and data conversion from legacy system into OraclePayables
• Development of Master items update interface program
• Developed various Customized reports in AP, AR, PO, OM and INV Reports
• Customized AR Invoice Report and other reports using XML Publisher
• Writing UNIX Shell scripts and commands for file management and job automation tasks
• Defined AOL Objects like registered concurrent program, request sets etc.,
• Development/modification of SQL scripts and PLSQL programs as per the project needs and as directed
• Followed MD50 functional documents and written the technical (MD70) specifications, provided support for end users and documented the modifications
• Developed scripts to fix the bugs in production system
• Gave Support for the developed components after implementing in production and fixed the issues that were discovered.

Environment: Oracle Applications 11.5.10.2, AP, AR, GL, PO, OM, INV, AOL, Reports 6i, Forms 6i, UNIX, XML Publisher, Oracle9i, SQL, PLSQL, SQL Developer.