.Net 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, C#, VB.NET, Java, WCF

Computer Skills:

Operating Systems: Windows 2012 - 2003 Server/2000/XP, Linux (Debian)

Databases: MS SQL 2017-2008, Oracle 10g, MS Access

Languages: C#, ASP.NET, AJAX, HTML, CSS, jQuery, JavaScript, Angular, VB.NET, Java

Environments: Visual Studio 2017-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:

Ect E Inc. (Oracle), Toronto, 1999

MS in Computer Science, Taganrog Radio Engineering University 1987 to 1992

Work Experience:

Vital Data Technology Nov 2019 – present

Sr .NET Developer

•Extended Affinite QI 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, Angular, MVC.Net, SQL Server 2019, Reporting C# MVC.Net/OpenXML, TFS, OpenXML, NPOI

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 and SSIS reporting were used.

•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# app for identifying inmates as part of Resource Center. Kendo Reporting was used to produce reports: Kendo/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.

•Gathered business requirements from Business Units, implemented and tested apps.

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 stored proces/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

•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 desktop applications. ExchangeWeb provides web interface to Trading Partners to manage their business documents online and sends them over to a HUB in EDI format. Desktop part of the system provides UI for system administration for personnel.

•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

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