Scroll To View More
Sagi Kovaliov, TFS Developer in Alpharetta, GA, United States
Sagi Kovaliov

TFS Developer in Alpharetta, GA, United States

Member since February 5, 2017
Sagi is a top-performing senior ALM/DevOps professional with nine years of solid hands-on experience in programming, business intelligence, scripting, and deployment. Sagi has been specializing in implementing and managing ALM and DevOps tools, services and processes such as TFS, Jenkins, HP ALM, Azure and more. Using his gained experience in multiple application development areas, Sagi has become one of the most prominent experts on the market.
Sagi is now available for hire

Portfolio

  • NCR Corporation
    Microsoft TFS, TFS Build/Release Management, Azure, MS SQL Server, SSRS, SSIS...
  • DataCube
    Java Core + Java APIs, ANSI-SQL, PL/SQL, T-SQL, MDX, Bourne Shell, Bash Shell...
  • Incentives Solutions
    Oracle 9i/10g, PL/SQL, .NET, VBA

Experience

  • T-SQL, 9 years
  • TFS Build & Release Management, 6 years
  • C#.NET, 6 years
  • DevOps, 4 years
  • Windows PowerShell, 4 years
  • Azure, 3 years
  • Azure DevOps, 3 years
  • Jenkins, 2 years
Alpharetta, GA, United States

Availability

Part-time

Preferred Environment

Windows, Visual Studio, TFS, Azure

The most amazing...

...thing I've done was to install/configure a TFS on-premises: a multi-tiered, complex project involving seven servers and a hardware move and upgrade of the TFS.

