SUMMARY:
- Accomplished data wrangling tasks to transform and reshape layout of datasets to make data complete and tidier
- Learned to use various data mining techniques to identify anomalies within datasets and extract meaningful insights
- Provided informed marketing decisions from quantifying and visualizing Facebook’s users’ and diamonds datasets
- Implemented statistical techniques to summarize Facebook’s user’s dataset and provided recommendations
- Displayed solutions using R Markdown file which includes code, graphical charts, and analysis supporting investigations
- Extracted and loaded health, US census population, and cars - mpg datasets from web into csv format
- Applied python’s pandas package to cleanse and transform datasets, subset and manipulate data columns and rows
- Performed various computations using the “numpy” package to interpret data through using summary statistics
TECHNICAL & LANGUAGE SKILLS:
- Python, R, SQL, SAS, MS Excel, HTML, CSS, JavaScript
- Working knowledge in STATA, MATLAB, Java
- Microsoft proficiency Word, Outlook, Access, PowerPoint
- Fluent in English, Bengali, Hindi
WORK EXPERIENCE:
Data Quality Analyst
Confidential
Responsibilities:
- Supported Confidential on a data quality project to provide systems continuity within Confidential division
- Worked with Confidential officers to identify and perform root cause analysis on data entry errors frequently experienced by inspectors
- Used SQL Server to manipulate data and apply database profiling techniques to detect data quality issues displayed in frontend
- Performed data mining using R, and generated graphical reports to deliver statistical summary analysis in monthly catalog
Data Specialist (Intern)
Confidential
Responsibilities:
- Supported Customer Success team to enhance internal donor management system through data import related operations
- Transformed legacy data into a standardized format to ensure smooth import of customers’ data files into the Confidential ’s donor management system
- Implemented data file mapping, transformation and loading processes for new donor management customers
- Deployed data into test and production environments by using SQL and Confidential ’s internal data importing tools
Research Assistant
Confidential
Responsibilities:
- Consolidated multiple tables from pension and tax return database to extract insights to support Confidential
- Used python, Excel, and STATA to cleanse, transform, and manipulate data to make datasets complete and tidier
- Implemented various algorithms to match data points within pension and tax return datasets
- Wrote SQL queries to validate data, maintain data integrity for various tables, and check for anomalies
- Examined confidential “5500 tax” documents from Confidential website to ensure data is accurate
- Presented research and analysis to project manager and senior economists, provided data solutions and recommendations
Data Collection & Survey Design Intern
Confidential
Responsibilities:
- Worked in a large group to measure and record door openings, checked door swings, and identified any obstructions
- Collected data from surveying water coolers and door handles, and made adjustments to comply with American Disability Act
- Integrated data to analyze business metrics using Excel, and provided optimal solutions on reducing material cost
