Data Analyst Python

Bonny Shah

Dallas-Fort Worth Area, TX 682-***-**** ***********@*****.*** linkedin.com/in/bonnyshah1994

TECHNICAL SKILLS

Power BI SQL MS Office MS Visio Oracle ERP JIRA SAP Business Objects Tableau Python R C++ JAVA

EDUCATION & CERTIFICATES

Master of Science in Information Technology & Management Dallas Baptist University, Dallas, TX December 2018

Bachelor of Business Administration Gujarat University, India May 2015

INDUSTRY EXPERIENCE & MASTERS PROJECT

Business Data/Process Analyst, UT Southwestern Medical Center March 2020 – Present

Working for leadership team in supply chain department at the Clements University hospital and helping leadership team in defining and improving business processes and mapping out processes for future needs.

Working with cross functional teams to identify issues in current business processes and to improve them. Also working on gathering software requirements to discuss in weekly meetings with technical team.

Working with Sr. Business Data Analyst to define and maintain key performance indicators for the department.

Providing data support (Product Usage, POs, Department product requirements) including data extraction, data validation, data mining and quality check to assist ad-hoc data analysis. Automated daily and repetitive analysis with the help of VBA macros.

Developed SQL queries for the validation of logistic, claims and inventory data help of non-technical team members.

Working with value analysis team on state government contract documentation. Responsible for analyzing profit and savings for each contract on the time of renewal.

Responsible for visualizing weekly and monthly reports with the help of PowerBI and providing it to Director to measure supply and demand for each product in weekly executive hurdle meetings. Build and deploy PowerBI data visualization dashboard to spot KPIs metrics to get trend analysis, to support business decisions and to get more insight from data.

Business Analyst, OM Produce July 2019 – March 2020

Analyzed Business logic and gathered information from cross-functional teams to create requirement specification document for the ease of technical team.

Experience in communicating with the customer and getting feedback from them to improve efficiency and accuracy. Engaged in creating Power BI dashboards to visualize the data and future needs.

Assisted QA and operational team in creating test strategy, Test plan and Test Cases for functional requirement specifications. Retrieved data using SQL queries and did data mapping and data analysis.

Engagement operation management, Order forecasting, Process improvement and standardization & statistical analytics. Helped operational Manager to Look for methods to automate and electronically capture existing manual and legacy techniques to improve efficiency and performance. Actively engaged in gathering customer feedback about the service and constantly updating the operation team for better customer satisfaction.

Python Developer Intern, Smart Start Inc. April 2019 – June 2019

Developed new features by using Python and MySQL. Worked on Application Development with the team.

Worked on Developing new features in GUI which exactly look like web database which we used for regression and Load testing by using PyQt. Experienced working with a huge database and used JOIN SQL queries to fetch the data from different tables in MySQL workbench. Strong understanding on Waterfall and Agile Methodology.

Worked on different data formats like JSON, XML and used libraries to change the data formats.

Strong debugging skills and unit tests with proficiency in code versioning tools such as GIT and SVN.

Experienced in Scrum practices like User Stories, Story Slicing, Backlog Grooming, Release Planning, Sprint Planning, Scrum Planning, and Sprint Review.

Project Simulation – MSITM 6320 Software Project Management November 2018

Completed an Alliance Project to augment the sales and marketing capabilities of Uniworld with an E-commerce equipped website within the approved budget of $ 50,000 and a schedule of 14 weeks.

Contact this candidate