Post Job Free

Resume

Sign in

Developer Oracle

Location:
Noida, Uttar Pradesh, India
Posted:
February 24, 2021

Contact this candidate

Resume:

Flat No *** Skytech Merion Residency Phase * Crossing Republik

Ghaziabad, 201016

Email id:- adkgga@r.postjobfree.com

Cell: +91-98-712*****

Govinda Gupta

OBJECTIVE

To always be open to walk the extra mile and take on some additional responsibilities or tasks which may not be in my job description, so as to get exposure outside my current role & build a network across the company.

EMPLOYMENT HISTORY

Serial

Organization

Role

Designation

Duration

1

Fujitsu Consulting India

Software developer

IT Consultant

15-Feb-2010 to 30-Nov-2012

2

Stryker global technology

Software Engineer

Software Engineer

03-Dec-2012 to 17-Aug-2015

3

IBM India Pvt. Ltd.

Application Developer

Oracle Techno Functional Consultant

18-Aug-2015 to Till Date

Profile

Currently working as an Oracle EBS techno/Functional consultant with IBM India

IT industry experience encompassing a wide range of skill set, roles and industry verticals.

Extensive experience with analysis, design, development, customizations and implementation of Oracle E Business Suite.

Proficient in analyzing and translating business requirements to technical requirements and architecture.

Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Experience in customizations and development in Oracle E Business Suite.I am working in Oracle SQL, Pl/SQL, Forms and Reports Developer, Workflow, XML Publisher and SCM, HRMS, Financial module.

Knowledge on Oracle Cloud OIC/ICS

Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Experience in Technical documentation using AIM Methodology

Skill Set

Technology: Oracle Apps11i,R12, PLSQL, SQL, Forms,Reports,Advance Queues

Development Tools: RICEW,Workflow, XML Publisher, Data Templates reports, Performance Tuning, Form Personalization, Oracle Reports, Oracle Forms, Oracle Discoverer 10g, TOAD, SQL Developer, ZEBRA Label designer

Knowledge Areas: Cloud (OIC,ICS),FAH

Others: AOL Concurrent Managers

Modules: SCM (O2C, P2P), Financials (AP,AR,GL),HRMS

Database: Oracle 9i, Oracle10g

Education:

Master of Computer Application(MCA) UPTU University, UP, India,

B.com Pass Delhi University, India

AUG 15 – Till date, System Advisory Consultant IBM India Pvt. Ltd. India

Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents

Present and defend product designs and architecture to clients

I am working in Oracle SQL, Pl/SQL, Forms and Reports Developer, XML Publisher and SCM module.

Project details

26/Feb/2018 – Till Date

AMEX Export Blue

Project Description: The American Express Company(Amex), is an multinational financial services corporation. The company is best known for its charge card, credit card, and traveler's cheque businesses. American Express has got Oracle Financial, Billing and report system implemented.

The scope of this project is to provide incident and problem resolution for incidents in Oracle Applications and Business Intelligence Applications. Consolidation Hub is replaced by HFM for consolidations. IBM AMS Team will provide issue resolution to AMEX Oracle GL Team, Sub ledger Team (Singapore and US) and business users.: Worked as a senior application developer for supporting of existing objects in financial modules (GL & SL).

•Work directly with oracle EBS functional specialists or business users to thoroughly understand functional & technical requirements to produce highly effective technical design documentation using best practice development standards.

•Design various technical specifications and documents on oracle applications and prepare reports and revise same and coordinate with all system and Database administrators to implement all patches and fixes and provide support to all technical activities and prepare efficient plans for same.

•Working with users on oracle application related setup issues in GL and SL modules & Responsible for raising SR with oracle for standard data fixes.

•Troubleshooting Oracle EBS issues including performance tuning of sql/PLSQL code, Workflow, forms, reports, concurrent programs and processes & fix defects reported by the users of customized programs.

•Provide an effective interface for all business requirements and support to all vendors to resolve all business issues and provide assistance to support client in month end urgent issues.

•Working on client MEC(month end closing) and YEC(year end closing) process which is clitical time for users and provide them quick resolution so that they can complete the month end process smoothly.

