aahana khajanchi
Business Intelligence Analyst at Sharp HealthCare
data analytics | python | sql | tableau
data scientist intermediate skill , insatiable intellectual curiosity , ability mine hidden gem located within large set data . able leverage heavy dose mathematics applied statistic distributed storage management , visualization healthy sense exploration .
Sharp HealthCare
https://www.linkedin.com/company/sharp-healthcare
• Created multiple reports and dashboard visualizations to provide insights to enterprise leadership for Covid Vaccines
using Alteryx, sent reports to San Diego County
• Automated multiple Covid workflows and charts for Covid Count stats which is used by county for Decision making, 
whether San Diego county should be in Red Tier or Purple etc
• Implemented Various ML models in DataRobot using Python for - Predicting length of appointment for home care 
visits to improve appointment scheduling 
• Managed Pharmacy and Lab data from multiple sources, created views in Denodo, and generated reports in IBM 
Cognos
• Retrieved data from various health plans, transform it and constructed database, executed queries in Oracle and 
visualized output in IBM Cognos
• Performed deep analyses and created reports for Inventory Management for Flu and Mask Supplies
San Diego County, California, United States
https://media-exp1.licdn.com/dms/image/C560BAQHJK9rplnUT_A/company-logo_100_100/0/1626712055860?e=1655942400&v=beta&t=xik5vdagPSp3UG0Wj_Hcg-174LKDznwH8TS149WLjKw
Business Intelligence Analyst
Suffolk Construction
https://www.linkedin.com/company/suffolk-construction
●	Developed and produced ad hoc business analytics to support management and strategic decision-making
●	Analyzed data and developed Dashboards for the Management of Project Profit Risk using Tableau, leading to regional profit growth by 20%
●	Built an interactive Dashboard to report coding errors in the data which improved Data Quality by 30% 
●	Engineered ER diagram and produced functionalities with stored procedures, triggers, and complex SQL joins; constructed whole database, executed queries, and visualized output in Power BI
●	Cleaned data, performed EDA and calculated outliers on projects for business users to make data-driven decisions
Greater Boston Area
https://media-exp1.licdn.com/dms/image/C4E0BAQEkv7rSfQMWJw/company-logo_100_100/0/1580689350279?e=1655942400&v=beta&t=NxLfLIZ5x6wVV0TyxucUZnD0aivDp20VF0N9sIKDCf8
Data Analytics Co-op
Master of Science 
 Information Systems
