Graduate Assistant Data Analyst

Sangeeta Apparado

**** ****** ******, ******, **,76207 214-***-**** ****************@*****.***

EDUCATION

University of North Texas: BS in Business in IS – Fall 2019 MS in Information System – Spring 2021 Major GPA: 3.75 Cumulative GPA: 3.5

SKILLS

Technical Skills: Python, Java, MySQL, Big Data, SAS, JMP, SPSS, Tableau, R, Microsoft Projects, Data visualization, Data mining, Statistics, Power Pivot, Power BI, Oracle DB, Mongo DB, Agile Technology: PyCharm, Microsoft SQL, GitHub, Jupiter, Eclipse, NetBeans, Jira, Dev Ops Google Collab, SQuirrel SQL Personal: Excellent communicator (verbal &written), loyal, quick learner, punctual, detailed-oriented, eager to learn, funny and friendly

EXPERIENCE

UNIVERSITY OF NORTH TEXAS August 2019- May 2021

SYSTEM ANALYST (Graduate Assistant) for Information System Department

• Developed sprint platform by using JIRA-Agile to assign the task to scrum master and teams

• Created and managed JIRA platform with different tasks such as STORY, EPIC, BUG, and TASK for each project

• Provided required details from client to development teams regarding each task

• Tracked each task been on track with Agile methodology such as planning, implementation, testing, review

• Updated and deleted records to the students’ record database by using execute query to feed existing SQL commands

• Migrated the output from the database into a DataFrame with pandas

• Filtered and read data by using cursor.fetchall without making any changes from existing data REDWOOD APPLICATIONS LLC – DATA ANALYST (INTERNSHIP) January 2021- May 2021

● Received data from third party vendor and manipulated data to be uploaded to DevOps

● Built pipeline for data and created appropriate flow through Azure Data Factory

● Built a mapping data flow with four transformations (Create, Update, Insert, Delete)

● Assisted in creating end to end workflow in Microsoft Synapse Analytics

● Developed and migrated data from Power Pivot to Power BI

● Uploaded the required the data file in UAT shareable folder to get approval from manager

● Tested SQL queries in SQuirrel to find valid records before the project goes to live

● Created weekly SSI package based upon completion of weekly task HANDS ON PROJECT

Legal Knowledge Graph Annotation with Python: Purpose of this project is to create a user-friendly web system easy to annotate pre-uploaded paper and the result of annotation will be turned into knowledge graph. January 2021- May 2021

● Created project modules, polls and syn database into the modules by using Django

● Developed relational databases and required database table with SQL queries and export those databases into Django project

● Implanted multiple modules based on primary key of modules such as (Paper_id, Author_id, Annote_Id)

● Build knowledge graph from the annotation results by using Neo4j Data Visualization with SAS:

Purpose of this project to identify the number of COVID-19 cases in third world country by using SAS August - Dec 2020

● Cleaned the dataset and developed modules based on the requirements

● Gathered approximately 20-25 different data attributes for third world country

● Build data filter to identify the source of number of positive cases and number deceased due to COVID-19

● Used PROC Forecast to predict the percentage of COVID-19 numbers for next 10 months Android Weather App with Java:

Purpose of this project to build an Android weather app with JAVA August 2019- Dec 2019

● Designed and built app format by using Android Studio

● Declared variables inside Android Studio through MainActivity.java

● Imported JAVA capacity in order to deal with Android components

● Executed code that convert from Fahrenheit to Celsius Sales Growth Dashboard with Tableau:

Purpose of this project is to identify patterns or trends on Sales margin January 2020- May 2020

● Created Pipeline dashboard for sales data and analyze data based on region, profit, and discount

● Amplified booking percentage and sliced results in multiple ways (view of account sale and account details)

● Determined number of sales based on sales rep’s commission and identified the products the sales reps sold

● Identified the reasons for selected inventory produced profit and loss REFERENCES

Mrs. Rosa Malave (Senior Lecture of UNT) Email: ****.******@***.*** Phone number: 940-***-**** Mahdi Fathi (Assistant Professor of ITDS) Email:*****.*****@***.*** Phone number: 940-***-**** Komala Sambasivan (Manager of Redwood Application) Email: *******@*****.*** Phone number: 214-***-****

Contact this candidate