Resume

Sign in

Data Social Media

Location:
Boston, Massachusetts, United States
Posted:
August 25, 2018

Contact this candidate

Resume:

KSENIA KHLOPOTINA

Contacts: 617-***-**** ac6s6o@r.postjobfree.com

Location: South Boston, MA

EDUCATION

Computer Science and Math, UMASS Boston 2018

Calculus I; Data Structures and Algorithms in Java: Queues, Linked Lists, Heaps, Stacks, BSTs, Graph Theory

Data Science, University of Toronto, St. George 2017 - 2018

Certificate: Statistics; Big Data Systems; Hands-On Machine Learning with Scikit-Learn and TensorFlow

Data Science, John Hopkins University: Data Science Fundamentals, R Programming, Predictive Modeling;

Data Science, University of Michigan: Intro to Data Science in Python

Web Development Bootcamp, BrainStation (JavaScript, jQuery, Angular JS, HTML5, CSS3) 2015

Computer Science, Computer Programming, Quincy College, MA, USA 2013 - 2015

Associate’s Degree, GPA = 3.89/4 Information Technology Management, Cambridge College, MA, USA 2010 - 2013

Master’s Degree, MBA, GPA = 3.91/4

COMPETENCIES

Python Data Analysis: Analytic Techniques for Data Manipulation, Machine Learning in Jupiter Notebooks with Scikit-Learn and TensorFlow;

Big Data Systems: Scala, Apache Spark, Hadoop, MongoDB;

Statistical Modeling using Python: Linear, Logistic Regression, Naïve Bayes, Hypothesis Testing, Classification, Predictive Modeling, PCA Analysis

Projects: Python, Java, Unix/Linux shell scripting, R - in MS Visual Studio, R Studio, Jupiter Notebooks environments

Data Analytics: Tableau, R (Exploratory Data Analysis, Predictive Modeling), Python (Data Munging, Slicing, Grouping, Data Visualization, Data Cleaning, Processing, Conditional Selection, Merging in pandas, numpy, matplotlib, scipy)

Data Extraction, Manipulation, Presentation: MS Excel (VBA, Functions, Pivot Tables, Graphs, Charts and Histograms), MS Access 2008/2012 Reports, Forms, Queries

Classification, Model Building and Model Evaluation: TensorFlow and Scikit-Learn libraries

Databases and Data Management: advanced querying using SQL, MS SQL Server 2012, FTP Server, Adobe Dreamweaver 7

Reporting Solutions: MS SSRS, Crystal Reports 10, Tableau

Web Development:, HTML5, CSS3, JavaScript, jQuery, AngularJS, Bootstrap, Grunt, Gulp, Joomla (Content MS)

Web Analytics: Google Analytics

PROFESSIONAL EXPERIENCE

Jan 2018 – relocation back perm to the US. Spring ’18 semester of studies to prepare better for job market. June ‘18 – started job search for full-time work, studies will be finished online only.

Business Systems Analyst Cosmetica Laboratories Toronto, Canada May 2017 – January 2018

Mined the sought-out data using SQL queries in MS SQL Server 2012, MS Access and Excel; pulled data in and out of applications and server to procure data for specific requests with set parameters; reconciled data discrepancies in formats between large datasets of historic and current data

Created macros, advanced functions in MS Excel; wrote Microsoft Access 2010 macros, forms and queries, verified data mappings in Infor Visual 10 ERP (visualization software on business-user end) for extracting Business Intelligence information per questions posed by functional units of the organization

Created enterprise-scale business reports in SSRS (using MS Visual Studio 2010) and Crystal Reports 10 reporting solutions using data segmentation, aggregation techniques: grouping and sorting criteria on reports for Sharepoint to provide access to key business data through interactive, dynamic reports

Wrote automation scripts in Automate 10 app using native command language of the application and VBA to implement custom procedures to run on MS SQL Server

Performed Admin duties for setting up company’s documentation structure on Smartsheet.com web app; created and set up user security groups with privileges and access rights

Worked cross-functionally among Accounting, IT and DevOps units, iterating weekly over current projects, analyzing required functionality, data formats, mass updating ways; then tested heavily throughout development in use cases; provided step-by-step guidance in user acceptance on release

Developed technical documentation to capture full scope of new functionality

Web and Database Project Analyst TCET Toronto, Canada April 2016 – May 2017

Created and ran ad-hoc queries to procure targeted data insights that are thorough and accurate, from multiple disjoint tables in database; performed data reconciliation and cleansing – to present quantitative info for business-valued decisions and data insights

Performed BI Analytics and quantified business performance indicators based on threshold metrics through mining historic data in MS SQL Server; analyzed large data sets given specific criteria and areas of interest; presented data relationships using MS Excel data analysis and graphical presentation functionality

Strategically planned and produced digital content for company’s website, print and email campaign collateral considering UX design principles; administered web presentation using HTML, CSS, JavaScript; transferred digital content into requested formats; modified back-end source code

Coordinated software dev. projects: business requirements gathering from clients, translating them to the team and gauging time estimates per task, allocated work resources to fit in the goal schedule and objectives, developed use cases, held team meetings in agile and module-based software development framework

Assisted users of organization-wide CRM web application (ASP.NET) with MS SQL Server back end, with system navigation as well as data discrepancies resolution

Waiting Period to get Work Authorization in Canada

Business Intelligence Report Developer Laboure College Milton, US, MA September 2014 – May 2015

(2 semesters of internship)

Designed and developed Business Intelligence reporting solutions for analyzing institutional data in SQL database in dynamic reports (triggered by user-provided criteria) to create data-driven analytical products for making business intelligence decisions

Applied understanding of relational database concepts, query language and data warehouse methodologies for proper analysis of structure of college's student information system database and improving strategies of retrieving meaningful information about data

Data Administrator TripAdvisor Newton, MA, US September 2013 - March 2014

(Strictly Temp, Contract)

Carried out data audits to ensure data quality and integrity across massive amounts of data in online repository for restaurants, accommodations and recreational sites; investigated and resolved data discrepancies and redundancy, formatted data for accuracy and absence of duplicates

Researched and procured additional listing objects from social media and venue-listing websites

IT Team Lead/Business Developer Steelgate Technologies Boston, MA, US June 2012 - July 2013

Led team of programmers on daily basis on functional and navigation-related improvements to company’s website (in Jira) to boost website traffic and increase business retention

Created marketing collateral; launched email campaigns and acquired new accounts through sales presentations and underlining of product key features and distinctions with competition



Contact this candidate