Vlad Pilipets Email & Phone Number

Minnesota, Mn

• Data Warehouse o Building an enterprise data warehouse system for analysis, reporting and analytics of an omnichannel customer interaction services using star schema and tabular structures o Enhancing data integrity between multiple CRM systems, vendors and clientso Building automated ETL system using SSIS service & conventional stored proc methodso Performing ongoing data retention & data purge for time related and compliance policies o Configured analytics services integration with Python & R installationso Building a speech analytics service using CallMiner and SpeechIQ APIs• Database Administration & Development o Completed migration of all analysis and analytics services from 2008 to 2017 & 2019, including Windows Server, Sql Server, SSIS and PowerBI implementationso Performing daily database operations with data tuning, index maintenance, data fragmentation, query regression o Implemented data compression for tables, indexes and file systemo Implemented data security with Sql Server TDE encryption and custom 256 bit encryption for column level protection• Team Managemento Improved collaboration of analytics department team members with the scrum project management approach, source code implementations, code reviews and deployments. o Helped creating effective remote team management with interviews, trainings, feedbacks and planning Databases: SQL Server 2017 / 2019; Languages: C#, Python, Excel VBA; Tools: Spotlight, SSIS, PowerBI, CACHE (CRM & ODBC), Filezilla, Sharepoint, Teams, TFS, CallMiner, SpeechIQ, ServiceDesk; Scripts: XML / XMLA, XSLT, JSon.

• Product developmento Designed and developed configuration console for market personalization and revenue optimization product.o Created new concepts enhancing recommendation engine, including recommendations distributed cache objects and recommendations rule engine, service for geographical and weather personalization.o Designed and developed an automated service for generating dynamic configuration and implementation instructions.• Database developmento Designed SQL Server database entities – tables, partitions, views, functions, procedures and indexes and creating API services. o Created dynamic database optimization process for index re-building and defragmentation.o Implemented performance optimization with table, dimension, fact views partitioning.o Designed, developed, optimized, and maintained SQL queries and stored procedures. o Gathered requirements for new reports development and enhancements of existing reports. • Data warehouse developmento Designed data warehouse platform using MS OLAP technology. Gathered data warehouse requirements and performed data analysis to identify key business metrics, measures and points of interest.o Developed architecture for ETL processes using SSIS methodology. Created ETL solutions for data warehouse staging environment and production data warehouses.o Implemented Claudera Hadoop environment for historic data repository.Databases: SQL Server 2012 / 2014; Languages: C#,Impala,Spark; Tools: Enterprise Manager, SSAS, SSIS, SSRS, Cloudera, DITA, Visio, Windows Sharepoint Services 3.0, VSS; Scripts: Javascript, XML / XMLA, XSLT, HTML, JSon

Managed SQL server database administration and security operations, managing server space and installations. Responsible for data integrity, troubleshooting database, resolution data presentation issues and quality assurance.Created and maintained high availability environment using SQL Server Clustering, Log Shipping and replication solutions.Created automated system to proactively analyze and optimize multiple servers and multiple database performance.Developed architecture for implementation of ETL solutions using SSIS and DTS methodology. Created various reports using SQL Server Reporting Services.Designed and led the implementation of new SharePoint based framework for company's primary LMS product.Technology Used:Databases: SQL Server 2000 / 2005; Languages: C#; Tools: Enterprise Manager, SQL Reporting Services, SSIS, Visio, Windows Sharepoint Services 3.0, VSS; Scripts: Javascript, XML, XSLT, HTML.

Designed and created centralized and automated optimization and backup plans for multiple servers and databases. Maintained clustered high availability environment.SQL Server performance tuning, execution analysis, tracing, data import / export / archive.Created ETL solutions loading data from multiple data sources to the BI data structures. Developed data mining and multi dimensional analysis.Participated in system and database architecture design. Supported development teams through all enterprise application development and migration processes and environments.Implemented and customized CRM 3.0 solution; Designed and created WWF for CRM based applications. Developed framework and projects for different financial products.Technology Used:Databases: SQL Server 2000 / 2005; Languages: C#; Tools: Enterprise Architect, Enterprise Manager, SQL Reporting Services, SQL Analysis Services, SSIS, Visio, CRM3.0, NUnit, TFS, SVN; Scripts: Ajax, Javascript, XML, XSLT, HTML.