Oracle Developer

K A L Y A N

Senior Oracle SOA fusion middleware developer

PLANO TX 75024 Tel: 561-***-**** *********@*****.***

Extensive experience in Oracle SOA Fusion Middleware 10g/11g with solution architecture experience

SUMMARY OF QUALIFICATIONS

• Seasoned senior developer with over 10 years of experience in analysis, design, development and delivery of enterprise applications using SOA, BPEL, BPM, Java, J2EE, and Database technologies.

• 5 years’ experience in large-scale SOA/EAI implementations using Oracle Fusion Middleware (Oracle JDeveloper, SOA Suite, OSB, BAM, ADF and Oracle Weblogic)

• In-depth understanding in Service-Oriented Architecture and its related technologies like BPEL, Web Services, ADF, WSDL, SOAP, XML, XSD, XSLT, MDS, RESTful Web Services and Web Service Security.

• Adept at working with Oracle SOA Suite SCA composites and components like BPEL, Mediator, Business Rules, Human Workflow, and activities like Assign, Invoke, Pick, Receive, Switch, Flow, Java embedding, Email, Wait, While, Validate etc. in JDeveloper.

• Experienced using the following SOA Suite technology adapters for integration with Oracle ERP, SAP and external/legacy systems: JMS, B2B, FTP/File Web Service,AS 400, BAM and Oracle applications.

• Expertise in the design, development and integration of BPEL events with Sensors & Oracle Business Activity Monitoring (BAM) to create dashboards with various types of graphs.

• Experienced in designing and building robust and fault-tolerant Fusion Middleware components in BPEL and OSB using the Oracle Fault Management Framework and catch/compensate activities in addition to custom fault policies and fault binding.

• Well versed with troubleshooting Weblogic domains, clusters and servers in distributed environments for SOA and J2EE platforms.

• Prepared detailed technical design documents for fusion solutions.

• Experienced in working with Oracle AIA 3.0 in Oracle soa suite 11.1.1.2 and 11.1.1.4.

• Experience of Development, Interfaces & Data Conversion, and Implementation, Customizations of Trading Community Architecture modules.

• Expertise in executing Oracle Apps projects as Techno-Functional Consultant in Oracle E-Business Suite Applications.

• Worked with Oracle Corporation as Sr. Applications developer for 3 years.

• Extensively worked on TCA, OM, AP, AR, AOL and System Administration modules.

• Experience of Development, Interfaces & Data Conversion, and Implementation, Customizations of Trading Community Architecture modules.

• Proficient in database design with expert knowledge in writing stored procedures, functions, packages, tables, views, sequences, indexes, synonyms, objects, collections using SQL & PL/SQL.

• Experienced in developing & customizing Oracle Reports in Oracle Applications.

• Experience in performance and tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf, Indexing and Hints.

EDUCATION

• Bachelor of Technology in Computer Science and Engineering

TECHNICAL SKILLS

ERP Products Oracle Applications E-BIZ 11i, Oracle Applications E-BIZ R12, Oracle On-Demand R17/R18, SAP ERP 6.0

Product Tools JDeveloper,Weblogic 10.3.5, Oracle Fusion Middleware 10g/11g SOA BPEL, OSB, ADF BAM, Oracle Reports 6i, SQL Developer, SQL Navigator, TOAD, J2EE

Operating Systems Unix, Windows, Linux

Databases Oracle 8i, 9i, 10g, 11g, SQL Server

Languages C, JAVA, SQL, PL/SQL, HTML, XML, XSL, XSD, XQuery, Pro*C, BPEL.

Web Technologies HTML, JSP, Servlets

Cloud Oracle CRM-On Demand

Frameworks OA Framework, Oracle ADF

PROFESSIONAL EXPERIENCE

McAfee, Plano, TX April 2012 – Present

Sr. Oracle 11g Middleware Fusion Developer

