Resume

Sign in

Clinical Research Data

Location:
Lake Zurich, Illinois, United States
Posted:
January 04, 2018

Contact this candidate

Steve Ratmanskiy

ac3wsc@r.postjobfree.com

www.linkedin.com/in/steve-ratmanskiy-02477213/

Phone: 847-***-****

Summary

18+ years of experience working with payroll and general ledger data, productivity reporting, financial reporting, clinical research and pharmacy drug pricing.

An expert and pioneer in implementing programs and solutions in the pharmaceutical, hospital and clinical research industries.

Experienced in managing all aspects of the software development life cycle (SDLC), from initial capture of the requirements through development, testing, delivery and enchantments.

Design scalable databases that will minimize data redundancy, minimize data restructuring, reduce transaction sizes, and enforce referential integrity.

SQL optimization, index tuning, storage and backup monitoring, data transformation and understanding of database structures, principles, theories and practices.

Proficient in SQL Server, T-SQL, ETL, SSIS, SSRS, PowerShell, VB, ASP, .Net, ASP.NET, VS.NET, MS Office and Crystal Reports.

Work Experience

Business Application Development Consultant 2002-Present

Rx-Net, Inc.

Responsible for core business application and database design, development, testing and support of production environment.

Design, develop and manage core business applications and infrastructure including database design, data processing and transformation, desktop user interface for internal employees and web interface for customer access.

Developed and evolved ETL interfaces to receive and transform the pharmacy pricing data from multiple data sources (Relay Health, First Data Bank, MediSpan and Pharmacy Claims reports) using SSIS, T-SQL, PowerShell and .NET.

Implemented interfaces with multiple pharmacy software vendors (Computer-Rx, Cost Effective Computers, Etreby, Liberty Software, McKesson, EnterpriseRx, McKesson Pharmaserv, McKesson Pharmacy Rx, Qs/1 and Rx30) to receive and process pharmacy claim reports and send daily price update files. Design and develop price update processing stored procedures and client software for McKesson Pharmaserv and McKesson Pharmacy Rx pharmacy systems.

Developed process that sends the price update files over SFTP to McKesson EnterpriseRx Pharmacy system

Assisted new and existing clients with integration, data conversion activities and establishing interfaces.

Identified data issues and provided recommendations for resolution to ensure optimal performance.

Worked with internal and external clients on import and normalization of third-party data.

IS Manager / Database Developer 1998 to 2017

RUSH University Medical Center

Team leader responsible for analysis, design, and implementation of HIPAA compliant information system solutions using development methodology.

Successfully led a clinical research database development to help scientist keep track of patient progress, outcomes and lab results. At scientist request wrote complex queries based on patient demographics, stage of disease, lab results and disease outcome.

Developed ETL solutions using SSIS, T-SQL and PowerShell to incorporate data from different data sources into main Cancer Center database to allow single point of access to all relevant data.

Designed and developed desktop application where data from multiple sources (GL, Payroll, Visits, visit complexity and RVU productivity, Budgeted vs Actual), for reports viewing, export into Excel on demand or request more complex query

Developed main research management application “Study Manager” – intellectual property of RUSH university. Study Administrator provides tools for study activation tracking, research trial budget creation, screening and accrual tracking, visits and procedures completion and sponsor billing.

Designed, developed and maintained Cancer Center web portal that provided centralized point of access to Cancer Center resources such as Cancer Center productivity/financial/research activity reports policies and procedures, access to in-house applications.

Designed and developed research patient specimens tracking database to complement research patient database developed earlier. Research patient specimen tracking application allow scientist to plan their work based on specimen availability and quantity.

Designed and developed multidepartment Provider Time Off web application with integrated security, two levels of approval and email notification.

Converted legacy VB6, Classic ASP and Access applications to SQL Server and .NET applications.

Education

Bachelor of Science in Information Technology

National Technical University of Ukraine

Kiev, Ukraine

Platform/Language Proficiencies

SQL Server, DTS, SSIS, ETL, PowerShell, VB.NET, Crystal Reports, Microsoft Office, IIS, Classic ASP, ASP.NET, HTML, JavaScript, Secure Black Box, MS Access, VB6, VSS, and MS Office automation

Affiliations

Member of Institutional Review Board (IRB)



Contact this candidate