Andrea Pascale Email & Phone Number

Arlington, Va, Us

Arlington, Va, Us

Currently supporting the Office of the Deputy Assistant Secretary of the Army – Cost & Economics (DASA-CE) with re-architecting cloud storage and developing a web app for the Automated Cost Database (ACDB). This database is a source of cost, technical, and performance data for the following commodities: electronic communications & radars, aviation, missiles & ordnance, and ground vehicles.

Alexandria, Virginia, Us

• Cloud Computing, Systems Engineering, & IT Cost Optimization: Partnered with internal teams and clients to configure and modernize legacy data infrastructure that generated business insights and optimized cost. Solutions built included: -> Database Migration from Monolithic Architecture to Microservices: Led migration of an on-premise database to AWS Cloud using S3, Lambdas, Relational Database Service (RDS), and Database Migration Service (DMS). Set up and configured a virtual private cloud (VPC), an Elastic Compute Cloud (EC2) web server, and Identity & Access Management (IAM) roles. -> Big Data Processing & Storage: Re-architected storage of a national voter database from expensive Redshift clusters to an unlimited object file system on an S3 data lake. Partitioned and compressed data with Apache Hive. -> Automation & Network Security: Automated and scheduled tasks via EventBridge, a serverless event bus. Utilized AWS Systems Manager (SSM) and Key Management Service (KMS) to securely store sensitive data and manage encryption protocols across AWS services. -> Infrastructure-as-Code (IaC): Wrote and launched IaC templates in CloudFormation to provision secure networking environments and compute resources. ***• Advanced Analytics Products: Developed/automated a 12-page daily report template in R Markdown for a gubernatorial race. The product was scaled to track early voting trends in 10 additional Senate races.• Technical Documentation: Created and presented clear and concise technical documentation—such as process flow diagrams, user guides, data dictionaries, and standard operating procedures (SOPs)—that improved the client experience and reduced maintenance requests.• Agile Project Management: Introduced Jira for software issue tracking, streamlining task assignment and prioritization, minimizing production downtime, reducing backlogs, and expediting issue resolution time by over 30%.

Arlington, Virginia, Us

• Business Analytics, Strategic Consulting, and Client Services: Researched, analyzed, and reported on client data, sharing insights that supported business growth and operational efficiency. Consulting projects included: -> Financial Audits, Anomaly Detection, and Dashboard Builds: Audited 3 years of transactional data using SQL and statistical models, then designed executive dashboards that led to the discovery of $200K in revenue leakage. Collaborated with internal and client teams to acquire, transfer, and ingest a comprehensive dataset from the client’s ERP system. -> Market Forecasting: Researched and collected data sources for a market demand model that helped a client forecast commodity prices as part of ongoing procurement negotiations. -> Entity Resolution & Data Wrangling: As part of a sales lead generation/product recommender system, used Python to clean and standardize factory plant locations into a unique “Site ID” identifier. Worked with data scientists to design a logistic regression model. Created slide deck to convey technical modeling concepts to client.***• Exploratory Data Analysis & Product Management: Wrote code base and developed business logic for productization of USPS change-of-address data, using R and SQL to build scalable queries capable of replication in software applications.

Washington, Dc, Us

• TV & Online Advertising, Social Media Content Creation, and Broadcast Studio Management: Produced, edited, and animated broadcast-quality digital ads that drove unprecedented levels of viewership. Created viral, rapid-response social media content that cultivated a following of millions. Efforts during the 2020 political cycle ultimately led to a multi-year contract for a Sunday morning talk show on Newsmax TV and a $300K studio renovation.• Workflow Optimization and Virtual Events: Led research and organization-wide implementation of project management tools and internal communications software, facilitating the virtualization of grassroots activism during COVID-19.• Marketing Analytics: Analyzed digital marketing metrics to improve audience retention rates and average watch time of video content across all social media platforms.• Web Design & Development: Developed front-end web content using HTML & CSS coding on a Drupal content management system.

Washington, Dc, Us

• Field Production and Video Editing: Shot and edited video footage of political rallies and fundraisers in 15 different battleground states, which were featured in multimillion-dollar TV ad buys from outside political organizations and top-tier U.S. Senate campaigns.• Animation and Digital Fundraising: Designed and animated motion graphics for lead generation on social media platforms, direct solicitation via email and MMS messaging, as well as timely political merchandise sales.• Studio Management: Oversaw all aspects of production in a single-camera studio, recording candidate remarks that contributed to $3M+ in digital fundraising for the 2018 political cycle.

Arlington, Va, Us

• Live Broadcasting: Incorporated live event programming to feature on-location interviews with elected officials, public figures, celebrities, and presidential candidates on social media networks.• Vendor Management: Managed outsourced video projects, overseeing the work of 2–3 external vendors to ensure brand consistency.

Arlington, Va, Us

Video Journalism: Researched, storyboarded, filmed, and edited videos that raised the organization’s profile. Pioneered a corporate journalism brand that led to earned media placements in outlets such as the New York Times and CNN.

Washington, Dc, Us

• Video Production and Editing: Filmed interviews and b-roll at public diplomacy events such as sports clinics, cultural performances, academic conferences, etc. Edited short-form "sizzle-reel" content for publication on government websites and social media, managing time and concurrent projects to meet tight deadlines and advance strategic priorities.• Workflow Optimization: Organized and implemented a video production workflow, streamlining processes such as request tracking, scheduling, and digital asset archiving.• Virtual Events: Streamed live webcasts and hosted interactive webinars, with audiences of up to several thousand students and exchange visitors.• Web Design: Redesigned and modernized the Bureau of Educational and Cultural Affairs website, tripling traffic, boosting time-on-site by 150%, and increasing engagement among exchange program alumni.

Certificate In Data Science

Data Science Immersive

Bachelor Of Arts - Ba, International Affairs