Jayesh Jagtap

Oracle Developer (Oracle Apps Technical, PLSQL, Oracle Forms – Reports Developer)

+91-808******* +91-702******* ady70e@r.postjobfree.com Pune- 411057

CAREER OBJECTIVE:

To secure a challenging position with scope for future career growth, which will enable me to use my strong technical and functional skills in the field of Oracle technologies like Oracle Apps, Oracle Forms and Reports and PLSQL.

SUMMARY:

Almost years 9+ years of experience in as Application Development using SQL, PL/SQL, and Oracle Forms and Reports 10g/11g and Oracle Apps.

Around 6+ years of experience as Oracle Application Technical Developer in customization of Oracle e-Business Suite Applications (R12.).

Technically proficient in FRICE components (Form, Reports (RDF), Interfaces, Conversions, Extensions). Also having knowledge on AOL.

Experienced in Customizing Oracle Forms with Forms Personalization

Having Knowledge in SQL*Loader, XML Publisher

Having Knowledge on PO, INV,OM, AR, AP modules.

Have experience in writing SQL Queries, Indexing, Views, Materialized views, PL/SQL- procedures, functions, packages, triggers, cursors, collections, Ref cursor.

Experience in Bulk collect, and Collections (VARRAY, PLSQL Tables).

Involved in Explain plan and investigate the performance issues.

Good exposure on advanced topics like Indexes and Job Scheduling.

Extensively participated in developing technical and requirement documents (MD70, MD60).

Extensively worked with version control tool like STAT, SVN, Service Now.

Involved in Procure to Pay (P2P), Order to cash (O2C) life cycles and Supply Chain business flows.

Experienced in interacting with Business Users, Application Owner, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications

TECHNICAL SKILLS:

Databases: Oracle 10g and 11g,

GUI: EBS R12, Oracle Forms 10g/11g and Reports 10g/11g

Languages: PLSQL, SQL, HTML, CORE JAVA.

Tools: PLSQL Developer, TOAD, STAT, SVN, WORKFRONT, SERVICE NOW

Operating Systems: Windows 10, 7, XP and UNIX.

EDUCATIONAL PROFILE:

Post-graduation in MCA-Engineering from Pune University with an aggregate 63.52 % in the year 2010-2013

Graduation in science with specialization in Information Technology [B.Sc. (IT)] from North Maharashtra University with an aggregate of 70% in the year 2007-2010.

HSC from Pune Board with 61.67% in the year 2006.

SSC from Pune Board with 64.13% in the year 2004.

PROFESSIONAL EXPERIENCE:

Tech Mahendra- Mar 2023 -Till now

HCL– Jul 2021- Mar 2023, Pune

Lead Consultant

Responsibilities:

Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Application

Developed Custom reports, Customized existing reports (PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report) according to the functional specifications using Reports 10g and XML publisher.

Involved in the day-to-day activities of production support of Oracle applications environment in OM, INV, PO, INV etc.

Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.

Work on the development activities as part of issue resolution. Perform Unit Testing, assist user testing and closing the tickets.

Closely worked with users to understand business needs and objectives.

Worked on SQL*Loader Scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.

Personalized Oracle standard and custom Forms using oracle forms builder as per the Client requirements.

Extensive experience on Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views, and Packages using PL/SQL.

Extensively participated in developing technical and requirement documents (MD70, MD60).

Involved in SQL tuning, troubleshooting, debugging, and fixing the code and made the changes according to the new business requirements.

Environment: SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, TOAD

WIPRO– Mar 2021- Jun 2021, Pune

Oracle Apps Tech Lead

Responsibilities: NA

TCS - Feb 2018- Feb 2021, Pune

IT Analyst

Responsibilities:

Developed Master-Detail and Transaction forms using TEMPLATE.FMB and registered them in Oracle Application.

Worked on Form Personalization.

Registered the Concurrent Programs, Forms, Reports and Requests Sets in AOL and System Administration

Involved in the day to day activities of production support of Oracle applications environment in AP, PO, OM, INV, AR and GL

Customized the existing forms with descriptive flex fields.

Developed various Custom reports, Customized existing reports (PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report) according to the functional specifications using Reports 10g and XML publisher.

Created custom templates with Data Definitions for XML Publisher and Developed reports using reports and registered as XML reports in applications

Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.

Extensively participated in developing technical documents (MD70).

Worked on SQL*Loader Scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.

Fixing Bugs in Forms and Reports previously designed.

Development of screens in forms using oracle at backend according to the requirements of Clients.

