Software Development Team Leader
A’ayan Leasing & Investment Co
Total years of experience :14 years, 10 Months
• Coaching team members on delivering results and encouraging their professional development
• Reviewed team's code and coordinate with team member to resolve issues.
• Provide weekly, monthly, yearly required reports to finance team including activities in GL chart of account and related (SLA).
• Customized Open Interface invoices form to handle exceptions during the invoice validation and import.
• Carrying out routine operational activities as Administrator of GL, AP, AR, FA, and Cash Management.
• Manage business expectations and ensure customer satisfaction.
• Provide hands on implementation and post implementation support utilizing prescribed software design lifecycle techniques and system documentation techniques
• carrying out routine operational activities as Administrator of GL, AP, AR, FA, and Cash Management
• Customized Open Interface invoices form to handle exceptions during the invoice validation and import.
• Managing a full support and maintenances for Bank Master, Supplier Master and Customer Master Data in Oracle Financials Application.
• Extensively worked on Formula Columns, Summary Columns, Placeholder Columns and Ref Cursor Query for developing the reports and prepared complex Data Model in Oracle Reports.
• Strong knowledge of P2P and O2C cycles
• Developed custom activities and notifications to build complex workflow processes as per the business scenarios.
• Developed customized forms using Custom. pll.
• Developed customized reports using XML Publisher & Discoverer Reports.
• Used the features of BI Publisher such as Sort, Group, and Total, to make data intense operations happen at the template level.
• Provide weekly, monthly, yearly required reports to finance team including activities in GL chart of account and related (SLA).
• Testing modules’ setup for inconsistencies and missing steps in addition to create Test scripts and Users Acceptance Tests Documents (UAT).
• Reviewed team's code and coordinate with team member to resolve issues.
• Playing a major role and key player with a finance team to finalize financial activities.
• Worked on custom API to generate error, data files and import data from legacy system to ERP system.
• Data Migration from Legacy systems and Open Interfaces
• Involved in the projects meetings to define/direct project goals and objectives extensive.
• Performed and owned the tasks to completion and help other team members.
• Worked on the entire life cycle of the project starting from Requirements Gathering, Analysis, Design, Development, System Testing and Production support.
• Studied the Required business processes and suggested alternate ways to accomplish the same through Non-Customizations Oracle.
• Supported Rollouts and Post Go Live Operations Daily interaction with client to understand existing business process and help client in understanding Oracle ERP features and processes.
• Used SQL Loader for importing, PL/SQL block validation of data and inserting into base tables.
• Converting Pro C report to Oracle 10G reports.
• Designed and developed complete Vendor Interface for import of vendor information into the Oracle Account payables system.
• Designed and created custom form using Forms 10g tool to hold lookup cross reference values between legacy system and oracle apps.
• Develop custom application form using oracle 10g.
• Conduct impact analysis of the CR (Change Request) and Gap analysis between existing and proposed solutions.
• Involved in writing PL/SQL Triggers, Procedures, Functions and Packages.
• Developed Oracle E-Business Suite using PL/SQL, Workflow Builder, Application Object Library, Forms and Reports.
, maintain, and enhance all objects packages/functions in PL/SQL to support application process.
•fixing Bugs in Forms and Reports previously designed.
•Development of screens in forms using oracle at backend according to the requirements of Clients.
•Developed database triggers on insert or update on tables to track the changes in the table.
•Business Requirements Mapping.
•Prepared User Requirements document (URD) for Data Migration from legacy system to Oracle Apps.
•Used Custom PL/SQL API’S for converting open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AR Invoices, Open Purchase Orders from legacy system (Mainframe) to Oracle Applications.
,