Ivan S Email & Phone Number

Duarte, Ca, Us

Woonsocket, Ri, Us

• Applied Machine Learning Algorithms and Statistical Modelling to generate customized datasets by extracting, transforming and summarizing from largely unstructured data using Python and SQL • Participated in features engineering such as feature intersection generating, feature normalize and label encoding with scikit-learn pre-processing • Performed Linear Regression, Logistic Regression, Decision Trees (CART), KNN, K-Means and Random Forest using python and R programming • Developing containment scripts for data reconciliation using SQL and Python • Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team • Performed Data Cleaning, features scaling, features engineering using pandas and numpy packages in python • Analysed different types of data to derive insights about relationships between locations, statistical measurements and qualitatively assess the data using R • Understand the data visualization requirements from the Business Users • Developed Power BI data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart • Responsible for Creating/maintaining complex sql queries, custom queries, views, and stored procedures.• Analyzed and validated data in partnership with business owners to identify trends and problem areas and propose improvement.

Moscow, Moscow City, Ru

• Analysed different types of data to derive insights about relationships between locations, statistical measurements and qualitatively assess the data using R • Performed Data Cleaning, features scaling, features engineering using pandas and NumPy packages in python • Performed Linear Regression, Logistic Regression, Decision Trees (CART), KNN, K-Means and Random Forest using python and R programming • Imported the customer data into Python using Panda libraries and performed various data analysis found patterns in data which helped in key decisions for the company • Worked on predictive analytics use-cases using Python language • Imported the claims data into Python using Panda libraries and performed various data • Developed predictive models using Python (Pandas, NumPy) to predict possibility of equipment failure • Implemented and followed Agile development methodology within the cross-functional team and acted as a liaison between the business user group and the technical team • Wrote, executed, performance tuned SQL queries for data analysis and profiling and wrote complex SQL queries using joins, and sub queries • Perform slicing and dicing of data using SQL and Excel for data cleaning and data preparation • Generated and published customized interactive reports, dashboards and scheduled reports using Tableau • Monitored, Triaged, Tracked and resolved issues with the Excel and Tableau reports • Prepared the data rules spreadsheets using MS Excel that would be used to update allowed values, findings and profiling results • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata • Interacted with business analysts to understand data requirements in order to give high-quality data to customers

• Programming online surveys using SurveyMonkey for companies such as Sberbank (the largest bank in Russia) and MTS (the largest telecom operator) • Wrote, executed, and performance-tuned SQL queries for data analysis • Working with different types of unstructured data • Generated customized interactive reports, dashboards, and scheduled reports using MS Excel, and PowerPoint. • Prepared the data rules spreadsheets using MS Excel • Create spreadsheet reports using Excel (Pivot Tables, VLOOKUP) • Converted charts into Crosstabs for further underlying data analysis in MS Excel

Master Of Science - Ms, Computer Science And Data Analytics

Bachelor'S Degree, Math And Computer Science