Inga Serebriansky

Sr. Data Engineer

: 201-***-**** LOC: 200 Winston Dr., Cliffside Park, NJ 07010 E: ad3yeb@r.postjobfree.com

Profile / Summary

An experienced Data Engineer, with a proven track record of enhancing existing systems to improve performance, add functionality, and integrate new technologies.

Strength in project management, excellent analytical and problem-solving skills.

Key Skills / Competencies

SSIS ETL tool

SQL Server 2019

T-SQL

VB.NET/C#

XML

Azure DevOps

Web Services

API

Azure DF

iTextSharp Component

VBA

SQL Agent

Python

EDI

ASP.NET

ADO.NET

Pervasive

HIPPA

Education / Qualifications

1988: Georgian Technical University, Tbilisi USSR: Equivalent to MS - Electronics Engineering

1999: The Chubb Institute, Jersey City, New Jersey: Diploma of completion – Programming/Computer Science

Career Highlights / Key Achievements

Command Digital: Lead Developer and Data Analyst

A Horizon Commercial Contracts project to process Cierant XML format batches for different types of printing documents, letters and brochures. Transitioned existing legacy project with poor performance to scalable and efficient SSIS solution utilising .NET component iTextSharp. Increased performance and satisfied sales requirements to process new enrolment contracts

A Walter Kluwer Purchase Orders project (POD) to parse 850 EDI file and create data records in ProShip internal database. Generated 856 Shipment confirmation file to confirm order/item level & shipment information back to client.

Streamlined internal processes to control inventory and push it to VeraCore system, increased book’s sale significantly

A CareFirst ID Cards project to load mixed format data file (header, detail, trailer) and build complex household logic.

Designed robust, automated solution to satisfy the business requirements using best ETL practices.

Collaborated with GMC developer to design and build ID cards for new and change plans.

Career History / Work Experience

July 2015 – December 2023: Strategic Content Imaging Corp d/b/a Command Digital

Secaucus, New Jersey: Sr. Application Developer/Data Analyst

Designed data warehouse for new client CareFirst utilizing SSIS ETL tool and complex T-SQL (stored procedures with CTE, correlated sub quires, functions). Lifted and shifted SQL server IS workloads to the cloud.

Uploaded and advocated for high standards in code quality, testing, and maintainability using Azure DevOps.

Developed requirement recommendations from a project’s inception to its conclusion for IT subject matter area.

Coded multiple VB.NET Scripts for database connections, IO operations, parsing XML source files.

Built SSIS package to read and load data from multiple XML files to multiple outputs, utilizing transformation Script component.

Researched, tested and evaluated the new features of SQL Server database engine like UTF-8 encoding support and

automatic tuning.

Worked with Avanti SlingShot Job Ticket Integration being a liaison between technical team and business stakeholders.

Led StoreFront integration for Aetna client, developed stored procedures, used complex SSIS packages to exchange data with GMC and produce final production pdf’s for print.

Analyzed and built logic for multiple health plans within Aetna Medicaid Kit Fulfilment Project. Created Index/Composition files, utilizing complex parameterised stored procedures.

Performed root cause analysis on ETL processes and resolved production issues, documented all test procedures for systems and coordinated with project manager to resolve the issues.

May 2014-November 2014: Affinity Health, Bronx, New York: Sr. Programmer Analyst

Worked with Facets extensions VB.NET windows custom applications and TFS.

Exhibited in-depth knowledge of how own specialism contributes to the business when leading complex healthcare projects.

Designed and developed Customer Service Top 10 report using Crystal Report and Infoview.

Analyzed and pulled complex data from Facets database, improved performance of the report by doing performance tuning in stored procedure.

December 2012-May 2014: Emblem Health, Manhattan, New York: Systems Programmer Analyst

Migrated multiple databases from SQL server 2005 to SQL Server 2008(64 Bit OS).

Set up database and server level permissions, moved jobs and operators, created proxies to enable SQL Server Agent functionality across the network.

Served as an SQL server expert in the DocScience Group to implement best practices and tips for optimization and normalization of databases.

