C# Business Analyst

sergiy (sam) klokov

Location: Phoenix, Arizona. E-mail: *******@*****.*** Phone: 480-***-****

Some examples: github.com/sam-klok, github.com/sergeklokov, examples.20m.com

PROFESSIONAL SUMMARY

Over 20 years experience as a Software and Database developer for Windows and Web.

Extensive experience in software development using C#, .NET, JavaScript/TypeScript, Python, Java, Visual Basic.NET, C/C++ and SQL. Expert in DB development (data modeling, ER-modeling, transforming, normalizing etc.) including graph and non-sql databases. Proficient in coding, testing and documenting software, and development of multi-tier database applications.

Expert in SQL (T-SQL, Watcom SQL, PL/SQL). Expert in reports creating (Report Builder, Crystal Reports).

TECHNICAL SKILLS

Languages: C#, Java Script, TypeScript, Java(Android Java SDK), Visual Basic.Net, Delphi, C/C++, Assembler (x86), SQL (T-SQL, PL/SQL), XML

Technologies: .NET7 / .Net Core, .Net 4.8.1, MVC/Razor/Blazor, WCF/Web.Api/REST Web Services, OOA/OOP, SQL, HTML, Javascript/ECMAScript/Typescript/JQuery/Angular, ASP.NET, Android SDK, Xamarin, Winforms/GUI programming, Win API, OLAP, SSIS/DTS, TCP/IP.

Client/server:

MS SQL Server 2022, neo4j, CompassDB, Sybase SQL Anywhere, Oracle 8/9

DB design:

Sybase Power Designer, ER/Studio, ERWIN

CERTIFICATIONS

Azure Fundamentals (2023, Microsoft, AZ-900) Cert # BAC13E-3CB941

C# 5.0 (2015, Brainbench) Brainbench transcript id=4471578

.NET Framework 4.5 (2015, Brainbench)

JavaScript 1.8 (2015, Brainbench)

MS SQL Server 2012 Programming (2015, Brainbench)

MAJOR SKILLSETS

Programming Languages: C#, TypeScript, JavaScript, VB.Net

Databases: MS SQL Server 2019/2022, ORACLE 9, Sybase SQL Anywhere 8.0, Interbase, Access

Database connectivity: ADO.NET, ADO, ODBC, OLE DB

Distributed technologies: .NET, Web Services, WCF/REST, COM/DCOM/COM+

Teamwork tools: Git, TFS, PVCS

Operating Systems: Windows, Android OS

Management Technologies: Active Directory/LDAP, Install Shield/MSI,

Networking: TCP/IP, SMTP/POP3, network administration (Windows 2000, AD),

Report tools: SSRS

Other tools and technologies: SDLC, MVC, Jquery, Angular, Ajax, knockoutjs, Web API/REST, WCF/SOAP, CSS, XML,json, IIS, Best coding practices.

Industry Experience: Manufacturing, Financial consulting, Publishing, Industrial Distribution, Home Health Care

PROFESSIONAL EXPERIENCE

November 2018 – present Phoenix, AZ

Apex Systems Software Developer

Audit/tax web application with microservices/web.api backend.

It was multilayer set of of .Net 5 applications, some of them self hosting, database use MS SQL 2019, and Azure Cosmos DB, and several clients based on MVC/Razor or Angular. Also I was involved in some other not related to above applications, like VSTO Outlook addons, and standard .Net Framework MVC app.

Environment: Windows 10, Visual Studio 2019/2022, MS TFS, TDD, Angular 12, TypeScript, Node.js, Azure (VM, IIS, JFrog Artifactory, Notification Hub/Service Bus) Agile/Scrum etc, .Net 5 and 4.7, .Net Core,.

Project 2

Real estate price estimation web app with rich user interface, and complex calculations based on various geographical data.

It is a group of .Net 4.7.2 applications, web running under IIS, database use MS SQL 2016, Entity Framework 6.2, client part is MVC/razor/JQuery/Angular. Some other features: Memcached used for distributed cache, code compilation on the fly, hundreds of millions of records in the databases which required data optimization and query/stored procedures tuning.

I developed all layers, mostly focusing on the database back end and middle layer, data modeling/OOP design/redesign.

Environment: Windows 10, Visual Studio 2017, MS TFS, SSIS, TDD, Angular 11, TypeScript, Node.js, Azure (VM, IIS, JFrog Artifactory, Notification Hub/Service Bus) Agile/Scrum etc, .Net 4.7, .Net Core, MVC6.

August 2015 – October 2018 Phoenix, AZ

Aetna Sr. Developer at Aetna Medicaid

Client facing web application with sophisticated search capabilities, and more than hundred of supporting apps

Project #1. Developing “standard” enhancement to forms as well as major performance related enhancements for main app, which operates with millions of records. App use MVC, Angular, Web API, web services, MS SQL 2014 database and SSIS packages to populate main database from source databases.

Project #2. Upgrade of 100+ applications and 20+ windows servers Net 4-.Net 4.5.2 which required to recompile many of them and adding impersonation fix (known upgrade issue). Challenge was to figure out many components and short time.

