SUMMARY:

• Having 8 years of experience in Oracle Fusion Middleware (SOA, ODI, BPEL Business Rules) designing and development.
• Expertise in Oracle Service Oriented Architecture (SOA) and Oracle data integrator (ODI) with a strong focus on Business Process Execution Language (BPEL).
• Expertise in developing, Testing and deploying BPEL Processes using technology adapters (Oracle Applications, DB Adapter, File Adapter, FTP Adapter, JMS Adapter, AQ Adapter), Fault handling (catch and catchall), MDS, Messaging and Alerts, Transformations, RDBMS.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Experience in developing BPEL, Web Services with WSDL, SOAP, REST, XML technologies.
• Experience with Business systems such as Sales, Inventory and Order Management.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Worked on slowly changing dimensions (SCD), Change data capture (CDC) as part of data warehousing concepts.
• Installed SOA 12c/11g components (Database server, OSB) along with WebLogic Server.
• Experience deploying SOA and OSB projects using ANT SCRIPTS.
• Good Working Knowledge of monitoring tools like MYST and ticketing tools like Service Now and Summus.
• Good Experience to handle the Incident tickets, Change Requests, Problem tickets and Oracle SR's.
• Experienced with Full Project life cycle and well versed with SDLC methodologies and API interface design.
• A highly motivated, energetic individual and a team player with excellent analytical & problem - solving skills, communication skills and interpersonal skills. Worked on SOA governance implementation.
• Understanding for project requirements, attending status calls and project/release specific tasks execution.
• Have worked on orchestrating End-to-End BPEL process using various Design Patterns.
• Extensive administration experience supporting Web Logic Server including installation, configuration, monitoring and deploying applications
• Experience in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
• Integration of the application with third party tools using various Adapter Services available in BPEL
• Expertise in deploying Oracle SOA Suite 12c composite using EM Console and set of command line tools using scripts (ANT and MAVEN).
• Deployed Applications (WAR, JAR, and EAR) in Domain and Clustered environment using WLST.
• Troubleshooting and fixing of problems on Web Logic Application Server, administration working knowledge, monitoring and management for console side.
• Good experience on master data management(MDM-MDR).
• Support working experience on DEV, TEST, UAT and PROD.
• Working experience in developing technical and functional design documents.
• Expertise in SDLC and Agile project managements
• Extensive experience in Handling Faults, Alerting/Notification, Monitoring/Reporting both in ODI and SOA
• Expertise in using design and version control tools like GITHub, UML, Visual SourceSafe, CVS, Subversion.
• Understanding of Data Model and Business process functionality in either Oracle Fusion

TECHNICAL SKILLS:

Integration Technologies: Oracle Fusion Middleware ODI, SOA Web logic 12c

Adapters: FTP, JMS, DB, AQ Adapter, MQ Adapter, IBM MQ, File, Rest

ETL Tools: Informatica 9.5

Databases: Oracle 12c/11g/10g, MS SQL Server

Developer Tools: Oracle JDeveloper, Eclipse, Oracle SQL Developer, UML, NetBeans

Build Tools: Ant, Jenkins

Programming Languages: C++, JAVA, HTML, SQL/PLSQL, BPEL, B2B, OSB, BPM, OAG, MFT

Version control Tools: GitHub, CVS, SVN, Subversion

Ticketing Tools: HPSM, ServiceNow, Summus

Test Tools: Software Quality Assurance (SQA) tools - Mercury Interactive-Test Director, Load Runner, Soap UI, Load UI, JUnit.

Application Server: Web Logic Server, Apache Tomcat, Glassfish Serve Putty, WinSCP

PROFESSIONAL EXPERIENCE:

Confidential - Chicago, IL

Oracle ODI/SOA Developer

Responsibilities:

• Primary responsibility includes installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ELT.
• Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
• Experience in ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Creating Topology, model and load plans in ODI 12C/11G.
• Performed scheduling with ELT jobs using Agents in ODI.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.
• Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load into Oracle data warehouse.
• Responsible for Developing, Design and Orchestration of the requirement on SOA Suite.
• Participated in design discussions with data architects and application architects.
• Created BPEL process for Exception handling, Audit and Error Handling, Email Notifications.
• Fully designed and developed a BPEL process to validate and transform data in Oracle Configuration tables to the Database using Database Adapter.
• Configure and created WebLogic domains, clusters, servers, connection pools, JMS queues and topics.
• Ensure all proper change management and problem management processes are followed
• Perform technical migrations and code migrations between environments
• 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.
• Experience in ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Experience in increasing efficiency of data load from source to target by doing performance tuning such as using Hints, Indexes, analyzing tables.
• Used JDeveloper IDE for coding BPEL Process Models.
• Developed different SOAP services and Web Services using WSDL, SOAP, and Oracle JDeveloper.
• Developed the code with File Adapters, DB Adapters and JMS adapters worked for fault handling.
• Install, configure and administer clustered Oracle WebLogic Server 12c/11g/10g, OSB and Oracle SOA Suite 12c/11g/10g on Linux and Windows platforms in Development, Test, QA and Production.

