Project Title:    Telmar Network Technologies, USA

Modules:          AP, AR, GL, INV, OM, PO, Manufacturing

Languages:      SQL, PL/SQL

Software:         Oracle Apps R12

Database:        Oracle 11g

Tools:               Oracle Apex, Oracle Forms 6i, Reports 6i, Discoverer 11g, XML Publisher, Toad, SQL*Loader,

                       Workflow Builder

Roles and Responsibilities:

• Lead a team of 4 technical resources and 2 functional resources.
• Develop and maintain a custom module for the client which would be a bridge between the client software and Oracle Apps.
• The client software would send data into a custom table and that would be inserted into another custom table via a database trigger.
• Subsequently through a series of concurrent programs data would be transferred to Oracle Apps. Sales orders would be created and processed.
• Data would be sent back to the client database as processed data.
• Developed a custom program for uploading Service Contracts. All the user had to do was place the data files on the FTP server and then run one concurrent program. This program took care of loading the data into custom tables and performing all necessary validations. Data which passed all validations was then used to create the service contracts in Oracle. For the records which were in error, proper error messages were displayed in the concurrent program error log, so that the user could fix the errors and load the data again.
• Led weekly calls with the client for weekly updates.
• Had the responsibility for researching on Oracle Apex and developing a number of custom reports and custom query only forms in Apex.

Project Title: FMG, Saudi Arabia

Modules: AP, AR, GL

Languages: SQL, PL/SQL

Software: Oracle Apps R12

Database: Oracle 11g

Tools: Oracle Forms 6i, Reports 6i, Discoverer 11g, XML Publisher, Toad, SQL*Loader, Workflow Builder

Responsibilities:

• The requirement was to develop an interface between HRMS and Accounts Payables. Data would flow from HRMS to Accounts Payables.

     • Developed various custom BI Publisher reports for Payables and HRMS

Project Title:    ICUMEDICAL, San Clemente, California, USA

Modules:          AP, AR, GL, INV, OM, PO

Languages:      SQL, PL/SQL

Software:         Oracle Apps 11.5.10.2

Database:        Oracle 11g

Tools:               Oracle Forms 6i, Reports 6i, Discoverer 11g, XML Publisher, Toad, SQL*Loader, Workflow Builder

Responsibilities: The client has a list of 300+ unresolved issues:

• As Onsite Project Coordinator

• Accountable for collating requirements from the client functional team and preparing Requirement documents for the Offshore Technical Team
• Responsible for holding weekly status meetings with the client’s  Director of Applications and keeping a track of work handed out to offshore team and charting the progress
• Working on getting future business with the client

• As Offshore Technical Lead

• Steering a team of 4 technical consultants and one functional consultant to complete the work as handed out by the onsite coordinator
• Involved in daily sprint calls with the client using the Scrum methodology

Title:                Indian Express, Chennai

Modules:          AR, AP, GL, OM, QM and INV

Languages:      SQL, PL/SQL

Database:        Oracle 10g

Software:         Oracle Apps R12

Tools:               Oracle Forms 6i, Reports 6i, XML Publisher, Oracle Alerts, Toad, SQL*Loader, DataLoader

Role:               

• Led a team of 5 Technical Consultants’ offsite
• Involved in preparing the effort estimates for the objects to be developed
• Developed interfaces, custom reports using PL/SQL and Report writer
• Loaded opening balances for AP, GL and Supplier information