概要

Over 08 years’ extensive experience in delivering highly complex and large-scale IT projects.


I am a tech-savvy professional with solid history spearheading complex system migrations and executing robust Oracle applications / database administration. I am well versed in data conversion, data migration, report generation and developing interfaces within several modules in oracle applications. Proven expertise in oracle forms and reports, procedure based forms to meet the management’s requirements. I am proficient in performance tuning SQL & procedural SQL code. I am adept at leveraging outstanding management skills to direct cross-functional team operations, carry out effective task delegation, and prepare in-depth documentation to accentuate operational success. Instrumental in tuning using various types of Hints, Partitioning, Indexes, Explain plan. Articulate communicator, with strong interpersonal skills, and the ability to easily interface with clients to identify requirements and accurately assess needs.


My key skills include Oracle Database Development • Oracle Apex Development • SQL and PLSQL Development • Performance Tuning using Advanced PLSQL • Database Management • Data Integration, Mining, & Migration • IT Management • User Training & Support • Continues Process Improvement • Training & Development


My professional background and great industrial exposure coupled with an excellent track record makes me an ideal candidate for executive roles. As such I would welcome a discussion regarding opportunities with your organization that fit my background.


工作经历

公司标识
Senior Oracle Database Developer(SQL, PLSQL, Forms and Reports 12c)
Strategic Systems International
Oct 2022 - 代表 | Lahore, Pakistan


Directly Working with international client as an Oracle Database Developer
Expertly applied various technologies, including Oracle, Structured Query Language, Procedural Language, Oracle Application Express, Oracle Forms (11g/12g), and Oracle Reports (11g/12g).
Utilized Advanced PL/SQL (Analytical Functions, PL/SQL tables, Record type, Bulk Collects and Bulk Binds) and various types of hints, partitioning, indexes, and explain plan to ensure tuning of application.
Debugged Oracle Back-end PL/SQL development to write packages, stored procedures, functions and triggers.
Achieved bottom line results by applying Oracle built-in packages, cursor management, and exception handling.
Experienced in tuning application using Advanced PL/SQL (Analytical Functions, PL/SQL tables, Record type, Bulk Collects and Bulk Binds)
Experienced in Tuning using various types of Hints, Partitioning, Indexes, Explain plan
Ability to handle multiple tasks concurrently, and perform multiple roles to meet the deadline.
Ability to translate business requirements into technical solution. 

公司标识
Associate Manager
Allied Bank Limited
Aug 2022 - Oct 2022 | Lahore, Pakistan


 Experienced on different projects like POWERBI, OBIEE, and DISCOVERER.
 I have used the SQL and PLSQL to load the data into one source from different data sources. 

公司标识
Oracle Database Developer (SQL, PLSQL, Forms and Reports 11G R2, APEX)
Shaukat Khanum Cancer Hospital and Research Centre
Apr 2015 - Aug 2022 | Lahore, Pakistan

Render a keen eye for details to generate and maintain database objects such as tables, views and materialized views, indexes, constraints, sequences, synonyms and database links. Create complex PL/SQL subprograms, packages, procedures, functions and DB triggers to implement the business logic. Hold full accountability for executing data migration enforcement tasks through data mapping. Apply advanced PL/SQL (analytical functions, PL/SQL tables, record type, bulk collects and binds) to develop applications. Meet assigned deadline while supervising multiple tasks and translating business requirements into technical solution.
Key Accomplishments

Expertly applied various technologies, including Oracle, Structured Query Language, Procedural Language and Structured Query Language, Oracle Application Express, Oracle Forms (11g/12g), and Oracle Reports (11g/12g).
Utilized Advanced PL/SQL (Analytical Functions, PL/SQL tables, Record type, Bulk Collects and Bulk Binds) and various types of hints, partitioning, indexes, and explain plan to ensure tuning of application.
Debugged Oracle Back-end PL/SQL development to write packages, stored procedures, functions and triggers.
Achieved bottom line results by applying Oracle built-in packages, cursor management, and exception handling.
Planned, supervised, and finalized large data migration projects according to strict guidelines while complying with budget and time constraints.

学历

COMSATS Institute of Information Technology
硕士, , BCS‎
Java Programing
CGPA 2.7/4
2014
Punjab College
中级/A级, , F.Sc Pre-Engineering‎
所占比重 61%
2009
naveed foundation high school
非预科, Matric in Science‎
Completed
2007

技能

中级 C++
熟练 Data Management
中级 Data Migration
熟练 Database
熟练 Database Design
熟练 Database Procedures
熟练 Database Schema
熟练 HTML5 
中级 Java
中级 JavaScript
中级 JQuery
熟练 Microsoft SQL Database
熟练 Oracle
中级 Oracle Apex Development
熟练 Oracle Database Development
熟练 Oracle PL SQL Development
熟练 Oracle SQL Developer
中级 Oral Communication Skills
熟练 PL and SQL
熟练 PLSQL
熟练 Queries
熟练 Software Development
熟练 SQL
中级 SQL Server
熟练 Toad
熟练 XML

语言

中级 英语
熟练 乌尔都语