Post Job Free

Resume

Sign in

Data Analyst Supply Chain

Location:
Boston, MA
Posted:
May 14, 2021

Contact this candidate

Resume:

ASHI CHATURVEDI

+1-617-***-**** linkedin.com/in/ashichaturvedi adme74@r.postjobfree.com Boston, MA EDUCATION

Northeastern University, Boston, MA Expected Jul 2021 College of Engineering, Master of Science in Data Analytics Engineering GPA: 3.76 Relevant Courses: Data Warehousing and Business Intelligence, Data management and Database design, Probability and Statistics, Data Mining, Computation and Visualization, Machine Learning, Operation Research IES IPS Academy, Indore, India Aug 2015-Jul 2019

Bachelor of Technology in Electronics and Communication Founder of Literary Club, Student of the year 2019, President of Lab Services PROFESSIONAL EXPERIENCE

Takeda, Boston, MA Aug 2020-Jan 2021

Data Scientist Co-op

• Led analyses to demarcate scope of 2 top prioritized programs by building data systems, pipelines and architecture

• Established methodology for data integration, analyses, and structure on large-scale unstructured data across teams

• Developed models and interpreted data by visualization and predictive analyses and generated Process Flow Diagrams using R studio, SQL, Tableau and PowerBI and used Salesforce for CRM and JIRA to update system analyses

• Applied computational and statistical methods to build algorithms, models and prototypes to derive insights

• Identified key information to inform complex decisions using multivariate analyses with PCA and statistical modeling; discovered clusters and statistical significance between groups for various combinations

• Built the data and reporting infrastructure from ground up using Tableau and SQL to provide real time insights into the product

• Strengthened development of strategy and alignment across sites (Japan, Boston) by analyzing the gaps and mending them

• Communicated model results to cross-functional teams over 100 members through presentations, and technical reports WebCraft IT, Indore, India

Assistant Data Analyst Jan 2018-May 2019

• Implemented ETL strategies for processing Customer Data on various Warehousing Projects

• Constructed workflow charts and gathered customer insights to study business functions and system capabilities

• Influenced stakeholders to support business projects and identified business opportunities using Salesforce

• Designed ETL data pipeline templates for populating data and constructed scripts to generate direct load and SSIS mappings

• Synthesized current business intelligence data to produce reports and presentations using tools like JIRA and Confluence

• Troubleshooted, fixed and reported bugs developed during data migration to Azure cloud environment TECHNICAL SKILLS

Programming Languages: SQL, R programming, Python, SAS Database Management: Oracle SQL, MySQL, PostgreSQL and MS SQL Server Data Integration: Talend, SSIS, Alteryx, ER/Studio Data Architect, Informatica Data Science: Machine Learning, Deep Learning, Neural Networks, Keras, Tenserflow, PyTorch, Dplyr, Time Series, Statistical Methods, Scikit-learn, Numpy, Pandas, Matplotlib, Rshiny, Jupyter, Hadoop, Spark, Azure, R Studio

AWS: Redshift, Quicksight, Athena, S3, Lamda, EC2

Data Visualization: Google Analytics, Power BI, Tableau, Qlik Sense, QlikView, Datawrapper, Flourish ACADEMIC PROJECTS

Stock Price Prediction using Machine Learning Northeastern University Aug 2020-Dec 2020

• Built a model to analyze company’s future profitability on the basis of current business environment and financial performance

• Predicted future stock price by using simple algorithms like averaging and linear regression and advanced technique like LSTM

• Enforced structural time series model using TensorFlow Probability for forecasting everyday closing stock price

• Computed point forecasts and predictive uncertainties in stock price; actual prices fell within 95% interval with 85% accuracy Data Integration and visualization for Student’s behavior Northeastern University Jan 2020-Apr 2020

• Devised a data warehouse from 5 different school districts data sources using Talend and SSIS

• Headed streamlining of data pipelines that automate flow and transformation of data between key systems

• Automated ETL processes, making it easier to wrangle data and reducing time by as much as 40%

• Developed several Tableau and Power BI dashboards following OLAP and Data Modelling concepts to prompt integrated dynamic data visualizations for student behavior analysis and finding Key Performance Indicators Supply Chain Prediction Database Northeastern University Aug 2019-Dec 2019

• Built ERD, Business rules and relationships between 10 entities with minimum 2 attributes to map end to end supply chain

• Created a database to maintain an inventory using stored procedures, triggers, functions, indexes, views and SQL scripts

• Enforced business rules applying constraints, predicted number of products to be produced and visualized results in Power BI



Contact this candidate