SUMMARY

• 11 Years of experience with ERP Application Development, Technical Consulting and implementation of CC&B (customer management and billing) solutions, Supply Chain management Purchasing Order(PO),Account Payables(AP), General Ledger(GL), Inventory(Inv), Order Management (OM), Account Receivable ( AR) and HRMS in oracle EBS 11i and R12 and oracle fusion applications.
• Over 8 years of Valuable experience in Information Technology Architect, Application Design, Development, Supporting of Oracle Fusion Middleware (SOA), Oracle Service Bus (OSB), Oracle BPM Suite 11g (BPM) and Oracle Applications (E - Business) under Verity of Environments.
• Experience in end to end Oracle R12 and 12C upgrades.
• Experience in all phases of the project life cycle (SDLC) like Agile/waterfall development methodologies.
• Experience business processes and their integration with the other applications
• Strong hands-on experience in BPM, BPEL Process Manager, Mediator, Business Rules, Human Workflow Engine, Adapters ( FTP, File, DB), Business Activity Monitoring BAM, Enterprise Service Bus ESB, OWSM, Error Handling, Security, Reporting, Monitoring, Oracle Identity Management, XML, XSLT, XQuery, WSDL, SOAP, WS-Policy, WS-Security, WS-Addressing, WS-Standards and WebLogic Server Concepts.
• Extensive hands on experience on Custom WEB ADI integrators.
• Hands on experience on Oracle ODI and troubleshoot session, procedures in various environments.
• Expertise with Oracle EBS integration using EDI
• Expertise in Oracle SOA technology like Oracle SOA Suite like BPEL, OSB, BPM.
• Worked on Various Oracle SOA adapters (FTP, DB, B2B, and File) including Out of the box adapters (Oracle Apps Adapter).
• Experience on IDE tools like Oracle JDeveloper 9.0/10/11 and Web Services using WSDL, SOAP
• Excellent experience in XML technologies - XML, XSLT,XSD, Xpath, XML Reports and Web Services - SOAP,REST,JAX WSDL
• Strong work experience on SQL & PL/SQL and Reports and Utilities UTL FILE, TOAD, SQL *Plus, SQL*Loader.
• Expert in writing SQL queries, Cursors, Sub programs like Procedures, Functions, Views, Indexes and Packages & Triggers in PL/SQL blocks and Performance Tuning using Explain Plan.
• Expertise designing customized Reports using Crystal Reports, Reports6i, and Forms 6i and also Inbound/ Outbound Interfaces, Reports and Forms.
• Design and build solutions based on best practices and the complexity of the systems involved
• Good experience in Oracle Service Bus (OSB) and BPM
• Hands on experience with Oracle Service Bus (OSB) - Service provisioning, Virtualization and security.
• Worked on Various Oracle SOA adapters (FTP, DB, JMS, and File).
• Good understanding and experience in oracle Application Implementation Methodology (AIM 3.0) and documentation prepared at different stages of implementation.
• Responsible for understanding and analyzing the provided RICE Component specifications and developing solutions by using PL/SQL.
• Registration of Executables, Concurrent Programs and Value Sets into Oracle Apps.
• Registration of Executables, Concurrent Programs and Value Sets into Oracle Apps.
• Strong experience in designing and developing technical solutions for Oracle Applications including Inbound/ Outbound Interfaces
• Worked extensively on ODI in developing various outbound and inbound interfaces.
• Worked on Taleo implementation for HR Payroll.
• Experience with Oracle and Other Utilities: TOAD, SQL *Plus, SQL*Loader.
• Develop a monitoring system to constantly monitor the BPEL and ESB transactions
• Excellent Experience to Handle critical data disasters and recovery
• Experienced in communicating with Business partners.
• Excellent communication and interpersonal skills.
• Experience in Offshore, Onsite project models
• Experience in handling multiple projects at same time.
• Ability to work effectively as a team Leader/member as well as individually
• Certified AWS cloud Solution Architect.
• Certified AWS cloud Developer Associate.
• Strong knowledge of AWS Cloud environment and different storage options such as S3, EBS, DynamoDB, etc
• Knowledge of AWS Identity Access Management (IAM).
• Experience with provisioning and configuration tools like AWS Cloud Formation.
• Currently working on the initial phase of migrating on-premise applications to AWS cloud.

TECHNICAL SKILLS

ERP Modules: PO, AP, INV, GL, OM, AR, HR, OTL.

Operating Systems: UNIX, Linux, ALL MS- Windows Versions

Languages: PL/SQL, UNIX Shell Scripting

Tools: SQL*Loader, TOAD, JDeveloper, Eclipse and TaleoGUI Apex, Developer-2000, ADF

Reporting Tools: OBIEE11g, XML Publisher, Crystal Reports, Forms 6i & Reports-6i

Databases: Oracle 9i, 10g, 11 g

Middleware: SOA, OSB, Oracle BPM Suite 11g

Scheduling tools: CAWA

PROFESSIONAL EXPERIENCE

Confidential, Portland, OREnvironment:

• Oracle Applications
• SOA
• OSB
• BPM
• ADF
• ODI

Oracle SOA Architect

