Willis Simmons
Information Technology Application Analyst at Metropolitan Development and Housing Agency- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Metropolitan Development and Housing Agency
-
United States
-
Government Administration
-
1 - 100 Employee
-
Information Technology Application Analyst
-
Jan 2022 - Present
Nashville, Tennessee, United States
-
-
-
InCadence Strategic Solutions
-
Defense and Space Manufacturing
-
1 - 100 Employee
-
Database Analyst
-
Jul 2019 - Aug 2022
• Preformed performance tuning, database backup and recovery, maintenance of database replication, planning and support for database and software releases and updates, analysis of the impact of updates, data upkeep and validation. • Wrote and executed iSQL scripts to facilitate input and output of data, wrote and executed queries on the database. • Used SAP SQL Anywhere, a relational database management system (RDBMS) to manage and analyze information in a relational… Show more • Preformed performance tuning, database backup and recovery, maintenance of database replication, planning and support for database and software releases and updates, analysis of the impact of updates, data upkeep and validation. • Wrote and executed iSQL scripts to facilitate input and output of data, wrote and executed queries on the database. • Used SAP SQL Anywhere, a relational database management system (RDBMS) to manage and analyze information in a relational database. • Checked system requirement to ensure processor, ram and disk space met the specs for new installation new application upgrade. • Reviewed release notes, installation instruction and implementation instruction for new application upgrades. • Uninstalled / installed programs on server and client machines. • Used remote setting via PowerShell and command prompt to access other network computer to preform system upgrades and install software and preformed basic systems administration. • Used port 443 for secure connection, also use IPsec to encrypt packets of data. • Used transmission control protocol on database port 2638 to ensure our servers establish a connection and exchanged streams of data. Also, used port 2439 for database sync. • Setup and managed database user profiles and acted as a liaison with users while monitoring the active directory. • Setup, troubleshoot and connected network computers, printers and PDA’s. • Submitted required firewall modification per military cyber security protocol to ensure the integrity of the military network. • Created windows services to run and used task scheduler to automatically execute tasks. • Created VBA macros to automatically format data in Microsoft excel. Show less
-
-
-
-
Database Analyst
-
Nov 2018 - Aug 2022
• Used SAP SQL Anywhere a relational database management system (RDBMS) to manage and analyze information in a relational database. • Preformed performance tuning, database backup and recovery, maintenance of database replication, planning and support for database and software releases. • Updates, analysis of the impact of updates, data upkeep and validation, writing and execution of scripts to facilitate input and output of data, writing and execution of queries on the database and… Show more • Used SAP SQL Anywhere a relational database management system (RDBMS) to manage and analyze information in a relational database. • Preformed performance tuning, database backup and recovery, maintenance of database replication, planning and support for database and software releases. • Updates, analysis of the impact of updates, data upkeep and validation, writing and execution of scripts to facilitate input and output of data, writing and execution of queries on the database and server maintenance. • Setup and managed database user profiles and acted as a liaison with users while monitoring the active directory. • Used remote setting via PowerShell and CMD to access other network computer to preform system upgrades and install software and preformed systems administration. • Setup, troubleshoot and connected network computers, printers and PDA’s. • Follow military cyber security protocol to ensure the integrity of the military network. Show less
-
-
-
-
LMP Data Analyst
-
Aug 2017 - Nov 2018
Afghanistan • Used the user interface of AWRDS, a relational database to maintain and updated records. Performed SQL, data quality, data integrity, data accuracy and data entry as a Data Analyst in Afghanistan and Kuwait on a U.S Army support contract. • Created and executed advanced SQL statements to extract or update data from the relational database and; connected results by using Microsoft query wizard and open database connectivity (ODBC). • Linked multiply tables to retrieve vital information… Show more • Used the user interface of AWRDS, a relational database to maintain and updated records. Performed SQL, data quality, data integrity, data accuracy and data entry as a Data Analyst in Afghanistan and Kuwait on a U.S Army support contract. • Created and executed advanced SQL statements to extract or update data from the relational database and; connected results by using Microsoft query wizard and open database connectivity (ODBC). • Linked multiply tables to retrieve vital information for military briefing and presented the finding. • Created VBA macros to automate tasks within excel so that I can work more efficiently and with fewer errors. • Used the material management side of LMP, a SAP based product to manage Army Material Command (AMC) equipment in Afghanistan. • Provided assessment of the accuracy, validity of gathered data, along with configuring PDA to providing visibility of military asset. • Supported the US military by providing detailed research, reports, organize data, logistic and supply operations. • Gathered and monitor logistic data to identify trends requiring analysis and corrective action. • Validated and shipped all retrograde equipment leaving Kandahar Airfield, Afg, tracked/monitored and provided asset visibility until item arrived to CONUS Depot along with addresses problematic components, complied logistical metrics data. • Analyze data between AWRDS DB and LMP DB to ensure the accuracy of the data. • Set up mobile network via VSAT (very small aperture terminal) while traveling in Afg to ensure the synchronizing of AWRDS data between local DB and master consolidated DB, along with checking replication status. • Analyzed logistics issues that affect acquisition/sustainment decisions and performed risk/benefits analysis of proposed recommendation and action. • Analyzed electronic data interchange (EDI) to locate potential errors between LMP and AWRDS DB and preformed corrective actions when needed. Show less
-
-
-
Community Health Systems
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
Data Analyst
-
Jun 2017 - Aug 2017
Greater Nashville Area, TN • Created data and provided data maintenance to over 146 hospitals in 21 states as one of the largest hospital chains in the U.S as an analyst on the master data management team. • Communicated with venders to find the best price on a variety of medical supplies. • Conducted data cleanup and updated the Lawson database to provide the most up to date data for the supporting hospitals. • Created SQL statements in Oracle to check supply and reorder medical supplies before stock was… Show more • Created data and provided data maintenance to over 146 hospitals in 21 states as one of the largest hospital chains in the U.S as an analyst on the master data management team. • Communicated with venders to find the best price on a variety of medical supplies. • Conducted data cleanup and updated the Lawson database to provide the most up to date data for the supporting hospitals. • Created SQL statements in Oracle to check supply and reorder medical supplies before stock was depleted. • Communicated with a variety of department within CHS to ensure the flow of data correct. • Conducted research with a variety of health care sites to confirm prices, supplies and unit of measure. Show less
-
-
-
-
Senior Data Analyst
-
May 2013 - Apr 2017
Kuwait/Afghanistan
-
-
-
CGI
-
Canada
-
IT Services and IT Consulting
-
700 & Above Employee
-
Senior Data Analyst
-
May 2013 - Apr 2017
Kuwait/Afghanistan • Maintain and updated records in a relational database, AWRDS (Army War Reserve Deployment System) by performing SQL, data quality, data integrity, data accuracy and data entry as a Data Analyst in Afghanistan and Kuwait on the Army prepositioned stock contract. • Created and executed advanced SQL statements to extract or update data from the relational database and; connected results by using Microsoft query wizard and open database connectivity (ODBC). • Linked multiply tables to… Show more • Maintain and updated records in a relational database, AWRDS (Army War Reserve Deployment System) by performing SQL, data quality, data integrity, data accuracy and data entry as a Data Analyst in Afghanistan and Kuwait on the Army prepositioned stock contract. • Created and executed advanced SQL statements to extract or update data from the relational database and; connected results by using Microsoft query wizard and open database connectivity (ODBC). • Linked multiply tables to retrieve vital information for military briefing and presented the finding. • Provided assessment of the accuracy, validity of gathered data, along with configuring PDA to providing visibility of military asset. • Supported the US military by providing detailed research, reports, organize data, logistic and supply operations. • Gathered and monitor logistic data to identify trends requiring analysis and corrective action. • Validated and shipped all retrograde equipment leaving Kandahar Airfield, Afg, tracked/monitored and provided asset visibility until item arrived to CONUS Depot along with addresses problematic components, complied logistical metrics data. • Prioritize work by equipment requirements and validated DA form 1348 to determine the AWRDS and LIW Logistics process. • Set up mobile network via VSAT (very small aperture terminal) while traveling in Afg to ensure the synchronizing of AWRDS data between local DB and master consolidated DB in VA, along with checking replication status. • Review DA 1348, DA 3161 and 2404 for accuracy along with ensuring PBUSE reflected correct information. • Analyzed logistics issues that affect acquisition/sustainment decisions and performed risk/benefits analysis of proposed recommendation and action. • Operated and managed the Logistic Modernization Program (LMP) ensuring the system information is reflected in the Army War Reserve Deployment System (AWRDS). Show less
-
-
-
Sikorsky
-
United States
-
Aviation and Aerospace Component Manufacturing
-
700 & Above Employee
-
Warehouse Technician
-
Sep 2015 - Nov 2015
Fort Campbell, KY
-
-
-
-
Supply/Inventory Specialist
-
Aug 2012 - Mar 2013
Kabul, Afghanistan • Independently developed and established new storage system that improved workflow productivity and reduced retrieval times. • Conducted 100% monthly inventory on all equipment classified as sensitive items. • Uses Integrated Booking System, Container Management Module (IBS-CMM) to control containers as Container Control Officer (CCO) of container management. • Traveled to other FOB’s to oversee and ensure the delivery of materials to end user. • Assisted in logistics strategic… Show more • Independently developed and established new storage system that improved workflow productivity and reduced retrieval times. • Conducted 100% monthly inventory on all equipment classified as sensitive items. • Uses Integrated Booking System, Container Management Module (IBS-CMM) to control containers as Container Control Officer (CCO) of container management. • Traveled to other FOB’s to oversee and ensure the delivery of materials to end user. • Assisted in logistics strategic planning and distribution plans. • Issued, received, shipped and provide accountability of supplies and equipment to partner nations. Show less
-
-
-
-
Senior Warehouseman
-
Dec 2011 - Jul 2012
Kandahar, Afghanistan • Managed all warehouse nightshift operations and personnel, also provided leadership and work guidance to less experienced personnel; briefed dayshift on all nightshift • Trained warehouse personnel in warehouse functions and practices in the areas of loading, unloading, segregation, palletizing, selection of stock and storage areas. • Issued and maintain an accurate inventory of over 20,000 lines of stock; verified count against documents to ensure accuracy. • Issued bench stock… Show more • Managed all warehouse nightshift operations and personnel, also provided leadership and work guidance to less experienced personnel; briefed dayshift on all nightshift • Trained warehouse personnel in warehouse functions and practices in the areas of loading, unloading, segregation, palletizing, selection of stock and storage areas. • Issued and maintain an accurate inventory of over 20,000 lines of stock; verified count against documents to ensure accuracy. • Issued bench stock replenishment listings and initiated requisition action. • Ensures appropriate adjustment actions and documentation is processed for shipment and receiving discrepancies and lost, damage or destroyed action is initiated and properly submitted. • Mark and prepare labels for shipping using muti-pack boxes, wooden, skid and pallets with netting. Show less
-
-
-
-
Logistic Warehouse Forman
-
Dec 2009 - Nov 2011
Baghdad, Iraq • Managed and supervised 25 supply personnel as Class I Warehouse Foreman. • Provided training and motivation to warehouse employees to drive continuous improvement in the areas of safety, productivity, quality and cost control. • Issued, received, inventoried and maintained the whole bottle water supply for Sather Air Base; maintained all refrigeration vans/containers to Preventive Medicine and Veterinary standards. • Completed all tasks according to DCMA and QA/QC auditing… Show more • Managed and supervised 25 supply personnel as Class I Warehouse Foreman. • Provided training and motivation to warehouse employees to drive continuous improvement in the areas of safety, productivity, quality and cost control. • Issued, received, inventoried and maintained the whole bottle water supply for Sather Air Base; maintained all refrigeration vans/containers to Preventive Medicine and Veterinary standards. • Completed all tasks according to DCMA and QA/QC auditing standards; completed SitReps and provided daily reports of mission accomplishment to military client. • Attended Army Battalion bi-weekly meetings to discuss the progress of the mission and any other mission related issues. • Responsible for identifying, tagging, tracking, lateral transferring, receiving, issuing, and subsequent turn-in of all US Government Property (both government furnished and contract acquired). • Maintained 100% inventory accuracy of all Government Property items on Property Book. Show less
-
-
-
-
Demand Flow Specialist (Work Leader)
-
Jun 2006 - Mar 2009
Clarksville, Tennessee • Managed small to medium equipment projects lifecycle from conceptualization through completion. • Successfully tasked and supervised 9 personnel engaged in manufacturing HVAC units. • Conducted training and quality control inspections and arc/mig welded in the assembly process; also operated a robotic welding machine. • Performed inventory and quality control checks throughout a given process or operation. • Interfaced with maintenance to repair machines and with my superiors to… Show more • Managed small to medium equipment projects lifecycle from conceptualization through completion. • Successfully tasked and supervised 9 personnel engaged in manufacturing HVAC units. • Conducted training and quality control inspections and arc/mig welded in the assembly process; also operated a robotic welding machine. • Performed inventory and quality control checks throughout a given process or operation. • Interfaced with maintenance to repair machines and with my superiors to keep them informed as to production quotas. • Supervised team, providing training and work task guidance, ensuring they had adequate supplies to complete mission. • Provide guidance and direction to co-workers and labor staff while promoting excellence in work ethics and team motivation. Show less
-
-
Education
-
Austin Peay State University
Bachelor's Degree, Homeland Security -
AUSTIN PEAY STATE UNIVERSITY
Database Administration, Data Modeling/Warehousing and Database Administration -
Fort Campbell High School