Sr. Software Developer

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, VB.NET, Java

Environments: WinUI, Visual Studio 2022-2003, .NET 1.1-4.0, Entity Framework, Kendo UI, MVC.NET, ASP.NET Web Form, OpenXML, Telerik Reporting, WCF, REST API, SSIS/SSRS, TFS, VSS 6.0, Crystal Reports, IIS 7/6

Education:

MS in Computer Science, Taganrog Radio Engineering 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 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, testing, deploying.

Created new SQL job: console app (c#) for processing FloridaBlue group/contract files, consists of 2 phases: Staging DB load and working DB insert.

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 (OCSD) 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; 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

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.

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