Responsibilities:

• Architect the business solutions in migration of IBPM 10g workflows to 11g using Oracle Business Process Management (Oracle BPM 11g), Oracle SOA Suite, Java/J2ee, and Oracle ADF.
• Integrations with PayPal, amazon web service and salesforce
• Developed the Out of the box custom process to integrate to the existing legacy applications.
• Implemented the business functionally by developing the SOA Composites using Human work flows and adapters like File, FTP, JMS.
• Developed the ADF Screens with integrating the Custom UI for interacting with Oracle BPM Work List App.
• Supported and provided Application Modules and the services needed for GUI to have user task details in the user portal.
• Supported the UAT with the business.

Confidential, Chicago, ILEnvironment:

• Oracle Applications
• SOA
• OSB
• BPM
• ODI

Oracle SOA Architect

My roles and responsibilities:

• Design and developed SOA BPEL,BPM processes for real time interfaces like Customer Master creation/update from order entry system, synchronization of customer profile information back to order entry system, customer invoice transaction number update back to order entry system.
• Hands on experience on Oracle Service Bus (OSB) - Provisioning, content based routing, Transformation and Error handling
• Developed the common error handling using SOA Error handling framework.
• Develop processes using technology adapters (FTP Adapter, DB Adapter, Apps adapter) of Oracle.
• Experience with developing the business and proxy services of Oracle service bus.
• Auto Scheduling Jobs and Monitoring.
• Responsible for enhancements depends on client requirements.
• Registering Reports in Oracle Application.
• PL/SQL method of submitting Concurrent programs.
• Defining Concurrent Programs, Executables.
• Preparing Technical Documentation.
• Developing/Customization Reports, Forms, Interfaces and Conversions as per Client Requirement.
• Developed mapping documents for the columns of source application and oracle applications
• Involved in developing the template using which help the customers to understand the format of the data file, the required columns and optional columns and the mapping between the client's columns and the GL interface columns.
• Journal Import: Developed a package for GL Interface that validates and imports journals to General Ledger.
• Involved in development of interfaces which will extract the data from base tables into flat files using UTL FILE.
• Registered PL/SQL packages, Forms, Menus and reports as concurrent programs.

Confidential, Conshohocken, PAEnvironment:

• Oracle Applications
• SOA
• OSB
• ADF
• BPM.

Integration Consultant/Architect

My Responsibilities:

• Built BPEL processes that subscribe EBS events around sales order processing functionality and participate in database and JMS transactions.
• Developed the Business and Proxy services by using OSB while exposing the SOA real time processes to external application.
• Experience with setting up new environment, installation, domain creation, configuration and testing.
• Worked with Oracle Fusion Middleware Adapters, Oracle JDeveloper, BPEL, BPM, Mediator and transformation using XPATH, XSLT functions.
• Deployment of SOA components using ANT scripts, WLST scripts and automation of deployment procedures in different environments.
• Worked on Oracle Service Bus while creating the proxy and business services by using Java callout, File and DB adapter and applying the security policies on services.
• Experience with BAM: notified critical errors/faults through emails from BAM.
• Experience with the SOA Gateway to expose the pl/sql Api’s, concurrent programs and custom Api’s by using Oracle Application adapter.
• Implemented server side tasks using Servlets and XML.
• Developed Jsp’s with Custom Tag Libraries for control of the business processes in the middle-tier and was involved in their integration.
• Developed Web services (SOAP) to interact with other components.
• Create custom pl/sql packages and procedures to be invoked from the Application Modules.

ConfidentialEnvironment:

• Oracle Applications
• SOA
• OSB
• ADF
• BPM

Integration Consultant/Architect

My roles and responsibilities:

• Worked on Full life cycle implementation -requirements gathering, design, implementation, integration testing, deployment and post production support
• Used Technology Adapters (FTP Adapter, File Adapter, DB Adapter and JMS Adapter) to develop process to import flat files and update custom tables.
• Used Web services exposed in J2EE web services, BPEL Process using FTP adapter, DB Adapter, Workflow Tasks in Oracle BPEL Process manager.
• Experience with BAM: notified critical errors/faults through emails from BAM.
• Participated in the development of Authentication & Authorization services as part of core platform security in the application by using OPSS Api’s, Oracle API Gateway and Oracle IDM Suite.
• Participated in technical architecture team to deliver the SOA best practices in enterprise environment.
• Worked on Oracle Application Development Framework (ADF) while integrating platform level middleware services to ADF UI components.
• Production support role involving monitoring, maintenance and deployment of various J2EE web applications on Linux/Windows Operating systems in Testing and Production environments.
• Create custom pl/sql packages and procedures to be invoked from the Application Modules.
• Unit testing and Integration testing of the customizations.
• Responsible for enhancements depends on client requirements.
• Registering Reports in Oracle Application.
• PL/SQL method of submitting Concurrent programs.
• Defining Concurrent Programs, Executables.
• Developed and Customization of Reports based on Customer Requirements.
• Prepared technical documentation for the developed objects.
• Creation of value sets in various modules of the application.
• Development of Executable, concurrent programs, creating value sets and registering them into Oracle applications.
• Developed PO Open Interface to upload the Standard Purchase orders data into Oracle POBase tables by using PL/SQL Program.
• Excellent documentation with respect to solution design, User Acceptance, test scripts, Production setup document, and issue logs and document standardization in line with AIM Methodology.
• Prepared technical documents (MD070) for reports, interfaces and concurrent programs as per client business logic.

