JAGRITI GOSWAMI
+1-949-***-**** ****************@*****.*** 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.