Oracle Techno Functional consultant

Venkateswarlu Boddapati

Professional Summary

Currently working as Senior Oracle Apps Techno-Functional Consultant at AMMROC, Abu Dhabi, UAE.

Oracle Certified Java Programmer with 11+ years of experience in various phases of Oracle Apps Implementations, development and Production support

Vast experience in OAF customizations, Extensions, Interfaces, Conversions, BI Publisher Reports, Java, SQL, PL/SQL, Forms, Reports and Work flow.

Worked on technical components in Oracle EBS modules eAM, CMRO and SCM.

Adept at writing SQL queries and procedures in PL/SQL.

Very good knowledge on Endeca.

Experience in data migration from legacy systems using SQL LOADER, UTL_FILE, Partitioned tables etc.

Good exposure in performance tuning using SQLTXPLAIN, Trace and Tkprof

Worked on Requirements gathering and provide solutions to complex system requirements, review technical specifications of system enhancements and development of new features/products/enhancements for R12.2.

Good knowledge on P2P and O2C cycles.

Good experience in preparing documents : BR100, MD50, MD70, TE40, CV20 and MD120

Extensive experience in Customer Interactions.

Experience in preparation of user manuals and provided training to the users based on the roles.

A self-motivated individual with strong analytical, interpersonal and innovative skills.

Successfully mentored new joiners and lateral entrants.

Work Experience

Working as Senior Oracle Apps Techno-Functional Consultant at AMMROC, Abu Dhabi since December 2015.

Worked as Lead Oracle Apps Techno-Functional Consultant at Qatar Airways, Qatar from July 2014 to November 2015.

Worked as Project Lead at Oracle India Pvt Ltd, Hyderabad from October 2007 to July 2014.

Worked as Senior IT Engineer at CMC Ltd (Acquired by Tata Sons) from July 2006 to October 2007.

Worked as IT Engineer at TCS from July 2005 to June 2006.

Educational Qualifications

M.C.A from GITAM University with 72% (2002 - 2005)

B.C.A from Nagarjuna University with 72% (1999 – 2002)

Intermediate from Board of Intermediate Education with 87% (1997 – 1999)

S.S.C from Board of Secondary Education with 77% (1996 – 1997)

Professional Skills

Technologies and Languages

Oracle Application Framework, OAF, Flex fields, AOL

BI Publisher

Oracle Workflow Builder, Business Events

Interfaces and Conversions

Oracle Application Implementation Methodology(AIM)

Oracle Forms, Oracle Reports and Personalization

Oracle EBS Endeca Extensions( Clover, Studio pages, ETL, OAF Integration)

Forms/OAF Personalization, Extensions and Customizations

Java 5.0( Collections, Multithreading, Generics, Annotations etc)

Java, Servlets, JSP

PLSQL

HTML, XML, CSS. JavaScript

Shell Scripting(Unix/Linux)

SQL*Loader

Assignments Summary

Senior Oracle Apps Techno-Functional Consultant at AMMROC, Abu Dhabi, UAE from December 2015 – till date

Project #1

Oracle Applications( SCM, eAM, CMRO-Complex Maintenance, Repair, and Overhaul module R12.2.5)

Period

Jan 2015 – till date

Role

Senior Oracle Apps Technical Consultant

Customer

AMMROC, Abu Dhabi, UAE

Responsibilities

1.Understanding the current business process, client requirement (MD50) related to eAM, MRO services, SCM and Finance areas, preparing technical design documents (MD70) and developing the components.(Self service pages using OAF, BI Publisher reports, Oracle Workflows etc) by adhering to Oracle Methodologies (BR100, MD050)

2.Analyzing the client requirement and development of enhancements/customizations such as BI publisher reports, OAF/BC4J components, PL/SQL objects.

3.Provide user support, handholding and respond to queries in Configuration, Engineering, Planning and Execution (cMRO).

4.Perform root cause analysis for frequently occurring issues and provide permanent fix.

5.Evaluate requirements from users, prepare change requests for approval from management with solution approach, with effort and cost estimates

