aafaz ilahi
Clinical Data Associate at Eli Lilly and Company
data science | odsc brand ambassador | certified tableau specialist | aws certified cloud practitioner
self-driven passionate data science graduate student indiana university , graduated may 2021 . love applying analytical skill solve real-world problem provide value business . two year experience data science field working data curious eye converting data powerful insight make data-driven solution business , actively looking full-time opportunity data analytics data science field . data science portfolio project : ( github.com/aafaz ) 1 . u covid-19 dashboard : tableau dashboard provides state-level county-level number case , death , fatality rate . 2 . loan prediction system bank : machine-learning model predicting loan-eligibility applicant based factor asked filling loan application . 3 . indyarchive document classification : document classification project building predictive model classify document category . 4 . ozone level forecasting : forecasted ozone level marion county study effect due stay-at-home order covid . technical skill include : • programming language : python , r , c++ , java • machine learning : supervised unsupervised • data visualization : tableau , matplotlib , seaborn • database : mysql , nosql , mongodb • big data analytics tool : spark , hadoop • library : panda , numpy , scipy , scikit learn • statistic & probability : hypothesis testing , bayesian statistic • cloud computing platform : amazon web service ( aws ) • deep learning framework : pytorch , tensorflow always looking connect data science professional , hiring manger recruiter linkedin .
Eli Lilly and Company
https://www.linkedin.com/company/eli-lilly-and-company
Indianapolis, Indiana, United States
https://media-exp1.licdn.com/dms/image/C560BAQE4b2WwDuShZg/company-logo_100_100/0/1625050553418?e=1655942400&v=beta&t=315ju4dV_ZoubDGpgMwOiR4Dvi2fcjxKJi_rVsT2mYg
Clinical Data Associate
Open Data Science Conference (ODSC)
https://www.linkedin.com/company/open-data-science
ODSC brings together the open-source and data science communities with the goal to cultivate and grow the global data science community.
Roles and Responsibilities included: 
• Working with the event planning team to plan future ODSC conferences and ensure attendees, speakers, and sponsors have the best possible experience.
• Assisting in transitioning a 500+ attendee conference into a well structured virtual conference series that is spread across 5 countries with over 15,000+ attendees.
• Working closely with the marketing team to share content and educate people in the data science industry.
https://media-exp1.licdn.com/dms/image/C4E0BAQF9xxYuQyx3Yw/company-logo_100_100/0/1625082270114?e=1655942400&v=beta&t=TZEvbuPplBIYrHTQrpW95A_qQyQk9-3-rpZ343DrKSQ
Data Science Brand Ambassador
Navient
https://www.linkedin.com/company/navient
Navient (Nasdaq: NAVI) is a leader in education loan management and business processing solutions for education, healthcare, and government clients at the federal, state, and local levels.
Roles and Responsibilities include:
• Delivered complete reporting solutions by gathering requirements and designing executive dashboards together with instructive reports for the business intelligence team via Tableau.
• Built machine learning models using PySpark to analyze communication patterns and predict delinquent borrowers, saving up-to $200K quarterly on customer calls.
Fishers, Indiana, United States
https://media-exp1.licdn.com/dms/image/C4D0BAQF0EpIdCRKQyw/company-logo_100_100/0/1565368191090?e=1655942400&v=beta&t=xWgmgThd4rz359Edlgm6gcVaLx6Cr8ex1eAbaaGJzd4
Data Science Intern
Resero Analytics
https://www.linkedin.com/company/resero-analytics
Resero Analytics creates software and data products for pharmaceutical companies to better manage their data, apply analytics to generate insights, and reporting it more promptly.
Roles and Responsibilities included:
• Devised a workflow in Python to convert legacy toxicology datasets into the CDISC-approved standardized format that saved 100 labor hours monthly. 
• Designed executive dashboards and reports of clinical trial data of pharmaceutical drugs using Tableau, increasing the interpretation speed by 70%.
• Built a machine learning model with F1 score of 93% to predict the biological significance of drugs in the market and deployed the model in production with AWS SageMaker.
Indianapolis, Indiana, United States
Data Science Intern
IU School of Informatics and Computing at IUPUI
https://www.linkedin.com/company/soic-iupui
The School of Informatics and Computing at IUPUI, works together with researchers, faculty and students to deliver web, mobile and interactive media solutions for a range of projects.
Roles and Responsibilities included:
• Designed & developed the database by gathering requirements from the Informatics department of IUPUI to store, retrieve, and update data of research projects.
• Identified relevant data sources and monitoring the progress of research projects through databases tracking using MySQL.
• Analyze data for trends and patterns, and building reports and dashboards in Tableau to make key funding decisions.
• Communicate analytic results to the Dean and implement improvements as needed.
Greater Indianapolis
https://media-exp1.licdn.com/dms/image/C560BAQHarG03QC0h0A/company-logo_100_100/0/1602103500503?e=1655942400&v=beta&t=AFRhxdfdsPQ52bxFJw_mY1dDEBuh9IBVatBYut9iMKs
Graduate Research Assistant
Master of Science - MS
Relevant Coursework and Learnings: 
                                                                                               
