Oracle ERP Team Leader
AYTB
Total years of experience :22 years, 1 Months
Month Closing Issue for Purchasing, Inventory, Account Payable, Account Receivables, Fixed Assets, and General Ledger.
Currency Exchange Rate maintenance, Period Open, Define calendar for the year, Document Sequence Creation and Assignment.
Working on the Oracle Personalization and Reports Creation.
Checking with Daily tasks and All Schedules for all Modules.
• Daily monitoring the system log to check all the activity working as normal (cost manger, Oracle mailer, all schedule request, all submitted PR and PO in proper status)
• Monthly monitoring script to help in month closing, drill down the Receiving and Inventory transaction with Gl and communicating with finance for any discrepancy.
• Creating SR with oracle and oracle community for any error, bug, and clarification and applying the patch with a help of dba and testing the Issue.
• Creation of new Organization, Setup, testing all transaction type to get the desire Inventory and Purchase business flow and hit proper account till transfer to Gl.
• Merging Of Supplier, Modification in Oracle SLA, Merging of Organization,
• Creating Flex field as per business need, Value set, Creating Security Rule and assigning. Working on Oracle personalization
• Creating the PR and PO position hierarchy, assign the approval limit on transaction type, working with stuck PO and resenting with oracle mailer.
• Creating the Purchase Related Report, for end user and Managerial level and Comparing with Oracle standard Reports.
• Implementation of Qatar Implementation from Legacy system to oracle 12.
• Creating the Oracle Document R.D.050-Business Requirements, B.P.080-Future Processing, BR.100-Application Setup, TE-040-Test Script and D0070-Training Manual
• Complete Inventory and Purchasing Setup, Uploading Unit of Measure, Item Master, Opening Stock with Cost, Uploading Supplier and Opening Balances.
• Testing the system, Provide the User Training Creating Document Printing and Report
• Implementation of Zero Value Organization for Inventory Tracking Purpose :
• Creating the Oracle Documentation for the Internal Company. The Organization is to be used for the Internal tracking of Used Item without passing any transaction to Gl. Assignment of the Item to New Organization. Uploading the balance,
Inventory level setup, Personalization of forms, creating the Related Document print and Reports.
• Interacted with the management, team and associates to facilitate smooth communication to understand and analyze the requirement and also to identify appropriate solutions for problems.
• Facilitate discovery, design, development, and deployment activities and Manage resources and deliver project tasks, both external and internal.
• Perform gap analysis between system functionality and client requirements, Communicate and document system specifications for clients and team members. Document test scenarios and perform unit, system, and data conversion testing tasks and Provide excellent customer interface skills throughout the project life cycle and Provide periodic status reports and accurate estimates and timelines of work.
• Assumed responsibility for creating the organization setup and organization hierarchy for closing inventory period while checking the health check up for the inventory. Pioneer in creating and managing TARs with the Oracle support organization to resolve Oracle functionality/data issues.
• Organized various training sessions for Key and End users on OM, INV and PUR Module.
• Closely monitored key business processes and work with end users to streamline business processes using Oracle functionality and improve the efficiency.
• Drove the initiative to resolve Production Issues within SLA time while guiding the team on critical Issues.
• Involved in system administration for Oracle ERP including defining users, their responsibilities, and profile options.
• Proactively identifying and rectifying problems to ensure smooth functioning and enhancing operational efficiency.
• Drove the efforts for building the Knowledge Base for purchasing related issues.
• Deftly managed various projects, ensuring successful completion of the projects within stipulated timeframe; collaborating with the team members and senior management to maintain a continuous stream of information regarding the project status and progress.
• Meticulously documented all major activities for effective reference and use.
• Accomplished responsibility for installation of Orion system, applying database & application level patches.
• Proactively contributed in creating group and user with all security level measurement, controlling authorization and amendment access.
• Geared the activities for registration of new forms, creating instance, creating new or modification in forms.
• Crafted report and created new report using sales analysis report tool, writing external validation on instance as per requirement. Performing New Year processing for financial year, year closing activity.
• Actively involved in the inventory of location with stock take sheet procedure.
• Contributed significantly in designing the report for customer with respective ageing, set up for the matching and un-matching rule for customer, validating receivable account with general ledger account.
• Instrumental in resolving any issue related to any discrepancy in operation and general ledger and provide the reason making setup for the any payable account and discrepancy account.
• Established account period, GL transaction, company level and location level parameter, setting of auto general and normal financial transaction.
• Associated closely in merging of two companies, segregation of company, designing of chart of account with financial department and simulations division and department in view of consolidation of general ledger with all company.
• Developed plan for controlling the group level master. Set up for inter company transfer and bank reconciliation and uploading the stock and opening balances
• Accountable for performing initial tests and generate the required reports and to get them approved before going live.
• Imparted training to all levels of end users and data analysts, to prototype possible approaches to problems and translate raw data into informative information for management.
• Meticulously analyzed cost, effort performance parameters and implementing improvements based upon data collated.
• Designed & developed plan to support process improvements.
• Solely responsible for creation of new databases and initial space allocations of database, table spaces and primary storage objects in consultation with the respective departments using the OMF Module and configuring Parameter File.
• Entrusted with the onus of monitoring DBA activities with Oracle 7.3, 7.4 and Oracle 10G Release 1 & 2 including Tuning, Query Optimization, Backup and Recovery, Import/Export, Planning of backup strategy, space management, capacity planning, etc. Data Migration from Oracle 7.3 to Oracle 10G using Data Migration Assistant and from Ms Access to Oracle using SQL * Loader and ODBC.
• Attended Project status Review meeting with the management.
• Interacted with the management, team and associates to facilitate smooth communication to understand and analyze the requirement and also to identify appropriate solutions for problems.
• Established & used service level and response time objectives while planning and managing the service-level quality using the real-time management skills.
• Collaborated with the team members and senior management to maintain a continuous stream of information regarding the project status and progress.
• Master of Computer Application (MCA), Osmania University - 1997
• Bachelor of Science (B.Sc.), Osmania University - 1994