David W. Hill
1110 Argyle Street, Saint Paul, MN  55103
DaveHill52@gmail.com
651-493-4915 (Home) or 515- 778-2837 (Cell)

Summary of Skills and Qualifications

An Accomplished Project Manager/Analyst with more than eight years experience managing both major and minor projects. Proven ability to design and implement effective strategies, develop new products, manage resources, develop and maintain project plans and schedules.

• Project Management skills include: facilitation, planning, coordination of activities, presentation delivery, data analysis, risk management and identification and problem solving
• As a Business/Data Analyst have ability to use sound analytic skills, pay attention to detail, and the ability to communicate clearly in both verbal and written form
• Experienced using MS Project, Planview, STAMP, MS Office (Word, Excel, PowerPoint & Access) and Visio
• Experienced in application design principles and practices, system development methodologies; have the ability to gather and assess user requirements and translate them in a logical and practical set of software requirements
• Experienced in application support, analysis and troubleshooting as well as experience with software testing methodologies and user training
• Have participated in Unit, SIT, UAT and performance Testing. Have developed Test Plans and Test Cases
• Have over eight years experience in financial applications as Project Manager and Business Analyst.
• Have over twenty years experience in Government applications with focus in Federal/Military and Local Governments.
• Have used COBOL, Fortran, Basic, PL/1, Visual Basic and Assembler in development and/or maintenance of software applications.
• Have used Oracle and Access for creation and maintaining various databases using both the forms, report and query features of both. Have utilized SQL query writing skills to access information from these databases.
• Have over six years experience with Healthcare software performing as programmer analysis, testing, help desk support, on-site client support, and training.
• Have accomplished personnel management objectives through recruiting, selecting, orienting, training, assigning, scheduling, coaching, counseling, and disciplining employees; communicating job expectations; planning, monitoring, appraising, and reviewing job contributions; planning and reviewing compensation actions; enforcing policies and procedures.

Employment History

Project Manager (Contracting at Wells Fargo, Minneapolis, MN) Oct 2008 – Dec 2009

Technisource  Minneapolis, MN

Computer Consultant assigned to Wells Fargo Institutional Trust Services in Project Management support.

• Managed ten projects for related to new development and enhancements for Retirement Planning Services and Institutional Trust Services. Responsible for setting up project folder in STAMP & Planview, requirements gathering, project documentation written and approved, scheduling and coordinating testing activities, preparing change requests for production implementations. Collaboration with the enterprise project manager, coordinating scheduling needs, budget and forecasts and project deliverables.
• Environment: MS Project, Planview, STAMP, SAS, Oracle, ASP .NET, SQL 2005, Windows 2003, Actiate BI, WUP – Wells Fargo Unified Process Project Methodology, SDLC, Pac2000.

Project Manager/Business Systems Analyst (Contracting at infoUSA, Omaha, NE) May 2008 – Oct 2008

ProKarma Omaha, NE

Computer Consultant assigned to infoUSA Product Services group to provide Business Analysis and Project Management support.

• Wrote Functional Requirements Specification (FRS) for the integration of web based application with subsidiary ExpressCopy.
• Wrote a RFP to obtain services with a List Management solution to be integrated into the infoUSA MyAccounts application.

 

David W. Hill Page 2

Business Analyst (Contracting at State of Iowa / Judicial Branch) Oct 2007 – Feb 2008

TEKSystems  Des Moines, IA

Computer Consultant assigned to the Judicial Branch of the State of Iowa to work on the Electronic Document Management System (EDMS). Implementation of the EDMS was to be implemented state wide for all type court case files.

• Gathered and documented Business Requirements to ensure implementation of software was complete and testable.
• Worked with various Clerks of the Court offices to gain understanding of work flow and current system operations.
• Worked with various Judges to design a process that would integrate the current ICIS2 database with the EDMS document case files.

Data Analyst/Analyst/Designer (Contracting at Wells Fargo, Des Moines, IA) Sep 2006 – May 2007