https://media-exp1.licdn.com/dms/image/C4D0BAQGwTPCvlTQlvw/company-logo_100_100/0/1597690746891?e=1655942400&v=beta&t=jmUiUcOXCU0bADKVWx19mhaN2u38Tqthfncxz9h5c2U
Northeastern University
https://www.linkedin.com/school/northeastern-university/
Bachelor of Engineering 
Information Technology
https://media-exp1.licdn.com/dms/image/C4E0BAQEAVRB3i7rHHg/company-logo_100_100/0/1519874329661?e=1655942400&v=beta&t=X1XWvMY9pweE63oj4f4GQpf8nMGcDxvQ3H9CBaMpxzM
Rajiv Gandhi Prodyogiki Vishwavidyalaya
https://www.linkedin.com/school/rajiv-gandhi-prodyogiki-vishwavidyalaya/
It’s a non-profit organization that exists to help serve and mobilize international students in the USA and abroad to promote social connections.
Bridges International
Member
The workshops based upon individual goals for development, improving the leadership skills as well as connecting with the peers.
Graduate Leadership Institute (Lead 360)
Member
It is a non-profit educational organization that provides a supportive and positive learning experience in which members are empowered to develop communication and leadership skills.
Toastmasters International
Member
Advance Data Science
-
Application Engineering Development
-
Big Data and Intelligence
-
Data Management and Database Design
-
Information Storage Management
-
Software Engineering and Management
-
● Built an interactive dashboard to compare Growth of Online Learning using Tableau 
● Implemented data quality check, cross-data joins, action filter and used Level of Detail LOD expressions 
● Created Scatter plots to explore and compare Electrical Usage and mobile Phones over the years
Growth of Online Learning
https://public.tableau.com/profile/aahana.khajanchi#!/
•	Developed a machine learning based Web application using Django to Predict suitable job titles/position from resume and give links to suitable Jobs.
•	Implemented Naïve Bayes classifier using Job description with the title and Pickled the model
•	Engineered a custom Web Scraper to scrape the latest job posting from indeed.com given position and location with Scrapy
•	Pipelined the process to automatically retrain the model from the new scraped data with Luigi and AWS lambda
•	Deployed the project on AWS EC2 t2 medium instance and stored the latest model with scraped data into S3 Bucket
•	Integrated Tableau into user dashboard for learning trend analysis in the job posting 
•	Created the entire website mobile responsive and elegant by using materialize CSS
Resume Parser
https://github.com/aahana-khajanchi/ADS-Final-Project-1
http://198.199.74.32:5000
•	Created Web Application using Flask. The application inputs data using Forms as well as REST API calls using JSON.
•	Explored Data using Seaborn, Matplotlib, Pandas, and Numpy. 
•	Executed Regressor and Classifier models like Random Forest, Extra Trees, and KNeighbors
•	Pickled all the models and Dockerize the application.
•	Used Amazon S3 for Model Deployment
•	Used MySQL for Database
Machine Learning Approach for Predicting Position of the User using WIFI Fingerprint Based Localization
https://github.com/aahana-khajanchi/ADS-Final-Project
• Applied Exploratory Data Analysis using PandasProfiling and Plotted several Graphs
• Generated New Features for Feature Engineering
• Implemented various models like Random Forest and Linear Regression
• Performed Feature Selection using tpot, Boruta and tsfresh
• Created Final Pipeline and used Docker
Analysis of Appliances-Energy-Prediction Dataset
https://github.com/aahana-khajanchi/AdavancedDataScience-1/tree/master/Assignment2
•	Scraped EDGAR data from web to extract tables from 10-Q filings for different companies  
•	Analyzed EDGAR dataset by handling missing data, observing anomalies and computing summary metrics
•	Created docker image which runs the whole pipeline
•	Created a log file that contains logs of events that have occurred in the program
Analysis of EDGAR Dataset
•	Implemented Data munging techniques on data sets using Python
•	Applied Exploratory Data Analysis for plotting the graphs using numpy and pandas
•	Analyzed data using Linear Regression Model
Automobile Price Prediction Tool
	Designed an Object model which has multiple directories, networks, enterprises and organizations
	Developing an efficient child alert care system and bring valuable synergy among parents, vaccine provider's and distributors for vaccines of the children
