Senior .NET Developer with SQL & UI Expertise

Tatiana Tsaritsyna

North Tustin, California, ****5

**********@*****.*** ; 949-***-****

Senior .Net Developer

Summary of Qualifications:

• Excellent Database knowledge and working experience

• Solid understanding of OOP principles, OOD and analysis

• Excellent knowledge and working experience in MS SQL, SSIS, SSRS, WinUI, C#, VB.NET, Java, WCF Computer Skills:

Operating Systems: Windows 2012 - 2003 Server/2000/XP, Linux (Debian) Databases: MS SQL 2019-2008, Oracle 10g, MS Access Languages: C#, ASP.NET, AJAX, HTML, CSS, jQuery, JavaScript, Angular, Python, VB.NET, Java Environments: WinUI, Visual Studio 2022-2003, .NET 1.1-4.0, Entity Framework, Kendo UI, MVC.NET, ASP.NET, EDI, OpenXML, Telerik Reporting, WCF, REST API, SSIS/SSRS, TFS, VSS 6.0, Crystal Reports, IIS 7/6 Education:

MS in Computer Science, Taganrog State Radio Technical University 1987 to 1992 Ect E Inc. (Oracle), Toronto, 1999

Work Experience:

WebTPA, Irving, TX

Sr .NET Developer Jan 2023 – Aug 2025

• Converting VB6 app to WinUI (MVVM) desktop app: worked on StopLoss, Benefit Administrator as a part of General and Claims Management projects: UI front and back end, APIs pulling data for GeneralManagement (EF, sps).

• Worked on a different business tasks to maintain and extend processing claims flow.

• Created new, updated existing SSIS packages, ETL processes, testing, deploying.

• Created new SQL jobs: console app (c#) for processing FloridaBlue group/contract files

• Maintaining code, adding new functionality for existed SQL jobs.

• Extended existing VB6 app, adding a new functionality, fixing bugs. Environment: VS2022, VS2019, SQL Server 2019, .NET, .NETCore, EF, WinUI, C#, REST API, SSIS, VB6, Git, DevOps Vital Data Technology, Newport Beach, CA Nov 2019 – July 2022 Sr .NET Developer

• Extended Affinite UI Web MVC app implementing new features and updating existing workflow (HEDIS certification solution): UI, middle layer, back end.

• Implemented reporting section of Affinite app: created new architecture for UI and business layer.

• Created various custom reports XML and Excel (MVC.Net, Excel, OpenXML, templates, SQL SPs/functions) for client’s needs to ensure HEDIS certification on time.

• Worked closely with Product manager to satisfy client’s fast changing requirements to get through certification (IDSS, PLD reports comparison, ad-hoc reports).

Environment: VS2019, C#/JavaScript/jQuery/ Bootstrap, MVC.Net, SQL Server 2019, Reporting C# MVC.Net/OpenXML, TFS, NPI CDI (OC Sheriff Dpt.) Santa Ana, CA March 2017 – Oct 2019 Sr .NET Developer

• Created Classification Interview MVC app for County Jail to classify inmates, adapting San Bernardino algorithm, extending existed Custody Center.(Kendo controls/SSIS reporting)

• Created MVC Public Center app for Fire Dpt. reading/saving/displaying PTZ camera’s snapshots in real time: Kendo UI/SQL Server.

• Converted legacy code 6 pack app from VB.Net to MVC.Net C# for identifying inmates (part of Resource Center) reports were done with Kendo Reporting /SQL Server

• Created MVC Web API Service Center for logging.

• Adapted RIPA Stop app to OCSD environment using React; Created MVC Web API to send RIPA records to CA DOJ, extended existing Common Center as a library for the other centers to use. Environment: VS2015, C#/Kendo UI/JavaScript/jQuery/ Bootstrap, REST API, MVC.Net, SQL Server 2014/17, SSIS/Telerik Reporting R12017, TFS, React

DB Schenker Irvine, CA Apr 2015 - Nov 2016

Sr .NET Developer

• Participated in creating Schenker’s system architecture as a base for further development

• Created Batches (EDI messages) for clients: Amazon, Clarins, Cisco, Lorex using C#, Oracle, SQL Server

• Created MVC apps and Wcf Services for Amazon and Cisco clients

• Created packages (stored procs/functions) in Oracle (WMS database) and sps/functions in SQL Server

• Modified and extended existing applications utilizing constantly coming client’s requirements

• Tested new messages in integration environment

Environment: VS2012, C#, ASP.Net Web Form, SQL Server 2014/2008R2, Oracle SQL Developer 4.0, TFS, WCF, MVC4.0, Linq, EF

Epicor Irvine, CA Apr 2014 – Oct 2014

SQL/.NET Developer (Integration team)

• Extended Library project (TitanLib) with new functionality (C#/LINQ to SQL)

• Developed SSIS packages using extended Lib project dlls, stored procedures, udf, Web Services, XML/XSLT/XPath

• Created ETL packages to ensure quality data flow from source to destination databases, error handling strategy used.

• Converted SQL Jobs into SSIS packages

• Created method/data directives (BPM) using custom code in C#

• Worked on integration projects for HR and Financial systems, ERP

• Tested integration projects in development, staging and production environments Environment: VS2012, C#, IIS 7, SQL Server 2012, VSS, SSIS/SSRS, Web Services, SQL Server Profiler, Linq OC Probation Center - Santa Ana, CA Feb 2013 – Feb 2014 Senior .Net Developer

• Developed new web application (Account Payable), created database schema, stored procedures/functions, worked closely with customers to create SSRS reports (parameterized, sub reports, drill down, with complex expressions), extended and maintained app corresponding to customer’s requests

• Extended and maintained existing web application (IPFS) due to business rules changes, customer’s requests through ticket system

Environment: VS2008, C#, ASP.NET Web Form, JavaScript, SQL Server 2008 R2, VSS, SSRS, Web Services Aimia (Carlson Marketing Canada), Mississauga Jan 2011 – Aug 2012 Senior .NET Developer

• Created data flow process loading reporting database (star schema), developed set of administrative and financial reports using SSIS/SSRS

• Extended and maintained existing multilingual websites (localization/enhancing old and creating new functionality) for Scotia and RBC banks.

• Converted web app with ASPX pages to ASP.NET

Environment: Microsoft VS2010, C#, ASP.NET, WCF, AJAX, jQuery, SQL Server 2008, .NET 3.5/4.0, Entity Framework, Crystal Reports XI, TFS, SSIS/SSRS

Commport Communications Inc., Aurora July 2008 – Dec 2010 Senior .Net Developer

• Developed ExchangeWeb and ExchangeTool WinForm desktop applications. ExchangeWeb provides web interface to Trading Partners to manage their business documents online and send them over to a HUB in EDI format. Desktop part of the system provides UI for personnel’s system administration.

• Designed and developed PaperLessLink web application that allows gathering EDI parameters from different users and update existing systems to configure EDI routing between trading partners Environment: Microsoft VS2008, C#, ASP.NET, AJAX, JavaScript, IIS 6, SQL Server 2008, SQL Reporting Services, .NET 3.5, Subversion/VSS, WinForm, X12

Bell ExpressVu, Toronto July 2005 – July 2008

Programmer/Reporting Analyst

• Extracted and analyzed data, created various automated reports (KPIs, scorecards, dashboards, templates) using Excel 2005, C#, VB.NET, SQL Server, Oracle according to business rules Environment: Microsoft VS2003/2005, C#, VB.NET, ASP.NET, VBA (MS Access 2003/2005), IIS 6, Crystal Repost, SQL Server 2005, VSS, MS Office

Contact this candidate