Overview
Work History
Education
Skills
Otherrelatedinformation
References
Timeline
Generic

Irina Rathsachack

Sioux Falls,South Dakota

Overview

26
26
years of professional experience

Work History

Data Mining Analyst

Cigna Ins
11.2016 - Current

SQL – ETL - Database Developer / Data Sr. Specialist

Citibank
11.2014 - 11.2016
  • Client Experience Research Database Development
  • Extract, transform, and load data from multiple sources into central database and making that data available for analysis
  • Design and maintain high performance automation of data load for the Client Experience Research process
  • Responsible for all phases of the database life cycle including design, coding, testing, setting up security and documentation
  • Writing complex dynamic cross tab queries for data analysis

Applications System Engineer

Wells Fargo Bank
03.2007 - 05.2012
  • User Interface Application Design and Development
  • Was part of the IT group that was responsible for the Loan Origination software written in C#.NET
  • Worked closely with multiple groups such as Project Managers, Database Administrators, and Quality Assurance group during project development Life Cycles
  • Created technical design documents for the provided Business Requirements
  • Worked on software development on my own or with other developers
  • Was a C+.NET mentor to the junior developers

Senior Programmer/Analyst

CitiBank
01.1999 - 03.2007
  • User Interface and Web Applications Design and Development
  • Was part of the MIS group that created internal MIS website and was responsible for multiple supportive applications and MIS web application
  • Developed application mainly using VB and ASP.NET, Crystal Reports, and XML Viewer
  • Worked closely with internal users during requirements and quality assurance cycles

Education

Bachelor's Degree - Business Administration

University of Sioux Falls
Sioux Falls, SD
01.2003

Associate Degree - Computer Programming

Southeast Technical Institute
Sioux Falls, SD
05.1999

Skills

  • Project Management
  • Database Administration
  • SQL Programming
  • Programming
  • Web Programming
  • Tableau Reports
  • Microsoft Reporting Services
  • Microsoft SQL Server 2015
  • VB Script
  • Writing Automated Test Scripts
  • Writing Software Test Scripts
  • Writing Technical and User Instructions
  • Writing Technical Requirements
  • XML (Files and Schemas)

Otherrelatedinformation

One of the projects that I was a lead programmer on for more than 3 years was creating and supporting a web application for 300 internal users. I was a lead programmer over 2 senior programmers. The project involved users from 5 teams in 5 states. After it was implemented in production, more businesses throughout organization signed up to use the website. It was a very high complexity process, which involved automatic data transmission using Connect Direct software, importing data into SQL database located on 4 servers, downloading and comparing data from multiple mainframe systems, data processing by representatives using website application, and generating numerous audit logs. I have received high performance appraisals from upper management for this project.

References

Available upon request

Timeline

Data Mining Analyst

Cigna Ins
11.2016 - Current

SQL – ETL - Database Developer / Data Sr. Specialist

Citibank
11.2014 - 11.2016

Applications System Engineer

Wells Fargo Bank
03.2007 - 05.2012

Senior Programmer/Analyst

CitiBank
01.1999 - 03.2007

Bachelor's Degree - Business Administration

University of Sioux Falls

Associate Degree - Computer Programming

Southeast Technical Institute
Irina Rathsachack