NIKHIL JAIN

SOA SUITE

BPEL, ESB, Rules, OWSM, AIA

APPLICATIONS

 Oracle Applications 11i Manufacturing, Financials, CRM, iprocurement, PO

DATA MODELING

 Erwin (4.1), ERStudio(6.5)

 Function Point Analysis for Effort Estimation. (Minimal)

PROCESS

 Design for Six Sigma Green Belt Certified (DFSS)

OPERATING SYSTEMS

 UNIX – Solaris, AIX

 Windows XP/2000/NT

RDBMS

 Oracle 8i/9i/10g

LANGUAGES

 Java, SQL, PL/SQL, XML

GUI

 TOAD

 Forms 6i

 Reports 6i

WAREHOUSING TOOLS

 Oracle Discoverer (Rel 4.1)

 Oracle Warehouse Builder

CERTIFICATIONS

 Cleared SQL paper of Oracle 9i Certified Professional-DBA Track.

TRAININGS

 Workflow, Projects Foundation, Billing & Costing, iprocurement from Oracle Education.

 Database Modeling (Dimensional) & Oracle Warehouse builder (OWB) from Oracle Education.

AWARDS RECEIVED/PAPERS

PRESENTED

 Two Team Excellence Award for Oracle Applications Team.

 Individual Excellence Award for Bendix/King.com Migration project.

 Team Excellence Award from data management group.

 Spot Award for extending unofficial support during critical delivery period of BMS project.

 Paper presented on sensor effects on pilots for reducing stress during distance flights.

EXPERIENCE SUMMARY

Overall 7 years of IT experience with in depth expertise in Service Oriented Architecture (SOA) and Enterprise Application Integration (EAI) areas including Oracle SOA suite (Oracle BPEL, ESB, WSM, AIA), B2B Integration, client-server, and web based architecture. Experience in software development life cycle including requirements definition, prototyping and proof of concept (POC), design, development, deployment, testing and maintenance.

SPECIALTIES

Software development and consulting

SOA, BPEL, Rules, AIA, OWSM, Workflows, OWB

Oracle Ebusiness Suite (R10 - R12), Oracle Fusion Middleware.

ROLE AS FUSION MIDDLEWARE /AIA INTEGRATION CONSULTANT

Extensive experience as fusion middleware consultant. Implemented various synchronous and polling based interfaces in A2A architecture. Used various technology adapters, Apps adapter Rules and ESB to integrate heterogeneous applications.

Used AIA FP 2.2 for integrating SAP enterprise services with APS. Also worked on troubleshooting of O2C PIP 2.2 for Siebel-EBS Integration.

ROLE AS ORACLE APPS TECHNICAL CONSULTANT

Skilled in doing system Analysis, Discoverer Report Design and Oracle standard report customizations. Strong technical knowledge and experience of Oracle Applications Open Interfaces, APIs, Workflow customizations, iprocurement customization, Concurrent programs etc. Experience with database query tuning and ability to trouble shoot oracle application issues regarding flexfields, concurrent manager processing.

ROLE AS DATABASE MODELER & DEVELOPER

 Established & implemented Data Modeling Standards for the team.

 Interactions with the Customers for Requirement Clarifications.

 Conceptual/Logical Model and getting approval from customer.

 Logical and Physical Modeling (ER Diagram, Physical Properties, Database Sizing).

 Coding of Database Triggers, Procedures, and PL/SQL Packages for projects. Have applied concepts of Autonomous Transactions, Collections, DBMS packages, Native Dynamic Sql.

 Used Erwin, ERStudio

 DB Effort Estimation using Function Point Analysis

EDUCATION

 Preparing for TOGAF certification.

 Currently pursuing MS (Finance) from ICFAI University, India.

 Bachelor of Engineering (B.E.), Nagpur University, July 2001 (72%).

 DAC- Diploma in Advanced Computing from Mumbai. (74%)

PROJECT DETAILS

Fujitsu Consulting, US (Oct 2007 – Till Date)

Dec 08 New Product Development – ‘SAP Connector’, Fujitsu Consulting

TEAM SIZE

4 members

ROLE

• AIA Integration Consultant for onsite Product development.

• FP 2.2 used for integrating SAP and APS (Planning).

• Around 40 EBOs integrated with SAP ABMs.

