William Ragatz Email & Phone Number

Arlington, Tn, Us

Leesburg, Va, Us

Falls Church, Virginia, Us

• Senior Data Modeler for US Navy efforts to modernize data systems and provide meaningful data marts in the Enterprise Authoritative Data Environment (eADE) for use within the Manpower Personnel Training and Education domain. Providing end users with Single Sources of Truth and Purpose Built Datamarts with in the Navy's 105 disparate human resources data systems to provide an equal basis of clean data for reporting needs. • Provided data visualization with Tableau and data flows with Tableau Prep as proof of concepts and initial builds for reports. Also provided continuous mentoring of users in the domain on Tableau and quarterly training sessions.• Built the MNCC CPPA Dashboard used to track sailor pay issues for MNCC and unit personnel in the fleet along with the input and formatting the data received to support this dashboard. Dashboard currently serve 7000 end users supporting all Active and Reserve Navy personnel.• Built PBDM to support Commander’s Risk Mitigation Dashboard to provide unit commanders with insights on destructive behaviors.• Produced PBDM for My Navy Foresight efforts to model US Navy personnel inventory to make predictions on retention and recruiting.• Produced internal PBDM to support GDIT ADE demonstrations utilizing our datalake, SSOT, PBDM and tools within the ADE domain to include insights on COVID, Education, Physical Fitness, Geographic Locations and Navy End Strength.

Alexandria, Va, Us

Provides knowledge and expertise in MPTE reporting systems to include NSIPS, Cognos, and CeTars as they pertain to the Supply Chain Operations of Naval Education and Training Command(NETC). Duties include data collection and formatting for the modelling of student and Recruit Division Commanders for the flow o students and instructors through the training pipeline. Tableau developer for the visualization of modeled data for the NAVAIR PMA-265 aircraft maintenance lifecycle program.

Provides knowledge and expertise in MPTE reporting systems to include NSIPS, Cognos, and CeTars as they pertain to the Supply Chain Operations of Naval Education and Training Command(NETC). Duties include data collection and formatting for the modelling of student and Recruit Division Commanders for the flow o students and instructors through the training pipeline. Tableau developer for the visualization of modeled data for the NAVAIR PMA-265 aircraft maintenance lifecycle program.

Provides knowledge and expertise in MPTE reporting systems to include NSIPS, Cognos, and CeTars as they pertain to the Supply Chain Operations of Naval Education and Training Command(NETC). Duties include data collection and formatting for the modelling of student and Recruit Division Commanders for the flow o students and instructors through the training pipeline. Tableau developer for the visualization of modeled data for the NAVAIR PMA-265 aircraft maintenance lifecycle program.

Memphis, Tennessee, Us

Responsible for collecting requirements and utilizing them to create new reports within the Commercial Credit Analytics in ACBS. Provides expertise in how to use Business Objects and it's uses. Also provide report creation in Cognos ALS application

Hook, Hampshire, Gb

• Continuously delivered quality support to a naval command’s supply chain operations in generating visualizations of supply chain metrics. Execute data visualizations by gathering requirements and determining optimal data sources; design layouts; and required data cleansing and formulas.• Consistently demonstrated expertise by developing data sets for use within various stages of the supply chain process and performing automation with Tableau, R Scripts, Macros, VBA and SQL coding. Performed data visualizations of a recruitment process (average of 30,000 students) for decision-making purposes.• Established an internal data lake supporting supply chain operations comprised of 1.5 million records.

Washington, Dc, Us

Provided oversight for data collection, analysis, and verification, including supporting data used to manage the entire Navy. Created complex IT tools for distribution to office peers, conducted data pulls from sophisticated Navy systems and generated detailed data reports. Provided software automation programming to assist in data collection and analysis. Continuously exhibited strong technical proficiency by utilizing Microsoft Office applications, Crystal Dashboards, and proprietary technical programs to execute processes. Earned recognition for successfully creating a Diversity Dashboard used to view inventories by their individual demographic compositions and provide specific demographic reports. Established a comprehensive database of Navy personnel assigned to global missions with data that optimized the generation of specific reports. Served as a sole contact for all diversity and inclusion data calls over 4 consecutive years, which included delivering extensive demographic information on up to 400,000 individuals.

Memphis, Tn, Us

Authorized funds for the repair and replacement of policy holders’ items in the home during the coverage period. Executed a Six Sigma project, which involved programming and automating a cash in lieu calculator for use proprietary software.

Washington, Dc, Us

Served in multiple capacities, including Helicopter Aircrewman; Search and Rescue (SAR) Swimmer; Small Arms Instructor; NATOPS Instructor; and Operations Leading Petty Officer.Implemented Microsoft Excel automation for the tracking of fiscal year squadron flight funds. Tested and established proprietary Navy Operational Risk Management (ORM) systems. Programmed in Palm Pilot OS to interface with ORM systems to update data used to calculate risk. Reduced manual data recording by an average of 30 minutes per flight crew.