Employment

  • MS Team Foundation Server (TFS) Senior Expert

    2012 - PRESENT
    NCR Corporation
    • Expertly directed the administration and management of a complex TFS 2010/2013/2015 environment that consists of 3 global TFS instances for more than 2500 active users, 24 collections, and 130 projects.
    • Led the business requirements analysis which made an on-premise installation of TFS on Microsoft Azure the preferred choice over the cloud team services approach because of the need for a high level of TFS customization and security concerns.
    • Strictly adhered to Microsoft best practices for a tiered TFS architecture—carefully considering user count, density, and distribution to create a sophisticated TFS implementation composed of 7 servers configured to work together to provide high scalability, availability, and unmatched performance for all the users.
    • Orchestrated the seamless upgrade from TFS 2010/2013 to 2013/2015 handling the coordination of different business unit needs, schedules, and testing requirements without impact to ongoing operations.
    • Saved on consulting costs by creating the project plan, process, and execution strategy for enterprise upgrades managing internal infrastructure, networking, and DBA teams after vendor efforts had failed.
    • Developed a support roadmap that carefully aligns business requirements with TFS product functionality.
    • Reduced cost and errors by the lead TFS development efforts to create custom administration utilities for automating administrative tasks by creating the console, WinForms, and WPF applications using TFS API and .NET.
    • Ensured that end-users can perform all available operations that align with business needs by extending native TFS features (WPF desktop applications).
    • Enabled a TFS functionality for external customers without compromising data security for internal clients by developing custom VS and Web Access TFS controls.
    • Expertly managed the installation, support, and customization of a TFS build environment to support continuous integration.
    • Executed the XAML build process template upgrades and optimization that enabled performance gains with TFS 2013 and reduced the complexity of the build template which in the end limited the time spent on customizations and maintenance.
    • Reduced TFS build failures through advanced troubleshooting and a remediation approach that identified infrastructure issues involving a lack of space on a build agent, queue issues, and connectivity problems between agent/controller/server (ports) from other more complex programming errors.
    • Created an effective escalation process for all build issues resulting from programming errors that were quickly directed to the development teams.
    • Extensively used PowerShell scripts to create a flexible data warehouse reporting platform to track all the hardware and software information from approximately 600 Linux and Windows servers that are under the responsibility of the department.
    • Created valuable analytical management reports from the data warehouse to predict disk growth, track all of the installed software licensing and ownership, and represent actionable statistics about server usage.
    • Supported and enhanced the TFS environment by taking ownership of MS SQL Server administration, T-SQL development, and the installation and configuration of a SharePoint Server.
    • Optimized the TFS environment to avoid serious performance issues by developing and implementing a user agent blocking mechanism for TFS API clients that consisted of user-agent identification, approval procedures, and IIS access grant and tracking reports.
    • Created a multi-tiered environment for TFS 2015 on the Microsoft Azure platform.
    Technologies: Microsoft TFS, TFS Build/Release Management, Azure, MS SQL Server, SSRS, SSIS, T-SQL, .NET, C#, WPF, WinForms, WCF Services, PowerShell, VBScript, VBA
  • Software Engineer | BI Developer

    2009 - 2012
    DataCube
    • Overcame a slow processing time by using a multi-threaded processing approach to accelerate loading and transforming transaction files from multiple remote servers for a Java-based ETL module that was developed.
    • Expertly designed, built, and scripted data warehouse projects in diverse RDBM systems like SQL Server, Oracle, and MySQL with a demonstrated proficiency with ETL tools that including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and an Oracle Data Integrator (ODI).
    • Developed and customized the Team Foundation Server 2010 that included efforts to build WCF clients for event processing and server plugins and development of many end-user applications to extend the TFS abilities.
    • Customized and extended the functionality of HP Quality Center 10 to better meet the requirements of the business through server side database development, development of end-user applications, quality control, and the utilization of scheduled services and maintenance tools.
    • Saved manual effort, time, and errors for QA users by developing a utility that can copy test plans across different projects, collections, and servers which were an option that was not available by using the existing features of TFS.
    • Designed, developed and integrated a reporting platform for Unix/Linux servers—developed a Java-based ETL module for loading and transforming transaction files from multiple remote servers by using multi-threaded processing.
    • Designed and developed DWH and data migrating processes in Oracle DB.
    • Built a web user interface for managing application configurations; created deployment packages and Shell Scripts for a Linux/Unix environment.
    Technologies: Java Core + Java APIs, ANSI-SQL, PL/SQL, T-SQL, MDX, Bourne Shell, Bash Shell, Oracle 9i/10g/11g, SSIS 2005/8, SSAS 2008, ODI 10g, Apache Tomcat 6/7, IIS 7, WebLogic, Unix Solaris, RedHat Linux 5,6
  • Software Integrator

    2008 - 2009
    Incentives Solutions
    • Installed, customized, and maintained a company's software products.
    • Developed integration modules using PL/SQL scripting, SQL DTS, and .NET programming.
    • Installed and maintained a Oracle database.
    • Integrated SAP Business Objects with the company's products.
    Technologies: Oracle 9i/10g, PL/SQL, .NET, VBA
  • IT Support Engineer

    2006 - 2008
    Sensecom
    • Developed extension modules using T-SQL.
    • Developed a business support applications using MS Access.
    • Built reports using Sybase Infomaker.
    • Developed and implemented streamlining processes.
    • Performed user training.
    Technologies: T-SQL, VB6, MS Access, WinForms

