Sr Developer & Analyst

-Resume-

Lorne Corrigan

Grand Rapids, Mi

**********@*****.***

SUMMARY OF QUALIFICATIONS

** ***** ** *** ****** development experience (versions 6.5 through 2005).

Highly proficient in SSIS and DTS ETL development.

In-depth understanding of security, backup and recovery procedures to ensure database integrity.

Adept in Replication (snapshot, transactional and merge).

Familiar with Log Shipping techniques.

Experienced developing and supporting multiple servers in multiple environments (Dev, QA, UAT and Production).

Strong analytical and debugging skills.

Skilled in all stages of software development life cycle (SDLC).

Effective in maintaining positive communications and working relationships at all business levels.

Proven ability to get the job done with little supervision.

TECHNICAL SKILLS

Databases: SQL Server 2005 / 2000, MYSQL, MS Access,

SSIS/DTS Packages, Triggers, Stored Procedures, User Defined Functions, Views, Schema design and development

Languages: Transact SQL, PowerBuilder, VB .NET

Tools: Erwin, Embarcadero, Visual SourceSafe, Remote Desktop, LiteSpeed Backup/Restore

Industries: Health Care, Pharmaceutical, and Manufacturing, Retail

JOB HISTORY

08/2011 - 09/2011 Medical Advantage Group - consulting and management physcians.

SQL Server SQL/ETL developer responsible for the development of SSIS packages and stored procedures to handle the import, cleansing and database storage of a variety of customer flat files.

Spent several weeks documenting 2 large MS Access databases. The orginial developers are gone and no one knows what the mdbs really do.

03/2009 - 09/2010 CareCore National – A Specialty Health Care Benefit Management Co.

SQL Server SQL/ETL developer processing large quantities of Health Care member and provider data for major US Health Insurance organization.

Perform ad-hoc queries and customized SSRS reports for contract managers.

Provide changes to database schema, sql and etl applications for efficiency and business requirement changes.

10/2007 - 11/2008 Taleo - Talent Software Development (formerly Vurv Technology)

Permanent Full-time SQL Server DBA/Developer

Maintained and developed SQL code and SSIS Packages in a SQL2000 and SQL2005 environments.

Managed DBA activities for development, QA, UAT and Production servers, including backup and restores, database security including encryption of data, coordination of builds through the different environments.

Provided assistance to development teams on tuning tables, indexes and queries.

Debugged issues raised by customers.

Developed ETL solutions for loading client data.

Migrated databases from SQL 2000 to SQL 2005.

10/2006 - 10/2007 The Great Atlantic & Pacific Tea Company (A&P) - Retail Grocery

Permanent Full-time SQL Server DBA

Performed daily administration, monitoring, and documentation of over 40 SQL Servers (2005, 2000, 7.0, and 6.5).

Established and maintained transactional and merge replication.

Provided assistance to development teams on tuning data, indexes and queries.

Designed and developed an internal departmental Web application using Visual Basic .NET. and SQL 2005 database.

Migrated several SQL 2000 databases to SQL 2005.

10/2002 - 10/2006 Independent Consultant

SQL Server and Application Developer

Clients:

A&P (2 contracts)

Federal Reserve Bank of New York and Richmond

Horizon Blue Cross (2 contracts)

Independence Blue Cross

3 years - Developed applications using PowerBuilder and SQL Server database version 2000.

1 year - SQL Server Developer writing SQL Code and SSIS Packages.

03/2000 - 12/2001 Gerard Daniel Worldwide - Manufacturer

Permanent Full-Time MIS Manager/Lead Technical Analyst

Was the Lead Analyst and PowerBuilder/SQL developer.

Major accomplishments:

Converted accounting system from SBT and IntelliSoft to Great Plains Dynamics.

Upgraded Order Entry and Billing systems from an old Dos based application to a more modern one by utilizing PowerBuilder and SQL Server.

Supervised conversion of Vendor Managed Inventory system from batch to Internet using ASP and Visual Interdev.

Trained and mentored development staff in PowerBuilder and SQL Server.

Planned and executed a physical move of the Distribution warehouse and Computer Systems from New York to Pennsylvania.

07/1986 - 03/2000 Tiffany Computer Systems - Software Consulting

Permanent Full Time Application and SQL Developer

Clients:

A&P (2 contracts)

Hoechst/Celanese (5 contracts)

Panasonic (2 contracts),

Horizon Blue Cross (2 contracts)

Bristol Meyers/Squibb (2 contracts)

Englehard

4 years - Developed applications using Powerbuilder and SQL

10 years - Developed applications using Cobol, CICS, VSAM

Memberships

NJ SQL Server User Group

Contact this candidate