Ted Stauffer ac7c7i@r.postjobfree.com

**** ****** ***** • Arlington, Texas 76016 • cell - 817-***-**** •

Sr. IT Business Analyst / Liaison; Application Systems Leader

~ BUSINESS PROCESS IMPROVEMENT ~ IT TRANSFORMATION DESIGN ~ PROJECT LEADERSHIP ~

IT Business Analyst / IT Services Leader. Overseeing IT design from initiation thru delivery (SDLC), using Agile methodology, seeking to provide results of value. Expertise in business process diagramming/modeling, consolidated documentation, requirements specification, program design, vendor/legacy interfaces, and implementation. Proven ability to clarify business requirements, convert them to technical and functional specifications (TDD / FDD), perform risk and fit / gap analysis, and design process re-engineering, transition, integration, and system improvements to increase productivity and reduce costs. Adept at diplomatically facilitating discussions with stakeholders; organize and plan delivery with internal and external vendors, offshore QA’s, and SME’s. Expertise in application build and app code (M/F, COBOL, JAVA, IIB, CDC, IMS, UNIX) and testing for stakeholders via delivery as SaaS (software-as-a-service).

Demonstrated skill at verbal and written articulation; delivery of critical projects and data migrations on-time and within budget.

• IT Strategy • Data Analysis and Data Mining • ERP Expertise • Gap Analysis • Technical Requirements / Specifications • Airline Domain • Problem-Solving • OO Software Analysis and Design •

Career Achievements

Translated functional requirements into use cases and process models, and refined user stories from raw requirements. Facilitated discussions between development end-user teams and business stakeholders during the creation of User Stories/EPICS/Features. Led vendors to maintain integrity throughout the implementation process.

Served as senior Business Analyst for IT support, providing the highest level of customer service to HRIS, Airline Domain, Finance, Quality / Risk / Change Control, Marketing, and Loan applications.

Prepared and delivered presentations to all corporate levels ensuring desired results by reviewing project activities, metrics, workload management, dashboard of accomplishments, and milestones. Led ongoing training.

Gathered, redefined, flowcharted, and documented databases, data warehouses, and business requirements to emulate IT infrastructure. Tasks included mapped files and leading Business analyst in integrating and migrating data from external vendors to internal DBMS.

High impact solutions using Joint Application Development (JAD) sessions/meetings with stakeholders.

Communications - Provided enhancement release notes and user training for new features and functions. Assisted customers with techniques for problem resolution, assuring quality of analysis and decision-making, based on initial user stories, and refined with constant updates & change control throughout release (sprints) and Scrum planning cycles.

Created custom technical documentation, including job flow and data diagrams, program flowcharts, ERD’s, scheduling, planning, monitoring, and table/program documentation, as well as data security logic narration.

Professional Experience

Sr. Business Analyst/Project Coordinator – Isthmus Inc., Bedford, TX - for ACCC Insurance Co. 5/2018 – present

Conduct IT project leadership and service management for auto insurance policy and claims software. BI and analysis of SQL Server databases including SSRS and Azure. Scheduled and tracked change management and releases using Remedy Force in Sharepoint.

Create functional documentation, BRD, SSD, system specification document, and technical flowcharts and illustrations for system enhancements and new logic using MS Office, VISIO, WORD, and MS utilities.

Proficient in Microsoft Visio; used SQL Server Management Studio (SSMS) to define relational databases and perform BI analysis.

Confirm and display as flowcharts all insurance sales and claims processes and logic. Analyze legacy reports and processes for remediation and transformation following the ITIL Service delivery areas; created statistical and pictorial representations throughout the SDLC process. Use Microsoft TFS for requirement and task tracking, as well as project timelines and dashboards.

Confirmed testing and UAT results using queries, data extraction, and database interrogation.

Sr. Business Analyst – DXC for United Airlines 4/2017 – 3/2018

Senior BA consultant for WMS/MRO integration and conversion of legacy airline MRO/Supply chain and sourcing system, SCEPTRE WMS, to web-based HighJump (similar to Oracle) WMS/TMS (warehouse management and transportation management) vendor software databases and data architecture. Team member of BA’s and application experts creating requirements design analysis, and documentation for syncing both systems via data modeling, orchestration, and replication, using IIB (IBM Integration Bus) and data analysis and explicit data mapping. Identified correlated business and functional processes to assigned correct process identifier number. Worked in scheduling, data profiling and development, and UAT (use case) testing.

Senior analyst responsible for design and transformation of business workflows and processes for airline parts and supply orders. Convert business requirements to automated processes. Document and revise current IBM mainframe parts inventory/procurement software and process to sync with new SQL server business flow, including tracking of vendor performance and flexibility.

