Data Analyst

MARILYN COLE

****.*******.*@*****.*** LinkedIn: www.linkedin.com/in/marilyn-m-cole 302-***-****

EXECUTIVE PROFILE

Driven Data Analyst with 10+ years experience optimizing operations through advanced analytics and data visualization. Skilled in transforming complex data into actionable insights, communicating findings, and leading teams to achieve strategic objectives.

EXPERIENCE

Jan 22 - Sep 24: Senior Principal Operations SME and Software Integration Lead, Office of the Under Secretary of Defense for Intelligence and Security

• Responsible for maintaining and expanding the Partner Engagement Common Operating Picture (PE COP), for use by the Defense Intelligence Enterprise Partner Engagement community to coordinate and deconflict on senior level foreign partner intelligence engagements. This also served as the partner engagements metric repository for the National Defense Strategy Implementation, Strategic Management Plan, and OUSD(I&S) Annual Report.

• Required to produce both permanent and ad-hoc data analysis and visualizations for and on behalf of the Undersecretary and the Partner Engagements office.

• Driving force behind Partner Engagement inputs to the Security Senior Leadership Council. Analyzed over 1K inputs to create graphics, metrics, and talking points in coordination with OUSD(I&S) country desk officers and Data Analysis team. The Under Secretary of Defense for Intelligence and Security briefed the data to the directors of NGA, NSA, DIA, and NRO, shaping the next year of intelligence partner engagement strategy.

• Learned VBA to create a more efficient method to track Key Leader Engagements (KLE) on the highest network, giving Combat Service Agencies (CSAs) the ability to securely input OUSD(I&S) reporting requirements with the same ease as funded software. Adjusted required inputs to be more in line with strategic metrics tracking.

• Excel Wizard - data cleaned over 4,000 inputs for secure and accurate system upload and analysis to set a baseline; then, data cleaned and uploaded roughly 100 inputs monthly, making an automatically updating spreadsheet to determine progress compared with previous years and current goals.

• Learned Tableau and PowerBI to authenticate software upgrade accuracy, accomplished bi-monthly.

• Developed the software training program to include tactics, techniques, and procedures (TTPs), Standard Operating Procedures (SOP), Data Entry Business Rules, training pipeline, schedule, and over 15 mini-tutorial products for continuation of learning at multiple classification levels.

Nov 21 - Oct 22: Masters Student, American Military University, Data Collection and Analysis

Sep 20 - Nov 21: Senior Intelligence Officer, Incirlik AB, Turkey

• Oversaw Installation Commander Briefing team for one year, delivering fused intelligence with actionable threat prevention recommendations, which led to the prevention of at least four installation attacks and the successful arrest of at least 7 ISIS members by Turkish National Police.

• Recognized shortfalls in reporting Unarmed Aerial System sightings; directed 8-member cross-functional team to streamline process, reduced the national reporting timeline by 2 hours, 30% above the international average.

Dec 19 - Sep 20: Chief, ISR Asset Management, USAFE-AFAFRICA, Ramstein AB, DE

• Chaired 40-member cross-functional team to develop long term sensor acquisition strategy, increasing collection capabilities 300% against near peer adversaries and saving the Intelligence Directorate $13 million.

• Lead intelligence analyst for permanent aircraft squadron movements; aided in senior level decision making for European theater intelligence collection strategy; reallocated over four thousand collection hours to more efficiently collect against near peer adversaries; awarded the Air Force Commendation Medal.

Sep 19 - Dec 19: Intelligence Chief, Combined Joint Operations Center-Akcakale, Turkey

• Provided key daily intelligence updates to US embassy staff, which shaped the US Ambassador to Turkey’s communications with Turkish military and US SECDEF, Congress, and POTUS during combat in Syria.

• Developed multi-source intelligence reports under fire which assisted the rescue of self and 32-member team by coordinating with complex military and government organizations, awarded Officer of the Quarter.

• Personally tasked by the highest-ranking Air Force General in Europe to determine flight and ground safety in a combat zone under fire; analysis directly drove the final decision to allow air rescue of over 1.1K US and coalition troops.

• Established open line of communication with troops in contact to share real-time intelligence gathered from tactical and satellite imagery fused with multi-source data, ensuring safe transfer of US and coalition soldiers and sensitive equipment out of a combat zone in Syria to a safe zone in Iraq.

Feb 17 - Sep 19: OIC AFAFRICA and USAFE Targeting, 603d Air Operations Center, Ramstein AB, Germany

• Led 6-member team in advanced target development and intelligence maintenance for over two thousand targets in Europe and Africa, which enabled execution of two military plans.

• Developed new North Atlantic Treaty Organization (NATO) targeting protocol for a time sensitive tracking program that reduced time from target acquisition to prosecution by 75%.

• Led 30-member operational planning team in US Air Forces in Europe’s largest exercise; strategized the most efficient pattern of targets to destroy near peer defenses and directed tactical planning team for target prosecution, which aided in training 28 partner nation countries and $36 million exercise success.

Feb 16-Feb 17: Deputy OIC AFAFRICA Analysis, 603d Air Operations Center, Ramstein AB, Germany

• Developed and briefed daily intelligence updates to General Officer staff on topics throughout Europe, Africa, and Syria for one year, which aided in tactical decision making for air operations.

• Hand-picked by General staff to determine and brief threats to aircraft for highly sensitive missions which led to first-time US and coalition aircraft access to areas in Western Africa and enabled the recovery of four US soldiers fallen in battle.

EDUCATION

• Master of Arts in Data Collection and Analysis from American Military University, October 2022, GPA: 3.92

• Bachelor of Science in Biology from United States Air Force Academy, CO, 2014, GPA: 3.29

• Distinguished Graduate, Intelligence Technical Training

• Honor Graduate, Air Operations Center Training

• Squadron Officer School, in Residence, 2020

• Intelligence, Surveillance, and Reconnaissance Master Level Training, 2020

ADDITIONAL SKILLS

• Information Gathering, Critical Thinking, and Predictive Analysis

• Professional Writing: White papers, Presentations

• Briefing and Public Speaking

• Process Development, Mapping, and Improvement

• General, Office and Financial Management

• Physical and Information Security

• Data Cleaning

• Advanced Excel, Word, and PowerPoint

• Advanced Tableau and Power BI

• Intermediate VBA, SQL, Python

Contact this candidate