CAREER SUMMARY

Mr. O'Bryan has over 20-years of IT Experience, with 15-plus years as a Business Analyst Data Analyst. He has taken the development process from requirements gathering through the development and implementation of the Logical Data Modeling. He has served as both a Team and a Project Lead, as well as, mentored others. He has worked with Admirals, Generals, CEO, Corporate Presidents, Subject Matter Experts, and those doing the data entry. Thus, Mr. O'Bryan has had many successes which have awarded him promotions, pay raises, bonuses and contract extensions. Mr. O'Bryan's ability to access situations and to work with others independently are some of his strongest characteristics. Mr. O'Bryan, also, has experience utilizing program modules and Business Object Models BOMs needed to support Enterprise Resource Planning ERP .

Achievements:

• Successfully mediated court assigned cases
• Provided advice on a hardware purchase that saved over 25 million
• Redesigned an on-site development strategy which reduced development time and cost
• Received a bonus for saving a contract and having it extended 9 months
• Taught a Leadership program for 6 years
• Wrote the proposal that won a contract worth 10 million

COMPUTER 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 .Net VSAM

Documentation:

• BPMs Coding Standards Data Dictionaries Data Maps Entity Relationship Diagrams ERDs
• Logical Data Models LDMs Maintenance Manuals Software Unit Specifications User Manuals
• Functional Design Descriptions FDDs Service-oriented Architecture SOA Physical Models
• Functional Descriptions

Financal:

• OPUS Mercury Quality Center AppQuest Project Reporting System PRS Beeline Test Director
• Enterprise Request System ERS ServiceWare Architect Empower E MISMO Back-In-The-Black
• Latitude Billing Tree

Federal Government:

• Air Force Systems: Provisioning D220, DO33 DO35K , Stock Control and Distribution DO35J , Requirements DataBank D200 , DO43, ABOM, NIMMS, DIFMS
• 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, DOD 7935a, PTD, WRM, DII/COE, DOD 1800, and many other Government and Military Regulations and systems
• Other: EPA PBBR, CMIS, DIFMS, PTS

Languages:

• Assembler Basic 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:

IDEF0 IDEF1X IDEF4 Dr. James Martin Dr. Joe Vasta Dr. E.F. Codd Theory of Constraints SDLC

Microsoft:

• Access Active Directory Excel Outlook Outlook Express PowerPoint Project
• Visio Windows 93 / 95 / 98 / 2000 / ME / XP / 2007 Word

Operating Systems:

DOS MVS/ESA MVS/XA OS/2 UNIX Windows AS400

Other:

• Adobe Acrobat CHIMES an ERP Crystal Reports Data Query Data Reporter Easytrieve ETL
• Expeditor HIPAA ISPF Lotus 1-2-3 Oracle Forms 4 Roscoe SQL Navigator 4.4 TCP/IP
• Tivoli Problem Reporting Tivoli Remote Access TSO Word Perfect Lotus Notes Snag-It
• 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 uses AGILE Oovoo Print.Net

PROFESSIONAL EXPERIENCE:

Confidential

Lead Business Analyst

• Assigned to Axcess Financial
• Gather and document functional requirements to resolve problem tickets
• Track the requirements via JIRA, which utilizes AGILE
• Communicate daily with the engineers in Lima, Peru

Confidential

Senior IT Specialist

• Assigned to the DFAS, Indianapolis to support their work with Air Force Materials Data on ABOM/NIMMS
• Served as the Senior Specialist
• Developed Training Material and trained new team members
• 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
• Analyzed data requirements for the enhancement of two automated bill of material systems
• 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
• Assembled project of functional users
• 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
• Oversaw project teams of subordinate financial systems specialists to accomplish large scale reviews, system changes, testing, and implementation
• 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 alternative approaches to the design of current or proposed systems
• 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 Specifications, 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
• Performed staff assignments related to IT project planning, monitoring, and in coordination with system life cycle functions
• 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.
• Served as the Edit-Inc Employee Representative at DFAS-Indianapolis

Confidential

Independent Contractor / Consultant

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

Business Analyst Specialist

• 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

Business Analyst

• 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

Data Analyst

• 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

Project Manager

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

Confidential

Business Analyst Data Migration

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

Financial Data Analyst

• Performed system test on Computer Horizons 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

Web Site Developer

• Designed, Developed, Maintained and Updated websites for profit and not-for-profit organizations utilizing MS/FrontPage
• Developed PDF files using Adobe Acrobat

Confidential

Help Desk Analyst Support Position

• 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

Systems Analyst

• 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

Senior Systems Analyst

• 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

• Principal Business Process Reengineering Specialist/On-Site Coordinator
• 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

Sr. Software Engineer

• 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

Sr. Information Engineer / Conversion Team Lead

• Assisted with Data Standardization and Data Cleansing
• Had final approval of all recommended changes to the Provisioning database tables
• Reviewed technical documentation for correctness
• Coordinated and presented functional analysis and design
• Gathered business functional requirements and meta-data
• Developed Business Process Models and Data Model using IEF/Composer and IDEF Methodology
• Performed requirement analysis utilizing compliance and reference documentation to support the Business Area Analysis BAA , and Data Standardization
• Assistant Development Team Leader on one of two Provisioning Development Teams
• Provided functional and technical expertise to team members, SMEs, Senior Management and others
• Mapped/Modeled data and was responsible for changes to the LDM
• Conducted RAD JAD sessions with subject matter expert SMEs , managers and others
• Managed the team that successfully converted the U.S. Army CCSS VSAM data to an Oracle RDBMS
• Assigned to the DoD Provisioning and Cataloging Technical Support System PCTSS
• 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

Programmer Analyst

• Analyzed, maintained and wrote COBOL II /CICS and IDEAL applications, and JCL
• Performed modular testing and updated test procedures
• Assigned to Air Force Stock Control and Distribution System D035J and Marine Corp Stock Control Supply Systems
• 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

Principal Computer Systems Analyst

• 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

Programmer Analyst

• 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

Computer Systems Analyst

• Prepared system documentation for purposes of improving software development processes in accordance with acceptable industry standards, and DoD and Air Force Regulations
• 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
• 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