Data Python

352-***-**** Minal Chanana adi5xt@r.postjobfree.com

EDUCATION

Master of Science in Information Systems, Illinois State University, Normal, IL GPA:3.85/4.00 May 2020 Bachelors in Information Technology, Technocrats Institute of Technology, Bhopal, India GPA:3.19/4.00 June 2011 TECHNICAL SKILLS

Business Skills- Requirement Elicitation, Requirement Documentation, Agile Development, Stakeholder Development, Strategic Decisioning, Data Analytics Strategy

Data Analysis- Data Visualization, Data Modeling, Data Transformation, Database Management, Data Migration Programming Languages/Tools- SQL, Tableau, Jira, Microsoft Office Suite, Advanced Excel, Balsamiq, Power BI, Oracle 12c, Python, R Certifications- Certified Scrum Master, Oracle PL/SQL Developer Certified Associate WORK EXPERIENCE

Global Systems LLC

Business Analyst Trainee Aug 2020 – Present

● Analyzing client requirement and translate them into a functional solution

● Performing analysis of large sets of data and user stories

● Data analysis for various version changes of EDI messages on different subsystems Illinois State University, Normal, IL

Business Analyst Graduate Assistant Aug 2019 – Dec 2019

● Created student satisfaction survey, kept track of responses, and analyzed student responses (Using Pivot Tables and VLOOKUP) by applying analytical and critical thinking skills in MS Excel

● Collected student data by running reports in Symplicity tool and exported the reports in MS Excel to be used for analysis

● Examined and combined large amounts of confidential student data according to guidelines set by the Career Services by using MS Excel

● Transitioned the executive summaries into high-quality presentations to be delivered to the Career Services staff for recommending improvements in processes and services Abhyudaya Multimedia, Indore, India Jun 2014 to May 2017 Systems Engineer

● Translated Clients requirements and ideas into comprehensive business requirements and design documents, along with database designing and technical documentation

● Assisted the deployment phase with customer interaction, risk planning, and maintenance

● Performed data analysis to support the various implementation initiatives supporting decision making

● Assisted in manual testing and maintenance of the web application which reduced operational burden by 5 hours/week of developer’s time

● Trained to write, and troubleshoot Microsoft SQL database scripts and implement these scripts to develop and maintain databases

● Mentored two new hires which made them available for new projects 3-4 weeks earlier PROJECTS

Absenteeism Analysis (Python, SQL and Tableau) Apr 2020 - May 2020

● Examine the reasons for employees for their absentees from work. Build a machine learning model to predict absenteeism.

● Use the integration of Python (Jupyter), SQL and Tableau for analysis and applied data preprocessing techniques.

● Connect Python and SQL to transfer data from Jupyter to SQL (Workbench) and visualize data in Tableau NBA Players Data Analysis (Python) Feb 2020 – Mar 2020

● Analyzed the performance of top 10 NBA players from 2005 to 2015 and visualize the data by importing packages such as NumPy and Matplotlib

● Created functions which used to generate result of players for number of field goals scored per game, salary and number of games played

Twitter Analysis (Python, NLTK, Pandas and NumPy) Mar 2019 – May 2019

● Extract tweets to develop a sentiment analysis model that helped improve sales and marketing strategies.

● Pre-processed and cleaned (removal of emojis, special characters, delete duplicate tweets and stop words) tweets using Tweepy libraries for further analysis.

Video Games Sales Data Analysis (OSEMN, R) Oct 2018 – Dec 2018

● Performed Data Analysis on video games sales dataset from Kaggle using OSEMN framework steps, used machine learning techniques

Contact this candidate