VIKAS SONI (Work Status - Permanent Resident)

Phone No. 314-***-****, 18432 Tapestry Lake Cir Apt. 204, Lutz / Tampa, FL 33548, www.linkedin.com/in/vikassoni01 adb02b@r.postjobfree.com

PROFESSIONAL A data scientist and engineer SUMMARY! experienced in machine learning, statistical modeling, big data engineering, data analy- sis, data visualization and reporting using R, Python, Spark, SQL, SAS, AWS, Excel, and Tableau within several areas including consumer behavior, media, healthcare, sales/marketing, engineering, manufacturing, research and technology. I am experienced in working with large data sets and interpreting as well as communicating insights and findings from analysis to a technical and non-technical audience. I enjoy applying my strong quantitative and analyti- cal T ECHNICAL skills in solving SKILLS! complex business problems. W ORK W ellCare, EXPERIENCE Tampa! !

• Data Worked Scientist on Data (October engineering, 2019 - Present)ETL, forecasting ! and reporting/dashboarding of Healthcare data (Member health records, claims data, Medicaid and Medicare data) using Python, SAS, R, SQL, Tableau.

• Used tools and technologies SAS Enterprise Guide, Jupyter Notebook, Microsoft SQL Server, R studio for data extraction, data cleaning, data manipulation, machine learning and reporting.

• Applied Bayesian Time Series Models like Unobserved Components Models and ARIMA for forecasting the HEDIS STAR measures.

• Worked on clustering analysis of members to support markets target the compliance rate and improve star rat- ings.

• Built Dashboards and reports on using advanced Tableau techniques such as Level-of-Detail expressions, ac- tions, navigation techniques, parameter control, context filters etc. Utilized Tableau server to publish the reports and shared them with different stakeholder.

Programming Skills PySpark, Spark SQL, R, Python, SAS Packages Pandas, Numpy, Matplotlib, Seaborn, Scikit-learn, SciPy, MLlib, Ggplot2, Dplyr, Tidyr, Forecast

Reporting/Data Visualization Tableau, Spotfire, Excel Database MDL (Media Data Lake), Microsoft SQL Server, Greenplum, Oracle SQL, MySQL, PostgreSQL, InfluxDB, Netezza

Tools Databricks,, Tableau Server, SSIS, SSRS, Google Analytics, R-Stu- dio, Jupyter Notebook, SAS Enterprise Guide, Mathematica, MAT- LAB/Simulink, Microsoft Office, GitHub, Origin, Sparx Systems En- terprise Architecture, NetSuite ERP

Big Data and Cloud Apache Hadoop, Spark, Hive, Hue, AWS EMR, AWS S3 Bucket, AWS EC2, Parquet, ORC, Apache Airflow, Ganglia, YARN, Zeppelin, Machine Learning Regression Analysis, Time Series Forecasting (ARIMA), Random Forests, Support Vector Machines, K-Means Clustering, Decision Trees, Principal Component Analysis (PCA), Logistic Regression, K-Nearest Neighbor, Natural Language Processing, Naive Bayes, Deep Neural Networks

Statistical Modeling Bayesian Methods, Normal Distribution, Multivariate Regression Models, Analysis of Variance (ANOVA), Hypothesis Testing, A/B Testing Operating Systems Windows, Mac–OS, Linux

Project Management Atlassian (Jira, Confluence), Redmine VIKAS SONI (Work Status - Permanent Resident)

Phone No. 314-***-****, 18432 Tapestry Lake Cir Apt. 204, Lutz / Tampa, FL 33548, www.linkedin.com/in/vikassoni01 adb02b@r.postjobfree.com

• Explored SAS Viya implementation on Amazon Web Services (AWS) cloud.

Nielsen, Tampa!

• Data Built Scientist data pipelines (September for custom 2018 - reports September for various 2019)! clients.!

• Leveraged Big Data tools and technologies Hadoop, Hive, PySpark, Spark SQL, Databricks, Data Lake, Apache Airflow, and AWS ecosystem for building data pipelines and data validation.

• Worked on the analysis of numerical ratings.

• Worked on a project to convert legacy SAS code to Python

• Analyzed/visualized the trends of the ratings using using advanced LOD expressions, table calculations, parame- ters and visualizations in Tableau. Shared analysis and findings with various stakeholders using Tableau server.