McAfee, a wholly owned subsidiary of Intel Corporation, is the world's largest dedicated security company. It helps customers to stay safe by creating proactive security solutions for securing your digital world. The services include offering protection for mobile devices, including the ability to locate lost or stolen devices, and essential identity protection, to keep money, credit, and personal information safe.

# GEWI : April 2012 – till Date

GEWI stands for Global External Workforce Initiative. McAfee employee data resides in SAP HR. Cost Center and Asset Master data is housed in SAP FI. IQNavigator is the vendor management tool used by McAfee to manage contractors and the related assets. From a business perspective there are 3 entities that need to be synced in case of any update to those.

1. Employee

2. Cost Center

3. Asset Master

Any changes to employees/cost center/asset master need to be synced with IQNavigator. The changes to Employees is captured as IDOCS. The changes to Cost Center also comes from SAP as IDOCS. Data changes to Asset is retrieved by making BAPI calls to SAP.

IQNavigator has RESTful web services exposed to make changes to employees/cost center/asset master.

Oracle fusion processes get the employee/cost center/asset master using the SAP adapter in the form or IDOCS/BAPI and makes the necessary transformations and invokes the RESTful web service using the HTTP Binding adapter.

Appropriate Error Handling is done to notify of errors/exceptions

Responsibilities:

• Designed the technical solution for composites in collaboration with architects.

• Created the technical documents that encompass the mapping structures from source to destination databases fields as per user requirements and also the database related changes to complement the composites.

• Designed to reprocess the failed requests.

• Used advanced BPEL 2.0 features along with AIA 3.0

• Used SAP IWAY adapter and also the HTTP Binding adapter to call the RESTful Web services.

• Used custom fault handling and fault policy for remote and binding faults.

• Used MDS to share common assets like XSD, WSDL, Fault Policies etc.

• Created and managed configuration plans to deploy composites to different environments.

• Developed around 10 composites.

• Developed unit test cases for SOA composites.

• Managed a team of 5.

• Involved in the code review.

Environment: Oracle SOA Suite 11.1.1.4 - BPEL 2.0, BPM, AIA 3.0, SAP IWAY Adapter, HTTP Binding Adapter, RESTFul Web services, Mediators & Adapters,JDeveloper 11.1.1.4.0, Oracle Weblogic 11g on Linux, WSDL, XML, Visio, Oracle SQL Developer.

Accident Fund, Lansing, MI July 2011 – March 2012

Sr. Oracle 11g MiddlewareFusion Developer

Accident Fund, Insurance Company of America is a worker’s compensation insurance company headquartered in Lansing, Michigan.

# PayGo : Oct 2011 – till Date

The policy system of AFHI is called 'Point In' and is outsourced to CSC. ODS or the Operational Data Store is maintained in-house at AFHI that acts as the hub.AFHI (Accident Fund Holdings Inc) sells policies to companies.The premiums of the policies are determined based on the payroll data.The purpose of the PayGo automated payroll integration process is to gather payroll data from selected payroll vendors like RPM to be used to validate estimated payroll amounts defined within AFHI policy systems. For the initial rollout, Payroll information corresponding to AF policy holders, will be collected from Payroll companies and integrated into the Operational Data Store to be consolidated and fedback to Point In for auditing purposes. There are several integration points as part of the whole process that are addressed in this project.

• Policy Extract outbound to the payroll vendor from ODS.

• Payroll File inbound from payroll vendor to ODS.

• Audit Extract outbound from ODS to Point In.

• Policy Detail inbound from Point In to ODS.

All the integration processes are developed in Oracle 11g Fusion Middleware as composites. The errors caputured in the ‘Payroll File Inbound’ are interfaced to the business users in ADF to resolve them.

Responsibilities:

• Designed the technical solution for composites in collaboration with architects .

• Designed the UI in ADF to handle the errors with ADF security handling the authorization and authentication.

• Created the technical documents that encompass the mapping strcutures from source to destination databases fields as per user requirements.

