Summary

Adaptable, receptive and creative-minded personality who is willing to learn new horizons of advancements in technology.
I would like to be associated with a well-reputed organization that would further enhance my technical knowledge and expand my learning base in the fields of Information Technology and Computer Sciences along with fully utilizing my expertise and personal skills.Furthermore, enabling me the opportunities to attain professional growth to achieve corporate goals.
Special interest and personal experience in working with several tools, languages and technologies such as:



• SQL
• Data Analysis
• Power BI
• Tableau
• ETL



Personal Attributes:
• Outstanding Documentation expertise
• Good Team Player
• Self-Learning

Achievements and Activities
Participated in Nascon 13 as Vice Head - Social Media Officer
•Participated in Nascon 14 as Coordinator - Math magician event
•Runner up of Math magician event Nascon 12
•I did TA (Teacher Assistant) of these subjects (Linear Algebra, Calculus-1,Calculus-2).

Interest
• To solve Mathematical, Analytical and IQ Problems.


Projects

AdventureWorks Data Analysis
Logit interactive learning tool
Timetable Yielder [C#, SQL, Visual Studio]

Experience

Company Logo
Data Engineer
Afiniti Software Solutions Pvt Ltd
Feb 2020 - Present | Lahore, Pakistan

Roles & Responsibilities

Responsible for the development of end-to-end data pipeline.
Maintaining/developing data pipelines in order to deliver data daily to Analytics and AI teams
Develop and automate daily data loading ETL jobs using Talend open-source software.
Responsible for optimizing ETL jobs and queries
Monitor all production ETL processes, perform root cause analysis on all incidents, and resolve all production issues.
Responsible for migrating & converting all MySQL processes (Store procedures, views) and data into Greenplum

Company Logo
SQA Engineer
Strategic Systems International
Dec 2019 - Jan 2021 | Lahore, Pakistan


Roles & Responsibilities

Responsible for performing testing of Web Based Applications and reporting bugs on Team Foundation Server
Develop variety of Dashboards in Grafana to perform bug analysis using Influx DB and SQL
Communicate & Coordinate with the development team to help them resolve different issues
Support development team to verify or reproduce reported issues
Automated Testing using Selenium Web Driver
Develop and maintain test plan, test scenarios and test cases for the application and execute different testing techniques.

Tools Used: Grafana ,Telegraf , Selenium, Postman , TFS

DB Used: InfluxDB, PostgreSQL , SQL

Product: APM ( ASM Performance monitor) , R-Connect

Company Logo
SQA Engineer
Cheetay Logistics
Apr 2019 - Dec 2019 | Lahore, Pakistan


Roles & Responsibilities
Bug logging, prioritizing and bug tracking
Assist in designing and implementation of policies for testing and evaluating standalone and web-based software applications
Creating/reviewing User Stories, Task, Test Plan, Test Suite, Test Cases, Bugs in JIRA on daily basis
Responsible for Web, Android and iOS application testing
Develop variety of Dashboards in Power BI
Write different queries for collecting data and from that data generate reports for information of higher authority for making decisions
Tools used: PowerBi, JIRA , Postman
DB used: Mysql
Product: Cheetay.pk , Aysap Rider App, Vendor App, Cheetay App , Cheetaylogistics.pk

Company Logo
Software Quality Assurance Engineer
MTBC
Dec 2017 - Mar 2019 | Islamabad, Pakistan


Roles & Responsibilities
Review requirement specification documents, software design specification documents and develop understanding of testing requirements
Data Verification through SQL queries
Creating test cases for functional, integration, scenario based and performance testing
Responsible for performing smoke, sanity, UI and regression testing as well as checklist based testing of multiple products.
Execution of the test cases and reporting bugs on Team Foundation Server (TFS)
Designed test cases in Microsoft Test Management tool (MTM)
Participation in QA meetings and discussion sessions
Support development teams to verify and/or reproduce reported issues.
Investigation of Production issues and providing workarounds
API Testing of back-end services using Postman tool respective to each environment.
Tools Used: TFS, MTM, Excel, Selenium
DB Used: SQL
Product: TalkEHR( Web & Mobile), WebEHR, TalkPHR, IcheckIn

Education

FAST (Lahore)
Bachelors, Bachelors in Technology, Computer Science‎
Database Management System, Image Processing
Grade C+
2017

Skills

Intermediate Analytical Applications Command
Intermediate Coordination Skill's
Intermediate Data Analysis
Intermediate Data Modelling
Expert ETL
Intermediate Greenplum
Intermediate MySQL
Intermediate PostgreSQL
Intermediate Power BI
Intermediate Programming Languages
Beginner Python Framework Command
Intermediate Python Knowledge
Expert SQL
Intermediate Tableau
Expert Talend

Languages

Expert Urdu
Intermediate English

Muhammad Contacts

Hammad Ahmad
Wavetec ( Telenor Headquarters Islamabad)