Data Analyst

Sr. SAS Programmer/Developer

Results-driven professional with more than 10 years’ experience in database and application development. Interact with senior management and colleagues to derive business requirements pertaining to analytics and business intelligence (BI). Possess extensive experience in data conversion, requirements analysis and design.

Data Cleansing and Quality Assurance

SAS – Base, Macro, Graph, Stat, ODS

Extract Transform Load (ETL)

T-SQL, SQL

Data Mapping and Validation

JCL, COBOL, DB2, QMF

PROFESSIONAL CERTIFICATIONS

Microsoft Certified Solutions Associate (MCSA) - SQL Server 2012 Database Administration

Microsoft Certified Professional (MCPS)

PROFESSIONAL EXPERIENCE

BlueCross BlueShield of South Carolina Columbia, SC

Sr. Business/Data Analyst - Developer 2016-Present

Business/Data Analyst, 2015-2016

Retrieve, review, analyze, monitor and interpret data from multiple sources. Develop and execute complex queries on data sets containing millions of records. Validate analytical outcomes and create innovative and efficient methods for data gathering, data quality assessment and data analysis in support of operational functions. Administer and maintain databases; extract, transform and load (ETL) data and investigate and mitigate data-related issues via data validation and data mapping processes; and contribute to the design and support of new and existing information systems. Help in the development of quality-based healthcare initiatives by developing case studies; applying mathematical concepts and statistical analysis; and utilizing SAS (Base, Macro, Stat, ODS, Graph), SQL, Microsoft Excel and Microsoft Access to create reports that help with determining the feasibility and projected return-on-investment for projects. Present analytical information orally to technical and non-technical audiences including senior management.

Help in the development of quality-based healthcare initiatives by developing case studies; applying mathematical concepts and statistical analysis; and utilizing SAS, SQL, Microsoft Excel and Microsoft Access to create reports outlining trends and patterns that help with determining the feasibility and projected return-on-investment for projects. Present analytical information orally to technical and non-technical audiences including senior management.

Project lead on multiple initiatives utilizing industry best practices and continuously improving work-flow processes.

Key Accomplishments:

oOverhauled the existing quality-based measurement process by converting existing VBA code and Microsoft Access queries into SAS; normalized existing Microsoft Access databases and made existing SAS more efficient. Automated a once highly manual process of document creation, thereby reducing processing time by more than 97%.

oUncovered hidden defects and eliminated known and newly discovered defects.

Aon Hewitt (formerly Hewitt Associates) Virtual

IT Developer Analyst, 2011-2015

Develop, test and implement software and reports utilizing SAS (Base, Macro, ODS), SQL and JCL.

Analysis and mitigation of software defects.

Extraction, cleaning, transformation and loading of data using multiple sources and large data sets.

Data processing to include tax regulations; health and welfare data; and pension and retirement.

Creating analytical reports

Programmer Analyst, 2008-2011 Orlando, FL

Develop, test and implement software and reports utilizing SAS (Base, Macro, ODS), SQL and JCL.

Data conversion and data mapping using large input data sets.

Requirements and data analysis and design.

Create scheduled and ad-hoc reports.

Troubleshooting and debugging of software issues.

Coaching of more junior colleagues.

BlueCross BlueShield of South Carolina Columbia, SC

Programmer Analyst, 2004 – 2007

Code in COBOL, test, implement and support software while ensuring compliance with corporate standards.

Create reports using SQL, JCL, Easytrieve and Excel.

Make recommendations toward the development of new code or reuse of existing code.

Frequently work and coordinate with individuals across departments and with external customers.

Analyze production system and data problems and implement or recommend workable solutions.

MILITARY EXPERIENCE

US Army Reserve

Electronic Imaging Specialist Wilson, NC

Deployed - Camp McGovern, Bosnia and Herzegovina

Non-commissioned Officer-in-Charge (NCOIC) - Managed a visual information studio. Organized and documented 250+ events and missions through the use of photography and video.

Created graphical layouts and picture stories for distribution to guests of the base camp and for general display using Photoshop.

In charge of scheduling missions, supervising soldiers, inventory/supplies, and equipment accountability.

Secret security clearance.

EDUCATION

Nova Southeastern University, Davie, FL

Master of Science, Information Technology

Pacific Institute of Technology, Morrow, GA

Certificate, Microsoft SQL Server 2012 Database Administration

Defense Information School (DINFOS), Fort Meade, MD

Diploma/Military Occupational Specialty, Video Documentation and Production & Photography

University of North Carolina, Wilmington, NC

Bachelor of Arts, Mathematics, Minor Computer Science

PROFESSIONAL AFFILIATIONS

Technology Association of Georgia (TAG)

Professional Association for SQL Server (PASS)

Contact this candidate