Oracle/M.I.S. Application Developer with a demonstrated history of working in textiles industry Handling various SCM data and transactions Related to FG/RM inventories, Production, Sale & Purchase. Expertise in Business Flow and its requirement, Skilled in Oracle Database & Oracle EBS. Strong operational proficiency, good understanding of ERP flow, P2P and O2C Cycle, Experienced with PL/SQL, SQL Forms and reports. Qualified from Karachi University with Strong and supportive academic background of Computer Science/Information System and Commerce.
▪ Script and queries analysis for errors, exception and condition.
▪ Create function triggers and procedures.
▪ Build Sql Query for ad-hoc reports.
▪ Develop new Forms & rdf/xml reports.
▪ Compilation of Forms Modules on server
▪ Registration of Form, Report, Concurrent programs on EBS R12
▪ Customization of form and reports.
▪ Provide support and assist users of standard and custom supply chain modules
▪ Coordinate with users on new requirement & changes.
▪ Document new applications, changes and it behaviors / script /queries / messages /functions.
▪ Design and creating user manuals for existing and new application with step by step details.
▪ Train new employees and provide supporting materials.
Tools:
Toad for Oracle, EBS-R12, Form Builder, Report Builder, XML Publisher, Data loader, Ms. Office,
Currently working on Oracle Apex as beginner level.
Maintain and reconcile all data of spinning unit with its transactions & activities to ensure error free data into Oracle database and resolve users queries and problem.
▪ Co-coordinate with concern persons of marketing, accounts, production and dispatch department about pending and existing transaction and reconciliation on month’s end and closing for reporting.
▪ Daily M.I.S reporting regarding production, sale and factory activities to the higher
management on daily basis.
▪ Responsible for smooth process and data flow of supply chain modules (inventory, order management, shipping & WIP discrete manufacturing).
▪ Maintain and document various Records.
▪ Provide support and assist users ORACLE EBS.
▪ Coordinate with users on new requirement & changes.
▪ Develop Ad-hoc reports, make changes in existing reports when required
▪ Forms and Reports development
▪ Registration of Form, Report, Concurrent programs on EBS R12
▪ Design and creating user manuals for existing and new application with step by step details.
Tools:
Oracle E-Business suite R12 (Modules: Sale Order Management, Shipping, Order entry, Inventory
management, Discreet Manufacturing, BOM, WIP) Sql, Pl/sql, Toad, Form and Report developer
Data loader, Microsoft outlook, outlook Messenger, Ms. Excel, Word, Visio, PowerPoint.