SUMMARY

• Over 9+ years of experience in Design, Development, Conversion, Customization, Interfacing and Implementation of business applications using EBS Oracle Applications R11i/11.0.x/R12.
• Extensive experience in Project Life Cycle including requirement gathering and Analysis,
• Good experience in Database design, Database development, Application development, documentation, Test and Support.
• Have completed 3 implementations for Oracle Applications Modules (OM, iStore, Quoting, Configurator), SQL, PL/SQL, Java J2EE, (XML) publisher.
• Very good experience with Order - to-Cash
• Extensive experience in Oracle 10g/9i/8i and hands on experience writing Oracle SQL queries and Oracle PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors and using latest features to optimize performance (Bulk Collects, Collections, Ref Cursors, Materialized views, Global Temporary Tables).
• Strong experience in all kinds of AOL objects, defining Logical Apps rules, defining Oracle Business Events and subscribing to them
• Technically proficient in RICE (Reports, Interfaces, Configuration, Enhancements) methodologies in Oracle Supply Chain, Oracle Financials.
• Experience in preparing AIM documents (MD50, MD70, MD120) during development and support and designing data/process flow diagrams using VISIO.
• Experience in all phases of life cycle right from Planning, Requirements Gathering to Production support.
• Proficient in writing and tuning complex SQL statements, complex joins co-related sub-queries and SQL statements.
• Experience in tuning application using tools like Explain Plan, SQL*Trace and TKPROF for high efficiency.
• Experience in writing dynamic SQL statements using EXECUTE IMMEDIATE and DBMS SQL.
• Experienced in developing batch programs by using PL/SQL and shell scripts and in using SQL*Loader for loading data from flat files into Oracle tables.
• Extensively worked with third party database tools like TOAD, SQL Navigator, SQL*PLUS, Jdeveloper.
• Strong programming, debugging and problem solving skills and ability to translate customer requirements into technical solutions by utilizing business insights.
• Ability to work within an aggressive and demanding project schedule and environment.
• Excellent team player with strong analytical, presentation, and problem solving skills.

TECHNICAL SKILLS

Oracle Application Modules: Oracle Application Order Management, Configurator, Quoting, eContracts, eLicence (technical), iStore (technical & Functional)

Languages / RDBMS: PL/SQL, Java, JSP, Action Script 2.0, XML, HTML Oracle 11g/10g/9i/8i

Tools: PLSQL Developer, Toad, Mercury IT Governance (Kintana), Oracle J-Developer, Flash, RWD, MS-Word, Tomcat 5.5

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Oracle Apps Techno Functional

Responsibilities:

• Develop, test, maintain and support customizations to Oracle E-Business Suite, PL/SQL code, UNIX shell scripts, OAF, ADF
• Perform technical analysis and development on multiple moderate to large projects concurrently
• Participate in technical and functional group discussions and code reviews
• Provide technical expertise and support to line of business
• Write clear technical design documents based on analysis of business requirements
• Understand and follow corporate SDLC standards and release management standards

Confidential, Charlotte, NC

Oracle Apps Techno Functional

Responsibilities:

• The program aims to do away with the current architecture involving Oracle Apps 11i and legacy systems.
• Study the legacy systems and understand the business processes. Solution the business processes in Oracle R12 environment by maximum utilization of standard Oracle features.
• Customer Requirement Study, Preparation of Development Requirements from customer requirements
• Worked on various iStore customizations like custom ATP form, background order creation process, providing various item type information in Direct Item Entry, Adding new address type checkout process, backlog report, advanced order search
• Worked on OM interfaces like Creating Promotion in Oracle, Item Creation, Validation & adding it to Price list, Outbound interface to send Salespersons data from Oracle, Order Management Defaulting Dependencies Extension.
• Worked on the XML Publisher reports to send Configurator Model Report in xls Format
• Major role in developing MD70, core development and preparation of MD120 for several modules
• Involved in analysis and development of major conversions and interfaces
• Participations in the code reviews and Technical design reviews in across all the modules.
• Performed unit testing and coordinating for CAT testing and fixing the issues
• Used SQL*Loader, UTL FILE package and External Table concepts for loading data into the database tables through an automated process.
• Analysis, design and development of Database procedures, functions and packages using PL/SQL as per the business process.
• Involved in Optimizing SQL queries involving large tables.
• Logging service requests with Oracle and working with Oracle to resolve Applications Software defects.
• Providing assistance in coordinating and troubleshooting with different side system developers and business owners for side system interface application support.

Environment: Oracle Applications R12, Procure to Pay ( PTP), Oracle Order Management(OM), Inventory, Oracle General Ledger(GL), Account Receivables(AR), Account Payables(AP), PL/SQL, Workflows, XML Publisher, Advanced Pricing

Confidential, Schaumburg, IL

Oracle CRM Techno-Functional

Responsibilities:

