Kevin C Hillock

**** ***** ***** **. #***

Fairfax VA 22031

571-***-****

l3j7v6@r.postjobfree.com

Summary of Qualifications

Mr. Hillock has over 10 years of experience in software development and information systems integration. He has experience in several system projects throughout the whole life cycle of software development, including design, development, test, and system maintenance. Strong data modeling skills with MS Access development skills using VBA, SQL, forms and reports.

Employment History

CGI, Fairfax VA November 2011 to Date

• Providing MS Access 2003 and Unit and System testing support for Fannie Mae’s Multifamily business unit.

• Created and executed Unit test plans.

• Created a process to programmatically create ODBC System DSNs within an MS Access database.

• Worked on three MS Access projects simultaneously to update existing MS Access database with TRAM code changes and enhancements.

• Created various documents to include Unit testing results, migration documents for Acceptance and Production environments.

• Lead code review session in support of Migration efforts

• Supported UAT to include trouble shooting testers access to Acceptance roles and Active Directory (AD) access

Business Transformation Agency, Crystal City, Arlington VA May 2011 to September 2011

• Created normalized MS Access 2007 database to assist military purchasing agents with price data with respects to various areas of Afghanistan.

• Created a dynamic report for price information for various commodities and services across multiple countries.

• Created form to allow price information searches across various cities, provinces and countries.

• Created data import process from MS Excel 2007

Technical Environment: MS Access 2007, MS Excel 2007

Federal Reserve Board Washington DC November 2010 to December 2010

• Worked on a one month contract providing MS Access 2007 and MS Excel support.

• Normalized existing MS Access 2007 database to include adding primary and secondary keys.

• Identify substandard code, queries, forms, and reports and replacing them, taking advantage of the newly normalized tables.

• Create History process and develop History reports.

• Created process to export reports to MS Excel 2007.

Technical Environment: MS Access 2007, MS Excel 2007

Centech, Falls Church VA November 2010 to November 2010

MS Access Developer

• Created menu driven application in MS Access 2007 to create metric reports accessing data from their SharePoint application.

• Created process to export reports to MS Excel 2007.

Technical Environment: MS Access 2007, MS Excel 2007

Grey Associates, West Springfield VA May 2009 to January 2010.

Sr. Data Analyst/Access Developer

• Provided MS Access 2003, VBA, MS Access Reports, SQL support for an automated job and billings system.

• Designed and created MS Access database using user requirements and process analysis.

• Created billing statements and job reports which included all job line items and rates.

Technical Environment: MS Access 2003

Discovery Communications, Silver Spring MD May 2008 to September 2008.

Sr. Data Analyst/Access Developer

• Provided MS Access 2007, VBA, MS Access Reports, SQL support to various projects with emphasis on debugging and enhancing existing End User application Interviewed stake-holders to re-engineer reports to clarify data elements and data formatting.

• Performed data cleansing to ensure data quality by removing redundant rows and correcting erroneous data.

• Performed performance analysis on reports to determine changes that would reduce report generation time. Applied user developed requirements to modify existing MS Access forms and reports.

• Re-engineered existing forms to reduce redundant processes and screen flashing from duplicate updating and refreshing.

• Followed established CVS standards for version control.

• Other duties include the modification of existing reports and forms to include underlying query changes, format changes and field additions.

Technical Environment: MS Access 2007

Fannie Mae, Bethesda, MD, June 2007 to March 2008.

Sr. Data Analyst/Access Developer

• Provided MS Access, MS Excel, VBA, SQL and CA Autosys support for the BCE Go Forward development process.

• Created both user and system documentation.

• Created process to export reports to MS Excel.

• Primary duties involved gathering system requirements by interviewing stake-holders, business analysts and managers to create and maintain exception and success reports on Multifamily loan level data imported from Standard and Pour and reports for end of month summaries.

• Created multi-layered forms to gather report criteria and update system variables. Used CA Autosys processes to automate sending emailing with attached reports for their BCE Go Forward (Bond Credit Enhancement) process and data uploading and exporting for their Standard and Poor’s data import/export process.

• In support of these activities worked with managers to create a failure driven alert process using CA Autosys. Follow established CVS standards for version control.

• Performed Performance Analysis on report and system queries so as to reduce execution time. Other duties include providing support to Data Analysts, Testers and Technical Writers.

Technical Environment: MS Access 2003, MS Excel 2003, SQL, CVS, CA Autosys.

Freddie Mac, McLean, VA December 2006 to March 2007.

Sr. Data Analyst/Access Developer

