JAGRITI GOSWAMI

+1-949-***-**** adklwr@r.postjobfree.com http://www.linkedin.com/in/jagritig

Certified Data Science Professional with 7+ years of total professional and hands-on experience in Python, SQL, Data Analytics, and Visualization, with 3+ years in teaching Electrical and Computer Engineering. TECHNICAL SKILLS

Languages: Python, SQL

Databases: MySQL, MSSQL, SQLite, PostgreSQL, IBM DB2, MongoDB Analytical Tools: Tableau, Python Pandas, NumPy, SciPy, Scikit-Learn Visualization Tools: Tableau, Matplotlib, Seaborn, Plotly, Folium Software IDEs: PyCharm, Jupyter Notebook, Anaconda, Eclipse, Git DB-API & Others: MySQL Connector, sqlite3, SQLAlchemy (ORM/Dialect); APIs, Google Sheet EDUCATION

M.Tech, Electrical Engineering NERIST, India Jul 2013-May 2015 B.E., Electrical Engineering National Institute of Technology, Agartala, India Aug 2003-May 2007 CERTIFICATES

IBM Data Science Professional Certificate

Credential ID: coursera.org/verify/professional-cert/2GLHSFSE7JJQ Feb 2021

EXPERIENCE

Python Developer

Freelance, Client - Hive Collective Inc.

Jan 2021

• Implemented custom SQLAlchemy dialect to perform insert, update, and delete operation in Google Spreadsheets (Python 3).

Software Programmer and TA, EE Lab, NERIST, India Aug 2014-May 2015

• Wrote python scripts to collect, clean, and integrate large Power network data into MySQL database. Performed Statistical analysis and visualization on Power network data. Assistant Professor, Global Institute of Technology, Jaipur, India Jan 2011-May 2012

• Taught Electrical and Computer Engineering to undergraduate students.

• Led and guided multiple software development project & execution of under graduate students Lecturer, Poornima Institute of Engineering and Technology, Jaipur, India Mar 2009-Dec 2010

• Taught Electrical and Computer Engineering to undergraduate students.

• Conducted several lab experiments of undergraduate students TECHNICAL PROJECTS

Freelance, self-employed

• Developed a neighborhood Clustering model using K-means clustering algorithm to select an optimal location for opening up a new business. This project includes data acquisition, analysis, machine learning, and map visualization using Foursquare API, Geopy, Folium, Pandas, NumPy, Scipy, Scikit-learn, Seaborn, Matplotlib, Plotly). [GitHub, PDF] Feb 2021

• Implemented a data integration middleware DataMidWare in Python. It allows interaction with multiple data sources, databases, processing, and visualization tools using its APIs. It accelerates data science projects by reducing data collection and preparation time (approx. 70%-90%) to as little as 50%. [GitHub, PDF]

Oct 2020

• Implemented Python APIs to connect with Relational Database (MySQL, MSSQL, PostgreSQL) and NoSQL Database (MongoDB). [GitHub, PDF]

Feb 2020

• Implemented Python Visualization APIs (Matplotlib, Seaborn, & Plotly). [GitHub, PDF]

• Built Tableau reporting dashboards for product marketing KPI, sales insights, and forecasting. Nov 2019

ACADEMIC PROJECT

Smart Grid Data Pipeline Development, Data Analysis, and Visualization [PDF] Sept 2014 - May 2015

• Architected Smart Grid simulation and data analysis framework. (Python, Matlab, Simulink)

• Performed uncertainty analysis of power network using Monte Carlo simulation.

• Built Simple Linear Regression model to analyze the contribution of stochastic loads in the power network. Statistical Data Analysis using Matlab Jan 2014 - Apr 2014

• Evaluated sample data set using exploratory data analysis, normal distribution, histograms, correlation matrix, and scatter plot.

Contact this candidate