Summary:

7 years of extensive experience of implementation, support, up gradation, migration in Financials, Distributions, SCM, CRM modules of Oracle Applications E-Business Suite including Business Requirements Mapping, Application Module Design and Development, Data conversion, Documentation, Testing, Performance enhancements and Production Support.

Professional with rich varied experience in:

• Project Management Planning System Analysis SDLC
• Business Analysis Pre Sales Client Interaction
• Time Management Team Management Requirement- Mapping Analysis Cost Control Meeting Deadlines Risk Management Documentation Application Development Technical Support MIS Management
• Techno-Functional Consultant Order Management, Account Receivables, Shipping, Accounts Payable AP , General Ledger GL , Inventory INV , Purchasing PO , Service Contracts/Contracts Core OKS/OKC , CRM Foundation JTF , Install Base, Field Service, Depot Repair, Service and Trading Community Architecture TCA/HZ
• Experience in implementation, conversions, interface and customization of Oracle Applications objects.
• Proficient programming experience in SQL, PL/SQL, SQL Loader, Oracle Developer 2000 Forms 6i/9i/10g, Reports 6i/9i/10g , XML Publisher, OAF and Workflows.
• Design and development experience on Oracle SOA Suite which includes BPEL, ESB, WSM, Oracle Rules Engine/Rule Author and Worklist Application all with the latest version 11g.
• Lead the team of Developers in the implementation of Reports, Forms and developing them from scratch and customizing.
• Expertise in SOAP, WSDL, and Web services, XSD, XML, XSLT and XPATH.
• Lead the team in Designing and Development of SOA Suite Components using BPEL and OSB.
• Expertise in Production Support, Requirement gathering, functional gap analysis, configuration, module setup, test script generation, training users.
• Experience in customizations and Enhancements of Interfaces, Reports, Forms and Workflows.
• Knowledge of Application Object Library AOL , Application Programming Interface API and System Administrator activities.
• Expertise in customizing ORACLE Alerts
• Experience in System Administration responsibilities such as registration of concurrent programs, request sets, creation of Users, Responsibilities, Forms, Functions, Values Sets and Flex fields in Oracle Applications.
• Expertise in Performance Tuning of Queries, Reports and high volume transaction processing.
• Significant Experience with System Requirements Gathering, Analysis, Design and Development, Test Plan Preparation, Unit testing, System Integration testing and documentation.
• Involved in End User training, preparation of user manuals, user guides and Desktop procedures for various projects.
• Ability to work with Cross-functional teams including Users, Financial Analyst, Business Analyst and Technical Consultants
• Testing of module functionality after patch Application and after Applying customization releases.
• Follows ups of TAR and Applications of Patches as and when required with Oracle Corp.
• Guide Users in formulating requirements, advice on alternatives and on the implications of new or revised processing analysis.
• Strong analytical and troubleshooting skills with excellent verbal and written communication skills.
• Familiar with change and configuration management methodologies, the Oracle AIM and Oracle UOM methodology, and project management techniques.
• Conversant with:
• Oracle Apps 11i, R12 Financials, Oracle Fusion Middleware, PL/SQL, Java, BPEL.
• Oracle ERP Application.
• Oracle Applications 11i Financials, CRM and Distribution.
• RICE Reports, Interfaces, Conversions and Extensions components, Onsite/Offshore methodology.
• OAF customizations and Creation of new pages using OAF.

Key Deliverables across the tenures

• A project planner with demonstrated success in end-to-end project management by ensuring effective management of various resources to meet the project objectives.
• Insightful experience in IT project management activities including project scoping, estimation, planning, risk management, finalization of technical / functional specifications, resource administration optimization and quality management of the software applications.
• An effective leader with proven ability in leading and guiding the teams during the project phases and enabling knowledge sharing among the teams.
• Hands-on experience in end-to-end development of software products from requirement analysis to system study, designing, coding, testing, de-bugging, documentation and implementation.
• Acquires a clear understanding of the technology trends with the distinction of instituting new practices to achieve business excellence at the lowest overall cost.
• Extensive experience of environments requiring direct customer interaction during specifications, effort estimation, development, product implementation phases production support.
• An effective communicator with excellent relationship building interpersonal skills. Strong analytical, problem solving organizational abilities. Possess a flexible detail oriented attitude.