Aircraft MOR systems interfaced and coordinated included Inbound and Outbound Orders, kitting, item master, vendor master, M&E kit build, parts transfer, pick order, unpick order, borrows, return to stock, and parts control.

Created requirements documents, program change specifications, SQL Server table mapping, and work flow orchestrations.

Collaborated with customer SME’S, experts, offshore (India) designers and testers, and onshore IBM specialists to determine risks and impacts to existing processes. Created use cases from detailed work flow diagrams. Proven ability to succeed in trouble-shooting and to explain complex ideas to technical and non-technical audiences.

Completed deliverables for Work Product Review and enhancement of artifacts; e.g., pictorial representation of process flow, IMS segment and copybook layouts, articulation of use cases, input and output data, tracking using TFS, and XML schemas for IIB methods.

Created SWIMLANE / activity diagrams and flowcharts utilizing Rational Uniform Modeling (RUP), UML, and Visio.

Selected Accomplishments

Created 16 design / orchestrations for IIB (IBM Integration Bus) developers. Included WSDL and schema documents.

Assisted in supplying test data and tracking of test updates for offshore test team using Intertest and IMS screen images.

Sr. Business Analyst / Requirements Specialist – Allstate, Irving, TX 11/2015 – 1/2017

Ask questions on the documentation to the property and casualty group SME’s & receive answers back to complete the conversion

Detail-oriented, organized functional documentation and technical flowcharts and illustrations using MS Office, VISIO, etc.

Proficient in Microsoft Visio; use Excel for complex charts and calculations. Consolidate references and conversions for EDI transition from vers. 3040 to vers. 4010 for transaction sets 810, 811, 850, 997, etc., for insurance data transmission to lenders

Confirm and display as flowcharts all mainframe JCL and systems. Analyze legacy reports and processes for remediation and transformation following the ITIL Service delivery areas; created statistical & pictorial representations throughout the SDLC process.

Conduct extensive surveys and searches of SharePoint and web resources to include complete system details and interfaces as part of extensive system-wide documentation and user manuals; served as liaison between IT and non-IT resources.

Led solutions development for business initiatives and improved system performance to achieve reduced processing costs of 20% and job automation for positions previously performed by 8-12 temporary employees.

Record and run UNIX scripts to confirm accuracy; tracked data movement via FTP, XML, SQL, and generated emails

Merge documents into a single deliverable for each lender/insurance system and populate into company SharePoint

Sr. Project Manager and Business Analyst - American Airlines, Ft. Worth, TX 3/2013 – 9/2014

Fleet/Crew/Passenger Specialist

Monitors and reports to IT management on the status of project efforts for onboard and cabin/crew flight operations, ground operations, & customer (PAX) support systems (including ACARS messages, E.G., OOOI - gate out, wheels off, wheels on, gate in and FMC air-to-ground messages and 2- & 3-letter abbreviations, SABRE DECS (daily monitoring of pilot flight reports), crew scheduling, crew panel display of departure / flight messages (including triggers; e.g., door close), real-time weather updates, electronic flight bag, automated announcements, status reporting, resource and quality tracking, migration from one vendor to another vendor, delivery and flight/crew schedule, reservations, IT change management, financial planning/forecasting reviews) adhering to Agile development methodology and lean Agile project development, via daily team and status meetings.

Provides supervision, guidance, and AGILE SDLC mentoring while leading IT process change and project planning for a WIFI / on-board server mobile technology / touch screen project; & aggressively analyzes risk and issues of a 2 phase, 8 release 3RD party vendor infotainment software project; recommends escalation or mitigation efforts as appropriate.

Monitors and validates data flow for online and (touch screen device) credit card purchases to assure accuracy of the payment processing, and assures credit card transaction PCI-compliance according to PCI-DSS standards.

Collaborates with quality analysts, vendor development, and other team leads to approve progress of issue resolution.

Gathered requirements, developed test cases, and coordinated with vendor on enhancements to integrated custom software.

Attends frequent meetings & conference calls to provide data & guidance toward meeting business analysis deliverables & timelines with the vendors, including Panasonic and Thales. Provides test schedules & checklists for participants in UAT.

Conducts software design concepts with UI experience documents and business requirements as a senior business analyst and supports upgrade validation at various installation sites. Used organizational skills to provide test schedules and checklists for other testers. Utilizes MS Project and Rally extensively for schedule and forecast.

Selected Accomplishments

* Created passenger personalization feature based on PNR ticket (reservation) using Sabre system, hospitality, reservation

history (native Sabre), loyalty, and cross-airline data according to IATA standards. Provided program logic to assure ticketing

workflow and inquiry at airport sites/kiosks was available, as well as network and wirelessly.