• Primary duty was to create an MS Access database using VBA, Forms and SQL for a Meta Data Repository warehouse.

• In support of this effort, and to maintain high data quality, worked with the stake-holder to develop the MS Access database to import, validate and cleanse data mappings for all Freddie Mac data systems.

• Worked with the business analyst to develop requirements for Excel reports using MS Excel macros and Vlookup to update CDE (Critical Data Elements) under the control of the stake-holders. Every CDE was stored to include, the data owner, processes and data controls associated with them.

• Created user and system documentation.

• Other duties include developing and reporting metrics, automating data input processes and data validation.

Technical Environment: MS Access 2000, MS Excel 2000, SQL, CVS.

Fannie Mae, Bethesda MD March 2006 to August 2006.

Sr. Data Analyst/Access Developer

• Provided MS Access, MS Excel, VBA, SQL development support for the FIN 46 restatement process.

• Primary duties involved developing multiple MS Access databases in collaboration with business analysts and stake-holder requirements, cleansing, filtering and processing security and loan data imported from their Oracle Multi-family Restatement database under extremely tight deadlines.

• Creating forms and exception reports to support data cleansing.

• Other duties included developing various ad-hoc reports for stake-holders and managers using SQL and VBA and providing support to Business Analysts, Testers and Technical Writers.

Technical Environment: MS Access 2000, MS Excel 2000, SQL.

TRICare, Arlington, VA, September 2005 to October 2005.

Sr. Data Analyst/Access Developer

• Provided TRICare with MS Access, VBA, SQL and MS Excel form and report development in collaboration with senior project manager and stake-holders using VBA and MS Excel macros.

• Used VLookup, MS Excel macros and SQL manipulated imported data for an Excel report.

Technical Environment: MS Access 2000, MS Excel 2000, SQL Server and SQL.

Army TMO, Arlington VA September 2004 September 2005.

Sr. Data Analyst/Access Developer

• Provided senior process planning and MS Access 2000, VBA, SQL support to Army's TMO (Technical Management Office).

• Managed the development and implementation of a plan to receive, update and export existing TMO security data to various Army site MS Access End User databases.

• Created a strategic plan to develop and implement an MS Access database to replace a non-functioning existing database and to incorporate new as well as current business rules, as defined by senior TMO officials and DOD directives.

• Set performance criteria based on user required outputs and TMO/DoD requirements and data search capabilities and the actual speed of the system.

• The new system provided instant response to extremely time sensitive requests and replaced the old manual file system. Provided over 10 reports for Security Officers to facilitate classified queries of the database.

• Determined best practices for the implementation of DoD/TMO directives and provided weekly status updates to senior TMO staff.

• Developed forms, reports, queries, macros, VBA code and tables to automate data importation and exportation to a system created in MS Access within DOD directives and TMO requirements.

• Took existing TMO/DoD/User requirements for a search process and implemented those requirements to provide the ability to search across multiple user directed databases using a fuzzy or direct search by name or social security number.

• Actively collected user feedback, DOD directives and business rules and requirements from senior TMO staff and incorporated them into the existing MS Access database.

• Developed and executed a plan by which three different databases were created based on senior TMO managers selected criteria.

• Other accomplishments included data normalization of a pre-existing non-normalized database and adding various references to a new database using VBA.

Technical Environment: MS Access 2000, MS Excel 2000, SQL.

BearingPoint, McLean VA August 2003 to September 2004.

Sr. Data Analyst/Access Developer

• Worked with Senior BearingPoint and Nextel managers to develop a system to track Oracle and Atlas’ EMPAC data conversion to PeopleSoft’s ERP.

• Tracked and reported milestones into weekly reports on system conversion status to senior BearingPoint and Nextel managers with respects to the data conversion.

• Worked with managers to create performance metrics and perform reasonableness testing and validated data capture processes with business analysts.

• Provided performance metrics, which were compared to the previously developed time line, with respect to current percentage of data converted with weekly reports on any problems and possible solutions.

• Though design and implementation of an MS Access database, which accessed the old systems and compared data with the new system, was able to analyze and report deltas in data rows as they were converted, reducing the amount of analyst hours from weeks to hours with a zero error rate.

• Developed a plan to provide data scrubbing and import/export file creation to facilitate data updates from the old inventory auditing system to the new Nextel’s inventory auditing system. Developed an MS Access database using SQL to scrub old data and export the data to allow senior Nextel engineers to update the new Nextel’s inventory auditing system.

