Position Qualifications

An experienced business analyst and programmer with over 20 years of experience in the insurance industry including Claims, Provider, Member and clinical information. Have worked with a variety of databases including Netezza , Teradata, and Oracle. Have worked on analysis projects to develop an entity data model and on projects modeling data on an enterprise level.

Technical Skills

Professional Experience

Confidential

Business Analysist Specialist

• Worked as part of the Cigna Finance Initiative Development and Accounting Support team to maintain and enhance the Medical Loss Ratio MLR system.
• Access data in DB2 tables containing medical claims data, using SAS Data Step Proc SQL and SQL
• Modified SAS programs, macros, and formats to satisfy changing business needs
• Developed and executed test plans
• Researched discrepancies and anomalies in data

Confidential

Business Project Specialist

• Worked as part of the Cigna Information Management Analytics CIMA Communications team to maintain and enhance the Collaborative Accounting Care CAC system.
• Reviewed business needs to developed formal requirements specifications
• Developed acceptance test plans
• Access data in DB2 tables containing medical claims data, using SAS Data Step Proc SQL and SQL
• Built prototypes of planned enhancements
• Developed benchmark data
• Performed acceptance testing.

Confidential

SAS Developer

• Worked as part of a Vision Technologies development team, building a SAS based system supporting the Alternative Quality Contract initiative of BCBS. This system utilizes a NETEZZA based data warehouse.
• Developed and modified SAS programs to meet specifications in processing and reporting
• Unit tested programs, participated in system integration testing, and supported user acceptance testing.
• System made extensive use of SAS MACRO language
• Utilized WINSQL and SAS Enterprise Guide.

Confidential

Senior SAS Consultant

• Worked on various SAS projects using multiple database back-ends such as Teradata, Oracle and DB/2.
• Accessed data related to Medicare pharmacy claims.
• Data accessed on multiple data bases data warehouses in DB/2, Oracle, and other relational databases.
• Wrote SQL queries using MS Access pass-through code, SAS PROC SQL, SAS Data Step, and other SAS PROCS. Used SAS Enterprise Guide.
• Lead analyst programmer for project to provide Star Rating reporting for medication adherence rate in support of Accountable Care Organization ACO initiative.
• Provided rapid turnaround ad hoc reports.

Confidential

Consultant

• Utilized SAS Data Mining Tools and other SAS tools
• Accessed a variety of data sources, including accident reporting.
• Downloaded U.S. Census data for Connecticut, and Massachusetts, converted to SAS data sets, and provided access to this data to users.
• Analyze possible data source for data collected and generated by assessors of towns in Connecticut and Massachusetts.
• Created SAS programs using SAS Enterprise, and SAS Data Integration Workbench.

Confidential

Senior SAS Programmer

• Accessed Medicare Claim Data.
• Wrote and ran SAS programs in on a UNIX platform, where appropriate exported results to EXCEL worksheets where pivot tables could be produced, utilizing MACROS where appropriate also exported to MS ACCESS tables.
• Utilized both SAS PROC SQL and SAS Data Step. Made extensive use of SAS MACRO language.
• Analyze data for Colonoscopy study.
• Produced rate data e.g. Inpatient Back Surgery per 1,000 Medicare Enrollee for The Dartmouth Atlas.
• Produced Healthcare Effectiveness Data and Information Set HEDIS .

Confidential

Senior Information Analyst

• Populating research data mart consisting of many SAS datasets on a UNIX server while information extracted from production IMS and DB/2 databases on IBM MVS mainframe. Supporting use of SAS, EXCEL, data and text mining software.
• Spearheaded data and text mining practice enabling researchers to utilized unstructured data in building predictive models.
• Streamlined data acquisition process enabling management to reduce staff size.
• Provided research team with business knowledge of bodily injury claim data enabling project team, unfamiliar with bodily injury terminology to proceed with project became recognized as subject matter expert by team members.

Participated in pilot projects evaluating use of Teradata device.

• Utilized SAS functions to display data in form of a map, enabling researchers to show geographic aspects of data patterns that are not otherwise apparent.
• Incorporated MACROS and MACRO VARIABLES where possible to maximize flexibility and reusability of code produced and minimize development and maintenance effort.
• Made extensive use of SAS PROCS such as CONTENTS, FREQ, MEANS, SQL, TRANSPOSE, DATASETS, PROC FORMAT
• Created ODS links between SAS DATASETS and EXCEL
• Delivered Reports as EXCEL PIVOT TABLES where appropriate.

Confidential

Senior Application Developer

Developed and maintained production and ad hoc business intelligence reports using FOCUS, FOCUS SQL, SAS, and COBOL.

Confidential

Senior Programmer Analyst

• Participated in several consulting engagements, including:
• Maintaining the health insurance claim processing system for Group Health Insurance. This is a system based on VSAM, COBOL, CICS, SAS, and EASYTRIEVE running in an MVS environment.
• Designing an interface between the Group Health Insurance managed care system, which ran on a SQL system running in a UNIX environment and its fee for service system which was based on VSAM in an MVS environment.
• Maintaining the supply chain management system for Unilver, which was a COBOL CICS system running under VSAM in an MVS environment. Only SAS resource on team and had complete responsibility for all of the reports produced by the system, which were produced by SAS. Assisted other areas of UNILEVER in resolving SAS problems.