SUMMARY:

• I have over 20 - years of IT Experience of which 12-years has been with U.S. DoD Supply Chain Systems (Provisioning, Stock Control, Requisitioning, etc.). My experience includes but is not limited to the following: Team Lead, Mentor, development of ‘As-Is’ and ‘To-Be’ Business Models, Data Conversion, Data Modeling/Mapping, Liaison between Stakeholders and Development Teams, Facilitating RAD/JAD Sessions.
• Provided advice on a hardware purchase that saved an investment firm over $25 million
• Redesigned an on-site development strategy which reduced development time and cost for DoD
• Received a bonus for saving a Confidential contract and having it extended 9 months
• Received a Letter of Appreciation from the DMAPS PMO, W.P.A.F.B. for work performed
• Successfully mediated court assigned cases
• Taught a Leadership program for 6 years
• Wrote the proposal that won a U.S. Army contract worth $10 million
• Provided advise to the Federal Drug Enforcement Center on the development of its first Data Warehouse

TECHNICAL SKILLS:

Professional: Business Area Analysis (BAA) Business Process Analysis Business Process Modeling (BPM) Data Analysis Data Conversion Data Modeling/Mapping Data Standardization Data Integration EDI IDMS IMS ISO 9000 JAD & RAD Facilitator Mediator Requirements Gathering OLAP ETL ERP Sarbanes Oxley (SOX) Internal Controls HIIPA Data Security

Case Tools: BPWIN IEF/Composer ERWIN Information Framework (IFW) Business Object Model (BOM) Interface Data Model (IDM) WebSphere

Databases: Access DataCom IDMS IMS ISAM Oracle 7, 9i & 11i .Net VSAM

Documentation: BPMs Coding Standards Data Dictionaries Data Maps Entity Relationship Diagrams (ERDs) Logical Data Models (LDMs) User Manuals Service - oriented Architecture (SOA) Physical Models Functional Descriptions Financal: Mercury Quality Center AppQuest Project Reporting System (PRS) Test Director Enterprise Request System (ERS) ServiceWare Architect MISMO

Federal Government: Air Force Systems: Provisioning (D220, DO33 & DO35K), Stock Control and Distribution (DO35J), Requirements DataBank (D200), DO43, ABOM, NIMMS Army Systems: CCSS (Provisioning and Depot Maintenance) Marine Corp: Provisioning, Stock Control and Supply Navy: Provisioning, CARES/SPA Other Military: Supply Support Request (SSR), Mil - Strap, Mil-Strip, DO43, JO11, JO41, TIMS, AFMAN 23-110, FAR, DOD 4140.26-M, DOD 4100 (FLIS), REMIS, SBSS, Supply Chain Management, PTD, WRM, DII/COE, and many other Government and Military Regulations and systems Other: EPA PBBR, CMIS, DIFMS, PTS, DIFMS

Languages: Assembler CICS COBOL COBOL II COBOL DL/SP HTML Ideal JCL SQL PL SQL SQL Loader SQL Plus UNIX Control Script HTML Web Services Description Language (WSDL) XML

Methodology: IDEF SDLC Sapient Approach DMAIC SIPOC RACI Charts

Microsoft: Access Active Directory Excel Outlook PowerPoint Project Visio Word Windows OS

Operating Systems: DOS MVS/ESA MVS/XA OS/2 UNIX Windows AS400

Other: Adobe Acrobat CHIMES (an ERP) Crystal Reports Data Query Easytrieve ETL Expeditor HIPAA ISPF Oracle Forms 4 Roscoe SQL Navigator 4.4 TCP/IP Tivoli Problem Reporting Tivoli Remote Access TSO Lotus Notes Point - in-Time Reporting (PTR) Service Center Operational Data Store (ODS) ClearQuest Lotus Forms Designer Network Operating Systems ServiceWare Reflections Balanced Scorecard Tectia Remedy SQL Developer JIRA CMIS

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Business Analyst

Responsibilities:

• Development of the conversion Initial Load project plan (task level - Microsoft project)
• Maintenance of the project plan (tracking progress and ETA by task)
• Report weekly on project progress (see weekly status report)
• Report weekly on data loading status
• Track open issues
• Oversight of Data Entry team
• Review Individual Member progress
• Conduct, retrain or refresh for individuals as required
• Manage validation error resolution
• Development of detailed conversion plan/process (step level)
• Development of SOP documents for data entry (step by step instructions)
• Capture all business rules for data collection
• Document data translations by attribute
• Create and organize data collection spreadsheets
• Organization by Release by Commodity
• Additional organization will be required for target systems sources, repeating vs non-repeating attributes, Basic vs. Commodity Specific Attributes, and package type
• Develop communication process and how the team will work in parallel tracks without stepping on each other
• Resolve issues
• Revision data capture for each release
• Creation of transformation excel files for converting Valid Value data or creating derived data
• Creation of collection spreadsheets for non-system data