• Developed time line and performance based metrics to compare to the actual data conversion process. Processes where developed to facilitate data verification in conjunction with the developed of metrics to provide a percentage of total data validated sorted by date.

• Helped senior Nextel engineers spot outdated vendor data as well as duplicate vendors because of name variations.

• Identified and extracted problem data sets and generated reports that were provided to the Nextel inventory engineers. Created an automated MS Access system to test scrubbed data, check updated tables with current data sets, create import file, so as, to turn operations over to Nextel.

• Provided training to senior engineers to facilitate the turnover of the MS Access database. Other duties include working with Nextel management to expose problems and determine solutions.

Technical Environment: MS Access 2000, MS Excel 2000, SQL.

JIL Information Systems Arlington VA, February 2002 to March 2003.

Web Developer/ Sr. Data Analyst

• Navy’s International Programs Office (NIPO), Cold Fusion Wed Developer, Provided Internet and Intranet Web sites support and development using Cold Fusion and SQL for the Navy’s IPO department.

• Met with senior IPO managers to address concerns of pre-existing systems and requirements for the new system.

• Developed weekly status reports to track current open problem tickets and new development status.

• Other duties include database design and modification, Test Script development and client support.

Technical Environment: Cold Fusion, MS Access 2000, MS Excel 2000 SQL.

PricewaterhouseCoopers LLP, Fairfax VA, July 2000 to July 2001.

• Department of State DoS February 2001 to July 2001.

Activity Based Costing/Business Process Improvement Analyst

• Provide analytical support for the process of exporting ABC Technologies Oros ABC model into PeopleSoft s ABM module.

• U.S. Veterans Administration September 2000 to January 2001

Sr. Data Analyst/Access Developer

• Activity-Based Costing ABC Model, Business Process Improvement

• VBA required assistance to automate quarterly data updates to its activity-based costing ABC models. \ Applied ABC accounting methodologies in support of VBA goals using the Oros ABC modeling package. Leverages his knowledge of Oros to develop a data driven MS Access End User interface to provide the VBA an automated process to create actual driver quantities using SQL.

• Reduced the time VBA required to develop intramodular assignments of support activity costs to primary activities from almost a week to just a few hours.

• Decreased the error rate associated with a manual process.

• Developed an error checking processes to identify erroneous reference numbers and correct them and developed a process to move costs from one reference number to another.

• Internal PricewaterhouseCoopers LLP October 2000 to December 2000

Test Team Lead/E-Time and Expense System Implementation Analyst

• Developed Test plans and procedures for two team members to provide real time testing for the web based electronic time and expense reporting system.

• Developed standards for creating test scripts, as well as, processes to report and document problems encountered while testing.

• Developed an MS Access system to track test scripts and provide project managers with problem test reports.

Technical Environment: eT&E Version 6.01, MS Access97, Oros, SQL.

SMS January 2000 to March 2000

Systems Analyst

• Provided a time and cost analysis of the existing U.S. Navy budget system for the purpose of converting from the Altos mainframe to a client/server platform.

• Interviewed all line item managers and documented processes of data collections for all inputs to the Navy’s Budget as reported to Congress.

• Determined the data flow from other outside agencies with respects to automating input processes.

Technical Environment: Altos, UNIX, C, 20/20, SQL.

CSI,June 1999 to September 1999.

Y2K Process Analyst

• Supported the State of New York’s requirement to perform Y2K process reviews for all of its top 40 information systems.

• Performed extensive reviews of all documentation and interviewed all critical staff members to verify that due diligence and best practices were followed while designing and managing the process and remediation code.

Technical Environment: Microsoft word

Litton/PRC May 1998 to May 1999

Y2K Verification and Validation Analyst

• Provided inspection and assessment of calendar Year Two Thousand Y2K issues for a variety of MS Access, Visual FoxPro and other software tools.

• Provided Y2K testing for the U.S. Patent Trademark Offices PTO Services, Technicians, and Asset Tracking System STATS.

• Designed and implemented test plans for the PTO s Expert Advisor, Hand held Asset Management Software, Hand held Dispatch Software, and Mobile Asset Administration Software.

• Ran SQL scripts against an Oracle back-end to determine Y2K compliance.

Technical Environment: FoxPro, Visual FoxPro, MS Access, SQL Server and SQL.

DynCorp February 1994 to May 1998.

Sr. Data Analyst/Access Developer

• Supported the Pentagon s Safety and Environmental Management Division with Access 2.0 and FoxPro 2.5b full life cycle development and maintenance support.

