SAS Certified Base Programmer Resume

SUMMARY:

Skill Analytics professional with 5+ years of extensive Programming, Data Analysis and Reporting experience working majorly in Healthcare/ Insurance and Finance/Mortgage domains using SQL, SAS, SSIS and VBA Excel.
Data Quality Data Transformation Data Analysis
Data Visualization ETL Process Ad - hoc Analysis/Report
Extensively worked on Medicare database to extract membership, provider and claims data to measure the utilization of services, frequency of visits and payments to those services.
Experience in performing Business Intelligence Analysis in understanding complex business requirements and converting them into technical requirements.
Good understanding and working knowledge on ICD-9/ICD-10 CM/PCS, HCPCS, and CPT codes.
Experience in working on analyzing and reporting membership data, in-patient, out-patient claims, Facility claims, Professional claims, Medical and Pharmacy Claims data.
Expert in writing SQL queries and optimizing the queries in SQL Server 2005/2008/2012 and Teradata.
Competent in data extraction from multiple sources like MS SQL Server, Teradata, and Oracle using SQL implicit and explicit pass-through facility.
Proficient in handling large database using SQL Queries, strong skills in writing queries, joining multiple tables complex stored procedures, complex joins, function, view, and triggers.
Expertise in Designing & Developing complex Extract, Transform and Load (ETL) packages and Summary Reports using SQL Server Integration Services (SSIS).
Excellent knowledge in DBMS Concepts and Data Modeling using Star and Snowflake Schema.
Comprehensive knowledge of SAS Reporting Procedures, SAS Statistical Procedures and SAS Functions.
Excellent command in writing complex routines for data extraction, data transformation, data manipulation, and reporting using SAS/BASE, SAS/SQL, SAS/MACRO, SAS/ACCESS on various (WIN/LINUX) environment.
Thorough knowledge and experience of using SAS/MACRO facility for SAS code automation, customization, reusability and ad hoc reporting.
Adept in developing conditional statements using Query Builder, formats using Formats tab, summary statistics using tables, graphs, random sampling, and many other task in SAS Enterprise Guide.
Profound knowledge of Root Cause Analysis and Problem Management.
Experience in successfully carrying out data projects right from requirements gathering to analysis and reporting in a team-oriented or collaborative environment.
Good MS Excel skills include V H Lookup, Function, visualization using Pivot tables, graphs, and dynamic dashboard with parameters.
Excellent analytical, problem-solving, troubleshooting, communication and interpersonal skills. Self-starter and Dedicated to putting in the extra effort to achieve quality results with meeting deadlines.

TECHNICAL SKILLS:

Languages: Base SAS, Advanced SAS, T-SQL, PL/SQL, VBA, C, C++

Tools: Confidential .2 -9.3 - 9.4, SAS Studio, SAS EG, SQL Server Mgmt. Studio, SSIS

Databases: SQL Server 2012/2008/2005 , MS-Access, MySQL, Oracle 11g, Teradata, DB2

Operating Systems: Windows XP/ 2000/2003/7/8/10 , Unix

Reporting Tools: MS Excel, SQL Server Reporting Services (SSRS), Tableau

PROFESSIONAL EXPERIENCE:

SAS Certified Base Programmer

Confidential

Responsibilities:

Data Quality Data Transformation Data Analysis
Data Visualization ETL Process Ad - hoc Analysis/Report
Extensively worked on Medicare database to extract membership, provider and claims data to measure the utilization of services, frequency of visits and payments to those services.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship