Software Developer Project Management

DAVID A. HARGIS

Cell: 817-***-****

********@*******.***

SUMMARY

Highly capable Software Developer with experience in Health Care, Point of Sale, Mortgage, Government, Transportation, Financial, Retail, Insurance, and Wholesale Distribution industries. Skilled in analysis, design, and development of large and small scale applications.

Personable and professional with strong service orientation and well developed interpersonal and communications skills.

Technically skilled in multiple operating systems and programming languages.

Adaptable, resourceful, and willing to assume a high level of responsibility.

TECHNICAL BACKGROUND

Hardware and Operating Systems:

Programming Languages:

IBM Mainframe and AS/400

DOS and Windows

Multi-Tier Client Server

VB, VBA, VB Script, C#, T-SQL

Databases and Tools:

SQL Server, Microsoft suite of office products 95 to Office 365. MS Project 2007, PowerPoint, Visio, MS Access, MS Excel, ABC Flow charter, VISUAL SOURCESAFE, Crystal Reports, SSRS, SSMS

PROJECT METHODOLGIES:

ERNST AND YOUNG NAVIGATOR

PRODUCTIVITY PLUS

SKILLS

Interviewing

Presentation

PMI Principals

Business analysis

Project Management

Requirements definitions

System analysis

Defect analysis and resolution

Project plans and WBS

Status reporting

Meeting organization

JAR and JAD facilitator

Complex Multi system integration

Complex accounting Regulatory compliance

Gap analysis

Data mapping

Object oriented design

Use case development

Best practices

SDLC

Formal deliverables

Process flows

EDUCATION

Jones College – Accounting emphasis

Houston Community College – Accounting emphasis

Completed course in Project Management Evolution emphasizing PMI principals.

Completed various technical courses including database design database management, various programming languages, and various operating systems.

Completed seminars in sales, professional development including time management, employee relations, law, and project methodologies.

Completed Texas Real Estate Commission approved classes including 60 hours in Mortgage Finance.

AWARDS

Microsoft MVP in Access – January, 2007; January, 2008; January, 2009

Information on the Most Valuable Professional award can be found at http://mvp.support.microsoft.com/

PROFESSIONAL EXPERIENCE

01/22 to 11/23 CareFirst Systems Analyst

Insurance

My assignment here was to correct bugs in an existing Access database application, then create a new version to improve accuracy and the user interface. This involved splitting the database into front end and backend components to make it multi-user.

The data was both Access databases and ODBC connections to SQL Server and Oracle databases.

07/21 to 11/22 New York Life Insurance Programmer/Analyst

Insurance

In this role I am supporting a system transition project schedule Excel spreadsheet to identify and track tasks for transitioning employees, hardware, and system configurations to move activities from Cigna to New York Life. This involves using Access to gather and combine several Excel spreadsheets into a Master Schedule used by the project team to manage transitions tasks. Access is being used because the macro enabled spreadsheets were to slow to use in the production environment.

All the Excel VBA macros were moved to an Access database and modified as needed to process the data. Access SQL queries were written to manipulate the data.

12/19 to 09/23 My Health My Resources, Tarrant County Programmer/Analyst II

Healthcare

I was asked by the Research Department to return to MHMRTC on a part time basis and resume my role of supporting their department’s existing Microsoft Access applications and creating new applications as needed.

We are currently in the process of moving the Access applications to MyAvatar. When that is complete, my involvement will come to an end.

10/19 to 04/20 National General Insurance Programmer/Analyst

Insurance

This role was to support the maintenance of mortgage loan insurance for client banks. I enhanced and modified an application used to assign issues to an analyst and track the progress and completion of the issues. The application was a Microsoft Access User Interface with SQL Server 2014 as the database and VBA as the programming language.

I was responsible for designing the user interface, VBA coding, and building queries, functions, and stored procedures using SSMS.

01/14 to 09/19 My Health My Resources, Tarrant County Programmer/Analyst II

Healthcare

In this role, my responsibility was to create and support desktop applications that supported government funded grants. The applications gather and validate data required for reporting to the funder. Theses applications were Microsoft Access VBA applications.

Lead a team of three in converting two Microsoft Access applications to web based applications using C# and SQL Server databases. We used Visual Studio 2017, Ajax, and Telerik tools. This included designing and building the database and user interface, and building queries, functions, and stored procedures using SSMS. I was responsible from converting the VBA code to C#.

