Naresh Antham

Email: advwsw@r.postjobfree.com

Mobile: +1-470-***-****

EXPERIENCE SUMMARY:

Having more than 16 years of experience in IT and is into Oracle Applications having technical and functional knowledge on SCM modules (INV, OM, BOM), Financial modules (AR, AP, PA, GL), HRMS, Application Developer, System Administrator of Oracle Applications Fusion, EBS R12 and Ver.11.5.10. Have worked on various Oracle Tools and Technologies: Oracle APEX, RICE Components, SQL, PL/SQL, Forms, Reports, XML Publisher, Discoverer Reports, OAF and OBIEE etc.

Extensive experience in PL/SQL including developing Stored Procedures, Functions, Views, Cursors, Packages, Exceptions, Sub Queries

Worked on Oracle database 10g, 11g, 12c and 19c

Proficient with Microsoft Office Suite

Good understanding of Relational Databases and Data modelling

Very good understanding of AIM methodology and onsite/offshore practice

Certified Scrum Master

Strong understanding of business processes with good experience in development and support.

Good experience of coordinating with various teams like Deployment, Testing Team to speed up Development process.

Experience of good client interaction and to deal with their requirements.

Quick learner & Self-directed, consistently updating self with emerging trends in the industry.

TECHNICAL SKILLS:

Languages

SQL, PLSQL, Java, Python, R

Tools

RICE Components, Discoverer 10g, Reports 6i/10g, Forms 6i, XMLP, Workflow, Informatica, OAF, OBIEE, APEX

ERP – Oracle Applications 11i, R12, Fusion

HRMS, SCM, Financials and AOL

PROFESSIONAL SUMMARY:

Ooredoo Qatar (Feb 2016 – Feb 2023)

Project

Ooredoo Qatar Implementation and Support (Feb 2016 to Feb 2023)

Responsibilities:

Gathering the requirements and preparing the technical documents

Writing huge blocks of PLSQL to process the data

Performance tuning and optimization

Worked as the main channel between Technical and Functional teams

Role

Senior Engineer

Solution Environment

Oracle 10g, 19c database, Oracle applications R12

Tools

Oracle 10g, Sql, PL/SQL, TOAD, Formatter Plus, ADF

Amway IT Services (September 2014 – Feb 2016)

Project

Amway ATLAS Solution Designing (Sep 2014 to Feb 2016)

Responsibilities:

Developing Technical design documents for various RIE components

Helping the functional team in preparing Functional documents

Preparing Unit test case documents, Migration documents etc

Reviewing of Code developed by the peers

Developing RIE components

Role

Senior Software Developer

Solution Environment

Oracle Applications R12, Oracle Fusion, Oracle 10g database

Tools

Oracle 10g, Sql, PL/SQL, TOAD, Formatter Plus

Deloitte (February 2014 – August 2014)

Project

Polycom R12 Implementation (Feb 2014 to Aug 2014)

Responsibilities:

Developing Functional and Technical design documents for Conversions and Interfaces

Helping the functional team with Legacy to Oracle mapping

Preparing Development standards, Conversion Strategy Integration strategy documents and Unit test case templates

Working on preparing Instance Checklist and Review Checklists

Role

Technical Lead

Solution Environment

Oracle Applications R12, Oracle 10g database

Tools

Oracle 10g, Sql, PL/SQL, TOAD, Formatter Plus

Oracle India Pvt. Ltd (October 2010 – February 2014)

Project

Oracle - ADP Payroll Rollout (Jan 2012 to Feb 2014)

Responsibilities:

Working with ADP streamline to implement payroll for Oracle worldwide (approximately 40 countries)

Gathering the requirements for each country and working with the users to make sure that the payroll process works well

Developing interface and customizing it for each country as per the requirements which sometimes include adding new elements on OTL, setting up payment methods and adding new customizations

Working with the users to add new functionality in the system which is required for payroll processing

Creating new reports based on user’s request for reconciliation

Implemented the payroll interface for more than 20 countries

Managed the project by coordinating with Oracle global payroll team, ADP Streamline, Third party payroll vendors and Local payroll in every country

Involved in preparing the design documents, functional documents, user training documents etc as per AIM methodology

Role

Developer

Solution Environment

Oracle Applications R12, Oracle 10g database.

Tools

Oracle 10g, Sql, PL/SQL, TOAD, Formatter Plus

Project

Oracle Dev Ops (Oct 2010 to Dec 2011)

Responsibilities:

Modifying/creating reports as per the requests.

Developing conversions and interfaces to load the data into Oracle system for the companies that are acquired by Oracle.

Working with the users to add new functionality in the system by modifying the custom PL/SQL packages.

Involved in preparing the functional and technical design documents as per AIM methodology.

