Data Analyst Python

Priyanka Bansal

Data Analyst

Contact: mailto:******.**********@*****.*** +1-603-***-**** Github LinkedIn 801 Lake Carolyn Pkwy, Apt#2106 Irving, TX-75039 USA I already have a work permit here, valid till Aug 2022, so there is no need for any visa sponsorship to me and I can join immediately.

Motivated, team-oriented and responsible Data Analyst with 5+ years of experience interpreting and analyzing data to drive successful business solutions. Highly educated, possessing a Bachelor’s, a master’s and various professional certifications in data analytics and statistics. SUMMARY

• Diligent Data Analyst with professional experience with hands-on experience in Data Mining, Big Data Analytics and Statistical Analysis.

• Experience in Python to manipulate data for data loading and extraction and worked with python libraries like Matplotlib, Scikit, NumPy, Seaborn and Pandas for data analytics and predictive modelling along with BI tools such as Tableau.

• Proficient in RDBMS including SQL Server, and MS SQL and ETL methodologies using SQL for validating and retrieving data.

• Strong skills in Data Cleaning, Data Processing, Data Extraction & Visualization with large datasets and Statistical Modeling, Multivariate Analysis. TECHNICAL SKILLS

Languages MySQL, Python

Skills Data Analytics, Database Management System, Programming Database Systems SQL Server

Reporting Tableau, Python (matplotlib, seaborn), MS Excel Python Libraries Pandas, Numpy, Scikit, Matplotlib, Seaborn Browsers Internet Explorer, Mozilla Firefox, Google Chrome Operating Systems Windows, Mac OS

MS Office Tools MS Outlook, MS Word, MS Excel, MS PowerPoint PROFESSIONAL WORK EXPERIENCE:

IT Business Operations Data Analyst

Consortium Gifts – BNI

Aug/2016 – April/2018

Responsibilities:

• Data collection procedure enhancement to include information that is relevant for building analytic systems processing, cleaning, and verifying the integrity of data used for analysis

• Involved in analysis of Business requirement, Design and Development of process. Interacted with the other departments to understand and identify data needs and requirements

• Thorough grounding in all phases of data analysis, including definition and analysis of questions concerning available data and resources, an overview of data and assessment of data quality, selection of appropriate models and statistical and presentation of results

• Responsible for performing the data validation, process flow and User Acceptance Testing and subsequent problem resolution

• Converted data into actionable insights by predicting and modelling future outcomes

• Utilized MS Excel, ERP, CRM and other toolsets for data intelligence and analysis

• Successfully adhered to company data governance standards and received the ISO certification for the company

• The Saved amount by researching and implementing cost-saving initiatives and creating fresh new approaches to long-standing problems

• Leveraged strong analytical background to develop innovative and efficient organization solutions to complex data sets for a varied set of users Achievements: Increased revenue by proper channelizing client’s dataset, resolved issues that saved company cost every month, increased client satisfaction, got ISO certification for the company.

Data Analyst

Sapphire Fashion House

Dec/2015 - Aug/2016

Responsibilities:

• Involved in all phases of data acquisition, data collection, data cleaning, model development and visualization to deliver data analysis solutions

• Created models to process internal sales order request for the smooth functioning of orders

• Created and maintained reports to display the status and performance of the deployed model

• Experience in designing stunning visualizations and presenting dashboards and Proficient in MS Word, Excel

• Strong experience in data extraction, manipulation, Analysis using data

• Experience in analyzing data, future trends and summarized results to generate recommendations for management

• Identified analyzed and executed new and potential systems for easy flow of systems

• Prepared production reports on a daily, weekly and monthly basis

• Analyzed production data and facilitated integral steps for improving productivity Achievements: Reduced company cost by developing new systems, a designed system for tracking and proper utilization of inventory, improved revenue by implemented cost-cutting initiatives

Data Analyst

Trident Group, India

Dec/2015 - Aug/2016

Responsibilities:

• Developed a system that regulated the approval of the export orders

• Leveraged on Excel to develop business dashboards enabling leaders for decision making and forecasting the future cost of orders for budget allocation

• Performed Data Exploration, Data Preparation, Data Cleaning and Data Visualization of the raw production data for team members and built model in SAP to predict the probability of orders raw material requirement in future

• Active member in the planning team and involved in SAP meetings, estimations and gathered information on requirements

• Producing reports on daily, weekly and monthly basis

• Strong experience in data extraction, manipulation, Analysis using data

• Coordinated with business analysis and finance departments to design objectives to achieve through data automation

Achievements: Changed working of SAP which saved 75-80% orders going in Red-Zone, proper utilization of inventory data which saved 20% company cost, selected in India’s top 40 students for this job

PAST PROJECTS

• Data_Visualization: Analyzed the Bike-sharing in Bay Area dataset to find out the usage of bikes. I used Kaggle dataset for this by using Python and its libraries. Project link

• Investigate-Dataset-TMDB: Analyzed a TMDB movies dataset that contains information about 10k+ movies and then communicated the findings of it. Used Python libraries NumPy, pandas, and Matplotlib. Project link

• Tableau - Global Life Expectancy dataset. Project link

• Tableau – Sample Superstore dataset. Project link EDUCATION

MS in Information Technology Bachelor’s in Mathematics and Computers Punjabi University, Patiala, India Punjabi University, Patiala, India Aug/2009 – June/2012 Aug/2006 – June/2009

PROFESSIONAL CERTIFICATES

• Data Analyst in Python

• Probability: Fundamentals

• SQL and Databases

• Storytelling through Visualization

Education Achievements: Secured the first position in Master’s, won many awards in the curriculum like sports, speech competition, event organizer, Quiz competition, etc.

Contact this candidate