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

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.

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

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 clients 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 o 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

Involved in leading a team of 3 technical consultants and attending client meetings to understand custom module requested by client Engaged in giving estimates for custom objects to be developed and opening balances to be loaded and developing custom forms and reports for custom module with data flowing to AR Formulated interfaces to load Customer master, Supplier Master, Inventory Item Master, AP & AR opening balances Devised interface for loading Project Accounting templates and opening balances.

Steered a team of 3 technical consultants offshore. Formulated interface programs for loading Supplier Master, Customer Master and opening balances for AP. Developed custom reports based on MD50 documents prepared by functional consultants Prepared relevant MD70 documents for all custom objects prepared

Led a team of 10 technical consultants onsite The project was an enhancement of the existing Merchandise Management System (MMS) and the upgrade of the POS system from FoxPro to Dot net. Interaction with client directly for business requirements, design and deliverables and was the single point of contact between client and development team. Held weekly meetings with the client Senior IT Director for updates.

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

Developed interfaces, custom reports using PL/SQL and Report writer in coordination with the functional consultants and in accordance with MD50 documents. Modified existing reports as per user requirements and in coordination with the functional team. Prepared MD70 documents for new objects created and updated existing MD70 documents for modified code.