Al Roark Email & Phone Number

Portland, Oregon Metropolitan Area

Created the BRDCreated Test ScriptsCreated Screen mockups for the new EV Charging PilotWorked with both the Business and Development to gather requirements to create the BRD and project time line.

Beaverton, Oregon, United States

• Senior Data / Business System Analyst (Contract) ServerLogic
• Create BRD, Data flow documents, validating data, and gather requirements.
• SQL to Update views
• Gap analysis of data from new and old views
• Teradata, Snowflake, Confluence, Excel, Jira, SQL, Agile, SDLCThe contract ended due to COVID 19 budget impacts.

Portland, Oregon, United States

• Senior Data / Business System Analyst (Contract) Digital Intelligence Systems, LLC (DISYS)
• Create BRD, Data flow documents, validating data, and pulling requirements from code.
• Pulled test cases from Code and Files
• Pulled test data using SQL and looking at incoming files.
• Gap analysis of data from new and old systems
• Confluence, Excel, Jira, SQL, Toad, Waterfall, SDLC

Portland, Oregon, United States

• Senior Implementations Business Analyst
• Work with Clients and development to gather requirements for new system enhancements.
• Work with Clients to determine what configuration settings will be needed
• Implementations Gap analysis of new ERP software that was cloud based with both mobile and web-based requirements.
• Data analysis of client’s data using TOAD & SQL Server
• Technical SME, client consultation regarding solutions

Beaverton, Oregon, United States

• Xerox / Cognizant, Sr. Business Analyst
• Developed functional and technical requirements for the Nevada Health care system.
• Participated in the design of new reports for both internal and external use.
• Participated in the design of new web pages
• System tested the new application and all new reports.
• Confluence, Excel, Jira, SQL Agile, SDLC

Colorado Springs / Denver / London

• Sr. Systems Business Analyst /Developer
• Developed functional and technical requirements during (WorldPay) JAD sessions in London.
• Performed research and analysis to create Functional Specifications for the development team. The process included use cases, application flows, detailed business, and functional requirements.
• Defined business rules for merchant processing, and provided technical support for the test team.
• Confluence, Excel, SQL, JCL, Agile, Waterfall, SDLC

Broomfield, Colorado, United States

• Developed Functional Specifications for the UI development team.
• Designed new web pages, reports, and all SQL for merchant processing.
• Environment: VISIO, Snagit, SharePoint
• Confluence, Excel, Jira, SQL, Waterfall, SDLC

Denver, Colorado, United States

• Created succinct and testable requirements and developed use cases for ERP systems.
• Reviewed use cases /stories with on-shore and off-shore development teams, testers, and the business groups to ensure that all requirements were included and correctly interpreted.
• All software was cloud-based with both mobile and web requirements.
• Jira, Excel, SQL, Agile, Waterfall, SDLC

Colorado Springs, Colorado, United States

• Performed analysis and developed multiple projects for data center applications and disaster recovery, a new point of sale (POS) system, and enhanced numerous telecommunication systems.
• Participated in JAD sessions to determine system and business requirements for use case scenarios and testing scenarios. Interacted with technical leaders from interfacing applications
• Designed web UI that fed an Oracle DB; and interfaced with a COBOL DB2 backend. This approach enabled the client to perform real-time product and pricing updates.
• Developed applications design from initial business requirements, JAD results, document analysis, GAP analyses, and data warehousing.
• Developed LDRPS (Living Disaster Recovery Planning System) through JAD sessions and weekly meetings with all of the technical leads from participating groups in the data center. Representatives included the Network.
• Created pseudo-code for offshore developers, and performed requirement/code reviews. Environment: COBOL II, Java, JavaScript, HTML, VISIO, UML, SCRUM, SOX, LDRPS, Snagit, SharePoint

Denver, Colorado, United States

• Participated in a four-year, large-scale conversion of 401K system; mainframe legacy system to OMNI Plus. The conversion impacted 15,000 educational institutions as they formatted and transmitted files for the new OMNI.
• Conducted business analysis of requirement reviews and researched client data to ensure current modules could process the new data format.
• Confluence, Excel, Jira, SQL, DB2, Cobol, Waterfall, SDLC

Colorado Springs, Colorado, United States

• Provided analysis and production support for daily outages.
• Managed outage resolution and communication of high severity/high exposure and mission critical outages.
• Provided problem resolution and coordinated efforts to ensure adequate resources were applied to resolve critical issues in a timely manner.
• Prepared notifications and reports of daily outages and communicated status to all levels of management.
• Environment: Mainframe and Midrange, COBOL, JCL, DB2, VISIO, ISO 9000, UNIX

• Merged billing and OE systems from three companies to create a single system that supports all billing for local, long distance and cellular services.Elicited business requirements from the following: end users.
• Created data flows and use cases which included all modules and functions for the combined system.
• Functional scenarios incorporated the current data from all converting systems. The approach included detailed data flows and design documents and testing time frames and assignments.
• Environment: Mainframe and Midrange, COBOL, JCL, DB2, VISIO, SOX, JAVA, HTML, ISO 9000

• Provided support and analysis for application install issues for all Oracle modules.
• Supported Oracle Applications ERP software installation/configuration via phone/remote access.
• Customer base included client/server and web-based implementations in UNIX, Windows, and mixed platform environments.
• Utilized expertise to create and troubleshoot Alerts and Flex Fields
• Functioned two years as technical team lead in the Application Object Library group.
• Traveled to customer sites to resolve ongoing and severity/high exposure issues.

• Led a development team for 18-months to create the British Telcom (BT) Spares Inventory System, which involved a full inventory lifecycle, accounting links and purchase orders. BT experienced a £96 million savings.
• Worked from initial business request, multiple interfacing applications, technical leads and support from JAD sessions. Researched requirements of each department utilizing the new system.
• Prioritized the needs of each department into “wants” and “needs”. Developed detailed design documents for the first release, which included only the requirements required for the release.
• Environment: Mainframe and Midrange, COBOL, JCL, DB2. ADABAS

Come College, Management Information Systems, General

Come College, Management Information Systems, General