Technical Skills

• ERP: Oracle Applications 12.1,4/11i/11.5.10/11.5.9/11.5.8/11.5.7/11.5.6/11.0.3
• GL, AR, AP, CE, INV, PA, OE, OM, Work Flow, Alerts, iProcurement, iPayment, Shipping, Pricing,
• PO, BOM, WIP, TCA, Service Contracts, Install Base, Field Service, Depot Repair, Quoting, AOL, System Administration.
• Fusion Middleware Technology: Oracle SOA 11g/10g, BPEL, ESB,BPEL Activities, Adapters, Mediator, Fault Management Framework, OSB and B2B
• Programming languages Sql, Plsql , XML, Java, C, C
• Web Technologies HTML, XML, XSD, WSDL, UDDI, XSL
• Framework Oracle Application OA Framework
• Database Oracle9i,10g

Tools:

• Oracle JDeveloper 10g/11g, Oracle Developer 2000, Oracle Workflow, XML Publisher, DATA LOADER, VSS,
• Putty and Mercury IT Governance Suite formerly KINTANA Objects Migration Tool , ITIL Support Management Tool, ipat, Oracle SQL Developer, TOAD, SQL Loader.
• GUI Forms 6i/9i/10g Reports 6i/10g, Oracle Discoverer, Workflow Builder 2.6.3
• Project Management
• Project Initiation, Planning, execution and controlling
• processes Risk Management.
• Agile Methodology. Aim Methodology
• Operating Systems Linux, UNIX, Windows 95/98, Win2000/XP.

PROJECTS EXECUTED

Confidential

SOA Developer

Confidential provides reliable, cost-competitive electricity to nearly 250,000 customers throughout Southwest Florida.

Responsibilities:

• Involved in developing File Adapter, FTP Adapter, Database Adapter, AQ Adapter and JMS Adapter for integration using Oracle ESB and for development of custom business processes using Oracle BPEL Process Manager.
• Design the various BPEL processes to facilitate the integrations.
• Defined WSDL for BPEL process, partner links, BPEL process templates and developed process logic definition.
• Extensive experience in troubleshooting the deployment and other application problems, applying WebLogic patches, Service Packs, and working closely with Development Teams in solving issues.
• Testing the portal functionalities and BPEL workflows.
• Developed various Web Services using WSDL, SOAP and Oracle JDeveloper.
• Closely interacted with various development/Functional teams in Design, Development testing phases.
• Designed, documented and developed LLDs for integrations of applications on different environments.
• Extensively used XSLT, XSD, and WSDL
• Closely interacted with various development/Functional teams in Design, Development testing phases
• Design and Developed ESB processes, configure database, file adapters and tuned BPEL and ESB processes.

Confidential

SOA/BPEL Developer

Engage Point delivers best-in-class healthcare software and IT services to governments and to commercial and administrative insurance payers. Department of Information systems in collaboration with Department of Human services, Arkansas, focussed on providing the citizens with the Medicaid, involved this integration approach to allow the transaction services between the state servers and Exchange servers through BPEL.

Responsibilities:

• Involved in detailed design, complex implementation, interfacing, integration, unit testing, documentation, and maintenance responsibilities for the complete enterprise client and web applications.
• Defined WSDL for BPEL process, partner links, BPEL process templates and developed process logic definition.
• Involved in deploying BPEL and ESB services on to the production server.
• Delivered design, code and unit test results performed diagnostic analysis of test results and deliver solutions to critical areas.
• Run and monitor performance/integration/unit tests on new and existing software for the purposes of correcting mistakes, isolating areas for improvement, and general debugging.
• Directed and participated in research on emerging business process management and integration software products, languages, and application development methodology standards in support of procurement and development efforts.
• Developed various Web Services using WSDL, SOAP and ActiveVOS.
• Designed Oracle Service Bus Service Interactions like service management, message brokering, configuration framework, security and transport layer, and messaging protocols.
• Performed IT reviews and deployments related to BPEL-BPMN development.
• Liaised with network administrators, database developers, programmers, and other software engineers to resolve any defects in products or company systems.
• Communicated with various levels of staff to provide a regular status regarding BPEL-BPMN development projects and activities.

