Data Analyst Python

AARUSHI KAUSHIK

https://www.linkedin.com/in/aarushi-kaushik/ +1-469-***-**** adbgp9@r.postjobfree.com Dallas, Texas SUMMARY

Business and data analyst with experience in interpreting and analysing data in order to drive successful business decisions. Excellent understanding of business operations and analytics tools for effective analysis of data. Focused on transforming data into business solutions using business intelligence & informative technical abilities. EXPERIENCE

National Healthcare Solutions Inc. – Dallas, Texas Data Analyst Intern July 2019 – December 2019

• Designed database structures, implementing data verification and validation using advanced ETL processes to integrate large datasets in SQL server and MS access.

• Automated scripts to generate weekly and monthly data metrics reports, reducing report turnaround time by 60%

• Analyzed claims and eligibility data, transformed data into actionable insights using interactive Tableau dashboards.

• Evaluated, updated inbound data warehouses and data structures using SQL Server, improving performance by 30%

• Identified trends and data anomalies, created stored procedures, macros using SQL queries for data warehousing.

• Extracted, mapped and cleaned data by handling missing values in Python using NumPy and Pandas libraries. Win Incorporation – Lucknow, India

Business Data Analyst August 2016 – May 2018

• Analyzed inventory of over 50,000 products, highlighted top performing products in Tableau, increasing profits by 12%

• Created interactive dashboards using Tableau to visualize financial and sales data and developed reports using Vlookup, pivot tables in MS Excel to identify KPIs, enhancing key data driven business decisions.

• Designed in-house database with tables from multiple sources in SQL Server reducing time for analysis by 20%.

• Developed business rules using SQL to competitively price the products and increased profits by 10%.

• Collaborated closely with client business heads to evaluate business objectives, developed crucial functional requirement specifications, creating detailed use cases, entity relationship diagrams and process flow diagrams. ACADEMIC PROJECTS

Python for Data science – Census Analysis January 2019 – May 2019

• Cleaned and transformed data by grouping and aggregating parameters such as age, salary, occupation for census analysis.

• Visualized data using matplotlib and created box plots for age distribution, capital gains per occupation and generated summary statistics for census analysis.

Database Management – Order Management System August 2018 – December 2018

• Designed an order management database and created a class diagram and use case diagram for order tracking, inventory fulfilment and meeting order delivery on time in an efficient and cost-effective manner.

• Identified the data trends which helped in targeting 40% potential customers to increase the productivity by 15%. EDUCATION

The University of Texas at Dallas, M.S. Information Technology and Management May 2020 Vishveshwarya Institute of Engineering and Technology, B.Tech. Computer Science and Engineering June 2016 SKILLS

Analytical Tools: Tableau, MS Excel, Python, QlikView, Power BI, MS Access, VBA, Macros, Pivot Tables Languages & Databases: SQL, Python, Java, MySQL, MS Access, Oracle, SQL Server, Stored Procedures Analytical Techniques: Regression, Time series, Principal component analysis, K-means clustering, VLOOKUP Project Management: Agile, SDLC, JIRA, Scrum, Earned Value management, Release Planning, User Story Big data Analytics: Hue, MapReduce, Spark, Scala, HDFS Certifications: Python for Data Analysis, Advanced SQL for Data Scientists

Contact this candidate