SSIS Developer
Resume:
[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-***-****];
[****.*********@*****.***];
}
/* 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