• Statistical Inferences: Statistical tests for analysis, z-test, t-test, ANOVA, MANOVA, Chi-square test, Bayesian Statistics
•. Database Design: Database management using MySQL,Design principles and Data Warehousing
• Informatics : Python programming language for Data Science, Object Oriented Programming
•. Data Analytics: Statistical Methods and Machine Learning Algorithms: Supervised & Unsupervised
• Cloud Computing: Handling big-data with PySpark and Hadoop, Cloud Infrastructure 
• Deep Learning: Convolution Neural Networks(CNNs), Recurrent Neural Networks(RNNs), Computer Vision.
Applied Data Science
https://media-exp1.licdn.com/dms/image/C4D0BAQHq7U6wXuv5Vw/company-logo_100_100/0/1519921995695?e=1655942400&v=beta&t=KwIXLj4CVhI6b1TVllviWs2WyRZMuinSP_9vAYQmpkg
Indiana University–Purdue University Indianapolis
https://www.linkedin.com/school/indiana-university%E2%80%93purdue-university-indianapolis/
Bachelor of Engineering - BE
Graduated with a Bachelor's degree with a detailed knowledge of 
• Programming: Data Structure & Algorithms, Object Oriented Programming, Fundamentals of Programming Language 
• Image Processing: Digital Image Processing, Signals and Systems 
• System Programming , Operating System, Cyber Security, Computer Networks 
• Electronics: Power Electronics, Analog & Digital Communications, VLSI Design, Microcontrollers

Final year Project: Designed and developed a micro-strip patch antenna in collaboration with Defense Research and Development Organization(DRDO), India. Based on the requirement of military bases to convey special information, the antenna was designed with meta-materials at a particular frequency of 2.4 GHz for communication. Got selected by Defense Research Laboratory (DRL) as a prototype to develop high-end military applications.
Electronics and Telecommunications
https://media-exp1.licdn.com/dms/image/C4E0BAQGvnYd1TSSKxA/company-logo_100_100/0/1585975398434?e=1655942400&v=beta&t=2kBo6fQ-6pNQ01TSqfrvBi1nWTnvYKLEztFkUhnbF-4
Sinhgad College of Engineering
https://www.linkedin.com/school/sinhgad-college-of-engineering/
Junior Chamber International
Coordinator
IEEE Student Chapter
Event Head
Awarded as a junior scientist in 19th National Children's Science Congress for the project on focal theme- Land Resources: Use of prosperity, Save for posterity, held in Jaipur, India
National Children's Science Congress
Junior Scientist
Applied Cloud Computing for Data Intensive Sciences
INFO H516
Data Analytics
INFO H515
Database Design
LIS-S511
Deep Learning Neural Networks
INFO H518
Information Visualization
ENGR- 583
Introduction to Informatics
INFO-511
Project Management
INFO-505
Statistical Inference
PSY-60000
• Built a dashboard in Tableau showing COVID-19 cases in real-time.
• Generated insights for number of cases, deaths, and mortality rate.
• Customized the dashboard for each state and county showing daily trend of cases.
US COVID-19 Tracker
https://tabsoft.co/3eroWKQ
Task: To build a model that can automatically categorize documents of Encyclopedia of Indianapolis.
• Collected, cleaned, and annotated 1600+ unstructured text documents for training using SpaCy and Python.
• Implemented a deep learning model using RNN, LSTM for Jane Polis Center, IUPUI by reducing the manual task of editors by 100%.
• Performed hyper-parameter tuning and achieved an accuracy of 84% from the baseline model of 73%.
IndyArchieve Document Classification
https://github.com/aafaz/Indy-Archive-Document-Classification
• Task: To predict the Ozone Levels in Marion County,IN for the next two years.
• Extracted data from website through web scraping in Python and conducted data wrangling and data cleaning.
• Performed Statistical Analysis and Feature Engineering in PySpark 
• Developed a time-series SARIMA model to predict the ozone levels over next two years and deployed it in AWS EMR Cluster
Ozone Level Forecasting in Marion County
https://github.com/aafaz/Ozone-Level-Forecasting
Task: To predict whether the loan will be approved or not based on applicant information.
• Discovered hidden patterns from the data using exploratory data analysis, performed outlier treatment
and feature engineering of variables.
• Obtained a cross-validated F1 score of 87% using XGBoost with 4% improved over baseline logistic regression model.
• Deployed the model in AWS EC2 instance to get the loan approval response in real time.
Loan Prediction System for Banks
https://bit.ly/2Y3dZIT
Science and Technology
Open Data Science Conference (ODSC)
https://www.linkedin.com/company/open-data-science
Volunteered in ODSC West 2019 in San Francisco and Virtual ODSC 2020 East Conferences.
Activities included in these 4-day conferences:
• As an emcee(MC), welcoming and introducing speakers on stage, making announcements and engaging with audience to keep the conference agenda flowing as smoothly as possible.
• Helping attendees with the check-in process and registration along with general duties.

