Oracle Project

Email: ******.********.***@*****.***

Mobile: +91-983*******

LinkedIn URL: https://www.linkedin.com/in/sourav-banerjee-98879794/

Objective:

Seeking challenging and rewarding growth oriented position that will enable me to apply my skills and knowledge to ensure effective utilization to improve operations and contribute towards the organizational goal.

Professional Summary:

Oracle Applications Techno Functional Consultant with more than 10 years of experience in Implementation, support and development.

Expertise in Oracle Applications Framework (OAF), Oracle Workflow, PL/SQL, Oracle form personalization, self-service page personalization, XML/BI Publisher & RTF Template, Approval Management Engine (AME), SQL*Loader and UTL_FILE utilities, FNDLOAD utility and shell scripting for components migration.

Strong experience in Requirement Gathering, Gap Analysis, Business Process Modelling.

Strong experience in Implementation, Upgrade, RICE Development, Data Conversion.

Strong experience in Concurrent Programs, and Request Sets using PLSQL, Oracle Open Interfaces and Oracle Standard APIs.

Strong experience in distinct roles and stages in development cycle of Implementation projects.

Strong experience in i-Procurement, i-Supplier, i-Expense, Oracle Payable, Oracle Purchasing modules.

Good Functional Knowledge in Oracle Core HRMS, SSHR, Oracle Receivables, GL, Oracle Projects modules.

Excellent Documentation skills to prepare deliverables using AIM methodology.

Excellent communication, Interpersonal, Analytical and problem-solving skills.

Experience of working with clients from UK, US, Malaysia, Singapore, Australia.

Working experience as regression tester as well, in automation testing using QTP and QC.

Education Summary:

Bachelor of Technology (Electronics and Instrumentation Engineering) West Bengal University of Technology, West Bengal, India.

Skill Set:

ERP Skills

Oracle E-Business Suite R12.0.6/R12.1.3/R12.2.4

Oracle Applications

Account Payables, Oracle Purchasing, Oracle i-Expense, Oracle i-Procurement,

Oracle i-Supplier, Oracle Projects, Oracle Core HRMS, SSHR, Oracle Receivables, GL

Oracle Tools

J-Developer, Sql*Plus, Toad, PLSQL Developer, SQL Developer, Data Loader,

Web ADI

Development Tools

Oracle Developer Suite, Oracle Workflow Builder, XML/BI Publisher, Discoverer,

Power Builder, Report Builder, OAF, ADF, FNDLOAD,

Approval Management Engine (AME)

RDMS

Oracle, MS-Access

Programming Languages

SQL, PLSQL, JAVA, VB Script, Java Script, HTML, XML, JSP, UNIX Shel scripts

Operating System

Windows 2000, Windows XP, Windows 7, Windows 8

Others

FTP Tools, Notepad++, WINSCP, Putty

Work Experience Summary:

Company

Position

Period

IBM India Private Limited

Oracle Applications Technical Consultant

March-2016 – Till date

Wipro Technologies

Technical Lead

February-2015 -- March-2016

TATA Consultancy Services

Assistant Consultant

August-2007 – February-2015

Training and Certification:

Training/Certification

Subject/Technology

Oracle certification

Oracle Payables (1Z0-517) for Oracle Applications Implementation specialist

Pearsonvue Step Plus

Passed the global English exam with level-8 (Done through Wipro)

Agile Methodology

Attended Wipro training and passed Wipro Agile Pack exam

TCS internal certification

Java, Oracle PL/SQL and SQL, security awareness, software testing engineering

Attended training

Oracle Workflow, Advance PL/SQL, XML Publisher report, Oracle AME, Basics of Oracle ERP Cloud

Training Conducted:

I have conducted several TCS internal trainings on Oracle Application Framework (OAF), Oracle work-flow, Quick test Professional (QTP), Quality Centre (QC) operation and administration, XML publisher reports, Oracle EBS P2P cycle process.

WORK EXPERIENCE DETAILS:

IBM India Private Limited, Kolkata, INDIA

Project: Kroger Retail Company Technical Consultant July 2017 – Till Date

Being a Technical Consultant I am responsible for Support and Enhancement Oracle Application’s Supplier HUB. Support mainly involves Payables module related to different oracle workflows (R12.2.4), OAF customizations in Oracle Quote module, XML publishers and PLSQL packages and concurrent programs as a technical consultant for technical changes.

Handling designs, developments and delivery of the above-mentioned component’s customizations.

As a support project, we are handling enhancement request through Jira and for administration activity Confluence is used here. Also, we are following Agile methodologies which includes KANBAN process.

Effort estimation and project work execution.

Currently working on production support.

Customized OAF page changes related to quote module are delivered in this current project.

Mentoring team members to make them individual contributors.

Workflow customization including AME functionality relates to R12.1.3 and R12.2.4.

Migration script preparation for different components (OAF, XML publisher, AOL objects, DB packages and functions) migrating to higher instances.

Project: Unifirst Technical Consultant May 2017 – July 2017

Responsible for Oracle Application’s Receivables module related to different oracle workflows (R12.2.4), OAF customizations in Oracle Quote module, XML publishers and PLSQL packages and concurrent programs as a technical consultant for technical changes.

Handling designs, developments and delivery of the above-mentioned component’s customizations.

Effort estimation and project work execution.

Customized OAF page changes related to quote module are delivered in this current project.

Mentoring team members to make them individual contributors.

Workflow customization including AME functionality relates to R12.1.3.

Migration script preparation for different components (OAF, XML publisher, AOL objects, DB packages and functions) migrating to higher instances.

