Valeriy - Architecte SQL

Sphere Consulting Inc., Kiev, Ukraine 6/1/2008 – Present
Ukraine, Kiev, Vikentiya Khvoiki str, 18/14

PROJECT EXPERIENCE:
Project Manager, Technical Team Lead
BetterFeedback
Project overview: Performance Management, Continuous Feedback, Employee Engagement Software
Duties and responsibilities:
• Collaborate with Marketing, Product Management, R&D teams in identifying market trends, customer feedback and competitive landscape to define differentiating product features and develop product requirements.
• Translate business and functional requirements into technical approach, solution, and technical design specifications
• Estimate project workload and resource availability to create resource plans.
• Develop Project Plan and schedule for software development and delivery.
• Collaborate with software developers to implement product requirements and problem solve any issues that would impact scheduled delivery.
• Collaborate with BETA teams to identify potential testers based on end-user profiles.
• Manage product software release to internal teams and external vendors making sure that software with the appropriate quality and security is used for development and testing.
• Provide status updates and project progress reports to senior executives.
• Provide software release notes that showcase the true product capabilities to Marketing and Sales teams.
Technologies used: Ruby on Rails, JavaScript, CoffeeScript, Hanglebars.js, JST, Backbone.js, HTML5, CSS3, jQuery, jQuery UI.

Technical Team Lead
Sittercity 2.0
Project overview: social network designed to connect families, individuals and corporate employees with local in-home care
Duties and responsibilities:
• Supervised a distributed R&D team to successfully develop enterprise-level application and custom integration solutions, including major enhancements and interfaces, functions, and features.
• Provided technical guidance and expert opinion for the development team on the choice of tools and frameworks.
• Determined specifications, planned and developed complex and business-critical software solutions, utilizing appropriate standards and procedures as well as programming architectures for code reuse.
Technologies used: Ruby On Rails 3.2, Mysql, Elasticsearch, Mongo, Scrum, Jira.

Project Manager, Technical Team Lead
StyleUp.ru, StyleUp.ua
Project overview: Beauty industry related portal for searching and booking beauty salons that provide required services. Project was successfully deployed to production and currently is in process of advertising, SEO optimization, selling and support.
Duties and responsibilities:
• Responsible for prioritization, implementation, and analysis of customer-facing web project with an intense focus on driving conversion and customer loyalty.
• Managed Marketing, Sales and R&D teams, led testing and training efforts and established business processes.
• Held ultimate responsibility for project scope, timeline, budget and resource allocation.
• Oversaw Marketing, Sales and R&D teams in identifying market trends, customer feedback and competitive landscape to define differentiating product features and develop product requirements.
Technologies used: Ruby On Rails 3.1, JQuery, SASS, RSpec, PostgreSQL, Apache, Unicorn, NGinx; Scrum, Jira.

Technical Team Lead
Data mining project for pay day loan’s provider
Duties and responsibilities:
Extracting and loading data from credit report agencies for analysis. Source data did not have a well-formed structure (a set of XML documents) and it was the main technical challenge of the project. Non - SQL database (Mongo DB) was used to resolve this problem.
Technologies used: Ruby On Rails 3.0, JQuery, SASS, RSpec, Mongo DB, PostgreSQL, Apache.

Project Manager
Centralized clinical trial management system
Project overview:
Development of clinical trial management system with Electronic Data Capture. It was designed to handle multiple simultaneous trials by multiple companies. The User Interface for each trial can be completely configured by the trial’s administrator. One of the main project requirements is HIPAA compliance, so strong security and auditing sub modules were required.

Duties and Responsibilities:
Project management; high-level architecture; functional design. Acceptance tests implementation.
Technologies used: Ruby On Rails 2.3, MySQL, JQuery, RSspec, Apache, Passenger; Pivotal Tracker, Story Mapper for Pivotal tracker.

Technical Team Lead
Pay Card Loans Application
Duties and Responsibilities:
• Managed an agile offshore team implementing sophisticated accounting logic.
• Worked with online bank transactions that required careful testing and following up with constant legislative changes on state and federal levels.
• Communication with the customer’s representatives, organize development & quality assurance processes, code review, design application modules.
Technologies used: Ruby On Rails 2.2, Postgres 8.2/8.3, RSpec, Selenium.

