khurram khalil

Responsibilities as IT Manager
Headed Software Development Life Cycle and implemented software applications for the revenue generation and office automation.Administrating All Business Application (Penta System) Penta RMS Management, Security Administration, Supper User.
Responsible for Product Setups, Product cloning, Agency Channel setup, Financial Setup in Penta system.Manage all SMS alert messages to our clients and Agents.Integration of Takaful / Insurance applications with SAP and Oracle Financials 11i.
Effectively utilizes each team member to their fullest potential.Identified and implemented projects for enhancing organization’s net profit but reducing administrative, operational cost and increasing the revenue streams through different services.Involved in analysis, design/architecture and development of Software Applications using Oracle Forms & Reports and ASP.NET. Monitored and proactively managing day to day IT operations and their issues Implemented IT strategies & processes in order to further facilitate& automate business processes and maximize the efficiency and effectiveness of services.Ensured the implementation and continual improvement of IT / IT Security policies for secure and stringent controls throughout the organization using state of the art technology.Human resource management, time management, task management, conflict resolution & people management.Provided monthly or on demand MIS reports to management over the resolution of daily IT Operations, software Issues and status of running IT projects
Feasibility reporting to the management for new projects. Provided project plans to management.Software Development as per the business needs .Dealt with external /internal auditors, Oracle Software & Aetins Licenses vendors.Lead the quarterly held Information Technology software section meetings.

Highlights as Project Manager

Directed and managed the project execution, monitoring and controlling project work, integrating change control and successful closing of the project .Develop Job Roles in Post Change scenarios.Project Coordinator of Core Business Application “Penta Takaful System” by Penta soft Malaysia.Infrastructure Coordinator between Penta soft team and Pak Qatar IT&S hardware team.Documentation of Penta System User security matrix and trainings (Supper Users and IT Users).Successfully closed Disaster Recovery Project.Developed comprehensive document of Data Centre Relocation Project.Ongoing Project Group Life Web portal.
Developing Banka Takaful web portal Project and interfacing with Penta System. Developed Control & Monitoring for Budgeting and Maintenance functions for these projects Completed the Software projects within the schedule and budget.Monitored progress of the project and evaluated compliance with set standards.

Responsibilities as Senior DBA and Application Server 10g

Installation & Administration Oracle Products 11g, 10g Databases, Application Server 10g on Windows 2003 & SUSE Linux, AIX 5L Platform Problem diagnosing/ analyzing and fix them.Develop physical and logical design of a database, as well as configuring security and access permissions.Develop & Implemented Disaster Recovery Plan .Adopt and Implemented different approaches of Database backup and Recovery.Manage and Audit User’s Schemas, Roles and security database & Pentasoft Application Level.Hand on experience in Transportable Tablespaces, Partitioning, Database cloning.Hands on oracle support (Metalink).Applying Upgradation, Maintainace Patches on Databases and Application servers.BATCH scripting to Automate backup procedures on production (Windows based).Created multiple testing environment as per Business users requirement e.g. (without Transaction data). Reorganization database structures as needed. Tune databases using AWR 10g reports to maintain performance and find out performance drop causes. Successfully Implemented Data Guard and Database Migration from Oracle 10g to 11g.

Responsibilities as Project Coordinator

Project Administrator/ Coordinator of Core Business Application “Penta Takaful System” by Pentasoft Malaysia. Infrastructure Coordinator between Penta soft team and Salama IT&S hardware team.
Maintain Project schedule and time line.
Quality Management of all delivers Forms and Initial Reports
Handling all Communications between Pentasoft Team and Salama Team (Technical /Functional).
Documentation of Penta System security procedures and personnel trainings (Supper Users and IT Users).


Responsibilities as Senior DBA

Involves ensuring that an organization's databases are running efficiently and reliably.
Penta System Patch and RMS Management.
Installing SALAMA illustrate Database and Application. Enabling web browser for ActiveX detection.
Installing ActiveX, WAMP SERVER, into the specific client PC, Configuring PHP.ini, My SQL to high performance.
Responsible for the Oracle Server installation and up gradation using 9i, 10g Databases, Also responsible for each and every aspect of Penta Takaful System.
Setup Oracle Client 10g on the SABB Illustrate server.
Administration of Oracle 9i Application Server on Windows 2003 Platform.
Continuous monitoring of all Databases, Performances, Roles and Security maintain.
Implement automatic monitoring of alert logs via email. Ensure disk space utilization and Capacity. Export /Import.
Technical support to users from within the Head Office and Branches.
Mapping the Application executable folder. Configure Oracle client registry to access Penta Takful System.
Preparing Monthly MIS Reports maintain record for Previous MIS reports.

Responsibilities as Oracle Financial 11i Apps DBA

Installation and Configuration of 11i and Troubleshooting.
User creation in Application and allot the respective responsibility.
Attaching customized new reports to Oracle Financial Application.
Involved in audit of Users, Responsibilities, Forms and Concurrent request.

Responsibilities as Database & Apps DBA

Oracle Server installation and up gradation using Oracle 9i, 10g Databases, Oracle Application server 10g and Oracle Financial 11i on AIX 5L Platform.
Installations and configurations on Clients / Servers for Windows XP /Windows 2003.
Size hardware & storage requirements for databases of all sizes.
System testing, Managing and Administration Large databases.
Writing Scripts for performing backup and Restores and many other RDBMS tasks.
Job Scheduling for back end processing on server, Import / Export.
Event scheduling for Auto Email for Database Alert messages, different events and jobs completed Using OEM.
Perform different task for Database Performance and Tuning.
Analysis and design oracle database using Oracle 9i Designer and SCM for Version control. Perform Cloning from Production Server to Test server .Manage Oracle E-Business suit system by using OAM.
Recreating Concurrent Manager Services. Migratation old data into oracle application by ADI.
Change password for Application /Database schema using utility (FNDCPASS)
Registering Oracle username, Report Attachment, Define Data Group, Logical Database.
Working with local vendor for maintenance and licensing issues and Oracle technical support (Meta link) through the SR process.

Responsibilities as Senior Business Analysis

Develop Inventory Control System, Online data transfer Messaging system, upgraded Group Life System, System documentation and User Training, Trouble shooting. Coordinate with team members in the development of organizational information systems. Identify process bottlenecks and build new solutions.

Responsibilities as Data Base Administrator:

As a DBA I’m responsible for installing and upgrading the oracle databases. Developing and maintaining the database documentation. Monitoring user access. Establish and maintain the network connectivity for 110+users on the database. Planning for backup & Recovery and restoring the database and maintain. Monitoring and optimizing the performance of the database.