Oracle Management

APOORV JAIN

Oracle Fusion Technical consultant

Synopsis

More than 8 years of experience in Oracle applications.

Oracle Application Development Framework 11g Certified Implementation Specialist by Oracle University.

Worked on technologies like Oracle Fusion: ADF JSF Faces(Application Development Framework).

Deep understanding of Oracle ADF Architecture and strong knowledge of SDLC.

Sound experience of designing, programming, customizing, and testing Oracle Pages using OA Framework.

Conversant knowledge of Web Center 11, JSF life cycle, Jasper Reports.

Core competencies over oracle development tools that enable us to design & develop application, extensions and new technologies to create self-service web pages (from scratch) and to modify standard web service pages using Oracle ADF Faces(Fusion Techstack).

Occasionally liaising clients to understand the new requirements and resolve specific Technical Enhancements.

An experienced team player with excellent communication and interpersonal skills with ability to work independently under pressure. Also can lead, motivate and influence others and can train and mentor subordinates.

Hands on experience on SQL, PL/SQL, HTML and technical tools for data migration.

Organizational/Project Experience

Axtria India Private Limited, India (Apr 2014- Present)

Designation: Engagement Manager

Oracle Fusion Incentive Compensation SAAS Cloud Implementation

Mylan,DSI

Apr 2014 – Present

Scope

Oracle Fusion Incentive compensation Implementation on SAAS Cloud environment, as we are targeting clients in Pharma domain so needed customizations and layers to achieve the requiremnts, so developing additional functionality onPAAS environment.

Also doing RND on ADF essentials (free version of ADF) and deploying that application on glassfish (on IAAS environment) to get rid of licensing cost.

Roles & Responsibilities

Develop custom functionality to provide add on to customer on base oracle fusion SAAS implementation.

Provided some out of box solution for UI which allowed us minimal changes during the several releases.

Working on application using ADF Essentials, MS SQL server, and Glassfish server, to provide more options to client, and provide more efficient system, with less licensing cost.

Provided custom solutions for PDF reports using Jasper reports (open source).

Building responsive UI (targeting tablets and mobile) also used new components such as deck, drawer, grids, sunburn, timeline, hierarchy viewer, Sprigboard.

Tools & Technologies

ADF, HTML, SQL, JDeveloper 12c, Oracle Fusion IC Webservices, iReport, Glassfish server 3.1.2, Oracle JAVA Cloud and Oracle DB cloud.

Capgemini India Private Limited, India (Jan 2012- Present)

Designation: Senior Consultant

Delta Dental

Delta Dental(Oracle GSD)

June 2012 – Present

Scope

The Enrollee Management/Maintenance Application is required to perform/provide functions to support the Delta Dental’s Client/ Enrollee management. This Enrollee Management/Maintenance Application (EMA) tool will enable the Delta dental Agents/Clients to enroll user for insurance under a centralised system. This will enable Delta Dental and their Agents to follow company policies without any discrepancy of data and manage the Client as committed. To develop EMA Application we have used ADF and customized some of the components to get the desired results.

Roles & Responsibilities

Develop custom screens based on Services exposed; creating data control using EJB.

Provided some out of box solution for UI which allowed us minimal changes during the several releases.

For Read only pages used ADFBC components, created custom components for reusability.

Provided custom solutions for PDF reports using Jasper reports (open source).

Worked on tuning of application, for better scalability.

Tools & Technologies

ADF, HTML, SQL, JDeveloper 11.1.1.6.0, Webservices, iReport.

GE IPPM

GE HealthCare(Oracle GSD)

Jan 2012 – June 2012

Scope

The Enterprise Project Portfolio Management of the IPPM suite is required to perform/provide functions to support the GE Healthcare’s Installation project management. This Project & Portfolio Management (PPM) tool will enable the Install Services for managing equipment orders & identification and mitigation of risks and issues. This will enable the Project Managers and Regional teams making installation decisions and manage the project timelines as committed to GEHC customers. To develop Custom applications in ADF and to integrate it with Primavera P6 via BPM and Webservices.

Roles & Responsibilities

Develop custom screens based on Human task from BPM and provide the changes done by user back to BPM.

Create Multilingual Templates for the letters based on input from BPM, conditionally render them based on the language attribute coming from BPM.

Provided some out of box solution for UI which allowed us minimal changes during the several releases.

Created custom application for Resource Assignment and Resource Management using webservices in ADF.

Tools & Technologies

ADF, HTML, SQL, JDeveloper 11.1.1.5.0, BPM, Webservices.

Fujitsu Consulting India Private Limited, Noida, India (April 2008 – Dec 2011)

Designation: Technical Consultant

EBAB Portal

Abu Dhabi Ports Company

November 2010 – December 2011

Scope

This project was our first implementation of Web Center 11 and with custom ADF application with it.

Roles & Responsibilities

Customized and developed on webcenter’s basic package.

Developed Custom hierarchical chart in ADF 11g and migrated it with webcenter.

Integrated webcenter with OID, OAM and configure the weblogic server.

Tools & Technologies

Web center 11, ADF, SQL, PL/SQL, JDeveloper 11.1.1.3.4, OC4J, Oracle 10g, Java, JDBC.

Schreiber Foods Inc US

Milk procurement System Upgrade

May 2010 – November 2010

Scope

This Project was upgarade of previously implemented project done in 10.1.3.4 to 11.1.1.2.0

Roles &

Responsibilities

