Devin Mcknight, Mba, Dcam Email & Phone Number

Texas, United States

Red Oak, Texas, Us

New York, Ny, Us

• Architected process to identify, curate and mature the client’s classification of reporting assets totaling approximately 3000+ from 0% to a 95% completion rate.• Developed process and worked with domain SMEs to master and differentiate between data terms and critical data elements for 1000+ attributes.• Built internal process to harness and utilize existing metadata to build out business glossary, data dictionary, lineage, visualizations, etc.• Conducted data governance tool vendor evaluation and POC for Alation, Erwin and Collibra for client by coaching and maturing program and platform resources both personnel, processes and technology to position the company to acquire a DG tool to continue to grow and mature their data’s insight for their stakeholders. • Developed and presented POC to utilize existing metadata and business domain input documents to create end to end mapping and lineage insight.• Architected and implemented a data governance and data quality scorecard for key data stakeholders that tracked the agreed upon data governance metrics such as: data classification progress, business glossary and data dictionary completion rates and data quality dimension metrics.• Improved the adoption and understanding of data governance principles and standards for both the program and platform pillars of data governance through the administering of assessments, education and training for key data stakeholders, auditing, risk management and alignment to the client's overall data strategy plan.• Served as change agent and integrated DG principles into the SDLC process, which included but not limited to: requirement gathering and analysis, development, QA, defect resolution, data lifecycle, etc.• Coached and provided leadership for internal team of 2-3 in the understanding, development and implementation of data governance program and platform policies, standards and principles and associated data governance artifacts.

• Designed matching algorithm for reimbursement project that improved the identification of transactions from a pool of 10M++ transactions by 60% which decreased the over-refund process by approximately 2-3% overall. • Created automated DDL/DML/Metadata creation and validation process currently for 200+ entities for ambiguous, format-challenged and development extensive files resulting in a 50% de-allocation of resource time and 24-48 hour improved deployment time into development/test/production. • Circumvented project labor reduction for the company’s largest project, which would either service and/or replace approximately 30% of the companies’ existing systems by developing and co-designing system orientation packages detailing system description, overview, file dependencies, data lineage for 2000+ attributes, mappings, load frequencies, metadata and much more for existing and on-boarding team of analyst, developers, testers which was projected to increase project acclimation by 25%.

West Des Moines, Ia, Us

• Architected and co-developed data dictionary and data lineage automation application (SQL/SSIS/Python), change management process and data models within 3-5 iterative phases by standardizing 300+ mapping documents, leading and assisting with the association of metadata and definitions for 10,000+ data attributes across multiple environments , which resulted in the company’s 1st end-to-end data lineage and dictionary process boosting a 20% confidence in analyzing and completing data related projects and tasks for managers, analysts, developers and SMEs.• Reduction of vendor product and support SOW by 80% by improving and recommending the internal technical resources and competencies resulting in an in-house data management product that better aligned to the enterprise data management technical strategy.• Conducted 2-4 meetings weekly to engage, understand, implement DAMA framework and align and reassure strategic objectives from the CFO where properly baselined within the project deliverable schedules with CDO, directors and managers, which resulted in a more consensus delivery approach void of requirements and surprises and a 10-20% reduction in re-development, re-testing, etc. due to initiative and requirement ambiguities.

• Developed state product management, auditing and forecasting application to refund the existing and prevent future over and under payment of product fees due to yearly state and product percentage changes not being accounted for in legacy system which resulted in the identification, remediation and refund of $1M collectively across all states for 1000+ customers within given refund timeline to avoid further regulatory penalties, embedded process monitoring that prevents future mishaps for upward to 45 states across 20+ products preventing approximately $50,000 - $100,000 in fees.• Created data quality process to improve data set preparation and confidence for early market segmentation analysis which resulted in a 10% quicker response time by the Marketing team of 5 to evaluate product opportunity and deliver third party deliverable requirements. • Conducted (3-5) monthly meetings to engage ALL program directors, managers, leads and employees to better understand each departments’ role in the overall data requirements, workflow and strategic goals and wish list for the product selection, dissemination and marketing necessities.• Directed, coached and trained one direct report through technical best practices and personal career objectives.