• Supported the Pentagon-wide 474 internal ordering system developed in Access 2.0 with a SQL*Server 6.5 back-end. Performed full life cycle development for the Pentagon s Federal Voting Tracking System with an Access 97 front-end attached to an SQL*Server Version 6.5 back-end.

• Performed full life cycle development and debugged and enhanced more than nine multi-user systems and migrated four ObjectVision systems into FoxPro for Windows.

• Provided the Environment Protection Agency, dBase IV 2.0 support and developed its National Center for Environmental Assessment Office of Research and Development group.

• Provided support for the Public Information Request Tracking System and Risk Document and Search System systems RISKDOCS.

• Combined and debugged the Chemical and Risk Assessment; Occupational, Health, Occupation Health, and Environmental Assessment Log; Chemical Synonym systems; developed in dBase III+ into the RISKDOCS system developed in dBase IV 2.0.

• Performed full life cycle developed for the Budget and Expense Tracking System for the National Archives using dBase IV.

Technical Environment: dBase IV, FoxPro, C, MS Access 2.0, MS Access 97, SQL, SQL*Server, Windows NT, Windows 95.

EER Systems August 1992 to February 1994

Sr. Data Analyst/dBase IV Developer

• Provided support for the U.S. Army inventory tracking systems.

• Determined user needs, performed systems analyses, and designed and developed, tested, and generated reports.

• Trained users on system usage and supported the technical writer.

Technical Environment: dBase

PRC/EDP Temps May 1992 to August 1992.

Data Analyst/dBase IV Developer

• Provided the U.S. District Courts with programming support for the CFS-2 Courts Financial System.

• Performed systems analysis, design and development, and coding and testing for the installation and upgrade module.

• Provided user training on the CFS-2 installation and upgrade module.

Technical Environment: Clipper, Blinker.

CSC November 1991 to May 1992

Data Analyst/Clipper 87 Developer

• Provided systems analysis and designed, testing, and debugging for U.S. Air Force publications, Inspector General Cases, and a supplies and equipment system.

• Provided training to users and assisted the Senior Technical Writer with development of user’s manuals and software development folders.

Technical Environment: Clipper 87.

NVA Appraisals February 1991 to October 1991

Data Analyst/Programmer

• Provided software and hardware support for a team of real estate appraisers.

• Using systems analysis and designed, coded, tested, and debugged an appraisal and comparisons tracking database’

Technical Environment: Clipper 87.

Telesystems Source July 1990 to January 1991.

Installations Specialist

• As part of an onsite installation team provided hardware and software installation and training for a predictive dialing system operating under Concurrent DOS (CDOS).

• Developed reports for clients, automated Telesystems Source s software installation process, and provided on line user support.

Technical Environment: CDOS, DOS batch files, Clipper.

TgBauer March 1996 to June 1990.

Data Analyst/Programmer

• Performed systems analysis and design for the conversion of an ECP Tracking System from COBOL to Clipper 87.

• Provided system analysis, design, coding, testing, debugging, and user support and training for an H-53 Bulletin Tracking System for the Naval Air Systems Command.

Technical Environment: Clipper 87, dBase III/IV, MS DOS.

Resource Consultants Inc. November 1986 to March 1988

Data Analyst/Programmer

• Maintained the Aircraft Engine Maintenance System database, wrote reports using Query Language Program, and trained Naval Air Systems Command personnel on the operation of the IBM 360.

• Designed, coded, and tested computer-based training packages and a U.S. Navy student tracking database and report system in BASIC.

Technical Environment: QLP, IBM 360.

CRS, Data Analyst/Programmer/User Support January 1986 to November 1986.

• Provided system analysis, and design, software and hardware support to more than 100 clients operating the BASIC Collection Resource System package operating under the XENIX operating system.

• Developed reports providing statistical analysis and data entry verification programs for clients.

Technical Environment: BASIC, XENIX.

Computer Skills

Software: Word, WordPerfect, Excel, Access, FoxPro, dBase III/IV, Crystal Reports.

Languages: Clipper, BASIC, VBA, C, SQL.

Databases: SQL*Server 6.5/7.0, Oracle, dBase, Access, FoxPro.

Hardware: IBM and compatible PCs.

Operating Systems: Windows NT, Windows 95, MS DOS, Unix, Xenix.

Certifications

ABC Technologies Oros Activity Based Costing modeling.

Awards and Honors

U.S. Air Force, Air Force Systems Command, Letter of Commendation, 1992.

U.S. Air Force, Air Force Systems Command, Letter of Appreciation, 1992.

Education and Certifications

B.S., Management Information Systems, George Mason University.

Contact this candidate