Imran Khan

**-* *** ******, ******** Cell: +923********* Email: adg8s6@r.postjobfree.com

PROFESSIONAL SUMMARY

An Information technology professional with extensive experience in all phases of software development life cycle including System Analysis, Design, Data Modeling, Data Migration, Implementation and Support of various applications with domestic and international clients and insight over wide array of industries Key Skills

Database Programming SQL, PL/SQL, T-SQL, Oracle Developer Database Tuning Spotlight, Oracle AWR and SQL Server profiler Tools Erwin, TOAD, PL-SQL Developer, SQL Developer, Visio, MS Project Databases Oracle 8/9i/10g/11g, SQL Server 2005/2008, MYSQL (Basic) Operating System Windows, Linux, Solaris

ETL Data warehousing Concepts/SQL Scripting/SSIS

New Learning Cloud Native Computing and AI using Python (Initial)

• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

• Project Planning, Resource Planning, Time and Cost Estimate and Documentation

• Process flow diagram using Visio

• Data Modeler with strong Conceptual and Logical Data Modeling skills, has experience of requirements gathering, creating data mapping documents, writing functional specifications, queries.

• Extensive experience in Relational for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.

• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, created naming convention files

• Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.

• Participated in the Gap Analysis activity and developed Requirement Specifications and Functional Specification documents.

• Involved in the Effort & Cost estimations and performed Impact Analysis on requirements.

• Acted as technical lead for various projects and involved in projects from its inceptions to delivery and maintenance and reporting directly to Head of departments.

• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design technique

• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008 and 2012, Transact SQL, PL/SQL, SQL *PLUS, PL/SQL Developer, TOAD and SQL*LOADER.

• Developed complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL, T-SQL and PL/SQL.

• Experience with data migration and loaded data into Oracle and SQL Server tables using SQL Loader, SSIS.

• Monitoring performance and rectifying performance issues by optimization of top queries using AWR and ASH

• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

SPECIALIZED COURSES/CERTIFICATIONS:

o Oracle DBA Certified Professional

o Cloud Computing Workshop (PITB 5 full days)

PROFESSIONAL EXPERIENCE

Company Name : NetSol Technologies Inc.

Tenure: March 08, 2008 to Present

Job Status: Permanent

Designation: Senior Database Architect/Team Lead

Product Title: NetSol Financial Suit (Contract Management System) Onsite Experience

China

Worked as key member of China delivery team in NETSOL Beijing office to provide all type of first level support for China region clients including (Mercedes Benz, Hyundai, Toyota, and Nissan)

• Discuss new requirements and help to finalize the requirements along with back office team and involved in complete life cycle of the change request, provide after live support as well.

• Follow-up all open issues with back office project team and client.

• Provide first level support on all client reported issues

• Involved in estimation, functional specification finalization with the help of project team and client discussions.

• Cross selling of product new features which are already implemented on one of the client in same market.

• Data migration from legacy systems

Thailand

• Worked with the ISUZU client for initial requirements.

• Deliver Product database design training to ISUZU, along with data dictionary for better design understanding to build reports and stationeries.

Projects at NETSOL Technologies

Projects o Auto Finance / Leasing Retail Information System o Toyota Leasing Thailand – Thailand

o BMW Financial Services - China

o Mercedes-Benz Auto Finance – China

o PACCAR – Mexico

o ISUZU Thailand

o Beijing Hyundai Auto Finance Company – China

Tools o Oracle 9i/10g/11g/12c/MYSQL

o SQL Server 2008/2012/2014/SSIS

o ERWin/Visio/Toad/PL SQL Developer

o Power Builder

o Windows/Linux

My Roles o China Regional Team Lead

o Data Model Team Lead

o DB Optimizer Team Lead

o Data Migration expert

Company Name : Sitara Textile Industries

Tenure: December, 2002 to July 2007

Job Status: Permanent

Designation: Asst. Manager IT

Projects at Sitara Textile Industries

Project Details • Marketing/ Order Management System for Textile Exports

• Financial Accounting System (FAS)

• Integrated Inventory Control System (IMS)

• HR/Payroll Management System

• Weaving / Grey Conversion Management System

• Textile / Processing Management System

• Stitching Production System

• Integrated Housing Construction System for Sitara Sapna City. Tools • Oracle 9i, Oracle Forms & Reports 6i, Erwin

• Oracle 10g, Oracle Forms & Reports 10g

My Roles • Analyst

• Developer

• Asset. Manager IT

Education

• Master of Computer Science from Al-Khair University AJK 1998-2000

• B.Sc. Punjab University 1996-1998

Personal Information:

Full Name IMRAN KHAN

Address 88-X DHA Lahore, Pakistan

Mobile Number +923*********

Email adg8s6@r.postjobfree.com

Passport Details Number : DR4100053 Date of Expiry : 14-Nov-2020 Date of Birth 03-May-1977

Marital Status Married

Languages English, Urdu, Chinese (initial)

References

Personal and professional references will be furnished upon request.

Contact this candidate