SUMMARY:

• Over 9 years of total IT experience in software analysis, design and development for various software applications.
• Over 5 years of experience in SOA implementations using Oracle Fusion Middleware Oracle JDeveloper, Oracle Weblogic, SOA Suite and OSB
• Over 3 years of strong Data Warehousing experience in Business Requirement Analysis, Design, Development, Testing, Implementations, Loading, Maintenance and Enhancements of Data warehouse and ODS systems using Informatica and well versed with Data Warehousing Architecture, Technology, Operational Data Store and Dimensional Data Modeling. Have exposure to SAP R3 and R2 Material Management Module.
• In-depth understanding in Service-Oriented Architecture and its related technologies like BPEL, Web Services, WSDL, SOAP, RESTful Web Services , Web Service Security, XML, XSD, XSLT, XQuery and MDS.
• Experience on IDE tools like Oracle JDeveloper and Eclipse OEPE.
• Worked with Oracle SOA Suite SCA composites and components like BPEL, Mediator, Business Rules, Human Workflow and activities like Assign, Invoke, Pick, Receive, While, Switch, Flow, Java embedding, Wait, Email, Transformation, Validate, Dehydrate, Terminate etc. in JDeveloper.
• Experience using the SOA Suite adapters like File, FTP, JMS, AQ, B2B, BAM etc.
• Experience working with Testing, Debugging, and Deployment of Applications.
• Prepared detailed technical design documents for fusion solutions.
• Created Complex synchronous and asynchronous BPEL Processes for orchestrating the business flows end-to-end to meet the business requirements.
• In-depth understanding of OSB and implemented OSB to interact with SOA Composites.
• Integrated SOA composites with external application using B2B adapters.
• Experience in using Human work Flow and Business rules.
• Experienced in troubleshooting Weblogic domains, clusters and servers in distributed environments.
• Created Quartz jobs, DBMS SCHEDULER and Event Delivery to schedule SOA composites.
• Experienced in building robust fault-tolerant Middleware composites using the Oracle Fault Management Framework and catch/compensate activities.
• Experienced in implemented Domain Value Mapping DVM and Xref.
• Worked on BPEL events, Sensors and Oracle Business Activity Monitoring BAM to create dashboards.
• Experience in JMS Architecture, MS Queues ,Connection Factories
• Hands on experience in supporting and implementation of Business Integration for various customers.
• Good Knowledge on ADF frame work and implemented ADF to create bounded and unbound task flow by using entity and view objects to display data.
• Experience in installation, configuration and administration of the Oracle SOA Suite on Development, Test, QA and Production environments.
• Experience in production support and handling enhancements, production tickets.
• Worked extensively with Oracle RDBMS Comfortable with SQL,PL/SQL, and developing various database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.
• Experience in working on different operating systems like Windows and UNIX.
• Heavily interacted with the Source System owners and business users to gather requirements, design tables, standardize interfaces for receiving data from multiple operational sources, coming up with load strategies of loading staging area and data warehouse.
• Extensive knowledge with Dimensional Data modeling, Star / Snowflakes Schema, Fact and Dimension tables.
• Developed various charts and graphs like Bar chart side by side, stacked , line graphs, pie charts etc by using chart expert utility of Crystal reports.
• Good communication and presentation skills.

Core Skills

Professional Experience:

Confidential

Oracle Middleware Lead Developer/Architect

The project is to implement OSB as a mid-layer between third part vendors and Confidential Virtualizes web services created in BPEL and Java implementations. Implementation was divided in to two main streams, Inbound OSB implementation and Outbound OSB implementation.Any third party service requests will be passing through OAG/OSB and transformation/security/validation of the payload to CalHeers Canonical data model is done before calling business services. All the security is implemented using Oracle application Gateway.

Responsibilities:

• Worked with different third party systems and documented the Technical Integration requirements for the project.
• Created Mapping documents for the data elements during the integration process.
• Lead a team of five on-site and enhancements/support team off-shore.
• Involved in creating proxies and implemented asynchronous and synchronous Services through OSB.
• Created Schema's Validations for the data elements involved during Integration Process.
• Converted third-party payload to match client's Canonical data model using XSLT's and XQuery's.
• Implemented security using OAG to secure web services.
• Created polling service in OSB which will poll for records according to business requirement and call other web service. Depending on the process flow in proxy services the table will be updated by a publish activity.
• Created logging services which will insert records to a jms queue. A BPEL process is subscribed to jms queue and depending on the payload message will be routed to various services of the system.
• To overcome the size limit of XSLT on OSB managed server separated single business logic transformation to multiple and combined the outcome of each XSLT to send the final payload to business service.
• Configured fault response with error code and description on OSB when an error occurs based on the Fault Schema.
• Extensively used SVN to check in code and helped in following the best practices to maintain branches with minimum dependencies.
• Involved in Functional Requirement analysis and was part of design implementation which best suits the requirement.
• Extensively used business rules/Human task to orchestrate process flow.
• Created logical roles and mapped them to LDAP users to restrict the operations that can be performed by various users.
• Created Manual/Sync/Async BPM process flows to meet business needs.
• Developed a common Email Process in BPEL using notification service to send the email to concerned person in case of any failure or exception occurs in the flow.
• Used Human Task flow activity and created Business rules to accommodate Business logic.
• Implement old processes into new modules and make sure all the business needs are addressed.
• Extensively worked on XML, XSD and XSLT in order to transform the message from Legacy modules in order to complete a transaction or a process.
• File based MDS repository was used to store all the common artifacts between composites like DVM, XSD, Fault policy and Fault Binding files. Abstract WSDL's were also stored here and any call to a composite through a BPEL is made through abstract WSDL in-order to avoid dependencies problems during server startups.
• Developed Processes in OSB for routing and transformation.
• Used DVM to store the static domain data in the system to avoid database calls on code tables.
• Used policy studio to consume WSDL and created certificated for authorizing the transactions.
• Defined XSD schemas for the various services/web services after careful analysis of the customer requirement and the coarse-grained/fine-grained nature of the function.
• Use error handling framework to log all the errors in the backend and do appropriate action on the fault occurred.
• Extensively used BPEL components and activities for implementing the business logic.
• Developed BPEL modules within SOA Suite for creating services that managed data transformation, business workflow, business processing, data routing, and communication with external systems.
• Configured JNDI Name, Connection Pools and Data Sources to create JMS queue/Topics.
• Combined similar business process web services from BPEL to a single WSDL based implementation on OSB.
• Unit tested the service developed using SOAP UI.
• Created customization template/file which was used by ant scripts to deploy the code various environments.
• Used ant/maven to build and deploy to various environments.

Environment: Oracle SOA Suite 11g, Oracle Weblogic, Jdeveloper, OSB, Oracle 11g,BPM, JIRA, SVN, Maven, Jenkins, Windows, Oracle SQL Developer.

Confidential

Oracle Fusion Developer

The Project is based on Integrating SAP HR with multiple systems such as OIM Oracle Identity Management and other legacy systems .Integration is done using BPEL ESB .When a new Employee joins the Company, Employee data is stored into SAP HR System manually by HR Persons, based on the Hire Data an event gets created in SAP HR and calls the OSB proxy service. The proxy will initiate the business service which in turn initiates BPEL WebService. BPEL process Consumes the data and perform necessary business process and gets back with a Work Order Numbers and sync the data between all the applications. The process of data flow is vice-versa, changes made to the data on OIM or other legacy system will be propagated back to SAP HR module.

Responsibilities:

• Developed and designed several Generic BPEL Processes ESB Services.
• Involved in business meetings ,defined the business processes accordingly to the requirements and develop Business Processes Orchestrated in BPEL, ESB using Oracle J Developer, Eclipse OEPE and SOA Suite for integration processes
• Designed Database Adapters to poll for new records and sync data from multiple systems.
• Designed JMS Adapters to actively send and receive messages from various enterprise systems.
• Created the technical documents that encompass the mapping structures from source to destination databases fields as per user requirements.
• Involved in the configuration of the connection pools and data sources for Database Adapter and on the application server.
• Created Scheduler for BPEL Process using dbms scheduler and quatz jobs.
• Created Fault Policies for Error Handling, Configured and Managed OSB Oracle Service Bus Services.
• Created Queues, Connection Factories, Multi Data sources and Data sources.
• Configured JMS Queues, Connection pools and connection factories to connect to different databases and publish and receive JMS messages.
• Used MDS to share common assets like XSD, WSDL, and Fault Policies etc.
• Used SAP IWAY adapter and also the HTTP Binding adapter to call the RESTful Web services.
• Customized the oracle process integration pack PIP according to the business scenarios.
• Worked on Oracle Financial Management PIP to integrate Transportation Management OTM and Oracle E-Business Suite Financials.
• Attached OWSM policies to services and passing the password information through keys.
• Used DVM to store the static domain data in the system to avoid database calls on code tables.
• Developed Processes in OSB for routing.
• Developed a common Email Process in BPEL using notification service to send the email to concerned person in case of any failure or exception occurs in the flow.
• Implemented Correlation for async business process to route the response back to the appropriate request service and also implemented master/detail work flow patterns to meet the business requirement.
• Working extensively on XQUERY and XSLT transformations in OSB to provide mapping between the consumer and provider business service.
• Implemented Oracle OSB to Validate, transform and filter the incoming data using the proxy service and then routed to the business service.
• Created pipeline pairs with multiple stage configurations which had multiple actions for content based and rule based routing.
• Used BAM for Alerts and Notifications.
• Executed and wrote complex SQL queries to validate data integration
• Responsible for Integration and Unit testing.
• Deployed to multiple environments using ant scripts.