• Used BAM extensively for logging and reporting by creating Data Objects, Reports, Alerts.

• Migrated BAM related objects to other enviroments using Icommand.

• Modified the WSDL urls to exploit the load balancing functionality of the SOA cluster environment.

• Used advanced BPEL 2.0 features viz. foreach, direct binding to improve performance.

• Used the various features/options of Database adaptor like various flavors of polling, TopLink, pure SQL, sequences etc. across all the composites..

• Used DVM to store the static domain data in the system to avoid database calls on code tables..

• Used fault handling and fault policy on error in file adapter..

• Tweaked the properties in Weblogic console and Enterprise Manager (EM) console to fix some critical performance, memory and transaction timeout issues in the system.

• Worked extensively on the File Adapter, developed XSD Schema to format the data in extracted file as per requirement, using pipeline delimiters.

• Used service components like Mediator, BPEL and Human Task to notify business users on business faults.

• The ‘worklist’ app part of the weblogic was used to monitor and process the Human Tasks was used.

• Used MDS to share common assets like XSD, WSDL, Fault Policies etc. Replaced concrete WSDL with abstract WSDL stored in MDS to avoid dependency problems during server startups.

• Created and managed configuration plans to deploy composites to different environments.

• Developed around 15 composites.

• Developed unit test cases for critical SOA composites.

• Involved in the code review.

Environment: Oracle SOA Suite 11.1.1.4 - BPEL 2.0, BPM, Oracle Human Task, Mediators & Adapters, ADF, BAM Server, JDeveloper 11.1.1.4.0, Oracle Weblogic 11g, WSDL, XML, Visio, Oracle SQL Developer.

#RMIS: Jul 2011 – Sep 2011

.The scope of the project included building highly scalable and fault-tolerant system to move high volume live-transactional data from legacy system (FoxPro) sourced in SQLServer databases to Enterprise wide single source system hosted on Oracle. Oracle Fusion Middleware 11g was used to build and implement the solution. On a nightly basis the Agency, Client and Policy Data is moved from SQL Server to the Oracle Data Store and the files were extracted based on the data in the ODS for the downstream processes.

Responsibilities:

• Designed the technical solution in consultation with data architects and application architects.

• Created the mapping documents from source to destination databases fields as per user requirements.

• Created the Data Objects in BAM to be used for logging.

• Used BPEL 2.0 features.

• Used the various features/options of Database adaptor like polling, TopLink, pure SQL, sequences etc. in achieving the required data map from source to target data sources.

• Used DVM to store the static domain data in the system.

• Used the various error handling features of SOA Suite 11g like Fault Management Framework, catch/catch-all branches, compensating transaction etc. to achieve robust error handling.

• Worked extensively on the SOA infrastructure using Weblogic console and Enterprise Manager (EM) console to fix some critical performance, memory and transaction timeout issues in the system.

• Worked extensively on the File Adapter, developed XSD Schema to format the data in extracted file as per requirement, using pipeline delimiters.

• Used MDS to share common assets like XSD, WSDL, Fault Policies etc. .

• Worked on configuration plans to deploy composites to different environments.

• Wrote unit test cases for some critical SOA composites.

• Participated in code review.

Environment: Oracle SOA Suite 11.1.1.4 - BPEL 2.0, BPM, Mediators & Adapters, BAM Server, JDeveloper 11.1.1.4.0, Oracle Weblogic 11g, WSDL, XML, Visio, Oracle SQL Developer, Microsoft SQL Server 08 R2.

Office Depot Inc, Boca Raton, FL Sep 2008 to June 2011

Sr. Oracle SOA Developer

Office Depot, Inc. is a global supplier of office products and services. The company was incorporated in 1986 with the opening of our first retail store in Fort Lauderdale, Florida. The three main business segments are: North American Retail Division, North American Business Solutions Division and International Division. Sales are processed through multiple channels, consisting of office supply stores, a contract sales force, an outbound telephone account management sales force, internet sites, direct marketing catalogs and call centers.

