Joe Warren

***** ****** *** ****

Katy, TX *****

(Home Office) 214-***-****

ac3z12@r.postjobfree.com

Objective

I am highly motivated with over 11 years’ experience in SQL development. I am looking for contract, contract to hire or permanent positions in a Microsoft environment.

Summary

Scope of expertise including:

11 plus years developing Microsoft Business Intelligence (BI) reports to provide mission-critical metrics and statistics (SSRS) creating stored procedures, triggers, and functions.

5 plus years Integration Services (SSIS) generating code to extract, transform and load data (ETL) in support of new data warehousing initiatives.

10 plus years providing critical day-to-day application support with SOP writing, training, testing, and data management.

6 plus years in applications planning, development and testing in an Agile/Scrum Project Development environment, working closely with .NET developers.

6 plus years QA Analysis including function, regression, and unit testing.

3 plus years writing queries against data warehouse

13 plus years business forecasting, dashboard development.

Skills

Databases: SQL Server Management Studio 2005/2008R2, 2012, AMISYS Claims Management

Microsoft BI Tools: T-SQL, SSRS, SSIS, Business Intelligence Design Studio (BIDS), Microsoft Report Builder

Oracle: PL/SQL

TriZetto QNXT

Operating systems: Microsoft, UNIX

Excel Tools: PowerPivot

Excel: Create and edit connections to external data sources

Data visualization: Sisense for OLAP cube creation against a data warehouse

Medical Claims Submission System: Pulse8

Source Control: Serena Dimensions, Microsoft Team Foundation; Borland StarTeam

Portal Technology: Microsoft SharePoint 2010

Software Development Management: Symantec Altiris

Accounting Software: Microsoft Dynamics Great Plains

Solid verbal and written communication skills

Professional Experience

July 2017 to Present

Baylor, Scott, and White Health Plan

Dallas, Texas/Remote

SQL Developer – Medicare, Affordable Care Act Claims Submissions (Contract)

Monitor Claims Flow from AMISYS to third party vendors Pulse8 and Edifecs for final submission to CMS/Edge Server for payment. Worked closely with claims team and financial auditors to ensure all claims presented were processed and accepted, or rejected claims analyzed and resubmitted.

Maintain SQL Code Library

Unit testing for code modification

Process documentation

March 2013 to July 2017

North Texas Specialty Physicians

Fort Worth, Texas

Senior Business Intelligence Developer – Medicare Risk Adjustment (Permanent)

SSRS Business Intelligence: Medicare Risk Adjustment SQL report development for QA and provider productivity

Business analysis: including analysis of trends for HCC-based risk adjustment factors, analysis of RAPS return files, submission QA, RAF projections, demographics studies

Work closely with SSIS team for process flow and quality analysis

Work closely with DBA for database management, implementation of SQL procedures and jobs; creating and maintaining a data warehouse

Play key roles in the design of specialty software with testing and deployment

2001 - 2013

Cellmark Forensics

(Previously Orchid Cellmark – a provider of forensic DNA casework analysis data)

Farmers Branch, Texas

Increasing range of responsibilities including:

Business Intelligence: Supporting company Business Intelligence (BI) initiatives (client mission critical metrics and statistics) Excel-based dashboards, BIDS dashboard, BI Reports generation utilizing BI tools (SSRS) that involved the creation and deployment of complex T-SQL stored procedures into BIDS as well as report implementation in a Microsoft SharePoint portal environment

Development of Integration Services (ETL) packages in support of warehousing initiatives (SSIS)

Application Development: Data modeling, database creation and implementation to develop and design database objects, such as tables, indexes, constraints. Microsoft Team Foundation Source Control. Altiris Software Management

Quality Assurance: Improved quality of software updates through functional testing of new software products Inventory Control, LIMS Stats, IQAS Quality Assurance Program using the Agile Software Development model including: creating UI test strategies/test plans; developing test cases; developing and executing case test scripts, regression, requirements testing and performance testing in a time-demanding fashion

LIMS Administration/Helpdesk: Supporting proprietary Laboratory Information Management System with SOP writing, training, testing, and data management

Education

University of North Carolina - Greensboro, Bachelor’s Degree awarded in 1987 (Magna cum Laude).

University of North Carolina - Chapel Hill, Graduate studies in genetics and molecular biology.

New Horizons Computer Learning Centers - 2778 Writing Queries Using Microsoft SQL Server 2008 Transact - SQL

New Horizons Computer Learning Centers – 6235A Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

Contact this candidate