Confidential, Rockland, MA

Business Systems Analyst

Responsibilities:

• Assigned to Fidelity Investments, Covington, KY
• Identified the role of Business System Analyst
• Identified and designed the tools needed to gather and write detailed requirements
• Liaison between all the IT Teams and stakeholders
• Used the Sapient Approach, Six-Sigma’s “DMAIC Methodology” incorporated, SIPOC, RACI Charts, and Fusion User Workshops which included Story-Boarding to gather, identify and map requirements
• Identified and wrote detailed requirements for the Inbound Mail Image Processing for the distribution of the images and capturing of data

Confidential, Cincinnati, OH

Lead Business Analyst

Responsibilities:

• Assigned to Axcess Financial
• Gathered and documented functional requirements to resolve problem tickets
• Tracked requirements using JIRA
• Communicate daily with the engineers in Lima, Peru

Confidential, Milford, MA

Senior IT Specialist

Responsibilities:

• Assigned to the DFAS, Indianapolis to support their work with Air Force Requisitioning through the DMAPS PMO, WPAFB
• Served as the Senior Specialist
• Developed Material and trained the new business analyst
• Responsible for the daily effective operation of two critical financial systems including the identification of problems, needed enhancements and system changes
• Analyzed and evaluated financial management accounting systems, public laws, governing policies, guidelines, rules, regulations, and precedents
• Provided advisory services to management in relationship to performance assessments and kept management informed of inconsistencies in work processes
• Analyzed functional and technical requirements of proposed and existing Finance and Accounting Systems to determine avenues of development or modification necessary to meet mission objectives
• Worked with all information sources to improve system performance and reliability through the develop of databases and micro-applications
• Reviewed operational capabilities and provided comments and recommendations for proposed changes
• Prepared System Change Requests (SCRs)
• Developed documentation required for the Configuration Control Board (CCB)/Configuration Management Information System (CMIS) overviews
• Established conditions and requirements for systems tests
• Established project requirements and timetables
• Provided technical advice and assistance to team members for the interpretation of system controls
• Researched, analyzed and resolved daily system problems related to system interfaces, potential interfaces, database management and process cycles
• Provided technical advice in determining the extent of system problems, potential solutions, and required actions for resolution
• Advised supervisors and Senior Management on major system issues, associated risks, functional impact and data integrity
• Analyzed COBOL code to identify and understand processing issues, and to create Physical Models
• Wrote SQL and Unix scripts to support the analysis of data issues and for testing purposes
• Prepared system documentation for the purposes of improving software development processes in accordance with accepted industry standards, and DoD and Air Force Regulations
• Participated in User Group Conferences and system requirement reviews, and coordinated with customer/functional representatives and other technical personnel to clarify requirements
• Identified how system modifications or new systems or subsystems affect current systems
• Prepared system documentation for purposes of improving software development processes in accordance with acceptable industry standards and Government Regulations
• Lead the design and development of the following documents: Functional Requirement, User Manual, Data Element Dictionary, Coding Standards, and Code Design Standards
• Performed analysis and wrote a summary as to what the impact would be to bring U.S.A.F. NWRM data into ABOM/NIMMS and identified other systems that would be affected
• Identified how system modifications or new systems or subsystems would affect current systems
• Performed analysis in support of the Air Force Expeditionary Combat Support System (ECSS) Interface
• Supported the ABOMTR Rehost at the U.S.A.F. Air Logistic Centers (ALCs) and received a letter of appreciation from the DMAPS Program Office at WPAFB, Dayton, OH.

Confidential, Beavercreek, OH

Independent Contractor / Consultant

Responsibilities:

• Provides Subject Matter expertise (SME) and Program Management (PM) consultancy services supporting: “Legacy Information Systems and Data Architecture: Sustainment, Enhancement, and/or Modernization of the Federal Enterprise” services.

Confidential, Milwaukee, WI

Business Analyst Specialist

Responsibilities:

