Naresh Antham
Email: ************@*****.***
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.