6.Raise support tickets with Oracle support and follow up for solution.

7.Coordinate with Oracle support, DBA, Functional and Technical consultant and other Functional consultants for implementing bug fixes.

8.Providing production support for R12.1.3.

9.Mapping the client's requirement to the Oracle applications standard process and mentoring/leading the team.

10.Preparing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).

11.Analyzing the Performance issues reported in production using the tools like TRACE, TKPROF and AWR reports.

The Project

Oracle Complex Maintenance, Repair, and Overhaul (Oracle cMRO) is both an aircraft maintenance application for transportation and defense operations and an MRO service application for aerospace and defense manufacturers. Only Oracle cMRO's unique service-model design enables accurate and responsive collaboration among all parties involved in air fleet maintenance. Oracle cMRO integrates service supply chain planning, scheduling, and fleet configuration management capabilities in a single, real-time information system.

Operating System

Windows 7 and Linux

Software

OAF, Java, JSP, PLSQL, BI Publisher, AOL, Forms, Reports, JDeveloper, Workflow builder, Toad, SVN

Work Location

Abu Dhabi, UAE

Lead Oracle Apps Techno-Functional Consultant at Qatar Airways, Doha, Qatar from July 2014 – November 2015

Involved in implementation of eAM for the facilities management at Hamad International Airport, subsidiary company of Qatar Airways Group.

Involved in requirements gathering, process mapping sessions, data gathering, data loading, personalization’s, extensions, customizations, documentation and training.

Providing eAM system support which includes resolving issues, improving performance, working on enhancements and next phases.

Project #2

eAM implementation for HIA Facilities

Period

Jul 2014 – Nov 2015

Role

Senior Oracle Apps Technical Consultant

Company

HIA (Hamad International Airport), Qatar Airways Group, Qatar.

Responsibilities

Conducted business process mapping sessions and gathered client requirements

Analyzing the client requirement and development of Extensions/customizations such as OAF/BC4J components, BI publisher reports, PLSQL objects.

Developed new OAF pages for contingent worker creation requirement

Developed conversions for data loading

Extended work request page to meet the business requirements

Supported the team in development of mobile app and dashboards

Developed notification programs to send the email to requestor upon work order creation and completion

Evaluate requirements from users, prepare change requests for approval from management with solution approach, with effort and cost estimates

Trained 200+ users on the business processes

Raise support tickets with Oracle support and follow up for solution

Coordinate with Oracle support, DBA, Functional and Technical consultant and other Functional consultants for implementing bug fixes

Coordinate with other application consultants for issue fixing and proactively prevent issue occurrence for existing customizations

Providing production support for R12.1.3

Preparing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).

Analyzing the Performance issues reported in production using the tools like TRACE, TKPROF and AWR reports.

The Project

HIA is the international Airport for Doha, Qatar. This project is to implement eAM for 14 Facilities at HIA with huge database of 250,000 assets. It is very critical in terms of the preventive maintenance carried out to ensure smooth operations at the airport, in terms of the asset hierarchy to be able to find an asset quickly to log a work request upon a complaint and to be able to report the

Operating System

Windows 7 and Linux

Software

OAF, Java, SQL, PLSQL, AOL, JDeveloper, Workflow builder, Toad, BI Publisher, Forms, Reports

Work Location

Doha, Qatar

Project Lead at Oracle India Private Limited, Hyderabad from October 2007 – July 2014

Experience in Oracle Applications–Enterprise Asset Management (eAM) and integrating points with SCM modules

Roles and Responsibilities at Oracle involve leading the teams working on new features & releases, R&D Activities and working on POCs, Mentoring team members.

Developed OAF pages as part of new projects.

Maintenance work includes Diagnosing/analyzing and bug fixing across the modules.

As a team lead handled new features viz Linear Asset Management, Safety Enhancements - Permit and Work Clearance.

Worked on Design and development of eAM & IB Endeca integration with EBS

Worked on many other minor ERs Asset Number Change, Defaulting work order completion date, etc.,

