Data Architect

Leonid “Leo” Dashevskiy

*************@*****.*** https://www.linkedin.com/in/leo-dashevskiy-3061062/ 770-***-**** SUMMARY

An experienced Data/Solution architect and technical lead with expertise in software architecture, development and delivery and product design. Proven ability to work with technical and non-technical teams to define business needs, gather requirements, create solutions, and deliver results that improve the company’s competitive edge and efficiency.

• 15+ years of experience leading development teams in SDLC - design, plan, estimate and deliver

• Management and leadership experience including hiring and mentoring

• Expert in Database Architecture, ETL and Software Development

• Expertise with complex solutions using MS SQL, MySQL, PostgreSQL, SnowFlake, Oracle, C#, VB.NET, HTML, on- prem, AWS or GCP

• Extensive experience in enterprise architecture design for APIs and data integration with external systems on different levels – from database access to on-wire communication

• Experienced with hardware design and embedded system development

• Ability to work across the organization – marketing, product management, support, sales – to deliver solutions

• Experience with pre-sales and creating presentations, proposals and estimates for a variety of clients PROFESSIONAL EXPERIENCE

Senior Solution Architect – Consilio (Remote) December 2022 – Current Working as a part of a team to rewrite existing monolithic application to a modular, expendable and configurable one.

• Working with Business units to gather business requirements and convert them into technical requirements.

• Performed Database optimization to improve performance.

• Defined and designed APIs to be used with C#

• Created reports using PowerBI with SQL server as a data source Senior Solution Architect - Convergent/SageNet, Atlanta area, GA August 2019 – December 2022 Architect multiple unique solutions to successfully deliver required products to clients such as Home Depot, T-Mobile, and Samsung from the enterprise architecture level to the application level, including extensive integration with external systems.

• Lead and mentor multiple internal and client development teams.

• Data transfer (ETL) between different platforms/formats using standard (SSIS) and custom (.NET application) methods.

• Orchestrate and document the architecture and design of proof-of-play reporting and interactive action reporting by working with the implementation, product, and IT teams as well as the customer's business team.

• Design and create reporting database populated with raw Google Analytics data for the PowerBI team to create custom reports.

• Prototype new products and define and develop client-specific customizations and implementation.

• Deliver cloud (AWS) and on-prem Architecture solutions using C#, MS SQL/MySQL/SnowFlake, REST/JSON as a part of contract worth $4M.

• Work with Engineering to transfer parts of the business from AWS to GCP without interruption of service.

• Evaluate and recommend new possible technological approaches and products for internal use.

• Research and design solutions with the product, pre-sales, and R&D teams. Solution Architect (Contract) - Site One Landscape Supply, Alpharetta, GA March 2018 – August 2019 Created a new internal POS/Inventory management system. Was responsible for back-end/middle tier optimization.

• Designed and developed multiple SSIS packages to integrate data with external suppliers.

• Worked with Mobile development team to optimize API to be consumed by mobile application (REST/JSON).

• Created Reports using SSRS and PowerBI

• Worked with Financial team to gather reporting requirements and converted to technical specifications.

• Led and mentored junior developers.

Solution Architect - Nexidia (division of NICE), Atlanta, GA January 2017 – March 2018 Customized and implemented products to four big customers (Microsoft, T-Mobile, Bank of America and ShutterFly)

• Performed multiple integrations with Customer’s internal systems using MS SSIS and custom ETL tools – on- prem and cloud-based in contracts worth $3+ million.

• Determined hardware requirements based on projected load. Consultant (Contract) - LexisNexis, Alpharetta, GA May 2016 – December 2016 Worked as a liaison between business units and development team to create risk assessment application.

• Designed multiple back-end components in PCI-complied environment. Technical Architect - Landis+Gyr, Alpharetta, GA October 2015 – May 2016 Created technical architecture for implementing company’s products.

• Created multiple data integrations with Customer’s systems (billing, support, etc)

• Hardware sizing and resolved performance problems in network/infrastructure.

• Created custom reports using SSRS/PowerBI.

Consultant (Contract) - LexisNexis, Alpharetta, GA February 2015 – October 2015 Worked as a liaison between business units and development team to create risk assessment application.

• Designed multiple back-end components in PCI-complied environment. Architectural Consultant (Contract) - Park N’ Fly, Atlanta, GA February 2014 – February 2015 Worked with Business process owners to collect business requirements and processes and translated it into technical specifications, data structures, business rules and created technical documentations for developers.

• Performed Database Analyses and Optimization.

• Optimized Database for peak performance and scalability (modifying table structures, creating indexes, views, optimizing Stored Procedures, creating User-defined Functions, creating SSIS packages)

• Optimized interfaces specifications

• Created API to work with RFID readers.

Senior Developer/Architect - Convergent/SONY, Alpharetta, GA August 2007 – January 2014 Architected, designed, and developed multiple solutions to allow company serve existing and attract new customers. Engineered solution for new type of SONY stores, which was patented. Created several hardware devices for SONY stores worldwide.

• Worked as a “front-line” technical person to interact with Customers to collect information about their business needs and translated it into technical requirements.

• Created configurable SNMP-poller to collect data from 50K+ devices and generate alerts.

• Created ASP.NET-based monitoring application to monitor IPTV in MGM Resorts Hotels (9 properties).

• Created series of Interactive Podia Devices for SONY stores. 3 types of device holder (for PS3 MOVE, 6-axes controller and for 3D-glasses) and 2 types of controllers (IP-based and RS-232-based) were created.

• Reverse-engineered existing third-party solution and extended functionality of it. Created web-based application to produce Attendance- and Exception-reports, based on information from existing application. This required reverse-engineering of dataflow and database structure. Final solution was integrated with existing undocumented services.

EDUCATION

Master of Science in Computer Science, Tashkent Polytechnic University, Tashkent, USSR, 1989 Languages: Fluent English, Native Russian

Patent: US Patent # 8,589,990 (awarded Nov 19, 2013)

Contact this candidate