Frank Ellis Hunt Jr.

Summary:

●Over eighteen years of experience as an innovative creative Project/Delivery Manager, Administrator, as well as hands on roles as a Sr. Business Analyst and Test Manager.

●Experienced at administering projects in a Project Management Office (PMO) environment and engaging in multiple roles to assure project completion

●Served as a Delivery Manager for MS SharePoint 2010/2007 deployment and implementation.

●Managed over 50 new and enhanced relational database systems.

●Managed Oracle, SQL Server and MS Access databases utilizing SSIS (ETL/Report Builder), Visual Studio, MS Access, SQL/Plus PL/SQL and VBA. Extracted data from ODBC connected and linked external database tables/queries, imported Excel/CSV/Text files, user-friendly navigable menus and forms and a host of comprehensive reports/charts/graphs and dashboards based upon careful analysis of initial user needs and requirements.

●Managed SharePoint Portal and Intranet Sites and accompanying pages for over 25 divisions, implemented Document Management system responsible for storing and sharing inventory of historical drawings, libraries, lists, constructing workflows, records, contracts, programs, projects, policies and procedures, Identity/Access Management Search Consolidation System incorporating Active Directory, LDAP, CRD and integration of software and other web services/data sources.

●Served as a Sr. Business Analyst and Test Manager for over 15 ServiceNow Modules and custom-built applications

●Served as a Project Manager with experience in Healthcare Enterprise Project Management and Information Technology.

●Experience with managing more than 30 healthcare based IT Systems development initiatives and projects including Facets claims, extracts, EDI/Informatica, membership, CMS Medicare, Marketplace, State of Michigan DHS Medicaid, ICD-9/ICD-10, Vendor-based, Healthcare Website Marketing Analytics, Health Savings Account, Letter Server generation, Automated Authorizations, Individual/Group, etc. applications and solutions.

●Solid experience with Technology Infrastructure (Servers, Network Appliances, Data Center) and Software Application Development

●Experienced facilitator of requirements gathering with groups of 5 – 15 team members, resources, and stakeholders

●Attendee and firm believer of Knowledge conferences (ServiceNow Knowledge17 - May 2017) and continuing Information Technology/Business Courses

Education:

●U of D Mercy.

Masters Management Information Systems - Business Process Reengineering/Project Management/Software Development.

●Davenport University.

Bachelor Business Administration - Computer Information System/Program Management.

Certification:

●ITIL Service Management Certified

●Agile Certified

Professional experience:

Ally Bank, Detroit, MI May 2016 - June 2017

Sr. Business Analyst/Test Manager

Solid and extensive working experience leading the enhancement, maintenance, and testing of ServiceNow Modules:

●Managed ServiceNow Demand Testing. Responsible for all ServiceNow testing activities for ServiceNow Modules:

● Manual

● Managed Functional and UAT Tests

● Defined Testers and all Roles

● Created Test Suites/Cases/Steps

● Produced/Sign-offed Test Plans - Release and Standard Change

● Reported Defects and assigned developers to fix them

● Automated

●Guided Automated Test Team onsite/offshore

●Set policy for regression and smoke testing

●Worked with test tools HPE-UFT and open source Selenium

●Integrating Automation into ServiceNow

●Istanbul and future releases

●Integrating into ServiceNow Test Management

●Third party vendors - Cerna Solutions (CAP10)

●Responsible for managing the Demand Management process from start to finish:

●Ideas/Requests/Incidents/Projects

●Reviewed Ideas and approved as a Demand

●Analyzed user requests to create Demands

● Determined specific Incidents to be Demands

● Multiple Demands comprised a Project

● Monitored Demand State/Status

● Reviewed Demand Dashboard for state

● Tracked Metrics on Demands

● Created multiple metrics/reports

● Viewed Roadmap

●Worked with Change Management and Incident Management Team:

● Change Requests

● Change Management eight (8) step Life Cycle Process

● Separation of Duties Roles and Responsibilities

● Change Request Enhancements

● CAB Agenda and Demand Approval for Release

●Managed Incidents and worked with Incident Team:

● Determination of an Incident versus a Demand (Enhancement)

● Moving Alerts (including Email) into Incident Forms

● Incident Form Enhancements

●Managed Events and Alerts with Global Command Center:

● Monitored imported events (log message, warnings, etc.) from various external sources

● Make determinations of messages and color codes

● Escalate based upon severity levels

●Worked with Integration Partners and Leading ServiceNow third-party VendorsSCOM

● ScienceLogic

● Splunk

● Ariba/SAS

● CAP10

Job Search July 2015 - April 2016

Spectrum Health, Grand Rapids, MI October 2014 - June 2015

Project Manager

Managed Projects:

