Data Sql Server

James Crispin

Phone: 630-***-****

Email: **********@***.***

Address: *** **** ********* **. ******* IL 60187

IT APPLICATIONS SENIOR ANALYST / DEVELOPER

Accomplished IT professional skilled in business analysis, requirements definition, design, data modeling, development, implementation and maintenance. SME with ETL, Informatica PowerCenter, Unix, SQL, several databases. Excellent communication skills (former English teacher).

TECHNICAL AREAS OF EXPERTISE

Informatica PowerCenter

Oracle

Unix

SQL, PL/SQL, T-SQL

Netezza

XML

SSIS

MS SQL Server

Java

EDUCATION / CERTIFICATIONS

MBA

MIS, DePaul University

PMI PMP (2001-2010)

MS

Educational Psychology, Northern IL University

Sun Java 2 Programmer (2002-2004)

BA

English, Northern IL University

CompTIA i-Net+

PROFESSIONAL EXPERIENCE

CVS Health

03/2017 – 05/2017

Contract Developer supporting www.cvs.com via data migration. Released late 05/2017 for lack of work. [Informatica PowerCenter, Unix, Oracle]

Coventry Health Care, an Aetna Company

09/2007 – 01/2017

Senior Data Warehouse Developer, primarily working with external encounter data feed migration into an enterprise data warehouse. [Informatica PowerCenter, Unix, Oracle, Netezza]

Served as team lead for five developers who developed and supported applications to load Encounter vendor data into Coventry’s data warehouse, overseeing incoming data feed count increase from 25 to 100. Managed development & delivery schedule.

Led additional team (5 on-shore, 5 off-shore) to migrate 90 Encounter data feeds from Oracle to Netezza platform, including creation of design / coding specifications.

Scheduled and managed monthly application releases.

Developed pre-load data validation code to trap data errors before subjecting feeds to the data warehouse, reducing the production abend rate to near zero.

Advised and guided team members in technical design, coding, and testing.

Mentored less-experienced developers.

Established documentation standards.

Extracted from multiple data sources included flat files, HL7, XML.

James Crispin

CNA Insurance, Chicago IL

04/2002 – 09/2007

Application Development Specialist, focusing on claims adjudication support and enterprise data warehouse applications. [Informatica PowerCenter, Unix, Oracle, PL/SQL, SQL Server, Sybase]

Architected, developed, and implemented data mart for CNA’s actuarial triangle reports to consolidated and enhance capabilities of legacy systems. Benchmarked multiple physical database configurations. Automated mathematically-intensive requirements to generate test cases/results.

Maintained application which supports nurse case management of injury claim adjudication. Introduced extensive data integrity checks and corrections. Authored comprehensive database and batch process documentation.

Created conceptual and detail design for integration of claim notes from legacy application to new enterprise claim management application.

Designed & developed Unix Korn Shell script application to select/spool data files and invoke SFTP to transmit them. Authored step-by-step use guide.

PricewaterhouseCoopers, Chicago IL

03/1999 – 08/2001

Manager, focusing on like kind exchange applications for large auto leasers. [Oracle, MS SQL Server, PL/SQL].

Project-managed development and implementation of $2.5M Like Kind Exchange tax deferral system for the largest auto leasing fleet in the U.S. Interfaced with client senior-level client tax management. Coordinated geographically-dispersed development team of 1-10 persons.

Created conceptual and detail design for a calculation engine and related reports to support Layered Depreciation methodology for Like Kind Exchange assets. Mentored junior staff in requirements definition, development, testing.

Managed creation and implementation of Layered Depreciation calculation and related reporting for the Like Kind Exchange application of a $6 billion portfolio.

Deloitte & Touche / DRT Systems

03/1997 – 03/1999

Consultant, focusing on general web and client/server development. [PowerBuilder, Java, SQL]

Led creation of a web-based system to deliver software to 3000 physicians associated with a major health care network.

Led creation of application to manage the assignment of company-owned assets to all 5000 employees of a global management consulting firm.

Contact this candidate