Dan Schmidt Email & Phone Number

Herndon, Va

Supports the transformation of a traditional enterprise data architecture to a cloud-based streaming architecture. Responsible for working with multiple platforms, architectures, and diverse technologies gathering requirements, design and developing ETL processes to transform information from multiple sources. Manages ETL development, articulates and implements best practices for ETL reusability and modularity, across Pentaho PDI primarily and tools such as Apache NiFi and Kafka. The candidate must have a successful track record in ETL job design, development and automation activities with minimal supervision. Automates manual ETL tasks and jobs; Troubleshoots, monitors and coordinates defect resolution related to ETL processing; Responsible for support of all existing ETL processes across various data assets.

Ashburn, Virginia

• Spearheaded data acquisition, ingestion, transformation, analysis, reporting and support for internal and external clients. Advised on data strategy to finance, service and product marketing pipelines• Revised data import processes to greatly improve reliability, accuracy and usability. Created and managed fully-automated process to download, extract and load six million record FCC engineering databases. Included processes for reporting, error checking, rollback and updates using daily transaction files. Enhanced data value by adding spatial attributes and history. Utilized WinAutomation, Pentaho Kettle, JavaScript, PostgreSQL, Amazon RDS, and PostGIS• Designed, developed and executed processes to efficiently and accurately migrate legacy Sybase databases and stored procedures to PostgreSQL, Amazon RDS and Oracle in an Agile / Scrum SDLC environment• Created stored procedures and ETL processes to automate the generation of competitive intelligence pipeline and market share reports for telecom carriers and equipment vendors. These subscription reports integrate data from proprietary and public sources using spatial analysis and feature compelling visualizations• Managed data and technical support for the CTIA's AWS Spectrum Clearinghouse determining the cost sharing of relocated microwave links for wireless carriers in the AWS spectrum. Supported major program update to address the AWS-3 band auction. The Clearinghouse spatially analyzes hundreds of thousands of carrier base stations in the US to calculate cost sharing and reimbursement (ctiaspectrumclearinghouse.org)• Maintained database and end-user technical support for ASHE WMTS Frequency Coordination System registering all wireless medical telemetry systems in the US to calculate and mitigate life-threatening interference (wmtssearch.com)• Provided interference analysis employing ArcView to study proposed wind farms by plotting turbine locations against existing licensed microwave links

Ashburn, Virginia

• Designed and maintained marketing website with responsibility for organization, content and graphics• Developed content management system interacting with Sybase database and version control system to maintain, generate, check in, and upload web content• Created GUI standards and design for online engineering applications; developed shopping cart web app for data product sales• Excellence in Service Award, 2003, Spectrum Award for Outstanding Performance, 2002

Tysons Corner, Virginia

• Consultant to Bell Atlantic (Verizon) Training Education and Development Organization, Silver Spring, Maryland• Managed Intranet web design, production, and management; coordinated graphics production; oversaw maintenance, upgrades, and modification of existing sites for accessibility; designed document management and conversion process• Directed installation and administration of client web sites on UNIX and Windows servers. Employed Perl and JavaScript programming and database integration for web applications

Sterling, Virginia

• Founding partner of small full-service architecture and construction management firm• Oversaw marketing and administration in addition to all aspects of architectural design, consultant coordination and contract administration on churches and restaurants, large custom homes, and rehabilitation of garden apartment projects

Washington D.C. Metro Area

• Managed testing and analysis of various building system components, designed solutions and prepared technical reports• Assembled bidding documents, administered construction contracts, and provided inspection services for rehab projects

Bethesda, Maryland

• Progressively increased responsibilities included overseeing construction document production and contract administration• Projects included management of substantial renovations to a 457-unit high rise and numerous garden apartment complexes