PAUL A. CUPEC

484-***-**** adhr4o@r.postjobfree.com

Souderton, PA www.linkedin.com/in/paulcupec

Summary

Data Engineer with extensive experience in the healthcare and pharmaceutical industries. Expertise in data warehousing, ETL processes, and both Agile and system development life cycle methodologies. Recognized for on-time and accurate population of production databases, identifying and resolving issues, building effective cross-functional relationships, and being highly successful in individual contributor and team member roles.

DATABASES / TOOLS

Databases: SQL Server Management Studio v17.3; Oracle 9i, 10g; Oracle SQL Developer 4.0

Production Schedulers: CA Workload Automation (DE-Series) V11.3; Informatica v7.0; Autosys v3.4, Windows Task Scheduler

Cloud/BigData tools: Talend Studio 6.1.1; Hadoop / HUE / Hive

Other tools/languages: Python, SQL, PL/SQL, UNIX scripting (Linux, AIX, HP-UX, ksh), Qlikview, Git, TOAD, Syncsort

Professional Experience

INTEGRICHAIN, Ambler, PA 2018-2020

Data Engineer / Production Support Analyst (02/2018-05/2020)

Ensured production databases were loaded to SLA specifications – timely and with correct data.

Performed debugging of ETL jobs and correcting user issues with data and/or databases on an ad-hoc basis.

Designed and implemented automation of data loads and data validations where appropriate, saving the team man-hours every month.

Developed python scripts and SQL stored procedures to perform data extracts & deliveries to external customers on automated schedules.

SYMPHONY HEALTH, Conshohocken, PA 2017

Data Analyst Consultant – contracted through TalentFlex Solutions (03/2017-05/2017)

Processed database extracts / report creations for external customers involving new product campaign effectiveness across multiple types of communication. Implemented initial validation checks in several of the extract scripts, flagging errors/issues to be handled immediately.

ACCOLADE, Plymouth Meeting, PA 2013-2016

Senior Operations Engineer / Data Acquisitions Analyst (06/2014-11/2016)

Performed daily operations - overseeing tasks including (but not limited to): monitoring batch processing of production data file loads - claims, utilization management, eligibility, and call metrics; managing ad-hoc requests for file transfers, data lookups, and script creations; troubleshooting load errors, script failures, system downtimes, etc.; communicating with data vendors, data partners, etc.

Transferred knowledge of all the current production processes to the newly-hired Operations team members, as the solitary trainer for Operations.

Subject matter expert (SME) on the team for migrating our SQL-server based data loads to the cloud technology platform (AWS) using Talend Studio and HUE / Hive.

Performed code deployments following agile methodology (weekly) – SQL, Talend, shell scripting.

Managed Qlikview reporting processes – including running Business Intelligence loads (reload/publish), application accesses, and licensing.

Supported internal customers (call center operators) by: Ensuring that the production database was up-to-date with all of the clients’ data (that the customers accessed via an in-house application); resolved problem tickets that they had created to address clients’ data issues.

Senior Data Quality Analyst (02/2013-06/2014)

Responsible for performing validations of the production eligibility data loads on a weekly basis. Also accountable for working on and correcting customer-focused problem tickets.

Took the initiative to convert the manual validation procedures to SQL scripts / stored procedures and incorporate them into the production ETL (Extraction, Transformation, and Loading) workflows. This reduced the overall time for the production loads by 20%.

Assisted on various projects and ad-hoc requests to decrease time-to-production in validation steps.

UNITEDHEALTH GROUP, Philadelphia, PA 2008-2012

Senior IT Data Analytics Analyst

Managed ETL of various data into production database encompassing claims, membership, and provider information for majority of states across the nation. Implemented many script (UNIX, SQL) modifications within these ETL processes supporting various business needs. Also responsible for doing production code deployments.

Primary developer responsible for the incorporation of a new type of external data into the production database, CHIP (children's health insurance program), from raw data file layout to loading into the database.

Collaborated with team members in designing / developing modifications to the monthly ETL processes for speed, efficiency, and ease-of-troubleshooting.

Handled the occasional bug fixes with the production ETL code in a timely manner, especially when in the midst of the production database load.

ASTRA ZENECA, Wilmington, DE 2000-2007

Senior Systems Design/Developer

Supported Sales, Marketing, Commercial Analytics, Managed Markets, and Incentives & Objectives groups with project work, data loads, data extracts, and ad-hoc requests. Ran production data loads for Prescriber and Contract Sales (Oracle 9i, 10g databases) on various schedules (weekly, monthly, and trimesterly) using both established and new technology (Autosys batch jobs and Unix (HP-UX) shell scripts (w/embedded SQL) and Informatica, respectively) as ETL methods.

Performed ad-hoc query generation, data exporting for business customers, external data vendors, etc. using shell scripts w/SQL to dump requested data in specific formats.

Developed several ‘tools’ for business departments by handling database aspects (creating report-specific tables/indexes) and working closely with front-end developer(s) assigned to these various projects. Used a combination of shell scripts (w/SQL, Autosys and/or Informatica) to automate data feeds and calculations required for these reporting tools.

Additional Experience

FIRST CONSULTING GROUP, Wilmington, DE Consultant / Team Lead

PRC, INC., Conshohocken, PA Application Developer / System Administrator

Education

Bachelor of Science, Computer Science Clarion University of Pennsylvania, Clarion, PA

Contact this candidate