Systems Analyst Business

GENE FRENKEL

Cheshire, CT ***** linkedin.com/in/gene-frenkel-89024960

BUSINESS SYSTEMS ANALYST

Business Systems Analyst Process Optimization Business Intelligence

Experienced Business Systems Analyst with a demonstrable track record of success process optimization and data analysis through streamlining process, minimizing errors, saving time and automating data loads. Instrumental in improving productivity across various organizations and implementing cost-saving actions. Incredibly adept at making complex data understandable with years of expertise in third-party tools and reporting.

TECHNICAL SKILLS

CICS Cobol Data Migration Databricks DataStage DB2 Debugging Flow Charts Hadoop IBM

JCL Microsoft Office Office 365 Oracle Oracle SQL Putty SAS SQL SQL Server SSIS Toad

Visual Basic VSAM Webex Windows

EXPERIENCE

Cigna, Bloomfield, CT 06/2010 - 10/2024

Business Systems Analyst 02/2017-10/2024

Deadline-oriented Programmer Analyst with proficiency in SQL and SAS. Collaborative team player with commitment to building positive business culture.

Support SQL databases and managing data flow processes, while providing technical leadership within the Provider Solutions and Operations team.

Develop a strong preference for Data Management on the Provider Solutions and Operations team.

Develop and maintain SAS data pull jobs from database sources like HCPM, PRDS, and CPF. Decreased running time by 30% by splitting jobs based on provider type.

Map and ingest data into PIRATDVA tables using SSIS data movement process. Maintain and update when needed the SSIS packages.

Support and maintain the PIRATDVA database on SQL Server. Preserve data accuracy by running automated audits. This results in less data integrity issues.

Build, maintain SQL code / stored procedures.

Pre-validated data, decreasing processing time by 25% for data advocates.

Maintain open communications with internal and external partners to resolve issues.

Package and load data files to third-party vendor utilizing FTP process.

Application Development Adviser 09/2012 – 02/2017

Act as tech lead with CCMI Prod Support team for the CCMI (Capitation Care Management Incentive) application from AIMS FFV Reimbursement portfolio.

Participate in the full Life Cycle spectrum of projects including business requirements, project scope, technical specifications, coding, testing, and implementation.

Provide comprehensive consultation to business and IT management on the principals of major system designs, available technology and existing tools.

Support a variety of applications that are part of the CPF selection such as PWB/CPF/FSS/CSM/Portico and CCMI as a member of the Provider Production Support team.

Computer programmer 06/2010 – 09/2012

Highly motivated Senior Software developer with hands-on experience in design, implementation and maintenance of various mainframe and PC based applications, including 3-tier Client-Server architecture, Database Management in Healthcare.

Designed, coded and tested COBOL II/SQL programs to update DB2 tables or populate database using

DB2 utilities.

Main responsibilities include program abends research, writing and executing one shots, analyzing business requests, and preparing estimates.

Serve as SME on Production Support Team for eLoad, CSM applications.

Work closely with outside vendors, DataStage, and EDI teams to ensure successful execution of 20 eLoad vendors.

Provide release implementation support as Technical Release Coordinator during release weekends.

Manage activities for the 24/7 emergency pager support for PWB/CPF/FSS systems.

EDUCATION

Baruch College, Manhattan, NY

Bachelor of Science, Marketing Management

State University, Tashkent

Bachelor of Science, Engineering and Computer Science

Contact this candidate