Verified
This profile is verified using an email address.
Muhammad Shahzaib
Round Rock,TX
Summary
Results-driven analyst with experience at Applied Materials, leveraging SQL and Python to enhance data insights and streamline processes. Developed KPI dashboards and improved reporting efficiency by 25%, while collaborating effectively with engineering teams to resolve data discrepancies. Proficient in data analysis and committed to driving operational excellence.
Overview
1
1
Certification
3
3
years of professional experience
Work History
Manufacturing & Data Analyst Intern
Applied Materials
Austin, USA
06.2026 - Current
- Developed SQL queries to extract and clean data from production equipment and quality databases, supporting data-driven decisions in semiconductor manufacturing.
- Created KPI dashboards and reports in Excel, enabling engineering teams to visualize and assess manufacturing performance effectively.
- Track throughput, equipment utilization, cycle time, yield, and defect rates, flagging trends engineers use to catch issues early.
- Collaborated with engineers to identify and resolve recurring errors in production data, enhancing data accuracy and reliability.
Business Analytics Intern
Private Psychiatry Practice
Austin, USA
05.2025 - 09.2025
- Analyzed billing and insurance records with Python and Pandas to identify previously untracked revenue and cost trends.
- Built Excel models with pivot tables that made financial reporting about 25% faster.
- Compiled monthly performance summaries that informed the practice owner's business decisions.
- Used scheduling data to help cut average patient wait times by 10%.
Pharmacy Operations Analyst
CVS Health
Round Rock, USA
01.2024 - 08.2024
- Developed SQL queries on prescription databases to extract dispensing pattern insights for operational analysis.
- Created Tableau dashboards to monitor compliance trends, ensuring reported data accuracy at 95%.
- Collaborated with Operations and Legal to implement new regulations as standard operating procedures.
- Handled 2,000+ prescriptions weekly, keeping everything compliant with state reporting rules.
- Helped roll out new RxConnect features on the floor without disrupting day-to-day workflow.
Education
B.S. - Business Analytics and Artificial Intelligence
The University of Texas at Dallas
Richardson, TX01-2028
Skills
- SQL
- SQL querying
- Data cleaning
- Data analysis
- KPI tracking
- Statistical analysis
- Excel
- Python
- Pandas
- NumPy
- Tableau
- Power BI
- Dashboard creation
- Collaborative teamwork
- Python programming
Certification
- Microsoft Power BI Data Analyst Associate, 03/25
- Entry Certificate in Business Analysis (ECBA), 04/25
- Prompt Engineering & Generative AI Certification, 05/25
- IBM Data Science Professional Certificate (Coursera), In Progress
Projects
- SQL Retail Data Insights, 09/25, 10/25, Analyzed retail sales data in SQL - joins across multiple tables and aggregation functions to find top-performing categories and catch data quality issues skewing profit totals.
- Customer Order & Delivery Trends Dashboard, 09/25, Built an interactive Tableau dashboard covering customer orders, delivery performance, and regional trends, with filters and calculated fields for drilling into specific regions and time periods.
Timeline
Manufacturing & Data Analyst Intern
Applied Materials
06.2026 - Current
Business Analytics Intern
Private Psychiatry Practice
05.2025 - 09.2025
Pharmacy Operations Analyst
CVS Health
01.2024 - 08.2024
B.S. - Business Analytics and Artificial Intelligence
The University of Texas at Dallas