Worked on ERs related to Assets and Asset Routes

Primary Contact for Endeca for eAM and Installed Base

Project #3

Linear Asset Management (LAM)

Environment

Oracle Applications 12.2.4, OA Framework, GIS, Map Viewer, Java, PL/SQL, Oracle 11g, Oracle SQL Developer

Role Played

Design and development of Linear Asset Management functionality in eAM. Worked on Map viewer which is used to present Linear Assets, their properties and the work in geographical format.

Team Size

15

Responsibilities

Leading the team in product delivery

Developed new OAF pages and PL/SQL APIs

Map viewer integration with GIS

Description

This project deals with design and development of Linear Asset Management solution in eAM. Linear Assets are the assets which are spanned across geographies. E.g.: Roads, Railways, Pipe networks etc. For each linear asset, system captures the segments, properties, elements and relationships with other linear assets (Parallel, intersecting etc). Map viewer draws the entire linear asset on the geographical system using coordinates which helps in locating the portion where the problem occurred and proceeding with the work resolution.

Project #4

Endeca Integration for eAM and Installed Base (12.1.3 and 12.2)

Environment

Endeca Integrator, Endeca Studio, Oracle Applications R12.1, OA Framework, Java, PL/SQL, Oracle 11g, Oracle SQL Navigator, ARCS System.

Role Played

Lead: Functional Design Document (FDD), Technical Design Document (TDD), Coding, Unit Testing, Integration Testing

Team Size

3

Responsibilities

Developed complex views to fetch and load data from EBS tables to Endeca

Developed studio pages

Developed ETL graphs to load data

Integrated endeca pages with OAF

Description

This project deals with integrating endeca search capabilities with EBS functionality. This feature enables user to perform a quick search and to evaluate the compliance of the work with the help of charts and metrics. This also enables user to navigate to EBS pages for performing the transactions

Project #5

Safety Enhancements (12.1.3 and 12.2)

Environment

Oracle Applications R12.1 (eAM, WIP), OA Framework, Java, PL/SQL, Oracle 11g, Oracle SQL Navigator, ARCS System, Oracle’s Developer 2000 (Oracle Forms 6i).

Role Played

Lead: Worked on Functional Design Document (FDD), Technical Design Document (TDD), Coding, Unit Testing, Integration Testing

Team Size

7

Responsibilities

Developed new OAF pages and PL/SQL APIs

Developed work flow for work permit and work clearance

Developed reports for work permit and work clearance

Changed existing work order pages to integrate with work permit and work clearance

Created new tables and views

Description

This is a 12.1.3/12.2 Project wherein we introduced a new feature called Safety enhancements, which enables to take permit, clearance on a maintenance work that is being performed on hazardous machinery or equipment to prevent any unexpected injury to the resource who performs the maintenance work. The machinery or equipment will be isolated by being locked and tagged out. Energy sources could include mechanical, electrical, hydraulic, pneumatic, chemical, and thermal.

Project #6

Asset Move Workbench (Feature Pack of R12)

Environment

Oracle Applications R12.1 (eAM, Inventory, Install Base, Asset Tracking (EIB)), OA Framework, Java, PL/SQL, Oracle 10g, Oracle SQL Navigator, ARCS System, Oracle Forms 6i.

Role Played

Lead: Functional Design Document (FDD), Technical Design Document (TDD), Coding, Unit Testing, Integration Testing

Team Size

3

Responsibilities

Developed new OAF pages

Coordinated with inventory team for integration

Coding and unit testing

L3 Development support

Description

From Release 12 onwards we have started supporting transactable Assets and to facilitate more user friendly way of leveraging this feature for customers who have assets and/or asset-hierarchy which move between organizations for various business reasons.

Project #7

Express Work Order (Feature Pack of R12)

Environment

Oracle Applications R12.1 (eAM), OA Framework, Java, PL/SQL, Oracle 10g, Oracle SQL Navigator, ARCS System.

Role Played

Design and Development: Technical Design Document (TDD), Coding, Unit Testing, Integration Testing

