Sign in

IT Consultant/Contractor

Midlothian, VA
March 27, 2019

Contact this candidate


Hunter Harwood

Richmond, VA cell 205-***-****

Accomplished technical leader with 15+ years of experience driving teams to successful solution delivery based on leveraging technology and business expertise. Passionate about solving business problems and partnering with stakeholders and business leaders to achieve desired goals.

Summary of Skills

Experienced analyst, architect, project manager, and technical/business consultant.

Extensive experience with large scale data integration and analytics, application and integration architectures, solution design/development/maintenance, custom/package software integration and implementation, and data warehousing/data marts and BI.

Works effectively with technical staff, non-technical end users and senior management at all levels of an organization.

Able to manage competing priorities of multiple concurrent projects and ongoing production support to keep tasks on time and within budget.

Industry experience includes Government, Energy, Retail, Finance, Distribution, Mortgage, Medical, and Resource Management

Technical Proficiencies

Platforms: Windows, Unix/Linux, some OS/X

Data: Design/Modeling, mapping, management, SQL, ETL, warehousing/BI, integration

Languages: VB.NET, Visual Basic (including 3-tier OOP), VBA (MS Office), ASP, CSS, XML, XSLT, HTML, VBScript, JavaScript, some Java, Korn Shell, Perl

Tools/Packages: Informatica, SQL Server (including SSIS, SSRS, SSAS), Oracle 11g/12c, DB2, erwin, VS 2013, Version Control (TFS, Visual SourceSafe, PerForce, Subversion), Eclipse, Endeca, WebSphere Commerce (backend), Crystal/Crystal Enterprise, MS Office Suite, MS Project, MS Visio, MS SharePoint, Toad for Oracle, Toad Data Modeler, Toad Data Point, Scribe Workbench.


DATA CONCEPTS, Richmond, Virginia Dec 2016 - present

Data Architect Consultant at Virginia IT Agency (VITA)

Brought in to enhance existing data team, primarily to assist with a large system migration project, and other duties as needed.

1.5 year project to replace and enhance current state/vendor contact system. Duties include documenting existing web apps and services and their data consumption, creating the replacement schema, developing data migration strategies and scripts, as well as building and optimizing all new data integration feeds to maintain the new application and those that share data with it.

Provide support as needed to other data tasks, including Executive Order 20 system changes/enhancements (Advancing Equity for Small, Women, and Minority Owned Businesses).

Windows, Oracle 11g/12c, Toad for Oracle, Toad Data Point, Toad Data Modeler, SQL Server 2012 (T-SQL), VB.NET (VS 2013) + TFS, MS Office, MS Visio, Scribe Workbench.

PACIFICORP, Portland, Oregon Aug 2015 - Nov 2016

Transmission Data Integrity Specialist

Working in the Transmission Billing business unit, tasked with supporting the accurate and timely invoicing of other utilities utilizing PacifiCorp’s power transmission infrastructure.

Enhancing the custom .NET department reporting tool that pulls and compares transmission data from a variety of internal and external sources, either through direct database connections (SQL Server 2012, Oracle 9,11) or web service calls.

Developing modifications to a FTP/ETL tool that automates loading data only available through static sources.

Windows, VB.NET (VS 2013) + TFS, SQL Server 2012 (T-SQL), MS Office, XML

ADECCO USA, Portland, Oregon Nov 2012 - Jul 2014

IT/Analytics Consultant

Worked as a data and analytics consultant onsite with IBM Seterus within the Bankruptcy department, which offers an enterprise-wide loan servicing platform.

Developed multiple scheduled and ad-hoc reports for the different groups within Bankruptcy, based on SQL Server 2005/2008 databases and flat-file/XML documents.

Analyzed historical data and resolved issues, assisting with corporate and legal compliance directives.

Automated business processes and work flows, increasing department throughput (VBA in Excel, Word, and Outlook).

Led departmental business analysis and data mapping for company-wide loan platform migration project.

Windows, SQL Server (T-SQL), MS Office + VBA, MS SharePoint, XML

BORDERS GROUP, Ann Arbor, Michigan Dec 2007 - Sep 2010

IT Consultant/Senior ETL Analyst, E-commerce

Worked with major e-commerce book and multimedia retailer and distributor to assist with the re-launch of (live May 2008), and continued after launch to improve and enhance the site.