Project: Motorola Solutions, Greenfield Technical Consultant Mar 2016 – May 2017

In this project, Responsible for Oracle Application’s i-Procurement, i-Supplier, i-Expenses, Oracle quality modules related customizations in different oracle workflows (R12.2.4), OAF customizations, XML publishers and PLSQL packages and concurrent programs implementations.

Effort estimation and project work execution.

Most of the customized OAF page changes are delivered in this current project.

Mentoring team members to make them individual contributors.

Workflow customization and retrofitting the R12.1.3 functionality to R12.2.4.

Migration script preparation for different components (OAF, XML publisher, AOL objects, DB packages and functions) migrating to higher instances.

WIPRO Technologies, Bangalore, INDIA

Project: Cisco Systems Technical Consultant Feb 2015 – Mar 2016

As Technical Lead for Advance Services Projects for Cisco Systems Oracle Applications Project Module (R12.1.3) I was responsible for below activities.

Led team of size 10 in agile project development cycle.

Effort estimation and project work planning.

Mentoring team members to make them individual contributors.

Most of the customized OAF page changes are delivered in this current project.

Analyzing Oracle Apps landscape for R12.2.4 upgrade of OAF and web-logic technologies. Preparing roadmap and technical solution for upgrading current system to R12.2.4.

Development in Agile environment like scrum meeting, sprint planning and development and maintain progress board, burn down chart.

TATA Consultancy Services, Kolkata, INDIA

Project: Sun-life Financial Senior Application Developer Aug 2014 – Feb 2015

As an Assistant Consultant in this Oracle Applications upgrade project (R12.1.3 from 11i) I was responsible for below activities.

Analyze the requirements i.e. retrofitting the 11i functionality to R12.1.3.

Did POCs, developed the required components (table/view details update for different PL/SQL packages and custom views.

Developed and implemented solutions for replenishment of Oracle Application's WWK function which calls 3 legacy systems from Oracle applications.

Retrofitting customized NACHA payment format from Oracle Applications 11i to R12.1.3.

Developed few new PL/SQL based report.

Developed and implemented new OAF pages for full filling new requirement in Oracle applications R12.1.3.

Technical document creation and update, unit testing, support during UAT.

Project: Experian Ltd Technical module lead Dec 2011 – July 2014

This project mainly deals with the Change Request implementation as per business requirement. So my primary role was to understand the business requirement and involvement in development.

Analyze the requirement and try to understand if this can be done by enhancing the existing custom solution or need to have new one or can be done using application configuration.

Technical solution proposal to Client GPO (Global Process Owner).

Responsible for design and development and documentation for the changes.

Support and provide fix during SIT/ UAT testing phase.

TATA Consultancy Services, Nottingham, UK

Project: Experian Ltd Regression testing module lead Oct 2011 – Nov 2011

In this project, my primary role was to meet with business on daily basis for automation script execution and modify the MIS (management information system) report (Built with MS excel, MS word) for better visibility of higher management about the execution facts of Regression testing. Below are the activities involved.

Regression test case execution was performed once before every delivery cycle.

To execute the automation test scripts using HP quality center and QTP.

Preparing and maintaining documents for faster Regression testing execution, Business requirement on Regression testing.

TATA Consultancy Services, Kolkata, INDIA

Project: Experian Ltd Application Developer Oct 2009 – Sep 2011

As a developer in this project and responsible for understanding the requirement, analyzing the limitations of the custom developed systems, provide the solutions from Oracle Application side to minimize the limitation technically and functionally to understand, develop, unit test and deliver the solutions on time with minimum defects and high quality.

Involved in integrating Oracle Applications i-Procurement module with a custom developed Capital Expenditure Authorization (CEA) solution (developed in OAF and Oracle Work-flow) and the data flow that interfaced between Oracle Applications and the Capital Expenditure Authorization (CEA) solution.

Involved in integration between Oracle Application’s Invoice work-bench with a custom developed Paperless Payment Request (PPR) solution (developed in OAF and Oracle Work flow) and the data flow was interfaced between Oracle Applications and the Paperless Payment Request (PPR) solution.

Integrated Oracle Applications receivable’s transactions module with a custom developed e-Form solution (developed in OAF and Oracle Work flow) and the data flow was interfaced between Oracle Applications and the e-Form solution.

Successfully implemented the above solutions primarily for UK and US, and then rolled out the same for EMEA and APAC business units.

Project: Experian Ltd Application Developer Oct 2008 – Sep 2009

I worked as application developer and simultaneously as a Regression tester in Oracle Applications R12.0.6.

Built several automation test scripts and executed during different releases (Change Request, Architectural changes, and browser upgrade).

Automation test scripts built using QTP and stored in Quality Center used as a repository.

Worked with CR (change request) project as application developer in OAF. My role involved in development, unit test, SIT/ UAT support and post go-live warranty support of developed components.

Project: FDI UK Application Developer Nov 2007 – Sep 2008

My primary role was to develop a module in Oracle ADF and integrate with Oracle Applications 11i.

The ADF application mainly handled the incoming billing feeds and sent for approval. The approved billing feeds then sent to Oracle Applications through mapping custom tables used as a staging table and custom-built interfaces.

Integrating between different modules of custom ADF application.

Project: TCS ILP training Application Developer Aug 2007 – Oct 2007

I was undergone various trainings in TCS ILP (Initial Learning Program) which includes software engineering basics, programming basics, Software requirement specification (SRS) and use case writing, technical document preparation.

Contact this candidate