• Conducted monthly stakeholder meeting of 25-50 participants as well as hosted 2-3 virtual meetings monthly to work on the culture awareness/change campaign as well as to understand their overall processes based on how they used existing reports, extracted data from these reports and other integrated “home” built systems, which resulted in more actionable business intelligence/reporting road map due to stakeholder engagement, buy-in and cultural awareness.• Drafted initial enterprise reporting strategy by performing inventory assessment, reporting source matrices analysis, story backlog creation, cost effectiveness and strategic product alignment of 100-150 legacy reports and “in house” database systems across 10-20 departments with 5-10 power users per department across 4-8 business units which resulted with comparison chart delineated by reporting needs and/or limitation based on traditional pagination or data visualization applications.• Volunteered for, developed, transitioned and tested poor performing backlogged data integration projects by converting legacy linked servers/sprocs to more efficient SSIS 2016 packages based on enterprise standards which increased the completion duration and load percentage 10-15% per integration package as well as reduced the overall workload of existing ETL developers by 5% by requesting for these tasks beyond my “hired” upon position and responsibilities.

• Successfully developed, implemented and deployed conceptual, logical and physical data models, metadata, mappings, testing strategies for 10,000+ attributes, 25+ entities for the company’s 1st Credit Card Portfolio acquisition within a reduced timeline and escalated scope creep that impacted 2500+ customers with a budget of $2M++.• Reduced labor costs by approximately $100,000 a year by volunteering and serving in multiple positions as a modeler, data analyst and quality assurance analyst on company’s Credit Card Portfolio project.

• Promoted amongst 20+ analyst to Lead role responsible for managing, training, mentoring and collaborating on $5M+ plus data capture project implementing and ingesting 100+ systems with restricted timeline constraints. Developed a more streamlined new orientation process for employee ramp up by 20% to mitigate high employee turnover due to unexpected project funding obstacles. • Enhanced data capture and testing process by evaluating sourcing intricacies, templatizing and automating data migration/conversion source to target mapping documents through the integration of database/table metadata for “structured” and “unstructured” sources with needed data elements ranging from 500-5000+ per 100+ subsystems with associated embedded cleansing rules, loading frequencies, data load types (full and deltas), etc. which resulted in 100% conformity in deliverable to end developers and QA analysts which reduced development and defect resolution 50% and reduced downstream workload for QA and developers by 10% because of embedded functional pre-validations per transition.

• Developed testing software (DVO) interface that integrated database/table metadata with Informatica repositories to replace timely manual test case creations to a scalable automated test case platform, which allowed a team of 2-3 analysts to create a 1000 test cases/per 10 manual test creations. This development allowed reusable test cases to be scripted and shared amongst peers boosting a 25% increase per analyst in resource capacity, increased test case creation for parallel migration testing by 200%, and increased result evaluation for quicker defect resolutions• Architected, developed and managed multi-department extract integration, validations and alert platforms, which was processed 2-4 times a month for 3 different departments totaling 50-75 data elements per extract to circumvent defect corrections post submission, development to submission latency and extract pre-reconciliation, which resulted in an automated integration package that reduced labor cost by upwards of 5% and a 50% quarterly reduction of defects throughout the first year.

Little Rock, Ar, Us