Veteran’s Administration (VACO), Austin, Texas. 5/2012 – 2/2013

Business Analyst and RQA/Agile Consultant

Specialist for HR/benefits/payroll/retirement applications. Gather/elicit requirements and business logic to create detailed design document for the healthcare and benefits developers’ technical solution. Maintain, evaluate, and improve custom code for mainframe processes with ultimate integration and migration to mobile/digital devices in mind, assuring that the implemented business logic is accurate for IT software. Reviewed and maintained pay classifications and legislative/union payroll and SOX compliance.

In my role as RQA (requirements analyst), I provide version/source control (TFS), reporting, requirements management, project management, automated builds, testing, and release management capabilities. I created job flow diagrams, program flowcharts, file structures, I/O, custom user reports, and table logic narration. Conducted product owner usage surveys and translated feedback into functional requirements. Analytical reasoning to break down requirements into features and user stories.

Analyzed and mapped business processes (current state/future state; “as-is / to-be”); logic gap analysis and data verification.

Accomplished massive data conversion for the accurate integration into the new reporting system, following governance guidelines.

Facilitated discussions between development teams (JAD), UAT, and business stakeholders about security and web-app conversions.

Authored detailed deployment plans & schedules. Took lead role in project analysis & project tracking using MS Project and Rally.

Selected Accomplishments

Created and gathered functional requirements, use cases, and user stories from raw requirements. Facilitated discussions between development teams and business stakeholders during the data conversion, secure transfer, and requirements change process.

RFID Program SOLUTIONS ANALYST 1/2011 – 5/2012 Lockheed-Martin Aerospace Ft. Worth, Tx.

One of a select group of technical leads assigned to large complex engagements designing software architectures, verifying software design, and improving business processes for integration of supply chain for aircraft manufacturing IT systems with government and corporate mandated systems. Responsible for requirements control and software process tracking. Coordinate projects based on performance, cost, and schedule with least interference to each other or production.

Primarily include RFID, EDI, SQL, and MRP data structures. Created RFID tags to be included in EDI 856 ASN transaction set.

Specialized in financial segments of procurement, shipping, invoicing, inventory, and tracking using RFID, programmatically creating RFID codes for WIP tracking and asset management, using extensive IT experience in aerospace and manufacturing industry.

Coordinated and developed efficient operational processing controls (BPMN) and functional enhancements to improve Business Intelligence (BI) extract of correlating and subset data for more efficient data analysis.

Assisting with the business case; High-level feasibility studies; Eliciting and Gathering of the requirements

Leadership in MPP project plan from beginning to end. Keeping the project plan within scope while adjusting cost estimates.

Successfully tracked and verified projects according to company and federal specifications. Assured that improvements were made to the existing manufacturing ERP system.

Venture Encoding. Ft Worth, TX. service bureau specializing in mortgage, document print and management

Lead Business Systems Analyst and Project Lead; Internal Systems 10/2008 – 8/2010

Develop technical and functional specifications and convert requirements into IT logic and architecture for mortgage-related documents and forms. Conducted change and risk management along PMO guidelines within budgetary responsibility.

Supervise implementations via inclusive test data, integration testing, business analysis, and results diagrams.

Serve as liaison between administrative and business units and design, development, and maintenance teams conducting mainframe and web-based system security changes according to administrative principles.

Prepare reports for PMO management and stakeholders regarding status of projects, cost and time estimates.

Excellent oral, written, & interpersonal communication skills throughout full SDLC, mostly Agile (including SCRUM), following PMBOK methodologies, to present technical information in a way that establishes and gains understanding at all levels of management.

Selected Accomplishments

Constructed MS project plans and design concepts thru unambiguous scope definition and development, requirements updating, testing, and implementation; detailed integrated program / business process work flow diagrams and context diagrams.

Met and interfaced with customers, stakeholders and management to design high impact solutions using Joint Application Development (JAD) sessions and requirements gathering.

Manage documents; e.g., correspondence & property tax forms, for client data alteration & internal reuse or use by other clients.

Worked with several internal groups & external clients to gather & design requirements using MS Office Suite, VISIO, and EXCEL.

Sr. BA AAFES (Retail merchandising applications) Dallas, Tx. 5/2003 – 6/2008

Coordinates and develops more efficient operational processing controls, functional enhancements and custom mainframe COBOL/DB2 development following CMM-I (Level 2/ 3) guidelines.

Focus on merchandising and retail supply chain (Retek WMS) in an Oracle RDMS.

Experience and familiarity with Retail back-office applications including Merchandising, Financial, POS, Procurement, Consumer Product Replenishment, Invoicing, warehouse inventory management (WMS), Marketing, and Cross-Dock Warehousing, increasing on-time delivery/receiving/loading and reducing inventory.

