Responsible for overseeing EHR database operations, maintaining phenotype documentation, ensuring data quality, and managing clinical data sets using Postgres and MySQL. •Managed extensive nationwide Electronic Health Records databases encompassing primary and secondary care data, and meticulously curated data for epidemiological research within the CALIBER Research Platform. •Developed and maintained robust data pipelines using PostgreSQL and MySQL databases to ingest, transform, and load large volumes of structured and unstructured data from diverse sources. •Designed and implemented ETL processes using Postgres and MySQL to ensure efficient data extraction, transformation, and loading operations. •Optimized database performance by fine-tuning SQL queries, creating indexes, and implementing partitioning strategies to enhance data retrieval speed and overall system efficiency. •Implemented robust data reporting and validation processes, ensuring data accuracy and integrity, leading to reliable insights and informed decision- making. •Managed and organized all incoming Raw files from CPRD (UK), resulting in efficient data reporting and analysis.

Ufone | Dec 2015 - May 2019

Business Intelligence Analyst

•Prepared weekly and monthly financial reports for Senior Management, Finance teams, and Marketing Team, ensuring timely delivery of crucial financial insights to key stakeholders. •Created customized reports tailored for senior management consumption, providing clear insights into business performance and trends. •Introduced reporting standards and standard operating procedures (SOPs), improving efficiency, streamlining processes, and fostering consistency in reporting practices across the organization. •Acted as a liaison between internal and external auditors and the data warehousing team, ensuring a smooth annual data and reporting audit process, resulting in successful audits and compliance.

Ufone | Dec 2014 - Dec 2015

Software Test Engineer

•Designed and prepared test cases based on functional requirements of the solution, ensuring comprehensive test coverage and alignment with project objectives. •Automated test cases to improve testing efficiency and reduce manual effort, utilizing SoapUI and Jmeter •Conducted functional and performance testing in end-to-end environments, validating system functionality and assessing performance under various conditions. •Managed bug tracking and correlation with requirements and test cases, ensuring clear communication and resolution of issues throughout the testing process. •Executed User Acceptance Testing for solutions based on functional requirements and agreed test case documents, verifying adherence to user needs and project specifications.

PowerObjects | May 2014 - Dec 2014

SQA Engineer

•Preparing, planning and executing manual tests in system test phases. •Designed and wrote new tests based on functional requirements for complex technical and business solutions, ensuring comprehensive test coverage. •Analyzed functional and design specifications to identify test requirements and developed new test cases accordingly. •Tested client-server and web-based applications, verifying functionality, usability, and performance. •Conducted peer reviews of test preparation documentation to ensure accuracy and completeness.

Pakistan Revenue Automation (Pvt.) Ltd - FBR | Jan 2013 - Apr 2014

SQA-Tester

•Designed and implemented comprehensive test plans, scenarios, scripts, and procedures to ensure thorough testing coverage. •Conducted regression testing, negative testing, error or bug retests, and usability testing to identify and resolve software defects. •Documented software defects using a bug tracking system and reported defects to the software developers for resolution. •Participated in product design reviews to provide input on functional requirements and ensure alignment with testing objectives.

My Education

Take a look at my formal education

Master, Computer ScienceBlekinge tekniska högskola / Blekinge Institute of Technology | 2011

Bachelor of Science (BS), Computer ScienceUniversity of Arid Agriculture, Rawalpindi | 2008

College, General SciencePAF Inter College Chaklala Rawalpindi | 2002

About Me

Experienced Data Manager and Analyst with over 10 years in data management, quality assurance, and ad-hoc reporting within healthcare and telecom sectors. Proven expertise in data governance, data integrity, and analysis to support strategic decision

Create Your Data Portfolio for Free

Muhammad Qummer ul Arfeen

Data Manager

University College London | London

Case Study: Analyzing Sales Data in Alteryx

Case Study: Analyzing Sales Data in Alteryx

Data maestro, conducting the symphony of insights with analytical expertise.

My Work

Project: Identifying Flight Duration Trends in Air Travel

EV Cars Data Analysis

Chocolate Company Analysis

Customer Analysis

Project: Identifying Flight Duration Trends in Air Travel

DataCamp Course Completion

Courses