M

Muhammad Saqib

About

Detail

Lahore, Punjab, Pakistan

Contact Muhammad regarding: 
work
Full-time jobs

Timeline


work
Job

Résumé


Jobs verified_user 0% verified
  • Creative Chaos
    SQL Server Database Administrator
    Creative Chaos
    Aug 2021 - Current (4 years 10 months)
    Responsibilities: • Managing SQL Server databases and environments, from development, QA, UAT & Production. • Configured High Availability environment for new created SQL instances and responsible to check the others that are already configured. • Creation of new jobs to migrate data between different DBs as requested. • Assisting development team with query tuning & stored procedure writing and other issues. • Manages MongoDB & Postgres SQL Server for Daily Backup and restore in UAT & Production. • Configured Replication and CDC from on prem to Azure SQL for Synapse for QA, UAT & Production. • Optimizing & Monitoring databases for performance issue. • Responsible for database design/development/administration (data modeling, stored
  • Systems Limited
    Advisory Software Engineer
    Systems Limited
    Sep 2015 - Aug 2021 (6 years)
  • A
    Database Administrator
    Accountancy Outsource Limited (AOS)
    Dec 2012 - Aug 2015 (2 years 9 months)
    Responsibilities: • Design, development and maintenance of database of clients/data entry vendors and for new applications modules. • Handled the tasks of database backups, optimization, data security and others as directed by management. • Developed various management information reports by using crystal reports 2008/2011 .
  • S
    Sr. Software Engineer & Database
    Shalimar Institute of Health & Sciences
    Aug 2010 - Nov 2012 (2 years 4 months)
    Technologies VB 6.0, VB.NET, MS-SQL Server 2000, Oracle 10G Responsibilities: • My responsibilities are to transfer the existing database in Oracle 10g. • Convert the Front end to work with Oracle.
  • S
    Sr. Software Engineer & Database
    Sigmate Solutions
    Sep 2007 - Jul 2010 (2 years 11 months)
  • C
    Computer Programmer
    Carolina Fabric Limited.
    Sep 2005 - Jan 2007 (1 year 5 months)
    Technologies Used: VB.NET, MS-SQL Server 2000, Seagate Crystal Reports 8.5 Responsibilities: • System Study, System Design, developing and Implementation of New Packages. • Software training to the new employees. • Daily/Weekly/Monthly Backup schedule for Data & Programs. • Maintaining the existing software modules (Payroll, Accounting, Export, Import, Inventory Control (Spare, Yarn, Cotton, Chemical & Waste Stores), Production, Local Sales/Purchase, Vehicle Maintenance and MIS etc.) for Weaving, Spinning Units.
  • S
    Software Developer
    Sigmatec Solutions
    Jan 2003 - Aug 2005 (2 years 8 months)
    Planning and Budgeting, Sales Management, Inventory Management, Imports, Exports, General Ledger Accounting, Cash Flow Management, HR Management, Marketing Technologies Used: VB.net, MS-SQL Server 2000, Seagate Crystal Reports. Responsibilities • Worked as a software developer in the development of the complete ERP solution including front End (Presentation Layer) and Back end (Data Layer and Business Logic) • Worked as a report developer. • Worked on database designing database writing views and stored procedure. • Implement the project at clients and have responsibility to solve all the issues during the implementation of the module.
Education verified_user 0% verified
  • M
    Microsoft Certified Azure Database Administrator Associate DP-300 Microsoft Certified Azure Data Fundamentals DP-900 Mic
  • A
    Bachelor in Computer Sciences (BCS)
    Askari Computer College
  • Punjab University
    Bachelor in Arts (B.A.)
    Punjab University
  • A
    Masters in Computer Sciences (MCS)
    Al-Khair University (AJK)
Projects (professional or personal) verified_user 0% verified
  • C
    Case Compass – CH MACK
    An information system designed to cater health services related case management needs of government sector. Developed for Missouri State's Adult Protective Service department USA, it tracks and records a reported case's intake, routing to appropriate authority, investigation and intervention. It also facilitates the management of State's contracted providers and their employees and communicates with external systems as well. Technologies Used: Asp.net 3.5(C#), Asp.net web services, MS-SQL Server 2008, SSRS 2008 Responsibilities:
  • C
    College Management System (CMS)
    This is a full college management system using which we can handle all necessary information needed, like student information, staff information etc. Each module has been categorized by user type. There are six types of users like System Administrator, Student, Staff, Inventory, Accountant and Librarian. System Administrator can access all modules and he has authority to editing of all modules. Rest users can access only their own module and are not authorized to edit data Technologies Used: VB.net,
  • S
    Stitching Solution
    This project contains all the information about the stitching Unit of this company. In this there is sales contract where buyer requests can be extracted. Based on this information the process workflow starts, which involves Cut Order Plan, Planning, Shipments, raw material maintenance finished good maintenance packing list, Shipment schedule is made.
  • F
    FMCG/ERP Solution
    This Client Server and generic solution can handle the business issues associated with manufacturing oriented companies from small scale to extra-large scale The n-Tear structural design of the Solution meets the high standards of development world. The layered approach adopted in the development of this Solution helps in making changes at any time and at any layer. .This is the integrated solution of different modules which is customized as client requirements. ERP Major Modules
  • H
    Hospital Management System (HMS)
    This Hospital Management System is custom built to meet the specific requirement hospitals. All the required modules and features have been particularly built to just fit in to its requirement. Entire application is network based and built on 3 tier architecture using the latest technologies. The sound database of the application makes it more users friendly and expandable. Prolonged study of the functionalities of the hospital and its specific requirement has given it a wonderful shape both technically and usability wise. It covers all the required modules right from Patient Registration, Medicine Pharmacy, Doctor, Wards, HR & Payroll, Donation Management System, and Financial Support & Assessment. Technologies Used: VB.net, MS-SQL Server
  • B
    Baluchistan Land Record Management Information System (BLRMIS)
    BLRMIS replaces all manual land record system of Baluchistan in fully integrated system. This project includes scanning & indexing of old images, double data entry against these images and then migrate all the entered data into centralized database for operation. Responsibilities: • Responsible for (data stored procedures, functions and query optimization, Log Shipping • Migrate data from data entry to centralized database using SSIS. • Responsible for support queries
  • L
    LRMIS Software - Migration to Central LRMIS (Punjab)
    Land Records Management Information System Punjab is set to be one of the largest Land Records' databases in South East Asia. This is a mega project to develop a new centralized Land Records Management Information System (LRMIS). The new system will replace the current distributed system and will ensure scalability and uniform service and functionality across the 300 services centers in Punjab. The new system will be serving over 12,000 users in the Board of Revenue Punjab, and related stakeholders in all districts of Punjab and with its state-of-the-art architecture, as desired by the PMU-BOR, Systems Limited will deliver a solution which will be securely hosted and which delivers uniformly efficient service to all users in the 150 Tehsils
  • A
    Adecco DB Migration (On-Premise to Azure)
    In the existing system, there are different on-premise SQL Server Databases. Adecco wants to migrate from on-premise SQL Server to Azure SQL Server Databases. Using Data Migration Assistant to assess the source SQL Server Database to target Azure SQL Server Databases. Based on the recommendation from Data Migration Assistant, made changes related to Table schema, Stored Procedure, Views, and Function Objects. Power BI is used for building reports from Azure
  • L
    Land & Record Management Information System (Sindh)
    LARMIS is a complete automation of manually maintained parcel based revenue record system which deals with the establishment of rights of ownership on land such as verification and distribution of titles, mutation, crop assessment, tenancy etc. LARMIS envisions it to be the legal and administrative system registering and publicly announcing physical status, legal right relationship, limitation matters, and obligation matters regarding the land. LARMIS is a multi-million $ project, being implemented in Sindh province. With the implementation of this project in the 27 Districts of Sindh will eliminate the monopoly of patwari/tapadar in the revenue matters with attain accuracy, transparency and efficiency of the Revenue department. Technologie
  • E
    ERP Solution
    Sigmate Solutions Pvt. Limited is a product-based company. They have their own designed ERP with SQL Server 2000 used as database. A complete paperless solution for all types of business activities This is integrated software Product with 14 modules named, Purchases, Sales, Import & Export Inventory, Production, Q.C, Claims, Funds, Costing, Asset Management, Planning Budgeting & Costing HR Management and Marketing, with complete Accounting system. Used: