FRED NORFUL
Cleveland, Heights, OH 44121
216-***-**** ac0wym@r.postjobfree.com
Objective:
Seeking an IT position that will utilize my extensive experience in the running of multiple large-scale projects, managing departments and designing databases in various IT environments.
Experience:
Roles: executive liaison IT director project manager
contract manager data architect database designer
technical lead logical data modeler
Skills: strategic planning IT consulting systems implementation
vendor contracts P&L accountability department development
full SDLCs formal methodologies work flow analysis
database design warehouse development business intelligence
project delivery physical (DBA) design business development
telephony data management software instruction
business analysis resource budgeting IT audit and assessment
risk management budget management infrastructure development
e-Business networking computer operations
executive liaison archival strategy offshore team management
data integration data optimization secret clearance
Dynamic and positive manager with strong oral, written and interpersonal communications skills
Significant experience in developing work breakdown structures and optimizing timelines
Proven diversified industry knowledge and success in retail, healthcare, hospital systems, engineering, finance, insurance, logistics, telecomm, manufacturing, defense, software development, banking and government
Accomplishments:
Attained four consecutive years of “Exceptional” CPAR ratings for the maintenance of a Foreign Military Sales software system..
Performed verification, audit and consultation on $1.3B and $1.7B DoD ERP implementations; utilized COBIT, CMMI, and PMBOK.
Improved risk exposure for an international metallurgical firm by creating a database and dashboards to collect risk information, track collateral and report to senior management
Managed $5+ million supply chain, software integration & upgrade projects
Increased customer satisfaction by introducing formal project management methodology, increasing customization revenues and stabilizing product sales presentation for a custom software developer
Led software solution project to recapture $14 million in fraudulent telecomm usage charges
Enhanced management decision-making through use of business intelligence solutions
Facilitated mid-cap acquisition by venture capital firms through IT audit and analysis
Built department to install software and manage beta test environment for product customizations across multiple clients for a trucking dispatch software developer
Guided IT department for a mental health agency through a successful Y2K transition
Reduced error reconciliation turnaround time by 40%, generating additional revenue in a $3 million per day telecomm billing system
Professional History:
Principal Consultant (S-Corp, sole proprietor) 1997 to Present
Norful Consulting Group, Cleveland, Ohio
Program Manager,US Air Force (2012 – 2016)
Program Manager of ten-person team for production and application support, including software and operating system upgrades for the Foreign Military Sales (FMS) Case Management Control System (CMCS), Dayton, OH. Four consecutive years of “Exceptional” Contractor Performance Acceptance Reporting (CPAR) ratings.
Senior IV&V Consultant – US Air Force (2010 – 2012)
Specialist on Independent Verification and Validation teams (IV&V) for the Integrated Personnel and Pay Systems ERP implementation utilizing BCL (AF-IPPS, Montgomery, AL (2011-12, 18 months) and for the Expeditionary Combat Support System (ECSS) ERP implementation Dayton, OH (2010-11, 9 months).
Developed collateral for Risk Management (including ERAM), Quality Assurance, Configuration Management, Change Management, Program Mangagement, Project Management, Information Security, Requirements Management, System Design & Architecture, Infrastructure and Data Lifecycle Mission Critical areas
Conducted interviews, analyzed documents and developed SWOT findings for various assessment areas
Utilized CMMI, COBIT, IEEE, Oracle AIM and PMBOK in evaluating best practices and developing recommendations for each assessment area
Conducted a consultation to develop a CMMI-based Quality Management function, delivered to the Senior Program Officer
Quality Control Manager – United States Census, Brecksville, OH (2010, 5 months)
Managed call center for Non-Response Follow-Up ReInterview effort.
Utilized Paper-Based Operational Control System for tracking, verification and investigative functions
Established metrics for local team performance
Managed daily technical, administrative and operational issues
Managed resource budget
Developed technical queries into Oracle repository
Strategic Risk Analyst, Architect – AMG, Amsterdam, Netherlands (2008-9, 10 months)
Developed a pilot system for the strategic risk management effort
Analyzed cross-functional needs through collaboration with corporate Vice President and subsidiary executives
Built pilot system with executive dashboard functionality, utilizing Access 2007 and Excel pivot tables with runtime web-enablement
Utilized COBIT standards in design and implementation
Normalized data capture, full SDLC for risk tracking
Developed architecture for centralized utilization, evaluated BI solutions and conducted vendor selection
Analyzed and designed executive dashboards across platforms, including JDEdwards, Oracle 10, and DB2
Evaluated ETL process
Project Manager - Erie Insurance, Erie, PA (2007, 4 months)
Accomplished two high-profile projects concurrently, each in the 3,000 to 5,000 hour effort range in Oracle/DB2/Websphere environments
Managed a high-NPV value proposition to assess late charge and reinstatement recovery fees, applicable across all product lines and moderated by specific state regulations
Added value realized by facilitating numerous business sessions to define and refine the regulatory and procedural framework for the Recovery Fees effort
Monitored the effort to enhance existing Voice Recognition and Response systems by installing third-party software to improve customer service
Performed contract evaluation, clarification and negotiation, held analysis sessions and developed recommendations with the Customer Service VP and Finance manager
Facilitated product evaluation walk-throughs with Erie Subject Matter Experts (SMEs) and the external vendor implementation manager
Defined scope, established resource costs, allocated resources and developed risk mitigation through issues management review with technical teams, executive sponsors and SMEs
Delivered fully PMI/PMP-compliant reports and procedures within client-defined PMO framework
Director of IT – CorrPro, Medina, OH (2006-7, 7 months)
Operated client company’s outsourced Information Technology department on a daily basis, including administration of experienced staff
Reviewed and approved all IT expenditures and invoices
Directed maintenance of a JDEdwards ERP system concurrent with a growing demand for operations and infrastructure materials and services
Re-negotiated corporate-wide telephony contract with external vendors
Developed corporate-wide paper management system
P&L responsibility, budget management, Service Level Contract (SLA) management, member of Executive IT steering committee, liaison with client CFO
Strategic Consultant – Technisource, Frisco, TX (2006-7, 7 months)
Developed IT assessments for mid-cap firm ownership and for equity investment firms interested in acquisitions
Audited IT functions at target companies
Researched industry comparables for all vectors
Developed deliverables to describe the results of the assay in the areas of governance, operations, budget and staffing
Primary Test Lead - Merrill Corporation, Cleveland, OH (2004, 4 months)
Installed a new internally developed software suite to provide web-enabled access to the breadth of the document management company’s digital-imaging capabilities
Facilitated activities for project team comprised of area manager, a development lead (managing the offshore development component as well), a database/environment lead and primary test lead
Improved test procedures by gaining a thorough understanding of the possible process tracks as well as the particulars of the individual data states
Built the first test bed in use at the client site
Project Manager – Steelcase, Grand Rapids, MI (2003-4, 6 months)
Implemented AR and AP modules in SAP R4 for major furniture manufacturer
Managed integrated team of staff consultants, internal staff and independent contractors
Conducted PMP/PMI-compliant project management activities and provided liaison functions with PMO
Project Manager – KeyBank, Cleveland, OH (2003, 4 months)
Tracked and reported effort upgrade inventory of 30,000 programs in various releases of COBOL to current IBM standard
Facilitated review sessions, technical discussions and test planning, utilizing skills and experience developed as a COBOL programmer and operations manager
Communicated status of PMP/PMI-compliant deliverables to the Project Management Office and the Technical Operations departments
Re-compiled and triaged programs successfully within test/verification efforts
Maintained integrity of project management activities consistent with a RUP/UML implementation and a Websphere integration
Project Manager - University Hospitals, Cleveland, OH (2002, 6 months)
Implemented a purchased third-party solution for electronic funds transfers for four departments (Supply Chain, Payroll, Accounts Receivable and Finance)
Managed a team consisting of departmental managers and technical leads as well as the sales and implementation leads from the vendor (Bottomline) and technical leads (both assigned and ad-hoc) from the development, database management, training and operational areas
Operated as a “hands-on” project manager, aggressively driving the project to completion
Communicated a details-oriented approach along with sensitivity to the political environment (the IT shop was being outsourced in the coming months; most of the affected managers had signed off on the purchase decision with little understanding of the product) while maintaining progress to the implementation date
Installed vendor software (PayBase) at the client, with web interfaces to the underlying Oracle database and external ACH horizons
Utilized application training and installed several configurations in order to present solution sets to the local managers
Lead Data Warehouse Modeler - Qualchoice Health Plan, Cleveland, OH (2001-2, 5 months)
Developed logical and physical star schema for migration of existing financial data to SQL Server / Access data warehouse
Managed a four person team as a lead data modeler
Generated a 200-entity model for conformed facts and dimensions for business analysis applications
Conducted analysis sessions with technical and business SMEs
Developed ETL data cleansing criteria and procedures, as well as standards for client-level J2EE HTML and APIs
Senior Modeler - Sprint PCS Wireless Services, Overland Park, KS (2001, 2 months)
Developed a single product: a high-level Enterprise Logical Data Model
Defined business areas and relationships and developed process models
Built three models from 300 to 500 entities each using ERWin and BPWin which were integrated into the Enterprise model residing in the CASE environment
Developed metadata repository and engineered logical models
Completed Facts and Dimensions with delivered models
Lead Logical Modeler - Westfield Companies, Westfield, OH (2000-1, 8 months)
Developed a 300 entity model for an insurance application Datamart as the Lead Technical Modeler on a six person team
Managed the deployment of a Personal Lines offering developed for a planned state-by-state rollout and integrated into the 1,200 entity enterprise warehouse
Facilitated business analysis and all Erwin, BPWin and ModelMart tasks for logical database modeling
Managed SDLC, metadata and partitioning with mainframe DB2-UDB team
Developed Informatica ETL standards and built a metadata repository
Performed analysis for EAI standards integration, web deployment and web architecture
Executive Support Consultant - Sherwin Williams, Cleveland, Ohio (1999, 5 months)
Assisted Project Office Director in Y2K risk assessment, mitigation, and compliance
Developed PMP compliant project plan for the evaluation and Y2K triage of 3,000 end-user workstations
Developed test criteria and established regression plan
Project Manager - Medical Mutual of Ohio, Cleveland, OH (1998, 12 months)
Managed Antares integration, HIPAA systems, financials, and other acquisition software
Addressed hardware and software upgrades
Conducted White Paper research
Performed web-enabled report for acquisition/conversion
Mentored project management staff, conveying best practices for developing statements of work and project charters
Senior Consultant 2004 to 2006
Accenture, Cleveland, Ohio
Project Manager - Travelers St. Paul Insurance, Hartford, CT (2005-6, 6 months)
Updated Personal Lines portfolio in a DB2/Oracle/MVS environment Developed office-based upgrade solution as part of the Project Management Office
Managed three related business project areas totaling more than 100,000 person-hours of work
Managed two offshore (Mumbai, Bangalore) development teams, providing US liaison
Improvised solutions to address communications problems by initiating basic daily “critical path” checkpoint meetings and formalized daily turnover on each end of the offshore shift with the on-site/USA staff
Recommended and negotiated changes to the over-arching delivery schedule in order to align business needs with environmental/staffing requirements
Developed and reported full metrics on risk mitigation, expended effort, resource allocation, current status, current issues and overall progress to SMEs, development teams, off-shore teams, business analysts and executive management
Quality Assurance Manager - SBC Communications, Cleveland, OH (2005, 2 months)
Managed a 12-member team consisting of nine offshore (Manila) resources and three onshore consultants
Transitioned the team to the offshore client-employed manager during his move stateside synchronizing offshore and domestic activities for a smooth turnover
Performed hands-on testing and facilitated knowledge transfer activities with the team utilizing knowledge specific to the telecomm ABA-format mainframe data environment
Testing Manager - JP Morgan Chase, Lowell, MA (2005, 3 months)
Provided quality assurance services during the acquisition of BankOne
Developed a test bed in the Mercury Test Director repository-driven tool in Oracle/DB2 environments
Led a team of testers developing re-useable cases and provided technical and managerial liaison with the repository development team
Project Manager -National City Bank, Cleveland, OH (2004-5, 6 months)
Provided project management, testing management and quality assurance to convert existing systems and process of Provident Bank and integrate them into National City Bank post-acquisition architecture
Coordinated, planned, tracked and reported activities of over 200 business resources in a conversion/acquisition project
Worked with more than 50 contractors and 150 internal employees
Facilitated the QA and Test coordination for the GL, Universal Balancing, Conversion Balancing, State Tax, Accounting / Reporting, Warehouse Lending Auto Lease, Equipment Lease and Securitization areas as they related to the IT-based acquisition of the new bank
Executed both dry-run and real-time/actual conversions, with on-site problem resolution and communications duties addressed
Developed risk mitigation strategies and procedures to assure post-implementation balancing of bank chart of accounts entities
Managed resources and cost allocation for the assigned scope
Director of Information Systems 1999 to 2000
Northeast Community Mental Health Center, East Cleveland, Ohio
Managed Information Systems and Billing departments’ operations and staff
Provided input as member of executive management
Guided agency through Y2K transition successfully
Executed fund development program
Established quality assurance procedures for testing of new software releases
Moderated IT contracts and relationships with external vendors
Chaired Executive IT Steering Committee
Maintained budget responsibility
Director of Implementation Services 1996 to 1997
TMW Systems, Inc., Beachwood, Ohio
Implemented project management methodologies
Facilitated client relationships
Moderated the relationship between the development and sales departments
Introduced formal PMI/PMP project management methodology that improved customer satisfaction, increased customization revenues, and stabilized product sales presentation
Piloted help desk support system
Built department to install software and manage beta test environment for product customizations across multiple clients
Managed to P&L budget
Developed executive level consensus on policy providing client enhancement assessments, clarifying revenue allocations across departments
Developed procedures to manage full life cycle of client relationship improving internal communications
Computer operations, programming and IT consulting pre-1996
Instructor: project management business software logical data modeling
CASE methodology consultancy skills Computer Science (university-level)
Education:
University of Vermont, MBA Program
University of Vermont, BA Psychology, Mathematics minor
100+ days of work-related coursework in information technology and management
Community:
Tutor, Mathematics in inner-city grade school
Mentor, High School preparation & application process in inner-city grade school
Computer assistance, several local nursing homes
Chairperson, Adult Education committee, local organization
Technical Summary:
Technologies:
Expert-level in MS Project, PowerPoint, Visio, Excel, Word; Access, PS6, Outlook, Comparex
Various business-oriented word processors, utilities, PC/mainframe interfaces, spreadsheets, project software and e-mail systems
Voice Recognition/Response Units (VRU)
Packages/ERP:
Peoplesoft v8.9, MSA, DBS, SAP, Oracle ERP, JDEdwards, Mercury, Quality Center
Databases:
Oracle, SAP, SQL Server (multiple versions), DB2, FOCUS, JD Edwards, Access 2003/2007, dBase, Sybase, FoxPro, SharePoint, Endevor
Data warehouses, relational schema, data marts, ETL
Logical, physical, analysis, performance tuning, security
Methodologies:
Data Flow Diagramming, state/event analysis, process analysis
Relationship modeling, normalization
Schema development, repository management
COBIT, PMP, RUP, SDLC, Kimball, CMMI, PMBOK, IEEE (several standards)
Business Capability Lifecycle
Practice areas:
Risk Management: identification, mitigation planning, metrics development, contingency planning, analysis
Quality Management: standards, processes, metrics, analysis
IV&V: mission critical area evaluation and interviews, best practices evaluation, SWOT analysis, executive-level presentation
CASE tools:
Oracle Designer, Erwin/ModelMart, Silverrun, Synon, Seer HPS, LBMS, IEF
Environments:
Windows (NT, 3x, 95-2007, XP), Lotus Notes, Novell LAN, intranets, SAN, WAN, client server, thin client, Websphere, .NET
IBM Enterprise Z, 390, 43xx, 30xx, 36x, 37x, AS400, Series 1, Systems 34/36/38, z/OS
Oracle 8/9/10, CICS, DB2 DOS, DB2 v8.2 DOS/VSE, VM/CMS, OS/MVS, MVS90C, VAX, VSAM, OS/JCL, DOS/JCL, SPF, ISPF, ETSS, TSO, VMS, ED