Environment: Oracle Data Integrator 12c/11g, SOA Suite 12c, Oracle Database Server 12c, JDeveloper 12, Unix, Oracle WebLogic 12c, SQL Developer, SQL*Plus.

Confidential - Chicago, IL

Oracle ODI/SOA Developer

Responsibilities:

• Understanding the requirements & Design Specifications.
• Primary responsibility includes installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ELT.
• Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
• Experience in ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it.
• Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Creating Topology, model and load plans in ODI 12C/11G.
• Performed scheduling with ELT jobs using Agents in ODI.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.
• Experienced in developing Test Plans and Test Case Scenarios.
• Managing the master data MDM-MDR.
• Interacting with Client and updating the status.
• Involved to write technical design documents.
• Analyze the requirements and subsequently development of the integration module.
• Design, develop and deploy Business Processes Orchestrated in BPEL using Oracle JDeveloper and SOA Suite 12c.
• Fully designed and developed a BPEL process to validate and transform data in Oracle Configuration tables to the Database using Database Adapter.
• Worked on JMS, Database, File, Rest and SOAP adapters.
• Implemented Oracle Mediator and integrated with BPEL.
• Used JDeveloper IDE for coding BPEL Process Models.
• Developed different SOAP services and Web Services using WSDL, SOAP, and Oracle JDeveloper.
• Developed the code with File Adapters, DB Adapters and JMS adapters worked for fault handling.
• Implemented best practices such as error handling and file archiving in oracle Mediator.
• Expertise in working with DVM's, involved in designing.
• Integration of the application with third party tools using various Adapter Services available in BPEL.
• Created BPEL process for Exception handling, Audit and Error Handling, Email Notifications
• Created Data sources, JMS modules, JNDI, SMTP.
• Deployed Applications (WAR, JAR, and EAR) in Domain and Clustered environment.
• Tested the web services using Soap UI and EM Console.
• Configured of JDBC connections and Data Sources with Oracle Database server.
• Monitored error logs, fixing the problems and tuning parameters on WebLogic environment.
• Involved to monitor the production servers.
• Developed and fine-tuned PL/SQL stored procedures to increase the performance.
• Install, configure and administer clustered Oracle WebLogic Server 12c/11g/10g, OSB and Oracle SOA Suite 12c/11g/10g on Linux and Windows platforms in Development, Test, QA and Production
• Configure and created WebLogic domains, clusters, servers, connection pools, JMS queues and topics.
• Ensure all proper change management and problem management processes are followed
• Perform technical migrations and code migrations between environments
• Deployment process automation

Environment: Oracle Data Integrator 12c/11g, SOA Suite 12c, OSB 12c, Oracle Database Server 12c, JDeveloper 12, Unix, Oracle WebLogic 12c, JMS Adapter, Putty, GIT, SQL Developer, SQL*Plus.

Confidential

Sr ODI Developer

Responsibilities:

• Primary responsibility includes installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ELT.
• Provided best practices which need to be followed for object migration between environments.
• Gathering requirements from users to develop interfaces, packages, Load Plans.
• Performed loading of delta changes to target table with CDC and Time stamp process.
• Performed Versioning of ODI objects using external versioning tools and using internal ODI versioning using Solutions.
• Resolving Upgrade issues to make sure daily loads run efficiently.
• Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 12c.
• Used Smart export and import for finding dependencies to perform export and import of ODI objects.
• Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
• Experience in using new concept called mapping which is newly introduced in ODI12c.
• Created mappings with joining multiple sources and loading to multiple tables using IN and OUT connectors.
• Worked on Physical and Logical tabs where in physical tab we can choose KM’s and in logical tab we can create mappings.
• Worked on using component panel where we can use functionalities like aggregate, dataset, split, filter, join, set, sort.
• Experience with Business systems such as Sales, Inventory and Order Management.
• Used Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load into Oracle data warehouse
• Experience in increasing efficiency of data load from source to target by doing performance tuning such as using Hints, Indexes, analyzing tables.
• Analyzed the Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for reverse engineering to retrieve metadata from data storage and load it to the repository.
• Applied slowly changing dimensions (SCD) in various Mappings to load data from source to target and maintained current and historical data on year wise in all brand dimensions.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.
• Developed Complete Implementation Plan for Higher Level Environments (includes Build environment/ WebLogic Environment) prior to deployment