Environment: Oracle SOA Suite 11g, Oracle Weblogic 11g, Jdeveloper, Eclipse OEPE,OSB, Oracle 11g, Oracle Identity Management , Windows, Oracle SQL Developer.

Confidential

Oracle Fusion Developer

The scope of the project included building highly scalable and fault-tolerant system to move high volume live-transactional data from legacy system sourced in SQL Server databases to Enterprise wide single source system hosted on Oracle. The project also included creating and configuring trading partners for document exchange. 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.

Responsibilities:

• Participated in the initial installation and setup of the Fusion middleware software stack on Windows.
• Developed BPEL modules within SOA Suite for creating services that managed data transformation, business workflow, business processing, data routing, and communication with external systems.
• Extensively used BPEL components and activities for implementing the business logic.
• Use error handling framework to log all the errors in the backend and do appropriate action on the fault occurred.
• Defined XSD schemas for the various services/web services after careful analysis of the customer requirement and the coarse-grained/fine-grained nature of the function.
• Developed complex schemas and XSLT transformations to read, enhance and process incoming data and map it to Oracle applications Schemas.
• Analyzed the business needs for the processes and modules that needed migration.
• Implement business rules and set priorities for the incoming messages and integrate with BPEL Work Flow.
• Work with File Adapter, Database Adapter, AQ Adapter, JMS Adapter and Oracle Applications Adapter for establishing connection with services.
• Error handling was also done for handling the faults in BPEL Processes. Business faults were handled using the catch, catchall, throw, compensation and compensation handler activities. The system faults were handled by defining fault-policies in the fault management framework.
• The database MDS repository was used to store all the common artifacts between composites like DVM, XSD, Fault policy and Fault Binding files. Abstract WSDL's were also stored here and any call to a composite through a BPEL is made through abstract WSDL in-order to avoid dependencies problems during server startups.
• Created document definitions, trading partners, listening channels, and trading partner agreements using the Oracle B2B Console.
• Created composite using B2B adapter to poll for files by configuring listening channel and pass the data to BPEL process to route the data to source system.
• Worked on creating batches and scheduling the batch for outbound messages to multiple trading partners.
• Purged design metadata and instance data using B2B interface to better manage the space.
• Worked on HL7 and EDIx12 files.
• Developed user Interfaces for Human Work Flow Interaction using oracle ADF frame work.
• Create and Configure predictive alerts and notify a distribution list when certain conditions are met.
• Developed Composites which includes Mediator Service and BPEL integration architecture to consume and process large data files.
• Involved in code review.
• Design, trouble shoot and implement BPEL solution for integration between application's task workflow.

Environment: Oracle SOA Suite 11g, Oracle Applications, JDeveloper, Oracle Weblogic 11g, SQL Server /Oracle 10g, Windows, Toad.

Confidential

SOA developer

Confidential is a leading health insurance provider and a brand name for health insurance plans underwritten by many other companies. The technical scope of the project was to design, build and implement Enterprise Application Integration EAI using Oracle Fusion Middleware on Weblogic from existing java interfaces. The project involved migration of existing homegrown customer EJB code to SOA platform. It also involved replacing some Java/C /Legacy modules with Oracle SOA BPEL and Oracle OSB services running on Fusion Middleware.

Responsibilities:

• Understanding requirements and existing mock interfaces, interfacing with client and translating the requirements into application and system architecture.
• Designed and built SOA composites and BPEL processes using adapters such as FTP, DB, AQ ,File to extract the data and transformed the data using mediator transformation activity according to the business requirement before inserting into EBS system
• Prepare XML schema, WSDL, integration interfacing and create detailed implementation document for developing EAI System.
• Implement old processes into new modules and make sure all the business needs are addressed.
• Designed XSD's and elaborated type definitions schemas based on corporate standards.
• Participated in the initial installation and setup of Fusion Middleware software stack on Windows/Linux servers. Performed administrative tasks involving creating all the required resource for SOA development platform
• Designing and developing Enterprise Service Bus integration components and artifacts.
• Developed Composites which includes Mediator Service and BPEL integration architecture to consume and process large data files.
• Extensively worked on XML, XSD and XSLT in order to transform the message from Legacy modules in order to complete a transaction or a process.
• Developed Exception Handling architecture in BPEL for the whole project to handle all the exceptions and alerts.
• Implement old processes into new modules and make sure all the business needs are addressed.
• Used embed activity to call java code for complex business needs.
• Developed different SOAP services and Web Services using Oracle JDeveloper.
• Used structural activity like Flow, FlowN, Scope, Switch and While to meet the business requirements.
• Created composite which generate events and the generated events will be picked by other composites once the events are triggred.
• Developed custom XPath functions in ESB to transform messages.
• Developing web services and integrated applications.
• Implemented best practices such as error handling and file archiving.
• Developed a Service Oriented Architecture SOA based design of the collaboration product involving designing and creating schemas and wsdl's web services to develop BPEL processes to integrate various incompatible modules.
• Extensively used java embedding activity for executing custom Java Classes for Complex business logic.
• Design, develop, and deploy the integration process from Oracle JDeveloper.
• Design and implement a generic Error handling and reporting and business process retry mechanism using Oracle AQ and BPEL.
• Installation of BAM, configuring Users and their appropriate roles.
• Deployed BPEL processes and composites in to QA and prod environments.

