Summary
Overview
Work History
Education
Skills
Work Availability
Timeline
SUSAN LOCKHART

SUSAN LOCKHART

Data Analyst
Palm Bay,FL
You miss 100% of the shots you never take.
Wayne Gretzky

Summary

Experienced Technical Program Manager, Business Analyst, and Data Warehouse Architect with diverse expertise, including roles as Contracts Subtask Manager, Technical Delivery Manager, and Customer Experience Manager. Formerly certified in Oracle and SQL Server, I specialize in identifying and addressing pain points for internal and external customers, delivering reporting, process improvements, and technical solutions. Proficient in SQL, SQL Server tools (SSRS, SSIS), and third-party tools. Degreed Mathematician with a Top-Secret Clearance, I served as a Telemetry Analyst and rocket scientist at Kennedy Space Center. At Harris Semiconductor, I gained extensive manufacturing and supply chain experience, rising to Senior Engineer and later assuming the role of Product Assurance Subtask Manager for government contracts.

Overview

34
34
years of professional experience

Work History

CX Product Owner

  • Detailed definition of specific deliverables for product success
  • Managed CX Specialists and CX Data Analysts, creating Journey Maps, Personas, and overseeing NPS and VOC
  • Approved CX metrics and dashboards for presentation to Senior Executives
  • Approved all CX and IT CX-related deliverables, managing the IT side of projects
  • Oversaw and facilitated a cross-functional team of 24 department heads for collaboration
  • Directed production of SOPs, SIPOCs, project documentation, etc
  • Versatility: Swift transition between tech and business-speak
  • Proficient in data analysis, SSRS reports development, and dashboard creation (SQL Server, Tableau)
  • Experienced in Alteryx application development
  • Expertise in ETL, including data exploration, quality assurance, and handling unstructured or large datasets
  • Knowledgeable in data architecture, capable of providing expertise for a Kimball methodology data warehouse
  • Creation and management of T-SQL queries, stored procedures, Python scripts, and jobs
  • Recognition: First recipient of company "Crown of Excellence" award., Responsibilities:
  • Customized question sets by company vertical
  • Managed survey reward vendor research and management
  • Provided regular reporting on Customer Experience across operations
  • Conducted customer interviews to analyze pain points
  • Identified and flagged customer friction points for internal stakeholder follow-up
  • Distributed and presented survey and data analysis results to Regional and District management
  • Recognition: ACE (Achievement in Customer Excellence) award winner
  • Royal Blue," ADT award winner.

Experience Senior Data Analyst

Prime Therapeutics/Magellan Health
Melbourne, FL
08.2022 - Current
  • Expertise in advanced pharmacy reporting and analysis
  • Proficient in creating and maintaining dashboards
  • Provided support for pharmacists, inventory managers, and internal operations analysts

Patent Writer and Researcher

USSI Global
Melbourne, FL
07.2022 - 09.2022
  • UML Business Process Diagramming, visualization and optimization.
  • Developed visualizations for patent.
  • Researched applicable technologies.
  • Worked with patent attorney to correctly and effectively write patent technological material.
  • Demonstrated respect, friendliness and willingness to help wherever needed.
  • Passionate about learning and committed to continual improvement.
  • Cultivated interpersonal skills by building positive relationships with others.

Manager; Data Analyst

Christian Care Ministry, CCM
Melbourne, FL
09.2016 - 10.2021
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Participated in requirements meetings to understand business needs.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Implemented code solutions to answer analytic questions and test and assess new methods.

Product Manager, Business Intelligence Manager

ADT Security Service
Boca Raton, FL
03.2002 - 08.2016
  • Analytics and Predictive Modeling Leadership:
  • Led analytics, predictive modeling, and visualization team
  • Developed Voice of the Customer program, managing reporting and complex source data transfers
  • Managed a team of 4 actuaries, extracting, cleaning, categorizing, and standardizing large datasets for data scientists, ensuring consistency for predictive modeling.

Technical Director

Partsbase
Boca Raton, FL
02.1998 - 03.2002
  • Managed IT personnel for a global aviation parts reseller
  • Microsoft certified SQL Server DBA, provided training for subordinates
  • Collaborated with DBA team for swift issue resolution
  • Developed business process methodology and managed key metrics
  • Senior program management leadership with a focus on execution
  • Expertise in knowledge management and handling ambiguous requirements.

Senior Technical Manager

prcnetcare.com
Boca Raton, FL
06.1990 - 02.1998
  • Directed large teams of project managers, analysts, and developers
  • Collaborated on project scope, budgets, and timelines
  • Improved financial performance through cost management
  • Skilled in motivating high-performance professionals
  • Monitored cybersecurity using company data and resources.

Education

Bachelor of Science - Mathematics And Science

Rollins College

Bachelor of Science - Electrical Engineering

Florida Institute of Technology

Skills

  • Ninety-ninth percentile MENSA tested
  • Fast learner, inquisitive
  • Adaptable, excellent collaborator
  • Effective communicator
  • SQL proficiency, data exploration
  • Unstructured data, data mining, business analysis
  • Data warehousing, architecture, ETL, data quality assurance
  • Team management
  • SQL Server, Oracle, Alteryx
  • Some Python, R, XML
  • Salesforce, Netsuite, ER/Studio, Erwin, Confluence, Jira
  • Excel, Visio, PowerPoint, Microsoft Project, Tableau, Sisense
  • ADP, PeopleSoft, Greenhouse, Engagedly, Kronos
  • Cisco, Hubspot, UXPressia, Verint

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Experience Senior Data Analyst - Prime Therapeutics/Magellan Health
08.2022 - Current
Patent Writer and Researcher - USSI Global
07.2022 - 09.2022
Manager; Data Analyst - Christian Care Ministry, CCM
09.2016 - 10.2021
Product Manager, Business Intelligence Manager - ADT Security Service
03.2002 - 08.2016
Technical Director - Partsbase
02.1998 - 03.2002
Senior Technical Manager - prcnetcare.com
06.1990 - 02.1998
Rollins College - Bachelor of Science, Mathematics And Science
Florida Institute of Technology - Bachelor of Science, Electrical Engineering
CX Product Owner -
SUSAN LOCKHARTData Analyst