CIBER, Inc.  Des Moines, IA

Computer Consultant assigned to the Wells Fargo Finance to perform Business Data Analysis support for the Home and Consumer Finance Group – Core Phase I Data Strategy Data Integration (D11) D11B Data Integration is one of the initiatives of the Core Phase I Data Strategy for Wells Fargo Bank (WFB), Home and Consumer Finance Group (HCFG). D11 Data Integration assesses the impact on downstream data management environments of processing Phase One products and legacy products via different systems (Customer Facing, Deal Decisioning and Deal Processing) and processes, and provides cost estimates and a plan for integrating the associated data so that corresponding analytics and reporting is unaffected.

• Work with Requirements Analysts and Subject Matter Experts to identify, understand and document business needs for the data flow.
• Work closely with various financial and mortgage business teams in gathering the business requirements.
• Work with the Project Management in the creation of project estimates.
• Analysis of the data identifying source of data and data mappings of HCFG.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Interact with the SME’s to analyze the data extracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system.
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information.
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
• Enforce standards to ensure that the data elements and attributes are properly named.
• Work with the business and the ETL developers in the analysis and resolution of data related problem tickets.
• Support development teams creating applications against supported databases.
• Provide 24 x 7 problem management support to the development team.
• Document various Data Quality mapping document, audit and security compliance adherence.
• Perform small enhancements (SOR element additions, data cleansing/data quality).
• Create various Data Mapping Repository documents as part of Metadata services (EMR).
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Provide support in developing and maintaining ETL processes that extract data from multiple SORs residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
• Designed & developed Access database to track mapping of data elements for Wells Fargo Home Mortgage.
• Utilized Peoplesoft to track time on each project and e-mail correspondence with consulting firm.

Business Analyst (Contracting at Lowes, North Carolina) Mar 2006 – May 2006

Modis, Inc.  Charlotte, NC

Computer Consultant assigned to the Lowes, Inc to perform Business Data Analysis support.

• Responsible for working with vendor in finalizing the Business Requirements for an addendum to the Made To Order (m2ō) application.
• Built Test files using XML to test the web based m2ō application.
• Coordinated usage of Test Regions for developers in the Unix environment set up on the mainframe using Websphere.

  
David W. Hill  Page 3

Data Analyst (Contracting at Wells Fargo, Des Moines, IA) Sep 2005 – Mar 2006

CIBER, Inc.  Des Moines, IA

Computer Consultant assigned to the Wells Fargo Finance to perform Business Data Analysis support.

• Performed data quality analysis of data when transferred from system to system to identify potential problems and perform ROI on correcting problems found.
• Interviewed both Technical and Business users to identify problems related to data quality/integrity.
• Wrote requirement specifications for remediation where problems found.
• Utilized Planview to track and dissimilate documentation related to project.
• Utilized Peoplesoft to track time on each project and e-mail correspondence with consulting firm.

Business Analyst Sep 2004 – Sep 2005

ACS State Healthcare  Raleigh, NC

Provide project support for system being developed for the Department of Facility Services, specializing in the Healthcare Personnel Registry Section (HCPR). The HCPR section is responsible to register all Certified Nursing Assistants (CNA’s) in NC and ensure employers are using registered CNA’s.

• Worked with clients to identify needs using JAD sessions and one-on-one interviews and then generate Business Requirement Documents and General System Design documents.
• Worked with clients and programmer to develop the Detail Systems Design documentation.
• Created Use Cases and Test Plan Cases based on Business Requirements.
• Worked with developers to ensure web based design meets clients expectations.
• Created system integration and user training schedules and documents.

Project Manager May 2000 – Jul 2004

Branch Banking and Trust, Co. (BB&T)  Wilson, NC

Provide project support in the areas of project plan administration, issue tracking/resolution, incident tracking/resolution, meeting co-ordination/facilitation, information gathering/dissemination, and project communication, documentation creation/distribution.

