Business Intelligence Data Analyst

Seema Bhandari *** Ohio Ave, Youngstown, OH – ****4 ****************@*****.*** 330-***-****

EDUCATION

Master of Science in Analytics Jan 2019-May 2021

Dakota State University, 3.9 Madison, South Dakota Bachelor’s in Computer Engineering Nov 2013- Nov 2017 Kantipur Engineering College Lalitpur, Nepal

SKILLS & CERTIFICATES

Database Management: Microsoft Excel, MySQL, SQLite, SQL, Oracle ETL: CloverETL, Talend, Power BI, Tableau

Big Data: Hadoop, Hive, Kafka, Spark, HDFS

Software Development: Python, Java, R, SAS, C++, C, Android, JS, Jquery Data Science: Data Mining, Data Warehousing, Data Modelling, Data Visualization, Business Intelligence, Statistical Analysis, Advanced Microsoft Excel

WORK EXPERIENCE

Healthpoint, Dakota State University Mar 2019- Apr 2021 Full-stack Developer, Madison, SD

• Led and completed the development of a web application in less than 3 months of projected time.

• Developed frontend with HTML, CSS, JavaScript, and jQuery using agile method of development.

• Remodeled the client’s paper-based database to be SQL-based by building the backend using parametrized query written in ASP .net; reduced the code redundancy by 60%.

• Hosted the application on Azure; reduced patient screening time for the client by 50%. Department of Health, South Dakota Jun 2020- Aug 2020 Data Analyst Intern, Pierre, SD

• Built dashboards using Power BI to track changes in number of COVID-19 infected cases in the state.

• Increased efficiency of pre-existing SAS code by 20%.

• Improved data manipulation task in MS- Excel by deriving formulas to detect outliers.

• Escalated data analysis by cleaning everyday data using MS-Excel and uploading it to a database server.

• Extracted patient information from MS-Word using Maven and forwarded it to necessary departments. Healthpoint, Dakota State University Jan 2019- Mar 2019 Data Analyst, Madison, SD

• Used Java to extract information from pre-existing Risk Assessment reports in PDF and XML formats.

• Inserted the extracted information into MySQL database - eliminated manual data entry process and saved the client many hours and labor cost.

• Developed a system to generate better risk assessment reports based on client’s extracted information and Healthpoint’s information using iTextPDF library in Java. Datalytics Private Limited Jul 2016- Dec 2018

Data Analyst Intern, Kathmandu, Nepal

• Developed an ETL script using Python to track progress of different projects in the organization.

• Imported a MySQL database on Hadoop to run an ETL process in CloverETL.

• Created a dashboard on Tableau for weather forecast.

• Visualized farming data using R to explore the relation between seedling period and harvest amount. HONORS & AWARDS

• Grace Hopper Conference, Student Scholar Jul 2019- Present

• DSU and AT&T Hackathon, Winner Feb 2019- Feb 2019

Contact this candidate