Environment: Oracle SOA Suite11g/10g, Oracle Weblogic/ OC4J, Jdeveloper , ESB, Unix, Oracle 10g, PL/SQL developer.

Confidential

ETL Developer

The project is to design, develop and test the Time Allocation System TAS for Ameritrade. The objective of the project is to capture the time spent by various prudential employees, at various office locations. Data received from various sources Mainframe, Web sphere logs, spreadsheets... is extracted and loaded into Oracle staging tables. Data from these staging tables is loaded into the fact and dimension tables which in turn populate the summary report tables. The entire process is done using Informatica.

Responsibilities:

• Involved in Data Analysis of existing operational data source and target tables in order to build informatica maps and transformations
• Worked closely with the business analyst understand the source data.
• Loading of data into Data warehouse by scheduling through Informatica sessions.
• Worked extensively in creating the complex mappings using Informtica.
• Responsible for business requirement study, Migration data analysis/design, documentation of informatica ETL implementation
• Worked closely with D/W analysts and developers assigned to specific data marts and multiple business units to pinpoint key factors that would enhance business decision making
• Worked with the management to identify key dimensions and measures for business performance
• Designed a variety of connected and unconnected Lookups based on user requirements
• Involved in the testing of Informatica mappings and update processes.
• Designed and developed mappings using Source qualifier, Aggregator, Joiner, Lookup, Sequence generator, stored procedure, Expression, Filter and Rank transformations.
• Created session variables to build sessions more effectively by using Informatica server manager.
• Used touch files,event-wait tasks for scheduled job runs in Workflow execution.
• Converted jobs from Datastage mappings to Informatica jobs.
• Improve performance in ETL.
• Created prototype in Informatica to optimize the ETL performance.
• Migrated the ETL business logic from DB procedures to Informatica.
• Created Source to Target mapping from existing Procedures
• Created ETL job flow design.
• Developed several complex reports using various features like multiple grouping, drill down, parameterized fields, formulas and conditional formatting using Crystal Reports XI and 10.
• Troubleshoot/research stated issues with reports currently in the production environment
• Ongoing maintenance reports in the production environment.
• Involved in assisting testing team to better understand the design flow.
• Develop ad hoc reports in Crystal Reports v10 and XI

Environment: Informatica, Oracle, Crystal Reports, Unix, PL/SQL

Confidential

ETL Developer

Confidential includes development of data structures and associated processes, adequate to house all data required for the Product Performance Report in a single location to be accessed by a web server and to create and publish print and web the CRM Product Performance Report.

Responsibilities:

• Understanding the conceptual model produced using Object Role Model ORM as the methodology to gather business facts and rules.
• Create functional ETL routines and verify their reliability to ensure compliance of business rules and propagation of data definitions throughout the ETL processes.
• Implement ETL tools - code to extract, transform, correlate, integrate, load and verify data being migrated
• Manage ETL defects, enhancement, and new functionality requests to meet changes in the business needs.
• Identify and investigate data quality/integrity problems, determine impact and provide solutions to problems.
• Understand SQL, PL/SQL scripts and converted the rules to mappings.
• Loading data from Source systems to Stage, built Calculation tables and loading accepted data to publishing.
• Enhance existing data extraction, cleansing, transformation, and loading processes to improve efficiency.
• Designed and implemented an interactive ORACLE form to allow a department to conveniently add, modify and
• delete dental office groupings, and determine the offices associated with them
• Developed SQL scripts, to implement business rules.
• Build Mapping using transformations: Union, Lookup, Joiner, Router, Aggregator, Normalizer and Update strategy
• Enhance existing data extraction, cleansing, transformation, and loading processes to improve efficiency.
• Developed SQL scripts, to implement business rules
• Involved in creating views for PPR Publishing report
• Validate results of all data migrations and review those results
• Involved in unit testing and documenting the processes

Environment: Informatica, Oracle/ SQL Server, Windows, Visio, SQL Developer.