Environment/Tools: Windows 7/10, Web, Visual Studio 2015/2017, MS SQL Server 2008R2/2014 (stored procedures/functions), Javascript, Net 4.5.2, MS TFS, Team City, Octopus, SSIS, HTML5, Bootstrap, Node.js.

June – August 2015 Scottsdale, AZ

Hypur Sr. Developer

Creating modular web application for third party banking (cash transactions).

Environment/Tools: Windows 10, Web, Visual Studio 2015, MS SQL Server 2016 (stored procedures/functions), Javascript, Net 4.5.2, MS TFS, HTML5, Bootstrap.

Feb 2008 (contract) - September 2008 – May 2015: Senior Programmer

Isagenix Chandler, AZ

Sophisticated e-commerce website similar to amazon

I developed an application for sales through the internet. Application have several parts: web, windows and web, and app for Android cell phones, all parts are connected to business layer through web services (WCF/Web.api REST). For storing data MS SQL 2008 and Microsoft Commerce Server 2007 are used. Web part use .Net 4.5, cell phone part use MVC 4 Razor. Jquery, ajax, T4MVC, knockout, node.js also used. Windows parts use win forms and partially translated on WPF/MVVM. Xamarin/Android SDK, MS Azure used. I developed all parts of these applications.

I independently accomplished Events project (MVC & web.api) in very short time, and many other projects.

Environment: Windows 7/8, Web (Chrome, MS IE9 and another browsers), iPhone/Android/Tablet PC.

Tools and technologies: MS Visual Studio 2010 Ultimate, C#, .Net 4.5, ASP.NET MVC 3/Razor, MS SQL 2008, Microsoft Commerce Server 2007, WCF, LINQ, MVC/WPF/MVVM/Jquery/Knockout js/T4MVC etc.

August 2006 – January 2008: Programmer Analyst

Dallas County Dallas, TX

Database driven website for county & police

It's MS SQL 2000 application, connected to mainframim through Biztalk, with web (asp.net) interface.

Environment: Windows 2003/XP, MS Visual Studio 2005, C#, .Net 2, MS SQL 2000.