Environment: Oracle Applications server 10g, SQL, PL/SQL, TOAD, Oracle BAM, Oracle SOA Suite 11g, JDeveloper 11g, BPEL Process Manager, ESB, Oracle database 10gR2, Eclipse, SoapUI, ActiveVOS.

Confidential

Oracle OSB/BPEL/AIA Developer

Confidential, with corporate offices in Confidential, remains close to its origins. It is there, as a Confidential student that founder Confidential began producing sandals in Confidential. Since then, Confidential has grown into a leading global company with locations on three continents and six footwear brands - Confidential. The project involves implementation and support of Oracle Applications R12 Financials, SCM.

Responsibilities:

• Team Lead/Offshore coordinator for overall Oracle Financial ApplicationsR12 Project.
• Task Management, On-time Delivery and overall setup for critical milestones.
• Worked on RICE Objects in Financial modules of Oracle Applications.
• Worked on the Enhancements of the existing RICE objects.
• Worked on customizations for reports, XML Publishers.
• Worked on the incidents/tickets for the oracle financial modules provided from the client as part of the support.
• Implemented Oracle ESB and Integrated with BPEL.
• Provided presentation for Integration of Oracle Ebussiness suite with Oracle RTS.
• Established the integration of data flow between Oracle Ebussiness suite with Oracle RTS.
• Worked on designing and developing the integration through bpel and pl/sql.
• Understanding the Requirements and Design Specifications.
• Involved in creating BPEL processes.
• Creating jar file from WSDLs.
• Analyze the requirements and subsequently developed and provided presentation to the client the BPEL Integration of Oracle Apps with Oracle Retek of the integration module.
• Design and implemented Business Processes using Oracle BPEL PM and Developer.
• Involved in design and development of BPEL processes that contain Human Workflows.
• Developed BPEL processes that contain Exception Handling to capture the Remote and Binding Faults.
• Conversion of different XML formats in each other.
• Developed different SOAP services and Web Services using WSDL, SOAP and Oracle JDeveloper.
• Provided the Technical and Test Documentation for the objects created.

Environment: Oracle Applications 12R: GL, AP, AR, SCM, SOA11g, Forms10g Reports10g, ITILSupport Management, Putty, WinSCP3.

Confidential

Oracle OSB/BPEL

Provided Oracle E-Business Suite Support for the existing environment Integra Life Sciences spread across 7 countries and 3 continents across the globe manufacturer of different surgical tools. Uses Oracle AppsR12, Fusion Middleware. All its transactions were through Oracle Applications12R and integration with third party systems like Agile.

Responsibilities:

• Team Lead/Offshore coordinator for overall Oracle Fusion project.
• Interfaced between the client and BPEL Interface development team offshore.
• Task Management, On-time Delivery and overall setup for critical milestones.
• Fully designed and developed a BPEL process to publish legacy data into Oracle E-Business Suite Open interface tables using APPS-Adapter.
• Implemented BPEL Process Rejection Handler File system based
• Invoked BPEL Process thru PL/SQL.
• Managing different BPEL Domains thru Bpel Admin.
• Worked on RICE Objects in various modules of Oracle Applications.
• Worked on customizations for reports, forms and Oaf.
• Developed and involved in the POC of the Integra Life Sciences Project and developed new
• OAF page using oracle frame work and personalization for the business requirement.
• Provided the Technical and Test Documentation for the Projects

Environment : Oracle Applications 12R: GL, AP, PO, OM, Forms10g Reports10g, Putty, WinSCP3, SOA Suite, OAF.

Confidential

