Summary:

* **** ***** ** ********** in IT ,* years as a Datawarehouse BI Consultant and 3+ years as a Fusion Middleware (SOA/BPEL/ESB/BAM) Consultant carried out development on Data Warehouse, Oracle (10g, 9i, 8i), JAVA, JSP,XML Publishers, 1/10g, SQL*Loader and SOA Suite (11g/10g) SOA/BPEL/ESB/BAM

Integrated various disparate systems using SOA Oracle EBS with Agile, Siebel, and 1SYNC.a

Very good knowledge with Oracle AIA foundation pack.

Well experienced with SOA 11g – B2B, SCA, Mediator, Human Tasks and Business Rules.

Expertise in Business Process Integration, Service Orchestration, and Routing using Oracle SOA Suite Fusion Products (BPEL, ESB, Web Services,).

Expertise in developing and deploying BPEL Processes using technology adapters (Oracle

Applications, DB Adapter, File Adapter, FTP Adapter), Fault handling (catch and catchall), Messaging

And Alerts and Transformations

Expertise with BPEL process Orchestration and Enterprise Service Bus (ESB) for integrating ERP applications (Oracle Applications, Hyperion), Databases, legacy applications, Flat Files and Portals.

Experience in SOA Orchestration and Integration Technologies like, ESB, SOAP, WSDL, BPEL, XML, XSD, UDDI, XML, and Web services Security and Virtualization of Services OWSM

Successfully completed SOA Projects using SOA Framework with Oracle Fusion Middleware Components like BPEL / ESB / OWSM and Web services Manager.

Strong experience with Web Services, XML, XSL, XSLT, XPATH, XQuery, WSDL, Java.

Very good knowledge in Canonical Models and Application Integration Architecture (AIA), Oracle Service Bus, SoaSuite 11g, Business Activity Monitor (BAM), Participated in Web Logic/Aqua Logic Implementation Boot Camp

Very Good working Experience in SQL, PL/SQL, Discoverer4i.

Extensive experience in developing PL/SQL Procedures, Functions, Packages and Triggers.

Experienced with Offshore – Onsite Model project with CTS (Cognizant).

Hands on Experience in Oracle Distribution and Manufacturing modules (OM, BOM, and INV), AOL.

Experienced in implementing business process and life cycle of ERP through Workflow Builder. .

Proposed and implemented various in-house tools SQL Trace, TKPROF, Remedy, harvest.

TECHNICAL SKILLS:

Fusion Middleware:

Adapters

Foundation pack

Oracle Application

SOA Suite(11g/10g) ,Oracle Application Server OC4J, Oracle BPEL Process Manager, OWSM, ESB,BAM, UDDI, B2B,SCA,Mediator, Oracle Fusion 11g\ Web logic Sever, Handling Faults and Errors, Human Tasks, Business Rules

Oracle Apps, File, FTP, JMS, DB, AQ/MQ Adapter, ADF-BC Adapter

AIA (2.x)

Oracle E-Business Suite: R11i/R12 – CRM/ERP: i-Store, Install Base, Service Contract, Field Service Technician Portal, Quoting, Customer Support, Sales Online and Customer Online. AP, AR, GL, Order Management (OM), Inventory (INV), Purchasing, Bill of Material (BOM), Work in Process (WIP).

Framework Oracle Applications Framework (OAF), JTT/JTF Framework, ADF

OS UNIX, Sun Solaris, NT/2000 Advanced Servers, Windows, MS-DOS

Languages/Web Technologies SQL & PL/SQL,BPEL JAVA, J2EE, JSP, XML, HTML, XSD, XSLT, X Path, \X Query C,

Database Oracle 11g/10g/9i/8i

Tools/utilities

Others: J Developer 9i/10g/11g, Forms 6i, Reports 6i, Discoverer 4i, Workflow Builder, TOAD, putty, Edit Plus, SSH Secure file, Wok bench, Rational Rose, Eclipse 3.1,

AIM Methodology, Agile\SDLC\Clear Case\Harvest

PROFESSIONAL EXPERIENCE

Amway

GrandRapids ,MI

Oracle SOA Consultant Oct 2011 to Present