• Completed project ahead of schedule to change security tracking from CICS Operator Id use to User Security Id.
• Managed project for upgrade of the GEAC financial application software.
• Assisted managing project to implement Sales Management System for use in branches for commercial market.
• Assisted managing project to upgrade 15 year-old integrated deposits system to a new-scaled version using middleware technology.
• Evaluated and trained in use of Primavera as potential PM tool.

Project Manager/Computer Services Manager Nov 1995 – May 2000

Wycliffe Bible Translators/Summer Institute of Linguistics  Papua New Guinea

Responsible for a variety of computer related tasks such as computer training in both administrative and language applications, writing and maintaining computer programs, testing and repairing computer equipment, installing new components into existing systems and advising on present and future computer applications.

• Directed the daily activities of a staff of 30 individuals.
• Responsible for project management, personnel administration, departmental budgeting, hardware & software procurement, user support, type setting, publications and training.

Programmer/Analyst Dec 1991 – Nov 1995

Computer Science Corporation  Birmingham, AL

Provide program support for the PowerMHS healthcare application and financial software for AS/400 and IBM MVS systems.

• Used AS/400 CL and Query to generate reports and download files as needed.
• Made enhancements to the utilization management subsystem, eligibility benefits subsystem, and financial management subsystem (general ledger, accounts payable, and accounts receivable).
• Performed enhancements to ensure HIPAA requirements and security were met.
• Provided technical assistance to Help Desk personnel concerning application functionality.
• Provided technical assistance and training to other customer support representatives.
• Provided on-site training and consulting to various insurance companies.

 

David W. Hill  Page 4

Distributed Systems Manager Feb 1989 – May 1991

Pinellas County Government  Clearwater, FL

Computer manager for distributed networked computer systems located at various county sites.

• Managed the corporate distribute network, consisting of 24 mini computers with approximately 1,000 PC’s and terminals connected.
• Responsible for databases, security of all systems, creation of management reports of system status and resource utilization, forecasting and capacity planning, scheduling and implementation of all system software and database maintenance.
• Supervised a technical staff of nine for which I performed task co-ordination, project scheduling and performance reviews.

Systems Analyst Feb 1988 – Feb 989

El Paso Natural Gas  El Paso, TX

Senior Systems Analyst for the conversion of the reporting sub-system.

• Designed and wrote program specifications and assigned projects to various contract programming.
• Performed scheduling and tracking sub-projects and provided project status reports to management.

Consultant/Computer Manager Mar 1986 – Feb 1988

Agency Services, Inc.  Memphis, TN

Sole person responsible for management, operations and programming for a small Insurance Third Party Administrator.

• Responsible for networking systems and maintaining both a Wang VS & IBM System 36 computer systems.
• Developed, wrote and implemented a computerized system for tracing insurance claims and adjusting premium rates base on claim data.
• Responsible for year-end closing and the computerized accounting system.

Systems Analyst Aug 1984 – Feb 1986

Shelby County Government  Memphis, TN

Team Lead responsible for installation and operation of a Wang VS system and microcomputer related applications.

• Evaluated business needs and developed system enhancements through automation and training.
• Coordinated system development and enhancements.
• Acted as interface between customers and systems and programming staff and trained users in use of applications.

Data Processing Technician Jun 1971 – Aug 1984

U.S. Navy  Various sites in the US, overseas and at sea

Served 13 years as a Data Processing Technician, attaining the rank of E-7.

• Held Top Secret clearance.
• Responsible for over four million dollars in spare parts while serving on board ship.
• Taught various computer courses including Word Processing and Programming.

Education
Masters Certificate in Project Management 2003

ESI/The George Washington University, Washington DC

MS, Operations Management 1986
     University of Arkansas, Fayetteville, AR

BS, Sociology 1983
     University of the State of New York, Albany, NY

AA, Business Administration 1980
     Golden Gate University, San Francisco, CA