Data Migration Architect
2019 - 2020Spin- Analyzed current application and data architecture.
- Researched potential future architecture that matches business requirements and application demands.
- Proposed an optimal data migration solution from one Heroku platform to AWS.
- Researched, tested, and implemented one-directional data synchronization with Bucardo. Set up such synchronization on all databases in all environments.
- Prepared, designed, and provisioned future databases for all environments on AWS.
- Set up, supervised, and monitored actual data migration from Heroku to AWS. Successfully migrated all lower environments.
- Researched further data synchronization with FiveTran technology to an analytical database. Prepared step-by-step instructions for migrating said synchronization from Heroku DBs to AWS DBs in all environments.
- Prepared documentation, how-tos, diagrams, and presentation on a matter of my research and proposals. Supported and maintained such documentation.
- Participated in design and architectural reviews.
Technologies: Data Migration, Global, CockroachDB, PostgreSQLJava Developer
2019 - 2019Addteq, Inc. (via Toptal)- Built an in-house analog of the Einstein/Firebase service with WebSocket and STOMP protocols as well as STOMP token authentication, subscription, messages, and topics.
- Integrated the in-house service with Confluence Excellentable plugin for a collaborative editing feature.
Technologies: Stomp.js, Ajax, Apache Velocity, HTML, JavaScript, Atlassian Confluence, Authentication, Spring Boot, STOMP, WebSockets, JavaWeb Application Architect and Developer
2018 - 2019Linksbridge- Designed and developed a single-page rich web application.
- Set up and supported complete cloud infrastructure.
- Set up the database and designed data schema per business requirements.
- Set up an R back-end server. Designed and developed an R application for processing large data documents.
- Implemented UI and UX with input from the graphical interface designer.
- Analyzed business needs and technological capacity. Proposed most optimal solutions to ongoing problems and tasks.
Technologies: HTML, CSS, SQL, Java, jQuery, jQuery EasyUI, AngularJSJava Developer
2016 - 2016Danfoss Turbocor Compressors (via Toptal)- Analyzed existing code and solutions.
- Found the source of a performance discrepancy in different input data cases.
- Recommended solution approaches with corresponding implementation time and effectiveness.
Technologies: Profiling, JavaArchitect and Development Lead
2009 - 2016FINRA- Architected a complete system, including data processing modules, component framework, and infrastructure for logging, monitoring, and control.
- Designed and enforced the automated project lifecycle: build, test, and deployment.
- Established and enforced development best practices.
- Maintained overall product architecture consistency and clarity to support intuitive development and easy product evolution.
- Created and maintained technical and user documentation.
- Researched AWS Elastic MapReduce technology (web GUI and command-line interfaces).
- Developed Elastic MapReduce jobs capable of using Amazon S3 storage as input and output source.
- Analyzed the existing stream of event processing solutions in a market and evaluated them against desired system qualities to find the best-suited product/framework for a project.
- Architected a system POC version and supervised implementation.
- Designed and implemented high availability data storage and data processing systems. That includes utilizing data storage supporting sharding technology, data and application clusters, high availability data storage, and multi AZ deployment.
Technologies: Amazon Web Services (AWS), AWS, Performance Optimization, Parallel Programming, Web Services, Big DataBusiness Intelligence Architect and Developer
2008 - 2009Cambridge Interactive Development Corporation- Adapted an existing Java-based data load application for Netezza database, making the first generation of Netezza data warehouses operational.
- Developed a data load application for corporate data warehousing using Data Integrator increasing load speed four times, which was a critical achievement to support the data delivery service-level agreement.
- Designed data marts and studied, troubleshot, and configured a company-wide scheduling system.
- Parallelized and optimized schedule implementation, decreasing load time span by around 50%.
- Configured the load-balancing environment for a scheduler and ETL tool.
- Optimized corporate-wide ETL operations, cutting the overall load time in half.
Technologies: Perforce, CVS, Data Integration, SAP BusinessObjects (BO), MySQL, Netezza, Oracle, IBM Informix, JavaJ2EE Architect and Developer
2005 - 2008Liberty Travel- Analyzed application requirements and communicated with the business analyst.
- Architected and developed application modules.
- Integrated with a third-party application API.
- Designed and developed a web-based user interface.
- Designed a complex data matching algorithm for integrating with the external system.
Technologies: Oracle, XML, Servlets, JSP, Apache Struts, EJB, Core Java (J2EE)