Chand Bhanot

847-***-**** adkren@r.postjobfree.com

Summary:

• Innovative and enthusiastic self-starter interested in learning integrative skills to further intellect.

• Highly capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

• Extensive knowledge of BI tool Tableau, MySQL, and Python or development of visualizations for analysis and evaluation of data.

• Outstanding presentation skills highlighting data analysis through interactive use of building workbooks, stories, and dashboards.

• Stacked bar charts, Bullet graph, Histogram, Dual axis chart, Tree maps, Heat maps, Highlight tables as well as the more common line, bar, and pie chart are some of the techniques I’ve used to simplify raw data in a very easily understandable forms using Tableau.

• Experience in gathering business and functional requirements, feasibility studies, risk analysis, GAP analysis, and Data flow diagrams using UML Tools.

• Experienced in conducting backend testing and can write SQL to retrieve the data for validation and accuracy. Complete understanding of Software Development Life Cycle

• Hands on experience with backend testing using AS400 screens.

• Proven experience in writing Test Plans, Test Scenarios, and detailed Test Cases for conducting Functional, System, Regression, and end to end testing of applications.

• Hands on experience with test case designing, test execution, defect reporting, triage, tracking, coverage analysis and coordination of testing efforts.

• Good working knowledge of Microsoft Office Suite including - Word, PowerPoint, Excel, Access.

• Good Interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks

Education:

• Bachelors in BMB & Mathematics (Benedictine University) Aug 2013- July 2017

• Business Analyst Course Aug 2017- Sept 2017

• Certified as Tableau Desktop Specialist Feb 2021 Legal Status:

• US Citizen

Technical Expertise:

Business/Modeling Tools

MS Excel, MS Word, MS PowerPoint, MS Power pivot, Draw.io. Databases MySQL, SQL Server, MS Access, AS400

Computer Languages HTML, MySQL, Python

Software Tableau, Adobe Premiere Pro

Browsers Internet Explorer, Google Chrome, Safari, Firefox 2

Professional Background:

TABLEAU DEVELOPER (Crane Payment Innovations) Oct 2019 - Dec 2020

• Crane Payment Innovations (Mount Prospect, IL) partners with businesses globally to provide automated payment options in settings such as vending, retail, gaming, transport, kiosks, and more. I worked as a contract tableau developer under Sr. Systems developers to primarily present any modifications and upgrades to end user using various reporting tools such as Tableau and SQL. Responsibilities:

• Worked extensively with reporting software such as Tableau, Python and SQL using Dashboards and Stories highlighting benefits of any modifications or upgrades to previously set up automated payment options.

• After data integration from multiple sources using ETL and data cleaning using the help of Microsoft Excel and Microsoft Access, I had hands on experience exploring data using a multitude of visualizations including but not limited to as Bar Charts, Line Charts, Pie Charts, Area Chart, MAPS, cluster charts, and Scatter plots.

• Primarily, I was responsible for using different types of visualizations and the associated Filters, Highlighters, Trend lines, Parameters, Bins, Dual axis, ext. to showcase the pros and cons of any changes in the previously set up systems.

• Interacted with upper management, mostly Sr. Systems developers, to get feedback on dashboard and story design and on occasion deliver presentations to the end users. Environment: MySQL, Tableau, MS Access, MS Excel, MS Project BUISNESS ANALYST (M1 finance, Chicago) Apr 2018 – Sept 2019 M1 Finance (Chicago, IL) assists with online management and growth of customer finances through investing, digital checking, portfolio’s and more. In a BA contract position, I played an important role in improving customer retention and loyalty by reviewing loan and credit applications, analyzing loan extension, preparing collateral analysis reports using Tableau, and more.

Responsibilities:

• Interacting with the management to get a better understanding of client business processes and gather requirements.

• Involved in Requirement Scoping, RFP documenting, and analyzing high priority requirements for loan extension and renewal requests.

• Prepared logical data model to determine a client’s credit worthiness in the form of Business Context diagram to include various entities and attributes in order to facilitate the design of Data model.

• Conducted Joint Application Development (JAD) and Rapid Application Development (RAD) sessions for communicating and managing expectations.