ENVIRONMENT

UNIX (Sun Solaris), BPELPM 10.1.3.3.1, Oracle 10.2.0, AIA 2.2 FP, SAP (Enterprise Web Services)

Feb 08 – Dec 08 Charter Manufacturing, Milwaukee, WI

TEAM SIZE

7 members

ROLE

• Principal BPEL Solution Architect/Team Lead/Onsite coordinator for overall BPEL Interface development from offshore.

• Task Management, On-time Delivery and overall setup for critical milestones.

• Integration between ERP (OPM R12) and Manufacturing Execution System (MES) in SQL Server 2005.

• Implemented Sequence Polling Mechanism.

• Integrated using OA Adapter for OPM APIs.

• Carried out overall Assessment of existing MES system.

• BPEL Administration and tuning.

ENVIRONMENT

UNIX (Sun Solaris), BPELPM 10.1.3.3.1, Oracle 10.2.0, ERP R12

SYNOPSIS

It’s first implementation of Oracle R12 with any existing MES system. Involves around 25 different inbound and outbound interfaces. Existing Oracle 9i db being replaced by oracle apps R12. Production batches being created in oracle with Lot & other specification data coming form shop floor.

OCT 08 DPI Speciality Foods,CA

ROLE

• AIA Integration Consultant for Create Customer Business Process (POC).

• Mapped Siebel Application data to Customer EBO and also routed to CAVS.

• Used FP 2.0 for Business integration.

• First Client AIA Implementation.

Nov 07 MOVE.COM, CA

ROLE

• Principal BPEL Solution Architect

• Overall Assessment of existing Phase 1 and recommendations for Phase 2.

• Carried out Feasibility study and gap analysis between existing and implemented system.

• Changes to existing orchestrations.

• Created Business flow models for new Phase 2 implementation.

Oct 07- Jan- 08 Fujitsu Inc. Web Service Catalogue, CO

TEAM SIZE

5 members

ROLE

• Oracle Fusion Middleware Developer

• Built various value props, viz, Pricing Approval, BRIX, 3PL Architecture.

• BPEL Workflow for Approval chain hierarchies.

• BPEL Administration and tuning. (Minimal)

• Integrated using OA Adapters, DB adapters for apps modules involved.

• Business flow architecture created.

• Task Management, On-time Delivery and overall setup for critical milestones.

ENVIRONMENT

UNIX (Sun Solaris), BPELPM 10.1.3.2, Oracle 9i, ERP 11.5.10

SYNOPSIS

This program was kicked off to implement web service catalogue for internal Fujitsu group. Number of value propositions was setup to be implemented using oracle fusion middleware, primarily BPEL, Business Rules and ESB. 3PL Architecture is implemented using Oracle B2B Integrator, since it involves cross business interactions.

VIVA USA Inc., US (Feb 2007 – Oct 2007)

Mar 07-Oct 07 Jeppesen Sanderson , CO

Jeppesen Internet Programs

TEAM SIZE

9 members

ROLE

• BPEL Solution Architect

• First Client implementation.

• Developed generic XSDs for Customer and order interface (ERP 11.0.3 & 11.5.10).

• Used DB adapter, File Adapter for outbound and inbound interactions.

• BPEL Administration and tuning.

• Followed Oracle AIM methodology at all SDLC phases.

ENVIRONMENT

UNIX (Sun Solaris), BPELPM 10.1.3.2, Oracle 8i, ERP 11.0.3

NaviSite, Gurgaon (Feb 2006 – Jan 2007)

Mar 06 –Feb 07 Quantum Corporation

Nike-Quantum CRM Implementation

TEAM SIZE

4 members

ROLE

• Oracle Fusion Middleware Developer

• Understood business requirements (MD.050) from onsite and delegated them to the Team Members.

• Used DB adapter, File Adapter for outbound and inbound interactions.

• BPEL Administration and tuning.

• Followed Oracle AIM methodology at all SDLC phases.

• First Client implementation.

ENVIRONMENT

UNIX (Sun Solaris), BPELPM 10.1.3.2, Oracle 9i, ERP 11.5.10

SYNOPSIS

Customer’s claims in EDI and excel format need to be captured in oracle system. Implemented through BPEL and Apps APIs.