Mainframe development analyst / Project Manager devising continuous business process improvement through management of business requirements, facilitation, presentation, POC (Proof of Concept), and workflow.

Created swimlane / activity diagrams and flowcharts utilizing Rational Uniform Modeling (RUP), UML, and Visio.

Used several mainframe tools and software, including COBOL, IMS DB/DC, Telon, DB2, SQL, and JCL.

Oversee and implement diverse service orders in retail and EDI mainframe environment.

Confirmed testing results and verify files and database changes for GTIN, RFID, and barcodes (UCC Universal Product Codes).

EDI transaction set mapping to DB2 databases and files.

Use of MS Project, ACCESS, VB, and EXCEL (pivot tables, V-lookup).

Supervised and implemented diverse service orders in retail and financial mainframe environment.

Constructed MPP project plans and detailed program flows. Use of Business Objects and BPM (business process mgt.).

Created Agile SDLC for custom development and Project Management following CMM-I (Level 2 / 3) guidelines.

Analysis and presentation of processes toward suggested OOAD and reuse or consolidation of programs and modules.

Applications Development Manager; Senior Business Analyst 9/1996 - 5/2003

Sabre Group / American Airlines. Fort Worth, TX

Successfully provided technical /functional leadership, budgetary accountability, project management and overall program change management of critical systems for American Airlines system integrations, mergers / acquisitions / integrations, new development, enhancement projects, and 24-hour production support for HRMS / HRIS, human resources, health and welfare benefits, payroll processing, and insurance administration; on-site coordination with offshore staff.

Flight - Support of SPAN, Specialized Pro-rated Aircraft Net Revenue Management, system written in Mainframe COBOL / DB2 for support of aircraft revenue and flight planning by type; i.e., cargo, passenger, etc. Reviewed IATA cargo billing Cargo Accounting Settlement System and Simplified Interline Settlement (SIS) invoicing. Consolidated invoices sent out automatically via ACH. Analysis included use and analysis of Sabre reservation system data to review Passenger Reservations (PNR-passenger name records) for statistical analysis, revenue projection, and testing data. Other parameters included flight staff scheduling (pilots/flight attendants), ground and maintenance costs, ticketing, and gate expenses. Created and gathered requirements, online screens, batch jobs, and system documents. Maintained and developed many SQL queries and updates.

Managed and effectively tracked multiple concurrent projects with annual budgets in excess of 15,000 hours ($2 million). Accurately estimated project sizes, developed detailed MS project plans, determined resource staffing requirements and managed project progress. Utilized a central point of contact and logging system for requests and acted as liaison between development team and client.

HRIS - Additions and revisions made to a browser-based web-enabled Employee Self-Service system using HTML, XML, Mainframe interface, JAVA, and Javascript in ASP pages.

Supervised and directed activities of technical resources, clearly establishing strategy for projects, defining objectives and gathering requirements for software enhancements, integration projects, systems interfaces, vendor interfaces, troubleshooting issues, and support.

Technical Skills

Project Management: AGILE (Scrum) Project Management • System Development Life Cycle (SDLC) • PMBOK • Capability Maturity Model (CMM) • Information Driven Project Mgmt (IDPM) • Design Structure Matrix (DSM) • RRID (rapid release iterative development)

Operating Systems: z/OS 390 / MVS/XA • JES2/JES3 • VM • UNIX • Windows 7, 8, 10 O/S • SQL Server

Languages: COBOL LE / II • SQL • CICS • C • Assembler • PL/SQL • DL/1 • Easytrieve • JAVA • Javascript • XML • Visual Basic

OS JCL• Syncsort • Fileaid • ChangeMan • Data Dictionary

Software: JAVA • Javascript • DB2 • QMF • Oracle • IMS DB/DC • VSAM • TSO / ISPF • ISPF Dialog • Tesseract • SAP • HTML • XML • SAS • Rally • JIRA • SAS • IIB • Intertest • RDz • Web Services • HP ALM 11.5 (Quality Center)

MS Office: Excel • Word • Access • PowerPoint • Visio • Project • Sharepoint

EDUCATION & CREDENTIALS

Project Management Professional, CertTest SAP Certificate in ABAP, SAP/HR, Dallas, Tx.

N.A.T.T.S, Advanced Certificate in Computer Science Drexel University

Bachelor of IT Administration, Management Millersville University

Additional Coursework:

Information Systems Management, UNIX and shell scripts University of Texas at ArlingtonCertificates in

Managing Information Technology Projects and Technical Writing The Sabre Group, Ft. Worth, Tx.

CISSP / SixSigma training CertTest, Dallas, Tx.

Contact this candidate