•IT Professional with MS Degree in Computer Science, MCSD, MCDBA and 12+ years of extensive and diversified hands-on technology experience in small, medium, and large sized organizations, in technical leadership teams across the globe. Expertise in front end, middle tier, backend (SQL Server) design/development and Build automation (CI/CD) delivering client and web based applications.
•I am a senior level developer, with experience of working on large and medium scale projects, and have the desire to constantly improve upon project delivery by focusing on the key functional business points, delivering quality design and implementation, improving performance and focusing on usability. I have the ability to work in multiple roles on a project and quickly move from one to another including helping architects during HLD creation and project planning like ROM and resource planning. This includes the different tiers such as SQL data stores, middle tier and front end GUI in collaboration with UX, PM, SD, Build and Test teams. I have a “Can Do” attitude.
•For the last eight years I have been involved in large scale enterprise applications using the full stack of the latest Microsoft design techniques and technologies. I have been able to design and implement project deliveries in all three tiers with various languages and technologies such as JavaScript, JQuery, KendoUI, Telerik, JSON API, Ajax, HTML5, Less, CSS, MVC 4/5, IoC, Dependency Injection, Unit of Work, Modern UI, Responsive Web Design, ASP.NET, WPF, C# middle tier design, WCF, TFS based on WW CI/CD, T-SQL, SSIS. I have driven the E2E design and development as a project Dev lead, UI lead of a team of 12 developers-across the globe and in different time zones- as well as a feature owner.
•My duties included project management and planning. I have worked on several projects for the Enterprise Commerce (ECIT) groups at Microsoft. These applications were part of a thirty billion dollar annual revenue stream.
Senior Software Engineer @ From July 2015 to Present (6 months) Senior .Net Developer @ Role: Senior .Net Developer
• Responsible for migration, design and development existing https://eservices.wellsfargodealerservices.com/ to Modern UI Web portal based on Responsive Web Design principles targeting mobile devices v1.0.
• Owned a full stack of Estatement enrollment feature.
• Implemented and styled WF must head, footer, menus, home page, messaging system, a bunch of reusable controls based on jQuery, media queries and AngularJS for a phone, tablet and desktop designs.
• Designed and implemented a redirection from legacy site to a new mobile version based on touch feature and user agent limiting randomly selected users according to configurable percentage.
• Supported 24/7 on call existing WF eServices applications
• Worked closely with PM and Test teams preparing backend test Data and production promotion advertisement.
• Ensured my design factored re-usability and performance.
• Planned, designed and implemented infrastructure features like security (cross site request forgery prevention for ASP.Net MVC and Web API using filters), accessibility, contrast mode, error handling and logging. It's significantly improved quality of the web portal and reduced a number of logged bugs.
• Tools/Technologies: AngularJS, media queries, JIRA, Web API, JavaScript, JQuery, JSON API, Ajax, HTML5, CSS, MVC 4/5, Razor, Views, Modern UI, Responsive Web Design, ASP.NET, C#, WCF, Agile, Scrum. From December 2014 to July 2015 (8 months) Technical Skills @ ASP.NET MVC 4/5, MV*, Razor, Views, JQuery, KendoUI, Telerik controls, AngularJS, Ajax, HTML5, CSS, Less, WPF, C# middle tier design, WCF, Open XML , VS2013/2012
RDBMS MS SQL Server 6.0/6.5/7.0/2000/2005/2008/2012
Database Query Tools MS SQL Server Query Analyzer ,Service Broker
Database Modeling Data modeling / Database design (logical / physical) using Rational Rose, Visio, ERWin
Data Warehouse Modeling SQL Server Environment: Data Transformation Services, SSIS,
Languages C#,T-SQL, xQuery,
UI/Middle tier/Database/Build Automation Software Developer
Modern UI - (MVC4/jQuery/JSON) Developer
Analyzing functional specification/BRD, planning(ROM creation), designing, coding, unit testing and documenting VL applications maintaining standard compliance
Automating Continues Integration/ Continues Delivery/ Gated Check In / builds and promoting unified template among division
Implementing localization, globalization of software
SQL Server Developer - plan, architecture, design (conceptual, logical and physical), implement and support as SME Databases used in worldwide business applications From July 2006 to December 2014 (8 years 6 months) SOFTWARE DEVELOPMENT ENGINEER II @ Role: UI Lead
Responsible for delivering Partner self-service web portal version 1.0
Highlight: high adoption after august FY15 production deployment with 50% jump in user creation within two months of use vs 2 years of use legacy portal. High quality with 0 post production issues.
• Analyzed requirements created a plan for web portal delivery and assigned tasks to each Developer defining areas of responsibility. Coordinated meetings and collaborated with external teams – UX, Architect, PM, Test, Service and Backend to make sure that UI meets requirements and Data flow.
• Worked closely with Architecture team on proposing an alternate solution for search features to improve performance, which resulted in avoiding performance issues and providing to partners a better experience.
• Led the design, development and implementation of the web portal heavily using Modern UI design focusing on performance by using KendoUI HTML grid and rendering the grid by jQuery on a client side. Introduced using of Unity of Work to handle multiple repositories encapsulating multiple different services ‘calls as a way abstract UI models from underline service models.
• Ensured my design factored re-usability and performance.
• Planned, designed and implemented infrastructure features like security (STS, Claim Builder), accessibility, contrast mode, localization, error handling and logging during build phase to avoid bugs explosion in DIT and SIT phases. It's significantly improved quality of the web portal and reduced a number of logged bugs. Proactive use of pseudo localized satellite assemblies testing resulted in only 1 SIT localization bug.
• Tools/Technologies: JavaScript, JQuery, JSON API, Ajax, HTML5, Less, CSS, MVC 4/5, Razor, Views, Modern UI, Responsive Web Design, ASP.NET, C#, WCF, Agile, Scrum. From December 2013 to November 2014 (1 year) SOFTWARE DEVELOPMENT ENGINEER II @ Role: Web UI Feature owner/developer
Delivered two web pages as owner of two business features (select products from catalog into a “cart” and configure selected products with heavy business, pricing and dynamic UI logic) as part of newly developed and launched partner quoting web portal version 1.0 for external partners.
• Analyzed BRD, gathered requirements and provided comments and improvements for UX design, functional specification and design.
• Proposed new design for presenting product catalog and influenced UX , SD , PM teams by quickly implementing show cases in POC UI and demonstrating working UI Web pages with modern UI features available out of box from Telerik Grid control ( such as Grouping, sorting, filtering on client side), jQuery, HTML, CSS. All proposals accepted and in production. My new proposed designs saved time and resources on server side coding of above features, testing them and fixing possible bugs as a result of coding.
• ROMed and planned UI features
• Designed and implemented TS for both features covering MVC UI, HTML, JavaScripts, CSS files, controllers and repositories to get Data from corresponding service and process it.
• Scheduled, Presented and managed Internal and External reviews to a broad audience like Dev/PM/Test/Business/OPs teams and incorporated feedbacks.
• Implemented UI functionality for two pages using jQuery and Telerik controls with ability to fetch product catalog, group, filter and sort products in a grid, select any products and include in a cart, edit the cart and finally configure selected products to get pricing range and quote. Developed different types of searches across a web portal, accessibility, localization.
Tools/Technologies: JavaScript, JQuery, JSON API, Ajax, HTML5, Less, CSS, MVC 4, Razor, Views, HTML helpers, .Net 4.0,VS 2012, Modern UI, Telerik, ASP.NET, C#, WCF, Agile, Scrum. From January 2013 to December 2013 (1 year) SOFTWARE DEVELOPMENT ENGINEER II @ Role: Web UI developer
Delivered business features across a new Purchase Order Entry Tool (POET) web portal version 1.0 to allow partners search and order Microsoft products based on pricing list and discounts.
• Developed Order New Products and Summary Ux/UI functionality.
• Implemented search controls across the portal.
• Evangelized unobtrusive JavaScript style
• Improved performance by minimizing css and js files
• Implemented bundling for js files
Tools/Technologies: MVC4/ jQuery/ Razor/ Telerik/ JSON / AJAX/Metro style look and feel. From June 2012 to January 2013 (8 months) IT SOFTWARE DEVELOPMENT ENGINEER 2 @ Responsibilities:
• Designed and developed applications for the Microsoft Volume Licensing group mainly as front end and middle tier developer including designing, researching and writing technical specifications for new and existing large scale applications.
• Owned, designed and developed features for Agreement Creation contract management system with ability dynamically generate a contract package of required documents. The system is multi-tier and intended to automate processing Open XML documents and includes WPF Smart Client, ASP.Net Web Form portal, WCF services and SQL Server Databases.
• Introduced first in a group and implemented build automation based on Continues Integration/Continues Delivery/Gated Check In in partnering with SE Build team
• Set up and automated Code Coverage, FxCop code Analysis, Code Quality Metrics to ensure that project implementation meets organization standards.
• Automated Unit testing and BVT framework as a part of nightly builds. Set up Gated check in to enforce check in quality.
• Designed CI/CD practice and presented a Brown bag for the whole ECIT division. As a result of my innovation and influence now in 2014 a whole group of SEs created to implement and support CI/CD and widely used among all applications in ECIT Microsoft. From July 2009 to June 2012 (3 years) Application Developer @ Responsibilities:
• Plan, architecture, design (conceptual, logical and physical), implement and support as SME Databases used in worldwide business applications
• Design and implement dynamic searches with a specific requirement - output result, sorting order and filtering should be dynamic and user driven for 23 search criteria. Applied dynamic SQL and building non-parameterized queries with the values included. Free of SQL injection within back end implementation.
• Performance tuning and index optimization
• Refactoring Legacy systems and Integration with existing Databases.
• Design and Implement Data migration between different environments DIT, SIT, UAT.
• Database build automation and build deployment
• Unit testing with VS DB Professional 2008
• Implement Domain Data localization process
• Use of Service Broker to provide support for messaging and queuing applications
• Designing and Implementing Semi structured and FILESTREAM Storage
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction
• Perform quality assurance and testing of SQL server environment.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Created Stored Procedures, triggers, views, temp tables for data manipulation & reporting.
• SQL Development & Troubleshooting included file groups, data access, indexes, stored procedures, triggers and table structures for application behavior manipulation.
Tools/Technologies: SQL Server 2008/2005, SQL Server Management Studio, SQL Profiler, Data Model, SQL Trace, Transact SQL (T-SQL), Query Analyzer SQL Server 2000, Performance Monitor, SQL Query, Transactional Replication ,Backup/ Recovery, Database Transformation Services DTS,SSIS Windows 2008 Server, XML, XQuery, VSS, Visio, ERWin,VSTF, VS2008/2010, WCF, MSBuild. From July 2006 to July 2009 (3 years 1 month) SQL Server Developer (contractor) @ SQL Server 2005 (Yukon) Developer
Responsibilities:
•Installing, configuring and administering SQL Server 2005 Yukon/Windows 2003 Server
•Upgrading and fresh installation starting from 9.00.852.00 and until IDW15 (a current version of SQL Server 2005 Yukon)
•Was involved in a project planning and scheduling
• Database design
•Developing and updating Design Document
•Installation and testing a new project build, including a hand calculation
•Implementing distributed 4part queries using linked server
•Ad hoc queries
•Converting data from different formats using DTS and BCP
•Parallelized XQueries on XML
•Gathering data from different data sources using asynchronous calls, based on Service Broker
•Database Performance Tuning and monitoring, Scalability Testing
•Administer, maintain, develop and implement policies and procedures for ensuring a security and integrity of company database
•Index Optimization
•Optimizing Backup and Restore Performance
•Experience in Indexing, disk partitions and optimizing
•Writing Stored Procedures Using Transact-SQL including new Yukon features
•Database authentication modes, creation of users, configuring permissions and assigning roles to users
•Transformation data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS), Database Wizard
•Data conversions from legacy systems to SQL server Using DTS
•Maintaining remote and central databases for Synchronization of data and preparing plans for Replication
•Database Server Performance, tracking user activity, troubleshooting errors, tracking server resources and activities, tracing server events
•Creation and debugging objects like Stored Procedures, triggers, views as per requirement and implementation of the security model on Application for Access of Objects
•Troubleshooting
•Working with development teams on all aspects of database design including tables, views, stored procedures, permissions From October 2004 to July 2006 (1 year 10 months) SQL Server 2000 (Database Administrator) - DBA/Developer @ Responsibilities:
•Configuring GoldMine software application based on SQL Server
•Database Performance Tuning and monitoring, Scalability Testing
•Designed and implemented Transactional, Merge and Snapshot Replication
•Provide non-stop Database Access support 24x7
•Preparation of Schedules for Backup and Recovery. Maintenance of backup and recovery plans for system and user databases
•Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company database
•INDEX Optimization
•Setup and Maintain Replication between Production and the Standby servers
•Optimizing Backup and Restore Performance
•Optimizing Transaction Log Performance
•Experience in Indexing, disk partitions and optimizing
•Writing Stored Procedure Using Transact-SQL
•Designing a Data Warehouse, data mining, Relation Database design
•Memory management, data storage, user connections and Load Balance
•Database authentication modes, creation of users, configuring permissions and assigning roles to users
•Prepare and set up environment for Disaster recovery
•Transformation of data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS)
•Data conversions from legacy systems to SQL server Using DTS
•Creation of objects like Stored Procedures, triggers, views as per requirement and implementation of the security model on Application for Access of Objects
Environment: SQL Server 2000, Enterprise Manager, SQL Profiler, Data Model, SQL Trace, Transact SQL (T-SQL), Query Analyzer, Performance Monitor, SQL Query, Transactional Replication ,Backup/ Recovery, Analysis Service, Database Transformation Services DTS, Windows 2000,T-SQL, Windows 2000 Advanced server, PL/SQL Oracle PL/SQL, Windows NT, ETL From February 2004 to October 2004 (9 months)
Microsoft Certified Technical Education Center From 2007 to 2013 Master's degree, Computer Science @ Maharishi University of Management From 2004 to 2007 Master's degree, Information Technology @ Krasnoyarsk State Technical University (KSTU) From 1984 to 1989 ANDREY TSELYUK is skilled in: Web Development, Web Services, ASP.NET MVC, jQuery UI, MVC Architecture, WCF Services, HTML, WPF Development, Databases, Database Design, Data Modeling, Microsoft SQL Server, Build Automation, OOP, .NET