
Vishal Mishra
- Sr. Data Analyst
- Dayton, OH
- Member Since Mar 24, 2023
Vishal Mishra
SUMMARY:
Having 3.5 years of total experience including 3+ years of relevant I.T experience in Data Science, Data Analytics and Big Data as well as 6 months of experience in application development
· Having proficiency in Deep Learning Techniques like Convolutional Neural Network(CNN), Recurrent Neural Network(RNN) and Special Case of RNN such as Long Term Short Memory(LSTM), Gated Recurrent Unit (GRN).
· Currently working as Sr. Data Analytics Consultants
· Skilled in Statistical Techniques, Predictive Modeling and Machine Learning to create new scalable models for business requirements.
· Experience in Wrangling, manipulating, cleansing, and processing data using Excel, SQL/PLSQL, R and Python
· Proficient on performing Data Analytics using Excel, SQL/PLSQL, R and Python
· Skilled on developing Regression, Classification, Decision Trees and Ensemble models using R.
· Hands on experience in Recommending Systems, Pattern Recognition and Time Series Modeling.
· Basic knowledge on developing models using SAS.
· Basic knowledge on handling Big-Data using Hadoop, Hive, Pig, Hbase, Sqoop, Flume, Oozie, Spark and Scala.
· Skilled in creating Databases, Tables and performing CRUD operations on Greenplum DB.
· Proficient in RDBMS and very good hands on experience on DB systems like Oracle &MySql.
· Experience of performing ETL/ELT transactions using Informatica 9.1 and Greenplum DB
· Good knowledge on Data Warehousing concepts
· Expert in Analyzing raw data, drawing conclusions & developing recommendations
· Excellent customer management/resolution, problem solving and debugging skills with good verbal/written communications and presentation skills
· Got extensive experience in Agile Methodologies and involved in requirements gathering, designing business use cases, building end user reports, deriving metrics and analysis from the Business Data
· Worked in different domains like Insurance, Health care
PROFESSIONAL EXPERIENCE:
Caresource, Dayton, OH July 2017 – Present
Sr.Data Insight Analyst
Description: Providing analytics based solutions to different Insurance Businesses in order to predict/forecast the product in market and requirement of the rider’s needed add for existing products to meet the market demand with the help of historical data
Responsibilities:
● Building different predictive and forecasting models
● Finalizing the requirements and analyzing the In-scope and Out-scope for requirements
● Discussion on scope for implementation of Analytical models with Business users
● Collecting and transferring all data into Data Lake
● Writing SQL queries for performing CRUD operations on data from DB Server
● Perform Data Analytics using Excel, SQL and R
● Creating a model using R/Python for performing different Statistical Analysis on data.
Environment: SQL, PL/pgSQL, Greenplum DB, R, Python, MS-EXCEL
DARS (Data Analytics and Recommendation Systems),Cytel, IncMar 2015 – Jun 2017
Cambridge, MA
Data Engineer/Analyst
Description: This application is for analyzing customer's activity on client's e-commerce portal. Our model will identify different products that customers are visiting. Based on the product that customers are visiting, our model will give them recommendations for list of products that are related and also find the association rules.
Responsibilities:
● Analyzing the functional specs provided by the client and developing detailed solution design document with the Architect and the team
● Building item-item and user-user recommendation systems and recommending top k items to the user
● Analyzed the association and co-occurrences of buying behavior from a database of an e-commerce company
● Customer segmentation was done using k-means clustering
● Apriori Algorithm was used to address these customer clusters from which the sets of items which were greater than minimum support was found iteratively
● Using these frequent item sets based on confidence, Association rules were derived and were pruned according to need.
● A phase II, double-blind, randomized, multicenter, parallel group, active-controlled study comparing the safety and efficacy of (SPP100) in patients with essential hypertension
Environment:SQL, R, Python and Excel
TECHNICAL SKILLS:
Computer Languages & Systems: Python, R, Scala, Spark, MATLAB, C, C++, Java, Linux
Analytical Tools:Scikit-learn, SciPy, NumPy, Pandas, Matplotlib, Keras, Theano, TensorFlow, Lasagne, NLTK
Cloud Computing: Amazon AWS, Google Cloud Platform
Database & Web Technology: MongoDB, SQL Server 2012, MySQL, HTML, PHP, jQuery
Development Tools: Anaconda Spyder, Jupyter Notebook, Tableau
CERTIFICATION:
· Completed a certification, ‘Introduction to Big Data’ by UC, San Diego on Coursera
· Presented a lecture on Deep Learning architectures, viz. CNN and LSTM in the EECS5750 Machine Learning course at the request of the professor
· Certified Microsoft Technology Associate: ‘Database Administration Fundamentals’