Confidential offers groundbreaking mass spectrometry technology that is the fastest and most sensitive high-resolution mass spectrometer for high-performance qualitative and quantitative analysis. Confidential systems represent a significant advancement in mass spectrometry, combining for the first time on a single platform the quantitative capabilities typically associated with triple quadruples and the qualitative capabilities of a high-resolution, accurate-mass system. We supported the Confidential business process. Supporting the end-users with the day-to-day production issues. Working on new creation of reports, API's and enhancements if any.

Responsibilities:

• Supported day-to-day business process and addressed the production issues.
• Support to the business's various Supply chain modules.
• Involved in supporting the daily Order Management, Inventory, Receivables AR , Shipping and Picking issues.
• Resolved the issues in pending transactions and any stuck transactions.
• Monitored that the period close every month takes places as scheduled without any issues.
• Debugged the reports in case of incorrectness of data
• Work on AIM methodology for new Custom designs to best suit the user requirement.
• Created new Discoverer 10g reports for HR data, Shipment information, Customer Service data
• Assist the end-users with minor issues like Printing issues, Unable to Ship an order, unable to receive an order, miscellaneous transactions and others.
• Support on business critical Discoverer reports which contains their monthly sales data.
• Provide bug fix for the long pending issues like unable to receive orders, Purchasing approval hierarchy, Accounts for a particular customer site.
• Added columns in OM report to be able to view more data with clarity using Oracle Report Developer 10g
• Supported the business users in understanding the functioning of the reports.
• Interacted with users in gathering all the requirement information
• Supported the issues with oracle Alert, replicate the issues, test it and movement to production with help if MD-50, MD-70.
• Worked with Oracle as part of SR's TAR creation for standard Oracle issues and scheduled calls on weekly basis to resolve the issues faster.
• Worked with DBA's to apply patch and test the impact on the business.

Environment: Oracle Apps 11.5.9 SQL, PL/SQL, MS Excel, SQL Developer, Toad, SQL Plus, UNIX Box.

Confidential

Role : Oracle OSB/BPEL

Environment :

• Oracle Applications 12R: GL, AP, PO, CE, Forms10g, Reports10g, Java, Oracle Frame Work, SOA Architecture, BPEL, XML Publisher and Linux
• Module : R12-GeneralLedger, Account Payables, Purchase Order, Fixed Assets, Cash Management, Account Receivables.
• Implementation R12 application for its Corporate Business. Confidential is world renowned company in manufacture of routers and its accessories. Most of the world 80 of business is maintained by Confidential Systems in the Business. The previously used Oracle applications 11i and were migrating to R12 Oracle Applications. All the Cisco transactions take place through oracle applications and need to maintain Corporate Financials.

Responsibilities:

• Upgradation of R12 Oracle applications for the modules GL, AP, AR, CE.
• Maintained offshore and onsite teams from different locations and interacting with client manager for successful delivery of the project in fixed time duration.
• Delegation monitoring of work to the team members. Estimating the time required for tasks.
• Assisting the Project Manager in allotting the work to team members, monitoring the delivery of the project in time and preparing the plans for the test cycles in the Test Instance.
• Designed of MD50, MD70, CV40, MD120 and TE40 documents as per client's requirements.
• Building the interface tables required for performing validations before inserting the data into the Oracle Applications main tables.
• Code walk through, unit testing, guiding the developers in completing their tasks in time.
• Involved in analyzing business requirements and designing the functional document MD50 and also translated functional document into technical document MD70.
• Handled all the major issues while migration of the project from 11i to R12 Oracle applications.
• Involved in debugging the code review for the RICE Components.
• Designed and developed custom reports for the business in the R12.

Confidential

Role : Oracle BPEL

Modules : Receivables, GL, AR, Order Management, Service Contracts, Install Base

Environment : Oracle E-Business Suite 11.5.10 AR, GL, IB, OM, OKS , SQL, PL/SQL, Reports9i, Forms9i, Developer, OA Framework, Toad, SOA, Bpel, Esb.

As a Techno Functional Analyst, my primary involvement is gathering requirements from client, functional and technical design of interfaces, design of conversions and extensions, giving estimates for the project plan, project status reports, reviewing the code, setup of data for integration testing, assisting and motivating the project team in development and production support

