David L Collier Email & Phone Number

United States

Remote

• Performed business analytics and reporting utilizing/accessing My Travel and MIS System Archives in a PMO enterprise system. Develop/maintain all contract related documentation. Develop/update functional requirements, release notes, and user manuals for applications. Provide backlog input. Interface with Government, partners, and external stakeholders on a regular basis. Facilitate communication and coordinates meetings with Governmental and Business parties. Foster working relationships with all stakeholders.

San Antonio, Texas Metropolitan Area

Chenega Healthcare Services LLC (San Antonio, Texas) SR. Communications and Technology Specialist/Data Engineer (Contract)Performed business analytics and reporting utilizing/accessing the Naval Sexual Assault Prevention and Response (SAPR)Office.Developed a fully functional Dashboard in Excel using big data, pivot tables, slicers, and advanced VBA. Built a Sexual Assault Forensic Examination (SAFE) MS Access Database from inception to deployment tables, queries, inner and outer joins using a primary key an associated foreign keys. Used MS Access 365 forms as an Intake frontend process tool. Also, created a switchboard navigation to bring all forms and reports together.

San Antonio, Texas Area

Credit Risk Test Coordinator - (Credit Risk GPM/SAM) (Contract) USAAIdentified and contributed to process evolution to develop and assist with the implementation of continual service improvement cycles across all operational processes. Worked on problems of diverse magnitude where analysis of data requires evaluation as well as verification of identifiable factors. Worked on collaborative efforts gathering requirements and monitoring all testing in the perspective of the Credit Risk components. Used several different requirements gathering techniques used PowerPoint and charts to show measures of completeness. Developed software testing methodologies and tools while working with Bank marketing Subject Area Mart (SAM) domain. Exposed to VMWare Service Manager Systems application, Primary point of contact for a large regulatory Banking project known as (SAM). Ability to influence and built relationships with LOB stakeholders, enterprise leadership, external service providers and architecture teams. Understood and interpreted enterprise requirements and determined their impact to this Banking Systems applications. Used Software Development Life-Cycle Methodologies that include the following: JIRA and Rational Unified process, IBM Rational Team Concert - Agile Methodology and Object-Oriented Analysis and Design. Gathered Critical Data Elements for the Credit Risk team which includes: Credit Card Performance and Origination, Mortgage Performance and Origination, Demand Deposit Accounts Losses (Charge-offs and Recovery). Designed Credit Risk Test Planning Schedules, Critical Data Elements and created an issue tracking log.

San Antonio, Texas Area

Responsibilities for managing application project systems and Business requirement specifications (SRS) from the initial Kick-off phase to the post-sign-off implementation phase for several vendors. Developed reports for Tech Skills on Wheels, Nissi Corporate Training Solutions, WellMed, and The Inspiration Center. Worked with MS Azure cloud SaaS application.Responsibilities also included gathering business requirements and building programming specs for the creation of the applications and Crystal Enterprise v XI. Conducted JAD sessions, end-user requirements workshops, and interviewing techniques. Worked with several Schools in the SAISD creating a platform for encouraging college readiness in the area STEM (Science, Technology, Engineering, and Math) curriculum. Technologies: MS Office Suite, MS Azure SaaS, ITIL, Portfolio Accounting, Agile, Strong PowerPoint presentation and Excel, MS Visio, SQL, BI/BW, ORACLE 9i, Business Objects, Crystal Enterprise XI, MS Project, MS Office, Access, and automatic reports scheduling.

San Antonio, Texas Area

Identified and contributed to process evolution to develop and assist with the implementation of continual service improvement cycles across all operational processes. Worked with both IBM Tableau and ServiceNow Designs ITSM workflows as directed, created efficiencies and delivery standards for all IT Service Management third party members. Worked on problems of diverse magnitude where analysis of data requires evaluation as well as verification of identifiable factors.Worked with JIRA, WebSphere, Unix, Windows Server, Desktop OS internals or Mainframe domains. Exposed MS Azure Cloud Software as a server application (SaaS). IBM EMM(Unica) product. Administered the IBM infrastructure, design, and development of the marketing pre-select, credit card and car buying services for a USAA Banking system.The areas covered are Outbound campaigns, inbound campaigns, marketing operations, contact optimization. Created Use Case narratives (UML) or User Stories (Agile Methodology) Used several different requirements gathering techniques. Developed software testing methodologies and tools while working with Bank marketing domain. Exposed to VMWare Service Manager Systems application, API Object-Oriented approach, and Salesforce system applications. Acted as the Auto Lending Systems representative and primary point of contact for a large regulatory Banking project. Ability to influence and built relationships with LOB stakeholders, enterprise leadership, external service providers and architecture teams. Understood and interpreted enterprise requirements and determined their impact on these Banking Systems applications. Used Software Development Life-Cycle Methodologies that include the following: Rational Unified Process, Agile Methodology, and Object-Oriented Analysis and Design. Exposed to IBM DB2 Analytics Accelerator.

San Antonio, Tx