• Worked as a functional / technical SME and Systems analyst with the business users, stake holders, and marketing personnel across the world to identify and solidify key requirements for an R12 iStore implementation, a transformation from their existing legacy system to Oracle ERP solutions.
• Worked with the functional and business analysts and testing teams to prepare the customer requirements, business requirements MD50 / MD70 and BR100 documents.
• Supplied architectural design, mentorship, and development expertise to Confidential portal and oracle CRM modules and custom modules.
• Assumed ownership of the project initiative, and guided the various teams involved through implementation, testing, and into production.
• Worked with appropriate OM / Inventory / Pricing / Receivables teams to setup appropriate touch point system setups and components.
• Developed architecture designs, UAT user guides, test matrixes, and code.
• Worked with the various Confidential engaged offshore and onshore developers to successfully design and develop the Confidential approved UI, functionality and performance effective store.
• Provided several pilot technical solutions to fulfil the client requirements while staying within the realm of oracle CRM and TCA architecture including functional enhancements, user reports, UI enhancements, integration with legacy support systems.
• Developed a spinoff of the application to be used by the client sales personnel on their iPads and assist the end users effectively by being able to track, price or even create orders on the fly using Oracle ADF framework..
• Worked with the DBA teams across the world to make them understand about the various R12 server setups and tweaks.
• Successfully lead the team to completed, UAT, CAT and Production release with minimal bugs and effectively provided production support across various browsers and devices such as iPad, Zoom, Kindle.
• Worked with the client engaged RUN teams to make them technically and functionally capable of handling the application and its extensions.
• Provided a roadmap for future extensions and enhancements with all supporting artefacts.
• Service Suite (iSupport, Install Base, Service Contracts, Depot Repair)
• Perform a feasibility study for implementing Oracle CRM Service suite to replace the existing legacy system across Asia Pacific, Europe and American regions.
• Conduct an exploratory analysis of the legacy system functionality and map it to Oracle suite.
• Configure and setup Oracle service suite of modules and document the process within BR100.
• Work with the business process owners to chalk-out an end-to-end solution for the implementation.
• Prepare the traceability matrices across various requirements to provide a track for the management team to monitor the progress of the requirements.

Environment: ORACLE Applications R12,Oracle iStore, iReceivables, TCA, Oracle iSupport, Oracle Service, Oracle Service Contracts, Oracle Install Base, Depot Repair, Advanced Pricing, Inventory, Order Management, Tesseract etc.

Confidential, Davidson, NC

Oracle Apps Technical

Responsibilities:

• Goal of the program was to implement Oracle iStore for the Oracle Apps 11i system.
• Oracle iStore provided a way, to make the ordering process easier for end users because of its sophisticated web-based architecture.
• Deployed over 30 custom iStore components, automating the Order Process.
• Worked with the functional and business analysts and testing teams to prepare the customer requirements, business requirements MD50 / MD70 and BR100 documents.
• Supplied architectural design, mentorship, and development expertise to Confidential portal and oracle CRM modules and custom modules.
• Assumed ownership of the project initiative, and guided the various teams involved through implementation, testing, and into production.
• Worked with appropriate OM / Inventory / Pricing / Receivables teams to setup appropriate touch point system setups and components.
• Developed architecture designs, UAT user guides, test matrixes, and code.
• Worked with the various Confidential engaged offshore and onshore developers to successfully design and develop the Confidential approved UI, functionality and performance effective store.
• Provided several pilot technical solutions to fulfil the client requirements while staying within the realm of oracle CRM and TCA architecture including functional enhancements, user reports, UI enhancements, integration with legacy support systems.

Environment: ORACLE Applications R12,Oracle iStore, iReceivables, TCA, Oracle iSupport, Oracle Service, Oracle Service Contracts, Oracle Install Base, Depot Repair, Advanced Pricing, Inventory, Order Management, J-Developer, PLSQL Developer, e-Business Suite, Mercury, HP-PPM, Sharepoint.

Confidential, Davidson, NC

Oracle Apps Technical

Responsibilities:

• Major implementation of Oracle Apps R11i, for various geographies, involving localizations and customizations.
• Multi-lingual support for Spanish, French, German, Dutch and English.
• Customer Requirement Study, Preparation of Development Requirements from customer requirements
• Worked on various iStore customizations like custom ATP form, background order creation process, providing various item type information in Direct Item Entry, Adding new address type checkout process, backlog report, advanced order search
• Worked on OM interfaces like Creating Promotion in Oracle, Item Creation, Validation & adding it to Price list, Outbound interface to send Salespersons data from Oracle, Order Management Defaulting Dependencies Extension.
• Worked on the XML Publisher reports to send Configurator Model Report in xls Format
• Major role in developing MD70, core development and preparation of MD120 for several modules
• Involved in analysis and development of major conversions and interfaces
• Participations in the code reviews and Technical design reviews in across all the modules.

Environment: ORACLE Applications R11i,Oracle iStore, iReceivables, Solaris 9, Oracle 9I database, Oracle 11i AS, Oracle iStore & HTML Quoting and JSP, Oracle Application (Order management), PVCS, Kintana, J-Developer, PLSQL Developer, & Toad

Confidential

Responsibilities:

• Deliverables included user guides, and instructor guides. It also included system simulations recorded and edited using RWD InfoPak
• Multi-lingual support for Spanish, French, German, Dutch and English.
• Customer Requirement Study, Preparation of Development Requirements from customer requirements
• Involved in analysis and development of major conversions and interfaces
• Participations in the code reviews and Technical design reviews in across all the modules.

Environment: MS-VSS (for source code control), Infopak (RWD), Sound forge, & Flash MX, Action Script, XML, Java Script