Responsibilities

• Worked as a Techno functional consultant implementing Oracle Modules Install Base, Service Contracts, Field Service and Depot Repair, Order Management OM
• System study, gap analysis, project methodology discussions AIM methodology , High-level Business Analysis and recommendations.
• Involved in OM, Install Base Conversion programs, Field Service, Service request, Service Contracts, depot repair, field service conversion programs.
• Involved in development of forms reports using 9i.
• Involved in Requirement gathering and provided business solution.
• Modified CRM pages using personalization's through OA Framework and lead the team on CRM.
• Involved in controlling the functions on the pages using SPELL extensively.
• Extensively worked on Dependent Lovs and Lovs for the CRM pages using OA Frame Work.
• Developed the Integration test Scripts to test the Depot to Repair business flow.
• Defined the Test data for Integration testing from the Legacy systems.
• Responsible for importing Regular, Debit memo, Credit memo invoices from legacy system to Oracle Receivables tables using CTL file and Auto Invoice import program.
• Responsible for performance tuning and guiding the technical team with the analytic functions and multi table inserts in SQL and PL/SQL.
• Designed interfaces in BPEL and Routed to third party applications through ESB.
• Upload file into/from ftp location to Oracle Database. FTP and DB adapters were used with Oracle ESB.
• Expertise in using PL/SQL API's, Open Interfaces and custom coding of PL/SQL Packages and using them within the BPEL using Oracle Applications Adapter.
• Installation of Middle tier application server SOA Suite 10.1.3.x , configuring and deploying application adapters and integrating with E-Business Suite.
• Extensively used Fault and Error handling capabilities Catch and Catch All , Synchronous and Asynchronous processes, Transformations, XSD, XSLT and XPath.
• Designed system architecture and pseudo code for Technical Design Document.

Confidential

Role : Sr. Technical Consultant

Module : Oracle Order Management, Service Contracts, Install Base, AR

Environment : Oracle E-Business Suite 11.5.9 OM, OKS, IB, , SQL, PL/SQL, Reports9i, Forms 9i, JDeveloper, Toad.

Description : Implementation of Oracle Applications EBS suite Modules for Confidential. Confidential is one of the world's largest sellers of office products and an industry leader in every distribution channel, including stores, direct mail, contract delivery and Internet and business-to-business electronic commerce.

Responsibilities

• Modified Advanced Search Page in Order Information Portal in Applications Development Framework to add Line Status additional criteria to query for Sales Orders.
• Responsible for importing sales tax records into Order Entry application from sales tax feeder having different sales tax rates, dates and postal codes using interface program.
• Designed the Generate Pre-Billing Customer Acceptance Concurrent Program to perform implicit acceptance of the all the Sales Order lines that have passed the expiration date. Expiration days attribute is defaulted from the Account Receivables Revenue Management setup for Customer Acceptance.

Confidential

Module : Order Management, Purchasing, Receiving, Pricing, AP, AR, GL

Environment : Oracle Applications 11.5.10.0.2: OM, AR, AP, GL, Install Base, Service Contracts, Discoverer, BPEL Process, Forms6i/9i, Reports6i/9i and OAFrame Work, Java.

Description : Implementation of Oracle Applications Confidential suite Modules for Confidential. Confidential is one of the world's largest sellers of office products and an industry leader in every distribution channel, including stores, direct mail, contract delivery and Internet and business-to-business electronic.

Responsibilities:

• System study, gap analysis, project methodology discussions AIM methodology , High-level Business Analysis and recommendations.
• Responsible for the delivery of the project in UAT Phase.
• Migrating Customer Interface into Trading Community Architecture mapping the interface tables and columns using both the API's.
• Imported Sales Order and Customers using BPEL Process.
• Designed interface thru BPEL Process
• Worked on the PO Approval Process work flow by attaching the notification to contingent manager for the approval process and escalating it to permanent manager at the same time.
• Developed Oracle reports related to AR, AP and GL.
• Migration of Customers, Customer Addresses and Customer Open Invoices create ship to address at Invoice level. Used TCA API's to create customers under a party.
• Used TCA API's in migrating the legacy data into Oracle Application Tables.