Technical Team Lead
Payday Loan Accounting Project
Duties and Responsibilities:
• Managed an agile offshore team implementing sophisticated accounting logic.
• Worked with online bank transactions that required careful testing and following up with constant legislative changes on state and federal levels.
• Led a team of four developers and two QAs. Application modules design & implementation.
Technologies used: Ruby on Rails 1.2, PostgreSQL, internally-developed accounting modules and REST services.

Senior Developer
Aginity IPSOS – Salto Data Loading
Duties and Responsibilities:
Application design and development:
The goals of this project were to provide ASI users worldwide with new global systems that:
1. Provide access to advertising test data currently supported via a number of separate applications and databases including, the NA NORMs database, the Selector production application (NA), MEE (Europe), and others in Latin America and Asia Pacific.
2. Create consistency by creating standardized data classifications that are aligned with ASI product definitions.
3. Include new improved tools that deliver more efficient, consistent and faster processing of modeled measures worldwide.
4. Enable client facing teams to deliver extracts to external clients that can include the following features:
- Global ad test results for client.
- Global ad test results analysis and summary products - by client, brand, product type.
- Analysis and summary products based upon standard global data value classifications.
Technologies used: .NET Framework 2.0, C#, MS SQL, BCP

Lana Pro, Kharkov, Ukraine 9/1/2003 – 5/31/2008
Ukraine, Kharkiv, Pushkinskaya str. 32, +38 (057) 752-53-03

Technical Team Lead
Duties and Responsibilities:
Involved in developing of a large order management system – Corrigo Worktrack. As a leader of two teams was responsible for the design and development of the reporting and mobile modules of the application.
Technologies used: .NET Framework (C#), .NET Framework Compact Edition (C#), Windows Mobile 5.0 Pocket PC SDK, MS SQL Server, MS Reporting Services, J2ME

GSApps, Kharkov, Ukraine 10/30/2001 – 8/30/2003
Ukraine, Kharkiv, 50 let VLKSM ave, 56, +380 (57) 754-59-63

Senior Software Developer/System Analyst
DataGenerator Project
Duties and Responsibilities:
As a software developer and analyst participated in developing DataGenerator tool. This tool is intended for data generation of the stress and unit testing of programs. Responsibilities included design and develop of the software product.
Development was done using MS SQL Server, Sybase, Oracle, DB2, Access, C#, .Net Framework

SoftMatch Project
Duties and Responsibilities:
As a software developer participated in developing SoftMatch tool (SoftMatch is a box application for matching data loaded from the different sources. It can identify different data similarities and join data that is related to the same client). Responsibilities included software development, code creation and testing, modules design.
Development was done using MS SQL Server, C#, .Net Framework

Automated Task Management System
Duties and Responsibilities:
As a software developer participated in developing of Automated Task Management System for a start-up software company. System included Task, Document and Issues management. Responsibilities included developing and testing the software.
Development was done using MS SQL Server, Microsoft Project and Microsoft Project Server

Order Management System for a biotechnology company
Duties and Responsibilities:
As a software developer participated in development of an order management system for a biotechnology company. Responsibilities included developing and testing the software.
Development was done using MS SQL Server and GSApps Data Loader.

Telesens Ukraine, Kharkov, Ukraine 9/1/2000 – 10/25/2001
Ukraine, Kharkiv, Kirova str. 38, +38 (057) 719-94-71

Software Developer
Billing System for large telecommunication providers
Duties and Responsibilities:
As a software developer participated in development of a large billing system for inter-settlements between telecommunication providers. Billing system used phone calls, other service records and set of agreements between telecommunication providers to calculate currency flows between them.
Responsibilities included developing a part of the system’s core processes. Development was done using Oracle, C++, Java and Crystal Reports. Target platforms: SUN Solaris, Windows.

Ukrtelecom, Kharkov, Urkaine 9/1/1998 – 8/30/2000
Ukraine, Kharkiv, Netechenskaya ave. 8, +38 (057) 733-33-50
System Administrator
Responsible for effective provisioning, installation/configuration, operation, and maintenance of systems hardware and software and related infrastructure.