SQL Data Cleaning and Analysis
I transformed a messy global layoffs dataset into an analysis-ready resource using SQL, data standardisation, duplicate handling, null treatment, and exploratory trend analysis.
Abdul Adnan Portfolio
With a First-Class MSc in Mechatronics and professional experience in Defense Quality Assurance, I bring together engineering discipline, quality processes, data analysis, and automation to solve complex operational problems with clarity and precision.
Portfolio
Technical Portfolio
A selection of data, automation, dashboard, and engineering work. Click any project to see the problem statement, solution steps, code, and visuals.
Automated Web Scraper: US Corporate Revenue
Built a Python ETL workflow using BeautifulSoup and Pandas to convert unstructured HTML tables into clean CSV outputs.
European Consumer Insights Dashboard
Created an interactive Excel dashboard using Pivot Tables, Slicers, and Power Query to uncover regional sales patterns.
Airbnb Market Intelligence Mapping
Developed Tableau visualisations showing pricing hotspots, density patterns, and geographic market opportunities.
Technical Assurance Reporting
Produced reporting workflows that turned inspection outputs into clear, traceable summaries for review and compliance.
Operations Data Storytelling
Combined structured analysis with concise visuals to make stakeholder reporting faster, clearer, and more actionable.
Inspection and Quality Documentation
Supported quality-driven engineering environments with organised evidence, documentation controls, and validation structure.
Engineering
Engineering & QA
This section highlights mechanical systems work, technical clearance, inspection discipline, and quality assurance experience.
Core QA and Engineering Strengths
- Defense-quality inspection and clearance workflows
- Technical documentation and process reporting
- Root cause investigation and issue tracking
- Mechanical systems understanding and standards awareness
- Cross-functional coordination between operations and engineering
Professional Snapshot
Highlights from my tenure at Bharat Dynamics Limited, where I worked on high-precision quality assurance and technical clearance activities for defense-grade mechanical systems under strict compliance and safety expectations.
| Area | What I Contributed | Impact |
|---|---|---|
| Inspection | Performed systematic checks and validation against technical requirements. | Improved consistency and reduced acceptance risk. |
| Documentation | Prepared technical reports and supported evidence-based quality decisions. | Created stronger traceability and audit readiness. |
| Collaboration | Worked with engineering and production teams to maintain process quality. | Helped keep workflows accurate and aligned. |
Skills
Certifications, Skills & Education
A clear view of my qualifications, technical tools, and academic background.
Certifications
- Google Data Analytics Certificate
- SQL for Data Analysis
- Quality Assurance or Compliance Certification
- Six Sigma or Lean Process Certification
Technical Skills
- SQL, Python, Excel, Power Query
- Tableau, Power BI, Dashboards and Reporting
- Data Cleaning, ETL, Automation
- Quality Assurance, Documentation, Process Improvement
- Mechanical Engineering and Systems Understanding
Education
| Degree | Institution | Details |
|---|---|---|
| MSc Mechatronics and Computer Systems Engineering (First-Class Honours) |
University of East London, UK 2023 - 2024 |
Robotics, Systems Integration, Control Engineering, and Advanced CAE. |
| BEng Mechanical Engineering (First-Class) |
Osmania University, India 2018 - 2022 |
Thermodynamics, Fluid Mechanics, Engineering Mathematics, and Manufacturing. |
Experience
Work Experience
My professional experience across site operations, quality assurance, administration, and student representation.
Concierge / Site Operations
Everon Facilites Services (EFS)
June 2025 - Present
- Serve as the primary on-site liaison for Newlon Repairs, diagnosing maintenance issues accurately and raising jobs through established protocols to reduce no-access appointments.
- Manage out-of-hours emergency response procedures, dispatching specialist contractors for urgent mechanical, plumbing, and electrical failures.
- Oversee secure large-scale logistics, including auditing more than 2,000 keys and coordinating site access and inductions for 15 to 20 external contractors each day.
- Maintain complex team inboxes and digital maintenance logs with full accuracy, ensuring compliance, reliable record-keeping, and timely follow-up.
Mechanical Graduate Apprentice
Bharat Dynamics Limited (BDL)
December 2022 - August 2023
- Managed more than 50 ISO 9001-compliant documents and used Excel and SQL automation to reduce reporting preparation time by 40%.
- Handled relationships with more than 22 vendors to resolve operational conflicts and support smooth project coordination.
- Conducted on-site technical inspections to ensure products and processes met 100% quality standards.
Course Representative
University of East London
October 2023 - September 2024
- Addressed and resolved the needs and queries of a cohort of 50 students in the role of course representative.
- Implemented effective feedback collection methods including monthly surveys, suggestion boxes, focus groups, and 30 one-to-one meetings to understand root causes of student concerns.
- Delivered presentations to university management summarising student feedback, contributing to a 50% improvement in university policies and student satisfaction.
Contact
Contact Details
Open to engineering, QA, and data-focused opportunities across the UK.