Sultan Mahmood
Oracle Database Developer
Lahore,Punjab
Summary
Highly-motivated employee with desire to take on new challenges. Strong worth ethic, adaptability and exceptional interpersonal skills. Proven expertise in oracle forms and reports, procedure-based forms to meet the management’s requirements. Proficient in performance tuning SQL & procedural SQL code. Articulate communicator, with strong interpersonal skills, and the ability to easily interface with clients to identify requirements and accurately assess needs.
Overview
9
9
years of professional experience
Work History
Principal Software Engineer (Oracle Database Developer
STRATEGIC SYSTEMS INTERNATIONAL
Lahore
10.2022 - Current
- Directly Working with international client on Standard Application project as a Senior Oracle Database Developer.
- Expertly applied various technologies Including Oracle SQL, PLSQL and Oracle forms and reports 11g/12c.
- Using advance level SQL and PLSQL to write the business logic to fulfill the client requirements.
- Using various techniques to improve the performance of SQL Queries and PLSQL.
- Experienced in tuning application using Advanced PL/SQL (Analytical Functions, PL/SQL tables, PLSQL Types, Record type, Object Types, Bulk Collects and Bulk Binds)
- Tackled development tasks based on system requirements and documented approaches.
- Debugged Oracle Back-end PL/SQL development to write packages, stored procedures, functions and triggers.
- Worked closely with development team members to identify and remove software bugs.
- Evaluated performance of team members and provided consistent coaching to improve skills
Associate Manager (Oracle Database Developer)
ALLIED BANK LIMITED
Lahore
08.2022 - 10.2022
- 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.
- Handled responsibilities successfully in manager's absence.
- Evaluated performance of team members and provided consistent coaching to improve skills.
- Prioritized and delegated tasks for efficient completion within team environment.
Senior Software Engineer (Oracle Database Developer
SHAUKAT KHANUM CANCER HOSPITAL AND RESEARCH CENTRE
Lahore
04.2015 - 08.2022
- SQL, PLSQL, Forms and Reports 12c, Oracle APEX
- KEY ACCOMPLISHMENTS 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 and Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers to implement the business logic
- 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
- Experienced in Oracle APEX Development
- Experienced in large data migration projects
- Performed data migration enforcement tasks through data mapping
- Interacting with business analyst and participating in user requirement session to analyze and gather business
- Requirements
- Ability to handle multiple tasks concurrently, and perform multiple roles to meet the deadline
- Ability to translate business requirements into technical solution.
Education
BACHELOR OF SCIENCE - COMPUTER SCIENCE
COMSATS Institute of Information Technology
Lahore, Pakistan01.2014
F.S.C Pre Engineering -
Punjab Group of Colleges
Lahore, Pakistan01.2009
FSC -
MATRICULATION,Naveed Foundation High School
Lahore, Pakistan01.2007
Skills
- Oracle Database Development
- Database Designing
- SQL
- PLSQL Development
- SQL Tuning
- Performance Tuning Using Advance Level PLSQL
- Database Tuning
- Oracle Form and Reports 11gR2/ 12c
- Oracle Apex Development
- Data Migration
- Code Debugging
- Requirement Gathering
- User Training and Support
- Communication Skills
Tools and Technologies
- TOAD for Oracle Databases development
- SQL Developer
- PLSQL Developer
- Oracle Forms Builder
- Oracle Reports Builder
- Jasper Studio
Accomplishments
- Oracle Database Development 11g R2 (SQL, PL/SQL, FORMS & REPORTS) from ORANET, Lahore, Pakistan
- Leadership Skills
- Business Communication Skills
References
Professional References:
- Salman Shahid – Assistant Vice President at United bank Limited Contact: 0321-7644436, Email: vusalman1@hotmail.com.
- Shahid Jamal – Associate manager at Allied Bank, Contact: 0304-0067900, Email: shahid.jamal1137@gmail.com
Languages
Urdu
First Language
English
Upper Intermediate
B2
Timeline
Principal Software Engineer (Oracle Database Developer
STRATEGIC SYSTEMS INTERNATIONAL
10.2022 - Current
Associate Manager (Oracle Database Developer)
ALLIED BANK LIMITED
08.2022 - 10.2022
Senior Software Engineer (Oracle Database Developer
SHAUKAT KHANUM CANCER HOSPITAL AND RESEARCH CENTRE
04.2015 - 08.2022
BACHELOR OF SCIENCE - COMPUTER SCIENCE
COMSATS Institute of Information Technology
F.S.C Pre Engineering -
Punjab Group of Colleges
FSC -
MATRICULATION,Naveed Foundation High School
Similar Profiles
MUHAMMAD ZISHAN BASHIRMUHAMMAD ZISHAN BASHIR
SENIOR SOFTWARE ENGINEER at STRATEGIC SYSTEMS INTERNATIONALSENIOR SOFTWARE ENGINEER at STRATEGIC SYSTEMS INTERNATIONAL
Shahid IqbalShahid Iqbal
Journey Management Coordinator at Strategic Systems InternationalJourney Management Coordinator at Strategic Systems International
Neelab UmarNeelab Umar
SQA Automation Engineer at Strategic Systems InternationalSQA Automation Engineer at Strategic Systems International