• Performed responsibilities of Tableau Admin (Server installation/upgrade on AWS EC2, performance measure- ment, user management, permissions, backup and server maintenance).

• Delivered customer feature reports to different stakeholders.

• O penDEM Created different (Amzur clusters Energy for Services)various usage., Amzur Extensively Technologies used AWS Inc.S3, and Tampa AWS ! EC2.

• Systems Created Engineer building and load Data profile Analyst models (July using 2015-regression August 2018)and ! ARIMA analysis of energy data in R for the customer sites of OpenDEM. This involved data collection, data cleaning, data analyzing, and demand forecasting.!

• Applied machine learning algorithms and statistical modeling for solar forecasting in R, Python and SAS.

• Developed OpenDEM energy digital dashboards and created metrics for monitoring and controlling energy re- sources based on analyzed energy data stored in Microsoft SQL Server and MySQL server from customer sites. Used SQL for manipulation and extraction of data. Helped customers save up to 20% of their energy cost.!

• Presented findings and made recommendations based on customer consumption behavior to sales team and utility companies/customers. Used Tableau and Excel for automation, report and dashboard creation.

• Provided technical and analytical inputs to OpenDEM marketing/sales team for grants proposal submitted to na- tional labs, universities, department of energy, and swedish energy agency. OpenDEM secured about $1 million of funding from the above organizations.

• Worked on UML and XML schema development for Orange Button: Open solar data exchange initiative of Sun- spec W ashington Alliance University and Department in St. of Louis/Energy.Argonne National Laboratory, St. Louis/Chicago!

• Research Worked as Assistant an experimental (May 2014- physicist May 2015)and ! data analyst in superconductivity and magnetism laboratory.

• Measured the magnetic ordering of Dy from XMCD (X-ray magnetic circular dichroism) signal amplitude at different pressures. Plotted hysteresis and XANES (X-ray absorption near edge spectroscopy) curves.!

• Studied magnetic ordering at anomalously high temperature in Nd metal under extreme compression. Presented paper in APS (American Physical Society) meeting (Link).!

• Bharat Used Python, Heavy Microsoft Electricals Excel, Limited, Origin Bhopal for data analysis and plotting curves from above experiments.

• Design Analyzed Engineer design (July data 2009 and - finalized May 2012)optimized ! design of transformers.

• Wrote macros in visual basic for applications for automating product price estimation and generating bill of ma- terials.!

• Conducted analysis for promoting sales and maximizing profit. Worked with formulas, pivot tables and functions.

• Worked towards securing customer orders worth $20 million.

• Performed root cause analysis of product failures. Documented and reported relevant metrics using Excel and MS Word.!

VIKAS SONI (Work Status - Permanent Resident)

Phone No. 314-***-****, 18432 Tapestry Lake Cir Apt. 204, Lutz / Tampa, FL 33548, www.linkedin.com/in/vikassoni01 A CADEMIC R ealistic Scattering PROJECTS Cross Section ! and Resonances vikassoni.mnnit@Project gmail.on com Mathematica !

• Calculated the realistic scattering cross section for a given complex potential using the spherical Bessel and Neu- mann functions on Mathematica.

Adaptive Echo Cancellation using Normalized Least Mean Square (NLMS) Algorithm !

• This project involved echo cancellation of signals by means of an adaptive equalizer. The mathematical model was E DUCATION! developed on MATLAB and implemented on digital signal processing (TMS320C6711 development) kit. ! Master’s (Physics) GPA = 3.68/4.0

Washington University in St. Louis 2015!

Bachelor of Technology (Electronics & Communication) GPA = 8.77/10 Motilal C ertification Nehru (National Data Science Institute Specialization)of Technology ! (MNNIT), India 2009! Johns R ELEVANT A dvanced Hopkins google COURSES! University analytics, 2019! Practical machine learning, Statistical inference, Computer based numerical and statisti- cal techniques, Python for data science and machine learning, Computer programming, Data structure and program design, A WARDS! • University Statistical fellowship mechanics.from Washington University in St. Louis.

• Teaching assistantship for undergraduate electronics laboratory at Washington University in St. Louis.

• Grant from Carnegie/Department of energy alliance center (CDAC) for XMCD measurement on Dysprosium (Dy) and Data Analysis at the Advanced Photon Source (APS), Argonne National Laboratory.

Contact this candidate