Also supported and modified Access applications That had not yet been converted to web applications.

Supported and enhanced a timekeeping and payroll application written in Excel with VBA macros.

05/09 to 01/12 ECI Solutions Access Developer

Hardware Industry POS

Creating Access and SQL Server databases for new customers. This includes converting data from competitor systems for customers moving to our system. Also troubleshooting data issues and writing SQL scripts to correct these data problems. Using VB6, Access 2007,SQL Server TSQL. Also participated in transitioning from Jet database to SQL Server 2010R2 and from VB6 to VB.net.

06/07 to 11/08 RealPage, Inc. Access Developer

Multi Family Housing

Supporting and enhancing Microsoft Access applications that provide utilities billing, invoicing, and implementation workflow management. Providing design documentation, code remediation, and database schema design. Applications use both Jet and SQL Server 2005 database engines. Creating tables, indexes, views, and stored procedures in SQL. Applications made extensive use of VBA. Access applications connected to SQL Server data using ODBC.

02/07 to 05/07 KForce Technology Staffing Access Developer

Revenue Management

Assigned to Capgemeni Energy as a Business Analyst and Microsoft Access Developer. Applications were written using VBA and both SQL and Jet database engines. Access applications connected to SQL Server data using ODBC. Gathered functional requirements by review existing system and interviewing end users to design and construct an Exceptions Resolution Work Assignment database that will assign tasks to operators who will research and resolve the issues. Developed Systems Requirements and Functional Specifications Documents.

08/04 to 01/07 Paladin Consulting Access Developer

Project Costing

Assigned to Northrop Grumman Commercial, State, and Local System (CSLS) Business Management Unit as an Access Developer/Financial Analyst. CSLS manages IT projects cost accounting and billing. Developed an Access multi-user database application to produce the monthly invoice and provide management reporting for project costing. This included automation with Excel to provide complex reports including charts in spreadsheet format. Used VBA in both Access and Excel. Used ODBC to connect Excel to Jet database engine.

01/02 to 07/04 Independent Consultant

Application Development

Providing specialty application design, development, and support for the Real Estate industry using Access with VBA.

01/95 to 12/01 BEST Consulting, Salem, OR Developer/Business Analyst

Local Government Systems

For a Consortium of Work Force Investment Act County Agencies

State and Federal Workforce Investment Act Database Management and Reporting

Lead developer for a project for a consortium of county job training and placement agencies. Produced a client data gathering and reporting application compliant with changes in federal workforce investment laws. Converted the FoxPro 2.6 database to Microsoft Access 97 and 2000 to support new data and reporting requirements.

Worked with client representatives to develop business requirements and managed development team to produce the application.

Technical environment was NT Server based with Windows 95 through Windows NT clients. MS Access, and Visual SourceSafe.

State Government Systems

For the Oregon Department of Transportation

Developed multiple applications using Visual Basic 5 and 6, Visual Foxpro, and Microsoft Access. These applications included Safety Priority Indexing, Bridge Inspection, Crash Management. This role included gathering requirements and specifications for the project.

Technical environment was IBM Mainframe MVS, Client Server with NT Servers, Windows clients, COBOL, VB, Access, SQL Server.

For a Footwear and Clothing Company

Provided Business Analysis for a project to implement a warehouse inventory management system. Worked with business representatives to develop business requirements and document the workflow. Worked with software vendor to ensure project objectives were met. Wrote technical specifications for in-house modifications. Wrote user documentation, and user training manuals.

Technical environment was Unix based client server with Windows clients and interface to wireless handheld devices.

For an International Overnight Air Freight Company

Provided Business Analysis for a Computer Aided Dispatching project. Led effort to identify user requirements, develop selection criteria, and select vendors for the project. Also developed the technical architecture plan to integrate mainframe, client server, wireless, and handheld technologies. Worked closely with upper management to ensure business objectives were met.

Led or participated in multiple JAD sessions to produce requirement and functionality specifications. This included international participants.

Worked with hardware and software vendors to evaluate their companies and products. Analyzed products to ensure compatibility.

Worked with other application areas to define system interface requirements.

Worked with the software development team to develop and monitor field testing.

Technical Environment was multi-tier client server using IBM Mainframe as the enterprise server, Sun Unix based systems as regional servers

Contact this candidate