• Involved in GAP analysis and feasibility analysis for the design and architecture of the new application and demonstrated these variations using Tableau to both end user and higher management.

• Collaborated with system integrators to provide complete information and check database information using AS400

• Trained the users for new process and applications. Environment: Tableau, MS Access, MS Excel, Draw.io, MS Project, HTML, SQL Server, AS400. 3

JUNIOR TABLEAU DEVELOPER (Dream Salon, Palatine) Aug 2016 – Mar 2018 Dream Salon (Palatine, IL) presented with a requirement for an application for the salon containing main modules such as Customers, Service, Customer transactions, Customers billing, Employee hours, Daily reports, Weekly reports, Monthly reports, and others. I worked as a Junior Tableau Developer under a contract position until the requirements for the system were met.

Responsibilities:

• Requirement gathering and involvement in the creation of Business Requirement Document (BRD) while interacting with entrepreneurs was key in the beginning.

• I designed Use Cases, Use Case diagrams, Activity diagrams, Entity Relationship Diagram and Use Case Document.

• Preparation of project based on previous data and utilizing MS tools, Word and Excel, to perform analysis and to optimize the current software in place.

• Managed project planning sessions with project manager, Business Analyst, team members, and Users to analyze business requirements on best approach for employee to operate the software.

• Communicating with the Engineers and Technicians regarding visuals for the salon website which were created using Tableau.

• Actively participated in revising development solutions to deliver accurate solutions, and design application solutions that fully implement business requirements. Environment: Tableau, MS Access, MS Excel, Visual Basic, HTML, and MySQL STUDENT PROJECT (Benedictine University, IL) Jan 2016 – Aug 2016 Final student project done at Benedictine University (Lisle, IL) was for DNA variation over time based on Charles Darwin’s Theory of evolution. The project used a database filled with numerous data points of recorded DNA throughout history. Python as well Tableau were primarily used to develop a system showing trend variation of the DNA mutations over time. I worked with a team of associates to deliver this project. Responsibilities:

• Work with various disciplines to provide technical insight of new initiatives and existing frameworks

• High comfort level working within (as well as analyzing and improving) an established code base

• Creating relationships and manual testing of code for assistance with analyzing trends

• Follow and contribute to established development methodology and engineering practices

• Presented a biostatistical analysis of DNA variation over time working closely with team of associates

• Generated code using Python and held bug/defect review sessions twice a week.

• Worked extensively on Tableau BI and created Dashboards/Stories using different types of Slicers and different interactive Visualizations to show transformation in trend and R squared significance.

• Hands on experience in creating clusters, trend lines, and creating visually stimulating and easy to understand data in a variety of ways and across multiple visualizations.

• Worked with Tableau Public as well as Adobe Premiere Pro to create an end product featuring graphics to aid in visualization of trends and presented this in front of peers. Environment: Tableau, Python, MS Excel, MySQL, and Adobe Premiere Pro 4

Research and Extracurriculars:

STATISTICAL CONSIDERATION OF EPIDEMIC DISEASE SPREAD MODEL Jan 2016 Research was conducted with Dr. Anthony DeLegge at Benedictine University (Lisle, IL) and was presented ISMAA (Illinois Section of the Mathematical Association of America). I worked one on one with Dr. DeLegge and was the main presenter of this model.

Responsibilities:

• Involved in conducting manual research and exploring said research through the use of pre-existing code and AS400.

• Creating Excel sheets with data collection and making charts as well as graphics to symbolize how an epidemic disease would spread in different models of thought over time.

• Presenting findings at ISMAA conference with the use of Adobe premiere pro. Environment: MS Excel, AS400, and Adobe Premiere Pro VOLUNTEER AT ADVOCATE GOOD SHEPHERD HOSPITAL July 2016 Good Shepherd Hospital (Barrington, IL) has phenomenal physicians and helpers such as myself who provide a comprehensive range of services to ensure quality and compassionate care to patients and communities in the northwest suburbs of Illinois.

Responsibilities:

• Spent over 265 hours volunteering for the community alongside completing my education 5

Contact this candidate