A Child Care Alert System
•	Created a database to order the household products automatically using a sensor
•	Designed an Entity-Relationship diagram on MySQL
•	Implemented techniques like Stored Procedure, Views and triggers
IOT Distribution and Maintenance
•	Developed an Android based application for online booking of vehicles
•	Designed User interface of the application using Android Studio
Vehicle Rental System
Social Services
Gramiksha
https://www.linkedin.com/company/gramiksha
I participated in 2 projects Street meet and Project Udaan,
In Street meet, we reached out to children in rural and clannish areas to promote education and to spread the awareness about the drugs and other bad habits in which they shouldn't  be involved.
In Project Udaan, we went to different schools and focused on promoting extra-curricular among children.
https://media-exp1.licdn.com/dms/image/C4E0BAQEvXqheKQsh_w/company-logo_100_100/0/1593274794447?e=1655942400&v=beta&t=qT8kK07ZotiJW48I0so6jj8_1Th1Cbkxvr03x2ruIR4
Volunteer
LinkedIn
www.linkedin.com
Text Analytics and Predictions with Python Essential Training
http://www.linkedin.com/learning/text-analytics-and-predictions-with-python-essential-training
LinkedIn
www.linkedin.com
Creating Interactive Dashboards in Tableau 10
http://www.linkedin.com/learning/creating-interactive-dashboards-in-tableau-10
https://www.linkedin.com/in/aishwarya-sanap
Boston, MA
Aishwarya Sanap
"Data Analyst | Data Engineer | Data Scientist | IT Business Analyst”
https://www.linkedin.com/in/gupta-harshita
Greater Boston
Harshita Gupta (She/Her)
Manager, Data Analytics and Insights at Fidelity Investments
https://www.linkedin.com/in/kushal-doshi
Greater Boston
Kushal Doshi
SQL| Tableau| Business Intelligence | Data Engineer| Data Analyst | SQL Developer| Actively looking for permanent opportunities
https://www.linkedin.com/in/anuragpalanki
United States
Anurag Palanki
Grad student at NEU F21 | Data Analytics Engineering | CSE Graduate
https://www.linkedin.com/in/poornima-muralidharan
Boston, MA
Poornima Muralidharan
Senior Consultant - Data and Analytics Business Intelligence at EY
https://www.linkedin.com/in/sally-gillen-759617101
San Diego, CA
Sally Gillen
Data Analyst at Sharp HealthCare
https://www.linkedin.com/in/amitabairathi
San Diego, CA
Amita Bairathi
Senior Business Analyst at Amazon
https://www.linkedin.com/in/ryanhamlett
Yucaipa, CA
Ryan Hamlett
Healthcare Data Analyst I at IEHP
https://www.linkedin.com/in/trisha-c
Jersey City, NJ
Trisha Chakraborty
Business Intelligence Analyst at Thermo Fisher Scientific
https://www.linkedin.com/in/aditigautam3090
Greater Seattle Area
Aditi Gautam
Business Intelligence Analyst at Boeing
https://www.linkedin.com/in/hectoramaya
San Diego, CA
Hector Amaya
Business Intelligence Analyst at Sharp HealthCare
https://www.linkedin.com/in/mina-kazemi-571516223
Greater Boston
Mina Kazemi
Actively looking for internship in Summer’22@Data Analytics @ Northeastern University
https://www.linkedin.com/in/sathwikhegde
Boston, MA
Sathwik Hegde
Grad student @ Northeastern | Software Developer | Machine Learning & Data Science | Data Engineer
https://www.linkedin.com/in/meghagoyal2160
Tempe, AZ
Megha Goyal
Business Analyst at Amazon | Ex LinkedIn
https://www.linkedin.com/in/shilpa-p-bhat
Seattle, WA
Shilpa Parameshwara Bhat
Business Intelligence Engineer at Amazon
https://de.linkedin.com/in/nakulambravaneswaran
Berlin Metropolitan Area
Nakul Ambravaneswaran
Business Intelligence Engineer at Amazon
https://www.linkedin.com/in/anthonybuhr
Greater Minneapolis-St. Paul Area
Anthony Buhr
Senior Decision Scientist at Best Buy
https://www.linkedin.com/in/abhishek-yadav-41646b8b
Rochester-Austin, Minnesota Area
Abhishek Yadav
Business Intelligence Analyst at Mayo Clinic
https://www.linkedin.com/in/james-orler
Houston, TX
James Orler
Business Intelligence Analyst at Nutrabolt
Nicholas Carbone
      
          



            
              
        
              
  

    
        Aahana did a great job as a coop as Suffolk.  She worked hard, learned quickly, and suggested novel solutions that often improved our processes.  As her manager, she was responsive to advice and worked hard to develop rapidly.  Her understanding of the business improved rapidly and she quickly contributed to the team.  I would recommend her as a data analyst and as a coworker. 