Feb 06 –Mar 06 Laser Scope CRM Implementation

Self Implementation

ROLE

• Oracle Fusion Middleware Developer

• First Client implementation.

• Used OA adapter, File Adapter for outbound and inbound interactions.

• Modules involved were Oracle TeleService, Service Contracts and installed Base.

• Followed Oracle AIM methodology at all SDLC phases.

ENVIRONMENT

UNIX (Sun Solaris), BPELPM 10.1.3.2, Oracle 9i, ERP 11.5.10

HONEYWELL, BANGALORE (May 2002 – Feb 2006)

May 03 – Feb 06 Oracle Apps Support for Honeywell Technology Solutions Lab.,

Bangalore (v11.5.9 for AP,PO,PA,GL & v11.5.10 for iProcurement)

TEAM SIZE

4 members

ROLE

• Implemented analytical discoverer reports.

• Workflow customizations.

• Setting up concurrent request programs and sets.

• Implemented interfaces (Supplier Invoice, Requisition and Amex card transactions).

• Implemented Alerts.

• Iprocurement customization.

• Used PL*SQL APIs for triggering concurrent processing single-requests and sets.

• Functionally understood the modules and debugged/modified stored objects.

• Extensively used data loader in apps.

ENVIRONMENT

UNIX (Sun Solaris), Oracle 9i, TOAD

Mar

2004 Improving Peer Review Process of Data Management Group

Green Belt Project

TEAM SIZE

7 members

ROLE

• Usage of DFSS Tools like TMAP, SIPOC, RCA, QFD, PMAP, FMEA to set a new process and identify Critical Inputs for this process.

• Control Plan to implement the new process.

• Metrics Collection (Before & after process improvement).

Jan 03 – Mar 03 STAAR (Service Target Authorization and Approval Rating).

TEAM SIZE

14 members

ENVIRONMENT

UNIX (AIX 5.1), Oracle 8.1.7, ERStudio 6.5, TOAD 7.5

ROLE

• Logical & Physical Modeling.

• Interaction with the Customer for requirements clarifications & DB Design approvals.

• PL/SQL Development.

• Evaluate and recommend solution alternatives.

• DB Support for the Development Team.

• Preparing user/deployment documents.

SYNOPSIS

The STAAR program has been developed to improve the customer (Owner/Operator and OEM) support experience for Honeywell Aerospace products through the worldwide service center network by developing and managing an approval-rating program with metrics.

The combined data shall generate a scorecard, which will ultimately determine the final rating. The rating is categorized as either a Honeywell Authorized Service Center or a Honeywell S.T.A.A.R. Authorized Service Center for a specific product and service level.

Jun 02 – Dec 02 Bendix/King Migration.

TEAM SIZE

6 members

ENVIRONMENT

UNIX (Sun Solaris), Oracle 9i rel2, ERWin 4.1, TOAD 7.5

ROLE

• Logical & Physical Modeling.

• Procedures for migrating data from LDAP to Oracle, SQL scripts, and complex SQL*Loader control files for creating a development database consisting of ~60% production data.

• Evaluate and recommend solution alternatives.

• DB Support for the Development Team.

• Preparing user/deployment documents.

SYNOPSIS

The BK.com website (an order management system) was targeted as a website to be migrated from LDAP to Oracle owning to its high revenue generation capability ($64 mil/year). The common infrastructure will utilize the content management tool, a common security platform, and be hosted in a shared environment at ITG in Tempe. As part of the migration, all the seven database schemas need to be migrated to ITG facility.

May 02 – Apr-03 BPM Projects. (Business Performance Management)

Process Central, Metadata Management, Service Bulletin, Manufacturing Information; Create User Association, PDQA (Product Development & Quality Assurance), Security Badging, Fixed Asset Proposal.

ENVIRONMENT

UNIX (Sun Solaris), Oracle 8i, Erwin, TOAD

ROLE

Logical & Physical Modeling.

Interaction with the Customer for requirements clarifications & DB Design approvals.

PL/SQL Development.

Evaluate and recommend solution alternatives.

DB Support for the Development Team.

Preparing user/deployment documents.

SYNOPSIS

These projects deal with the workflow management of processes accounted-for in their own businesses. BPM helps to align the activities of people and processes to achieve the desired goals.

Contact this candidate