Syed Imran Qadri

An accomplished consultant with expertise in Financial, Retail, Manufacturing, and FMCG industries. Adept in restructuring departments and aligning technology with business. Possesses a demonstrated track record for delivery of global initiatives. Recognized for ability to plan, develop, and implement large-scale solutions within predetermined time frames and budgets. Well-organized, results oriented individual with solid management skills, capable of leading and motivating individuals to maximize productivity, while forming a cohesive team environment. Honored to have worked with market leading companies with the likes of AT&T, BookSpan, and OraTech Consulting. Currently associated with the Leading Retail Group in Saudi Arabia. • Technology Leadership • Program/Project Management • Hands on Leadership • Software Development Life Cycle • Strategic Planning • Governance & Compliance • Data Warehousing • System Integration • Change Leadership • Process Improvement • Architecture Design EDUCATION DETAILS: MBA Preston University1995 B.SC. in Science Karachi University1992 Diploma in Computer Science Petroman Computer Institute1992 Diploma in ElectricalKarachi Technical Board1990 SYMBOLS(Oracle Base Banking App)Ora-Tech On Site Training2003 Primavera ICI PTA On Site Training 1998 Oracle DBAICSS Skill Development1996 Oracle DeveloperICSS Skill Development1995 PROFESSIONAL AND SOCIAL AFFILIATION LinkedIn Public Profile: http://sa.linkedin.com/pub/syed-imran-qadri/5/891/364 Active member at Pakistan Oracle User Group Active member at Arab Oracle User Group Active member at Professional Database Projects Forum EXPERIENCE AND SKILL DETAILS: Databases & App : Oracle 12C/11G/10G/9i/8i/8.x/7.x/6.0, DB2 6.0/7.0, Oracle AS 10GAS/9iAS,Weblogic Languages : PL/SQL, iSQL, SQL, Shell Scripting (sh/ksh), DB2 SQL, Informix, FoxPro. Utilities & Tools : OEM, Forms 11G/10G/9i/6i/6.0/5.0/4.5/4.0/3.0, Reports 11G/10G/6i/6.0/3.0/2.5/2.0, SQL*Loader. EXPDUMP/IMPDUMP, Tkprof, Statspack, AWR DB2 Tools : Catalog Manager, Query Management Facility (QMF), SQL Processor using File Input (SPUFI) Misc. App. & Tools : MAXIMO 9-10, Oracle Financial(Inventory/Payable & Receivable/GL), Primavera, Erwin 4.0/3, COGNOS 8.3, SYMBOLS- Core Commercial Banking Application Operating Systems : UNIX, AIX 5L-4.x, Solaris 2.x, Windows NT 4.0/XP/98/95, Win2000/2008/2012-R2 and OS/390 EMPLOYMENT HISTORY: 1. From Jan 2011 to till Bindawood Group, Jeddah, KSA as Manager Database & Integration 2. From May 2007 to Dec 2010, AT&T, San Antonio, TX, USA as Project Manager 3. From March 2006 to May 2007, MCB, Karachi, as IT Coordinator / Manager Business Technology 4. From Jan 2003 to March 2006, Ora-Tech Karachi, as Senior Technical Consultant 5. From Oct 1999 to Dec 2002, Ace Technologies Inc., USA as Sr.Oracle Consultant 6. From Aug 1997 to Oct 1999, Saudi Business Machine as DB Manager 7. From Nov 1995 to June 1997, TCS Pvt. Ltd. as Development Team Leader 8. From Sept 1992 to Oct 1995, System Research, as System Analyst/Programmer EMPLOYMENT DETAILS: Organization: BinDawood Group-Saudi Arabia Role: Manager Database & IntegrationDuration: Jan 2011 - Present Environment: Windows 2012R-2 Servers, AS400,Oracle,IBM-JDA Responsibility: Accelerating and managing MIS Development and DB Warehouse Managing MIS Development and DB Warehouse Working for Databases including secure Data Integration. Working on ePayment project for B2B and B2C with IT services department as DBA & Data Mart specialist Working on various types of background stored procedures to automate procedures. Working on Data Modeling by using Erwin Tool and auditing security procedure. Recently performed different types of migration of complex databases. Using Oracle Enterprise Manager (OEM) for different database tasks. Report direct to CFO (The Best CFO awarded in KSA) Organization/Client: AT&T-USA Role: Project ManagerDuration: May 2007 – Dec 2010 Environment: Oracle 9i&10g DB, SQL*Loader, Export/Import, Windows 2000 Server, Linux 4, Oracle 9iAS, iSQL, SQL, PL/SQL, OEM, Shell Scripts Responsibility: I was responsible for the many lease roll over for the database servers. Coordinated with off shore teams for on time project/task completion. Worked in a cross-functional, matrix team environment, and showing expertise in communications management, training delivery and stakeholder management. Created and maintaining Project Plan and issue project charter. Ensuring proper assembly of operations and maintenance documentation. Participated in the design of the solutions to ensure business processes integrity for delivery to the organization. I was responsible to provide stream direction in accordance with project deliverables and timelines. Coordinated for project deliverables with functional and technical experts. Organization/Client: MCB Bank Limited, Karachi Role: Manager Business TechnologyDuration: March 2006 – May 2007 Environment: Oracle 10G, 10G AS, 9iAS, Symbols, MIBS Responsibility: Coordinated between core IT team and Commercial Banking Gather requirement from Branches/Hub Offices, compile and coordinated I was Responsible for smooth operation &Manage Country wise ATM operation Completed MIS for Retail Banking Group. Team member for monitoring high volume transactions. Liaison with IT regarding new Business requirements and Information systems’ improvements and Member of different reviewer IT Group SYMBOLS was newly adopted application of Bank which developed in Oracle tools and they were using Oracle Database and Application server to run on different Branches. Help and participate to Restored database after crash, with help of available backups with minimum down time, frequent backup and recovery on production and test server. Project Description: I was responsible for coordinating between core IT team and Commercial Banking , Gathering requirement from Branches/Hub Offices, compile and present to management for approval and making sure to get it done. I was also responsible for smooth operation & Manage Country wise ATM operation. In Addition I was member of different reviewer IT Group and It staring team. Lastly I was responsible for make sure for smooth operation of Symbols (New Core Banking Application). Organization/Client: Ora-Tech Karachi Role: Senior Technical ConsultantDuration: Jan 2003 –March 2006 Environment: Oracle 10G/10G AS, 9iAS, iSQL, SQL, PL/SQL, SQL*Loader, Export/Import, OEM, Shell Scripts, Windows 200 Server, Sun Solaris Responsibility: Worked on Oracle 10G/9iAS WIN 2000 Server Support Different type of Industrial Client for different type of Database issues. Visits Client sites for performance tuning of production environment Worked various types of background stored procedure to automate procedure. Performed different types of migration of various databases. Configured various standby databases for backup. Worked on partition tables and indexes on large tables for better performance. Used Oracle Enterprise Manager (OEM) for different database task. Worked on Load balancing. Wrote Shell Scripts to automate monitoring of database performance and size. Restored database after crash, with help of available backups with minimum down time. Handled frequent backup and recovery on production and test server. Project Description: I was responsible for support to clients and be a team member helps juniors for fulfill their client’s problems. Also was responsible to look after installation of Oracle with different type of OS like Aix 5L, Solaris, win2000Server, etc. Took comprehensive training of Symbols (Core Banking Application which is developed in Oracle), training include modules like Customer Landing, Branch Teller, Deposits, Kernel, Trade Finance, Knowledge Manager. Worked as Project Manager at Federal Urdu University for Development and Implementing complete automated admission, Enrollment and examination process. As well as Accounting, HR and Library Module. Completed assignment for UNDP (Program for Afghanistan) for Database Replication. My role was to install Oracle and configure replication on different servers at different physical locations. Organization/Client: ACE Technologies Inc., USA Role: Sr.Oracle Consultant Total Period Oct 1999 To Dec 2002 Assignment for Bookspane Inc., NYDuration: February 2001 - Dec 2002 Environment: Oracle 9iAS, PL/SQL, SQL*Loader, Export/Import, OEM, Shell Scripts, Windows NT 4.0, Solaris 2.6. Responsibility: 1 Worked on Oracle 9iAS WIN NT and Oracle 8.0.6 on Solaris 2.6. Worked various type of background stored procedure to automate procedure. Responsible for collecting data from different resource/Platforms and manage data warehouse. Performed migration of database from Microsoft SQL to Oracle 8.0 and then to Oracle 9iAS. Loaded large volumes of data from flat files into Oracle 8i database using SQL*Loader. Transferred data from file to database using Export/Import. Configured standby database for backup. Worked on partition tables and indexes on large tables for better performance. Tuned database using Oracle Enterprise Manager (OEM). Worked on Load balancing Wrote Shell Scripts to automate monitoring of database performance and size. Restored database after crash, with help of available backups with minimum down time. Handled frequent backup and recovery on production and test server. Used NET 80 for networking. Project Description: I was responsible for maintenance and support for company 24/7 days production database, including responsible for backup and recovery in worst case scenarios. Assignment for AT&T, NJDuration: July 2000 - January 2001 Environment: Oracle 8.0/7.3, PL/SQL, SQL*Loader, Export/Import, Shell Scripts, OEM, Erwin 3.5, Windows NT 4.0, HP Unix, AIX Responsibility: Installed and configured Oracle 8i on Windows NT 4.0, Managed Data warehousing with different tools Worked on HP Unix and AIX as a Platform with Oracle 7.3.4 Loaded large volumes of data from flat files into Oracle 8i database using SQL*Loader. Organized contents of database through table spaces. Worked various type of background stored procedure to automate procedure. Configured standby database for backup. Wrote scripts to automate monitoring of database performance/size and to identify error. Restored database after crash, with the help of available backup with minimum down time. Involved in database architecture and design of logical and physical data model using Erwin 3.5. Transferred data from file to database using Export/Import. Tuned database using Oracle Enterprise Manager (OEM). Project Description: I was responsible for support of development server, and also responsible for performance tuning of SQL and help to fine tune of their backend procedures, Backup and recovery was also my responsibility. Assignment for Huntington, WI Duration: Oct 1999 - June 2000 Environment: Oracle 8i, PL/SQL, SQL, SQL*Loader, Export/Import, Shell Scripts, OEM, RMAN, Erwin 3.5, Windows NT 4.0, Aix. Responsibility: Installed, configured and administered Oracle 8i. Did Performed upgrade with complete data transfer from old Oracle server. Loaded large volumes of data from flat files into Oracle 8i database using SQL*Loader. Transferred data from file to database using Export/Import. Tuned database using Oracle Enterprise Manager (OEM). Designed Oracle Database Security measures and participated in design of long-term archival procedures. Designed database structure. Organized contents of database through table spaces. Involved in database design of logical and physical data model using Erwin 3.5. Did backup and recovery using RMAN. Worked on Clustering to enhance processing speed. Used Oracle Enterprise Manager for monitoring database. Wrote Shell Scripts to automate monitoring of database performance and size. Designed backup strategy using archiving and hot and logical backups. Implemented transformation of logical database design to physical database. Designed and re-structured database to reduce contention and fragmentation. Restored database after crash, with the help of available backup with minimum down time. Supported maintenance window activities. Used Trace files and TKPROF utility for diagnosis. Diagnosed SQL statements using Explain Plan. Project Description: It was a software consultancy firm where I was utilized my experience in different ways, like support programmers for their backend programs, database performance tuning, loading data from other databases, including Installation of different versions of SQL server. Organization/Client: SBM (Saudi Business Machine) Position: DB ManagerDuration: Aug 1997 - October 1999 Environment: Oracle 8.0/7.3, Shell Scripts, OEM, AIX, and Windows NT 4.0 Responsibility: Installed, configured and administered Oracle 8.0 on Windows NT 4.0 and AIX. Did Migration of database from Oracle 7.3 to Oracle 8.0. Managed Hospital Management Information System (HMIS) application. Used TCP/IP LAN for these applications. Managed DBA activities such as ensuring availability of Oracle database and application, formulating backup strategies, downtime planning, database sizing, performance tuning and monitoring, and disaster recovery planning. Installed and configured Oracle replication and linked with five different remote locations. Tuning of MAXIMO database, Developed reports in Oracle Tools and plugging to MAXIMO Project Description: It was a project of IBM for one big hospital which was located in Al-Jubail Saudi Arabia, where I was responsible for Oracle database administration, In same project I configured complex replication in Oracle to link with 9 remote location. Organization/Client: TCS Private Limited Position: Development Team LeaderDuration: November 1995 - June 1997 Environment: Oracle 7.1, PL/SQL, SQL, Erwin, Oracle Utilities, and Windows NT Responsibility: Worked as Senior Oracle DBA using Oracle 7.2.3 Managed Billing Application to process from Booking to Billing to customers. Wrote background SQL script to automate Billing Application and synchronize database with remote locations. Prepared data transfer methodology from remote location to head office via different channels. Wrote Business procedures to customize application. Project Description: TCS is sister company of DHL worldwide, where I was responsible for database administration and migration of database from Informix to Oracle, in addition I was responsible for backup and recovery and managing of data warehouse. In addition I was involved in the development of the following systems using Oracle Developer 2000: - Order Management System. - Courier Pickup Order Management System. - Coupon Management System. - Accounts Receivable. - Manifest System Organization/Client: System Research Pvt. Limited Position: System Analyst /Programmer Duration: September 1992 - October 1995 Environment: Oracle 7.0/6.0, PL/SQL, SQL, Developer 2000, Forms 4.0, Reports 2.0, UNIX Responsibility: Performed analysis, design, development and administration of applications using Oracle 7.0/6.0. Developed applications viz., Purchase and Payable system, Sales and Receivable system, Financial Accounting system (G.L, Petty Cash, Budget), Personnel and Payroll system, Costing system, Karachi Stock Exchange and Library Management system Project Description: SR is a software consultancy firm where I was started my carrier from beginner and become a practical person for database operation, In same company I was involving system analysis, designing and developing of customize application on Oracle development tools for various customer.