Create standard purchase order, BPA, and blanket releases

Environment: Oracle forms and reports 10g, PL/SQL Developer.

ZAMIL ITG June 2016 – Feb 2018, Pune

Oracle Programmer

Project Description:

SUCHI is PEB (Pre-engineering steel buildings) customized software and an advanced ERP system which has provided it with a significant advantage over its peers when it comes to project build times and designs. SUSHI involves multiple departments like MFS (Material Fabrication Service), Sales System, PPC (Project Planning and Control) etc. Therefore, system provides an ideal solution to build complex expensive conventional steel buildings and phases without undermining important details such as the utility and functionality of these buildings.

Responsibilities:

Developed Data Entry, Transactions and Master forms, complex and template forms and reports in Oracle 10g.Creation of Pop-up Menus and maintaining Master Detail relationship.

Schedule auto generated reports and Alert mail in HTML format by mailing to concern person.

Developed barcode generated reports and print for scanning purposes.

Used WebUtil for client-side functionality like as file upload, integration between Oracle Forms applications and client browser or computer.

Used various LOVS (List of Values) and record groups at various points in runtime.

Involved in walkthrough sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.

Involved in Troubleshooting performance issues and bugs within packages and stored procedures using dbms_output and explain plan.

Environment: Oracle forms and reports 10g, PL/SQL Developer.

3i Infotech Ltd Dec 2014 – June 2016- Mumbai

Client ICICI Bank

Oracle Developer [Associate Engineer]

Project Description:

Symbols Project is a Core Banking System for corporate loans serviced by ICICI Bank, which is based on AMBIT Product to service its corporate term loans portfolio. In addition to the core of the system supplied by Sungard team, additional Third-Party modules was also built and continue to be serviced by 3i Infotech team, which Capture off-line transactions such as Loan Disbursement, HFC and customized reports as per user requirements. We provide support and development/modification for new/old forms/reports as per the requirement.

Responsibilities:

Developed Data Entry, Transactions and Master forms, complex and template forms, and reports in Oracle 11g.Creation of Pop-up Menus and maintaining Master Detail relationship.

Used WebUtil for client-side functionality like as file upload, integration between Oracle Forms applications and client browser or computer.

Used various LOVS (List of Values) and record groups at various points in runtime.

Involved in walkthrough sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.

Involved in Troubleshooting performance issues and bugs within packages and stored procedures using dbms_output and explain plan.

Environment: Oracle forms and reports 11g, PL/SQL Developer.

Neumann Systems Consultancy Private Limited Dec 2013 – Dec-2014, Nashik

Client RamBandhu Masale, Mahendra Sona Ltd, Alcon Electronics Ltd etc.

Role Oracle Developer

Project Description:

Galaxy is an Enterprise Resource Planning (ERP) solution useful for small and medium size manufacturing industries. It is configurable and fulfills requirements of a spectrum of industry segments - discrete engineering, process, assembly, projects, and fabrication. The industry may have standard or custom-made products. Modules can be customized to meet customer specific needs and to enhance performance of key business processes. Latest technology of Oracle with complete web enabling is used as platform of development. Solution is useful to single location companies and even to business groups having multiple companies with multiple manufacturing locations, warehouses, marketing branches, and distribution network.

Responsibilities:

Developed Master Forms, Transactions Forms, data entry forms, complex and template forms, and reports in Oracle 10g.Creation of Pop-up Menus and maintaining Master Detail relationship.

Developed Simple Web Reports, Matrix Reports, used conditional formatting, Format Trigger.

Used various LOVS (List of Values) and record groups at various points in run time.

Involved in walk through sessions with business users during Analysis and Designing phase. Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.

Involved in Troubleshooting performance issues and bugs within packages and stored procedures using dbms_output and explain plan.

Environment: Oracle forms and reports 10g, TOAD

PERSONAL DETAILS

Name: - Jayesh Sudhakar Jagtap.

Father’s Name: - Sudhakar Ziparu Jagtap.

Date of Birth: - 28 Apr 1989 at Pimpalner.

Permanent Address: - Flat No. 302, Neelambari, Wakad Pune- 411057

Gender: - Male

Marital Status: - Married

Nationality: -Indian

Languages Spoken: - English, Hindi, and Marathi.

Hobbies: – Drawing Sketches, Listening Music, Playing Cricket and Making new Friends.

DECLARATION:

I declare that the facts stated hereby are authentic and true to the best of my knowledge.

- Jayesh Jagtap

Pune-

Contact this candidate