Tools and technologies: MS Visual Studio .NET 2005 (C#), ASP.NET, ADO.NET, XML, XSLT, HTML, JavaScript, Query Analyzer, UML, MS SQL 2000.

September 2004 – July 2006: Programmer Analyst

The Aircraft Group, Inc http://www.theaircraftgroup.aero/ Phoenix, AZ

Database driven website

I do web database driven application that is and represent information over the Internet. It consist from Web part and Windows part. Web services are used for uploading information over the Internet. C# is used for creating all parts of application. I developed database for this project (MS SQL, tables, stored procedures), Web and Win applications. Project include some features as Encrypted security system, logging, statistics. It’s also was designed and developed by me.

Environment: Windows 2003/XP, MS Visual Studio 2005, C#, .Net 2, MS SQL 2000 Enterprise.

Tools and technologies: MS Visual Studio .NET 2005 (C#), ASP.NET, ADO.NET, XML, XSLT, HTML, JavaScript, Query Analyzer, UML, MS SQL 2000.

Wed based Scheduler of technical services and parts exchange (Web project)

I developed .Net web application. I was a senior software developer and architect for this app and did whole software development life cycle (SDLC): From business design to reporting. All made on C#, JavaScript(.Net 2003). Class library. MS SQL used as backend server. Password encryption. Query optimization. Full text search. Huge database. Architecture development, Specifications development, Database design, hands-on development, and implementation, including Schema, Tables, Views, Stored Procedures and Triggers and Coding.

Also I developed bunch of WinForms utilities (C#) for database update/recalculate etc.

Environment: Windows 2000/XP, MS Visual Studio 2003, C#, .Net 1.1, MS SQL 2000 Enterprise.

Tools and technologies: MS Visual Studio .NET 2003 (C#), ASP.NET, ADO.NET, MS DOM, SAX, XML Spy, XSLT, XPath, XFD, XFT, HTML, JavaScript, Query Analyzer, UML, MS SQL 2000, MS Analysis Services, OLAP.

September 2003 – August 2004: Programmer Analyst

Ameriquest Mortgage Company Orange County, CA

Loan Origination Projects (Web project)

Tools and technologies: MS Visual Studio .NET 2003 (C#), ASP.NET, ADO.NET, MS DOM, SAX, XML Spy, XSLT, XPath, XFD, XFT, HTML, JavaScript, PVCS VM and Tracker 7.5, Query Analyzer, WinSQL, UML, MS SQL 2000, MS Analysis Services, OLAP.

Tools and technologies: Borland Delphi 6/7, Java, JSP, Borland JBuilder X, ASP, ADO.NET, MS Visual Studio .NET (C#), MS DOM, SAX, XML Spy, XSLT, XPath, XFD, XFT, HTML, JavaScript, PVCS VM and Tracker 7.5, Sybase Power Designer 9, SQL+, PL/SQL Developer, TOAD, WinSQL.

July 2003 – September 2003: Programmer Analyst

National Labor Relation Board – Global Consulting Group www.nlrb.gov Washington, DC

Project Case Activity Tracking System (CATS)

Tools and technologies: MS Visual Studio .NET, ASP.NET, ASP, ADO.NET, XSLT, Xpath, XML Spy, JavaScript, PVCS 7.5, Erwin 4, Crystal Reports 9.

January 2003 – June 2003: Sr. Software Developer

Digital Research Labs Cincinnati, Ohio

The ASP.Net application “Micmac” (Jan-June)

Tools and technologies: MS C#, MS Visual Studio .NET, XML Spy, ASP, ADO.NET, XSLT, HTML, JavaScript.

June 2001 – December 2003 Sr. Software Developer

Euregon AG, software development company http://www.euregon.de Augsburg, Germany

Sr. Software Developer.

Projects: Development of the application for ambulance organizations. 3-tier application (with GUI looks like MS Outlook). Business layer supported different databases (MS SQL, Sybase SQL Anywhere and Oracle). I developed the database, business objects, client applications (COM+ objects, schedulers, reports, graphics, drag and drop, messages system).

Tools and technologies: Delphi 6/7, MS SQL 2000, C#, Oracle 9 (another version of mid-tier), COM+/MTS, ADO, C#/Visual Basic 6/.NET, Install Shield, WISE, Dream Calendar, MS Office XP Developer, ReportBuilder, PVCS, JBuilder, Excel VBA, Sybase PowerDesigner 8, Rational Rose where used for development.

Administration of databases (MS SQL 2000). Managing Security (Creating policies, user groups). Importing and exporting data (DTS), bcp. Created tables, stored procedures, views, triggers. Managing Backups, Automating Administrative Tasks (Job, Alerts etc). Monitoring Server Performance and Activity, index tuning.

April 1999 – December 2002 Team Lead/Business Owner

Startup - software development company Kiev, Ukraine

Developing software modules for accounting and warehouse applications. Connecting commercial accounting software (usually 1C: Accounting) to the 3rd party software tools. Visual FoxPro was primary language.

April 1998 – February 2002 Sr. Software Developer

TV-park publishing company Kiev, Ukraine

Projects: Development and introducing of databases for marketing, bookkeeping and other divisions.

Environment: Delphi 4/5, MS VSS, Visual Basic 6, MS SQL Server 2000/7, Windows NT, 9x - for clients. Sybase DataArchitect 5.5, Sybase PowerDesigner 7, Citrix (deployment), Windows NT Server, UNIX (Linux, BSD) - for server.

March 1997– April 1998 Programmer, system administrator

UOIP Kiev, Ukraine

Projects: Development and introducing the databases (Delphi 3, Access 97).

EDUCATION

Dynamic Worldwide Training www.dwwtc.com Phoenix, AZ

Developing Web Applications with Microsoft Visual Studio (Course 10264A)

Santiago Canyon College www.sccollege.edu Orange, CA

English language training.

Kiev International University of Civil Aviation (KIUCA) Kiev, Ukraine

Master of Science. Diploma with excellent marks (Computer science / Radio engineer).

High School #206 Kiev, Ukraine

Class with Advanced Math and Physics 7-11 grades

LANGUAGES

English, German, Russian, Ukrainian.

KEYWORDS

C#, JavaScript, Visual Basic.Net, JavaScript,MVC, WCF, REST, Web.api, Java, Delphi, C/C++, Empower script, Visual FoxPro, SQL (T-SQL, PL/SQL, Watcom SQL), VBA, HTML, Java Script, VB Script, XML, UML, OOA. OOP, OOD, COM, DCOM, COM+, .NET, DHTML, ActiveX, HTML, ASP, ASP.NET, JSP, J2EE, WinForms, GUI programming, Win API, c sharp, dot net, help-compiler, Client/server technologies, MS SQL Server 2000, Oracle, Sybase SQL Anywhere, Web Forms, Win Forms, WinForms, Borland InterBase, replication, Windows 98/NT/2000/XP, MS Exchange Server, MS Outlook, IIS, ASP, ASP.NET, CASE tools, Sybase Power Designer, ER/Studio, ERWIN, Rational Rose, MS SQL Server 2000/7, ORACLE 9/8.i, Sybase SQL Anywhere, Interbase, Access 97/2000/XP, DBASE, Paradox, DBA, ADO, ADO .NET, Empower script, ODBC, OLE DB, DAO, RDO, JDBC, BDE, Distributed technologies, COM, DCOM, COM+, MTS, ASP, XML, XSL, TCP/IP sockets, Web Services, XML, Teamwork tools, PVCS, Visual SourceSafe, CVS, Borland Team Source,, MAC OS, Unix (Linux), Install Shield, Windows Installer (MSI), Wise, Symantec PC Anywhere, VNC, SMS, Active Directory, AD, Group Policy, GPO, DBA, TCP/IP, SMTP, POP3, network, AD, Seagate Crystal Report, ReportBuilder, Quick Report, MS Excel, OLE, OWASP,

Contact this candidate