Improved reliability and streamlined Mass mailing Go Paperless internal workflow.

Obtained member information by Consuming Web Services in SSIS Script transformation component.

Wrote meta-data directly to the HIP portal utilizing web service calls and built the file to be submitted to ExactTarget for e-mail process.

August 2012-October 2012: Barnabas Health, Newark New Jersey: Database Consultant.

Created stored procedures from PICIS database utilizing best performance tuning and optimization.

Responsible for creating series of reports to meet requirements of Institute of HealthCare Optimization.

Performed complex analysis of surgical data utilizing SSIS, Excel and SQL Server 2008 MS.

Utilized Conditional Split, Pivot Transformation, Data Conversion, Derived Columns task in Data Flow of an SSIS package to modify and analyze data as it passes from source to destination.

January 2007-June 2012: TouchStone Health HMO, White Plains, New York: Systems Analyst.

Functionally responsible for coding DRGActive.Net Enterprise Application - primary component of health care claims reimbursement determination for Medicare. Call .NET assembly from SSIS Script Component, work with GAC, and code event handling error routine.

Met requirements for HIPAA compliant 270 format using Pervasive Data Integrator. Maintained quality by being able to translate and transfer data from application to file.

Played key role in XML Import project for provider and authorizations incremental in IKA system by communicating technical design and processes in managing client and business expectations.

Contributed strong technical expertise for Evolution Benefits File Interface Process which was designed to provide TouchStone members with a prepaid MasterCard card for a loyalty incentive program.

Created low-level design to combine different record types in one text file in SQL Server. Designed internal tables, coded stored procedures, function, indexes and views.

Created, troubleshot, and transmitted MEDSII encounter file to NY DOH. Built provider-matching routine to identify MMIS unique provider id, utilizing VB.NET classes.

Developed Emdeon Claim Status File. Successfully mapped and built cross-walk table for Washington Publishing Company HIPAA-compliant claim status codes.

April 2006-October 2006: IBM Global Services, Horizon BCBH client, Newark, New Jersey: Consultant.

Responsible for low-level design, analysis, coding and testing of Quality Recognition process, that assigns corresponding types of contracts to the providers based on performance level attributes, networks, indicators, regions and programs.

Extensively used SQL Query Analyzer and Enterprise Manager to review data schema of QBLUE, QMACS databases, developed stored procedures with enabled control and balance technique.

Built logic that populates contracts by analyzing provided attributes – performance levels (data loaded from CREPRO feed) using complex Transact SQL coding. Collaborated with team for Contract Auto Assign Project that automated the process of assigning various types of contracts on daily basis.

Actively participated and advocated for high standards in code quality, testing, and maintainability.

Created complex correlated sub-quires utilizing different predicate functions and CASE statements.

June 2005-March 2006: Horizon BCBS, QBLUE Group, Newark, New Jersey: Consultant.

Designed, coded, and implemented the new Healthcare product CDH MyWay 2006.

Conducted analysis to match collected data to file specifications and mapping documents,

wrote specks for the system architecture, built common module that massages and formats data used in three feeds sent to different partners.

Created DTS packages scheduled and run through BMC for Outbound/Extract File processing.

Earlier Career

September 1999-August 2004: GMA Accessories, Secaucus, New Jersey: Programmer Analyst

Years 1990-1997:Depatment of Automation Technology, Tbilisi, USSR: Programmer Analyst

Training / Certification

2024: AZ-900 A Microsoft Azure Fundamentals -The Knowledge Academy

2010: HandySoft BizFlow Web Maker Training

2008: In-house training for Pervasive Integration Fundamentals

2002:Training in Programming for MS SQL Server 2000

IT Skills / Software

SQL Server 2019, SSDT for Visual Studio 2017, Microsoft office, Visio, MS Access, Softartisans ExcelWriter

Additional Information

Active supporter of Humane Society International

Professional social media platform

Inga Serebriansky: https://www.linkedin.com/in/inga-serebriansky-454b024/

Contact this candidate