Resume with short term contracts and gaps. Best format

[WhoWasMises]

Folks:

Thank you much for reading this. I'd like to hear back from hiring managers (who look at resume and choose the best qualified cv) and anyone else who has this kind of experience (too many short term contracts and career gaps). Please note your profession in replies.

My resume has too many short three to six month contracts with a single one year employment at the very beginning of my career. It also has some long gaps where I worked in the film industry. I have put in "Sabbatical Year" which has helped once but right now that entry would be in there three times.

I'm thinking of doing a summary like this:
1993-2015
Clients: Toyota, Nissan, Bank of America, etc.
Experience: Table creation, normalization, requirements gathering, SQL, Visual Basic, etc

 

[johnherman]

Yeah, that's what I did. I did a lot of contract and consulting work from 1998-2004. I wrote it like this:

2004 - present Corporate job - typical resume entry.

1998 - 2004 Project contract and consulting work in NJ, PA, DE, and MD.
then list and blurb the applicable projects in the order that they would be important for the job you're seeking.
then at the bottom of the project list, I put a statement:
This is a partial list of applicable projects; full details available upon request


==================================
adaptive uber info galaxies (bigger, better, faster, and more adept than agile innovative cognitive big data clouds)

 

[WhoWasMises]

johnherman, thanks for the reply.

Would you mind uploading your resume (with your info removed for privacy)? I'd like to take a closer look.

 

[johnherman]

Example per your request. I have removed certain proprietary system names and changed years to help prevent identifying info from being posted for "Major Corporation", who might object...... It doesn't show, but I use BOLD for the company names in the section for Project Consulting and Contract work.

1964-1972 Job with Major Corporation, Wilmington, DE.
Data Warehouse Specialist 1964-67
<management job title> 1967-71
Project Manager 1971-72
Relevant projects and assignments (not all inclusive)
• As Data Warehouse Specialist, worked with a team of three on the <proprietary name> Data Warehouse. Used ERwin to provide a unified view of two existing (but retiring) claims systems in conformance with a new claims system. Considerable data transformation and conversion activities using Oracle PL/SQL and PL/SQL views. Oracle 10g, HP-UX, Data Stage and Cognos.
• As <management job title>, led and managed day-to-day operations for IT services supporting the <proprietary system name> and <proprietary name> Data Warehouse. Responsibilities included technical oversight as well as project and budget oversight for fixed bid and time and expense projects to improve the system. Oracle, Java, HP-UX, Solaris, Websphere, SQL Server, Erwin, Data Stage.
• As Project Manager, led upgrades from SQL Server 2000 to SQL Server 2005, from Oracle 9i to 10g and 10g to 11g, and from HP Superdome server to HP Itanium server. All three projects required heavy regression testing using HP Quality Center, Load Runner and other automated testing tools.


1972-1984 Project Consulting and Contract work in DE, MD, NJ, PA.
Relevant projects and assignments (not all-inclusive)
• As Data Warehouse Specialist, assisted with Business Requirements gathering and verification for the Health Services Data Mart at Independence Blue Cross. Participated in JRP sessions. Participated in Extended Relational Analysis sessions to design the Logical Data Model. Provided mapping of LDM Entities to Report Requirements in a custom MS Access database. Remained on the project team, providing design support using ERwin. Analyzed and mapped medical claims data from multiple sources, interfacing with subject matter experts for business rules. Provided data profiling and quality analysis using Evoke Axio and custom SQL. ETL development using Data Stage and DB2/SQL.
• As Data Warehouse Specialist, provided prototype and production development for the installation of a Microsoft Analysis Services environment for American Express. Developed OLAP cubes and initiated Data Mining using DTS/SSIS and Transact-SQL in a production environment, supporting Cognos, and Excel front-ends. Resolved several data quality issues within Oracle source system. The OLAP cubes analyzed American Express’s charge and credit card products for small business and consumers, tracking metrics and key performance indicators, and replacing similar mainframe processes with cost savings.
• As Project Manager and Data Architect, led a team assembled to evaluate, analyze, and design a solution for the Finance department at DuPont. The focus was to replace an aging, custom-developed Decision Support System with an integrated custom and package Data Warehouse solution. Reverse engineered the current system using ERwin to define the project requirements and designed the star schema. Reassigned before project budget was approved, but project was successful.
• As Project Leader and Data Architect, led the development and implementation of an Operational Data Store for Air Products and Chemicals. The Procurement ODS acts as a switching hub, serving a dozen purchased and custom developed software packages, converting data between applications on diverse platforms. Designed the metadata-driven ODS using ERwin, implemented on MS SQL Server. Provided DBA support for the test environment, and wrote and tested most of the stored procedures and triggers using Transact-SQL.
• As Data Warehouse Specialist, provided ETL support for the Managed Care Data Mart at Independence Blue Cross. Designed star schemas and built prototype OLAP cubes for Claims and Provider data using Microsoft Analysis Services. Wrote ETL procedures to provide data to the cubes using DTS/SSIS and Transact-SQL, from various source systems to MS SQL Server database.
etc for as many bullets as appropriate.
(this is a partial list, there were other projects) Also, prior work experience is available on request.


==================================
adaptive uber info galaxies (bigger, better, faster, and more adept than agile innovative cognitive big data clouds)