Data Scientist at the Joint Artificial Intelligence Center (JAIC)

Supporting the USAF Chief Data Office as a Senior Manager leading teams of up to 12 direct reports in agile project execution and client support across Data Science, Architecture, and Project Management work-streams. Manage and participate in the configuration and deployment of both on premises and AWS cloud analytics environments leveraging scikit-learn and Spark big data solutions for rapid data ingest and feature engineering of petabyte scale data. Involved directly in the gathering of requirements, modeling and implementation of Data Science and Machine Learning solutions including random forests, clustering, and regression based forecasting. Participated in hands on development of Pyspark and Python Data Science solutions. Briefed presentations of analytical findings and processes to executive leadership including the Air Force Under Secretary and Vice Chief of Staff. Produced scheduled deliverable status reports and conducted proposal/business development efforts with our client resulting in multiple contract extensions.

Data Architecture and Development manager providing rapid Tableau reporting insights for the US Department of Defense. Led architectural design and ETL development efforts for a multi-Terabyte financial data project. Managed the organization’s Microsoft Azure Cloud for Government data platform, development, and Tableau reporting efforts. Participated in technical recruitment and training activities for all IT related positions in the Firm’s Government and Public Sector practice. Performed Agile project management and interfaced with executive level management at our Defense client to provide sustainment and scalability guidance. Served as technical security advisor and compliance point of contact for all data sharing and storage agreements. Established organizational standards. Defined DoD data governance structures and led data quality initiatives.

Lead Data architect designing innovative high performance reporting solutions for the Red Cross enterprise Teradata warehouse. Created and implemented organizational standards for Erwin Data Modeling, Teradata indexing, and naming. Designed unified star schema data marts to provide an integrated information solution in the Business Objects Universe. Generated ETL specs and load strategies for the development of Informatica ETL jobs. Gathered and organized organizational metadata in an Enterprise Data Dictionary. Performed deep data profiling of complex data sets, to create a model which provides a significant source of blood drive information. This allowed the organization to expand dominance in the blood supply market above 40%.

Data Warehouse and Enterprise Data Architect for large corporate restaurant brand. Managed end to end design of data structures for Pizza Hut’s multi-terabyte HP Vertica warehouse and SQL server enterprise systems. Gathered business requirements and authored technical specs for the development of star schema, big data, and relational data storage structures. Created data models and documentation for the data warehouse and managed the Embarcadero model repository. Served in the Lead Architect role in the implementation of a Tibco MDM solution for management of customer data. Designed data structures to integrate cleansed and enriched MDM data into the Vertica warehouse for use with Microstrategy and Tableau reporting solutions. Used Facebook data sources to enrich customer data mart records. Participated in Agile Scrum development teams. Provided guidance for the implementation of a metadata management solution. Performed Enterprise Data Architecture and DBA duties in SQL Server environments.

Data Warehouse and Enterprise Data Architect for the financial division of General Motors. Responsible for gathering requirements, designing dimensional and normal form relational data architecture. Wrote ETL specifications and technical requirements for Informatica ETL development. Interfaced with high level business users to design data marts for credit scoring, leasing, auto loans, commercial lending, and securitization of assets. Performed troubleshooting of data loading problems in Oracle and Informatica. Designed data models in ERwin and implemented naming and table design standards. Designed and documented XML schemas to meet departmental standards. Created DDL for database objects such as tables, views, and indexes. Completed Data Vault 2.0 training which included data modeling for Data Vault, Agile data warehouse development methodologies, and Integrating Hadoop Big Data/NoSQL solutions into the data warehouse architecture through the use of MapReduce and Hive. Designed Data Vault marts with key-value architecture for Hadoop Big Data and NoSQL environments.

Responsible for the architectural design, ETL design, development, and support of many multi-terabyte Oracle EPM data warehouses. Designed star schema fact and dimension tables and implemented custom data marts to deliver a PeopleSoft data reporting solution for multiple remote campuses in the University of Texas System using IBM Infosphere Datastage. Managed data lineage and metadata. Implemented incremental Change Data Capture load designs for UT Arlington data which resulted in a 400% faster nightly data load. Performed code reviews and migrations. Established naming and development standards. Participated in the interview and hiring process. Mentored and trained new developers.

ETL Developer and Application Support Manager for various data warehouse projects at SUNY University at Buffalo using Oracle Warehouse Builder, SSIS, ERwin and other tools. Developed data architecture and ETL maps using Kimball methodology star schema dimensional modeling. Also developed a data in normalized data warehouse. Performed architectural duties including the design of fact and dimension tables. Authored technical requirement and spec documents. Standardized column names and data types. Performed impact analysis of changes to the data warehouse.

Data Analyst for a company specializing in data warehousing architecture design and reporting of medical standard X12 EDI data for many large clients in the pharmaceutical industry. Performed numerous data processing activities including scrubbing, staging, and validating supply chain management data in large MySQL and Oracle data warehouses. Installed and configured JRun Java web servers for optimal performance. Interfaced with customers to develop blueprints mapping X12 data to warehouse tables. Wrote many custom reports and data extracts to meet the needs of clients.