COREY H. JACKSON

**** ****** ***** **.

Spring, Tx. 77379

Home: 832-***-****

Email: ad1n8l@r.postjobfree.com

OBJECTIVE: Application Developer or Database Architect/Administrator opportunity within the programming field.

QUALIFIED BY:

More than 15 yrs of Experience with (UNIX/NT/Window2000/XP/8/10)

15 yrs of experience Database development on SQL Server 2000, 2005, 2008, 2012, and 2014

15 yrs of experience using SQL and PL/SQL for Application and Report programming.

15 yrs of experience using CRYSTAL REPORTS 7.0-XI, Business Objects, and Qlikview 11 reporting tools.

10 yrs of experience using Business Intelligence (SSIS, SSRS, and SSAS) and SSDT.

10 yrs of experience with Data Mart, EDW, and Data Warehouse from OLTP and OLAP systems

5 yrs of experience using Window PowerShell on Window Server 2008r2, 2012, and 2012r2

EXPERIENCE:

3/04-Current Texas Children’s Health Plan, Houston, Tx

Database Architect – Business Intelligence team

Started as Sr. Programmer Analyst

Software/Hardware Experience: SQL Server Management Studio (2000-2014), Microsoft Visual Studio2005-2015, SSDT (SSIS, SSRS, SSAS), ACCESS, TFS source safe, HL-7 files, CRYSTAL REPORTS 10-11, Business Objects reporting tool and Qlikview 11 reporting tool.

Specific Responsibilities: SQL development and improved processes for (QNXT - Claims Processing System). I have developed ETL processes in SSIS from state files (p834 - enrollment, p837 - claims, and p87, p82, p40, p50 capitation files). Coded and built complex reports in SSRS. I have migrated SQL servers from 2000 to 2005/2008/2012/2014. I have architect fully functional databases in SQL server 2000-2014 in both OLTP and OLAP environments. I have also created PowerShell scripts call on SQL server 2008 and 2012 to give permissions for system processes and calling Active Directory processes. I created SQL Server Agent jobs and database calls from/to using Business Intelligence tools. I have architect EDW and data warehouses with Medical data, Pharmacy data, and built ancillary systems. We are currently using Qlikview 11 to report the data in the EDW. I’m very experience in data system migrations, SQL server development and mentorship of junior programmers on our team with their skill development.

Leadership role: In 2007, I lead the development team in migrating our claims processing system “DST – in Cobol” to “QNXT – in SQL”. This was 1-yr plus project of planning, requirements, development, and implementing. In late 2015, I lead the BI Data team with coordinating and executing our applications move from TCH environment to new network. Work with Health Plan Assistant Director to ensure applications integrated in new environment as plan in early 2016. Also in 2017, I lead the BI Data team to achieve one our P3 goals and convert all of Health Plan financial reporting from hosted environment to TCH data warehouse EDW. I lead the data team in planning, migrating, and deploying 17 financial reports with contractor Health Catalyst within a year.

9/00-2/04 Accenture Corp. – Texas Medicaid Healthcare Partnership, Austin, Tx

formerly (ACS Inc.- Texas Healthcare Management)

Programmer/Analyst III

Software/Hardware Experience: VISUAL BASIC 6.0-VB.NET, VISUAL STUDIO.NET, ACCESS, COM/DCOM, SOURCESAFE 6.0, INSTALLSHIELD, CRYSTAL REPORTS 7.0, INFOMAKER 6.0, SQL Server 6.5-2000, NT Server, Windows 2000, and Windows XP

Specific Responsibilities: I provide automated solutions for the Texas Department of Health, Texas Medicaid Systems. This system stores information on providers, members, claims, and healthcare. My responsibilities include components for the Medicaid system process; which is design, develop, and implement using VB 6.0, .NET framework, and Access. I use COM/DCOM objects to access the mainframe and HR system. Other applications I help build is Claims Search, Provider Search, Staff Training, and Transmittal Tracking System using VB 6.0. These applications include programming reports using Crystal Reports 7.0-8.5, and InfoMaker 6.0. I have 2 years of VB.NET experience on the current project called TRAC (Complaints and Appeals System). I provided HIPPA compliance designing and coding on application forms for the CPS (Claims Processing System). Experience in Full Life Cycle.

7/98-8/00 CACI Inc., Federal, New Orleans, La.

Database Architect/Administrator

Software/Hardware Experience: VISUAL BASIC 5.0, ACCESS, CRYSTAL REPORTS 6.0-7.0, BPwin, ERwin, SYBASE 11.9x, VISIO 4, COBOL, SQL Server 7.0, NT Server, and Window2000

Specific Responsibilities: Develop a prototype for (NOTAP) team in Access a Naval Occupational Surveys. Design and program the interfaces and database. This survey generates Queries, Macros, and Reports for randomly selected personnel in the Navy. The survey was later built in VB 5.0. Also, reengineered legacy system in (COBOL) using BPwin and Erwin. I have also independently created a survey for customers concerning Y2K assessments. The interfaces, database, queries and macros was built and tested by me in VB 5.0 with an Access database. Also helped with the conversion for the State of Alabama Department of Corrections (DOC) system from Unisys System 80 to Unisys 2200, which the written in Micro Focus Cobol. All code remediation and testing was done from a PC platform and implemented to mainframe.

3/96-7/98 Anteon Corporation, Montgomery, Al.

Programmer/Analyst II

Software/Hardware Experience: ORACLE forms 4.5-6.0, Developer2000, PL/SQL, Vi Editor, and ORACLE Report

Environment: ORACLE database and UNIX Platform operating system

Specific Responsibilities: ORALCE programming and UNIX programming entry. The project was Cargo Movement Operation System (CMOS) for the Airforce. Develop using Developer2000 (ORACLE Forms version 4.5, 6.0). Help design interfaces, and implement forms and PL/SQL code. I coded triggers and procedures for the application. The operating system is Unix platform with an Oracle database. Also used the UNIX editor and FTP changes from forms and reports to database.

EDUCATION:

5/95- 11/98 Auburn University Montgomery, Montgomery, Al.

Bachelor of Science in Management Information Systems

Graduated fall 98’

91-93San Jacinto College, Pasadena, Tx

Associate Degree in General Studies

REFERENCES: Professional references provided from employers and colleges upon request.

Contact this candidate