Smit Mehta

adhaca@r.postjobfree.com • 646-***-**** • GitHub • LinkedIn • Tableau • Secaucus, NJ 07094

Summary

2+ years of Experience as Data Analyst with functional and industry experience with accomplished process and project responsibility such as Data analysis, design, development, quality assurance, user acceptance & performance management. Experience in Data Analysis, Data Cleansing, Data Modeling, Data Validation, Report Creation, User Acceptance Testing and ETL process. Skilled in writing SQL queries to validate data movement between different layers in data warehouse environment. Experience of using Python libraries and creating visualization dashboards in Excel, Tableau and Power BI.

Skills

Tools Tableau, Rattle, Gephi, Oracle Crystal Ball, Canopy, Spyder, MySQL Programming C, Python, R, SQL

Data Database Design & Management, Data Quality Assessment, Data Analysis, Data visualization Education

Master’s of Engineering, Management at Stevens Institute of Technology, GPA: 3.53 Transcript May 2019 Bachelor's in Electronics and Communication at Charusat University, GPA: 3.5 May 2016 Experience

Business Intelligence Analyst at City Of San Antonio, Texas VBA, Excel, Power BI Sept. 2019 – May 2020

• ETL process to reconcile three systems (SAP, Accela and POS) using VBA and Python tool.

• Extracting Data from SQL, Cleaning and Transferring into Excel.

• Creating Info Graph using Power BI and Excel.

• Built and evaluated different models in Python using Pandas and Sci-kit learn to find patterns in data which helped in key decisions for the company.

• Perform Data Validation, Data Verification and Data Mismatch Identification on the data stored in data- warehouse in Excel using VLOOKUP and reference functions.

• Designed Excel Pivot tables and V-Lookup tables to analyze large data.

• Extensively used Python's multiple packages like Pandas and NumPy for data cleaning. Data Analyst Intern at Health Concept LLC, New Jersey Tableau, Excel Oct. 2018 – Dec. 18

• Extracted reports for analysis and presentation in visual form using Tableau and Excel.

• Visualized trends by querying customer review data using Python Pandas.

• Create visually impactful dashboards in Excel using Pivot tables and Tableau for data reporting helping revenue team identify opportunities to maximize revenue growth. Embedded Systems Engineer at Prompt Softech, India C, MATLAB, Proteus, 8051 PIC Jan. 2015 – Feb. 2017

• Designed and developed an embedded system to maintain and control temperature of Peltier Cell.

• Analyzed data and properties of different Peltier cells to predict thermoelectric effect. Projects

Data Visualization of Citi Bikes Presentation Tableau R, Tableau, Excel Fall 2018

• Performed Visualization on the dataset using Tableau to show Variation in User Activity. Data Analysis of Pima Indian Diabetes Presentation Rattle, R, Excel Spring 2018

• Utilized Rattle to assess the relation between diabetes and other medical conditions like pregnancy, blood pressure, body mass index, and age.

Milk Production Data Analysis GitHub Presentation Python (Pandas, NumPy), Excel Fall 2017

• Analyzed Milk Production Data of a village in India using Python. Text Mining on Airbnb’s Customer Reviews Presentation Gephi, Rattle, Excel Spring 2018

• Performed network and text analysis on a file representing 100000 reviews. Web Scrapping on Movie Reviews from Rotten Tomatoes GitHub Python Fall 2017

• Scraping movie reviews from rotten tomatoes and text analyzing reviews using Python. Certifications

Data Exploration and Visualization for Risk and Decision Making Certificate May 2019 Intro to Python for Data Science on Data Camp Certificate Fall 2017 Joining Data in SQL Certificate June 2019

• Review vendor MSA’s, Contracts and SOW’s for summarization and analysis

• Support financial team with financial analysis, PO processes and ensure vendor leases/purchases are correct tracked in support IT and Ariba systems.

• Research vendor contracts and provide key contact deliverables including Operational and Financial measures (to include in vendor scorecards and overviews) 483526