Amina Asghar
Columbia,SC
Summary
Results-driven Data Engineer skilled in automating data processes and enhancing stakeholder access to critical information. Developed reusable algorithms for data privacy that eliminated manual errors, and streamlined reporting for over 50,000 student records, significantly improving data security and compliance with legislative mandates.
Overview
6
6
years of professional experience
Work History
Data Engineer
South Carolina Education Oversight Committee
Columbia, USA
10.2024 - Current
- Built and maintained ETL pipelines in Python, R, and SQL to process 55,000+ student records annually from multiple state agencies, generating legislatively mandated reports and dashboards for all 46 SC counties and 80+ school districts.
- Manage and overhaul dashboard data architecture using SSMS and Tableau, restructuring how 50,000+ student records are aggregated for public-facing visualization, resulting in faster load times and improved stakeholder accessibility.
- Automated student privacy protection by designing a reusable data-suppression algorithm in Python with multi-rule hierarchical logic, replacing a manual process that risked exposing identifiable information across all public-facing reports and dashboards.
- Prepared and analyzed multi-source datasets for legislatively mandated reports including the CERDEP early childhood report (2 cycles) and the military-connected students analysis (2 annual reports with accompanying dashboards), coordinating data from multiple state agencies under tight deadlines.
- Led analysis of student outcomes across instructional delivery methods, presented findings to the full EOC committee, and translated results into policy recommendations — work featured in local media coverage.
Statistician and Research Analyst III
Orangeburg-Calhoun Technical College
Orangeburg, USA
08.2024 - 10.2024
- Extracted and analyzed institutional data using SQL to inform program review, accreditation reporting, and strategic planning across academic and administrative departments.
- Queried and validated student and instructional datasets to create internal dashboards and compliance reports for institutional stakeholders.
- Analyzed data trends to support academic program evaluations.
- Developed statistical models for student performance assessments.
- Collaborated with faculty to design effective survey tools.
Supply Chain Portal Developer / Honors Research Assistant
University of Oklahoma
Norman, USA
02.2020 - 12.2020
- Developed dashboards and analytics tools using R, Python, and Excel to track supply chain performance and identify gaps in critical item availability, enabling data-driven improvement decisions.
- Coordinated with cross-functional teams across IT, procurement, and logistics to integrate portal with existing systems and led stakeholder update meetings to communicate project progress.
- Developed web portals for faculty and student engagement.
- Collaborated with university departments to gather requirements for portal features.
- Enhanced user experience through responsive design and intuitive navigation.
Education
Master of Science - Data Science and Analytics
University of Oklahoma
Norman, OK05-2024
Bachelor of Science - Industrial and Systems Engineering
University of Oklahoma
Norman, OK05-2021
Skills
- ETL development
- ETL pipeline development
- SQL management
- Database Optimization
- Data Modeling
- Data Aggregation
- Data cleaning
- Data privacy
- Data privacy protection
- Data security
- Python
- R
- SQL
- Pandas
- NumPy
- Scikit-learn
- Spark
- Hadoop
- OpenAI API
- Data analysis
- Data Mining
- Data visualization
- Matplotlib
- Power Query
- Power BI
- Azure SQL Database
- JDBC
- Excel
- PowerPoint
- Data security
Projects
- Detecting Hiring Bias in LLMs, University of Oklahoma, 08/01/23, 05/01/24, Analyzed 16,000 resumes using Python and the OpenAI API to detect algorithmic hiring bias by race, gender, age, and disability, applying prompt engineering and statistical analysis. Authored a formal technical report.
- Job-Shop Accounting Database, University of Oklahoma, 08/01/23, 12/01/23, Built a relational database for manufacturing accounting using Azure SQL Database, Java, JDBC, and JSP with a web-based interface.
- Stroke Risk Prediction via Data Mining, University of Oklahoma, 08/01/22, 11/01/22, Implemented Naïve Bayes, Decision Tree, and Random Forest classifiers from scratch in Python, achieving high accuracy via cross-validation.
Timeline
Data Engineer
South Carolina Education Oversight Committee
10.2024 - Current
Statistician and Research Analyst III
Orangeburg-Calhoun Technical College
08.2024 - 10.2024
Supply Chain Portal Developer / Honors Research Assistant
University of Oklahoma
02.2020 - 12.2020
Master of Science - Data Science and Analytics
University of Oklahoma
Bachelor of Science - Industrial and Systems Engineering
University of Oklahoma