Dylan Hennessy Email & Phone Number

Technical & Management Consulting with a Large Federal Regulatory Agency during new public data project release. Technical Consulting Expertise in PMO, Data Governance & Management, ETL Transformation Engineering, and Technical Design, Compliance and Engineering Management.

Analyze business' processes, systems and its underlying structure to discover and identify automation and efficiency opportunities.Produce core project and client documentation, diagrams, explanations, guidance and aggregations of knowledge to key stakeholders, clients and peers, on a plethora of highly complex topics, processes, systems.Navigation of complex highly matricized organizations, gathering requirements from business units, gaining informational clarity from subject matter experts, and deliver technical documents & writings tailored, to a multitude of levels of comprehension.

Gb

Reviewed code and debugged errors to improve performance.Wrote unit tests to confirm proper functioning of core database functionsApplied scripting knowledge to supplement Java development & integration of complex SQL database functionality. Determined coding requirements for specialized complex implementation of core relational database functionality.Participated in requirements gathering and design development & adjusted design parameters to incorporate new features.

Scottsdale, Az, Us

Documented current processes of BI data pipeline with AsciiDoc to understand complex data transformations, change data capture procedures (CDC), ETL pipelines, and data architecture for 500 million+ records across 50+ processes to provide a high-level understanding of the data pipeline.Developed and optimized scripts emulating the functionality of the documented processes (Full, Incremental, CDC) currently being performed by SAP Data Services (BODS) using Transactional SQL (TSQL), SISS, Git SSMS, Azure Data Studio, Data Warehousing, Data Modeling, and Data Architecture to discontinue use of the service and internalize its functionality into the organization.Tested, validated, and deployed developed scripts and processes in 4 environments DEV, QA, UA and PROD, sequentially through Data Validation scripts, SSIS packages to ensure smooth integration, deployment and usage of production data across multiple departments.

Integrated the Agile methodology among 4 interns across multiple geographical locations to develop 3 MVP web applications for 3 subdivisions using HTML, CSS, Javascript to transform and provide data for it each divisions specified functionality.Tested and resolved bugs relating to data quality, data storage, data transformations, user authentication, custom functions, AI data model, and the data warehouse to optimize through 2 different source control environments to fix issues relating to data used by in production.Implemented functional programs and data information systems, through 2 rounds of successful seed funding, by presenting and communicating highly complex technologies and concepts of Business Processes, Data Architecture, KPIs, backup procedures documentation guidelines leading help to secure $50,000 in seed funding for the company.

- scaffolding

Columbus, Ga, Us

Acquired a revenue generating pipeline of clients, focused on B2B insurance, through prospecting, cold calling, then providing guidance, knowledge of laws and underwriting, ranging from Cancer to Short Term Disability Insurance for local businesses, to provide cost effective solutions for business not previously able to.Tracked clients and prospects in a CRM system to allow for optimal usage of time and to ensure scheduled follow ups for prospective and current clients, allowing more effective service for future and past customers.