Part of launch team that designed and wrote 10+ large-scale custom ETL processes used for loading data into the site database.

Managed small team post-launch tasked with maintaining and enhancing ETL catalog.

Managed large-scale, high-profile e-commerce projects and integrations.

Designed and built XML/text extracts from WCS to send to internal systems or external clients.

Designed process that enabled site data changes in response to publisher announcements or current events, reducing time to market from hours to minutes.

Unix/Linux, Java, XML, Korn Shell, Perl, WebSphere Commerce, Endeca, DB2, MS Project, Eclipse, Subversion.

BOOKS A MILLION, Birmingham, Alabama Dec 2001 - Jul 2007

IT Consultant (Software Dev, ETL, Data Integration)

Worked as a Project Manager and team lead for a web-based book retailer in the design, development, implementation, and enhancement of various enterprise systems and databases.

Designed, created and maintained numerous SQL Server DTS packages and Informatica ETL batch processes used to maintain an OLTP Data Warehouse.

Implemented system that allowed external publishers and internal buyers to work together to get new book and non-book product into all corporate and store systems, resulting in dramatically increased data integrity and order accuracy.

Led cross-functional team in the design and development of a custom application for special Christmas fulfillment ordering to keep stores well stocked with popular titles during the holiday sales season.

Project manager, team lead, and Sr. Analyst/Developer for the design and development of Timeclock, a custom web-based time & attendance application integrated with HR and Payroll systems.

Project manager and Sr. Analyst/Developer for implementing Taleo Talent Management system and TALX I-9 Management system, and integrating both with Lawson HR.

Brought in to rescue failing project for development of a custom Finance Web Portal used by corporate departments as well as 200+ stores to perform a variety of HR, payroll, inventory and sales/operational analytics/reporting functions.

Windows, SQL Server (T-SQL, SP, Admin, DTS), DB2, MS Office, Informatica, VB, HTML, ASP, CSS, XML, XSLT, JavaScript, VBScript, Crystal Enterprise, MS Project, MS Visio, PerForce.

PLANT AMERICA, Arlington, Virginia Apr 2001 - Dec 2001

Senior Programmer/Analyst

Internet start-up producing web software and tools for the Horticulture and Gardening Community.

Developed template-driven, client customized websites, which allowed sites to come online quickly with little effort or IT knowledge required by the client.

Created RDF-based green industry article feed to Netscape business portal.

Windows, VB, HTML, ASP, XML, Javascript.

CROWN BOOKS, Landover, Maryland July 1996 - Apr 1998, Sep 1999 - Mar 2001

Senior Programmer/Analyst, Consultant

Initially hired as part of project team for national book retailer to help create a custom Point of Sale (POS) system to be used in Crown stores. Returned to lead development of Crown’s first Intranet applications as well as other automation projects.

Design and development of custom client/server POS system for 200+ retail stores.

Returned in 1999 as consultant to lead team launching Crown’s first Intranet portal.

Designed and developed MS Office automation for specialized reporting needs (dashboard).

Windows, VB, MS Office, VBScript, HTML, ASP, SQL Server, Erwin.


TekSystems (MAXIM GROUP), IT Contractor at various clients 1998- 1999

oPart of client/UI team on 3-tier project to redesign Sylvan Learning Systems’ scheduling software.

oAided Magellan Health with data processing for some of their clients, including introducing client-server architecture using VB and SQL Server 7.

Virginia Housing Development Authority, Project Lead/Sr. Programmer Analyst 1993-1996

oInitially hired to develop on mid-ranged Unix system

oDeveloped first client-server project for company (FoxPro for Windows to Sybase)

Automatic Equipment Sales, Programmer/Lead Analyst 1985-1987, 1988-1993

oPart of small dev team handling variety of applications for various business functions (AR, AP, GL, Inventory). Solely responsible for nightly batch transactional posting system. Returned to take lead position in dev team.

Crestar Bank, Programmer/Analyst 1987-1988

oSole developer for new OTS trust system.


M10776 Developing Microsoft SQL Server 2012 Databases, Global Knowledge, July 2014

Git Real, Code School, March 2015

M20463 Implementing a Data Warehouse with Microsoft SQL Server 2014, Global Knowledge, May 2015 (included working with SSIS, SSRS, SSAS)


Bachelor of Arts in Music, University of Virginia (Charlottesville, VA)

References available upon request.

Contact this candidate