Project Manager
Resume:
DAVID A. KENDALL, III
Arlington, VA 22204
(C) 206-***-****
************@*****.***
Career Summary and Objective
Experienced technology professional seeking a position where technical and analytical skills can be utilized to the best of my ability. Areas of expertise include database administration, project management, application development, and business analysis in the business areas of healthcare, biotech / pharma, government, higher education and associations.
Professional History
Molina Healthcare
June 2016 through April 2018
Senior MITA Financial Analyst III
Performed the business analysis role while working for the MMS division of Molina Healthcare. The MMS division manages the Medicare and Medicaid claim processing for state clients with a combination of custom and COTS products collectively known as HealthPAS. The current project, an implementation of HealthPAS for New Jersey, will serve1.7 million patients this year. My duties on the project included:
Developing and maintaining permanent company assets such as Use Case and Use Case Elaboration documents.
Assisting in the design of SSIS solutions to satisfy client business requirements including development of SQL code.
Developing and delivering ETL framework training to company staff.
Developing SQL code to support unit testing of SSIS packages.
Leading weekly status meetings.
Ron Greene & Associates
November 2015 through May 2016
Data Analyst
Performed the business analysis role working on the FREE re-engineering project in the MMS division of Molina Healthcare including the following activities:
Developed analysis documents and diagrams for SQL stored procedures.
Assisted in the development of Use Case and Use Case Elaboration documents.
Assisted in the design of SSIS solutions that will improve the performance of existing systems.
Seattle Public Library
August 2014 through September 2015
Senior Systems Analyst II
Responsible for maintaining mission critical databases and systems, perform the primary DBA role for all MS SQL server systems, generate ad hoc reporting, and revise existing systems as needed.
Project manager for replacement of patron self check out systems and software at all branches.
Project manager for replacement of staff check in software at all branches.
Performed business analysis role with departmental users to create ad hoc reporting of library data.
Performed updates of departmental COTS applications after coordinating with end users.
Project Universe
January 2014 through January 2016 (part time)
DBA/Developer
While at customer site Acucela, worked with a small project team to develop an automated method to gather payment information for reporting to the CMS Open Payments system per federal government regulations.
Designed a database schema to support the recording of payments reported and archive them for future issue resolution.
Developed SQL code to automatically generate CMS data based on accounting codes assigned to payments.
Developed a GUI in C# .NET to allow a user to manage the payment records and produce file outputs that could be sent directly to CMS or be integrated into the Porzio system.
Composed requirements and other documentation to support the project.
Converted multiple stored procedures and views from MS Dynamics GP to SAP B1.
Acucela, Inc. (biotech)
April 2012 through December 2013
DBA & Business Applications Engineer
With the assistance of one employee, managed the mission critical applications of the company in compliance with SOX regulations. In addition, performed the business analyst/project management role working with all business units to develop technology solutions involving their business processes. Accomplished the following:
Insured SOX compliance through the performance of quarterly audits and the creation of change control tickets for in scope applications – Dynamics GP, EASi stock management, and PNW payroll.
Developed and revised SOP documentation which allowed the company to maintain SOX compliance.
Reduced the costs of vendors supporting the accounting system by resolving simple to complex issues and by being the primary business and technical contact.
Led enterprise system migration from ADP to PNW payroll and time keeping services which lowered monthly payroll expenses.
Designed and developed code to facilitate ETL for data between Dynamics GP and Wells Fargo CCER automated payment system which eliminated the expense for printing checks.
Managed technical support and performed updates for the chemical compound database interface and inventory software which improved the usability of the systems.
Assisted scientists in development of perfusion system based on National Instruments software utilizing pressure transducer and syringe pump hardware which created a potential new revenue source for the company.
Led development of committee to guide intranet strategy for SharePoint collaboration system which will lead to an improved user experience.
Gathered and documented requirements, documented project charters, documented project plans, and documented implementation schedules for the projects listed above.
Bastyr University
August 2005 through April 2012
Applications Team Manager
Provided leadership in maintaining and developing university systems that facilitate the Bastyr mission in a manner that complies with FERPA and HIPAA regulations. Managed five IT professionals in addition to supporting several major database systems, in-house developed applications, and external web sites. Met independently with department heads and executive level personnel to identify issues and develop solutions. Provided strategic planning for department and contributed to budget planning. Accomplishments included:
Integrated the student information system (CAMS) with nearly all of the school’s systems resulting in savings of several FTEs of manual labor.
Redesigned and refactored the transportation system allowing the collection of parking fees increasing the school’s revenues by over $40K per year.
Developed midwifery clinical requirements system utilizing SQL Server, C#, .NET, and SSRS which allowed the department to maintain compliance with Washington state midwifery regulations.
Led implementation of system for disbursing financial aid to students via US Bank which eliminated large amounts of paperwork and labor.
Was the primary business analyst for the university documenting requirements, project charters, project plans, and implementation schedules for the following systems:
CAMS Student Information System
Moodle
Solomon (Dynamics SL) Financials
Raiser’s Edge
Ad Astra
Centricity Patient Management Software
The in-house departmental systems provided services to Facilities, Financial Aid, Dispensary, Faculty Services, and others utilizing tools such as ASP.NET, SQL Server, and Microsoft IIs. The external web sites included the main Bastyr web site, the Bastyr Center for Natural Health web site, and the university’s intranet.
Technology Consultant
November 2004 through July 2005
Primary customer was the American Diabetes Association where I provided remote on call support of various database systems at an hourly rate. Also provided assistance in technology for local nonprofits during this time as well as taking a web development class at Seattle Central Community College and an Oracle RAC implementation class provided by the Puget Sound Oracle Users Group.
American Diabetes Association
September 2002 through October 2004
Director, Database Administration
Provided leadership in development and deployment of database systems that facilitate the ADA mission. Managed one employee and with the cooperation of other team members, maintained several database systems utilizing a variety of operating systems and database technologies. Provided strategic planning for department, negotiated with vendors terms of maintenance agreements, and contributed to budget planning.
Oracle Financials
Team Approach enterprise association management software.
Siebel Call Center
Blue Martini Estore
Several client server systems with less than 25 users based on various database engines including MS SQL Server, MS Access, Interbase, and Borland Database Engine
Information Management Consultants, Inc.
May 1995 through March 2002
Provided leadership as a principal of the organization finding leads for new business and mentoring junior consultants. Performed a variety of technical and management duties including the following roles:
Project Management (June 2001 - March 2002)
Managed two projects which involved the development of web based software utilizing J2EE, MVC, and RAD for a bank client and for IMC.
Managed one COTS implementation project for a transportation system client.
Database Management (August 1998 - May 2001)
Managed a team of 7 consultants who provided database administration and system support for the federal government.
Managed one software implementation project including developing software utilizing Oracle and Microsoft VB for the federal government.
Network Management (June 1995 - July 1998)
Performed network administration duties for two different federal government agencies.
Performed workstation support including installation of software and resolution of issues.
Procured and installed new hardware and software.
Woodward & Lothrop Department Stores
July 1985 through May 1995
Senior Programmer/Analyst to Manager, Store Systems
June 1988 through May 1995
Managed three professionals maintaining PC based systems for a 10,000-person organization with 40 locations spread over several states and working with several systems involving inventory management, administration management, accounting management, and mainframe system integration.
Primary point of contact for internal customers for PC based solutions. Managed projects and coordinated outside contractors.
Responsible for acquisition, distribution and support of all PC hardware and software, including the creation of LAN/WAN services, full life cycle development of in-house systems according to company standards and utilized project management tools.
Certifications
CAPM 12/09 – 12/14
CNE 3.1X - 8/97
Specialized Training
Completed Classes Since 2000: Agile Project Management (Bellevue College), PMP Certification Prep II (South Seattle Community College), PMP Certification Prep I (Seattle Central Community College), Introduction to Web Design (Seattle Central Community College), Oracle 10g RAC Installation, Oracle Financials System Administration, Oracle 9i Application Server, HP UNIX Administration.
Completed Classes Prior to 2000: GroupWise Administration, GroupWise Advanced Administration, Intranetware: Integrating Windows NT, Microsoft SQL Server 6.5 Administration, Oracle 8 Administration, Oracle PL/SQL Introduction, Project Management, JAD/JRP, Introduction to Microsoft Access, Introduction to Microsoft Project.
Technical Skills
Hardware: HP rp8400, HP EVA 5000 SAN, IBM PC and compatibles, IBM 3090 mainframe, Token Ring, Ethernet 10BASET, CiscoPro Remote Access Routers, Synoptics Hubs, Cisco 7000 Routers
Computer Languages: T-SQL, C#, PHP, HTML, ASP, MS VBA (ACCESS), VBSCRIPT, MS C, MS BASIC, FOXPRO (DOS), DBASEIV, MS VISUAL BASIC 6, ADABASE NATURAL
Software: HP-UX (UNIX), Windows 95/98/XP, Windows NT/2000, Oracle 9i RAC, Microsoft SQL Server 2000/2005/2008 (including SSIS, SSRS) Microsoft Access, Dynamics GP, Crystal Reports, Novell Netware 4.11, GroupWise 5.5, Microsoft Office (Excel, Word, PowerPoint), Netscape 4.x, Backup Exec, ER Studio
Education
Georgetown University, Bachelor of Science, Business Administration
Contact this candidate