Learnt Public Speaking, Team & Event Management
https://media-exp1.licdn.com/dms/image/C4E0BAQF9xxYuQyx3Yw/company-logo_100_100/0/1625082270114?e=1655942400&v=beta&t=TZEvbuPplBIYrHTQrpW95A_qQyQk9-3-rpZ343DrKSQ
Volunteer
LinkedIn
www.linkedin.com
Apache Spark Essential Training
http://www.linkedin.com/learning/apache-spark-essential-training
Tableau Software
www.youracclaim.com
Tableau Desktop Specilaist
https://www.youracclaim.com/badges/7acb7ad6-5401-4955-9b18-1b8fec5dac15/public_url
Analytics Vidhya
www.credential.net
18533519
Tableau 2.0
https://www.credential.net/18477633-8801-4935-8d5c-d3873ce62d1d?_ga=2.26789438.2061691602.1590460399-1128029693.1590460399
Internshala
trainings.internshala.com
F396373C-DD45-47FD-B13A-710FA3BDBF5F
Web Development
https://trainings.internshala.com/verify_certificate
Amazon Web Services (AWS)
www.youracclaim.com
83F3TPLCP14Q10WF
Amazon Web Services Cloud Practitioner
https://www.youracclaim.com/badges/1d28ca18-6792-40da-a153-d362fe2017cf/public_url
MindScripts Technologies
Java Basics and Advance Course
Liked by Aafaz Ilahi
https://www.linkedin.com/signup/cold-join
A Day in the Life of Americans. One of the coolest Data Viz! What do you think?Look at microdata from the American Time Use Survey from 2014, which…
Liked by Aafaz Ilahi
https://www.linkedin.com/signup/cold-join
Join me and General Assembly for our Career Conversations: Tech in the Sports Industry event on Thursday, March 31st from 6 to 7 p.m. ET. We'll be…
Liked by Aafaz Ilahi
https://www.linkedin.com/signup/cold-join
If a Data Scientist has a Github with 3 Python projects, you don't need to give them a technical interview. If they've been working as a Data…
#100DaysOfCloud
https://media-exp1.licdn.com/dms/image/C5607AQEdZ6g4Yp7WHA/group-logo_image-shrink_92x92/0/1630996417125?e=1647691200&v=beta&t=DJ_cBCk0X9YA3VjmCRYp0ylfgHUQyFKUNvMNxlkiICE
https://www.linkedin.com/groups/13884435
Data Scientist Jobs
https://media-exp1.licdn.com/dms/image/C4D07AQFzlPg8_hq9Rg/group-logo_image-shrink_200x200/0/1631357859533?e=1647691200&v=beta&t=ZTTHcHFeOK9f0EBP2qRZNXCqmuMfq9_BhHE-2YnR_Bg
https://www.linkedin.com/groups/8297310
Big Data, Data Science, AI, IoT, Cloud Security & Blockchain
https://media-exp1.licdn.com/dms/image/C5107AQEn7Kn4FAIw3A/group-logo_image-shrink_92x92/0/1631009536156?e=1647691200&v=beta&t=QVrHw8Lmfkp2jzQn-6YtfkGIvvOtjMY_Sp6DMMw1LOs
https://www.linkedin.com/groups/3990648
"We're Hiring!" By PhillyTalent
https://media-exp1.licdn.com/dms/image/C5607AQEXZNJ6CsMVvA/group-logo_image-shrink_92x92/0/1631002206122?e=1647691200&v=beta&t=IIMTpLzE6FY9CV-F4dMFyBuArOawgpKr1AGi68XJCsQ
https://www.linkedin.com/groups/13652981
AWS Solution Architect
https://static-exp1.licdn.com/sc/h/4h1ldzvvebtszyx75ve7dst1v
https://www.linkedin.com/groups/10318988
KDnuggets AI, Big Data, Data Science, Machine Learning group
https://media-exp1.licdn.com/dms/image/C4D07AQGttAixleFxdQ/group-logo_image-shrink_92x92/0/1642177025016?e=1647691200&v=beta&t=bCvDhFvFbGpbS7MbIJcLTNXOU6ocL0oCgqD3v9OwndM
https://www.linkedin.com/groups/54257
AWS Cloud Computing (For Interested Parties & Users)
https://media-exp1.licdn.com/dms/image/C4D07AQG8Vd6LWUE0Gw/group-logo_image-shrink_92x92/0/1631004597306?e=1647691200&v=beta&t=q6Y__KuUSRVY7_fKagKP2kbeBh2VfRnnQeKsUMzNVB0
https://www.linkedin.com/groups/4658452
Data Mining, Statistics, Big Data, Data Visualization, AI, Machine Learning, and Data Science
https://media-exp1.licdn.com/dms/image/C4D07AQHC5_oHcJZLpw/group-logo_image-shrink_92x92/0/1525133044361?e=1647691200&v=beta&t=4c3uIC2OOG1dzRQoAzGxFGo6Tn40MVxi9XW2sUruUWQ
https://www.linkedin.com/groups/152247
Data Science Central
https://media-exp1.licdn.com/dms/image/C5607AQFgIrDQ9DzXEw/group-logo_image-shrink_92x92/0/1631005688319?e=1647691200&v=beta&t=lUwqIYR-FMu0MFhDa7mbkZw1QFFVw0fPaDtuBo3kr3w
https://www.linkedin.com/groups/35222
Machine Learning and Data Science
https://media-exp1.licdn.com/dms/image/C5607AQFB7YeCihMhmw/group-logo_image-shrink_92x92/0/1631002216279?e=1647691200&v=beta&t=Qw1Bdm1-3NN04SaKMh8WovIj4_0dGAjHYuEGdhoPWDc
https://www.linkedin.com/groups/4298680
IBM Big Data and Analytics
https://media-exp1.licdn.com/dms/image/C4D07AQG0YPL9tPgKmg/group-logo_image-shrink_200x200/0/1631356913009?e=1647691200&v=beta&t=0nm9t3_7LIi6DRnTkg0yPbKktt08DQjJ83kprZI9ltg
https://www.linkedin.com/groups/4014567
Tableau Developers Group
https://media-exp1.licdn.com/dms/image/C4E07AQFLneaMG3OatA/group-logo_image-shrink_92x92/0/1551376356372?e=1647691200&v=beta&t=xzZbb9MYqzGjtbndltg47DXqGn94EgB02XlSFw3Hxg4
https://www.linkedin.com/groups/8197127
Amazon AWS Architects
https://media-exp1.licdn.com/dms/image/C4D07AQETM_KfeMEQbw/group-logo_image-shrink_200x200/0/1631369382865?e=1647691200&v=beta&t=g-TcP1s90p1kthFoacnOmjj-xBAPWGBv65FZ_D-JG-o
https://www.linkedin.com/groups/4387417
SOIC Career Services Office IUPUI
https://media-exp1.licdn.com/dms/image/C4E07AQGE1yZ3QgxpZw/group-logo_image-shrink_200x200/0/1631377757204?e=1647691200&v=beta&t=TEOrEB3XA72PHfFQCqhVtiyYCljl3zH1JlM2y2SCxfg
https://www.linkedin.com/groups/1790439