Irina Chizhov Email and Phone Number

• Provided consistent service to customers in data management and application support.• Designed IT solutions based on business and/or technical requirements for finance and medical management departments.• Integrated multiple sources of healthcare data: lab, medical and pharmacy claims, membership and provider for HEDIS project.• Responsible for the clear and detailed documentation such as standard operating procedures (SOP), process maps and business requirement documents (BRD).• Implemented and maintained new SSIS solution for HEDIS project that reduced time up to 50%.• Optimized SQL queries, stored procedures, and ETL processes to decrease execution time.

• Tested, designed and maintained tables, constraints, indexes, UDF functions, stored procedures and views.• Extracted data from multiple sources, integrate disparate data into a common data model, and integrate data into a target database, application, or file using efficient ETL processes.• Collaborated with Quality Assurance resources to debug ETL development and ensure the timely delivery of products• Performed migrations from development to production, upgrades, installations and configurations.

• Maintained database tables, UDF functions, stored procedures and SSIS Packages. • Created and modified of various SSRS Reports in SQL Server 2008 R2. • Provided development of ASP.NET Web Intranet Applications (ASP.NET, C#).• Developed Caring Voice Coalition’s portal (MVC3: models, razor views and controllers). • Conducted system, regression and integration testing of new releases.

• Developed various types of SSRS reports for Dominion Packaging. • Provided development, regression testing and after hours on call support (problems and code changes).• Created user group importer project to quickly create new users and groups into the Qualtrax system, rather than one at a time through the standard system administration pages that decreased operation time more than 60% and reduced input errors by implementing validation up to 70%.

Responsibilities included development, testing and implementation of a Calendar Event Web-based ASP.NET Internet application. • Developed Data Access Layer (SQL Server 2008). • Designed, implemented and maintained Database Schema, Tables, Stored procedures, Constraints, Indexes, Functions.• Designed and developed User Interface. • Post implementation adjustment, user training and maintenance.

Developed large web-based applications to provide members with pharmacy benefit information; care managers and plan administrators with reporting tools. • Responsibilities included compiling business requirements and technical design (database, security, multiple UI for new software), regression and integration testing, post implementation adjustment and maintenance. • Co-designed database architecture, business logic tiers and user interface.• Developed data access layer and the business logic layer, data loading, database maintenance routines, more than 200 tables and dozens of stored procedures.• Used DTS migration wizard to convert DTS to SSIS packages and develop new SSIS packages.

Designed, implemented and maintained large and multifunctional payroll system, created implementation plan, related documentation backups and tested. Technology used: FoxPro, ORACLE-7, PL-SQL, Word, Excel.• Co- designed database architecture, business logic for the complicated system with more than 2500 employees.• Created Tax and Deduction applications. • Designed and developed multiple interface processes for Financial and HR Applications.