•Manage and resolve various Oracle applications issues for all service tickets raised on service now tool. Performing troubleshoot on all oracle application issues and provide post production support and prepare test scripts on all applications and implement all fixes.

•Assist all team for feasibility analysis and participate in all development activities and perform tests on data migration and production platform.

•Identifying complex problems and reviewing related information of issue rasied and develop and evaluate options and implement solutions of problem raised.

•Have knowledge of the SQL & PLSQL programming languages & database systems to solve the problem of business users.

•Using golden 32 tool for querying data from database and oracle application 12.1.2 to check data on frontend. Analyzing the queries using golden 32 tool provided by client and fixing the cost affective queries which impact database processing time.

•Using oracle reporting tools like Oracle reports 10g &6i,XML publisher for handling reporting issues.To perform the debuging on reporting issue, i gained experience on oracle reporting tools.

•Working closely with other users and teams to identify the root cause and eliminate the same by analyzing logs.To analyze logs, client is using Putty and winscp tools.

•Responsible for coordination between onsite and offshore team through stand-up calls & meetings & Reporting for improvements and enhancements to keep client production high availability.

•Gained knowledge on oracle AIM methodologies, which will help in creating standard business documents for migration of codes.These documents give help to business users in solving repeitive issues during month end closing activity.

•Completed oracle certification in oracle iprocurement & AP. This will help in solving procurement and GL functional related issues of client.

12/Feb/2018 – 23/Feb/2018

Honda Motors

Project Description: Business requirement was to design new ZPL labels for Honda motors 2wheeler and 4 Wheeler. Also need to make some changes in in existing ZPL labels.

Contribution:

•Worked on zebra label printing using oracle warehouse & oracle reports for 2G projects PCR of Honda motors

•Worked on ZebraDesigner for XML tool to design ZPL labels. The simple variable wizard makes it easy to link variable information to text, barcode and RFID tags on the label.

•Worked on oracle inventory and oracle warehouse modules to do the related setup for ZPL labels.

•Designed understanding document & MD50,MD70 & MD120 for Honda IT.

•Worked on oracle pl/sql package and concurrent programs to print the Honda pricing labels.

•Responsible for developing interfaces for AR, AP, PO, HRMS modules.

•Responsible for developing PL/SQL code, workflow, XML reports and performance tuning.

07/2016 – 26/Jan/2018

ICAP AMS

Project Description: Support for their business of financial modules implemented in Oracle R12.

Contribution: Worked as a senior application developer for enhancement of existing and new objects in financial, HRMS & SCM modules

•Develop PL/SQL code, workflow, XML reports and performance tuning

•Worked on oracle development Tools: Forms and Reports developer,

•Develop Form Personalization which will help client to support on daily issues.

•Troubleshoot Oracle EBS issues including performance tuning of sql/PLSQL code, Workflow, forms, reports, concurrent programs and processes & fix defects reported by the users of customized programs.

•Manage and resolve various Oracle applications issues for all service tickets raised on service now tool.Perform troubleshoot on all oracle application issues and provide post production support and prepare test scripts on all applications and implement all fixes.

•Worked extensively on Oracle applications R12 & 11i which will help client to support on daily issues.

•Worked on HRMS issue and written HRMS interface for employee creation.

•Gained knowledge on Functional Modules: SCM, HRMS, AR,AP,FA which help in extra support in client issues.

•Timely delivered the assigned task with expected quality and the efficiency of work is improving as I am gaining more experience by working on projects in real time. Works in extra time when the volume of work is more and gave prime importance to targets to achieve client success.

09/2015 – 01/2016

AMEX Development project

Project Description: The American Express Company(Amex), is an multinational financial services corporation. The company is best known for its charge card, credit card, and traveler's cheque businesses. American Express has got Oracle Financial, Billing and report system implemented.

Supported for their business of financial modules implemented in Oracle R12

Contribution:

•Responsible for enhancement of Web Adi of AR module.

•Responsible for developing PL/SQL code, workflow, XML reports.

•Worked with users on oracle application related setup issues in GL and SL modules & Responsible for raising SR with oracle for standard data fixes.

•Worked on OAF and develop new Web ADI’s for GL & SL oracle modules.

•Designed various technical specifications and documents on oracle applications.

•Designed understanding document & MD50, MD70 & MD120.

