SHEFALI VAJRAMATTI

315-***-**** ac8je1@r.postjobfree.com https://www.linkedin.com/in/shefali-vajramatti/

EDUCATION:

MS in Information Management, School of Information Studies, Syracuse University, NY (GPA: 3.94) Aug 2017-May 2019

Certificate of Advanced Study in Data Science: Big Data Analytics, Machine Learning, Natural Language Processing, DBMS

B.E in Electronics and Communication Engineering, SJCE, India (GPA: 3.51) Aug 2013-May 2017

TECHNICAL SKILLS:

Programming Languages Operating Systems: R, Python, C, C++, Java, Windows 7/10, Linux

Database/Data Warehouse: Microsoft SQL Server (SSIS, SSRS, SSAS, ETL), MySQL, Access, Excel (VBA, Pivot Tables)

Machine Learning Algorithms/Libraries: Hadoop - MapReduce, Pandas, PySpark, Keras, Tensorflow, RNN, LSTM

BI tools/ Applications: Tableau, Alteryx, Google Analytics, MS Power BI, Anaconda, Github, MS Project, MATLAB, Blockchain (Ethereum DApps, Hyperledger), Visio, CAD

PROFESSIONAL EXPERIENCE:

National Grid, Syracuse Data Analyst Intern May 2018-Dec 2018

•Designed highly intuitive Tableau dashboards facilitating improved decision-making across 7 major strategic initiatives

•Built data pipelines using Alteryx, Python and SQL to automate data processing from IBM DB2 and Oracle databases

•Performed ad-hoc data analysis and reporting for tracking the department’s financial status and key performance metrics

•Developed an auto-updating Excel tool linking 36 critical reports to monitor the schedule exceptions of 120 employees

Light Work, Syracuse Business Technology Analyst Oct 2017-May 2018

•Migrated the data schema from Access onto a cloud-based database platform to revamp their process improvement strategies

•Customized forms and reports for the user-interface that increased the customer data maintenance efficiency by 75%

•Embedded frequently used queries that streamlined data-handling and provided 50% faster information retrieval capabilities

•Documented the project deliverables and trained the client on using the easily accessible and user-friendly online platform

ACADEMIC PROJECTS:

Natural Language Processing Generative Chatbot Aug 2018-Dec 2018

•Applied Keras tokenization, sequence padding and word vector transformation to create a structured dataset for analysis

•Developed a chatbot using LSTM, Seq to Seq and Attention Deep Learning algorithms that enhanced the chatbot functionalities

•Experimented with the attention layer and concluded to have 30 % better performance based on the chatbot evaluation metrics

Information Visualization Indian International Trade Poster Aug 2018-Dec 2018

•Analyzed India’s export and import data over the past 3 years to extract key findings and trends impacting the trade deficit

•Extracted the insights in R and designed visualizations in Adobe Illustrator to depict the current situation and potential markets

Machine Learning Prediction Model Basketball Tournament Prediction for 2018 Jan 2018-May 2018

•Performed data munging using Python to integrate and structure the historical tournament data for the past 20 years

•Applied feature engineering and correlation techniques that helped in extracting 8 important features for training the model

•Implemented Logistic Regression and Random Forest algorithms and developed a predictive model with 83% accuracy

Data Science R programming Net Promoter Score Enhancement for Hyatt Hotels Jan 2018-May 2018

•Cleaned 1.5 million hotel data records to detect anomalies and patterns that refined the data quality by 90%

•Programmed in R to derive statistical and actionable insights about the hotel’s global services and customer responses

•Determined key Net Promoter Score drivers based on algorithms to provide recommendations for leveraging the resources

Database Management System Grocery Store Search Engine Aug 2017-Dec 2017

•Designed and implemented a database system that performed advance search for finding local grocery stores and items

•Gathered required data and applied SQL to perform filtering operations and Access VBA to navigate through the application

System Analysis & Design Tourism System Aug 2017-Dec 2017

•Identified functional and non-functional requirements to develop a plan and design an architecture for a local tourism system

•Investigated the involved risks and devised appropriate mitigation plans by employing use-case and dataflow models

LEADERSHIP EXPERIENCE:

•Supervised and guided cross-functional teams during VEX robotics session as a part of National Grid’s summer trade camp

•Collaborated with a research team as an Assistant under Prof. Ingrid Erickson to study the evolving skills of ‘Digital Nomads’

•Organized an extempore event and designed posters using Adobe Photoshop for 2017 technical and cultural fests in India

Contact this candidate