Upgrade contains use of bounded Taskflows where all pages were replaced by the jsff Regions and those regions were dynamically opened on the Welcome page as a new tab.

Used Latest 11g ADF components to achieve user friendly UI, with some customized components.

Handled Sequence on commit so that Sequence is never lost, which helped client in Auditing purposes.

Handled multi organizational environment, created custom logger class for logging purpose.

Tools & Technologies

ADF, SQL, PL/SQL, JDeveloper 11.1.1.2.0, Oracle 10g, Java, JDBC

Fujitsu America Inc US

Implementation & Integration with Fujitsu America

Oct 2009 – April 2010

Scope

Fujitsu America Integration project involved complete Implementation and integration of their legacy systems all over world in phases, also involving Technical designing of management level reports, using 3rd party tools and integrating them with web portal.

Roles & Responsibilities

Currently developing custom OAF application to Show eror and logs generated.

Integrated BPEL webservices to the Audit Log page to get details directly from SOA Server.

Added functionality to download file from server through OAF page.

Developed Integrated Management level reports (using Jasper) with Oracle portal. Worked as offshore Team lead.

Gathering data and functional document from onsite Developing Management level reports using Jasper Reports and integrating them with oracle web portal.

Tools & Technologies

iRreport 3.1.2, Jasper Server 3.5, Oracle Application Server 10.1.3,Oracle Portal 10.1.4.

Schreiber Foods Inc US

Milk procurement System

March 2009 – Oct 2009

Scope

MPS project is a J2EE application being developed in Oracle ADF Faces (Fusion Techstack), from scratch. MPS is to capture the flow on screen at each checkpoint so that later data can be used to generate report and can be merged with Oracle Applications. This Project has two phases first phase will have development of the application based on Oracle ADF Faces and 2nd phase is to merge the application with the oracle APPS.

Roles & Responsibilities

This is a J2EE application being developed in Oracle ADF Faces (Fusion Techs tack), from scratch.

This tool contains more than 30 core pages as well as business pages.

Involved in first phase of application to develop and design of core pages as well as business pages.

It also includes some system essential reporting using Jasper reports.

Worked on Linking of Jasper reports to jDeveloper.

Only person in technical support for the application.

Tools & Technologies

ADF, JSF, SQL, PL/SQL JDeveloper 10.1.4, OC4J, Oracle 9i, Java, JDBC.

Fujitsu India Inc

Operation Management System

May 2008 – March 2009

Scope

OMS tool is a J2EE application being developed in Oracle ADF Faces (Fusion Techstack) .OMS automated Competency management and Resource Management in Oracle Practice. When en employee logs in OMS, he would assigned either of the roles based on his/her designation or by setup.

Roles & Responsibilities

This is a J2EE application being developed in Oracle ADF Faces(Fusion Techstack), from scratch.

The tool contain over 50 web screens, java schdule and mail implementation .

This tool will baiscally handle entire resource managment and competancy matrix managment.

It also includes some system essential reporting using Jasper reports in XML using Apache POI and Itext, open source java libraries.

Worked as technical Developer for this tool, understanding the requirement of client and then technically designing and coding of the tool.

Tools & Technologies

ADF, JSF, SQL, PL/SQL, JavaScript, JDeveloper 10.1.3, OC4J, Oracle Application Server, Oracle 9i, Java, JDBC, Java Mail.

Simplex Software Solution Pvt Ltd. Gurgaon, India (Feb 2007 – April 2008)

Designation: Trainee, Developer & Team member

Microhouse Net Ltd.( Offshore Client)

Implementation & Support of Oracle Apps

July 2007 – April 2008

Scope

Microhouse Net Ltd. has been Information Systems Consultants & Software Solutions provider to companies and organizations. This project involved Implementation of Oracle eBusiness suite 11.5.10 and integration with legacy systems in phases, also involving Technical Customizations primarily in Reports, Data Conversions and Interfaces and support for implemented modules.

Roles

Involved in creating Interfaces.

Working as a Team member for modifying PL/SQL queries for Customization of Reports.

Design, Program, Customization and test of Oracle Pages using the OA Framework (Standard iProcurement pages).

Worked as a Technical Support.

Tools & Technologies

Oracle Applications 11.5.10/ 11i (AP, INV), SQL, PL/SQL, Developer/2000 (Reports 6i), SQL*Loader, OA Framework

Skills and Competency

ERP

Oracle Fusion, Web Center, Oracle Applications 11i/12 (AOL, INV)

IDE

JDeveloper (12c,11g,10.3.3,10.3.4) (OAF patch 4045639)

Database

Oracle 9i/10g, XE

Languages

SQL, PL/SQL, Java, HTML, ADF JSF Faces

Known Concepts

SDLC (AIM), Multi Org.

Tools

iReport(3.1.2),jDeveloper(12c,11g,10.3.3,10.3.4),Toad, SQL*Loader, FNDLOAD, Lob Editor, Filezilla

Certifications

1Z0-554-ENU: Oracle Application Development Framework 11g Certified Implementation Specialist by Oracle University.

Academic Credentials

B.E (CSE)

APEEJAY Engineering College Sohna Gurgaon

67%

2007

12th

K.V. No.2, Delhi Cantt /CBSE

56%

2002

10th

K.V. No.1, Delhi Cantt /CBSE

72.8%

2000

Passport Details

Name On Passport

Apoorav

Passport Number

G9842953

Issue Date:

26/8/2008

Expiration Date:

25/8/2018

Country

India

Date:

Place: (APOORV JAIN)

Contact this candidate