[Gregory.Spillman]

{

[West coast: suite #*** **00 N Green Valley Parkway #440, Henderson, NV 89074];

[702-***-****];

[East coast: 4001 Kennett Pike, Ste. 134-460 Greenville, DE 19807-2000];

[302-***-****];

[o83t12@r.postjobfree.com];

}

/* HIGHLIGHTS */

1. More than 15 years of versatile experience in the software industry

2. Dynamic and skilled IT professional with proven success in enterprise and commercial software project/product development

3. Specializing in Extraction, Transformation, and Loading, and software automation

/* SKILLS SUMMARY */

ETL:    DTS, SSIS, Packages, Transformations, Scripting;

Database: MS SQL Server (6.5, 7.0, 2000/MSDE, 2005), IBM DB2, AS400 iSeries, SQL performance monitoring and tuning, SQL-DMO, SQL-SMO, ISQL, OSQL, MS Access (1.1 ý 9); some experience with Informix, Oracle and Sybase;

Business Intelligence: UDM and OLAP Cubes, MDX, SQL Server 2000 Analysis Services, SSAS 2005 and 2008, ProClarity 6.3, ProClarity Developer, SharePoint, Office Web 2007;

Reporting Tools:  SQL Server Reporting Services, MS Access Reports, Crystal Reports;

Architecture:  Extensive experience in object and data modeling and translating use cases into application and data models;

Platforms: Windows (3.0-Vista), UNIX, Linux (Mandrake, Debian, RedHat, SUSE), DOS;

Languages: C#, C++, Visual Basic (all versions), HTML, Transact-SQL, VBScript, JavaScript, Net Framework 1.0 ý 3.0;

Software Methodology:  CMM (Capability Maturity Model), CMMI, Experienced in Full Life Cycle development with UML using VISIO modeling and OOD/OOP;

Version Control: MS Visual SourceSafe, Subversion, Perforce, Microsoft Team Foundation, TeleLogic CM Synergy;

Requirement Management: TeleLogic Change Synergy, Microsoft Team Foundation;

Web Development: ASP.NET 1.0 - 3, HTML/ASP/JavaScript, XML, Visual Studio, Web Services. Visual Interdev, HTML, DHTML, JavaScript, XML, XSL, Data Islands, Internet Information Server (IIS), Apache Server;

Software Installers:  InstallShield Developer: versions 7 and 8, DemoShield 7.5, Windows MSI installer, MS Package and Deployment Wizard, .Net Bootstrapper, Orca;

Data Access Technologies:  DAO, RDO, ADO, ADO.NET, COM, COM+, MTS;

Scripting:   Shell scripting (Bourne shell, Bash shell), DOS batch;

Automation:   Draco, Cruise Control, NAnt, Ant, MSBuild, ACT, NDoc, NUnit;

/* EXPERIENCE SUMMARY */

@Total:      15 years+    (1993 to date)

American Automobile Association, Mt Laurel ,N.J. 1 month(January 2008)

Deloitte Consulting, Grand Rapids, MI 3 months (November 2007 to January 2008)

Urban Outfitters, Philadelphia, PA 4 Months (July 2007 to Nov 2007)

Connectiv Energy  Exton, PA   2 months    (June 2007 to July 2007)

Oakleaf Waste Mgmt Hartford, CT   5 months    (Oct 2006 to March 2007)

TIOTE Software  Las Vegas, NV  22 months   (Nov 2004 to Sept 2006)

Department of Energy Las Vegas, NV  7 months    (April 2004 to Oct 2004)

Basell Polyolefins  Elkton, MD  7 months    (Sept 2003 to March 2004)

4gl Solutions  Towson, MD  15 months   (Feb 2002 to May 2003)

TMG Marketing  Denver, CO  5 months    (Sept 2001 to Jan 2002)

ActivLogic Software  Dover, DE   13 months   (June 2000 to July 2001)

FirstUSA Bank  Wilmington, DE  30 months   (Dec 1997 to May 2000)

Dow Chemical  Detroit, MI  3 months    (Aug 1997 to Oct 1997)

Great American Life  Cincinnati, OH  21 months   (Jan 1996 to Sept 1997)

Fischer Systems  Dallas, TX   6 months    (July 1995 to Jan 1996)

Regency Communications Fort Worth, TX  5 months    (March 1995 to July 1995)

Computer Knowledge Dallas, TX   9 months    (June 1993 to May 1995)

/* PROJECTS SUMMARY */

1. American Automobile Association

Description: American Automobile Association needed SSIS\ETL training for 3 developers.

Role:  Instructor  

Duration:  January 2008

Competency:  C#, VB.Net, SSIS 2005, SQL Server 2005

Platforms:  Win 2003, Win XP, Vista

Team Size:  3

Responsibilities: Conduct training in SSIS for Datawarehouse ETL.

Hands On: 100%

2. Deloitte Consulting

Description: Deloitte Consulting needed an ETL process to generate KPIs for their client.

Role:  Problem Solver  

Duration:  November 2007 to January 2008

Competency:  C#, Transact-SQL, SSIS 2005, SQL Server 2005

Platforms:  Win 2003, Win XP

Team Size:  5

Responsibilities: Create ETL process and Custom Transfer Components to move data and create KPIs using SSIS.

Hands On: 100%

3. Urban Outfitters

Description: Urban Outfitters needed a business area data mart for Sales Audit records.

Role:  Problem Solver  

Duration:  July 2007 to November 2007

Competency:  C#, Transact-SQL, ProClarity 6.3, SSIS 2005, SQL Server 2005, SSAS 2005, MDX, Reporting Services 2005

Platforms:  Win 2003, Win XP

Team Size:  3

Responsibilities: Create ETL process and Custom Transfer Components to move data from AS400 to SQL Server using SSIS, create and load Staging and Dimensional databases using SSIS, Create and deploy UDM Cubes for Sales Analysis, create and deploy reports using SSAS and SSRS. 

Hands On: 100%

4. Connectiv Energy

Description: The Petron Billing application was designed to replace an aging dBase accounting system.

Role:  Problem Solver  

Duration:  June 2007 to July 2007

Competency:  C#, web services, Transact-SQL, SSIS 2005, SQL Server 2005, Reporting Services 2005

Platforms:  Win 2003, Win XP

Team Size:  4

Responsibilities: Debug a Winforms C# accounting application that used SSIS, SSRS, and web services. 

Hands On: 100%

5. Acorn Data Warehouse

Description: The Acorn Data Warehouse was created to handle aggregate reporting for Oakleafýs waste management business

Role:  Data Warehouse\ETL Architect  

Duration:  Oct 2006 to March 2007

Competency:  SSIS 2005, SSAS 2005, SQL Server 2005, ASP.Net, web services, Transact-SQL, Reporting Services 2005

Platforms:  Win 2003, Win XP

Team Size:  25

Responsibilities: Design and develop a Data Warehouse with UDM over OLTP source and other data marts, Reporting and Change Data Architecture using SSIS and SSRS. 

Hands On: 100%

6. CEP

Description: Commercial application (Compliance Event Portal, CEP) for monitoring, reporting, and controlling compliance processes. Application contains up to 2500 user-configurable UI and database points for customized compliance events and timelines. Application contains more than 100 user-configurable reports as well as a user report creation capability.

Role: Application\Database architect  

Duration:  Nov 2004 to Sept 2006

Competency:  Transact-SQL (Microsoft SQL Server), C#, ASP.Net, JavaScript, SQL Reporting Services, HTML

Platforms:  Win 2000, Win XP, Win 2003

Team Size:  2

Responsibilities: Design and develop a commercial Compliance application to be user-configurable in all data points and reporting, as well as customizable for any type of compliance application.

Hands On: 100%

7. SCMLA LSN

Description: The SCMLA LSN was created to handle software licensing requirements relating to the application for an operating license for the Yucca Mountain nuclear repository

Role:  Database\ETL Architect

Duration:  April 2004 to Oct 2004

Competency:  Transact-SQL (Microsoft SQL Server), DTS, C#, ASP.Net, JavaScript, SQL Reporting Services, HTML, BEA Web Logic

Platforms:  Win 2000, Win XP

Team Size:  10

Responsibilities: Designed SQL Server database application for Yucca Mountain Nuclear Waste Repository Licensing Application (SCMLA LSN application) using CMM Level 2 standards. (Web Logic and ASP.Net applications in conjunction with SQL Server 2000). Designed and programmed SQL Server 2000 ETL\DTS database application to conform and transfer current software compliance records to new application. Designed and implemented SQL Server Reporting Services as part of software licensing application. Designed specifications for integration of ancillary application data to support licensing application. Designed specifications for integration of TeleLogic CM Synergy data with SCMLA application.  ETL\DTS portion of the application was later re-written using SSIS.

Hands On: 100%

8. Basell Data Warehouse

Description: Project was created to migrate the North American division of Basell Inc to the SAP R.3 platform for the purpose of reporting sales results from a common platform.

Role:  ETL\Data Warehouse Architect

Duration:  Sept 2003 to March 2004

Competency:  BRIO, Business Objects, Transact-SQL (Microsoft SQL Server), C#, ASP.Net, JavaScript, SQL DTS, HTML, VBScript, OLE Automation, Web Services

Platforms:  Win 2000, Win NT, UNIX

Team Size:  125

Responsibilities: Architect and design SQL Server ETL and reporting process of North American Basell migration to SAP BW. Design and create SAP BW data extraction process and SQL Server DTS process. Design and create custom DTS packages for data extraction (VB Script, ActiveX Objects). Design and create web interface for DTS monitoring (ASP.Net). Design and create custom Windows Server event monitor (C#). Mentor other team members as needed.

Hands On: 100%

 

6. SETS

Description: SETS is a software application designed to handle placement, tracking, and remediation of special education issues

Role:  Lead Developer

Duration:  Feb 2002 to May 2003

Competency:  Transact-SQL (Microsoft SQL Server), C, ASP, JavaScript, SQL DTS, HTML, VBScript, OLE Automation  

Platforms:  Win 2000, Win98, Win NT, Mac OS

Team Size:  75

Responsibilities: Mentored other team members on the design and coding of SQL SERVER ANSI-SQL statements, T-SQL statements, user-defined functions, and stored procedures. Designed and coded VB application to handle all maintenance routines for SQL SERVER installations for clients nationwide using SQL-DMO for import, export, and database structure changes. Designed ETL routines using SQL SERVER DTS to transfer metadata codes from Development to Test platforms and from Test platform to Production. Responsible for analysis and design recommendations to optimize and improve current SETS application. Designed and implemented advanced error handling for SETS application. Designed and created application to translate business rules from user requirements into metadata rules. Responsible for creating all custom InstallShield packages used in product installations.

Hands On: 100%

7. TMG ACH

Description: TMG marketing needed an application to handle ACH submissions and tracking

Role:  Lead Developer\Analyst 

Duration:  Sept 2001 to Jan 2002

Competency:  Transact-SQL (Microsoft SQL Server), Visual Basic, ASP, JavaScript, SQL DTS, HTML, VBScript

Platforms:  Win 2000, Win NT

Team Size:  5

Responsibilities: Created business objects and rules from user requirements for all SQL SERVER databases. Developed architecture, logical and physical database design for several mission critical SQL SERVER 2000 databases. Designed and coded all T-SQL and ANSI-92 SQL statements and stored procedures for all SQL SERVER databases. Optimized all stored procedures and views using Query Analyzer Plan View and Index Optimizer. Designed and coded customized DTS packages and ETL jobs for data exchange with FTP site and banking and fulfillment clients. Wrote ETL specifications for banking and fulfillment clients for data exchange with in house RDBMS. Created and deployed maintenance plan for all SQL SERVER 2000 databases. Conducted performance tuning processes and capacity planning on all SQL SERVER 2000 databases. Ported all current marketing and reconciliation processes to SQL SERVER 2000 from MS Access. Developed linked SQL SERVER processes for automatic processing of revenue and product shipment. Designed and coded Visual Basic /COM / ASP /SQL SERVER 2000 application to track customer orders and fulfillment. Converted VB /ACCESS application to Visual Basic /COM /SQL SERVER 2000 order and fulfillment application to interact with banking clients and fulfillment house, using VBScript, JavaScript, DHTML, and HTML. Developed complete report writer in VB for Crystal Reports 8.5, deployed across entire IT department. Developed and deployed standardized VB COM and DCOM processes for the entire IT department.

Hands On: 100%

8. ActivLogic

Description: ActivLogic is a commercial application used in service industries to handle Scheduling, Point-of-Sale, Payables, and Receivables

Role:  Lead Developer\Analyst

Duration:  June 2000 to July 2001

Competency:  Microsoft Access, SQL, Visual Basic

Platforms:  Win 2000, Win XP, Win98

Team Size:  6

Responsibilities: Translated customer business requirements into project plan for retail Visual Basic application. Led team of 6 in creating a retail VB application for Point of Sale, Scheduling, Payables, Receivables, and inventory control for small to medium size businesses. Created all data flow, class module, use-case, and static diagrams for application in VISO. Designed and coded all back-end and middleware objects, as well as their associated installation software. Designed and coded physical and logical database design for application. Created presentation tier design and coding standards. Developed ETL package for transferring current accounts information to new system. Designed and created security levels and processes for application. Designed and coded three-tiered custom reports in Crystal Reports 8.0. Designed and coded installation software that allowed user and business rule customization on deployment.

Hands On: 100%

9.

 FirstUSA Marketing Operations

Description: The marketing Operations application at FirstUSA was created to manage aggregation of demand for production of marketing materials and marketing campaigns

Role:  Lead Developer\Analyst

Duration:  Dec 1997 to May 2000

Competency:  Transact-SQL, SQL Server, C, MS Access, VB Script, Visual Basic, Progress

Platforms:  Win95, Win98, Win NT

Team Size: 7

Responsibilities: Conducted user interviews to codify business rules and requirements. Developed logical and physical database design for Telemarketing Operations SQL SERVER 6.5\7.0 database. Designed and coded all T-SQL and ANSI-92 SQL statements and stored procedures for Telemarketing Operations SQL SERVER 6.5\7.0 database. Designed and coded DTS packages for data exchange with Telemarketing vendors (Optima Direct). Wrote ETL specifications for Telemarketing vendors for data exchange with in house SQL SERVER. Responsible for optimization of all stored procedures and views. Created and deployed maintenance plan for SQL SERVER 7.0 database. Conducted performance tuning processes and capacity planning on SQL SERVER 7.0 database. Designed and coded Visual Basic /COM /ASP / SQL SERVER 7.0 application to process and analyze Telemarketing Operations with What If scenario, as well as regression analysis tool for telemarketing vendor capacity planning. Designed and coded Visual Basic /COM /ASP /SQL SERVER 7.0 application that created custom reports on demand using VB 6.0, SQL SERVER 6.5/7.0, and Crystal Reports. Application used ActiveX EXE server to monitor user traffic and report requests. Designed and coded business application to process credit card number requests in conjunction with central repository in Omaha, NE. Designed and coded Visual Basic /COM /ASP / Oracle application to process and assign part numbers for credit card components. Designed and coded several smaller Microsoft Access applications to support data entry for Just-In-Time MRP Symix mailing component database.

Hands On: 100%

10. Global Incident Reporting

Description: The Global Incident Reporting application (GIR) was created to track procedures and responses to chemical accidents for Dow Chemical worldwide operations

Role:  Lead Developer\Analyst

Duration:  Aug 1997 to Oct 1997

Competency: MS Access, VBA script, Visual Basic

Platforms:  Win95, Win98, Win NT

Team Size:  5

Responsibilities: Developed testing and benchmark plan for troubleshooting database designed to track chemical spills world-wide. Conducted user interviews to document business rules and requirements. Led three-person team in re-design process to redevelop logical and physical database design for chemical spills application. Used specs developed to re-architect and re-code presentation tier of application to increase speed and scalability, using less than 80% of budgeted time. Conducted training sessions in Visual Basic and MS Access development at two sites in Michigan and one in Houston, TX.

Hands On: 100%

11. Commission and Compliance

Description:  The Commission and Compliance application was created to solve Great American Lifeýs agency system needs for payment of commission and tracking of licensing and marketing materials

Role:  Lead Developer\Analyst

Duration:  Jan 1996 to Sept 1997

Competency:  Visual Basic, MS Access, Oracle, DB2, VBScript

Platforms:  Win 95, Win NT

Team Size:  5

Responsibilities: Created Visual Basic/Oracle/MS Access Agency Commission application, Agent License and Registration application, and Document Compliance application. Designed and coded logical and physical database design for Agency Commission database, Agent License and Registration database, and Document Compliance database. Designed and coded all stored procedures for hybrid Oracle /MS Access Agency Commission database, License and Registration database, and Document Compliance database. Designed and coded ETL packages for data exchange with DB2 server and Agency Commission database. Responsible for optimization of all stored procedures and views

Hands On: 100%

12. Fischer System

Description: The Fischer System was a proprietary real estate management system to handle property leases, escalations, and budgeting

Role:  Developer  

Duration:  1995 to Jan 1996

Competency:  MS Access 2.0, Access Basic, Visual Basic

Platforms:  Windows 95, Win NT

Team Size:  10

Responsibilities: Develop, support, maintain, and enhance database code as required

Hands On: 100%

13. Regency Call System

Description: The Regency Call System was created to provide management reports for a hybrid proprietary predictive dialing system running on an Informix\UNIX platform

Role:  Developer  

Duration:  March 1995 to July 1995

Competency:  MS Access, VBScript, Bourne shell

Platforms:  UNIX, Win 3.11, Win 95

Team Size:  8

Responsibilities: Lead developer

Hands On: 100%

14. Student Enrollment DB

Description: Student Enrollment DB was used by ComputerKnowledge for delivery of targeted instruction in programming languages

Role:  Developer  

Duration:  June 1994 to May 1995

Competency:  Access 1.1, VB script, Access Basic

Platforms:  Win 95, NT

Team Size:  7

Responsibilities: Lead Developer

Hands On: 100%

/* EDUCATION */

Degree/Specialization:  B.A in Religious Studies;

Institute/University:  University of Colorado, Boulder, Colorado;

Graduate Work:   Southwest Baptist Seminary (Divinity);

University of Texas at Arlington (Mathematics);

/* PERSONAL */

Gender:    Male;

Everything Else:   Confidential;

/* KEYWORDS */

ETL, SSIS, SQL Server, SSAS, SSRS, Reporting Services, Analysis Services, MDX, UDM, Cube, Dimensional Modeling, ProClarity, Integration Services, Automation, Database Development, DTS

Contact this candidate