●Worked for the Enterprise Project Management Office (EPMO) and managed multiple healthcare projects through all life-cycle phases including gathering and determining the goals, requirements, capacity, assumptions, gap analysis, limitations, risks, resources, costs, etc. from Executive/Project Sponsors, SMEs, Presentations, Kickoffs, In-House/Vendor sponsored studies, surveys, etc. to define the scope of the project. Then, through estimating/establishing/adjusting a budget, more clearly define the functional requirements, test cases, issues and execute project through clear ongoing communication with all stakeholders to monitor/control, mitigate risk, change control, close and post evaluate project.

Formed Core Project Teams:

●Formed and managed large and diverse Project Teams, implemented solid communication plan and coordinated activities/tasks on multiple projects including with Executive/Project Sponsors, Business Resources, Business Analysts, Subject Matter Experts, Technology Mapping Architect, Technical Lead, Quality Analyst, Testing Team, Facets Team, EDI/Informatica Team, Enterprise Web Services, Web Development, UI/UX Designer, Vendor Application Integration Experts, Customer Service and Helpdesk.

Utilized Advanced Project Tools:

●Worked with the latest key Project methods and collaboration tools to manage projects effectively and efficiently:

οAgile Project Methodology.

●Scrum.

●Product/Sprint Backlog Board.

●Epics/User Stories.

●Daily Standups and Team communication.

οEPIC Estimation/Budget Worksheet.

●EPIC/Scope Item/User Story.

●T-Shirt sizes - baseline estimation.

●Resource costs.

οJIRA (Atlassian).

●Creating and Managing Boards - Scrum, Kanban.

●Administer Issues, Sprints.

●Zephyr - Testing.

●Reports - Sprint, Burndown, Velocity.

οMS Project.

●Project scheduling of all activities, tasks, milestones, etc.

●Monitored and delivered on deliverable dates.

οJIVE.

●Used the latest version of JIVE to manage documents and links for Project Team and Business Users.

οRisks Actions Issues Decisions (RAID) Log.

●Documented Project related activities and questions.

●Assigned resources to bring resolution.

οWebEx/GotoMeeting/Oovoo/Skype.

●Scheduling of audio and visual display meetings.

οCisco Jabber.

●Instant Messaging tool.

●Extensive knowledge of Federal CMS and State of Michigan DHS Health Insurance Regulations CMS Federal Regulations and Policies.

οAnnual Marketplace Renewal Letters.

οAnnual Notice of Change/End of Coverage.

●Medicaid - State of Michigan.

οMS-DRG codes.

οNew APR-DRG Codes.

●Worked with Industry Leading Vendors.

οMckesson.

οOPTUM.

οConnective DX.

οSitecore.

Job Search August 2014 - September 2014

Blue Care Network - Southfield October 2013 - July 2014

Project Coordinator

Managed Database Projects and Initiatives

●Coordinated and communicated project details using MS Outlook email, JAD and group meetings to keep all managers, analysts, technicians and all project stakeholders informed of project progress, scope changes, updates, prototype reviews, meetings, launch dates, unit/user acceptance testing, etc.

Maintained excellent communication in organization:

●Developed and maintained excellent communication and relationships with executive level administration, managers, business analysts, technicians and other users and stakeholders to define and develop solutions for a variety of unique high-level business needs and requirements.

Managed Major Databases for membership:

●Followed SDLC methodologies to manage and maintain over 7 major database systems while also employing VBA, Macros, Menus/Interfaces design, exporting and importing of data from linked ODBC connected Oracle tables/SQL queries, Excel CSV files text files, user friendly robust form designs, efficient reader friendly designed informational reports, Developed new and unique SQL queries to external databases and files to import, extract, validate and track data in tables, forms and reports.

Utilized Healthcare Software Tools:

●Utilized a variety of membership systems including- FACETS, Market Prominence, Business Object XI 3.1 for analysis, comparison, etc. of membership data. Proficient with MS Office suite including MS Outlook, MS Word, MS Excel as well as the use of Visio for designing, diagramming and mapping of systems.

●2014 Health Care Compliance Trained.

●Corporate Ethics and Compliance.

●HIPAA Privacy and Security Standards.

●Medicare Compliance.

●Fraud and Abuse.

●Code of Business Conduct.

●Employee Conflicts of Interest.

●Fraud, Waste and Abuse.

Department of Water and Sewerage Detroit October 1995 - October 2013

Project/Delivery Manager

●Utilized Software Development Lifecycle Methodologies and software tools covering initiation, planning, execution, monitoring/controlling and closing of projects over the 10 knowledge areas of Project Integration, Scope, Time, Cost, Quality, Human Resources, Communications, Risk, Procurement and Stakeholder Management.

●Reengineered numerous business processes.

●Continued process improvement ensuring initiatives are aligned with the changing business priorities and stakeholder project alternatives and solutions.

●Interfaced with clients/customers on implementation specifications.

●Managed relational database systems.

