Senior Database Analyst, supporting the Department of Defense (DoD) Logistics Database and Acquisitions Center (LDAC) Army Enterprise System for functional applications such as Pipeline Army Logistics Intelligence File (LIF), Electronic Data Interchange (EDI), and the Logistics Modernization Reporting (LMR). Provide advanced analytic support to Army Enterprise Portal users, modifying/enhancing existing Army Enterprise Portal reports and capabilities to accommodate changing Army demands and requirements, and developing new business intelligence (BI) reports and capabilities in support of the Army logistics community. Maintain close working relationships with Army logistics managers worldwide and seek out new business opportunities. Function as liaison between government functional and contracting developers, to recommend modifications to existing reports and capabilities within the Army Enterprise Portal to meet ever changing demands for cost effective and time-saving solutions to new problems thru continuous improvement of existing capabilities. Assist the Integrated Processing Team (IPT) and other stakeholders and team members with the integration of maintenance data into other ILAP business areas, programs, and applications. Assist customers with complex Standard Query Language (SQL) queries for integrating and analyzing data from LMP and GCSS-Army not otherwise available thru canned LIW or Army Enterprise Portal reports. Extract, compile, and validate data to generate reports, reinforcing and maintaining compliance government standards. Work with managing leadership to prioritize business and information requirements. Query and report key metrics and actionable insights utilizing Excel, SQL skills and other business intelligence software to leadership team. Experience with AESIP, GCSS-Army, LIW Applications (Forward Pipeline, LMR, Parts Tracker, CAESAR), and OSMIS.

Senior ERP Business Analyst, supporting the Department of Defense (DoD) Logistics Support Activity Center (LOGSA) Logistics Information Warehouse (LIW) functional applications such as Pipeline and EDI. Extracted, compiled, and validated data to generate reports, reinforced and maintained compliance with government standards, and worked with managing leadership to prioritize business and information requirements. Developed and maintained operational metrics and reporting, created and maintained metric definitions and worked internally and cross-functionally to ensure consistent use of metrics. Queried and reported key metrics and actionable insights utilizing Excel, SQL skills and other business intelligence software to leadership team. Compiled and validated data; reinforced and maintained compliance government standards. Evaluated business and design requirements for implementation of schema updates for various qualifiers for Pipeline transactions. Provided testing data and generated documents to identify testing results and recommendation for various ERPs, as needed. Analyzed testing guidance documents on how functional and usability tests should be performed.

Researched actual data requirements from Army doctrine, regulatory documentation, and field manuals for In-Theater Supply Chain Support. Work with software developers to debug simulation as needed to successfully pass component and integration tests. Participate in software design reviews, code reviews. Updated documentation of data warehouses and data marts designed and developed by database analyst. Research fuel and equipment repair requirements for major ground weapon systems in support of Strategic Planner application. Developed solutions that solidified estimated failure rates of key components of ground weapon systems within any given estimated field mission. Utilized specific sample data collections to simulate the probability of which critical items of a specific ground system would be likely to fail and how often it is likely over a certain amount of time. Work with project manager and team to ensure that the requirements are implemented properly to provide the customer with a satisfactory and accurate solution to their desired need. Validate queries for system performance analysis. Working with project manager and data analyst on validation of queries for building of data warehouse and data marts to ensure they are in compliance with the current standards. Designed and developed Tableau dashboards utilizing the business warehouse data for various Business processes. Followed the Spiral software development process, as well as, adhered to various government standards to manage software testing procedures during the entire lifecycle. Continuously assisted with integration and analysis of the larger System of Systems option(s) for the three ground sorts threads. Calculated Mean Time Between Failures (MTBF), Mean Down Time (MDT), Mean Up Time (MUT), Total Logistics Response Time- Maintenance (TLRT-M), Turn Around Time (TAT) utilizing sample data collections for specified ground systems and critical items.

