Eric A Sissom

*** ********* **. #****, ******** TN 37067 615-***-**** ad0c1s@r.postjobfree.com linkedin.com/in/eric-sissom

DATA ANALYST

Successful Analyst / Engineer with emphasis on data analysis, database design, and data management. Proficient skills in business intelligence software such as SQL Server Integration Services (SSIS) to load / transfer / import / export data for reporting in various file formats with focus on data quality using multiple database systems and data warehouses. Excellent coding in SQL with joining multiple tables for data results based on business requirements. Focus on process improvement by analyzing code, SSIS packages, and other areas of need. Manages priorities on multiple projects and meets deadlines successfully. Motivated, detail-oriented team member looking for the next opportunity to further challenge his skills in the every changing data environment.

CORE COMPETENCIES

Data Analysis Data Computation Data Management Business Intelligence (BI) Database Design

Data Warehousing Data Mining Data Modeling Project Management Report Generation Data Engineering

Online Analytical Processing (OLAP) Extract-Transform-Load (ETL) Object-Oriented Programming (OOP)

TECHNICAL SKILLS

Microsoft Visual Studio (with SQL Server Management Studio / Data Tools / Business Intelligence Development Studio)

Access (advanced) Excel (advanced) Visual Basic for Applications (VBA) IBM Netezza Teradata Oracle

Apache Hadoop / Hive Google Cloud BigQuery Coginiti Pro SAS XML PowerPoint Visio Word Windows

PROFESSIONAL EXPERIENCE

CVS Health Data Engineer 01/2021 to 10/2023

Aetna Informatics Analyst 05/2013 to 01/2021

Coventry Pharmacy Business Analyst 01/2012 to 05/2013

From Coventry in 2012 to Aetna and CVS Health, these positions included the same or similar duties as a member of a Data Engineering / Data Management team within the pharmacy operations department. These included:

Data processing with SQL, SSIS, SAS, Access, and Excel. Importing and exporting data vie multiple file formats and retrieving or sending files vie FTP servers.

Completed daily analysis of RX claims data to find potential issues.

Worked with business partners to establish processes for sending or receiving data. Loaded data from various venders to provide reports or for analysis.

Determined Business / Functional / User Requirements for data requests, processes, or reports. Excellent customer relations with internal or external clients and vendors.

Created or modified SSIS packages for various purposes to support the needs of the department and/or business.

Wrote complex SQL queries to pull data from multiple tables and database schemes. Provided results for ad hoc data requests. Created database tables or views for loading data or query results.

Analyzed data query results to identify data quality issues that need to be corrected. Verified data accuracy by test queries and/or normalization. Researched and identified root cause analysis to figure out solutions to data issues.

Developed efficient data reporting applications and processes. Created SSIS packages to export data to Excel, Access, CSV, or text files. Generated customize reports based on data and/or business requirements.

Assisted in developing Relational Database Management Systems (RDBMS). Used SQL stored procedures to improve data operations. Monitored database usage and preformed cleanup operations to reduce space.

Documented processes, methods, specifications, and results clearly. Familiar with data dictionaries.

Extracted data from multiple sources and created integrated analytic data sets. Produced Excel spreadsheets on data results for further analysis.

Assisted team with data projects, database design, and troubleshooting issues. Improved business and/or data processes by automation and/or analyzing SQL or other code.

EDUCATION

Master of Science (MS), Information Systems – Middle Tennessee State University

Bachelor of Science (BS), Information Technology – Middle Tennessee State University

Contact this candidate