Digital and Enterprise UX

Provided analytical services to various teams within JetBlue's Finance org and cross-divisional groups. Stakeholders include Revenue Accounting, Revenue Management, Financial Reporting, Loyalty, FP&A, Tax & Payroll, and Customer Support.Served as Data Analyst Lead for Revenue & Controller's Group starting May 2020 during org restructure and held ownership of 30+ queries, dashboards, and analytics processes. Led training for 5+ crewmembers on SQL best practices and building user-friendly dashboards to empower self-service analytics and enhance team efficiencies. Supported leadership in ad-hoc decision making during COVID-19 by proactively monitoring and dispersing insights on air traffic liability, cash flow, revenue drivers, and other financial metrics. Implemented a novel method in Python to prorate ticket fares based on coupon segments and developed a model to forecast no-show attrition and assess its impact on revenue recognition.

1st Rotation: Global Operations Strategy and Analytics2nd Rotation: Customer Strategy and Innovation3rd Rotation: Supply Chain Data ScienceTools: Python, R, SQL, Teradata, SQL Server, Oracle BI, VBA, SAS Enterprise Miner, Spotfire, Palantir Foundry, Qualtrics, Clarabridge, PySpark, SparkSQL

Predictive Maintenance and Global Logistics Optimization:Support and implement advanced analytics and process optimization initiatives across various business units within Tech Ops Supply Chain. Stakeholders include Warehousing & Logistics, Inventory Planning, Vendor Management, Procurement, Fleet, Maintenance Planning.Worked with Data Scientists to develop machine learning and data mining solutions with the goal of improving lead time performance, optimizing demand forecasting models, and classifying needed parts in future maintenance events.

Worked with external strategy consultants and leadership on system wide inititatives to benchmark against competitors, generate meaningful insights, and improve customer satisfaction and NPS across airport and inflight experience drivers. Partnered with Customer Insights and operational planning committees to revamp strategy behind food and beverage portfolios, cabin cleanliness, baggage to claim guarantee, and airport technology products. Optimized customer surveying & sampling techniques and integrated catering data with global flight data to identify pain points in existing meal cycles. Supported global launch of new on-board snack options (Stroopwafels, Biscoff, and Pretzels) across the network in Q2 2019. Served as Product Analytics Lead for Collab, an ~300M internal alerting and communications product to help frontline airport workers be situated at the right place at the right time during irregular operations.

Leverage data analytics to drive continuous improvement and disseminate insight across numerous operational groups and cross-functional divisions. Stakeholders include Airport & Catering Ops, Customer Service Delivery, Network Planning, Inflight, Ground Experience, Tools & Innovation, and Premium Services.Provide system level analytics based on aggregation of 16 KPIs within 4 core pillars of metrics (Safety, Caring, Reliability, and Efficiency), enabling senior leadership and general managers across 340+ airports to better manage the business through a weighted scoring model. Performed metric deep dives, root cause and scenario analyses on large datasets to assess the impact of operational changes and new business cases on network reliability, customer experience, and financial performance.

Performed data wrangling and exploration on extracts from Microsoft SQL Server, Socrata Open Data, and other data sources to provide ad-hoc decision support, forecast branch targets, and measure KPIs surrounding library consumption using Python, SQL, and Excel.Created a suite of intuitive dashboards on Tableau as a self-service tool to help librarians across 58+ branches better understand and segment their patrons. Worked closely with networks and staff focus groups to iterate, test, and integrate user feedback into design. Gathered capital finance data for all active branch projects from NYC financial terminals, implemented a dataflow pipeline on Tableau Prep, and automated the fiscal reporting process, enabling Project Managers, Government Affairs, and Finance teams to track project phases, budget encumbrance, and commitment metrics more efficiently. Collaborated with Data Analysts and IT to design and develop a k-means clustering based anomaly detection filter to spot potentially corrupt data in Tableau Server and SQL Server, improving data integrity system-wide.

Leveraged Excel, Access, SQL, and Salesforce ETL Tool to clean, validate, and integrate data between Salesforce and 5 external marketing applications and remediated 19,500+ errors across 31 data sources, improving data quality of CRM system by 43%.Collaborated on a cross-firm data team to streamline workflows, data models, and mappings in departmental systems across 6 business units to improve data reconciliation, ensure GDPR compliance, and set the pipeline for a future transition to an enterprise data warehouse.Constructed loader files using VBA and XML to automate the import of 9 years of incomplete matter data into Elite 3e legal billing system, strengthening firm-wide reporting and saving firm 10+ man-hours per month on manual data entry.Built ad-hoc reports and dashboards on SAP BusinessObjects and Power BI to support Partners and FP&A teams in financial planning efforts and analyzed metrics involving attorney staffing utilization, engagements, and annual projections.

Analyzed sales activity and invoice data from Salesforce to augment areas of opportunities in existing purchasing funnel and identify trends across sales metrics such as conversion, close rate, up-sells, cross-sells, and lead generation.Gathered user requirements from Sales teams and communicated to IT teams to ensure proper updates of systems. Partnered with Marketing and IT to transition marketing automation software from Oracle Eloqua to Salesforce Marketing Cloud and delivered bi-weekly employee training on new systems.Worked closely with Operations Managers to manage vendor contracts, forecast fulfillment needs, and implement cost control efforts for entire department. Led the coordination of 40+ sales events monthly across NYC metro area through extensive logistics planning, scheduling, and budgeting.

Gathered observational data about senior leadership across Fortune 500 companies by extracting unstructured text data from interviews, press conference manuscripts, and quarterly earnings reports on Seeking Alpha.Performed data preprocessing, text mining, and sentiment analyses in SimStat/WordStat for Stata and R to evaluate the correlation between personality traits and performance of CEOs and predict the impact of behavioral tendencies in senior leadership on business operations.Explored indications of psychopathy, empathy, humility, and narcissism in natural language articulation and created a concept dictionary to serve as a guide for interpreting samples of an individual's speech to support the research team's thesis.

Conducted laboratory research and experimentation on operant, classical, and fear based learning paradigms using applied scientific methods and principles of learning and cognitive theory from both animal and human methodology.Focus on creating, maintaining, and modifying behavior on Sprague Dawley vermin through stimuli control and A/B testing. Examined potential implications on affective neuroscience and other neural mechanisms of emotions.

Credit Risk Analysis - NYC Ladders4Leaders Program