Experience

  • On-Premise TFS 2015 Installation and Configuration on Azure (Development)

    • Created a multi-tiered environment for TFS 2015 on the Microsoft Azure platform (5 servers).
    • Installed and configured a SharePoint Enterprise 2013 Server.
    • Installed and configured SQL Server, reporting, and analysis services.
    • Configured TFS instances.
    • Installed and configured build servers.

  • Upgrade of TFS 2010 to TFS 2013 (Development)

    Planned and executed a TFS upgrade from 2010 to 2013 using a hardware move strategy.

  • Domain User Migration in TFS (Development)

    As a part of an integration process of Retalix with NCR, I was required to design, test, and plan user migration (identity change) in TFS between two domains.

    During the project I created, tested, and executed the migration plan with minimum downtime for TFS.
    All 1,100 active users were divided into migration groups and every day we migrated 20 users with the downtime of 10 minutes only.

  • Migration of a BI Solution from MS Server 2000 to 2008 (Development)

    • Designed and built an integration services project as a replacement for the existing MS Server 2000 DTS packages (Visual Studio 2008, MS SSIS 2008, MS DTS 2000, SQL Server 2000/2008, T-SQL, C#).
    • Developed a new Analysis 2008 solution to replace the existing one in Analysis 2000 (Visual Studio 2008, MS SSAS 2008, MDX, MS Analysis 2000).

  • Preparation and Maintenance of OBIEE Physical Layer (Development)

    • Developed a data ware house on Oracle 10g and built data updating procedures (PL-SQL, PL/SQL Developer 7.1, SQL Plus.)
    • Created an ETL solution for loading data into DWH from different sources (Oracle ODI 10gR3.)
    • Installed and configured Oracle OBIEE for a single sign-on environment on the application server (Windows Server 2008 R2, IIS 7.)

  • Design, Development, and Integration of a Reporting Platform for Unix/Linux Servers (Development)

    • Developed a Java-based ETL module for loading and transforming transaction files from multiple remote servers by using multi-threaded processing (Java Core and various Java APIs, Eclipse 3.5)
    • Designed and developed DWH and data migrating processes in Oracle DB (PL-SQL, PL/SQL Developer 7.1, SQL Plus)
    • Built a web user interface for managing application configurations (JSP, JSF 2.0, Tomcat 6, Eclipse 3.5)
    • Built deployment packages and shell scripts for a Linux/Unix environment (Bourne Shell, C Shell, Perl, PKG, and RPM packages)

  • Development and Customization of a Team Foundation Server 2010 (Development)

    • Development and customization of work items, process templates, and custom controls (VS 2010, TFS 2010, TFS Power Tools, TFS API, C#).
    • Built WCF clients for event processing and server plugins
    (VS 2010, TFS 2010, WCF, TFS API, C#).
    • Developed end-user applications to extend TFS abilities
    (VS 2010, TFS 2010, WinForms, TFS API, C#).

  • Customizing and Extending the HP Quality Center 10 According to Business Needs (Development)

    • Server side database development (SQL Server 2008, T-SQL, Management Studio).
    • Development of end-user applications, scheduled services, and maintenance tools (VS 2010, .NET, WinForms, WinServices, C#).
    • QC Administration and resolving users' issues.

  • Onsite SAP BI Products Integration (Client: BTC Bahamas) (Development)

    • Installed and configured a SAP BI platform on Linux RedHat 5.4 Servers (Oracle Database 11g, SAP Business Objects BI Platform 4, SAP Data Integrator, and SAP Information Platform Services).

  • Personal Project (Hobby): Developing a Fully Automated Client for MMORGP Online Game (lacunaexpanse.com) Using JSON‐RPC 2.0 (Development)

    • Developed Java-based modules for iterating with a game API
    (Java Core, Apache HTTP Client, JSON APIs, Java APIs, Eclipse).
    • Designing and implementing comprehensive algorithms for fully automated game-playing.
    • Preparing for the next steps: building an Android client
    (Android SDK APIs).

Skills

  • Languages

    C#.NET, T-SQL, Visual Basic for Applications (VBA), VBScript, Visual Basic 6 (VB6), XML, Bash Script, CSS, HTML, MDX, Bourne Shell
  • Frameworks

    Windows PowerShell, WPF, Windows Communication Framework (WCF), ASP.NET
  • Libraries/APIs

    TFS API
  • Tools

    Microsoft Visual Studio, Microsoft Access, TFS, HP Quality Center (QC), Apache Tomcat, C#.NET WinForms, Eclipse IDE, Jenkins, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), SSAS
  • Paradigms

    Azure DevOps, DevOps
  • Storage

    SQL Server Integration Services (SSIS), PL/SQL Developer, ANSI SQL, SQL Server Reporting Services (SSRS), Oracle PL/SQL, Azure Blobs, Azure SQL, Microsoft SQL Server, JSON, MySQL
  • Other

    TFS Administration, TFS Customization, TFS Build & Release Management, IIS, Windows Services, WebLogic, SAP BusinessObjects (BO)
  • Platforms

    Oracle Database, Windows Server, Azure, Azure IaaS, Solaris, Red Hat Linux

Education

  • Certificate in Developing Microsoft Azure Solutions
    2017 - 2017
    Opsgility - Online
  • Certificate in Advanced PowerShell Development
    2016 - 2016
    Microsoft - Tel Aviv, Israel
  • Oracle PL/SQL Developer Certified Associate in Oracle PL/SQL Development
    2007 - 2008
    Oracle University - Tel Aviv, Israel
  • Bachelor of Science (BSc) in Information Technology
    2003 - 2007
    Holon Institute of Technology (H.I.T.) - Holon, Israel
I really like this profile
Share it with others