Yaqub Jan SQL Server, data analysis, software engineering
No reviews yet

Hello,

I have more than 18 years of professional experience in the field of software engineering. Have knowledge of different low and high level programming languages such as C, C++, C#, PHP, Python, R and Java.

I have extensive experience of working on databases such as SQL Server, MySQL and MS Access. Database server configuration, storage, backups and security. I have developed and managed web servers of the organizations served.

I have Google Data Analytics basic and advanced certification and can help students, professionals and businesses in preparing and organizing data, extract useful information from it, report generation and visual presentation. Data visualization is sharing your finding in form of charts or graphs so that stakeholders can make effective and correct decisions based on facts which can help grow their businesses. Students can learn data cleaning in SQL, Excel, Python, and R and also visualization in Microsoft Excel, Tableau, Python or R.

Learned from my seniors and then guided and taught youngsters who joined my team during my professional life about programming, databases, web and network configuration. Taught MS Office tools like Excel, Word and Power-point to my team.
I am practical and want to teach those skills to students which will benefit them later in their professional life.

Thank you,
Yaqub Jan

Subjects

  • SQL Server Beginner-Expert

  • Data Visualization Beginner-Expert

  • Data analysis R programming Beginner-Expert

  • Crystal reports Beginner-Expert

  • Basic SQL Beginner-Expert

  • Tableau, SQL, and Excel Beginner-Expert

  • Data Analysis in R/Python Beginner-Expert

  • Windows operating System Beginner-Expert

  • Python for Beginners

  • R Markdown Beginner-Expert

  • Data Analysis with Excel, Access and sql Beginner-Expert

  • R Programming/Python Beginner-Expert

  • SQL Queries Beginner-Expert

  • Python for Data Science Beginner-Expert

  • Python for Data Analysis Beginner-Expert

  • Excel (Advanced) Beginner-Expert

  • Tableau Dashboards Beginner-Expert

  • Data analytics and visualization Beginner-Expert

  • Python for Data science, Machine Learning and Artificial Intelligence Beginner-Expert

  • Excel data cleaning and formatting Beginner-Expert

Experience

  • Sr. Manager Data Analysis and Processing (Oct, 2019–Present) at City Research and Testing Service-Pakistan
    In-charge of data processing and analysis section. Data is collected through online applications in SQL Server/ MySQL database and filtered out by me after download in Local SQL Server/ MySQL. Criteria and sql queries are applied for filtering out data of eligible and ineligible candidates. Result is processed by me after each assessment. Computer and paper (OMR) based test results are prepared. Data of test items and results is analyzed by me for quality checks. FInal results are submitted in MS Excel. Summary reports are generated in Excel and Crystal Reports.
  • Deputy Director (Jul, 2014–Feb, 2019) at National Testing Service Pakistan
    1. Head of Operation department, all the sections were reporting to me during my tenure
    2. Meeting clients, plan and execute tests
    3. Train and dispatch invigilation staff for the test
    4. Training software professionals for software development and further improve IT section. In-house software development started in NTS-Pakistan
    5. Reporting the progress to the higher management
  • Manager Software (Jul, 2008–Jun, 2014) at National Testing Service Pakistan
    1. Divided Computer department into further section i.e. (Data Processing, Web Development, Scanning and Results)
    2. Introduced photograph and barcode in answer sheets/ roll-no slips for candidate's verification and prevent impersonation in tests
    3. Isolated and secured Scanning and Result Section from the rest of organization through own LAN
    4. Test planning and execution
    5. Rest of the responsibilities were almost identical to the previous designation (Programmer )
    6. Despite additional responsibilities, I still stayed in-charge of Results Section throughout my career in National Testing Service-Pakistan
  • Programmer (Dec, 2004–Jun, 2008) at National Testing Service Pakistan
    1. Develop data entry, test center allocation, photograph transfer, test material printing, email and online registration software (C# ASP.NET/ Crystal Reports, PHP, SQL Server, MySQL,)
    2. Database design, administration and maintenance (SQL Server)
    3. Windows servers installation, Domain Controller setup, Network configuration (LAN/ Wifi switches and routers) and printers
    4. Website development, uploading data to and downloading from website and website maintenance
    5. Data filtering by applying eligibility criteria and shortlisting before and after tests
    6. Generating summary of eligible /rejected candidates
    7. Planning of tests by arranging human resource, and stationary etc according to the eligible candidates' summary reports
    8. Printing all the test material i.e roll-no slips/ stickers, answer sheets, attendance sheets etc
    7. Setup OMR scanners and scanning of test material after tests (answer sheets)
    8. Result generation in OMR and exporting to SQL Server database (Remarks office OMR)
    9. Preparation of merit lists according to client's requirements (Excel, Crystal Reports)
    10. Analysis of test items and candidate's responses to analyze quality of test content

Education

  • Master in Computer Science (Mar, 2002–May, 2004) from Shaheed Zulfikar Ali Bhutto Institute of Science and Technology–scored 2.82
  • B.Sc. Computer Science (Mar, 2000–Mar, 2002) from Alkhair university–scored 2.8

Fee details

    Rs3,000–10,000/hour (US$10.77–35.89/hour)

    Fee can vary in case of additional service requirement, like help in assignments, quizzes or assessments.

Reviews

No reviews yet. Be the first one to review this tutor.