EDUCATION
New Mexico State University, Las Cruces, NM, USA
Master of Science in Data Analytics (STEM) Analytics Focus SZABIST University
Master of Business Administration Analytics Focus NFC Institute of Engineering and Technology
Bachelor of Business Administration Analytics Focus Jan 2023 – May 2025
Sep 2017 - Jan-2019
Aug 2013 – Aug 2017
Ayyan Asif
657-***-**** ***********@*****.*** LinkedIn Portfolio PROFESSIONAL SUMMARY
Business Analyst with over 5 years of experience delivering data-driven insights, optimizing business processes, and supporting strategic decision-making. Proficient in SQL, Python, Tableau, and Power BI, with expertise in requirements gathering, KPI development, stakeholder collaboration, and data visualization. Strong background in healthcare, finance, and technology industries with a proven record of enhancing operational efficiency and driving business growth. SKILLS
Programming & Tools: Python, R, SQL, Spark (PySpark/MLLib), Power BI, Tableau, Excel, AI, Generative AI
Business Analytics: Business Process Analysis, Requirements Gathering, KPI Development, Gap Analysis, Financial Modeling, Credit Risk Analysis
Data Techniques: Machine Learning, Exploratory Data Analysis (EDA), Statistical Modeling, Time Series Analysis, A/B Testing, Natural Language Processing (NLP), ETL Pipelines.
Certifications: Data Analytics Specialization, Generative AI, Introduction to AI, The Path to Insights: Data Models and Pipelines, Foundations of Business Intelligence (all by Google); Introduction to Big Data (UC San Diego); SQL for Data Science. EXPERIENCE
New Mexico State University
Business Analyst Consultant Jan 2023 – Present
Health and Financial Access Analysis - Department of Health and Social Sciences
Conducted requirements gathering and business needs analysis for health and financial access projects, leading to improved healthcare service delivery.
Developed predictive models (Linear Regression, XGBoost) to optimize healthcare financial performance, reducing churn by 20% Customer Churn Prediction Analysis – Arrowhead Centre
Applied clustering algorithms in Python to segment customer profiles, enhancing resource allocation efficiency by 15%
Engineered ETL pipelines using SQL and Python to process 1M+ records, improving reporting speed by 90% Supply Chain Demand Forecasting Analysis – American Indian Business Enterprise (AIBE)
Designed NLP-driven categorization systems, boosting customer retention and ROI by 6%.
Built Salesforce-based dashboards to visualize entrepreneur engagement data. Zameen.Com
Business Analyst Jan 2022 – Aug 2022
Partnered with cross-functional teams to align data analytics solutions with strategic business objectives.
Developed Tableau dashboards increasing visibility of KPIs by 40% and accelerating decision-making speed by 30%.
Conducted geospatial and trend analyses using Python, uncovering regional market growth opportunities and optimizing resource allocation by 25%
Security Organizing System Pakistan (Pvt.) Ltd
Business Intelligence Analyst Dec 2019 – Oct 2021
Conducted gap analysis and created business requirement documents (BRD) for financial reconciliation workflows.
Designed Python matching algorithms increasing reconciliation efficiency by 40%.
Built ETL solutions processing 100K+ financial records, improving reporting accuracy and compliance. PEPSI
Data Intern July 2016 – Sep 2016
Created Power BI dashboards tracking high-risk products, reducing service costs by 27%.
Conducted year-end audit analyses ensuring financial compliance and data integrity across business units.
Standardized financial reporting using Excel pivot tables to enhance data quality and accuracy. PROJECTS
Sports Analytics - Match Score Predictor: Built machine learning models (Random Forest, Gradient Boosting, SVM) on 50K+ match records, achieving MAE < 5%. Tools: Python, Scikit-learn, Pandas, Matplotlib.
Workforce Insights - HR Analytics Dashboard: Developed a dashboard from 100K+ employee records, improving hiring efficiency by 20% and supporting workforce diversity initiatives. Tools: Power BI, SQL, Excel.
Healthcare Data Analytics - Resource Optimization: Analyzed 500K+ patient records identifying high-risk groups, optimizing resource allocation by 20%. Tools: SQL, Python, Tableau.