• Solutioned, implemented and managed an enterprise data management improvement strategy and application impacting 25 + business units, 2000+ employees, 26,000+ student body and ancillary city data dependencies to improve the overall dimensions of data quality and governance while relentlessly championing the strategic advantages of data quality which resulted in a 25% reduction in loss of revenue due to data management issues and 30% increase in stakeholders’ data confidence.• Gathered, conceptualized and modeled requirements related to 20,000+ attributes, 200+ entities and processes through multiple stakeholder engagement sessions consisting of 25-100 attendees to create technical specification to build dimensional models based on “Ralph Kimball’s” approach.• Lead the development and managed the assignment and relationship between two external teams of developers in the creation of 25-50 mapping documents, identification of 1st cut KPIs, end-to-end SSIS data integration packages and TSQL stored procedures and testing.• Successfully managed and implemented District’s first $2M+ K-12 longitudinal performance management DW/BI solution servicing a user community of 4000+ with an internal and vendor staff of 6-10 employees and consultants.• Implemented mitigation plan to remedy vendor and internal resource (6-10 consultants and employees) loss during crucial deliverable cycle by more fervently engaging, equipping and discovering untapped staff competencies which resulted in a 50% reduction in employee labor costs and a leaner internal resource model.• Identified, designated and trained 500+ data stewards, champions, power users, internal educational trainers and IT support throughout the district by deploying a train-the-trainer program to support BI reporting, analytics, usage and understanding and developing customized user documentation per user group function, resulting in a 25% reduction in “outside” vendor training costs.

Little Rock, Ar, Us

• Architected, developed, managed and trained resources on proactive internal data management and reporting application with improved data controls, validations, error reporting, alerts and forecasting to improve the erroneous data submission and latency, data readiness and quality for state submission funding for approximately 26,000 students/2000+ employees on an aggressive 5-7 yearly cycle schedule which resulted in a 25% eligibility match rate each quarter for the initial year, 90% sustained data quality improvement each subsequent year and a yearly internal IT labor cost reduction of $25,000.• Developed an internal BI asset management system with streamlined reporting, improved management functionality, intuitiveness and improved depreciation modules which resulted in the consolidation of 8-10 reports into one parameterized report with integrated reconciliation modules, the identification of an existing $250,000 asset depreciation auditing oversight and the stoppage and prevention of 25% of that cumulative amount occurring yearly.• Architected and implemented enterprise data management platform and analytics that improved the readiness and quality of data.

North Little Rock, Ar, Us

Little Rock, Ar, Us

• Alleviated upwards of 25% of market overhead costs by merging 20-40 markets based on market analysis, performance and costs commonalities.• Increased data input, improved data quality and process inefficiencies by creating sophisticated automated scripts to replicate and perform workload tasks between 500-1000 per cycle by over 200% for assigned team of 3-5 which reduced employee acquisitions for the company by a projected $250k over the course of 5 years. This process also boosted team morale, synergy and productivity by reducing “busy” tasks from individual workloads, which also gave the team the capacity to analyze and concentrate their attention on more cost improving, debt reducing projects. • Reduced cyclical performance and defects by at least 50% by creating more intuitive proactive change management and quality assurance road map and processes, which reduced the company’s defect to correction expense by 5-10% per human capital each cycle• Coached mid and junior level analyst in data validation best practices and career road maps to better position themselves within team and company strategic vision allowing the company to build and retain valuable resources internally.

• Ranked within the top 3% of fellow technologists based on performance matrix of project deliverance within or under budget, process improvement, customer satisfaction and knowledge transfer and quality development of IT deliverables.• Enhanced transactional relay by 25% for inefficient patient interfaces which increased day-to-day data acquisition, processing and decision making for system users. • Increased process performance by 10% be rearchitecting and optimizing existing COBOL and EZ tree extract programs to ProC/SQL and Unix technologies.• Trained client communities of 20-25 stakeholders at least 1-2 sessions per month by creating and revamping more intuitive documentation/metadata and volunteering to travel without advanced notice, which resulted in increased customer synergy and reduction of post-production technical debt by 10% each project implementation.• Managed, developed, tested and supported 5-10 graphical user interfaces per project within the course of multiple healthcare system implementations.

Bachelors, Computer Science

Masters, Business Administration