Amway is a direct selling company that uses network marketing to sell a variety of products, primarily in the health, beauty, and home care markets.Its product lines include home care products, personal care products, jewelry, electronics, Nutrilite dietary supplements, water purifiers, air purifiers, insurance and cosmetics. In 2004, health and beauty products accounted for nearly 60% of worldwide sales. Amway conducts business through a number of affiliated companies in more than a hundred countries and territories around the world

Responsibilities:

Extensively used Fault and Error handling capabilities (Catch and Catch All), Synchronous and Asynchronous processes, Transformations, XSD, XSLT and X Path

Fully designed and developed a BPEL process to integrate Oracle Applications (E-Business Suite) Inventory Module (INV) with external applications/Flat Files for inbound material transactions. The deployed BPEL process used Oracle Applications Adapters, File Adapters, FTP Adapter and Oracle Material Transaction Open Interface. This Orchestrated BPEL Process had process activities like data conversion, transformation and fault handling

Design and develop SOA Composite having Mediator and BPEL

Greatly analyzed AIA architecture concepts to see the Integration possibilities with Seibel 8.0

Developed custom X Path functions to transform messages

Developed BPEL processes that contain error handling to capture the Remote and Binding faults.

Implemented Oracle Enterprise Service Bus (ESB) and integrated with BPEL.

Developed composite for dynamic read operation using Java Messaging Service (JMS).

Developed Interface Program using PLSQL by mapping the OHI data to AP interface.

Environment: Oracle SOA Suite 11g, Oracle Service Bus ,BAM,Oracle Web logic Server 10.3.2, J developer 11g, Oracle Apps R11i,XML, Web Services, BPEL, Java, SQL,PL SQL, OAF, Oracle BPEL Process Manager,(Oracle Applications, DB, File, FTP, Topic).

DeVry,IL

Oracle SOA Consultant

November 2009 - Current

DeVry University, offers online education includes Keller Graduate School of Management, associate, bachelor's and master's degree programs in technology, healthcare technology, business and management. Advanced academics provides online secondary education to school districts throughout the U.S.

Responsibilities:

Implemented Event Delivery Network functionality.

Setup, configured and worked on JMS, Database, File and SOAP adapters for Oracle ESBCarried out SOA Server Administrative tasks like automating scripts, clustering and performance tuning

Designed and implemented Business Processes using Oracle BPEL PM, J Developer.

Involved in design and development of BPEL processes that contain Human workflow and paging.

Administer and monitor development/test and production SOA servers. Maintain and support Employee related SOA interfaces.

Extensive use of J-dev 11g IDE for coding BPEL Process Models

Environment: Oracle SOA Suite 11g, Oracle Web logic Server 10.3.2, J developer 11g, Oracle Apps R11i,XML, Web Services, BPEL, Java, SQL,PL SQL, OAF, Oracle BPEL Process Manager,(Oracle Applications, DB, File, FTP, AQ, MQ, JMS).

Convergys, OH

DataWarehouse/Fusion Middleware Consultant

October 2008 - October 2009

Convergys is a leader in relationship management, providing solutions to optimize the everyday interactions between customers and employees. Managing and fostering the improvement and adding value to them worldwide to improve their business performance.

Fusion Middleware:

Design, develop and deploy Business Processes Orchestrated in BPEL and ESB using Oracle J Developer and SOA Suite 10.1.3.3

Fully designed and developed a BPEL process to publish legacy data into Oracle E-Business Suite Open interface tables using APPS-Adapter.

Deployed BPEL Suitcases to a specific domain.

Implemented BPEL Process Rejection Handler (File system based).

Performed propagation of E-Business Suits events with Enterprise Service Bus (ESB).

Invoked BPEL Process thru PL/SQL, JAVA Generic API.

Deployed BPEL Process using ANT scripts.

Resolved various issues related to seeded BPEL process on OTM (Oracle Transaction Management) side. Implemented Rule based subscription for Multi consumer Queues in AQ Adapters.

Mapped variables from multiple sources in a transformation.

Trapped Error Message in the Catch All branch of BPEL Process.