ConfidentialEnvironment:

• Oracle Applications (AP
• AR
• PO
• OM
• GL)
• SOA
• OSB
• ADF.

Consultant/Architect

My roles and responsibilities:

• Developed processes using technology adapters (FTP Adapter, DB Adapter) of Oracle BPEL and tune them for the expected load, Transformations, Exception Handling, and use of Third Party JDBC Drivers.
• Configured Oracle Applications adapter for invoking PL/SQL API to send data to EBS, and for receiving Order status from EBS
• Worked with Oracle Fusion Middleware Adapters, Oracle JDeveloper 10.1.3.4, Java, JSP, HTML and JavaScript.
• Configuration and Maintenance of JDBC, JMS, JNDI and other J2EE Services with WebLogic 10.3.
• Work with other programmers/designers/architects to make sure that the components meet integration requirements.
• Developed Technical Specification for on boarding three new EDI Customers (B2B).
• Create the technical design document, MD70 as part of the AIM. MD70 will include the process flow and the technical features used to develop the component, input and output specification and setups needed.
• Defined value sets and value set values
• Developing/Customization Reports, Forms, Interfaces and Conversions as per Client Requirement.
• Involved in developing new forms as per the client Requirement by using TEMPLATE.fmb
• Developed mapping documents for the columns of source application and oracle applications
• Involved in developing the template using which help the customers to understand the format of the data file, the required columns and optional columns and the mapping between the client's columns and the GL interface columns.
• Journal Import: Developed a package for GL Interface that validates and imports journals to General Ledger.
• Involved in development of interfaces which will extract the data from base tables into flat files using UTL FILE.
• Registered PL/SQL packages, Forms, Menus and reports as concurrent programs.
• Developed PO Open Interface to upload the Standard Purchase orders data into Oracle POBase tables by using PL/SQL Program.
• Excellent documentation with respect to solution design, User Acceptance, test scripts, Production setup document, and issue logs and document standardization in line with AIM Methodology.
• Prepared technical documents (MD070) for reports, interfaces and concurrent programs as per client business logic.
• Define value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures and Packages.

Confidential

Consultant/Architect

My roles and responsibilities:

• Custom validations in Oracle using cursors, triggers, procedures and functions which only allow specific business functions suggested by the client thereby restricting the improper flow for a better business approach as Techno functional consultant.
• Developing reports using Business Objects - Crystal Reports for financial analysis, reconciliation, etc…
• Data corrections - problem finding using custom scripts written in SQL/PLSQL and problem solving using SQL/PLSQL with cursors, triggers, procedures and functions.
• Client business process analysis - Understanding client business processes, suggesting / improvising the business scenarios, etc… and implementation of few modules as per clients requirement
• Implementation of new features / Third party integrations - Payment Gateway.
• Regular maintenance of billing activities and daily issues resolving using SQL/PLSQL.
• Data porting of all the subscriber base into MQS using SQLLOADER and inserting the data accurately into various table by writing stored procedures, triggers and cursors.
• Developed complex reports using Business Objects - Crystal Reports for financial analysis, reconciliation, etc as per client's requirement
• Developed a custom workflow for Customer Care module at DB level where there is no feasibility for the client required workflow within the product. Good level of using triggers, stored procedures and functions for this workflow setup.
• Scheduled DB jobs by writing stored procedures for different features which are not feasible within the product as per client's requirement.

Confidential

Developer

My roles and Responsibilities:

• Confidential is a convergent customer management and billing solution for the Pay TV, ISP, VOIP and IPTV industry. Confidential is a highly cost-effective, Modular, flexible and scalable solution. It enables service providers to effectively provision, rate, accurately bill and engage in customer care for all their basic and advanced services such as Pay TV / Internet Service Providers, Broadband Services, Interactive TV Services. Confidential can be integrated with Middle ware for Broadband services, VOIP services and Conditional Access Systems for Pay TV Services
• Coordinating with team members and analyzing the client's business process for requirement mapping, system design integration and product implementation.
• Accurate configuration of business processes as per the scope defined and work flows identified within the agreed time lines (via Business Process Document and project plan).
• Write / enhance the procedures / triggers and other relevant objects of the DB using Oracle PL/SQL for meeting the analysis requirements as per scope defined.
• Worked on performance tuning both script level and server level
• Preparation of Acceptance Test Cases. Facilitate to conduct the acceptance tests during implementation conforming to the defined scope with prior acceptance of the solution by the client.
• Developing simple / complex custom reports confirming to clients processes using Crystal Reports.
• Limited to the identified business processes and work flow, train or hand hold the team of users at customer's location. Effectively imparting training to the users or user groups at customer's location. Training PPTs and relevant documentation and training environment like the solution configured as per the client's processes along with sample data.
• Resolving queries/issues at production level and extending onsite support including maintenance support.