Iuliia Kepley
619-***-**** ******.******@*****.***
La Mesa, 91942
Applying for position “Data Analyst”
SUMMARY OF QUALIFICATIONS
* Background in marketing research and database (9-year experience with qualitative and quantitative research methods, statistical analysis)
* Additional experience as Software Quality Assurance Specialist
* Strong analytical (mathematical), problem solving, decision-making skills with ability to manage activities in a fast paced team environment (multi-task, deadlines)
* Strong foundation in computer science: TCP/IP Networking, Virtualization, Server Security
* Familiar with HTML, PHP, CSS, ASP.Net
* Ability to work effectively within a team and/ or independently
* Language skills: English, Russian, Ukrainian
TRAINING IN COMPUTER TECHNOLOGY
Web Server Maintenance and Security, 2014
San Diego Continuing Education, North City Campus
* Configuring, administering, and maintaining Windows servers.
* Installing, configuring, and securing networks (TCP/IP Network).
* Creating and managing Virtual Machines.
* Configuring, administering, and maintaining Linux OS as Server Platform.
* SQL Server and ASP.net and MySQL and PHP
* ASP.Net using MS Visual Basic
Software QA Training, 2012
* Creating and implementing an effective software testing strategy (testing cycle).
* Practicing a wide array of testing techniques, and examining test development models such as Agile and Waterfall.
* Exploring software testing processes within a variety of industries contexts, and studying practices applicable to cloud, mobile and Web environments.
Database Systems, 2009
* Installing and configuring MySQL server and clients.
* Designing efficient databases.
* Using Structured Query Language (SQL) to build databases and queries data.
* Evaluating data types and character sets for performance issues.
* Performing backup and restore operations.
TECHNICAL PROFICIENCIES
Windows 7/8
VMWare
MySQL/XAMPP
Selenium IDE
Windows Server
MS Office
Linux Server
SQL Server 2008 R2
SPSS
Markdata Media Workstation
Visual Studio (ASP.NET)
RELEVANT EXPERIENCE & ACCOMPLISHMENTS
Database Analysis related
* Using Structured Query Language (SQL) to build databases and related tables.
* Implementing procedures to ensure accurate and efficient collection and entry of data into RDBMS.
* Implementing “end to end” validation of data, processes, and queries used within given assignments.
* Optimizing databases for better performance by using functions and procedures.
* Defining and implementing technical requirements for extracting data from RDBMS.
* Appling advanced modeling and statistical analysis against large scale datasets.
* Manipulating data through MS applications in order to create reports (by merging data and other data mining tools).
* Maintaining database backup system
* Experience with Big Data: Markdata Media Workstation (special software/database for media research) for measuring TV audience, identifying trends, consumer behavior and for analyzing media preferences.
* Configuring SQL Server instance to be remotely accessible over TCP/IP.
Marketing Researching related
* Designing and preparing survey’s methodology and materials: questionnaires, instructions, and characteristics of the sample.
* Analyzing target intended demographics; established benchmarks, goals, and corrective measures.
* Preparing databases in Excel and SPSS (Statistical Software Package) by cleaning, checking, coding, and merging data for analyses.
* Conducting statistical analysis using various analytic techniques and software SPSS (correlation, regression, factor, cluster, conjoint analyses, indexes).
* Analyzing and interpreting data; synthesized information from a variety of sources and translated into effective and actionable reports (creating graphs, tables and charts).
Software Quality Assurance related
* According to testing procedure performing ad hoc, functionality, networking, GUI, usability, performance and regression testing in QA and production environments.
* Appling ‘Unit Test’ based upon knowledge HTML, PHP, CSS, ASP.Net
* Performing manual black box testing from Beta, Pilot, RC to the final release
* Creating, executing test cases for the application modules
* Analyzing software failures, reported issues to Bug Reporting System, Bugzilla
* Providing report status of assigned project, including daily updates, bugs, scheduling and overall quality assessment
* Mobile testing: Validated UI flows, dialogs, and user interactions, including proper local language, currency, time zone (date and time format), cross-platform testing.
* Appling automation / regression testing by using Selenium IDE
* Experience with Agile methodology
EMPLOYMENT HISTORY
Software QA Specialist Crimson IT 2012-2014
Database Analyst GFK Ukraine 2009-2011
Marketing Research Analyst Taylor Nelson Sofres Ukraine 2004-2008
EDUCATION:
Master’s degree of Sociology, Statistical Analysis, Kharkiv National University, Ukraine
(Diplomas were evaluated by World Education Services (WES) New York, NY)