Providing user training materials. Building test case templates.

Role

Developer

Solution Environment

Oracle Applications R12, Oracle 10g database.

Tools

Oracle 10g, Sql, PL/SQL, TOAD, Formatter Plus

Apps Associates Pvt. Ltd (June 2006 – Sep 2010)

Project

Navinet Managed Services (April 2009 to Sep 2010)

Responsibilities:

Understanding the business requirements using the Functional design/documentations

and developing Technical design/documentations.

Lead the team of three people. Assign the tasks and help the team to deliver quality solutions.

Worked on modifying the Project Accounting Account Generator

Built custom PA reports as per the functional design

Worked on adding new project types

Role

Team Lead/Developer,

Solution Environment

Oracle Applications (11.5.10), Oracle 10g database

Tools

Oracle 10g, Reports 6i/10g, PL/SQL, TOAD, sql plus.

Project

IDC Managed Services (February 2009 to March 2009)

Responsibilities:

Gathered Requirements, prepared Technical Design Document and user manuals.

Understanding the business requirements using the functional design/documentations.

Develop PL/SQL package to load the AP Invoices.

Create a shell script to get the data files to local server.

Tested the data and functionality in development and test instances.

Deployed the AP Invoice Interface to production without any issues.

Role

Team Lead/Developer,

Solution Environment

Oracle Applications (11.5.10)

Tools

Sql, PL/SQL, TOAD.

Project

Smiths Medical Japan Implementation ( June 2008 to January 2009)

Responsibilities:

Worked on the migration of Items, Item Onhand Quantities, BOMs, AR Invoices and building XML reports.

Helped the functional team in mapping between Legacy and Oracle.

Developing Conversion Strategy, Development Standards, Conversion Technical Design and Extension Technical Design documents.

Developed the Unit Test Case templates, Reconciliation Templates.

Role

Team Lead/Developer,

Solution Environment

Oracle Applications (11.5.10), Oracle 10g database

Tools

Oracle 10g, PL/SQL, TOAD, Formatter plus, sql plus, XML Publisher.

Project

Wyndham HR Analytics

Period

March 2008 to May 2008

Responsibilities:

Customize HR Analytics to modify the pre-built logic for various dimensions and facts and enhance the seeded repository to add many fields like Descriptive flex fields, Extra Information fields.

Role

Developer

Solution Environment

Oracle Applications R12, Oracle 10g database.

Tools

Oracle 10g, PL/SQL, TOAD, Informatica.

Project

Vectron Implementation

Period

September 2007 to February 2008

Responsibilities:

Worked on the migration of Employees, Employee Assignments and Sales orders.

Helped the functional team in mapping between Legacy and Oracle.

Developing Conversion Strategy, Development Standards, Conversion Technical Design and Extension Technical Design documents.

Developed the Unit Test Case templates, Reconciliation Templates.

Developed Commission Reports.

Role

Developer

Solution Environment

Oracle Applications (11.5.10), Oracle 10g database

Tools

Oracle 10g, Reports 6i, PL/SQL, Formatter plus.

Project

Nuance Managed Services

Period

April 2007 To August 2007

Role

Developer

Responsibilities

Worked on Interface to iChart program to automate the whole process and also added a new column error_message which is used to print the error message dynamically.

Worked on Japan Invoice XML template changes.

Added a new logic to update the customer and customer contact information in OM to PA interface which is used to create the project from the salesorder if it is a project order.

Customized the ‘Print New Invoices’ program to print 50 invoices per batch and call the program recursively until all the invoices are printed. This is customized as the printer was not able to print bulk number of invoices at a time.

Solution Environment

Oracle Apps 11i, Oracle Database 10g.

Tools

Oracle 10g, Reports 6i, XML Publisher, PL/SQL, Formatter Plus

Project

Nuance – Dictaphone migration

Period

August 2006 to March 2007

Role

Developer

Responsibilities

Data migration for Items, Item categories, Item costs, BOMs, Onhand Balances, Item Attachments, Projects, Project Agreements and Fundings, Project Events and Project Expenditures to oracle

Created temporary tables and developed SQL* Loader control files to load the legacy data into the temporary tables.

Developed packages for mapping, validating the records in conversion staging tables

Involved in performing development tasks such as writing extensive PL/SQL Programs units like procedures, functions, triggers and packages.

Worked on interfaces like Interface to iChart, Auto Accounting and VSOE programs.

Customized the Pricing Extension

Developed CV80 and CV120 documents for conversions and MD70 and MD120 documents for Interfaces

Solution Environment

Oracle apps 11i, Oracle database 10g

Tools

Oracle 10g, PL/SQL, TOAD, Formatter plus, SQL plus.

Contact this candidate