#TDS: Apr 2010 – Jun 2011

This project is for the TDS (Tech Depot Services). One of the services Office Depot offers is Tech Depot Services. This includes the services provided to the customers like laptop repairs and other services.

The aim of this project is to sync the customer data along with the orders realtime in Oracle Apps as the source is from AOPS.

Responsibilities:

• Designing new BPEL processes according to the requirements

• Configuring OSB to throttle the requests.

• Leverage the alerts monitoring on OSB.

• Design and implementing alert notification to verify the system is up always.

• Performing the testing.

• Develop JUnit test cases.

• Schema design for the request / response of the process

• Canonical schema design to accommodate for multiple systems.

• Write custom PL/SQL packages to prep the data before/after calling the seeded APIs.

Environment: Oracle Applications 11.5.10.2, OSB, MQ Series Adapter, Fusion Middleware 11g, Jdeveloper 11g, Weblogic, Linux

# Simplify: Oct 2008 - Mar 2010

This is the North America implementation of the Oracle Application 11.5.10.2. All the customers and orders are created in AOPS, the AS/400 legacy system. As part of this project the customer data has to be moved to Oracle Applications tables as all the financial transactions are carried out here and for that to happen the customer data needs to be present here. Through the BPEL processes all the required entities are moved from AOPS to Oracle Apps CRM tables.

Responsibilities:

• Designing and implementaton of the bpel processes.

• Preparation of Technical Design Documents (MD070) as per AIM methodology.

• Use of seeded Oracle EBIZ Business Object APIs.

• Coding the processes.

• Performing the stress testing and tuning.

• Improving performance

• Leading the enhancement tasks.

Environment: JDeveloper 10.1.3.4, SOA, BPEL, XML, SVN-tortoise, Weblogic, Oracle Fusion, Oracle Applications 11.5.10.2

Schneider National, Green Bay, WI March 2008 to September 2008

Oracle Fusion Middleware Consultant

Schneider National Inc. is a leading provider of transportation, logistics and related services. Schneider National serves more than 80 percent of the Fortune 500® companies, offering the broadest portfolio of services in the industry.

# SNI – Pricing: Mar 2008 – Sep 2008

This module deals with the price to be quoted to Customer and Service Provider when Schneider acts as a 3PL. Various factors like market conditions and the buyer behavior patterns are considered in determining the price. The pricing engine integrates with the OTM (Oracle Transportation Management) product to pass on the price

Responsibilities:

• Designing of the pricing engine for Customer and Service Provider.

• Preparation of Technical Design Documents (MD070) as per AIM methodology.

• Designing the test case scenarios.

• Coding of the Business Service Layer of ADF: Business Components ( BC4Js).

• Preparation of JUnit test cases for unit testing.

• Exposing the Business Services as web service to be consumed in SOA.

• Usage of Oracle Coherence to improve the performance by querying from cache instead of d/b.

• Creation of Business Rules in Oracle Business Rules Engine.

• Creation of deployment profiles and deployment of final code.

• Version control using SVN-tortoise.

Environment: Oracle Fusion,JDeveloper 10.1.3.3.0, SOA, BPEL, XML, ADF, Rules Engine, Coherence, SVN-tortoise, J2EE, OTM, Oracle Applications E-Business Suite 11.5.10.2

DHL, Bracknell, UK Jan 2007 to January 2008

Software Consultant

DHL is the global market leader in international express, overland transport and air freight. It is also the world's number 1 in ocean freight and contract logistics. DHL offers a full range of customized solutions - from express document shipping to supply chain management.

# D2P – Direct to Pharma: May 2007 – Jan 2008

The D2P system is to support pharmaceutical customers’ (Pharmacies, Dispensing Doctors, Hospitals, etc.) ordering of products from DHL and delivery of those products directly to the customers’ locations.

