Robbie Smith, Cbap, Csm, Sp, Spmpo Email & Phone Number

Placentia, Ca, Us

United States

Irvine

• Elicited and validated requirements for web-based System Performance Reporting Tool (SPR)• Led multiple SPR deployments, reducing report preparation time by 50 - 60% and allowing access to reports via the web• Planned three testing environments for SPR; two inside firewall and one using Terremark cloud solution• Created test cases, performed SPR User Acceptance Testing (UAT) and evaluated results.• Identified, analyzed and tracked SPR software defects and resolutions.• Liaison to SPR offshore vendor to clarify requirements, coordinate deployments and obtain statuses• Analyzed SPR export files and airline incident data for inconsistencies and anomalies.• Created IFE System Performance reports using VBA, Excel, Access and Crystal Reports.• Created user documentation and processing guide using Visio, Word and Excel.• Provided SPR training, demonstrations and production support.• Served as Scrum Master/Product Owner for Cipher Manager vendor on SKS Agile Release train.• Created user stories, dashboards and Kanban board in JIRA for Cipher Manager.

United States

- Analyzed airline data files in various formats and mapped columns to SPR format- Defined required cleansing and created Excel (VBA) macros to sanitize data.- Developed ACA Trend reports and automation using Excel (VBA), Access (VBA) and Crystal Reports.- Created monthly customer reports for ACA and BAW using Excel, Crystal Reports and SPR.

• Developed, implemented and maintained Membership, Conference and Accounting databases for clients dramatically reducing registration and follow-up time. • Elicited requirements and delivered MS Access database solutions for various small business and church clients.• Created Access queries, modules, forms and reports using VBA. • Developed and maintained Frontpage web sites

•Gathered requirements for trouble ticket (SPAM) system.•Developed SPAM database, screens and reports utilizing VB6, Crystal Reports 7 and Access.•Created documentation, conducted end-user training, implemented and maintained SPAM.•Analyzed, resolved and documented issues related to files on FTRS System.•Developed SQL scripts to fix claim adjustments, recoveries, and extract Encounter data.•Processed claim status changes and generated Claim Count Reports daily and weekly.•Created Claim Processing documentation and trained offshore development staff.

•Analyzed existing Visual Auction’s account and report modules for improvements.•Developed account enhancements, Interface to QuickBooks, multi-invoice payment/ credit processing.•Utilized ColdFusion, HTML, Access and SQL to implement enhancements. •Provided technical support and maintained project tracking using MS Project 2000.

•Analyzed COBOL reports for conversion to Crystal Reports using new UNIFI Loan Origination Client Server system.•Gathered report requirements and generated specifications.•Developed and implemented reports using Access and Crystal Reports 6.0.•Created Progress 4GL programs to extract data from UNIFI for Excel and Access database.•Utilized MS SQL 6.5 to extract data from Onyx database and import into Access.•Created and maintained Access tables, queries and VBA modules.•Maintained Visual Basic 4 & 5 programs to support branch printing of Crystal Reports.•Developed and Maintained programs for Loan Servicing, Escrow, Inventory and Accounting on the HP3000.

El Monte, California

•Led HP 3000 to IBM 4381 conversion of the Cost Ledger to WDS Contract and Cost Accounting •Assisted with the HP to IBM conversion of Labor/Payroll, Work Orders, Work Centers and Routers.•Implemented Data Collection Bar Code System enhancements utilizing DELTA One software. •Provided DELTA One contractors with requirements and assistance.•Performed all phases of program development using COBOL, VSAM, IMAGE, Speedware and FOCUS.•Interfaced with all levels of management to obtain system requirements and to perform training

B.A., Economics

Testing, Verification And Validation, Requirements Management

Economics

Sql Query Writing