• Developed a white paper titled “Business Process Modeling - Roadmap” to illustrate the need for Business Process Modeling
• Analyzed SOA documentation to make distinctions between the data elements and document them
• Analyzed the Metadata Logical Data Model (LDM) for improvements
• Wrote pseudo SQL scripts for the Metadata Load of the Global Banking application
• Reengineered documentation to develop the Business Process Model (BPM) and the Business Object Model (BOM), utilizing the FDDs, and the IDMs from IFW for Global Banking
• Developed a Power Point Presentation for various levels of management illustrating how the various models fit together
• Reviewed the WSDL Parse of XML to verify and validate IDM use cases
• Supported both the Global Banking Business Process and the Data Management Teams
• Analyzed business process models drawn in Visio for Customer Relationship Management (CRM) / Service Request Management (SRM)
• Developed the As-Is BPM for SRM\CRM utilizing WebSphere & Visio

Confidential, Columbus, OH

Business Analyst

Responsibilities:

• Lead Business Analyst on the Voyager Letters Project to improve Customer Service
• Worked with users to identify workflow for retail mortgage letters
• Worked with users and database teams to identify shared data for Letters
• Identified data elements for data integration and interfaces

Confidential, Miamisburg, OH

Data Analyst

Responsibilities:

• Analyzed and mapped loan (mortgage) data from legacy (AS400) to new DB2 & Oracle databases
• Worked with Business Analyst to work out data issues
• Mapped data elements from the Empower (E ) to ODS database using Empower
• Analyzed data to insure it was MISMO compliant

Confidential, Marysville, OH

Project Manager

Responsibilities:

• Trained the Business Analysts (BAs)
• Developed a resource tracking application using MS/Project
• Provided input to the Confidential Steel Department and its vendor for the design of a new application

Confidential, Columbus, OH

Business Analyst - Data Migration

Responsibilities:

• Performed requirements gathering, business and data analyst for Data Quality Management (DQM) of Mortgage Data
• Wrote DQM Baseline Requirements Specification which included the data structure of a new interface data file
• Performed business and data analysis for OPUS for document tracking for retail mortgage software upgrade from version 2 to 4 - This tracked retail mortgages from conception to disposal
• Developed As-Is and To-Be Business Models using IDEF methodology
• Worked with users to gather business requirements
• Wrote Functional Specifications for the OPUS upgrade, which included VISIO diagrams of the As-Is and To-Be OPUS System which illustrate the OPUS interfaces.
• Wrote OPUS Interface Requirements Specifications which include data mappings and data parsing scripts
• Wrote OPUS Interface Test Requirements which included the data mapping and assignment of default values using Word
• Developed prototype screens for the OPUS Thin-Client,for intranet use with Paintbrush

Confidential, Troy, MI

Financial Data Analyst

Responsibilities:

• Performed system test on Confidential Integrated Management Efficiency System (CHIMES)
• Ran SQL Plus Load Scripts to ETL data from an Excel Spreadsheet
• Wrote and executed PL SQL scripts to update and maintain customer Oracle databases utilizing SQL Navigator
• Tracked data by viewing both tables and data views to identify other tables and/or views that needed to be updated in order to maintain data integrity
• Performed data and database analysis on customer databases
• Designed, Developed, Maintained and Updated websites for profit and not-for-profit organizations utilizing MS/FrontPage
• Developed PDF files using Adobe Acrobat

Confidential, Dayton, OH

Help Desk Analyst (Support Position)

Responsibilities:

• Assisted users in identifying computer and/or system problems
• Insured HIPAA Data security requirements
• Reset passwords, Reconnected PCs and system printers, Loaded software, Mapped Applications
• Installed printers, network cards, keyboards, monitors, etc.

Confidential, Dayton, OH

Systems Analyst

Responsibilities:

• Performed analysis on the CourtView Oracle RDBMS using SQL Plus to extract the data
• Developed, published and maintained the website utilizing FrontPage and Adobe Acrobat
• Sealed court records

Confidential, Fairborn, OH

Senior Systems Analyst

Responsibilities:

• Designed and developed a Microsoft Access database, with imbedded Visual Basic commands that utilized ETL from an Excel spreadsheet for reporting
• Performed business case analysis for the US Environmental Protection Agency (EPA) on its Performance Based Burden Reduction (PBBR) program, and developed a web site, using Microsoft FrontPage, to publish the results
• Tracked PBBR project expenses using Excel

Confidential, Alexandria, VA

Principal Business Process Reengineering Specialist/On-Site Coordinator

Responsibilities:

• Maintained the Confidential CARES/SPA Oracle database
• Loaded test data to the Oracle RDBMS using Oracle SQL Plus, and Oracle SQL Loader
• Validated and resolved Software Problem Reports (SPRs)
• Assisted with the development of a preferred database maintenance/management plan to elevate customer and user perceptions
• Created a data migration plan to transfer control of CARES/SPA to the NAVY as required by JLSC
• Developed and presented the Database Transfer Plan Schedule using Microsoft Project
• Wrote and executed UNIX Control Scripts to maintain the database
• Maintained the Database Design Description (DBDD), its appendixes and other deliverables
• Was instrumental in improving the Tech Support Rating taking it from “Poor” to “Excellent”
• Worked closely with the Admiral that was over the Navy Material Command, Mechanicsburg, PA
• Received a BONUS for saving this project and having it extended 9-months

Confidential, Dayton, OH

Sr. Software Engineer

Responsibilities:

• Performed functional analysis on the Confidential
• Performed requirements gathering, business analysis and developed the "As-Is" and "To-Be" Business Process Models using IDEF and BPWIN
• Performed data analysis and developed a data model using IDEF methodology & ERWIN

Confidential, Dayton, OH

Sr. Information Engineer / Conversion Team Lead

Responsibilities:

• Assigned to the DoD Provisioning and Cataloging Technical Support System (PCTSS)
• Managed the team that successfully converted the U.S. Army CCSS VSAM data to an Oracle RDBMS
• Conducted RAD & JAD sessions with subject matter expert (SMEs), managers and others
• Mapped/Modeled data and was responsible for changes to the LDM
• Provided functional and technical expertise to team members, SMEs, Senior Management and others
• Assistant Development Team Leader on one of two Provisioning Development Teams
• Performed requirement analysis utilizing compliance and documentation to support the Business Area Analysis (BAA), and Data Standardization
• Developed Business Process Models and Data Model using IEF/Composer and IDEF Methodology
• Gathered business functional requirements and meta-data
• Coordinated and presented functional analysis and design
• Reviewed technical documentation for correctness
• Had final approval of all recommended changes to the Provisioning database tables
• Assisted with Data Standardization and Data Cleansing
• Prepared system documentation for the purposes of improving software development processes in accordance with accepted industry standards, and DoD, Air Force, Army, Marine Corp and Navy Regulations
• Provided technical advice to team members, SMEs, Senior Management, DoD Representatives, and others
• Interfaced regularly with Admirals and Generals

Confidential, Fairborn, OH

Programmer Analyst

Responsibilities:

• Assigned to Air Force Stock Control and Distribution System (D035J) and Marine Corp Stock Control Supply Systems
• Performed modular testing and updated test procedures
• Analyzed, maintained and wrote COBOL II /CICS and IDEAL applications, and JCL
• Prepared system documentation for the purposes of improving software development processes in accordance with accepted industry standards, and DoD, Air Force, and Marine Corp Regulations
• Analyzed existing functionality to determine ways to make the systems more user friendly and made such recommendations
• Coordinated with customer/functional representatives and other technical personnel on recommended enhancements
• Supported the life cycle management of the systems

Confidential, Dayton, OH

Principal Computer Systems Analyst

Responsibilities:

• Designed and developed an online application to track the architecture and infrastructure information for all of the Material Management Directorate’s computer systems, for the Joint Logistics System Center (JLSC)
• Gathered system information on over 30 computer system for Defense Enterprise Information System projects which required daily communication with Admirals and Generals
• Developed the Entity Relationship Diagram (ERD) using VISIO and a Data Dictionary using WORD
• Designed & Developed an Oracle RDBMS using Oracle, Oracle Forms & SQL Plus

Confidential, Dayton, OH

Programmer Analyst

Responsibilities:

• Assigned to the Air Force Requirements DataBank/D200 Project
• Analyzed, maintained and wrote COBOL/CICS and IDEAL applications and JCL
• Performed modular testing and updated Test Cases

Confidential, Fairborn, OH

Computer Systems Analyst

Responsibilities:

• Assigned to the Air Force Initial Provisioning Management Information System (IPMIS) to convert the existing Provisioning/D220 VSAM data to RDBMS and create a more robust and user friendly system
• Worked with SMEs to gathered system and business requirements
• Prepared system documentation for purposes of improving software development processes in accordance with acceptable industry standards, and DoD and Air Force Regulations
• Performed detail-design analysis, data and functional analysis, and data mapping and modeling
• Wrote Data Conversion programs to migrate data from U.S. Air Force D220 VSAM IDMS to the new DataCom RDBMS
• Wrote Batch and Online applications for reports and data loads using Meta-COBOLS and IDEAL
• Performed modular and integration testing
• Used Visio to develop Business, Data and Programming Flow Charts
• Assisted in the design of workflow from user-group to user-group and from user-to-user
• Provided technical advice to team members, Senior Management and Air Force Management
• Supported system life cycle management