Team Size

4

Responsibilities

Developed new OAF pages

Worked on integration with Quality

Coding and unit testing

Conference calls with customers

Description

From Release 11i, there exists the concept of “work order “, which is the backbone of the Enterprise asset management (eAM) product.

But in earlier releases, to complete a work order there are quite a number of flows and a user has to navigate through different pages from the time onwards the creation of work order, issue the material, charge it, complete it etc., All these flows are covered in one single page and in one flow, which enables the user to raise and report the work related to maintenance activity at a single shot.

Project #8

Maintenance Project–Enterprise Asset Management(eAM)

Environment

Oracle Applications 11.5.10, R12, 12.1 and 12.2 (eAM, Inventory, Install Base, Costing and Purchasing), OA Framework, Java, PL/SQL, Oracle 10g, Oracle SQL Navigator, ARCS System.

Role Played

Lead and Manage: Includes Customer Interaction, Analyzing and advising on the issues customers face during the implementation of the product and Fixing the issues raised by the customers

Team Size

12

Responsibilities

Providing fixes to the issues raised by customers

Coordinating with Oracle support in understanding the issues

Conference calls with customers to analyze the issues

Answering queries raised by customers through oracle support

Description

Oracle Applications’ eAM deals with the Maintenance of the Assets owned by an organization from the time of inception of the asset into the Organization till the end of its expiry. It also Includes integration with other modules of the oracle like Inventory, WIP(Work In Progress), Install Base, Oracle Asset Tracking.

CMC Ltd (acquired by Tata Sons) from July 2005 to October 2007 as IT Engineer

Project #9

NewMACH

Duration

July 2006 to October 2007

Location

CMC Ltd, Gachibowli, Hyderabad

Customer

Mundra International Container Terminal

Environment

Java, Swings, EJB 3.0, SQL, Oracle JDeveloper, Optimize IT, Visual Source Safe, PLSQL Developer, Mercury Test Director

Role Played

Team Member

Team Size

10

Responsibilities

Developing new screens using swings

Coordinating with other teams in integration points

Coordinating with users and fixing the issues

Unit testing

Description

NewMACH is a single system for terminal management. This covers various types of operations related to containers, general cargo, yard & ship planning. It integrates all informational requirements of the terminal and the enterprise. Worked in the Rail and Yard Modules. Rail Module covers discharging and loading of containers from and to the train. Yard module covers all the activities related to placing of containers in the yard.

Project #10

ISIS

Duration

July 2005 to July 2007

Location

TCS, Deccan Park, Hyderabad

Customer

P&O Ports

Environment

Java, Swings, SQL, BC4J, Oracle JDeveloper, Optimize IT, Visual Source Safe, Rational Clear Case, PLSQL Developer, Crystal Enterprise 10, Mercury Test Director

Role Played

Team Member and Team Lead

Team Size

5

Responsibilities

Developing new screens using swings

Coordinating with other teams in integration points

Coordinating with users and fixing the issues

Unit testing

Description

Project ISIS is the definition, development and deployment of the P&O Ports’ Integrated Stevedoring Information System. ISIS is a single system encompassing aspects of stevedoring and terminal management. This covers various types of operations related to containers, general cargo, autos, billing, yard & ship planning, labour management and assets’ management. It integrates all informational requirements of the terminal and the enterprise. I worked in ISIS for Rail Module. This covers discharging and loading of containers from and on to the train.

Professional certifications

Cleared SCJP 1.4 (Sun Certified Java Programmer) with 96%.

Achievements

Received appreciation from business for loading the critical life & safety assets and getting the system ready for preventive maintenance at Hamad International Airport, Qatar Airways.

Received ‘Extra Mile’ award while working on Endeca Project in Oracle India Pvt Ltd.

Received ‘award for working beyond the role in stabilizing the project’ in ISIS project at TCS.

Secured 191 rank in ICET 2002.

Personal Details

Date of Birth : 05-Jun-1982

Nationality : Indian

Gender : Male

Marital Status : Married

Passport Details

Contact this candidate