Usman Bhatti Email and Phone Number

o Designing, developing, testing and supporting the applications, which involve programming with Oracle tools such as Forms and Reports 10g, 11g and TOADo Execute PL/SQL Queries, Functions, Procedures and Packages.o Data Migration between different applicationso Designed programs for data extraction and loading into Oracle database.o Managed database tables procedures and indexes.o Develop procedure for Auto Email and SMS to Customer.o TPM development and Data loading utility with API and webutil.o Extensive experience in Extraction, Transformation and Loading.o Created and developed complex PL/SQL procedures, functions, packages and database triggers.o Create, modify and troubleshoot new and existing oracle forms and reportso Develop and enforce best practices to improve system operational efficiency. o Carry out Process analysis / Gap analysis for successful implementation of Oracle application. o Handle multiple projects and manage on-time deliveries. Recommend system enhancements and modifications to improve performance efficiency. o Write requirements definitions and develop optimal solutions to meet project needs.o Ensures that project tasks are completed on time.

o Experience in designing, developing, testing and supporting RDBMS based applicationso Programming with Oracle tools such as Forms and Reports 6i & 10g, Toad, SQL and PL/SQL.o Created and developed complex PL/SQL procedures, functions, packages and database triggers.o Plan and supervise the daily activities of the application supporto Auto/schedule backup of payroll application. o Trouble shooting existing software applications.o Carry out Process analysis / Gap analysis for successful implementation and Development of Payroll Application.o Assists in the creation and implementation of ERP Oracle Financial project plans, status reports and checklists. Creates updates and manage project Open Issues Lists. Ensures that project tasks are completed on time. o Creates technical support documentation. Analysis of Business Requirement and performed Business Process Re-engineering.o Provide user support, handholding and respond to queries. o Provide user training to new users and retraining to existing users on new functionalities. o Managing and maintaining the Time and attendance system (Bio Metric). Manages the purchase of hardware and software products as per CAPEX / Management requirement through purchase department.

Oracle System Implementation