More than 12 years of extensive experience in business analysis, design, development, implementation, training and client support.
Proven record of leadership and management skills on various large scale government projects of Pakistan and Oman.
Develop database solutions by designing proposed system; define database physical structure and functional capabilities, security, back-up, and recovery specifications.
Focus on reliability and performance by designing an efficient, scalable database including interfaces, Query Optimization and indexes enables efficient user access to data.
Extensive experience in writing advance PL/SQL back-end packages, procedure and functions, queries optimization and performance tuning, triggers, scripts for data extraction, cleansing, transformation, loading and analysis of data.
Working experience in Oracle 8i/9i/10g/11g/12c,SQL Servers - Homogenous as well as Heterogeneous environment.
Corporate Training from INFOTECH of RAC 11G R2, Oracle Data Integrator(ODI), Weblogic Server, Dataware House Administration.
Coporate Training of Agile SCRUM from Akai Ideas.
Update job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
Successful in meeting new challenges and satisfying clients by providing best solutions.
Hard working, resourceful, creative and result oriented person with exceptional analytical, design, development and client support skills
Develop database solutions by designing proposed system; define database physical structure and functional capabilities, security, back-up, and recovery specifications.
Determine database structural requirements by analyzing operations, applications, and programming;
Maintain database performance by identifying and resolving production and application development problems; answering user questions.
Focus on reliability and performance by designing an efficient, scalable database including interfaces, Query Optimization and indexes enables efficient user access to data.
Prepare users by conducting training (Performance Tune and Optimization).
Update job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
Accomplish information systems and organization mission by completing related results as needed.
Writing PL/SQL packages, procedure and functions, queries optimization/performance tuning, triggers and scripts.
Performing analysis on taxpayer's declaration data and find tax evasion.
Requirement Gathering, Database Modelling & Designing
Project and Team management.
Projects include Computerized Risk Based Evaluation of SalesTax (CREST), Inland Revenue Information System (IRIS), ReCAP (Reconciliation of Collection of Automated Payments), ERS (Expeditious Refund System ), STAR, ITMS Modules ( Jurisdicton, Registration, Reporting, Organogram, Posting, etc.) etc.
Design and Developing the Projects CREST (Computerized Risk Based Evaluation of SalesTax), ReCAP, Ledger, STMS (SalesTax Management System) etc.
Maintaining the Projects ( Trekker, Invoice Cross-Matching etc.)
Data Migration and Transformation scripts from heterogenous enviornment.
Writing PL/SQL packages, procedure and functions, queries optimization/performance tuning, triggers and scripts.
Data Analysis Reporting from taxpayer's declaration data and find tax evasion.
Requirement Gathering, Database Modelling & Designing
Study of existing system and Gap analysis focusing current requirements and then reengineering into new proposed system on ORACLE RDBMS database 10G for online application in Developer Suite 10G.
Performance Tuning and Query Optimization of the existing system.
Projects were as followed:
Omani Registration System , Labour Card System, College System (Educational System)
I was responsible to lead overall IT Projects (Designing, Development and Maintenance) of Masood Textile Mills Limited ( Among the best Textile Company of the Pakistan
Develop, maintain and update following Systems, which control the overall functionality of Enterprise.
Financial Accounting System (FAS), Inventory Management System, HRM (Payroll, Barcode),
Export Document Management System, Sales Tax Management System, Shares Management System
, Garment Management System, Fuel Stations Management System
I was responsible for overall development and management, working as IT In charge.
Analysis, Design and Development of the Financial Accounting System, Inventory Management System, Machine Maintenance System by replacing the existing manual ledger system.
Perform the analysis and lead the project of HRMS & Gate Management System.