ORION 11J | IT Distribution | ERP Implementation | Technical & Functional Consultant

Managing the Oracle ERP (Orion 10.6) Software Systems with the modules Finance / Sales / Purchase / Planning / Inventory / Operation / HRMS.Usability Changes in major forms like sales invoice, sales order, goods receipt note and purchase order.Reviewing, designing, optimizing & tuning PL/SQL and Oracle Stored Procedures.Leading application development using Oracle Forms 6i/10g and Oracle Reports 6i/10g.Learning about client's market sector and providing them independent professional advice & guidance accordingly.Interfacing with outside IT consultants and other 3rd party contractors to ensure timely completion of projects.Preparing & modifying database triggers & reports using Business Object Reporting Tools; optimizing SQL queries for better performance and key mapping utility of forms on operating environment.Accountable for complete business analysis of Distribution Business / Process / Network / Operations.Handling MIS related activities for complete business cycle.Working on ERP Administration Finance / Sales / Purchase / Planning / Inventory / Operation / HRMS Modules.Generating reports using XRT tool and ORACLE Discoverer.Maintaining smooth connectivity and access of the ERP in all the group companies in UAE, Qatar and India.Executing & implementing Hardware (OS Installation / Database Installation / Network Printer Installation / LAN Configuration) across all the group companies.Taking complete ownership of all the IT and Telecom related activities in all the group companies.The direct point of contact for any IT related Purchases and IT related decisions across all the companies in the group.Managing the Active Directory and Domain Control Server and all the users.Managing Exchange Server and configuring the exchange server email to the concerned users.Design and execute the Group Policy for all the users in the group.Checking & monitoring the implemented modules, back-up and data flow on a daily & weekly basis.

Complete administration of ORION ERP (Oracle based) 10.4 for Finance (GL/AR/AP/FA/Cash/Bank Reconciliation), Operations (Sales,Purchase,Inventory,Job Contracting),HRMS & Payroll Modules.• Providing complete application support and technical expertise to ORION users.• Resolving all technical issues pertaining to ORION.• Gathering business requirements and understanding/creating company procedures in order to provide optimum software solutions. • Plan, design, implement and map business processes into existing ERP system. • Develop new system functionalities after detailed analysis of user requirements.• Customize and modify the existing codes to suit existing / new business needs.• Construction of Forms & Reports in Oracle D2K.• Reports generation with Discoverer 9i. • Writing queries and creating ad hoc reports using TOAD.• Generating reports using XRT tool• Data correction from back end using TOAD / SQL Plus.• Creating and updating stored procedures, packages and triggers.• Troubleshooting on front-end and database level.• Provide in-house training to employees for various Orion features, functions and their process.• Maintaining documentation for existing and newly configured system functionalities and processes.• Installation and setup of ORION base product.• Performing system upgrades and patches to ensure optimal functionality.• Maintain database backup on daily basis.• Acting as primary liaison with ERP vendor• Coordinating with vendor support team for issues that cannot be resolved in-house• AVAYA IP Telephonic system administration.• Blackberry Server Administration.• User Configuration, Addition, amendment, in the Blackberry server.• Managing the Active Directory and Domain Control Server and all the users.• Managing Exchange Server and configuring the exchange server email to the concerned users.• Backup scheduling and preparing the documentation for the same as per the ISO requirement.

• Maintaining the application Orion developed by 3i Infotech using forms and reports. • Coordinated with Vendor for quotations on new software or hardware.• Programmed Oracle D2k Forms and Reports, PL/SQL, Oracle 9i• Managed and maintained a mid range ERP system called ORION v7.4.• Maintained a program using Visual Basic and MS Access, to access data from biometric system and generate Attendance and overtime for employees of the company.

• Attending to the incoming calls from USA and Canadian Customers with HP Computers and Laptops; and make sure that their technical issue with their HP Products are resolved.• Cross selling any HP Products to the customer with complete satisfaction.• Fetching Positive Remarks from the Customers through the email survey.• Submitting the day today calls summary attended by all the technicians in the team to the Team Leader.

• Networking issues to be handled and sorted out immediately after getting information from the Senior Engg.• To make sure that CCTV around the bank comes in line with the Network and monitor the CCTV.• Providing user access to the doors in the bank to all the staffs of various departments according to their need.

• Attending the Calls from the Customers and visit location where computer is and resolve the issue with their Computers and computer related accessories.• Hardware / Networking Issues with various Customers to be handled.

• Attending the Calls from the Customers and visit location where computer is and resolve the issue with their Computers and computer related accessories.• Hardware / Networking Issues with various Customers to be handled.• Do Market about the firm, sell computers and computer accessories.