Responsibilities:

• Designing of the UI screens.

• Developing of UI screens in ADF and branding of the screens for DHL look and feel.

• Preparation of Integration Technical Design (ITD) Documents and test plans for the web portal designed

for D2P

• Developing BPEL process flow for Customer creation.

• Interacting and co-ordinating with off-shore team members.

• Branding and customization of OTM pages for DHL look and feel.

• Impact analysis from OTM version 4.0 to 5.5

Environment: Oracle Fusion, JDeveloper 10.1.3.2.0, BPEL, XML, ADF, Web Center for java components, Rules Engine, Oracle E-business Suite 11.5.10.2, J2EE, OTM 5.5

#Receivables/TCA Customer Interface : Jan 2007 – Apr 2007

Worked on Customer Interface Import to create customers from external systems into AR / TCA customers tables.

Responsibilities:

• Responsible for documenting the mapping and requirements for the interfaces and conversions between the source and oracle Applications

• Developed a package to import expense information into Oracle Payables.

• Extracted data from AR / TCA tables and sending a flat file using UTL_FILE package at periodic intervals.

• Registered PL/SQL packages, Request Sets, Forms, and Menus.

• Involved in creating Custom reports for the end users to check the details and errors.

• Customized Employee Listing report, Invoices on Hold report and Suppliers report as per the business requirements.

• Executed the Payables Transfer to General Ledger program and resolved the issues during the process.

• Responsible for the technical and user documentation of the conversions and interfaces.

Environment: Oracle Applications 11.5.10 (AR, TCA),Oracle Fusion, J2EE, Reports 6i, Oracle 9i(SQL,PL/SQL), TOAD, SQL *Loader and UNIX.

Oracle India Pvt Ltd, India Oct 2003 – Dec 2006

Sr. Applications Engineer

# Customer Interface : Jun 2005 – Dec 2006

Loading the Customer Information and the related information from the legacy systems into Oracle Apps

TCA Tables.

Responsibilities:

• Ownership of ‘Customer Interface’ module.

• Done enhancements for Bank upgrade for R12.

• Enhancements for functional gaps like using existing contacts of customer.

• Maintenance of code in 11i.

• Single point of contact for CDH Data Model.

• Usage of Bulk APIs to improve performance.

Environment: Oracle Apps 11i, R12, Pro *C, pl/sql, Oracle 9i, 10g.

# Relationship Manager – TCA Module : Oct 2003 – May 2005

Use Oracle Trading Community Architecture (TCA) Relationship Manager to create and manage relationships among existing parties in the TCA Registry. Using relationships to model the interactions among parties in the TCA Registry helps you make better business decisions.

Responsibilities:

• Ownership of the module.

• Done enhancements for additional functionality.

• Maintenance of code in 11i.

.

Environment: Oracle Apps 11.5.10+, JDeveloper 9i, OA Framework, Oracle PL/SQL, SQL. 10g, 9i

CSX, Jacksonville, FL June 2002 to September 2003

Oracle Developer

# PRISM – Jun 2002 – Sep 2003

Responsibilities:

• Extensively developed PL/SQL Procedures, Functions, Form Triggers and Packages

• Developed custom reports using Reports 6i

• Used TOAD, PL/SQL developer tools for faster application design and developments.

• Creating SQL, Object Views, PL/SQL database objects.

• Used PL/SQL TABLE, VARRAY, RECORDS and OBJECT TYPES.

• Analyzed and prepared Statement of Work and Requirement Definition Document.

• Designed the business logic to eliminate problems and to ensure efficient system functioning.

• Creating the Oracle schema i.e. table spaces, tables, indexes, constraints, triggers, synonyms,

database links, roles etc.

• Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.

Tested the entire application in testing environment and exported to Production.

Environment: Oracle 8i, Java, SQL, PL/SQL, PRISM

Contact this candidate