ANDREW FRALICK

248-***-****

SUMMARY:

Highly versatile, methodical, and hands-on professional, proficient in change control and release management.

20+ years' experience in project management, CRM, ERP (including Supply Chain & Logistics) and Electronic Medical Record systems, computer networking, database systems, TCP/IP phone and video-conferencing systems, security planning and implementation, and business planning.

Proven interpersonal skills, such as getting disparate groups of people to work together toward a common goal while staying within established budgets and timeframes.

Successfully led numerous projects and implementations involving various technologies, certifications, and standards including HIPAA, Patriot Act 1 & 2, and PCI, HITECH, 21CFR, and ITAR.

Provides full software development lifecycle management for both completely custom-written and modified COTS implementations.

Experienced in state/county government, automotive, tier 1 and 2 suppliers, ISO certification, healthcare/electronic medical records, FDA regulatory compliance, business continuity strategies, business intelligence/data mining, financial solution development, and implementation.

KEY ACCOMPLISHMENTS:

Managing budgets up to $33M.

Designing and implementing infrastructure for entire North American operations.

Managing implementation of multiple ERP and CRM packages, internationally.

KEY STRENGTHS:

Project / Program Management

Agile/Scrum Sub-Methodologies

Change Management

Release Management

Risk Mitigation

Business Continuity

Disaster Recovery

Cost Management

Security Planning & Implementation

Business Process Development & Re-Engineering

Business Analysis & Business Intelligence

SDLC, including International Projects

ERP/CRM/MRP Implementation Specialist

Cyber-Security Range Development

Clarity Portfolio Manager

Planview Portfolio Manager

Changepoint Portfolio Manager

Rational Team Concert software development and collaboration tool.

Business Administration

Communication Planning & Management

Major Systems Implementation

Cyber-Security Implementations

Strong Business and Commercial Acumen

Payment Card Industry (PCI) Compliance

International Traffic in Arms Regulations

Database Development & Network Management for National Propane Gas Association

TECHNICAL SKILLS:

Databases: DB2, AS/400, MSSQL, MySQL, Access

Software: MS Commerce Server, MS ISA Server, MS Office (Word, Excel, PowerPoint, InfoPath, OneNote, Access, Visio, Outlook, Publisher), MS SharePoint & SharePoint Designer, MSSQL Server, MS IIS, MS BizTalk, MS Exchange, MS FrontPage, MS Expression, MS FRx, MS Dynamics GP & AX, MS Dynamics CRM, MS Server 2000/2003/2008, MS Project, MS DPM, several Enterprise-Wide Quality Management Systems (3rd-Party & Off-the-Shelf), CA Clarity, Open Workbench, Planview, Adobe Acrobat, Adobe CS5, several Media Editing & Creation packages

Working Knowledge: SAP, QAD MFG/PRO, Sage, PRMS ERP, Siebel Systems CRM packages

EXPERIENCE:

State of Michigan, Lansing, MI 01/20 – 06/20

Senior Technical Project Manager, DTMB EPMO, Supporting EGLE & MDARD

Lead on the Michigan Agriculture Environmental Assurance Program (MAEAP) verification system project which offers Michigan farms the means to demonstrate their compliance with best farming practices and provides detailed reporting for state and federal legislators. This includes budget control, requirements gathering, procurement process, planning, in-depth project documentation, business case creation, JAD sessions, User Story creation, Test Case creation and multiple levels of status reporting following the Agile methodology. Worked with Vendor PM for creation of Use Cases and training documentation. Worked with Business Analysts to ensure integration with Legacy and other new systems.

Served as interim project manager for several quality of life division projects including USAHERDS, MiWaters, and RIDE, with complete planning, requirements gathering and management control.

Bendle School District, Burton, MI 04/19 – 01/20

Preferred Substitute (09/19 – 01/20)

Taught grades K-1, as a substitute for all subjects.

Title 1 Interventionist (04/19 – 06/19)

Taught and worked with students who had mental, behavioral, and/r emotional issues; helped them maintain their grade level and progress to middle school.

General Motors, Warren, MI 07/16 – 11/18

Change Control Board Lead (Contract)

Led daily Change Control Board and Technical Review Board meetings, facilitating review and validation of change requests, process approvals, and all software/hardware releases in the new GM division dealing with technology that was related to autonomous automobiles/advanced driver assistance systems (ADAS), active safety, vehicle-to-vehicle communications (V2V), connected vehicle, cybersecurity, infotainment, and powertrain. Worked with various divisions on Supply Chain and Logistic issues world-wide, including ensuring the various legal restrictions, by country, were observed.

Managed groups of engineers, maintaining project and development integrity and timeliness, including but not limited to: Business Case creation, Requirements Gathering, standard project documentation as used within Agile methodology, Use Case creation, and facilitated UAT.

