presenting the professional experiences of
Richard Hathaway
SQL
Developer / Data Architect / Enterprise Process Engineer
abplwz@r.postjobfree.com
RiverPoint Group, Des Plaines, IL July
September 2008
Client: Curran
Management Services, Inc (InnSeason/Island One resorts)
Consultant - Data Warehouse Architect / ETL SpecialistLead engineer
on data warehouse initiatives relating marketing data from two companies.Generate
inbound interfaces to legacy systems.Peripheral
analytical role on implementation of Unica business intelligence marketing
system.Maintain and
update functional and technical specifications.
Technologies
involved: SQL Server 2005, SQL Server Integration Services (SSIS), TSQL,
Alteryx, Office Suite 2007, VMware, Unica, TimeShareWare
Next Wave, Inc., Warrenville, IL
March - May 2008
Client: Lia Sophia
Consultant - SQL Developer / ETL and Process Engineer SpecialistLead engineer
on initiatives to an online direct sales system; data modeling and
processing enhancements within affected systems: order entry, order
processing, and data warehouse.Generate
inbound and outbound interfaces to iSeries and legacy systems.Coordinate
deliverables with quality assurance and production support personnel.Maintain and
update functional and technical specifications.
Technologies
involved: SQL Server 2005, SQL Server Integration Services (SSIS), T-SQL,
stored procedures, Office Suite 2007, DocumenTree.
RiverPoint Group, Des Plaines, IL December
2006 February 2008
Client: WestfaliaSurge (div. GEA), Naperville, IL
SSIS Developer / ETL and
Process Engineer Specialist / Data ArchitectServed as Technical
lead and planner for SQL Server 2000 to SQL Server 2005 migration.DTS to SSIS
package conversion and impact analysis of one hundred and ninety-six
packages. Package
consolidation and re-factoring effort of data warehouse ETL logic. Cleanup and
archival processing of retired packages. Created SQL
JOBS scripting necessary to automate daily processing. Database
conversions including security analysis to refine existing permissions and
roles. Produce
customized documentation to aid future support roles necessary for SQL
Server 2005.
Customer Service Call
Tracking and Complaint Application upgradesEnhance
applications to perform synchronization and exception checking/reporting
of parts and customer lists from SAP data source. Adaptation of
SQL views and stored procedures to support ADP client upgrades. Microsoft
Vista and Microsoft Office 2007 readiness upgrades and validation testing.
Other rolesDocumentation
of data warehouse elements, existing mappings, and process flows. Synchronization
enhancement to FTP scripting of SAP to data warehouse automation. Standardization
and automation of SQL 2005 database backups. Create scripting
to support package logging and analysis reporting.
Technologies
involved: SQL Server 2005, SQL Server 2000, SQL Server Integration Services
(SSIS), T-SQL, stored procedures, SAP, VBA, ActiveX, Source Safe, Access 2000,
Access 2007, and Office 2007.
Client: Komatsu International of America, Rolling
Meadows, IL
SSIS Developer/ETL and
Process Engineer Specialist / Data ArchitectTechnical lead
for SQL Server 2005 Package development / deployment / and support. Create SSIS
Package, SQL JOBS, and scripting necessary to automate daily processing
and transformation of data from source systems to new parts inventory and
planning system. Engineer an
SAP to SQL 2005 ETL to synchronize pricing facts. Preparation of
solution for integration into Informatica scheduling and workflows. FTP scripting
to automate the retrieval and delivery of source and result data. Create
scripting for automation of SQL 2005 database SNAPSHOTS. Create
scripting to maintain and analyze package logging and metrics. Generate requirements,
technical, project standards, and support documentation. Technologies
involved: SQL Server 2005, SQL Server Integration Services (SSIS), T-SQL,
stored procedures, DB2 and Mainframe data sources, and ActiveX scripts.
ServiceMaster, Downers Grove, IL Aug.
2005 November 2006
Consultant - Data ArchitectCreate six DTS
interfaces providing ETL logic between auxiliary systems and JDEdwards WorldSoftware Financial system.Create
deployment scripts adhering to existing change management system. Creation of
standard documentation for specifications.Technologies
involved: SQL Server 2000, DTS, T-SQL, ActiveX, and JDEdwards
WorldSoftware.
Quality Audit Report
Archive:Create ETL
process to move data from ODS tables into the data warehouse for permanent
storage. Create
deployment scripts adhering to existing change management system. Technologies
involved: SQL Server 2000, DTS, T-SQL and ActiveX.
Partner Leads
Reconciliation Process:Create four
ETL processes to synchronize completed sales records back into ECOM system
to help aid in reporting accuracy of leads that came to fruition. Create
deployment scripts adhering to existing change management system. Technologies
involved: SQL Server 2005, DTS, T-SQL, java web services, SOAP, XML,
ActiveX; light exposure to SQL Server 2005 SSIS.
Direct Call Marketing
System:Create a four
table data warehouse schema to store customer call data queried by
web-based application components to support agent direct call marketing
initiative. Create ETL
routines to maintain daily synchronization of data between an AS400
Terminix sales databases and Cisco DCM dialer database. Create
deployment scripts adhering to existing change management system. Provide
technical support and technical leadership in ongoing initiatives and
enhancements. Technologies
involved: SQL Server 2000, DTS, stored procedures, DCM Campaign Manager.
Migration of DTS
components into new metadata framework:Create DTS
templates to accommodate a multitude of data interoperability needs. Adapted
seventeen DTS interfaces into new framework. Create
deployment scripts adhering to existing change management system. Technologies
involved: SQL Server 2000, DTS, stored procedures, FTP, ActiveX, data
drivers from various ServiceMaster brand database systems (i.e. iSeries /
DataDirect, Excel/Jet), customized JD Edwards (JDE) ready load formats for
GL/AP/AR interfaces.
Sanford Corp. (div. Newell Rubbermaid), Oak Brook, IL Oct.
2004 July 2005
Consultant - Lead
architect / developer / report writer on data warehouse initiatives.
Construct a Point of
Sale data warehouse:Create a 28
table staging and data warehouse schema to support a custom point of sale
initiative. Create the ETL
routines to initialize the tables. Create Cognos
query subjects and relationships necessary to support report writers
needs. Create Cognos
ReportNet reports for load result metrics and load fault details. Setup Cognos
automation routines to distribute monthly Business Intelligence reports
and analysis. Provide
technical support and initiative guidance for refinements and
enhancements.
Construct a Cash Flow
Financing Study:Create
business requirements document from interviews with financing personnel. Analyze and
design data flow sourcing using Oracle Analyzer and My Eureka to mine data
per business stated requirements. Create an 8 table
staging and data warehouse schema to support a Business Intelligence cash
flow studies. Create the ETL
routines to initialize the tables. Create Cognos query
subjects and relationships necessary to support reporting needs. Create Cognos
ReportNet reports for fact details and exception reporting.
Support 3rd
party POS system enhancements (Velocity authored by VMT):Construct and
present Sanford s
business requirements document for a dashboard metrics system. Create
synchronization routines to deliver resulting metrics in ReportNet ready
format.
Construct a DTS package
run-time analysis system:Create
historic analysis tables to collect DTS step run-time metrics. Create ETL and
synchronization logic for real-time to historic fact collection. Create Cognos
ReportNet report graphing run-time analysis for packages over a three
month period; also included a system availability overlay.
Support additional IT
directives:Enhance DTS
packages with fault tolerance logic related to nightly connectivity
failures. Create
technical documentation: operations and processes, core templates of
expected methods and practices, and quality control methodologies. Setup and
train technical personnel on usage of Source Safe. Test and aid
in setup of security boundaries between DEVELOPER and DBA job roles.
Technologies
involved: SQL Server 2000, DTS, T-SQL, stored procedures, triggers, VBA,
ActiveX, Excel, Access, Source Safe, Cognos Framework Manager and ReportNet;
Redbrick, Oracle, NOPS, and QMF data sources.
PI Engineering Software Inc., Hoffman Estates, IL Nov.
2004 (ongoing/sparse)
Consultant Software Developer
Responsibilities: Developer on
engineering analysis tool, K-Flange. Collect design requirements and implement
application enhancements to VB 6 application. Duties included but not limited
to ETL scripting in Access database, and GUI enhancements including security features.
McLagan Partners, Inc. (div. AON Corporation), Chicago, IL July 1997
Sept. 2004
Software Engineer III
Software developer and
technical lead on creation of a custom analytical tool:Create a
custom Access interface to provide query, graphing, and report analysis of
financial data. Create a Query
Analyzer like client using Visual Basic 6