Avishek Khadka
Bloomington,IN
Overview
2
2
years of professional experience
Work History
Database Administrator
Smithville Communications
03.2022 - Current
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Reduced data retrieval times for queries by creating indexed views and optimizing stored procedures.
- Built databases and table structures in Azure Data Studio to store company data.
- Used Mulesoft to create API connections to connect Salesforce with another billing software.
- Facilitated extraction, transformation, and dissemination of data from billing system (NISC's iVUE) to both internal and external stakeholders.
Marketing Data Analyst
Smithville Communications
08.2022 - 03.2023
- Analyzed data of over 70000 monthly active internet users and used outputs to guide marketing and product strategies which resulted in high take rate and decreased the churn.
- Managed a database of customers, service orders and customer care data and regularly performed data queries and data cleaning
- Assisted in making key marketing decisions and analyzed campaigns for success rate using KPIs and customer sentiment analysis through python.
Education
Bachelor of Science - Computer Science
Northwest Missouri State University
Maryville, MO05.2022
Skills
- Programming Languages: Java Python
CSS C HTML Java Script SQL R - Databases: Oracle MongoDB SQL Firebase Azure iVUE
- Source and Version Control: Git GitHub
- Data Visualization: Microsoft Excel Tableau
- Statistics: SAS Regression Analysis
- CRM: Salesforce
Accomplishments
- Serviceability Database
- COVID-19 Sentiment Analysis
- Car Valuation
Used Microsoft Azure to develop a seviceability database to store addresses of customers and what kind of service they can get.
Used Python and Tableau along with sentiment analyzing algorithm to analyze tweets and observe people's reaction to the decisions made by the government related to COVID
Used SAS for multiple linear analysis to determine the price of a car by comparing it to the features the different cars in the market.
Timeline
Marketing Data Analyst
Smithville Communications
08.2022 - 03.2023
Database Administrator
Smithville Communications
03.2022 - Current
Bachelor of Science - Computer Science
Northwest Missouri State University
Similar Profiles
Sarah CrawfordSarah Crawford
Cashier at Smithville FoodlandCashier at Smithville Foodland
Brooke FergusonBrooke Ferguson
Supervisor of Respiratory Care/Acting Manager at Ascension Seton Smithville, Ascension Seton BastropSupervisor of Respiratory Care/Acting Manager at Ascension Seton Smithville, Ascension Seton Bastrop
Stihl GartmanStihl Gartman
Teacher's Assistant at ACE Smithville ElemeentaryTeacher's Assistant at ACE Smithville Elemeentary