State of Michigan, Lansing, MI 09/15 – 07/16

Technical Project Manager (Contract)

Managed the development and initial implementation of the ASCAP Modernization project, replacing an aging case management system for MDHHS (Michigan Department of Health and Human Services) specifically dealing with ILS (Independent Livings Services), ACP (Adult Community Placement), and APS (Adult Protective Services).

Organized capture of requirements.

Mediated all alpha, beta, and final releases of software builds.

Developed use cases for design.

Worked with various State of Michigan agencies to ensure integration with ongoing Legacy systems as well as other new systems under development. Facilitated the build out of hardware infrastructure to support the new system, as well as remediating security concerns.

State of Michigan, Lansing, MI 01/14 – 09/15

Senior Technical Project Manager (Contract)

Led the implementation of new electronic medical record system for two state veteran homes, including controlling incremental releases of customized modules necessary for the two unique facilities.

Organized and led capture of requirements, Use Cases, standard project documentation, and presented status reports to varied levels of State Management up to and including the Governor.

Created RFP, and reviewed vendor proposals.

Served as and lead project manager for Michigan State Police Cybersecurity Task Force, and implementation lead for State of Michigan Air National Guard/Army National Guard Cyber-Security Range. Supply chain integration for mock emergency exercises as well as the logistics of people and material was a part of this project as well. System integration with existing military and State systems was a must.

Comerica Bank, Auburn Hills, MI 06/13 – 01/14

Senior Technical Project Manager (Contract)

Managed the configuration, build, shipment, and installation of new switches and Windows servers, replacing Novell servers, Lotus Notes, and Windows XP across entire organization.

Efficiently coordinated data migration from old Novell servers to new Windows servers. Disaster Recovery planning.

Managed replacement of Windows XP with Windows 7 Enterprise.

Productively worked with cross-functional teams in replacing Lotus Notes with Microsoft Exchange and SharePoint, including the mediated releases of regional requirements.

Tested internal software to assure integration with new servers/system. Used Planview for management.

Reviewed and recommended changes/updates to PCI-related issues within the infrastructure and software upgrade.

Produced the majority of the documentation for all the above projects including: Requirements gathering, procurement, JAD sessions, UAT and final security testing.

General Motors, Detroit, MI 03/13 – 05/13

Senior Program/Project Manager (Contract)

Designed, developed, and tested the initial customer experience for ordering/re-ordering service with OnStar, by displaying all the possible options from GM and AT&T. This included the switch from Verizon’s CDMA infrastructure to AT&T’s GSM 4G LTE infrastructure.

Handled project scope, schedule, and budget under the auspices of the Project Management Office (PMO); and creep, changes, and budgetary issues reported up to PMO for consideration, remediation, or approval.

Began this project using the GM internal methodology, but it morphed into an Agile implementation. Used Planview for management.

Managed meetings between business analysts, vendors, and business owners (GM Infotainment), and managed preparation of developers, change management for testing group, and release management for all groups.

Troubleshot supply chain issues with Chinese firm who produced the new Onstar unit.

Resolved tremendously difficult challenge of keeping the various groups on the same page, each of whom thought their area was the only "important" one in the project, successfully garnering compromise between all of them.

Populus Group, Troy, MI 07/12 – 03/13

Senior Program/Project Manager (Contract)

Served as project manager for implementation of Microsoft Dynamics GP and Erecruit CRM recruiting system, as well as the creation of initial BI system combining information from GP and E-Recruit

Managed relationship and responsibilities between Populus Group, major vendors, and parent organization.

Led development of testing criteria and training criteria, and mediated change and release management. Assured this new system would integrate with Tek-System, a sister recruiting firm.

Gulfstream Aerospace, Savannah, GA 05/12 – 07/12

Program / Project Manager (Contract)

Served as project manager for Lotus Notes to Exchange 2010 and Outlook/Office 2010 implementation, including vendor and overall change/release management and all project documentation for all facilities worldwide.

Troubleshot legacy programs and had many rewritten so that full system integration with other company systems was maintained.

Served as project manager for transition of Gulfstream's primary technology vendor, from CSC to HCL.

Re-process engineered supply chain issues, in conjunction with HCL, to address world wide access to repair/replacement parts for corporate and military/government jets.

Reviewed and recommended changes for all ITAR-related issues.

Used Planview Portfolio Manager to manage projects.

Consumers Energy, Jackson, MI 11/11 – 01/12

Program / Project Manager (Contract)

Brought in as part of initial team of 10, for creating the new PMO and developing new methodology and documentation standards.

Served as project manager for Lotus Notes to Exchange 2010 and Outlook implementation, including vendor management; created presentation and training materials for the implementation.

Served as project manager on PCI project for network security for electronic transactions and on a mobility project for creation and logical staged release of mobile applications, used by technicians in the field.