Evaluated business and design requirements for implementation, in support of the Department of Defense (DoD) Logistics Support Activity Center (LOGSA) provisioning and analysis tool, PowerLOG-J, and Systems Planning and Requirements Software (SYSPARS), a tri-service expert system that assists Program Managers and Integrated Logistics Support Managers in preparation of integrated logistics support. Analyzed testing guidance document on how functional and usability tests should be performed. Followed the Agile software development process, as well as, adhered to the government standards--GIEA 0007 and MIL-STD-1388-2B-- to manage PowerLOG-J and SYSPARS software testing procedures during the entire lifecycle. Utilized the Department of Defense Architecture Framework (DoDAF) to develop the artifacts needed to show capabilities, forecast the tools maturation and develop a data dictionary that enables the stakeholders to have a common understanding of the terms used regarding their tool. Analyzed and revised Logistics Automation Division’s (LAD) business testing process and presented the testing reconfiguration to the customer. Manually validated requirements, at the acceptance level, by developing test plans and test reports. Met with the developers daily to resolve software issues related to the latest build. Performed and documented the business analysis process for the LAD requirements procedures. Generated documents to identify testing results and recommendations, managing the testing schedule using Microsoft project. Worked with government lead to solidify official release date of next version of the tool.

Analyzed testing guidance document on how functional and usability tests should be performed, in support of the Department of Defense (DoD) Logistics Support Activity Center (LOGSA) provisioning and analysis tool, PowerLOG-J, and Systems Planning and Requirements Software (SYSPARS) in preparation of integrated logistics support. Adhered to the Agile software development process, as well as, followed to the government standards--GIEA 0007 and MIL-STD-1388-2B-- to manage PowerLOG-J and SYSPARS software testing procedures during the entire lifecycle. Utilized the Department of Defense Architecture Framework (DoDAF) to develop the artifacts needed to show capabilities, forecast the tools maturation and develop a data dictionary that enables the stakeholders to have a common understanding of the terms used regarding their tool. Analyzed and revised Logistics Automation Division’s (LAD) business testing process and presented the testing reconfiguration to the customer. Manually validated requirements, at the acceptance level, by developing test plans and test reports. Evaluated business and design requirements for implementation. Met with the developers daily to resolve software issues related to the latest build. Performed and documented the business analysis process for the LAD requirements procedures. Generated documents to identify testing results and recommendations, managing the testing schedule using Microsoft project. Worked with government lead to solidify official release date of next version of the tool.

Program coded, tested, debugged, implemented, and performed maintenance, in support of the Department of Defense (DoD) Logistics Support Activity Center (LOGSA), for COMPASS 7, a computer model designed to assist in conducting a Level of Repair Analysis (LORA) study, using C#, HTML, and XML and for CASA using C++, HTML, and XML. Modified html structure behind applications help file, which describes COMPASS 7’s capabilities, usage, and dependencies. Developed software design document (SDD) that specified design of COMPASS 7 application and of CASA from start-to-finish following the steps specified in the Software Lifecycle. Analyzed and evaluated existing CASA environment and identify areas of concerns to increase CASA’s cost efficiency by reviewing SOW against XML validation structure with sets boundaries on data entered into the CASA application. Maintained CASA project schedule to ensure that all task worked and completed are accurate and in correspondence with each completion dates and requirements. Performed modification for non-mandatory elements within CASA xml schema to allow missing data elements and recommended technical design, standards and process improvements, where applicable. Performed unit test of xml schema modification and complete coding of CASA xml data validator and modules to facilitate the implementation of the new CASA xml structure. Analyzed and evaluated procurement policies associated with the acquisition process pertaining to development of an Automated Database Exchange System (ADES). Developed software development plan (SDP) that specifies design of the ADES from start-to-finish following the steps specified in the Software Lifecycle.

Developed and implemented code for web applications. Program designed, coded, tested, debugged, implemented, and performed maintenance for Mission Execution Report (MER) using C#, SQL, and HTML. Worked in team environment to build, test, document and support customer web solutions. Analyzed customer’s requirements for the implementation of GUI layout for the SpaceX and Von Braun Center (VBC) website. Program designed, coded, tested, debugged, implemented, and performed maintenance of the public review site for SpaceX Falcon Program FA and Phase III for the VBC site using C# and HTML. Coordinated with client representatives on technical issues. Performed quality assurance to ensure application will produce the desired results. Maintained and included new capabilities in KAYA’s existing intranet site. Managed the application’s system lifecycle; Recommend technical design, standards and process improvements, where applicable.