Confidential

Environment : Oracle E-Business Suite 11.5.9/11.5.10 INV, BOM, WIP , OA Framework, Java, PL/SQL, XML, Reports 6i, Oracle 9i.

Description : Creating an inventory organization involves numerous setup steps and it is often a repetitive task. This project is designed to copy the setup from a model inventory organization and create large number of inventory organizations along with their associated entities. This feature is widely used in many inventory organization implementations and retail industry.

Responsibilities

• Assisted in Enhancements to existing APIs such as migrating implementation from iSetup Java Framework to PL/SQL to improve the performance.
• Implemented validations and middle tier logic for some APIs such as WIP Parameters using OA Framework BC4J components
• Modified the Report Design which is created using Oracle Reports to show the new APIs.
• Modified the Interface table to add a new column SITE ID for retail. Retail Team will invoke Copy Inventory Organization and update this column linking it to their site id after Copy Inventory Organization finishes copying.
• Resolved numerous Customer issues in a timely manner

Confidential

BPEL Developer

Confidential is a distributed system that allows users to scan documents, apply business logic and rules to compress and check validity, automate approvals, send notifications and help retrieve them online.

Responsibilities

• Gathered and documented the requirements from the business users.
• Designed the portal application and the BPEL processes.
• Developed portlets using the PDK and JPDK.
• Developed BPEL processes using the BEPL process manager.
• Tested the portal functionalities and BPEL processes.
• Coordinated with Offshore team to pass on the requirement details and technical know-how.
• Technical documents creation.
• Mapped documents creation.
• Development of TIBCO BW code.
• TIBCO RV Stream usage for process initiation.
• Development of Unix Shell Scripts.
• Development of BW Stubs.
• Unit testing the BW components using stubs.
• Defect fixing and Deployments of components using UNIX scripting.
• Defect Management using MQC Mercury Quality Centre
• Creating reports of the defects using MQC.
• Environment: TIBCO BW, TIBCO EMS, Oracle OSB, Tibco Administrator, Hawk
• Unix shell scripting, MQC

Confidential

Description : Confidential has the legacy system and the Data is converted from Legacy system to Oracle Applications thru Interface table and performing Pl/SQL validations and using Standard import program data loaded into base tables.

Responsibilities

• Responsible for PO Interface Developed Conversion Package to load data from flat file to staging table and validate the data and load the validated data into PO Interface tables.
• Involved in Developing Technical Specification and Documentation before developing the code and working with onsite Business Analyst.
• Developed PL/SQL Packages for GL Outbound interface to Legacy Systems.
• Worked on Pl/Sql Procedures, Triggers and Packages as part of Implementation and Production Support.
• Debugging, Testing and maintaining the various OA Frame work components across multiple environment.

Environment : Oracle Applications 11.5.10.0.2: GL, AP, PO, iprocurement, Oracle 8i/9i, OA Frame work, Discoverer, Forms6i, Reports6i, SQL Loader, Linux and Window N/T .

Confidential

Module : General Ledger, Account Receivables, Account Payables, Purchase Order

Environment : Oracle Applications 11.5.9, 11.5.10: GL, AP, AR, PO, AOL, Sysadmin, Oracle 8i/9i, Forms6i, Reports6i, SQL Loader, UNIX and Windows N/T.

Description : Confidential, Product Based Company for certifying the hosts for third party payment checks. Have established in nearly 180 countries across the globe have implemented oracle applications. All the transactions were done using Oracle Applications.

Responsibilities

• Developed PL/SQL Packages for GL Outbound interface to Legacy Systems.
• Involved in Automation of oracle applications with Microsoft Active Directory System Legacy system
• Developed PL/SQL Packages for Populate Service Parts Request Data into Oracle Base Tables using Oracle Standard API.
• Involved in Developing Technical Specification and Documentation before developing the code and working with onsite Business Analyst.
• Monitoring the performance of the load of the data when transferring the orders