Dec 12 – AUG 15, Software Engineer Stryker Global Technology Center Pvt. Ltd., Gurgaon, India

Work with Business Analyst in translating business requirements into Functional Requirements Document and to Detailed Design Documents

Present and defend product designs and architecture to clients

I am working in Oracle SQL, Pl/SQL, Forms and Reports Developer, XML Publisher and SCM module.

Ensure that development is performed as per requirements

Work with QA to create test scripts and scenarios for enhancements and customizations to the core product

Communicate activities/progress to project managers, business development, business analysts and clients

Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to oversee the acceptance and dissemination process

Environment: Oracle 11i, R12, Oracle 10G

Assignments Undertaken

Project Title : Stryker Japan Rollouts

Responsibilities

Worked on Oracle apps –System Administrator, Application Developer.

Develop XML Reports

Worked on report 6i

FA Mass retirement interfaces

Ship deliveries Interfaces

Un-apply Credit memo interfaces

Worked on SCM module.

Oracle forms 6i

Develop SQL query

Develop PL/SQL code

Performance Tuning

Project Title : Stryker International

Responsibilities

Worked on Oracle apps –System Administrator, Application Developer.

Develop XML Reports

Worked on report 6i

Un-apply Credit memo interfaces

Worked on SCM module.

Oracle forms 6i

Develop SQL query

Develop PL/SQL code

Performance Tuning

Project Title : NV(R12)

Responsibilities

Develop XML Reports

Interfaces

Conversion

Worked on report 6i

Worked on SCM module.

Oracle forms 6i

Develop SQL query

Develop PL/SQL code

Performance Tuning

Sep 10 – Nov 12, IT Consultant Fujitsu Consulting India Pvt. Ltd. Noida, India

Responsible for delivering conversion objects of all AR/PO/PA module.

Deliver new and complex high quality solutions to clients in response to varying business requirements.

Responsible for managing scope, planning, tracking, change control, aspects of the project.

I am working in Oracle SQL, Pl/SQL, Forms and Reports Developer, XML Publisher and SCM module.

Provide day to day direction and regular project status to the customer.

Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Utilize in-depth knowledge of functional and Technical experience in Oracle ERP and business skills to deliver solutions to customer.

Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: Oracle 11i, Oracle 10G

Project Title : FAI (Fujitsu America Integration)

Under the project our client has the responsibility to develop and maintain the B2C business solutions as part of configuration its product for corporate data. The product Data transformer from Oracle updates and configurates each segment of information to tackle the problems the company meets in its day to day business environment concerned to CRM system.

Responsibilities

Worked on Oracle apps –System Administrator, Application Developer.

Worked on Customer, Item, BOM, Order Interfaces.

Worked on Inventory and BOM.

Worked on Order Management.

Develop oracle Discoverer report.

Develop SQL query

Develop PL/SQL code

Worked on Data Loader for Data Migration.

Unix Shell scripting

Worked on report 6i

Creating data loading scripts.

Developed Xml reports

Oracle Forms 6i

Interfaces

Performance Tuning

Project Title : Mcdonalds

Responsibilities

Working on Oracle apps –System Administrator, Application Developer.

Develop oracle Discoverer report.

Working on report 6i

Develop SQL query

Develop PL/SQL code

Worked on Order management.

Developed Xml reports on order management module.

Performance Tuning

Project Title : Mastec

Responsibilities

Worked on Oracle apps –System Administrator, Application Developer.

Develop oracle Discoverer report.

Worked on report 6i

Worked on Order management, Purchase order module.

Creating data loading scripts.

Developed Xml reports on order management.

Certification:

Oracle cloud Iprocurment

Oracle Cloud Payables

PERSONAL DETAILS

DATE OF BIRTH : 27 APRIL 1987

SEX : MALE

NATIONALITY : INDIAN

MERITAL STATUS : MARRIED

LANUGUAGES : HINDI & ENGLISH

Passport Number : J5875406

KEY STRENGTHS

Good communication and client interface abilities.

Confidence of taking responsibilities without hesitation.

Believing in achievement of Success through Hard work, smart work & Dedication.

Encouraging Team spirit for sharing skills and knowledge to achieve the set goals.

References: Available upon request



Contact this candidate