Adeptly facilitated meetings that captured campaign requirementsProvided recommendations to assist with the infrastructure, design, and development of the targeted marketing requested.Defined business requirements in a structured large-scale corporate environment. Worked with and created, analyzed, and published ITSM metrics. Managed and made recommendations to ITSM Service Catalog, Asset, and Configuration Management and tracking systems.Worked with both IBM Tableau and ServiceNow Illustrated process flows using a swim-line technique to project teams and help design AT&T Marketing Infrastructure solutions.Used digital channel and managed products capabilities and used several storage tools. Created permissions, roles, and Software tokens, Security certificates, RSA SecurID, Biometrics, Two-stage authentication using Identity/Access Management application systems. Worked with several Network Services including VPN, Wi-Fi, Ethernet connectivity.Worked closely with Cloud Application Services, Back-up Storage with a recovery component.Created use cases and test scenarios as needed to communicate the approach and validated the solution.Developed functional specifications and system design specifications in conjunction with marketing, legal and other consultative roles. Assisted in timeline/schedule enforcement, testing strategies, and issue tracking.Technologies: IBM Unica 8.2. ITIL IBM Infrastructure, Business Requirement/Systems requirements, Information Security, VMWare Service Manager Systems application. Microsoft Office Suite 2010, MS Word, Excel (PowerPivot) MS Access DB, MS OneNote, Salesforce system applications, MS Outlook 2010, Q messaging tool, Amdocs, Share Point, Visio, Snag-it, Oracle DB (approval application), SAS, T-SQL, SSRS, Teradata QCQA Packages, and marketing Scheduler for upcoming campaigns. Generated Reports and Lists.

Remote

See full description by request,

Usaa San Antonio Tx

See full description by request,

Arlington, Texas

See full description by request,

Arlington, Texas Remote Assignment

See full description by request,

See full description by request,

Business Analyst in support of developing reports for Grand Prairie and Fort Worth ISDs and other third party Educational Institutions.

See full description by request,

the area of supply chain management systems. Responsibilities included Updating stored procedures, triggers and DTS as well as business and IT analysis. Technologies:SQL Server 2005, ETL, Business Objects, SSRS, DTS, Triggers, Stored Procedures, UNIX Scripting (Korn), DB2, UDB, Brio, Cognos, Crystal, MS Project

As a Business Systems Analyst supported and developed reports for Total Transportations Transportation Management systems(TMS). Responsibilities including gathering business requirements and building programming specs for the creation of the applications and reports. Technologies:LoadTech Transportation Management System, Airline application, SQL, SQL Server, Crystal Enterprise/ Business Objects, MS Project, Citrix, ETL, Stored Procedures, Triggers and ATMs.

Brought in on a short term contract to perform modifications for a major retail system utilizing COBOL, CICS and VSAM programming.TECHNOLOGIES: COBOL II, CICS, VSAM, DB2, JCL, FILE-AID, ROSCOE, TSO/ISPF AND IBM ZOS.

Extensive documentation in the area of business requirements and system functional Specifications including BRD, FRD and FSD.Created test cases and test scripts used MS Visio for data mapping.Technologies: Crystal Enterprise XI, ETL/ Business Objects, COBOL II, DB2, File Manager, VISIO, TSO/ISPF, VSAM, CICS and Xpediter.

Managed tasks and resources on several consulting projects for Mansfield ISD using MS Project. Specifically brought in for the business analysis, development, testing, and implementation of an online STUDY ISLAND project.

Developing detailed specifications for use in ATM and Debit card Programming. Market Research, Feasibility Studies, Data Analyses, System Analyses, Gap Analyses, and Risks Analyses.Technologies: MS Project, ETL/ Business Objects, Xepediter, Test Director, Win Runner, Cobol, DB2, Crystal Reports, and JCL

Extensive documentation of business requirements and system functional Specifications includes: BRD, FRD, and FSDSoftware used to manage these processes included: MS Project, PMO, MS Word, MS Excel and Crystal Reports. Built a plan, tracked and managed the re-engineering of the Revenue subsystem project using MS Project and finished the project ahead of schedule. Used Data Management to oversee the regulation of revenue subsystems processesTechnologies: MS Project, MS Visio, Test Director, cycle test scripts, COBOL, JCL, DB2, ETL, EDI, CICS

Technologies: Oracle, PL/SQL, Online test scripts, Windows, Crystal Reports, AS/400, Visual Basic, Cognos

Performed enhancements, implementations, and maintenance using EmPower, Underwriter Expert System, and Visual Rater System. These productive tools were utilized to add functionality and flexibility to the Policy and Claims Administration, Windows/Property and Casualty, Gupta/Centura and the ValueRate Policy Administration systems.Developed and maintained client applications using Visual Basic 6.0, RDBMS, Oracle/SQL 7.3.4 and Crystal Reports.Technologies: 3-tier client/server architecture, front-end using Visual Basic 6.0, middle tier using the Business Rules from INSpire, and the back-end using RDBMS, ETL, Oracle 7.3.4, MS Access 97/SQL Server 6X) utilizing API Object-Oriented approach, Windows NT. Exposed to Java 2.1 and Lotus Notes 4.5 for STAR tracking problem

Managed tasks and resources on several consulting projects using MS Project.

Bachelor Of Business Administration - Bba, Information Technology

B.B.A, Accounting/Information Systems

Education record