About Me
- A dynamic professional with over 20 years in the IT industry which includes over 12 years Oracle Apps experience in the following areas along with extensive people management experience, while currently in the process of Agile Scrum Master ...
- Demonstrated excellence in handling technical and non-technical aspects and delivering projects on time and within the cost with latest technologies
- Adept in handling end-to-end development of software products from requirement analysis to system study, documentation and implementation
- Proficient in reviewing the Design Documents, Code Changes & Project Plans and maintaining the User Documents of various projects
- Expertise in developing applications encompassing system design & analysis, development and implementation. Deft in handling project management activities which include planning, design, scope management, estimation, resource administration and completion of project within specified parameters.
- Expertise in managing model based testing & capable of implementing process and practices in Software Development Life Cycle.
Skills
Database
Programming Language
Web Development
Others
Portfolio Projects
Company
Telmar Network Technologies USA
Description
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.
Company
FMG Saudi Arabia
Description
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
Show More Show LessSkills
Oracle ERP Oracle Forms SQLCompany
ICU Medical San Clemente USA
Description
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
Tools
SQL Developer ToadCompany
Soham Energy Bangalore
Description
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
Tools
SQL Developer