Entry Level Jobs and Internships: College Recruiter
https://media-exp1.licdn.com/dms/image/C4D07AQEpJc23i6jtvg/group-logo_image-shrink_200x200/0/1631365542121?e=1647691200&v=beta&t=x5_XnGQkEWJnz4p27L7pFcM3lTh2Rf1YHVXr8Pvqpys
https://www.linkedin.com/groups/2067005
Python Developers Community (moderated)
https://media-exp1.licdn.com/dms/image/C4D07AQHwzHzy4qrgaw/group-logo_image-shrink_92x92/0/1631004564272?e=1647691200&v=beta&t=BgwniO3j8jfI52dOjNEfTwxRe1okKBPGY8NfYAwvoOc
https://www.linkedin.com/groups/25827
Digital Hive's The Data Story
https://media-exp1.licdn.com/dms/image/C4D07AQFG0kc_pGq_Jg/group-logo_image-shrink_92x92/0/1637075839479?e=1647691200&v=beta&t=JXWhti7avbVOiSpLuMqj5iWHgsZKjPPVlOF2OUxYk68
https://www.linkedin.com/groups/12229951
Evernote Product Community
https://media-exp1.licdn.com/dms/image/C4E07AQHBcSwGTBoS1Q/group-logo_image-shrink_92x92/0/1631002793409?e=1647691200&v=beta&t=wd3eFEAitg0G56ERVuutYqin68aDx5xjbTp6dssvcoE
https://www.linkedin.com/groups/12527703
Greater Boston Area Microsoft Students
https://static-exp1.licdn.com/sc/h/4h1ldzvvebtszyx75ve7dst1v
https://www.linkedin.com/groups/8683662
Information Systems Management & services
https://static-exp1.licdn.com/sc/h/4h1ldzvvebtszyx75ve7dst1v
https://www.linkedin.com/groups/3128484
Young Scholars & Women in STEM
https://static-exp1.licdn.com/sc/h/4h1ldzvvebtszyx75ve7dst1v
https://www.linkedin.com/groups/12071092
Northeastern University Information Systems
https://media-exp1.licdn.com/dms/image/C5107AQFK17RRQGrKtQ/group-logo_image-shrink_200x200/0/1631418755583?e=1647691200&v=beta&t=_xh7wLUKQAmlys_NRpGvOhyE-8hUfzaFu0mUIBz3B0g
https://www.linkedin.com/groups/12074088
CSS Designers & Developers
https://media-exp1.licdn.com/dms/image/C4D07AQF09FuU2fL6bg/group-logo_image-shrink_200x200/0/1631365341288?e=1647691200&v=beta&t=YxyKYrKT2b4J6ZNKyilWeRVg3fuUPz76ft_M65Jp5OY
https://www.linkedin.com/groups/128819
She+ Geeks Out
https://media-exp1.licdn.com/dms/image/C5607AQE-pvgqn_znpw/group-logo_image-shrink_92x92/0/1630996790544?e=1647691200&v=beta&t=kLNQ3ZazmSaBNpKTdYGBARGG20bPHJMWQYwxNF3GYdM
https://www.linkedin.com/groups/5059895
Careers in Texas
https://media-exp1.licdn.com/dms/image/C4E07AQEtgt_Z0q_RfQ/group-logo_image-shrink_92x92/0/1631000995339?e=1647691200&v=beta&t=VaMsruqm8M6a65e26JuGc5CWEawo1G11LV-M4DTAMq0
https://www.linkedin.com/groups/12302471
Entry Level Data Scientists
https://media-exp1.licdn.com/dms/image/C4D07AQE8xJp4srUMBA/group-logo_image-shrink_92x92/0/1631010235768?e=1647691200&v=beta&t=TCwI5Qhl_-yvC00YV4_ifGYUfkWkkVZM1bO4CXv5Vn8
https://www.linkedin.com/groups/6607352
Northeastern University International Students and Alumni Networking Group
https://media-exp1.licdn.com/dms/image/C4E07AQFWnurPPePWRg/group-logo_image-shrink_200x200/0/1631371294602?e=1647691200&v=beta&t=8v0tVQWGoq91gCOaWOQ3TyAX9hmy6kVgj0F-3YhCwBA
https://www.linkedin.com/groups/8138817
DATA SCIENCE INFINITY
https://media-exp1.licdn.com/dms/image/C4E07AQHuIzT_U7XZfA/group-logo_image-shrink_92x92/0/1631002904421?e=1647691200&v=beta&t=XOzc71y3_qukDVg-lejuoJ-_aTIvLvkScmNWRpHcf8E
https://www.linkedin.com/groups/8621918