Environment: Oracle SOA Suite 10.1.3.3, BPEL, ESB, BAM, Oracle Applications(financials & Supply Chain), (INV, OM, PO, AP, AR, GL), Oracle J Developer, Oracle AS 10.1.3.3, Oracle BPEL PM 10.1.3.3, OWSM, Adapters (Oracle Applications, DB, File, FTP, AQ, MQ, JMS), Oracle Database 10g/9i, PL/SQL developer, Toad, Forms 10g, Reports 10g, BI Publisher,OWB,Cognos.

Department of Health & Human Resources, WV

Cognos Developer

April 2007 – October 2008

Department of Health and Human Resources West Virginia FACTS Project is The Family and Children Tracking System (FACTS) is a customized statewide automated child welfare information system established FACTS was designed and developed based on the requirements established by the U.S. Department of Health and Human Services, administration for children and families, to support the state’s federal reporting for adoption and foster care analysis and reporting system and national child abuse and neglect.

Responsibilities:

Architected high availability Cognos solution to deliver analytic reporting

Designed and developed dashboards to support executive level decisions drillable to line item transactional systems data.

Designed and developed metadata dashboards to track ETL processes, usage tracking, and promote proactive error resolution of nightly batch jobs.

Employed row-level filters, application security and advanced IBot design to report aggregated metrics to individual business units based on data driven business events.

Designed Hyperion Essbase model to support financial planning and forecasting.

Designed and developed the integration of Oracle BI App – Financial Analytics to facilitate advanced financial reporting.

Led the requirements gathering, ETL, and development of reporting layer to provide operational reporting against the financial infrastructure program providing valuable contribution to client IPO.

Environment: Cognos8 BI v8.1, Transformers 7.3, Oracle 10g/11g,OWB.Hyperon,Crystal reports.

Inttra Inc, NJ

Cognos Consultant

March 2006 – April 2007

INTTRA is the preferred global e-commerce shipping platform. It combines advanced solutions for organizing and streamlining shipment processes with one simple connection to the world’s largest network of ocean carriers. At INTTRA reports are developed to find shipment information based on a wide range of criteria and tailor searches for shipments by carrier, vessel/voyage, origin, destination and much more.

Responsibilities:

Migrating Crystal Reports to Cognos 8.

Developed landing pages for each business by using Cognos ReportNet and Cognos 8.

Used Framework Manager to build models, packages and publish packages to the ReportNet Server.

Built models containing query subjects, query items, and name spaces from scratch as well as from imported metadata.

Created published and managed packages.

Planned and created professional reports in Report Studio and used Power Play Transformer.

Conversion of existing Impromptu reports to Report Studio reports.

Assigning tasks to the development team based on the priority basis.

Conducting training to users and business owners.

Creating the catalogs and analyzing the joins.

Creating calculations at the catalog Level.

Environment: Cognos 8 Framework ,Report Studio , Crystal Reports,Windows NT/2000, UNIX Server

First Tennessee Bank, Memphis, TN

Data Warehouse Consultant

January 2005 – February 2006

First Tennessee Bank used as many of the opportunities areas in Cognos ReportNet such as Dashboards, graphics highlight exceptions, and flexible drill-downs to provide flexibility in reports.

Responsibilities:

Designed and developed migration from Cognos Finance financial consolidation system to Hyperion Financial Management (HFM).

Develop , installed, configured and managed financial application and advanced reporting infrastructure server farm.

Designed and developed the extraction of metadata and data from GL, consolidation of financial structure, load and consolidation of multi-dimensional cube and advanced financial reporting analytic layer.

Addressed design challenges included slowly changing dimensions, advanced networking principles and integration of data across multiple technology platforms.

Environment: Cognos 8, ReportNet 1.1MR2 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio), Pentium PC, Solaris Server, Windows NT/2000, UNIX, SQL, Oracle 9i,Hyperion.

CERTIFICATIONS AND TRAINING

BI Author

Data Model Developer

DataWarehouse

EDUCATION

Bachelor of Technology at Jawaharlal Nehru Technological University, India

Varun Kumar

asoe7d@r.postjobfree.com

Contact this candidate