Developed their first supply chain concept for repair people in the field to ensure the most commonly used parts were always available on the repair trucks. This included work on the back end with suppliers to ensure JIT logistic deliveries.

Functioned as a technical adviser for an additional 7 projects.

Used Planview Portfolio Manager to manage projects.

Common Ground, Bloomfield Hills, MI 12/08 – 11/11

IT Director

Provided project management for the initial implementation, release, and subsequent upgrade of county-wide Oakland County Community Mental Health Authority (OCCMHA) electronic health record system (EHR). Ensured compliancy to HIPAA, Health Information Technology for Economic & Clinical Health Act (HITECH), Patriot Act I & II, and 21 CFR (Code of Federal Regulations). Project managed development and implementation of virtualization of 15 physical servers down to 4 using MS Server and MS Hyper-V technologies.

Performed network infrastructure planning and development.

Managed development of a non-traditional BI system that ensured "consumers" were receiving the best possible treatment, as required by federal regulations, within reasonable timeframe.

Provided project management the overhaul of business continuity/disaster recovery plan with a new MS product. Achieved 4 complete backups of entire system, every 24 hours, with no impact on productivity; resulted in organization being consistently only 4 hours away from last complete system backup.

Managed help desk and negotiated and managed all vendor contracts.

Provided system administration for financial and fundraising systems, as well as HR and timekeeping systems.

Assured that the new EHR system still integrated with existing financial and HR systems.

Attended state-sponsored healthcare conference, twice a year, keeping abreast of changing technologies and requirements.

Created training curriculum for staff in the EHR system as well as Outlook and Publisher.

Used Clarity Portfolio Manager to manage EHR system implementation.

Azentek, Grand Blanc, MI 01/08 – 04/08

Technology and Business Process Re-Engineering / Project Manager (Contract)

Involved in developing and executing marketing strategies for sourcing revenue opportunities.

Performed project management of infotainment product testing and evaluation.

Secured national and international trademarks and copyrights.

Webasto Product North America, Fenton, MI 06/03 – 08/07

IT Director

Managed budgets up to 33M Euro.

Laid groundwork and opened new subsidiaries in several international locations, setting up banking, tariff, and sales/marketing operations.

Designed and implemented infrastructure for entire North American operations.

Updated and revamped WAN for Webasto aftermarket locations, worldwide.

Managed multiple domestic and international implementations of ERP (GP, AX, and Navision) and CRM packages through the entire range of the project from inception through discovery, scoping, implementation, release management, go-live, and post-mortem. This involved traveling extensively to locations in Europe, South America, and the Pacific Rim, as well as managing multiple cultures, languages, currencies, and expectations. Maintained full functionality at each location by develop bridges to assure integration with existing systems in various languages. This included full MRP, R&D, Supply Chain Management, Logistics and HR. Used Clarity Portfolio Management system.

Served as project manager for development and implementation of mobile applications for ERP and CRM; migrated business units from a variety of CRM systems (Salesforce.com, Siebel, etc.) to Microsoft CRM.

Handled purchasing functions, including as negotiating and managing all vendor contracts, as well as serving as buyer of infotainment and other electronic products for vehicle usage direct from sources in Pacific Rim.

Served as project manager for multiple SharePoint implementations.

Served as project manager, moving multiple subsidiaries from a variety of systems (e.g., SAP, QAD, Sage) to Microsoft AX or GP. This included all financial, shop floor, logistics, sales/marketing, and BI functions.

Managed both foreign and domestic infotainment projects, including cutting-edge navigation and entertainment products, designed domestically and built in China.

EDUCATION:

Master of Arts / MDiv in Theology & Philosophy

Asbury Seminary, Wilmore, KY

Bachelor of Arts in Sociology & Psychology

Spring Arbor College, Spring Arbor, MI

CERTIFICATIONS:

IBM and Learning Tree International Certified

Project Management Certified

CISM (Certified Information Security Manager) – In Process

Computer Hacking Forensics and CEH (Certified Ethical Hacker) – In Process

PROFESSIONAL TRAINING:

MS Networking – 1997, 2003

IIS (Microsoft Web Server) – 2000

MS Commerce Server – 2000

MS BizTalk Server – 2000

MS ISA Server (Security & Firewall) – 2001

MS Exchange – 2000, 2003, 2007, 2010

MS Office – 2000, 2003, 2007, 2010

MS FrontPage - 2000, 2003

MS SharePoint/MOSS – 2005, 2007, 2010

TCP/IP – 1997

AS/400 Administration – 1998-2000

MS Windows Server – 2003, 2008 R2

MSSQL Server – 1998, 2000, 2003

BUSINESS AFFILIATIONS:

ISACA Member (Information Systems Audit & Control Association)

Contact this candidate