●Managed and implemented numerous relational database systems for departments and organizations and have successfully mentored and trained several staff in the use of MS Access, MS SQL Server (Visual Studio/ETL), VBA, Macros and the exporting and importing of data (especially from Excel CSV files as well as a variety of other databases and flat files).

●Conceptualized, budgeted and managed MS Access 600, 000 voters mobile database Voter Information Personnel System (WDIV News Video Demonstration - WDIV 10/2005).

●Highly experienced with SQL Utilized MS Access SQL, PL/SQL and transact SQL as well as using Crystal Reports, Business Objects and Oracle BI reporting tools

●Skilled at using MS Office 2003 - 2013 Regularly create Databases, Spreadsheets, User Manuals, Reports and daily correspondence (letters, memos, notifications, etc.), Impactful Presentations, Comprehensive Diagrams (Data Flow, Flowcharts, etc.) and daily Email correspondence.

●Worked with high-level ERP Systems (Oracle ERP) and Data Warehousing (Oracle ETL/Oracle OWB), integration of emerging technologies.

●Related business requirements and detailed functional specifications covering Information Technology, Human Resources and Finance modules.

●Gathered requirements from project teams, designed and constructed prototypes.

●Coordinated a number of special web development initiatives involving Joomla/PHP Open Source CRM with integration of current web services/data sources.

●Utilized Data Modeling tools MS Visio and Erwin to develop ERDs, data models and data flow diagrams, flow charts and hierarchical organization and work tasks charts.

●Managed budgets and contracts associated with all system development, resource allocation and vendor/customer relationships with proven deliverables.

●(12) twelve years of experience as a technical writer Created high level reports, technical manuals, email/online correspondence, website editing.

●Facilitated and monitored JAD sessions, Strategic Action Team meetings and ad hoc meetings to bring together business users, Information Technology Staff and Stakeholders to draw up plans for major enterprise initiatives and business-to-IT application development projects and systems.

●Executed projects and project plans and monitored Service Level Agreements (SLA’s).

●Performed, setup and monitored User Acceptance Testing (UAT) and reported critical path activities for best most time and cost-effective way to benefit organization.

Skills:

●Project Management

οMS Office Pro 2007-2013/Project Management - MS Project - Other software Project Software includes Basecamp/5PM/Zoho Diagramming.

●MS Visio/Smartdraw/Edraw.

●MS Access/VBA/SQL.

●MS SharePoint Enterprise Class Web Applications.

οPortal/Document Management/MS Visual Studio 2010/SharePoint Designer/MS .Net 3.5 - 4.0 HTML5/HTML4/CSS.

●Clarity/Peoplefluent.

οPeople/time management software.

●ServiceNow – Geneva, Helsinki, Istanbul – Serviced and administration of out of box modules (Demand, Change, Incident, Event, Test, etc.) as well as customized ServiceNow modules and applications

●Agile - Atlassian JIRA Project Management Software version 6.3.1.

οCreating and managing boards - Scrum/Kanban, projects, creating personal dashboard, Issues - Change Control, Chore, Defects, Epics, Risks, Spikes, Test (Zephyr for JIRA - testing add on), Creating Sprints, Gadgets, Creating versions, Assigning Priorities (Critical, High, Medium, Low) and Reports (Sprint, Epic, Epic Burndown, Version, Release Burndown, Velocity Chart, Control Chart, Cumulative Flow Diagram).

●Jive/Jive for MS Office/Outlook.

οCreating Places, Groups and Projects - sharing and adding members, adding Widgets to site, customizing HTML for conveying creative and useful content.

●WebEx and GoToMeeting.

οCreating Audio/Visually Shared Meetings.

●Cisco Jabber.

οInstant Messaging communicating with Project Team and Stakeholders

●Framework/ADO.Net/C#/Excel/VBA/JQuery/Java/JavaScript/JQuery/Sitecore.

οWebsite Analytics 8.0.

●Joomla/Drupal/WordPress/PHP.

●Social Networking.

οFacebook/Twitter.

●Application/Systems Development.

οUnix(Solaris)/MS Windows Server/Ubuntu Linux/SQL- Oracle/MS/SQL Server/SSIS Visual Studio (ETL)/PL SQL/Business Objects/Crystal Reports.

●Directory Server and Web Services Technology.

οLDAP/Active Directory/Identity/Access Management/Google Search Appliance/SVD search tools and Queries/Open Source Tools/Testing/Debugging.

●Internet Security.

οSAML, Single Sign-On, Encryption, SSL and WS-Security.

●Storage.

οHypervisor/virtualization/VMWare/HP/Cloud Computing.

●Graphics.

οAdobe Photoshop/Dreamweaver/Fireworks/Flash/Adobe.

●Tablet/Smartphone.

οAndroid - Samsung, LG.

Affiliations:

●Active Huron Valley PMI Member.

Contact this candidate