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 U.S. Navy 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:

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

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

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

Confidential

Web Site Developer

Responsibilities:

• 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, OHJ

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 U.S. Navy 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 U.S. Army Depot MRP
• 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
• Wrote the response to an RFP which won the contract to support an interface between McDonnell Douglas and the U.S. Army CCSS supply chain data

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, Confidential 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 Confidential 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 Confidential 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