Irina Rathsachack
Sioux Falls,South Dakota
Overview
26
26
years of professional experience
Work History
Data Mining Analyst
Cigna Ins
Sioux Falls, SD
11.2016 - Current
SQL – ETL - Database Developer / Data Sr. Specialist
Citibank
Sioux Falls, SD
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
Sioux Falls, SD
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
Sioux Falls, SD
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, SD01.2003
Associate Degree - Computer Programming
Southeast Technical Institute
Sioux Falls, SD05.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