Environment: Oracle Data Integrator 12c, Oracle Database Server 12c, Oracle WebLogic 12c, SQL Developer, SQL*Plus.

Confidential

Oracle SOA Developer

Responsibilities:

• Primarily responsible for Developing, Design and Orchestration of the requirement on SOA Suite.
• Involved in requirements gathering, component designing, deployment and testing of the application.
• Involved in developing complex SQL queries, procedures for use With Database Adapter to extract data from Database.
• Configured and deployed resource adapters like AQ Adapter and Applications adapter to WebLogic server and used it SOA suite.
• Implemented SYNC and ASYNC flows based on the client requirement in SOA.
• Implemented Service Decomposition pattern with the combination Proxy Ability pattern for SOA design.
• Installation of Oracle SOA Suite 11g.
• Extensively worked with adapters like DB adapter, File adapter and FTP adapter in developing BPEL process.
• Experience in creating JNDI names for FTP and DB adapter in SOA.
• Used WS-Addressing for ASYNC callback implementation.
• Tested the services in EM console and SOAP UI.
• Exposed services on http, jms, local, sb protocols and soa-direct for routing requests to BPEL.
• Extensively used Service Callouts, Routing tables, Route, Dynamic Route, Publish, Java callouts, transport headers to implement message flow.
• Developing complex composites in Oracle SOA 11g in a way they can be further decomposed into granular processes.
• Used MDS repository to store all the common artifacts between composites like DVM, XSD, Fault policy and Fault Binding files.
• Coordinating with Oracle for SRs and RCAs.
• Working with Offshore- Onshore model.
• Created BPEL process for Exception handling, Audit and Error Handling, Email Notifications.
• Created Data sources, JMS modules, JNDI, SMTP.
• Deployed Applications (WAR, JAR, and EAR) in Domain and Clustered environment using WLST.
• Acted as a single point of contact for all SOA/ODI/OSB related queries/issues.
• Involved in production support for existing SOA services.
• Configured of JDBC connections and Data Sources with Oracle Database server.
• Monitored error logs, fixing the problems and tuning parameters on WebLogic environment.
• Involved to monitor the production servers.

Environment: Oracle Fusion Middleware 11g (Oracle SOA Suite, BPEL, Oracle Business Rules, Mediators & Adapters), JDeveloper 11.1.1.5, 11.1.1.6, Oracle Weblogic 11g.

Confidential

Oracle SOA Developer

Responsibilities:

• Participated in design discussions with data architects and application architects.
• Modified and mapped data from source to destination databases fields as per user requirements.
• Designed lookup code tables to insert ID's in destination for the corresponding source data.
• Logged error messages in BAM if any lookup is not found or in any error/fault case; notified critical errors/ faults through emails from BAM.
• 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 extensively 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 service components like Mediator, BPEL and Human Task.
• Used MDS to share common assets like XSD, WSDL, Fault Policies, DVM etc. Replaced concrete WSDL with Abstract WSDL stored in MDS to avoid dependency problems during server startups.
• Worked on configuration plans to deploy composites in different environments.
• Wrote unit test cases for some critical SOA composites.
• Configured of JDBC connections and Data Sources with Oracle Database server.
• Monitored error logs, fixing the problems and tuning parameters on WebLogic environment.
• Involved to monitor the production servers.
• Participated in code review and design discussions with SOA architects

Environment: Oracle SOA Suite 11g - BPEL 2.0, Oracle Human Task, Mediators & Adapters, BAM Server, JDeveloper 11.1.1.4.0 , Oracle Weblogic 11g, WSDL, XML, JAXB, JAXP, Visio, Oracle SQL Developer, Microsoft SQL Server 08 R2

Confidential

Programmer Analyst

Responsibilities:

• Understanding the functional requirement, analyzing the requirement in technical perspective,
• Create technical document and providing the estimates to business team.
• Created various transformations such as Update Strategy, Look-Up (Connected & Unconnected), Expression, Joiner, Filter and Router Transformations.
• Developed mapping to load data in slowly changing dimensions Update Else Insert and Updated the flag columns whenever a record is inserted or updated to identify the current record.
• Used Mapping Parameters and Session Parameters.
• Creating Workflows and Sessions.
• Tested the mappings to view the data got populated according to specified logics in the technical specification document.
• Involved in Unit Testing, Peer Review.
• Reviewed the Peer mappings and reverted bugs if any were encountered.
• Assisted the users while performing the UAT in SIT environment.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping
• Designer, Mapplet Designer and Transformations Developer.

Environment: Informatica 9.5, Oracle, SQL Developer, Microsoft SQL Server 08 R2