Data Analyst

NIDHI GOYAL

Jersey City, NJ 201-***-**** *****.**@************.*** https://www.linkedin.com/in/nidhi91 Education

Northeastern University, Boston, MA

Master of Science in Information Systems Expected July 2021 Relevant Courses: Data Architectures for BI, Data Science Engineering Methods & Tools, Database Management & Design National Institute of Technology (NIT), Raipur, CG, India Bachelor of Technology in Biotechnology Engineering May 2014 Relevant Courses: Database Management System, Biostatistics and Probability Technical Skills

• Programming Languages: Python, R, Java

• Database: MySQL, MS SQL, Oracle, PostgreSQL, SQLite

• Data Modelling: ER/Studio Data Architect, MS Visio

• Data Integration: ETL, Talend, Alteryx

• BI Tools: Tableau, TIBCO Spotfire, Power BI, Qlik Sense

• Data Science Libraries: NumPy, Pandas, SciPy, Scikit-learn

• IDE: NetBeans, Eclipse, Visual Studio

• Version Control: Git, Bitbucket

• SDLC: Agile and Waterfall

• AWS: EC2, S3, IAM, Athena, Glue

• Tools: UML, MS Project, Excel, Office,

Google Analytics, Balsamiq, JIRA

Experience

Data Analyst Co-op, Pfizer, New Jersey - Remote Aug 2020 – Present

• Added new data view for equipment in the existing Data Mart to allow for easy management of manufacturing data and provide real-time data in a centralized location

• Enhanced existing dashboards by adding features like real-time Equipment Tooling & Manufacturing Status that provide insights into equipment availability and maintenance

• Built Spotfire automation services job for receiving weekly or monthly reports for project schedule and QTS (Quality Tracking System) to help maintain timeliness and quality

• Worked on Integration of MS SQL Server data, Clementine data, and Processing data for streamlining GMP production data

• Created multiple interactive dashboards in Spotfire using Data on Demand feature, thereby loading only use case specific data

• Added landing pages, bookmarks, and navigation steps in Spotfire dashboards to guide cross-team users for usage

• Gathered business requirements for creating a Data Warehouse for the Drug Product Supply Group, performed Fit Gap Analysis, and created FRD (functional requirement document) Business Analyst, iDreamBiz, Noida, India Aug 2014 – Dec 2017

• Lead the client interaction to understand and translate requirements into deliverables like functional specifications, workflow, and data model diagrams to align with development teams

• Rode Process Documentation and performed Fit GAP Analysis (As-Is and To-Be process study)

• Designed project plan with MS project and managed the development of MVP using agile methodology

• Facilitated the QA process lifecycle for integration, User Acceptance Testing (UAT), and regression testing

• Assisted in documenting User Manual and mentor new hires Academic Projects

Retail Data warehouse (Talend, Tableau) Feb 2020 – Apr 2020

• Designed a data warehouse for Brazilian eCommerce by extracting data from different sources and using Kimball data warehouse methodology

• Inspected & cleansed data using Talend Data Quality tool

• Planned ETL workflows using Talend to further integrate metadata into staging area and created dimension and facts tables

• Created Tableau dashboards and stories to visualize KPI’s related to customer, sales, product and seller COVID-19 Twitter Sentiment Analysis (Python) Apr 2020

• Built a classification model to predict sentiments for COVID related tweets as positive/negative/neutral

• Extracted data using Twitter API and performed data cleaning using nltk

• Improved the model accuracy by using feature extraction techniques like bag of words (BOW), TF-IDF vectorizer

• Visualized sentiment distribution for most common entities using Named Entity Recognition Medico - Medical Image Identification (MySQL, Python) Sept 2019 – Dec 2019

• Created a database application for the identification of medical images based on image type and body part

• Built a machine learning classification model using the Convolutional Neural Network algorithm

• Extracted text from the images to analyze them by using OpenCV's EAST deep learning model Mindspace - Mental Health Care System (Java, Swing) Sept 2019 – Dec 2019

• Developed an application for the user to take MCQ tests to make effective recommendations to the doctors

• Designed an ecosystem using OOP design principles and used work queues to send requests between various stakeholders

• Used Open Source Object Database Db40 to store patient details, employee information, prescriptions and NGO events

Contact this candidate