Email: [email protected],
House # A-73, P.C.S.I.R Society, Gulzar-e-Hijri
Scheme-33 Karachi Pakistan.
Contact: +92 333 2140915 / +92 300 2140914
+92 315 3311221 / + 92 21 34156157
IMRAN ALTAF
Senior Manager Applications and Databases Administration
Professional Objective
To join a dynamic and progressive organization offering unique opportunities of diversified exposure where I can possesses over 20 years of versatile and hands-on experience in almost all the spectrums of IT including but not limited to IT Infrastructure, ERP & Business Intelligence, Project Management, Networking, Web Servers, Languages and Databases. Utilize.
Area of Expertise
– Oracle Database 10g/11g – Oracle EBS R12.2.4/R12.1.3 – Oracle Data Gard/RAC/Grid
– Oracle Application Server 10g – Oracle Linux (Distributions) – Oracle Developer 10gs
– MS IIS Server 6.1/7.0 – Linux (Red Hat,Centos,Ubantu) – IBM AIX 6.1, HP-UX 11i
– MS Windows 2008/2012 – IBM WebSphere – MS SQL Server 2008/2012/2016
– IBM Storage DS-8800/4700 – SAP Bases / Net viewer 7.0 – Oracle RMAN & PT
Professional Certifications Courses
– Oracle Certified Professional (DBA + Developer Track)
– Red Hat Linux
– Brain Bench (Oracle DBA + Developer)
– ITIL – BCP/BCRS
Professional Trainings
– SAP Basis – Red Hat Linux – HP-UX 11i Administration – Swift /RTGS Banking
– Fidelity Core Banking System ( Profile, Theta, PFW, etc) – IBM-AIX – MYSIS Kondor Treasury
Academic Qualification:
– Masters in Computer Science from (PAF-KIET) University Complete in [July-2008].
– BCS. in Computer Science from Al-Khair University Year (2004)
– Two Year Professional Diploma in Computer Science & Architecture.
– Intermediate in Commerce from Govt. College of Commerce & Economics, Karachi. (1998)
– Matric Science from Govt. Boys Secondary School Karachi. (1996)
Professional Qualification:
– Two Year Professional Diploma in Computer Science & Architecture.
– Certified course in Red Hat Certified Engineer from Techno-ED Institute.
– Certified course in Oracle Developer 2000 from Noor College of. Prof Education.
– Certified course in MS/SQL Server 2008 R2 Administration.
– JAVA Certified Professional, JAVA 2.0.
– OCP (Oracle Certified Professional) Application Developer Release 2.0/6i.
– Complete certified course in Oracle10g DBA from Oracle University.
– Complete Oracle Data warehouse Course from Oracle University.
– Course in Domino Administration with Lotus Notes.
Professional Objective
Professional Experience:
– 10+ years working as a Production DBA and System Administrator in multiple MNCS and Banking Sectors.
– 4+ years working as a Team Lead to implement a Data Warehouse and Data Mining Projects.
– 10+ years working on OLAP/OLTP Databases.
– 10+ years working as a Software Development Project Manager.
– 4+ years Oracle WEB logic, Fusion Middleware and Oracle Infrastructure Administration / Performance Tuning.
– 8+ years as a system administration (Linux(Red hat), Centos, Suse, AIX, HP UNIX and other Unix flavors)
– Database trainings, support and provide consultancy in different projects
– Working in Different MNCs Banks and Corporate Sectors.
– Working in IBM Solutions Tivoli (TSM), P6/P7 Machines, IBM SAN DS8800 and DS4700.
– Database Performance tuning, and ETL Code Optimization.
– Strong knowledge and hands on expertise on the following operating systems (Unix Linux AIX Hp-unix and Windows(x)
– Database back end Development Experience on the following tools PL/SQL Developer, Erwin, and Toad Sqlplus.
– Shell Scripting. Jobs Scheduling cron Jobs.
– Database Tuning, Query optimization, Init.ora configuration, Memory optimization, Table/Index analysis, etc
– Development, testing, and troubleshooting of Packages, stored procedures, views, triggers, materialized views.
– Partition strategies, OLTP, OLAP, Stored Procedures, Performance Tuning.
TF Group (Pvt.) Ltd January – 2017 – Present
Senior Manager Databases and Infrastructure
I have joined TF Group as a Senior Manager Databases and Infrastructure, I have successfully completed the following projects end to end deployments and team management.
· Pakistan State Oil, Card Payment system. I have completely design and readiness the Infrastructure of the said system on CLOUD in following technology. Java design application with the database of Oracle 11g Cluster (2 Node) reside on private Cloud, we are using base operating system Redhat Linux (6.5) and also use Transaction Encryption by HSM, tomcat application server with Load Balancer,
· Shell Pakistan, I have Design and Configured VeriFone NAC and HSM to perform shell card payment transactions from POS Devise and communicate to host server. I have completely design and readiness the Infrastructure of the said system on CLOUD in following technology. Windows Server 2012 DC Cluster on Cloud, MS SQL Server 2016 always on Cluster (2 Node) on Cloud, Transaction Encryption by HSM, IIS Server Load Balancing Cluster (4 Nodes), Hyper-V 2016 V-Cluster
· Current Projects:
· Design Core Infrastructure and Database Core Architecture for United Bank Limited e-Commerce system.
Mobilink Pakistan ePayment system:
I have design Electronic commerce, commonly known as e-commerce or eCommerce, or e-business consists of the buying and selling of products or services to perform payment over electronic systems such as the Internet and other computer networks.
Inbox Business Technologies (Pvt.) Ltd April – 2016 – December – 2016 10 – Months
Senior Team Lead Technical (Oracle EBS R12 Apps/DB/Linux Distribution)
I had joined Inbox Business Technologies as a Senior Team lead of Technical team (DBA), I have manage and install/configured oracle EBS R12 database and application server eg: EBS Suite, EBS multi nodes, Datagard 11g,12c, WebLogic merge nodes.
Following are the current projects as below:
· Habib Bank Ltd, under implementation of Oracle EBS suit R12, prepared R12 EBS Production, UAT, TEST and Staging environments, with end to end readiness of linux and oracle ebs suite.
· UBL Bank Pvt. Ltd, have been successfully implement Oracle EBS suit R12, (GL, HRMS, PAYROLL, CONTENT, BI) modules are successfully live and running in production environment.
– EBS Cloning from RAC to RAC environment, RAC to NON RAC instances.
– Configured Dataguard for single node for EBS R12.
· TCS Pakistan PVT Ltd , Successfully implement Oracle EBS suit R12, Production, UAT, TEST and Staging environments, with end to end modules readiness, integration and HA environment of linux and oracle ebs suite.
OIES International Services and Consultants September – 2006 – January – 2016 09 – Years
Manager IT, Database and Systems Consultant
I had joined OIES International Services as a Senior Database Administrator and I had completed big life experience Projects in my 09 years journey at OIES International Services.
Following are my key Projects:
· Working in the core team for the implementation and assessment of technically hardware and software’s installation/configuration for the NBP Core Banking ERP “Profile” system.
· Working in the core team for the implementation of SAP (HRMS, FICO).
· Working in the core team for the installation and Implementation of IBM P7 and P8 machines and IBM DS-8800 and DS-4700 storages.
· Working in the core team for the installation and Implementation of HP-UX super-dome machines for NBP Core Banking Application.
· Install and implement Microsoft virtualization cluster Hyper-V. approx. 100 plus production machine operational.
· Oracle 11g RAC and Data guard implementation.
· NBP Prime Minister Loan application for Govt. Loans, Lead the complete application development and implementation in all over Pakistan like NBP 1400 branches. “Technology – Oracle DB 10g & Oracle Developer”
· NBP SAIBAAN application for consumer house loans, Lead the complete application development and implementation in all over Pakistan like NBP 1400 branches. “Technology – Oracle DB 10g & Oracle Developer”
· NBP ROZGAR application for consumer goods, Lead the complete application development and implementation in all over Pakistan like NBP 1400 branches. “Technology – Oracle DB 10g & Oracle Developer”
Following are the Key Responsibilities:
· Manager/Team Lead System and Database Administration.
· Install/Manage Oracle 11g/10g Database Server’s Administration, Oracle Data guard, Rman, Grid Vault, etc. .
· Install/Manage Oracle10g Application Server’s Administration.
· Install/Manage SQL Server 2005 Administration.
· Install/Manage IIS Server 2003 Administration.
· Install/Manage Microsoft 2000/2003 Server’s Administration.
· Install/Manage Unix/Linux/AIX 5.3,6.1 Server’s Administration.
· Manage Data Warehouse (4 to 10 Terabytes).
· Maintain Daily Basis Oracle Database Hot & Cold Backup’s.
· Maintain Daily Basis SQL Server 2005 Automatic Tape & HD Backup’s.
· Maintain Oracle Applications Backup when deploy new version.
· Involved Application Database design and object creation
· DB Account creation, modification, deletion, Monitoring, troubleshooting, Remediation, Migration, Upgrades.
· Oracle10g Database Tuning & Performance.
· Oracle WEB logic, Fusion Middleware Application Server Administration Tuning & Performance.
· Troubleshooting Oracle10g Database & Application Server.
· Demonstrated proficiency in all techniques of database schema creation and maintenance.
· As Per Bank Requirement to make Core Banking Integration Software.
· Coordinate with vendors for the new software/Hardware Deployment and Implementation.
· Coordinate/Troubleshoot on daily basis Branches Related Problems on Application and Database Servers Site.
· Coordinate with vendors for the resolution of Hardware/Software.
· Coordinate with software vendor for new business requirement.
· Currently working on Disaster Recovery/Business Continuity Project for multiple applications.
· Train & develop team on upcoming technologies for smooth operations.
Pak-Libya Holding Company Pvt. Ltd December – 2004 – September – 2006 02 – Years
Manager I.T. Database and Systems
I was working in Pak-Libya as a Manager I.T and my Job Responsibilities are to Manage Oracle Database Administration & coordinate with Sidat Hyder Murshid Associates Project Manager’s for the Implementation of Sidat Banking ERP system in Pak-Libya.
Pak-Libya Holding Company is a Financial Institution; I have managed Pak-Libya Oracle10g Database Administration and support to Banking/Financial ERP Software Like GL, Fixed Assets, Portfolio Accounting System, Hr, Payroll, & Loan Accounting Systems. All systems run in Oracle10g Environment & front End Oracle Developer (10g-IDS). I have also Designed Disaster and Business Continuity Plan that Replicate Oracle operational database server to remote site and also replicate the Users/OS data on Real time basis.
Afghan Group of Companies Feb – 2000 – November – 2004 05 – Years
Manager Database and Application Development
In Afghan Group, My working position was Manager-IT and my job responsibilities were to manage Oracle Database Administration and Develop Afghan Group applications in Pure Oracle Environment.
I had designed & developed the software’s for Afghan Group, I am using Oracle 9i database server and front end is Oracle Developer 2000 Rel.6i, The Afghan Group software application are Barcode Inventory System, Point Of Sale, CRM, Sale & Purchase Module’s, Leather Tannery, General Ledger, and A/C Receivables & Payables. All modules run all over Pakistan with the support of broadband connectivity.
Technologics Software House Jan – 1999 – December – 1999 01 – Years
Oracle Developer and DBA.
In Technologics I was working as Oracle Application Developer/Analyst, Technologics is the software house that work on Pakistan & Middle East market. In technologice I have designed & developed many software applications modules based in oracle developer and oracle database. These are the major client of technologics there I had independently develop applications.
· Afghan Group of Companies.
· Hyundai Defense Motors.
· Suzuki Margalla Motors.
· Orient Exporters.
· Pearl Continental Hotel (Pakistan).
Major Achievements:
Æ Successfully Implement Fidelity Profile Core Banking Solution In National Bank of Pakistan.
Æ Successfully Implement SAP GL and HRM Module in National Bank with Complete understanding of SAP Basis.
Æ Successfully implement SWIFT/RTGS system in Pak-Libya.
Æ Successfully implement E-CIB system in Pak-Libya.
Æ Successfully implement disaster recovery & business continuity plan in Pak-Libya.
Æ Successfully Implement Oracle Data Marts * Warehouse in National Bank of Pakistan.