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